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_CHANGE_ORDER_PK dependencies on OE_DEBUG_PUB

Line 253: oe_debug_pub.add('Adjust_workflow_node: ' || 'Values passed in are as follows: ', 5);

249: lStmtNumber := 10;
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: IF PG_DEBUG <> 0 THEN
253: oe_debug_pub.add('Adjust_workflow_node: ' || 'Values passed in are as follows: ', 5);
254: oe_debug_pub.add('Adjust_workflow_node: ' || 'p_config_line_id = ' || p_config_line_id, 5);
255: oe_debug_pub.add('Adjust_workflow_node: ' || 'p_can_create_supply = ' || p_can_create_supply, 5);
256: END IF;
257:

Line 254: oe_debug_pub.add('Adjust_workflow_node: ' || 'p_config_line_id = ' || p_config_line_id, 5);

250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: IF PG_DEBUG <> 0 THEN
253: oe_debug_pub.add('Adjust_workflow_node: ' || 'Values passed in are as follows: ', 5);
254: oe_debug_pub.add('Adjust_workflow_node: ' || 'p_config_line_id = ' || p_config_line_id, 5);
255: oe_debug_pub.add('Adjust_workflow_node: ' || 'p_can_create_supply = ' || p_can_create_supply, 5);
256: END IF;
257:
258: CTO_WORKFLOW_API_PK.query_wf_activity_status(

Line 255: oe_debug_pub.add('Adjust_workflow_node: ' || 'p_can_create_supply = ' || p_can_create_supply, 5);

251:
252: IF PG_DEBUG <> 0 THEN
253: oe_debug_pub.add('Adjust_workflow_node: ' || 'Values passed in are as follows: ', 5);
254: oe_debug_pub.add('Adjust_workflow_node: ' || 'p_config_line_id = ' || p_config_line_id, 5);
255: oe_debug_pub.add('Adjust_workflow_node: ' || 'p_can_create_supply = ' || p_can_create_supply, 5);
256: END IF;
257:
258: CTO_WORKFLOW_API_PK.query_wf_activity_status(
259: p_itemtype => 'OEOL',

Line 275: oe_debug_pub.add('Adjust_workflow_node : Create Supply Order Eligible node status =' || l_cce_activity_status, 1);

271: p_activity_name => 'CREATE_SUPPLY_ORDER_ELIGIBLE',
272: p_activity_status => l_CCE_activity_status);
273:
274: If PG_DEBUG <> 0 then
275: oe_debug_pub.add('Adjust_workflow_node : Create Supply Order Eligible node status =' || l_cce_activity_status, 1);
276: oe_debug_pub.add('Adjust_workflow_node : Ship Line node status =' || l_ship_activity_status, 1);
277: End if;
278:
279: If p_can_create_supply = 'N' and l_CCE_activity_status = 'NOTIFIED' Then

Line 276: oe_debug_pub.add('Adjust_workflow_node : Ship Line node status =' || l_ship_activity_status, 1);

272: p_activity_status => l_CCE_activity_status);
273:
274: If PG_DEBUG <> 0 then
275: oe_debug_pub.add('Adjust_workflow_node : Create Supply Order Eligible node status =' || l_cce_activity_status, 1);
276: oe_debug_pub.add('Adjust_workflow_node : Ship Line node status =' || l_ship_activity_status, 1);
277: End if;
278:
279: If p_can_create_supply = 'N' and l_CCE_activity_status = 'NOTIFIED' Then
280:

Line 302: oe_debug_pub.add('Adjust_workflow_node: ' || 'Updating the shipping attributes..',1);

298: l_changed_attributes(1).released_status := 'N';
299: l_changed_attributes(1).action_flag := 'U';
300:
301: IF PG_DEBUG <> 0 THEN
302: oe_debug_pub.add('Adjust_workflow_node: ' || 'Updating the shipping attributes..',1);
303: End if;
304:
305: lStmtNumber := 50;
306:

Line 314: oe_debug_pub.add('Adjust_workflow_node: ' || 'CTO:Failed in WSH_INTERFACE.update_shipping_attributes :', 1);

310: x_return_status => x_return_status);
311:
312: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
313: IF PG_DEBUG <> 0 THEN
314: oe_debug_pub.add('Adjust_workflow_node: ' || 'CTO:Failed in WSH_INTERFACE.update_shipping_attributes :', 1);
315: END IF;
316: OE_MSG_PUB.ADD;
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: ELSE

Line 320: oe_debug_pub.add('Adjust_workflow_node: ' || ' Success in update_shipping attributes..', 2);

316: OE_MSG_PUB.ADD;
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: ELSE
319: IF PG_DEBUG <> 0 THEN
320: oe_debug_pub.add('Adjust_workflow_node: ' || ' Success in update_shipping attributes..', 2);
321: END IF;
322: END IF ;
323:
324: end if; -- bugfix 3076061 Get_Code_Release_Level

Line 338: oe_debug_pub.add('Adjust_workflow_node: ' || 'Processing done. exiting...', 5);

334: end if; -- if p_can_cto_create_supply
335:
336:
337: IF PG_DEBUG <> 0 THEN
338: oe_debug_pub.add('Adjust_workflow_node: ' || 'Processing done. exiting...', 5);
339: END IF;
340:
341: Exception
342:

Line 346: oe_debug_pub.add('Adjust_workflow_node: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber), 1);

342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: IF PG_DEBUG <> 0 THEN
346: oe_debug_pub.add('Adjust_workflow_node: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber), 1);
347: END IF;
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 352: oe_debug_pub.add('Adjust_workflow_node: ' || 'UnExpected error. Last stmt executed is ..' || to_char(lStmtNumber) || ' ' || sqlerrm, 1);

348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: IF PG_DEBUG <> 0 THEN
352: oe_debug_pub.add('Adjust_workflow_node: ' || 'UnExpected error. Last stmt executed is ..' || to_char(lStmtNumber) || ' ' || sqlerrm, 1);
353: END IF;
354:
355: when others then
356: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 358: oe_debug_pub.add('Adjust_workflow_node: ' || 'When others exception ..Last stmt executed is ..' || to_char(lStmtNumber) || ' ' || sqlerrm, 1);

354:
355: when others then
356: x_return_status := fnd_api.g_ret_sts_unexp_error;
357: IF PG_DEBUG <> 0 THEN
358: oe_debug_pub.add('Adjust_workflow_node: ' || 'When others exception ..Last stmt executed is ..' || to_char(lStmtNumber) || ' ' || sqlerrm, 1);
359: END IF;
360:
361: End Adjust_workflow_node;
362:

Line 459: oe_debug_pub.add('Change_Notify: ' || 'Inside CTO_NOTIFICATION procedure change_notify.',1);

455: BEGIN
456:
457: X_return_status := FND_API.G_RET_STS_SUCCESS;
458: IF PG_DEBUG <> 0 THEN
459: oe_debug_pub.add('Change_Notify: ' || 'Inside CTO_NOTIFICATION procedure change_notify.',1);
460:
461: oe_debug_pub.add('Change_Notify: ' || 'Input Line id = '||to_char(pLineid),2);
462: END IF;
463:

Line 461: oe_debug_pub.add('Change_Notify: ' || 'Input Line id = '||to_char(pLineid),2);

457: X_return_status := FND_API.G_RET_STS_SUCCESS;
458: IF PG_DEBUG <> 0 THEN
459: oe_debug_pub.add('Change_Notify: ' || 'Inside CTO_NOTIFICATION procedure change_notify.',1);
460:
461: oe_debug_pub.add('Change_Notify: ' || 'Input Line id = '||to_char(pLineid),2);
462: END IF;
463:
464: -- OM is not able to handle the Config change in case of PTO-ATO Hybrid.
465: -- When the new option class or option item is added OM cannot identify

Line 485: oe_debug_pub.add('Change_Notify: ' || 'PChgtype array is NULL',2);

481: -- Bugfix 2420484 (Base bug 2418075 )
482: lStmtNumber := 2;
483: IF Pchgtype.COUNT = 0 THEN
484: IF PG_DEBUG <> 0 THEN
485: oe_debug_pub.add('Change_Notify: ' || 'PChgtype array is NULL',2);
486: END IF;
487: raise FND_API.G_EXC_UNEXPECTED_ERROR;
488: END IF;
489: -- Bugfix 2420484 (Base bug 2418075 )

Line 509: oe_debug_pub.add('Change_Notify: ' || 'This is PTO-ATO-Create new lines case....',3);

505: -- call our change_notify procedure recursivly.
506: -- This part of the code is added by Renga Kannan on 02/27/2001
507:
508: IF PG_DEBUG <> 0 THEN
509: oe_debug_pub.add('Change_Notify: ' || 'This is PTO-ATO-Create new lines case....',3);
510:
511: oe_debug_pub.add('Change_Notify: ' || 'Calling Pto_Ato_Config_wrapper procedure...',3);
512: END IF;
513: lStmtNumber := 5;

Line 511: oe_debug_pub.add('Change_Notify: ' || 'Calling Pto_Ato_Config_wrapper procedure...',3);

507:
508: IF PG_DEBUG <> 0 THEN
509: oe_debug_pub.add('Change_Notify: ' || 'This is PTO-ATO-Create new lines case....',3);
510:
511: oe_debug_pub.add('Change_Notify: ' || 'Calling Pto_Ato_Config_wrapper procedure...',3);
512: END IF;
513: lStmtNumber := 5;
514: Pto_Ato_config_wrapper(
515: Pchgtype => Pchgtype,

Line 521: oe_debug_pub.add('Change_Notify: ' || 'Pto_Ato_Config_Wrapper Procedure returned with status '||X_return_status,1);

517: X_Msg_Count => X_Msg_count,
518: X_Msg_Data => X_Msg_data);
519:
520: IF PG_DEBUG <> 0 THEN
521: oe_debug_pub.add('Change_Notify: ' || 'Pto_Ato_Config_Wrapper Procedure returned with status '||X_return_status,1);
522: END IF;
523:
524: if X_return_status = FND_API.G_RET_STS_ERROR then
525: IF PG_DEBUG <> 0 THEN

Line 526: oe_debug_pub.add ('Change_Notify: ' || 'Failed in Pto_Ato_config_wrapper with expected error.', 1);

522: END IF;
523:
524: if X_return_status = FND_API.G_RET_STS_ERROR then
525: IF PG_DEBUG <> 0 THEN
526: oe_debug_pub.add ('Change_Notify: ' || 'Failed in Pto_Ato_config_wrapper with expected error.', 1);
527: END IF;
528: raise FND_API.G_EXC_ERROR;
529:
530: elsif X_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

Line 532: oe_debug_pub.add ('Change_Notify: ' || 'Failed in Pto_Ato_config_wrapper with unexpected error.', 1);

528: raise FND_API.G_EXC_ERROR;
529:
530: elsif X_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
531: IF PG_DEBUG <> 0 THEN
532: oe_debug_pub.add ('Change_Notify: ' || 'Failed in Pto_Ato_config_wrapper with unexpected error.', 1);
533: END IF;
534: raise FND_API.G_EXC_UNEXPECTED_ERROR;
535: end if;
536:

Line 597: oe_debug_pub.add('Change_Notify: ' || 'This is ATO ITEM Case..',3);

593:
594: lconfig_line_id := PLineid; -- In case of ATO item both config id and model id are same
595:
596: IF PG_DEBUG <> 0 THEN
597: oe_debug_pub.add('Change_Notify: ' || 'This is ATO ITEM Case..',3);
598: END IF;
599:
600: EXCEPTION
601: WHEN NO_DATA_FOUND THEN

Line 605: oe_debug_pub.add('Change_Notify: ' || 'This is ATO MODEL Case..',3);

601: WHEN NO_DATA_FOUND THEN
602:
603: lato_item_flag := 'N';
604: IF PG_DEBUG <> 0 THEN
605: oe_debug_pub.add('Change_Notify: ' || 'This is ATO MODEL Case..',3);
606: END IF;
607: END;
608:
609: lStmtNumber := 20;

Line 620: oe_debug_pub.add('Change_Notify: ' || 'Config item does not exists , No action needed...',3);

616: AND CTO_WORKFLOW.config_line_exists(pLineid) <> TRUE
617: THEN
618:
619: IF PG_DEBUG <> 0 THEN
620: oe_debug_pub.add('Change_Notify: ' || 'Config item does not exists , No action needed...',3);
621: END IF;
622: x_return_status := FND_API.G_RET_STS_SUCCESS;
623:
624: return;

Line 648: oe_debug_pub.add('Change_Notify: ' || 'Config item id = '||to_char(lconfig_id),3);

644: WHERE ato_line_id = plineid
645: AND item_type_code = 'CONFIG';
646:
647: IF PG_DEBUG <> 0 THEN
648: oe_debug_pub.add('Change_Notify: ' || 'Config item id = '||to_char(lconfig_id),3);
649:
650: oe_debug_pub.add('Change_Notify: ' || 'Config line id = '||to_char(lconfig_line_id),3);
651: END IF;
652:

Line 650: oe_debug_pub.add('Change_Notify: ' || 'Config line id = '||to_char(lconfig_line_id),3);

646:
647: IF PG_DEBUG <> 0 THEN
648: oe_debug_pub.add('Change_Notify: ' || 'Config item id = '||to_char(lconfig_id),3);
649:
650: oe_debug_pub.add('Change_Notify: ' || 'Config line id = '||to_char(lconfig_line_id),3);
651: END IF;
652:
653: ELSE
654: IF PG_DEBUG <> 0 THEN

Line 655: oe_debug_pub.add('Change_Notify: ' || 'ATO item id = '||to_char(lconfig_id),3);

651: END IF;
652:
653: ELSE
654: IF PG_DEBUG <> 0 THEN
655: oe_debug_pub.add('Change_Notify: ' || 'ATO item id = '||to_char(lconfig_id),3);
656:
657: oe_debug_pub.add('Change_Notify: ' || 'ATO line id = '||to_char(lconfig_line_id),3);
658: END IF;
659:

Line 657: oe_debug_pub.add('Change_Notify: ' || 'ATO line id = '||to_char(lconfig_line_id),3);

653: ELSE
654: IF PG_DEBUG <> 0 THEN
655: oe_debug_pub.add('Change_Notify: ' || 'ATO item id = '||to_char(lconfig_id),3);
656:
657: oe_debug_pub.add('Change_Notify: ' || 'ATO line id = '||to_char(lconfig_line_id),3);
658: END IF;
659:
660: END IF;
661:

Line 673: oe_debug_pub.add('Change_Notify: ' || 'Change type #'||to_char(pchgtype(i).change_type),3);

669: LOOP
670: IF (pchgtype.exists(i)) THEN
671:
672: IF PG_DEBUG <> 0 THEN
673: oe_debug_pub.add('Change_Notify: ' || 'Change type #'||to_char(pchgtype(i).change_type),3);
674:
675: oe_debug_pub.add('Change_Notify: ' || 'Old value = '||pchgtype(i).old_value,3);
676:
677: oe_debug_pub.add('Change_Notify: ' || 'New Value = '||pchgtype(i).new_value,3);

Line 675: oe_debug_pub.add('Change_Notify: ' || 'Old value = '||pchgtype(i).old_value,3);

671:
672: IF PG_DEBUG <> 0 THEN
673: oe_debug_pub.add('Change_Notify: ' || 'Change type #'||to_char(pchgtype(i).change_type),3);
674:
675: oe_debug_pub.add('Change_Notify: ' || 'Old value = '||pchgtype(i).old_value,3);
676:
677: oe_debug_pub.add('Change_Notify: ' || 'New Value = '||pchgtype(i).new_value,3);
678: END IF;
679:

Line 677: oe_debug_pub.add('Change_Notify: ' || 'New Value = '||pchgtype(i).new_value,3);

673: oe_debug_pub.add('Change_Notify: ' || 'Change type #'||to_char(pchgtype(i).change_type),3);
674:
675: oe_debug_pub.add('Change_Notify: ' || 'Old value = '||pchgtype(i).old_value,3);
676:
677: oe_debug_pub.add('Change_Notify: ' || 'New Value = '||pchgtype(i).new_value,3);
678: END IF;
679:
680: IF pchgtype(i).change_type = CTO_CHANGE_ORDER_PK.SSD_CHANGE THEN
681:

Line 683: oe_debug_pub.add('Change_Notify: ' || 'Unschedule case ' ,3);

679:
680: IF pchgtype(i).change_type = CTO_CHANGE_ORDER_PK.SSD_CHANGE THEN
681:
682: if( pchgtype(i).new_value is null ) then
683: oe_debug_pub.add('Change_Notify: ' || 'Unschedule case ' ,3);
684: l_unschedule_action := TRUE ;
685: l_req_change_details.unschedule_action_flag := TRUE;
686: --l_req_change_details.new_ssd_date := 'NULL';
687: else

Line 688: oe_debug_pub.add('Change_Notify: ' || 'Date change case ' ,3);

684: l_unschedule_action := TRUE ;
685: l_req_change_details.unschedule_action_flag := TRUE;
686: --l_req_change_details.new_ssd_date := 'NULL';
687: else
688: oe_debug_pub.add('Change_Notify: ' || 'Date change case ' ,3);
689:
690: l_req_change_details.date_change_flag := TRUE;
691: -- rkaza. note that a varchar2 is directly assigned to a date.
692: -- This assumes that the varchar2 string is in default date

Line 707: oe_debug_pub.add('Change_Notify: ' || 'Warehouse change ' ,3);

703: IF pchgtype(i).change_type = CTO_CHANGE_ORDER_PK.WAREHOUSE_CHANGE THEN
704:
705: if( pchgtype(i).new_value is not null ) then
706:
707: oe_debug_pub.add('Change_Notify: ' || 'Warehouse change ' ,3);
708: oe_debug_pub.add('Change_Notify: ' ||' Old ship from org = '||pchgtype(i).old_value,3);
709: oe_debug_pub.add('Change_Notify: ' ||' New ship from org = '||pchgtype(i).new_value,3);
710:
711: l_warehouse_change := TRUE ;

Line 708: oe_debug_pub.add('Change_Notify: ' ||' Old ship from org = '||pchgtype(i).old_value,3);

704:
705: if( pchgtype(i).new_value is not null ) then
706:
707: oe_debug_pub.add('Change_Notify: ' || 'Warehouse change ' ,3);
708: oe_debug_pub.add('Change_Notify: ' ||' Old ship from org = '||pchgtype(i).old_value,3);
709: oe_debug_pub.add('Change_Notify: ' ||' New ship from org = '||pchgtype(i).new_value,3);
710:
711: l_warehouse_change := TRUE ;
712:

Line 709: oe_debug_pub.add('Change_Notify: ' ||' New ship from org = '||pchgtype(i).new_value,3);

705: if( pchgtype(i).new_value is not null ) then
706:
707: oe_debug_pub.add('Change_Notify: ' || 'Warehouse change ' ,3);
708: oe_debug_pub.add('Change_Notify: ' ||' Old ship from org = '||pchgtype(i).old_value,3);
709: oe_debug_pub.add('Change_Notify: ' ||' New ship from org = '||pchgtype(i).new_value,3);
710:
711: l_warehouse_change := TRUE ;
712:
713: -- Fix for the FP bug 4103806

Line 727: oe_debug_pub.add('Change_notify : Item is option specific.. Validating ship org',1);

723: and rownum = 1;
724:
725: If l_option_specific is not null Then
726:
727: oe_debug_pub.add('Change_notify : Item is option specific.. Validating ship org',1);
728:
729: begin
730:
731: -- The following sql looks at the sourcing assignment for the item and

Line 748: oe_debug_pub.add('Change_Notify : New ship from org '||pchgtype(i).new_value||' is valid..',1);

744: and ( assg.organization_id = pchgtype(i).new_value
745: or src.source_organization_id = pchgtype(i).new_value)
746: and rownum =1;
747:
748: oe_debug_pub.add('Change_Notify : New ship from org '||pchgtype(i).new_value||' is valid..',1);
749:
750: Exception When No_data_found then
751: oe_debug_pub.add('Change Notify: New Ship from org '||pchgtype(i).new_value||' is not valid',1);
752: l_valid_ship_from_org := 'N';

Line 751: oe_debug_pub.add('Change Notify: New Ship from org '||pchgtype(i).new_value||' is not valid',1);

747:
748: oe_debug_pub.add('Change_Notify : New ship from org '||pchgtype(i).new_value||' is valid..',1);
749:
750: Exception When No_data_found then
751: oe_debug_pub.add('Change Notify: New Ship from org '||pchgtype(i).new_value||' is not valid',1);
752: l_valid_ship_from_org := 'N';
753: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');
754: raise FND_API.G_EXC_ERROR;
755: End;

Line 757: oe_debug_pub.add('Change_Notify : Item is not option Specific...',1);

753: CTO_MSG_PUB.cto_message('BOM','CTO_OSS_INVALID_SHIP_ORG');
754: raise FND_API.G_EXC_ERROR;
755: End;
756: Else
757: oe_debug_pub.add('Change_Notify : Item is not option Specific...',1);
758: End if;
759: -- End of Fix for the FP bug 4103806
760:
761: else

Line 763: oe_debug_pub.add('Change_Notify: ' || 'Warehouse change null ' ,3);

759: -- End of Fix for the FP bug 4103806
760:
761: else
762:
763: oe_debug_pub.add('Change_Notify: ' || 'Warehouse change null ' ,3);
764:
765: end if;
766:
767: END IF ;

Line 774: oe_debug_pub.add('Change_Notify: ' || 'Configuration is changed..',3);

770:
771:
772: IF pchgtype(i).change_type = CTO_CHANGE_ORDER_PK.CONFIG_CHANGE THEN
773: IF PG_DEBUG <> 0 THEN
774: oe_debug_pub.add('Change_Notify: ' || 'Configuration is changed..',3);
775: oe_debug_pub.add('Change_Notify: ' || 'Configuration is changed..' || poptionchgdtls.count ,3);
776: END IF;
777:
778:

Line 775: oe_debug_pub.add('Change_Notify: ' || 'Configuration is changed..' || poptionchgdtls.count ,3);

771:
772: IF pchgtype(i).change_type = CTO_CHANGE_ORDER_PK.CONFIG_CHANGE THEN
773: IF PG_DEBUG <> 0 THEN
774: oe_debug_pub.add('Change_Notify: ' || 'Configuration is changed..',3);
775: oe_debug_pub.add('Change_Notify: ' || 'Configuration is changed..' || poptionchgdtls.count ,3);
776: END IF;
777:
778:
779: /* Added by Sushant for Decimal-Qty Support for Option Items */

Line 788: oe_debug_pub.add('Change_Notify: ' || 'Going to check old and new qty..',3);

784:
785:
786:
787: IF PG_DEBUG <> 0 THEN
788: oe_debug_pub.add('Change_Notify: ' || 'Going to check old and new qty..',3);
789: oe_debug_pub.add('Change_Notify: ' || 'first..' || poptionchgdtls.first
790: || ' last ' || poptionchgdtls.last ,3);
791: END IF;
792:

Line 789: oe_debug_pub.add('Change_Notify: ' || 'first..' || poptionchgdtls.first

785:
786:
787: IF PG_DEBUG <> 0 THEN
788: oe_debug_pub.add('Change_Notify: ' || 'Going to check old and new qty..',3);
789: oe_debug_pub.add('Change_Notify: ' || 'first..' || poptionchgdtls.first
790: || ' last ' || poptionchgdtls.last ,3);
791: END IF;
792:
793:

Line 798: oe_debug_pub.add('Change_Notify: ' || 'first..' || v_options_index , 1 );

794: v_options_index := poptionchgdtls.first ;
795:
796: -- for v_options in 1..PoptionChgDtls.count
797:
798: oe_debug_pub.add('Change_Notify: ' || 'first..' || v_options_index , 1 );
799:
800: while( v_options_index is not null )
801: loop
802:

Line 804: oe_debug_pub.add('Change_Notify: ' || 'old qty ' || PoptionChgDtls(v_options_index).old_qty ,3);

800: while( v_options_index is not null )
801: loop
802:
803: IF PG_DEBUG <> 0 THEN
804: oe_debug_pub.add('Change_Notify: ' || 'old qty ' || PoptionChgDtls(v_options_index).old_qty ,3);
805: oe_debug_pub.add('Change_Notify: ' || 'new qty ' || PoptionChgDtls(v_options_index).new_qty ,3);
806: END IF;
807:
808: oe_debug_pub.add('Change_Notify: actual new qty ' || Round( NVL(PoptionChgDtls(v_options_index).new_qty, 0 ) , 7 ), 1 ) ;

Line 805: oe_debug_pub.add('Change_Notify: ' || 'new qty ' || PoptionChgDtls(v_options_index).new_qty ,3);

801: loop
802:
803: IF PG_DEBUG <> 0 THEN
804: oe_debug_pub.add('Change_Notify: ' || 'old qty ' || PoptionChgDtls(v_options_index).old_qty ,3);
805: oe_debug_pub.add('Change_Notify: ' || 'new qty ' || PoptionChgDtls(v_options_index).new_qty ,3);
806: END IF;
807:
808: oe_debug_pub.add('Change_Notify: actual new qty ' || Round( NVL(PoptionChgDtls(v_options_index).new_qty, 0 ) , 7 ), 1 ) ;
809:

Line 808: oe_debug_pub.add('Change_Notify: actual new qty ' || Round( NVL(PoptionChgDtls(v_options_index).new_qty, 0 ) , 7 ), 1 ) ;

804: oe_debug_pub.add('Change_Notify: ' || 'old qty ' || PoptionChgDtls(v_options_index).old_qty ,3);
805: oe_debug_pub.add('Change_Notify: ' || 'new qty ' || PoptionChgDtls(v_options_index).new_qty ,3);
806: END IF;
807:
808: oe_debug_pub.add('Change_Notify: actual new qty ' || Round( NVL(PoptionChgDtls(v_options_index).new_qty, 0 ) , 7 ), 1 ) ;
809:
810: oe_debug_pub.add('Change_Notify: actual old qty ' || Round( NVL(PoptionChgDtls(v_options_index).old_qty, 0 ) , 7 ), 1 ) ;
811:
812: if ( Round( NVL( PoptionChgDtls(v_options_index).new_qty , 0 ) , 7 ) <>

Line 810: oe_debug_pub.add('Change_Notify: actual old qty ' || Round( NVL(PoptionChgDtls(v_options_index).old_qty, 0 ) , 7 ), 1 ) ;

806: END IF;
807:
808: oe_debug_pub.add('Change_Notify: actual new qty ' || Round( NVL(PoptionChgDtls(v_options_index).new_qty, 0 ) , 7 ), 1 ) ;
809:
810: oe_debug_pub.add('Change_Notify: actual old qty ' || Round( NVL(PoptionChgDtls(v_options_index).old_qty, 0 ) , 7 ), 1 ) ;
811:
812: if ( Round( NVL( PoptionChgDtls(v_options_index).new_qty , 0 ) , 7 ) <>
813: Round( NVL( PoptionChgDtls(v_options_index).old_qty , 0 ) , 7 ) ) then
814: lconfig_change := TRUE ;

Line 817: oe_debug_pub.add('Change_Notify: actual Decimal Change ' , 1 ) ;

813: Round( NVL( PoptionChgDtls(v_options_index).old_qty , 0 ) , 7 ) ) then
814: lconfig_change := TRUE ;
815: l_req_change_details.config_change_flag := TRUE;
816: l_decimal_qty := TRUE ;
817: oe_debug_pub.add('Change_Notify: actual Decimal Change ' , 1 ) ;
818:
819: exit ;
820: end if;
821:

Line 826: oe_debug_pub.add('Change_Notify: ' || 'next..' || v_options_index , 1 );

822:
823: v_options_index := poptionchgdtls.next(v_options_index);
824:
825:
826: oe_debug_pub.add('Change_Notify: ' || 'next..' || v_options_index , 1 );
827:
828:
829:
830: end loop;

Line 835: oe_debug_pub.add('Change_Notify: ' || 'PoptionChgDtls count is 0 ..',3);

831:
832:
833: else /* backward compatibility for pre-patchset J OM code */
834: IF PG_DEBUG <> 0 THEN
835: oe_debug_pub.add('Change_Notify: ' || 'PoptionChgDtls count is 0 ..',3);
836: END IF;
837:
838: lconfig_change := TRUE;
839: l_req_change_details.config_change_flag := TRUE;

Line 851: oe_debug_pub.add('Change_Notify: ' || 'Line is cancelled..',3);

847: ELSIF pchgtype(i).change_type = CTO_CHANGE_ORDER_PK.QTY_CHANGE and to_number(pchgtype(i).new_value) = 0 THEN
848: lcancel_line := TRUE;
849: l_req_change_details.cancel_line_flag := TRUE;
850: IF PG_DEBUG <> 0 THEN
851: oe_debug_pub.add('Change_Notify: ' || 'Line is cancelled..',3);
852: END IF;
853:
854: ELSIF pchgtype(i).change_type = CTO_CHANGE_ORDER_PK.QTY_CHANGE THEN
855: lqty_change := TRUE;

Line 859: oe_debug_pub.add('Change_Notify: ' || 'Quantity is changed..',3);

855: lqty_change := TRUE;
856: l_req_change_details.qty_change_flag := TRUE;
857: l_req_change_details.new_order_qty := to_number(pchgtype(i).new_value);
858: IF PG_DEBUG <> 0 THEN
859: oe_debug_pub.add('Change_Notify: ' || 'Quantity is changed..',3);
860: END IF;
861:
862:
863:

Line 871: oe_debug_pub.add('Change_Notify: ' || 'first..' || v_splits_index , 1 );

867:
868: v_splits_index := psplitdtls.first ;
869:
870:
871: oe_debug_pub.add('Change_Notify: ' || 'first..' || v_splits_index , 1 );
872:
873: while( v_splits_index is not null )
874: loop
875:

Line 877: oe_debug_pub.add('Change_Notify: split line id ' || 'line id ' ||

873: while( v_splits_index is not null )
874: loop
875:
876: IF PG_DEBUG <> 0 THEN
877: oe_debug_pub.add('Change_Notify: split line id ' || 'line id ' ||
878: PsplitDtls(v_splits_index).line_id ,3);
879: END IF;
880:
881:

Line 882: oe_debug_pub.add('Change_Notify: ' || 'calling split line ' , 1 );

878: PsplitDtls(v_splits_index).line_id ,3);
879: END IF;
880:
881:
882: oe_debug_pub.add('Change_Notify: ' || 'calling split line ' , 1 );
883:
884: cto_utility_pk.split_line( psplitdtls(v_splits_index).line_id,
885: x_return_status => x_return_status,
886: X_Msg_Count => x_Msg_Count,

Line 890: oe_debug_pub.add('Change_Notify: ' || 'done split line ' , 1 );

886: X_Msg_Count => x_Msg_Count,
887: x_Msg_data => x_Msg_data);
888:
889:
890: oe_debug_pub.add('Change_Notify: ' || 'done split line ' , 1 );
891:
892:
893:
894: v_splits_index := psplitdtls.next(v_splits_index);

Line 897: oe_debug_pub.add('Change_Notify: ' || 'next..' || v_splits_index , 1 );

893:
894: v_splits_index := psplitdtls.next(v_splits_index);
895:
896:
897: oe_debug_pub.add('Change_Notify: ' || 'next..' || v_splits_index , 1 );
898:
899:
900:
901: end loop;

Line 904: oe_debug_pub.add('Change_Notify: ' || 'calling adjust_bcol..' || pLineId , 1 );

900:
901: end loop;
902:
903:
904: oe_debug_pub.add('Change_Notify: ' || 'calling adjust_bcol..' || pLineId , 1 );
905:
906: cto_utility_pk.adjust_bcol_for_split( p_ato_line_id => pLineId,
907: x_return_status => x_return_status,
908: X_Msg_Count => x_Msg_Count,

Line 923: oe_debug_pub.add('Change_Notify: ' || 'Secondary Quantity is changed..',3);

919: l_req_change_details.qty2_change_flag := TRUE;
920: l_req_change_details.new_order_qty2 := to_number(pchgtype(i).new_value);
921:
922: IF PG_DEBUG <> 0 THEN
923: oe_debug_pub.add('Change_Notify: ' || 'Secondary Quantity is changed..',3);
924: END IF;
925:
926: END IF;
927:

Line 937: oe_debug_pub.add('Change_Notify: ' || 'config change is true..',3);

933:
934:
935: if( lconfig_change ) then
936:
937: oe_debug_pub.add('Change_Notify: ' || 'config change is true..',3);
938:
939: else
940:
941: oe_debug_pub.add('Change_Notify: ' || 'config change is false..',3);

Line 941: oe_debug_pub.add('Change_Notify: ' || 'config change is false..',3);

937: oe_debug_pub.add('Change_Notify: ' || 'config change is true..',3);
938:
939: else
940:
941: oe_debug_pub.add('Change_Notify: ' || 'config change is false..',3);
942:
943: end if ;
944:
945:

Line 960: oe_debug_pub.add('Change_Notify: ' || 'Checking started...order #'||to_char(lorder_no),3);

956: WHERE header_id = lheader_id;
957:
958:
959: IF PG_DEBUG <> 0 THEN
960: oe_debug_pub.add('Change_Notify: ' || 'Checking started...order #'||to_char(lorder_no),3);
961: END IF;
962:
963:
964: -- rkaza. ireq project. 05/10/2005.

Line 982: oe_debug_pub.add('Change_notify: ' || 'success from check_cto_can_create_supply', 5);

978: x_message => l_message); --opm
979:
980: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
981: IF PG_DEBUG <> 0 THEN
982: oe_debug_pub.add('Change_notify: ' || 'success from check_cto_can_create_supply', 5);
983: oe_debug_pub.add('Change_notify: ' || 'source_type = ' || x_source_type, 5);
984: oe_debug_pub.add('Change_notify: ' || 'sourcing_org = ' || l_sourcing_org, 5);
985: oe_debug_pub.add('Change_notify: ' || 'l_can_create_supply = ' || l_can_create_supply, 5);
986: END IF;

Line 983: oe_debug_pub.add('Change_notify: ' || 'source_type = ' || x_source_type, 5);

979:
980: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
981: IF PG_DEBUG <> 0 THEN
982: oe_debug_pub.add('Change_notify: ' || 'success from check_cto_can_create_supply', 5);
983: oe_debug_pub.add('Change_notify: ' || 'source_type = ' || x_source_type, 5);
984: oe_debug_pub.add('Change_notify: ' || 'sourcing_org = ' || l_sourcing_org, 5);
985: oe_debug_pub.add('Change_notify: ' || 'l_can_create_supply = ' || l_can_create_supply, 5);
986: END IF;
987: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 984: oe_debug_pub.add('Change_notify: ' || 'sourcing_org = ' || l_sourcing_org, 5);

980: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
981: IF PG_DEBUG <> 0 THEN
982: oe_debug_pub.add('Change_notify: ' || 'success from check_cto_can_create_supply', 5);
983: oe_debug_pub.add('Change_notify: ' || 'source_type = ' || x_source_type, 5);
984: oe_debug_pub.add('Change_notify: ' || 'sourcing_org = ' || l_sourcing_org, 5);
985: oe_debug_pub.add('Change_notify: ' || 'l_can_create_supply = ' || l_can_create_supply, 5);
986: END IF;
987: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
988: IF PG_DEBUG <> 0 THEN

Line 985: oe_debug_pub.add('Change_notify: ' || 'l_can_create_supply = ' || l_can_create_supply, 5);

981: IF PG_DEBUG <> 0 THEN
982: oe_debug_pub.add('Change_notify: ' || 'success from check_cto_can_create_supply', 5);
983: oe_debug_pub.add('Change_notify: ' || 'source_type = ' || x_source_type, 5);
984: oe_debug_pub.add('Change_notify: ' || 'sourcing_org = ' || l_sourcing_org, 5);
985: oe_debug_pub.add('Change_notify: ' || 'l_can_create_supply = ' || l_can_create_supply, 5);
986: END IF;
987: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
988: IF PG_DEBUG <> 0 THEN
989: oe_debug_pub.add('Change_notify: ' || 'Expected error in check_cto_can_create_supply', 1);

Line 989: oe_debug_pub.add('Change_notify: ' || 'Expected error in check_cto_can_create_supply', 1);

985: oe_debug_pub.add('Change_notify: ' || 'l_can_create_supply = ' || l_can_create_supply, 5);
986: END IF;
987: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
988: IF PG_DEBUG <> 0 THEN
989: oe_debug_pub.add('Change_notify: ' || 'Expected error in check_cto_can_create_supply', 1);
990: END IF;
991: raise FND_API.G_EXC_ERROR;
992: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: IF PG_DEBUG <> 0 THEN

Line 994: oe_debug_pub.add('Change_notify: ' || 'Unexpected error in check_cto_can_create_supply', 1);

990: END IF;
991: raise FND_API.G_EXC_ERROR;
992: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: IF PG_DEBUG <> 0 THEN
994: oe_debug_pub.add('Change_notify: ' || 'Unexpected error in check_cto_can_create_supply', 1);
995: END IF;
996: raise FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF;
998:

Line 1040: oe_debug_pub.add('Change_Notify: ' || 'Config change.. Calling delink function...',3);

1036: lStmtNumber := 40;
1037:
1038: -- Delink the configuration item
1039: IF PG_DEBUG <> 0 THEN
1040: oe_debug_pub.add('Change_Notify: ' || 'Config change.. Calling delink function...',3);
1041: END IF;
1042:
1043: -- Added by Renga Kannan
1044: -- The Following Pkg varibale is sest to 1 to notify the delink pkg that the call is coming

Line 1060: oe_debug_pub.add('Change_Notify: ' || 'Delink failed....',5);

1056: -- Re-initialize the pkg variable
1057:
1058: CTO_CHANGE_ORDER_PK.CHANGE_ORDER_PK_STATE := 0;
1059: IF PG_DEBUG <> 0 THEN
1060: oe_debug_pub.add('Change_Notify: ' || 'Delink failed....',5);
1061: END IF;
1062:
1063: CTO_MSG_PUB.cto_message('BOM',x_err_name);
1064: raise FND_API.G_EXC_ERROR;

Line 1090: oe_debug_pub.add('Change_Notify: ' || 'Not sending notification. Either drop ship or decimal qty beyond 7 digits',3);

1086: -- if the option item qty change is beyond the 7 digits.
1087:
1088: if l_source_type_code = 'EXTERNAL' or l_decimal_qty = FALSE then
1089: notify_flag := FALSE;
1090: oe_debug_pub.add('Change_Notify: ' || 'Not sending notification. Either drop ship or decimal qty beyond 7 digits',3);
1091: end if;
1092:
1093: lStmtNumber := 70;
1094:

Line 1098: oe_debug_pub.add('Change_Notify: ' || 'Calling the notification...',3);

1094:
1095: if notify_flag then
1096:
1097: IF PG_DEBUG <> 0 THEN
1098: oe_debug_pub.add('Change_Notify: ' || 'Calling the notification...',3);
1099: END IF;
1100:
1101: start_work_flow(porder_no =>lorder_no,
1102: pline_no =>plineid,

Line 1113: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with expected error.', 1);

1109: pSplitDtls => pSplitDtls );
1110:
1111: if X_Return_Status = FND_API.G_RET_STS_ERROR then
1112: IF PG_DEBUG <> 0 THEN
1113: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with expected error.', 1);
1114: END IF;
1115: raise FND_API.G_EXC_ERROR;
1116:
1117: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then

Line 1119: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with unexpected error.', 1);

1115: raise FND_API.G_EXC_ERROR;
1116:
1117: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
1118: IF PG_DEBUG <> 0 THEN
1119: oe_debug_pub.add ('Change_Notify: ' || 'Failed in start_work_flow with unexpected error.', 1);
1120: END IF;
1121: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1122: end if;
1123:

Line 1187: oe_debug_pub.add('Change_Notify: ' || ' Return value from display_wf_status = '|| return_value,3);

1183: x_source_type in (1, 3))
1184: then
1185: return_value := CTO_WORKFLOW_API_PK.display_wf_status(Lconfig_line_id);
1186: IF PG_DEBUG <> 0 THEN
1187: oe_debug_pub.add('Change_Notify: ' || ' Return value from display_wf_status = '|| return_value,3);
1188: END IF;
1189: end if;
1190:
1191: EXCEPTION

Line 1194: oe_debug_pub.add('Change_Notify: ' || 'Expected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);

1190:
1191: EXCEPTION
1192: WHEN FND_API.G_EXC_ERROR THEN
1193: IF PG_DEBUG <> 0 THEN
1194: oe_debug_pub.add('Change_Notify: ' || 'Expected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1195: END IF;
1196: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
1197: p_msg_data => X_Msg_Data);
1198: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1203: oe_debug_pub.add('Change_Notify: ' || 'UnExpected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);

1199:
1200:
1201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1202: IF PG_DEBUG <> 0 THEN
1203: oe_debug_pub.add('Change_Notify: ' || 'UnExpected error in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1204: END IF;
1205: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
1206: p_msg_data => X_Msg_Data);
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1212: oe_debug_pub.add('Change_Notify: ' || 'OTHERS excepn in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);

1208:
1209:
1210: WHEN OTHERS THEN
1211: IF PG_DEBUG <> 0 THEN
1212: oe_debug_pub.add('Change_Notify: ' || 'OTHERS excepn in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1213:
1214: oe_debug_pub.add('Change_Notify: ' || 'The error message is ..'||sqlerrm,2);
1215: END IF;
1216: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 1214: oe_debug_pub.add('Change_Notify: ' || 'The error message is ..'||sqlerrm,2);

1210: WHEN OTHERS THEN
1211: IF PG_DEBUG <> 0 THEN
1212: oe_debug_pub.add('Change_Notify: ' || 'OTHERS excepn in CHANGE_NOTIFY. Last stmt executed is ..'|| to_char(lStmtNumber),1);
1213:
1214: oe_debug_pub.add('Change_Notify: ' || 'The error message is ..'||sqlerrm,2);
1215: END IF;
1216: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
1217: p_msg_data => X_Msg_Data);
1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1242: oe_debug_pub.add('Reservation_Exists: ' || 'Entering into Reservation_exists procedure....',1);

1238:
1239: BEGIN
1240:
1241: IF PG_DEBUG <> 0 THEN
1242: oe_debug_pub.add('Reservation_Exists: ' || 'Entering into Reservation_exists procedure....',1);
1243: END IF;
1244: -- Check if flow schedule exists . If not check some inv/work order Reservation
1245: -- exists. If both of them does'nt exists then return false. Other wise return true.
1246:

Line 1250: oe_debug_pub.add('Reservation_Exists: ' || 'flow Reservation not exists..',5);

1246:
1247: IF CTO_WORKFLOW.flow_sch_exists(pconfigLineId) <> TRUE THEN
1248:
1249: IF PG_DEBUG <> 0 THEN
1250: oe_debug_pub.add('Reservation_Exists: ' || 'flow Reservation not exists..',5);
1251:
1252: oe_debug_pub.add('Reservation_Exists: ' || 'The line_id passed for reservation = '||to_char(pconfiglineid),5);
1253: END IF;
1254:

Line 1252: oe_debug_pub.add('Reservation_Exists: ' || 'The line_id passed for reservation = '||to_char(pconfiglineid),5);

1248:
1249: IF PG_DEBUG <> 0 THEN
1250: oe_debug_pub.add('Reservation_Exists: ' || 'flow Reservation not exists..',5);
1251:
1252: oe_debug_pub.add('Reservation_Exists: ' || 'The line_id passed for reservation = '||to_char(pconfiglineid),5);
1253: END IF;
1254:
1255: SELECT reservation_id
1256: INTO l_reservation_id

Line 1283: oe_debug_pub.add('Reservation_Exists: ' || 'Work order/Inv reservation Exists..',5);

1279: INV_RESERVATION_GLOBAL.g_source_type_oe) --bugfix 1799874
1280: and mr.reservation_quantity > 0
1281: and rownum = 1;
1282: IF PG_DEBUG <> 0 THEN
1283: oe_debug_pub.add('Reservation_Exists: ' || 'Work order/Inv reservation Exists..',5);
1284: END IF;
1285: END IF;
1286:
1287: x_result := TRUE;

Line 1293: oe_debug_pub.add('Reservation_Exists: ' || 'Coming out of reservation_exists procedure with FALSE...',2);

1289:
1290: EXCEPTION
1291: WHEN no_data_found THEN
1292: IF PG_DEBUG <> 0 THEN
1293: oe_debug_pub.add('Reservation_Exists: ' || 'Coming out of reservation_exists procedure with FALSE...',2);
1294: END IF;
1295: x_return_status := FND_API.G_RET_STS_SUCCESS;
1296: x_result := FALSE;
1297:

Line 1300: oe_debug_pub.add('Reservation_Exists: ' || 'OTHERS excpn occured in Reservation_Exists procedure..',2);

1296: x_result := FALSE;
1297:
1298: WHEN others THEN
1299: IF PG_DEBUG <> 0 THEN
1300: oe_debug_pub.add('Reservation_Exists: ' || 'OTHERS excpn occured in Reservation_Exists procedure..',2);
1301:
1302: oe_debug_pub.add('Reservation_Exists: ' || 'Error message is : '||sqlerrm,1);
1303: END IF;
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1302: oe_debug_pub.add('Reservation_Exists: ' || 'Error message is : '||sqlerrm,1);

1298: WHEN others THEN
1299: IF PG_DEBUG <> 0 THEN
1300: oe_debug_pub.add('Reservation_Exists: ' || 'OTHERS excpn occured in Reservation_Exists procedure..',2);
1301:
1302: oe_debug_pub.add('Reservation_Exists: ' || 'Error message is : '||sqlerrm,1);
1303: END IF;
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1305: x_result := FALSE;
1306:

Line 1472: oe_debug_pub.add('start_work_flow: ' || 'Inside procedure start_work_flow',5);

1468:
1469: lstmt := 10;
1470:
1471: IF PG_DEBUG <> 0 THEN
1472: oe_debug_pub.add('start_work_flow: ' || 'Inside procedure start_work_flow',5);
1473: END IF;
1474:
1475: --
1476: -- The Following Block of Statment will set the minimum attributes needed for the work flow

Line 1488: oe_debug_pub.add('start_work_flow: ' || 'Getting details from Oe_order_lines for line id '||to_char(pline_no),5);

1484: --
1485:
1486: lstmt := 20;
1487: IF PG_DEBUG <> 0 THEN
1488: oe_debug_pub.add('start_work_flow: ' || 'Getting details from Oe_order_lines for line id '||to_char(pline_no),5);
1489: END IF;
1490:
1491: SELECT
1492: schedule_ship_date,

Line 1553: oe_debug_pub.add('Start_workflow: Customer Name = '||lcustomer_name,1);

1549: AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
1550: AND oeh.header_id = l_header_id;
1551:
1552: if PG_DEBUG <> 0 then
1553: oe_debug_pub.add('Start_workflow: Customer Name = '||lcustomer_name,1);
1554: end if;
1555:
1556: -- rkaza. bug 4101723. 01/19/2005. Notification should be sent to the old
1557: -- org in case of warehouse change. So deriving the old org from pchgtype.

Line 1575: oe_debug_pub.add('start_work_flow: ' || 'Getting buyer info..',1);

1571: -- Buyer . Get the buyer info from Mtl_system_items
1572: IF pmlmo_flag = 'B' THEN
1573:
1574: IF PG_DEBUG <> 0 THEN
1575: oe_debug_pub.add('start_work_flow: ' || 'Getting buyer info..',1);
1576: END IF;
1577:
1578: -- bugfix 2203802: Instead of getting the full name directly from po_buyers_all_v
1579: -- get the corresponding application user.

Line 1626: oe_debug_pub.add('start_work_flow: ' || 'Buyer Not defined.. Defaulting to Sysadmin: ',2);

1622:
1623: EXCEPTION
1624: WHEN OTHERS THEN
1625: IF PG_DEBUG <> 0 THEN
1626: oe_debug_pub.add('start_work_flow: ' || 'Buyer Not defined.. Defaulting to Sysadmin: ',2);
1627:
1628: oe_debug_pub.add('start_work_flow: ' || 'Error Message : '||sqlerrm,2);
1629: END IF;
1630: lplanner_code := Null;

Line 1628: oe_debug_pub.add('start_work_flow: ' || 'Error Message : '||sqlerrm,2);

1624: WHEN OTHERS THEN
1625: IF PG_DEBUG <> 0 THEN
1626: oe_debug_pub.add('start_work_flow: ' || 'Buyer Not defined.. Defaulting to Sysadmin: ',2);
1627:
1628: oe_debug_pub.add('start_work_flow: ' || 'Error Message : '||sqlerrm,2);
1629: END IF;
1630: lplanner_code := Null;
1631:
1632: END;

Line 1637: oe_debug_pub.add('start_work_flow: ' || 'Getting the planner code ..',3);

1633: ELSE
1634: -- Get the item name and planner code from mtl_system_item_vl
1635: lstmt := 40;
1636: IF PG_DEBUG <> 0 THEN
1637: oe_debug_pub.add('start_work_flow: ' || 'Getting the planner code ..',3);
1638: oe_debug_pub.add('start_work_flow: ' || 'MLMO not B: lship_org_id = ' || lship_org_id,3);
1639: END IF;
1640:
1641: BEGIN

Line 1638: oe_debug_pub.add('start_work_flow: ' || 'MLMO not B: lship_org_id = ' || lship_org_id,3);

1634: -- Get the item name and planner code from mtl_system_item_vl
1635: lstmt := 40;
1636: IF PG_DEBUG <> 0 THEN
1637: oe_debug_pub.add('start_work_flow: ' || 'Getting the planner code ..',3);
1638: oe_debug_pub.add('start_work_flow: ' || 'MLMO not B: lship_org_id = ' || lship_org_id,3);
1639: END IF;
1640:
1641: BEGIN
1642: -- bugfix 2203802: Instead of getting the planner code directly from MSI,

Line 1665: oe_debug_pub.add('start_work_flow: ' || 'Error in getting the planner code data. Defaulting to SYSADMIN.',2);

1661: EXCEPTION
1662:
1663: WHEN OTHERS THEN
1664: IF PG_DEBUG <> 0 THEN
1665: oe_debug_pub.add('start_work_flow: ' || 'Error in getting the planner code data. Defaulting to SYSADMIN.',2);
1666:
1667: oe_debug_pub.add('start_work_flow: ' || 'Error Message : '||sqlerrm,2);
1668: END IF;
1669: lplanner_code := Null; -- bug 4101723

Line 1667: oe_debug_pub.add('start_work_flow: ' || 'Error Message : '||sqlerrm,2);

1663: WHEN OTHERS THEN
1664: IF PG_DEBUG <> 0 THEN
1665: oe_debug_pub.add('start_work_flow: ' || 'Error in getting the planner code data. Defaulting to SYSADMIN.',2);
1666:
1667: oe_debug_pub.add('start_work_flow: ' || 'Error Message : '||sqlerrm,2);
1668: END IF;
1669: lplanner_code := Null; -- bug 4101723
1670: END;
1671:

Line 1676: oe_debug_pub.add('start_work_flow: ' || 'Planner code = '||lplanner_code,3);

1672:
1673: END IF;
1674:
1675: IF PG_DEBUG <> 0 THEN
1676: oe_debug_pub.add('start_work_flow: ' || 'Planner code = '||lplanner_code,3);
1677: END IF;
1678:
1679:
1680: -- Loop through the change type pl/sql record and set the workflow attributes according to the

Line 1700: oe_debug_pub.add('start_work_flow: ' || 'Planner code is not a valid workflow user...Defaulting to'||lplanner_code,5);

1696: lplanner_code := wf_engine.getItemAttrText(ItemType => 'CTOCHORD',
1697: ItemKey => litem_key,
1698: aname => 'WF_ADMINISTRATOR');
1699: IF PG_DEBUG <> 0 THEN
1700: oe_debug_pub.add('start_work_flow: ' || 'Planner code is not a valid workflow user...Defaulting to'||lplanner_code,5);
1701: END IF;
1702: END IF;
1703:
1704: IF PG_DEBUG <> 0 THEN

Line 1705: oe_debug_pub.add('start_work_flow: ' || 'Looping thru the change table...',1);

1701: END IF;
1702: END IF;
1703:
1704: IF PG_DEBUG <> 0 THEN
1705: oe_debug_pub.add('start_work_flow: ' || 'Looping thru the change table...',1);
1706: END IF;
1707:
1708: --bugfix 3651068
1709: --check for cancel has been moved up from the below LOOP

Line 1765: oe_debug_pub.add('start_work_flow: ' || 'Change type value...'||to_char(pchgtype(i).change_type),1);

1761:
1762: i := pchgtype.FIRST;
1763: LOOP
1764: IF PG_DEBUG <> 0 THEN
1765: oe_debug_pub.add('start_work_flow: ' || 'Change type value...'||to_char(pchgtype(i).change_type),1);
1766: END IF;
1767: IF (pchgtype.exists(i)) then
1768:
1769: IF (pchgtype(i).change_type = CTO_CHANGE_ORDER_PK.QTY_CHANGE and to_number(pchgtype(i).new_value) <> 0)

Line 1793: oe_debug_pub.add('start_work_flow: ' || 'Adding Split Data ' ,1);

1789:
1790: IF pchgtype(i).change_type = CTO_CHANGE_ORDER_PK.QTY_CHANGE THEN
1791: if( pSplitDtls.count > 0 ) then
1792:
1793: oe_debug_pub.add('start_work_flow: ' || 'Adding Split Data ' ,1);
1794:
1795: v_split_index := pSplitDtls.first ;
1796:
1797: l_aname_split(1) := 'SPLIT_DTLS' ;

Line 1825: oe_debug_pub.add('start_work_flow: ' || 'Adding Split Data ' || v_split_qty ,1);

1821: */
1822:
1823: l_atxtvalue_split(1) := l_atxtvalue_split(1) || l_new_line || 'Line Number: ' || v_model_line_num || ' Quantity: ' || to_char( v_split_qty ) ;
1824:
1825: oe_debug_pub.add('start_work_flow: ' || 'Adding Split Data ' || v_split_qty ,1);
1826:
1827: v_split_index := pSplitDtls.next(v_split_index) ;
1828:
1829:

Line 1860: oe_debug_pub.add('start_work_flow: ' || 'VALUE of i for RD change=>'||i,1);

1856: l_aname(i) := 'RD_DATE';
1857: l_atxtvalue(i) := pchgtype(i).old_value||' TO '||nvl(pchgtype(i).new_value,'NULL');
1858:
1859: IF PG_DEBUG <> 0 THEN
1860: oe_debug_pub.add('start_work_flow: ' || 'VALUE of i for RD change=>'||i,1);
1861: END IF;
1862:
1863:
1864: ELSIF pchgtype(i).change_type = CTO_CHANGE_ORDER_PK.SSD_CHANGE then

Line 1907: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || nvl( pchgtype(i).old_value , 'NULL' )

1903:
1904:
1905: ELSIF pchgtype(i).change_type = CTO_CHANGE_ORDER_PK.WAREHOUSE_CHANGE then
1906: l_aname(i) := 'SHIP_ORG';
1907: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || nvl( pchgtype(i).old_value , 'NULL' )
1908: || ' new ' || nvl(pchgtype(i).new_value , 'NULL') ) ;
1909: -- l_atxtvalue(i) := pchgtype(i).old_value||' TO '||pchgtype(i).new_value;
1910:
1911: begin

Line 1923: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || 'exception while querying inv_organization_name_v for ' ||

1919:
1920: exception
1921: when others then
1922:
1923: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || 'exception while querying inv_organization_name_v for ' ||
1924: nvl( pchgtype(i).old_value , 'NULL' ) ) ;
1925:
1926: v_old_org := pchgtype(i).old_value ;
1927: end ;

Line 1939: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || 'exception while querying inv_organization_name_v for ' ||

1935:
1936: exception
1937: when others then
1938:
1939: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || 'exception while querying inv_organization_name_v for ' ||
1940: nvl( pchgtype(i).new_value , 'NULL' ) ) ;
1941:
1942: v_new_org := pchgtype(i).new_value ;
1943: end ;

Line 1946: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || nvl( v_old_org , 'NULL' )

1942: v_new_org := pchgtype(i).new_value ;
1943: end ;
1944:
1945:
1946: oe_debug_pub.add('CHANGE WAREHOUSE INFO : ' || nvl( v_old_org , 'NULL' )
1947: || ' new ' || nvl( v_new_org , 'NULL') ) ;
1948:
1949: l_atxtvalue(i) := v_old_org ||' TO '|| v_new_org ;
1950:

Line 1961: oe_debug_pub.add('start_work_flow: ' || 'customer line number is....'||lcust_line_no,5);

1957:
1958:
1959:
1960: IF PG_DEBUG <> 0 THEN
1961: oe_debug_pub.add('start_work_flow: ' || 'customer line number is....'||lcust_line_no,5);
1962: END IF;
1963:
1964: lstmt := 70;
1965:

Line 1978: oe_debug_pub.add('start_work_flow: ' || 'VALUE of i for action_text=>'||i,1);

1974: i := i + 1;
1975: l_aname(i) := 'ACTION_TEXT';
1976:
1977: IF PG_DEBUG <> 0 THEN
1978: oe_debug_pub.add('start_work_flow: ' || 'VALUE of i for action_text=>'||i,1);
1979: END IF;
1980:
1981: IF l_cancel_flag = 'Y' THEN
1982: l_atxtvalue(i) := FND_MESSAGE.get_string ('BOM', 'CTO_ACTION_CANCELED');

Line 1984: oe_debug_pub.add('start_work_flow: ' || 'Action is set to Canceled',5);

1980:
1981: IF l_cancel_flag = 'Y' THEN
1982: l_atxtvalue(i) := FND_MESSAGE.get_string ('BOM', 'CTO_ACTION_CANCELED');
1983: IF PG_DEBUG <> 0 THEN
1984: oe_debug_pub.add('start_work_flow: ' || 'Action is set to Canceled',5);
1985: END IF;
1986:
1987: ELSE
1988: l_atxtvalue(i) := FND_MESSAGE.get_string ('BOM', 'CTO_ACTION_MODIFIED');

Line 1990: oe_debug_pub.add('start_work_flow: ' || 'Action is set to Modified',5);

1986:
1987: ELSE
1988: l_atxtvalue(i) := FND_MESSAGE.get_string ('BOM', 'CTO_ACTION_MODIFIED');
1989: IF PG_DEBUG <> 0 THEN
1990: oe_debug_pub.add('start_work_flow: ' || 'Action is set to Modified',5);
1991: END IF;
1992: END IF;
1993:
1994:

Line 2023: oe_debug_pub.add('start_work_flow: ' || 'added split line data to main txt ' ,1);

2019: i:= i + 1;
2020: l_aname(i) := l_aname_split(1) ;
2021: l_atxtvalue(i) := l_atxtvalue_split(1) ;
2022: IF PG_DEBUG <> 0 THEN
2023: oe_debug_pub.add('start_work_flow: ' || 'added split line data to main txt ' ,1);
2024: END IF;
2025: end if;
2026:
2027:

Line 2041: oe_debug_pub.add('start_work_flow: ' || 'Enable Lower level supply parameter not set for org '|| lship_org_id,3);

2037: WHERE bp.organization_id = lship_org_id;
2038: EXCEPTION --bug#4666504 ,opm
2039: WHEN no_data_found THEN
2040: IF PG_DEBUG <> 0 THEN
2041: oe_debug_pub.add('start_work_flow: ' || 'Enable Lower level supply parameter not set for org '|| lship_org_id,3);
2042: oe_debug_pub.add('start_work_flow: ' || 'Defaulting parameter to 1 ',3);
2043: END IF;
2044:
2045: l_mlsupply_parameter := 1;

Line 2042: oe_debug_pub.add('start_work_flow: ' || 'Defaulting parameter to 1 ',3);

2038: EXCEPTION --bug#4666504 ,opm
2039: WHEN no_data_found THEN
2040: IF PG_DEBUG <> 0 THEN
2041: oe_debug_pub.add('start_work_flow: ' || 'Enable Lower level supply parameter not set for org '|| lship_org_id,3);
2042: oe_debug_pub.add('start_work_flow: ' || 'Defaulting parameter to 1 ',3);
2043: END IF;
2044:
2045: l_mlsupply_parameter := 1;
2046:

Line 2052: oe_debug_pub.add('start_work_flow: ' || 'Before calling get_child_configurations with item_id '|| pconfig_id,5);

2048:
2049: IF (l_mlsupply_parameter in (2,3)) THEN
2050:
2051: IF PG_DEBUG <> 0 THEN
2052: oe_debug_pub.add('start_work_flow: ' || 'Before calling get_child_configurations with item_id '|| pconfig_id,5);
2053: END IF;
2054:
2055: l_mlsupply_items(1).item_id := pconfig_id;
2056:

Line 2073: oe_debug_pub.add('start_work_flow: ' || 'Unexcpected error in CTOSUBSB.gte_child_configurations',1);

2069:
2070: );
2071:
2072: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2073: oe_debug_pub.add('start_work_flow: ' || 'Unexcpected error in CTOSUBSB.gte_child_configurations',1);
2074:
2075: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2076:
2077: oe_debug_pub.add('start_work_flow: ' || 'Expected error in CTOSUBSB.gte_child_configurations',1);

Line 2077: oe_debug_pub.add('start_work_flow: ' || 'Expected error in CTOSUBSB.gte_child_configurations',1);

2073: oe_debug_pub.add('start_work_flow: ' || 'Unexcpected error in CTOSUBSB.gte_child_configurations',1);
2074:
2075: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2076:
2077: oe_debug_pub.add('start_work_flow: ' || 'Expected error in CTOSUBSB.gte_child_configurations',1);
2078: ELSE
2079:
2080:
2081: oe_debug_pub.add('start_work_flow: ' || 'before entering teh loop to get the items',5);

Line 2081: oe_debug_pub.add('start_work_flow: ' || 'before entering teh loop to get the items',5);

2077: oe_debug_pub.add('start_work_flow: ' || 'Expected error in CTOSUBSB.gte_child_configurations',1);
2078: ELSE
2079:
2080:
2081: oe_debug_pub.add('start_work_flow: ' || 'before entering teh loop to get the items',5);
2082: IF ( l_mlsupply_items.count >1 ) THEN
2083: j := 1;
2084: LOOP
2085: IF(j = 1) THEN

Line 2099: oe_debug_pub.add('start_work_flow: ' || 'No sub-assemblies found',5);

2095:
2096: l_atxtvalue(i) := l_items ;
2097:
2098: ELSE
2099: oe_debug_pub.add('start_work_flow: ' || 'No sub-assemblies found',5);
2100:
2101: END IF; --mlsupply_item count
2102: END IF; -- return status of get_child_configurations
2103:

Line 2122: oe_debug_pub.add('start_work_flow: ' || 'Single level single org model, Special text is set to Null',5);

2118: -- Attribute is having default value that will be displayed.
2119:
2120: IF pmlmo_flag <> 'Y' THEN
2121: IF PG_DEBUG <> 0 THEN
2122: oe_debug_pub.add('start_work_flow: ' || 'Single level single org model, Special text is set to Null',5);
2123: END IF;
2124:
2125: lstmt := 82;
2126: wf_engine.SetItemAttrText(ItemType=>'CTOCHORD',itemkey=>litem_key,aname=>'SPL_TEXT',avalue=>'');

Line 2133: oe_debug_pub.add('start_work_flow: ' || 'Starting the workflow...',2);

2129:
2130: -- Calling the work flow
2131: lstmt := 80;
2132: IF PG_DEBUG <> 0 THEN
2133: oe_debug_pub.add('start_work_flow: ' || 'Starting the workflow...',2);
2134: END IF;
2135: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);
2136: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);
2137:

Line 2139: oe_debug_pub.add('start_work_flow: ' || 'success from ..... notification....',5);

2135: wf_engine.SetItemOwner(Itemtype=>'CTOCHORD',itemkey=>litem_key,owner=>lplanner_code);
2136: wf_engine.StartProcess(itemtype=>'CTOCHORD',ItemKey=>litem_key);
2137:
2138: IF PG_DEBUG <> 0 THEN
2139: oe_debug_pub.add('start_work_flow: ' || 'success from ..... notification....',5);
2140: END IF;
2141:
2142: EXCEPTION
2143:

Line 2149: oe_debug_pub.add('start_work_flow: ' || 'Expected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);

2145:
2146: WHEN FND_API.G_EXC_ERROR THEN
2147: -- x_return_status := FND_API.G_RET_STS_ERROR;
2148: IF PG_DEBUG <> 0 THEN
2149: oe_debug_pub.add('start_work_flow: ' || 'Expected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2150: END IF;
2151: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,
2152: p_msg_data => x_msg_data);
2153:

Line 2157: oe_debug_pub.add('start_work_flow: ' || 'UnExpected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);

2153:
2154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2155: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2156: IF PG_DEBUG <> 0 THEN
2157: oe_debug_pub.add('start_work_flow: ' || 'UnExpected error in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2158: END IF;
2159: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,
2160: p_msg_data => x_msg_data);
2161:

Line 2165: oe_debug_pub.add('start_work_flow: ' || 'OTHERS excpn in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);

2161:
2162: WHEN OTHERS THEN
2163: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2164: IF PG_DEBUG <> 0 THEN
2165: oe_debug_pub.add('start_work_flow: ' || 'OTHERS excpn in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2166:
2167: oe_debug_pub.add('start_work_flow: ' || 'Error Message is : '||Sqlerrm);
2168: END IF;
2169: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,

Line 2167: oe_debug_pub.add('start_work_flow: ' || 'Error Message is : '||Sqlerrm);

2163: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2164: IF PG_DEBUG <> 0 THEN
2165: oe_debug_pub.add('start_work_flow: ' || 'OTHERS excpn in start_work_flow. Last stmt executed is ..'||to_char(lStmt),2);
2166:
2167: oe_debug_pub.add('start_work_flow: ' || 'Error Message is : '||Sqlerrm);
2168: END IF;
2169: CTO_MSG_PUB.count_and_get(p_msg_count => x_msg_count,
2170: p_msg_data => x_msg_data);
2171:

Line 2213: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Inside Procedure Is_item_ML_OR_MO', 3);

2209: /* The following function tells whether this model is sourced or not */
2210:
2211:
2212: IF PG_DEBUG <> 0 THEN
2213: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Inside Procedure Is_item_ML_OR_MO', 3);
2214: END IF;
2215:
2216: l_stmt_no := 10;
2217:

Line 2262: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with expected error.', 1);

2258: );
2259:
2260: if X_Return_Status = FND_API.G_RET_STS_ERROR then
2261: IF PG_DEBUG <> 0 THEN
2262: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with expected error.', 1);
2263: END IF;
2264: raise FND_API.G_EXC_ERROR;
2265:
2266: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then

Line 2268: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with unexpected error.', 1);

2264: raise FND_API.G_EXC_ERROR;
2265:
2266: elsif X_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR then
2267: IF PG_DEBUG <> 0 THEN
2268: oe_debug_pub.add ('Is_item_ML_OR_MO: ' || 'Failed in get_model_sourcing_org with unexpected error.', 1);
2269: END IF;
2270: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2271: end if;
2272:

Line 2275: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'The source flag returned from model sourcing..'||x_result,2);

2271: end if;
2272:
2273:
2274: IF PG_DEBUG <> 0 THEN
2275: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'The source flag returned from model sourcing..'||x_result,2);
2276: END IF;
2277:
2278: -- Modified by Renga Kannan on 05/09/2001
2279: -- The p_sourcing_rule_exists parameter is returned as FND_API.G_TRUE/FND_API.G_FLASE.

Line 2308: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'This config line is not multi level ...',3);

2304: AND MTL.Base_item_id Is Not Null -- This condition tells this is a config item.
2305: AND rownum = 1;
2306: EXCEPTION WHEN NO_DATA_FOUND THEN
2307: IF PG_DEBUG <> 0 THEN
2308: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'This config line is not multi level ...',3);
2309: END IF;
2310: X_result := 'N';
2311: END;
2312: ELSE --- If the model is sourced

Line 2322: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'Expected error in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);

2318: EXCEPTION
2319:
2320: WHEN FND_API.G_EXC_ERROR THEN
2321: IF PG_DEBUG <> 0 THEN
2322: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'Expected error in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);
2323: END IF;
2324: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2325: p_msg_Data => X_Msg_Data);
2326: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2331: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'UnExpected error in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);

2327:
2328:
2329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2330: IF PG_DEBUG <> 0 THEN
2331: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'UnExpected error in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);
2332: END IF;
2333: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2334: p_msg_Data => X_Msg_Data);
2335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2341: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'OTHER excpn in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);

2337:
2338: WHEN OTHERS THEN
2339:
2340: IF PG_DEBUG <> 0 THEN
2341: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'OTHER excpn in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);
2342:
2343: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'The error message is ..'||sqlerrm,2);
2344: END IF;
2345: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2343: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'The error message is ..'||sqlerrm,2);

2339:
2340: IF PG_DEBUG <> 0 THEN
2341: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'OTHER excpn in Is_item_ML_OR_MO : Last statement executed is ...'||to_char(l_Stmt_no),1);
2342:
2343: oe_debug_pub.add('Is_item_ML_OR_MO: ' || 'The error message is ..'||sqlerrm,2);
2344: END IF;
2345: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346:
2347: END Is_item_ML_OR_MO;

Line 2373: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Entering Procedure Pto_Ato_Config_Wrapper....',1);

2369: BEGIN
2370:
2371: l_Stmt_no := 10;
2372: IF PG_DEBUG <> 0 THEN
2373: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Entering Procedure Pto_Ato_Config_Wrapper....',1);
2374: END IF;
2375:
2376: i := pchgtype.FIRST;
2377: LOOP

Line 2390: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'The line_id = '||Pchgtype(i).old_value||' ATO line id ='||l_ato_line_id,3);

2386: FROM OE_ORDER_LINES_ALL
2387: WHERE line_id = Pchgtype(i).old_value;
2388:
2389: IF PG_DEBUG <> 0 THEN
2390: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'The line_id = '||Pchgtype(i).old_value||' ATO line id ='||l_ato_line_id,3);
2391: END IF;
2392:
2393:
2394: IF l_ato_line_id is null THEN

Line 2396: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'The line id ='||Pchgtype(i).old_value||' Belongs to PTO-- Ignore',5);

2392:
2393:
2394: IF l_ato_line_id is null THEN
2395: IF PG_DEBUG <> 0 THEN
2396: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'The line id ='||Pchgtype(i).old_value||' Belongs to PTO-- Ignore',5);
2397: END IF;
2398:
2399: -- Removed the condition for bug fix 1874380
2400:

Line 2403: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Ato_line_id = '|| to_char( l_ato_line_id) ||

2399: -- Removed the condition for bug fix 1874380
2400:
2401: ELSIF l_ato_line_id = Pchgtype(i).old_value and l_item_type_code = 'OPTION' then
2402: IF PG_DEBUG <> 0 THEN
2403: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Ato_line_id = '|| to_char( l_ato_line_id) ||
2404: ' item type code ' || l_item_type_code ||
2405: ' Is an ATO ITEM under PTO Model, should be ignored..',5);
2406: END IF;
2407:

Line 2410: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Ato_line_id = '||l_ato_line_id||' Is already processed...',5);

2406: END IF;
2407:
2408: ELSIF l_process_set.exists(l_ato_line_id) THEN
2409: IF PG_DEBUG <> 0 THEN
2410: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Ato_line_id = '||l_ato_line_id||' Is already processed...',5);
2411: END IF;
2412:
2413: ELSIF CTO_WORKFLOW.config_line_exists(l_ato_line_id) = TRUE THEN
2414:

Line 2416: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Ato line_id = '||l_ato_line_id||' is having config item..',5);

2412:
2413: ELSIF CTO_WORKFLOW.config_line_exists(l_ato_line_id) = TRUE THEN
2414:
2415: IF PG_DEBUG <> 0 THEN
2416: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Ato line_id = '||l_ato_line_id||' is having config item..',5);
2417:
2418: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Calling main procedure Change_Notify...',5);
2419: END IF;
2420:

Line 2418: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Calling main procedure Change_Notify...',5);

2414:
2415: IF PG_DEBUG <> 0 THEN
2416: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Ato line_id = '||l_ato_line_id||' is having config item..',5);
2417:
2418: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Calling main procedure Change_Notify...',5);
2419: END IF;
2420:
2421: l_chgtype(1).change_type := CTO_CHANGE_ORDER_PK.CONFIG_CHANGE;
2422: l_stmt_no := 30;

Line 2432: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in change_notify procedure....',3);

2428: X_Msg_Data => X_Msg_Data);
2429:
2430: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2431: IF PG_DEBUG <> 0 THEN
2432: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in change_notify procedure....',3);
2433: END IF;
2434: raise FND_API.G_EXC_ERROR;
2435:
2436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2438: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Unexpected error occurred in change_notify...',3);

2434: raise FND_API.G_EXC_ERROR;
2435:
2436: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2437: IF PG_DEBUG <> 0 THEN
2438: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Unexpected error occurred in change_notify...',3);
2439: END IF;
2440: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2441: END IF;
2442:

Line 2447: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'This lines top model ato does not have config line...ignore',3);

2443: l_process_set(l_ato_line_id) := l_ato_line_id;
2444: ELSE
2445:
2446: IF PG_DEBUG <> 0 THEN
2447: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'This lines top model ato does not have config line...ignore',3);
2448: END IF;
2449: l_process_set(l_ato_line_id) := l_ato_line_id;
2450:
2451: END IF;

Line 2464: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);

2460:
2461: WHEN FND_API.G_EXC_ERROR THEN
2462: x_return_status := FND_API.G_RET_STS_ERROR;
2463: IF PG_DEBUG <> 0 THEN
2464: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Expected error in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);
2465: END IF;
2466: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2467: p_msg_Data => X_Msg_Data);
2468:

Line 2472: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'UnExpected error in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);

2468:
2469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2471: IF PG_DEBUG <> 0 THEN
2472: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'UnExpected error in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);
2473: END IF;
2474: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2475: p_msg_Data => X_Msg_Data);
2476:

Line 2480: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'OTHERS excpn in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);

2476:
2477: WHEN OTHERS THEN
2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2479: IF PG_DEBUG <> 0 THEN
2480: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'OTHERS excpn in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);
2481:
2482: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Error Message is : '||sqlerrm);
2483: END IF;
2484: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,

Line 2482: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Error Message is : '||sqlerrm);

2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2479: IF PG_DEBUG <> 0 THEN
2480: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'OTHERS excpn in Pto_Ato_Config_Wrapper. Last stmt executed is ..'||to_char(l_stmt_no),2);
2481:
2482: oe_debug_pub.add('Pto_Ato_Config_Wrapper: ' || 'Error Message is : '||sqlerrm);
2483: END IF;
2484: CTO_MSG_PUB.count_and_get(p_msg_count => X_Msg_Count,
2485: p_msg_Data => X_Msg_Data);
2486: END Pto_Ato_Config_Wrapper;

Line 2510: oe_debug_pub.add('req_interface_rec_exists: ' || 'interface record exists for the line', 5);

2506: and item_id = p_item_id
2507: and process_flag is null;
2508:
2509: IF PG_DEBUG <> 0 THEN
2510: oe_debug_pub.add('req_interface_rec_exists: ' || 'interface record exists for the line', 5);
2511: END IF;
2512:
2513: return TRUE;
2514:

Line 2519: oe_debug_pub.add('req_interface_rec_exists: ' || 'interface record does not exist for the line', 1);

2515: Exception
2516:
2517: when no_data_found then
2518: IF PG_DEBUG <> 0 THEN
2519: oe_debug_pub.add('req_interface_rec_exists: ' || 'interface record does not exist for the line', 1);
2520: END IF;
2521: return FALSE;
2522:
2523: when others then

Line 2526: oe_debug_pub.add('req_interface_rec_exists: ' || 'When others exception ..' || sqlerrm, 1);

2522:
2523: when others then
2524: x_return_status := fnd_api.g_ret_sts_unexp_error;
2525: IF PG_DEBUG <> 0 THEN
2526: oe_debug_pub.add('req_interface_rec_exists: ' || 'When others exception ..' || sqlerrm, 1);
2527: END IF;
2528: return FALSE;
2529:
2530: End req_interface_rec_exists;

Line 2562: oe_debug_pub.add('delete_from_req_interface: ' || 'Processed interface record deletion. exiting...', 5);

2558: Where interface_source_line_id = p_line_id
2559: and item_id = p_item_id;
2560:
2561: IF PG_DEBUG <> 0 THEN
2562: oe_debug_pub.add('delete_from_req_interface: ' || 'Processed interface record deletion. exiting...', 5);
2563: END IF;
2564:
2565: Exception
2566:

Line 2569: oe_debug_pub.add('delete_from_req_interface: ' || 'expected error: ' || sqlerrm, 1);

2565: Exception
2566:
2567: when FND_API.G_EXC_ERROR THEN
2568: IF PG_DEBUG <> 0 THEN
2569: oe_debug_pub.add('delete_from_req_interface: ' || 'expected error: ' || sqlerrm, 1);
2570: END IF;
2571: x_return_status := FND_API.G_RET_STS_ERROR;
2572:
2573: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2575: oe_debug_pub.add('delete_from_req_interface: ' || 'unexpected error: ' || sqlerrm, 1);

2571: x_return_status := FND_API.G_RET_STS_ERROR;
2572:
2573: when FND_API.G_EXC_UNEXPECTED_ERROR then
2574: IF PG_DEBUG <> 0 THEN
2575: oe_debug_pub.add('delete_from_req_interface: ' || 'unexpected error: ' || sqlerrm, 1);
2576: END IF;
2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2578:
2579: when others then

Line 2581: oe_debug_pub.add('delete_from_req_interface: ' || 'When others exception ..' || sqlerrm, 1);

2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2578:
2579: when others then
2580: IF PG_DEBUG <> 0 THEN
2581: oe_debug_pub.add('delete_from_req_interface: ' || 'When others exception ..' || sqlerrm, 1);
2582: END IF;
2583: x_return_status := fnd_api.g_ret_sts_unexp_error;
2584:
2585: End delete_from_req_interface;

Line 2607: oe_debug_pub.add('update_req_interface_rec: ' || 'Values passed in are as follows: ', 5);

2603:
2604: x_return_status := FND_API.G_RET_STS_SUCCESS;
2605:
2606: IF PG_DEBUG <> 0 THEN
2607: oe_debug_pub.add('update_req_interface_rec: ' || 'Values passed in are as follows: ', 5);
2608: oe_debug_pub.add('update_req_interface_rec: ' || 'p_line_id = ' || p_line_id, 5);
2609: oe_debug_pub.add('update_req_interface_rec: ' || 'p_qty = ' || p_qty, 5);
2610: oe_debug_pub.add('update_req_interface_rec: ' || 'p_need_by_date = ' || p_need_by_date, 5);
2611: END IF;

Line 2608: oe_debug_pub.add('update_req_interface_rec: ' || 'p_line_id = ' || p_line_id, 5);

2604: x_return_status := FND_API.G_RET_STS_SUCCESS;
2605:
2606: IF PG_DEBUG <> 0 THEN
2607: oe_debug_pub.add('update_req_interface_rec: ' || 'Values passed in are as follows: ', 5);
2608: oe_debug_pub.add('update_req_interface_rec: ' || 'p_line_id = ' || p_line_id, 5);
2609: oe_debug_pub.add('update_req_interface_rec: ' || 'p_qty = ' || p_qty, 5);
2610: oe_debug_pub.add('update_req_interface_rec: ' || 'p_need_by_date = ' || p_need_by_date, 5);
2611: END IF;
2612:

Line 2609: oe_debug_pub.add('update_req_interface_rec: ' || 'p_qty = ' || p_qty, 5);

2605:
2606: IF PG_DEBUG <> 0 THEN
2607: oe_debug_pub.add('update_req_interface_rec: ' || 'Values passed in are as follows: ', 5);
2608: oe_debug_pub.add('update_req_interface_rec: ' || 'p_line_id = ' || p_line_id, 5);
2609: oe_debug_pub.add('update_req_interface_rec: ' || 'p_qty = ' || p_qty, 5);
2610: oe_debug_pub.add('update_req_interface_rec: ' || 'p_need_by_date = ' || p_need_by_date, 5);
2611: END IF;
2612:
2613: if p_qty is null and p_qty2 is null and p_need_by_date is null then

Line 2610: oe_debug_pub.add('update_req_interface_rec: ' || 'p_need_by_date = ' || p_need_by_date, 5);

2606: IF PG_DEBUG <> 0 THEN
2607: oe_debug_pub.add('update_req_interface_rec: ' || 'Values passed in are as follows: ', 5);
2608: oe_debug_pub.add('update_req_interface_rec: ' || 'p_line_id = ' || p_line_id, 5);
2609: oe_debug_pub.add('update_req_interface_rec: ' || 'p_qty = ' || p_qty, 5);
2610: oe_debug_pub.add('update_req_interface_rec: ' || 'p_need_by_date = ' || p_need_by_date, 5);
2611: END IF;
2612:
2613: if p_qty is null and p_qty2 is null and p_need_by_date is null then
2614: IF PG_DEBUG <> 0 THEN

Line 2615: oe_debug_pub.add('update_req_interface_rec: ' || 'Both qty and date are null. Nothing to update. Simply returning ', 5);

2611: END IF;
2612:
2613: if p_qty is null and p_qty2 is null and p_need_by_date is null then
2614: IF PG_DEBUG <> 0 THEN
2615: oe_debug_pub.add('update_req_interface_rec: ' || 'Both qty and date are null. Nothing to update. Simply returning ', 5);
2616: end if;
2617: return;
2618: end if;
2619:

Line 2628: oe_debug_pub.add('update_req_interface_rec: ' || 'Processed interface record update. Exiting...', 5);

2624: Where interface_source_line_id = p_line_id
2625: and item_id = p_item_id;
2626:
2627: IF PG_DEBUG <> 0 THEN
2628: oe_debug_pub.add('update_req_interface_rec: ' || 'Processed interface record update. Exiting...', 5);
2629: END IF;
2630:
2631: Exception
2632:

Line 2636: oe_debug_pub.add('update_req_interface_rec: ' || 'When others exception ..' || sqlerrm, 1);

2632:
2633: when others then
2634: x_return_status := fnd_api.g_ret_sts_unexp_error;
2635: IF PG_DEBUG <> 0 THEN
2636: oe_debug_pub.add('update_req_interface_rec: ' || 'When others exception ..' || sqlerrm, 1);
2637: END IF;
2638:
2639: End update_req_interface_rec;
2640:

Line 2676: oe_debug_pub.add('get_open_demand: ' || 'Values passed in are as follows: ', 5);

2672:
2673: x_return_status := FND_API.G_RET_STS_SUCCESS;
2674:
2675: IF PG_DEBUG <> 0 THEN
2676: oe_debug_pub.add('get_open_demand: ' || 'Values passed in are as follows: ', 5);
2677: oe_debug_pub.add('get_open_demand: ' || 'p_line_id = ' || p_line_id, 5);
2678: oe_debug_pub.add('get_open_demand: ' || 'p_order_qty = ' || p_order_qty, 5);
2679: oe_debug_pub.add('get_open_demand: ' || 'p_order_qty2 = ' || p_order_qty2, 5);
2680: END IF;

Line 2677: oe_debug_pub.add('get_open_demand: ' || 'p_line_id = ' || p_line_id, 5);

2673: x_return_status := FND_API.G_RET_STS_SUCCESS;
2674:
2675: IF PG_DEBUG <> 0 THEN
2676: oe_debug_pub.add('get_open_demand: ' || 'Values passed in are as follows: ', 5);
2677: oe_debug_pub.add('get_open_demand: ' || 'p_line_id = ' || p_line_id, 5);
2678: oe_debug_pub.add('get_open_demand: ' || 'p_order_qty = ' || p_order_qty, 5);
2679: oe_debug_pub.add('get_open_demand: ' || 'p_order_qty2 = ' || p_order_qty2, 5);
2680: END IF;
2681:

Line 2678: oe_debug_pub.add('get_open_demand: ' || 'p_order_qty = ' || p_order_qty, 5);

2674:
2675: IF PG_DEBUG <> 0 THEN
2676: oe_debug_pub.add('get_open_demand: ' || 'Values passed in are as follows: ', 5);
2677: oe_debug_pub.add('get_open_demand: ' || 'p_line_id = ' || p_line_id, 5);
2678: oe_debug_pub.add('get_open_demand: ' || 'p_order_qty = ' || p_order_qty, 5);
2679: oe_debug_pub.add('get_open_demand: ' || 'p_order_qty2 = ' || p_order_qty2, 5);
2680: END IF;
2681:
2682:

Line 2679: oe_debug_pub.add('get_open_demand: ' || 'p_order_qty2 = ' || p_order_qty2, 5);

2675: IF PG_DEBUG <> 0 THEN
2676: oe_debug_pub.add('get_open_demand: ' || 'Values passed in are as follows: ', 5);
2677: oe_debug_pub.add('get_open_demand: ' || 'p_line_id = ' || p_line_id, 5);
2678: oe_debug_pub.add('get_open_demand: ' || 'p_order_qty = ' || p_order_qty, 5);
2679: oe_debug_pub.add('get_open_demand: ' || 'p_order_qty2 = ' || p_order_qty2, 5);
2680: END IF;
2681:
2682:
2683:

Line 2706: oe_debug_pub.add('get_open_demand: ' || 'exception from get_resv_qty_and_code call', 1);

2702: );
2703:
2704: if x_return_status <> fnd_api.g_ret_sts_success then
2705: IF PG_DEBUG <> 0 THEN
2706: oe_debug_pub.add('get_open_demand: ' || 'exception from get_resv_qty_and_code call', 1);
2707: END IF;
2708: raise fnd_api.g_exc_unexpected_error;
2709: end if;
2710:

Line 2750: oe_debug_pub.add('get_open_demand: ' || 'supply qty = ' || l_supply_qty, 1);

2746:
2747: END IF; --p_order_qty
2748:
2749: IF PG_DEBUG <> 0 THEN
2750: oe_debug_pub.add('get_open_demand: ' || 'supply qty = ' || l_supply_qty, 1);
2751: oe_debug_pub.add('get_open_demand: ' || 'open_demand = ' || x_open_demand, 1);
2752: END IF;
2753:
2754: --OPM

Line 2751: oe_debug_pub.add('get_open_demand: ' || 'open_demand = ' || x_open_demand, 1);

2747: END IF; --p_order_qty
2748:
2749: IF PG_DEBUG <> 0 THEN
2750: oe_debug_pub.add('get_open_demand: ' || 'supply qty = ' || l_supply_qty, 1);
2751: oe_debug_pub.add('get_open_demand: ' || 'open_demand = ' || x_open_demand, 1);
2752: END IF;
2753:
2754: --OPM
2755:

Line 2789: oe_debug_pub.add('get_open_demand: ' || 'supply qty2 = ' || l_supply_qty2, 1);

2785: END IF; --p_order_qty2
2786:
2787:
2788: IF PG_DEBUG <> 0 THEN
2789: oe_debug_pub.add('get_open_demand: ' || 'supply qty2 = ' || l_supply_qty2, 1);
2790: oe_debug_pub.add('get_open_demand: ' || 'open_demand2 = ' || x_open_demand2, 1);
2791: oe_debug_pub.add('get_open_demand: ' || 'Processing done. exiting...', 5);
2792: END IF;
2793:

Line 2790: oe_debug_pub.add('get_open_demand: ' || 'open_demand2 = ' || x_open_demand2, 1);

2786:
2787:
2788: IF PG_DEBUG <> 0 THEN
2789: oe_debug_pub.add('get_open_demand: ' || 'supply qty2 = ' || l_supply_qty2, 1);
2790: oe_debug_pub.add('get_open_demand: ' || 'open_demand2 = ' || x_open_demand2, 1);
2791: oe_debug_pub.add('get_open_demand: ' || 'Processing done. exiting...', 5);
2792: END IF;
2793:
2794:

Line 2791: oe_debug_pub.add('get_open_demand: ' || 'Processing done. exiting...', 5);

2787:
2788: IF PG_DEBUG <> 0 THEN
2789: oe_debug_pub.add('get_open_demand: ' || 'supply qty2 = ' || l_supply_qty2, 1);
2790: oe_debug_pub.add('get_open_demand: ' || 'open_demand2 = ' || x_open_demand2, 1);
2791: oe_debug_pub.add('get_open_demand: ' || 'Processing done. exiting...', 5);
2792: END IF;
2793:
2794:
2795:

Line 2801: oe_debug_pub.add('get_open_demand: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);

2797:
2798: WHEN FND_API.G_EXC_ERROR THEN
2799: x_return_status := FND_API.G_RET_STS_ERROR;
2800: IF PG_DEBUG <> 0 THEN
2801: oe_debug_pub.add('get_open_demand: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
2802: END IF;
2803:
2804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2807: oe_debug_pub.add('get_open_demand: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);

2803:
2804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2806: IF PG_DEBUG <> 0 THEN
2807: oe_debug_pub.add('get_open_demand: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
2808: END IF;
2809:
2810: when others then
2811: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2813: oe_debug_pub.add('get_open_demand: ' || 'When others exception ..' || sqlerrm, 1);

2809:
2810: when others then
2811: x_return_status := fnd_api.g_ret_sts_unexp_error;
2812: IF PG_DEBUG <> 0 THEN
2813: oe_debug_pub.add('get_open_demand: ' || 'When others exception ..' || sqlerrm, 1);
2814: END IF;
2815:
2816: End get_open_demand;
2817:

Line 2850: oe_debug_pub.add('change_order_ato_req_item: ' || 'Inside procedure change_order_ato_req_item',5);

2846:
2847: x_return_status := FND_API.G_RET_STS_SUCCESS;
2848:
2849: IF PG_DEBUG <> 0 THEN
2850: oe_debug_pub.add('change_order_ato_req_item: ' || 'Inside procedure change_order_ato_req_item',5);
2851: END IF;
2852:
2853:
2854:

Line 2871: oe_debug_pub.add('change_order_ato_req_item: ' || 'Interface record does not exist. Nothing to update. Simply returning ', 5);

2867: if l_req_exists = FALSE then
2868:
2869: -- if no req record exists, no processing needed. just return.
2870: IF PG_DEBUG <> 0 THEN
2871: oe_debug_pub.add('change_order_ato_req_item: ' || 'Interface record does not exist. Nothing to update. Simply returning ', 5);
2872: end if;
2873:
2874: return;
2875:

Line 2898: oe_debug_pub.add('change_order_ato_req_item: ' || 'Either cancel or unschedule or config change. Interface record deleted. Returning ', 5);

2894: raise fnd_api.g_exc_unexpected_error;
2895: end if;
2896:
2897: IF PG_DEBUG <> 0 THEN
2898: oe_debug_pub.add('change_order_ato_req_item: ' || 'Either cancel or unschedule or config change. Interface record deleted. Returning ', 5);
2899: end if;
2900:
2901: return;
2902:

Line 2967: oe_debug_pub.add('change_order_ato_req_item: ' || 'No Open demand. Interface record deleted. Returning ', 5);

2963: raise fnd_api.g_exc_unexpected_error;
2964: end if;
2965:
2966: IF PG_DEBUG <> 0 THEN
2967: oe_debug_pub.add('change_order_ato_req_item: ' || 'No Open demand. Interface record deleted. Returning ', 5);
2968: end if;
2969:
2970: return;
2971:

Line 2994: oe_debug_pub.add('change_order_ato_req_item: ' || 'Processing done. Exiting ', 5);

2990:
2991:
2992:
2993: IF PG_DEBUG <> 0 THEN
2994: oe_debug_pub.add('change_order_ato_req_item: ' || 'Processing done. Exiting ', 5);
2995: end if;
2996:
2997:
2998:

Line 3004: oe_debug_pub.add('change_order_ato_req_item: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);

3000:
3001: WHEN FND_API.G_EXC_ERROR THEN
3002: x_return_status := FND_API.G_RET_STS_ERROR;
3003: IF PG_DEBUG <> 0 THEN
3004: oe_debug_pub.add('change_order_ato_req_item: ' || 'Expected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3005: END IF;
3006:
3007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3010: oe_debug_pub.add('change_order_ato_req_item: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);

3006:
3007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3009: IF PG_DEBUG <> 0 THEN
3010: oe_debug_pub.add('change_order_ato_req_item: ' || 'UnExpected error. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3011: END IF;
3012:
3013: WHEN OTHERS THEN
3014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3016: oe_debug_pub.add('change_order_ato_req_item: ' || 'OTHERS excpn. Last stmt executed is ..'|| to_char(lStmtNumber),1);

3012:
3013: WHEN OTHERS THEN
3014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3015: IF PG_DEBUG <> 0 THEN
3016: oe_debug_pub.add('change_order_ato_req_item: ' || 'OTHERS excpn. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3017: oe_debug_pub.add('change_order_ato_req_item: ' || 'Error Message is : '|| sqlerrm, 1);
3018: END IF;
3019:
3020: END CHANGE_ORDER_ATO_REQ_ITEM;

Line 3017: oe_debug_pub.add('change_order_ato_req_item: ' || 'Error Message is : '|| sqlerrm, 1);

3013: WHEN OTHERS THEN
3014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3015: IF PG_DEBUG <> 0 THEN
3016: oe_debug_pub.add('change_order_ato_req_item: ' || 'OTHERS excpn. Last stmt executed is ..'|| to_char(lStmtNumber),1);
3017: oe_debug_pub.add('change_order_ato_req_item: ' || 'Error Message is : '|| sqlerrm, 1);
3018: END IF;
3019:
3020: END CHANGE_ORDER_ATO_REQ_ITEM;
3021: