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 680: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

676: document_type IN OUT NOCOPY VARCHAR2)
677: IS
678: --
679: l_sales_document_type_code VARCHAR2(1);
680: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
681: l_header_id NUMBER;
682: l_order_type_id NUMBER;
683: l_transaction_type_name VARCHAR2(300);
684: l_transaction_type_id NUMBER;

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

759: p_reason_comments IN VARCHAR2,
760: x_return_status OUT NOCOPY VARCHAR2)
761: IS
762: --
763: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
764: l_activity_name VARCHAR2(30);
765: l_sales_document_type VARCHAR2(30);
766: l_reason_id NUMBER;
767: l_return_status VARCHAR2(240);

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

770: BEGIN
771: OE_MSG_PUB.initialize;
772: x_return_status := FND_API.G_RET_STS_SUCCESS;
773: IF l_debug_level > 0 THEN
774: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Lost: '|| TO_CHAR (p_header_id) ,1) ;
775: END IF;
776: OE_MSG_PUB.set_msg_context(
777: p_entity_code => 'HEADER'
778: ,p_entity_id => p_header_id

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

802: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
803: oe_msg_pub.add;
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: IF l_debug_level > 0 THEN
806: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost WITH STATUS: '||X_RETURN_STATUS ,1);
807: END IF;
808: return;
809: END;
810: -- ok to go Lost

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

821:
822: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'LOST');
823:
824: IF l_debug_level > 0 THEN
825: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost normally', 1);
826: END IF;
827: EXCEPTION
828: WHEN OTHERS THEN
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

827: EXCEPTION
828: WHEN OTHERS THEN
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
830: IF l_debug_level > 0 THEN
831: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost WITH STATUS: '||X_RETURN_STATUS ,1);
832: END IF;
833: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
834: THEN
835: OE_MSG_PUB.Add_Exc_Msg

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

845: PROCEDURE Customer_Accepted(p_header_id IN NUMBER,
846: x_return_status OUT NOCOPY VARCHAR2)
847: IS
848: --
849: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
850: l_activity_name VARCHAR2(30);
851: l_sales_document_type_code VARCHAR2(1);
852: l_sales_document_type VARCHAR2(30);
853: l_response VARCHAR2(30);

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

860: BEGIN
861: OE_MSG_PUB.initialize;
862: x_return_status := FND_API.G_RET_STS_SUCCESS;
863: IF l_debug_level > 0 THEN
864: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Accepted: '|| TO_CHAR (p_header_id) ,1) ;
865: END IF;
866:
867: OE_MSG_PUB.set_msg_context(
868: p_entity_code => 'HEADER'

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

924: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
925: oe_msg_pub.add;
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: IF l_debug_level > 0 THEN
928: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);
929: END IF;
930: return;
931: END;
932: -- ok to go Accept

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

954: itemkey => to_char(p_header_id),
955: activity => l_activity_name,
956: result => 'ACCEPT');
957: IF l_debug_level > 0 THEN
958: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted normally', 1);
959: END IF;
960: EXCEPTION
961:
962: WHEN OTHERS THEN

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

961:
962: WHEN OTHERS THEN
963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
964: IF l_debug_level > 0 THEN
965: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);
966: END IF;
967: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
968: THEN
969: OE_MSG_PUB.Add_Exc_Msg

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

984: p_reason_comments IN VARCHAR2,
985: x_return_status OUT NOCOPY VARCHAR2)
986: IS
987: --
988: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
989: l_activity_name VARCHAR2(30);
990: l_sales_document_type VARCHAR2(30);
991: l_response VARCHAR2(30);
992: l_reason_id NUMBER;

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

998: BEGIN
999: OE_MSG_PUB.initialize;
1000: x_return_status := FND_API.G_RET_STS_SUCCESS;
1001: IF l_debug_level > 0 THEN
1002: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Rejected: '|| TO_CHAR (p_header_id) ,1) ;
1003: END IF;
1004: OE_MSG_PUB.set_msg_context(
1005: p_entity_code => 'HEADER'
1006: ,p_entity_id => p_header_id

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

1030: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1031: oe_msg_pub.add;
1032: x_return_status := FND_API.G_RET_STS_ERROR;
1033: IF l_debug_level > 0 THEN
1034: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);
1035: END IF;
1036: return;
1037: END;
1038: -- ok to go Reject

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

1048:
1049:
1050: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'REJECT');
1051: IF l_debug_level > 0 THEN
1052: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected normally', 1);
1053: END IF;
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1057: IF l_debug_level > 0 THEN
1058: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);
1059: END IF;
1060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1061: THEN
1062: OE_MSG_PUB.Add_Exc_Msg

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

1072: PROCEDURE Offer_Date_Changed(p_header_id NUMBER,
1073: x_return_status OUT NOCOPY VARCHAR2)
1074: IS
1075: --
1076: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1077: l_activity_name VARCHAR2(30);
1078: l_sales_document_type_code VARCHAR2(1);
1079: l_sales_document_type VARCHAR2(30);
1080: --

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

1081: BEGIN
1082: OE_MSG_PUB.initialize;
1083: x_return_status := FND_API.G_RET_STS_SUCCESS;
1084: IF l_debug_level > 0 THEN
1085: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Offer_Date_Changed: '|| TO_CHAR (p_header_id) ,1) ;
1086: END IF;
1087: OE_MSG_PUB.set_msg_context(
1088: p_entity_code => 'HEADER'
1089: ,p_entity_id => p_header_id

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

1112: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1113: oe_msg_pub.add;
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: IF l_debug_level > 0 THEN
1116: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
1117: END IF;
1118: return;
1119: END;
1120: -- ok to go date changed

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

1118: return;
1119: END;
1120: -- ok to go date changed
1121: IF l_debug_level > 0 THEN
1122: oe_debug_pub.add('Calling WF_ENGINE to completeactivity' ,3);
1123: END IF;
1124: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'DATE_CHANGED');
1125: IF l_debug_level > 0 THEN
1126: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed normally', 1);

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

1122: oe_debug_pub.add('Calling WF_ENGINE to completeactivity' ,3);
1123: END IF;
1124: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_NGO, to_char(p_header_id), l_activity_name, 'DATE_CHANGED');
1125: IF l_debug_level > 0 THEN
1126: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed normally', 1);
1127: END IF;
1128: EXCEPTION
1129: WHEN OTHERS THEN
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1128: EXCEPTION
1129: WHEN OTHERS THEN
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1131: IF l_debug_level > 0 THEN
1132: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
1133: END IF;
1134: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1135: THEN
1136: OE_MSG_PUB.Add_Exc_Msg

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

1145: PROCEDURE Submit_Draft(p_header_id NUMBER,
1146: x_return_status OUT NOCOPY VARCHAR2)
1147: IS
1148: --
1149: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1150: l_activity_name VARCHAR2(30);
1151: l_sales_document_type_code VARCHAR2(1);
1152: l_sales_document_type VARCHAR2(30);
1153: l_entity_code VARCHAR2(30);

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

1161: BEGIN
1162: -- OE_MSG_PUB.initialize; commented out for 4671489
1163: x_return_status := FND_API.G_RET_STS_SUCCESS;
1164: IF l_debug_level > 0 THEN
1165: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Submit_Draft: '|| TO_CHAR (p_header_id) ,1) ;
1166: END IF;
1167:
1168: BEGIN
1169: --Bug3435165

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

1240: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1241: oe_msg_pub.add;
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: IF l_debug_level > 0 THEN
1244: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
1245: END IF;
1246: return;
1247: END;
1248: -- ok to go Submit Draft

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

1250: itemkey => to_char(p_header_id),
1251: activity => l_activity_name,
1252: result => 'COMPLETE');
1253: IF l_debug_level > 0 THEN
1254: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft normally', 1);
1255: END IF;
1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1259: IF l_debug_level > 0 THEN
1260: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
1261: END IF;
1262: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1263: THEN
1264: OE_MSG_PUB.Add_Exc_Msg

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

1274: PROCEDURE set_header_attributes_internal(p_header_id IN NUMBER)
1275: IS
1276: --
1277: l_sales_document_type_code VARCHAR2(1);
1278: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1279: l_sold_to_org_id NUMBER;
1280: l_salesrep_id NUMBER;
1281: l_salesrep VARCHAR2(240);
1282: l_sold_to VARCHAR2(240);

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

1286: l_avaluetext wf_engine.texttabtyp;
1287: --
1288: BEGIN
1289: IF l_debug_level > 0 THEN
1290: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Header_Attributes_Internal:'||To_char(p_header_id) ,1 ) ;
1291: END IF;
1292:
1293: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, To_char(p_header_id), 'SALES_DOCUMENT_TYPE_CODE');
1294: IF l_sales_document_type_code = 'O' THEN

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

1339: funcmode in varchar2,
1340: resultout in out nocopy varchar2)
1341: IS
1342: --
1343: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1344: BEGIN
1345: IF l_debug_level > 0 THEN
1346: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Header_Attributes:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
1347: END IF;

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

1342: --
1343: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1344: BEGIN
1345: IF l_debug_level > 0 THEN
1346: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Header_Attributes:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
1347: END IF;
1348: OE_STANDARD_WF.Set_Msg_Context(actid);
1349: IF (funcmode = 'RUN') THEN
1350: set_header_attributes_internal(To_number(itemkey));

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

1371: funcmode in varchar2,
1372: resultout in out nocopy varchar2)
1373: IS
1374: --
1375: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1376: l_final_timer NUMBER;
1377: l_sales_document_type_code VARCHAR2(1);
1378: l_expiration_date DATE;
1379: --

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

1379: --
1380:
1381: BEGIN
1382: IF l_debug_level > 0 THEN
1383: oe_debug_pub.add( 'ENTERING OE_Negotiate_WF.Set_Final_Expiration_Date:'||ITEMTYPE||'/'||ITEMKEY ,1 ) ;
1384: END IF;
1385: OE_STANDARD_WF.Set_Msg_Context(actid);
1386: IF (funcmode = 'RUN') then
1387: OE_MSG_PUB.set_msg_context(

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

1390: ,p_header_id => to_number(itemkey));
1391:
1392: set_header_attributes_internal(To_number(itemkey));
1393: IF l_debug_level > 0 THEN
1394: oe_debug_pub.add( 'Done setting header attributes',1);
1395: END IF;
1396:
1397: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'SALES_DOCUMENT_TYPE_CODE');
1398: IF l_sales_document_type_code = 'O' THEN

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

1425: resultout := 'COMPLETE:EXPIRED';
1426: END IF;
1427:
1428: IF l_debug_level > 0 THEN
1429: oe_debug_pub.add('Leaving OE_Negotiate_WF.Set_Final_Expiration_Date', 1);
1430: END IF;
1431: END IF;
1432: EXCEPTION
1433: when others then

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

1448: RETURN Boolean
1449: IS
1450:
1451: --
1452: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1453: l_activity_name VARCHAR2(30);
1454: --
1455: l_customer_acceptance VARCHAR2(30) := 'CUSTOMER_ACCEPTANCE';
1456: --

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

1456: --
1457: BEGIN
1458:
1459: IF l_debug_level > 0 THEN
1460: oe_debug_pub.add( 'ENTER OE_Negotiate_WF.At_Customer_Acceptance');
1461: END IF;
1462:
1463: select wpa.activity_name
1464: into l_activity_name