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_ITEMS_PK dependencies on FND_API

Line 172: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

168:
169: BEGIN
170:
171: WriteToLog('Entering create_items_and_sourcing', 1);
172: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
173:
174: --
175: -- Call OSS processing
176: -- Populate / refresh bcso for all lines in bcol_upg

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

219: x_msg_count => l_msg_count,
220: x_msg_data => l_msg_data);
221:
222: -- Bugfix 13362916
223: -- IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
224: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
225: WriteToLog('ERROR: Process oss configurations returned with exp error',1);
226:
227: --Bugfix 6376208: Not all upgrade cases will be present on SO lines. Handle the NDF

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

220: x_msg_data => l_msg_data);
221:
222: -- Bugfix 13362916
223: -- IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
224: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
225: WriteToLog('ERROR: Process oss configurations returned with exp error',1);
226:
227: --Bugfix 6376208: Not all upgrade cases will be present on SO lines. Handle the NDF
228: begin

Line 255: p_encoded => FND_API.G_FALSE);

251: FOR l_index IN 1..nvl(l_msg_count,1) LOOP
252: lstmtnum := 20;
253: l_msg_data := fnd_msg_pub.get(
254: p_msg_index => l_index,
255: p_encoded => FND_API.G_FALSE);
256: lstmtnum := 30;
257: WriteToLog('Error : '||substr(l_msg_data,1,250), 1);
258: END LOOP;
259: lstmtnum := 40;

Line 269: --raise FND_API.G_EXC_ERROR;

265: where ato_line_id = v_lines.ato_line_id;
266:
267: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
268: GOTO SKIP;
269: --raise FND_API.G_EXC_ERROR;
270: /* Bugfix 13362916
271: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
272: WriteToLog('ERROR: Process_oss_configurations returned with unexp error',1);
273: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

267: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
268: GOTO SKIP;
269: --raise FND_API.G_EXC_ERROR;
270: /* Bugfix 13362916
271: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
272: WriteToLog('ERROR: Process_oss_configurations returned with unexp error',1);
273: raise FND_API.G_EXC_UNEXPECTED_ERROR;
274: */
275: END IF;

Line 273: raise FND_API.G_EXC_UNEXPECTED_ERROR;

269: --raise FND_API.G_EXC_ERROR;
270: /* Bugfix 13362916
271: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
272: WriteToLog('ERROR: Process_oss_configurations returned with unexp error',1);
273: raise FND_API.G_EXC_UNEXPECTED_ERROR;
274: */
275: END IF;
276:
277: --

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

319: l_msg_count,
320: l_msg_data);
321:
322: -- Bugfix 13362916
323: -- IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
324: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
325: WriteToLog('ERROR: Populate_src_orgs_upg returned with status:' || l_return_status, 1);
326:
327: -- Bugfix 13362916

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

320: l_msg_data);
321:
322: -- Bugfix 13362916
323: -- IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
324: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
325: WriteToLog('ERROR: Populate_src_orgs_upg returned with status:' || l_return_status, 1);
326:
327: -- Bugfix 13362916
328: BEGIN

Line 350: p_encoded => FND_API.G_FALSE);

346:
347: FOR l_index IN 1..nvl(l_msg_count,1) LOOP
348: l_msg_data := fnd_msg_pub.get(
349: p_msg_index => l_index,
350: p_encoded => FND_API.G_FALSE);
351: WriteToLog('Error : '||substr(l_msg_data,1,250), 1);
352: END LOOP;
353: lstmtnum := 40;
354: WriteToLog('++++++++++++++++++++++++++++++++++++++++++', 1);

Line 363: --raise FND_API.G_EXC_ERROR;

359: where ato_line_id = v_lines.ato_line_id;
360:
361: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
362: GOTO SKIP;
363: --raise FND_API.G_EXC_ERROR;
364: -- Bugfix 13362916
365: /*
366: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
367: WriteToLog('ERROR: Populate_src_orgs_upg returned with unexp error',1);

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

362: GOTO SKIP;
363: --raise FND_API.G_EXC_ERROR;
364: -- Bugfix 13362916
365: /*
366: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
367: WriteToLog('ERROR: Populate_src_orgs_upg returned with unexp error',1);
368: raise FND_API.G_EXC_UNEXPECTED_ERROR;
369: */
370: END IF;

Line 368: raise FND_API.G_EXC_UNEXPECTED_ERROR;

364: -- Bugfix 13362916
365: /*
366: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
367: WriteToLog('ERROR: Populate_src_orgs_upg returned with unexp error',1);
368: raise FND_API.G_EXC_UNEXPECTED_ERROR;
369: */
370: END IF;
371:
372: WriteToLog('After populate_src_orgs_upg:: seq::'||to_char(l_seq), 4);

Line 407: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN

403: l_msg_count,
404: l_msg_data);
405:
406: -- Update_Bcso only returns unexp errors
407: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
408: WriteToLog('Update_bcso returned with unexpected error', 1);
409: --Bugfix 13362916
410: WriteToLog('Skipping ato_line_id:' || v_lines.ato_line_id, 1);
411: --raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 411: --raise FND_API.G_EXC_UNEXPECTED_ERROR;

407: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
408: WriteToLog('Update_bcso returned with unexpected error', 1);
409: --Bugfix 13362916
410: WriteToLog('Skipping ato_line_id:' || v_lines.ato_line_id, 1);
411: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
412: GOTO SKIP;
413: END IF;
414:
415: /*

Line 484: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN

480: l_msg_count,
481: l_msg_data);
482:
483: -- Update_Acc_Items only returns unexp errors
484: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
485: WriteToLog('Update_Acc_Items returned with unexpected error', 1);
486: raise FND_API.G_EXC_UNEXPECTED_ERROR;
487: END IF;
488:

Line 486: raise FND_API.G_EXC_UNEXPECTED_ERROR;

482:
483: -- Update_Acc_Items only returns unexp errors
484: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
485: WriteToLog('Update_Acc_Items returned with unexpected error', 1);
486: raise FND_API.G_EXC_UNEXPECTED_ERROR;
487: END IF;
488:
489:
490: --

Line 501: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN

497: l_msg_count,
498: l_msg_data);
499:
500: -- Update_Pc_Items only returns unexp errors
501: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
502: WriteToLog('Update_Acc_Items returned with unexpected error', 1);
503: raise FND_API.G_EXC_UNEXPECTED_ERROR;
504: END IF;
505:

Line 503: raise FND_API.G_EXC_UNEXPECTED_ERROR;

499:
500: -- Update_Pc_Items only returns unexp errors
501: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
502: WriteToLog('Update_Acc_Items returned with unexpected error', 1);
503: raise FND_API.G_EXC_UNEXPECTED_ERROR;
504: END IF;
505:
506: --
507: -- create data for items in child tables

Line 515: IF (l_return_status = fnd_api.G_RET_STS_ERROR) THEN

511: l_return_status,
512: l_msg_count,
513: l_msg_data);
514:
515: IF (l_return_status = fnd_api.G_RET_STS_ERROR) THEN
516: WriteToLog('Update_Item_Data returned with expected error', 1);
517: raise FND_API.G_EXC_ERROR;
518: ELSIF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
519: WriteToLog('Update_Item_Data returned with unexpected error', 1);

Line 517: raise FND_API.G_EXC_ERROR;

513: l_msg_data);
514:
515: IF (l_return_status = fnd_api.G_RET_STS_ERROR) THEN
516: WriteToLog('Update_Item_Data returned with expected error', 1);
517: raise FND_API.G_EXC_ERROR;
518: ELSIF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
519: WriteToLog('Update_Item_Data returned with unexpected error', 1);
520: raise FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;

Line 518: ELSIF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN

514:
515: IF (l_return_status = fnd_api.G_RET_STS_ERROR) THEN
516: WriteToLog('Update_Item_Data returned with expected error', 1);
517: raise FND_API.G_EXC_ERROR;
518: ELSIF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
519: WriteToLog('Update_Item_Data returned with unexpected error', 1);
520: raise FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:

Line 520: raise FND_API.G_EXC_UNEXPECTED_ERROR;

516: WriteToLog('Update_Item_Data returned with expected error', 1);
517: raise FND_API.G_EXC_ERROR;
518: ELSIF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
519: WriteToLog('Update_Item_Data returned with unexpected error', 1);
520: raise FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:
523: --
524: -- Update status to 'ITEM'

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

584: p_changed_src => p_changed_src );
585:
586: -- bug 13362916
587: --
588: -- IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
589: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
590: WriteToLog('ERROR: Create_oss_sourcing_rules returned with status:' || l_return_status,1);
591:
592: -- bug 13362916

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

585:
586: -- bug 13362916
587: --
588: -- IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
589: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
590: WriteToLog('ERROR: Create_oss_sourcing_rules returned with status:' || l_return_status,1);
591:
592: -- bug 13362916
593: BEGIN

Line 615: p_encoded => FND_API.G_FALSE);

611:
612: FOR l_index IN 1..nvl(l_msg_count,1) LOOP
613: l_msg_data := fnd_msg_pub.get(
614: p_msg_index => l_index,
615: p_encoded => FND_API.G_FALSE);
616: WriteToLog('Error : '||substr(l_msg_data,1,250), 1);
617: END LOOP;
618: lstmtnum := 40;
619: WriteToLog('++++++++++++++++++++++++++++++++++++++++++', 1);

Line 628: --raise FND_API.G_EXC_ERROR;

624: where ato_line_id = v_lines.ato_line_id;
625:
626: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
627: GOTO SKIP2;
628: --raise FND_API.G_EXC_ERROR;
629: -- 13362916
630: /*
631: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
632: WriteToLog('ERROR: Create_oss_sourcing_rules returned with unexp error',1);

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

627: GOTO SKIP2;
628: --raise FND_API.G_EXC_ERROR;
629: -- 13362916
630: /*
631: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
632: WriteToLog('ERROR: Create_oss_sourcing_rules returned with unexp error',1);
633: raise FND_API.G_EXC_UNEXPECTED_ERROR;
634: */
635: END IF;

Line 633: raise FND_API.G_EXC_UNEXPECTED_ERROR;

629: -- 13362916
630: /*
631: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
632: WriteToLog('ERROR: Create_oss_sourcing_rules returned with unexp error',1);
633: raise FND_API.G_EXC_UNEXPECTED_ERROR;
634: */
635: END IF;
636:
637: --debugging for bug 13029577

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

703: x_msg_count => l_msg_count,
704: x_msg_data => l_msg_data);
705:
706: -- Bugfix 13362916
707: -- IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
708: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
709: WriteToLog('ERROR: Create_sourcing_rules returned with status:' || l_return_status,1);
710:
711: -- bug 13362916

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

704: x_msg_data => l_msg_data);
705:
706: -- Bugfix 13362916
707: -- IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
708: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
709: WriteToLog('ERROR: Create_sourcing_rules returned with status:' || l_return_status,1);
710:
711: -- bug 13362916
712: BEGIN

Line 734: p_encoded => FND_API.G_FALSE);

730:
731: FOR l_index IN 1..nvl(l_msg_count,1) LOOP
732: l_msg_data := fnd_msg_pub.get(
733: p_msg_index => l_index,
734: p_encoded => FND_API.G_FALSE);
735: WriteToLog('Error : '||substr(l_msg_data,1,250), 1);
736: END LOOP;
737: WriteToLog('++++++++++++++++++++++++++++++++++++++++++', 1);
738:

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

744: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
745: GOTO SKIP2;
746: -- Bug 13362916
747: /*
748: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
749: WriteToLog('ERROR: Create_sourcing_rules returned with unexp error',1);
750: raise FND_API.G_EXC_UNEXPECTED_ERROR;
751: */
752: END IF;

Line 750: raise FND_API.G_EXC_UNEXPECTED_ERROR;

746: -- Bug 13362916
747: /*
748: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
749: WriteToLog('ERROR: Create_sourcing_rules returned with unexp error',1);
750: raise FND_API.G_EXC_UNEXPECTED_ERROR;
751: */
752: END IF;
753: ELSIF (v_src_rule.config_creation = 3 ) THEN
754: --

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

767: x_msg_count => l_msg_count,
768: x_msg_data => l_msg_data);
769:
770: -- bug 13362916
771: -- IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
773: WriteToLog('ERROR: Create_type3_sourcing_rules returned with status:' || l_return_status, 1);
774:
775: -- bug 13362916

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

768: x_msg_data => l_msg_data);
769:
770: -- bug 13362916
771: -- IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
773: WriteToLog('ERROR: Create_type3_sourcing_rules returned with status:' || l_return_status, 1);
774:
775: -- bug 13362916
776: BEGIN

Line 798: p_encoded => FND_API.G_FALSE);

794:
795: FOR l_index IN 1..nvl(l_msg_count,1) LOOP
796: l_msg_data := fnd_msg_pub.get(
797: p_msg_index => l_index,
798: p_encoded => FND_API.G_FALSE);
799: WriteToLog('Error : '||substr(l_msg_data,1,250), 1);
800: END LOOP;
801: WriteToLog('++++++++++++++++++++++++++++++++++++++++++', 1);
802:

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

808: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
809: GOTO SKIP2;
810: -- Bug 13362916
811: /*
812: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
813: WriteToLog('ERROR: Create_type3_sourcing_rules returned with unexp error',1);
814: raise FND_API.G_EXC_UNEXPECTED_ERROR;
815: */
816: END IF;

Line 814: raise FND_API.G_EXC_UNEXPECTED_ERROR;

810: -- Bug 13362916
811: /*
812: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
813: WriteToLog('ERROR: Create_type3_sourcing_rules returned with unexp error',1);
814: raise FND_API.G_EXC_UNEXPECTED_ERROR;
815: */
816: END IF;
817: END IF;
818: END IF;

Line 846: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

842: cto_msg_pub.count_and_get
843: ( p_msg_count => xMsgCount
844: , p_msg_data => xMsgData
845: );
846: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
847: --return(0);
848:
849: when FND_API.G_EXC_ERROR then
850: WriteToLog('ERROR: Expected error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

Line 849: when FND_API.G_EXC_ERROR then

845: );
846: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
847: --return(0);
848:
849: when FND_API.G_EXC_ERROR then
850: WriteToLog('ERROR: Expected error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
851: cto_msg_pub.count_and_get
852: ( p_msg_count => xMsgCount
853: , p_msg_data => xMsgData

Line 855: xReturnStatus := FND_API.G_RET_STS_ERROR;

851: cto_msg_pub.count_and_get
852: ( p_msg_count => xMsgCount
853: , p_msg_data => xMsgData
854: );
855: xReturnStatus := FND_API.G_RET_STS_ERROR;
856: --return(0);
857:
858: when FND_API.G_EXC_UNEXPECTED_ERROR then
859: WriteToLog('ERROR: Unxpected error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

Line 858: when FND_API.G_EXC_UNEXPECTED_ERROR then

854: );
855: xReturnStatus := FND_API.G_RET_STS_ERROR;
856: --return(0);
857:
858: when FND_API.G_EXC_UNEXPECTED_ERROR then
859: WriteToLog('ERROR: Unxpected error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
860: cto_msg_pub.count_and_get
861: ( p_msg_count => xMsgCount
862: , p_msg_data => xMsgData

Line 864: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

860: cto_msg_pub.count_and_get
861: ( p_msg_count => xMsgCount
862: , p_msg_data => xMsgData
863: );
864: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
865: --return(0);
866:
867: when OTHERS then
868: WriteToLog('ERROR: Others error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

Line 873: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

869: cto_msg_pub.count_and_get
870: ( p_msg_count => xMsgCount
871: , p_msg_data => xMsgData
872: );
873: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
874: --return(0);
875:
876: END Update_Items_And_Sourcing;
877:

Line 930: l_return_status := FND_API.G_RET_STS_SUCCESS;

926: -- 2. For each config, identify all order lines
927: -- 3. For each order line, delete sourcing from bcso for this config
928: -- and insert line referencing bcmo.
929: --
930: l_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: lStmtNum := 10;
933: WriteToLog('Entering update_bcso', 3);
934:

Line 1037: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1033: cto_msg_pub.count_and_get
1034: ( p_msg_count => l_msg_count
1035: , p_msg_data => l_msg_data
1036: );
1037: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1038:
1039: END Update_Bcso;
1040:
1041:

Line 1154: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

1150: BEGIN
1151:
1152: WriteToLog('Entering Update_Item_Data', 3);
1153: lStmtNumber := 10;
1154: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
1155:
1156: insert into mtl_system_items_tl (
1157: inventory_item_id,
1158: organization_id,

Line 1694: raise FND_API.G_EXC_ERROR;

1690: IF PG_DEBUG <> 0 THEN
1691: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
1692: END IF;
1693: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1694: raise FND_API.G_EXC_ERROR;
1695: when others then
1696:
1697: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1698: end ;

Line 1697: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1693: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1694: raise FND_API.G_EXC_ERROR;
1695: when others then
1696:
1697: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1698: end ;
1699:
1700: when others then
1701: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1701: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1697: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1698: end ;
1699:
1700: when others then
1701: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1702: end ;
1703: /* end bugfix 4057651, default CTO cost type id = 7 if it does not exist */
1704:
1705:

Line 2153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2149:
2150: IF (l_layer_id = 0) THEN
2151: WriteToLog('Create_Item: ' || 'CST function create_layer returned with error '||to_char(x_err_num)||', '||x_msg_name||', '||
2152: lMsgData||'for '||to_char(v_layer.org_id)||', '||to_char(v_layer.cost_group_id),1);
2153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2154: ELSE
2155: WriteToLog('Inserted row into cql for '||to_char(l_layer_id)||', '||to_char(v_layer.org_id)||', '|| to_char(v_layer.cost_group_id),1);
2156: END IF;
2157:

Line 3025: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

3021: CTO_MSG_PUB.Count_And_Get(
3022: p_msg_count => lMsgCount,
3023: p_msg_data => lMsgData
3024: );
3025: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
3026:
3027: WHEN FND_API.G_EXC_ERROR THEN
3028: WriteToLog ('ERROR:Expected error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
3029: CTO_MSG_PUB.Count_And_Get(

Line 3027: WHEN FND_API.G_EXC_ERROR THEN

3023: p_msg_data => lMsgData
3024: );
3025: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
3026:
3027: WHEN FND_API.G_EXC_ERROR THEN
3028: WriteToLog ('ERROR:Expected error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
3029: CTO_MSG_PUB.Count_And_Get(
3030: p_msg_count => lMsgCount,
3031: p_msg_data => lMsgData

Line 3033: xReturnStatus := FND_API.G_RET_STS_ERROR;

3029: CTO_MSG_PUB.Count_And_Get(
3030: p_msg_count => lMsgCount,
3031: p_msg_data => lMsgData
3032: );
3033: xReturnStatus := FND_API.G_RET_STS_ERROR;
3034:
3035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3036: WriteToLog ('ERROR:Unexpected error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
3037: CTO_MSG_PUB.Count_And_Get(

Line 3035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3031: p_msg_data => lMsgData
3032: );
3033: xReturnStatus := FND_API.G_RET_STS_ERROR;
3034:
3035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3036: WriteToLog ('ERROR:Unexpected error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
3037: CTO_MSG_PUB.Count_And_Get(
3038: p_msg_count => lMsgCount,
3039: p_msg_data => lMsgData

Line 3041: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

3037: CTO_MSG_PUB.Count_And_Get(
3038: p_msg_count => lMsgCount,
3039: p_msg_data => lMsgData
3040: );
3041: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
3042:
3043: WHEN OTHERS THEN
3044: WriteToLog ('ERROR:Others error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
3045: CTO_MSG_PUB.Count_And_Get(

Line 3049: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

3045: CTO_MSG_PUB.Count_And_Get(
3046: p_msg_count => lMsgCount,
3047: p_msg_data => lMsgData
3048: );
3049: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
3050:
3051: END Update_Item_Data;
3052:
3053:

Line 3104: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

3100:
3101: WriteToLog('Entering Update_Acc_Items', 3);
3102:
3103: lStmtNumber := 10;
3104: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
3105:
3106: lItemType := FND_PROFILE.Value('BOM:CONFIG_ITEM_TYPE');
3107:
3108: --perf bugfix 4905887 (sql id 16105473)

Line 3843: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

3839: CTO_MSG_PUB.Count_And_Get(
3840: p_msg_count => xMsgCount,
3841: p_msg_data => xMsgData
3842: );
3843: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
3844:
3845: END Update_Acc_Items;
3846:
3847:

Line 3883: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

3879: BEGIN
3880:
3881: WriteToLog('Entering Update_Pc_Items', 3);
3882: lStmtNumber := 10;
3883: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
3884:
3885: lItemType := FND_PROFILE.Value('BOM:CONFIG_ITEM_TYPE');
3886:
3887: select substr(attribute_name, instr(attribute_name, '.' )+ 1), control_level

Line 4625: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

4621: CTO_MSG_PUB.Count_And_Get(
4622: p_msg_count => xMsgCount,
4623: p_msg_data => xMsgData
4624: );
4625: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
4626:
4627: END Update_Pc_Items;
4628:
4629: