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.AP_WORKFLOW_PKG dependencies on FND_LOG

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

2: /* $Header: aphanwfb.pls 120.64.12010000.4 2008/08/08 03:12:27 sparames ship $ */
3: --------------------------------------------------------------
4: -- Global Variables --
5: --------------------------------------------------------------
6: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP_WORKFLOW_PKG';
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10:

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

3: --------------------------------------------------------------
4: -- Global Variables --
5: --------------------------------------------------------------
6: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP_WORKFLOW_PKG';
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10:
11: -- Public Procedure Specifications

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

5: --------------------------------------------------------------
6: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP_WORKFLOW_PKG';
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10:
11: -- Public Procedure Specifications
12:
13: -- Procedure Definitions

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

60: ,p_hist_rec.APPROVER_COMMENTS
61: ,p_hist_rec.NOTIFICATION_ORDER);
62: l_debug_info := 'After Insert into AP_INV_APRVL_HIST_ALL';
63: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
64: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
65: l_debug_info);
66: END IF;
67: commit;
68: END insert_history_table;

Line 98: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.update_invoice_header2(+)');

94:
95: l_api_name := 'recreate_pay_scheds';
96:
97: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
98: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_ISP_UTILITIES_PKG.update_invoice_header2(+)');
99: END IF;
100:
101: l_debug_info := 'Step 1. update invoice amount: invoice_id = ';
102: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

99: END IF;
100:
101: l_debug_info := 'Step 1. update invoice amount: invoice_id = ';
102: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
103: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
104: END IF;
105:
106: BEGIN
107:

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

117: EXCEPTION
118: WHEN NO_DATA_FOUND THEN
119: l_debug_info := 'no lines found for the invoice id = '|| p_invoice_id;
120: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
121: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info);
122: END IF;
123: END;
124:
125:

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

132:
133:
134: l_debug_info := 'Creating Pay Schedules ';
135: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
137: END IF;
138:
139: AP_INVOICES_POST_PROCESS_PKG.insert_children (
140: X_invoice_id => p_invoice_id,

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

208: ', l_invoice_id = ' || l_invoice_id ||
209: ', l_hold_id = ' || l_hold_id ||
210: ', l_org_id = ' || l_org_id;
211: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
212: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
213: l_debug_info);
214: END IF;
215:
216:

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

222: nextApproverOut => l_next_approver
223: );
224: l_debug_info := l_api_name || ': after call to ame';
225: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
226: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
227: l_api_name,l_debug_info);
228: END IF;
229: IF l_next_approver.approval_status = ame_util.exceptionStatus THEN
230: l_debug_info := 'Error in AME_API.getNextApprover call';

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

228: END IF;
229: IF l_next_approver.approval_status = ame_util.exceptionStatus THEN
230: l_debug_info := 'Error in AME_API.getNextApprover call';
231: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
233: l_api_name,l_debug_info);
234: END IF;
235: APP_EXCEPTION.RAISE_EXCEPTION;
236: END IF;

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

322: itemkey,
323: 'HOLD_ID');
324: l_debug_info := 'Before select';
325: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
326: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
327: l_api_name,l_debug_info);
328: END IF;
329: select count(1)
330: into l_num

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

355: resultout := wf_engine.eng_completed||':'||'N';
356: END IF;
357: l_debug_info := 'After select, reultout : ' || resultout;
358: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
359: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
360: l_api_name,l_debug_info);
361: END IF;
362: EXCEPTION
363:

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

434: l_hist_rec.HOLD_ID := l_hold_id;
435:
436: l_debug_info := 'Before insert_history_table';
437: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
438: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
439: l_api_name,l_debug_info);
440: END IF;
441: insert_history_table(p_hist_rec => l_hist_rec);
442:

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

442:
443:
444: l_debug_info := 'Before AME_API.updateApprovalStatus2';
445: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
446: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
447: l_api_name,l_debug_info);
448: END IF;
449: AME_API.updateApprovalStatus2(applicationIdIn => 200,
450: transactionIdIn => to_char(l_hold_id),

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

527: l_hist_rec.HOLD_ID := l_hold_id;
528:
529: l_debug_info := 'Before ap_isp_utilities_pkg.release_hold';
530: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
531: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
532: l_api_name,l_debug_info);
533: END IF;
534: ap_isp_utilities_pkg.release_hold(p_hold_id => l_hold_id);
535:

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

534: ap_isp_utilities_pkg.release_hold(p_hold_id => l_hold_id);
535:
536: l_debug_info := 'Before insert_history_table';
537: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
538: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
539: l_api_name,l_debug_info);
540: END IF;
541: insert_history_table(p_hist_rec => l_hist_rec);
542:

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

542:
543:
544: l_debug_info := 'Before AME_API.updateApprovalStatus2';
545: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
546: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
547: l_api_name,l_debug_info);
548: END IF;
549: AME_API.updateApprovalStatus2(applicationIdIn => 200,
550: transactionIdIn => to_char(l_hold_id),

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

631: l_hist_rec.HOLD_ID := l_hold_id;
632:
633: l_debug_info := 'Before insert_history_table';
634: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
636: l_api_name,l_debug_info);
637: END IF;
638: insert_history_table(p_hist_rec => l_hist_rec);
639:

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

639:
640:
641: l_debug_info := 'Before AME_API.updateApprovalStatus2';
642: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
643: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
644: l_api_name,l_debug_info);
645: END IF;
646: AME_API.updateApprovalStatus2(applicationIdIn => 200,
647: transactionIdIn => to_char(l_hold_id),

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

723: l_hist_rec.HOLD_ID := l_hold_id;
724:
725: l_debug_info := 'Before ap_isp_utilities_pkg.release_hold';
726: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
727: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
728: l_api_name,l_debug_info);
729: END IF;
730: ap_isp_utilities_pkg.release_hold(p_hold_id => l_hold_id);
731:

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

730: ap_isp_utilities_pkg.release_hold(p_hold_id => l_hold_id);
731:
732: l_debug_info := 'Before insert_history_table';
733: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
735: l_api_name,l_debug_info);
736: END IF;
737: insert_history_table(p_hist_rec => l_hist_rec);
738:

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

738:
739:
740: l_debug_info := 'Before AME_API.updateApprovalStatus2';
741: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
743: l_api_name,l_debug_info);
744: END IF;
745: AME_API.updateApprovalStatus2(applicationIdIn => 200,
746: transactionIdIn => to_char(l_hold_id),

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

887: l_hist_rec.HOLD_ID := l_hold_id;
888:
889: l_debug_info := 'Before ap_isp_utilities_pkg.release_hold';
890: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
891: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
892: l_api_name,l_debug_info);
893: END IF;
894: ap_isp_utilities_pkg.release_hold(p_hold_id => l_hold_id);
895:

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

894: ap_isp_utilities_pkg.release_hold(p_hold_id => l_hold_id);
895:
896: l_debug_info := 'Before insert_history_table';
897: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
898: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
899: l_api_name,l_debug_info);
900: END IF;
901: insert_history_table(p_hist_rec => l_hist_rec);
902:

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

902:
903:
904: l_debug_info := 'Before AME_API.updateApprovalStatus2';
905: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
906: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
907: l_api_name,l_debug_info);
908: END IF;
909: AME_API.updateApprovalStatus2(applicationIdIn => 200,
910: transactionIdIn => to_char(l_hold_id),

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

914: transactionTypeIn => 'APHLD');
915:
916: l_debug_info := 'Before wf_engine.CompleteActivity';
917: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
918: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
919: l_api_name,l_debug_info);
920: END IF;
921: wf_engine.CompleteActivity(
922: itemType => 'APINVHDN',

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

1053: l_hist_rec.AMOUNT_APPROVED := null;
1054: l_hist_rec.HOLD_ID := l_hold_id;
1055: l_debug_info := 'Before Ap_Cancel_Single_Invoice';
1056: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1057: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1058: l_api_name,l_debug_info);
1059: END IF;
1060:
1061: open invoice;

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

1082:
1083:
1084: l_debug_info := 'Before insert_history_table';
1085: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1087: l_api_name,l_debug_info);
1088: END IF;
1089: insert_history_table(p_hist_rec => l_hist_rec);
1090:

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

1090:
1091:
1092: l_debug_info := 'Before AME_API.updateApprovalStatus2';
1093: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1094: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1095: l_api_name,l_debug_info);
1096: END IF;
1097: AME_API.updateApprovalStatus2(applicationIdIn => 200,
1098: transactionIdIn => to_char(l_hold_id),

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

1102: transactionTypeIn => 'APHLD');
1103:
1104: l_debug_info := 'Before wf_engine.CompleteActivity';
1105: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1106: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1107: l_api_name,l_debug_info);
1108: END IF;
1109: wf_engine.CompleteActivity(
1110: itemType => 'APINVHDN',

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

1201: l_hist_rec.HOLD_ID := l_hold_id;
1202:
1203: l_debug_info := 'Before ap_isp_utilities_pkg.release_hold';
1204: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1205: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1206: l_api_name,l_debug_info);
1207: END IF;
1208: ap_isp_utilities_pkg.release_hold(p_hold_id => l_hold_id);
1209:

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

1208: ap_isp_utilities_pkg.release_hold(p_hold_id => l_hold_id);
1209:
1210: l_debug_info := 'Before insert_history_table';
1211: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1212: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1213: l_api_name,l_debug_info);
1214: END IF;
1215: insert_history_table(p_hist_rec => l_hist_rec);
1216:

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

1216:
1217:
1218: l_debug_info := 'Before AME_API.updateApprovalStatus2';
1219: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1220: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1221: l_api_name,l_debug_info);
1222: END IF;
1223:
1224: AME_API.updateApprovalStatus2(applicationIdIn => 200,

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

1229: transactionTypeIn => 'APHLD');
1230:
1231: l_debug_info := 'Before wf_engine.CompleteActivity';
1232: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1233: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1234: l_api_name,l_debug_info);
1235: END IF;
1236: wf_engine.CompleteActivity(
1237: itemType => 'APINVHDN',

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

1284:
1285: BEGIN
1286:
1287: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1288: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1289: l_api_name,
1290: 'AP_IAW_PKG.'|| l_api_name);
1291: END IF;
1292:

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

1291: END IF;
1292:
1293: l_debug_info := 'set variables from workflow';
1294: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1295: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1296: l_api_name,l_debug_info);
1297: END IF;
1298:
1299: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

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

1309: 'ITERATION');
1310:
1311: l_debug_info := 'get invoice amount';
1312: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1313: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1314: l_api_name,l_debug_info);
1315: END IF;
1316:
1317: SELECT invoice_amount

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

1320: WHERE invoice_id = l_invoice_id;
1321:
1322: l_debug_info := 'check AME if production rules should prevent approval';
1323: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1324: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1325: l_api_name,l_debug_info);
1326: END IF;
1327:
1328: ame_api2.getTransactionProductions(

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

1334:
1335: IF l_result IS NOT NULL THEN
1336: l_debug_info := 'loop through production results';
1337: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1339: l_api_name,l_debug_info);
1340: END IF;
1341: FOR i IN 1..l_result.count LOOP
1342:

Line 1353: FND_LOG.STRING(G_LEVEL_STATEMENT,

1349:
1350: l_debug_info := 'get translation of reason';
1351: IF (G_LEVEL_STATEMENT >=
1352: G_CURRENT_RUNTIME_LEVEL) THEN
1353: FND_LOG.STRING(G_LEVEL_STATEMENT,
1354: G_MODULE_NAME||
1355: l_api_name,l_debug_info);
1356: END IF;
1357:

Line 1368: FND_LOG.STRING(G_LEVEL_STATEMENT,

1364:
1365: l_debug_info := 'populate history record Variables';
1366: IF (G_LEVEL_STATEMENT >=
1367: G_CURRENT_RUNTIME_LEVEL) THEN
1368: FND_LOG.STRING(G_LEVEL_STATEMENT,
1369: G_MODULE_NAME||
1370: l_api_name,l_debug_info);
1371: END IF;
1372:

Line 1393: FND_LOG.STRING(G_LEVEL_STATEMENT,

1389:
1390: l_debug_info := 'populate history record';
1391: IF (G_LEVEL_STATEMENT >=
1392: G_CURRENT_RUNTIME_LEVEL) THEN
1393: FND_LOG.STRING(G_LEVEL_STATEMENT,
1394: G_MODULE_NAME||
1395: l_api_name,l_debug_info);
1396: END IF;
1397:

Line 1403: FND_LOG.STRING(G_LEVEL_STATEMENT,

1399:
1400: l_debug_info := 'Set transaction statuses';
1401: IF (G_LEVEL_STATEMENT >=
1402: G_CURRENT_RUNTIME_LEVEL) THEN
1403: FND_LOG.STRING(G_LEVEL_STATEMENT,
1404: G_MODULE_NAME||
1405: l_api_name,l_debug_info);
1406: END IF;
1407:

Line 1433: FND_LOG.STRING(G_LEVEL_STATEMENT,

1429:
1430: l_debug_info := 'get translated reason value';
1431: IF (G_LEVEL_STATEMENT >=
1432: G_CURRENT_RUNTIME_LEVEL) THEN
1433: FND_LOG.STRING(G_LEVEL_STATEMENT,
1434: G_MODULE_NAME||
1435: l_api_name,l_debug_info);
1436: END IF;
1437:

Line 1452: FND_LOG.STRING(G_LEVEL_STATEMENT,

1448:
1449: l_debug_info := 'populate history record Variables';
1450: IF (G_LEVEL_STATEMENT >=
1451: G_CURRENT_RUNTIME_LEVEL) THEN
1452: FND_LOG.STRING(G_LEVEL_STATEMENT,
1453: G_MODULE_NAME||
1454: l_api_name,l_debug_info);
1455: END IF;
1456: l_hist_rec.invoice_id := l_invoice_id;

Line 1476: FND_LOG.STRING(G_LEVEL_STATEMENT,

1472:
1473: l_debug_info := 'populate history record';
1474: IF (G_LEVEL_STATEMENT >=
1475: G_CURRENT_RUNTIME_LEVEL) THEN
1476: FND_LOG.STRING(G_LEVEL_STATEMENT,
1477: G_MODULE_NAME||
1478: l_api_name,l_debug_info);
1479: END IF;
1480:

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

1496: ELSE --there were no production results
1497:
1498: l_debug_info := 'continue with workflow';
1499: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1500: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1501: l_api_name,l_debug_info);
1502: END IF;
1503: resultout := wf_engine.eng_completed||':'||'Y';
1504:

Line 1548: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||

1544:
1545: BEGIN
1546:
1547: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1548: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
1549: l_api_name,
1550: 'AP_WORKFLOW_PKG.'|| l_api_name);
1551: END IF;
1552:

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

1552:
1553: /*
1554: l_debug_info := 'set variables from workflow';
1555: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1556: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1557: l_api_name,l_debug_info);
1558: END IF;
1559:
1560: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,

Line 1596: FND_LOG.STRING(G_LEVEL_STATEMENT,

1592:
1593: l_debug_info := 'get translation';
1594: IF (G_LEVEL_STATEMENT >=
1595: G_CURRENT_RUNTIME_LEVEL) THEN
1596: FND_LOG.STRING(G_LEVEL_STATEMENT,
1597: G_MODULE_NAME||
1598: l_api_name,l_debug_info);
1599: END IF;
1600:

Line 1610: FND_LOG.STRING(G_LEVEL_STATEMENT,

1606:
1607: l_debug_info := 'Open Lines Cursor to Update History Tables';
1608: IF (G_LEVEL_STATEMENT >=
1609: G_CURRENT_RUNTIME_LEVEL) THEN
1610: FND_LOG.STRING(G_LEVEL_STATEMENT,
1611: G_MODULE_NAME||
1612: l_api_name,l_debug_info);
1613: END IF;
1614:

Line 1621: FND_LOG.STRING(G_LEVEL_STATEMENT,

1617:
1618: l_debug_info := 'After Open Into Fetch Lines Cursor';
1619: IF (G_LEVEL_STATEMENT >=
1620: G_CURRENT_RUNTIME_LEVEL) THEN
1621: FND_LOG.STRING(G_LEVEL_STATEMENT,
1622: G_MODULE_NAME||
1623: l_api_name,l_debug_info);
1624: END IF;
1625:

Line 1633: FND_LOG.STRING(G_LEVEL_STATEMENT,

1629:
1630: l_debug_info := 'Populate History Variables';
1631: IF (G_LEVEL_STATEMENT >=
1632: G_CURRENT_RUNTIME_LEVEL) THEN
1633: FND_LOG.STRING(G_LEVEL_STATEMENT,
1634: G_MODULE_NAME||
1635: l_api_name,l_debug_info);
1636: END IF;
1637:

Line 1663: FND_LOG.STRING(G_LEVEL_STATEMENT,

1659:
1660: l_debug_info := 'Populate History';
1661: IF (G_LEVEL_STATEMENT >=
1662: G_CURRENT_RUNTIME_LEVEL) THEN
1663: FND_LOG.STRING(G_LEVEL_STATEMENT,
1664: G_MODULE_NAME||
1665: l_api_name,l_debug_info);
1666: END IF;
1667:

Line 1677: FND_LOG.STRING(G_LEVEL_STATEMENT,

1673:
1674: l_debug_info := 'Update Lines Approval Status';
1675: IF (G_LEVEL_STATEMENT >=
1676: G_CURRENT_RUNTIME_LEVEL) THEN
1677: FND_LOG.STRING(G_LEVEL_STATEMENT,
1678: G_MODULE_NAME||
1679: l_api_name,l_debug_info);
1680: END IF;
1681:

Line 1704: FND_LOG.STRING(G_LEVEL_STATEMENT,

1700:
1701: l_debug_info := 'Check if any more lines require approval';
1702: IF (G_LEVEL_STATEMENT >=
1703: G_CURRENT_RUNTIME_LEVEL) THEN
1704: FND_LOG.STRING(G_LEVEL_STATEMENT,
1705: G_MODULE_NAME||l_api_name,l_debug_info);
1706: END IF;
1707:
1708: SELECT count(*)

Line 1718: FND_LOG.STRING(G_LEVEL_STATEMENT,

1714: IF l_lines_require_approval > 0 THEN
1715: l_debug_info := 'Still some lines require approval';
1716: IF (G_LEVEL_STATEMENT >=
1717: G_CURRENT_RUNTIME_LEVEL) THEN
1718: FND_LOG.STRING(G_LEVEL_STATEMENT,
1719: G_MODULE_NAME||l_api_name,l_debug_info);
1720: END IF;
1721: resultout := wf_engine.eng_completed||':'||'Y';
1722: ELSE

Line 1726: FND_LOG.STRING(G_LEVEL_STATEMENT,

1722: ELSE
1723: l_debug_info := 'No More Lines require approval in this invoice';
1724: IF (G_LEVEL_STATEMENT >=
1725: G_CURRENT_RUNTIME_LEVEL) THEN
1726: FND_LOG.STRING(G_LEVEL_STATEMENT,
1727: G_MODULE_NAME||l_api_name,l_debug_info);
1728: END IF;
1729: resultout := wf_engine.eng_completed||':'||'N';
1730: END IF;

Line 1769: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1765: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
1766:
1767: BEGIN
1768: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1769: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1770: G_MODULE_NAME||l_api_name,
1771: 'AP_WORKFLOW_PKG.'|| l_api_name);
1772: END IF;
1773: l_debug_info := l_api_name ||

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

1774: ': get variables from workflow: itemtype = ' ||
1775: itemtype ||
1776: ', itemkey = ' || itemkey;
1777: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1778: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1779: l_api_name,l_debug_info);
1780: END IF;
1781:
1782: l_invoice_id := WF_ENGINE.GETITEMATTRNumber

Line 1800: FND_LOG.STRING(G_LEVEL_STATEMENT,

1796: ', l_invoice_id = ' || l_invoice_id ||
1797: ', l_iteration = ' || l_iteration ||
1798: ', l_org_id = ' || l_org_id;
1799: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1800: FND_LOG.STRING(G_LEVEL_STATEMENT,
1801: G_MODULE_NAME||l_api_name,
1802: l_debug_info);
1803: END IF;
1804:

Line 1821: FND_LOG.STRING(G_LEVEL_STATEMENT,

1817:
1818: -- More values in the approver list
1819: l_debug_info := l_api_name || ': after call to ame';
1820: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1821: FND_LOG.STRING(G_LEVEL_STATEMENT,
1822: G_MODULE_NAME||l_api_name,
1823: l_debug_info);
1824: END IF;
1825:

Line 1830: FND_LOG.STRING(G_LEVEL_STATEMENT,

1826: IF l_complete = ame_util.booleanFalse THEN
1827: -- Loop through approvers' table returned by AME
1828: l_debug_info := l_api_name || ': more approvers';
1829: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1830: FND_LOG.STRING(G_LEVEL_STATEMENT,
1831: G_MODULE_NAME||l_api_name,
1832: l_debug_info);
1833: END IF;
1834: l_debug_info := l_api_name ||

Line 1839: FND_LOG.STRING(G_LEVEL_STATEMENT,

1835: ': looping through approvers'||
1836: ', next_approvers.count = ' ||
1837: l_next_approvers.count;
1838: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1839: FND_LOG.STRING(G_LEVEL_STATEMENT,
1840: G_MODULE_NAME||l_api_name,
1841: l_debug_info);
1842: END IF;
1843: --

Line 1851: FND_LOG.STRING(G_LEVEL_STATEMENT,

1847: ame_util.headerItemClassName
1848: THEN
1849: l_debug_info := l_api_name || ': item_id = '|| l_next_approver.item_id;
1850: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1851: FND_LOG.STRING(G_LEVEL_STATEMENT,
1852: G_MODULE_NAME||l_api_name,
1853: l_debug_info);
1854: END IF;
1855: --

Line 1863: FND_LOG.STRING(G_LEVEL_STATEMENT,

1859: --
1860: IF l_next_approver.item_id IS NULL THEN
1861: l_debug_info := 'item_id is null';
1862: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1863: FND_LOG.STRING(G_LEVEL_STATEMENT,
1864: G_MODULE_NAME||l_api_name,
1865: l_debug_info);
1866: END IF;
1867: FOR l_rec IN 1..l_index.count LOOP

Line 1872: FND_LOG.STRING(G_LEVEL_STATEMENT,

1868: --l_index contains the mapping between
1869: --approvers and items
1870: l_debug_info := 'looping through l_rec';
1871: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1872: FND_LOG.STRING(G_LEVEL_STATEMENT,
1873: G_MODULE_NAME||l_api_name,
1874: l_debug_info);
1875: END IF;
1876: IF l_index(l_rec) = l_table THEN

Line 1879: FND_LOG.STRING(G_LEVEL_STATEMENT,

1875: END IF;
1876: IF l_index(l_rec) = l_table THEN
1877: l_debug_info := 'check type of item class';
1878: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1879: FND_LOG.STRING(G_LEVEL_STATEMENT,
1880: G_MODULE_NAME||l_api_name,
1881: l_debug_info);
1882: END IF;
1883: --Depending on the type of item class, we need to set

Line 2005: FND_LOG.STRING(G_LEVEL_STATEMENT,

2001: sysdate,
2002: 0);
2003: l_debug_info := 'after insert';
2004: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2005: FND_LOG.STRING(G_LEVEL_STATEMENT,
2006: G_MODULE_NAME||l_api_name,
2007: l_debug_info);
2008: END IF;
2009: l_debug_info := 'Before calling insert_history_table';

Line 2011: FND_LOG.STRING(G_LEVEL_STATEMENT,

2007: l_debug_info);
2008: END IF;
2009: l_debug_info := 'Before calling insert_history_table';
2010: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2011: FND_LOG.STRING(G_LEVEL_STATEMENT,
2012: G_MODULE_NAME||l_api_name,
2013: l_debug_info);
2014: END IF;
2015: l_hist_rec.HISTORY_TYPE := 'LINESAPPROVAL';

Line 2036: FND_LOG.STRING(G_LEVEL_STATEMENT,

2032: insert_history_table(p_hist_rec => l_hist_rec);
2033:
2034: l_debug_info := 'After calling insert_history_table';
2035: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2036: FND_LOG.STRING(G_LEVEL_STATEMENT,
2037: G_MODULE_NAME||l_api_name,
2038: l_debug_info);
2039: END IF;
2040: END IF; --l_index mapping

Line 2045: FND_LOG.STRING(G_LEVEL_STATEMENT,

2041: END LOOP; -- l_index mapping
2042: ELSE --only one item_id per approver
2043: l_debug_info := 'only one item_id per approver';
2044: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2045: FND_LOG.STRING(G_LEVEL_STATEMENT,
2046: G_MODULE_NAME||l_api_name,
2047: l_debug_info);
2048: END IF;
2049: --

Line 2173: FND_LOG.STRING(G_LEVEL_STATEMENT,

2169: sysdate,
2170: 0);
2171: l_debug_info := 'Before calling insert_history_table';
2172: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2173: FND_LOG.STRING(G_LEVEL_STATEMENT,
2174: G_MODULE_NAME||l_api_name,
2175: l_debug_info);
2176: END IF;
2177: l_hist_rec.HISTORY_TYPE := 'LINESAPPROVAL';

Line 2200: FND_LOG.STRING(G_LEVEL_STATEMENT,

2196:
2197: insert_history_table(p_hist_rec => l_hist_rec);
2198: l_debug_info := 'After calling insert_history_table';
2199: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2200: FND_LOG.STRING(G_LEVEL_STATEMENT,
2201: G_MODULE_NAME||l_api_name,
2202: l_debug_info);
2203: END IF;
2204: END IF; --more than one item_id per approver

Line 2250: FND_LOG.STRING(G_LEVEL_PROCEDURE,

2246:
2247: l_pend := 0;
2248:
2249: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2250: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2251: G_MODULE_NAME||l_api_name,
2252: 'AP_WORKFLOW_PKG.'|| l_api_name);
2253: END IF;
2254: l_debug_info := l_api_name ||

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

2255: ': get variables from workflow: itemtype = ' ||
2256: itemtype ||
2257: ', itemkey = ' || itemkey;
2258: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2259: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2260: l_api_name,l_debug_info);
2261: END IF;
2262:
2263: l_invoice_id := WF_ENGINE.GETITEMATTRNumber

Line 2277: FND_LOG.STRING(G_LEVEL_STATEMENT,

2273: l_invoice_id ||
2274: ', iteration = ' ||
2275: l_iteration;
2276: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2277: FND_LOG.STRING(G_LEVEL_STATEMENT,
2278: G_MODULE_NAME||l_api_name,
2279: l_debug_info);
2280: END IF;
2281:

Line 2284: FND_LOG.STRING(G_LEVEL_STATEMENT,

2280: END IF;
2281:
2282: l_debug_info := 'Check for Pending Approvers to be notified';
2283: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2284: FND_LOG.STRING(G_LEVEL_STATEMENT,
2285: G_MODULE_NAME||l_api_name,
2286: l_debug_info);
2287: END IF;
2288:

Line 2291: FND_LOG.STRING(G_LEVEL_STATEMENT,

2287: END IF;
2288:
2289: l_debug_info := 'Process Group Approvers Cursor';
2290: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2291: FND_LOG.STRING(G_LEVEL_STATEMENT,
2292: G_MODULE_NAME||l_api_name,
2293: l_debug_info);
2294: END IF;
2295:

Line 2301: FND_LOG.STRING(G_LEVEL_STATEMENT,

2297:
2298: l_debug_info := 'Inside Group Approvers Loop for Role: '||
2299: Group_Approvers_Rec.role_name;
2300: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2301: FND_LOG.STRING(G_LEVEL_STATEMENT,
2302: G_MODULE_NAME||l_api_name,
2303: l_debug_info);
2304: END IF;
2305:

Line 2310: FND_LOG.STRING(G_LEVEL_STATEMENT,

2306: l_pend := 1;
2307:
2308: l_debug_info := 'Get Notification Iteration';
2309: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2310: FND_LOG.STRING(G_LEVEL_STATEMENT,
2311: G_MODULE_NAME||l_api_name,
2312: l_debug_info);
2313: END IF;
2314:

Line 2322: FND_LOG.STRING(G_LEVEL_STATEMENT,

2318: WHERE invoice_key = itemkey;
2319:
2320: l_debug_info := 'Notification Iteration:'||l_not_iteration;
2321: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2322: FND_LOG.STRING(G_LEVEL_STATEMENT,
2323: G_MODULE_NAME||l_api_name,
2324: l_debug_info);
2325: END IF;
2326:

Line 2329: FND_LOG.STRING(G_LEVEL_STATEMENT,

2325: END IF;
2326:
2327: l_debug_info := 'Update Iteration Value in ap_apinv_approvers';
2328: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2329: FND_LOG.STRING(G_LEVEL_STATEMENT,
2330: G_MODULE_NAME||l_api_name,
2331: l_debug_info);
2332: END IF;
2333:

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

2349: resultout := wf_engine.eng_completed||':'||'MORE';
2350: ELSE
2351: l_debug_info := 'Into the No Pending Case';
2352: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2353: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2354: l_api_name,l_debug_info);
2355: END IF;
2356:
2357: BEGIN

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

2370: l_debug_info := l_api_name ||
2371: ': sent = ' || l_sent ||
2372: ', complete = ' || l_comp;
2373: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2374: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2375: l_api_name,l_debug_info);
2376: END IF;
2377:
2378: --None sent at all

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

2379: IF l_sent = 0 and l_comp = 0 THEN
2380:
2381: l_debug_info := 'Into l_sent = 0 and l_comp = 0 case';
2382: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2383: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2384: l_api_name,l_debug_info);
2385: END IF;
2386:
2387: l_debug_info := 'Setting Approval Status for Line Records';

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

2385: END IF;
2386:
2387: l_debug_info := 'Setting Approval Status for Line Records';
2388: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2389: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2390: l_api_name,l_debug_info);
2391: END IF;
2392:
2393: /* For Invoices whose source is ISP there should always be

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

2408: AND WFApproval_Status = 'INITIATED';
2409:
2410: l_debug_info := 'Cleanup ap_apinv_approvers';
2411: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2412: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2413: l_api_name,l_debug_info);
2414: END IF;
2415:
2416:

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

2419:
2420:
2421: l_debug_info := 'Set the Result to Finish';
2422: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2423: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2424: l_api_name,l_debug_info);
2425: END IF;
2426:
2427: resultout := wf_engine.eng_completed||':'||'FINISH';

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

2429: ELSIF l_sent >0 THEN
2430:
2431: l_debug_info := 'Set the Result to Finish';
2432: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2433: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2434: l_api_name,l_debug_info);
2435: END IF;
2436: resultout := wf_engine.eng_completed||':'||'WAIT';
2437:

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

2438: ELSIF l_sent = 0 AND l_comp >0 THEN
2439:
2440: l_debug_info := l_api_name ||': all complete but none sent';
2441: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2442: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2443: l_api_name,l_debug_info);
2444: END IF;
2445:
2446: l_debug_info := 'Set the Invoice Line Approval Status to Approved if it was part of the approval process';

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

2444: END IF;
2445:
2446: l_debug_info := 'Set the Invoice Line Approval Status to Approved if it was part of the approval process';
2447: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2448: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2449: l_api_name,l_debug_info);
2450: END IF;
2451:
2452: UPDATE AP_INVOICE_LINES_ALL

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

2460: AND NOTIFICATION_STATUS = 'COMP');
2461:
2462: l_debug_info := 'Set the Invoice Line Approval Status to Not Required if it was not part of the approval process';
2463: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2464: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2465: l_api_name,l_debug_info);
2466: END IF;
2467:
2468: UPDATE AP_INVOICE_LINES_ALL

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

2471: AND WFApproval_Status = 'INITIATED';
2472:
2473: l_debug_info := 'Clear the ap_apinv_approvers';
2474: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2476: l_api_name,l_debug_info);
2477: END IF;
2478:
2479:

Line 2541: FND_LOG.STRING(G_LEVEL_PROCEDURE,

2537:
2538: BEGIN
2539:
2540: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2541: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2542: G_MODULE_NAME||l_api_name,
2543: 'AP_WORKFLOW_PKG.'|| l_api_name);
2544: END IF;
2545: l_debug_info := l_api_name ||

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

2546: ': get variables from workflow: itemtype = ' ||
2547: itemtype ||
2548: ', itemkey = ' || itemkey;
2549: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2550: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2551: l_api_name,l_debug_info);
2552: END IF;
2553:
2554: l_invoice_id := WF_ENGINE.GETITEMATTRNumber

Line 2568: FND_LOG.STRING(G_LEVEL_STATEMENT,

2564: l_invoice_id ||
2565: ', Org ID = ' ||
2566: l_org_id;
2567: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2568: FND_LOG.STRING(G_LEVEL_STATEMENT,
2569: G_MODULE_NAME||l_api_name,
2570: l_debug_info);
2571: END IF;
2572:

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

2629: ': supplier_name ' || l_invoice_supplier_name ||
2630: ', invoice_num = '|| l_invoice_number ||
2631: ', invoice_total = '|| l_invoice_total;
2632: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2633: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2634: l_api_name,l_debug_info);
2635: END IF;
2636:
2637:

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

2637:
2638:
2639: l_debug_info := 'Process Notif_Process Cursor';
2640: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2641: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2642: l_api_name,l_debug_info);
2643: END IF;
2644:
2645: FOR Notif_Process_Rec IN Notif_Process LOOP

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

2649:
2650: l_debug_info := l_api_name ||
2651: ': Role Name ' || Notif_Process_Rec.role_name;
2652: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2653: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2654: l_api_name,l_debug_info);
2655: END IF;
2656:
2657: l_debug_info := 'Before: Create The Lines Sub Process';

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

2655: END IF;
2656:
2657: l_debug_info := 'Before: Create The Lines Sub Process';
2658: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2659: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2660: l_api_name,l_debug_info);
2661: END IF;
2662:
2663: SELECT notification_key,

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

2678:
2679: l_debug_info := l_api_name ||
2680: ': Notification Key ' || l_notification_key;
2681: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2682: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2683: l_api_name,l_debug_info);
2684: END IF;
2685:
2686: WF_ENGINE.createProcess('APINVAPR',

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

2688: 'APPROVAL_INVOICE_LINES');
2689:
2690: l_debug_info := 'After: Create The Lines Sub Process';
2691: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2692: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2693: l_api_name,l_debug_info);
2694: END IF;
2695:
2696: l_debug_info := 'Set the attributes';

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

2694: END IF;
2695:
2696: l_debug_info := 'Set the attributes';
2697: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2698: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2699: l_api_name,l_debug_info);
2700: END IF;
2701:
2702: WF_DIRECTORY.GetUserName(l_orig_system,

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

2772: );
2773:
2774: l_debug_info := 'Select the Role and Approver information';
2775: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2776: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2777: l_api_name,l_debug_info);
2778: END IF;
2779: l_debug_info := 'Define Parent Child Association';
2780: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2777: l_api_name,l_debug_info);
2778: END IF;
2779: l_debug_info := 'Define Parent Child Association';
2780: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2781: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2782: l_api_name,l_debug_info);
2783: END IF;
2784:
2785: WF_ENGINE.setItemParent('APINVAPR',

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

2789: null);
2790:
2791: l_debug_info := 'Start the child process';
2792: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2793: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2794: l_api_name,l_debug_info);
2795: END IF;
2796:
2797: wf_engine.startProcess('APINVAPR', l_notification_key);

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

2797: wf_engine.startProcess('APINVAPR', l_notification_key);
2798:
2799: l_debug_info := 'Update the ap_apinv_approvers notification status';
2800: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2801: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2802: l_api_name,l_debug_info);
2803: END IF;
2804:
2805: UPDATE ap_apinv_approvers

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

2871: BEGIN
2872:
2873: l_debug_info := 'Start';
2874: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2875: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2876: l_api_name,l_debug_info);
2877: END IF;
2878:
2879: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

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

2934: END IF;
2935:
2936: l_debug_info := 'Before calling AME esc_flag : ' || l_esc_flag;
2937: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2938: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2939: l_api_name,l_debug_info);
2940: END IF;
2941: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
2942: transactionIdIn => to_char(l_invoice_id),

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

2969: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
2970:
2971: l_debug_info := 'Before calling insert_history_table';
2972: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2973: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2974: l_api_name,l_debug_info);
2975: END IF;
2976:
2977: insert_history_table(p_hist_rec => l_hist_rec);

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

2976:
2977: insert_history_table(p_hist_rec => l_hist_rec);
2978: l_debug_info := 'Before UPDATE AP_INVOICES_ALL';
2979: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2980: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2981: l_api_name,l_debug_info);
2982: END IF;
2983:
2984: UPDATE AP_INVOICES_ALL

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

2986: WHERE invoice_id = l_invoice_id;
2987:
2988: l_debug_info := 'End';
2989: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2990: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2991: l_api_name,l_debug_info);
2992: END IF;
2993:
2994: resultout := wf_engine.eng_completed||':'||'Y';

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

3033: BEGIN
3034:
3035: l_debug_info := 'Start';
3036: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3037: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3038: l_api_name,l_debug_info);
3039: END IF;
3040:
3041: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

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

3108: END IF;
3109:
3110: l_debug_info := 'Before calling AME esc_flag : ' || l_esc_flag;
3111: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3112: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3113: l_api_name,l_debug_info);
3114: END IF;
3115: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
3116: transactionIdIn => to_char(l_invoice_id),

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

3144: l_hist_rec.APPROVER_COMMENTS := l_comments;
3145:
3146: l_debug_info := 'Before calling insert_history_table';
3147: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3148: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3149: l_api_name,l_debug_info);
3150: END IF;
3151:
3152: insert_history_table(p_hist_rec => l_hist_rec);

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

3170:
3171:
3172: l_debug_info := 'End';
3173: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3174: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3175: l_api_name,l_debug_info);
3176: END IF;
3177:
3178:

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

3234:
3235: BEGIN
3236: l_debug_info := 'Start';
3237: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3238: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3239: l_api_name,l_debug_info);
3240: END IF;
3241: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
3242: itemkey,

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

3294: END IF;
3295:
3296: l_debug_info := 'Before Update Approvers table';
3297: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3298: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3299: l_api_name,l_debug_info);
3300: END IF;
3301: --Update Approvers table
3302: UPDATE AP_APINV_APPROVERS

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

3348:
3349: l_debug_info := 'Before calling insert_history_table for Line'
3350: || l_line_number;
3351: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3352: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3353: l_api_name,l_debug_info);
3354: END IF;
3355:
3356: insert_history_table(p_hist_rec => l_hist_rec);

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

3380: EXCEPTION
3381: WHEN NO_DATA_FOUND THEN
3382: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;
3383: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3384: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3385: l_api_name,l_debug_info);
3386: END IF;
3387: RAISE;
3388:

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

3389: END;
3390: l_debug_info := 'Before CompleteActivity APPROVAL_MAIN:BLOCK' ||
3391: 'l_invoice_key = ' || l_invoice_key;
3392: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3393: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3394: l_api_name,l_debug_info);
3395: END IF;
3396: wf_engine.CompleteActivity(
3397: itemType => 'APINVAPR',

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

3400: result => 'NULL');
3401:
3402: l_debug_info := 'End';
3403: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3404: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3405: l_api_name,l_debug_info);
3406: END IF;
3407: resultout := wf_engine.eng_completed||':'||'Y';
3408: EXCEPTION

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

3462:
3463: BEGIN
3464: l_debug_info := 'Start';
3465: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3466: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3467: l_api_name,l_debug_info);
3468: END IF;
3469: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
3470: itemkey,

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

3540: END IF;
3541:
3542: l_debug_info := 'Before Update Approvers table';
3543: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3544: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3545: l_api_name,l_debug_info);
3546: END IF;
3547: --Update Approvers table
3548: UPDATE AP_APINV_APPROVERS

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

3593:
3594: l_debug_info := 'Before calling insert_history_table for Line'
3595: || l_line_number;
3596: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3597: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3598: l_api_name,l_debug_info);
3599: END IF;
3600:
3601: insert_history_table(p_hist_rec => l_hist_rec);

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

3615: EXCEPTION
3616: WHEN NO_DATA_FOUND THEN
3617: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;
3618: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3619: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3620: l_api_name,l_debug_info);
3621: END IF;
3622: RAISE;
3623:

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

3625:
3626: l_debug_info := 'Before CompleteActivity APPROVAL_MAIN:BLOCK' ||
3627: 'l_invoice_key = ' || l_invoice_key;
3628: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3629: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3630: l_api_name,l_debug_info);
3631: END IF;
3632: wf_engine.CompleteActivity(
3633: itemType => 'APINVAPR',

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

3636: result => 'NULL');
3637:
3638: l_debug_info := 'End';
3639: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3640: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3641: l_api_name,l_debug_info);
3642: END IF;
3643: resultout := wf_engine.eng_completed||':'||'Y';
3644: EXCEPTION

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

3761: l_curr_calling_sequence
3762: := 'AP_WORKFLOW_PKG.aprvl_process_accept_ext';
3763: l_debug_info := 'Start';
3764: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3765: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3766: l_api_name,l_debug_info);
3767: END IF;
3768: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
3769: itemkey,

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

3855:
3856: l_debug_info := 'Before calling insert_history_table for Line'
3857: || l_line_number;
3858: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3859: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3860: l_api_name,l_debug_info);
3861: END IF;
3862: insert_history_table(p_hist_rec => l_hist_rec);
3863:

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

3863:
3864:
3865: l_debug_info := 'Before calling recreate_pay_scheds';
3866: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3867: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3868: l_api_name,l_debug_info);
3869: END IF;
3870: SELECT invoice_type_lookup_code
3871: INTO l_invoice_type_lookup_code

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

3883: result => 'APPROVED');
3884:
3885: l_debug_info := 'End';
3886: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3887: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3888: l_api_name,l_debug_info);
3889: END IF;
3890:
3891: resultout := wf_engine.eng_completed||':'||'Y';

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

3935:
3936: BEGIN
3937: l_debug_info := 'Start';
3938: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3939: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3940: l_api_name,l_debug_info);
3941: END IF;
3942: l_curr_calling_sequence := 'AP_WORKFLOW_PKG.aprvl_process_accept_int';
3943: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,

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

4017:
4018:
4019: l_debug_info := 'Before calling recreate_pay_scheds';
4020: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4021: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4022: l_api_name,l_debug_info);
4023: END IF;
4024: SELECT invoice_type_lookup_code
4025: INTO l_invoice_type_lookup_code

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

4030: recreate_pay_scheds(l_invoice_id,l_curr_calling_sequence);
4031: END IF;
4032: l_debug_info := 'End';
4033: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4034: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4035: l_api_name,l_debug_info);
4036: END IF;
4037: wf_engine.CompleteActivity(
4038: itemType => 'APINVAPR',

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

4118: BEGIN
4119:
4120: l_debug_info := 'Start';
4121: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4122: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4123: l_api_name,l_debug_info);
4124: END IF;
4125: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
4126: itemkey,

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

4180: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
4181:
4182: l_debug_info := 'Before Update Approvers table';
4183: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4184: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4185: l_api_name,l_debug_info);
4186: END IF;
4187:
4188: l_debug_info := 'Before Ap_Cancel_Single_Invoice';

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

4186: END IF;
4187:
4188: l_debug_info := 'Before Ap_Cancel_Single_Invoice';
4189: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4190: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4191: l_api_name,l_debug_info);
4192: END IF;
4193:
4194:

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

4222: */
4223: l_debug_info := 'Before calling insert_history_table for Line'
4224: || l_line_number;
4225: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4226: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4227: l_api_name,l_debug_info);
4228: END IF;
4229: insert_history_table(p_hist_rec => l_hist_rec);
4230:

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

4259:
4260:
4261: l_debug_info := 'End';
4262: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4263: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4264: l_api_name,l_debug_info);
4265: END IF;
4266:
4267: resultout := wf_engine.eng_completed||':'||'Y';

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

4971:
4972: BEGIN
4973: l_debug_info := 'Start';
4974: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4975: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4976: l_api_name,l_debug_info);
4977: END IF;
4978:
4979: --Get the current approver info

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

5098: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
5099:
5100: l_debug_info := 'Before insert_history_table';
5101: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5102: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5103: l_api_name,l_debug_info);
5104: END IF;
5105: insert_history_table(p_hist_rec => l_hist_rec);
5106:

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

5155: BEGIN
5156:
5157: l_debug_info := 'Start';
5158: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5159: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5160: l_api_name,l_debug_info);
5161: END IF;
5162:
5163:

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

5260:
5261: l_debug_info := 'Before calling insert_history_table for Line'
5262: || l_line_number;
5263: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5264: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5265: l_api_name,l_debug_info);
5266: END IF;
5267:
5268: insert_history_table(p_hist_rec => l_hist_rec);

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

5310:
5311: BEGIN
5312: l_debug_info := 'Start';
5313: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5314: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5315: l_api_name,l_debug_info);
5316: END IF;
5317: BEGIN
5318:

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

5324: EXCEPTION
5325: WHEN NO_DATA_FOUND THEN
5326: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;
5327: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5328: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5329: l_api_name,l_debug_info);
5330: END IF;
5331: RAISE;
5332:

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

5333: END;
5334: l_debug_info := 'Before CompleteActivity APPROVAL_MAIN:BLOCK' ||
5335: 'l_invoice_key = ' || l_invoice_key;
5336: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5337: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5338: l_api_name,l_debug_info);
5339: END IF;
5340: wf_engine.CompleteActivity(
5341: itemType => 'APINVAPR',

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

5344: result => 'NULL');
5345:
5346: l_debug_info := 'End';
5347: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5349: l_api_name,l_debug_info);
5350: END IF;
5351:
5352:

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

5412:
5413: BEGIN
5414: l_debug_info := 'Start';
5415: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5416: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5417: l_api_name,l_debug_info);
5418: END IF;
5419: SELECT AP_NEGOTIATION_HIST_S.nextval
5420: INTO l_new_child_ItemKey

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

5604:
5605: p_wfitemkey := l_new_child_itemkey;
5606: l_debug_info := 'End';
5607: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5608: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5609: l_api_name,l_debug_info);
5610: END IF;
5611:
5612:

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

5672:
5673: BEGIN
5674: l_debug_info := 'Start';
5675: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5676: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5677: l_api_name,l_debug_info);
5678: END IF;
5679: l_debug_info := 'Before UPDATE AP_INVOICES_ALL';
5680: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

5677: l_api_name,l_debug_info);
5678: END IF;
5679: l_debug_info := 'Before UPDATE AP_INVOICES_ALL';
5680: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5681: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5682: l_api_name,l_debug_info);
5683: END IF;
5684: l_calling_sequence := l_api_name;
5685: UPDATE AP_INVOICES_ALL

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

5692: */
5693:
5694: l_debug_info := 'Before ame_api2.clearAllApprovals';
5695: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5696: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5697: l_api_name,l_debug_info);
5698: END IF;
5699:
5700: ame_api2.clearAllApprovals(

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

5716:
5717: l_debug_info := 'Before Calling WF_ENGINE.createProcess(APINVAPR,'
5718: || l_itemkey || ',APPROVAL_MAIN);';
5719: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5720: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5721: l_api_name,l_debug_info);
5722: END IF;
5723:
5724: wf_engine.createProcess('APINVAPR', l_itemkey, 'APPROVAL_MAIN');

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

5723:
5724: wf_engine.createProcess('APINVAPR', l_itemkey, 'APPROVAL_MAIN');
5725: l_debug_info := 'Before setting item attributes' ;
5726: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5727: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5728: l_api_name,l_debug_info);
5729: END IF;
5730:
5731: WF_ENGINE.SetItemAttrNumber('APINVAPR',

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

5768: any Line levcel approvers for the matched case even if the rules
5769: have been so set up. */
5770: l_debug_info := 'Before UPDATE AP_INVOICE_LINES_ALL';
5771: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5772: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5773: l_api_name,l_debug_info);
5774: END IF;
5775: SELECT COUNT(*)
5776: INTO l_num

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

5798:
5799: l_debug_info := 'Before Calling WF_ENGINE.startProcess(APINVAPR,'
5800: || l_itemkey || ');';
5801: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5802: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5803: l_api_name,l_debug_info);
5804: END IF;
5805: WF_ENGINE.startProcess('APINVAPR', l_itemkey);
5806: l_debug_info := 'After Calling WF_ENGINE.startProcess' ;

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

5806: l_debug_info := 'After Calling WF_ENGINE.startProcess' ;
5807: p_wfitemkey := l_itemkey;
5808: l_debug_info := 'End';
5809: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5810: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5811: l_api_name,l_debug_info);
5812: END IF;
5813:
5814:

Line 5868: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

5864:
5865: BEGIN
5866:
5867: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5868: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
5869: END IF;
5870:
5871: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
5872:

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

5904: process => 'APPROVAL_MAIN');
5905:
5906: l_debug_info := 'opening item cursor';
5907: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5908: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
5909: l_debug_info);
5910: END IF;
5911:
5912: OPEN Item_Cur;

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

5941: ELSE --just a line
5942:
5943: l_debug_info := 'opening line item cursor';
5944: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5945: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
5946: l_debug_info);
5947: END IF;
5948:
5949: OPEN Line_Item_Cur;

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

6049: END IF;
6050:
6051:
6052: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6053: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6054: l_api_name,l_debug_info);
6055: END IF;
6056:
6057: l_invoice_id := WF_ENGINE.GetItemAttrNumber('APINVAPR',

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

6110: END IF;
6111:
6112: l_debug_info := 'Before Update Approvers table';
6113: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6114: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6115: l_api_name,l_debug_info);
6116: END IF;
6117: --Update Approvers table
6118: IF l_response in ('APPROVED','REJECTED','ACCEPT') THEN

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

6174:
6175: l_debug_info := 'Before calling insert_history_table for Line'
6176: || l_line_number;
6177: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6178: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6179: l_api_name,l_debug_info);
6180: END IF;
6181:
6182: insert_history_table(p_hist_rec => l_hist_rec);

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

6209: EXCEPTION
6210: WHEN NO_DATA_FOUND THEN
6211: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;
6212: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6213: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6214: l_api_name,l_debug_info);
6215: END IF;
6216: RAISE;
6217:

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

6241: END IF;
6242: */
6243: l_debug_info := 'End';
6244: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6246: l_api_name,l_debug_info);
6247: END IF;
6248: END process_single_line_response;
6249:

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

6271:
6272: BEGIN
6273:
6274: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6275: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
6276: END IF;
6277:
6278: IF p_context = 'header' THEN
6279: --dealing with a header level attribute

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

6415: l_api_name CONSTANT VARCHAR2(200) := 'AP_Dist_Accounting_Flex';
6416:
6417: BEGIN
6418: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6419: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
6420: END IF;
6421:
6422: SELECT dist_code_combination_id,set_of_books_id
6423: INTO l_ccid,l_sob

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

6496: itemkey,
6497: 'HOLD_ID');
6498: l_debug_info := 'Before select';
6499: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6500: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6501: l_api_name,l_debug_info);
6502: END IF;
6503: select aha.release_lookup_code
6504: into l_hold_release_code

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

6514: resultout := wf_engine.eng_completed||':'||'N';
6515: END IF;
6516: l_debug_info := 'After select, reultout : ' || resultout;
6517: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6518: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6519: l_api_name,l_debug_info);
6520: END IF;
6521: EXCEPTION
6522:

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

6553: itemkey,
6554: 'HOLD_ID');
6555: l_debug_info := 'Before select';
6556: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6557: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6558: l_api_name,l_debug_info);
6559: END IF;
6560: select nvl(ahc.wait_before_notify_days,0)*24*60
6561: into l_wait_time

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

6576: resultout := wf_engine.eng_completed||':'||'N';
6577: END IF;
6578: l_debug_info := 'After select, reultout : ' || resultout;
6579: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6580: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6581: l_api_name,l_debug_info);
6582: END IF;
6583: EXCEPTION
6584:

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

6616: itemkey,
6617: 'HOLD_ID');
6618: l_debug_info := 'Before select';
6619: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6620: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6621: l_api_name,l_debug_info);
6622: END IF;
6623: select aha.release_lookup_code,
6624: nvl(ahc.wait_before_notify_days,0)*24*60

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

6641: resultout := wf_engine.eng_completed||':'||'N';
6642: END IF;
6643: l_debug_info := 'After select, reultout : ' || resultout;
6644: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6645: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6646: l_api_name,l_debug_info);
6647: END IF;
6648: EXCEPTION
6649:

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

6658: l_debug_info VARCHAR2(2000);
6659: BEGIN
6660: l_debug_info := 'Start';
6661: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6662: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6663: l_api_name,l_debug_info);
6664: END IF;
6665:
6666: UPDATE ap_holds_all

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

6668: WHERE hold_id = p_hold_id;
6669:
6670: l_debug_info := 'End';
6671: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6672: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6673: l_api_name,l_debug_info);
6674: END IF;
6675: END;
6676:

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

6688: l_num_lines_under_neg := 0;
6689:
6690: l_debug_info := 'Before select for l_num_holds_under_neg';
6691: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6692: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6693: l_api_name,l_debug_info);
6694: END IF;
6695:
6696: SELECT count(*)

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

6701: AND aha.wf_status = 'NEGOTIATE';
6702:
6703: l_debug_info := 'After select for l_num_holds_under_neg, l_num_holds_under_neg = ' || l_num_holds_under_neg;
6704: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6705: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6706: l_api_name,l_debug_info);
6707: END IF;
6708: IF l_num_holds_under_neg > 0 THEN
6709: RETURN(TRUE);

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

6710: END IF;
6711:
6712: l_debug_info := 'Before select for l_num_lines_under_neg';
6713: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6714: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6715: l_api_name,l_debug_info);
6716: END IF;
6717:
6718: SELECT COUNT(*)

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

6725: AND aaa.approval_status = 'NEGOTIATE';
6726:
6727: l_debug_info := 'After select for l_num_lines_under_neg, l_num_lines_under_neg = ' || l_num_lines_under_neg;
6728: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6729: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6730: l_api_name,l_debug_info);
6731: END IF;
6732: IF l_num_lines_under_neg > 0 THEN
6733: RETURN(TRUE);

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

6764:
6765: BEGIN
6766:
6767: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6768: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
6769: END IF;
6770:
6771: l_calling_sequence := 'AP_WORLFLOW_PKG.'||l_api_name || ' <-' || p_calling_sequence;
6772:

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

6771: l_calling_sequence := 'AP_WORLFLOW_PKG.'||l_api_name || ' <-' || p_calling_sequence;
6772:
6773: l_debug_info := 'set variables from workflow';
6774: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6775: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
6776: l_debug_info);
6777: END IF;
6778:
6779: l_invoice_id := p_invoice_id;

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

6817:
6818: --More values in the approver list
6819: l_debug_info := 'after call to ame';
6820: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6821: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6822: l_api_name,l_debug_info);
6823: END IF;
6824: IF l_complete = ame_util.booleanFalse THEN
6825: --Loop through approvers' table returned by AME

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

6824: IF l_complete = ame_util.booleanFalse THEN
6825: --Loop through approvers' table returned by AME
6826: l_debug_info := 'more approvers';
6827: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6828: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6829: l_api_name,l_debug_info);
6830: END IF;
6831:
6832: FOR l_table IN

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

6833: nvl(l_next_approvers.First,0)..nvl(l_next_Approvers.Last,-1)
6834: LOOP
6835: l_debug_info := 'looping through approvers';
6836: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6837: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6838: l_api_name,l_debug_info);
6839: END IF;
6840: --set the record variable
6841: l_next_approver := l_next_approvers(l_table);

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

6847: --with this approver.
6848: IF l_next_approver.item_id IS NULL THEN
6849: l_debug_info := 'item_id is null';
6850: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6851: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6852: l_api_name,l_debug_info);
6853: END IF;
6854:
6855: FOR l_rec IN 1..l_index.count LOOP

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

6856: --l_index contains the mapping between
6857: --approvers and items
6858: l_debug_info := 'looping through l_rec';
6859: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6860: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6861: l_api_name,l_debug_info);
6862: END IF;
6863: IF l_index(l_rec) = l_table THEN
6864: l_debug_info := 'check type of item class';

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

6862: END IF;
6863: IF l_index(l_rec) = l_table THEN
6864: l_debug_info := 'check type of item class';
6865: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6866: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6867: l_api_name,l_debug_info);
6868: END IF;
6869: --Depending on the type of item class, we need to set
6870: --some variables

Line 6936: FND_LOG.STRING(G_LEVEL_STATEMENT,

6932:
6933: l_debug_info := 'after insert';
6934: IF (G_LEVEL_STATEMENT >=
6935: G_CURRENT_RUNTIME_LEVEL) THEN
6936: FND_LOG.STRING(G_LEVEL_STATEMENT,
6937: G_MODULE_NAME||
6938: l_api_name,l_debug_info);
6939: END IF;
6940: END IF; --l_index mapping

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

6943: ELSE --only one item_id per approver
6944:
6945: l_debug_info := 'only one item_id per approver';
6946: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6947: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6948: l_api_name,l_debug_info);
6949: END IF;
6950: --Depending on the type of item class, we need to set
6951: --some variables:

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

7062:
7063: BEGIN
7064:
7065: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7066: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
7067: END IF;
7068:
7069: l_calling_sequence := l_api_name;
7070:

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

7069: l_calling_sequence := l_api_name;
7070:
7071: l_debug_info := 'opening key cursor';
7072: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7073: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
7074: l_debug_info);
7075: END IF;
7076:
7077: OPEN key_Cur;

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

7139:
7140: BEGIN
7141: l_debug_info := 'Start';
7142: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7143: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7144: l_api_name,l_debug_info);
7145: END IF;
7146: SELECT count(*)
7147: INTO l_sent

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

7168: EXCEPTION
7169: WHEN NO_DATA_FOUND THEN
7170: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;
7171: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7172: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7173: l_api_name,l_debug_info);
7174: END IF;
7175: RAISE;
7176:

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

7177: END;
7178: l_debug_info := 'Before CompleteActivity APPROVAL_MAIN:BLOCK' ||
7179: 'l_invoice_key = ' || l_invoice_key;
7180: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7181: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7182: l_api_name,l_debug_info);
7183: END IF;
7184: BEGIN
7185: wf_engine.CompleteActivity(

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

7192: END;
7193: END IF;
7194: l_debug_info := 'End';
7195: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7196: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7197: l_api_name,l_debug_info);
7198: END IF;
7199: EXCEPTION
7200: WHEN OTHERS THEN NULL;

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

7220: resultout := wf_engine.eng_completed||':'||'N';
7221: END IF;
7222: l_debug_info := 'resultout : ' || resultout;
7223: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7224: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7225: l_api_name,l_debug_info);
7226: END IF;
7227: EXCEPTION
7228:

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

7267:
7268: BEGIN
7269: l_debug_info := 'Start';
7270: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7271: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7272: l_api_name,l_debug_info);
7273: END IF;
7274: -- Bug 6845397. Getting invoice id.
7275: l_invoice_id := substr(p_itemkey, 1, instr(p_itemkey,'_')-1);

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

7287: -- atleast one invoice distribution.
7288:
7289: l_debug_info := 'Updating the generate_dists of ap_invoice_lines. Invoice_id = ' || l_invoice_id;
7290: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7291: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7292: l_api_name,l_debug_info);
7293: END IF;
7294: update ap_invoice_lines_all ail
7295: set generate_dists = decode(ail.generate_dists, 'Y', 'D', ail.generate_dists)

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

7300:
7301: -- End bug 6845397
7302: l_debug_info := 'End';
7303: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7304: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7305: l_api_name,l_debug_info);
7306: END IF;
7307: EXCEPTION
7308: WHEN OTHERS THEN

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

7307: EXCEPTION
7308: WHEN OTHERS THEN
7309: l_debug_info := 'Exception during update.';
7310: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7311: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7312: l_api_name,l_debug_info);
7313: END IF ;
7314: APP_EXCEPTION.RAISE_EXCEPTION;
7315: END approve_button;

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

7319:
7320: BEGIN
7321: l_debug_info := 'Start';
7322: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7323: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7324: l_api_name,l_debug_info);
7325: END IF;
7326: BEGIN
7327: wf_engine.CompleteActivity(

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

7333: WHEN OTHERS THEN NULL;
7334: END;
7335: l_debug_info := 'End';
7336: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7337: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7338: l_api_name,l_debug_info);
7339: END IF;
7340: EXCEPTION
7341: WHEN OTHERS THEN NULL;

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

7347:
7348: BEGIN
7349: l_debug_info := 'Start';
7350: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7351: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7352: l_api_name,l_debug_info);
7353: END IF;
7354: BEGIN
7355: wf_engine.CompleteActivity(

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

7361: WHEN OTHERS THEN NULL;
7362: END;
7363: l_debug_info := 'End';
7364: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7365: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7366: l_api_name,l_debug_info);
7367: END IF;
7368: EXCEPTION
7369: WHEN OTHERS THEN NULL;

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

7374:
7375: BEGIN
7376: l_debug_info := 'Start';
7377: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7378: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7379: l_api_name,l_debug_info);
7380: END IF;
7381: BEGIN
7382: wf_engine.CompleteActivity(

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

7388: WHEN OTHERS THEN NULL;
7389: END;
7390: l_debug_info := 'End';
7391: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7392: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7393: l_api_name,l_debug_info);
7394: END IF;
7395: EXCEPTION
7396: WHEN OTHERS THEN NULL;

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

7402:
7403: BEGIN
7404: l_debug_info := 'Start';
7405: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7406: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7407: l_api_name,l_debug_info);
7408: END IF;
7409: BEGIN
7410: wf_engine.CompleteActivity(

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

7416: WHEN OTHERS THEN NULL;
7417: END;
7418: l_debug_info := 'End';
7419: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7420: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7421: l_api_name,l_debug_info);
7422: END IF;
7423: EXCEPTION
7424: WHEN OTHERS THEN NULL;

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

7430: BEGIN
7431:
7432: l_debug_info := 'Start';
7433: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7434: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7435: l_api_name,l_debug_info);
7436: END IF;
7437:
7438: WF_ENGINE.SetItemAttrText('APINVAPR',

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

7441: p_notes);
7442:
7443: l_debug_info := 'Inserting wf_notes for approval from product page';
7444: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7445: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7446: l_api_name,l_debug_info);
7447: END IF;
7448:
7449: -- Save approval comments in wf_notification_attributes

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

7456: end if;
7457:
7458: l_debug_info := 'End';
7459: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7460: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7461: l_api_name,l_debug_info);
7462: END IF;
7463:
7464: EXCEPTION

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

7490: resultout := wf_engine.eng_completed||':'||'N';
7491: END IF;
7492: l_debug_info := 'resultout : ' || resultout;
7493: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7494: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7495: l_api_name,l_debug_info);
7496: END IF;
7497: EXCEPTION
7498: