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_APPROVAL_MATCHED_PKG dependencies on AP_APPROVAL_PKG

Line 37: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

33: p_line_location_id IN NUMBER,
34: p_match_option IN VARCHAR2,
35: p_rcv_transaction_id IN NUMBER,
36: p_system_user IN NUMBER,
37: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
38: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
39: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
40: p_calling_sequence IN VARCHAR2);
41:

Line 38: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

34: p_match_option IN VARCHAR2,
35: p_rcv_transaction_id IN NUMBER,
36: p_system_user IN NUMBER,
37: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
38: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
39: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
40: p_calling_sequence IN VARCHAR2);
41:
42: PROCEDURE Calc_Shipment_Qty_Billed(

Line 39: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

35: p_rcv_transaction_id IN NUMBER,
36: p_system_user IN NUMBER,
37: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
38: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
39: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
40: p_calling_sequence IN VARCHAR2);
41:
42: PROCEDURE Calc_Shipment_Qty_Billed(
43: p_invoice_id IN NUMBER,

Line 89: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

85: p_invoice_currency_code IN VARCHAR2,
86: p_po_unit_price IN NUMBER,
87: p_price_tolerance IN NUMBER,
88: p_system_user IN NUMBER,
89: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
90: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
91: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
92: p_calling_sequence IN VARCHAR2);
93:

Line 90: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

86: p_po_unit_price IN NUMBER,
87: p_price_tolerance IN NUMBER,
88: p_system_user IN NUMBER,
89: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
90: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
91: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
92: p_calling_sequence IN VARCHAR2);
93:
94: PROCEDURE CHECK_AVERAGE_PRICE(

Line 91: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

87: p_price_tolerance IN NUMBER,
88: p_system_user IN NUMBER,
89: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
90: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
91: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
92: p_calling_sequence IN VARCHAR2);
93:
94: PROCEDURE CHECK_AVERAGE_PRICE(
95: p_invoice_id IN NUMBER,

Line 254: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

250: p_inv_currency_code IN VARCHAR2,
251: p_sys_xrate_gain_ccid IN NUMBER,
252: p_sys_xrate_loss_ccid IN NUMBER,
253: p_system_user IN NUMBER,
254: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
255: p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
256: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
257: p_calling_sequence IN VARCHAR2) IS
258:

Line 255: p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

251: p_sys_xrate_gain_ccid IN NUMBER,
252: p_sys_xrate_loss_ccid IN NUMBER,
253: p_system_user IN NUMBER,
254: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
255: p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
256: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
257: p_calling_sequence IN VARCHAR2) IS
258:
259: -- Project LCM 7588322

Line 256: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

252: p_sys_xrate_loss_ccid IN NUMBER,
253: p_system_user IN NUMBER,
254: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
255: p_hold_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
256: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
257: p_calling_sequence IN VARCHAR2) IS
258:
259: -- Project LCM 7588322
260: l_lcm_enabled VARCHAR2(1) := 'N';

Line 476: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN

472: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'AP_APPROVAL_MATCHED_PKG.Exec_Matched_Variance_Checks(+)');
474: END IF; --bug 9242891
475:
476: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
477: g_debug_mode := 'Y';
478: END IF;
479:
480: IF (g_debug_mode = 'Y') THEN

Line 1465: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

1461: END IF;
1462:
1463: /* Bug 5230770. We should not process any invalid acct holds since it
1464: does not make any sense with SLA
1465: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
1466: p_invoice_id,
1467: NULL,
1468: NULL,
1469: 'ERV ACCT INVALID',

Line 1628: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN

1624:
1625: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
1626: p_calling_sequence;
1627:
1628: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
1629: g_debug_mode := 'Y';
1630: END IF;
1631:
1632: IF (g_debug_mode = 'Y') THEN

Line 1891: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN

1887:
1888: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
1889: p_calling_sequence;
1890:
1891: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
1892: g_debug_mode := 'Y';
1893: END IF;
1894:
1895: IF (g_debug_mode = 'Y') THEN

Line 2098: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

2094: p_services_rate_amt_tolerance IN NUMBER,
2095: p_services_total_amt_tolerance IN NUMBER,
2096: p_system_user IN NUMBER,
2097: p_conc_flag IN VARCHAR2,
2098: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
2099: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
2100: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
2101: p_calling_sequence IN VARCHAR2) IS
2102:

Line 2099: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

2095: p_services_total_amt_tolerance IN NUMBER,
2096: p_system_user IN NUMBER,
2097: p_conc_flag IN VARCHAR2,
2098: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
2099: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
2100: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
2101: p_calling_sequence IN VARCHAR2) IS
2102:
2103: CURSOR Matched_Cur IS

Line 2100: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

2096: p_system_user IN NUMBER,
2097: p_conc_flag IN VARCHAR2,
2098: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
2099: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
2100: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
2101: p_calling_sequence IN VARCHAR2) IS
2102:
2103: CURSOR Matched_Cur IS
2104: SELECT PLL.line_location_id,

Line 2326: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN

2322:
2323: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
2324: p_calling_sequence;
2325:
2326: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
2327: g_debug_mode := 'Y';
2328: END IF;
2329:
2330: l_action := 'UPDATE_CLOSE_STATE';

Line 2547: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2543: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2544: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2545: END IF;
2546:
2547: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2548: p_invoice_id,
2549: l_line_location_id,
2550: l_rcv_transaction_id,
2551: 'FINAL MATCHING',

Line 2586: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2582: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2583: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2584: END IF;
2585:
2586: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2587: p_invoice_id,
2588: l_line_location_id,
2589: l_rcv_transaction_id,
2590: 'CURRENCY DIFFERENCE',

Line 2629: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2625: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2626: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2627: END IF;
2628:
2629: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2630: p_invoice_id,
2631: l_line_location_id,
2632: l_rcv_transaction_id,
2633: 'PO NOT APPROVED',

Line 2716: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2712: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2713: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2714: END IF;
2715:
2716: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2717: p_invoice_id,
2718: l_line_location_id,
2719: l_rcv_transaction_id,
2720: 'QTY ORD',

Line 2753: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2749: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2750: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2751: END IF;
2752:
2753: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2754: p_invoice_id,
2755: l_line_location_id,
2756: l_rcv_transaction_id,
2757: 'MAX QTY ORD',

Line 2819: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2815: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2816: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2817: END IF;
2818:
2819: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2820: p_invoice_id,
2821: l_line_location_id,
2822: l_rcv_transaction_id,
2823: 'QTY REC',

Line 2864: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2860: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2861: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2862: END IF;
2863:
2864: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2865: p_invoice_id,
2866: l_line_location_id,
2867: l_rcv_transaction_id,
2868: 'MAX QTY REC',

Line 2938: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2934: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2935: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2936: END IF;
2937:
2938: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2939: p_invoice_id,
2940: l_line_location_id,
2941: l_rcv_transaction_id,
2942: 'QUALITY',

Line 2994: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

2990: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2991: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2992: END IF;
2993:
2994: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
2995: p_invoice_id,
2996: l_line_location_id,
2997: l_rcv_transaction_id,
2998: 'AMT ORD',

Line 3031: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3027: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3028: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3029: END IF;
3030:
3031: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3032: p_invoice_id,
3033: l_line_location_id,
3034: l_rcv_transaction_id,
3035: 'MAX AMT ORD',

Line 3092: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3088: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3089: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3090: END IF;
3091:
3092: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3093: p_invoice_id,
3094: l_line_location_id,
3095: l_rcv_transaction_id,
3096: 'AMT REC',

Line 3137: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3133: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3134: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3135: END IF;
3136:
3137: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3138: p_invoice_id,
3139: l_line_location_id,
3140: l_rcv_transaction_id,
3141: 'MAX AMT REC',

Line 3221: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3217: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3218: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3219: END IF;
3220:
3221: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3222: p_invoice_id,
3223: l_line_location_id,
3224: l_rcv_transaction_id,
3225: 'MILESTONE',

Line 3290: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3286: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3287: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3288: END IF;
3289:
3290: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3291: p_invoice_id,
3292: l_line_location_id,
3293: l_rcv_transaction_id,
3294: 'QTY REC',

Line 3351: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3347: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3349: END IF;
3350:
3351: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3352: p_invoice_id,
3353: l_line_location_id,
3354: l_rcv_transaction_id,
3355: 'MILESTONE',

Line 3413: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3409: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3410: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3411: END IF;
3412:
3413: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3414: p_invoice_id,
3415: l_line_location_id,
3416: l_rcv_transaction_id,
3417: 'AMT REC',

Line 3578: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3574: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3575: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3576: END IF;
3577:
3578: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3579: p_invoice_id,
3580: l_line_location_id,
3581: l_rcv_transaction_id,
3582: 'MAX SHIP AMOUNT',

Line 3640: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3636: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3637: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3638: END IF;
3639:
3640: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3641: p_invoice_id,
3642: l_line_location_id,
3643: l_rcv_transaction_id,
3644: 'MAX RATE AMOUNT',

Line 3708: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

3704: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3705: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3706: END IF;
3707:
3708: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
3709: p_invoice_id,
3710: l_line_location_id,
3711: l_rcv_transaction_id,
3712: 'MAX TOTAL AMOUNT',

Line 4076: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

4072: PROCEDURE Exec_PO_Final_Close(
4073: p_invoice_id IN NUMBER,
4074: p_system_user IN NUMBER,
4075: p_conc_flag IN VARCHAR2,
4076: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4077: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4078: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4079: p_calling_sequence IN VARCHAR2) IS
4080:

Line 4077: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

4073: p_invoice_id IN NUMBER,
4074: p_system_user IN NUMBER,
4075: p_conc_flag IN VARCHAR2,
4076: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4077: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4078: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4079: p_calling_sequence IN VARCHAR2) IS
4080:
4081: /*-----------------------------------------------------------------+

Line 4078: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

4074: p_system_user IN NUMBER,
4075: p_conc_flag IN VARCHAR2,
4076: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4077: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4078: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4079: p_calling_sequence IN VARCHAR2) IS
4080:
4081: /*-----------------------------------------------------------------+
4082: | 1. Select each 'CANT CLOSE PO' hold associated with |

Line 4202: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN

4198:
4199: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
4200: p_calling_sequence;
4201:
4202: IF ( AP_APPROVAL_PKG.g_debug_mode = 'Y' ) THEN
4203: g_debug_mode := 'Y';
4204: END IF;
4205:
4206: l_cant_try_po_close_exists := 'N';

Line 4234: AP_APPROVAL_PKG.Release_Hold(

4230:
4231: -------------------------------------------------------------------------
4232: -- Release 'CANT PO CLOSE' or 'CANT TRY PO CLOSE' hold for this match --
4233: -------------------------------------------------------------------------
4234: AP_APPROVAL_PKG.Release_Hold(
4235: p_invoice_id,
4236: l_line_location_id,
4237: '', -- rcv_transaction_id
4238: l_hold_code,

Line 4438: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

4434: IF (g_debug_mode = 'Y') THEN
4435: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
4436: END IF;
4437:
4438: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
4439: p_invoice_id,
4440: l_line_location_id,
4441: null,
4442: 'CANT CLOSE PO',

Line 4475: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

4471: IF (g_debug_mode = 'Y') THEN
4472: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
4473: END IF;
4474:
4475: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
4476: p_invoice_id,
4477: null,
4478: null,
4479: 'CANT TRY PO CLOSE',

Line 4526: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

4522: p_line_location_id IN NUMBER,
4523: p_match_option IN VARCHAR2,
4524: p_rcv_transaction_id IN NUMBER,
4525: p_system_user IN NUMBER,
4526: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4527: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4528: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4529: p_calling_sequence IN VARCHAR2) IS
4530:

Line 4527: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

4523: p_match_option IN VARCHAR2,
4524: p_rcv_transaction_id IN NUMBER,
4525: p_system_user IN NUMBER,
4526: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4527: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4528: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4529: p_calling_sequence IN VARCHAR2) IS
4530:
4531: l_rec_exception_exists VARCHAR2(1) := 'N';

Line 4528: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

4524: p_rcv_transaction_id IN NUMBER,
4525: p_system_user IN NUMBER,
4526: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4527: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4528: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4529: p_calling_sequence IN VARCHAR2) IS
4530:
4531: l_rec_exception_exists VARCHAR2(1) := 'N';
4532: l_rec_exception_count NUMBER := 0;

Line 4591: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

4587: l_debug_info := 'Process Invoice Hold Status for REC EXCEPTION';
4588: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info);
4589: END IF;
4590:
4591: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
4592: p_invoice_id,
4593: p_line_location_id,
4594: p_rcv_transaction_id,
4595: 'REC EXCEPTION',

Line 4652: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,

4648: p_invoice_currency_code IN VARCHAR2,
4649: p_po_unit_price IN NUMBER,
4650: p_price_tolerance IN NUMBER,
4651: p_system_user IN NUMBER,
4652: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4653: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4654: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4655: p_calling_sequence IN VARCHAR2) IS
4656:

Line 4653: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

4649: p_po_unit_price IN NUMBER,
4650: p_price_tolerance IN NUMBER,
4651: p_system_user IN NUMBER,
4652: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4653: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4654: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4655: p_calling_sequence IN VARCHAR2) IS
4656:
4657:

Line 4654: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,

4650: p_price_tolerance IN NUMBER,
4651: p_system_user IN NUMBER,
4652: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.HOLDSARRAY,
4653: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4654: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.COUNTARRAY,
4655: p_calling_sequence IN VARCHAR2) IS
4656:
4657:
4658: l_price_error_exists VARCHAR2(1):='N';

Line 4782: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

4778: IF (g_debug_mode = 'Y') THEN
4779: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
4780: END IF;
4781:
4782: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
4783: p_invoice_id,
4784: p_line_location_id,
4785: p_rcv_transaction_id,
4786: 'PRICE',

Line 6350: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,

6346:
6347: -- 7299826 EnC Project
6348: PROCEDURE exec_pay_when_paid_check(p_invoice_id IN NUMBER,
6349: p_system_user IN NUMBER,
6350: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
6351: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
6352: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
6353: p_calling_sequence IN VARCHAR2) IS
6354:

Line 6351: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,

6347: -- 7299826 EnC Project
6348: PROCEDURE exec_pay_when_paid_check(p_invoice_id IN NUMBER,
6349: p_system_user IN NUMBER,
6350: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
6351: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
6352: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
6353: p_calling_sequence IN VARCHAR2) IS
6354:
6355: l_debug_loc VARCHAR2(30) := 'exec_pay_when_paid_check';

Line 6352: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,

6348: PROCEDURE exec_pay_when_paid_check(p_invoice_id IN NUMBER,
6349: p_system_user IN NUMBER,
6350: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
6351: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
6352: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
6353: p_calling_sequence IN VARCHAR2) IS
6354:
6355: l_debug_loc VARCHAR2(30) := 'exec_pay_when_paid_check';
6356: l_curr_calling_sequence VARCHAR2(2000);

Line 6397: AP_APPROVAL_PKG.process_inv_hold_status(p_invoice_id,

6393: END LOOP;
6394:
6395: Print_Debug(l_debug_loc, 'pay when paid hold required for invoice id : '||p_invoice_id||' - '||l_hold_required );
6396:
6397: AP_APPROVAL_PKG.process_inv_hold_status(p_invoice_id,
6398: NULL,
6399: NULL,
6400: 'Pay When Paid',
6401: l_hold_required,

Line 6428: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,

6424:
6425: -- 7299826 EnC Project
6426: PROCEDURE exec_po_deliverable_check(p_invoice_id IN NUMBER,
6427: p_system_user IN NUMBER,
6428: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
6429: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
6430: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
6431: p_calling_sequence IN VARCHAR2
6432: ) IS

Line 6429: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,

6425: -- 7299826 EnC Project
6426: PROCEDURE exec_po_deliverable_check(p_invoice_id IN NUMBER,
6427: p_system_user IN NUMBER,
6428: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
6429: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
6430: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
6431: p_calling_sequence IN VARCHAR2
6432: ) IS
6433:

Line 6430: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,

6426: PROCEDURE exec_po_deliverable_check(p_invoice_id IN NUMBER,
6427: p_system_user IN NUMBER,
6428: p_holds IN OUT NOCOPY AP_APPROVAL_PKG.holdsarray,
6429: p_holds_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
6430: p_release_count IN OUT NOCOPY AP_APPROVAL_PKG.countarray,
6431: p_calling_sequence IN VARCHAR2
6432: ) IS
6433:
6434: l_debug_loc VARCHAR2(30) := 'exec_po_deliverable_check';

Line 6476: AP_APPROVAL_PKG.process_inv_hold_status(p_invoice_id,

6472: END LOOP;
6473:
6474: Print_Debug(l_debug_loc, 'po deliverable hold required for invoice id : '||p_invoice_id||' - '||l_hold_required );
6475:
6476: AP_APPROVAL_PKG.process_inv_hold_status(p_invoice_id,
6477: NULL,
6478: NULL,
6479: 'PO Deliverable',
6480: l_hold_required,

Line 6510: IF AP_APPROVAL_PKG.g_debug_mode = 'Y' THEN

6506: p_api_name IN VARCHAR2,
6507: p_debug_info IN VARCHAR2) IS
6508: BEGIN
6509:
6510: IF AP_APPROVAL_PKG.g_debug_mode = 'Y' THEN
6511: AP_Debug_Pkg.Print('Y', p_debug_info );
6512: END IF;
6513:
6514: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 6526: AP_APPROVAL_PKG.holdsarray,

6522:
6523: PROCEDURE exec_partial_funds_check (p_invoice_id IN NUMBER,
6524: p_system_user IN NUMBER,
6525: p_holds IN OUT NOCOPY
6526: AP_APPROVAL_PKG.holdsarray,
6527: p_holds_count IN OUT NOCOPY
6528: AP_APPROVAL_PKG.countarray,
6529: p_release_count IN OUT NOCOPY
6530: AP_APPROVAL_PKG.countarray,

Line 6528: AP_APPROVAL_PKG.countarray,

6524: p_system_user IN NUMBER,
6525: p_holds IN OUT NOCOPY
6526: AP_APPROVAL_PKG.holdsarray,
6527: p_holds_count IN OUT NOCOPY
6528: AP_APPROVAL_PKG.countarray,
6529: p_release_count IN OUT NOCOPY
6530: AP_APPROVAL_PKG.countarray,
6531: p_calling_sequence IN VARCHAR2)
6532: IS

Line 6530: AP_APPROVAL_PKG.countarray,

6526: AP_APPROVAL_PKG.holdsarray,
6527: p_holds_count IN OUT NOCOPY
6528: AP_APPROVAL_PKG.countarray,
6529: p_release_count IN OUT NOCOPY
6530: AP_APPROVAL_PKG.countarray,
6531: p_calling_sequence IN VARCHAR2)
6532: IS
6533:
6534: --BUG# 9868268

Line 6688: AP_APPROVAL_PKG.process_inv_hold_status( p_invoice_id,

6684: END LOOP;
6685:
6686: --Start bug#9868268
6687: --Introduced below call here
6688: AP_APPROVAL_PKG.process_inv_hold_status( p_invoice_id,
6689: l_line_location_id, --Bug#9868268 NULL,
6690: NULL,
6691: l_hold_name,
6692: l_hold_required,

Line 6708: /* AP_APPROVAL_PKG.process_inv_hold_status(p_invoice_id,

6704:
6705: --End bug#9868268
6706:
6707: --Commented below call here and introduced above for bug#9868268
6708: /* AP_APPROVAL_PKG.process_inv_hold_status(p_invoice_id,
6709: NULL,
6710: NULL,
6711: l_hold_name,
6712: l_hold_required,