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 231: oe_debug_pub.add('Initiate_Approval STATUS FROM Update_Flow_Status_Code: '|| l_return_status );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1365: l_nego_details VARCHAR2 (1000);
1366: l_nego_short_desc VARCHAR2 (1000);
1367: l_order_number NUMBER;
1368: l_rma_descriptor VARCHAR2 (1000);
1369: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1370: l_ame_transaction VARCHAR2 (250);
1371: l_item_type VARCHAR2 (10) := 'OEAME';
1372: l_nego_url VARCHAR2 (1000);
1373: l_order_url VARCHAR2 (1000);

Line 1387: oe_debug_pub.ADD ('Inside get_ame_approvers_launch:funcmode '

1383: SAVEPOINT get_ame_approvers_launch; --establishing save point here.
1384:
1385: IF l_debug_level > 0
1386: THEN
1387: oe_debug_pub.ADD ('Inside get_ame_approvers_launch:funcmode '
1388: || funcmode
1389: );
1390: END IF;
1391:

Line 1399: oe_debug_pub.ADD ('funcmode is run');

1395: IF (funcmode = 'RUN')
1396: THEN
1397: IF l_debug_level > 0
1398: THEN
1399: oe_debug_pub.ADD ('funcmode is run');
1400: END IF;
1401:
1402: l_transaction_type_id := itemtype; --'OENH';
1403: l_transaction_id := TO_NUMBER (itemkey);

Line 1418: oe_debug_pub.ADD ('Initiate_Approval');

1414: );
1415:
1416: IF l_debug_level > 0
1417: THEN
1418: oe_debug_pub.ADD ('Initiate_Approval');
1419: END IF;
1420:
1421: -- Delete any previous approval transaction data.
1422: DELETE FROM oe_approver_transactions

Line 1435: oe_debug_pub.ADD ( 'l_sales_document_type_code= '

1431: );
1432:
1433: IF l_debug_level > 0
1434: THEN
1435: oe_debug_pub.ADD ( 'l_sales_document_type_code= '
1436: || l_sales_document_type_code
1437: );
1438: END IF;
1439:

Line 1459: oe_debug_pub.ADD

1455: --Plug in New API Code Here
1456: ------------
1457: IF l_debug_level > 0
1458: THEN
1459: oe_debug_pub.ADD
1460: ('Getting the AME transaction type associated with this header');
1461: END IF;
1462:
1463: IF itemtype = oe_globals.g_wfi_ngo

Line 1467: oe_debug_pub.ADD ('item type is negotiation so AME TTY is OENEG');

1463: IF itemtype = oe_globals.g_wfi_ngo
1464: THEN
1465: IF l_debug_level > 0
1466: THEN
1467: oe_debug_pub.ADD ('item type is negotiation so AME TTY is OENEG');
1468: END IF;
1469:
1470: IF l_sales_document_type_code = 'O' THEN
1471:

Line 1481: oe_debug_pub.ADD ('item type is header so AME TTY is OERMA');

1477: ELSIF itemtype = oe_globals.g_wfi_hdr
1478: THEN
1479: IF l_debug_level > 0
1480: THEN
1481: oe_debug_pub.ADD ('item type is header so AME TTY is OERMA');
1482: END IF;
1483:
1484: l_ame_transaction := 'OERMA';
1485: END IF;

Line 1489: oe_debug_pub.ADD

1485: END IF;
1486:
1487: IF l_debug_level > 0
1488: THEN
1489: oe_debug_pub.ADD
1490: ( 'AME transaction type associated with this header is:'
1491: || l_ame_transaction
1492: );
1493: oe_debug_pub.ADD ('Before calling AME API :' || TO_NUMBER (itemkey));

Line 1493: oe_debug_pub.ADD ('Before calling AME API :' || TO_NUMBER (itemkey));

1489: oe_debug_pub.ADD
1490: ( 'AME transaction type associated with this header is:'
1491: || l_ame_transaction
1492: );
1493: oe_debug_pub.ADD ('Before calling AME API :' || TO_NUMBER (itemkey));
1494: END IF;
1495:
1496: -- 16084377 unnecessary notification bug
1497:

Line 1508: oe_debug_pub.ADD ('no approvers.May be quote/bsa/rma does not qualify AME rules');

1504: approversout => approverlist
1505: );
1506:
1507: IF approverlist.COUNT = 0 THEN
1508: oe_debug_pub.ADD ('no approvers.May be quote/bsa/rma does not qualify AME rules');
1509: resultout := 'COMPLETE:NOT_APPLICABLE';
1510: RETURN;
1511: END IF ;
1512: EXCEPTION

Line 1568: oe_debug_pub.ADD ( 'AFTER calling AME API :'

1564: IF l_next_approvers.COUNT > 0
1565: THEN
1566: IF l_debug_level > 0
1567: THEN
1568: oe_debug_pub.ADD ( 'AFTER calling AME API :'
1569: || l_next_approvers.COUNT
1570: );
1571: oe_debug_pub.ADD ( 'nextApproversOut = '
1572: || l_next_approvers (1).NAME

Line 1571: oe_debug_pub.ADD ( 'nextApproversOut = '

1567: THEN
1568: oe_debug_pub.ADD ( 'AFTER calling AME API :'
1569: || l_next_approvers.COUNT
1570: );
1571: oe_debug_pub.ADD ( 'nextApproversOut = '
1572: || l_next_approvers (1).NAME
1573: || '----'
1574: || l_complete
1575: );

Line 1584: oe_debug_pub.ADD ('Fully Approved');

1580: IF l_complete = ame_util2.completefullyapproved
1581: THEN
1582: IF l_debug_level > 0
1583: THEN
1584: oe_debug_pub.ADD ('Fully Approved');
1585: END IF;
1586: ELSIF l_complete = ame_util2.completefullyrejected
1587: THEN
1588: IF l_debug_level > 0

Line 1590: oe_debug_pub.ADD ('Fully Rejected');

1586: ELSIF l_complete = ame_util2.completefullyrejected
1587: THEN
1588: IF l_debug_level > 0
1589: THEN
1590: oe_debug_pub.ADD ('Fully Rejected');
1591: END IF;
1592: ELSIF l_complete = ame_util2.completepartiallyapproved
1593: THEN
1594: IF l_debug_level > 0

Line 1596: oe_debug_pub.ADD ('Partially Approved');

1592: ELSIF l_complete = ame_util2.completepartiallyapproved
1593: THEN
1594: IF l_debug_level > 0
1595: THEN
1596: oe_debug_pub.ADD ('Partially Approved');
1597: END IF;
1598: ELSIF l_complete = ame_util2.completenoapprovers
1599: THEN
1600: IF l_debug_level > 0

Line 1602: oe_debug_pub.ADD ('No Approvers');

1598: ELSIF l_complete = ame_util2.completenoapprovers
1599: THEN
1600: IF l_debug_level > 0
1601: THEN
1602: oe_debug_pub.ADD ('No Approvers');
1603: END IF;
1604: ELSIF l_complete = ame_util2.notcompleted
1605: THEN
1606: IF l_debug_level > 0

Line 1608: oe_debug_pub.ADD ('Not Completed');

1604: ELSIF l_complete = ame_util2.notcompleted
1605: THEN
1606: IF l_debug_level > 0
1607: THEN
1608: oe_debug_pub.ADD ('Not Completed');
1609: END IF;
1610: END IF;
1611:
1612: -- Loop through approvers' table returned by AME

Line 1617: oe_debug_pub.ADD ( 'l_next_approvers.count= '

1613: IF l_complete = ame_util.booleanfalse
1614: THEN
1615: IF l_debug_level > 0
1616: THEN
1617: oe_debug_pub.ADD ( 'l_next_approvers.count= '
1618: || l_next_approvers.COUNT
1619: || '---'
1620: || l_index.COUNT
1621: || '---'

Line 1632: oe_debug_pub.ADD

1628: l_next_approver := l_next_approvers (l_table);
1629:
1630: IF l_debug_level > 0
1631: THEN
1632: oe_debug_pub.ADD
1633: ( '***nextApproversOut = '
1634: || l_next_approvers (l_table).NAME
1635: || '-'
1636: || l_next_approvers (l_table).group_or_chain_order_number

Line 1640: oe_debug_pub.ADD

1636: || l_next_approvers (l_table).group_or_chain_order_number
1637: || '-'
1638: || l_next_approvers (l_table).member_order_number
1639: );
1640: oe_debug_pub.ADD
1641: ( '***nextApproversOut = '
1642: || l_next_approvers (l_table).action_type_id
1643: || '-'
1644: || l_next_approvers (l_table).occurrence

Line 1648: oe_debug_pub.ADD

1644: || l_next_approvers (l_table).occurrence
1645: || '-'
1646: || l_next_approvers (l_table).SOURCE
1647: );
1648: oe_debug_pub.ADD
1649: ( '***nextApproversOut = '
1650: || l_next_approvers (l_table).item_class
1651: || '-'
1652: || l_next_approvers (l_table).item_id

Line 1656: oe_debug_pub.ADD

1652: || l_next_approvers (l_table).item_id
1653: || '-'
1654: || l_next_approvers (l_table).item_order_number
1655: );
1656: oe_debug_pub.ADD
1657: ( '***nextApproversOut = '
1658: || l_next_approvers (l_table).action_type_order_number
1659: || '-'
1660: || l_next_approvers (l_table).approver_order_number

Line 1664: oe_debug_pub.ADD ( 'Inside Approvals LOOP'

1660: || l_next_approvers (l_table).approver_order_number
1661: || '-'
1662: || l_next_approvers (l_table).approval_status
1663: );
1664: oe_debug_pub.ADD ( 'Inside Approvals LOOP'
1665: || '-'
1666: || l_next_approvers (l_table).NAME
1667: || '-'
1668: || l_next_approvers (l_table).item_class

Line 1682: oe_debug_pub.ADD ('Role->' || l_role, 1);

1678: l_orig_system_id := l_next_approvers (l_table).orig_system_id;
1679:
1680: IF l_debug_level > 0
1681: THEN
1682: oe_debug_pub.ADD ('Role->' || l_role, 1);
1683: END IF;
1684:
1685: IF l_role IS NULL
1686: THEN

Line 1689: oe_debug_pub.ADD

1685: IF l_role IS NULL
1686: THEN
1687: IF l_debug_level > 0
1688: THEN
1689: oe_debug_pub.ADD
1690: ('Role is null. Set transaction to Not Eligible',
1691: 1
1692: );
1693: END IF;

Line 1702: oe_debug_pub.ADD ('role is not null.Launch workflows');

1698: RETURN;
1699: ELSE
1700: IF l_debug_level > 0
1701: THEN
1702: oe_debug_pub.ADD ('role is not null.Launch workflows');
1703: END IF;
1704:
1705: SELECT TO_CHAR (oe_ame_parallel_s.NEXTVAL)
1706: INTO l_item_key

Line 1711: oe_debug_pub.ADD ('item key derived is:' || l_item_key);

1707: FROM SYS.DUAL;
1708:
1709: IF l_debug_level > 0
1710: THEN
1711: oe_debug_pub.ADD ('item key derived is:' || l_item_key);
1712: END IF;
1713:
1714: -- Create a child process for the retrieved approver.
1715: IF itemtype = 'OENH'

Line 1816: oe_debug_pub.ADD

1812: );
1813:
1814: IF l_debug_level > 0
1815: THEN
1816: oe_debug_pub.ADD
1817: ('Before calling OE_CONTRACTS_UTIL.attachment_location.. ',
1818: 1
1819: );
1820: END IF;

Line 1834: oe_debug_pub.ADD ( 'l_attachment_location->'

1830: );
1831:
1832: IF l_debug_level > 0
1833: THEN
1834: oe_debug_pub.ADD ( 'l_attachment_location->'
1835: || l_attachment_location,
1836: 1
1837: );
1838: oe_debug_pub.ADD ( 'l_return_status->'

Line 1838: oe_debug_pub.ADD ( 'l_return_status->'

1834: oe_debug_pub.ADD ( 'l_attachment_location->'
1835: || l_attachment_location,
1836: 1
1837: );
1838: oe_debug_pub.ADD ( 'l_return_status->'
1839: || l_return_status,
1840: 1
1841: );
1842: oe_debug_pub.ADD ('l_msg_data->' || l_msg_data, 1);

Line 1842: oe_debug_pub.ADD ('l_msg_data->' || l_msg_data, 1);

1838: oe_debug_pub.ADD ( 'l_return_status->'
1839: || l_return_status,
1840: 1
1841: );
1842: oe_debug_pub.ADD ('l_msg_data->' || l_msg_data, 1);
1843: END IF;
1844:
1845: IF l_return_status = fnd_api.g_ret_sts_error
1846: THEN

Line 1952: oe_debug_pub.ADD ('before calling start process');

1948:
1949: -- End setting Header Attributes
1950: IF l_debug_level > 0
1951: THEN
1952: oe_debug_pub.ADD ('before calling start process');
1953: END IF;
1954: END IF;
1955:
1956: wf_engine.setitemattrtextarray (l_item_type,

Line 1987: oe_debug_pub.ADD

1983: );
1984:
1985: IF l_debug_level > 0
1986: THEN
1987: oe_debug_pub.ADD
1988: ( 'Initiate_Approval STATUS FROM Update_Flow_Status_Code: '
1989: || l_return_status
1990: );
1991: END IF;

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

2063: resultout OUT NOCOPY VARCHAR2
2064: )
2065: IS
2066: l_exception VARCHAR2 (100);
2067: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2068: BEGIN
2069: IF l_debug_level >0 THEN
2070: oe_debug_pub.ADD ('Checking if there is AME exception');
2071: END IF ;

Line 2070: oe_debug_pub.ADD ('Checking if there is AME exception');

2066: l_exception VARCHAR2 (100);
2067: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2068: BEGIN
2069: IF l_debug_level >0 THEN
2070: oe_debug_pub.ADD ('Checking if there is AME exception');
2071: END IF ;
2072: l_exception :=
2073: wf_engine.getitemattrtext (itemtype => itemtype,
2074: itemkey => itemkey,

Line 2078: oe_debug_pub.ADD ('ame exception is:' || l_exception);

2074: itemkey => itemkey,
2075: aname => 'AME_EXCEPTION'
2076: );
2077: IF l_debug_level >0 THEN
2078: oe_debug_pub.ADD ('ame exception is:' || l_exception);
2079: END IF ;
2080:
2081: IF l_exception IS NULL
2082: THEN

Line 2085: oe_debug_pub.ADD ('ame exception is:' || l_exception);

2081: IF l_exception IS NULL
2082: THEN
2083: resultout := 'COMPLETE:N';
2084: IF l_debug_level >0 THEN
2085: oe_debug_pub.ADD ('ame exception is:' || l_exception);
2086: END IF ;
2087: ELSE
2088: resultout := 'COMPLETE:Y';
2089: END IF;

Line 2091: oe_debug_pub.ADD ('Exiting is AME exception');

2087: ELSE
2088: resultout := 'COMPLETE:Y';
2089: END IF;
2090: IF l_debug_level >0 THEN
2091: oe_debug_pub.ADD ('Exiting is AME exception');
2092: END IF ;
2093: EXCEPTION
2094: WHEN OTHERS
2095: THEN

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

2117: resultout OUT NOCOPY VARCHAR2
2118: )
2119: IS
2120: l_open_children NUMBER := 0;
2121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2122: BEGIN
2123: IF l_debug_level > 0 THEN
2124: oe_debug_pub.ADD ('entering check_parallel_wf_status');
2125: END IF ;

Line 2124: oe_debug_pub.ADD ('entering check_parallel_wf_status');

2120: l_open_children NUMBER := 0;
2121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2122: BEGIN
2123: IF l_debug_level > 0 THEN
2124: oe_debug_pub.ADD ('entering check_parallel_wf_status');
2125: END IF ;
2126:
2127: SELECT COUNT (1)
2128: INTO l_open_children

Line 2143: oe_debug_pub.ADD ('exiting check_parallel_wf_status');

2139: ELSE
2140: resultout := 'COMPLETE:NOT_EXISTS';
2141: END IF;
2142: IF l_debug_level > 0 THEN
2143: oe_debug_pub.ADD ('exiting check_parallel_wf_status');
2144: END IF ;
2145: EXCEPTION
2146: WHEN OTHERS
2147: THEN

Line 2149: oe_debug_pub.ADD ('error in check parallel wf status:' || SQLERRM);

2145: EXCEPTION
2146: WHEN OTHERS
2147: THEN
2148: IF l_debug_level > 0 THEN
2149: oe_debug_pub.ADD ('error in check parallel wf status:' || SQLERRM);
2150: END IF ;
2151: wf_core.CONTEXT ('OE_Approvals_WF',
2152: 'check_parallel_wf_status',
2153: itemtype,

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

2176: IS
2177: SELECT item_type, item_key
2178: FROM wf_items
2179: WHERE parent_item_type = itemtype AND parent_item_key = itemkey;
2180: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2181: BEGIN
2182: IF l_debug_level >0 THEN
2183: oe_debug_pub.ADD ('Inside treat_ame_exception_as');
2184: END IF ;

Line 2183: oe_debug_pub.ADD ('Inside treat_ame_exception_as');

2179: WHERE parent_item_type = itemtype AND parent_item_key = itemkey;
2180: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2181: BEGIN
2182: IF l_debug_level >0 THEN
2183: oe_debug_pub.ADD ('Inside treat_ame_exception_as');
2184: END IF ;
2185:
2186: IF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'), 'REJECTION') =
2187: 'APPROVAL'

Line 2191: oe_debug_pub.ADD ('Treating as approval');

2187: 'APPROVAL'
2188: THEN
2189: resultout := 'COMPLETE:APPROVAL';
2190: IF l_debug_level > 0 THEN
2191: oe_debug_pub.ADD ('Treating as approval');
2192: END IF ;
2193: oe_standard_wf.clear_msg_context;
2194: RETURN;
2195: ELSIF NVL (oe_sys_parameters.VALUE ('TREAT_AME_EXCEPTION'), 'REJECTION') =

Line 2206: oe_debug_pub.ADD ('Treating as rejection');

2202: END LOOP;
2203:
2204: resultout := 'COMPLETE:REJECTION';
2205: IF l_debug_level > 0 THEN
2206: oe_debug_pub.ADD ('Treating as rejection');
2207: END IF ;
2208: oe_standard_wf.clear_msg_context;
2209: RETURN;
2210: END IF;

Line 2215: oe_debug_pub.ADD ('error in treat ame exceptions as:' || SQLERRM);

2211: EXCEPTION
2212: WHEN OTHERS
2213: THEN
2214: IF l_debug_level > 0 THEN
2215: oe_debug_pub.ADD ('error in treat ame exceptions as:' || SQLERRM);
2216: END IF ;
2217: wf_core.CONTEXT ('OE_Approvals_WF',
2218: 'treat_ame_exception_as',
2219: itemtype,

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

2237: funcmode IN VARCHAR2,
2238: resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2239: )
2240: IS
2241: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2242: BEGIN
2243: IF l_debug_level > 0
2244: THEN
2245: oe_debug_pub.ADD ('Entering get notification attributes');

Line 2245: oe_debug_pub.ADD ('Entering get notification attributes');

2241: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2242: BEGIN
2243: IF l_debug_level > 0
2244: THEN
2245: oe_debug_pub.ADD ('Entering get notification attributes');
2246: END IF;
2247:
2248: oe_approvals_wf.g_ame_used := 'Y';
2249:

Line 2254: oe_debug_pub.ADD ('Exiting get notification attributes');

2250: -- can add code in future if required. Leaving blank for now as we are already setting the attributes
2251: --from parent itself
2252: IF l_debug_level > 0
2253: THEN
2254: oe_debug_pub.ADD ('Exiting get notification attributes');
2255: END IF;
2256:
2257: resultout := 'COMPLETE:NULL';
2258: EXCEPTION

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

2285: l_transaction_id NUMBER;
2286: l_role VARCHAR2 (240);
2287: l_sales_document_type_code VARCHAR2 (30);
2288: l_return_status VARCHAR2 (30);
2289: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2290: l_sold_to_org_id NUMBER;
2291: l_salesrep_id NUMBER;
2292: l_salesrep VARCHAR2 (240);
2293: l_sold_to VARCHAR2 (240);

Line 2353: oe_debug_pub.ADD ('Error in getting parent item key:'

2349: EXCEPTION
2350: WHEN OTHERS
2351: THEN
2352: IF l_debug_level > 0 THEN
2353: oe_debug_pub.ADD ('Error in getting parent item key:'
2354: || SQLERRM
2355: );
2356: END IF ;
2357: END;

Line 2371: oe_debug_pub.ADD ('Entering PROCESS_RESPONSE_APPROVE ', 1);

2367: );
2368:
2369: IF l_debug_level > 0
2370: THEN
2371: oe_debug_pub.ADD ('Entering PROCESS_RESPONSE_APPROVE ', 1);
2372: END IF;
2373:
2374: -- We need to set the status of the last approver to APPROVED here
2375: -- in the OE_APPROVER_TRANSACTIONS

Line 2394: oe_debug_pub.ADD ('l_sales_document_type_code - Exception');

2390: EXCEPTION
2391: WHEN OTHERS
2392: THEN
2393: IF l_debug_level > 0 THEN
2394: oe_debug_pub.ADD ('l_sales_document_type_code - Exception');
2395: oe_debug_pub.ADD
2396: ( 'l_sales_document_type_code - Exception'
2397: || SQLERRM
2398: );

Line 2395: oe_debug_pub.ADD

2391: WHEN OTHERS
2392: THEN
2393: IF l_debug_level > 0 THEN
2394: oe_debug_pub.ADD ('l_sales_document_type_code - Exception');
2395: oe_debug_pub.ADD
2396: ( 'l_sales_document_type_code - Exception'
2397: || SQLERRM
2398: );
2399: END IF ;

Line 2408: oe_debug_pub.ADD ('l_setp - ' || l_step);

2404: ------------
2405: BEGIN
2406: l_step := 'get Attr for N APP';
2407: IF l_debug_level > 0 THEN
2408: oe_debug_pub.ADD ('l_setp - ' || l_step);
2409: oe_debug_pub.ADD ('l_setp - ' || l_step);
2410: END IF ;
2411: l_name :=
2412: wf_engine.getitemattrtext (itemtype,

Line 2409: oe_debug_pub.ADD ('l_setp - ' || l_step);

2405: BEGIN
2406: l_step := 'get Attr for N APP';
2407: IF l_debug_level > 0 THEN
2408: oe_debug_pub.ADD ('l_setp - ' || l_step);
2409: oe_debug_pub.ADD ('l_setp - ' || l_step);
2410: END IF ;
2411: l_name :=
2412: wf_engine.getitemattrtext (itemtype,
2413: l_transaction_id,

Line 2432: oe_debug_pub.ADD ( 'l_name - '

2428: l_transaction_id,
2429: 'USER_ID'
2430: );
2431: IF l_debug_level > 0 THEN
2432: oe_debug_pub.ADD ( 'l_name - '
2433: || l_name
2434: || ' Orig System - '
2435: || l_orig_system
2436: || 'Orig Sys ID - '

Line 2461: oe_debug_pub.ADD ('l_setp - ' || l_step);

2457: THEN
2458: --L_User_Id := L_Orig_System_Id;
2459: l_step := 'updateApprovalStatus2';
2460: IF l_debug_level > 0 THEN
2461: oe_debug_pub.ADD ('l_setp - ' || l_step);
2462: oe_debug_pub.ADD ('l_setp - ' || l_step);
2463: END IF ;
2464: ame_api2.updateapprovalstatus2
2465: (applicationidin => 660,

Line 2462: oe_debug_pub.ADD ('l_setp - ' || l_step);

2458: --L_User_Id := L_Orig_System_Id;
2459: l_step := 'updateApprovalStatus2';
2460: IF l_debug_level > 0 THEN
2461: oe_debug_pub.ADD ('l_setp - ' || l_step);
2462: oe_debug_pub.ADD ('l_setp - ' || l_step);
2463: END IF ;
2464: ame_api2.updateapprovalstatus2
2465: (applicationidin => 660,
2466: transactiontypein => l_ame_transaction_type,

Line 2481: oe_debug_pub.ADD ('l_setp - ' || l_step);

2477: THEN
2478: l_user_id := l_orig_system_id;
2479: l_step := 'updateApprovalStatus2';
2480: IF l_debug_level > 0 THEN
2481: oe_debug_pub.ADD ('l_setp - ' || l_step);
2482: oe_debug_pub.ADD ('l_setp - ' || l_step);
2483: END IF ;
2484: ame_api2.updateapprovalstatus2
2485: (applicationidin => 660,

Line 2482: oe_debug_pub.ADD ('l_setp - ' || l_step);

2478: l_user_id := l_orig_system_id;
2479: l_step := 'updateApprovalStatus2';
2480: IF l_debug_level > 0 THEN
2481: oe_debug_pub.ADD ('l_setp - ' || l_step);
2482: oe_debug_pub.ADD ('l_setp - ' || l_step);
2483: END IF ;
2484: ame_api2.updateapprovalstatus2
2485: (applicationidin => 660,
2486: transactiontypein => l_ame_transaction_type,

Line 2501: oe_debug_pub.ADD ('l_setp - ' || l_step);

2497: THEN
2498: l_person_id := l_orig_system_id;
2499: l_step := 'updateApprovalStatus2';
2500: IF l_debug_level > 0 THEN
2501: oe_debug_pub.ADD ('l_setp - ' || l_step);
2502: oe_debug_pub.ADD ('l_setp - ' || l_step);
2503: END IF ;
2504: ame_api2.updateapprovalstatus2
2505: (applicationidin => 660,

Line 2502: oe_debug_pub.ADD ('l_setp - ' || l_step);

2498: l_person_id := l_orig_system_id;
2499: l_step := 'updateApprovalStatus2';
2500: IF l_debug_level > 0 THEN
2501: oe_debug_pub.ADD ('l_setp - ' || l_step);
2502: oe_debug_pub.ADD ('l_setp - ' || l_step);
2503: END IF ;
2504: ame_api2.updateapprovalstatus2
2505: (applicationidin => 660,
2506: transactiontypein => l_ame_transaction_type,

Line 2520: oe_debug_pub.ADD ( 'USER ID - '

2516: END IF;
2517:
2518: resultout := 'COMPLETE';
2519: IF l_debug_level > 0 THEN
2520: oe_debug_pub.ADD ( 'USER ID - '
2521: || l_user_id
2522: || ' Person ID - '
2523: || l_person_id
2524: );

Line 2525: oe_debug_pub.ADD ( 'USER ID - '

2521: || l_user_id
2522: || ' Person ID - '
2523: || l_person_id
2524: );
2525: oe_debug_pub.ADD ( 'USER ID - '
2526: || l_user_id
2527: || ' Person ID - '
2528: || l_person_id
2529: );

Line 2546: oe_debug_pub.ADD

2542: l_aname,
2543: l_avaluetext
2544: );
2545: IF l_debug_level > 0 THEN
2546: oe_debug_pub.ADD
2547: ('Set the approver response attribute to approved');
2548: END IF ;
2549: EXCEPTION
2550: WHEN OTHERS

Line 2553: oe_debug_pub.ADD ( 'Call AME to Update Status-Approved - '

2549: EXCEPTION
2550: WHEN OTHERS
2551: THEN
2552: IF l_debug_level > 0 THEN
2553: oe_debug_pub.ADD ( 'Call AME to Update Status-Approved - '
2554: || itemtype
2555: || '-'
2556: || itemkey,
2557: NULL || '-' || l_application_id

Line 2559: oe_debug_pub.ADD ( 'Call AME to Update Status-Approved - '

2555: || '-'
2556: || itemkey,
2557: NULL || '-' || l_application_id
2558: );
2559: oe_debug_pub.ADD ( 'Call AME to Update Status-Approved - '
2560: || itemtype
2561: || '-'
2562: || itemkey
2563: || '-'

Line 2583: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);

2579: resultout := 'COMPLETE';
2580: WHEN OTHERS
2581: THEN
2582: IF l_debug_level > 0 THEN
2583: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);
2584: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);
2585: END IF ;
2586: wf_core.CONTEXT ('OE_Approvals_WF',
2587: 'process_response_approve',

Line 2584: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);

2580: WHEN OTHERS
2581: THEN
2582: IF l_debug_level > 0 THEN
2583: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);
2584: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);
2585: END IF ;
2586: wf_core.CONTEXT ('OE_Approvals_WF',
2587: 'process_response_approve',
2588: itemtype,

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

2611: l_transaction_id NUMBER;
2612: l_role VARCHAR2 (240);
2613: l_sales_document_type_code VARCHAR2 (30);
2614: l_return_status VARCHAR2 (30);
2615: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2616: l_sold_to_org_id NUMBER;
2617: l_salesrep_id NUMBER;
2618: l_salesrep VARCHAR2 (240);
2619: l_sold_to VARCHAR2 (240);

Line 2679: oe_debug_pub.ADD ('Error in getting parent item key:'

2675: EXCEPTION
2676: WHEN OTHERS
2677: THEN
2678: IF l_debug_level > 0 THEN
2679: oe_debug_pub.ADD ('Error in getting parent item key:'
2680: || SQLERRM
2681: );
2682: END IF ;
2683: END;

Line 2697: oe_debug_pub.ADD ('Entering PROCESS_RESPONSE_REJECT ', 1);

2693: );
2694:
2695: IF l_debug_level > 0
2696: THEN
2697: oe_debug_pub.ADD ('Entering PROCESS_RESPONSE_REJECT ', 1);
2698: END IF;
2699:
2700: -- We need to set the status of the last approver to APPROVED here
2701: -- in the OE_APPROVER_TRANSACTIONS

Line 2720: oe_debug_pub.ADD ('l_sales_document_type_code - Exception');

2716: EXCEPTION
2717: WHEN OTHERS
2718: THEN
2719: IF l_debug_level > 0 THEN
2720: oe_debug_pub.ADD ('l_sales_document_type_code - Exception');
2721: oe_debug_pub.ADD
2722: ( 'l_sales_document_type_code - Exception'
2723: || SQLERRM
2724: );

Line 2721: oe_debug_pub.ADD

2717: WHEN OTHERS
2718: THEN
2719: IF l_debug_level > 0 THEN
2720: oe_debug_pub.ADD ('l_sales_document_type_code - Exception');
2721: oe_debug_pub.ADD
2722: ( 'l_sales_document_type_code - Exception'
2723: || SQLERRM
2724: );
2725: END IF ;

Line 2734: oe_debug_pub.ADD ('l_setp - ' || l_step);

2730: ------------
2731: BEGIN
2732: l_step := 'get Attr for N APP';
2733: IF l_debug_level > 0 THEN
2734: oe_debug_pub.ADD ('l_setp - ' || l_step);
2735: oe_debug_pub.ADD ('l_setp - ' || l_step);
2736: END IF ;
2737: l_name :=
2738: wf_engine.getitemattrtext (itemtype,

Line 2735: oe_debug_pub.ADD ('l_setp - ' || l_step);

2731: BEGIN
2732: l_step := 'get Attr for N APP';
2733: IF l_debug_level > 0 THEN
2734: oe_debug_pub.ADD ('l_setp - ' || l_step);
2735: oe_debug_pub.ADD ('l_setp - ' || l_step);
2736: END IF ;
2737: l_name :=
2738: wf_engine.getitemattrtext (itemtype,
2739: l_transaction_id,

Line 2758: oe_debug_pub.ADD ( 'l_name - '

2754: l_transaction_id,
2755: 'USER_ID'
2756: );
2757: IF l_debug_level > 0 THEN
2758: oe_debug_pub.ADD ( 'l_name - '
2759: || l_name
2760: || ' Orig System - '
2761: || l_orig_system
2762: || 'Orig Sys ID - '

Line 2787: oe_debug_pub.ADD ('l_setp - ' || l_step);

2783: THEN
2784: --L_User_Id := L_Orig_System_Id;
2785: l_step := 'updateApprovalStatus2';
2786: IF l_debug_level > 0 THEN
2787: oe_debug_pub.ADD ('l_setp - ' || l_step);
2788: oe_debug_pub.ADD ('l_setp - ' || l_step);
2789: END IF ;
2790: ame_api2.updateapprovalstatus2
2791: (applicationidin => 660,

Line 2788: oe_debug_pub.ADD ('l_setp - ' || l_step);

2784: --L_User_Id := L_Orig_System_Id;
2785: l_step := 'updateApprovalStatus2';
2786: IF l_debug_level > 0 THEN
2787: oe_debug_pub.ADD ('l_setp - ' || l_step);
2788: oe_debug_pub.ADD ('l_setp - ' || l_step);
2789: END IF ;
2790: ame_api2.updateapprovalstatus2
2791: (applicationidin => 660,
2792: transactiontypein => l_ame_transaction_type,

Line 2807: oe_debug_pub.ADD ('l_setp - ' || l_step);

2803: THEN
2804: l_user_id := l_orig_system_id;
2805: l_step := 'updateApprovalStatus2';
2806: IF l_debug_level > 0 THEN
2807: oe_debug_pub.ADD ('l_setp - ' || l_step);
2808: oe_debug_pub.ADD ('l_setp - ' || l_step);
2809: END IF ;
2810: ame_api2.updateapprovalstatus2
2811: (applicationidin => 660,

Line 2808: oe_debug_pub.ADD ('l_setp - ' || l_step);

2804: l_user_id := l_orig_system_id;
2805: l_step := 'updateApprovalStatus2';
2806: IF l_debug_level > 0 THEN
2807: oe_debug_pub.ADD ('l_setp - ' || l_step);
2808: oe_debug_pub.ADD ('l_setp - ' || l_step);
2809: END IF ;
2810: ame_api2.updateapprovalstatus2
2811: (applicationidin => 660,
2812: transactiontypein => l_ame_transaction_type,

Line 2827: oe_debug_pub.ADD ('l_setp - ' || l_step);

2823: THEN
2824: l_person_id := l_orig_system_id;
2825: l_step := 'updateApprovalStatus2';
2826: IF l_debug_level > 0 THEN
2827: oe_debug_pub.ADD ('l_setp - ' || l_step);
2828: oe_debug_pub.ADD ('l_setp - ' || l_step);
2829: END IF ;
2830: ame_api2.updateapprovalstatus2
2831: (applicationidin => 660,

Line 2828: oe_debug_pub.ADD ('l_setp - ' || l_step);

2824: l_person_id := l_orig_system_id;
2825: l_step := 'updateApprovalStatus2';
2826: IF l_debug_level > 0 THEN
2827: oe_debug_pub.ADD ('l_setp - ' || l_step);
2828: oe_debug_pub.ADD ('l_setp - ' || l_step);
2829: END IF ;
2830: ame_api2.updateapprovalstatus2
2831: (applicationidin => 660,
2832: transactiontypein => l_ame_transaction_type,

Line 2846: oe_debug_pub.ADD ( 'USER ID - '

2842: END IF;
2843:
2844: resultout := 'COMPLETE';
2845: IF l_debug_level > 0 THEN
2846: oe_debug_pub.ADD ( 'USER ID - '
2847: || l_user_id
2848: || ' Person ID - '
2849: || l_person_id
2850: );

Line 2851: oe_debug_pub.ADD ( 'USER ID - '

2847: || l_user_id
2848: || ' Person ID - '
2849: || l_person_id
2850: );
2851: oe_debug_pub.ADD ( 'USER ID - '
2852: || l_user_id
2853: || ' Person ID - '
2854: || l_person_id
2855: );

Line 2872: oe_debug_pub.ADD

2868: l_aname,
2869: l_avaluetext
2870: );
2871: IF l_debug_level > 0 THEN
2872: oe_debug_pub.ADD
2873: ('Set the approver response attribute to rejected');
2874: END IF ;
2875: EXCEPTION
2876: WHEN OTHERS

Line 2879: oe_debug_pub.ADD ( 'Call AME to Update Status-Approved - '

2875: EXCEPTION
2876: WHEN OTHERS
2877: THEN
2878: IF l_debug_level > 0 THEN
2879: oe_debug_pub.ADD ( 'Call AME to Update Status-Approved - '
2880: || itemtype
2881: || '-'
2882: || itemkey,
2883: NULL || '-' || l_application_id

Line 2885: oe_debug_pub.ADD ( 'Call AME to Update Status-Approved - '

2881: || '-'
2882: || itemkey,
2883: NULL || '-' || l_application_id
2884: );
2885: oe_debug_pub.ADD ( 'Call AME to Update Status-Approved - '
2886: || itemtype
2887: || '-'
2888: || itemkey
2889: || '-'

Line 2909: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);

2905: resultout := 'COMPLETE';
2906: WHEN OTHERS
2907: THEN
2908: IF l_debug_level > 0 THEN
2909: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);
2910: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);
2911: END IF ;
2912: wf_core.CONTEXT ('OE_Approvals_WF',
2913: 'process_response_reject',

Line 2910: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);

2906: WHEN OTHERS
2907: THEN
2908: IF l_debug_level > 0 THEN
2909: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);
2910: oe_debug_pub.ADD ('error in PROCESS_RESPONSE_APPROVE:' || SQLERRM);
2911: END IF ;
2912: wf_core.CONTEXT ('OE_Approvals_WF',
2913: 'process_response_reject',
2914: itemtype,

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

2954: l_preparer_user_name fnd_user.user_name%TYPE;
2955: l_doc_string VARCHAR2 (200);
2956: l_ame_exception ame_util.longeststringtype;
2957: l_approver_response VARCHAR2 (20);
2958: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2959: xx_ame EXCEPTION;
2960:
2961: CURSOR l_child_wf (
2962: p_itemtype IN wf_items.parent_item_type%TYPE,

Line 2985: oe_debug_pub.ADD ('Entering Process beat by first');

2981: l_sales_document_type_code VARCHAR2(240); -- 16084377 ame bsa
2982: BEGIN
2983: IF l_debug_level > 0
2984: THEN
2985: oe_debug_pub.ADD ('Entering Process beat by first');
2986: END IF;
2987:
2988: SELECT parent_item_type, parent_item_key
2989: INTO l_parent_item_type, l_parent_item_key

Line 2993: oe_debug_pub.ADD ('After getting parent details');

2989: INTO l_parent_item_type, l_parent_item_key
2990: FROM wf_items
2991: WHERE item_type = itemtype AND item_key = itemkey;
2992: IF l_debug_level > 0 THEN
2993: oe_debug_pub.ADD ('After getting parent details');
2994: END IF ;
2995: /* Check if there we have encountered any ame exception.
2996: If the value of ame_exception is not null, then we have faced some exception.
2997: So just comlete the block activity and return */

Line 3004: oe_debug_pub.ADD ( 'After gettingAME exception details:'

3000: itemkey => l_parent_item_key,
3001: aname => 'AME_EXCEPTION'
3002: );
3003: IF l_debug_level > 0 THEN
3004: oe_debug_pub.ADD ( 'After gettingAME exception details:'
3005: || l_ame_exception
3006: );
3007: END IF ;
3008: l_current_person_id :=

Line 3034: oe_debug_pub.ADD ('Header id derived is:' || l_header_id);

3030:
3031: l_header_id := TO_NUMBER (l_parent_item_key);
3032:
3033: IF l_debug_level > 0 THEN
3034: oe_debug_pub.ADD ('Header id derived is:' || l_header_id);
3035: END IF ;
3036: l_approver_response :=
3037: wf_engine.getitemattrtext (itemtype => itemtype,
3038: itemkey => itemkey,

Line 3042: oe_debug_pub.ADD ('Approver response is:' || l_approver_response);

3038: itemkey => itemkey,
3039: aname => 'APPROVER_RESPONSE'
3040: );
3041: IF l_debug_level > 0 THEN
3042: oe_debug_pub.ADD ('Approver response is:' || l_approver_response);
3043: END IF ;
3044: IF l_approver_response = 'APPROVED'
3045: THEN
3046: IF l_parent_item_type = 'OENH'

Line 3067: oe_debug_pub.ADD ( 'After getting AME transaction type:'

3063: THEN
3064: ametransactiontype := 'OERMA';
3065: END IF;
3066: IF l_debug_level > 0 THEN
3067: oe_debug_pub.ADD ( 'After getting AME transaction type:'
3068: || ametransactiontype
3069: );
3070: END IF ;
3071: BEGIN

Line 3099: oe_debug_pub.ADD ( 'authority'

3095: FOR i IN 1 .. approverlist.COUNT
3096: LOOP
3097: IF l_debug_level > 0
3098: THEN
3099: oe_debug_pub.ADD ( 'authority'
3100: || ' '
3101: || approverlist (i).authority
3102: );
3103: oe_debug_pub.ADD ( 'approval_status'

Line 3103: oe_debug_pub.ADD ( 'approval_status'

3099: oe_debug_pub.ADD ( 'authority'
3100: || ' '
3101: || approverlist (i).authority
3102: );
3103: oe_debug_pub.ADD ( 'approval_status'
3104: || ' '
3105: || approverlist (i).approval_status
3106: );
3107: oe_debug_pub.ADD ( 'api_insertion'

Line 3107: oe_debug_pub.ADD ( 'api_insertion'

3103: oe_debug_pub.ADD ( 'approval_status'
3104: || ' '
3105: || approverlist (i).approval_status
3106: );
3107: oe_debug_pub.ADD ( 'api_insertion'
3108: || ' '
3109: || approverlist (i).api_insertion
3110: );
3111: oe_debug_pub.ADD ( 'group_or_chain_id'

Line 3111: oe_debug_pub.ADD ( 'group_or_chain_id'

3107: oe_debug_pub.ADD ( 'api_insertion'
3108: || ' '
3109: || approverlist (i).api_insertion
3110: );
3111: oe_debug_pub.ADD ( 'group_or_chain_id'
3112: || ' '
3113: || approverlist (i).group_or_chain_id
3114: );
3115: END IF;

Line 3181: oe_debug_pub.ADD ('before getting child workflows');

3177: END IF;
3178:
3179: -- stop the workflow
3180: IF l_debug_level > 0 THEN
3181: oe_debug_pub.ADD ('before getting child workflows');
3182: END IF ;
3183:
3184: OPEN l_child_wf (l_parent_item_type, l_parent_item_key);
3185:

Line 3192: oe_debug_pub.ADD ('Inside getting child workflows');

3188: INTO l_child_wf_cur;
3189:
3190: EXIT WHEN l_child_wf%NOTFOUND;
3191: IF l_debug_level > 0 THEN
3192: oe_debug_pub.ADD ('Inside getting child workflows');
3193: END IF ;
3194:
3195: /* l_child_approver_empid := wf_engine.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
3196: itemkey => l_child_wf_cur.item_key,

Line 3221: oe_debug_pub.ADD ( 'before aborting the flow for:'

3217: AND NAME = 'ORIG_SYSTEM_ID'
3218: AND number_value = l_orig_system_id
3219: AND item_key = l_child_wf_cur.item_key;
3220: IF l_debug_level > 0 THEN
3221: oe_debug_pub.ADD ( 'before aborting the flow for:'
3222: || l_child_wf_cur.item_key
3223: );
3224: END IF ;
3225: wf_engine.abortprocess (l_child_wf_cur.item_type,

Line 3232: oe_debug_pub.ADD

3228: EXCEPTION
3229: WHEN NO_DATA_FOUND
3230: THEN
3231: IF l_debug_level > 0 THEN
3232: oe_debug_pub.ADD
3233: ('this might be a parallel flow from dual chain of authority.do no abort'
3234: );
3235: END IF ;
3236: END;

Line 3273: oe_debug_pub.ADD ('error in Process_Beat_By_First:' || SQLERRM);

3269: resultout := 'COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
3270: WHEN OTHERS
3271: THEN
3272: IF l_debug_level > 0 THEN
3273: oe_debug_pub.ADD ('error in Process_Beat_By_First:' || SQLERRM);
3274: END IF ;
3275: wf_core.CONTEXT ('OE_Approvals_WF',
3276: 'process_beat_by_first',
3277: itemtype,

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

3299: IS
3300: l_ame_used VARCHAR2 (10);
3301: l_rejected_once VARCHAR2 (1);
3302: l_ame_transaction VARCHAR2 (250);
3303: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3304: l_sales_document_type_code varchar2(10);
3305: BEGIN
3306: IF l_debug_level > 0 THEN
3307: oe_debug_pub.ADD ('Entering IS_AME_APPROVAL');

Line 3307: oe_debug_pub.ADD ('Entering IS_AME_APPROVAL');

3303: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3304: l_sales_document_type_code varchar2(10);
3305: BEGIN
3306: IF l_debug_level > 0 THEN
3307: oe_debug_pub.ADD ('Entering IS_AME_APPROVAL');
3308: END IF ;
3309: g_ame_used := 'N';
3310:
3311: IF itemtype = oe_globals.g_wfi_ngo

Line 3318: oe_debug_pub.ADD ('item type is negotiation so AME TTY is OENEG');

3314: itemtype,
3315: itemkey,
3316: 'SALES_DOCUMENT_TYPE_CODE');
3317: IF l_debug_level > 0 THEN
3318: oe_debug_pub.ADD ('item type is negotiation so AME TTY is OENEG');
3319: END IF ;
3320: IF l_sales_document_type_code = 'O' THEN
3321: l_ame_transaction := 'OENEG'; -- 16084377 AME BSA
3322: ELSE

Line 3328: oe_debug_pub.ADD ('item type is header so AME TTY is OERMA');

3324: END IF ;
3325: ELSIF itemtype = oe_globals.g_wfi_hdr
3326: THEN
3327: IF l_debug_level > 0 THEN
3328: oe_debug_pub.ADD ('item type is header so AME TTY is OERMA');
3329: END IF ;
3330: l_ame_transaction := 'OERMA';
3331: END IF;
3332:

Line 3368: oe_debug_pub.ADD

3364: ELSE
3365: resultout := 'COMPLETE:Y';
3366: oe_approvals_wf.g_ame_used := 'Y';
3367: IF l_debug_level > 0 THEN
3368: oe_debug_pub.ADD
3369: ('AME approval is used.check if the transaction is rejected in the past'
3370: );
3371: END IF ;
3372: BEGIN

Line 3385: oe_debug_pub.ADD

3381: AND wiash.activity_status = 'COMPLETE'
3382: AND wiash.activity_result_code = 'REJECTED'
3383: AND ROWNUM = 1;
3384: IF l_debug_level > 0 THEN
3385: oe_debug_pub.ADD
3386: ('Yes it was rejected in the past. So reset the approvals');
3387: END IF ;
3388: EXCEPTION
3389: WHEN NO_DATA_FOUND

Line 3392: oe_debug_pub.ADD ('No. This is the first time');

3388: EXCEPTION
3389: WHEN NO_DATA_FOUND
3390: THEN
3391: IF l_debug_level > 0 THEN
3392: oe_debug_pub.ADD ('No. This is the first time');
3393: END IF ;
3394: l_rejected_once := 'N';
3395: END;
3396:

Line 3400: oe_debug_pub.ADD ('Calling AME API to reset the approvals');

3396:
3397: IF l_rejected_once = 'Y'
3398: THEN
3399: IF l_debug_level > 0 THEN
3400: oe_debug_pub.ADD ('Calling AME API to reset the approvals');
3401: END IF ;
3402: BEGIN
3403: ame_api2.clearallapprovals
3404: (applicationidin => '660',

Line 3413: oe_debug_pub.ADD

3409: EXCEPTION
3410: WHEN OTHERS
3411: THEN
3412: IF l_debug_level > 0 THEN
3413: oe_debug_pub.ADD
3414: ('error is clearing approvals.correct the error and retry'
3415: );
3416: END IF ;
3417: END;

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

3447: )
3448: IS
3449: l_parent_item_key VARCHAR2 (100);
3450: l_parent_item_type VARCHAR2 (20);
3451: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3452: BEGIN
3453: IF l_debug_level > 0 THEN
3454: oe_debug_pub.ADD ('Entering Push_block_activity');
3455: END IF ;

Line 3454: oe_debug_pub.ADD ('Entering Push_block_activity');

3450: l_parent_item_type VARCHAR2 (20);
3451: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3452: BEGIN
3453: IF l_debug_level > 0 THEN
3454: oe_debug_pub.ADD ('Entering Push_block_activity');
3455: END IF ;
3456: g_current_item_key := NULL;
3457:
3458: SELECT parent_item_key, parent_item_type

Line 3480: oe_debug_pub.ADD ('Exiting Push_block_activity');

3476:
3477: resultout := 'COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
3478: RETURN;
3479: IF l_debug_level > 0 THEN
3480: oe_debug_pub.ADD ('Exiting Push_block_activity');
3481: END IF ;
3482: EXCEPTION
3483: WHEN OTHERS
3484: THEN

Line 3486: oe_debug_pub.ADD (SQLERRM);

3482: EXCEPTION
3483: WHEN OTHERS
3484: THEN
3485: IF l_debug_level > 0 THEN
3486: oe_debug_pub.ADD (SQLERRM);
3487: END IF ;
3488: wf_core.CONTEXT ('OE_Approvals_WF',
3489: 'push_block_activity',
3490: itemtype,

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

3513: l_current_approver VARCHAR2 (320);
3514: l_sales_document_type_code VARCHAR2 (30);
3515: l_transaction_id NUMBER;
3516: l_return_status VARCHAR2 (30);
3517: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3518: BEGIN
3519: --
3520: -- RUN mode - normal process execution
3521: --

Line 3533: oe_debug_pub.ADD ('Approval_Timeout ame.. ', 1);

3529: );
3530:
3531: IF l_debug_level > 0
3532: THEN
3533: oe_debug_pub.ADD ('Approval_Timeout ame.. ', 1);
3534: END IF;
3535:
3536: IF NVL (oe_sys_parameters.VALUE ('NO_RESPONSE_FROM_APPROVER'),
3537: 'CONTINUE'

Line 3568: oe_debug_pub.ADD ('Exception in Approval_Timeout.. ', 1);

3564: WHEN OTHERS
3565: THEN
3566: IF l_debug_level > 0
3567: THEN
3568: oe_debug_pub.ADD ('Exception in Approval_Timeout.. ', 1);
3569: END IF;
3570:
3571: wf_core.CONTEXT ('OE_APPROVALS_WF',
3572: 'Approval_Timeout_AME',

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

3593: l_discount NUMBER;
3594: l_tax NUMBER;
3595: l_charges NUMBER;
3596: l_order_total NUMBER;
3597: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3598: BEGIN
3599: IF l_debug_level > 0 THEN
3600: oe_debug_pub.ADD ('Entering oe_approvals_Wf.get_order_total');
3601: END IF ;

Line 3600: oe_debug_pub.ADD ('Entering oe_approvals_Wf.get_order_total');

3596: l_order_total NUMBER;
3597: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3598: BEGIN
3599: IF l_debug_level > 0 THEN
3600: oe_debug_pub.ADD ('Entering oe_approvals_Wf.get_order_total');
3601: END IF ;
3602: oe_oe_totals_summary.order_totals (p_header_id => p_header_id,
3603: p_subtotal => l_subtotal,
3604: p_discount => l_discount,

Line 3609: oe_debug_pub.ADD ('After getting all the totals');

3605: p_charges => l_charges,
3606: p_tax => l_tax
3607: );
3608: IF l_debug_level > 0 THEN
3609: oe_debug_pub.ADD ('After getting all the totals');
3610: END IF ;
3611: l_order_total := l_subtotal + l_charges + l_tax;
3612: IF l_debug_level > 0 THEN
3613: oe_debug_pub.ADD ('returning:' || l_order_total);

Line 3613: oe_debug_pub.ADD ('returning:' || l_order_total);

3609: oe_debug_pub.ADD ('After getting all the totals');
3610: END IF ;
3611: l_order_total := l_subtotal + l_charges + l_tax;
3612: IF l_debug_level > 0 THEN
3613: oe_debug_pub.ADD ('returning:' || l_order_total);
3614: END IF ;
3615: RETURN l_order_total;
3616: EXCEPTION
3617: WHEN OTHERS

Line 3620: oe_debug_pub.ADD ('Error in getting order total:' || SQLERRM);

3616: EXCEPTION
3617: WHEN OTHERS
3618: THEN
3619: IF l_debug_level > 0 THEN
3620: oe_debug_pub.ADD ('Error in getting order total:' || SQLERRM);
3621: END IF ;
3622: RETURN 0;
3623: END get_order_total;
3624:

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

3625: FUNCTION get_customer_category (p_header_id IN NUMBER, p_ame_type IN VARCHAR2)
3626: RETURN VARCHAR2
3627: IS
3628: l_cust_category VARCHAR2 (240);
3629: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3630: BEGIN
3631: IF l_debug_level > 0
3632: THEN
3633: oe_debug_pub.ADD ('Entering oe_approvals_Wf.get_customer_category');

Line 3633: oe_debug_pub.ADD ('Entering oe_approvals_Wf.get_customer_category');

3629: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3630: BEGIN
3631: IF l_debug_level > 0
3632: THEN
3633: oe_debug_pub.ADD ('Entering oe_approvals_Wf.get_customer_category');
3634: END IF;
3635:
3636: if p_ame_type='OEBSA' THEN
3637: BEGIN

Line 3689: oe_debug_pub.ADD ('Error in getting order total:' || SQLERRM);

3685: WHEN OTHERS
3686: THEN
3687: IF l_debug_level > 0
3688: THEN
3689: oe_debug_pub.ADD ('Error in getting order total:' || SQLERRM);
3690: END IF;
3691:
3692: l_cust_category := NULL;
3693: RETURN l_cust_category;