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_PREPAY_PKG dependencies on AP_PREPAY_PKG

Line 1: PACKAGE BODY AP_PREPAY_PKG AS

1: PACKAGE BODY AP_PREPAY_PKG AS
2: /*$Header: aprepayb.pls 120.42.12010000.3 2008/10/13 09:15:43 pgayen ship $*/
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_PREPAY_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_PREPAY_PKG';

1: PACKAGE BODY AP_PREPAY_PKG AS
2: /*$Header: aprepayb.pls 120.42.12010000.3 2008/10/13 09:15:43 pgayen ship $*/
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_PREPAY_PKG';
6: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
7: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
8: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
9: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 21: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_PREPAY_PKG.';

17: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
19: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
20: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_PREPAY_PKG.';
22:
23: FUNCTION Check_Supplier_Consistency (
24: p_prepay_num IN VARCHAR2,
25: p_vendor_id IN NUMBER) RETURN VARCHAR2

Line 130: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Check_Prepayment_Invoice(+)');

126:
127: BEGIN
128: l_api_name := 'Check_Prepayment_Invoice';
129: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
130: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Check_Prepayment_Invoice(+)');
131: END IF;
132:
133:
134: l_debug_info := 'Check if the prepayment invoice is a valid invoice ';

Line 166: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Check_Prepayment_Invoice(-)');

162: AND vendor_id = p_vendor_id;
163: END IF;
164:
165: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
166: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Check_Prepayment_Invoice(-)');
167: END IF;
168:
169: RETURN (l_reject_code);
170:

Line 459: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Validate_Prepay_Info(+)');

455: BEGIN
456: l_api_name := 'Validate_Prepay_Info';
457:
458: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
459: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Validate_Prepay_Info(+)');
460: END IF;
461:
462: IF p_prepay_case_name = 'DO_NOTHING_CASE' THEN
463:

Line 667: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Validate_Prepay_Info(-)');

663: RETURN (l_reject_code);
664: END IF;
665:
666: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
667: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Validate_Prepay_Info(-)');
668: END IF;
669:
670: RETURN (l_reject_code);
671:

Line 694: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Get_Prepay_Case_Name(+)');

690:
691: BEGIN
692: l_api_name := 'Get_Prepay_Case_Name';
693: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
694: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Get_Prepay_Case_Name(+)');
695: END IF;
696:
697: l_debug_info := 'Derive case name';
698: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 761: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Get_Prepay_Case_Name(-)');

757:
758: END IF;
759:
760: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
761: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Get_Prepay_Case_Name(-)');
762: END IF;
763:
764: RETURN (l_prepay_case_name);
765:

Line 945: p_prepay_appl_info OUT NOCOPY ap_prepay_pkg.prepay_appl_tab)

941: p_apply_amount IN NUMBER,
942: p_vendor_id IN NUMBER,
943: p_calling_sequence IN VARCHAR2,
944: p_request_id IN NUMBER,
945: p_prepay_appl_info OUT NOCOPY ap_prepay_pkg.prepay_appl_tab)
946: IS
947:
948: l_application_result BOOLEAN;
949: l_apply_amount_remaining NUMBER;

Line 1185: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Check_Prepay_Info_Import(+)');

1181:
1182: l_api_name := 'Check_Prepay_Info_Import';
1183:
1184: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1185: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Check_Prepay_Info_Import(+)');
1186: END IF;
1187:
1188: p_prepay_invoice_id := p_import_invoice_id;
1189:

Line 1240: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Check_Prepay_Info_Import(-)');

1236: RETURN (l_reject_code);
1237: END IF;
1238:
1239: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1240: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Check_Prepay_Info_Import(-)');
1241: END IF;
1242:
1243: RETURN (l_reject_code);
1244:

Line 1261: p_prepay_appl_info OUT NOCOPY ap_prepay_pkg.prepay_appl_tab,

1257: p_prepay_included IN VARCHAR2,
1258: p_import_invoice_id IN NUMBER,
1259: p_vendor_id IN NUMBER,
1260: p_request_id IN NUMBER,
1261: p_prepay_appl_info OUT NOCOPY ap_prepay_pkg.prepay_appl_tab,
1262: p_calling_sequence IN VARCHAR2) IS
1263:
1264: l_apply_amount NUMBER;
1265: BEGIN

Line 1312: p_prepay_appl_log OUT NOCOPY ap_prepay_pkg.Prepay_Appl_Log_Tab)

1308: p_prepay_included IN VARCHAR2,
1309: p_user_id IN NUMBER,
1310: p_last_update_login IN NUMBER,
1311: p_calling_sequence IN VARCHAR2,
1312: p_prepay_appl_log OUT NOCOPY ap_prepay_pkg.Prepay_Appl_Log_Tab)
1313: IS
1314: l_prepay_apply_amount NUMBER;
1315: l_loop_counter BINARY_INTEGER;
1316: l_dummy BOOLEAN;

Line 1318: l_prepay_appl_info ap_prepay_pkg.prepay_appl_tab;

1314: l_prepay_apply_amount NUMBER;
1315: l_loop_counter BINARY_INTEGER;
1316: l_dummy BOOLEAN;
1317: l_error_message VARCHAR2(2000);
1318: l_prepay_appl_info ap_prepay_pkg.prepay_appl_tab;
1319: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;
1320: l_curr_calling_sequence VARCHAR2(2000);
1321: BEGIN
1322:

Line 1319: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;

1315: l_loop_counter BINARY_INTEGER;
1316: l_dummy BOOLEAN;
1317: l_error_message VARCHAR2(2000);
1318: l_prepay_appl_info ap_prepay_pkg.prepay_appl_tab;
1319: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;
1320: l_curr_calling_sequence VARCHAR2(2000);
1321: BEGIN
1322:
1323:

Line 1326: AP_PREPAY_PKG.Get_Prepay_Info_Import(

1322:
1323:
1324: l_curr_calling_sequence := 'Apply_Prepay_Import <-'||p_calling_sequence;
1325:
1326: AP_PREPAY_PKG.Get_Prepay_Info_Import(
1327: P_Prepay_Case_Name => p_prepay_case_name,
1328: P_Prepay_Invoice_Id => p_prepay_invoice_id,
1329: P_Prepay_Num => p_prepay_num,
1330: P_Prepay_Line_Num => p_prepay_line_num,

Line 1346: IF (AP_PREPAY_PKG.Apply_Prepay_Line (

1342:
1343: FOR l_loop_counter IN NVL(l_prepay_appl_info.FIRST,0) .. NVL(l_prepay_appl_info.LAST,0) LOOP
1344:
1345: -- Call the Apply_Prepay_line API to apply the prepayment
1346: IF (AP_PREPAY_PKG.Apply_Prepay_Line (
1347: l_prepay_appl_info(l_loop_counter).prepay_invoice_id,
1348: l_prepay_appl_info(l_loop_counter).prepay_line_num,
1349: l_prepay_dist_info,
1350: 'Y',

Line 1394: P_PREPAY_DIST_INFO IN OUT NOCOPY AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE,

1390:
1391: FUNCTION Apply_Prepay_Line (
1392: P_PREPAY_INVOICE_ID IN NUMBER,
1393: P_PREPAY_LINE_NUM IN NUMBER,
1394: P_PREPAY_DIST_INFO IN OUT NOCOPY AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE,
1395: P_PRORATE_FLAG IN VARCHAR2,
1396: P_INVOICE_ID IN NUMBER,
1397: /*Contract Payments*/
1398: P_INVOICE_LINE_NUMBER IN NUMBER DEFAULT NULL,

Line 1470: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;

1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1468:
1469: -- PREPAY distributions related variables
1470: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;
1471: l_max_dist_number
1472: ap_invoice_distributions_all.distribution_line_number%TYPE;
1473: l_loop_counter BINARY_INTEGER := 1;
1474: l_loop_variable BINARY_INTEGER;

Line 1639: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Apply_Prepay_Line(+)');

1635:
1636: l_api_name := 'Apply_Prepay_Line';
1637:
1638: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1639: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Apply_Prepay_Line(+)');
1640: END IF;
1641:
1642: -- ==========================================================
1643: -- Step 0: Get Base Currency Code

Line 1915: l_debug_info := 'Call Ap_Prepay_Pkg.Insert_Prepay_Line';

1911: -- _LINE procedure to create the PREPAY line if the
1912: -- calling mode is 'PREPAYMENT APPLICATION', not for
1913: -- RECOUPMENT.
1914: -- ===========================================================
1915: l_debug_info := 'Call Ap_Prepay_Pkg.Insert_Prepay_Line';
1916: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1917: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1918: END IF;
1919:

Line 1920: l_dummy := AP_PREPAY_PKG.INSERT_PREPAY_LINE(

1916: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1917: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1918: END IF;
1919:
1920: l_dummy := AP_PREPAY_PKG.INSERT_PREPAY_LINE(
1921: p_prepay_invoice_id,
1922: p_prepay_line_num,
1923: p_invoice_id,
1924: l_prepay_ln_number,

Line 2408: l_debug_info := 'Call Ap_Prepay_Pkg.Insert_Prepay_Dists';

2404: ELSE
2405: l_invoice_line_number := l_prepay_ln_number;
2406: END IF;
2407:
2408: l_debug_info := 'Call Ap_Prepay_Pkg.Insert_Prepay_Dists';
2409: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2410: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2411: END IF;
2412:

Line 2413: l_dummy := AP_PREPAY_PKG.INSERT_PREPAY_DISTS(

2409: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2410: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2411: END IF;
2412:
2413: l_dummy := AP_PREPAY_PKG.INSERT_PREPAY_DISTS(
2414: p_prepay_invoice_id,
2415: p_prepay_line_num,
2416: p_invoice_id,
2417: l_std_inv_batch_id,

Line 2561: l_dummy := AP_PREPAY_PKG.Update_Prepayment(

2557: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2558: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2559: END IF;
2560:
2561: l_dummy := AP_PREPAY_PKG.Update_Prepayment(
2562: l_prepay_dist_info,
2563: p_prepay_invoice_id,
2564: p_prepay_line_num,
2565: p_invoice_id,

Line 2596: l_dummy := AP_PREPAY_PKG.Update_PO_Receipt_Info(

2592: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2593: END IF;
2594:
2595:
2596: l_dummy := AP_PREPAY_PKG.Update_PO_Receipt_Info(
2597: l_prepay_dist_info,
2598: p_prepay_invoice_id,
2599: p_prepay_line_num,
2600: p_invoice_id,

Line 2673: l_dummy := AP_PREPAY_PKG.Update_Payment_Schedule(

2669: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2670: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2671: END IF;
2672:
2673: l_dummy := AP_PREPAY_PKG.Update_Payment_Schedule(
2674: p_invoice_id,
2675: p_prepay_invoice_id,
2676: p_prepay_line_num,
2677: l_ppay_apply_amt_in_pay_curr,

Line 2726: -- l_dummy := AP_PREPAY_PKG.Update_Rounding_Amounts(

2722: --IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2723: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2724: --END IF;
2725:
2726: -- l_dummy := AP_PREPAY_PKG.Update_Rounding_Amounts(
2727: -- p_prepay_invoice_id,
2728: -- p_prepay_line_num,
2729: -- p_invoice_id,
2730: -- l_invoice_line_number,

Line 2762: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Apply_Prepay_Line(-)');

2758: -- Hence we can return TRUE to the calling module.
2759: -- ===========================================================
2760:
2761: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2762: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Apply_Prepay_Line(-)');
2763: END IF;
2764:
2765: RETURN (TRUE);
2766:

Line 2847: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Insert_Prepay_Line(+)');

2843: l_current_calling_sequence := 'Insert_Prepay_Line<-'
2844: ||p_calling_sequence;
2845:
2846: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2847: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Insert_Prepay_Line(+)');
2848: END IF;
2849:
2850: l_debug_info := 'Insert PREPAY Line';
2851: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3170: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Insert_Prepay_Line(-)');

3166: WHERE invoice_id = p_prepay_invoice_id
3167: AND line_number = p_prepay_line_num;
3168:
3169: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3170: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Insert_Prepay_Line(-)');
3171: END IF;
3172:
3173: RETURN (TRUE);
3174: EXCEPTION

Line 3220: P_prepay_dist_info IN OUT NOCOPY AP_PREPAY_PKG.Prepay_Dist_Tab_Type,

3216: P_prepay_line_num IN NUMBER,
3217: P_invoice_id IN NUMBER,
3218: P_batch_id IN NUMBER,
3219: P_line_number IN NUMBER,
3220: P_prepay_dist_info IN OUT NOCOPY AP_PREPAY_PKG.Prepay_Dist_Tab_Type,
3221: P_user_id IN NUMBER,
3222: P_last_update_login IN NUMBER,
3223: P_calling_sequence IN VARCHAR2,
3224: P_error_message OUT NOCOPY VARCHAR2)

Line 3244: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Insert_Prepay_Dists(+)');

3240: l_api_name := 'Insert_Prepay_Dists';
3241: l_calling_program := p_calling_sequence;
3242:
3243: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3244: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Insert_Prepay_Dists(+)');
3245: END IF;
3246:
3247: l_debug_info := 'Insert PREPAY Distributions';
3248: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3739: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Insert_Prepay_Dists(-)');

3735: -- END IF;
3736: END LOOP;
3737:
3738: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3739: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Insert_Prepay_Dists(-)');
3740: END IF;
3741:
3742: RETURN (TRUE);
3743: EXCEPTION

Line 3778: p_prepay_dist_info IN AP_PREPAY_PKG.Prepay_Dist_Tab_Type,

3774: END Insert_Prepay_Dists;
3775:
3776:
3777: FUNCTION Update_Prepayment(
3778: p_prepay_dist_info IN AP_PREPAY_PKG.Prepay_Dist_Tab_Type,
3779: p_prepay_invoice_id IN NUMBER,
3780: p_prepay_line_num IN NUMBER,
3781: p_invoice_id IN NUMBER,
3782: p_invoice_line_num IN NUMBER,

Line 3814: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Update_Prepayment(+)');

3810: -- Update the calling sequence for debugging purposes
3811:
3812: l_api_name := 'Update_Prepayment';
3813: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3814: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Update_Prepayment(+)');
3815: END IF;
3816:
3817: l_calling_program := p_calling_sequence;
3818: l_current_calling_sequence := 'update_prepayment<-' ||p_calling_sequence;

Line 3948: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Update_Prepayment(-)');

3944:
3945: END IF;
3946:
3947: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3948: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Update_Prepayment(-)');
3949: END IF;
3950:
3951: RETURN (TRUE);
3952:

Line 3985: p_prepay_dist_info IN AP_PREPAY_PKG.Prepay_Dist_Tab_Type,

3981: END Update_Prepayment;
3982:
3983:
3984: FUNCTION Update_PO_Receipt_Info(
3985: p_prepay_dist_info IN AP_PREPAY_PKG.Prepay_Dist_Tab_Type,
3986: p_prepay_invoice_id IN NUMBER,
3987: p_prepay_line_num IN NUMBER,
3988: p_invoice_id IN NUMBER,
3989: p_invoice_line_num IN NUMBER,

Line 4063: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Update_PO_Receipt_Info(+)');

4059:
4060: l_current_calling_sequence := 'update_po_receipt_info<-'||
4061: p_calling_sequence;
4062: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4063: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Update_PO_Receipt_Info(+)');
4064: END IF;
4065:
4066: l_debug_info := 'Create l_po_ap_dist_rec object';
4067: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4225: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Update_PO_Receipt_Info(-)');

4221: X_Return_Status => l_return_status,
4222: X_Msg_Data => l_msg_data);
4223:
4224: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4225: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Update_PO_Receipt_Info(-)');
4226: END IF;
4227:
4228: RETURN (TRUE);
4229: EXCEPTION

Line 4315: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Update_Payment_Schedule(+)');

4311: l_current_calling_sequence := 'update_payment_schedule<-'||
4312: p_calling_sequence;
4313:
4314: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4315: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Update_Payment_Schedule(+)');
4316: END IF;
4317:
4318: IF (p_invoice_id IS NULL OR
4319: p_apply_amount IS NULL OR

Line 4467: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Update_Payment_Schedule(-)');

4463:
4464: END IF;
4465:
4466: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4467: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_PREPAY_PKG.Update_Payment_Schedule(-)');
4468: END IF;
4469:
4470: RETURN (TRUE);
4471:

Line 4548: l_prepay_dist_info AP_PREPAY_PKG.prepay_dist_tab_type;

4544: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
4545: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
4546: l_ppay_apply_amt_in_pay_curr NUMBER;
4547: l_prepay_line_rec ap_invoice_lines_all%ROWTYPE;
4548: l_prepay_dist_info AP_PREPAY_PKG.prepay_dist_tab_type;
4549: l_debug_info VARCHAR2(100);
4550: l_current_calling_sequence VARCHAR2(2000);
4551: l_calling_program VARCHAR2(1000);
4552: l_result BOOLEAN;

Line 4714: l_dummy := AP_PREPAY_PKG.Update_Prepayment(

4710: */
4711: -- ===========================================================
4712: -- Step 6: Update Prepayment
4713: -- ===========================================================
4714: l_dummy := AP_PREPAY_PKG.Update_Prepayment(
4715: l_prepay_dist_info,
4716: p_prepay_invoice_id,
4717: p_prepay_line_num,
4718: p_invoice_id,

Line 4733: l_dummy := AP_PREPAY_PKG.Update_PO_Receipt_Info(

4729: -- ===========================================================
4730: -- Step 7: Update PO/RCV information
4731: -- ===========================================================
4732:
4733: l_dummy := AP_PREPAY_PKG.Update_PO_Receipt_Info(
4734: l_prepay_dist_info,
4735: p_prepay_invoice_id,
4736: p_prepay_line_num,
4737: p_invoice_id,

Line 4755: l_dummy := AP_PREPAY_PKG.Update_Payment_Schedule (

4751: -- Step 8: Update Payment Schedules
4752: -- ===========================================================
4753:
4754: IF NVL(p_prepay_included, 'N') = 'N' THEN
4755: l_dummy := AP_PREPAY_PKG.Update_Payment_Schedule (
4756: p_invoice_id,
4757: p_prepay_invoice_id,
4758: p_prepay_line_num,
4759: l_ppay_apply_amt_in_pay_curr,

Line 4839: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;

4835: p_calling_sequence IN VARCHAR2,
4836: p_error_message OUT NOCOPY VARCHAR2)
4837: RETURN BOOLEAN IS
4838:
4839: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;
4840:
4841: l_prepay_id NUMBER;
4842: l_prepay_num VARCHAR2(50);
4843: l_prepay_ln_num NUMBER;

Line 4920: l_result := AP_PREPAY_PKG.Apply_Prepay_Line (

4916: END IF;
4917:
4918: l_apply_amount_remaining := l_apply_amount_remaining - l_apply_amount;
4919:
4920: l_result := AP_PREPAY_PKG.Apply_Prepay_Line (
4921: l_prepay_id,
4922: l_prepay_ln_num,
4923: l_prepay_dist_info,
4924: 'Y',

Line 4989: END AP_PREPAY_PKG;

4985:
4986: END Apply_Prepay_FR_Prepay;
4987:
4988:
4989: END AP_PREPAY_PKG;