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.OE_NEGOTIATE_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: --
16:
17: BEGIN

Line 19: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Update_Status_Lost:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

15: --
16:
17: BEGIN
18: IF l_debug_level > 0 THEN
19: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Update_Status_Lost:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
20: END IF;
21: OE_STANDARD_WF.Set_Msg_Context(actid);
22: IF (funcmode = 'RUN') then
23:

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

64: resultout in out nocopy varchar2)
65: IS
66: --
67: l_sales_document_type_code VARCHAR2(1);
68: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
69: l_return_status VARCHAR2(30);
70: l_msg_count NUMBER;
71: l_msg_data VARCHAR2(2000);
72: --

Line 76: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Negotiation_Complete:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

72: --
73:
74: BEGIN
75: IF l_debug_level > 0 THEN
76: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Negotiation_Complete:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
77: END IF;
78: OE_STANDARD_WF.Set_Msg_Context(actid);
79: IF (funcmode = 'RUN') then
80:

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

127: resultout in out nocopy varchar2)
128: IS
129: --
130: l_sales_document_type_code VARCHAR2(1);
131: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
132: l_return_status VARCHAR2(30);
133: l_validate_cfg BOOLEAN;
134: Cursor Query_Lines IS
135: SELECT item_type_code, ordered_quantity

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

145: --
146:
147: BEGIN
148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Submit_Draft_Internal:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
150: END IF;
151: OE_STANDARD_WF.Set_Msg_Context(actid);
152:
153: IF (funcmode = 'RUN') then

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

169: x_msg_count => l_msg_count,
170: x_msg_data => l_msg_data);
171:
172: IF l_debug_level > 0 THEN
173: oe_debug_pub.add( 'Contract returns: x_return_status:' || l_return_status || ' x_qa_return_status:' || l_qa_return_status, 1);
174: END IF;
175: -- If API call is successful, but the check failed, return incomplete
176:
177: IF l_return_status = FND_API.G_RET_STS_SUCCESS

Line 221: oe_debug_pub.add('Submit_Draft_Internal: Finish looking for Configs', 1);

217: End Loop;
218: Close Query_Lines;
219:
220: IF l_debug_level > 0 THEN
221: oe_debug_pub.add('Submit_Draft_Internal: Finish looking for Configs', 1);
222: END IF;
223:
224: IF l_validate_cfg THEN
225: l_return_status := OE_Config_Util.Validate_Cfgs_In_Order(p_header_id => to_number(itemkey));

Line 227: oe_debug_pub.add( 'RETURN STATUS AFTER VALIDATE CFGS:'||L_RETURN_STATUS );

223:
224: IF l_validate_cfg THEN
225: l_return_status := OE_Config_Util.Validate_Cfgs_In_Order(p_header_id => to_number(itemkey));
226: IF l_debug_level > 0 THEN
227: oe_debug_pub.add( 'RETURN STATUS AFTER VALIDATE CFGS:'||L_RETURN_STATUS );
228: END IF;
229:
230: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
231: resultout := 'COMPLETE:INCOMPLETE';

Line 249: oe_debug_pub.add('Submit_Draft_Internal: Finish calling Update Draft Submitted status: ' || l_return_status, 1);

245: p_flow_status_code => 'DRAFT_SUBMITTED',
246: p_draft_submitted_flag => 'Y',
247: x_return_status => l_return_status);
248: IF l_debug_level > 0 THEN
249: oe_debug_pub.add('Submit_Draft_Internal: Finish calling Update Draft Submitted status: ' || l_return_status, 1);
250: END IF;
251:
252: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
253: resultout := 'COMPLETE:INCOMPLETE';

Line 264: oe_debug_pub.add('Exiting OE_NEGOTIATE_WF.Submit_Draft_Internal Normally', 1);

260:
261: resultout := 'COMPLETE:COMPLETE';
262:
263: IF l_debug_level > 0 THEN
264: oe_debug_pub.add('Exiting OE_NEGOTIATE_WF.Submit_Draft_Internal Normally', 1);
265: END IF;
266:
267:
268: END IF;

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

288: funcmode in varchar2,
289: resultout in out nocopy varchar2)
290: IS
291: --
292: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
293: l_return_status VARCHAR2(30);
294: --
295:
296: BEGIN

Line 298: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Customer_Acceptance:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

294: --
295:
296: BEGIN
297: IF l_debug_level > 0 THEN
298: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Customer_Acceptance:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
299: END IF;
300: OE_STANDARD_WF.Set_Msg_Context(actid);
301: IF (funcmode = 'RUN') then
302: OE_MSG_PUB.set_msg_context(

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

340: funcmode in varchar2,
341: resultout in out nocopy varchar2)
342: IS
343: --
344: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
345: l_return_status VARCHAR2(30);
346: --
347:
348: BEGIN

Line 350: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Update_Customer_Accepted:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

346: --
347:
348: BEGIN
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Update_Customer_Accepted:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
351: END IF;
352: OE_STANDARD_WF.Set_Msg_Context(actid);
353: IF (funcmode = 'RUN') then
354: OE_MSG_PUB.set_msg_context(

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

393: funcmode in varchar2,
394: resultout in out nocopy varchar2)
395: IS
396: --
397: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
398: l_return_status VARCHAR2(30);
399: --
400:
401: BEGIN

Line 404: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Update_Customer_Rejected:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

400:
401: BEGIN
402:
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Update_Customer_Rejected:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
405: END IF;
406: OE_STANDARD_WF.Set_Msg_Context(actid);
407: IF (funcmode = 'RUN') then
408: OE_MSG_PUB.set_msg_context(

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

446: funcmode in varchar2,
447: resultout in out nocopy varchar2)
448: IS
449: --
450: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
451: l_expiration_date DATE;
452: l_pre_notification_percent NUMBER;
453: l_aname wf_engine.nametabtyp;
454: l_avalue wf_engine.numtabtyp;

Line 462: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Check_Expiration_Date:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

458:
459: BEGIN
460:
461: IF l_debug_level > 0 THEN
462: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Check_Expiration_Date:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
463: END IF;
464: OE_STANDARD_WF.Set_Msg_Context(actid);
465: IF (funcmode = 'RUN') then
466: OE_MSG_PUB.set_msg_context(

Line 501: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: NO TIMER TO SET', 1);

497: , avalue=>l_avalue
498: );
499: resultout := 'COMPLETE:COMPLETE';
500: IF l_debug_level > 0 THEN
501: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: NO TIMER TO SET', 1);
502: END IF;
503: return;
504: END IF;
505:

Line 510: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: EXPIRED', 1);

506: -- expiration date does exist but expired
507: IF l_expiration_date < sysdate THEN
508: resultout := 'COMPLETE:EXPIRED';
509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: EXPIRED', 1);
511: END IF;
512: return;
513: END IF;
514:

Line 529: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: NO REMINDER', 1);

525: aname=>'OFFER_FINAL_EXPIRE_TIMER',
526: avalue=>l_final_timer);
527: resultout := 'COMPLETE:NO_REMINDER';
528: IF l_debug_level > 0 THEN
529: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: NO REMINDER', 1);
530: END IF;
531: ELSIF to_char(sysdate, 'DD-MON-RRRR') = to_char(l_expiration_date, 'DD-MON-RRRR') THEN
532: -- pre notification percentage is non-zero
533: -- expiration_date is today midnight, we should send the reminder

Line 542: oe_debug_pub.add('OE_Negotiate_WF.Check_Expiration_Date: EXPIRE TODAY', 1);

538: , avalue=>(l_expiration_date - sysdate) * 1440
539: );
540: resultout := 'COMPLETE:EXPIRE_TODAY';
541: IF l_debug_level > 0 THEN
542: oe_debug_pub.add('OE_Negotiate_WF.Check_Expiration_Date: EXPIRE TODAY', 1);
543: END IF;
544: ELSE --expiration is not today, i.e. it is in the future
545: --again expiration_date should already be in 23:59:59
546: l_aname(1) := 'OFFER_FINAL_EXPIRE_TIMER';

Line 560: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: TIMER(S) SET', 1);

556: resultout := 'COMPLETE:COMPLETE';
557: END IF; -- end if of expiration date is today or future
558:
559: IF l_debug_level > 0 THEN
560: oe_debug_pub.add('Leaving OE_Negotiate_WF.Check_Expiration_Date: TIMER(S) SET', 1);
561: END IF;
562: END IF; --funcmode = run
563:
564: EXCEPTION

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

582: funcmode in varchar2,
583: resultout in out nocopy varchar2)
584: IS
585: --
586: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
587: l_return_status VARCHAR2(30);
588: l_sales_document_type_code VARCHAR2(1);
589: l_sold_to_org_id NUMBER;
590: l_salesrep_id NUMBER;

Line 602: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Offer_Expired:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;

598: --
599:
600: BEGIN
601: IF l_debug_level > 0 THEN
602: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Offer_Expired:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
603: END IF;
604: OE_STANDARD_WF.Set_Msg_Context(actid);
605: IF (funcmode = 'RUN') then
606: OE_MSG_PUB.set_msg_context(

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

678: )
679: IS
680: --
681: l_sales_document_type_code VARCHAR2 (1);
682: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
683: l_header_id NUMBER;
684: l_order_type_id NUMBER;
685: l_transaction_type_name VARCHAR2 (300);
686: l_transaction_type_id NUMBER;

Line 705: oe_debug_pub.ADD ('item key selected is:' || l_item_key);

701: INTO l_item_key, l_item_type --l_header_id AME ER
702: FROM wf_item_activity_statuses
703: WHERE notification_id = TO_NUMBER (document_id);
704: IF l_debug_level > 0 THEN
705: oe_debug_pub.ADD ('item key selected is:' || l_item_key);
706: END IF ;
707: EXCEPTION
708: WHEN NO_DATA_FOUND
709: THEN

Line 731: oe_debug_pub.ADD ( 'before getting attribute:');

727:
728:
729: BEGIN
730: IF l_debug_level > 0 THEN
731: oe_debug_pub.ADD ( 'before getting attribute:');
732: END IF ;
733: IF l_item_type='OEAME'
734: THEN --AME ER
735: l_header_id :=

Line 743: oe_debug_pub.ADD ('After getting attribute:' || l_header_id);

739: l_header_id := TO_NUMBER (l_item_key);
740: --AME ER
741: END IF; --AME ER
742: IF l_debug_level > 0 THEN
743: oe_debug_pub.ADD ('After getting attribute:' || l_header_id);
744: END IF ;
745: IF l_header_id IS NULL
746: THEN
747: l_header_id := TO_NUMBER (l_item_key);

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

814: p_reason_comments IN VARCHAR2,
815: x_return_status OUT NOCOPY VARCHAR2)
816: IS
817: --
818: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
819: l_activity_name VARCHAR2(30);
820: l_sales_document_type VARCHAR2(30);
821: l_reason_id NUMBER;
822: l_return_status VARCHAR2(240);

Line 829: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Lost: '|| TO_CHAR (p_header_id) ,1) ;

825: BEGIN
826: OE_MSG_PUB.initialize;
827: x_return_status := FND_API.G_RET_STS_SUCCESS;
828: IF l_debug_level > 0 THEN
829: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Lost: '|| TO_CHAR (p_header_id) ,1) ;
830: END IF;
831: OE_MSG_PUB.set_msg_context(
832: p_entity_code => 'HEADER'
833: ,p_entity_id => p_header_id

Line 861: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost WITH STATUS: '||X_RETURN_STATUS ,1);

857: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
858: oe_msg_pub.add;
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: IF l_debug_level > 0 THEN
861: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost WITH STATUS: '||X_RETURN_STATUS ,1);
862: END IF;
863: return;
864: END;
865: -- ok to go Lost

Line 880: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost normally', 1);

876:
877: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'LOST');
878:
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost normally', 1);
881: END IF;
882: EXCEPTION
883: WHEN OTHERS THEN
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 886: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost WITH STATUS: '||X_RETURN_STATUS ,1);

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

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

900: PROCEDURE Customer_Accepted(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: l_sales_document_type_code VARCHAR2(1);
907: l_sales_document_type VARCHAR2(30);
908: l_response VARCHAR2(30);

Line 919: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Accepted: '|| TO_CHAR (p_header_id) ,1) ;

915: BEGIN
916: OE_MSG_PUB.initialize;
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Accepted: '|| TO_CHAR (p_header_id) ,1) ;
920: END IF;
921:
922: OE_MSG_PUB.set_msg_context(
923: p_entity_code => 'HEADER'

Line 983: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);

979: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
980: oe_msg_pub.add;
981: x_return_status := FND_API.G_RET_STS_ERROR;
982: IF l_debug_level > 0 THEN
983: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);
984: END IF;
985: return;
986: END;
987: -- ok to go Accept

Line 1013: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted normally', 1);

1009: itemkey => to_char(p_header_id),
1010: activity => l_activity_name,
1011: result => 'ACCEPT');
1012: IF l_debug_level > 0 THEN
1013: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted normally', 1);
1014: END IF;
1015: EXCEPTION
1016:
1017: WHEN OTHERS THEN

Line 1020: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);

1016:
1017: WHEN OTHERS THEN
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1019: IF l_debug_level > 0 THEN
1020: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);
1021: END IF;
1022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1023: THEN
1024: OE_MSG_PUB.Add_Exc_Msg

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

1039: p_reason_comments IN VARCHAR2,
1040: x_return_status OUT NOCOPY VARCHAR2)
1041: IS
1042: --
1043: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1044: l_activity_name VARCHAR2(30);
1045: l_sales_document_type VARCHAR2(30);
1046: l_response VARCHAR2(30);
1047: l_reason_id NUMBER;

Line 1057: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Rejected: '|| TO_CHAR (p_header_id) ,1) ;

1053: BEGIN
1054: OE_MSG_PUB.initialize;
1055: x_return_status := FND_API.G_RET_STS_SUCCESS;
1056: IF l_debug_level > 0 THEN
1057: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Rejected: '|| TO_CHAR (p_header_id) ,1) ;
1058: END IF;
1059: OE_MSG_PUB.set_msg_context(
1060: p_entity_code => 'HEADER'
1061: ,p_entity_id => p_header_id

Line 1089: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);

1085: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1086: oe_msg_pub.add;
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: IF l_debug_level > 0 THEN
1089: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);
1090: END IF;
1091: return;
1092: END;
1093: -- ok to go Reject

Line 1107: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected normally', 1);

1103:
1104:
1105: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'REJECT');
1106: IF l_debug_level > 0 THEN
1107: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected normally', 1);
1108: END IF;
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1113: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);

1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1112: IF l_debug_level > 0 THEN
1113: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);
1114: END IF;
1115: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1116: THEN
1117: OE_MSG_PUB.Add_Exc_Msg

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

1127: PROCEDURE Offer_Date_Changed(p_header_id NUMBER,
1128: x_return_status OUT NOCOPY VARCHAR2)
1129: IS
1130: --
1131: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1132: l_activity_name VARCHAR2(30);
1133: l_sales_document_type_code VARCHAR2(1);
1134: l_sales_document_type VARCHAR2(30);
1135: --

Line 1140: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Offer_Date_Changed: '|| TO_CHAR (p_header_id) ,1) ;

1136: BEGIN
1137: OE_MSG_PUB.initialize;
1138: x_return_status := FND_API.G_RET_STS_SUCCESS;
1139: IF l_debug_level > 0 THEN
1140: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Offer_Date_Changed: '|| TO_CHAR (p_header_id) ,1) ;
1141: END IF;
1142: OE_MSG_PUB.set_msg_context(
1143: p_entity_code => 'HEADER'
1144: ,p_entity_id => p_header_id

Line 1171: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);

1167: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1168: oe_msg_pub.add;
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: IF l_debug_level > 0 THEN
1171: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
1172: END IF;
1173: return;
1174: END;
1175: -- ok to go date changed

Line 1177: oe_debug_pub.add('Calling WF_ENGINE to completeactivity' ,3);

1173: return;
1174: END;
1175: -- ok to go date changed
1176: IF l_debug_level > 0 THEN
1177: oe_debug_pub.add('Calling WF_ENGINE to completeactivity' ,3);
1178: END IF;
1179: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'DATE_CHANGED');
1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed normally', 1);

Line 1181: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed normally', 1);

1177: oe_debug_pub.add('Calling WF_ENGINE to completeactivity' ,3);
1178: END IF;
1179: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'DATE_CHANGED');
1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed normally', 1);
1182: END IF;
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1187: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);

1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
1188: END IF;
1189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1190: THEN
1191: OE_MSG_PUB.Add_Exc_Msg

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

1200: PROCEDURE Submit_Draft(p_header_id NUMBER,
1201: x_return_status OUT NOCOPY VARCHAR2)
1202: IS
1203: --
1204: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1205: l_activity_name VARCHAR2(30);
1206: l_sales_document_type_code VARCHAR2(1);
1207: l_sales_document_type VARCHAR2(30);
1208: l_entity_code VARCHAR2(30);

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

1216: BEGIN
1217: -- OE_MSG_PUB.initialize; commented out for 4671489
1218: x_return_status := FND_API.G_RET_STS_SUCCESS;
1219: IF l_debug_level > 0 THEN
1220: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Submit_Draft: '|| TO_CHAR (p_header_id) ,1) ;
1221: END IF;
1222:
1223: BEGIN
1224: --Bug3435165

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

1295: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1296: oe_msg_pub.add;
1297: x_return_status := FND_API.G_RET_STS_ERROR;
1298: IF l_debug_level > 0 THEN
1299: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
1300: END IF;
1301: return;
1302: END;
1303: -- ok to go Submit Draft

Line 1309: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft normally', 1);

1305: itemkey => to_char(p_header_id),
1306: activity => l_activity_name,
1307: result => 'COMPLETE');
1308: IF l_debug_level > 0 THEN
1309: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft normally', 1);
1310: END IF;
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1314: IF l_debug_level > 0 THEN
1315: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
1316: END IF;
1317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1318: THEN
1319: OE_MSG_PUB.Add_Exc_Msg

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

1329: PROCEDURE set_header_attributes_internal(p_header_id IN NUMBER)
1330: IS
1331: --
1332: l_sales_document_type_code VARCHAR2(1);
1333: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1334: l_sold_to_org_id NUMBER;
1335: l_salesrep_id NUMBER;
1336: l_salesrep VARCHAR2(240);
1337: l_sold_to VARCHAR2(240);

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

1341: l_avaluetext wf_engine.texttabtyp;
1342: --
1343: BEGIN
1344: IF l_debug_level > 0 THEN
1345: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Header_Attributes_Internal:'||To_char(p_header_id) ,1 ) ;
1346: END IF;
1347:
1348: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, To_char(p_header_id), 'SALES_DOCUMENT_TYPE_CODE');
1349: IF l_sales_document_type_code = 'O' THEN

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

1395: funcmode in varchar2,
1396: resultout in out nocopy varchar2)
1397: IS
1398: --
1399: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1400: BEGIN
1401: IF l_debug_level > 0 THEN
1402: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Header_Attributes:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
1403: END IF;

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

1398: --
1399: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1400: BEGIN
1401: IF l_debug_level > 0 THEN
1402: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Header_Attributes:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
1403: END IF;
1404: OE_STANDARD_WF.Set_Msg_Context(actid);
1405: IF (funcmode = 'RUN') THEN
1406: set_header_attributes_internal(To_number(itemkey));

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

1427: funcmode in varchar2,
1428: resultout in out nocopy varchar2)
1429: IS
1430: --
1431: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1432: l_final_timer NUMBER;
1433: l_sales_document_type_code VARCHAR2(1);
1434: l_expiration_date DATE;
1435: l_from_role VARCHAR2(200);

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

1436: --
1437:
1438: BEGIN
1439: IF l_debug_level > 0 THEN
1440: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Final_Expiration_Date:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
1441: END IF;
1442: OE_STANDARD_WF.Set_Msg_Context(actid);
1443: IF (funcmode = 'RUN') then
1444: OE_MSG_PUB.set_msg_context(

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

1447: ,p_header_id => to_number(itemkey));
1448:
1449: set_header_attributes_internal(To_number(itemkey));
1450: IF l_debug_level > 0 THEN
1451: oe_debug_pub.add( 'Done setting header attributes',1);
1452: END IF;
1453:
1454: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'SALES_DOCUMENT_TYPE_CODE');
1455: IF l_sales_document_type_code = 'O' THEN

Line 1496: oe_debug_pub.add('Leaving OE_Negotiate_WF.Set_Final_Expiration_Date', 1);

1492: resultout := 'COMPLETE:EXPIRED';
1493: END IF;
1494:
1495: IF l_debug_level > 0 THEN
1496: oe_debug_pub.add('Leaving OE_Negotiate_WF.Set_Final_Expiration_Date', 1);
1497: END IF;
1498: END IF;
1499: EXCEPTION
1500: when others then

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

1515: RETURN Boolean
1516: IS
1517:
1518: --
1519: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1520: l_activity_name VARCHAR2(30);
1521: --
1522: l_customer_acceptance VARCHAR2(30) := 'CUSTOMER_ACCEPTANCE';
1523: --

Line 1527: oe_debug_pub.add( 'ENTER OE_Negotiate_WF.At_Customer_Acceptance');

1523: --
1524: BEGIN
1525:
1526: IF l_debug_level > 0 THEN
1527: oe_debug_pub.add( 'ENTER OE_Negotiate_WF.At_Customer_Acceptance');
1528: END IF;
1529:
1530: select wpa.activity_name
1531: into l_activity_name