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 260: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

256: l_return_status,
257: l_msg_count,
258: l_msg_data);
259:
260: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
261: WriteToLog('Update_In_Src_Orgs returned with expected error.', 1);
262: --RAISE FND_API.G_EXC_ERROR ;
263: --
264: -- Here, we want to skip processing for

Line 262: --RAISE FND_API.G_EXC_ERROR ;

258: l_msg_data);
259:
260: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
261: WriteToLog('Update_In_Src_Orgs returned with expected error.', 1);
262: --RAISE FND_API.G_EXC_ERROR ;
263: --
264: -- Here, we want to skip processing for
265: -- the rest of this ato_line_id, but continue
266: -- processing the remaining ato_line_ids.

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

275:
276: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
277: l_error_flag := 'Y';
278: EXIT;
279: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
280: WriteToLog('Update_In_Src_Orgs returned with unexpected error.', 1);
281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
282: END IF;
283:

Line 281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

277: l_error_flag := 'Y';
278: EXIT;
279: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
280: WriteToLog('Update_In_Src_Orgs returned with unexpected error.', 1);
281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
282: END IF;
283:
284:
285:

Line 300: p_encoded => fnd_api.g_false);

296: for i in 1..l_msg_count
297: Loop
298: l_msg_data1 := fnd_msg_pub.get(
299: p_msg_index => i,
300: p_encoded => fnd_api.g_false);
301: WriteToLog(l_msg_data1,1);
302: end loop;
303: WriteToLog('============= End of error Messages ============',1);
304: End if;

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

322: p_seq,
323: l_return_status,
324: l_msg_count,
325: l_msg_data);
326: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
327: WriteToLog('Update_Bom_Rtg_Bulk returned with expected error.', 1);
328: RAISE FND_API.G_EXC_ERROR ;
329: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
330: WriteToLog('Update_Bom_Rtg_Bulk returned with unexpected error.', 1);

Line 328: RAISE FND_API.G_EXC_ERROR ;

324: l_msg_count,
325: l_msg_data);
326: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
327: WriteToLog('Update_Bom_Rtg_Bulk returned with expected error.', 1);
328: RAISE FND_API.G_EXC_ERROR ;
329: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
330: WriteToLog('Update_Bom_Rtg_Bulk returned with unexpected error.', 1);
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
332: END IF;

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

325: l_msg_data);
326: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
327: WriteToLog('Update_Bom_Rtg_Bulk returned with expected error.', 1);
328: RAISE FND_API.G_EXC_ERROR ;
329: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
330: WriteToLog('Update_Bom_Rtg_Bulk returned with unexpected error.', 1);
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
332: END IF;
333:

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

327: WriteToLog('Update_Bom_Rtg_Bulk returned with expected error.', 1);
328: RAISE FND_API.G_EXC_ERROR ;
329: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
330: WriteToLog('Update_Bom_Rtg_Bulk returned with unexpected error.', 1);
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
332: END IF;
333:
334: --
335: -- Update rows processed to BOM_BULK

Line 360: RAISE FND_API.G_EXC_ERROR;

356:
357: EXCEPTION
358: WHEN no_data_found THEN
359: WriteToLog('ERROR: CTO seeded assignment set not found', 1);
360: RAISE FND_API.G_EXC_ERROR;
361: END;
362:
363: --
364: -- Copy sourcing from CTO to MRP Default Assignment Set

Line 491: WHEN fnd_api.g_exc_error THEN

487: End if;
488:
489: EXCEPTION
490:
491: WHEN fnd_api.g_exc_error THEN
492: WriteToLog('ERROR: Expected error in CTO_Bom_Rtg_Pk.Update_Boms_Rtgs:: '|| l_stmt_num ||'::'||sqlerrm, 1);
493: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
494: WriteToLog('Update Configuration Boms completed with WARNING');
495: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 499: WHEN fnd_api.g_exc_unexpected_error THEN

495: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
496: errbuf := 'Progam completed with warning';
497: retcode := 1; -- exit with warning
498:
499: WHEN fnd_api.g_exc_unexpected_error THEN
500: WriteToLog('ERROR: Unexpected error in CTO_Bom_Rtg_Pk.Update_Boms_Rtgs:: '|| l_stmt_num ||'::'||sqlerrm, 1);
501: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
502: WriteToLog('Update Configuration Boms completed with ERROR');
503: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 578: xReturnStatus := fnd_api.g_ret_sts_success;

574: BEGIN
575:
576: WriteToLog('Processing line_id '||pLineId, 3);
577:
578: xReturnStatus := fnd_api.g_ret_sts_success;
579:
580: --
581: -- Get total lead time for this config based on OE validation org
582: --

Line 624: raise FND_API.G_EXC_ERROR;

620: IF (lOEValidationOrg = -99) THEN
621: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++++++++', 1);
622: WriteToLog('ERROR: Unable to find OE Validation Org for line_id '||pLineId, 1);
623: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++++++++', 1);
624: raise FND_API.G_EXC_ERROR;
625: END IF;
626:
627: WriteToLog('Validation Org is :' || lOEValidationOrg,4);
628:

Line 655: raise FND_API.G_EXC_ERROR;

651: IF (lStatus = 0) THEN
652: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++', 1);
653: WriteToLog('ERROR: Error in get_model_lead_time', 1);
654: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++', 1);
655: raise FND_API.G_EXC_ERROR;
656: ELSE
657: lTotLeadTime := lLeadTime + lTotLeadTime;
658: END IF;
659:

Line 723: raise fnd_api.g_exc_error;

719:
720:
721: if (lStatus <> 1) then
722: WriteToLog('ERROR: Update_Bom_Rtg_Loop returned with error.', 1);
723: raise fnd_api.g_exc_error;
724: end if;
725:
726: v_bom_created := v_bom_created + 1 ; /* increment bom created variable */
727: lStmtNum := 130;

Line 752: raise fnd_api.g_exc_error;

748: ** In either case the error will be caught if the bom
749: ** was not created even in a single org.
750:
751: cto_msg_pub.cto_message('BOM','CTO_BOM_NOT_DEFINED');
752: raise fnd_api.g_exc_error;
753: */
754: end if; -- end check model bom
755:
756: else /* create_config_bom = 'N' */

Line 772: WHEN fnd_api.g_exc_error THEN

768:
769:
770: EXCEPTION
771:
772: WHEN fnd_api.g_exc_error THEN
773: WriteToLog('Expected error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
774: xReturnStatus := fnd_api.g_ret_sts_error;
775: cto_msg_pub.count_and_get
776: ( p_msg_count => xMsgCount

Line 774: xReturnStatus := fnd_api.g_ret_sts_error;

770: EXCEPTION
771:
772: WHEN fnd_api.g_exc_error THEN
773: WriteToLog('Expected error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
774: xReturnStatus := fnd_api.g_ret_sts_error;
775: cto_msg_pub.count_and_get
776: ( p_msg_count => xMsgCount
777: , p_msg_data => xMsgData
778: );

Line 780: WHEN fnd_api.g_exc_unexpected_error THEN

776: ( p_msg_count => xMsgCount
777: , p_msg_data => xMsgData
778: );
779:
780: WHEN fnd_api.g_exc_unexpected_error THEN
781: WriteToLog('Unexpected error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
782: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
783: cto_msg_pub.count_and_get
784: ( p_msg_count => xMsgCount

Line 782: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;

778: );
779:
780: WHEN fnd_api.g_exc_unexpected_error THEN
781: WriteToLog('Unexpected error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
782: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
783: cto_msg_pub.count_and_get
784: ( p_msg_count => xMsgCount
785: , p_msg_data => xMsgData
786: );

Line 790: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

786: );
787:
788: WHEN OTHERS then
789: WriteToLog('Others error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
790: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
791: cto_msg_pub.count_and_get
792: ( p_msg_count => xMsgCount
793: , p_msg_data => xMsgData
794: );

Line 1438: raise fnd_api.g_exc_error;

1434:
1435:
1436: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP', l_token1 );
1437:
1438: raise fnd_api.g_exc_error;
1439:
1440:
1441:
1442:

Line 1745: raise fnd_api.g_exc_error;

1741: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR');
1742:
1743: end loop ;
1744:
1745: raise fnd_api.g_exc_error;
1746:
1747: end if ;
1748:
1749: end if;

Line 1870: raise fnd_api.g_exc_error;

1866:
1867: EXCEPTION -- exception for stmt 52 ,53 and 54
1868: when others then
1869: WriteToLog('Others excepn from stmt '||lStmtNum ||':'||sqlerrm, 1);
1870: raise fnd_api.g_exc_error;
1871:
1872: END ;
1873:
1874: end loop; /* missed lines cursor */

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

1904: ,x_return_status => l_return_status
1905: ,x_msg_count => l_msg_count
1906: ,x_msg_data => l_msg_data);
1907:
1908: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1909: WriteToLog('Failed in Check Holds with expected error.' ,1);
1910: raise FND_API.G_EXC_ERROR;
1911:
1912: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1910: raise FND_API.G_EXC_ERROR;

1906: ,x_msg_data => l_msg_data);
1907:
1908: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1909: WriteToLog('Failed in Check Holds with expected error.' ,1);
1910: raise FND_API.G_EXC_ERROR;
1911:
1912: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1913: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
1914: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

1908: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1909: WriteToLog('Failed in Check Holds with expected error.' ,1);
1910: raise FND_API.G_EXC_ERROR;
1911:
1912: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1913: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
1914: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1915:
1916: ELSE

Line 1914: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1910: raise FND_API.G_EXC_ERROR;
1911:
1912: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1913: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
1914: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1915:
1916: ELSE
1917: WriteToLog('Success in Check Holds.' ,1);
1918: if l_hold_result_out = FND_API.G_FALSE then

Line 1918: if l_hold_result_out = FND_API.G_FALSE then

1914: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1915:
1916: ELSE
1917: WriteToLog('Success in Check Holds.' ,1);
1918: if l_hold_result_out = FND_API.G_FALSE then
1919:
1920: WriteToLog('Calling OM api to apply hold.' ,1);
1921: l_hold_source_rec.hold_entity_code := 'O';
1922: l_hold_source_rec.hold_id := 55;

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

1930: , x_return_status => l_return_status
1931: , x_msg_count => l_msg_count
1932: , x_msg_data => l_msg_data);
1933:
1934: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1935: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
1936: WriteToLog ('ERROR: Apply_holds returned expected error.', 1);
1937: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
1938: raise fnd_api.g_exc_error;

Line 1938: raise fnd_api.g_exc_error;

1934: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1935: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
1936: WriteToLog ('ERROR: Apply_holds returned expected error.', 1);
1937: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
1938: raise fnd_api.g_exc_error;
1939:
1940: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1941: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
1942: WriteToLog ('ERROR: Apply_holds returned unexpected error.', 1);

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

1936: WriteToLog ('ERROR: Apply_holds returned expected error.', 1);
1937: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
1938: raise fnd_api.g_exc_error;
1939:
1940: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1941: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
1942: WriteToLog ('ERROR: Apply_holds returned unexpected error.', 1);
1943: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
1944: raise fnd_api.g_exc_error;

Line 1944: raise fnd_api.g_exc_error;

1940: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1941: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
1942: WriteToLog ('ERROR: Apply_holds returned unexpected error.', 1);
1943: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
1944: raise fnd_api.g_exc_error;
1945: END IF;
1946: l_order_num := v_holds.order_num;
1947: l_line_num := v_holds.line_num;
1948:

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

2017: ,x_return_status => l_return_status
2018: ,x_msg_count => l_msg_count
2019: ,x_msg_data => l_msg_data);
2020:
2021: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2022: WriteToLog('Failed in Check Holds with expected error.' ,1);
2023: raise FND_API.G_EXC_ERROR;
2024: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2025: WriteToLog('Failed in Check Holds with unexpected error.' ,1);

Line 2023: raise FND_API.G_EXC_ERROR;

2019: ,x_msg_data => l_msg_data);
2020:
2021: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2022: WriteToLog('Failed in Check Holds with expected error.' ,1);
2023: raise FND_API.G_EXC_ERROR;
2024: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2025: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
2026: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2027: ELSE

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

2020:
2021: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2022: WriteToLog('Failed in Check Holds with expected error.' ,1);
2023: raise FND_API.G_EXC_ERROR;
2024: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2025: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
2026: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2027: ELSE
2028: WriteToLog('Success in Check Holds.' ,1);

Line 2026: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2022: WriteToLog('Failed in Check Holds with expected error.' ,1);
2023: raise FND_API.G_EXC_ERROR;
2024: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2025: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
2026: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2027: ELSE
2028: WriteToLog('Success in Check Holds.' ,1);
2029: if l_hold_result_out = FND_API.G_FALSE then
2030:

Line 2029: if l_hold_result_out = FND_API.G_FALSE then

2025: WriteToLog('Failed in Check Holds with unexpected error.' ,1);
2026: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2027: ELSE
2028: WriteToLog('Success in Check Holds.' ,1);
2029: if l_hold_result_out = FND_API.G_FALSE then
2030:
2031: WriteToLog('Calling OM api to apply hold.' ,1);
2032: l_hold_source_rec.hold_entity_code := 'O';
2033: l_hold_source_rec.hold_id := 55;

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

2045: , x_return_status => l_return_status
2046: , x_msg_count => l_msg_count
2047: , x_msg_data => l_msg_data);
2048:
2049: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2050: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2051: WriteToLog ('ERROR: Apply_holds returned expected error.', 1);
2052: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2053: raise fnd_api.g_exc_error;

Line 2053: raise fnd_api.g_exc_error;

2049: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2050: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2051: WriteToLog ('ERROR: Apply_holds returned expected error.', 1);
2052: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2053: raise fnd_api.g_exc_error;
2054:
2055: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2056: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2057: WriteToLog ('ERROR: Apply_holds returned unexpected error.', 1);

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

2051: WriteToLog ('ERROR: Apply_holds returned expected error.', 1);
2052: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2053: raise fnd_api.g_exc_error;
2054:
2055: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2056: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2057: WriteToLog ('ERROR: Apply_holds returned unexpected error.', 1);
2058: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2059: raise fnd_api.g_exc_error;

Line 2059: raise fnd_api.g_exc_error;

2055: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2056: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2057: WriteToLog ('ERROR: Apply_holds returned unexpected error.', 1);
2058: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2059: raise fnd_api.g_exc_error;
2060: END IF;
2061: WriteToLog ('+++++++++++++++++++++++++++++++++++++++++++++', 1);
2062: WriteToLog ('WARNING: Order line put on hold due to dropped components on configuration item '|| v_config , 1);
2063: WriteToLog ('Order number: '||l_order_num, 1);

Line 2116: raise fnd_api.g_exc_error;

2112:
2113: EXCEPTION -- exception for stmt 51 and 55
2114: when others then
2115: WriteToLog ('Failed in stmt ' || lStmtNum || ' with error: '||sqlerrm, 1);
2116: raise fnd_api.g_exc_error;
2117: END ; /* check for dropped components */
2118:
2119: /*---------------------------------------------------------------+
2120: Third : Get the base model row into BOM_INVENTORY_COMPONENTS

Line 3904: raise fnd_api.g_exc_error;

3900: cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
3901:
3902:
3903:
3904: raise fnd_api.g_exc_error;
3905:
3906:
3907: end if;
3908:

Line 4890: l_return_status := FND_API.G_RET_STS_SUCCESS;

4886: l_return_status VARCHAR2(1);
4887:
4888: BEGIN
4889: i := 1;
4890: l_return_status := FND_API.G_RET_STS_SUCCESS;
4891:
4892: for rec in ctg
4893: loop
4894: l_catalog_dtls(i).cat_element_name := rec.element_name;

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

4912: p_params => l_params,
4913: p_catalog_dtls => l_catalog_dtls,
4914: x_return_status => l_return_status);
4915:
4916: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
4917: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error', 1);
4918: RAISE FND_API.G_EXC_ERROR ;
4919:
4920: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then

Line 4918: RAISE FND_API.G_EXC_ERROR ;

4914: x_return_status => l_return_status);
4915:
4916: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
4917: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error', 1);
4918: RAISE FND_API.G_EXC_ERROR ;
4919:
4920: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
4921: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error', 1);
4922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

4916: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
4917: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error', 1);
4918: RAISE FND_API.G_EXC_ERROR ;
4919:
4920: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
4921: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error', 1);
4922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4923: end if ;
4924:

Line 4922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4918: RAISE FND_API.G_EXC_ERROR ;
4919:
4920: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
4921: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error', 1);
4922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4923: end if ;
4924:
4925: if l_catalog_dtls.count <> original_count then
4926: WriteToLog ('ERROR: Custom hook did not return same number of elements.'||

Line 4929: raise FND_API.G_EXC_ERROR;

4925: if l_catalog_dtls.count <> original_count then
4926: WriteToLog ('ERROR: Custom hook did not return same number of elements.'||
4927: 'Original_count='||original_count||
4928: 'New count = '||l_catalog_dtls.count, 1);
4929: raise FND_API.G_EXC_ERROR;
4930: end if;
4931:
4932: for k in l_catalog_dtls.first..l_catalog_dtls.last
4933: loop

Line 5037: raise FND_API.G_EXC_ERROR;

5033: xErrorMessage);
5034:
5035: if l_status <> 0 then
5036: WriteToLog('ERROR:bmlupid_update_item_desc returned error::' || l_status, 1);
5037: raise FND_API.G_EXC_ERROR;
5038: end if;
5039: /*------------------------------------------------------------+
5040: Copy BOM attachments
5041: +------------------------------------------------------------*/

Line 5089: WHEN FND_API.G_EXC_ERROR THEN

5085: WHEN NO_DATA_FOUND THEN
5086: xBillID := 0;
5087: return(0);
5088:
5089: WHEN FND_API.G_EXC_ERROR THEN
5090: xErrorMessage := 'CTOCBOMB:create_bom_ml failed with expected error in stmt '||to_char(lStmtNum);
5091: xMessageName := 'CTO_CREATE_BOM_ERROR';
5092: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5093: WriteToLog('ERROR: Expected error in Update_Bom_Rtg_Loop::'||to_char(lStmtNum)||sqlerrm,1);

Line 5097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5093: WriteToLog('ERROR: Expected error in Update_Bom_Rtg_Loop::'||to_char(lStmtNum)||sqlerrm,1);
5094: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5095: return(0);
5096:
5097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5098: xErrorMessage := 'CTOCBOMB:create_bom_ml failed with unexpected error in stmt '||to_char(lStmtNum);
5099: xMessageName := 'CTO_CREATE_BOM_ERROR';
5100: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5101: WriteToLog('ERROR: Unexpected error in Update_Bom_Rtg_Loop::'||to_char(lStmtNum)||sqlerrm,1);

Line 5569: xReturnStatus := fnd_api.g_ret_sts_unexp_error;

5565: WHEN OTHERS THEN
5566: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5567: WriteToLog('ERROR: Others error in Update_Bom_Rtg_Bulk::'||to_char(lStmtNum)||sqlerrm,1);
5568: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5569: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
5570: cto_msg_pub.count_and_get
5571: ( p_msg_count => xMsgCount
5572: , p_msg_data => xMsgData
5573: );

Line 5998: raise fnd_api.g_exc_error;

5994:
5995:
5996: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP' , l_token1 );
5997:
5998: raise fnd_api.g_exc_error;
5999:
6000:
6001:
6002:

Line 6544: raise fnd_api.g_exc_error;

6540:
6541: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR');
6542: end loop ;
6543:
6544: raise fnd_api.g_exc_error;
6545:
6546: end if ;
6547:
6548: end if;