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

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

56:
57: l_aname wf_engine.nametabtyp;
58: l_avaluetext wf_engine.texttabtyp;
59:
60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
61: BEGIN
62:
63: --
64: -- RUN mode - normal process execution

Line 77: oe_debug_pub.add( 'Initiate_Approval ', 1) ;

73: ,p_entity_id => to_number(itemkey)
74: ,p_header_id => to_number(itemkey));
75:
76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( 'Initiate_Approval ', 1) ;
78: END IF;
79:
80: -- Delete any previous approval transaction data.
81: DELETE

Line 97: oe_debug_pub.add( 'Role->' || l_role, 1) ;

93: l_role := Get_Next_Approver_internal(l_transaction_id,
94: itemtype,
95: l_sales_document_type_code);
96: IF l_debug_level > 0 THEN
97: oe_debug_pub.add( 'Role->' || l_role, 1) ;
98: END IF;
99:
100:
101: if l_role is NULL then

Line 103: oe_debug_pub.add('Role is null. Set transaction to Not Eligible', 1 ) ;

99:
100:
101: if l_role is NULL then
102: IF l_debug_level > 0 THEN
103: oe_debug_pub.add('Role is null. Set transaction to Not Eligible', 1 ) ;
104: END IF;
105:
106:
107: /* OE_ORDER_WF_UTIL.Update_Flow_Status_Code

Line 115: oe_debug_pub.add('Initiate_approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );

111: p_sales_document_type_code => l_sales_document_type_code,
112: x_return_status => l_return_status );
113:
114: IF l_debug_level > 0 THEN
115: oe_debug_pub.add('Initiate_approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );
116: END IF;
117:
118: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
119: OE_STANDARD_WF.Save_Messages;

Line 133: oe_debug_pub.add('Setting the role to->' || l_role, 1 ) ;

129: return;
130:
131: else
132: IF l_debug_level > 0 THEN
133: oe_debug_pub.add('Setting the role to->' || l_role, 1 ) ;
134: END IF;
135:
136: wf_engine.SetItemAttrText(itemtype,
137: itemkey,

Line 142: oe_debug_pub.add('Before calling OE_CONTRACTS_UTIL.attachment_location.. ', 1);

138: 'NOTIFICATION_APPROVER',
139: l_role);
140:
141: IF l_debug_level > 0 THEN
142: oe_debug_pub.add('Before calling OE_CONTRACTS_UTIL.attachment_location.. ', 1);
143: END IF;
144:
145: OE_CONTRACTS_UTIL.attachment_location
146: (p_api_version => 1.0,

Line 156: oe_debug_pub.add('l_attachment_location->' || l_attachment_location, 1);

152: x_msg_data => l_msg_data );
153:
154:
155: IF l_debug_level > 0 THEN
156: oe_debug_pub.add('l_attachment_location->' || l_attachment_location, 1);
157: oe_debug_pub.add('l_return_status->' || l_return_status, 1);
158: oe_debug_pub.add('l_msg_data->' || l_msg_data, 1);
159: END IF;
160:

Line 157: oe_debug_pub.add('l_return_status->' || l_return_status, 1);

153:
154:
155: IF l_debug_level > 0 THEN
156: oe_debug_pub.add('l_attachment_location->' || l_attachment_location, 1);
157: oe_debug_pub.add('l_return_status->' || l_return_status, 1);
158: oe_debug_pub.add('l_msg_data->' || l_msg_data, 1);
159: END IF;
160:
161: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 158: oe_debug_pub.add('l_msg_data->' || l_msg_data, 1);

154:
155: IF l_debug_level > 0 THEN
156: oe_debug_pub.add('l_attachment_location->' || l_attachment_location, 1);
157: oe_debug_pub.add('l_return_status->' || l_return_status, 1);
158: oe_debug_pub.add('l_msg_data->' || l_msg_data, 1);
159: END IF;
160:
161: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: -- start data fix project

Line 230: oe_debug_pub.add('Initiate_Approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );

226: p_sales_document_type_code => l_sales_document_type_code,
227: x_return_status => l_return_status );
228:
229: IF l_debug_level > 0 THEN
230: oe_debug_pub.add('Initiate_Approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );
231: END IF;
232:
233: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
234: -- start data fix project

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

317: l_role VARCHAR2(240);
318: l_sales_document_type_code VARCHAR2(30);
319:
320: l_return_status VARCHAR2(30);
321: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
322:
323: l_sold_to_org_id NUMBER;
324: l_salesrep_id NUMBER;
325: l_salesrep VARCHAR2(240);

Line 350: oe_debug_pub.add( 'Get_Next_Approver ', 1 ) ;

346: ,p_entity_id => to_number(itemkey)
347: ,p_header_id => to_number(itemkey));
348:
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'Get_Next_Approver ', 1 ) ;
351: END IF;
352:
353: -- We need to set the status of the last approver to APPROVED here
354: -- in the OE_APPROVER_TRANSACTIONS

Line 376: oe_debug_pub.add('Role-> ' || l_role, 1) ;

372: l_role := Get_Next_Approver_internal(l_transaction_id,
373: itemtype,
374: l_sales_document_type_code);
375: IF l_debug_level > 0 THEN
376: oe_debug_pub.add('Role-> ' || l_role, 1) ;
377: END IF;
378:
379:
380:

Line 392: oe_debug_pub.add('Get_next_approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );

388: p_sales_document_type_code => l_sales_document_type_code,
389: x_return_status => l_return_status );
390:
391: IF l_debug_level > 0 THEN
392: oe_debug_pub.add('Get_next_approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );
393: END IF;
394:
395: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
396: OE_STANDARD_WF.Save_Messages;

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

534: l_transaction_phase_code VARCHAR2(30);
535:
536: l_check_default_list VARCHAR2(1) := 'N';
537:
538: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
539:
540:
541: -- Get the next approver_sequence and its role
542: -- cursor c_get_next_approver (m_cur_seq number, m_list_id number) is

Line 561: oe_debug_pub.add('Get_Next_Approver_internal', 1 ) ;

557:
558:
559: BEGIN
560: IF l_debug_level > 0 THEN
561: oe_debug_pub.add('Get_Next_Approver_internal', 1 ) ;
562: END IF;
563:
564: -- Get the User ID
565: l_user_id := OE_APPROVALS_WF.get_user_id;

Line 571: oe_debug_pub.add('SaleDocumentTypeCode-> ' || p_sales_document_type_code, 1) ;

567: -- First get the transaction_type_id and the transaction_phase
568: -- We need to hit different table to find that out
569:
570: IF l_debug_level > 0 THEN
571: oe_debug_pub.add('SaleDocumentTypeCode-> ' || p_sales_document_type_code, 1) ;
572: END IF;
573:
574: -- If p_sales_document_type_code is not B, it is either a quote or order or line
575: IF nvl(p_sales_document_type_code, 'XXXX') = 'B' THEN

Line 581: oe_debug_pub.add('Transaction_type_id->' || l_transaction_type_id, 1) ;

577: into l_transaction_type_id, l_transaction_phase_code
578: from oe_blanket_headers_all
579: where header_id = p_transaction_id;
580: IF l_debug_level > 0 THEN
581: oe_debug_pub.add('Transaction_type_id->' || l_transaction_type_id, 1) ;
582: oe_debug_pub.add('TransactionPhase->' || l_transaction_phase_code, 1);
583: END IF;
584:
585: ELSE

Line 582: oe_debug_pub.add('TransactionPhase->' || l_transaction_phase_code, 1);

578: from oe_blanket_headers_all
579: where header_id = p_transaction_id;
580: IF l_debug_level > 0 THEN
581: oe_debug_pub.add('Transaction_type_id->' || l_transaction_type_id, 1) ;
582: oe_debug_pub.add('TransactionPhase->' || l_transaction_phase_code, 1);
583: END IF;
584:
585: ELSE
586: select ORDER_TYPE_ID, nvl(TRANSACTION_PHASE_CODE, 'F')

Line 591: oe_debug_pub.add('Transaction_type_id->' || l_transaction_type_id, 1) ;

587: into l_transaction_type_id, l_transaction_phase_code
588: from oe_order_headers_all
589: where header_id = p_transaction_id;
590: IF l_debug_level > 0 THEN
591: oe_debug_pub.add('Transaction_type_id->' || l_transaction_type_id, 1) ;
592: oe_debug_pub.add('TransactionPhase->' || l_transaction_phase_code, 1);
593: END IF;
594:
595: END IF;

Line 592: oe_debug_pub.add('TransactionPhase->' || l_transaction_phase_code, 1);

588: from oe_order_headers_all
589: where header_id = p_transaction_id;
590: IF l_debug_level > 0 THEN
591: oe_debug_pub.add('Transaction_type_id->' || l_transaction_type_id, 1) ;
592: oe_debug_pub.add('TransactionPhase->' || l_transaction_phase_code, 1);
593: END IF;
594:
595: END IF;
596:

Line 608: oe_debug_pub.add('ListID-> ' || l_list_id, 1) ;

604: and TRANSACTION_PHASE_CODE = l_transaction_phase_code
605: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE )
606: AND NVL(END_DATE_ACTIVE, SYSDATE );
607: IF l_debug_level > 0 THEN
608: oe_debug_pub.add('ListID-> ' || l_list_id, 1) ;
609: END IF;
610:
611: EXCEPTION
612: when NO_DATA_FOUND then

Line 614: oe_debug_pub.add('No ListID Found ', 1) ;

610:
611: EXCEPTION
612: when NO_DATA_FOUND then
613: IF l_debug_level > 0 THEN
614: oe_debug_pub.add('No ListID Found ', 1) ;
615: END IF;
616: l_check_default_list := 'Y';
617: end;
618:

Line 631: oe_debug_pub.add('Default ListID-> ' || l_list_id, 1) ;

627: and TRANSACTION_PHASE_CODE is NULL
628: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE )
629: AND NVL(END_DATE_ACTIVE, SYSDATE );
630: IF l_debug_level > 0 THEN
631: oe_debug_pub.add('Default ListID-> ' || l_list_id, 1) ;
632: END IF;
633:
634: EXCEPTION
635: when NO_DATA_FOUND then

Line 637: oe_debug_pub.add('No Default ListID Found ', 1) ;

633:
634: EXCEPTION
635: when NO_DATA_FOUND then
636: IF l_debug_level > 0 THEN
637: oe_debug_pub.add('No Default ListID Found ', 1) ;
638: END IF;
639: l_role := NULL;
640: return l_role;
641: end;

Line 658: oe_debug_pub.add('Max Curr APPROVER_SEQUENCE-> ' || l_curr_approver_sequence, 1);

654: and TRANSACTION_TYPE_ID = l_transaction_type_id
655: and TRANSACTION_PHASE_CODE = l_transaction_phase_code;
656:
657: IF l_debug_level > 0 THEN
658: oe_debug_pub.add('Max Curr APPROVER_SEQUENCE-> ' || l_curr_approver_sequence, 1);
659: END IF;
660: IF l_curr_approver_sequence is null Then
661: l_curr_approver_sequence := 0;
662: END IF;

Line 667: oe_debug_pub.add('Max Curr APPROVER_SEQUENCE-> ' || l_curr_approver_sequence, 1);

663:
664: EXCEPTION
665: when NO_DATA_FOUND then
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.add('Max Curr APPROVER_SEQUENCE-> ' || l_curr_approver_sequence, 1);
668: END IF;
669:
670: l_curr_approver_sequence := 0;
671: END;

Line 683: oe_debug_pub.add('No Role ', 1) ;

679: INTO l_role, l_approver_sequence;
680:
681: if c_get_next_approver%notfound then
682: IF l_debug_level > 0 THEN
683: oe_debug_pub.add('No Role ', 1) ;
684: END IF;
685:
686: l_role := NULL;
687: CLOSE c_get_next_approver;

Line 693: oe_debug_pub.add('Role-> ' || l_role, 1) ;

689:
690: end if;
691:
692: CLOSE c_get_next_approver;
693: oe_debug_pub.add('Role-> ' || l_role, 1) ;
694:
695:
696: IF p_query_mode = 'N' THEN
697: IF l_debug_level > 0 THEN

Line 698: oe_debug_pub.add('Inserting into OE_APPROVER_TRANSACTIONS ', 1) ;

694:
695:
696: IF p_query_mode = 'N' THEN
697: IF l_debug_level > 0 THEN
698: oe_debug_pub.add('Inserting into OE_APPROVER_TRANSACTIONS ', 1) ;
699: END IF;
700: -- insert this next approver in the OE_APPROVER_TRANSACTIONS
701: INSERT INTO OE_APPROVER_TRANSACTIONS
702: (

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

751:
752: l_transaction_id NUMBER;
753: l_sales_document_type_code VARCHAR2(30);
754: l_return_status VARCHAR2(30);
755: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
756:
757: BEGIN
758:
759: --

Line 780: oe_debug_pub.add('Approve_Approval.. ', 1) ;

776: ,p_entity_id => to_number(itemkey)
777: ,p_header_id => to_number(itemkey));
778:
779: IF l_debug_level > 0 THEN
780: oe_debug_pub.add('Approve_Approval.. ', 1) ;
781: END IF;
782:
783: OE_ORDER_WF_UTIL.Update_Flow_Status_Code
784: (p_item_type => itemtype,

Line 791: oe_debug_pub.add('Approve_Approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );

787: p_sales_document_type_code => l_sales_document_type_code,
788: x_return_status => l_return_status );
789:
790: IF l_debug_level > 0 THEN
791: oe_debug_pub.add('Approve_Approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );
792: END IF;
793:
794: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
795: -- start data fix project

Line 846: oe_debug_pub.add('Exception in Reject_Approval.. ' ,1) ;

842: when others then
843: -- The line below records this function call in the error system
844: -- in the case of an exception.
845: IF l_debug_level > 0 THEN
846: oe_debug_pub.add('Exception in Reject_Approval.. ' ,1) ;
847: END IF;
848: wf_core.context('OE_APPROVALS_WF', 'Approve_Approval',
849: itemtype, itemkey, to_char(actid), funcmode);
850: -- start data fix project

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

880: l_current_approver varchar2(320);
881: l_sales_document_type_code VARCHAR2(30);
882: l_transaction_id NUMBER;
883: l_return_status VARCHAR2(30);
884: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
885:
886: BEGIN
887:
888: --

Line 902: oe_debug_pub.add('Approval_Timeout.. ', 1) ;

898: ,p_entity_id => to_number(itemkey)
899: ,p_header_id => to_number(itemkey));
900:
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add('Approval_Timeout.. ', 1) ;
903: END IF;
904:
905:
906: IF nvl(OE_SYS_PARAMETERS.value('NO_RESPONSE_FROM_APPROVER'), 'CONTINUE') ='CONTINUE' THEN

Line 978: oe_debug_pub.add('Exception in Approval_Timeout.. ' ,1) ;

974: when others then
975: -- The line below records this function call in the error system
976: -- in the case of an exception.
977: IF l_debug_level > 0 THEN
978: oe_debug_pub.add('Exception in Approval_Timeout.. ' ,1) ;
979: END IF;
980: wf_core.context('OE_APPROVALS_WF', 'Approval_Timeout',
981: itemtype, itemkey, to_char(actid), funcmode);
982: -- start data fix project

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

1012: IS
1013:
1014: l_transaction_id NUMBER;
1015: l_return_status VARCHAR2(30);
1016: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1017:
1018: BEGIN
1019:
1020: --

Line 1034: oe_debug_pub.add('Reject_Approval.. ', 1) ;

1030: ,p_entity_id => to_number(itemkey)
1031: ,p_header_id => to_number(itemkey));
1032:
1033: IF l_debug_level > 0 THEN
1034: oe_debug_pub.add('Reject_Approval.. ', 1) ;
1035: END IF;
1036:
1037: BEGIN
1038: UPDATE OE_APPROVER_TRANSACTIONS

Line 1067: oe_debug_pub.add('Reject_Approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );

1063: x_return_status => l_return_status);
1064: END IF;
1065:
1066: IF l_debug_level > 0 THEN
1067: oe_debug_pub.add('Reject_Approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );
1068: END IF;
1069:
1070: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1071: -- start data fix project

Line 1120: oe_debug_pub.add('Exception in Reject_Approval.. ' ,1) ;

1116: when others then
1117: -- The line below records this function call in the error system
1118: -- in the case of an exception.
1119: IF l_debug_level > 0 THEN
1120: oe_debug_pub.add('Exception in Reject_Approval.. ' ,1) ;
1121: END IF;
1122: wf_core.context('OE_APPROVALS_WF', 'Reject_Approval',
1123: itemtype, itemkey, to_char(actid), funcmode);
1124: -- start data fix project

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

1158: l_user_id NUMBER;
1159: l_transaction_type_id NUMBER;
1160: l_transaction_phase_code VARCHAR2(30);
1161:
1162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1163:
1164: Begin
1165: IF l_debug_level > 0 THEN
1166: oe_debug_pub.add('Get_Current_Approver.. ' ,1) ;

Line 1166: oe_debug_pub.add('Get_Current_Approver.. ' ,1) ;

1162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1163:
1164: Begin
1165: IF l_debug_level > 0 THEN
1166: oe_debug_pub.add('Get_Current_Approver.. ' ,1) ;
1167: END IF;
1168:
1169:
1170: -- select to_number(ITEM_KEY)

Line 1184: oe_debug_pub.add('ItemKey/Current Role' || l_transaction_id || '/'

1180:
1181: l_role := Get_Current_Approver_internal (l_transaction_id);
1182:
1183: IF l_debug_level > 0 THEN
1184: oe_debug_pub.add('ItemKey/Current Role' || l_transaction_id || '/'
1185: || l_role,1);
1186: END IF;
1187:
1188:

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

1200: return varchar2
1201: IS
1202: l_role varchar2(320);
1203:
1204: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1205:
1206: BEGIN
1207:
1208: IF l_debug_level > 0 THEN

Line 1209: oe_debug_pub.add('In function Get_Current_Approver_internal....', 1);

1205:
1206: BEGIN
1207:
1208: IF l_debug_level > 0 THEN
1209: oe_debug_pub.add('In function Get_Current_Approver_internal....', 1);
1210: END IF;
1211:
1212: BEGIN
1213: select role

Line 1224: oe_debug_pub.add('No OE_APPROVER_TRANSACTIONS for TransactionID:'

1220:
1221: EXCEPTION
1222: WHEN NO_DATA_FOUND THEN
1223: IF l_debug_level > 0 THEN
1224: oe_debug_pub.add('No OE_APPROVER_TRANSACTIONS for TransactionID:'
1225: || p_transaction_id ,1);
1226: l_role := null;-- 6615403
1227: END IF;
1228:

Line 1232: oe_debug_pub.add('ItemKey/Current Role' || p_transaction_id || '/'

1228:
1229:
1230: END;
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add('ItemKey/Current Role' || p_transaction_id || '/'
1233: || l_role,1);
1234: END IF;
1235: RETURN l_role;-- 6615403
1236:

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

1249: l_sales_document_type_code VARCHAR2(30);
1250: l_sales_document_type_desc VARCHAR2(80);
1251: l_transaction_id NUMBER;
1252:
1253: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1254:
1255: BEGIN
1256: IF l_debug_level > 0 THEN
1257: oe_debug_pub.add('Get_Sales_Document_Type...',1);

Line 1257: oe_debug_pub.add('Get_Sales_Document_Type...',1);

1253: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1254:
1255: BEGIN
1256: IF l_debug_level > 0 THEN
1257: oe_debug_pub.add('Get_Sales_Document_Type...',1);
1258: END IF;
1259:
1260: -- select to_number(ITEM_KEY)
1261: -- into l_transaction_id

Line 1284: oe_debug_pub.add('Sales_Document_Type_Code:' || l_sales_document_type_code,1);

1280: where LOOKUP_TYPE = 'SALES_DOCUMENT_TYPE'
1281: and LOOKUP_CODE = l_sales_document_type_code;
1282:
1283: IF l_debug_level > 0 THEN
1284: oe_debug_pub.add('Sales_Document_Type_Code:' || l_sales_document_type_code,1);
1285: END IF;
1286:
1287: document := l_sales_document_type_desc;
1288: EXCEPTION