DBA Data[Home] [Help]

APPS.AP_WORKFLOW_PKG dependencies on AME_API

Line 219: AME_API.getNextApprover(applicationIdIn => 200,

215:
216:
217: --get the next approver
218:
219: AME_API.getNextApprover(applicationIdIn => 200,
220: transactionTypeIn => 'APHLD',
221: transactionIdIn => to_char(l_hold_id),
222: nextApproverOut => l_next_approver
223: );

Line 230: l_debug_info := 'Error in AME_API.getNextApprover call';

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';
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;

Line 444: l_debug_info := 'Before AME_API.updateApprovalStatus2';

440: END IF;
441: insert_history_table(p_hist_rec => l_hist_rec);
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;

Line 449: AME_API.updateApprovalStatus2(applicationIdIn => 200,

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),
451: approvalStatusIn => AME_UTIL.approvedStatus,
452: approverPersonIdIn => l_approver_id,
453: approverUserIdIn => NULL,

Line 544: l_debug_info := 'Before AME_API.updateApprovalStatus2';

540: END IF;
541: insert_history_table(p_hist_rec => l_hist_rec);
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;

Line 549: AME_API.updateApprovalStatus2(applicationIdIn => 200,

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),
551: approvalStatusIn => AME_UTIL.approvedStatus,
552: approverPersonIdIn => l_approver_id,
553: approverUserIdIn => NULL,

Line 641: l_debug_info := 'Before AME_API.updateApprovalStatus2';

637: END IF;
638: insert_history_table(p_hist_rec => l_hist_rec);
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;

Line 646: AME_API.updateApprovalStatus2(applicationIdIn => 200,

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),
648: approvalStatusIn => AME_UTIL.approvedStatus,
649: approverPersonIdIn => l_approver_id,
650: approverUserIdIn => NULL,

Line 740: l_debug_info := 'Before AME_API.updateApprovalStatus2';

736: END IF;
737: insert_history_table(p_hist_rec => l_hist_rec);
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;

Line 745: AME_API.updateApprovalStatus2(applicationIdIn => 200,

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),
747: approvalStatusIn => AME_UTIL.approvedStatus,
748: approverPersonIdIn => l_approver_id,
749: approverUserIdIn => NULL,

Line 904: l_debug_info := 'Before AME_API.updateApprovalStatus2';

900: END IF;
901: insert_history_table(p_hist_rec => l_hist_rec);
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;

Line 909: AME_API.updateApprovalStatus2(applicationIdIn => 200,

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),
911: approvalStatusIn => AME_UTIL.approvedStatus,
912: approverPersonIdIn => l_internal_approver_id,
913: approverUserIdIn => NULL,

Line 1092: l_debug_info := 'Before AME_API.updateApprovalStatus2';

1088: END IF;
1089: insert_history_table(p_hist_rec => l_hist_rec);
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;

Line 1097: AME_API.updateApprovalStatus2(applicationIdIn => 200,

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),
1099: approvalStatusIn => AME_UTIL.rejectStatus,
1100: approverPersonIdIn => l_internal_approver_id,
1101: approverUserIdIn => NULL,

Line 1218: l_debug_info := 'Before AME_API.updateApprovalStatus2';

1214: END IF;
1215: insert_history_table(p_hist_rec => l_hist_rec);
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;

Line 1224: AME_API.updateApprovalStatus2(applicationIdIn => 200,

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,
1225: transactionIdIn => to_char(l_hold_id),
1226: approvalStatusIn => AME_UTIL.approvedStatus,
1227: approverPersonIdIn => l_approver_id,
1228: approverUserIdIn => NULL,

Line 1328: ame_api2.getTransactionProductions(

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(
1329: applicationIdIn => 200,
1330: transactionIdIn => to_char(l_invoice_id),
1331: transactionTypeIn => 'APINV',
1332: variableNamesOut => l_result,

Line 1573: ame_api2.getTransactionProductions(applicationIdIn => 200,

1569: itemkey,
1570: 'ITERATION');
1571:
1572: --check AME if any production rules should prevent approval
1573: ame_api2.getTransactionProductions(applicationIdIn => 200,
1574: transactionIdIn => to_char(l_invoice_id),
1575: transactionTypeIn => 'APINV',
1576: variableNamesOut => l_result,
1577: variableValuesOut => l_reason);

Line 1806: AME_API2.getNextApprovers1

1802: l_debug_info);
1803: END IF;
1804:
1805: --get the next layer (stage) of approvers
1806: AME_API2.getNextApprovers1
1807: (applicationIdIn => 200,
1808: transactionTypeIn => 'APINV',
1809: transactionIdIn => to_char(l_invoice_id),
1810: flagApproversAsNotifiedIn => ame_util.booleanFalse,

Line 1917: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

1913: END IF; --l_class
1914: /**************/
1915: --IF l_class(l_rec) <>
1916: -- ame_util.headerItemClassName THEN
1917: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
1918: transactionIdIn => to_char(l_invoice_id),
1919: approvalStatusIn => AME_UTIL.notifiedStatus,
1920: approverNameIn => l_next_approver.NAME,
1921: transactionTypeIn => 'APINV',

Line 2088: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

2084:
2085: /********/
2086: --IF l_next_approver.item_class <>
2087: --ame_util.headerItemClassName THEN
2088: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
2089: transactionIdIn => to_char(l_invoice_id),
2090: approvalStatusIn => AME_UTIL.notifiedStatus,
2091: approverNameIn => l_next_approver.NAME,
2092: transactionTypeIn => 'APINV',

Line 2941: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

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),
2943: approvalStatusIn => AME_UTIL.rejectStatus,
2944: approverNameIn => l_role,
2945: transactionTypeIn => 'APINV',

Line 3115: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

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),
3117: approvalStatusIn => AME_UTIL.approvedStatus,
3118: approverNameIn => l_role,
3119: transactionTypeIn => 'APINV',

Line 3339: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

3335: l_invoice_key,l_line_number, l_line_amount;
3336: EXIT WHEN Items_Cur%NOTFOUND OR Items_Cur%NOTFOUND IS NULL;
3337:
3338: --update AME with response
3339: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
3340: transactionIdIn => to_char(l_invoice_id),
3341: approvalStatusIn => AME_UTIL.rejectStatus,
3342: approverNameIn => l_name,
3343: transactionTypeIn => 'APINV',

Line 3584: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

3580: l_invoice_key,l_line_number, l_line_amount;
3581: EXIT WHEN Items_Cur%NOTFOUND OR Items_Cur%NOTFOUND IS NULL;
3582:
3583: --update AME with response
3584: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
3585: transactionIdIn => to_char(l_invoice_id),
3586: approvalStatusIn => AME_UTIL.approvedStatus,
3587: approverNameIn => l_name,
3588: transactionTypeIn => 'APINV',

Line 3846: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

3842: --available so there will not be a need to loop.
3843:
3844: --update AME with response
3845: /*
3846: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
3847: transactionIdIn => to_char(l_invoice_id),
3848: approvalStatusIn => AME_UTIL.approvedStatus,
3849: approverNameIn => l_role_name,
3850: transactionTypeIn => 'APINV',

Line 4215: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

4211: --available so there will not be a need to loop.
4212:
4213: /* Not needed since we are completing the parent activity
4214: --update AME with response
4215: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
4216: transactionIdIn => to_char(l_invoice_id),
4217: approvalStatusIn => AME_UTIL.rejectStatus,
4218: approverNameIn => l_role_name,
4219: transactionTypeIn => 'APINV',

Line 4737: AME_API.getNextApprover(200,

4733: itemkey,
4734: 'NOTF_ITERATION');
4735:
4736: /*
4737: AME_API.getNextApprover(200,
4738: substr(itemkey, 1, instr(itemkey,'_')-1),
4739: 'APINV',
4740: l_next_approver);
4741: */

Line 4742: AME_API2.getNextApprovers1(applicationIdIn => 200,

4738: substr(itemkey, 1, instr(itemkey,'_')-1),
4739: 'APINV',
4740: l_next_approver);
4741: */
4742: AME_API2.getNextApprovers1(applicationIdIn => 200,
4743: transactionTypeIn => 'APINV',
4744: transactionIdIn => substr(itemkey, 1, instr(itemkey,'_')-1),
4745: flagApproversAsNotifiedIn => ame_util.booleanFalse,
4746: approvalProcessCompleteYNOut => l_complete,

Line 5057: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

5053: l_esc_approver.authority := ame_util.authorityApprover;
5054: l_esc_approver.approval_status := ame_util.forwardStatus;
5055:
5056: --update AME
5057: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
5058: transactionTypeIn => 'APINV',
5059: transactionIdIn => to_char(l_invoice_id),
5060: approvalStatusIn => AME_UTIL.noResponseStatus,
5061: approverNameIn => l_role,

Line 5249: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

5245: l_invoice_key,l_line_number, l_line_amount;
5246: EXIT WHEN Items_Cur%NOTFOUND OR Items_Cur%NOTFOUND IS NULL;
5247:
5248: --update AME
5249: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
5250: transactionTypeIn => 'APINV',
5251: transactionIdIn => to_char(l_invoice_id),
5252: approvalStatusIn => AME_UTIL.noResponseStatus,
5253: approverNameIn => l_role,

Line 5694: l_debug_info := 'Before ame_api2.clearAllApprovals';

5690: SET WFAPPROVAL_STATUS = 'INITIATED'
5691: where invoice_id = p_invoice_id;
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;

Line 5700: ame_api2.clearAllApprovals(

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(
5701: applicationidin => 200,
5702: transactiontypein => 'APINV',
5703: transactionidin => p_invoice_id);
5704: OPEN csr_ap_inv_details;

Line 5920: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

5916: l_invoice_key, l_not_key;
5917: EXIT WHEN Item_Cur%NOTFOUND;
5918:
5919:
5920: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
5921: transactionIdIn => to_char(l_invoice_id),
5922: approvalStatusIn => AME_UTIL.nullStatus,
5923: approverNameIn => l_name,
5924: transactionTypeIn => 'APINV',

Line 5957: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

5953: l_invoice_key, l_not_key;
5954: EXIT WHEN Line_Item_Cur%NOTFOUND;
5955:
5956:
5957: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
5958: transactionIdIn => to_char(l_invoice_id),
5959: approvalStatusIn => AME_UTIL.nullStatus,
5960: approverNameIn => l_name,
5961: transactionTypeIn => 'APINV',

Line 6156: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

6152: FETCH Items_Cur INTO l_item_class, l_item_id, l_name,
6153: l_invoice_key,l_line_number, l_line_amount;
6154: --update AME with response
6155: IF l_response IN ('APPROVED','ACCEPT') THEN
6156: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
6157: transactionIdIn => to_char(l_invoice_id),
6158: approvalStatusIn => AME_UTIL.approvedStatus,
6159: approverNameIn => l_name,
6160: transactionTypeIn => 'APINV',

Line 6164: AME_API2.updateApprovalStatus2(applicationIdIn => 200,

6160: transactionTypeIn => 'APINV',
6161: itemClassIn => l_item_class,
6162: itemIdIn => l_item_id);
6163: ELSIF l_response = 'REJECTED' THEN
6164: AME_API2.updateApprovalStatus2(applicationIdIn => 200,
6165: transactionIdIn => to_char(l_invoice_id),
6166: approvalStatusIn => AME_UTIL.rejectStatus,
6167: approverNameIn => l_name,
6168: transactionTypeIn => 'APINV',

Line 6794: AME_API2.getAllApprovers1(applicationIdIn => 200,

6790: IF l_wfapproval_status IN ('REQUIRED', 'INITIATED',
6791: 'STOPPED', 'NEEDS WFREAPPROVAL') THEN
6792: BEGIN
6793: --get all of the approvers
6794: AME_API2.getAllApprovers1(applicationIdIn => 200,
6795: transactionTypeIn => 'APINV',
6796: transactionIdIn => to_char(l_invoice_id),
6797: approvalProcessCompleteYNOut => l_complete,
6798: approversOut => l_next_approvers,

Line 7093: AME_API2.clearAllApprovals(applicationIdIn => 200,

7089:
7090: --we only need to clear for main process
7091: IF l_process = 'APPROVAL_MAIN' THEN
7092:
7093: AME_API2.clearAllApprovals(applicationIdIn => 200,
7094: transactionIdIn => to_char(l_invoice_id),
7095: transactionTypeIn => 'APINV');
7096:
7097: END IF;