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_WORKFLOW_API_PK dependencies on CTO_WIP_WORKFLOW_API_PK

Line 510: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'Entering Display_wf_status');

506: BEGIN
507:
508: IF PG_DEBUG <> 0 THEN
509: oe_debug_pub.add('display_wf_status: ' || 'Entering display_wf_status', 1);
510: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'Entering Display_wf_status');
511: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'P_order_line_id ='||to_char(p_order_line_id));
512: End if;
513:
514: v_ordered_quantity := 0;

Line 511: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'P_order_line_id ='||to_char(p_order_line_id));

507:
508: IF PG_DEBUG <> 0 THEN
509: oe_debug_pub.add('display_wf_status: ' || 'Entering display_wf_status', 1);
510: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'Entering Display_wf_status');
511: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'P_order_line_id ='||to_char(p_order_line_id));
512: End if;
513:
514: v_ordered_quantity := 0;
515:

Line 555: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_header_id = '||to_char(v_header_id));

551: and oel.inventory_item_id = msi.inventory_item_id
552: and oel.ship_from_org_id = msi.organization_id;
553:
554: If PG_DEBUG <> 0 Then
555: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_header_id = '||to_char(v_header_id));
556: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'l_oe_org_id = '||to_char(l_oe_org_id));
557: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_ordered_quantity = '||to_char(v_ordered_quantity));
558: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_source_type_code = '||v_source_type_code);
559: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'ato line id = '||l_ato_line_id);

Line 556: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'l_oe_org_id = '||to_char(l_oe_org_id));

552: and oel.ship_from_org_id = msi.organization_id;
553:
554: If PG_DEBUG <> 0 Then
555: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_header_id = '||to_char(v_header_id));
556: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'l_oe_org_id = '||to_char(l_oe_org_id));
557: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_ordered_quantity = '||to_char(v_ordered_quantity));
558: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_source_type_code = '||v_source_type_code);
559: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'ato line id = '||l_ato_line_id);
560: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'top model line id = '||l_top_model_line_id);

Line 557: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_ordered_quantity = '||to_char(v_ordered_quantity));

553:
554: If PG_DEBUG <> 0 Then
555: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_header_id = '||to_char(v_header_id));
556: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'l_oe_org_id = '||to_char(l_oe_org_id));
557: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_ordered_quantity = '||to_char(v_ordered_quantity));
558: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_source_type_code = '||v_source_type_code);
559: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'ato line id = '||l_ato_line_id);
560: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'top model line id = '||l_top_model_line_id);
561: oe_debug_pub.add('display_wf_status: ' || 'v_header_id = '||to_char(v_header_id) , 5);

Line 558: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_source_type_code = '||v_source_type_code);

554: If PG_DEBUG <> 0 Then
555: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_header_id = '||to_char(v_header_id));
556: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'l_oe_org_id = '||to_char(l_oe_org_id));
557: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_ordered_quantity = '||to_char(v_ordered_quantity));
558: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_source_type_code = '||v_source_type_code);
559: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'ato line id = '||l_ato_line_id);
560: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'top model line id = '||l_top_model_line_id);
561: oe_debug_pub.add('display_wf_status: ' || 'v_header_id = '||to_char(v_header_id) , 5);
562: oe_debug_pub.add('display_wf_status: ' || 'l_oe_org_id = '||to_char(l_oe_org_id) , 5);

Line 559: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'ato line id = '||l_ato_line_id);

555: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_header_id = '||to_char(v_header_id));
556: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'l_oe_org_id = '||to_char(l_oe_org_id));
557: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_ordered_quantity = '||to_char(v_ordered_quantity));
558: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_source_type_code = '||v_source_type_code);
559: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'ato line id = '||l_ato_line_id);
560: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'top model line id = '||l_top_model_line_id);
561: oe_debug_pub.add('display_wf_status: ' || 'v_header_id = '||to_char(v_header_id) , 5);
562: oe_debug_pub.add('display_wf_status: ' || 'l_oe_org_id = '||to_char(l_oe_org_id) , 5);
563: oe_debug_pub.add('display_wf_status: ' || 'v_ordered_quantity = '||to_char(v_ordered_quantity) , 5);

Line 560: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'top model line id = '||l_top_model_line_id);

556: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'l_oe_org_id = '||to_char(l_oe_org_id));
557: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_ordered_quantity = '||to_char(v_ordered_quantity));
558: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'v_source_type_code = '||v_source_type_code);
559: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'ato line id = '||l_ato_line_id);
560: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'top model line id = '||l_top_model_line_id);
561: oe_debug_pub.add('display_wf_status: ' || 'v_header_id = '||to_char(v_header_id) , 5);
562: oe_debug_pub.add('display_wf_status: ' || 'l_oe_org_id = '||to_char(l_oe_org_id) , 5);
563: oe_debug_pub.add('display_wf_status: ' || 'v_ordered_quantity = '||to_char(v_ordered_quantity) , 5);
564: oe_debug_pub.add('display_wf_status: ' || 'v_source_type_code = '||v_source_type_code , 5);

Line 573: cto_wip_workflow_api_pk.cto_debug('Display_wf_status',' Line is not yet booked. No need to change status');

569: l_stmt_num := 11;
570:
571: If l_booked_flag = 'N' Then
572: IF PG_DEBUG <> 0 Then
573: cto_wip_workflow_api_pk.cto_debug('Display_wf_status',' Line is not yet booked. No need to change status');
574: oe_debug_pub.add('Display_wf_status: Line is not yet booked. No need to change status',1);
575: End if;
576: elsif nvl(v_shipped_quantity,0) <> 0 then
577:

Line 579: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',

575: End if;
576: elsif nvl(v_shipped_quantity,0) <> 0 then
577:
578: If PG_DEBUG <> 0 Then
579: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
580: 'Line is shipped no need to change the status..');
581: End if;
582:
583: Elsif v_source_type_code = 'EXTERNAL' THEN

Line 589: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'Drop ship line, will be updating line status');

585:
586:
587:
588: If PG_DEBUG <> 0 Then
589: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'Drop ship line, will be updating line status');
590: End if;
591:
592: --bugfix 5461892
593:

Line 660: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'change_status_batch raised expected error.');

656:
657: if x_return_status = FND_API.G_RET_STS_ERROR then
658: IF PG_DEBUG <> 0 THEN
659: oe_debug_pub.add('display_wf_status: ' || 'change_status_batch raised expected error.', 1);
660: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'change_status_batch raised expected error.');
661: End if;
662: raise FND_API.G_EXC_ERROR;
663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
664: IF PG_DEBUG <> 0 THEN

Line 666: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'change_status_batch raised unexpected error.');

662: raise FND_API.G_EXC_ERROR;
663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
664: IF PG_DEBUG <> 0 THEN
665: oe_debug_pub.add('display_wf_status: ' || 'change_status_batch raised unexpected error.', 1);
666: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'change_status_batch raised unexpected error.');
667: End if;
668: raise FND_API.G_EXC_UNEXPECTED_ERROR;
669: end if; /* x_return_status = FND_API.G_RET_STS_ERROR */
670:

Line 679: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'Exiting display_wf_Status with return value 1');

675: End if; /* l_change_status <> '_' */
676:
677: IF PG_DEBUG <> 0 THEN
678: oe_debug_pub.add('display_wf_status: ' || 'Exiting disp_wf_status', 4);
679: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'Exiting display_wf_Status with return value 1');
680: End if;
681: return 1;
682:
683: EXCEPTION

Line 687: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',

683: EXCEPTION
684: when FND_API.G_EXC_ERROR then
685: IF PG_DEBUG <> 0 THEN
686: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status raised exp error::stmt number '||to_char(l_stmt_num), 1);
687: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
688: 'CTO_WORKFLOW_API_PK.display_wf_status raised exp error::stmt number '|| to_char(l_stmt_num));
689: End if;
690: return 0;--bugfix 4545070
691:

Line 696: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',

692: when FND_API.G_EXC_UNEXPECTED_ERROR then
693: IF PG_DEBUG <> 0 THEN
694: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status raised unexp error::stmt number '||
695: to_char(l_stmt_num)||sqlerrm, 1);
696: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
697: 'CTO_WORKFLOW_API_PK.display_wf_status raised unexp error::stmt number '|| to_char(l_stmt_num));
698: End if;
699: return 0;
700: when others then

Line 704: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',

700: when others then
701: IF PG_DEBUG <> 0 THEN
702: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status::stmt number '||to_char(l_stmt_num), 1);
703: oe_debug_pub.add('display_wf_status: ' || sqlerrm, 1);
704: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
705: 'CTO_WORKFLOW_API_PK.display_wf_status::stmt number '||
706: to_char(l_stmt_num));
707: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', sqlerrm);
708: End if;

Line 707: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', sqlerrm);

703: oe_debug_pub.add('display_wf_status: ' || sqlerrm, 1);
704: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
705: 'CTO_WORKFLOW_API_PK.display_wf_status::stmt number '||
706: to_char(l_stmt_num));
707: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', sqlerrm);
708: End if;
709: return 0;
710:
711: END display_wf_status;

Line 755: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'In inventory_reservation_check');

751:
752: BEGIN
753: IF PG_DEBUG <> 0 THEN
754: oe_debug_pub.add('inventory_reservation_check: ' || 'Entering inventory_reservation_check', 2);
755: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'In inventory_reservation_check');
756: End if;
757:
758: x_return_status := FND_API.G_RET_STS_SUCCESS;
759:

Line 779: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'ATO Line Id = '||v_ato_line_id);

775:
776: -- removing code to allow reservation for ATOitem
777: -- by kkonada :adding below code again for dummy assignment*/
778: If PG_DEBUG <> 0 then
779: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'ATO Line Id = '||v_ato_line_id);
780: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Item Type Code = '||v_item_type_code);
781: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Source Type
782: Code = '||v_source_type_code);
783: End if;

Line 780: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Item Type Code = '||v_item_type_code);

776: -- removing code to allow reservation for ATOitem
777: -- by kkonada :adding below code again for dummy assignment*/
778: If PG_DEBUG <> 0 then
779: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'ATO Line Id = '||v_ato_line_id);
780: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Item Type Code = '||v_item_type_code);
781: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Source Type
782: Code = '||v_source_type_code);
783: End if;
784: /*

Line 781: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Source Type

777: -- by kkonada :adding below code again for dummy assignment*/
778: If PG_DEBUG <> 0 then
779: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'ATO Line Id = '||v_ato_line_id);
780: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Item Type Code = '||v_item_type_code);
781: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Source Type
782: Code = '||v_source_type_code);
783: End if;
784: /*
785: ** BUG#2234858, BUG#2312701 AND BUG#2358576 Drop Ship changes to disallow reservation

Line 830: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check',

826: --End of bug fix 4888964
827: exception
828: when others then
829: If PG_DEBUG <> 0 Then
830: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check',
831: 'no data found in po_headers_all for om header ' ||
832: to_char( v_header_id ) || ' line id ' ||
833: to_char( p_order_line_id ) || ' po header id ' ||
834: to_char( v_po_header_id ) ) ;

Line 888: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'v_activity_status_code <> NOTIFIED');

884: v_activity_status_code);
885:
886: if upper(v_activity_status_code) <> 'NOTIFIED' then
887: If PG_DEBUG <> 0 then
888: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'v_activity_status_code <> NOTIFIED');
889: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
890: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
891: End if;
892: raise FND_API.G_EXC_ERROR;

Line 889: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');

885:
886: if upper(v_activity_status_code) <> 'NOTIFIED' then
887: If PG_DEBUG <> 0 then
888: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'v_activity_status_code <> NOTIFIED');
889: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
890: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
891: End if;
892: raise FND_API.G_EXC_ERROR;
893: end if;

Line 899: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Exiting inventory_reservation_check');

895: end if;
896:
897: end if;
898: If PG_DEBUG <> 0 then
899: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Exiting inventory_reservation_check');
900: oe_debug_pub.add('inventory_reservation_check: ' || 'Exiting inventory_reservation_check', 2);
901: END IF;
902:
903: EXCEPTION

Line 907: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no :'|| to_char(l_stmt_num));

903: EXCEPTION
904: when FND_API.G_EXC_ERROR then
905: IF PG_DEBUG <> 0 THEN
906: oe_debug_pub.add('inventory_reservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);
907: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no :'|| to_char(l_stmt_num));
908: End if;
909:
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: cto_msg_pub.count_and_get(

Line 918: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'|| to_char(l_stmt_num));

914: );
915: when FND_API.G_EXC_UNEXPECTED_ERROR then
916: IF PG_DEBUG <> 0 THEN
917: oe_debug_pub.add('inventory_reservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);
918: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'|| to_char(l_stmt_num));
919: End if;
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: cto_msg_pub.count_and_get(
922: p_msg_count => x_msg_count,

Line 931: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'||to_char(l_stmt_num) );

927: IF PG_DEBUG <> 0 THEN
928: oe_debug_pub.add('inventory_reservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);
929:
930: oe_debug_pub.add('inventory_reservation_check: ' || sqlerrm);
931: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'||to_char(l_stmt_num) );
932: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check', sqlerrm);
933: End if;
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 932: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check', sqlerrm);

928: oe_debug_pub.add('inventory_reservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_reservation_check::stmt number '||to_char(l_stmt_num), 1);
929:
930: oe_debug_pub.add('inventory_reservation_check: ' || sqlerrm);
931: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'||to_char(l_stmt_num) );
932: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check', sqlerrm);
933: End if;
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
936: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 987: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Entering wf_update_after_inv_reserv');

983:
984:
985: BEGIN
986: If PG_DEBUG <> 0 Then
987: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Entering wf_update_after_inv_reserv');
988: End if;
989:
990: IF PG_DEBUG <> 0 THEN
991: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Entering wf_update_after_inv_reserv', 2);

Line 997: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'Before selecting info from oe_order_lines_all');

993: x_return_status := FND_API.G_RET_STS_SUCCESS;
994: l_stmt_num := 10;
995:
996: If PG_DEBUG <> 0 Then
997: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'Before selecting info from oe_order_lines_all');
998: End if;
999:
1000:
1001: select item_type_code,

Line 1008: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'ato_line_id = '||v_ato_line_id);

1004: v_ato_line_id
1005: from oe_order_lines_all
1006: where line_id = p_order_line_id;
1007: If PG_DEBUG <> 0 Then
1008: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'ato_line_id = '||v_ato_line_id);
1009: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'v_item_type_code = '||v_item_type_code);
1010: End if;
1011:
1012:

Line 1009: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'v_item_type_code = '||v_item_type_code);

1005: from oe_order_lines_all
1006: where line_id = p_order_line_id;
1007: If PG_DEBUG <> 0 Then
1008: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'ato_line_id = '||v_ato_line_id);
1009: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'v_item_type_code = '||v_item_type_code);
1010: End if;
1011:
1012:
1013: IF ((upper(v_item_type_code) = 'STANDARD') -- Ato item line

Line 1027: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Before querying wf_activity_status..');

1023: IF PG_DEBUG <> 0 THEN
1024: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'item_type_code is STANDARD OR OPTION => an ato item', 4);
1025: END IF;--fix for bug#1874380
1026: If PG_DEBUG <> 0 Then
1027: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Before querying wf_activity_status..');
1028: End if;
1029:
1030: -- Check if workflow is in Create supply order eligible activity
1031:

Line 1039: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','v_activity_status_code = '||

1035: 'CREATE_SUPPLY_ORDER_ELIGIBLE',
1036: v_activity_status_code);
1037:
1038: If PG_DEBUG <> 0 then
1039: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','v_activity_status_code = '||
1040: upper(v_activity_status_code));
1041: End if;
1042: -- If notified move the workflow to Ship line
1043:

Line 1048: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Complete the workflow

1044:
1045: if upper(v_activity_status_code) = 'NOTIFIED' then
1046: l_stmt_num := 30;
1047: If PG_DEBUG <> 0 Then
1048: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Complete the workflow
1049: stmt no : 30');
1050: End if;
1051: -- Modified for MOAC project
1052: -- Called complete_acitivity procedure instead of calling wf_engine api.

Line 1075: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Before calling display_wf_status..'||

1071: -- End of MOAC Change
1072:
1073: --start of fix for bug#1895563
1074: If PG_DEBUG <> 0 Then
1075: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Before calling display_wf_status..'||
1076: 'from l_stmt_num=>'||l_stmt_num);
1077: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Before calling display_wf_status.. from l_stmt_num=>'||l_stmt_num,2);
1078: END IF;
1079:

Line 1083: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Return value after display_wf_status'

1079:
1080: return_value := display_wf_status(p_order_line_id);
1081:
1082: If PG_DEBUG <> 0 Then
1083: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Return value after display_wf_status'
1084: ||to_char(return_value));
1085: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Return value after display_wf_status at l_stmt_num=>'||l_stmt_num||'is'
1086: ||to_char(return_value),1);
1087: END IF;

Line 1099: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Stmt no : 40, query

1095: else -- not in supply order eligible
1096:
1097: l_stmt_num := 40;
1098: If PG_DEBUG <> 0 then
1099: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Stmt no : 40, query
1100: wf_activity status..');
1101: End if;
1102:
1103: query_wf_activity_status(G_ITEM_TYPE_NAME,

Line 1110: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','v_activity_status_code = '||

1106: 'EXECUTECONCPROGAFAS',
1107: v_activity_status_code);
1108:
1109: If PG_DEBUG <> 0 then
1110: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','v_activity_status_code = '||
1111: v_activity_status_code);
1112:
1113: End if;
1114: IF upper(v_activity_status_code) <> 'NOTIFIED' THEN

Line 1119: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Stmt no : 50

1115:
1116: l_stmt_num := 50;
1117:
1118: If PG_DEBUG <> 0 Then
1119: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Stmt no : 50
1120: querying wf_activity_status');
1121: End if;
1122: query_wf_activity_status(G_ITEM_TYPE_NAME,
1123: TO_CHAR(p_order_line_id),

Line 1129: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'v_actitivity_status_code ='||

1125: 'SHIP_LINE',
1126: v_activity_status_code);
1127:
1128: If PG_DEBUG <> 0 Then
1129: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'v_actitivity_status_code ='||
1130: v_activity_status_code);
1131: End if;
1132: IF upper(v_activity_status_code) = 'NOTIFIED' then
1133:

Line 1136: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',

1132: IF upper(v_activity_status_code) = 'NOTIFIED' then
1133:
1134:
1135: If PG_DEBUG <> 0 Then
1136: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1137: 'Before calling display_wf_status..'||
1138: 'from l_stmt_num=>'||l_stmt_num);
1139: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Before calling display_wf_status.. from l_stmt_num=>'||l_stmt_num,2);
1140: END IF;

Line 1146: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',

1142: return_value := display_wf_status(p_order_line_id);
1143:
1144:
1145: If PG_DEBUG <> 0 Then
1146: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1147: 'Return value after display_wf_status'
1148: ||to_char(return_value));
1149: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Return value after display_wf_status at l_stmt_num=>'||l_stmt_num||'is'
1150: ||to_char(return_value),1);

Line 1157: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Before calling display_wf_status..'||

1153:
1154: ELSE -- Auto create fas Notified
1155:
1156: If PG_DEBUG <> 0 Then
1157: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Before calling display_wf_status..'||
1158: 'from l_stmt_num=>'||l_stmt_num);
1159: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Before calling display_wf_status.. from l_stmt_num=>'||l_stmt_num,2);
1160: END IF;
1161:

Line 1166: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Return value after display_wf_status'

1162: return_value := display_wf_status(p_order_line_id);
1163:
1164:
1165: If PG_DEBUG <> 0 Then
1166: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Return value after display_wf_status'
1167: ||to_char(return_value));
1168: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Return value after display_wf_status at l_stmt_num=>'||l_stmt_num||'is'
1169: ||to_char(return_value),1);
1170: END IF;

Line 1177: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');

1173:
1174: end if;
1175: if return_value <> 1 then
1176: If PG_DEBUG <> 0 Then
1177: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');
1178: End if;
1179: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
1180: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1181: end if;

Line 1194: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',

1190:
1191: l_stmt_num := 60;
1192:
1193: If PG_DEBUG <> 0 Then
1194: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1195: ' Stmt no : 60 , querying activity_status');
1196: End if;
1197:
1198: query_wf_activity_status(G_ITEM_TYPE_NAME,

Line 1205: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' v_actitivity_status_code = '||

1201: 'CREATE_SUPPLY_ORDER_ELIGIBLE',
1202: v_activity_status_code);
1203:
1204: If PG_DEBUG <> 0 Then
1205: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' v_actitivity_status_code = '||
1206: v_activity_status_code);
1207: End if;
1208:
1209: IF upper(v_activity_status_code) = 'NOTIFIED' then

Line 1214: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Stmt no : 70, Completing

1210:
1211: l_stmt_num := 70;
1212:
1213: If PG_DEBUG <> 0 Then
1214: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Stmt no : 70, Completing
1215: workflow activity..');
1216: End if;
1217:
1218: -- Modified for MOAC project

Line 1243: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Stmt no : 80 querying

1239: ELSE
1240:
1241: l_stmt_num := 80;
1242: if pG_DEBUG <> 0 Then
1243: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Stmt no : 80 querying
1244: wf_activity_status');
1245: end if;
1246: query_wf_activity_status(G_ITEM_TYPE_NAME,
1247: TO_CHAR(p_order_line_id),

Line 1253: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','v_activity_status_code = '||

1249: 'EXECUTECONCPROGAFAS',
1250: v_activity_status_code);
1251:
1252: If PG_DEBUG <> 0 Then
1253: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','v_activity_status_code = '||
1254: v_activity_status_code);
1255: End if;
1256:
1257: IF upper(v_activity_status_code) <> 'NOTIFIED' then

Line 1262: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Stmt no : 90,

1258:
1259: l_stmt_num := 90;
1260:
1261: If PG_DEBUG <> 0 Then
1262: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Stmt no : 90,
1263: querying wf_activity_status');
1264: End if;
1265: query_wf_activity_status(G_ITEM_TYPE_NAME,
1266: TO_CHAR(p_order_line_id),

Line 1272: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', ' v_activity_status_code = '||

1268: 'SHIP_LINE',
1269: v_activity_status_code);
1270:
1271: If PG_DEBUG <> 0 Then
1272: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', ' v_activity_status_code = '||
1273: v_activity_status_code);
1274: End if;
1275:
1276: if upper(v_activity_status_code) <> 'NOTIFIED' then

Line 1279: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'v_activity_status_code <> NOTIFIED');

1275:
1276: if upper(v_activity_status_code) <> 'NOTIFIED' then
1277:
1278: If PG_DEBUG <> 0 Then
1279: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'v_activity_status_code <> NOTIFIED');
1280: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1281: End if;
1282:
1283: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');

Line 1280: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'Raising CTO_INVALID_ACTIVITY_STATUS');

1276: if upper(v_activity_status_code) <> 'NOTIFIED' then
1277:
1278: If PG_DEBUG <> 0 Then
1279: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'v_activity_status_code <> NOTIFIED');
1280: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1281: End if;
1282:
1283: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1284: raise FND_API.G_EXC_ERROR;

Line 1296: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Before calling display_wf_status');

1292:
1293: -- display proper status to OM form
1294:
1295: If PG_DEBUG <> 0 Then
1296: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Before calling display_wf_status');
1297: End if;
1298:
1299: return_value := display_wf_status(p_order_line_id);
1300:

Line 1302: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Return_value from display_wf_status = '||

1298:
1299: return_value := display_wf_status(p_order_line_id);
1300:
1301: If PG_DEBUG <> 0 Then
1302: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Return_value from display_wf_status = '||
1303: to_char(return_value));
1304: End if;
1305:
1306: IF return_value <> 1 then

Line 1308: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');

1304: End if;
1305:
1306: IF return_value <> 1 then
1307: IF PG_DEBUG <> 0 Then
1308: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');
1309: End if;
1310: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
1311: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1312: END IF;

Line 1316: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Exiting wf_update_after_inv_reserv');

1312: END IF;
1313:
1314: end if; /* end of item_type_code check */
1315: If PG_DEBUG <> 0 then
1316: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Exiting wf_update_after_inv_reserv');
1317: End if;
1318: IF PG_DEBUG <> 0 THEN
1319: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Exiting wf_update_after_inv_reserv', 2);
1320: END IF;

Line 1329: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',

1325: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'exp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);
1326: END IF;
1327:
1328: If PG_DEBUG <> 0 Then
1329: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1330: 'Exp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1331: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1332: End if;
1333:

Line 1343: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',

1339:
1340: when FND_API.G_EXC_UNEXPECTED_ERROR then
1341: IF PG_DEBUG <> 0 THEN
1342: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_reserv::stmt number '||to_char(l_stmt_num), 1);
1343: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1344: 'UNExp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1345: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1346: End if;
1347:

Line 1361: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'OTHERS excpn: stmt no : '||to_char(l_stmt_num));

1357:
1358: oe_debug_pub.add('wf_update_after_inv_reserv: ' || sqlerrm, 1);
1359: END IF;
1360: If PG_DEBUG <> 0 Then
1361: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'OTHERS excpn: stmt no : '||to_char(l_stmt_num));
1362: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', sqlerrm);
1363: End if;
1364:
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1362: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', sqlerrm);

1358: oe_debug_pub.add('wf_update_after_inv_reserv: ' || sqlerrm, 1);
1359: END IF;
1360: If PG_DEBUG <> 0 Then
1361: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'OTHERS excpn: stmt no : '||to_char(l_stmt_num));
1362: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', sqlerrm);
1363: End if;
1364:
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1366: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1408: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check','Entering inventory_unreservation_check');

1404:
1405: BEGIN
1406: IF PG_DEBUG <> 0 THEN
1407: oe_debug_pub.add('inventory_unreservation_check: ' || 'Entering inventory_unreservation_check', 2);
1408: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check','Entering inventory_unreservation_check');
1409: End if;
1410:
1411: x_return_status := FND_API.G_RET_STS_SUCCESS;
1412: l_stmt_num := 10;

Line 1432: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');

1428: 'SHIP_LINE',
1429: 'SHIP_LINE', v_activity_status_code);
1430: if upper(v_activity_status_code) <> 'NOTIFIED' then
1431: If PG_DEBUG <> 0 Then
1432: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1433: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1434: End if;
1435: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1436: raise FND_API.G_EXC_ERROR;

Line 1433: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');

1429: 'SHIP_LINE', v_activity_status_code);
1430: if upper(v_activity_status_code) <> 'NOTIFIED' then
1431: If PG_DEBUG <> 0 Then
1432: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1433: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1434: End if;
1435: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1436: raise FND_API.G_EXC_ERROR;
1437: end if;

Line 1453: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'p_rsv_quantity'||p_rsv_quantity);

1449: then
1450:
1451: --begin bugfix 2001824 : check if qty being unreserved is ok
1452: If PG_DEBUG <> 0 Then
1453: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'p_rsv_quantity'||p_rsv_quantity);
1454: End if;
1455: if (CTO_UTILITY_PK.check_rsv_quantity (p_order_line_id => p_order_line_id,
1456: p_rsv_quantity => p_rsv_quantity) = FALSE )
1457: then

Line 1464: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');

1460: ' is NOT allowed since part of this has been either ship confirmed, intrasit or closed.', 2);
1461: END IF;
1462:
1463: If PG_DEBUG <> 0 Then
1464: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1465: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1466: End if;
1467: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1468: raise FND_API.G_EXC_ERROR;

Line 1465: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');

1461: END IF;
1462:
1463: If PG_DEBUG <> 0 Then
1464: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1465: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1466: End if;
1467: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1468: raise FND_API.G_EXC_ERROR;
1469: else

Line 1480: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Exiting inventory_unreservation_check');

1476: end if;
1477:
1478: IF PG_DEBUG <> 0 THEN
1479: oe_debug_pub.add('inventory_unreservation_check: ' || 'Exiting inventory_unreservation_check', 2);
1480: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Exiting inventory_unreservation_check');
1481: End if;
1482:
1483: EXCEPTION
1484:

Line 1488: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',

1484:
1485: when FND_API.G_EXC_ERROR then
1486: IF PG_DEBUG <> 0 THEN
1487: oe_debug_pub.add('inventory_unreservation_check: ' || 'exp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1488: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1489: 'Raised FND_API.G_EXC_ERROR, stmt'||l_stmt_num);
1490: End if;
1491: x_return_status := FND_API.G_RET_STS_ERROR;
1492: cto_msg_pub.count_and_get(

Line 1500: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',

1496:
1497: when FND_API.G_EXC_UNEXPECTED_ERROR then
1498: IF PG_DEBUG <> 0 THEN
1499: oe_debug_pub.add('inventory_unreservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1500: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1501: 'Raised FND_API.G_EXC_UNEXPECTED_ERROR, stmt'||l_stmt_num);
1502: End if;
1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1504: cto_msg_pub.count_and_get(

Line 1514: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',

1510: IF PG_DEBUG <> 0 THEN
1511: oe_debug_pub.add('inventory_unreservation_check: ' || 'unexp error in CTO_WORKFLOW_API_PK.inventory_unreservation_check::stmt number '||to_char(l_stmt_num), 1);
1512:
1513: oe_debug_pub.add('inventory_unreservation_check: ' || sqlerrm, 1);
1514: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1515: 'Raised OTHERS excepn, stmt: '||l_stmt_num);
1516: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', sqlerrm);
1517: End if;
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1516: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', sqlerrm);

1512:
1513: oe_debug_pub.add('inventory_unreservation_check: ' || sqlerrm, 1);
1514: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1515: 'Raised OTHERS excepn, stmt: '||l_stmt_num);
1516: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', sqlerrm);
1517: End if;
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1520: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1634: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'In wf_update_after_inv_unreserv');

1630: v_open_flag varchar2(1); -- Bugfix 7214005
1631:
1632: BEGIN
1633: If PG_DEBUG <> 0 Then
1634: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'In wf_update_after_inv_unreserv');
1635: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'Entering wf_update_after_inv_unreserv', 2);
1636: END IF;
1637:
1638: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1665: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'ATO Line Id = '||v_ato_line_id);

1661: from oe_order_lines_all
1662: where line_id = p_order_line_id;
1663:
1664: If PG_DEBUG <> 0 Then
1665: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'ATO Line Id = '||v_ato_line_id);
1666: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Item Type Code = '||v_item_type_code);
1667: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Open Flag = '||v_open_flag);
1668: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'ATO Line Id ='||v_ato_line_id, 1);
1669: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'Item Type Code ='||v_item_type_code, 1);

Line 1666: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Item Type Code = '||v_item_type_code);

1662: where line_id = p_order_line_id;
1663:
1664: If PG_DEBUG <> 0 Then
1665: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'ATO Line Id = '||v_ato_line_id);
1666: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Item Type Code = '||v_item_type_code);
1667: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Open Flag = '||v_open_flag);
1668: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'ATO Line Id ='||v_ato_line_id, 1);
1669: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'Item Type Code ='||v_item_type_code, 1);
1670: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'Open Flag ='||v_open_flag, 1);

Line 1667: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Open Flag = '||v_open_flag);

1663:
1664: If PG_DEBUG <> 0 Then
1665: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'ATO Line Id = '||v_ato_line_id);
1666: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Item Type Code = '||v_item_type_code);
1667: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Open Flag = '||v_open_flag);
1668: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'ATO Line Id ='||v_ato_line_id, 1);
1669: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'Item Type Code ='||v_item_type_code, 1);
1670: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'Open Flag ='||v_open_flag, 1);
1671: End if;

Line 1756: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'v_counter = '||v_counter);

1752: and demand_source_line_id = p_order_line_id
1753: and primary_reservation_quantity > 0;
1754:
1755: If PG_DEBUG <> 0 Then
1756: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'v_counter = '||v_counter);
1757: End if;
1758:
1759: v_counter2 := 0;
1760: l_stmt_num := 40;

Line 1789: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'v_counter2 = '||v_counter2);

1785: end if;
1786: -- end bugfix 3174334
1787:
1788: If PG_DEBUG <> 0 Then
1789: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'v_counter2 = '||v_counter2);
1790: End if;
1791: ---Modified by Renga Kannan on 12/18/2000
1792:
1793: -- Modified by Renga Kannan on 14-NOV-2001

Line 1836: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'l_po_req_qty = '||l_po_req_qty);

1832: and item_id = l_inventory_item_id
1833: AND process_flag is null;
1834:
1835: If PG_DEBUG <> 0 Then
1836: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'l_po_req_qty = '||l_po_req_qty);
1837: End if;
1838:
1839: -- no reservation at all
1840:

Line 1883: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',

1879: x_msg_data => v_x_msg_data);
1880:
1881: IF (v_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1882: IF PG_DEBUG <> 0 THEN
1883: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',
1884: 'Failed in WSH_Integration_Pub.Get Tolerance');
1885: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'CTO:Failed in WSH_Integration_Pub.Get Tolerance :' || v_x_return_status, 1);
1886: END IF;
1887: OE_MSG_PUB.ADD;

Line 1913: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'v_x_min_remaining_quantity = '|| l_out_attributes.min_remaining_quantity);

1909: -- With post-CMS (change mgmt from OM), unreservation will be triggered from shipping rather than OM.
1910: -- OM.
1911:
1912: IF PG_DEBUG <> 0 THEN
1913: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'v_x_min_remaining_quantity = '|| l_out_attributes.min_remaining_quantity);
1914: cto_wip_workflow_api_pk.cto_debug('Wf_update_after_inv_unreserve',' Shipping interfaced flag = '||l_ship_xfaced_flag);
1915: oe_debug_pub.add('Wf_update_after_inv_unreserve: Shipping interfaced flag = '||l_ship_xfaced_flag);
1916: end if;
1917:

Line 1914: cto_wip_workflow_api_pk.cto_debug('Wf_update_after_inv_unreserve',' Shipping interfaced flag = '||l_ship_xfaced_flag);

1910: -- OM.
1911:
1912: IF PG_DEBUG <> 0 THEN
1913: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'v_x_min_remaining_quantity = '|| l_out_attributes.min_remaining_quantity);
1914: cto_wip_workflow_api_pk.cto_debug('Wf_update_after_inv_unreserve',' Shipping interfaced flag = '||l_ship_xfaced_flag);
1915: oe_debug_pub.add('Wf_update_after_inv_unreserve: Shipping interfaced flag = '||l_ship_xfaced_flag);
1916: end if;
1917:
1918: -- bugfix 2118864

Line 1930: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'No Reservations exists... Updating workflow.');

1926: (l_ship_xfaced_flag = 'N' or nvl(l_out_attributes.min_remaining_quantity,0) > 0 )
1927: then
1928:
1929: IF PG_DEBUG <> 0 Then
1930: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'No Reservations exists... Updating workflow.');
1931: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'No Reservation Exists...',1);
1932: END IF;
1933:
1934: l_stmt_num := 50;

Line 1956: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',

1952: l_changed_attributes(1).action_flag := 'U';
1953:
1954: IF PG_DEBUG <> 0 THEN
1955: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'Renga: Updating the shipping attributes..',1);
1956: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',
1957: 'Renga : CAlling Shipping update attribute api');
1958: End if;
1959: WSH_INTERFACE.Update_Shipping_Attributes
1960: ( p_source_code => 'OE'

Line 1969: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',

1965:
1966: IF (v_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1967:
1968: IF PG_DEBUG <> 0 THEN
1969: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',
1970: 'WSH_INTERFACE.update_shipping_attributes');
1971: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'CTO:Failed in WSH_INTERFACE.update_shipping_attributes :', 1);
1972: END IF;
1973: OE_MSG_PUB.ADD;

Line 1978: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserve',

1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: ELSE
1976: IF PG_DEBUG <> 0 THEN
1977: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || ' Renga: Success in update_shipping attributes..', 2);
1978: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserve',
1979: ' Renga: Success in update_shipping attributes..');
1980:
1981: END IF;
1982: END IF ;

Line 2022: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Raising CTO_ERROR_FROM_DISPLAY_STATUS');

2018:
2019: if return_value <> 1 then
2020:
2021: if PG_DEBUG <> 0 Then
2022: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Raising CTO_ERROR_FROM_DISPLAY_STATUS');
2023: End if;
2024: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
2025: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2026:

Line 2043: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Exiting wf_update_after_inv_unreserv');

2039: END IF;
2040: end if; --v_open_flag Bugfix 7214005
2041:
2042: IF PG_DEBUG <> 0 THEN
2043: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Exiting wf_update_after_inv_unreserv');
2044: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'Exiting wf_update_after_inv_unreserv', 2);
2045: END IF;
2046:
2047: EXCEPTION

Line 2052: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','exp erro stmt no :'|| to_char(l_stmt_num));

2048: when FND_API.G_EXC_ERROR then
2049:
2050: IF PG_DEBUG <> 0 THEN
2051: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'exp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num), 1);
2052: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','exp erro stmt no :'|| to_char(l_stmt_num));
2053:
2054: END IF;
2055: x_return_status := FND_API.G_RET_STS_ERROR;
2056: cto_msg_pub.count_and_get(

Line 2065: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp err stmt no:'|| to_char(l_stmt_num));

2061: when FND_API.G_EXC_UNEXPECTED_ERROR then
2062:
2063: IF PG_DEBUG <> 0 THEN
2064: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num));
2065: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp err stmt no:'|| to_char(l_stmt_num));
2066:
2067: END IF;
2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2069: cto_msg_pub.count_and_get(

Line 2079: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp errr stmt no :'|| to_char(l_stmt_num));

2075:
2076: IF PG_DEBUG <> 0 THEN
2077: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num), 1);
2078: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || sqlerrm, 1);
2079: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp errr stmt no :'|| to_char(l_stmt_num));
2080: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE',sqlerrm);
2081:
2082: END IF;
2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2080: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE',sqlerrm);

2076: IF PG_DEBUG <> 0 THEN
2077: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'unexp error in CTO_WORKFLOW_API_PK.wf_update_after_inv_unreserv::stmt number '||to_char(l_stmt_num), 1);
2078: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || sqlerrm, 1);
2079: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp errr stmt no :'|| to_char(l_stmt_num));
2080: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE',sqlerrm);
2081:
2082: END IF;
2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2084: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2786: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);

2782: l_stmt_num := 10;
2783: l_message := 'line status is '||p_change_status||', (change_status_batch) at stmt number'||to_char(l_stmt_num);
2784: IF PG_DEBUG <> 0 THEN
2785: oe_debug_pub.add('Change_Status_Batch: ' || l_message, 5);
2786: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2787:
2788: END IF;
2789: -- bugfix 2825486: added select to get the current flow_status_code.
2790: l_stmt_num := 20;

Line 2801: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);

2797:
2798: IF PG_DEBUG <> 0 THEN
2799: l_message := 'Current flow_status_code = '||lFlowStatusCode;
2800: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,4);
2801: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2802: END IF;
2803:
2804: -- bugfix 2825486: Added IF. Only when flow_status is different, we'll call OM api to update the
2805: -- flow_status_code.

Line 2814: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);

2810: -- bugfix 2825486: added dbg stmt
2811: IF PG_DEBUG <> 0 THEN
2812: l_message := 'calling OE_ORDER_WF_UTIL.update_flow_status_code to update flow_status to '||p_change_status;
2813: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,5);
2814: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2815: END IF;
2816:
2817: -- Fixed by Renga Kannan on 04/27/06
2818: -- Fixed for bug 5122923

Line 2843: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);

2839: x_return_status := FND_API.G_RET_STS_SUCCESS; -- 5151111
2840: IF PG_DEBUG <> 0 THEN
2841: l_message:= 'Error occurred in updating line status to '||p_change_status||' - Stmt_num'||to_char(l_stmt_num);
2842: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2843: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2844:
2845: --bug#4700053
2846: l_message:= 'Progressing ahead even though line status may be wrong';
2847: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);

Line 2848: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);

2844:
2845: --bug#4700053
2846: l_message:= 'Progressing ahead even though line status may be wrong';
2847: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2848: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2849:
2850: END IF;
2851: --raise FND_API.G_EXC_ERROR;
2852:

Line 2858: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);

2854: x_return_status := FND_API.G_RET_STS_SUCCESS; --5151111
2855: IF PG_DEBUG <> 0 THEN
2856: l_message:= 'UnExp Error occurred in updating line status to '||p_change_status||' - Stmt_num'||to_char(l_stmt_num);
2857: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2858: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2859:
2860: --bug#4700053
2861: l_message:= 'Progressing ahead even though line status may be wrong';
2862: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);

Line 2863: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);

2859:
2860: --bug#4700053
2861: l_message:= 'Progressing ahead even though line status may be wrong';
2862: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2863: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2864: END IF;
2865: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
2866:
2867: end if;

Line 2882: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', l_message);

2878:
2879: l_message := 'after updating line status to '||p_change_status||', (change_status_batch) at stmt number'||to_char(l_stmt_num);
2880: IF PG_DEBUG <> 0 THEN
2881: oe_debug_pub.add('Change_Status_Batch: ' || l_message, 5);
2882: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', l_message);
2883:
2884: END IF;
2885: EXCEPTION
2886:

Line 2890: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','exp erro change_status_batch :: '||l_stmt_num||sqlerrm);

2886:
2887: WHEN FND_API.G_EXC_ERROR THEN
2888: IF PG_DEBUG <> 0 THEN
2889: oe_debug_pub.add('Change_Status_Batch: ' || 'exp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2890: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','exp erro change_status_batch :: '||l_stmt_num||sqlerrm);
2891:
2892: END IF;
2893: x_return_status := FND_API.G_RET_STS_ERROR;
2894:

Line 2898: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);

2894:
2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2896: IF PG_DEBUG <> 0 THEN
2897: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2898: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);
2899: End if;
2900:
2901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2902:

Line 2907: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);

2903: WHEN OTHERS THEN
2904: IF PG_DEBUG <> 0 THEN
2905: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error (others) in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2906: oe_debug_pub.add('Change_Status_Batch: ' || sqlerrm, 1);
2907: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);
2908:
2909: END IF;
2910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2911: END;