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 163: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

159:
160: BEGIN
161:
162: WriteToLog('Entering create_items_and_sourcing', 1);
163: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
164:
165: --
166: -- Call OSS processing
167: -- Populate / refresh bcso for all lines in bcol_upg

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

200: x_return_status => l_return_status,
201: x_msg_count => l_msg_count,
202: x_msg_data => l_msg_data);
203:
204: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
205: WriteToLog('ERROR: Process oss configurations returned with exp error',1);
206:
207: --Bugfix 6376208: Not all upgrade cases will be present on SO lines. Handle the NDF
208: begin

Line 235: p_encoded => FND_API.G_FALSE);

231: FOR l_index IN 1..nvl(l_msg_count,1) LOOP
232: lstmtnum := 20;
233: l_msg_data := fnd_msg_pub.get(
234: p_msg_index => l_index,
235: p_encoded => FND_API.G_FALSE);
236: lstmtnum := 30;
237: WriteToLog('Error : '||substr(l_msg_data,1,250), 1);
238: END LOOP;
239: lstmtnum := 40;

Line 249: --raise FND_API.G_EXC_ERROR;

245: where ato_line_id = v_lines.ato_line_id;
246:
247: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
248: GOTO SKIP;
249: --raise FND_API.G_EXC_ERROR;
250: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
251: WriteToLog('ERROR: Process_oss_configurations returned with unexp error',1);
252: raise FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;

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

246:
247: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
248: GOTO SKIP;
249: --raise FND_API.G_EXC_ERROR;
250: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
251: WriteToLog('ERROR: Process_oss_configurations returned with unexp error',1);
252: raise FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254:

Line 252: raise FND_API.G_EXC_UNEXPECTED_ERROR;

248: GOTO SKIP;
249: --raise FND_API.G_EXC_ERROR;
250: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
251: WriteToLog('ERROR: Process_oss_configurations returned with unexp error',1);
252: raise FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254:
255: --
256: -- Refresh bcso, create src for each ato_line_id

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

296: l_return_status,
297: l_msg_count,
298: l_msg_data);
299:
300: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
301: WriteToLog('ERROR: Populate_src_orgs_upg returned with exp error',1);
302: select oeh.order_number
303: into l_order_number
304: from oe_order_lines_all oel,

Line 319: p_encoded => FND_API.G_FALSE);

315:
316: FOR l_index IN 1..nvl(l_msg_count,1) LOOP
317: l_msg_data := fnd_msg_pub.get(
318: p_msg_index => l_index,
319: p_encoded => FND_API.G_FALSE);
320: WriteToLog('Error : '||substr(l_msg_data,1,250), 1);
321: END LOOP;
322: lstmtnum := 40;
323: WriteToLog('++++++++++++++++++++++++++++++++++++++++++', 1);

Line 332: --raise FND_API.G_EXC_ERROR;

328: where ato_line_id = v_lines.ato_line_id;
329:
330: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
331: GOTO SKIP;
332: --raise FND_API.G_EXC_ERROR;
333: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
334: WriteToLog('ERROR: Populate_src_orgs_upg returned with unexp error',1);
335: raise FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;

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

329:
330: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
331: GOTO SKIP;
332: --raise FND_API.G_EXC_ERROR;
333: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
334: WriteToLog('ERROR: Populate_src_orgs_upg returned with unexp error',1);
335: raise FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;
337:

Line 335: raise FND_API.G_EXC_UNEXPECTED_ERROR;

331: GOTO SKIP;
332: --raise FND_API.G_EXC_ERROR;
333: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
334: WriteToLog('ERROR: Populate_src_orgs_upg returned with unexp error',1);
335: raise FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;
337:
338: WriteToLog('After populate_src_orgs_upg:: seq::'||to_char(l_seq), 4);
339:

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

369: l_msg_count,
370: l_msg_data);
371:
372: -- Update_Bcso only returns unexp errors
373: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
374: WriteToLog('Update_bcso returned with unexpected error', 1);
375: raise FND_API.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377:

Line 375: raise FND_API.G_EXC_UNEXPECTED_ERROR;

371:
372: -- Update_Bcso only returns unexp errors
373: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
374: WriteToLog('Update_bcso returned with unexpected error', 1);
375: raise FND_API.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377:
378: /*
379: else

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

440: l_msg_count,
441: l_msg_data);
442:
443: -- Update_Acc_Items only returns unexp errors
444: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
445: WriteToLog('Update_Acc_Items returned with unexpected error', 1);
446: raise FND_API.G_EXC_UNEXPECTED_ERROR;
447: END IF;
448:

Line 446: raise FND_API.G_EXC_UNEXPECTED_ERROR;

442:
443: -- Update_Acc_Items only returns unexp errors
444: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
445: WriteToLog('Update_Acc_Items returned with unexpected error', 1);
446: raise FND_API.G_EXC_UNEXPECTED_ERROR;
447: END IF;
448:
449:
450: --

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

457: l_msg_count,
458: l_msg_data);
459:
460: -- Update_Pc_Items only returns unexp errors
461: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
462: WriteToLog('Update_Acc_Items returned with unexpected error', 1);
463: raise FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465:

Line 463: raise FND_API.G_EXC_UNEXPECTED_ERROR;

459:
460: -- Update_Pc_Items only returns unexp errors
461: IF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
462: WriteToLog('Update_Acc_Items returned with unexpected error', 1);
463: raise FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465:
466: --
467: -- create data for items in child tables

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

471: l_return_status,
472: l_msg_count,
473: l_msg_data);
474:
475: IF (l_return_status = fnd_api.G_RET_STS_ERROR) THEN
476: WriteToLog('Update_Item_Data returned with expected error', 1);
477: raise FND_API.G_EXC_ERROR;
478: ELSIF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
479: WriteToLog('Update_Item_Data returned with unexpected error', 1);

Line 477: raise FND_API.G_EXC_ERROR;

473: l_msg_data);
474:
475: IF (l_return_status = fnd_api.G_RET_STS_ERROR) THEN
476: WriteToLog('Update_Item_Data returned with expected error', 1);
477: raise FND_API.G_EXC_ERROR;
478: ELSIF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
479: WriteToLog('Update_Item_Data returned with unexpected error', 1);
480: raise FND_API.G_EXC_UNEXPECTED_ERROR;
481: END IF;

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

474:
475: IF (l_return_status = fnd_api.G_RET_STS_ERROR) THEN
476: WriteToLog('Update_Item_Data returned with expected error', 1);
477: raise FND_API.G_EXC_ERROR;
478: ELSIF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
479: WriteToLog('Update_Item_Data returned with unexpected error', 1);
480: raise FND_API.G_EXC_UNEXPECTED_ERROR;
481: END IF;
482:

Line 480: raise FND_API.G_EXC_UNEXPECTED_ERROR;

476: WriteToLog('Update_Item_Data returned with expected error', 1);
477: raise FND_API.G_EXC_ERROR;
478: ELSIF (l_return_status = fnd_api.G_RET_STS_UNEXP_ERROR) THEN
479: WriteToLog('Update_Item_Data returned with unexpected error', 1);
480: raise FND_API.G_EXC_UNEXPECTED_ERROR;
481: END IF;
482:
483: --
484: -- Update status to 'ITEM'

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

527: x_msg_count => l_msg_count,
528: x_msg_data => l_msg_data,
529: p_changed_src => p_changed_src );
530:
531: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
532: WriteToLog('ERROR: Create_oss_sourcing_rules returned with exp error',1);
533: select oeh.order_number
534: into l_order_number
535: from oe_order_lines_all oel,

Line 550: p_encoded => FND_API.G_FALSE);

546:
547: FOR l_index IN 1..nvl(l_msg_count,1) LOOP
548: l_msg_data := fnd_msg_pub.get(
549: p_msg_index => l_index,
550: p_encoded => FND_API.G_FALSE);
551: WriteToLog('Error : '||substr(l_msg_data,1,250), 1);
552: END LOOP;
553: lstmtnum := 40;
554: WriteToLog('++++++++++++++++++++++++++++++++++++++++++', 1);

Line 563: --raise FND_API.G_EXC_ERROR;

559: where ato_line_id = v_lines.ato_line_id;
560:
561: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
562: GOTO SKIP2;
563: --raise FND_API.G_EXC_ERROR;
564: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
565: WriteToLog('ERROR: Create_oss_sourcing_rules returned with unexp error',1);
566: raise FND_API.G_EXC_UNEXPECTED_ERROR;
567: END IF;

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

560:
561: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
562: GOTO SKIP2;
563: --raise FND_API.G_EXC_ERROR;
564: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
565: WriteToLog('ERROR: Create_oss_sourcing_rules returned with unexp error',1);
566: raise FND_API.G_EXC_UNEXPECTED_ERROR;
567: END IF;
568:

Line 566: raise FND_API.G_EXC_UNEXPECTED_ERROR;

562: GOTO SKIP2;
563: --raise FND_API.G_EXC_ERROR;
564: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
565: WriteToLog('ERROR: Create_oss_sourcing_rules returned with unexp error',1);
566: raise FND_API.G_EXC_UNEXPECTED_ERROR;
567: END IF;
568:
569:
570: FOR v_src_rule IN c_copy_src_rules(v_lines.ato_line_id) LOOP

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

585: x_return_status => l_return_status,
586: x_msg_count => l_msg_count,
587: x_msg_data => l_msg_data);
588:
589: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
590: WriteToLog('ERROR: Create_sourcing_rules returned with exp error',1);
591: select oeh.order_number
592: into l_order_number
593: from oe_order_lines_all oel,

Line 608: p_encoded => FND_API.G_FALSE);

604:
605: FOR l_index IN 1..nvl(l_msg_count,1) LOOP
606: l_msg_data := fnd_msg_pub.get(
607: p_msg_index => l_index,
608: p_encoded => FND_API.G_FALSE);
609: WriteToLog('Error : '||substr(l_msg_data,1,250), 1);
610: END LOOP;
611: WriteToLog('++++++++++++++++++++++++++++++++++++++++++', 1);
612:

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

616: where ato_line_id = v_lines.ato_line_id;
617:
618: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
619: GOTO SKIP2;
620: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
621: WriteToLog('ERROR: Create_sourcing_rules returned with unexp error',1);
622: raise FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:

Line 622: raise FND_API.G_EXC_UNEXPECTED_ERROR;

618: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
619: GOTO SKIP2;
620: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
621: WriteToLog('ERROR: Create_sourcing_rules returned with unexp error',1);
622: raise FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: ELSIF (v_src_rule.config_creation = 3 ) THEN
626: --

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

638: x_return_status => l_return_status,
639: x_msg_count => l_msg_count,
640: x_msg_data => l_msg_data);
641:
642: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
643: WriteToLog('ERROR: Create_type3_sourcing_rules returned with exp error',1);
644: select oeh.order_number
645: into l_order_number
646: from oe_order_lines_all oel,

Line 661: p_encoded => FND_API.G_FALSE);

657:
658: FOR l_index IN 1..nvl(l_msg_count,1) LOOP
659: l_msg_data := fnd_msg_pub.get(
660: p_msg_index => l_index,
661: p_encoded => FND_API.G_FALSE);
662: WriteToLog('Error : '||substr(l_msg_data,1,250), 1);
663: END LOOP;
664: WriteToLog('++++++++++++++++++++++++++++++++++++++++++', 1);
665:

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

669: where ato_line_id = v_lines.ato_line_id;
670:
671: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
672: GOTO SKIP2;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
674: WriteToLog('ERROR: Create_type3_sourcing_rules returned with unexp error',1);
675: raise FND_API.G_EXC_UNEXPECTED_ERROR;
676: END IF;
677: END IF;

Line 675: raise FND_API.G_EXC_UNEXPECTED_ERROR;

671: WriteToLog('Rows updated to status ERROR::'||sql%rowcount, 1);
672: GOTO SKIP2;
673: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
674: WriteToLog('ERROR: Create_type3_sourcing_rules returned with unexp error',1);
675: raise FND_API.G_EXC_UNEXPECTED_ERROR;
676: END IF;
677: END IF;
678: END LOOP; /* c_copy_src_rules */
679: <>

Line 702: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

698: cto_msg_pub.count_and_get
699: ( p_msg_count => xMsgCount
700: , p_msg_data => xMsgData
701: );
702: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
703: --return(0);
704:
705: when FND_API.G_EXC_ERROR then
706: WriteToLog('ERROR: Expected error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

Line 705: when FND_API.G_EXC_ERROR then

701: );
702: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
703: --return(0);
704:
705: when FND_API.G_EXC_ERROR then
706: WriteToLog('ERROR: Expected error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
707: cto_msg_pub.count_and_get
708: ( p_msg_count => xMsgCount
709: , p_msg_data => xMsgData

Line 711: xReturnStatus := FND_API.G_RET_STS_ERROR;

707: cto_msg_pub.count_and_get
708: ( p_msg_count => xMsgCount
709: , p_msg_data => xMsgData
710: );
711: xReturnStatus := FND_API.G_RET_STS_ERROR;
712: --return(0);
713:
714: when FND_API.G_EXC_UNEXPECTED_ERROR then
715: WriteToLog('ERROR: Unxpected error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

Line 714: when FND_API.G_EXC_UNEXPECTED_ERROR then

710: );
711: xReturnStatus := FND_API.G_RET_STS_ERROR;
712: --return(0);
713:
714: when FND_API.G_EXC_UNEXPECTED_ERROR then
715: WriteToLog('ERROR: Unxpected error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);
716: cto_msg_pub.count_and_get
717: ( p_msg_count => xMsgCount
718: , p_msg_data => xMsgData

Line 720: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

716: cto_msg_pub.count_and_get
717: ( p_msg_count => xMsgCount
718: , p_msg_data => xMsgData
719: );
720: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
721: --return(0);
722:
723: when OTHERS then
724: WriteToLog('ERROR: Others error in Update_Items_and_Sourcing::lStmtNum::'||to_char(lStmtNum)||'::'||sqlerrm, 1);

Line 729: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

725: cto_msg_pub.count_and_get
726: ( p_msg_count => xMsgCount
727: , p_msg_data => xMsgData
728: );
729: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
730: --return(0);
731:
732: END Update_Items_And_Sourcing;
733:

Line 768: l_return_status := FND_API.G_RET_STS_SUCCESS;

764: -- 2. For each config, identify all order lines
765: -- 3. For each order line, delete sourcing from bcso for this config
766: -- and insert line referencing bcmo.
767: --
768: l_return_status := FND_API.G_RET_STS_SUCCESS;
769:
770: lStmtNum := 10;
771: WriteToLog('Entering update_bcso', 3);
772:

Line 894: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

890: cto_msg_pub.count_and_get
891: ( p_msg_count => l_msg_count
892: , p_msg_data => l_msg_data
893: );
894: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895:
896: END Update_Bcso;
897:
898:

Line 1011: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

1007: BEGIN
1008:
1009: WriteToLog('Entering Update_Item_Data', 3);
1010: lStmtNumber := 10;
1011: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
1012:
1013: insert into mtl_system_items_tl (
1014: inventory_item_id,
1015: organization_id,

Line 1551: raise FND_API.G_EXC_ERROR;

1547: IF PG_DEBUG <> 0 THEN
1548: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
1549: END IF;
1550: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1551: raise FND_API.G_EXC_ERROR;
1552: when others then
1553:
1554: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1555: end ;

Line 1554: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1550: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1551: raise FND_API.G_EXC_ERROR;
1552: when others then
1553:
1554: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1555: end ;
1556:
1557: when others then
1558: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1558: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1554: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1555: end ;
1556:
1557: when others then
1558: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1559: end ;
1560: /* end bugfix 4057651, default CTO cost type id = 7 if it does not exist */
1561:
1562:

Line 2010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2006:
2007: IF (l_layer_id = 0) THEN
2008: WriteToLog('Create_Item: ' || 'CST function create_layer returned with error '||to_char(x_err_num)||', '||x_msg_name||', '||
2009: lMsgData||'for '||to_char(v_layer.org_id)||', '||to_char(v_layer.cost_group_id),1);
2010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2011: ELSE
2012: 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);
2013: END IF;
2014:

Line 2856: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

2852: CTO_MSG_PUB.Count_And_Get(
2853: p_msg_count => lMsgCount,
2854: p_msg_data => lMsgData
2855: );
2856: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
2857:
2858: WHEN FND_API.G_EXC_ERROR THEN
2859: WriteToLog ('ERROR:Expected error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
2860: CTO_MSG_PUB.Count_And_Get(

Line 2858: WHEN FND_API.G_EXC_ERROR THEN

2854: p_msg_data => lMsgData
2855: );
2856: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
2857:
2858: WHEN FND_API.G_EXC_ERROR THEN
2859: WriteToLog ('ERROR:Expected error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
2860: CTO_MSG_PUB.Count_And_Get(
2861: p_msg_count => lMsgCount,
2862: p_msg_data => lMsgData

Line 2864: xReturnStatus := FND_API.G_RET_STS_ERROR;

2860: CTO_MSG_PUB.Count_And_Get(
2861: p_msg_count => lMsgCount,
2862: p_msg_data => lMsgData
2863: );
2864: xReturnStatus := FND_API.G_RET_STS_ERROR;
2865:
2866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2867: WriteToLog ('ERROR:Unexpected error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
2868: CTO_MSG_PUB.Count_And_Get(

Line 2866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2862: p_msg_data => lMsgData
2863: );
2864: xReturnStatus := FND_API.G_RET_STS_ERROR;
2865:
2866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2867: WriteToLog ('ERROR:Unexpected error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
2868: CTO_MSG_PUB.Count_And_Get(
2869: p_msg_count => lMsgCount,
2870: p_msg_data => lMsgData

Line 2872: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

2868: CTO_MSG_PUB.Count_And_Get(
2869: p_msg_count => lMsgCount,
2870: p_msg_data => lMsgData
2871: );
2872: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
2873:
2874: WHEN OTHERS THEN
2875: WriteToLog ('ERROR:Others error in update_item_data'||to_char(lStmtNumber)||sqlerrm,1);
2876: CTO_MSG_PUB.Count_And_Get(

Line 2880: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

2876: CTO_MSG_PUB.Count_And_Get(
2877: p_msg_count => lMsgCount,
2878: p_msg_data => lMsgData
2879: );
2880: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
2881:
2882: END Update_Item_Data;
2883:
2884:

Line 2935: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

2931:
2932: WriteToLog('Entering Update_Acc_Items', 3);
2933:
2934: lStmtNumber := 10;
2935: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
2936:
2937: lItemType := FND_PROFILE.Value('BOM:CONFIG_ITEM_TYPE');
2938:
2939: --perf bugfix 4905887 (sql id 16105473)

Line 3631: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

3627: CTO_MSG_PUB.Count_And_Get(
3628: p_msg_count => xMsgCount,
3629: p_msg_data => xMsgData
3630: );
3631: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
3632:
3633: END Update_Acc_Items;
3634:
3635:

Line 3671: xReturnStatus := FND_API.G_RET_STS_SUCCESS;

3667: BEGIN
3668:
3669: WriteToLog('Entering Update_Pc_Items', 3);
3670: lStmtNumber := 10;
3671: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
3672:
3673: lItemType := FND_PROFILE.Value('BOM:CONFIG_ITEM_TYPE');
3674:
3675: select substr(attribute_name, instr(attribute_name, '.' )+ 1), control_level

Line 4373: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;

4369: CTO_MSG_PUB.Count_And_Get(
4370: p_msg_count => xMsgCount,
4371: p_msg_data => xMsgData
4372: );
4373: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
4374:
4375: END Update_Pc_Items;
4376:
4377: