eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on FND_API

Line 263: --IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

259:
260: --
261: -- bug 10627731
262: --
263: --IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
264: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
265: --WriteToLog('Update_In_Src_Orgs returned with expected error.', 1);
266: WriteToLog('Update_In_Src_Orgs returned with status:' || l_return_status ||
267: ' for line_id:' || v_all_configs.line_id, 1);

Line 264: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

260: --
261: -- bug 10627731
262: --
263: --IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
264: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
265: --WriteToLog('Update_In_Src_Orgs returned with expected error.', 1);
266: WriteToLog('Update_In_Src_Orgs returned with status:' || l_return_status ||
267: ' for line_id:' || v_all_configs.line_id, 1);
268: --RAISE FND_API.G_EXC_ERROR ;

Line 268: --RAISE FND_API.G_EXC_ERROR ;

264: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
265: --WriteToLog('Update_In_Src_Orgs returned with expected error.', 1);
266: WriteToLog('Update_In_Src_Orgs returned with status:' || l_return_status ||
267: ' for line_id:' || v_all_configs.line_id, 1);
268: --RAISE FND_API.G_EXC_ERROR ;
269: --
270: -- Here, we want to skip processing for
271: -- the rest of this ato_line_id, but continue
272: -- processing the remaining ato_line_ids.

Line 289: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

285: --
286: -- bug 10627731
287: --
288: /*
289: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
290: WriteToLog('Update_In_Src_Orgs returned with unexpected error.', 1);
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
292: */
293: END IF;

Line 291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

287: --
288: /*
289: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
290: WriteToLog('Update_In_Src_Orgs returned with unexpected error.', 1);
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
292: */
293: END IF;
294:
295:

Line 311: p_encoded => fnd_api.g_false);

307: for i in 1..l_msg_count
308: Loop
309: l_msg_data1 := fnd_msg_pub.get(
310: p_msg_index => i,
311: p_encoded => fnd_api.g_false);
312: WriteToLog(l_msg_data1,1);
313: end loop;
314: WriteToLog('============= End of error Messages ============',1);
315: End if;

Line 337: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

333: p_seq,
334: l_return_status,
335: l_msg_count,
336: l_msg_data);
337: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
338: WriteToLog('Update_Bom_Rtg_Bulk returned with expected error.', 1);
339: RAISE FND_API.G_EXC_ERROR ;
340: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
341: WriteToLog('Update_Bom_Rtg_Bulk returned with unexpected error.', 1);

Line 339: RAISE FND_API.G_EXC_ERROR ;

335: l_msg_count,
336: l_msg_data);
337: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
338: WriteToLog('Update_Bom_Rtg_Bulk returned with expected error.', 1);
339: RAISE FND_API.G_EXC_ERROR ;
340: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
341: WriteToLog('Update_Bom_Rtg_Bulk returned with unexpected error.', 1);
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
343: END IF;

Line 340: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

336: l_msg_data);
337: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
338: WriteToLog('Update_Bom_Rtg_Bulk returned with expected error.', 1);
339: RAISE FND_API.G_EXC_ERROR ;
340: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
341: WriteToLog('Update_Bom_Rtg_Bulk returned with unexpected error.', 1);
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
343: END IF;
344:

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

338: WriteToLog('Update_Bom_Rtg_Bulk returned with expected error.', 1);
339: RAISE FND_API.G_EXC_ERROR ;
340: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
341: WriteToLog('Update_Bom_Rtg_Bulk returned with unexpected error.', 1);
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
343: END IF;
344:
345: --
346: -- Update rows processed to BOM_BULK

Line 371: RAISE FND_API.G_EXC_ERROR;

367:
368: EXCEPTION
369: WHEN no_data_found THEN
370: WriteToLog('ERROR: CTO seeded assignment set not found', 1);
371: RAISE FND_API.G_EXC_ERROR;
372: END;
373:
374: --
375: -- Copy sourcing from CTO to MRP Default Assignment Set

Line 548: WHEN fnd_api.g_exc_error THEN

544: End if;
545:
546: EXCEPTION
547:
548: WHEN fnd_api.g_exc_error THEN
549: WriteToLog('ERROR: Expected error in CTO_Bom_Rtg_Pk.Update_Boms_Rtgs:: '|| l_stmt_num ||'::'||sqlerrm, 1);
550: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
551: WriteToLog('Update Configuration Boms completed with WARNING');
552: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 556: WHEN fnd_api.g_exc_unexpected_error THEN

552: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
553: errbuf := 'Progam completed with warning';
554: retcode := 1; -- exit with warning
555:
556: WHEN fnd_api.g_exc_unexpected_error THEN
557: WriteToLog('ERROR: Unexpected error in CTO_Bom_Rtg_Pk.Update_Boms_Rtgs:: '|| l_stmt_num ||'::'||sqlerrm, 1);
558: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
559: WriteToLog('Update Configuration Boms completed with ERROR');
560: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 635: xReturnStatus := fnd_api.g_ret_sts_success;

631: BEGIN
632:
633: WriteToLog('Processing line_id '||pLineId, 3);
634:
635: xReturnStatus := fnd_api.g_ret_sts_success;
636:
637: --
638: -- Get total lead time for this config based on OE validation org
639: --

Line 681: raise FND_API.G_EXC_ERROR;

677: IF (lOEValidationOrg = -99) THEN
678: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++++++++', 1);
679: WriteToLog('ERROR: Unable to find OE Validation Org for line_id '||pLineId, 1);
680: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++++++++', 1);
681: raise FND_API.G_EXC_ERROR;
682: END IF;
683:
684: WriteToLog('Validation Org is :' || lOEValidationOrg,4);
685:

Line 712: raise FND_API.G_EXC_ERROR;

708: IF (lStatus = 0) THEN
709: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++', 1);
710: WriteToLog('ERROR: Error in get_model_lead_time', 1);
711: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++', 1);
712: raise FND_API.G_EXC_ERROR;
713: ELSE
714: lTotLeadTime := lLeadTime + lTotLeadTime;
715: END IF;
716:

Line 780: raise fnd_api.g_exc_error;

776:
777:
778: if (lStatus <> 1) then
779: WriteToLog('ERROR: Update_Bom_Rtg_Loop returned with error.', 1);
780: raise fnd_api.g_exc_error;
781: end if;
782:
783: v_bom_created := v_bom_created + 1 ; /* increment bom created variable */
784: lStmtNum := 130;

Line 809: raise fnd_api.g_exc_error;

805: ** In either case the error will be caught if the bom
806: ** was not created even in a single org.
807:
808: cto_msg_pub.cto_message('BOM','CTO_BOM_NOT_DEFINED');
809: raise fnd_api.g_exc_error;
810: */
811: end if; -- end check model bom
812:
813: else /* create_config_bom = 'N' */

Line 829: WHEN fnd_api.g_exc_error THEN

825:
826:
827: EXCEPTION
828:
829: WHEN fnd_api.g_exc_error THEN
830: WriteToLog('Expected error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
831: xReturnStatus := fnd_api.g_ret_sts_error;
832: cto_msg_pub.count_and_get
833: ( p_msg_count => xMsgCount

Line 831: xReturnStatus := fnd_api.g_ret_sts_error;

827: EXCEPTION
828:
829: WHEN fnd_api.g_exc_error THEN
830: WriteToLog('Expected error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
831: xReturnStatus := fnd_api.g_ret_sts_error;
832: cto_msg_pub.count_and_get
833: ( p_msg_count => xMsgCount
834: , p_msg_data => xMsgData
835: );

Line 837: WHEN fnd_api.g_exc_unexpected_error THEN

833: ( p_msg_count => xMsgCount
834: , p_msg_data => xMsgData
835: );
836:
837: WHEN fnd_api.g_exc_unexpected_error THEN
838: WriteToLog('Unexpected error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
839: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
840: cto_msg_pub.count_and_get
841: ( p_msg_count => xMsgCount

Line 839: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;

835: );
836:
837: WHEN fnd_api.g_exc_unexpected_error THEN
838: WriteToLog('Unexpected error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
839: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
840: cto_msg_pub.count_and_get
841: ( p_msg_count => xMsgCount
842: , p_msg_data => xMsgData
843: );

Line 847: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

843: );
844:
845: WHEN OTHERS then
846: WriteToLog('Others error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
847: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
848: cto_msg_pub.count_and_get
849: ( p_msg_count => xMsgCount
850: , p_msg_data => xMsgData
851: );

Line 1497: raise fnd_api.g_exc_error;

1493:
1494:
1495: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP', l_token1 );
1496:
1497: raise fnd_api.g_exc_error;
1498:
1499:
1500:
1501:

Line 1804: raise fnd_api.g_exc_error;

1800: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR');
1801:
1802: end loop ;
1803:
1804: raise fnd_api.g_exc_error;
1805:
1806: end if ;
1807:
1808: end if;

Line 1959: raise fnd_api.g_exc_error;

1955:
1956: EXCEPTION -- exception for stmt 52 ,53 and 54
1957: when others then
1958: WriteToLog('Others excepn from stmt '||lStmtNum ||':'||sqlerrm, 1);
1959: raise fnd_api.g_exc_error;
1960:
1961: END ;
1962:
1963: end loop; /* missed lines cursor */

Line 1997: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1993: ,x_return_status => l_return_status
1994: ,x_msg_count => l_msg_count
1995: ,x_msg_data => l_msg_data);
1996:
1997: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1998: WriteToLog('Failed in Check Holds with expected error.' ,1);
1999: raise FND_API.G_EXC_ERROR;
2000:
2001: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1999: raise FND_API.G_EXC_ERROR;

1995: ,x_msg_data => l_msg_data);
1996:
1997: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1998: WriteToLog('Failed in Check Holds with expected error.' ,1);
1999: raise FND_API.G_EXC_ERROR;
2000:
2001: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2002: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
2003: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2001: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1997: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1998: WriteToLog('Failed in Check Holds with expected error.' ,1);
1999: raise FND_API.G_EXC_ERROR;
2000:
2001: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2002: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
2003: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2004:
2005: ELSE

Line 2003: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1999: raise FND_API.G_EXC_ERROR;
2000:
2001: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2002: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
2003: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2004:
2005: ELSE
2006: WriteToLog('Success in Check Holds.' ,1);
2007: if l_hold_result_out = FND_API.G_FALSE then

Line 2007: if l_hold_result_out = FND_API.G_FALSE then

2003: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2004:
2005: ELSE
2006: WriteToLog('Success in Check Holds.' ,1);
2007: if l_hold_result_out = FND_API.G_FALSE then
2008:
2009: WriteToLog('Calling OM api to apply hold.' ,1);
2010: l_hold_source_rec.hold_entity_code := 'O';
2011: l_hold_source_rec.hold_id := 55;

Line 2023: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2019: , x_return_status => l_return_status
2020: , x_msg_count => l_msg_count
2021: , x_msg_data => l_msg_data);
2022:
2023: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2024: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2025: WriteToLog ('ERROR: Apply_holds returned expected error.', 1);
2026: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2027: raise fnd_api.g_exc_error;

Line 2027: raise fnd_api.g_exc_error;

2023: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2024: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2025: WriteToLog ('ERROR: Apply_holds returned expected error.', 1);
2026: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2027: raise fnd_api.g_exc_error;
2028:
2029: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2030: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2031: WriteToLog ('ERROR: Apply_holds returned unexpected error.', 1);

Line 2029: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2025: WriteToLog ('ERROR: Apply_holds returned expected error.', 1);
2026: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2027: raise fnd_api.g_exc_error;
2028:
2029: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2030: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2031: WriteToLog ('ERROR: Apply_holds returned unexpected error.', 1);
2032: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2033: raise fnd_api.g_exc_error;

Line 2033: raise fnd_api.g_exc_error;

2029: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2030: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2031: WriteToLog ('ERROR: Apply_holds returned unexpected error.', 1);
2032: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2033: raise fnd_api.g_exc_error;
2034: END IF;
2035: l_order_num := v_holds.order_num;
2036: l_line_num := v_holds.line_num;
2037:

Line 2110: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2106: ,x_return_status => l_return_status
2107: ,x_msg_count => l_msg_count
2108: ,x_msg_data => l_msg_data);
2109:
2110: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2111: WriteToLog('Failed in Check Holds with expected error.' ,1);
2112: raise FND_API.G_EXC_ERROR;
2113: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2114: WriteToLog('Failed in Check Holds with unexpected error.' ,1);

Line 2112: raise FND_API.G_EXC_ERROR;

2108: ,x_msg_data => l_msg_data);
2109:
2110: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2111: WriteToLog('Failed in Check Holds with expected error.' ,1);
2112: raise FND_API.G_EXC_ERROR;
2113: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2114: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
2115: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2116: ELSE

Line 2113: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2109:
2110: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2111: WriteToLog('Failed in Check Holds with expected error.' ,1);
2112: raise FND_API.G_EXC_ERROR;
2113: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2114: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
2115: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2116: ELSE
2117: WriteToLog('Success in Check Holds.' ,1);

Line 2115: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2111: WriteToLog('Failed in Check Holds with expected error.' ,1);
2112: raise FND_API.G_EXC_ERROR;
2113: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2114: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
2115: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2116: ELSE
2117: WriteToLog('Success in Check Holds.' ,1);
2118: if l_hold_result_out = FND_API.G_FALSE then
2119:

Line 2118: if l_hold_result_out = FND_API.G_FALSE then

2114: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
2115: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2116: ELSE
2117: WriteToLog('Success in Check Holds.' ,1);
2118: if l_hold_result_out = FND_API.G_FALSE then
2119:
2120: WriteToLog('Calling OM api to apply hold.' ,1);
2121: l_hold_source_rec.hold_entity_code := 'O';
2122: l_hold_source_rec.hold_id := 55;

Line 2138: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2134: , x_return_status => l_return_status
2135: , x_msg_count => l_msg_count
2136: , x_msg_data => l_msg_data);
2137:
2138: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2139: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2140: WriteToLog ('ERROR: Apply_holds returned expected error.', 1);
2141: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2142: raise fnd_api.g_exc_error;

Line 2142: raise fnd_api.g_exc_error;

2138: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2139: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2140: WriteToLog ('ERROR: Apply_holds returned expected error.', 1);
2141: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2142: raise fnd_api.g_exc_error;
2143:
2144: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2145: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2146: WriteToLog ('ERROR: Apply_holds returned unexpected error.', 1);

Line 2144: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2140: WriteToLog ('ERROR: Apply_holds returned expected error.', 1);
2141: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2142: raise fnd_api.g_exc_error;
2143:
2144: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2145: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2146: WriteToLog ('ERROR: Apply_holds returned unexpected error.', 1);
2147: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2148: raise fnd_api.g_exc_error;

Line 2148: raise fnd_api.g_exc_error;

2144: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2145: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2146: WriteToLog ('ERROR: Apply_holds returned unexpected error.', 1);
2147: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2148: raise fnd_api.g_exc_error;
2149: END IF;
2150: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2151: WriteToLog ('WARNING: Order line put on hold due to dropped components on configuration item '|| v_config , 1);
2152: WriteToLog ('Order number: '||l_order_num, 1);

Line 2205: raise fnd_api.g_exc_error;

2201:
2202: EXCEPTION -- exception for stmt 51 and 55
2203: when others then
2204: WriteToLog ('Failed in stmt ' || lStmtNum || ' with error: '||sqlerrm, 1);
2205: raise fnd_api.g_exc_error;
2206: END ; /* check for dropped components */
2207:
2208: /*---------------------------------------------------------------+
2209: Third : Get the base model row into BOM_INVENTORY_COMPONENTS

Line 4071: raise fnd_api.g_exc_error;

4067: cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
4068:
4069:
4070:
4071: raise fnd_api.g_exc_error;
4072:
4073:
4074: end if;
4075:

Line 5089: l_return_status := FND_API.G_RET_STS_SUCCESS;

5085: l_return_status VARCHAR2(1);
5086:
5087: BEGIN
5088: i := 1;
5089: l_return_status := FND_API.G_RET_STS_SUCCESS;
5090:
5091: for rec in ctg
5092: loop
5093: l_catalog_dtls(i).cat_element_name := rec.element_name;

Line 5115: if( l_return_status = FND_API.G_RET_STS_ERROR ) then

5111: p_params => l_params,
5112: p_catalog_dtls => l_catalog_dtls,
5113: x_return_status => l_return_status);
5114:
5115: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
5116: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error', 1);
5117: RAISE FND_API.G_EXC_ERROR ;
5118:
5119: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then

Line 5117: RAISE FND_API.G_EXC_ERROR ;

5113: x_return_status => l_return_status);
5114:
5115: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
5116: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error', 1);
5117: RAISE FND_API.G_EXC_ERROR ;
5118:
5119: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
5120: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error', 1);
5121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 5119: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then

5115: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
5116: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error', 1);
5117: RAISE FND_API.G_EXC_ERROR ;
5118:
5119: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
5120: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error', 1);
5121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5122: end if ;
5123:

Line 5121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

5117: RAISE FND_API.G_EXC_ERROR ;
5118:
5119: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
5120: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error', 1);
5121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5122: end if ;
5123:
5124: if l_catalog_dtls.count <> original_count then
5125: WriteToLog ('ERROR: Custom hook did not return same number of elements.'||

Line 5128: raise FND_API.G_EXC_ERROR;

5124: if l_catalog_dtls.count <> original_count then
5125: WriteToLog ('ERROR: Custom hook did not return same number of elements.'||
5126: 'Original_count='||original_count||
5127: 'New count = '||l_catalog_dtls.count, 1);
5128: raise FND_API.G_EXC_ERROR;
5129: end if;
5130:
5131: for k in l_catalog_dtls.first..l_catalog_dtls.last
5132: loop

Line 5236: raise FND_API.G_EXC_ERROR;

5232: xErrorMessage);
5233:
5234: if l_status <> 0 then
5235: WriteToLog('ERROR:bmlupid_update_item_desc returned error::' || l_status, 1);
5236: raise FND_API.G_EXC_ERROR;
5237: end if;
5238: /*------------------------------------------------------------+
5239: Copy BOM attachments
5240: +------------------------------------------------------------*/

Line 5298: WHEN FND_API.G_EXC_ERROR THEN

5294: WHEN NO_DATA_FOUND THEN
5295: xBillID := 0;
5296: return(0);
5297:
5298: WHEN FND_API.G_EXC_ERROR THEN
5299: xErrorMessage := 'CTOCBOMB:create_bom_ml failed with expected error in stmt '||to_char(lStmtNum);
5300: xMessageName := 'CTO_CREATE_BOM_ERROR';
5301: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5302: WriteToLog('ERROR: Expected error in Update_Bom_Rtg_Loop::'||to_char(lStmtNum)||sqlerrm,1);

Line 5306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5302: WriteToLog('ERROR: Expected error in Update_Bom_Rtg_Loop::'||to_char(lStmtNum)||sqlerrm,1);
5303: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5304: return(0);
5305:
5306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5307: xErrorMessage := 'CTOCBOMB:create_bom_ml failed with unexpected error in stmt '||to_char(lStmtNum);
5308: xMessageName := 'CTO_CREATE_BOM_ERROR';
5309: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5310: WriteToLog('ERROR: Unexpected error in Update_Bom_Rtg_Loop::'||to_char(lStmtNum)||sqlerrm,1);

Line 5778: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

5774: WHEN OTHERS THEN
5775: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5776: WriteToLog('ERROR: Others error in Update_Bom_Rtg_Bulk::'||to_char(lStmtNum)||sqlerrm,1);
5777: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5778: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
5779: cto_msg_pub.count_and_get
5780: ( p_msg_count => xMsgCount
5781: , p_msg_data => xMsgData
5782: );

Line 6207: raise fnd_api.g_exc_error;

6203:
6204:
6205: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP' , l_token1 );
6206:
6207: raise fnd_api.g_exc_error;
6208:
6209:
6210:
6211:

Line 6756: raise fnd_api.g_exc_error;

6752:
6753: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR');
6754: end loop ;
6755:
6756: raise fnd_api.g_exc_error;
6757:
6758: end if ;
6759:
6760: end if;