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 512: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'Entering Display_wf_status');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 584: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',

580: --elsif nvl(v_shipped_quantity,0) <> 0 then
581: elsif nvl(v_shipped_qty,0) <> 0 then
582:
583: If PG_DEBUG <> 0 Then
584: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
585: 'Line is shipped no need to change the status..');
586: End if;
587:
588: Elsif v_source_type_code = 'EXTERNAL' THEN

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

590:
591:
592:
593: If PG_DEBUG <> 0 Then
594: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'Drop ship line, will be updating line status');
595: End if;
596:
597: --bugfix 5461892
598:

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

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

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

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

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

680: End if; /* l_change_status <> '_' */
681:
682: IF PG_DEBUG <> 0 THEN
683: oe_debug_pub.add('display_wf_status: ' || 'Exiting disp_wf_status', 4);
684: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', 'Exiting display_wf_Status with return value 1');
685: End if;
686: return 1;
687:
688: EXCEPTION

Line 692: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',

688: EXCEPTION
689: when FND_API.G_EXC_ERROR then
690: IF PG_DEBUG <> 0 THEN
691: 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);
692: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
693: 'CTO_WORKFLOW_API_PK.display_wf_status raised exp error::stmt number '|| to_char(l_stmt_num));
694: End if;
695: return 0;--bugfix 4545070
696:

Line 701: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',

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

Line 709: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',

705: when others then
706: IF PG_DEBUG <> 0 THEN
707: oe_debug_pub.add('display_wf_status: ' || 'CTO_WORKFLOW_API_PK.display_wf_status::stmt number '||to_char(l_stmt_num), 1);
708: oe_debug_pub.add('display_wf_status: ' || sqlerrm, 1);
709: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
710: 'CTO_WORKFLOW_API_PK.display_wf_status::stmt number '||
711: to_char(l_stmt_num));
712: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', sqlerrm);
713: End if;

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

708: oe_debug_pub.add('display_wf_status: ' || sqlerrm, 1);
709: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS',
710: 'CTO_WORKFLOW_API_PK.display_wf_status::stmt number '||
711: to_char(l_stmt_num));
712: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', sqlerrm);
713: End if;
714: return 0;
715:
716: END display_wf_status;

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

756:
757: BEGIN
758: IF PG_DEBUG <> 0 THEN
759: oe_debug_pub.add('inventory_reservation_check: ' || 'Entering inventory_reservation_check', 2);
760: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'In inventory_reservation_check');
761: End if;
762:
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:

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

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

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

781: -- removing code to allow reservation for ATOitem
782: -- by kkonada :adding below code again for dummy assignment*/
783: If PG_DEBUG <> 0 then
784: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'ATO Line Id = '||v_ato_line_id);
785: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Item Type Code = '||v_item_type_code);
786: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Source Type Code = '||v_source_type_code);
787: oe_debug_pub.add('inventory_reservation_check: ATO Line Id:'|| v_ato_line_id);
788: oe_debug_pub.add('inventory_reservation_check: Item Type Code: '|| v_item_type_code);
789: oe_debug_pub.add('inventory_reservation_check: Source Type Code: '|| v_source_type_code);

Line 786: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Source Type Code = '||v_source_type_code);

782: -- by kkonada :adding below code again for dummy assignment*/
783: If PG_DEBUG <> 0 then
784: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'ATO Line Id = '||v_ato_line_id);
785: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Item Type Code = '||v_item_type_code);
786: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Source Type Code = '||v_source_type_code);
787: oe_debug_pub.add('inventory_reservation_check: ATO Line Id:'|| v_ato_line_id);
788: oe_debug_pub.add('inventory_reservation_check: Item Type Code: '|| v_item_type_code);
789: oe_debug_pub.add('inventory_reservation_check: Source Type Code: '|| v_source_type_code);
790: End if;

Line 839: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check',

835: --End of bug fix 4888964
836: exception
837: when others then
838: If PG_DEBUG <> 0 Then
839: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check',
840: 'no data found in po_headers_all for om header ' ||
841: to_char( v_header_id ) || ' line id ' ||
842: to_char( p_order_line_id ) || ' po header id ' ||
843: to_char( v_po_header_id ) ) ;

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

893: v_activity_status_code);
894:
895: if upper(v_activity_status_code) <> 'NOTIFIED' then
896: If PG_DEBUG <> 0 then
897: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'v_activity_status_code <> NOTIFIED');
898: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
899: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
900: End if;
901: raise FND_API.G_EXC_ERROR;

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

894:
895: if upper(v_activity_status_code) <> 'NOTIFIED' then
896: If PG_DEBUG <> 0 then
897: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'v_activity_status_code <> NOTIFIED');
898: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
899: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
900: End if;
901: raise FND_API.G_EXC_ERROR;
902: end if;

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

904: end if;
905:
906: end if;
907: If PG_DEBUG <> 0 then
908: cto_wip_workflow_api_pk.cto_debug('inventory_reservation_check', 'Exiting inventory_reservation_check');
909: oe_debug_pub.add('inventory_reservation_check: ' || 'Exiting inventory_reservation_check', 2);
910: END IF;
911:
912: EXCEPTION

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

912: EXCEPTION
913: when FND_API.G_EXC_ERROR then
914: IF PG_DEBUG <> 0 THEN
915: 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);
916: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no :'|| to_char(l_stmt_num));
917: End if;
918:
919: x_return_status := FND_API.G_RET_STS_ERROR;
920: cto_msg_pub.count_and_get(

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

923: );
924: when FND_API.G_EXC_UNEXPECTED_ERROR then
925: IF PG_DEBUG <> 0 THEN
926: 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);
927: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'|| to_char(l_stmt_num));
928: End if;
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
930: cto_msg_pub.count_and_get(
931: p_msg_count => x_msg_count,

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

936: IF PG_DEBUG <> 0 THEN
937: 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);
938:
939: oe_debug_pub.add('inventory_reservation_check: ' || sqlerrm);
940: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'||to_char(l_stmt_num) );
941: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check', sqlerrm);
942: End if;
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

937: 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);
938:
939: oe_debug_pub.add('inventory_reservation_check: ' || sqlerrm);
940: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check','Stmt no:'||to_char(l_stmt_num) );
941: cto_wip_workflow_api_pk.cto_debug('Inventory_reservation_check', sqlerrm);
942: End if;
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
945: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

992:
993:
994: BEGIN
995: If PG_DEBUG <> 0 Then
996: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Entering wf_update_after_inv_reserv');
997: End if;
998:
999: IF PG_DEBUG <> 0 THEN
1000: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Entering wf_update_after_inv_reserv', 2);

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

1002: x_return_status := FND_API.G_RET_STS_SUCCESS;
1003: l_stmt_num := 10;
1004:
1005: If PG_DEBUG <> 0 Then
1006: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'Before selecting info from oe_order_lines_all');
1007: End if;
1008:
1009:
1010: select item_type_code,

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

1013: v_ato_line_id
1014: from oe_order_lines_all
1015: where line_id = p_order_line_id;
1016: If PG_DEBUG <> 0 Then
1017: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'ato_line_id = '||v_ato_line_id);
1018: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'v_item_type_code = '||v_item_type_code);
1019: oe_debug_pub.add('wf_update_after_inv_reserv: ato_line_id:' || v_ato_line_id);
1020: oe_debug_pub.add('wf_update_after_inv_reserv: v_item_type_code:' || v_item_type_code);
1021: oe_debug_pub.add('wf_update_after_inv_reserv: p_order_line_id:' || p_order_line_id);

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

1014: from oe_order_lines_all
1015: where line_id = p_order_line_id;
1016: If PG_DEBUG <> 0 Then
1017: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'ato_line_id = '||v_ato_line_id);
1018: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'v_item_type_code = '||v_item_type_code);
1019: oe_debug_pub.add('wf_update_after_inv_reserv: ato_line_id:' || v_ato_line_id);
1020: oe_debug_pub.add('wf_update_after_inv_reserv: v_item_type_code:' || v_item_type_code);
1021: oe_debug_pub.add('wf_update_after_inv_reserv: p_order_line_id:' || p_order_line_id);
1022: End if;

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

1039: --SUN ER#9793792: Changed the debug message
1040: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'item_type_code is STANDARD/OPTION/INCLUDED => an ato item', 4);
1041: END IF;--fix for bug#1874380
1042: If PG_DEBUG <> 0 Then
1043: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Before querying wf_activity_status..');
1044: End if;
1045:
1046: -- Check if workflow is in Create supply order eligible activity
1047:

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

1051: 'CREATE_SUPPLY_ORDER_ELIGIBLE',
1052: v_activity_status_code);
1053:
1054: If PG_DEBUG <> 0 then
1055: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','v_activity_status_code = '||
1056: upper(v_activity_status_code));
1057: End if;
1058: -- If notified move the workflow to Ship line
1059:

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

1060:
1061: if upper(v_activity_status_code) = 'NOTIFIED' then
1062: l_stmt_num := 30;
1063: If PG_DEBUG <> 0 Then
1064: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Complete the workflow
1065: stmt no : 30');
1066: End if;
1067: -- Modified for MOAC project
1068: -- Called complete_acitivity procedure instead of calling wf_engine api.

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

1087: -- End of MOAC Change
1088:
1089: --start of fix for bug#1895563
1090: If PG_DEBUG <> 0 Then
1091: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Before calling display_wf_status..'||
1092: 'from l_stmt_num=>'||l_stmt_num);
1093: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Before calling display_wf_status.. from l_stmt_num=>'||l_stmt_num,2);
1094: END IF;
1095:

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

1095:
1096: return_value := display_wf_status(p_order_line_id);
1097:
1098: If PG_DEBUG <> 0 Then
1099: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Return value after display_wf_status'
1100: ||to_char(return_value));
1101: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Return value after display_wf_status at l_stmt_num=>'||l_stmt_num||'is'
1102: ||to_char(return_value),1);
1103: END IF;

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

1111: else -- not in supply order eligible
1112:
1113: l_stmt_num := 40;
1114: If PG_DEBUG <> 0 then
1115: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Stmt no : 40, query
1116: wf_activity status..');
1117: End if;
1118:
1119: query_wf_activity_status(G_ITEM_TYPE_NAME,

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

1122: 'EXECUTECONCPROGAFAS',
1123: v_activity_status_code);
1124:
1125: If PG_DEBUG <> 0 then
1126: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','v_activity_status_code = '||
1127: v_activity_status_code);
1128:
1129: End if;
1130: IF upper(v_activity_status_code) <> 'NOTIFIED' THEN

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

1131:
1132: l_stmt_num := 50;
1133:
1134: If PG_DEBUG <> 0 Then
1135: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Stmt no : 50
1136: querying wf_activity_status');
1137: End if;
1138: query_wf_activity_status(G_ITEM_TYPE_NAME,
1139: TO_CHAR(p_order_line_id),

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

1141: 'SHIP_LINE',
1142: v_activity_status_code);
1143:
1144: If PG_DEBUG <> 0 Then
1145: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'v_actitivity_status_code ='||
1146: v_activity_status_code);
1147: End if;
1148: IF upper(v_activity_status_code) = 'NOTIFIED' then
1149:

Line 1152: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',

1148: IF upper(v_activity_status_code) = 'NOTIFIED' then
1149:
1150:
1151: If PG_DEBUG <> 0 Then
1152: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1153: 'Before calling display_wf_status..'||
1154: 'from l_stmt_num=>'||l_stmt_num);
1155: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Before calling display_wf_status.. from l_stmt_num=>'||l_stmt_num,2);
1156: END IF;

Line 1162: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',

1158: return_value := display_wf_status(p_order_line_id);
1159:
1160:
1161: If PG_DEBUG <> 0 Then
1162: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1163: 'Return value after display_wf_status'
1164: ||to_char(return_value));
1165: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Return value after display_wf_status at l_stmt_num=>'||l_stmt_num||'is'
1166: ||to_char(return_value),1);

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

1169:
1170: ELSE -- Auto create fas Notified
1171:
1172: If PG_DEBUG <> 0 Then
1173: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Before calling display_wf_status..'||
1174: 'from l_stmt_num=>'||l_stmt_num);
1175: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Before calling display_wf_status.. from l_stmt_num=>'||l_stmt_num,2);
1176: END IF;
1177:

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

1178: return_value := display_wf_status(p_order_line_id);
1179:
1180:
1181: If PG_DEBUG <> 0 Then
1182: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Return value after display_wf_status'
1183: ||to_char(return_value));
1184: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Return value after display_wf_status at l_stmt_num=>'||l_stmt_num||'is'
1185: ||to_char(return_value),1);
1186: END IF;

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

1189:
1190: end if;
1191: if return_value <> 1 then
1192: If PG_DEBUG <> 0 Then
1193: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');
1194: End if;
1195: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
1196: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1197: end if;

Line 1210: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',

1206:
1207: l_stmt_num := 60;
1208:
1209: If PG_DEBUG <> 0 Then
1210: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1211: ' Stmt no : 60 , querying activity_status');
1212: End if;
1213:
1214: query_wf_activity_status(G_ITEM_TYPE_NAME,

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

1217: 'CREATE_SUPPLY_ORDER_ELIGIBLE',
1218: v_activity_status_code);
1219:
1220: If PG_DEBUG <> 0 Then
1221: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' v_actitivity_status_code = '||
1222: v_activity_status_code);
1223: End if;
1224:
1225: IF upper(v_activity_status_code) = 'NOTIFIED' then

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

1226:
1227: l_stmt_num := 70;
1228:
1229: If PG_DEBUG <> 0 Then
1230: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Stmt no : 70, Completing
1231: workflow activity..');
1232: End if;
1233:
1234: -- Modified for MOAC project

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

1255: ELSE
1256:
1257: l_stmt_num := 80;
1258: if pG_DEBUG <> 0 Then
1259: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Stmt no : 80 querying
1260: wf_activity_status');
1261: end if;
1262: query_wf_activity_status(G_ITEM_TYPE_NAME,
1263: TO_CHAR(p_order_line_id),

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

1265: 'EXECUTECONCPROGAFAS',
1266: v_activity_status_code);
1267:
1268: If PG_DEBUG <> 0 Then
1269: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','v_activity_status_code = '||
1270: v_activity_status_code);
1271: End if;
1272:
1273: IF upper(v_activity_status_code) <> 'NOTIFIED' then

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

1274:
1275: l_stmt_num := 90;
1276:
1277: If PG_DEBUG <> 0 Then
1278: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Stmt no : 90,
1279: querying wf_activity_status');
1280: End if;
1281: query_wf_activity_status(G_ITEM_TYPE_NAME,
1282: TO_CHAR(p_order_line_id),

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

1284: 'SHIP_LINE',
1285: v_activity_status_code);
1286:
1287: If PG_DEBUG <> 0 Then
1288: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', ' v_activity_status_code = '||
1289: v_activity_status_code);
1290: End if;
1291:
1292: if upper(v_activity_status_code) <> 'NOTIFIED' then

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

1291:
1292: if upper(v_activity_status_code) <> 'NOTIFIED' then
1293:
1294: If PG_DEBUG <> 0 Then
1295: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'v_activity_status_code <> NOTIFIED');
1296: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1297: End if;
1298:
1299: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');

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

1292: if upper(v_activity_status_code) <> 'NOTIFIED' then
1293:
1294: If PG_DEBUG <> 0 Then
1295: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'v_activity_status_code <> NOTIFIED');
1296: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_reserv', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1297: End if;
1298:
1299: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1300: raise FND_API.G_EXC_ERROR;

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

1308:
1309: -- display proper status to OM form
1310:
1311: If PG_DEBUG <> 0 Then
1312: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Before calling display_wf_status');
1313: End if;
1314:
1315: return_value := display_wf_status(p_order_line_id);
1316:

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

1314:
1315: return_value := display_wf_status(p_order_line_id);
1316:
1317: If PG_DEBUG <> 0 Then
1318: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Return_value from display_wf_status = '||
1319: to_char(return_value));
1320: End if;
1321:
1322: IF return_value <> 1 then

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

1320: End if;
1321:
1322: IF return_value <> 1 then
1323: IF PG_DEBUG <> 0 Then
1324: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV','Raising CTO_ERROR_FROM_DISPLAY_STATUS');
1325: End if;
1326: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
1327: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END IF;

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

1328: END IF;
1329:
1330: end if; /* end of item_type_code check */
1331: If PG_DEBUG <> 0 then
1332: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',' Exiting wf_update_after_inv_reserv');
1333: End if;
1334: IF PG_DEBUG <> 0 THEN
1335: oe_debug_pub.add('wf_update_after_inv_reserv: ' || 'Exiting wf_update_after_inv_reserv', 2);
1336: END IF;

Line 1345: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',

1341: 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);
1342: END IF;
1343:
1344: If PG_DEBUG <> 0 Then
1345: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1346: 'Exp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1347: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1348: End if;
1349:

Line 1359: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',

1355:
1356: when FND_API.G_EXC_UNEXPECTED_ERROR then
1357: IF PG_DEBUG <> 0 THEN
1358: 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);
1359: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV',
1360: 'UNExp error in CTO_WORKFLOW_API_PK.wf_update_inv_reserv::
1361: stmt no : '||to_char(l_stmt_num)||'::'||sqlerrm);
1362: End if;
1363:

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

1373:
1374: oe_debug_pub.add('wf_update_after_inv_reserv: ' || sqlerrm, 1);
1375: END IF;
1376: If PG_DEBUG <> 0 Then
1377: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'OTHERS excpn: stmt no : '||to_char(l_stmt_num));
1378: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', sqlerrm);
1379: End if;
1380:
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1374: oe_debug_pub.add('wf_update_after_inv_reserv: ' || sqlerrm, 1);
1375: END IF;
1376: If PG_DEBUG <> 0 Then
1377: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'OTHERS excpn: stmt no : '||to_char(l_stmt_num));
1378: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', sqlerrm);
1379: End if;
1380:
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1420:
1421: BEGIN
1422: IF PG_DEBUG <> 0 THEN
1423: oe_debug_pub.add('inventory_unreservation_check: ' || 'Entering inventory_unreservation_check', 2);
1424: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check','Entering inventory_unreservation_check');
1425: End if;
1426:
1427: x_return_status := FND_API.G_RET_STS_SUCCESS;
1428: l_stmt_num := 10;

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

1444: 'SHIP_LINE',
1445: 'SHIP_LINE', v_activity_status_code);
1446: if upper(v_activity_status_code) <> 'NOTIFIED' then
1447: If PG_DEBUG <> 0 Then
1448: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1449: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1450: End if;
1451: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1452: raise FND_API.G_EXC_ERROR;

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

1445: 'SHIP_LINE', v_activity_status_code);
1446: if upper(v_activity_status_code) <> 'NOTIFIED' then
1447: If PG_DEBUG <> 0 Then
1448: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1449: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1450: End if;
1451: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1452: raise FND_API.G_EXC_ERROR;
1453: end if;

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

1470: then
1471:
1472: --begin bugfix 2001824 : check if qty being unreserved is ok
1473: If PG_DEBUG <> 0 Then
1474: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'p_rsv_quantity'||p_rsv_quantity);
1475: End if;
1476: if (CTO_UTILITY_PK.check_rsv_quantity (p_order_line_id => p_order_line_id,
1477: p_rsv_quantity => p_rsv_quantity) = FALSE )
1478: then

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

1481: ' is NOT allowed since part of this has been either ship confirmed, intrasit or closed.', 2);
1482: END IF;
1483:
1484: If PG_DEBUG <> 0 Then
1485: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1486: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1487: End if;
1488: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1489: raise FND_API.G_EXC_ERROR;

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

1482: END IF;
1483:
1484: If PG_DEBUG <> 0 Then
1485: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'v_activity_status_code <> NOTIFIED');
1486: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Raising CTO_INVALID_ACTIVITY_STATUS');
1487: End if;
1488: cto_msg_pub.cto_message('BOM', 'CTO_INVALID_ACTIVITY_STATUS');
1489: raise FND_API.G_EXC_ERROR;
1490: else

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

1497: end if;
1498:
1499: IF PG_DEBUG <> 0 THEN
1500: oe_debug_pub.add('inventory_unreservation_check: ' || 'Exiting inventory_unreservation_check', 2);
1501: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', 'Exiting inventory_unreservation_check');
1502: End if;
1503:
1504: EXCEPTION
1505:

Line 1509: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',

1505:
1506: when FND_API.G_EXC_ERROR then
1507: IF PG_DEBUG <> 0 THEN
1508: 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);
1509: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1510: 'Raised FND_API.G_EXC_ERROR, stmt'||l_stmt_num);
1511: End if;
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: cto_msg_pub.count_and_get(

Line 1521: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',

1517:
1518: when FND_API.G_EXC_UNEXPECTED_ERROR then
1519: IF PG_DEBUG <> 0 THEN
1520: 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);
1521: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1522: 'Raised FND_API.G_EXC_UNEXPECTED_ERROR, stmt'||l_stmt_num);
1523: End if;
1524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1525: cto_msg_pub.count_and_get(

Line 1535: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',

1531: IF PG_DEBUG <> 0 THEN
1532: 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);
1533:
1534: oe_debug_pub.add('inventory_unreservation_check: ' || sqlerrm, 1);
1535: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1536: 'Raised OTHERS excepn, stmt: '||l_stmt_num);
1537: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', sqlerrm);
1538: End if;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1533:
1534: oe_debug_pub.add('inventory_unreservation_check: ' || sqlerrm, 1);
1535: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check',
1536: 'Raised OTHERS excepn, stmt: '||l_stmt_num);
1537: cto_wip_workflow_api_pk.cto_debug('inventory_unreservation_check', sqlerrm);
1538: End if;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1541: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

1651: v_open_flag varchar2(1); -- Bugfix 7214005
1652:
1653: BEGIN
1654: If PG_DEBUG <> 0 Then
1655: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'In wf_update_after_inv_unreserv');
1656: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'Entering wf_update_after_inv_unreserv', 2);
1657: END IF;
1658:
1659: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1682: from oe_order_lines_all
1683: where line_id = p_order_line_id;
1684:
1685: If PG_DEBUG <> 0 Then
1686: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'ATO Line Id = '||v_ato_line_id);
1687: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Item Type Code = '||v_item_type_code);
1688: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Open Flag = '||v_open_flag);
1689: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'ATO Line Id ='||v_ato_line_id, 1);
1690: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'Item Type Code ='||v_item_type_code, 1);

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

1683: where line_id = p_order_line_id;
1684:
1685: If PG_DEBUG <> 0 Then
1686: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'ATO Line Id = '||v_ato_line_id);
1687: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Item Type Code = '||v_item_type_code);
1688: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Open Flag = '||v_open_flag);
1689: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'ATO Line Id ='||v_ato_line_id, 1);
1690: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'Item Type Code ='||v_item_type_code, 1);
1691: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'Open Flag ='||v_open_flag, 1);

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

1684:
1685: If PG_DEBUG <> 0 Then
1686: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'ATO Line Id = '||v_ato_line_id);
1687: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Item Type Code = '||v_item_type_code);
1688: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Open Flag = '||v_open_flag);
1689: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'ATO Line Id ='||v_ato_line_id, 1);
1690: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'Item Type Code ='||v_item_type_code, 1);
1691: oe_debug_pub.add('wf_update_after_inv_unreserv ' || 'Open Flag ='||v_open_flag, 1);
1692: End if;

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

1779: and demand_source_line_id = p_order_line_id
1780: and primary_reservation_quantity > 0;
1781:
1782: If PG_DEBUG <> 0 Then
1783: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'v_counter = '||v_counter);
1784: End if;
1785:
1786: v_counter2 := 0;
1787: l_stmt_num := 40;

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

1812: end if;
1813: -- end bugfix 3174334
1814:
1815: If PG_DEBUG <> 0 Then
1816: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'v_counter2 = '||v_counter2);
1817: End if;
1818: ---Modified by Renga Kannan on 12/18/2000
1819:
1820: -- Modified by Renga Kannan on 14-NOV-2001

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

1859: and item_id = l_inventory_item_id
1860: AND process_flag is null;
1861:
1862: If PG_DEBUG <> 0 Then
1863: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'l_po_req_qty = '||l_po_req_qty);
1864: End if;
1865:
1866: -- no reservation at all
1867:

Line 1910: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',

1906: x_msg_data => v_x_msg_data);
1907:
1908: IF (v_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1909: IF PG_DEBUG <> 0 THEN
1910: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',
1911: 'Failed in WSH_Integration_Pub.Get Tolerance');
1912: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'CTO:Failed in WSH_Integration_Pub.Get Tolerance :' || v_x_return_status, 1);
1913: END IF;
1914: OE_MSG_PUB.ADD;

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

1936: -- With post-CMS (change mgmt from OM), unreservation will be triggered from shipping rather than OM.
1937: -- OM.
1938:
1939: IF PG_DEBUG <> 0 THEN
1940: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'v_x_min_remaining_quantity = '|| l_out_attributes.min_remaining_quantity);
1941: cto_wip_workflow_api_pk.cto_debug('Wf_update_after_inv_unreserve',' Shipping interfaced flag = '||l_ship_xfaced_flag);
1942: oe_debug_pub.add('Wf_update_after_inv_unreserve: Shipping interfaced flag = '||l_ship_xfaced_flag);
1943: end if;
1944:

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

1937: -- OM.
1938:
1939: IF PG_DEBUG <> 0 THEN
1940: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'v_x_min_remaining_quantity = '|| l_out_attributes.min_remaining_quantity);
1941: cto_wip_workflow_api_pk.cto_debug('Wf_update_after_inv_unreserve',' Shipping interfaced flag = '||l_ship_xfaced_flag);
1942: oe_debug_pub.add('Wf_update_after_inv_unreserve: Shipping interfaced flag = '||l_ship_xfaced_flag);
1943: end if;
1944:
1945: -- bugfix 2118864

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

1953: (l_ship_xfaced_flag = 'N' or nvl(l_out_attributes.min_remaining_quantity,0) > 0 )
1954: then
1955:
1956: IF PG_DEBUG <> 0 Then
1957: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'No Reservations exists... Updating workflow.');
1958: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'No Reservation Exists...',1);
1959: END IF;
1960:
1961: l_stmt_num := 50;

Line 1983: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',

1979: l_changed_attributes(1).action_flag := 'U';
1980:
1981: IF PG_DEBUG <> 0 THEN
1982: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'Renga: Updating the shipping attributes..',1);
1983: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',
1984: 'Renga : CAlling Shipping update attribute api');
1985: End if;
1986: WSH_INTERFACE.Update_Shipping_Attributes
1987: ( p_source_code => 'OE'

Line 1996: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',

1992:
1993: IF (v_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1994:
1995: IF PG_DEBUG <> 0 THEN
1996: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv',
1997: 'WSH_INTERFACE.update_shipping_attributes');
1998: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'CTO:Failed in WSH_INTERFACE.update_shipping_attributes :', 1);
1999: END IF;
2000: OE_MSG_PUB.ADD;

Line 2005: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserve',

2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2002: ELSE
2003: IF PG_DEBUG <> 0 THEN
2004: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || ' Renga: Success in update_shipping attributes..', 2);
2005: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserve',
2006: ' Renga: Success in update_shipping attributes..');
2007:
2008: END IF;
2009: END IF ;

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

2045:
2046: if return_value <> 1 then
2047:
2048: if PG_DEBUG <> 0 Then
2049: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Raising CTO_ERROR_FROM_DISPLAY_STATUS');
2050: End if;
2051: cto_msg_pub.cto_message('BOM', 'CTO_ERROR_FROM_DISPLAY_STATUS');
2052: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2053:

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

2066: END IF;
2067: end if; --v_open_flag Bugfix 7214005
2068:
2069: IF PG_DEBUG <> 0 THEN
2070: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'Exiting wf_update_after_inv_unreserv');
2071: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || 'Exiting wf_update_after_inv_unreserv', 2);
2072: END IF;
2073:
2074: EXCEPTION

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

2075: when FND_API.G_EXC_ERROR then
2076:
2077: IF PG_DEBUG <> 0 THEN
2078: 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);
2079: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','exp erro stmt no :'|| to_char(l_stmt_num));
2080:
2081: END IF;
2082: x_return_status := FND_API.G_RET_STS_ERROR;
2083: cto_msg_pub.count_and_get(

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

2088: when FND_API.G_EXC_UNEXPECTED_ERROR then
2089:
2090: IF PG_DEBUG <> 0 THEN
2091: 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));
2092: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp err stmt no:'|| to_char(l_stmt_num));
2093:
2094: END IF;
2095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2096: cto_msg_pub.count_and_get(

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

2102:
2103: IF PG_DEBUG <> 0 THEN
2104: 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);
2105: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || sqlerrm, 1);
2106: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp errr stmt no :'|| to_char(l_stmt_num));
2107: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE',sqlerrm);
2108:
2109: END IF;
2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2103: IF PG_DEBUG <> 0 THEN
2104: 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);
2105: oe_debug_pub.add('wf_update_after_inv_unreserv: ' || sqlerrm, 1);
2106: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE','Unexp errr stmt no :'|| to_char(l_stmt_num));
2107: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_UNRESERVE',sqlerrm);
2108:
2109: END IF;
2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

2810: l_stmt_num := 10;
2811: l_message := 'line status is '||p_change_status||', (change_status_batch) at stmt number'||to_char(l_stmt_num);
2812: IF PG_DEBUG <> 0 THEN
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:
2816: END IF;
2817: -- bugfix 2825486: added select to get the current flow_status_code.
2818: l_stmt_num := 20;

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

2826: IF PG_DEBUG <> 0 THEN
2827: l_message := 'Current flow_status_code = '||lFlowStatusCode;
2828: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,4);
2829: oe_debug_pub.add('Cancelled_flag: ' ||l_cancelled_flag,4);
2830: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2831: END IF;
2832:
2833: -- bugfix 2825486: Added IF. Only when flow_status is different, we'll call OM api to update the
2834: -- flow_status_code.

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

2840: -- bugfix 2825486: added dbg stmt
2841: IF PG_DEBUG <> 0 THEN
2842: l_message := 'calling OE_ORDER_WF_UTIL.update_flow_status_code to update flow_status to '||p_change_status;
2843: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,5);
2844: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2845: END IF;
2846:
2847: -- Fixed by Renga Kannan on 04/27/06
2848: -- Fixed for bug 5122923

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

2869: x_return_status := FND_API.G_RET_STS_SUCCESS; -- 5151111
2870: IF PG_DEBUG <> 0 THEN
2871: l_message:= 'Error occurred in updating line status to '||p_change_status||' - Stmt_num'||to_char(l_stmt_num);
2872: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2873: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2874:
2875: --bug#4700053
2876: l_message:= 'Progressing ahead even though line status may be wrong';
2877: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);

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

2874:
2875: --bug#4700053
2876: l_message:= 'Progressing ahead even though line status may be wrong';
2877: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2878: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2879:
2880: END IF;
2881: --raise FND_API.G_EXC_ERROR;
2882:

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

2884: x_return_status := FND_API.G_RET_STS_SUCCESS; --5151111
2885: IF PG_DEBUG <> 0 THEN
2886: l_message:= 'UnExp Error occurred in updating line status to '||p_change_status||' - Stmt_num'||to_char(l_stmt_num);
2887: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2888: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2889:
2890: --bug#4700053
2891: l_message:= 'Progressing ahead even though line status may be wrong';
2892: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);

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

2889:
2890: --bug#4700053
2891: l_message:= 'Progressing ahead even though line status may be wrong';
2892: oe_debug_pub.add('Change_Status_Batch: ' ||l_message,1);
2893: cto_wip_workflow_api_pk.cto_debug('change_status_batch', l_message);
2894: END IF;
2895: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
2896:
2897: end if;

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

2908:
2909: l_message := 'after updating line status to '||p_change_status||', (change_status_batch) at stmt number'||to_char(l_stmt_num);
2910: IF PG_DEBUG <> 0 THEN
2911: oe_debug_pub.add('Change_Status_Batch: ' || l_message, 5);
2912: cto_wip_workflow_api_pk.cto_debug('DISPLAY_WF_STATUS', l_message);
2913:
2914: END IF;
2915: EXCEPTION
2916:

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

2916:
2917: WHEN FND_API.G_EXC_ERROR THEN
2918: IF PG_DEBUG <> 0 THEN
2919: oe_debug_pub.add('Change_Status_Batch: ' || 'exp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2920: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','exp erro change_status_batch :: '||l_stmt_num||sqlerrm);
2921:
2922: END IF;
2923: x_return_status := FND_API.G_RET_STS_ERROR;
2924:

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

2924:
2925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2926: IF PG_DEBUG <> 0 THEN
2927: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2928: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);
2929: End if;
2930:
2931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2932:

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

2933: WHEN OTHERS THEN
2934: IF PG_DEBUG <> 0 THEN
2935: oe_debug_pub.add('Change_Status_Batch: ' || 'unexp error (others) in CTO_WORKFLOW_API_PK.change_status_batch::'||l_stmt_num, 1);
2936: oe_debug_pub.add('Change_Status_Batch: ' || sqlerrm, 1);
2937: cto_wip_workflow_api_pk.cto_debug('CHANGE_STATUS_BATCH','Unexp err change_status_batch :: '||l_stmt_num||sqlerrm);
2938:
2939: END IF;
2940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2941: END;