DBA Data[Home] [Help]

APPS.OE_BLANKET_WF dependencies on OE_DEBUG_PUB

Line 13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

9: funcmode in varchar2,
10: resultout in out nocopy varchar2)
11: IS
12: --
13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14: l_return_status VARCHAR2(30);
15: l_qa_return_status VARCHAR2(30);
16: l_msg_count NUMBER;
17: l_msg_data VARCHAR2(2000);

Line 22: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Submit_Draft_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

18: l_count NUMBER;
19: --
20: BEGIN
21: IF l_debug_level > 0 THEN
22: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Submit_Draft_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
23: END IF;
24: OE_STANDARD_WF.Set_Msg_Context(actid);
25: IF (funcmode = 'RUN') then
26:

Line 45: oe_debug_pub.add( 'Contract returns: x_return_status:' || l_return_status || ' x_qa_return_status:' || l_qa_return_status, 1);

41: x_return_status => l_return_status,
42: x_msg_count => l_msg_count,
43: x_msg_data => l_msg_data);
44: IF l_debug_level > 0 THEN
45: oe_debug_pub.add( 'Contract returns: x_return_status:' || l_return_status || ' x_qa_return_status:' || l_qa_return_status, 1);
46: END IF;
47:
48: -- If API call is successful, but the check failed, return incomplete
49: IF l_return_status = FND_API.G_RET_STS_SUCCESS

Line 108: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

104: funcmode in varchar2,
105: resultout in out nocopy varchar2)
106: IS
107: --
108: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
109: l_count NUMBER;
110: --
111: BEGIN
112: IF l_debug_level > 0 THEN

Line 113: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Check_Negotiation_Exists:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

109: l_count NUMBER;
110: --
111: BEGIN
112: IF l_debug_level > 0 THEN
113: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Check_Negotiation_Exists:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
114: END IF;
115: OE_STANDARD_WF.Set_Msg_Context(actid);
116: IF (funcmode = 'RUN') THEN
117: select count(1)

Line 132: oe_debug_pub.add( 'EXITING OE_BLanket_WF.Check_Negotiation_Exists:' || resultout);

128:
129: END IF;
130:
131: IF l_debug_level > 0 THEN
132: oe_debug_pub.add( 'EXITING OE_BLanket_WF.Check_Negotiation_Exists:' || resultout);
133: END IF;
134:
135: EXCEPTION
136: when others then

Line 158: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

154: funcmode in varchar2,
155: resultout in out nocopy varchar2)
156: IS
157: --
158: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
159: l_start_date DATE;
160: l_end_date DATE;
161: l_pre_notification_percent NUMBER;
162: l_aname wf_engine.nametabtyp;

Line 172: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Calculate_Effective_Dates:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

168:
169: BEGIN
170:
171: IF l_debug_level > 0 THEN
172: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Calculate_Effective_Dates:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
173: END IF;
174: OE_STANDARD_WF.Set_Msg_Context(actid);
175: IF (funcmode = 'RUN') then
176: SELECT obhe.Start_Date_Active, obhe.End_Date_Active

Line 196: oe_debug_pub.add('Leaving OE_Blanket_WF.Calculate_Effective_Dates: Start date not reached', 1);

192: x_return_status => l_return_status);
193:
194: resultout := 'COMPLETE:AWAITING_START_DATE';
195: IF l_debug_level > 0 THEN
196: oe_debug_pub.add('Leaving OE_Blanket_WF.Calculate_Effective_Dates: Start date not reached', 1);
197: END IF;
198: return;
199: ELSIF l_end_date is null THEN --start date reached, but no end date
200: oe_order_wf_util.update_flow_status_code(p_header_id => to_number(itemkey),

Line 206: oe_debug_pub.add('Leaving OE_Blanket_WF.Calculate_Effective_Date: No end date', 1);

202: p_item_type => OE_GLOBALS.G_WFI_BKT,
203: x_return_status => l_return_status);
204: resultout := 'COMPLETE:NO_END_DATE';
205: IF l_debug_level > 0 THEN
206: oe_debug_pub.add('Leaving OE_Blanket_WF.Calculate_Effective_Date: No end date', 1);
207: END IF;
208: return;
209: ELSIF l_end_date < sysdate THEN --start date reached, end date also reached
210: resultout := 'COMPLETE:EXPIRED';

Line 212: oe_debug_pub.add('Leaving OE_Blanket_WF.Calculate_Effective_Dates: EXPIRED', 1);

208: return;
209: ELSIF l_end_date < sysdate THEN --start date reached, end date also reached
210: resultout := 'COMPLETE:EXPIRED';
211: IF l_debug_level > 0 THEN
212: oe_debug_pub.add('Leaving OE_Blanket_WF.Calculate_Effective_Dates: EXPIRED', 1);
213: END IF;
214: -- status update will be handled in the Expired activity
215: return;
216: END IF;

Line 222: oe_debug_pub.add('sysdate:' || to_char(sysdate, 'DD-MON-RRRR') || ' and end date:' || to_char(l_end_date, 'DD-MON-RRRR'),1);

218: --if you are here, that means expiration date exists and is in the future
219:
220: l_pre_notification_percent := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'PRE_EXPIRE_TIME_PERCENT');
221:
222: oe_debug_pub.add('sysdate:' || to_char(sysdate, 'DD-MON-RRRR') || ' and end date:' || to_char(l_end_date, 'DD-MON-RRRR'),1);
223:
224: IF l_pre_notification_percent = 0 THEN
225: -- set the FINAL timer only is enough
226: -- this assumes expiration_date is already set to 23:59:59

Line 238: oe_debug_pub.add('Leaving OE_Blanket_WF.Calculate_Effective_Dates: NO REMINDER', 1);

234: p_item_type => OE_GLOBALS.G_WFI_BKT,
235: x_return_status => l_return_status);
236: resultout := 'COMPLETE:NO_REMINDER';
237: IF l_debug_level > 0 THEN
238: oe_debug_pub.add('Leaving OE_Blanket_WF.Calculate_Effective_Dates: NO REMINDER', 1);
239: END IF;
240: return;
241: ELSIF to_char(sysdate, 'DD-MON-RRRR') = to_char(l_end_date, 'DD-MON-RRRR') THEN
242: -- pre notification percentage is non-zero

Line 255: oe_debug_pub.add('OE_Blanket_WF.Calculate_Effective_Dates: EXPIRE TODAY', 1);

251: p_item_type => OE_GLOBALS.G_WFI_BKT,
252: x_return_status => l_return_status);
253: resultout := 'COMPLETE:EXPIRE_TODAY';
254: IF l_debug_level > 0 THEN
255: oe_debug_pub.add('OE_Blanket_WF.Calculate_Effective_Dates: EXPIRE TODAY', 1);
256: END IF;
257: ELSE --expiration is not today, i.e. it is in the future
258: --again end_date should already be in 23:59:59
259: l_aname(1) := 'BLANKET_FINAL_EXPIRE_TIMER';

Line 277: oe_debug_pub.add('Leaving OE_Blanket_WF.Calculate_Effective_Dates: TIMER(S) SET', 1);

273: resultout := 'COMPLETE:START_DATE_REACHED';
274: END IF; -- end if of expiration date is today or future
275:
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add('Leaving OE_Blanket_WF.Calculate_Effective_Dates: TIMER(S) SET', 1);
278: END IF;
279: END IF; --funcmode = run
280:
281: EXCEPTION

Line 401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

397: funcmode in varchar2,
398: resultout in out nocopy varchar2)
399: IS
400: --
401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
402: l_return_status VARCHAR2(30);
403: l_sold_to_org_id NUMBER;
404: l_salesrep_id NUMBER;
405: l_salesrep VARCHAR2(240);

Line 414: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Expired:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

410: l_avaluetext wf_engine.texttabtyp;
411: --
412: BEGIN
413: IF l_debug_level > 0 THEN
414: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Expired:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
415: END IF;
416: OE_STANDARD_WF.Set_Msg_Context(actid);
417: IF (funcmode = 'RUN') then
418: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,

Line 479: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

475: resultout in out nocopy varchar2)
476:
477: IS
478: --
479: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
480: l_return_status VARCHAR2(30);
481: --
482: BEGIN
483: IF l_debug_level > 0 THEN

Line 484: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Terminate_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

480: l_return_status VARCHAR2(30);
481: --
482: BEGIN
483: IF l_debug_level > 0 THEN
484: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Terminate_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
485: END IF;
486: OE_STANDARD_WF.Set_Msg_Context(actid);
487: IF (funcmode = 'RUN') then
488: OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,

Line 524: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

520: funcmode in varchar2,
521: resultout in out nocopy varchar2)
522: IS
523: --
524: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
525: l_return_status VARCHAR2(30);
526: l_msg_data VARCHAR2(2000);
527: l_msg_count NUMBER;
528: l_blanket_number NUMBER;

Line 532: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Close_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

528: l_blanket_number NUMBER;
529: --
530: BEGIN
531: IF l_debug_level > 0 THEN
532: oe_debug_pub.add( 'ENTERING OE_BLanket_WF.Close_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
533: END IF;
534: OE_STANDARD_WF.Set_Msg_Context(actid);
535: IF (funcmode = 'RUN') then
536: -- check for releases of blanket

Line 581: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

577: PROCEDURE Blanket_Date_Changed(p_header_id IN NUMBER,
578: x_return_status OUT NOCOPY VARCHAR2)
579: IS
580: --
581: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
582: l_activity_name VARCHAR2(30);
583: l_transaction_phase_code VARCHAR2(30);
584: --
585: BEGIN

Line 589: oe_debug_pub.add('ENTERING OE_Blanket_WF.Blanket_Date_Changed: '|| TO_CHAR (p_header_id) ,1);

585: BEGIN
586: OE_MSG_PUB.initialize;
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588: IF l_debug_level > 0 THEN
589: oe_debug_pub.add('ENTERING OE_Blanket_WF.Blanket_Date_Changed: '|| TO_CHAR (p_header_id) ,1);
590: END IF;
591:
592: SELECT transaction_phase_code
593: INTO l_transaction_phase_code

Line 620: oe_debug_pub.add('EXITING OE_Blanket_WF.Blanket_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);

616: fnd_message.set_name('ONT', 'OE_BKT_NO_DATE_CHANGE');
617: oe_msg_pub.add;
618: x_return_status := FND_API.G_RET_STS_ERROR;
619: IF l_debug_level > 0 THEN
620: oe_debug_pub.add('EXITING OE_Blanket_WF.Blanket_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
621: END IF;
622: return;
623:
624: END;

Line 633: oe_debug_pub.add('EXITING OE_Blanket_WF.Blanket_Date_Changed normally', 1);

629: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'DATE_CHANGED');
630: END IF;
631:
632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add('EXITING OE_Blanket_WF.Blanket_Date_Changed normally', 1);
634: END IF;
635:
636: EXCEPTION
637: WHEN OTHERS THEN

Line 640: oe_debug_pub.add('EXITING OE_Blanket_WF.Blanket_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);

636: EXCEPTION
637: WHEN OTHERS THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
639: IF l_debug_level > 0 THEN
640: oe_debug_pub.add('EXITING OE_Blanket_WF.Blanket_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
641: END IF;
642: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
643: THEN
644: OE_MSG_PUB.Add_Exc_Msg

Line 659: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

655: p_transaction_phase_code IN VARCHAR2,
656: x_return_status OUT NOCOPY VARCHAR2)
657: IS
658: --
659: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
660: l_activity_name VARCHAR2(30);
661: l_sales_document_type VARCHAR2(30);
662: --
663: BEGIN

Line 667: oe_debug_pub.add('ENTERING OE_Blanket_WF.Submit_Draft: '|| TO_CHAR (p_header_id) ,1);

663: BEGIN
664: -- OE_MSG_PUB.initialize; commented out due to 4671489
665: x_return_status := FND_API.G_RET_STS_SUCCESS;
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.add('ENTERING OE_Blanket_WF.Submit_Draft: '|| TO_CHAR (p_header_id) ,1);
668: END IF;
669: BEGIN
670: select wpa.activity_name
671: into l_activity_name

Line 689: oe_debug_pub.add('EXITING OE_Blanket_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);

685: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
686: oe_msg_pub.add;
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: IF l_debug_level > 0 THEN
689: oe_debug_pub.add('EXITING OE_Blanket_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
690: END IF;
691: return;
692: END;
693:

Line 698: oe_debug_pub.add('EXITING OE_Blanket_WF.Submit_Draft', 1);

694: -- ok to go submit draft
695: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'COMPLETE');
696:
697: IF l_debug_level > 0 THEN
698: oe_debug_pub.add('EXITING OE_Blanket_WF.Submit_Draft', 1);
699: END IF;
700:
701: EXCEPTION
702: WHEN OTHERS THEN

Line 705: oe_debug_pub.add('EXITING OE_Blanket_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);

701: EXCEPTION
702: WHEN OTHERS THEN
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
704: IF l_debug_level > 0 THEN
705: oe_debug_pub.add('EXITING OE_Blanket_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
706: END IF;
707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
708: THEN
709: OE_MSG_PUB.Add_Exc_Msg

Line 723: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

719: PROCEDURE Close(p_header_id IN NUMBER,
720: x_return_status OUT NOCOPY VARCHAR2)
721: IS
722: --
723: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
724: l_activity_name VARCHAR2(30);
725: l_sales_document_type VARCHAR2(30);
726: --
727: BEGIN

Line 731: oe_debug_pub.add('ENTERING OE_Blanket_WF.Close: '|| TO_CHAR (p_header_id) ,1);

727: BEGIN
728: OE_MSG_PUB.initialize;
729: x_return_status := FND_API.G_RET_STS_SUCCESS;
730: IF l_debug_level > 0 THEN
731: oe_debug_pub.add('ENTERING OE_Blanket_WF.Close: '|| TO_CHAR (p_header_id) ,1);
732: END IF;
733: BEGIN
734: select wpa.activity_name
735: into l_activity_name

Line 749: oe_debug_pub.add('EXITING OE_Blanket_WF.Close WITH STATUS: '||X_RETURN_STATUS ,1);

745: fnd_message.set_name('ONT', 'OE_BKT_NO_CLOSE');
746: oe_msg_pub.add;
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: IF l_debug_level > 0 THEN
749: oe_debug_pub.add('EXITING OE_Blanket_WF.Close WITH STATUS: '||X_RETURN_STATUS ,1);
750: END IF;
751: return;
752:
753: END;

Line 759: oe_debug_pub.add('EXITING OE_Blanket_WF.Close', 1);

755: -- ok to go submit draft
756: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'COMPLETE');
757:
758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add('EXITING OE_Blanket_WF.Close', 1);
760: END IF;
761:
762: EXCEPTION
763: WHEN OTHERS THEN

Line 766: oe_debug_pub.add('EXITING OE_Blanket_WF.Close WITH STATUS: '||X_RETURN_STATUS ,1);

762: EXCEPTION
763: WHEN OTHERS THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765: IF l_debug_level > 0 THEN
766: oe_debug_pub.add('EXITING OE_Blanket_WF.Close WITH STATUS: '||X_RETURN_STATUS ,1);
767: END IF;
768: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
769: THEN
770: OE_MSG_PUB.Add_Exc_Msg

Line 789: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

785: p_reason_comments IN VARCHAR2,
786: x_return_status OUT NOCOPY VARCHAR2)
787: IS
788: --
789: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
790: l_activity_name VARCHAR2(30);
791: l_sales_document_type VARCHAR2(30);
792: l_sold_to_org_id NUMBER;
793: l_salesrep_id NUMBER;

Line 808: oe_debug_pub.add('ENTERING OE_Blanket_WF.Terminate: '|| TO_CHAR (p_header_id) ,1);

804: BEGIN
805: OE_MSG_PUB.initialize;
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807: IF l_debug_level > 0 THEN
808: oe_debug_pub.add('ENTERING OE_Blanket_WF.Terminate: '|| TO_CHAR (p_header_id) ,1);
809: END IF;
810: BEGIN
811: select wpa.activity_name
812: into l_activity_name

Line 826: oe_debug_pub.add('EXITING OE_Blanket_WF.Terminate WITH STATUS: '||X_RETURN_STATUS ,1);

822: fnd_message.set_name('ONT', 'OE_BKT_NO_TERMINATE');
823: oe_msg_pub.add;
824: x_return_status := FND_API.G_RET_STS_ERROR;
825: IF l_debug_level > 0 THEN
826: oe_debug_pub.add('EXITING OE_Blanket_WF.Terminate WITH STATUS: '||X_RETURN_STATUS ,1);
827: END IF;
828: return;
829: END;
830:

Line 880: oe_debug_pub.add('EXITING OE_Blanket_WF.Terminate', 1);

876:
877: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'TERMINATE');
878:
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add('EXITING OE_Blanket_WF.Terminate', 1);
881: END IF;
882:
883: EXCEPTION
884: WHEN OTHERS THEN

Line 887: oe_debug_pub.add('EXITING OE_Blanket_WF.Terminate WITH STATUS: '||X_RETURN_STATUS ,1);

883: EXCEPTION
884: WHEN OTHERS THEN
885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
886: IF l_debug_level > 0 THEN
887: oe_debug_pub.add('EXITING OE_Blanket_WF.Terminate WITH STATUS: '||X_RETURN_STATUS ,1);
888: END IF;
889: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
890: THEN
891: OE_MSG_PUB.Add_Exc_Msg

Line 904: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

900: PROCEDURE Extend(p_header_id IN NUMBER,
901: x_return_status OUT NOCOPY VARCHAR2)
902: IS
903: --
904: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
905: l_activity_name VARCHAR2(30);
906: --
907: BEGIN
908: OE_MSG_PUB.initialize;

Line 911: oe_debug_pub.add('ENTERING OE_Blanket_WF.Extend: '|| TO_CHAR (p_header_id) ,1);

907: BEGIN
908: OE_MSG_PUB.initialize;
909: x_return_status := FND_API.G_RET_STS_SUCCESS;
910: IF l_debug_level > 0 THEN
911: oe_debug_pub.add('ENTERING OE_Blanket_WF.Extend: '|| TO_CHAR (p_header_id) ,1);
912: END IF;
913: BEGIN
914: select wpa.activity_name
915: into l_activity_name

Line 929: oe_debug_pub.add('EXITING OE_Blanket_WF.Extend WITH STATUS: '||X_RETURN_STATUS ,1);

925: fnd_message.set_name('ONT', 'OE_BKT_NO_EXTEND');
926: oe_msg_pub.add;
927: x_return_status := FND_API.G_RET_STS_ERROR;
928: IF l_debug_level > 0 THEN
929: oe_debug_pub.add('EXITING OE_Blanket_WF.Extend WITH STATUS: '||X_RETURN_STATUS ,1);
930: END IF;
931: return;
932: END;
933:

Line 938: oe_debug_pub.add('EXITING OE_Blanket_WF.Extend', 1);

934: -- ok to go extend
935: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_BKT, to_char(p_header_id), l_activity_name, 'EXTEND');
936:
937: IF l_debug_level > 0 THEN
938: oe_debug_pub.add('EXITING OE_Blanket_WF.Extend', 1);
939: END IF;
940:
941: EXCEPTION
942: WHEN OTHERS THEN

Line 945: oe_debug_pub.add('EXITING OE_Blanket_WF.Extend WITH STATUS: '||X_RETURN_STATUS ,1);

941: EXCEPTION
942: WHEN OTHERS THEN
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
944: IF l_debug_level > 0 THEN
945: oe_debug_pub.add('EXITING OE_Blanket_WF.Extend WITH STATUS: '||X_RETURN_STATUS ,1);
946: END IF;
947: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
948: THEN
949: OE_MSG_PUB.Add_Exc_Msg

Line 960: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

956:
957: PROCEDURE Set_Header_Attributes_Internal(p_header_id IN NUMBER)
958: IS
959: --
960: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
961: l_sold_to_org_id NUMBER;
962: l_salesrep_id NUMBER;
963: l_salesrep VARCHAR2(240);
964: l_sold_to VARCHAR2(240);

Line 972: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Set_Header_Attributes_Internal:'||To_char(p_header_id),1);

968: l_avaluetext wf_engine.texttabtyp;
969: --
970: BEGIN
971: IF l_debug_level > 0 THEN
972: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Set_Header_Attributes_Internal:'||To_char(p_header_id),1);
973: END IF;
974:
975: select bh.sold_to_org_id, bhx.end_date_active, bh.salesrep_id
976: into l_sold_to_org_id, l_end_date, l_salesrep_id

Line 1017: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1013: funcmode in varchar2,
1014: resultout in out nocopy varchar2)
1015: IS
1016: --
1017: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1018: --
1019: BEGIN
1020: IF l_debug_level > 0 THEN
1021: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Set_Header_Attributes:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

Line 1021: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Set_Header_Attributes:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

1017: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1018: --
1019: BEGIN
1020: IF l_debug_level > 0 THEN
1021: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Set_Header_Attributes:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
1022: END IF;
1023: OE_STANDARD_WF.Set_Msg_Context(actid);
1024: IF (funcmode = 'RUN') THEN
1025: set_header_attributes_internal(To_number(itemkey));

Line 1050: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1046: funcmode in varchar2,
1047: resultout in out nocopy varchar2)
1048: IS
1049: --
1050: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1051: l_final_timer NUMBER;
1052: l_end_date DATE;
1053: l_from_role VARCHAR2(200); --for bug 9897971
1054:

Line 1059: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Set_Final_Expiration_Date:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

1055: --
1056:
1057: BEGIN
1058: IF l_debug_level > 0 THEN
1059: oe_debug_pub.add( 'ENTERING OE_Blanket_WF.Set_Final_Expiration_Date:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
1060: END IF;
1061: OE_STANDARD_WF.Set_Msg_Context(actid);
1062: IF (funcmode = 'RUN') THEN
1063: set_header_attributes_internal(To_number(itemkey));

Line 1065: oe_debug_pub.add( 'Done setting header attributes',1);

1061: OE_STANDARD_WF.Set_Msg_Context(actid);
1062: IF (funcmode = 'RUN') THEN
1063: set_header_attributes_internal(To_number(itemkey));
1064: IF l_debug_level > 0 THEN
1065: oe_debug_pub.add( 'Done setting header attributes',1);
1066: END IF;
1067:
1068: SELECT obhe.End_Date_Active
1069: INTO l_end_date

Line 1099: oe_debug_pub.add('Leaving OE_Blanket_WF.Set_Final_Expiration_Date', 1);

1095: resultout := 'COMPLETE:EXPIRED';
1096: END IF;
1097:
1098: IF l_debug_level > 0 THEN
1099: oe_debug_pub.add('Leaving OE_Blanket_WF.Set_Final_Expiration_Date', 1);
1100: END IF;
1101: END IF;
1102: EXCEPTION
1103: when others then