APPS.AP_IAW_PKG dependencies on FND_LOG

Line 27: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

23: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
24: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
25: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
26:
27: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
28: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
29: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
30: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
31: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 28: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

24: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
25: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
26:
27: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
28: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
29: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
30: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
31: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: -- TODO

Line 29: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

25: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
26:
27: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
28: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
29: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
30: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
31: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: -- TODO
33: -- G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 30: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

26:
27: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
28: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
29: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
30: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
31: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: -- TODO
33: -- G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 31: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

27: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
28: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
29: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
30: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
31: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: -- TODO
33: -- G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: -- G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 33: -- G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

29: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
30: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
31: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: -- TODO
33: -- G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: -- G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
36: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
37: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_IAW_PKG';

Line 34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

30: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
31: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: -- TODO
33: -- G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: -- G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
36: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
37: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_IAW_PKG';
38:

Line 35: -- G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

31: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: -- TODO
33: -- G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: -- G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
36: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
37: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_IAW_PKG';
38:
39: -- get max notification iteration

Line 36: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

32: -- TODO
33: -- G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: -- G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
36: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
37: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_IAW_PKG';
38:
39: -- get max notification iteration
40: -- invoice_key is invoice_id + invoice_iteration from ap_apinv_approvers

Line 51: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

47:
48: BEGIN
49:
50: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
51: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
52: END IF;
53:
54: -- get max notification iteration
55: SELECT nvl(max(notification_iteration),0) + 1

Line 63: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

59:
60: l_debug_info := 'invoice_key = ' || p_invoice_key ||
61: ', and current max notification iteration = ' || l_notif_iter;
62: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
63: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
64: l_api_name,l_debug_info);
65: END IF;
66:
67: RETURN l_notif_iter;

Line 113: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

109:
110: BEGIN
111:
112: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
113: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
114: END IF;
115:
116: l_debug_info := 'set variables from workflow';
117: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 118: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

114: END IF;
115:
116: l_debug_info := 'set variables from workflow';
117: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
118: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
119: l_api_name,l_debug_info);
120: END IF;
121:
122: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 136: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

132: 'ITERATION');
133:
134: l_debug_info := 'get invoice amount';
135: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
137: l_api_name,l_debug_info);
138: END IF;
139:
140: SELECT invoice_amount

Line 147: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

143: WHERE invoice_id = l_invoice_id;
144:
145: l_debug_info := 'check AME if production rules should prevent approval';
146: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
147: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
148: l_api_name,l_debug_info);
149: END IF;
150:
151: ame_api2.getTransactionProductions(applicationIdIn => 200,

Line 160: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

156:
157: IF l_result IS NOT NULL THEN
158: l_debug_info := 'loop through production results';
159: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
160: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
161: l_api_name,l_debug_info);
162: END IF;
163: FOR i IN 1..l_result.count LOOP
164:

Line 175: FND_LOG.STRING(G_LEVEL_STATEMENT,

171:
172: l_debug_info := 'get translation of reason';
173: IF (G_LEVEL_STATEMENT >=
174: G_CURRENT_RUNTIME_LEVEL) THEN
175: FND_LOG.STRING(G_LEVEL_STATEMENT,
176: G_MODULE_NAME||
177: l_api_name,l_debug_info);
178: END IF;
179:

Line 190: FND_LOG.STRING(G_LEVEL_STATEMENT,

186:
187: l_debug_info := 'populate history record';
188: IF (G_LEVEL_STATEMENT >=
189: G_CURRENT_RUNTIME_LEVEL) THEN
190: FND_LOG.STRING(G_LEVEL_STATEMENT,
191: G_MODULE_NAME||
192: l_api_name,l_debug_info);
193: END IF;
194:

Line 218: FND_LOG.STRING(G_LEVEL_STATEMENT,

214:
215: l_debug_info := 'Set transaction statuses';
216: IF (G_LEVEL_STATEMENT >=
217: G_CURRENT_RUNTIME_LEVEL) THEN
218: FND_LOG.STRING(G_LEVEL_STATEMENT,
219: G_MODULE_NAME||
220: l_api_name,l_debug_info);
221: END IF;
222:

Line 248: FND_LOG.STRING(G_LEVEL_STATEMENT,

244:
245: l_debug_info := 'get translated reason value';
246: IF (G_LEVEL_STATEMENT >=
247: G_CURRENT_RUNTIME_LEVEL) THEN
248: FND_LOG.STRING(G_LEVEL_STATEMENT,
249: G_MODULE_NAME||
250: l_api_name,l_debug_info);
251: END IF;
252:

Line 267: FND_LOG.STRING(G_LEVEL_STATEMENT,

263:
264: l_debug_info := 'populate history record';
265: IF (G_LEVEL_STATEMENT >=
266: G_CURRENT_RUNTIME_LEVEL) THEN
267: FND_LOG.STRING(G_LEVEL_STATEMENT,
268: G_MODULE_NAME||
269: l_api_name,l_debug_info);
270: END IF;
271: l_h_hist.invoice_id := l_invoice_id;

Line 307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

303: ELSE --there were no production results
304:
305: l_debug_info := 'continue with workflow';
306: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
308: l_api_name,l_debug_info);
309: END IF;
310: resultout := wf_engine.eng_completed||':'||'Y';
311:

Line 359: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

355:
356: BEGIN
357:
358: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
359: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
360: END IF;
361:
362: l_debug_info := 'set variables from workflow';
363: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 364: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

360: END IF;
361:
362: l_debug_info := 'set variables from workflow';
363: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
364: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
365: l_api_name,l_debug_info);
366: END IF;
367:
368: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 404: FND_LOG.STRING(G_LEVEL_STATEMENT,

400:
401: l_debug_info := 'get translation';
402: IF (G_LEVEL_STATEMENT >=
403: G_CURRENT_RUNTIME_LEVEL) THEN
404: FND_LOG.STRING(G_LEVEL_STATEMENT,
405: G_MODULE_NAME||
406: l_api_name,l_debug_info);
407: END IF;
408:

Line 500: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.identify_approver (+)');

496:
497: BEGIN
498:
499: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.identify_approver (+)');
501: END IF;
502:
503: l_debug_info := 'get variables from workflow: itemtype = ' || itemtype ||
504: ', itemkey = ' || itemkey;

Line 506: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

502:
503: l_debug_info := 'get variables from workflow: itemtype = ' || itemtype ||
504: ', itemkey = ' || itemkey;
505: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
506: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
507: l_api_name,l_debug_info);
508: END IF;
509:
510: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 521: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

517:
518: l_debug_info := l_api_name ||': invoice_id = ' || l_invoice_id ||
519: ', iteration = ' || l_iteration;
520: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
521: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
522: l_api_name,l_debug_info);
523: END IF;
524:
525: --check for pending approvers

Line 542: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

538: END;
539: l_debug_info := l_api_name ||': pend = ' || l_pend ||
540: ', role_name = ' || l_name;
541: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
543: l_api_name,l_debug_info);
544: END IF;
545:
546: IF l_pend > 0 THEN

Line 556: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

552: WHERE Invoice_Key = itemkey;
553:
554: l_debug_info := l_api_name ||': get max notification iteration';
555: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
556: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
557: l_api_name,l_debug_info);
558: END IF;
559:
560: --set values for grouping

Line 590: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

586: END;
587: l_debug_info := l_api_name ||': sent = ' || l_sent ||
588: ', complete = ' || l_comp;
589: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
590: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
591: l_api_name,l_debug_info);
592: END IF;
593:
594: --None sent at all

Line 625: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

621: ELSIF l_sent = 0 AND l_comp >0 THEN
622:
623: l_debug_info := l_api_name ||': all complete but none sent';
624: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
625: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
626: l_api_name,l_debug_info);
627: END IF;
628:
629: --First set transaction statuses

Line 719: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

715:
716: BEGIN
717:
718: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
719: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
720: END IF;
721:
722: l_debug_info := l_api_name || ': get variables from workflow: itemtype = ' || itemtype ||
723: ', itemkey = ' || itemkey;

Line 725: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

721:
722: l_debug_info := l_api_name || ': get variables from workflow: itemtype = ' || itemtype ||
723: ', itemkey = ' || itemkey;
724: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
725: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
726: l_api_name,l_debug_info);
727: END IF;
728:
729: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 746: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

742: ', l_invoice_id = ' || l_invoice_id ||
743: ', l_iteration = ' || l_iteration ||
744: ', l_org_id = ' || l_org_id;
745: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
746: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
747: l_debug_info);
748: END IF;
749:
750:

Line 767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

763:
764: -- More values in the approver list
765: l_debug_info := l_api_name || ': after call to ame';
766: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
768: l_api_name,l_debug_info);
769: END IF;
770: IF l_complete = ame_util.booleanFalse THEN
771: -- Loop through approvers' table returned by AME

Line 774: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

770: IF l_complete = ame_util.booleanFalse THEN
771: -- Loop through approvers' table returned by AME
772: l_debug_info := l_api_name || ': more approvers';
773: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
774: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
775: l_api_name,l_debug_info);
776: END IF;
777:
778: l_debug_info := l_api_name || ': looping through approvers'||

Line 781: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);

777:
778: l_debug_info := l_api_name || ': looping through approvers'||
779: ', next_approvers.count = ' || l_next_approvers.count;
780: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
781: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);
782: END IF;
783:
784: FOR l_table IN 1..l_next_approvers.count LOOP
785: -- nvl(l_next_approvers.First,0)..nvl(l_next_Approvers.Last,-1) LOOP

Line 790: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);

786: --set the record variable
787: l_next_approver := l_next_approvers(l_table);
788: l_debug_info := l_api_name || ': item_id = '|| l_next_approver.item_id;
789: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
790: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);
791: END IF;
792:
793: --if the approver record does not have a value for item_id,
794: --we need to

Line 801: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

797: --with this approver.
798: IF l_next_approver.item_id IS NULL THEN
799: l_debug_info := 'item_id is null';
800: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
801: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
802: l_api_name,l_debug_info);
803: END IF;
804:
805: FOR l_rec IN 1..l_index.count LOOP

Line 810: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

806: --l_index contains the mapping between
807: --approvers and items
808: l_debug_info := 'looping through l_rec';
809: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
810: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
811: l_api_name,l_debug_info);
812: END IF;
813: IF l_index(l_rec) = l_table THEN
814: l_debug_info := 'check type of item class';

Line 816: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

812: END IF;
813: IF l_index(l_rec) = l_table THEN
814: l_debug_info := 'check type of item class';
815: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
816: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
817: l_api_name,l_debug_info);
818: END IF;
819: --Depending on the type of item class, we need to set
820: --some variables

Line 928: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

924: 0);
925:
926: l_debug_info := 'after insert';
927: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
928: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
929: l_api_name,l_debug_info);
930: END IF;
931: END IF; --l_index mapping
932: END LOOP; -- l_index mapping

Line 938: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

934: ELSE --only one item_id per approver
935:
936: l_debug_info := 'only one item_id per approver';
937: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
938: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
939: l_api_name,l_debug_info);
940: END IF;
941: --Depending on the type of item class, we need to set
942: --some variables:

Line 1086: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1082:
1083: BEGIN
1084:
1085: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1087: END IF;
1088:
1089: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
1090:

Line 1093: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1089: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
1090:
1091: l_debug_info := 'set variables from workflow';
1092: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1093: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1094: l_debug_info);
1095: END IF;
1096:
1097: l_invoice_id := p_invoice_id;

Line 1114: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

1110:
1111: --More values in the approver list
1112: l_debug_info := 'after call to ame';
1113: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1114: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1115: l_api_name,l_debug_info);
1116: END IF;
1117: IF l_complete = ame_util.booleanFalse THEN
1118: --Loop through approvers' table returned by AME

Line 1121: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

1117: IF l_complete = ame_util.booleanFalse THEN
1118: --Loop through approvers' table returned by AME
1119: l_debug_info := 'more approvers';
1120: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1121: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1122: l_api_name,l_debug_info);
1123: END IF;
1124:
1125: FOR l_table IN

Line 1130: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

1126: nvl(l_next_approvers.First,0)..nvl(l_next_Approvers.Last,-1)
1127: LOOP
1128: l_debug_info := 'looping through approvers';
1129: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1130: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1131: l_api_name,l_debug_info);
1132: END IF;
1133: --set the record variable
1134: l_next_approver := l_next_approvers(l_table);

Line 1144: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

1140: --with this approver.
1141: IF l_next_approver.item_id IS NULL THEN
1142: l_debug_info := 'item_id is null';
1143: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1144: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1145: l_api_name,l_debug_info);
1146: END IF;
1147:
1148: FOR l_rec IN 1..l_index.count LOOP

Line 1153: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

1149: --l_index contains the mapping between
1150: --approvers and items
1151: l_debug_info := 'looping through l_rec';
1152: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1153: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1154: l_api_name,l_debug_info);
1155: END IF;
1156: IF l_index(l_rec) = l_table THEN
1157: l_debug_info := 'check type of item class';

Line 1159: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

1155: END IF;
1156: IF l_index(l_rec) = l_table THEN
1157: l_debug_info := 'check type of item class';
1158: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1159: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1160: l_api_name,l_debug_info);
1161: END IF;
1162: --Depending on the type of item class, we need to set
1163: --some variables

Line 1225: FND_LOG.STRING(G_LEVEL_STATEMENT,

1221:
1222: l_debug_info := 'after insert';
1223: IF (G_LEVEL_STATEMENT >=
1224: G_CURRENT_RUNTIME_LEVEL) THEN
1225: FND_LOG.STRING(G_LEVEL_STATEMENT,
1226: G_MODULE_NAME||
1227: l_api_name,l_debug_info);
1228: END IF;
1229: END IF; --l_index mapping

Line 1236: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

1232: ELSE --only one item_id per approver
1233:
1234: l_debug_info := 'only one item_id per approver';
1235: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1236: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1237: l_api_name,l_debug_info);
1238: END IF;
1239: --Depending on the type of item class, we need to set
1240: --some variables:

Line 1335: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1331:
1332: BEGIN
1333:
1334: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1335: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1336: END IF;
1337:
1338: --Determine if line or header level approver
1339: SELECT DECODE(nvl(Line_Number,''),'','HEADER','LINE'), invoice_key

Line 1405: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1401:
1402: BEGIN
1403:
1404: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1405: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1406: END IF;
1407:
1408: --Get the current approver info
1409: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 1537: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1533:
1534: BEGIN
1535:
1536: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1537: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1538: END IF;
1539:
1540: --Get the current approver info
1541: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 1655: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1651: 'Notification_Handler';
1652: BEGIN
1653:
1654: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1655: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1656: END IF;
1657:
1658: --users may not transfer, or reassign them
1659: IF ( funcmode = 'TRANSFER' ) THEN

Line 1705: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1701:
1702: BEGIN
1703:
1704: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1705: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1706: END IF;
1707:
1708: --Get wf attribute values
1709: l_result := WF_ENGINE.GetActivityAttrText(itemtype => itemtype,

Line 1723: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

1719: || ', itemkey = ' || itemkey
1720: || ', invoice_id = ' || l_invoice_id
1721: || ', result = ' || l_result;
1722: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1723: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1724: l_api_name,l_debug_info);
1725: END IF;
1726:
1727:

Line 1831: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1827:
1828: BEGIN
1829:
1830: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1831: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1832: END IF;
1833:
1834: --Update Approvers table
1835: UPDATE AP_APINV_APPROVERS

Line 1921: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1917:
1918: BEGIN
1919:
1920: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1922: END IF;
1923:
1924: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
1925:

Line 1928: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1924: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
1925:
1926: l_debug_info := 'set variables';
1927: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1928: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1929: l_debug_info);
1930: END IF;
1931:
1932: if instr(p_invoice_id, '_') > 0 then

Line 1999: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1995: p_parameterlist => l_parameter_list);
1996:
1997: l_debug_info := 'raise event';
1998: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1999: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2000: l_debug_info);
2001: END IF;
2002:
2003:

Line 2013: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2009:
2010: commit;
2011: l_debug_info := 'after commit';
2012: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2013: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2014: l_debug_info);
2015: END IF;
2016:
2017: EXCEPTION

Line 2056: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.set_attribute_values (+)');

2052: l_debug_info VARCHAR2(2000);
2053:
2054: BEGIN
2055: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2056: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.set_attribute_values (+)');
2057: END IF;
2058:
2059: l_debug_info := l_api_name || ': itemtype = ' || itemtype ||
2060: ', itemkey = ' || itemkey;

Line 2062: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

2058:
2059: l_debug_info := l_api_name || ': itemtype = ' || itemtype ||
2060: ', itemkey = ' || itemkey;
2061: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2062: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2063: l_api_name,l_debug_info);
2064: END IF;
2065:
2066: IF itemtype = 'APINVLDP' THEN

Line 2080: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

2076:
2077: l_debug_info := l_api_name ||': notification_key = ' || l_not_key ||
2078: ', notification_iteration = '|| l_not_it;
2079: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2080: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2081: l_api_name,l_debug_info);
2082: END IF;
2083:
2084: WF_ENGINE.SetItemAttrText(itemtype,

Line 2109: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

2105: ', notification_iteration = '|| l_not_it ||
2106: ', orig_approver_id = ' || l_orig_id ||
2107: ', role = '|| l_role || ', invoice_id = '|| l_invoice_id;
2108: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2109: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2110: l_api_name,l_debug_info);
2111: END IF;
2112:
2113: WF_ENGINE.SetItemAttrNumber(itemtype,

Line 2177: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

2173: l_debug_info := l_api_name ||': supplier_name ' || l_invoice_supplier_name ||
2174: ', invoice_num = '|| l_invoice_number ||
2175: ', invoice_total = '|| l_invoice_total;
2176: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2177: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2178: l_api_name,l_debug_info);
2179: END IF;
2180:
2181: --set wf attributes

Line 2279: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2275:
2276: BEGIN
2277:
2278: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2279: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2280: END IF;
2281:
2282: --set the environment
2283: fnd_client_info.set_org_context(p_inv_aprvl_hist.org_id);

Line 2353: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2349:
2350: BEGIN
2351:
2352: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2353: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2354: END IF;
2355:
2356: --Get attribute values to create record in the history table
2357: IF p_type = 'ESC' THEN

Line 2450: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2446: l_not_cnt NUMBER;
2447: BEGIN
2448:
2449: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2450: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2451: END IF;
2452:
2453: --Now set the environment
2454: fnd_client_info.set_org_context(p_line_aprvl_hist.org_id);

Line 2544: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2540: GROUP BY Line_Number, item_class, item_id;
2541:
2542: BEGIN
2543: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2544: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2545: END IF;
2546:
2547: --Get attribute values to create record in the history table
2548: IF p_type = 'ESC' THEN

Line 2666: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2662:
2663: BEGIN
2664:
2665: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2666: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2667: END IF;
2668:
2669: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2670: itemkey,

Line 2751: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2747:
2748: BEGIN
2749:
2750: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2751: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2752: END IF;
2753:
2754: IF p_response = 'APPROVED' THEN
2755: l_response := 'WFAPPROVED';

Line 2813: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2809:
2810: BEGIN
2811:
2812: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2813: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2814: END IF;
2815:
2816: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2817: itemkey,

Line 2893: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2889:
2890: BEGIN
2891:
2892: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2893: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2894: END IF;
2895:
2896: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
2897:

Line 2900: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

2896: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
2897:
2898: l_debug_info := 'opening item cursor';
2899: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2900: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2901: l_api_name,l_debug_info);
2902: END IF;
2903:
2904: --amy call ame api clearAllApprovers by item id

Line 2944: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2940:
2941: BEGIN
2942:
2943: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2944: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2945: END IF;
2946:
2947: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
2948:

Line 2951: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

2947: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
2948:
2949: l_debug_info := 'opening item cursor';
2950: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2951: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2952: l_debug_info);
2953: END IF;
2954:
2955: OPEN Item_Cur;

Line 3027: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

3023:
3024: BEGIN
3025:
3026: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3027: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
3028: END IF;
3029:
3030: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
3031:

Line 3067: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3063: process => 'APPROVAL_STAGING');
3064:
3065: l_debug_info := 'opening item cursor';
3066: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3067: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3068: l_debug_info);
3069: END IF;
3070:
3071: OPEN Item_Cur;

Line 3104: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3100: ELSE --just a line
3101:
3102: l_debug_info := 'opening line item cursor';
3103: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3104: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3105: l_debug_info);
3106: END IF;
3107:
3108: OPEN Item_Cur;

Line 3180: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

3176:
3177: BEGIN
3178:
3179: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3180: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
3181: END IF;
3182:
3183: l_calling_sequence := l_api_name;
3184:

Line 3187: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

3183: l_calling_sequence := l_api_name;
3184:
3185: l_debug_info := 'opening key cursor';
3186: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3187: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3188: l_debug_info);
3189: END IF;
3190:
3191: OPEN key_Cur;

Line 3274: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

3270: l_api_name CONSTANT VARCHAR2(200) := 'AP_Dist_Accounting_Flex';
3271:
3272: BEGIN
3273: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3274: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
3275: END IF;
3276:
3277: SELECT dist_code_combination_id,set_of_books_id
3278: INTO l_ccid,l_sob

Line 3354: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

3350:
3351: BEGIN
3352:
3353: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3354: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
3355: END IF;
3356:
3357: IF p_context = 'header' THEN
3358: --dealing with a header level attribute

Line 3887: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

3883:
3884: BEGIN
3885:
3886: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3887: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
3888: END IF;
3889:
3890: for i IN 1..p_mapping_tbl.COUNT loop
3891: l_notif_iter := get_max_notif_iteration(p_item_key) + 1;

Line 3945: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

3941:
3942: end loop;
3943:
3944: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3945: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
3946: END IF;
3947:
3948: EXCEPTION
3949: WHEN OTHERS THEN

Line 4067: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

4063:
4064: BEGIN
4065:
4066: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4067: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
4068: END IF;
4069:
4070: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4071: itemkey,

Line 4083: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

4079: itemtype || ', itemkey = ' || itemkey ||
4080: ', invoice_id = ' || l_invoice_id ||
4081: ', iteration = ' || l_invoice_iteration;
4082: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4083: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4084: l_api_name,l_debug_info);
4085: END IF;
4086:
4087: select ai.invoice_type_lookup_code, ai.internal_contact_email,

Line 4103: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

4099: l_invoice_type || ', internal_contact_email = ' ||
4100: l_internal_contact_email || ', source = ' || l_source ||
4101: ', external_user_name = ' || l_ext_user_name;
4102: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4103: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4104: l_api_name,l_debug_info);
4105: END IF;
4106:
4107: -- for non po matched invoice, only 2 levels:

Line 4115: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

4111: if ( l_internal_contact_email is not null ) then
4112: l_debug_info := l_api_name || ': non-po matched invoice, '||
4113: ' internal contact email = ' || l_internal_contact_email;
4114: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4115: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4116: l_api_name,l_debug_info);
4117: END IF;
4118:
4119: -- get the corresponding role name

Line 4143: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

4139: role_description => 'AP dispute ad hoc role based on internal rep email');
4140: l_debug_info := l_api_name || ': non-po matched invoice, '||
4141: ' ad hoc role created.';
4142: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4143: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4144: l_api_name,l_debug_info);
4145: END IF;
4146: END IF; -- adhoc_role_count <= 0
4147:

Line 4154: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

4150: p_generic_role_name => l_adhoc_role_name);
4151: l_debug_info := l_api_name || ': non-po matched invoice, '||
4152: ' ap_apinv_approvers table populated.';
4153: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4154: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4155: l_api_name,l_debug_info);
4156: END IF;
4157:
4158: end if; -- email is not null

Line 4262: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

4258: END LOOP;
4259: end if;
4260:
4261: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4262: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
4263: END IF;
4264:
4265: EXCEPTION
4266: WHEN OTHERS THEN

Line 4509: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

4505:
4506: BEGIN
4507:
4508: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4509: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
4510: END IF;
4511:
4512: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4513: itemkey,

Line 4528: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

4524: ', l_iteration = ' || l_iteration ||
4525: ', l_org_id = ' || l_org_id;
4526:
4527: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4528: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4529: l_api_name,l_debug_info);
4530: END IF;
4531:
4532:

Line 4998: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

4994:
4995: BEGIN
4996:
4997: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4998: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
4999: END IF;
5000:
5001: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
5002: itemkey,

Line 5032: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

5028: || ', itemkey = ' || itemkey
5029: || ', invoice_id = ' || l_invoice_id
5030: || ', org_id = ' || l_org_id;
5031: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5032: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5033: l_api_name,l_debug_info);
5034: END IF;
5035:
5036:

Line 5047: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

5043: -- EXIT WHEN notif_process%NOTFOUND;
5044:
5045: l_debug_info := l_api_name || ': l_notification_key = ' || l_notification_key;
5046: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5047: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5048: l_api_name,l_debug_info);
5049: END IF;
5050:
5051: if l_rowid is not null then

Line 5056: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

5052: wf_engine.createProcess('APINVLPN', itemkey, 'SEND_NOTIFICATIONS');
5053:
5054: l_debug_info := l_api_name || ': create APINVLPN process';
5055: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5056: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5057: l_api_name,l_debug_info);
5058: END IF;
5059:
5060: WF_ENGINE.SetItemAttrNumber('APINVLPN', itemkey, 'ORG_ID',l_org_id);

Line 5074: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

5070: wf_engine.startProcess('APINVLPN', itemkey);
5071:
5072: l_debug_info := l_api_name || ': APINVLPN process started';
5073: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5074: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5075: l_api_name,l_debug_info);
5076: END IF;
5077:
5078:

Line 5122: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

5118:
5119: BEGIN
5120:
5121: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5122: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
5123: END IF;
5124:
5125: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
5126: itemkey,

Line 5160: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info);

5156:
5157: l_debug_info := l_api_name || ': holds count = ' ||
5158: l_holds_count ||', approval_status = '|| l_approval_status;
5159: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5160: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info);
5161: END IF;
5162:
5163:
5164: end revalidate_invoice;

Line 5178: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

5174:
5175: BEGIN
5176:
5177: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5178: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
5179: END IF;
5180:
5181: /*l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
5182: p_calling_sequence;

Line 5215: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info);

5211: */
5212:
5213: l_debug_info := l_api_name || ': Adjust the Release Count';
5214: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5215: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info);
5216: END IF;
5217:
5218: end release_holds;
5219: