[Home] [Help]
122: p_exchange_rate_cache IN BINARY_INTEGER DEFAULT 1000
123: ) IS
124: BEGIN
125: IF PG_DEBUG in ('Y', 'C') THEN
126: arp_util.debug('Configure_Library_Caches()+ ');
127: END IF;
128:
129: G_SITE_USE_CACHE_SIZE := p_site_use_cache;
130: G_CUST_NUM_CACHE_SIZE := p_cust_number_cache;
139: G_METHOD_INFO_CACHE_SIZE := p_method_info_cache;
140: G_EXCHANGE_RATE_CACHE_SIZE := p_exchange_rate_cache;
141:
142: IF PG_DEBUG in ('Y', 'C') THEN
143: arp_util.debug('Configure_Library_Caches()- ');
144: END IF;
145:
146: EXCEPTION
147: WHEN OTHERS THEN
145:
146: EXCEPTION
147: WHEN OTHERS THEN
148: IF PG_DEBUG in ('Y', 'C') THEN
149: arp_util.debug('EXCEPTION: Configure_Library_Caches() ');
150: END IF;
151: RAISE;
152:
153: END Configure_Library_Caches;
159:
160: BEGIN
161:
162: IF PG_DEBUG in ('Y', 'C') THEN
163: arp_util.debug('Add_Value_To_Cache()+ ');
164: END IF;
165:
166: IF ( p_cache_name = 'CUSTOMER_NUMBER' )
167: THEN
279: G_Legal_Entity_Cache_Tbl( p_index ).id := p_id;
280: END IF;
281: END IF;
282: IF PG_DEBUG in ('Y', 'C') THEN
283: arp_util.debug('Add_Value_To_Cache()- ');
284: END IF;
285:
286: EXCEPTION
287: WHEN OTHERS THEN
285:
286: EXCEPTION
287: WHEN OTHERS THEN
288: IF PG_DEBUG in ('Y', 'C') THEN
289: arp_util.debug('EXCEPTION: Add_Value_To_Cache. Cache: ' ||
290: p_cache_name || ' ' ||
291: ' Value: ' || p_value);
292: END IF;
293: RAISE;
305:
306: BEGIN
307:
308: IF PG_DEBUG in ('Y', 'C') THEN
309: arp_util.debug('Find_Value_In_Cache()+ ');
310: END IF;
311:
312: IF (p_cache_name = 'CUSTOMER_NUMBER')
313: THEN
468:
469: END LOOP;
470:
471: IF PG_DEBUG in ('Y', 'C') THEN
472: arp_util.debug('Find_Value_In_Cache()- ');
473: END IF;
474:
475: RETURN(NULL);
476:
477: EXCEPTION
478:
479: WHEN OTHERS THEN
480: IF PG_DEBUG in ('Y', 'C') THEN
481: arp_util.debug('EXCEPTION: Find_Value_In_Cache. Cache: ' ||
482: p_cache_name || ' ' ||
483: ' Value: ' || p_value);
484: END IF;
485:
503:
504: BEGIN
505:
506: IF PG_DEBUG in ('Y', 'C') THEN
507: arp_util.debug('Get_Id()+ ');
508: END IF;
509:
510: IF ( p_value IS NULL )
511: THEN
659: NVL( l_index, 0 ) + 1
660: );
661:
662: IF PG_DEBUG in ('Y', 'C') THEN
663: arp_util.debug('Get_Id: ' || 'Value selected. Entity: '||
664: p_entity || ',' ||
665: ' Value: ' || p_value || ',' ||
666: 'ID: ' || l_selected_id);
667: arp_util.debug('Get_Id()- ');
663: arp_util.debug('Get_Id: ' || 'Value selected. Entity: '||
664: p_entity || ',' ||
665: ' Value: ' || p_value || ',' ||
666: 'ID: ' || l_selected_id);
667: arp_util.debug('Get_Id()- ');
668: END IF;
669:
670: RETURN( l_selected_id );
671:
675: END IF; -- end p_value is not null case
676:
677:
678: IF PG_DEBUG in ('Y', 'C') THEN
679: arp_util.debug('Get_Id()- ');
680: END IF;
681:
682:
683: EXCEPTION
683: EXCEPTION
684:
685: WHEN NO_DATA_FOUND THEN
686: IF PG_DEBUG in ('Y', 'C') THEN
687: arp_util.debug('Get_Id: ' || 'Value not found. Entity: ' ||
688: p_entity ||' Value: ' || p_value);
689: END IF;
690: return(null);
691: IF PG_DEBUG in ('Y', 'C') THEN
688: p_entity ||' Value: ' || p_value);
689: END IF;
690: return(null);
691: IF PG_DEBUG in ('Y', 'C') THEN
692: arp_util.debug('Get_Id()- ');
693: END IF;
694:
695: WHEN OTHERS THEN
696: IF PG_DEBUG in ('Y', 'C') THEN
693: END IF;
694:
695: WHEN OTHERS THEN
696: IF PG_DEBUG in ('Y', 'C') THEN
697: arp_util.debug('Get_Id: ' || 'Value not found. Entity: ' ||
698: p_entity ||' Value: ' || p_value);
699: END IF;
700: RAISE;
701:
712: ) IS
713: BEGIN
714:
715: IF PG_DEBUG in ('Y', 'C') THEN
716: arp_util.debug('Add_Site_Use_To_Cache()+ ');
717: END IF;
718: IF ( p_index <= G_SITE_USE_CACHE_SIZE )
719: THEN
720: G_Site_Use_Cache_Tbl(p_index).customer_id :=
725: p_site_use_code;
726: G_Site_Use_Cache_Tbl(p_index).id := p_id;
727: END IF;
728: IF PG_DEBUG in ('Y', 'C') THEN
729: arp_util.debug('Add_Site_Use_To_Cache()- ');
730: END IF;
731: EXCEPTION
732: WHEN OTHERS THEN
733: IF PG_DEBUG in ('Y', 'C') THEN
730: END IF;
731: EXCEPTION
732: WHEN OTHERS THEN
733: IF PG_DEBUG in ('Y', 'C') THEN
734: arp_util.debug('EXCEPTION: Add_Site_Use_To_Cache');
735: END IF;
736: RAISE;
737: END Add_Site_Use_To_Cache;
738:
749:
750: BEGIN
751:
752: IF PG_DEBUG in ('Y', 'C') THEN
753: arp_util.debug('Find_Site_Use_In_Cache()+ ');
754: END IF;
755:
756: l_count := G_Site_Use_Cache_Tbl.count;
757:
778:
779: END LOOP;
780:
781: IF PG_DEBUG in ('Y', 'C') THEN
782: arp_util.debug('Find_Site_Use_In_Cache()- ');
783: END IF;
784:
785: RETURN(NULL);
786:
787: EXCEPTION
788:
789: WHEN OTHERS THEN
790: IF PG_DEBUG in ('Y', 'C') THEN
791: arp_util.debug('EXCEPTION: Find_Site_Use_In_Cache');
792: END IF;
793:
794: RAISE;
795:
807: l_index BINARY_INTEGER;
808: BEGIN
809:
810: IF PG_DEBUG in ('Y', 'C') THEN
811: arp_util.debug('Get_Site_Use_Id()+ ');
812: END IF;
813:
814: /* IF ( p_customer_id IS NULL ) THEN
815: RETURN(NULL);
843: AND site_use.location = p_location;
844: EXCEPTION
845: WHEN no_data_found THEN
846: IF PG_DEBUG in ('Y', 'C') THEN
847: arp_util.debug('Get_Site_Use_Id: ' || 'No data found in the hz_cust_site_uses for the location :'||p_location);
848: END IF;
849: --the error message will be raised in the validation routine.
850: null;
851: END;
871:
872: EXCEPTION
873: WHEN no_data_found THEN
874: IF PG_DEBUG in ('Y', 'C') THEN
875: arp_util.debug('Get_Site_Use_Id: ' || 'No_data_found : Site use id could not be defaulted for customer_id '||to_char(p_customer_id));
876: END IF;
877: --This is the case where customer site use id is null
878: --neither it was supplied by the user nor it could be defaulted
879: --a WARNING message raised in the validation routine to indicate
898: RETURN( l_selected_id );
899: EXCEPTION
900: WHEN others THEN
901: IF PG_DEBUG in ('Y', 'C') THEN
902: arp_util.debug('EXCEPTION: Get_Site_Use_Id.');
903: END IF;
904: raise;
905:
906: END Get_Site_Use_Id;
944:
945: EXCEPTION
946: WHEN others THEN
947: IF PG_DEBUG in ('Y', 'C') THEN
948: arp_util.debug('EXCEPTION: Get_Cross_Validated_Id() '||p_entity);
949: END IF;
950: raise;
951: END Get_Cross_Validated_Id;
952:
956: l_index BINARY_INTEGER;
957: BEGIN
958:
959: IF PG_DEBUG in ('Y', 'C') THEN
960: arp_util.debug('Add_Method_Info_To_Cache()+ ');
961: END IF;
962: IF p_index IS NULL THEN
963: l_index := nvl(Method_Info_Cache_Tbl.LAST,0) + 1;
964: END IF;
967:
968: Method_Info_Cache_Tbl(l_index) := p_method_info_record;
969:
970: IF PG_DEBUG in ('Y', 'C') THEN
971: arp_util.debug('Added the record at index '|| l_index);
972: END IF;
973: END IF;
974:
975: IF PG_DEBUG in ('Y', 'C') THEN
972: END IF;
973: END IF;
974:
975: IF PG_DEBUG in ('Y', 'C') THEN
976: arp_util.debug('Add_Method_Info_To_Cache()- ');
977: END IF;
978:
979: EXCEPTION
980:
979: EXCEPTION
980:
981: WHEN OTHERS THEN
982: IF PG_DEBUG in ('Y', 'C') THEN
983: arp_util.debug('EXCEPTION: Add_Method_Info_To_Cache');
984: END IF;
985: RAISE;
986: END Add_Method_Info_To_Cache;
987:
993: l_index_curr BINARY_INTEGER;
994:
995: BEGIN
996: IF PG_DEBUG in ('Y', 'C') THEN
997: arp_util.debug('Get_Method_Info_From_Cache ()+ ');
998: END IF;
999:
1000: l_count := Method_Info_Cache_Tbl.count;
1001:
1014: Nvl(Method_info_cache_tbl(L_index).Rma_end_date, P_receipt_date ) ) ) Then
1015: P_method_info_record := Method_info_cache_tbl(L_index);
1016:
1017: If Pg_debug In ('y', 'c') Then
1018: Arp_util.Debug('found The Record In Cache ');
1019: End If;
1020: Exit;
1021: End If;
1022: End Loop;
1022: End Loop;
1023: END IF;
1024:
1025: IF PG_DEBUG in ('Y', 'C') THEN
1026: arp_util.debug('Get_Method_Info_From_Cache ()- ');
1027: END IF;
1028:
1029: EXCEPTION
1030: WHEN others THEN
1028:
1029: EXCEPTION
1030: WHEN others THEN
1031: IF PG_DEBUG in ('Y', 'C') THEN
1032: arp_util.debug('EXCEPTION: Get_Method_Info_From_Cache() ');
1033: END IF;
1034: raise;
1035: END Get_Method_Info_From_Cache;
1036:
1044: ) IS
1045: BEGIN
1046:
1047: IF PG_DEBUG in ('Y', 'C') THEN
1048: arp_util.debug('Add_Exchange_Rate_To_Cache()+ ');
1049: END IF;
1050:
1051:
1052: IF ( p_index <= G_EXCHANGE_RATE_CACHE_SIZE )
1061: p_exchange_rate_date;
1062: END IF;
1063:
1064: IF PG_DEBUG in ('Y', 'C') THEN
1065: arp_util.debug('Add_Exchange_Rate_To_Cache()- ');
1066: END IF;
1067:
1068: EXCEPTION
1069:
1068: EXCEPTION
1069:
1070: WHEN OTHERS THEN
1071: IF PG_DEBUG in ('Y', 'C') THEN
1072: arp_util.debug('EXCEPTION: Add_Exchange_Rate_To_Cache');
1073: END IF;
1074:
1075: RAISE;
1076:
1085: l_default_gl_date DATE;
1086: BEGIN
1087: p_return_status := FND_API.G_RET_STS_SUCCESS;
1088: IF PG_DEBUG in ('Y', 'C') THEN
1089: arp_util.debug('Default_gl_date ()+');
1090: END IF;
1091: IF p_gl_date IS NULL THEN
1092: IF (arp_util.validate_and_default_gl_date(
1093: p_entered_date,
1088: IF PG_DEBUG in ('Y', 'C') THEN
1089: arp_util.debug('Default_gl_date ()+');
1090: END IF;
1091: IF p_gl_date IS NULL THEN
1092: IF (arp_util.validate_and_default_gl_date(
1093: p_entered_date,
1094: NULL,
1095: p_validation_date, /* Bug fix 3547720 */
1096: NULL,
1107: l_error_message) = TRUE)
1108: THEN
1109: p_gl_date := l_default_gl_date;
1110: IF PG_DEBUG in ('Y', 'C') THEN
1111: arp_util.debug('Default_gl_date: ' || 'Defaulted GL Date : '||to_char(p_gl_date,'DD-MON-YYYY'));
1112: END IF;
1113: ELSE
1114: IF PG_DEBUG in ('Y', 'C') THEN
1115: arp_util.debug('Default_gl_date: ' || 'GL Date could not be defaulted ');
1111: arp_util.debug('Default_gl_date: ' || 'Defaulted GL Date : '||to_char(p_gl_date,'DD-MON-YYYY'));
1112: END IF;
1113: ELSE
1114: IF PG_DEBUG in ('Y', 'C') THEN
1115: arp_util.debug('Default_gl_date: ' || 'GL Date could not be defaulted ');
1116: END IF;
1117: -- Raise error message if failure in defaulting the gl_date
1118: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1119: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', l_error_message);
1121: p_return_status := FND_API.G_RET_STS_ERROR;
1122: END IF;
1123: END IF;
1124: IF PG_DEBUG in ('Y', 'C') THEN
1125: arp_util.debug('Default_gl_date ()-');
1126: END IF;
1127: END default_gl_date;
1128:
1129:
1138: l_set_of_books_id NUMBER := arp_global.set_of_books_id;
1139: l_functional_currency VARCHAR2(100) := arp_global.functional_currency;
1140: BEGIN
1141: IF PG_DEBUG in ('Y', 'C') THEN
1142: arp_util.debug('Find_Cached_Exchange_Rate ()+');
1143: END IF;
1144: IF (p_currency_code IS NOT NULL) AND
1145: (p_currency_code <> l_functional_currency) AND
1146: (p_exchange_rate_date IS NOT NULL) AND
1184: */
1185: END IF;
1186: RETURN( l_exchange_rate );
1187: IF PG_DEBUG in ('Y', 'C') THEN
1188: arp_util.debug('Find_Cached_Exchange_Rate ()-');
1189: END IF;
1190: EXCEPTION
1191: WHEN gl_currency_api.NO_RATE THEN
1192: --rate does not exist set appropriate message.
1192: --rate does not exist set appropriate message.
1193: --p_return_status := FND_API.G_RET_STS_ERROR ;
1194: return(null);
1195: IF PG_DEBUG in ('Y', 'C') THEN
1196: arp_util.debug('Find_Cached_Exchange_Rate: ' || 'Exception : gl_currency_api.NO_RATE ');
1197: END IF;
1198: WHEN gl_currency_api.INVALID_CURRENCY THEN
1199: -- invalid currency set appropriate message.
1200: --p_return_status := FND_API.G_RET_STS_ERROR ;
1199: -- invalid currency set appropriate message.
1200: --p_return_status := FND_API.G_RET_STS_ERROR ;
1201: return(null);
1202: IF PG_DEBUG in ('Y', 'C') THEN
1203: arp_util.debug('Find_Cached_Exchange_Rate: ' || 'Exception: gl_currency_api.INVALID_CURRENCY ');
1204: END IF;
1205: WHEN others THEN
1206: IF PG_DEBUG in ('Y', 'C') THEN
1207: arp_util.debug('EXCEPTION: Find_Cached_Exchange_Rate() ');
1203: arp_util.debug('Find_Cached_Exchange_Rate: ' || 'Exception: gl_currency_api.INVALID_CURRENCY ');
1204: END IF;
1205: WHEN others THEN
1206: IF PG_DEBUG in ('Y', 'C') THEN
1207: arp_util.debug('EXCEPTION: Find_Cached_Exchange_Rate() ');
1208: END IF;
1209: raise;
1210: END Find_Cached_Exchange_Rate;
1211:
1284: l_method_info_record Method_Info_Cache_Rec_Type;
1285:
1286: BEGIN
1287: IF PG_DEBUG in ('Y', 'C') THEN
1288: arp_util.debug('Default_Receipt_Method_Info ()+');
1289: END IF;
1290:
1291: p_return_status := FND_API.G_RET_STS_SUCCESS;
1292:
1347: END IF;
1348: END IF;
1349:
1350: IF PG_DEBUG in ('Y', 'C') THEN
1351: arp_util.debug('Default_Receipt_Method_Info ()-');
1352: END IF;
1353:
1354: EXCEPTION
1355: WHEN no_data_found THEN
1362: p_return_status := FND_API.G_RET_STS_ERROR;
1363: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REM_BK_AC_ID_NULL');
1364: FND_MSG_PUB.Add;
1365: IF PG_DEBUG in ('Y', 'C') THEN
1366: arp_util.debug('Default_Receipt_Method_Info: ' || 'The remittance bank account could not be defaulted ');
1367: END IF;
1368: WHEN others THEN
1369: IF PG_DEBUG in ('Y', 'C') THEN
1370: arp_util.debug('EXCEPTION: Default_Receipt_Method_info() ');
1366: arp_util.debug('Default_Receipt_Method_Info: ' || 'The remittance bank account could not be defaulted ');
1367: END IF;
1368: WHEN others THEN
1369: IF PG_DEBUG in ('Y', 'C') THEN
1370: arp_util.debug('EXCEPTION: Default_Receipt_Method_info() ');
1371: arp_util.debug('Default_Receipt_Method_Info: ' || 'p_receipt_method_id = '
1372: ||TO_CHAR(p_receipt_method_id));
1373: END IF;
1374: raise;
1367: END IF;
1368: WHEN others THEN
1369: IF PG_DEBUG in ('Y', 'C') THEN
1370: arp_util.debug('EXCEPTION: Default_Receipt_Method_info() ');
1371: arp_util.debug('Default_Receipt_Method_Info: ' || 'p_receipt_method_id = '
1372: ||TO_CHAR(p_receipt_method_id));
1373: END IF;
1374: raise;
1375:
1387: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
1388: l_validation_date date ;
1389: BEGIN
1390: IF PG_DEBUG in ('Y', 'C') THEN
1391: arp_util.debug('validate_cc_segments ()+');
1392: END IF;
1393: p_return_status := FND_API.G_RET_STS_SUCCESS;
1394: l_validation_date := p_gl_date;
1395: l_chart_of_accounts_id := arp_global.chart_of_accounts_id;
1393: p_return_status := FND_API.G_RET_STS_SUCCESS;
1394: l_validation_date := p_gl_date;
1395: l_chart_of_accounts_id := arp_global.chart_of_accounts_id;
1396: IF PG_DEBUG in ('Y', 'C') THEN
1397: arp_util.debug('l_chart_of_accounts_id = '||to_char(l_chart_of_accounts_id));
1398: END IF;
1399: l_concat_segs := fnd_flex_ext.get_segs('SQLGL','GL#',
1400: l_chart_of_accounts_id,
1401: p_code_combination_id);
1399: l_concat_segs := fnd_flex_ext.get_segs('SQLGL','GL#',
1400: l_chart_of_accounts_id,
1401: p_code_combination_id);
1402: IF PG_DEBUG in ('Y', 'C') THEN
1403: arp_util.debug('l_concat_segs = '||l_concat_segs);
1404: END IF;
1405: l_value := FND_FLEX_KEYVAL.validate_segs('CHECK_SEGMENTS','SQLGL','GL#',
1406: l_chart_of_accounts_id,
1407: l_concat_segs,
1407: l_concat_segs,
1408: 'V',l_validation_date);
1409: IF l_value THEN
1410: IF PG_DEBUG in ('Y', 'C') THEN
1411: arp_util.debug('Returning true');
1412: END IF;
1413: ELSE
1414: IF PG_DEBUG in ('Y', 'C') THEN
1415: arp_util.debug('Returning False');
1411: arp_util.debug('Returning true');
1412: END IF;
1413: ELSE
1414: IF PG_DEBUG in ('Y', 'C') THEN
1415: arp_util.debug('Returning False');
1416: END IF;
1417: END IF;
1418: IF (NOT l_value) THEN
1419: FND_MESSAGE.SET_NAME('AR',p_message);
1447: l_gl_date DATE;
1448: l_cc_val_ret_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
1449: BEGIN
1450: IF PG_DEBUG in ('Y', 'C') THEN
1451: arp_util.debug('Validate_Receipt_Method_ccid ()+');
1452: END IF;
1453: p_return_status := FND_API.G_RET_STS_SUCCESS;
1454: l_gl_date := p_gl_date;
1455: IF p_receipt_method_id IS NOT NULL
1647: l_cross_rate NUMBER;
1648: l_conversion_rate NUMBER;
1649: BEGIN
1650: IF PG_DEBUG in ('Y', 'C') THEN
1651: arp_util.debug('Default_Currency_info ()+');
1652: END IF;
1653: p_return_status := FND_API.G_RET_STS_SUCCESS;
1654:
1655: IF p_currency_code <> arp_global.functional_currency THEN
1734: END IF; --if echange rate type IS NOT NULL
1735: END IF; --entered_currency <> functional currency
1736:
1737: IF PG_DEBUG in ('Y', 'C') THEN
1738: arp_util.debug('Default_Currency_info ()+');
1739: END IF;
1740: EXCEPTION
1741: WHEN others THEN
1742: IF PG_DEBUG in ('Y', 'C') THEN
1739: END IF;
1740: EXCEPTION
1741: WHEN others THEN
1742: IF PG_DEBUG in ('Y', 'C') THEN
1743: arp_util.debug('EXCEPTION: Default_Currency_Info() ');
1744: arp_util.debug('Default_Currency_info: ' || 'p_currency_code = '||p_currency_code);
1745: END IF;
1746: raise;
1747: END Default_Currency_Info;
1740: EXCEPTION
1741: WHEN others THEN
1742: IF PG_DEBUG in ('Y', 'C') THEN
1743: arp_util.debug('EXCEPTION: Default_Currency_Info() ');
1744: arp_util.debug('Default_Currency_info: ' || 'p_currency_code = '||p_currency_code);
1745: END IF;
1746: raise;
1747: END Default_Currency_Info;
1748:
1781: l_get_x_val_return_status VARCHAR2(1);
1782: l_boe_flag VARCHAR2(1);
1783: BEGIN
1784: IF PG_DEBUG in ('Y', 'C') THEN
1785: arp_util.debug('Default_cash_ids_from_values ()+');
1786: END IF;
1787: p_return_status := FND_API.G_RET_STS_SUCCESS;
1788: -- Customer ID/Number/Name
1789: -- If 0 has been entered in as the customer ID, consider it null
1940:
1941: EXCEPTION
1942: WHEN no_data_found THEN
1943: IF PG_DEBUG in ('Y', 'C') THEN
1944: arp_util.debug('Default_cash_ids: ' || 'Invalid receipt method id');
1945: END IF;
1946: null;
1947: END;
1948:
2202: END IF;
2203:
2204:
2205: IF PG_DEBUG in ('Y', 'C') THEN
2206: arp_util.debug('Default_cash_ids_from_values ()-');
2207: END IF;
2208: EXCEPTION
2209: WHEN others THEN
2210: IF PG_DEBUG in ('Y', 'C') THEN
2207: END IF;
2208: EXCEPTION
2209: WHEN others THEN
2210: IF PG_DEBUG in ('Y', 'C') THEN
2211: arp_util.debug('EXCEPTION: Default_cash_ids_from_values() ',
2212: G_MSG_UERROR);
2213: END IF;
2214: raise;
2215:
2248: l_bank_acc_val_ret_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2249: BEGIN
2250:
2251: IF PG_DEBUG in ('Y', 'C') THEN
2252: arp_util.debug('Get_Cash_Defaults()+ ');
2253: END IF;
2254: p_return_status := FND_API.G_RET_STS_SUCCESS;
2255: -- default the receipt date if NULL
2256: IF (p_receipt_date IS NULL)
2266: p_gl_date,
2267: NULL,
2268: l_def_gl_dt_return_status);
2269: IF PG_DEBUG in ('Y', 'C') THEN
2270: arp_util.debug('Get_Cash_Defaults: ' || 'l_default_gl_date_return_status : '||l_def_gl_dt_return_status);
2271: END IF;
2272: END IF;
2273:
2274: IF (p_deposit_date IS NULL)
2290: );
2291:
2292: --Set the precision of the receipt amount as per currency
2293: IF p_amount is NOT NULL THEN
2294: p_amount := arp_util.CurrRound( p_amount,
2295: p_currency_code
2296: );
2297: END IF;
2298:
2324: l_bank_acc_val_ret_status <> FND_API.G_RET_STS_SUCCESS THEN /* Bug3315058 */
2325: p_return_status := FND_API.G_RET_STS_ERROR;
2326: END IF;
2327: IF PG_DEBUG in ('Y', 'C') THEN
2328: arp_util.debug('Get_Cash_Defaults: ' || '************Cash Defaults********************');
2329: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_date : '||to_char(p_receipt_date,'DD-MON-YYYY'));
2330: arp_util.debug('Get_Cash_Defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2331: arp_util.debug('Get_Cash_Defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
2332: arp_util.debug('Get_Cash_Defaults: ' || 'p_maturity_date : '||to_char(p_maturity_date,'DD-MON-YYYY'));
2325: p_return_status := FND_API.G_RET_STS_ERROR;
2326: END IF;
2327: IF PG_DEBUG in ('Y', 'C') THEN
2328: arp_util.debug('Get_Cash_Defaults: ' || '************Cash Defaults********************');
2329: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_date : '||to_char(p_receipt_date,'DD-MON-YYYY'));
2330: arp_util.debug('Get_Cash_Defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2331: arp_util.debug('Get_Cash_Defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
2332: arp_util.debug('Get_Cash_Defaults: ' || 'p_maturity_date : '||to_char(p_maturity_date,'DD-MON-YYYY'));
2333: arp_util.debug('Get_Cash_Defaults: ' || 'p_currency_code : '||p_currency_code);
2326: END IF;
2327: IF PG_DEBUG in ('Y', 'C') THEN
2328: arp_util.debug('Get_Cash_Defaults: ' || '************Cash Defaults********************');
2329: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_date : '||to_char(p_receipt_date,'DD-MON-YYYY'));
2330: arp_util.debug('Get_Cash_Defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2331: arp_util.debug('Get_Cash_Defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
2332: arp_util.debug('Get_Cash_Defaults: ' || 'p_maturity_date : '||to_char(p_maturity_date,'DD-MON-YYYY'));
2333: arp_util.debug('Get_Cash_Defaults: ' || 'p_currency_code : '||p_currency_code);
2334: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2327: IF PG_DEBUG in ('Y', 'C') THEN
2328: arp_util.debug('Get_Cash_Defaults: ' || '************Cash Defaults********************');
2329: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_date : '||to_char(p_receipt_date,'DD-MON-YYYY'));
2330: arp_util.debug('Get_Cash_Defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2331: arp_util.debug('Get_Cash_Defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
2332: arp_util.debug('Get_Cash_Defaults: ' || 'p_maturity_date : '||to_char(p_maturity_date,'DD-MON-YYYY'));
2333: arp_util.debug('Get_Cash_Defaults: ' || 'p_currency_code : '||p_currency_code);
2334: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2335: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
2328: arp_util.debug('Get_Cash_Defaults: ' || '************Cash Defaults********************');
2329: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_date : '||to_char(p_receipt_date,'DD-MON-YYYY'));
2330: arp_util.debug('Get_Cash_Defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2331: arp_util.debug('Get_Cash_Defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
2332: arp_util.debug('Get_Cash_Defaults: ' || 'p_maturity_date : '||to_char(p_maturity_date,'DD-MON-YYYY'));
2333: arp_util.debug('Get_Cash_Defaults: ' || 'p_currency_code : '||p_currency_code);
2334: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2335: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
2336: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
2329: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_date : '||to_char(p_receipt_date,'DD-MON-YYYY'));
2330: arp_util.debug('Get_Cash_Defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2331: arp_util.debug('Get_Cash_Defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
2332: arp_util.debug('Get_Cash_Defaults: ' || 'p_maturity_date : '||to_char(p_maturity_date,'DD-MON-YYYY'));
2333: arp_util.debug('Get_Cash_Defaults: ' || 'p_currency_code : '||p_currency_code);
2334: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2335: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
2336: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
2337: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
2330: arp_util.debug('Get_Cash_Defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
2331: arp_util.debug('Get_Cash_Defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
2332: arp_util.debug('Get_Cash_Defaults: ' || 'p_maturity_date : '||to_char(p_maturity_date,'DD-MON-YYYY'));
2333: arp_util.debug('Get_Cash_Defaults: ' || 'p_currency_code : '||p_currency_code);
2334: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2335: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
2336: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
2337: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
2338: arp_util.debug('Get_Cash_Defaults: ' || 'remit bank acct use id : '||to_char(p_remittance_bank_account_id));
2331: arp_util.debug('Get_Cash_Defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
2332: arp_util.debug('Get_Cash_Defaults: ' || 'p_maturity_date : '||to_char(p_maturity_date,'DD-MON-YYYY'));
2333: arp_util.debug('Get_Cash_Defaults: ' || 'p_currency_code : '||p_currency_code);
2334: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2335: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
2336: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
2337: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
2338: arp_util.debug('Get_Cash_Defaults: ' || 'remit bank acct use id : '||to_char(p_remittance_bank_account_id));
2339: arp_util.debug('Get_Cash_Defaults: ' || 'p_state : '||p_state);
2332: arp_util.debug('Get_Cash_Defaults: ' || 'p_maturity_date : '||to_char(p_maturity_date,'DD-MON-YYYY'));
2333: arp_util.debug('Get_Cash_Defaults: ' || 'p_currency_code : '||p_currency_code);
2334: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2335: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
2336: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
2337: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
2338: arp_util.debug('Get_Cash_Defaults: ' || 'remit bank acct use id : '||to_char(p_remittance_bank_account_id));
2339: arp_util.debug('Get_Cash_Defaults: ' || 'p_state : '||p_state);
2340: arp_util.debug('Get_Cash_Defaults ()-');
2333: arp_util.debug('Get_Cash_Defaults: ' || 'p_currency_code : '||p_currency_code);
2334: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2335: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
2336: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
2337: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
2338: arp_util.debug('Get_Cash_Defaults: ' || 'remit bank acct use id : '||to_char(p_remittance_bank_account_id));
2339: arp_util.debug('Get_Cash_Defaults: ' || 'p_state : '||p_state);
2340: arp_util.debug('Get_Cash_Defaults ()-');
2341: END IF;
2334: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_rate_date,'DD-MON-YYYY'));
2335: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
2336: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
2337: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
2338: arp_util.debug('Get_Cash_Defaults: ' || 'remit bank acct use id : '||to_char(p_remittance_bank_account_id));
2339: arp_util.debug('Get_Cash_Defaults: ' || 'p_state : '||p_state);
2340: arp_util.debug('Get_Cash_Defaults ()-');
2341: END IF;
2342: END Get_Cash_Defaults;
2335: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
2336: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
2337: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
2338: arp_util.debug('Get_Cash_Defaults: ' || 'remit bank acct use id : '||to_char(p_remittance_bank_account_id));
2339: arp_util.debug('Get_Cash_Defaults: ' || 'p_state : '||p_state);
2340: arp_util.debug('Get_Cash_Defaults ()-');
2341: END IF;
2342: END Get_Cash_Defaults;
2343:
2336: arp_util.debug('Get_Cash_Defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
2337: arp_util.debug('Get_Cash_Defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
2338: arp_util.debug('Get_Cash_Defaults: ' || 'remit bank acct use id : '||to_char(p_remittance_bank_account_id));
2339: arp_util.debug('Get_Cash_Defaults: ' || 'p_state : '||p_state);
2340: arp_util.debug('Get_Cash_Defaults ()-');
2341: END IF;
2342: END Get_Cash_Defaults;
2343:
2344: FUNCTION Get_grace_days(
2372:
2373: EXCEPTION
2374: WHEN OTHERS THEN
2375: IF PG_DEBUG in ('Y', 'C') THEN
2376: arp_util.debug('EXCEPTION: Get_grace_days()');
2377: END IF;
2378: raise;
2379: END Get_grace_days;
2380:
2392: l_amount_applied NUMBER;
2393: l_amount_applied_from NUMBER;
2394: BEGIN
2395: IF PG_DEBUG in ('Y', 'C') THEN
2396: arp_util.debug('Default_trans_to_receipt_rate ()+');
2397: END IF;
2398:
2399: p_return_status := FND_API.G_RET_STS_SUCCESS;
2400: --if the trx currency and the receipt currency are not same
2435: --rate does not exist set appropriate message.
2436: --p_return_status := FND_API.G_RET_STS_ERROR ;
2437: l_temp_rate := NULL;
2438: IF PG_DEBUG in ('Y', 'C') THEN
2439: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception : gl_currency_api.NO_RATE ');
2440: END IF;
2441: WHEN gl_currency_api.INVALID_CURRENCY THEN
2442: -- invalid currency set appropriate message.
2443: --p_return_status := FND_API.G_RET_STS_ERROR ;
2442: -- invalid currency set appropriate message.
2443: --p_return_status := FND_API.G_RET_STS_ERROR ;
2444: l_temp_rate := NULL;
2445: IF PG_DEBUG in ('Y', 'C') THEN
2446: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception: gl_currency_api.INVALID_CURRENCY ');
2447: END IF;
2448: END;
2449: END IF ;
2450:
2467: --rate does not exist set appropriate message.
2468: --p_return_status := FND_API.G_RET_STS_ERROR ;
2469: l_temp_rate := NULL;
2470: IF PG_DEBUG in ('Y', 'C') THEN
2471: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception : gl_currency_api.NO_RATE ');
2472: END IF;
2473: WHEN gl_currency_api.INVALID_CURRENCY THEN
2474: -- invalid currency set appropriate message.
2475: --p_return_status := FND_API.G_RET_STS_ERROR ;
2474: -- invalid currency set appropriate message.
2475: --p_return_status := FND_API.G_RET_STS_ERROR ;
2476: l_temp_rate := NULL;
2477: IF PG_DEBUG in ('Y', 'C') THEN
2478: arp_util.debug('Default_trans_to_receipt_rate: ' || 'Exception: gl_currency_api.INVALID_CURRENCY ');
2479: END IF;
2480: END;
2481:
2482: IF p_trans_to_receipt_rate IS NOT NULL THEN
2509:
2510: IF p_amount_applied_from IS NOT NULL AND
2511: p_amount_applied IS NOT NULL
2512: THEN
2513: l_amount_applied_from := arp_util.CurrRound(
2514: p_amount_applied_from,
2515: p_cr_currency_code
2516: );
2517: /* Bugfix 2916389. Use p_trx_currency_code instead of
2515: p_cr_currency_code
2516: );
2517: /* Bugfix 2916389. Use p_trx_currency_code instead of
2518: p_cr_currency_code. */
2519: l_amount_applied := arp_util.CurrRound(
2520: p_amount_applied,
2521: p_trx_currency_code
2522: );
2523: p_trans_to_receipt_rate := ROUND(l_amount_applied_from/l_amount_applied, 38);
2526: END IF;
2527:
2528: END IF;
2529: IF PG_DEBUG in ('Y', 'C') THEN
2530: arp_util.debug('Default_trans_to_receipt_rate: ' || 'p_trans_to_receipt_rate :'||to_char(p_trans_to_receipt_rate));
2531: arp_util.debug('Default_trans_to_receipt_rate ()-');
2532: END IF;
2533: EXCEPTION
2534: WHEN others THEN
2527:
2528: END IF;
2529: IF PG_DEBUG in ('Y', 'C') THEN
2530: arp_util.debug('Default_trans_to_receipt_rate: ' || 'p_trans_to_receipt_rate :'||to_char(p_trans_to_receipt_rate));
2531: arp_util.debug('Default_trans_to_receipt_rate ()-');
2532: END IF;
2533: EXCEPTION
2534: WHEN others THEN
2535: IF PG_DEBUG in ('Y', 'C') THEN
2532: END IF;
2533: EXCEPTION
2534: WHEN others THEN
2535: IF PG_DEBUG in ('Y', 'C') THEN
2536: arp_util.debug('EXCEPTION: Default_trans_to_receipt_rate()');
2537: END IF;
2538: raise;
2539: END Default_trans_to_receipt_rate;
2540:
2548: ) IS
2549:
2550: BEGIN
2551: IF PG_DEBUG in ('Y', 'C') THEN
2552: arp_util.debug('Default_amount_applied_from ()+');
2553: END IF;
2554: p_return_status := FND_API.G_RET_STS_SUCCESS;
2555: IF p_amount_applied_from IS NULL THEN
2556: IF p_trx_currency_code <> p_cr_currency_code THEN
2559: IF p_trans_to_receipt_rate IS NOT NULL AND
2560: p_amount_applied IS NOT NULL
2561: THEN
2562:
2563: p_amount_applied_from := arp_util.CurrRound(
2564: p_amount_applied * p_trans_to_receipt_rate,
2565: p_cr_currency_code
2566: );
2567: END IF;
2569: END IF;
2570:
2571: ELSE
2572: --if user has entered the amount_applied_from then round it.
2573: p_amount_applied_from := arp_util.CurrRound(
2574: p_amount_applied_from,
2575: p_cr_currency_code
2576: );
2577: END IF;
2575: p_cr_currency_code
2576: );
2577: END IF;
2578: IF PG_DEBUG in ('Y', 'C') THEN
2579: arp_util.debug('Default_amount_applied_from ()+');
2580: END IF;
2581:
2582: EXCEPTION
2583: WHEN others THEN
2581:
2582: EXCEPTION
2583: WHEN others THEN
2584: IF PG_DEBUG in ('Y', 'C') THEN
2585: arp_util.debug('Default_amount_applied_from: ' || 'EXCEPTION: Default_applied_amount_from()');
2586: END IF;
2587: raise;
2588:
2589: END Default_amount_applied_from;
2637: l_trans_to_receipt_rate NUMBER;
2638:
2639: BEGIN
2640: IF PG_DEBUG in ('Y', 'C') THEN
2641: arp_util.debug('Default_val_llca_parameters()+');
2642: END IF;
2643: p_return_status := FND_API.G_RET_STS_SUCCESS;
2644:
2645:
2650: p_msg_data,
2651: p_msg_count);
2652:
2653: IF PG_DEBUG in ('Y', 'C') THEN
2654: arp_util.debug('Default_val_llca_parameters: Initialization Return Status : '||p_return_status);
2655: END IF;
2656:
2657: IF p_return_status <> FND_API.G_RET_STS_SUCCESS
2658: THEN
2661: FND_MSG_PUB.Add;
2662: p_return_status := FND_API.G_RET_STS_ERROR ;
2663:
2664: IF PG_DEBUG in ('Y', 'C') THEN
2665: arp_util.debug('Apply_In_Detail: ' || 'Error(s) occurred in arp_process_det_pkg.Initialization ');
2666: END IF;
2667: Return;
2668: END IF;
2669:
2669:
2670: IF p_llca_type = 'S'
2671: THEN
2672: IF PG_DEBUG in ('Y', 'C') THEN
2673: arp_util.debug('Default_val_llca_parameters: Summary Level Application ');
2674: END IF;
2675: IF p_line_amount IS NULL AND p_tax_amount IS NULL
2676: AND p_freight_amount IS NULL AND p_charges_amount is NULL
2677: THEN
2693: FND_MSG_PUB.Add;
2694: END IF;
2695:
2696: IF PG_DEBUG in ('Y', 'C') THEN
2697: arp_util.debug('Default_application_info: ' ||
2698: 'Amount applied has been defaulted to the sum of
2699: line/tax/freight/charges amount ');
2700: END IF;
2701: END IF;
2703:
2704: Elsif P_llca_type = 'L'
2705: Then
2706: IF PG_DEBUG in ('Y', 'C') THEN
2707: arp_util.debug('Default_val_llca_parameters: Line Level Application ');
2708: END IF;
2709: IF ( Nvl(p_line_amount,0) <> 0
2710: and Nvl(p_tax_amount,0) <> 0
2711: and nvl(p_charges_amount,0) <> 0
2720: FND_MSG_PUB.Add;
2721: END IF;
2722:
2723: IF PG_DEBUG in ('Y', 'C') THEN
2724: arp_util.debug('Default_val_llca_parameters: ' || 'Line, Tax,
2725: , Charges amount has been defaulted to Null');
2726: END IF;
2727: END IF;
2728:
2744: FND_MSG_PUB.Add;
2745: END IF;
2746:
2747: IF PG_DEBUG in ('Y', 'C') THEN
2748: arp_util.debug('Default_val_llca_parameters: ' || 'Amount applied
2749: amount has been defaulted to Null');
2750: END IF;
2751: END IF;
2752: Else
2751: END IF;
2752: Else
2753: -- Specified Lines
2754: IF PG_DEBUG in ('Y', 'C') THEN
2755: arp_util.debug('Specified one or more lines in PLSQL table... ');
2756: END IF;
2757:
2758: -- Calculate the line level amounts
2759: For sp_lines_row in gt_lines_cur(p_customer_trx_id)
2802: and line.customer_trx_line_id = tax.link_to_cust_trx_line_id (+);
2803: EXCEPTION
2804: WHEN NO_DATA_FOUND THEN
2805: IF PG_DEBUG in ('Y', 'C') THEN
2806: arp_util.debug('' || 'EXCEPTION: Default_val_llca_parameters()');
2807: END IF;
2808: p_return_status := FND_API.G_RET_STS_ERROR ;
2809: FND_MESSAGE.SET_NAME( 'AR','AR_RAPI_TRX_LINE_ID_INVALID');
2810: FND_MSG_PUB.ADD;
2810: FND_MSG_PUB.ADD;
2811: RAISE;
2812: WHEN others THEN
2813: IF PG_DEBUG in ('Y', 'C') THEN
2814: arp_util.debug('' || 'EXCEPTION: Default_val_llca_parameters()');
2815: END IF;
2816: RAISE;
2817: END;
2818: IF PG_DEBUG in ('Y', 'C') THEN
2815: END IF;
2816: RAISE;
2817: END;
2818: IF PG_DEBUG in ('Y', 'C') THEN
2819: arp_util.debug('Customer_trx_line_id =>'||to_char(sp_lines_row.customer_trx_line_id));
2820: END IF;
2821: Select decode ( ( Nvl(l_line_amount_remaining,0)
2822: / ( Nvl(l_line_amount_remaining,0)
2823: + Nvl(l_line_tax_remaining,0)
2846: sp_lines_row.amount_applied_from,
2847: p_cr_date,
2848: l_def_rate_return_status
2849: );
2850: sp_lines_row.amount_applied := arp_util.CurrRound(
2851: sp_lines_row.amount_applied_from / l_trans_to_receipt_rate,
2852: p_invoice_currency_code);
2853: sp_lines_row.tax_amount := NULL;
2854: sp_lines_row.line_amount := NULL;
2854: sp_lines_row.line_amount := NULL;
2855:
2856:
2857: IF PG_DEBUG in ('Y', 'C') THEN
2858: arp_util.debug('Default_val_llca_parameters: ' || 'Default trans_to_receipt_rate status: '||l_def_rate_return_status);
2859: arp_util.debug('Default_val_llca_parameters: ' || 'l_trans_to_receipt_rate: '||l_trans_to_receipt_rate);
2860: arp_util.debug('Default_val_llca_parameters: ' || 'sp_lines_row.amount_applied: '||sp_lines_row.amount_applied);
2861: END IF;
2862:
2855:
2856:
2857: IF PG_DEBUG in ('Y', 'C') THEN
2858: arp_util.debug('Default_val_llca_parameters: ' || 'Default trans_to_receipt_rate status: '||l_def_rate_return_status);
2859: arp_util.debug('Default_val_llca_parameters: ' || 'l_trans_to_receipt_rate: '||l_trans_to_receipt_rate);
2860: arp_util.debug('Default_val_llca_parameters: ' || 'sp_lines_row.amount_applied: '||sp_lines_row.amount_applied);
2861: END IF;
2862:
2863: END IF;
2856:
2857: IF PG_DEBUG in ('Y', 'C') THEN
2858: arp_util.debug('Default_val_llca_parameters: ' || 'Default trans_to_receipt_rate status: '||l_def_rate_return_status);
2859: arp_util.debug('Default_val_llca_parameters: ' || 'l_trans_to_receipt_rate: '||l_trans_to_receipt_rate);
2860: arp_util.debug('Default_val_llca_parameters: ' || 'sp_lines_row.amount_applied: '||sp_lines_row.amount_applied);
2861: END IF;
2862:
2863: END IF;
2864: END IF;
2869: -- First Priority Line Amount
2870: If Nvl(sp_lines_row.line_amount,0) <> 0
2871: Then
2872: IF PG_DEBUG in ('Y', 'C') THEN
2873: arp_util.debug('First priority : Line Amount ');
2874: arp_util.debug('Line Amount has taken precedence over the amount applied ');
2875: END IF;
2876: l_calc_tot_amount_app := arp_util.CurrRound(
2877: ( nvl(sp_lines_row.line_amount,0)
2870: If Nvl(sp_lines_row.line_amount,0) <> 0
2871: Then
2872: IF PG_DEBUG in ('Y', 'C') THEN
2873: arp_util.debug('First priority : Line Amount ');
2874: arp_util.debug('Line Amount has taken precedence over the amount applied ');
2875: END IF;
2876: l_calc_tot_amount_app := arp_util.CurrRound(
2877: ( nvl(sp_lines_row.line_amount,0)
2878: / nvl(l_calc_line_per,1)
2872: IF PG_DEBUG in ('Y', 'C') THEN
2873: arp_util.debug('First priority : Line Amount ');
2874: arp_util.debug('Line Amount has taken precedence over the amount applied ');
2875: END IF;
2876: l_calc_tot_amount_app := arp_util.CurrRound(
2877: ( nvl(sp_lines_row.line_amount,0)
2878: / nvl(l_calc_line_per,1)
2879: )
2880: ,p_invoice_currency_code);
2877: ( nvl(sp_lines_row.line_amount,0)
2878: / nvl(l_calc_line_per,1)
2879: )
2880: ,p_invoice_currency_code);
2881: l_calc_line_amount := arp_util.CurrRound(sp_lines_row.line_amount
2882: ,p_invoice_currency_code);
2883:
2884: -- Calculate Line amount based on the Amount Applied.
2885: Elsif Nvl(sp_lines_row.amount_applied,0) <> 0
2884: -- Calculate Line amount based on the Amount Applied.
2885: Elsif Nvl(sp_lines_row.amount_applied,0) <> 0
2886: Then
2887: IF PG_DEBUG in ('Y', 'C') THEN
2888: arp_util.debug('Considered the Amount Applied value ');
2889: End If;
2890:
2891: l_calc_tot_amount_app := arp_util.CurrRound(sp_lines_row.amount_applied
2892: ,p_invoice_currency_code);
2887: IF PG_DEBUG in ('Y', 'C') THEN
2888: arp_util.debug('Considered the Amount Applied value ');
2889: End If;
2890:
2891: l_calc_tot_amount_app := arp_util.CurrRound(sp_lines_row.amount_applied
2892: ,p_invoice_currency_code);
2893: l_calc_line_amount := arp_util.CurrRound((l_calc_tot_amount_app
2894: * l_calc_line_per),p_invoice_currency_code);
2895: End If;
2889: End If;
2890:
2891: l_calc_tot_amount_app := arp_util.CurrRound(sp_lines_row.amount_applied
2892: ,p_invoice_currency_code);
2893: l_calc_line_amount := arp_util.CurrRound((l_calc_tot_amount_app
2894: * l_calc_line_per),p_invoice_currency_code);
2895: End If;
2896:
2897: IF PG_DEBUG in ('Y', 'C') THEN
2894: * l_calc_line_per),p_invoice_currency_code);
2895: End If;
2896:
2897: IF PG_DEBUG in ('Y', 'C') THEN
2898: arp_util.debug('l_calc_tot_amount_app -> '||to_char(l_calc_tot_amount_app));
2899: arp_util.debug('l_calc_line_amount -> '||to_char(l_calc_line_amount));
2900: END IF;
2901:
2902:
2895: End If;
2896:
2897: IF PG_DEBUG in ('Y', 'C') THEN
2898: arp_util.debug('l_calc_tot_amount_app -> '||to_char(l_calc_tot_amount_app));
2899: arp_util.debug('l_calc_line_amount -> '||to_char(l_calc_line_amount));
2900: END IF;
2901:
2902:
2903: -- Tax amount has taken precedence over the Line / amount applied
2903: -- Tax amount has taken precedence over the Line / amount applied
2904: If NVL(sp_lines_row.tax_amount,0) <> 0
2905: THEN
2906: IF PG_DEBUG in ('Y', 'C') THEN
2907: arp_util.debug('Tax Amount has taken precedence over the amount applied ');
2908: End If;
2909: l_calc_tax_amount := arp_util.CurrRound(sp_lines_row.tax_amount
2910: ,p_invoice_currency_code);
2911:
2905: THEN
2906: IF PG_DEBUG in ('Y', 'C') THEN
2907: arp_util.debug('Tax Amount has taken precedence over the amount applied ');
2908: End If;
2909: l_calc_tax_amount := arp_util.CurrRound(sp_lines_row.tax_amount
2910: ,p_invoice_currency_code);
2911:
2912: l_calc_tot_amount_app := l_calc_line_amount +
2913: l_calc_tax_amount;
2912: l_calc_tot_amount_app := l_calc_line_amount +
2913: l_calc_tax_amount;
2914: Else
2915: IF PG_DEBUG in ('Y', 'C') THEN
2916: arp_util.debug('Amount Applied has taken precedence over the Tax Amount');
2917: End If;
2918: -- Amount applied has taken precedence over the tax amount
2919: l_calc_tax_amount := arp_util.CurrRound((Nvl(l_calc_tot_amount_app,0)
2920: - Nvl(l_calc_line_amount,0))
2915: IF PG_DEBUG in ('Y', 'C') THEN
2916: arp_util.debug('Amount Applied has taken precedence over the Tax Amount');
2917: End If;
2918: -- Amount applied has taken precedence over the tax amount
2919: l_calc_tax_amount := arp_util.CurrRound((Nvl(l_calc_tot_amount_app,0)
2920: - Nvl(l_calc_line_amount,0))
2921: ,p_invoice_currency_code);
2922: End If;
2923:
2932: END If;
2933:
2934:
2935: IF PG_DEBUG in ('Y', 'C') THEN
2936: arp_util.debug('l_calc_tot_amount_app -> '||to_char(l_calc_tot_amount_app));
2937: arp_util.debug('l_calc_line_amount -> '||to_char(l_calc_line_amount));
2938: arp_util.debug('l_calc_tax_amount -> '||to_char(l_calc_tax_amount));
2939: END IF;
2940:
2933:
2934:
2935: IF PG_DEBUG in ('Y', 'C') THEN
2936: arp_util.debug('l_calc_tot_amount_app -> '||to_char(l_calc_tot_amount_app));
2937: arp_util.debug('l_calc_line_amount -> '||to_char(l_calc_line_amount));
2938: arp_util.debug('l_calc_tax_amount -> '||to_char(l_calc_tax_amount));
2939: END IF;
2940:
2941: -- Update the GT table with calculated values
2934:
2935: IF PG_DEBUG in ('Y', 'C') THEN
2936: arp_util.debug('l_calc_tot_amount_app -> '||to_char(l_calc_tot_amount_app));
2937: arp_util.debug('l_calc_line_amount -> '||to_char(l_calc_line_amount));
2938: arp_util.debug('l_calc_tax_amount -> '||to_char(l_calc_tax_amount));
2939: END IF;
2940:
2941: -- Update the GT table with calculated values
2942:
2954: l_cum_line_discount := Nvl(l_cum_line_discount,0) + Nvl(sp_lines_row.line_discount,0);
2955: l_cum_tax_discount := Nvl(l_cum_tax_discount,0) + Nvl(sp_lines_row.tax_discount,0);
2956:
2957: IF PG_DEBUG in ('Y', 'C') THEN
2958: arp_util.debug('l_cum_tot_amount_app -> '||to_char(l_cum_amount_app));
2959: arp_util.debug('l_cum_line_amount -> '||to_char(l_cum_line_amount));
2960: arp_util.debug('l_cum_tax_amount -> '||to_char(l_cum_tax_amount));
2961: arp_util.debug('l_cum_line_discount -> '||to_char(l_cum_line_discount));
2962: arp_util.debug('l_cum_tax_discount -> '||to_char(l_cum_tax_discount));
2955: l_cum_tax_discount := Nvl(l_cum_tax_discount,0) + Nvl(sp_lines_row.tax_discount,0);
2956:
2957: IF PG_DEBUG in ('Y', 'C') THEN
2958: arp_util.debug('l_cum_tot_amount_app -> '||to_char(l_cum_amount_app));
2959: arp_util.debug('l_cum_line_amount -> '||to_char(l_cum_line_amount));
2960: arp_util.debug('l_cum_tax_amount -> '||to_char(l_cum_tax_amount));
2961: arp_util.debug('l_cum_line_discount -> '||to_char(l_cum_line_discount));
2962: arp_util.debug('l_cum_tax_discount -> '||to_char(l_cum_tax_discount));
2963: END IF;
2956:
2957: IF PG_DEBUG in ('Y', 'C') THEN
2958: arp_util.debug('l_cum_tot_amount_app -> '||to_char(l_cum_amount_app));
2959: arp_util.debug('l_cum_line_amount -> '||to_char(l_cum_line_amount));
2960: arp_util.debug('l_cum_tax_amount -> '||to_char(l_cum_tax_amount));
2961: arp_util.debug('l_cum_line_discount -> '||to_char(l_cum_line_discount));
2962: arp_util.debug('l_cum_tax_discount -> '||to_char(l_cum_tax_discount));
2963: END IF;
2964: End Loop;
2957: IF PG_DEBUG in ('Y', 'C') THEN
2958: arp_util.debug('l_cum_tot_amount_app -> '||to_char(l_cum_amount_app));
2959: arp_util.debug('l_cum_line_amount -> '||to_char(l_cum_line_amount));
2960: arp_util.debug('l_cum_tax_amount -> '||to_char(l_cum_tax_amount));
2961: arp_util.debug('l_cum_line_discount -> '||to_char(l_cum_line_discount));
2962: arp_util.debug('l_cum_tax_discount -> '||to_char(l_cum_tax_discount));
2963: END IF;
2964: End Loop;
2965: p_amount_applied := nvl(l_cum_amount_app,0) + nvl(p_freight_amount,0);
2958: arp_util.debug('l_cum_tot_amount_app -> '||to_char(l_cum_amount_app));
2959: arp_util.debug('l_cum_line_amount -> '||to_char(l_cum_line_amount));
2960: arp_util.debug('l_cum_tax_amount -> '||to_char(l_cum_tax_amount));
2961: arp_util.debug('l_cum_line_discount -> '||to_char(l_cum_line_discount));
2962: arp_util.debug('l_cum_tax_discount -> '||to_char(l_cum_tax_discount));
2963: END IF;
2964: End Loop;
2965: p_amount_applied := nvl(l_cum_amount_app,0) + nvl(p_freight_amount,0);
2966: p_line_amount := nvl(l_cum_line_amount,0);
2969: p_tax_discount := nvl(l_cum_tax_discount,0);
2970: p_discount := nvl(p_line_discount,0) + nvl(p_tax_discount,0)
2971: + nvl(p_freight_discount,0);
2972: IF PG_DEBUG in ('Y', 'C') THEN
2973: arp_util.debug('p_amount_applied => '||to_char(p_amount_applied) );
2974: arp_util.debug('p_line_amount => '||to_char(l_cum_line_amount));
2975: arp_util.debug('p_tax_amount => '||to_char(l_cum_tax_amount));
2976: arp_util.debug('p_freight_amount => '||to_char(p_freight_amount));
2977: arp_util.debug('p_line_discount => '||to_char(p_line_discount));
2970: p_discount := nvl(p_line_discount,0) + nvl(p_tax_discount,0)
2971: + nvl(p_freight_discount,0);
2972: IF PG_DEBUG in ('Y', 'C') THEN
2973: arp_util.debug('p_amount_applied => '||to_char(p_amount_applied) );
2974: arp_util.debug('p_line_amount => '||to_char(l_cum_line_amount));
2975: arp_util.debug('p_tax_amount => '||to_char(l_cum_tax_amount));
2976: arp_util.debug('p_freight_amount => '||to_char(p_freight_amount));
2977: arp_util.debug('p_line_discount => '||to_char(p_line_discount));
2978: arp_util.debug('p_tax_discount => '||to_char(p_tax_discount));
2971: + nvl(p_freight_discount,0);
2972: IF PG_DEBUG in ('Y', 'C') THEN
2973: arp_util.debug('p_amount_applied => '||to_char(p_amount_applied) );
2974: arp_util.debug('p_line_amount => '||to_char(l_cum_line_amount));
2975: arp_util.debug('p_tax_amount => '||to_char(l_cum_tax_amount));
2976: arp_util.debug('p_freight_amount => '||to_char(p_freight_amount));
2977: arp_util.debug('p_line_discount => '||to_char(p_line_discount));
2978: arp_util.debug('p_tax_discount => '||to_char(p_tax_discount));
2979: arp_util.debug('p_freight_discount => '||to_char(p_freight_discount));
2972: IF PG_DEBUG in ('Y', 'C') THEN
2973: arp_util.debug('p_amount_applied => '||to_char(p_amount_applied) );
2974: arp_util.debug('p_line_amount => '||to_char(l_cum_line_amount));
2975: arp_util.debug('p_tax_amount => '||to_char(l_cum_tax_amount));
2976: arp_util.debug('p_freight_amount => '||to_char(p_freight_amount));
2977: arp_util.debug('p_line_discount => '||to_char(p_line_discount));
2978: arp_util.debug('p_tax_discount => '||to_char(p_tax_discount));
2979: arp_util.debug('p_freight_discount => '||to_char(p_freight_discount));
2980: arp_util.debug('p_discount (Total) => '||to_char(p_discount));
2973: arp_util.debug('p_amount_applied => '||to_char(p_amount_applied) );
2974: arp_util.debug('p_line_amount => '||to_char(l_cum_line_amount));
2975: arp_util.debug('p_tax_amount => '||to_char(l_cum_tax_amount));
2976: arp_util.debug('p_freight_amount => '||to_char(p_freight_amount));
2977: arp_util.debug('p_line_discount => '||to_char(p_line_discount));
2978: arp_util.debug('p_tax_discount => '||to_char(p_tax_discount));
2979: arp_util.debug('p_freight_discount => '||to_char(p_freight_discount));
2980: arp_util.debug('p_discount (Total) => '||to_char(p_discount));
2981: END IF;
2974: arp_util.debug('p_line_amount => '||to_char(l_cum_line_amount));
2975: arp_util.debug('p_tax_amount => '||to_char(l_cum_tax_amount));
2976: arp_util.debug('p_freight_amount => '||to_char(p_freight_amount));
2977: arp_util.debug('p_line_discount => '||to_char(p_line_discount));
2978: arp_util.debug('p_tax_discount => '||to_char(p_tax_discount));
2979: arp_util.debug('p_freight_discount => '||to_char(p_freight_discount));
2980: arp_util.debug('p_discount (Total) => '||to_char(p_discount));
2981: END IF;
2982:
2975: arp_util.debug('p_tax_amount => '||to_char(l_cum_tax_amount));
2976: arp_util.debug('p_freight_amount => '||to_char(p_freight_amount));
2977: arp_util.debug('p_line_discount => '||to_char(p_line_discount));
2978: arp_util.debug('p_tax_discount => '||to_char(p_tax_discount));
2979: arp_util.debug('p_freight_discount => '||to_char(p_freight_discount));
2980: arp_util.debug('p_discount (Total) => '||to_char(p_discount));
2981: END IF;
2982:
2983: END IF; /* GT COUNT END IF */
2976: arp_util.debug('p_freight_amount => '||to_char(p_freight_amount));
2977: arp_util.debug('p_line_discount => '||to_char(p_line_discount));
2978: arp_util.debug('p_tax_discount => '||to_char(p_tax_discount));
2979: arp_util.debug('p_freight_discount => '||to_char(p_freight_discount));
2980: arp_util.debug('p_discount (Total) => '||to_char(p_discount));
2981: END IF;
2982:
2983: END IF; /* GT COUNT END IF */
2984: END IF; /* P_llca_type ENDIF */
2984: END IF; /* P_llca_type ENDIF */
2985:
2986:
2987: IF PG_DEBUG in ('Y', 'C') THEN
2988: arp_util.debug('Default_val_llca_parameters()-');
2989: END IF;
2990: EXCEPTION
2991: WHEN others THEN
2992: IF PG_DEBUG in ('Y', 'C') THEN
2989: END IF;
2990: EXCEPTION
2991: WHEN others THEN
2992: IF PG_DEBUG in ('Y', 'C') THEN
2993: arp_util.debug('EXCEPTION: Default_val_llca_parameters: ()');
2994: END IF;
2995: raise;
2996: END;
2997:
3051: l_allow_discount VARCHAR2(1) DEFAULT 'Y'; /* Bug fix 3450317 */
3052:
3053: BEGIN
3054: IF PG_DEBUG in ('Y', 'C') THEN
3055: arp_util.debug('Default_disc_and_amt_applied ()+');
3056: END IF;
3057: p_return_status := FND_API.G_RET_STS_SUCCESS;
3058: IF PG_DEBUG in ('Y', 'C') THEN
3059: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_discount = '||p_discount);
3055: arp_util.debug('Default_disc_and_amt_applied ()+');
3056: END IF;
3057: p_return_status := FND_API.G_RET_STS_SUCCESS;
3058: IF PG_DEBUG in ('Y', 'C') THEN
3059: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_discount = '||p_discount);
3060: END IF;
3061: IF p_amount_applied IS NULL THEN
3062: IF PG_DEBUG in ('Y', 'C') THEN
3063: arp_util.debug('Default_disc_and_amt_applied: ' || 'The p_amount_applied is NULL ');
3059: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_discount = '||p_discount);
3060: END IF;
3061: IF p_amount_applied IS NULL THEN
3062: IF PG_DEBUG in ('Y', 'C') THEN
3063: arp_util.debug('Default_disc_and_amt_applied: ' || 'The p_amount_applied is NULL ');
3064: END IF;
3065: IF p_trx_currency_code <> p_cr_currency_code --The cross-currency case
3066: THEN
3067: l_exchange_rate_type := pg_profile_cc_rate_type;
3065: IF p_trx_currency_code <> p_cr_currency_code --The cross-currency case
3066: THEN
3067: l_exchange_rate_type := pg_profile_cc_rate_type;
3068: IF PG_DEBUG in ('Y', 'C') THEN
3069: arp_util.debug('Default_disc_and_amt_applied: ' || 'default cross currency exchange rate type :'||l_exchange_rate_type);
3070: END IF;
3071: IF ( (gl_currency_api.is_fixed_rate(
3072: p_cr_currency_code,
3073: p_trx_currency_code,
3075: ) = 'Y' ) OR
3076: l_exchange_rate_type IS NOT NULL)
3077: THEN
3078: IF PG_DEBUG in ('Y', 'C') THEN
3079: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_trx_currency_code :'||p_trx_currency_code);
3080: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_currency_code :'||p_cr_currency_code);
3081: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_date :'||p_cr_date);
3082: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_exchange_rate_type :'||l_exchange_rate_type);
3083: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_amount_due_remaining :'||to_char(p_amount_due_remaining));
3076: l_exchange_rate_type IS NOT NULL)
3077: THEN
3078: IF PG_DEBUG in ('Y', 'C') THEN
3079: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_trx_currency_code :'||p_trx_currency_code);
3080: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_currency_code :'||p_cr_currency_code);
3081: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_date :'||p_cr_date);
3082: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_exchange_rate_type :'||l_exchange_rate_type);
3083: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_amount_due_remaining :'||to_char(p_amount_due_remaining));
3084: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_unapp_amount :'||to_char(p_cr_unapp_amount));
3077: THEN
3078: IF PG_DEBUG in ('Y', 'C') THEN
3079: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_trx_currency_code :'||p_trx_currency_code);
3080: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_currency_code :'||p_cr_currency_code);
3081: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_date :'||p_cr_date);
3082: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_exchange_rate_type :'||l_exchange_rate_type);
3083: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_amount_due_remaining :'||to_char(p_amount_due_remaining));
3084: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_unapp_amount :'||to_char(p_cr_unapp_amount));
3085: END IF;
3078: IF PG_DEBUG in ('Y', 'C') THEN
3079: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_trx_currency_code :'||p_trx_currency_code);
3080: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_currency_code :'||p_cr_currency_code);
3081: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_date :'||p_cr_date);
3082: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_exchange_rate_type :'||l_exchange_rate_type);
3083: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_amount_due_remaining :'||to_char(p_amount_due_remaining));
3084: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_unapp_amount :'||to_char(p_cr_unapp_amount));
3085: END IF;
3086:
3079: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_trx_currency_code :'||p_trx_currency_code);
3080: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_currency_code :'||p_cr_currency_code);
3081: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_date :'||p_cr_date);
3082: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_exchange_rate_type :'||l_exchange_rate_type);
3083: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_amount_due_remaining :'||to_char(p_amount_due_remaining));
3084: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_unapp_amount :'||to_char(p_cr_unapp_amount));
3085: END IF;
3086:
3087: BEGIN
3080: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_currency_code :'||p_cr_currency_code);
3081: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_date :'||p_cr_date);
3082: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_exchange_rate_type :'||l_exchange_rate_type);
3083: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_amount_due_remaining :'||to_char(p_amount_due_remaining));
3084: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_cr_unapp_amount :'||to_char(p_cr_unapp_amount));
3085: END IF;
3086:
3087: BEGIN
3088:
3109: l_exchange_rate_type,
3110: p_cr_unapp_amount);
3111:
3112: IF PG_DEBUG in ('Y', 'C') THEN
3113: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_convert_amount_inv:'||to_char(l_convert_amount_inv));
3114: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_convert_amount_cr :'||to_char(l_convert_amount_cr));
3115: END IF;
3116:
3117:
3110: p_cr_unapp_amount);
3111:
3112: IF PG_DEBUG in ('Y', 'C') THEN
3113: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_convert_amount_inv:'||to_char(l_convert_amount_inv));
3114: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_convert_amount_cr :'||to_char(l_convert_amount_cr));
3115: END IF;
3116:
3117:
3118: EXCEPTION
3119: WHEN gl_currency_api.NO_RATE THEN
3120: l_convert_amount_inv := NULL;
3121: l_convert_amount_cr := NULL;
3122: IF PG_DEBUG in ('Y', 'C') THEN
3123: arp_util.debug('Default_disc_and_amt_applied: ' || 'No rate exists in the GL for the cross currency conversion ');
3124: END IF;
3125: WHEN gl_currency_api.INVALID_CURRENCY THEN
3126: IF PG_DEBUG in ('Y', 'C') THEN
3127: arp_util.debug('Default_disc_and_amt_applied: ' || 'The Receipt/Invoice currency is Invalid ');
3123: arp_util.debug('Default_disc_and_amt_applied: ' || 'No rate exists in the GL for the cross currency conversion ');
3124: END IF;
3125: WHEN gl_currency_api.INVALID_CURRENCY THEN
3126: IF PG_DEBUG in ('Y', 'C') THEN
3127: arp_util.debug('Default_disc_and_amt_applied: ' || 'The Receipt/Invoice currency is Invalid ');
3128: END IF;
3129: raise;
3130: END;
3131:
3137: pass the invoice amount in invoice currency */
3138:
3139: l_applied_in_amount := p_amount_due_remaining;
3140: IF PG_DEBUG in ('Y', 'C') THEN
3141: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_convert_amount_inv = p_cr_unapp_amount, l_applied_in_amount = ' || to_char(l_applied_in_amount));
3142: END IF;
3143: ELSE
3144: /* bug 2174978 : if invoice amount in receipt currency <> receipt's unapplied amount
3145: pass the receipt amount in invoice currency */
3145: pass the receipt amount in invoice currency */
3146:
3147: l_applied_in_amount := l_convert_amount_cr;
3148: IF PG_DEBUG in ('Y', 'C') THEN
3149: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_convert_amount_inv <> p_cr_unapp_amount, l_applied_in_amount :'||to_char(l_applied_in_amount));
3150: END IF;
3151: END IF;
3152:
3153: /* if exchange rate type was ok, but no rate in GL, the value returned is
3224:
3225: IF p_applied_payment_schedule_id > 0 AND
3226: l_grace_days IS NOT NULL THEN
3227: IF PG_DEBUG in ('Y', 'C') THEN
3228: arp_util.debug('Default_disc_and_amt_applied: ' || 'Before calling the discounts routine ..');
3229: END IF;
3230:
3231: arp_calculate_discount.discounts_cover(
3232: -- IN PARAMETERS
3261: p_out_amount_to_apply => l_out_amount_to_apply,
3262: p_out_discount_to_take => l_discount
3263: );
3264: IF PG_DEBUG in ('Y', 'C') THEN
3265: arp_util.debug('Default_disc_and_amt_applied: ' || 'After calling the discounts routine ..');
3266: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_out_earned_discount = '||l_out_earned_discount);
3267: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_out_unearned_discount = '||l_out_unearned_discount);
3268: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_discount = '||l_discount);
3269: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_discount = '||p_discount);
3262: p_out_discount_to_take => l_discount
3263: );
3264: IF PG_DEBUG in ('Y', 'C') THEN
3265: arp_util.debug('Default_disc_and_amt_applied: ' || 'After calling the discounts routine ..');
3266: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_out_earned_discount = '||l_out_earned_discount);
3267: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_out_unearned_discount = '||l_out_unearned_discount);
3268: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_discount = '||l_discount);
3269: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_discount = '||p_discount);
3270: END IF;
3263: );
3264: IF PG_DEBUG in ('Y', 'C') THEN
3265: arp_util.debug('Default_disc_and_amt_applied: ' || 'After calling the discounts routine ..');
3266: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_out_earned_discount = '||l_out_earned_discount);
3267: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_out_unearned_discount = '||l_out_unearned_discount);
3268: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_discount = '||l_discount);
3269: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_discount = '||p_discount);
3270: END IF;
3271: l_earned_disc_pct := ROUND(l_earned_disc_pct,6);
3264: IF PG_DEBUG in ('Y', 'C') THEN
3265: arp_util.debug('Default_disc_and_amt_applied: ' || 'After calling the discounts routine ..');
3266: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_out_earned_discount = '||l_out_earned_discount);
3267: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_out_unearned_discount = '||l_out_unearned_discount);
3268: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_discount = '||l_discount);
3269: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_discount = '||p_discount);
3270: END IF;
3271: l_earned_disc_pct := ROUND(l_earned_disc_pct,6);
3272:
3265: arp_util.debug('Default_disc_and_amt_applied: ' || 'After calling the discounts routine ..');
3266: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_out_earned_discount = '||l_out_earned_discount);
3267: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_out_unearned_discount = '||l_out_unearned_discount);
3268: arp_util.debug('Default_disc_and_amt_applied: ' || 'l_discount = '||l_discount);
3269: arp_util.debug('Default_disc_and_amt_applied: ' || 'p_discount = '||p_discount);
3270: END IF;
3271: l_earned_disc_pct := ROUND(l_earned_disc_pct,6);
3272:
3273: -- Store the maximum allowed discount, to be used later while validating
3270: END IF;
3271: l_earned_disc_pct := ROUND(l_earned_disc_pct,6);
3272:
3273: -- Store the maximum allowed discount, to be used later while validating
3274: p_discount_max_allowed :=arp_util.CurrRound( l_out_earned_discount+
3275: l_out_unearned_discount,
3276: p_trx_currency_code);
3277: p_discount_earned_allowed := l_out_earned_discount;
3278:
3331: END IF;
3332:
3333: END IF;
3334:
3335: p_amount_applied := arp_util.CurrRound(p_amount_applied,
3336: p_trx_currency_code);
3337: p_discount := arp_util.CurrRound(p_discount,
3338: p_trx_currency_code);
3339: IF PG_DEBUG in ('Y', 'C') THEN
3333: END IF;
3334:
3335: p_amount_applied := arp_util.CurrRound(p_amount_applied,
3336: p_trx_currency_code);
3337: p_discount := arp_util.CurrRound(p_discount,
3338: p_trx_currency_code);
3339: IF PG_DEBUG in ('Y', 'C') THEN
3340: arp_util.debug('Default_disc_and_amt_applied ()-');
3341: END IF;
3336: p_trx_currency_code);
3337: p_discount := arp_util.CurrRound(p_discount,
3338: p_trx_currency_code);
3339: IF PG_DEBUG in ('Y', 'C') THEN
3340: arp_util.debug('Default_disc_and_amt_applied ()-');
3341: END IF;
3342: EXCEPTION
3343: WHEN others THEN
3344: IF PG_DEBUG in ('Y', 'C') THEN
3341: END IF;
3342: EXCEPTION
3343: WHEN others THEN
3344: IF PG_DEBUG in ('Y', 'C') THEN
3345: arp_util.debug('Default_disc_and_amt_applied: ' || 'EXCEPTION: Default_discount_and_amount_applied()');
3346: END IF;
3347: raise;
3348: END Default_disc_and_amt_applied;
3349:
3386: return(null);
3387:
3388: WHEN others THEN
3389: IF PG_DEBUG in ('Y', 'C') THEN
3390: arp_util.debug('Get_trx_Line_amount: ' || 'EXCEPTION: Default_Trx_Line_Amount()');
3391: END IF;
3392: raise;
3393: END Get_trx_Line_amount;
3394:
3453: AND site_use.site_use_code IN ('BILL_TO','DRAWEE');
3454:
3455: BEGIN
3456: IF PG_DEBUG in ('Y', 'C') THEN
3457: arp_util.debug('Default_Trx_Info ()+');
3458: END IF;
3459: p_return_status := FND_API.G_RET_STS_SUCCESS;
3460: --this is only for regular application, not for on-account
3461:
3498: ps.gl_date)) gl_date
3499: , ps.term_id
3500: , ps.amount_due_original
3501: , ps.amount_line_items_original
3502: , arp_util.CurrRound(ps.amount_due_remaining,
3503: ps.invoice_currency_code)
3504: , ps.discount_taken_earned
3505: , ps.discount_taken_unearned
3506: , ps.amount_line_items_original
3595: ps.gl_date)) gl_date
3596: , ps.term_id
3597: , ps.amount_due_original
3598: , ps.amount_line_items_original
3599: , arp_util.CurrRound(ps.amount_due_remaining,
3600: ps.invoice_currency_code)
3601: , ps.discount_taken_earned
3602: , ps.discount_taken_unearned
3603: , ps.amount_line_items_original
3713: ot.trx_gl_date)) gl_date,
3714: ot.term_id ,
3715: ot.amount_due_original,
3716: ot.amount_line_items_original ,
3717: arp_util.CurrRound(ot.balance_due_curr_unformatted,
3718: ot.invoice_currency_code) ,
3719: ot.discount_taken_earned,
3720: ot.discount_taken_unearned,
3721: ot.amount_line_items_original,
3790: ot.trx_gl_date)) gl_date,
3791: ot.term_id ,
3792: ot.amount_due_original,
3793: ot.amount_line_items_original ,
3794: arp_util.CurrRound(ot.balance_due_curr_unformatted,
3795: ot.invoice_currency_code) ,
3796: ot.discount_taken_earned,
3797: ot.discount_taken_unearned,
3798: ot.amount_line_items_original,
3905: );
3906: IF l_line_amt_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3907: p_return_status := FND_API.G_RET_STS_ERROR;
3908: END IF;
3909: p_trx_line_amount := arp_util.CurrRound(p_trx_line_amount,
3910: p_trx_currency_code);
3911: END IF;
3912: --Also check if the payment_schedule of the transaction has already been
3913: --applied once to the current_receipt, if yes then raise error
3952:
3953: END IF;
3954:
3955: IF PG_DEBUG in ('Y', 'C') THEN
3956: arp_util.debug('Default_Trx_Info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
3957: arp_util.debug('Default_Trx_Info: ' || 'p_bill_to_site_use_id : '||to_char(p_bill_to_site_use_id));
3958: arp_util.debug('Default_Trx_Info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
3959: arp_util.debug('Default_Trx_Info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag );
3960: arp_util.debug('Default_Trx_Info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
3953: END IF;
3954:
3955: IF PG_DEBUG in ('Y', 'C') THEN
3956: arp_util.debug('Default_Trx_Info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
3957: arp_util.debug('Default_Trx_Info: ' || 'p_bill_to_site_use_id : '||to_char(p_bill_to_site_use_id));
3958: arp_util.debug('Default_Trx_Info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
3959: arp_util.debug('Default_Trx_Info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag );
3960: arp_util.debug('Default_Trx_Info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
3961: arp_util.debug('Default_Trx_Info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
3954:
3955: IF PG_DEBUG in ('Y', 'C') THEN
3956: arp_util.debug('Default_Trx_Info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
3957: arp_util.debug('Default_Trx_Info: ' || 'p_bill_to_site_use_id : '||to_char(p_bill_to_site_use_id));
3958: arp_util.debug('Default_Trx_Info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
3959: arp_util.debug('Default_Trx_Info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag );
3960: arp_util.debug('Default_Trx_Info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
3961: arp_util.debug('Default_Trx_Info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
3962: arp_util.debug('Default_Trx_Info: ' || 'p_creation_sign : '||p_creation_sign);
3955: IF PG_DEBUG in ('Y', 'C') THEN
3956: arp_util.debug('Default_Trx_Info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
3957: arp_util.debug('Default_Trx_Info: ' || 'p_bill_to_site_use_id : '||to_char(p_bill_to_site_use_id));
3958: arp_util.debug('Default_Trx_Info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
3959: arp_util.debug('Default_Trx_Info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag );
3960: arp_util.debug('Default_Trx_Info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
3961: arp_util.debug('Default_Trx_Info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
3962: arp_util.debug('Default_Trx_Info: ' || 'p_creation_sign : '||p_creation_sign);
3963: arp_util.debug('Default_Trx_Info ()-');
3956: arp_util.debug('Default_Trx_Info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
3957: arp_util.debug('Default_Trx_Info: ' || 'p_bill_to_site_use_id : '||to_char(p_bill_to_site_use_id));
3958: arp_util.debug('Default_Trx_Info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
3959: arp_util.debug('Default_Trx_Info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag );
3960: arp_util.debug('Default_Trx_Info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
3961: arp_util.debug('Default_Trx_Info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
3962: arp_util.debug('Default_Trx_Info: ' || 'p_creation_sign : '||p_creation_sign);
3963: arp_util.debug('Default_Trx_Info ()-');
3964: END IF;
3957: arp_util.debug('Default_Trx_Info: ' || 'p_bill_to_site_use_id : '||to_char(p_bill_to_site_use_id));
3958: arp_util.debug('Default_Trx_Info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
3959: arp_util.debug('Default_Trx_Info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag );
3960: arp_util.debug('Default_Trx_Info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
3961: arp_util.debug('Default_Trx_Info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
3962: arp_util.debug('Default_Trx_Info: ' || 'p_creation_sign : '||p_creation_sign);
3963: arp_util.debug('Default_Trx_Info ()-');
3964: END IF;
3965: EXCEPTION
3958: arp_util.debug('Default_Trx_Info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
3959: arp_util.debug('Default_Trx_Info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag );
3960: arp_util.debug('Default_Trx_Info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
3961: arp_util.debug('Default_Trx_Info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
3962: arp_util.debug('Default_Trx_Info: ' || 'p_creation_sign : '||p_creation_sign);
3963: arp_util.debug('Default_Trx_Info ()-');
3964: END IF;
3965: EXCEPTION
3966: WHEN no_data_found THEN
3959: arp_util.debug('Default_Trx_Info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag );
3960: arp_util.debug('Default_Trx_Info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
3961: arp_util.debug('Default_Trx_Info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
3962: arp_util.debug('Default_Trx_Info: ' || 'p_creation_sign : '||p_creation_sign);
3963: arp_util.debug('Default_Trx_Info ()-');
3964: END IF;
3965: EXCEPTION
3966: WHEN no_data_found THEN
3967: IF PG_DEBUG in ('Y', 'C') THEN
3964: END IF;
3965: EXCEPTION
3966: WHEN no_data_found THEN
3967: IF PG_DEBUG in ('Y', 'C') THEN
3968: arp_util.debug('Default_Trx_Info : No data found ');
3969: END IF;
3970: IF ar_receipt_api_pub.Original_application_info.customer_trx_id IS NOT NULL THEN
3971:
3972: IF ar_receipt_api_pub.Original_application_info.installment IS NOT NULL THEN
3997: FND_MSG_PUB.ADD;
3998: END IF;
3999: WHEN others THEN
4000: IF PG_DEBUG in ('Y', 'C') THEN
4001: arp_util.debug('EXCEPTION: Default_Trx_Info()');
4002: END IF;
4003: raise;
4004: END Default_Trx_Info;
4005:
4021:
4022: BEGIN
4023: p_return_status := FND_API.G_RET_STS_SUCCESS;
4024: IF PG_DEBUG in ('Y', 'C') THEN
4025: arp_util.debug('Default_Receipt_Info ()+');
4026: END IF;
4027: IF p_cash_receipt_id IS NOT NULL THEN
4028: BEGIN
4029: SELECT cr.pay_from_customer,
4103: FND_MSG_PUB.ADD;
4104: END IF;
4105: WHEN others THEN
4106: IF PG_DEBUG in ('Y', 'C') THEN
4107: arp_util.debug('EXCEPTION: Default_Receipt_Info()');
4108: END IF;
4109: raise;
4110: END;
4111: WHEN others THEN
4109: raise;
4110: END;
4111: WHEN others THEN
4112: IF PG_DEBUG in ('Y', 'C') THEN
4113: arp_util.debug('EXCEPTION: Default_Receipt_Info()');
4114: END IF;
4115: raise;
4116: END;
4117:
4132: END IF;
4133:
4134: END IF;
4135: IF PG_DEBUG in ('Y', 'C') THEN
4136: arp_util.debug('Default_Receipt_Info: ' || ' p_return_status :'||p_return_status);
4137: arp_util.debug('Default_Receipt_Info ()-');
4138: END IF;
4139: EXCEPTION
4140: WHEN no_data_found THEN
4133:
4134: END IF;
4135: IF PG_DEBUG in ('Y', 'C') THEN
4136: arp_util.debug('Default_Receipt_Info: ' || ' p_return_status :'||p_return_status);
4137: arp_util.debug('Default_Receipt_Info ()-');
4138: END IF;
4139: EXCEPTION
4140: WHEN no_data_found THEN
4141: IF ar_receipt_api_pub.Original_application_info.cash_receipt_id IS NOT NULL THEN
4148: FND_MSG_PUB.ADD;
4149: END IF;
4150: WHEN others THEN
4151: IF PG_DEBUG in ('Y', 'C') THEN
4152: arp_util.debug('EXCEPTION: Default_Receipt_Info()');
4153: END IF;
4154: raise;
4155:
4156: END Default_Receipt_Info;
4182: p_return_status OUT NOCOPY VARCHAR2
4183: ) IS
4184: BEGIN
4185: IF PG_DEBUG in ('Y', 'C') THEN
4186: arp_util.debug('Default_customer_trx_id ()+');
4187: END IF;
4188: p_return_status := FND_API.G_RET_STS_SUCCESS;
4189: IF p_customer_trx_id IS NULL THEN
4190: IF p_trx_number IS NOT NULL THEN
4214: END IF;
4215: END IF;
4216: END IF;
4217: IF PG_DEBUG in ('Y', 'C') THEN
4218: arp_util.debug('Default_customer_trx_id ()-');
4219: END IF;
4220: EXCEPTION
4221: WHEN others THEN
4222: IF PG_DEBUG in ('Y', 'C') THEN
4219: END IF;
4220: EXCEPTION
4221: WHEN others THEN
4222: IF PG_DEBUG in ('Y', 'C') THEN
4223: arp_util.debug('EXCEPTION: Default_customer_trx_id()', G_MSG_UERROR);
4224: END IF;
4225: END Default_customer_trx_id;
4226: /* Bug 5284890 */
4227: PROCEDURE Default_group_id( p_customer_trx_id IN NUMBER,
4231: ) IS
4232: l_count Number;
4233: BEGIN
4234: IF PG_DEBUG in ('Y', 'C') THEN
4235: arp_util.debug('Default_group_id ()+');
4236: END IF;
4237: p_return_status := FND_API.G_RET_STS_SUCCESS;
4238:
4239: select count(1)
4252: p_return_status := FND_API.G_RET_STS_ERROR ;
4253: END IF;
4254:
4255: IF PG_DEBUG in ('Y', 'C') THEN
4256: arp_util.debug('Default_group_id ()+');
4257: END IF;
4258: END ;
4259: /* Bug fix 3435834
4260: New procedure created for defaulting customer_trx_line_id */
4270: where customer_trx_id = p_cust_trx_id;
4271: l_cust_trx_line_id Number;
4272: BEGIN
4273: IF PG_DEBUG in ('Y', 'C') THEN
4274: arp_util.debug('Default_customer_trx_line_id ()+');
4275: END IF;
4276: p_return_status := FND_API.G_RET_STS_SUCCESS;
4277:
4278: IF p_customer_trx_line_id IS NOT NULL AND
4403: End Loop;
4404: END IF;
4405: END If;
4406: IF PG_DEBUG in ('Y', 'C') THEN
4407: arp_util.debug('Default_customer_trx_line_id ()-');
4408: END IF;
4409: EXCEPTION
4410: WHEN others THEN
4411: IF PG_DEBUG in ('Y', 'C') THEN
4408: END IF;
4409: EXCEPTION
4410: WHEN others THEN
4411: IF PG_DEBUG in ('Y', 'C') THEN
4412: arp_util.debug('EXCEPTION: Default_customer_trx_line_id()', G_MSG_UERROR);
4413: END IF;
4414: END Default_customer_trx_line_id;
4415:
4416:
4420: p_return_status OUT NOCOPY VARCHAR2
4421: ) IS
4422: BEGIN
4423: IF PG_DEBUG in ('Y', 'C') THEN
4424: arp_util.debug('Default_cash_receipt_id ()+');
4425: END IF;
4426: p_return_status := FND_API.G_RET_STS_SUCCESS;
4427: arp_util.debug('Default_appln_ids:CHECK 2' || 'p_receipt_number :'||to_char(p_receipt_number));
4428: IF p_cash_receipt_id IS NULL
4423: IF PG_DEBUG in ('Y', 'C') THEN
4424: arp_util.debug('Default_cash_receipt_id ()+');
4425: END IF;
4426: p_return_status := FND_API.G_RET_STS_SUCCESS;
4427: arp_util.debug('Default_appln_ids:CHECK 2' || 'p_receipt_number :'||to_char(p_receipt_number));
4428: IF p_cash_receipt_id IS NULL
4429: THEN
4430: BEGIN
4431: SELECT cash_receipt_id
4455: END IF;
4456: END IF;
4457: END IF;
4458: IF PG_DEBUG in ('Y', 'C') THEN
4459: arp_util.debug('Default_cash_receipt_id ()-');
4460: END IF;
4461: EXCEPTION
4462: WHEN others THEN
4463: IF PG_DEBUG in ('Y', 'C') THEN
4460: END IF;
4461: EXCEPTION
4462: WHEN others THEN
4463: IF PG_DEBUG in ('Y', 'C') THEN
4464: arp_util.debug('EXCEPTION: Default_cash_receipt_id()');
4465: END IF;
4466: END Default_cash_receipt_id;
4467:
4468: PROCEDURE Default_appln_ids(
4493: p_return_status_group VARCHAR2(100); /* Bug 5284890 */
4494:
4495: BEGIN
4496: IF PG_DEBUG in ('Y', 'C') THEN
4497: arp_util.debug('Default_appln_ids ()+ ');
4498: END IF;
4499: p_return_status := FND_API.G_RET_STS_SUCCESS;
4500:
4501: -- First get a valid value for the customer_trx_id
4608: p_return_status := FND_API.G_RET_STS_ERROR;
4609: END IF;
4610:
4611: IF PG_DEBUG in ('Y', 'C') THEN
4612: arp_util.debug('Default_appln_ids: ' || '****Defaulted Value for the application ids****');
4613: arp_util.debug('Default_appln_ids: ' || 'p_cash_receipt_id :'||to_char(p_cash_receipt_id));
4614: arp_util.debug('Default_appln_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
4615: arp_util.debug('Default_appln_ids: ' || 'p_installment :'||to_char(p_installment));
4616: arp_util.debug('Default_appln_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
4609: END IF;
4610:
4611: IF PG_DEBUG in ('Y', 'C') THEN
4612: arp_util.debug('Default_appln_ids: ' || '****Defaulted Value for the application ids****');
4613: arp_util.debug('Default_appln_ids: ' || 'p_cash_receipt_id :'||to_char(p_cash_receipt_id));
4614: arp_util.debug('Default_appln_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
4615: arp_util.debug('Default_appln_ids: ' || 'p_installment :'||to_char(p_installment));
4616: arp_util.debug('Default_appln_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
4617: arp_util.debug('Default_appln_ids ()- ');
4610:
4611: IF PG_DEBUG in ('Y', 'C') THEN
4612: arp_util.debug('Default_appln_ids: ' || '****Defaulted Value for the application ids****');
4613: arp_util.debug('Default_appln_ids: ' || 'p_cash_receipt_id :'||to_char(p_cash_receipt_id));
4614: arp_util.debug('Default_appln_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
4615: arp_util.debug('Default_appln_ids: ' || 'p_installment :'||to_char(p_installment));
4616: arp_util.debug('Default_appln_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
4617: arp_util.debug('Default_appln_ids ()- ');
4618: END IF;
4611: IF PG_DEBUG in ('Y', 'C') THEN
4612: arp_util.debug('Default_appln_ids: ' || '****Defaulted Value for the application ids****');
4613: arp_util.debug('Default_appln_ids: ' || 'p_cash_receipt_id :'||to_char(p_cash_receipt_id));
4614: arp_util.debug('Default_appln_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
4615: arp_util.debug('Default_appln_ids: ' || 'p_installment :'||to_char(p_installment));
4616: arp_util.debug('Default_appln_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
4617: arp_util.debug('Default_appln_ids ()- ');
4618: END IF;
4619: EXCEPTION
4612: arp_util.debug('Default_appln_ids: ' || '****Defaulted Value for the application ids****');
4613: arp_util.debug('Default_appln_ids: ' || 'p_cash_receipt_id :'||to_char(p_cash_receipt_id));
4614: arp_util.debug('Default_appln_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
4615: arp_util.debug('Default_appln_ids: ' || 'p_installment :'||to_char(p_installment));
4616: arp_util.debug('Default_appln_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
4617: arp_util.debug('Default_appln_ids ()- ');
4618: END IF;
4619: EXCEPTION
4620: WHEN others THEN
4613: arp_util.debug('Default_appln_ids: ' || 'p_cash_receipt_id :'||to_char(p_cash_receipt_id));
4614: arp_util.debug('Default_appln_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
4615: arp_util.debug('Default_appln_ids: ' || 'p_installment :'||to_char(p_installment));
4616: arp_util.debug('Default_appln_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
4617: arp_util.debug('Default_appln_ids ()- ');
4618: END IF;
4619: EXCEPTION
4620: WHEN others THEN
4621: IF PG_DEBUG in ('Y', 'C') THEN
4618: END IF;
4619: EXCEPTION
4620: WHEN others THEN
4621: IF PG_DEBUG in ('Y', 'C') THEN
4622: arp_util.debug('EXCEPTION: Default_appln_ids()');
4623: END IF;
4624: raise;
4625: END Default_appln_ids;
4626:
4738: l_val_llca_msg_data VARCHAR2(2000);
4739: l_val_llca_msg_count NUMBER;
4740: BEGIN
4741: IF PG_DEBUG in ('Y', 'C') THEN
4742: arp_util.debug('Default_application_info ()+');
4743: arp_util.debug('Default_application_info: ' || 'p_discount = '||p_discount );
4744: END IF;
4745:
4746: p_return_status := FND_API.G_RET_STS_SUCCESS;
4739: l_val_llca_msg_count NUMBER;
4740: BEGIN
4741: IF PG_DEBUG in ('Y', 'C') THEN
4742: arp_util.debug('Default_application_info ()+');
4743: arp_util.debug('Default_application_info: ' || 'p_discount = '||p_discount );
4744: END IF;
4745:
4746: p_return_status := FND_API.G_RET_STS_SUCCESS;
4747: Default_Receipt_Info(
4758: p_remittance_bank_account_id,
4759: p_receipt_method_id,
4760: l_def_cr_return_status );
4761: IF PG_DEBUG in ('Y', 'C') THEN
4762: arp_util.debug('Default_application_info: ' || 'Default_Receipt_Info return status = '||l_def_cr_return_status);
4763: END IF;
4764:
4765: /* Bug 4038708 */
4766: IF(l_cr_customer_id is NULL) THEN
4816: l_rec_charges_remaining,
4817: l_def_trx_return_status );
4818:
4819: IF PG_DEBUG in ('Y', 'C') THEN
4820: arp_util.debug('Default_application_info: ' || 'Default trx info return status = '||l_def_trx_return_status);
4821: END IF;
4822: END IF;
4823:
4824: Default_apply_date(l_cr_date ,
4833: defaulted gl_date and in case it is incorrect, then we get the appropriate
4834: gl_date and use it as default.
4835: */
4836: l_return :=
4837: arp_util.validate_and_default_gl_date(
4838: gl_date => l_gl_date,
4839: trx_date => null,
4840: validation_date1 => null,
4841: validation_date2 => null,
4884: );
4885:
4886: END IF;
4887:
4888: --arp_util.debug('p_apply_gl_date '||p_apply_gl_date);
4889: Default_disc_and_amt_applied(
4890: l_customer_id ,
4891: l_bill_to_site_use_id ,
4892: p_applied_payment_schedule_id ,
4921: l_def_amt_return_status);
4922:
4923:
4924: IF PG_DEBUG in ('Y', 'C') THEN
4925: arp_util.debug('Default_application_info: ' || 'l_calc_discount_on_lines_flag : '||l_calc_discount_on_lines_flag);
4926: arp_util.debug('Default_application_info: ' || 'l_partial_discount_flag : '||l_partial_discount_flag );
4927: arp_util.debug('Default_application_info: ' || 'l_allow_overappln_flag : '||l_allow_overappln_flag);
4928: arp_util.debug('Default_application_info: ' || 'l_natural_appln_only_flag : '||l_natural_appln_only_flag);
4929: arp_util.debug('Default_application_info: ' || 'l_creation_sign : '||l_creation_sign);
4922:
4923:
4924: IF PG_DEBUG in ('Y', 'C') THEN
4925: arp_util.debug('Default_application_info: ' || 'l_calc_discount_on_lines_flag : '||l_calc_discount_on_lines_flag);
4926: arp_util.debug('Default_application_info: ' || 'l_partial_discount_flag : '||l_partial_discount_flag );
4927: arp_util.debug('Default_application_info: ' || 'l_allow_overappln_flag : '||l_allow_overappln_flag);
4928: arp_util.debug('Default_application_info: ' || 'l_natural_appln_only_flag : '||l_natural_appln_only_flag);
4929: arp_util.debug('Default_application_info: ' || 'l_creation_sign : '||l_creation_sign);
4930: arp_util.debug('Default_application_info: ' || 'Default amount return status :'||l_def_amt_return_status );
4923:
4924: IF PG_DEBUG in ('Y', 'C') THEN
4925: arp_util.debug('Default_application_info: ' || 'l_calc_discount_on_lines_flag : '||l_calc_discount_on_lines_flag);
4926: arp_util.debug('Default_application_info: ' || 'l_partial_discount_flag : '||l_partial_discount_flag );
4927: arp_util.debug('Default_application_info: ' || 'l_allow_overappln_flag : '||l_allow_overappln_flag);
4928: arp_util.debug('Default_application_info: ' || 'l_natural_appln_only_flag : '||l_natural_appln_only_flag);
4929: arp_util.debug('Default_application_info: ' || 'l_creation_sign : '||l_creation_sign);
4930: arp_util.debug('Default_application_info: ' || 'Default amount return status :'||l_def_amt_return_status );
4931: END IF;
4924: IF PG_DEBUG in ('Y', 'C') THEN
4925: arp_util.debug('Default_application_info: ' || 'l_calc_discount_on_lines_flag : '||l_calc_discount_on_lines_flag);
4926: arp_util.debug('Default_application_info: ' || 'l_partial_discount_flag : '||l_partial_discount_flag );
4927: arp_util.debug('Default_application_info: ' || 'l_allow_overappln_flag : '||l_allow_overappln_flag);
4928: arp_util.debug('Default_application_info: ' || 'l_natural_appln_only_flag : '||l_natural_appln_only_flag);
4929: arp_util.debug('Default_application_info: ' || 'l_creation_sign : '||l_creation_sign);
4930: arp_util.debug('Default_application_info: ' || 'Default amount return status :'||l_def_amt_return_status );
4931: END IF;
4932:
4925: arp_util.debug('Default_application_info: ' || 'l_calc_discount_on_lines_flag : '||l_calc_discount_on_lines_flag);
4926: arp_util.debug('Default_application_info: ' || 'l_partial_discount_flag : '||l_partial_discount_flag );
4927: arp_util.debug('Default_application_info: ' || 'l_allow_overappln_flag : '||l_allow_overappln_flag);
4928: arp_util.debug('Default_application_info: ' || 'l_natural_appln_only_flag : '||l_natural_appln_only_flag);
4929: arp_util.debug('Default_application_info: ' || 'l_creation_sign : '||l_creation_sign);
4930: arp_util.debug('Default_application_info: ' || 'Default amount return status :'||l_def_amt_return_status );
4931: END IF;
4932:
4933: Default_trans_to_receipt_rate(
4926: arp_util.debug('Default_application_info: ' || 'l_partial_discount_flag : '||l_partial_discount_flag );
4927: arp_util.debug('Default_application_info: ' || 'l_allow_overappln_flag : '||l_allow_overappln_flag);
4928: arp_util.debug('Default_application_info: ' || 'l_natural_appln_only_flag : '||l_natural_appln_only_flag);
4929: arp_util.debug('Default_application_info: ' || 'l_creation_sign : '||l_creation_sign);
4930: arp_util.debug('Default_application_info: ' || 'Default amount return status :'||l_def_amt_return_status );
4931: END IF;
4932:
4933: Default_trans_to_receipt_rate(
4934: l_trx_currency_code ,
4940: l_cr_date,
4941: l_def_rate_return_status
4942: );
4943: IF PG_DEBUG in ('Y', 'C') THEN
4944: arp_util.debug('Default_application_info: ' || 'Default trans_to_receipt_rate status :'||l_def_rate_return_status);
4945: END IF;
4946: Default_amount_applied_from(
4947: p_amount_applied ,
4948: l_trx_currency_code ,
4951: p_amount_applied_from ,
4952: l_def_aaf_return_status
4953: );
4954: IF PG_DEBUG in ('Y', 'C') THEN
4955: arp_util.debug('Default_application_info: ' || 'Default amount applied from return status :'||l_def_aaf_return_status);
4956: END IF;
4957:
4958:
4959: --populate the parameters with the values in the local variables
4993: p_return_status := FND_API.G_RET_STS_ERROR;
4994: END IF;
4995:
4996: IF PG_DEBUG in ('Y', 'C') THEN
4997: arp_util.debug('Default_application_info: ' || '*****************Application Defaults***************');
4998: arp_util.debug('Default_application_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
4999: arp_util.debug('Default_application_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5000: arp_util.debug('Default_application_info: ' || 'p_cr_date : '||to_char(p_cr_date,'DD-MON-YYYY'));
5001: arp_util.debug('Default_application_info: ' || 'p_cr_amount : '||to_char(p_cr_amount));
4994: END IF;
4995:
4996: IF PG_DEBUG in ('Y', 'C') THEN
4997: arp_util.debug('Default_application_info: ' || '*****************Application Defaults***************');
4998: arp_util.debug('Default_application_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
4999: arp_util.debug('Default_application_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5000: arp_util.debug('Default_application_info: ' || 'p_cr_date : '||to_char(p_cr_date,'DD-MON-YYYY'));
5001: arp_util.debug('Default_application_info: ' || 'p_cr_amount : '||to_char(p_cr_amount));
5002: arp_util.debug('Default_application_info: ' || 'p_cr_unapp_amount : '||to_char(p_cr_unapp_amount));
4995:
4996: IF PG_DEBUG in ('Y', 'C') THEN
4997: arp_util.debug('Default_application_info: ' || '*****************Application Defaults***************');
4998: arp_util.debug('Default_application_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
4999: arp_util.debug('Default_application_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5000: arp_util.debug('Default_application_info: ' || 'p_cr_date : '||to_char(p_cr_date,'DD-MON-YYYY'));
5001: arp_util.debug('Default_application_info: ' || 'p_cr_amount : '||to_char(p_cr_amount));
5002: arp_util.debug('Default_application_info: ' || 'p_cr_unapp_amount : '||to_char(p_cr_unapp_amount));
5003: arp_util.debug('Default_application_info: ' || 'p_cr_currency_code : '||p_cr_currency_code);
4996: IF PG_DEBUG in ('Y', 'C') THEN
4997: arp_util.debug('Default_application_info: ' || '*****************Application Defaults***************');
4998: arp_util.debug('Default_application_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
4999: arp_util.debug('Default_application_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5000: arp_util.debug('Default_application_info: ' || 'p_cr_date : '||to_char(p_cr_date,'DD-MON-YYYY'));
5001: arp_util.debug('Default_application_info: ' || 'p_cr_amount : '||to_char(p_cr_amount));
5002: arp_util.debug('Default_application_info: ' || 'p_cr_unapp_amount : '||to_char(p_cr_unapp_amount));
5003: arp_util.debug('Default_application_info: ' || 'p_cr_currency_code : '||p_cr_currency_code);
5004: arp_util.debug('Default_application_info: ' || 'p_customer_trx_id : '||to_char(p_customer_trx_id));
4997: arp_util.debug('Default_application_info: ' || '*****************Application Defaults***************');
4998: arp_util.debug('Default_application_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
4999: arp_util.debug('Default_application_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5000: arp_util.debug('Default_application_info: ' || 'p_cr_date : '||to_char(p_cr_date,'DD-MON-YYYY'));
5001: arp_util.debug('Default_application_info: ' || 'p_cr_amount : '||to_char(p_cr_amount));
5002: arp_util.debug('Default_application_info: ' || 'p_cr_unapp_amount : '||to_char(p_cr_unapp_amount));
5003: arp_util.debug('Default_application_info: ' || 'p_cr_currency_code : '||p_cr_currency_code);
5004: arp_util.debug('Default_application_info: ' || 'p_customer_trx_id : '||to_char(p_customer_trx_id));
5005: arp_util.debug('Default_application_info: ' || 'p_installment : '||to_char(p_installment));
4998: arp_util.debug('Default_application_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
4999: arp_util.debug('Default_application_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5000: arp_util.debug('Default_application_info: ' || 'p_cr_date : '||to_char(p_cr_date,'DD-MON-YYYY'));
5001: arp_util.debug('Default_application_info: ' || 'p_cr_amount : '||to_char(p_cr_amount));
5002: arp_util.debug('Default_application_info: ' || 'p_cr_unapp_amount : '||to_char(p_cr_unapp_amount));
5003: arp_util.debug('Default_application_info: ' || 'p_cr_currency_code : '||p_cr_currency_code);
5004: arp_util.debug('Default_application_info: ' || 'p_customer_trx_id : '||to_char(p_customer_trx_id));
5005: arp_util.debug('Default_application_info: ' || 'p_installment : '||to_char(p_installment));
5006: arp_util.debug('Default_application_info: ' || 'p_show_closed_invoices : '||p_show_closed_invoices);
4999: arp_util.debug('Default_application_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5000: arp_util.debug('Default_application_info: ' || 'p_cr_date : '||to_char(p_cr_date,'DD-MON-YYYY'));
5001: arp_util.debug('Default_application_info: ' || 'p_cr_amount : '||to_char(p_cr_amount));
5002: arp_util.debug('Default_application_info: ' || 'p_cr_unapp_amount : '||to_char(p_cr_unapp_amount));
5003: arp_util.debug('Default_application_info: ' || 'p_cr_currency_code : '||p_cr_currency_code);
5004: arp_util.debug('Default_application_info: ' || 'p_customer_trx_id : '||to_char(p_customer_trx_id));
5005: arp_util.debug('Default_application_info: ' || 'p_installment : '||to_char(p_installment));
5006: arp_util.debug('Default_application_info: ' || 'p_show_closed_invoices : '||p_show_closed_invoices);
5007: arp_util.debug('Default_application_info: ' || 'p_customer_trx_line_id : '||to_char(p_customer_trx_line_id));
5000: arp_util.debug('Default_application_info: ' || 'p_cr_date : '||to_char(p_cr_date,'DD-MON-YYYY'));
5001: arp_util.debug('Default_application_info: ' || 'p_cr_amount : '||to_char(p_cr_amount));
5002: arp_util.debug('Default_application_info: ' || 'p_cr_unapp_amount : '||to_char(p_cr_unapp_amount));
5003: arp_util.debug('Default_application_info: ' || 'p_cr_currency_code : '||p_cr_currency_code);
5004: arp_util.debug('Default_application_info: ' || 'p_customer_trx_id : '||to_char(p_customer_trx_id));
5005: arp_util.debug('Default_application_info: ' || 'p_installment : '||to_char(p_installment));
5006: arp_util.debug('Default_application_info: ' || 'p_show_closed_invoices : '||p_show_closed_invoices);
5007: arp_util.debug('Default_application_info: ' || 'p_customer_trx_line_id : '||to_char(p_customer_trx_line_id));
5008: arp_util.debug('Default_application_info: ' || 'p_trx_due_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5001: arp_util.debug('Default_application_info: ' || 'p_cr_amount : '||to_char(p_cr_amount));
5002: arp_util.debug('Default_application_info: ' || 'p_cr_unapp_amount : '||to_char(p_cr_unapp_amount));
5003: arp_util.debug('Default_application_info: ' || 'p_cr_currency_code : '||p_cr_currency_code);
5004: arp_util.debug('Default_application_info: ' || 'p_customer_trx_id : '||to_char(p_customer_trx_id));
5005: arp_util.debug('Default_application_info: ' || 'p_installment : '||to_char(p_installment));
5006: arp_util.debug('Default_application_info: ' || 'p_show_closed_invoices : '||p_show_closed_invoices);
5007: arp_util.debug('Default_application_info: ' || 'p_customer_trx_line_id : '||to_char(p_customer_trx_line_id));
5008: arp_util.debug('Default_application_info: ' || 'p_trx_due_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5009: arp_util.debug('Default_application_info: ' || 'p_trx_currency_code : '||p_trx_currency_code);
5002: arp_util.debug('Default_application_info: ' || 'p_cr_unapp_amount : '||to_char(p_cr_unapp_amount));
5003: arp_util.debug('Default_application_info: ' || 'p_cr_currency_code : '||p_cr_currency_code);
5004: arp_util.debug('Default_application_info: ' || 'p_customer_trx_id : '||to_char(p_customer_trx_id));
5005: arp_util.debug('Default_application_info: ' || 'p_installment : '||to_char(p_installment));
5006: arp_util.debug('Default_application_info: ' || 'p_show_closed_invoices : '||p_show_closed_invoices);
5007: arp_util.debug('Default_application_info: ' || 'p_customer_trx_line_id : '||to_char(p_customer_trx_line_id));
5008: arp_util.debug('Default_application_info: ' || 'p_trx_due_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5009: arp_util.debug('Default_application_info: ' || 'p_trx_currency_code : '||p_trx_currency_code);
5010: arp_util.debug('Default_application_info: ' || 'p_trx_gl_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5003: arp_util.debug('Default_application_info: ' || 'p_cr_currency_code : '||p_cr_currency_code);
5004: arp_util.debug('Default_application_info: ' || 'p_customer_trx_id : '||to_char(p_customer_trx_id));
5005: arp_util.debug('Default_application_info: ' || 'p_installment : '||to_char(p_installment));
5006: arp_util.debug('Default_application_info: ' || 'p_show_closed_invoices : '||p_show_closed_invoices);
5007: arp_util.debug('Default_application_info: ' || 'p_customer_trx_line_id : '||to_char(p_customer_trx_line_id));
5008: arp_util.debug('Default_application_info: ' || 'p_trx_due_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5009: arp_util.debug('Default_application_info: ' || 'p_trx_currency_code : '||p_trx_currency_code);
5010: arp_util.debug('Default_application_info: ' || 'p_trx_gl_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5011: arp_util.debug('Default_application_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5004: arp_util.debug('Default_application_info: ' || 'p_customer_trx_id : '||to_char(p_customer_trx_id));
5005: arp_util.debug('Default_application_info: ' || 'p_installment : '||to_char(p_installment));
5006: arp_util.debug('Default_application_info: ' || 'p_show_closed_invoices : '||p_show_closed_invoices);
5007: arp_util.debug('Default_application_info: ' || 'p_customer_trx_line_id : '||to_char(p_customer_trx_line_id));
5008: arp_util.debug('Default_application_info: ' || 'p_trx_due_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5009: arp_util.debug('Default_application_info: ' || 'p_trx_currency_code : '||p_trx_currency_code);
5010: arp_util.debug('Default_application_info: ' || 'p_trx_gl_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5011: arp_util.debug('Default_application_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5012: arp_util.debug('Default_application_info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
5005: arp_util.debug('Default_application_info: ' || 'p_installment : '||to_char(p_installment));
5006: arp_util.debug('Default_application_info: ' || 'p_show_closed_invoices : '||p_show_closed_invoices);
5007: arp_util.debug('Default_application_info: ' || 'p_customer_trx_line_id : '||to_char(p_customer_trx_line_id));
5008: arp_util.debug('Default_application_info: ' || 'p_trx_due_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5009: arp_util.debug('Default_application_info: ' || 'p_trx_currency_code : '||p_trx_currency_code);
5010: arp_util.debug('Default_application_info: ' || 'p_trx_gl_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5011: arp_util.debug('Default_application_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5012: arp_util.debug('Default_application_info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
5013: arp_util.debug('Default_application_info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag);
5006: arp_util.debug('Default_application_info: ' || 'p_show_closed_invoices : '||p_show_closed_invoices);
5007: arp_util.debug('Default_application_info: ' || 'p_customer_trx_line_id : '||to_char(p_customer_trx_line_id));
5008: arp_util.debug('Default_application_info: ' || 'p_trx_due_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5009: arp_util.debug('Default_application_info: ' || 'p_trx_currency_code : '||p_trx_currency_code);
5010: arp_util.debug('Default_application_info: ' || 'p_trx_gl_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5011: arp_util.debug('Default_application_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5012: arp_util.debug('Default_application_info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
5013: arp_util.debug('Default_application_info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag);
5014: arp_util.debug('Default_application_info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
5007: arp_util.debug('Default_application_info: ' || 'p_customer_trx_line_id : '||to_char(p_customer_trx_line_id));
5008: arp_util.debug('Default_application_info: ' || 'p_trx_due_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5009: arp_util.debug('Default_application_info: ' || 'p_trx_currency_code : '||p_trx_currency_code);
5010: arp_util.debug('Default_application_info: ' || 'p_trx_gl_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5011: arp_util.debug('Default_application_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5012: arp_util.debug('Default_application_info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
5013: arp_util.debug('Default_application_info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag);
5014: arp_util.debug('Default_application_info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
5015: arp_util.debug('Default_application_info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
5008: arp_util.debug('Default_application_info: ' || 'p_trx_due_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5009: arp_util.debug('Default_application_info: ' || 'p_trx_currency_code : '||p_trx_currency_code);
5010: arp_util.debug('Default_application_info: ' || 'p_trx_gl_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5011: arp_util.debug('Default_application_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5012: arp_util.debug('Default_application_info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
5013: arp_util.debug('Default_application_info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag);
5014: arp_util.debug('Default_application_info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
5015: arp_util.debug('Default_application_info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
5016: arp_util.debug('Default_application_info: ' || 'p_creation_sign : '||p_creation_sign);
5009: arp_util.debug('Default_application_info: ' || 'p_trx_currency_code : '||p_trx_currency_code);
5010: arp_util.debug('Default_application_info: ' || 'p_trx_gl_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5011: arp_util.debug('Default_application_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5012: arp_util.debug('Default_application_info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
5013: arp_util.debug('Default_application_info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag);
5014: arp_util.debug('Default_application_info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
5015: arp_util.debug('Default_application_info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
5016: arp_util.debug('Default_application_info: ' || 'p_creation_sign : '||p_creation_sign);
5017: arp_util.debug('Default_application_info: ' || 'p_cr_payment_schedule_id : '||to_char(p_cr_payment_schedule_id));
5010: arp_util.debug('Default_application_info: ' || 'p_trx_gl_date : '||to_char(p_trx_due_date,'DD-MON-YYYY'));
5011: arp_util.debug('Default_application_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5012: arp_util.debug('Default_application_info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
5013: arp_util.debug('Default_application_info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag);
5014: arp_util.debug('Default_application_info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
5015: arp_util.debug('Default_application_info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
5016: arp_util.debug('Default_application_info: ' || 'p_creation_sign : '||p_creation_sign);
5017: arp_util.debug('Default_application_info: ' || 'p_cr_payment_schedule_id : '||to_char(p_cr_payment_schedule_id));
5018: arp_util.debug('Default_application_info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
5011: arp_util.debug('Default_application_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5012: arp_util.debug('Default_application_info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
5013: arp_util.debug('Default_application_info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag);
5014: arp_util.debug('Default_application_info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
5015: arp_util.debug('Default_application_info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
5016: arp_util.debug('Default_application_info: ' || 'p_creation_sign : '||p_creation_sign);
5017: arp_util.debug('Default_application_info: ' || 'p_cr_payment_schedule_id : '||to_char(p_cr_payment_schedule_id));
5018: arp_util.debug('Default_application_info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
5019: arp_util.debug('Default_application_info: ' || 'p_term_id : '||to_char(p_term_id));
5012: arp_util.debug('Default_application_info: ' || 'p_calc_discount_on_lines_flag : '||p_calc_discount_on_lines_flag);
5013: arp_util.debug('Default_application_info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag);
5014: arp_util.debug('Default_application_info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
5015: arp_util.debug('Default_application_info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
5016: arp_util.debug('Default_application_info: ' || 'p_creation_sign : '||p_creation_sign);
5017: arp_util.debug('Default_application_info: ' || 'p_cr_payment_schedule_id : '||to_char(p_cr_payment_schedule_id));
5018: arp_util.debug('Default_application_info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
5019: arp_util.debug('Default_application_info: ' || 'p_term_id : '||to_char(p_term_id));
5020: arp_util.debug('Default_application_info: ' || 'p_amount_due_original : '||to_char(p_amount_due_original));
5013: arp_util.debug('Default_application_info: ' || 'p_partial_discount_flag : '||p_partial_discount_flag);
5014: arp_util.debug('Default_application_info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
5015: arp_util.debug('Default_application_info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
5016: arp_util.debug('Default_application_info: ' || 'p_creation_sign : '||p_creation_sign);
5017: arp_util.debug('Default_application_info: ' || 'p_cr_payment_schedule_id : '||to_char(p_cr_payment_schedule_id));
5018: arp_util.debug('Default_application_info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
5019: arp_util.debug('Default_application_info: ' || 'p_term_id : '||to_char(p_term_id));
5020: arp_util.debug('Default_application_info: ' || 'p_amount_due_original : '||to_char(p_amount_due_original));
5021: arp_util.debug('Default_application_info: ' || 'p_amount_due_remaining : '||to_char(p_amount_due_remaining));
5014: arp_util.debug('Default_application_info: ' || 'p_allow_overappln_flag : '||p_allow_overappln_flag);
5015: arp_util.debug('Default_application_info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
5016: arp_util.debug('Default_application_info: ' || 'p_creation_sign : '||p_creation_sign);
5017: arp_util.debug('Default_application_info: ' || 'p_cr_payment_schedule_id : '||to_char(p_cr_payment_schedule_id));
5018: arp_util.debug('Default_application_info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
5019: arp_util.debug('Default_application_info: ' || 'p_term_id : '||to_char(p_term_id));
5020: arp_util.debug('Default_application_info: ' || 'p_amount_due_original : '||to_char(p_amount_due_original));
5021: arp_util.debug('Default_application_info: ' || 'p_amount_due_remaining : '||to_char(p_amount_due_remaining));
5022: arp_util.debug('Default_application_info: ' || 'p_trx_line_amount : '||to_char(p_trx_line_amount));
5015: arp_util.debug('Default_application_info: ' || 'p_natural_appln_only_flag : '||p_natural_appln_only_flag);
5016: arp_util.debug('Default_application_info: ' || 'p_creation_sign : '||p_creation_sign);
5017: arp_util.debug('Default_application_info: ' || 'p_cr_payment_schedule_id : '||to_char(p_cr_payment_schedule_id));
5018: arp_util.debug('Default_application_info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
5019: arp_util.debug('Default_application_info: ' || 'p_term_id : '||to_char(p_term_id));
5020: arp_util.debug('Default_application_info: ' || 'p_amount_due_original : '||to_char(p_amount_due_original));
5021: arp_util.debug('Default_application_info: ' || 'p_amount_due_remaining : '||to_char(p_amount_due_remaining));
5022: arp_util.debug('Default_application_info: ' || 'p_trx_line_amount : '||to_char(p_trx_line_amount));
5023: arp_util.debug('Default_application_info: ' || 'p_discount : '||to_char(p_discount));
5016: arp_util.debug('Default_application_info: ' || 'p_creation_sign : '||p_creation_sign);
5017: arp_util.debug('Default_application_info: ' || 'p_cr_payment_schedule_id : '||to_char(p_cr_payment_schedule_id));
5018: arp_util.debug('Default_application_info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
5019: arp_util.debug('Default_application_info: ' || 'p_term_id : '||to_char(p_term_id));
5020: arp_util.debug('Default_application_info: ' || 'p_amount_due_original : '||to_char(p_amount_due_original));
5021: arp_util.debug('Default_application_info: ' || 'p_amount_due_remaining : '||to_char(p_amount_due_remaining));
5022: arp_util.debug('Default_application_info: ' || 'p_trx_line_amount : '||to_char(p_trx_line_amount));
5023: arp_util.debug('Default_application_info: ' || 'p_discount : '||to_char(p_discount));
5024: arp_util.debug('Default_application_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5017: arp_util.debug('Default_application_info: ' || 'p_cr_payment_schedule_id : '||to_char(p_cr_payment_schedule_id));
5018: arp_util.debug('Default_application_info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
5019: arp_util.debug('Default_application_info: ' || 'p_term_id : '||to_char(p_term_id));
5020: arp_util.debug('Default_application_info: ' || 'p_amount_due_original : '||to_char(p_amount_due_original));
5021: arp_util.debug('Default_application_info: ' || 'p_amount_due_remaining : '||to_char(p_amount_due_remaining));
5022: arp_util.debug('Default_application_info: ' || 'p_trx_line_amount : '||to_char(p_trx_line_amount));
5023: arp_util.debug('Default_application_info: ' || 'p_discount : '||to_char(p_discount));
5024: arp_util.debug('Default_application_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5025: arp_util.debug('Default_application_info: ' || 'p_discount_max_allowed : '||to_char(p_discount_max_allowed));
5018: arp_util.debug('Default_application_info: ' || 'p_applied_payment_schedule_id : '||to_char(p_applied_payment_schedule_id));
5019: arp_util.debug('Default_application_info: ' || 'p_term_id : '||to_char(p_term_id));
5020: arp_util.debug('Default_application_info: ' || 'p_amount_due_original : '||to_char(p_amount_due_original));
5021: arp_util.debug('Default_application_info: ' || 'p_amount_due_remaining : '||to_char(p_amount_due_remaining));
5022: arp_util.debug('Default_application_info: ' || 'p_trx_line_amount : '||to_char(p_trx_line_amount));
5023: arp_util.debug('Default_application_info: ' || 'p_discount : '||to_char(p_discount));
5024: arp_util.debug('Default_application_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5025: arp_util.debug('Default_application_info: ' || 'p_discount_max_allowed : '||to_char(p_discount_max_allowed));
5026: arp_util.debug('Default_application_info: ' || 'p_discount_earned_allowed : '||to_char(p_discount_earned_allowed));
5019: arp_util.debug('Default_application_info: ' || 'p_term_id : '||to_char(p_term_id));
5020: arp_util.debug('Default_application_info: ' || 'p_amount_due_original : '||to_char(p_amount_due_original));
5021: arp_util.debug('Default_application_info: ' || 'p_amount_due_remaining : '||to_char(p_amount_due_remaining));
5022: arp_util.debug('Default_application_info: ' || 'p_trx_line_amount : '||to_char(p_trx_line_amount));
5023: arp_util.debug('Default_application_info: ' || 'p_discount : '||to_char(p_discount));
5024: arp_util.debug('Default_application_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5025: arp_util.debug('Default_application_info: ' || 'p_discount_max_allowed : '||to_char(p_discount_max_allowed));
5026: arp_util.debug('Default_application_info: ' || 'p_discount_earned_allowed : '||to_char(p_discount_earned_allowed));
5027: arp_util.debug('Default_application_info: ' || 'p_discount_earned : '||to_char(p_discount_earned));
5020: arp_util.debug('Default_application_info: ' || 'p_amount_due_original : '||to_char(p_amount_due_original));
5021: arp_util.debug('Default_application_info: ' || 'p_amount_due_remaining : '||to_char(p_amount_due_remaining));
5022: arp_util.debug('Default_application_info: ' || 'p_trx_line_amount : '||to_char(p_trx_line_amount));
5023: arp_util.debug('Default_application_info: ' || 'p_discount : '||to_char(p_discount));
5024: arp_util.debug('Default_application_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5025: arp_util.debug('Default_application_info: ' || 'p_discount_max_allowed : '||to_char(p_discount_max_allowed));
5026: arp_util.debug('Default_application_info: ' || 'p_discount_earned_allowed : '||to_char(p_discount_earned_allowed));
5027: arp_util.debug('Default_application_info: ' || 'p_discount_earned : '||to_char(p_discount_earned));
5028: arp_util.debug('Default_application_info: ' || 'p_discount_unearned : '||to_char(p_discount_unearned));
5021: arp_util.debug('Default_application_info: ' || 'p_amount_due_remaining : '||to_char(p_amount_due_remaining));
5022: arp_util.debug('Default_application_info: ' || 'p_trx_line_amount : '||to_char(p_trx_line_amount));
5023: arp_util.debug('Default_application_info: ' || 'p_discount : '||to_char(p_discount));
5024: arp_util.debug('Default_application_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5025: arp_util.debug('Default_application_info: ' || 'p_discount_max_allowed : '||to_char(p_discount_max_allowed));
5026: arp_util.debug('Default_application_info: ' || 'p_discount_earned_allowed : '||to_char(p_discount_earned_allowed));
5027: arp_util.debug('Default_application_info: ' || 'p_discount_earned : '||to_char(p_discount_earned));
5028: arp_util.debug('Default_application_info: ' || 'p_discount_unearned : '||to_char(p_discount_unearned));
5029: arp_util.debug('Default_application_info: ' || 'p_new_amount_due_remaining : '||to_char(p_new_amount_due_remaining));
5022: arp_util.debug('Default_application_info: ' || 'p_trx_line_amount : '||to_char(p_trx_line_amount));
5023: arp_util.debug('Default_application_info: ' || 'p_discount : '||to_char(p_discount));
5024: arp_util.debug('Default_application_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5025: arp_util.debug('Default_application_info: ' || 'p_discount_max_allowed : '||to_char(p_discount_max_allowed));
5026: arp_util.debug('Default_application_info: ' || 'p_discount_earned_allowed : '||to_char(p_discount_earned_allowed));
5027: arp_util.debug('Default_application_info: ' || 'p_discount_earned : '||to_char(p_discount_earned));
5028: arp_util.debug('Default_application_info: ' || 'p_discount_unearned : '||to_char(p_discount_unearned));
5029: arp_util.debug('Default_application_info: ' || 'p_new_amount_due_remaining : '||to_char(p_new_amount_due_remaining));
5030: arp_util.debug('Default_application_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5023: arp_util.debug('Default_application_info: ' || 'p_discount : '||to_char(p_discount));
5024: arp_util.debug('Default_application_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5025: arp_util.debug('Default_application_info: ' || 'p_discount_max_allowed : '||to_char(p_discount_max_allowed));
5026: arp_util.debug('Default_application_info: ' || 'p_discount_earned_allowed : '||to_char(p_discount_earned_allowed));
5027: arp_util.debug('Default_application_info: ' || 'p_discount_earned : '||to_char(p_discount_earned));
5028: arp_util.debug('Default_application_info: ' || 'p_discount_unearned : '||to_char(p_discount_unearned));
5029: arp_util.debug('Default_application_info: ' || 'p_new_amount_due_remaining : '||to_char(p_new_amount_due_remaining));
5030: arp_util.debug('Default_application_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5031: arp_util.debug('Default_application_info: ' || 'p_amount_applied_from : '||to_char(p_amount_applied_from));
5024: arp_util.debug('Default_application_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5025: arp_util.debug('Default_application_info: ' || 'p_discount_max_allowed : '||to_char(p_discount_max_allowed));
5026: arp_util.debug('Default_application_info: ' || 'p_discount_earned_allowed : '||to_char(p_discount_earned_allowed));
5027: arp_util.debug('Default_application_info: ' || 'p_discount_earned : '||to_char(p_discount_earned));
5028: arp_util.debug('Default_application_info: ' || 'p_discount_unearned : '||to_char(p_discount_unearned));
5029: arp_util.debug('Default_application_info: ' || 'p_new_amount_due_remaining : '||to_char(p_new_amount_due_remaining));
5030: arp_util.debug('Default_application_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5031: arp_util.debug('Default_application_info: ' || 'p_amount_applied_from : '||to_char(p_amount_applied_from));
5032: arp_util.debug('Default_application_info: ' || 'p_trans_to_receipt_rate : '||to_char(p_trans_to_receipt_rate));
5025: arp_util.debug('Default_application_info: ' || 'p_discount_max_allowed : '||to_char(p_discount_max_allowed));
5026: arp_util.debug('Default_application_info: ' || 'p_discount_earned_allowed : '||to_char(p_discount_earned_allowed));
5027: arp_util.debug('Default_application_info: ' || 'p_discount_earned : '||to_char(p_discount_earned));
5028: arp_util.debug('Default_application_info: ' || 'p_discount_unearned : '||to_char(p_discount_unearned));
5029: arp_util.debug('Default_application_info: ' || 'p_new_amount_due_remaining : '||to_char(p_new_amount_due_remaining));
5030: arp_util.debug('Default_application_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5031: arp_util.debug('Default_application_info: ' || 'p_amount_applied_from : '||to_char(p_amount_applied_from));
5032: arp_util.debug('Default_application_info: ' || 'p_trans_to_receipt_rate : '||to_char(p_trans_to_receipt_rate));
5033: arp_util.debug('Default_application_info: ' || '**********************************************************');
5026: arp_util.debug('Default_application_info: ' || 'p_discount_earned_allowed : '||to_char(p_discount_earned_allowed));
5027: arp_util.debug('Default_application_info: ' || 'p_discount_earned : '||to_char(p_discount_earned));
5028: arp_util.debug('Default_application_info: ' || 'p_discount_unearned : '||to_char(p_discount_unearned));
5029: arp_util.debug('Default_application_info: ' || 'p_new_amount_due_remaining : '||to_char(p_new_amount_due_remaining));
5030: arp_util.debug('Default_application_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5031: arp_util.debug('Default_application_info: ' || 'p_amount_applied_from : '||to_char(p_amount_applied_from));
5032: arp_util.debug('Default_application_info: ' || 'p_trans_to_receipt_rate : '||to_char(p_trans_to_receipt_rate));
5033: arp_util.debug('Default_application_info: ' || '**********************************************************');
5034: arp_util.debug('Default_application_info ()-');
5027: arp_util.debug('Default_application_info: ' || 'p_discount_earned : '||to_char(p_discount_earned));
5028: arp_util.debug('Default_application_info: ' || 'p_discount_unearned : '||to_char(p_discount_unearned));
5029: arp_util.debug('Default_application_info: ' || 'p_new_amount_due_remaining : '||to_char(p_new_amount_due_remaining));
5030: arp_util.debug('Default_application_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5031: arp_util.debug('Default_application_info: ' || 'p_amount_applied_from : '||to_char(p_amount_applied_from));
5032: arp_util.debug('Default_application_info: ' || 'p_trans_to_receipt_rate : '||to_char(p_trans_to_receipt_rate));
5033: arp_util.debug('Default_application_info: ' || '**********************************************************');
5034: arp_util.debug('Default_application_info ()-');
5035: END IF;
5028: arp_util.debug('Default_application_info: ' || 'p_discount_unearned : '||to_char(p_discount_unearned));
5029: arp_util.debug('Default_application_info: ' || 'p_new_amount_due_remaining : '||to_char(p_new_amount_due_remaining));
5030: arp_util.debug('Default_application_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5031: arp_util.debug('Default_application_info: ' || 'p_amount_applied_from : '||to_char(p_amount_applied_from));
5032: arp_util.debug('Default_application_info: ' || 'p_trans_to_receipt_rate : '||to_char(p_trans_to_receipt_rate));
5033: arp_util.debug('Default_application_info: ' || '**********************************************************');
5034: arp_util.debug('Default_application_info ()-');
5035: END IF;
5036: END Default_application_info;
5029: arp_util.debug('Default_application_info: ' || 'p_new_amount_due_remaining : '||to_char(p_new_amount_due_remaining));
5030: arp_util.debug('Default_application_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5031: arp_util.debug('Default_application_info: ' || 'p_amount_applied_from : '||to_char(p_amount_applied_from));
5032: arp_util.debug('Default_application_info: ' || 'p_trans_to_receipt_rate : '||to_char(p_trans_to_receipt_rate));
5033: arp_util.debug('Default_application_info: ' || '**********************************************************');
5034: arp_util.debug('Default_application_info ()-');
5035: END IF;
5036: END Default_application_info;
5037:
5030: arp_util.debug('Default_application_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5031: arp_util.debug('Default_application_info: ' || 'p_amount_applied_from : '||to_char(p_amount_applied_from));
5032: arp_util.debug('Default_application_info: ' || 'p_trans_to_receipt_rate : '||to_char(p_trans_to_receipt_rate));
5033: arp_util.debug('Default_application_info: ' || '**********************************************************');
5034: arp_util.debug('Default_application_info ()-');
5035: END IF;
5036: END Default_application_info;
5037:
5038: FUNCTION Get_trx_ps_id(p_customer_trx_id IN OUT NOCOPY NUMBER,
5042: ) RETURN NUMBER IS
5043: l_trx_ps_id NUMBER;
5044: BEGIN
5045: IF PG_DEBUG in ('Y', 'C') THEN
5046: arp_util.debug('Get_trx_ps_id ()+');
5047: END IF;
5048: p_return_status := FND_API.G_RET_STS_SUCCESS;
5049:
5050: IF p_called_from IN ('BR_REMITTED',
5162: END IF;
5163:
5164: RETURN(l_trx_ps_id);
5165: IF PG_DEBUG in ('Y', 'C') THEN
5166: arp_util.debug('Get_trx_ps_id ()-');
5167: END IF;
5168: EXCEPTION
5169: WHEN others THEN
5170: IF PG_DEBUG in ('Y', 'C') THEN
5167: END IF;
5168: EXCEPTION
5169: WHEN others THEN
5170: IF PG_DEBUG in ('Y', 'C') THEN
5171: arp_util.debug('EXCEPTION: Get_trx_ps_id()');
5172: END IF;
5173: raise;
5174: END Get_trx_ps_id;
5175:
5183: ) IS
5184:
5185: BEGIN
5186: IF PG_DEBUG in ('Y', 'C') THEN
5187: arp_util.debug('Derive_receivable_appln_id ()+');
5188: END IF;
5189: p_return_status := FND_API.G_RET_STS_SUCCESS;
5190: IF p_cash_receipt_id IS NOT NULL AND
5191: p_applied_payment_schedule_id IS NOT NULL
5202: AND ra.application_type = 'CASH';
5203:
5204: END IF;
5205: IF PG_DEBUG in ('Y', 'C') THEN
5206: arp_util.debug('Derive_receivable_appln_id ()+');
5207: END IF;
5208: EXCEPTION
5209: WHEN no_data_found THEN
5210: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_NOT_APP_TO_INV');
5211: FND_MSG_PUB.Add;
5212: p_return_status := FND_API.G_RET_STS_ERROR;
5213: WHEN others THEN
5214: IF PG_DEBUG in ('Y', 'C') THEN
5215: arp_util.debug('Derive_receivable_appln_id: ' || 'EXCEPTION: Get_receivable_application_id()');
5216: END IF;
5217: raise;
5218: END Derive_receivable_appln_id;
5219:
5239: AND ps.class IN ('CB','CM','DEP','DM','INV','BR');
5240:
5241: BEGIN
5242: IF PG_DEBUG in ('Y', 'C') THEN
5243: arp_util.debug('Get_payment_schedule_info ()+');
5244: END IF;
5245: p_return_status := FND_API.G_RET_STS_SUCCESS;
5246:
5247: IF p_called_from IN ('BR_REMITTED',
5272:
5273: END IF;
5274:
5275: IF PG_DEBUG in ('Y', 'C') THEN
5276: arp_util.debug('Get_payment_schedule_info ()-');
5277: END IF;
5278: END Get_payment_schedule_info;
5279:
5280: PROCEDURE Get_receivable_appln_info(
5307: AND ra.status = 'APP';
5308:
5309: BEGIN
5310: IF PG_DEBUG in ('Y', 'C') THEN
5311: arp_util.debug('Get_receivable_appln_info ()+');
5312: END IF;
5313:
5314: p_return_status := FND_API.G_RET_STS_SUCCESS;
5315:
5338:
5339: END IF;
5340:
5341: IF PG_DEBUG in ('Y', 'C') THEN
5342: arp_util.debug('Get_receivable_appln_info ()-');
5343: END IF;
5344: END Get_receivable_appln_info;
5345:
5346: PROCEDURE Derive_unapp_ids(
5368: l_ra_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5369: l_cr_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5370: BEGIN
5371: IF PG_DEBUG in ('Y', 'C') THEN
5372: arp_util.debug('Derive_unapp_ids ()+');
5373: END IF;
5374: p_return_status := FND_API.G_RET_STS_SUCCESS ;
5375:
5376: -- First get a valid value for the customer_trx_id
5512: THEN
5513: p_return_status := FND_API.G_RET_STS_ERROR;
5514: END IF;
5515: IF PG_DEBUG in ('Y', 'C') THEN
5516: arp_util.debug('Derive_unapp_ids: ' || '****Defaulted Value for the unapplication ids****');
5517: arp_util.debug('Derive_unapp_ids: ' || 'p_cash_receipt_id :'||to_char(p_cash_receipt_id));
5518: arp_util.debug('Derive_unapp_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
5519: arp_util.debug('Derive_unapp_ids: ' || 'p_installment :'||to_char(p_installment));
5520: arp_util.debug('Derive_unapp_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
5513: p_return_status := FND_API.G_RET_STS_ERROR;
5514: END IF;
5515: IF PG_DEBUG in ('Y', 'C') THEN
5516: arp_util.debug('Derive_unapp_ids: ' || '****Defaulted Value for the unapplication ids****');
5517: arp_util.debug('Derive_unapp_ids: ' || 'p_cash_receipt_id :'||to_char(p_cash_receipt_id));
5518: arp_util.debug('Derive_unapp_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
5519: arp_util.debug('Derive_unapp_ids: ' || 'p_installment :'||to_char(p_installment));
5520: arp_util.debug('Derive_unapp_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
5521: arp_util.debug('Derive_unapp_ids: ' || 'p_receivable_application_id :'||to_char(p_receivable_application_id));
5514: END IF;
5515: IF PG_DEBUG in ('Y', 'C') THEN
5516: arp_util.debug('Derive_unapp_ids: ' || '****Defaulted Value for the unapplication ids****');
5517: arp_util.debug('Derive_unapp_ids: ' || 'p_cash_receipt_id :'||to_char(p_cash_receipt_id));
5518: arp_util.debug('Derive_unapp_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
5519: arp_util.debug('Derive_unapp_ids: ' || 'p_installment :'||to_char(p_installment));
5520: arp_util.debug('Derive_unapp_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
5521: arp_util.debug('Derive_unapp_ids: ' || 'p_receivable_application_id :'||to_char(p_receivable_application_id));
5522: arp_util.debug('Derive_unapp_ids: ' || 'Return Status :'||p_return_status);
5515: IF PG_DEBUG in ('Y', 'C') THEN
5516: arp_util.debug('Derive_unapp_ids: ' || '****Defaulted Value for the unapplication ids****');
5517: arp_util.debug('Derive_unapp_ids: ' || 'p_cash_receipt_id :'||to_char(p_cash_receipt_id));
5518: arp_util.debug('Derive_unapp_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
5519: arp_util.debug('Derive_unapp_ids: ' || 'p_installment :'||to_char(p_installment));
5520: arp_util.debug('Derive_unapp_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
5521: arp_util.debug('Derive_unapp_ids: ' || 'p_receivable_application_id :'||to_char(p_receivable_application_id));
5522: arp_util.debug('Derive_unapp_ids: ' || 'Return Status :'||p_return_status);
5523: arp_util.debug('Derive_unapp_ids ()-');
5516: arp_util.debug('Derive_unapp_ids: ' || '****Defaulted Value for the unapplication ids****');
5517: arp_util.debug('Derive_unapp_ids: ' || 'p_cash_receipt_id :'||to_char(p_cash_receipt_id));
5518: arp_util.debug('Derive_unapp_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
5519: arp_util.debug('Derive_unapp_ids: ' || 'p_installment :'||to_char(p_installment));
5520: arp_util.debug('Derive_unapp_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
5521: arp_util.debug('Derive_unapp_ids: ' || 'p_receivable_application_id :'||to_char(p_receivable_application_id));
5522: arp_util.debug('Derive_unapp_ids: ' || 'Return Status :'||p_return_status);
5523: arp_util.debug('Derive_unapp_ids ()-');
5524: END IF;
5517: arp_util.debug('Derive_unapp_ids: ' || 'p_cash_receipt_id :'||to_char(p_cash_receipt_id));
5518: arp_util.debug('Derive_unapp_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
5519: arp_util.debug('Derive_unapp_ids: ' || 'p_installment :'||to_char(p_installment));
5520: arp_util.debug('Derive_unapp_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
5521: arp_util.debug('Derive_unapp_ids: ' || 'p_receivable_application_id :'||to_char(p_receivable_application_id));
5522: arp_util.debug('Derive_unapp_ids: ' || 'Return Status :'||p_return_status);
5523: arp_util.debug('Derive_unapp_ids ()-');
5524: END IF;
5525: EXCEPTION
5518: arp_util.debug('Derive_unapp_ids: ' || 'p_customer_trx_id :'||to_char(p_customer_trx_id));
5519: arp_util.debug('Derive_unapp_ids: ' || 'p_installment :'||to_char(p_installment));
5520: arp_util.debug('Derive_unapp_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
5521: arp_util.debug('Derive_unapp_ids: ' || 'p_receivable_application_id :'||to_char(p_receivable_application_id));
5522: arp_util.debug('Derive_unapp_ids: ' || 'Return Status :'||p_return_status);
5523: arp_util.debug('Derive_unapp_ids ()-');
5524: END IF;
5525: EXCEPTION
5526: WHEN others THEN
5519: arp_util.debug('Derive_unapp_ids: ' || 'p_installment :'||to_char(p_installment));
5520: arp_util.debug('Derive_unapp_ids: ' || 'p_applied_payment_schedule_id :'||to_char(p_applied_payment_schedule_id));
5521: arp_util.debug('Derive_unapp_ids: ' || 'p_receivable_application_id :'||to_char(p_receivable_application_id));
5522: arp_util.debug('Derive_unapp_ids: ' || 'Return Status :'||p_return_status);
5523: arp_util.debug('Derive_unapp_ids ()-');
5524: END IF;
5525: EXCEPTION
5526: WHEN others THEN
5527: IF PG_DEBUG in ('Y', 'C') THEN
5524: END IF;
5525: EXCEPTION
5526: WHEN others THEN
5527: IF PG_DEBUG in ('Y', 'C') THEN
5528: arp_util.debug('EXCEPTION: Derive_unapp_ids()');
5529: END IF;
5530: raise;
5531: END Derive_unapp_ids;
5532:
5542: l_defaulting_rule_used VARCHAR2(100);
5543: l_error_message VARCHAR2(240);
5544: BEGIN
5545: IF PG_DEBUG in ('Y', 'C') THEN
5546: arp_util.debug('Default_reversal_gl_date ()+');
5547: END IF;
5548: l_apply_gl_date := p_apply_gl_date; /* Bug fix 3503167 */
5549:
5550: IF p_receivable_application_id IS NOT NULL THEN
5558: END IF;
5559: /* Bug fix 3503167 : We need to pass the apply_gl_date as the candidate gl_date and
5560: as the validation date */
5561: IF p_reversal_gl_date is null THEN
5562: IF (arp_util.validate_and_default_gl_date(
5563: nvl(l_apply_gl_date,trunc(sysdate)),
5564: NULL,
5565: l_apply_gl_date,
5566: NULL,
5587: END IF;
5588: END IF;
5589: END IF;
5590: IF PG_DEBUG in ('Y', 'C') THEN
5591: arp_util.debug('Default_reversal_gl_date ()-');
5592: END IF;
5593: EXCEPTION
5594: When others THEN
5595: IF PG_DEBUG in ('Y', 'C') THEN
5592: END IF;
5593: EXCEPTION
5594: When others THEN
5595: IF PG_DEBUG in ('Y', 'C') THEN
5596: arp_util.debug('EXCEPTION: Default_reversal_gl_date()');
5597: END IF;
5598: raise;
5599: END Default_reversal_gl_date;
5600:
5610: l_cash_receipt_id NUMBER(15);
5611: l_apply_gl_date DATE;
5612: BEGIN
5613: IF PG_DEBUG in ('Y', 'C') THEN
5614: arp_util.debug('Default_unapp_info ()+');
5615: END IF;
5616: l_apply_gl_date := p_apply_gl_date;
5617: l_cash_receipt_id := p_cash_receipt_id;
5618:
5644: EXCEPTION
5645: WHEN no_data_found THEN
5646: null;
5647: IF PG_DEBUG in ('Y', 'C') THEN
5648: arp_util.debug('Default_unapp_info: ' || 'Could not get the receipt_gl_date. ');
5649: END IF;
5650: END;
5651: END IF;
5652: IF PG_DEBUG in ('Y', 'C') THEN
5649: END IF;
5650: END;
5651: END IF;
5652: IF PG_DEBUG in ('Y', 'C') THEN
5653: arp_util.debug('Default_unapp_info ()-');
5654: END IF;
5655: END Default_unapp_info;
5656:
5657: PROCEDURE Default_rev_catg_code(p_reversal_category_code IN OUT NOCOPY VARCHAR2,
5660: ) IS
5661:
5662: BEGIN
5663: IF PG_DEBUG in ('Y', 'C') THEN
5664: arp_util.debug('Default_rev_catg_code ()+');
5665: END IF;
5666:
5667: p_return_status := FND_API.G_RET_STS_SUCCESS;
5668:
5692: END IF;
5693: END IF;
5694: END IF;
5695: IF PG_DEBUG in ('Y', 'C') THEN
5696: arp_util.debug('Default_rev_catg_code ()-');
5697: END IF;
5698: EXCEPTION
5699: WHEN others THEN
5700: IF PG_DEBUG in ('Y', 'C') THEN
5697: END IF;
5698: EXCEPTION
5699: WHEN others THEN
5700: IF PG_DEBUG in ('Y', 'C') THEN
5701: arp_util.debug('EXCEPTION: Default_rev_catg_code()');
5702: END IF;
5703: raise;
5704: END Default_rev_catg_code;
5705:
5710: ) IS
5711:
5712: BEGIN
5713: IF PG_DEBUG in ('Y', 'C') THEN
5714: arp_util.debug('Default_rev_reason_code ()+');
5715: END IF;
5716:
5717: p_return_status := FND_API.G_RET_STS_SUCCESS;
5718:
5742: END IF;
5743: END IF;
5744: END IF;
5745: IF PG_DEBUG in ('Y', 'C') THEN
5746: arp_util.debug('Default_rev_reason_code ()-');
5747: END IF;
5748: EXCEPTION
5749: WHEN others THEN
5750: IF PG_DEBUG in ('Y', 'C') THEN
5747: END IF;
5748: EXCEPTION
5749: WHEN others THEN
5750: IF PG_DEBUG in ('Y', 'C') THEN
5751: arp_util.debug('EXCEPTION: Default_rev_reason_code()');
5752: END IF;
5753: raise;
5754: END Default_rev_reason_code;
5755:
5766: l_rev_cat_return_status VARCHAR2(1);
5767: l_rev_res_return_status VARCHAR2(1);
5768: BEGIN
5769: IF PG_DEBUG in ('Y', 'C') THEN
5770: arp_util.debug('Derive_reverse_ids ()+ ');
5771: END IF;
5772: p_return_status := FND_API.G_RET_STS_SUCCESS ;
5773:
5774:
5776: Default_cash_receipt_id(p_cash_receipt_id ,
5777: p_receipt_number ,
5778: l_cr_def_return_status);
5779: IF PG_DEBUG in ('Y', 'C') THEN
5780: arp_util.debug('Derive_reverse_ids: ' || 'l_cr_def__return_status :'||l_cr_def_return_status);
5781: END IF;
5782:
5783: --reversal category
5784: Default_rev_catg_code(p_reversal_category_code,
5785: p_reversal_category_name,
5786: l_rev_cat_return_status
5787: );
5788: IF PG_DEBUG in ('Y', 'C') THEN
5789: arp_util.debug('Derive_reverse_ids: ' || 'l_rev_cat_return_status :'||l_rev_cat_return_status);
5790: END IF;
5791:
5792: --reversal reason code
5793: Default_rev_reason_code(p_reversal_reason_code,
5802: p_return_status := FND_API.G_RET_STS_ERROR ;
5803: END IF;
5804:
5805: IF PG_DEBUG in ('Y', 'C') THEN
5806: arp_util.debug('Derive_reverse_ids ()- ');
5807: END IF;
5808: EXCEPTION
5809: When others THEN
5810: IF PG_DEBUG in ('Y', 'C') THEN
5807: END IF;
5808: EXCEPTION
5809: When others THEN
5810: IF PG_DEBUG in ('Y', 'C') THEN
5811: arp_util.debug('EXCEPTION: Derive_reverse_ids()');
5812: END IF;
5813: END Derive_reverse_ids;
5814:
5815: PROCEDURE Default_reverse_info(p_cash_receipt_id IN NUMBER,
5822: l_receipt_date DATE;
5823: l_return_status VARCHAR2(1);
5824: BEGIN
5825: IF PG_DEBUG in ('Y', 'C') THEN
5826: arp_util.debug('Default_reverse_info ()+');
5827: END IF;
5828: /*Get the receipt date and the status */
5829:
5830: SELECT cr.receipt_date, crh.status, cr.type
5864: l_return_status);
5865: END IF;
5866:
5867: IF PG_DEBUG in ('Y', 'C') THEN
5868: arp_util.debug('Default_reverse_info: ' || '**************Defaulted Variables ************');
5869: arp_util.debug('Default_reverse_info: ' || 'p_reversal_gl_date : '||to_char(p_reversal_gl_date,'DD-MON-YYYY'));
5870: arp_util.debug('Default_reverse_info: ' || 'p_reversal_date : '||to_char(p_reversal_date,'DD-MON-YYYY'));
5871: arp_util.debug('Default_reverse_info: ' || 'p_receipt_state : '||p_receipt_state);
5872: arp_util.debug('Default_reverse_info: ' || 'p_receipt_gl_date : '||to_char(p_receipt_gl_date,'DD-MON-YYYY'));
5865: END IF;
5866:
5867: IF PG_DEBUG in ('Y', 'C') THEN
5868: arp_util.debug('Default_reverse_info: ' || '**************Defaulted Variables ************');
5869: arp_util.debug('Default_reverse_info: ' || 'p_reversal_gl_date : '||to_char(p_reversal_gl_date,'DD-MON-YYYY'));
5870: arp_util.debug('Default_reverse_info: ' || 'p_reversal_date : '||to_char(p_reversal_date,'DD-MON-YYYY'));
5871: arp_util.debug('Default_reverse_info: ' || 'p_receipt_state : '||p_receipt_state);
5872: arp_util.debug('Default_reverse_info: ' || 'p_receipt_gl_date : '||to_char(p_receipt_gl_date,'DD-MON-YYYY'));
5873: arp_util.debug('Default_reverse_info ()-');
5866:
5867: IF PG_DEBUG in ('Y', 'C') THEN
5868: arp_util.debug('Default_reverse_info: ' || '**************Defaulted Variables ************');
5869: arp_util.debug('Default_reverse_info: ' || 'p_reversal_gl_date : '||to_char(p_reversal_gl_date,'DD-MON-YYYY'));
5870: arp_util.debug('Default_reverse_info: ' || 'p_reversal_date : '||to_char(p_reversal_date,'DD-MON-YYYY'));
5871: arp_util.debug('Default_reverse_info: ' || 'p_receipt_state : '||p_receipt_state);
5872: arp_util.debug('Default_reverse_info: ' || 'p_receipt_gl_date : '||to_char(p_receipt_gl_date,'DD-MON-YYYY'));
5873: arp_util.debug('Default_reverse_info ()-');
5874: END IF;
5867: IF PG_DEBUG in ('Y', 'C') THEN
5868: arp_util.debug('Default_reverse_info: ' || '**************Defaulted Variables ************');
5869: arp_util.debug('Default_reverse_info: ' || 'p_reversal_gl_date : '||to_char(p_reversal_gl_date,'DD-MON-YYYY'));
5870: arp_util.debug('Default_reverse_info: ' || 'p_reversal_date : '||to_char(p_reversal_date,'DD-MON-YYYY'));
5871: arp_util.debug('Default_reverse_info: ' || 'p_receipt_state : '||p_receipt_state);
5872: arp_util.debug('Default_reverse_info: ' || 'p_receipt_gl_date : '||to_char(p_receipt_gl_date,'DD-MON-YYYY'));
5873: arp_util.debug('Default_reverse_info ()-');
5874: END IF;
5875: EXCEPTION
5868: arp_util.debug('Default_reverse_info: ' || '**************Defaulted Variables ************');
5869: arp_util.debug('Default_reverse_info: ' || 'p_reversal_gl_date : '||to_char(p_reversal_gl_date,'DD-MON-YYYY'));
5870: arp_util.debug('Default_reverse_info: ' || 'p_reversal_date : '||to_char(p_reversal_date,'DD-MON-YYYY'));
5871: arp_util.debug('Default_reverse_info: ' || 'p_receipt_state : '||p_receipt_state);
5872: arp_util.debug('Default_reverse_info: ' || 'p_receipt_gl_date : '||to_char(p_receipt_gl_date,'DD-MON-YYYY'));
5873: arp_util.debug('Default_reverse_info ()-');
5874: END IF;
5875: EXCEPTION
5876: WHEN no_data_found THEN
5869: arp_util.debug('Default_reverse_info: ' || 'p_reversal_gl_date : '||to_char(p_reversal_gl_date,'DD-MON-YYYY'));
5870: arp_util.debug('Default_reverse_info: ' || 'p_reversal_date : '||to_char(p_reversal_date,'DD-MON-YYYY'));
5871: arp_util.debug('Default_reverse_info: ' || 'p_receipt_state : '||p_receipt_state);
5872: arp_util.debug('Default_reverse_info: ' || 'p_receipt_gl_date : '||to_char(p_receipt_gl_date,'DD-MON-YYYY'));
5873: arp_util.debug('Default_reverse_info ()-');
5874: END IF;
5875: EXCEPTION
5876: WHEN no_data_found THEN
5877: --this may happen because of the invalid cash_receipt_id
5877: --this may happen because of the invalid cash_receipt_id
5878: --do not raise any message here, it shall be raised in the
5879: --validation phase.
5880: IF PG_DEBUG in ('Y', 'C') THEN
5881: arp_util.debug('Default_reverse_info: ' || 'Could not default info :Cash Receipt Id is invalid');
5882: END IF;
5883: WHEN others THEN
5884: IF PG_DEBUG in ('Y', 'C') THEN
5885: arp_util.debug('EXCEPTION: Default_reverse_info() ');
5881: arp_util.debug('Default_reverse_info: ' || 'Could not default info :Cash Receipt Id is invalid');
5882: END IF;
5883: WHEN others THEN
5884: IF PG_DEBUG in ('Y', 'C') THEN
5885: arp_util.debug('EXCEPTION: Default_reverse_info() ');
5886: END IF;
5887: raise;
5888: END Default_reverse_info;
5889:
5912: l_remit_bank_acct_use_id NUMBER;
5913: l_receipt_method_id NUMBER;
5914: BEGIN
5915: IF PG_DEBUG in ('Y', 'C') THEN
5916: arp_util.debug('Default_on_ac_app_info ()+');
5917: END IF;
5918: p_return_status := FND_API.G_RET_STS_SUCCESS;
5919:
5920: Default_Receipt_Info(
5932: l_receipt_method_id,
5933: l_receipt_return_status
5934: );
5935: IF PG_DEBUG in ('Y', 'C') THEN
5936: arp_util.debug('Default_on_ac_app_info: ' || 'Receipt defaulting return status :'||l_receipt_return_status);
5937: END IF;
5938: Default_apply_date(l_receipt_date ,
5939: null,
5940: p_apply_date);
5945: NULL,
5946: l_gl_date_return_status);
5947: END IF;
5948: IF PG_DEBUG in ('Y', 'C') THEN
5949: arp_util.debug('Default_on_ac_app_info: ' || 'Defaulting apply gl date return status :'|| l_gl_date_return_status);
5950: END IF;
5951:
5952: --default the amount applied
5953: IF p_amount_applied IS NULL THEN
5953: IF p_amount_applied IS NULL THEN
5954: p_amount_applied := l_cr_unapp_amount;
5955: END IF;
5956: --do the precision
5957: p_amount_applied := arp_util.CurrRound(
5958: p_amount_applied,
5959: l_cr_currency_code
5960: );
5961:
5970:
5971: p_cr_currency_code := l_cr_currency_code;
5972:
5973: IF PG_DEBUG in ('Y', 'C') THEN
5974: arp_util.debug('Default_on_ac_app_info: ' || '***************Default Values *****************');
5975: arp_util.debug('Default_on_ac_app_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
5976: arp_util.debug('Default_on_ac_app_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5977: arp_util.debug('Default_on_ac_app_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5978: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5971: p_cr_currency_code := l_cr_currency_code;
5972:
5973: IF PG_DEBUG in ('Y', 'C') THEN
5974: arp_util.debug('Default_on_ac_app_info: ' || '***************Default Values *****************');
5975: arp_util.debug('Default_on_ac_app_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
5976: arp_util.debug('Default_on_ac_app_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5977: arp_util.debug('Default_on_ac_app_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5978: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5979: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5972:
5973: IF PG_DEBUG in ('Y', 'C') THEN
5974: arp_util.debug('Default_on_ac_app_info: ' || '***************Default Values *****************');
5975: arp_util.debug('Default_on_ac_app_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
5976: arp_util.debug('Default_on_ac_app_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5977: arp_util.debug('Default_on_ac_app_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5978: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5979: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5980: arp_util.debug('Default_on_ac_app_info ()-');
5973: IF PG_DEBUG in ('Y', 'C') THEN
5974: arp_util.debug('Default_on_ac_app_info: ' || '***************Default Values *****************');
5975: arp_util.debug('Default_on_ac_app_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
5976: arp_util.debug('Default_on_ac_app_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5977: arp_util.debug('Default_on_ac_app_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5978: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5979: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5980: arp_util.debug('Default_on_ac_app_info ()-');
5981: END IF;
5974: arp_util.debug('Default_on_ac_app_info: ' || '***************Default Values *****************');
5975: arp_util.debug('Default_on_ac_app_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
5976: arp_util.debug('Default_on_ac_app_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5977: arp_util.debug('Default_on_ac_app_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5978: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5979: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5980: arp_util.debug('Default_on_ac_app_info ()-');
5981: END IF;
5982: EXCEPTION
5975: arp_util.debug('Default_on_ac_app_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
5976: arp_util.debug('Default_on_ac_app_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5977: arp_util.debug('Default_on_ac_app_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5978: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5979: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5980: arp_util.debug('Default_on_ac_app_info ()-');
5981: END IF;
5982: EXCEPTION
5983: WHEN others THEN
5976: arp_util.debug('Default_on_ac_app_info: ' || 'p_cr_gl_date : '||to_char(p_cr_gl_date,'DD-MON-YYYY'));
5977: arp_util.debug('Default_on_ac_app_info: ' || 'p_amount_applied : '||to_char(p_amount_applied));
5978: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
5979: arp_util.debug('Default_on_ac_app_info: ' || 'p_apply_date : '||to_char(p_apply_date,'DD-MON-YYYY'));
5980: arp_util.debug('Default_on_ac_app_info ()-');
5981: END IF;
5982: EXCEPTION
5983: WHEN others THEN
5984: IF PG_DEBUG in ('Y', 'C') THEN
5981: END IF;
5982: EXCEPTION
5983: WHEN others THEN
5984: IF PG_DEBUG in ('Y', 'C') THEN
5985: arp_util.debug('EXCEPTION: Default_on_ac_app_info() ');
5986: END IF;
5987: raise;
5988: END Default_on_ac_app_info;
5989:
5999: l_cash_receipt_id NUMBER;
6000: BEGIN
6001: p_return_status := FND_API.G_RET_STS_SUCCESS;
6002: IF PG_DEBUG in ('Y', 'C') THEN
6003: arp_util.debug('Derive_unapp_on_ac_ids ()+');
6004: END IF;
6005: --derive the cash_receipt_id from the receipt_number
6006: IF p_receipt_number IS NOT NULL THEN
6007: Default_cash_receipt_id(p_cash_receipt_id ,
6071: p_cash_receipt_id := l_cash_receipt_id;
6072: END IF;
6073:
6074: IF PG_DEBUG in ('Y', 'C') THEN
6075: arp_util.debug('Derive_unapp_on_ac_ids ()+');
6076: END IF;
6077: END Derive_unapp_on_ac_ids;
6078:
6079: PROCEDURE Derive_otheraccount_ids(
6092:
6093: BEGIN
6094: p_return_status := FND_API.G_RET_STS_SUCCESS;
6095: IF PG_DEBUG in ('Y', 'C') THEN
6096: arp_util.debug('Derive_otheraccount_ids ()+');
6097: END IF;
6098: --derive the cash_receipt_id from the receipt_number
6099: IF p_receipt_number IS NOT NULL THEN
6100: Default_cash_receipt_id(p_cash_receipt_id ,
6176: AND ra.status = 'UNAPP'
6177: AND nvl(ra.confirmed_flag,'Y') = 'Y';
6178: END IF;
6179: IF PG_DEBUG in ('Y', 'C') THEN
6180: arp_util.debug('Derive_otheraccount_ids: ' || 'Derive_unapp_on_ac_ids ()+');
6181: END IF;
6182: END Derive_otheraccount_ids;
6183:
6184: PROCEDURE Default_unapp_on_ac_act_info(
6195: l_defaulting_rule_used VARCHAR2(100);
6196: l_error_message VARCHAR2(240);
6197: BEGIN
6198: IF PG_DEBUG in ('Y', 'C') THEN
6199: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'Default_unapp_on_acc_act_info ()+');
6200: END IF;
6201: l_apply_gl_date := p_apply_gl_date;
6202:
6203: /* Bug fix 3503167 : We need to pass the apply_gl_date as the candidate gl_date and
6202:
6203: /* Bug fix 3503167 : We need to pass the apply_gl_date as the candidate gl_date and
6204: as the validation date */
6205: IF p_reversal_gl_date is null THEN
6206: IF (arp_util.validate_and_default_gl_date(
6207: nvl(l_apply_gl_date,trunc(sysdate)),
6208: NULL,
6209: l_apply_gl_date,
6210: NULL,
6245: EXCEPTION
6246: WHEN no_data_found THEN
6247: null;
6248: IF PG_DEBUG in ('Y', 'C') THEN
6249: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'Could not get the receipt_gl_date. ');
6250: END IF;
6251: END;
6252: END IF;
6253: IF PG_DEBUG in ('Y', 'C') THEN
6250: END IF;
6251: END;
6252: END IF;
6253: IF PG_DEBUG in ('Y', 'C') THEN
6254: arp_util.debug('Default_unapp_on_ac_act_info: ' || '*****Defaulted Values *********');
6255: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
6256: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_receivable_application_id : '||to_char(p_receivable_application_id));
6257: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
6258: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_reversal_gl_date : '||to_char(p_reversal_gl_date,'DD-MON-YYYY'));
6251: END;
6252: END IF;
6253: IF PG_DEBUG in ('Y', 'C') THEN
6254: arp_util.debug('Default_unapp_on_ac_act_info: ' || '*****Defaulted Values *********');
6255: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
6256: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_receivable_application_id : '||to_char(p_receivable_application_id));
6257: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
6258: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_reversal_gl_date : '||to_char(p_reversal_gl_date,'DD-MON-YYYY'));
6259: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'Default_unapp_on_acc_act_info ()-');
6252: END IF;
6253: IF PG_DEBUG in ('Y', 'C') THEN
6254: arp_util.debug('Default_unapp_on_ac_act_info: ' || '*****Defaulted Values *********');
6255: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
6256: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_receivable_application_id : '||to_char(p_receivable_application_id));
6257: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
6258: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_reversal_gl_date : '||to_char(p_reversal_gl_date,'DD-MON-YYYY'));
6259: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'Default_unapp_on_acc_act_info ()-');
6260: END IF;
6253: IF PG_DEBUG in ('Y', 'C') THEN
6254: arp_util.debug('Default_unapp_on_ac_act_info: ' || '*****Defaulted Values *********');
6255: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
6256: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_receivable_application_id : '||to_char(p_receivable_application_id));
6257: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
6258: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_reversal_gl_date : '||to_char(p_reversal_gl_date,'DD-MON-YYYY'));
6259: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'Default_unapp_on_acc_act_info ()-');
6260: END IF;
6261:
6254: arp_util.debug('Default_unapp_on_ac_act_info: ' || '*****Defaulted Values *********');
6255: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
6256: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_receivable_application_id : '||to_char(p_receivable_application_id));
6257: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
6258: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_reversal_gl_date : '||to_char(p_reversal_gl_date,'DD-MON-YYYY'));
6259: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'Default_unapp_on_acc_act_info ()-');
6260: END IF;
6261:
6262: END Default_unapp_on_ac_act_info;
6255: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_cash_receipt_id : '||to_char(p_cash_receipt_id));
6256: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_receivable_application_id : '||to_char(p_receivable_application_id));
6257: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_apply_gl_date : '||to_char(p_apply_gl_date,'DD-MON-YYYY'));
6258: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'p_reversal_gl_date : '||to_char(p_reversal_gl_date,'DD-MON-YYYY'));
6259: arp_util.debug('Default_unapp_on_ac_act_info: ' || 'Default_unapp_on_acc_act_info ()-');
6260: END IF;
6261:
6262: END Default_unapp_on_ac_act_info;
6263:
6275: l_cash_receipt_id NUMBER;
6276: BEGIN
6277: p_return_status := FND_API.G_RET_STS_SUCCESS;
6278: IF PG_DEBUG in ('Y', 'C') THEN
6279: arp_util.debug('Derive_activity_unapp_ids ()+');
6280: END IF;
6281: --derive the cash_receipt_id from the receipt_number
6282: IF p_receipt_number IS NOT NULL THEN
6283: Default_cash_receipt_id(p_cash_receipt_id ,
6383: AND nvl(ra.confirmed_flag,'Y') = 'Y';
6384: END IF;
6385:
6386: IF PG_DEBUG in ('Y', 'C') THEN
6387: arp_util.debug('Derive_activity_unapp_ids ()+');
6388: END IF;
6389: END Derive_activity_unapp_ids;
6390:
6391: PROCEDURE get_doc_seq(p_application_id IN NUMBER,
6407: l_aud_tab_name VARCHAR2(50);
6408: l_msg_flag VARCHAR2(1);
6409: BEGIN
6410: IF PG_DEBUG in ('Y', 'C') THEN
6411: arp_util.debug('get_doc_seq ()+');
6412: arp_util.debug('get_doc_seq: ' || 'SEQ : '||NVL( pg_profile_doc_seq, 'N'));
6413: arp_util.debug('get_doc_seq: ' || 'p_document_name :'||p_document_name);
6414: arp_util.debug('get_doc_seq: ' || 'p_application_id :'||to_char(p_application_id));
6415: arp_util.debug('get_doc_seq: ' || 'p_sob_id :'||to_char(p_sob_id));
6408: l_msg_flag VARCHAR2(1);
6409: BEGIN
6410: IF PG_DEBUG in ('Y', 'C') THEN
6411: arp_util.debug('get_doc_seq ()+');
6412: arp_util.debug('get_doc_seq: ' || 'SEQ : '||NVL( pg_profile_doc_seq, 'N'));
6413: arp_util.debug('get_doc_seq: ' || 'p_document_name :'||p_document_name);
6414: arp_util.debug('get_doc_seq: ' || 'p_application_id :'||to_char(p_application_id));
6415: arp_util.debug('get_doc_seq: ' || 'p_sob_id :'||to_char(p_sob_id));
6416: END IF;
6409: BEGIN
6410: IF PG_DEBUG in ('Y', 'C') THEN
6411: arp_util.debug('get_doc_seq ()+');
6412: arp_util.debug('get_doc_seq: ' || 'SEQ : '||NVL( pg_profile_doc_seq, 'N'));
6413: arp_util.debug('get_doc_seq: ' || 'p_document_name :'||p_document_name);
6414: arp_util.debug('get_doc_seq: ' || 'p_application_id :'||to_char(p_application_id));
6415: arp_util.debug('get_doc_seq: ' || 'p_sob_id :'||to_char(p_sob_id));
6416: END IF;
6417: p_return_status := FND_API.G_RET_STS_SUCCESS;
6410: IF PG_DEBUG in ('Y', 'C') THEN
6411: arp_util.debug('get_doc_seq ()+');
6412: arp_util.debug('get_doc_seq: ' || 'SEQ : '||NVL( pg_profile_doc_seq, 'N'));
6413: arp_util.debug('get_doc_seq: ' || 'p_document_name :'||p_document_name);
6414: arp_util.debug('get_doc_seq: ' || 'p_application_id :'||to_char(p_application_id));
6415: arp_util.debug('get_doc_seq: ' || 'p_sob_id :'||to_char(p_sob_id));
6416: END IF;
6417: p_return_status := FND_API.G_RET_STS_SUCCESS;
6418: IF ( NVL( pg_profile_doc_seq, 'N') <> 'N' )
6411: arp_util.debug('get_doc_seq ()+');
6412: arp_util.debug('get_doc_seq: ' || 'SEQ : '||NVL( pg_profile_doc_seq, 'N'));
6413: arp_util.debug('get_doc_seq: ' || 'p_document_name :'||p_document_name);
6414: arp_util.debug('get_doc_seq: ' || 'p_application_id :'||to_char(p_application_id));
6415: arp_util.debug('get_doc_seq: ' || 'p_sob_id :'||to_char(p_sob_id));
6416: END IF;
6417: p_return_status := FND_API.G_RET_STS_SUCCESS;
6418: IF ( NVL( pg_profile_doc_seq, 'N') <> 'N' )
6419: THEN
6437: l_aud_tab_name,
6438: l_msg_flag,
6439: 'Y',
6440: 'Y');
6441: arp_util.debug('Doc sequence return status :'||to_char(nvl(l_doc_seq_ret_stat,-99)));
6442: IF PG_DEBUG in ('Y', 'C') THEN
6443: arp_util.debug('get_doc_seq: ' || 'l_doc_sequence_name :'||l_doc_sequence_name);
6444: END IF;
6445: arp_util.debug('l_doc_sequence_id :'||to_char(nvl(p_doc_sequence_id,-99)));
6439: 'Y',
6440: 'Y');
6441: arp_util.debug('Doc sequence return status :'||to_char(nvl(l_doc_seq_ret_stat,-99)));
6442: IF PG_DEBUG in ('Y', 'C') THEN
6443: arp_util.debug('get_doc_seq: ' || 'l_doc_sequence_name :'||l_doc_sequence_name);
6444: END IF;
6445: arp_util.debug('l_doc_sequence_id :'||to_char(nvl(p_doc_sequence_id,-99)));
6446:
6447: IF l_doc_seq_ret_stat = -8 THEN
6441: arp_util.debug('Doc sequence return status :'||to_char(nvl(l_doc_seq_ret_stat,-99)));
6442: IF PG_DEBUG in ('Y', 'C') THEN
6443: arp_util.debug('get_doc_seq: ' || 'l_doc_sequence_name :'||l_doc_sequence_name);
6444: END IF;
6445: arp_util.debug('l_doc_sequence_id :'||to_char(nvl(p_doc_sequence_id,-99)));
6446:
6447: IF l_doc_seq_ret_stat = -8 THEN
6448: --this is the case of Always Used
6449: IF PG_DEBUG in ('Y', 'C') THEN
6446:
6447: IF l_doc_seq_ret_stat = -8 THEN
6448: --this is the case of Always Used
6449: IF PG_DEBUG in ('Y', 'C') THEN
6450: arp_util.debug('get_doc_seq: ' || 'The doc sequence does not exist for the current document');
6451: END IF;
6452: p_return_status := FND_API.G_RET_STS_ERROR;
6453: --Error message
6454: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_DOC_SEQ_NOT_EXIST_A');
6455: FND_MSG_PUB.Add;
6456: ELSIF l_doc_seq_ret_stat = -2 THEN
6457: --this is the case of Partially Used
6458: IF PG_DEBUG in ('Y', 'C') THEN
6459: arp_util.debug('get_doc_seq: ' || 'The doc sequence does not exist for the current document');
6460: END IF;
6461: --Warning
6462: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)
6463: THEN
6476: /*------------------------------------+
6477: | Automatic Document Numbering case |
6478: +------------------------------------*/
6479: IF PG_DEBUG in ('Y', 'C') THEN
6480: arp_util.debug('get_doc_seq: ' || 'Automatic Document Numbering case ');
6481: END IF;
6482: l_doc_seq_ret_stat :=
6483: fnd_seqnum.get_seq_val (
6484: p_application_id,
6495: FND_MESSAGE.Set_Name('AR', 'AR_RAPI_DOC_SEQ_AUTOMATIC');
6496: FND_MSG_PUB.Add;
6497: END IF;
6498: p_doc_sequence_value := l_doc_sequence_value;
6499: arp_util.debug('l_doc_sequence_value :'||to_char(nvl(p_doc_sequence_value,-99)));
6500: ELSIF (
6501: p_doc_sequence_id IS NOT NULL
6502: AND p_doc_sequence_value IS NOT NULL
6503: )
6544: | Generate an error if document numbering |
6545: | is mandatory. |
6546: +------------------------------------------*/
6547: IF PG_DEBUG in ('Y', 'C') THEN
6548: arp_util.debug('get_doc_seq: ' || 'no_data_found raised');
6549: END IF;
6550: IF (pg_profile_doc_seq = 'A' ) THEN
6551: p_return_status := FND_API.G_RET_STS_ERROR;
6552: FND_MESSAGE.Set_Name( 'FND','UNIQUE-ALWAYS USED');
6557: END IF;
6558:
6559: WHEN OTHERS THEN
6560: IF PG_DEBUG in ('Y', 'C') THEN
6561: arp_util.debug('get_doc_seq: ' || 'Unhandled exception in doc sequence assignment');
6562: END IF;
6563: raise;
6564:
6565: END;
6565: END;
6566:
6567: END IF;
6568: IF PG_DEBUG in ('Y', 'C') THEN
6569: arp_util.debug('get_doc_seq ()+');
6570: END IF;
6571: END get_doc_seq;
6572:
6573: /* modified for tca uptake */
6844: WHERE receipt_method_id = p_receipt_method_id;
6845: EXCEPTION
6846: WHEN no_data_found THEN
6847: IF PG_DEBUG in ('Y', 'C') THEN
6848: arp_util.debug('Default_misc_ids: ' || 'Invalid receipt method id');
6849: END IF;
6850: null;
6851: END;
6852:
7092: FROM ar_distribution_set_lines
7093: WHERE distribution_set_id = p_distribution_set_id;
7094: BEGIN
7095: IF PG_DEBUG in ('Y', 'C') THEN
7096: arp_util.debug('Get_misc_Defaults()+ ');
7097: END IF;
7098: p_return_status := FND_API.G_RET_STS_SUCCESS;
7099: -- default the receipt date if NULL
7100: IF (p_receipt_date IS NULL)
7110: p_gl_date,
7111: NULL,
7112: l_def_gl_dt_return_status);
7113: IF PG_DEBUG in ('Y', 'C') THEN
7114: arp_util.debug('Get_misc_defaults: ' || 'l_default_gl_date_return_status : '||l_def_gl_dt_return_status);
7115: END IF;
7116: END IF;
7117:
7118: IF (p_deposit_date IS NULL)
7131: );
7132:
7133: --Set the precision of the receipt amount as per currency
7134: IF p_amount is NOT NULL THEN
7135: p_amount := arp_util.CurrRound( p_amount,
7136: p_currency_code
7137: );
7138: END IF;
7139:
7355: END IF;
7356: /* End of Bug3315058*/
7357: IF p_tax_amount IS NOT NULL THEN
7358:
7359: l_tax_amount := arp_util.CurrRound( p_tax_amount,
7360: p_currency_code
7361: );
7362: END IF;
7363:
7392: l_bank_acc_val_ret_status <> FND_API.G_RET_STS_SUCCESS THEN /* Bug fix 3315058 */
7393: p_return_status := FND_API.G_RET_STS_ERROR;
7394: END IF;
7395: IF PG_DEBUG in ('Y', 'C') THEN
7396: arp_util.debug('Get_misc_defaults: ' || '************Cash Defaults********************');
7397: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_date : '||to_char(p_receipt_date,'DD-MON-YYYY'));
7398: arp_util.debug('Get_misc_defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
7399: arp_util.debug('Get_misc_defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
7400: arp_util.debug('Get_misc_defaults: ' || 'p_currency_code : '||p_currency_code);
7393: p_return_status := FND_API.G_RET_STS_ERROR;
7394: END IF;
7395: IF PG_DEBUG in ('Y', 'C') THEN
7396: arp_util.debug('Get_misc_defaults: ' || '************Cash Defaults********************');
7397: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_date : '||to_char(p_receipt_date,'DD-MON-YYYY'));
7398: arp_util.debug('Get_misc_defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
7399: arp_util.debug('Get_misc_defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
7400: arp_util.debug('Get_misc_defaults: ' || 'p_currency_code : '||p_currency_code);
7401: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_date,'DD-MON-YYYY'));
7394: END IF;
7395: IF PG_DEBUG in ('Y', 'C') THEN
7396: arp_util.debug('Get_misc_defaults: ' || '************Cash Defaults********************');
7397: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_date : '||to_char(p_receipt_date,'DD-MON-YYYY'));
7398: arp_util.debug('Get_misc_defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
7399: arp_util.debug('Get_misc_defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
7400: arp_util.debug('Get_misc_defaults: ' || 'p_currency_code : '||p_currency_code);
7401: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_date,'DD-MON-YYYY'));
7402: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
7395: IF PG_DEBUG in ('Y', 'C') THEN
7396: arp_util.debug('Get_misc_defaults: ' || '************Cash Defaults********************');
7397: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_date : '||to_char(p_receipt_date,'DD-MON-YYYY'));
7398: arp_util.debug('Get_misc_defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
7399: arp_util.debug('Get_misc_defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
7400: arp_util.debug('Get_misc_defaults: ' || 'p_currency_code : '||p_currency_code);
7401: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_date,'DD-MON-YYYY'));
7402: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
7403: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
7396: arp_util.debug('Get_misc_defaults: ' || '************Cash Defaults********************');
7397: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_date : '||to_char(p_receipt_date,'DD-MON-YYYY'));
7398: arp_util.debug('Get_misc_defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
7399: arp_util.debug('Get_misc_defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
7400: arp_util.debug('Get_misc_defaults: ' || 'p_currency_code : '||p_currency_code);
7401: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_date,'DD-MON-YYYY'));
7402: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
7403: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
7404: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
7397: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_date : '||to_char(p_receipt_date,'DD-MON-YYYY'));
7398: arp_util.debug('Get_misc_defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
7399: arp_util.debug('Get_misc_defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
7400: arp_util.debug('Get_misc_defaults: ' || 'p_currency_code : '||p_currency_code);
7401: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_date,'DD-MON-YYYY'));
7402: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
7403: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
7404: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
7405: arp_util.debug('Get_misc_defaults: ' || 'p_remittance_bank_account_id : '||to_char(p_remittance_bank_account_id));
7398: arp_util.debug('Get_misc_defaults: ' || 'p_gl_date : '||to_char(p_gl_date,'DD-MON-YYYY'));
7399: arp_util.debug('Get_misc_defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
7400: arp_util.debug('Get_misc_defaults: ' || 'p_currency_code : '||p_currency_code);
7401: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_date,'DD-MON-YYYY'));
7402: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
7403: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
7404: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
7405: arp_util.debug('Get_misc_defaults: ' || 'p_remittance_bank_account_id : '||to_char(p_remittance_bank_account_id));
7406: arp_util.debug('Get_misc_defaults: ' || 'p_state : '||p_state);
7399: arp_util.debug('Get_misc_defaults: ' || 'p_deposit_date : '||to_char(p_deposit_date,'DD-MON-YYYY'));
7400: arp_util.debug('Get_misc_defaults: ' || 'p_currency_code : '||p_currency_code);
7401: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_date,'DD-MON-YYYY'));
7402: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
7403: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
7404: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
7405: arp_util.debug('Get_misc_defaults: ' || 'p_remittance_bank_account_id : '||to_char(p_remittance_bank_account_id));
7406: arp_util.debug('Get_misc_defaults: ' || 'p_state : '||p_state);
7407: arp_util.debug('Get_misc_Defaults ()-');
7400: arp_util.debug('Get_misc_defaults: ' || 'p_currency_code : '||p_currency_code);
7401: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_date,'DD-MON-YYYY'));
7402: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
7403: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
7404: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
7405: arp_util.debug('Get_misc_defaults: ' || 'p_remittance_bank_account_id : '||to_char(p_remittance_bank_account_id));
7406: arp_util.debug('Get_misc_defaults: ' || 'p_state : '||p_state);
7407: arp_util.debug('Get_misc_Defaults ()-');
7408: END IF;
7401: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_date : '||to_char(p_exchange_date,'DD-MON-YYYY'));
7402: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
7403: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
7404: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
7405: arp_util.debug('Get_misc_defaults: ' || 'p_remittance_bank_account_id : '||to_char(p_remittance_bank_account_id));
7406: arp_util.debug('Get_misc_defaults: ' || 'p_state : '||p_state);
7407: arp_util.debug('Get_misc_Defaults ()-');
7408: END IF;
7409:
7402: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate_type : '||p_exchange_rate_type);
7403: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
7404: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
7405: arp_util.debug('Get_misc_defaults: ' || 'p_remittance_bank_account_id : '||to_char(p_remittance_bank_account_id));
7406: arp_util.debug('Get_misc_defaults: ' || 'p_state : '||p_state);
7407: arp_util.debug('Get_misc_Defaults ()-');
7408: END IF;
7409:
7410: END Get_misc_defaults;
7403: arp_util.debug('Get_misc_defaults: ' || 'p_exchange_rate : '||to_char(p_exchange_rate));
7404: arp_util.debug('Get_misc_defaults: ' || 'p_receipt_method_id : '||to_char(p_receipt_method_id));
7405: arp_util.debug('Get_misc_defaults: ' || 'p_remittance_bank_account_id : '||to_char(p_remittance_bank_account_id));
7406: arp_util.debug('Get_misc_defaults: ' || 'p_state : '||p_state);
7407: arp_util.debug('Get_misc_Defaults ()-');
7408: END IF;
7409:
7410: END Get_misc_defaults;
7411:
7425: WHERE application_id = 222
7426: and descriptive_flexfield_name = p_desc_flex_name;
7427: BEGIN
7428: IF PG_DEBUG in ('Y', 'C') THEN
7429: arp_util.debug('Validate_Desc_Flexfield ()+');
7430: END IF;
7431: p_return_status := FND_API.G_RET_STS_SUCCESS;
7432:
7433: OPEN desc_flex_exists;
7518: END IF;
7519: END LOOP;
7520:
7521: IF PG_DEBUG in ('Y', 'C') THEN
7522: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute_category : '||p_desc_flex_rec.attribute_category);
7523: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute1 : '||p_desc_flex_rec.attribute1);
7524: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute2 : '||p_desc_flex_rec.attribute2);
7525: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute3 : '||p_desc_flex_rec.attribute3);
7526: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute4 : '||p_desc_flex_rec.attribute4);
7519: END LOOP;
7520:
7521: IF PG_DEBUG in ('Y', 'C') THEN
7522: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute_category : '||p_desc_flex_rec.attribute_category);
7523: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute1 : '||p_desc_flex_rec.attribute1);
7524: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute2 : '||p_desc_flex_rec.attribute2);
7525: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute3 : '||p_desc_flex_rec.attribute3);
7526: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute4 : '||p_desc_flex_rec.attribute4);
7527: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute5 : '||p_desc_flex_rec.attribute5);
7520:
7521: IF PG_DEBUG in ('Y', 'C') THEN
7522: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute_category : '||p_desc_flex_rec.attribute_category);
7523: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute1 : '||p_desc_flex_rec.attribute1);
7524: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute2 : '||p_desc_flex_rec.attribute2);
7525: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute3 : '||p_desc_flex_rec.attribute3);
7526: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute4 : '||p_desc_flex_rec.attribute4);
7527: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute5 : '||p_desc_flex_rec.attribute5);
7528: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute6 : '||p_desc_flex_rec.attribute6);
7521: IF PG_DEBUG in ('Y', 'C') THEN
7522: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute_category : '||p_desc_flex_rec.attribute_category);
7523: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute1 : '||p_desc_flex_rec.attribute1);
7524: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute2 : '||p_desc_flex_rec.attribute2);
7525: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute3 : '||p_desc_flex_rec.attribute3);
7526: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute4 : '||p_desc_flex_rec.attribute4);
7527: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute5 : '||p_desc_flex_rec.attribute5);
7528: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute6 : '||p_desc_flex_rec.attribute6);
7529: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute7 : '||p_desc_flex_rec.attribute7);
7522: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute_category : '||p_desc_flex_rec.attribute_category);
7523: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute1 : '||p_desc_flex_rec.attribute1);
7524: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute2 : '||p_desc_flex_rec.attribute2);
7525: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute3 : '||p_desc_flex_rec.attribute3);
7526: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute4 : '||p_desc_flex_rec.attribute4);
7527: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute5 : '||p_desc_flex_rec.attribute5);
7528: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute6 : '||p_desc_flex_rec.attribute6);
7529: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute7 : '||p_desc_flex_rec.attribute7);
7530: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute8 : '||p_desc_flex_rec.attribute8);
7523: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute1 : '||p_desc_flex_rec.attribute1);
7524: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute2 : '||p_desc_flex_rec.attribute2);
7525: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute3 : '||p_desc_flex_rec.attribute3);
7526: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute4 : '||p_desc_flex_rec.attribute4);
7527: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute5 : '||p_desc_flex_rec.attribute5);
7528: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute6 : '||p_desc_flex_rec.attribute6);
7529: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute7 : '||p_desc_flex_rec.attribute7);
7530: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute8 : '||p_desc_flex_rec.attribute8);
7531: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute9 : '||p_desc_flex_rec.attribute9);
7524: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute2 : '||p_desc_flex_rec.attribute2);
7525: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute3 : '||p_desc_flex_rec.attribute3);
7526: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute4 : '||p_desc_flex_rec.attribute4);
7527: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute5 : '||p_desc_flex_rec.attribute5);
7528: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute6 : '||p_desc_flex_rec.attribute6);
7529: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute7 : '||p_desc_flex_rec.attribute7);
7530: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute8 : '||p_desc_flex_rec.attribute8);
7531: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute9 : '||p_desc_flex_rec.attribute9);
7532: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute10 : '||p_desc_flex_rec.attribute10);
7525: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute3 : '||p_desc_flex_rec.attribute3);
7526: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute4 : '||p_desc_flex_rec.attribute4);
7527: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute5 : '||p_desc_flex_rec.attribute5);
7528: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute6 : '||p_desc_flex_rec.attribute6);
7529: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute7 : '||p_desc_flex_rec.attribute7);
7530: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute8 : '||p_desc_flex_rec.attribute8);
7531: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute9 : '||p_desc_flex_rec.attribute9);
7532: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute10 : '||p_desc_flex_rec.attribute10);
7533: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute11 : '||p_desc_flex_rec.attribute11);
7526: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute4 : '||p_desc_flex_rec.attribute4);
7527: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute5 : '||p_desc_flex_rec.attribute5);
7528: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute6 : '||p_desc_flex_rec.attribute6);
7529: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute7 : '||p_desc_flex_rec.attribute7);
7530: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute8 : '||p_desc_flex_rec.attribute8);
7531: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute9 : '||p_desc_flex_rec.attribute9);
7532: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute10 : '||p_desc_flex_rec.attribute10);
7533: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute11 : '||p_desc_flex_rec.attribute11);
7534: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute12 : '||p_desc_flex_rec.attribute12);
7527: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute5 : '||p_desc_flex_rec.attribute5);
7528: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute6 : '||p_desc_flex_rec.attribute6);
7529: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute7 : '||p_desc_flex_rec.attribute7);
7530: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute8 : '||p_desc_flex_rec.attribute8);
7531: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute9 : '||p_desc_flex_rec.attribute9);
7532: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute10 : '||p_desc_flex_rec.attribute10);
7533: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute11 : '||p_desc_flex_rec.attribute11);
7534: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute12 : '||p_desc_flex_rec.attribute12);
7535: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute13 : '||p_desc_flex_rec.attribute13);
7528: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute6 : '||p_desc_flex_rec.attribute6);
7529: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute7 : '||p_desc_flex_rec.attribute7);
7530: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute8 : '||p_desc_flex_rec.attribute8);
7531: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute9 : '||p_desc_flex_rec.attribute9);
7532: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute10 : '||p_desc_flex_rec.attribute10);
7533: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute11 : '||p_desc_flex_rec.attribute11);
7534: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute12 : '||p_desc_flex_rec.attribute12);
7535: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute13 : '||p_desc_flex_rec.attribute13);
7536: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute14 : '||p_desc_flex_rec.attribute14);
7529: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute7 : '||p_desc_flex_rec.attribute7);
7530: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute8 : '||p_desc_flex_rec.attribute8);
7531: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute9 : '||p_desc_flex_rec.attribute9);
7532: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute10 : '||p_desc_flex_rec.attribute10);
7533: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute11 : '||p_desc_flex_rec.attribute11);
7534: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute12 : '||p_desc_flex_rec.attribute12);
7535: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute13 : '||p_desc_flex_rec.attribute13);
7536: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute14 : '||p_desc_flex_rec.attribute14);
7537: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute15 : '||p_desc_flex_rec.attribute15);
7530: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute8 : '||p_desc_flex_rec.attribute8);
7531: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute9 : '||p_desc_flex_rec.attribute9);
7532: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute10 : '||p_desc_flex_rec.attribute10);
7533: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute11 : '||p_desc_flex_rec.attribute11);
7534: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute12 : '||p_desc_flex_rec.attribute12);
7535: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute13 : '||p_desc_flex_rec.attribute13);
7536: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute14 : '||p_desc_flex_rec.attribute14);
7537: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute15 : '||p_desc_flex_rec.attribute15);
7538: arp_util.debug('Validate_Desc_Flexfield ()-');
7531: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute9 : '||p_desc_flex_rec.attribute9);
7532: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute10 : '||p_desc_flex_rec.attribute10);
7533: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute11 : '||p_desc_flex_rec.attribute11);
7534: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute12 : '||p_desc_flex_rec.attribute12);
7535: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute13 : '||p_desc_flex_rec.attribute13);
7536: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute14 : '||p_desc_flex_rec.attribute14);
7537: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute15 : '||p_desc_flex_rec.attribute15);
7538: arp_util.debug('Validate_Desc_Flexfield ()-');
7539: END IF;
7532: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute10 : '||p_desc_flex_rec.attribute10);
7533: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute11 : '||p_desc_flex_rec.attribute11);
7534: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute12 : '||p_desc_flex_rec.attribute12);
7535: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute13 : '||p_desc_flex_rec.attribute13);
7536: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute14 : '||p_desc_flex_rec.attribute14);
7537: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute15 : '||p_desc_flex_rec.attribute15);
7538: arp_util.debug('Validate_Desc_Flexfield ()-');
7539: END IF;
7540: END Validate_Desc_Flexfield;
7533: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute11 : '||p_desc_flex_rec.attribute11);
7534: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute12 : '||p_desc_flex_rec.attribute12);
7535: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute13 : '||p_desc_flex_rec.attribute13);
7536: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute14 : '||p_desc_flex_rec.attribute14);
7537: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute15 : '||p_desc_flex_rec.attribute15);
7538: arp_util.debug('Validate_Desc_Flexfield ()-');
7539: END IF;
7540: END Validate_Desc_Flexfield;
7541:
7534: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute12 : '||p_desc_flex_rec.attribute12);
7535: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute13 : '||p_desc_flex_rec.attribute13);
7536: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute14 : '||p_desc_flex_rec.attribute14);
7537: arp_util.debug('Validate_Desc_Flexfield: ' || 'attribute15 : '||p_desc_flex_rec.attribute15);
7538: arp_util.debug('Validate_Desc_Flexfield ()-');
7539: END IF;
7540: END Validate_Desc_Flexfield;
7541:
7542: /* Bug fix 3539008 */
7546: p_return_status IN OUT NOCOPY VARCHAR2
7547: ) IS
7548: BEGIN
7549: IF PG_DEBUG in ('Y', 'C') THEN
7550: arp_util.debug('ar_receipt_lib_pvt.Default_Desc_Flexfield(+)');
7551: END IF;
7552: p_return_status := FND_API.G_RET_STS_SUCCESS;
7553: IF p_cash_receipt_id IS NOT NULL THEN
7554: SELECT attribute_category,
7572: FROM ar_cash_receipts
7573: WHERE cash_receipt_id = p_cash_receipt_id;
7574: END IF;
7575: IF PG_DEBUG in ('Y', 'C') THEN
7576: arp_util.debug('ar_receipt_lib_pvt.Default_Desc_Flexfield(-)');
7577: END IF;
7578:
7579: EXCEPTION WHEN OTHERS THEN
7580: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_INVALID');
7589: p_return_status OUT NOCOPY VARCHAR2
7590: ) IS
7591: BEGIN
7592: IF PG_DEBUG in ('Y', 'C') THEN
7593: arp_util.debug('ar_receipt_lib_pvt.Default_prepay_cc_activity(+)');
7594: END IF;
7595:
7596: p_return_status := FND_API.G_RET_STS_SUCCESS;
7597:
7614: END;
7615: END IF;
7616:
7617: IF PG_DEBUG in ('Y', 'C') THEN
7618: arp_util.debug('ar_receipt_lib_pvt.Default_prepay_cc_activity(+)');
7619: END IF;
7620:
7621: END Default_prepay_cc_activity;
7622:
7665:
7666: BEGIN
7667:
7668: IF PG_DEBUG in ('Y', 'C') THEN
7669: arp_util.debug('ar_receipt_lib_pvt.Default_open_receipt(+)');
7670: END IF;
7671:
7672: x_return_status := FND_API.G_RET_STS_SUCCESS ;
7673: x_open_applied_ps_id := NULL;
7828:
7829: x_last_receipt_date := GREATEST(l_receipt_date,l_open_receipt_date);
7830:
7831: IF PG_DEBUG in ('Y', 'C') THEN
7832: arp_util.debug('ar_receipt_lib_pvt.Default_open_receipt(-)');
7833: END IF;
7834: END default_open_receipt;
7835:
7836: PROCEDURE default_unapp_open_receipt(
7844: BEGIN
7845:
7846: x_return_status := FND_API.G_RET_STS_SUCCESS;
7847: IF PG_DEBUG in ('Y', 'C') THEN
7848: arp_util.debug('ar_receipt_lib_pvt.Default_unapp_open_receipt(+)');
7849: END IF;
7850:
7851: SELECT app.applied_rec_app_id,
7852: applied_app.cash_receipt_id,
7859: WHERE app.applied_rec_app_id = applied_app.receivable_application_id
7860: AND app.receivable_application_id = p_receivable_application_id;
7861:
7862: IF PG_DEBUG in ('Y', 'C') THEN
7863: arp_util.debug('ar_receipt_lib_pvt.Default_unapp_open_receipt(-)');
7864: END IF;
7865:
7866: EXCEPTION
7867: WHEN no_data_found THEN
7876: l_legal_entity_id NUMBER;
7877: l_return_status VARCHAR2(1);
7878: BEGIN
7879: IF PG_DEBUG in ('Y', 'C') THEN
7880: arp_util.debug('ar_receipt_lib_pvt.get_legal_entity(+)');
7881: END IF;
7882:
7883: l_legal_entity_id := TO_NUMBER(Get_Id('LEGAL_ENTITY',
7884: p_remit_bank_acct_use_id,
7886: ));
7887: RETURN l_legal_entity_id;
7888:
7889: IF PG_DEBUG in ('Y', 'C') THEN
7890: arp_util.debug('ar_receipt_lib_pvt.get_legal_entity(-)');
7891: END IF;
7892: EXCEPTION
7893: WHEN OTHERS THEN
7894: RETURN NULL;
7932: l_party_site_id hz_parties.party_id%TYPE;
7933: l_pmt_attr_rec iby_disbursement_comp_pub.default_pmt_attrs_rec_type;
7934: BEGIN
7935: IF PG_DEBUG in ('Y', 'C') THEN
7936: arp_util.debug('ar_receipt_lib_pvt.default_refund_attributes(+)');
7937: END IF;
7938: l_trxn_attributes_rec.application_id := 222;
7939:
7940: IF p_cash_receipt_id IS NOT NULL THEN
8030: l_trxn_attributes_rec.payment_amount := p_amount;
8031: l_trxn_attributes_rec.payment_function := 'AR_CUSTOMER_REFUNDS';
8032:
8033: IF PG_DEBUG in ('Y', 'C') THEN
8034: arp_util.debug('Calling get_default_payment_attributes .......: ');
8035: END IF;
8036:
8037: /* Bug 5056865 p_ignore_payee_pref should be passed as 'Y' as discussed in
8038: Related Bug 5115632 */
8049: exception when others then null;
8050: end;
8051:
8052: IF PG_DEBUG in ('Y', 'C') THEN
8053: arp_util.debug('get_default_payment_attributes return status: '||x_return_status);
8054: END IF;
8055:
8056: x_payment_method_code := l_pmt_attr_rec.payment_method.payment_method_code;
8057: x_payment_method_name := l_pmt_attr_rec.payment_method.payment_method_name;
8062: x_delivery_channel_code := l_pmt_attr_rec.delivery_channel.code;
8063: x_delivery_channel_name := l_pmt_attr_rec.delivery_channel.meaning;
8064: x_pay_alone_flag := l_pmt_attr_rec.pay_alone;
8065: IF PG_DEBUG in ('Y', 'C') THEN
8066: arp_util.debug('ar_receipt_lib_pvt.default_refund_attributes(-)');
8067: END IF;
8068: END default_refund_attributes;
8069:
8070:
8084: p_return_status OUT NOCOPY VARCHAR2)
8085: IS
8086: BEGIN
8087: IF PG_DEBUG in ('Y', 'C') THEN
8088: arp_util.debug('Populate_llca_gt ()+ ');
8089: END IF;
8090:
8091: p_return_status := FND_API.G_RET_STS_SUCCESS;
8092:
8100: If p_llca_type = 'S'
8101: Then
8102: If p_llca_trx_lines_tbl.count <> 0 Then
8103: IF PG_DEBUG in ('Y', 'C') THEN
8104: arp_util.debug('Apply_In_Detail: ' || 'Table must be empty for
8105: Summary Level application ');
8106: END IF;
8107: End If;
8108: END IF;
8110: If p_llca_type = 'L'
8111: Then
8112: If p_llca_trx_lines_tbl.count = 0 Then
8113: IF PG_DEBUG in ('Y', 'C') THEN
8114: arp_util.debug('=======================================================');
8115: arp_util.debug(' PL SQL TABLE ( INPUT PARAMETERS ........)+ ');
8116: arp_util.debug('=======================================================');
8117: arp_util.debug('Apply_In_Detail: ' || 'Pl Sql Table is empty ..
8118: All Lines ');
8111: Then
8112: If p_llca_trx_lines_tbl.count = 0 Then
8113: IF PG_DEBUG in ('Y', 'C') THEN
8114: arp_util.debug('=======================================================');
8115: arp_util.debug(' PL SQL TABLE ( INPUT PARAMETERS ........)+ ');
8116: arp_util.debug('=======================================================');
8117: arp_util.debug('Apply_In_Detail: ' || 'Pl Sql Table is empty ..
8118: All Lines ');
8119: END IF;
8112: If p_llca_trx_lines_tbl.count = 0 Then
8113: IF PG_DEBUG in ('Y', 'C') THEN
8114: arp_util.debug('=======================================================');
8115: arp_util.debug(' PL SQL TABLE ( INPUT PARAMETERS ........)+ ');
8116: arp_util.debug('=======================================================');
8117: arp_util.debug('Apply_In_Detail: ' || 'Pl Sql Table is empty ..
8118: All Lines ');
8119: END IF;
8120: Else
8113: IF PG_DEBUG in ('Y', 'C') THEN
8114: arp_util.debug('=======================================================');
8115: arp_util.debug(' PL SQL TABLE ( INPUT PARAMETERS ........)+ ');
8116: arp_util.debug('=======================================================');
8117: arp_util.debug('Apply_In_Detail: ' || 'Pl Sql Table is empty ..
8118: All Lines ');
8119: END IF;
8120: Else
8121: IF PG_DEBUG in ('Y', 'C') THEN
8118: All Lines ');
8119: END IF;
8120: Else
8121: IF PG_DEBUG in ('Y', 'C') THEN
8122: arp_util.debug('No of records in PLSQL Table
8123: =>'||to_char(p_llca_trx_lines_tbl.count));
8124: END IF;
8125:
8126: --bug7311231, Populating the GT table with flexfield information of each line.
8188: p_llca_trx_lines_tbl(i).attribute15
8189: );
8190:
8191: IF PG_DEBUG in ('Y', 'C') THEN
8192: arp_util.debug('=======================================================');
8193: arp_util.debug(' Line .............=>'||to_char(i));
8194: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
8195: arp_util.debug('p_customer_trx_line_id =>'||to_char(p_llca_trx_lines_tbl(i).customer_trx_line_id));
8196: arp_util.debug('p_line_number =>'||to_char(p_llca_trx_lines_tbl(i).line_number));
8189: );
8190:
8191: IF PG_DEBUG in ('Y', 'C') THEN
8192: arp_util.debug('=======================================================');
8193: arp_util.debug(' Line .............=>'||to_char(i));
8194: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
8195: arp_util.debug('p_customer_trx_line_id =>'||to_char(p_llca_trx_lines_tbl(i).customer_trx_line_id));
8196: arp_util.debug('p_line_number =>'||to_char(p_llca_trx_lines_tbl(i).line_number));
8197: arp_util.debug('p_line_amount =>'||to_char(p_llca_trx_lines_tbl(i).line_amount));
8190:
8191: IF PG_DEBUG in ('Y', 'C') THEN
8192: arp_util.debug('=======================================================');
8193: arp_util.debug(' Line .............=>'||to_char(i));
8194: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
8195: arp_util.debug('p_customer_trx_line_id =>'||to_char(p_llca_trx_lines_tbl(i).customer_trx_line_id));
8196: arp_util.debug('p_line_number =>'||to_char(p_llca_trx_lines_tbl(i).line_number));
8197: arp_util.debug('p_line_amount =>'||to_char(p_llca_trx_lines_tbl(i).line_amount));
8198: arp_util.debug('p_tax_amount =>'||to_char(p_llca_trx_lines_tbl(i).tax_amount));
8191: IF PG_DEBUG in ('Y', 'C') THEN
8192: arp_util.debug('=======================================================');
8193: arp_util.debug(' Line .............=>'||to_char(i));
8194: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
8195: arp_util.debug('p_customer_trx_line_id =>'||to_char(p_llca_trx_lines_tbl(i).customer_trx_line_id));
8196: arp_util.debug('p_line_number =>'||to_char(p_llca_trx_lines_tbl(i).line_number));
8197: arp_util.debug('p_line_amount =>'||to_char(p_llca_trx_lines_tbl(i).line_amount));
8198: arp_util.debug('p_tax_amount =>'||to_char(p_llca_trx_lines_tbl(i).tax_amount));
8199: -- arp_util.debug('p_freight_amount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8192: arp_util.debug('=======================================================');
8193: arp_util.debug(' Line .............=>'||to_char(i));
8194: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
8195: arp_util.debug('p_customer_trx_line_id =>'||to_char(p_llca_trx_lines_tbl(i).customer_trx_line_id));
8196: arp_util.debug('p_line_number =>'||to_char(p_llca_trx_lines_tbl(i).line_number));
8197: arp_util.debug('p_line_amount =>'||to_char(p_llca_trx_lines_tbl(i).line_amount));
8198: arp_util.debug('p_tax_amount =>'||to_char(p_llca_trx_lines_tbl(i).tax_amount));
8199: -- arp_util.debug('p_freight_amount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8200: -- arp_util.debug('p_charges_amount =>'||to_char(p_llca_trx_lines_tbl(i).charges_amount));
8193: arp_util.debug(' Line .............=>'||to_char(i));
8194: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
8195: arp_util.debug('p_customer_trx_line_id =>'||to_char(p_llca_trx_lines_tbl(i).customer_trx_line_id));
8196: arp_util.debug('p_line_number =>'||to_char(p_llca_trx_lines_tbl(i).line_number));
8197: arp_util.debug('p_line_amount =>'||to_char(p_llca_trx_lines_tbl(i).line_amount));
8198: arp_util.debug('p_tax_amount =>'||to_char(p_llca_trx_lines_tbl(i).tax_amount));
8199: -- arp_util.debug('p_freight_amount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8200: -- arp_util.debug('p_charges_amount =>'||to_char(p_llca_trx_lines_tbl(i).charges_amount));
8201: arp_util.debug('p_amount_applied =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied));
8194: arp_util.debug('p_customer_trx_id =>'||to_char(p_customer_trx_id));
8195: arp_util.debug('p_customer_trx_line_id =>'||to_char(p_llca_trx_lines_tbl(i).customer_trx_line_id));
8196: arp_util.debug('p_line_number =>'||to_char(p_llca_trx_lines_tbl(i).line_number));
8197: arp_util.debug('p_line_amount =>'||to_char(p_llca_trx_lines_tbl(i).line_amount));
8198: arp_util.debug('p_tax_amount =>'||to_char(p_llca_trx_lines_tbl(i).tax_amount));
8199: -- arp_util.debug('p_freight_amount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8200: -- arp_util.debug('p_charges_amount =>'||to_char(p_llca_trx_lines_tbl(i).charges_amount));
8201: arp_util.debug('p_amount_applied =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied));
8202: arp_util.debug('p_amount_applied_from =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied_from));
8195: arp_util.debug('p_customer_trx_line_id =>'||to_char(p_llca_trx_lines_tbl(i).customer_trx_line_id));
8196: arp_util.debug('p_line_number =>'||to_char(p_llca_trx_lines_tbl(i).line_number));
8197: arp_util.debug('p_line_amount =>'||to_char(p_llca_trx_lines_tbl(i).line_amount));
8198: arp_util.debug('p_tax_amount =>'||to_char(p_llca_trx_lines_tbl(i).tax_amount));
8199: -- arp_util.debug('p_freight_amount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8200: -- arp_util.debug('p_charges_amount =>'||to_char(p_llca_trx_lines_tbl(i).charges_amount));
8201: arp_util.debug('p_amount_applied =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied));
8202: arp_util.debug('p_amount_applied_from =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied_from));
8203: arp_util.debug('p_line_discount =>'||to_char(p_llca_trx_lines_tbl(i).line_discount));
8196: arp_util.debug('p_line_number =>'||to_char(p_llca_trx_lines_tbl(i).line_number));
8197: arp_util.debug('p_line_amount =>'||to_char(p_llca_trx_lines_tbl(i).line_amount));
8198: arp_util.debug('p_tax_amount =>'||to_char(p_llca_trx_lines_tbl(i).tax_amount));
8199: -- arp_util.debug('p_freight_amount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8200: -- arp_util.debug('p_charges_amount =>'||to_char(p_llca_trx_lines_tbl(i).charges_amount));
8201: arp_util.debug('p_amount_applied =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied));
8202: arp_util.debug('p_amount_applied_from =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied_from));
8203: arp_util.debug('p_line_discount =>'||to_char(p_llca_trx_lines_tbl(i).line_discount));
8204: arp_util.debug('p_tax_discount =>'||to_char(p_llca_trx_lines_tbl(i).tax_discount));
8197: arp_util.debug('p_line_amount =>'||to_char(p_llca_trx_lines_tbl(i).line_amount));
8198: arp_util.debug('p_tax_amount =>'||to_char(p_llca_trx_lines_tbl(i).tax_amount));
8199: -- arp_util.debug('p_freight_amount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8200: -- arp_util.debug('p_charges_amount =>'||to_char(p_llca_trx_lines_tbl(i).charges_amount));
8201: arp_util.debug('p_amount_applied =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied));
8202: arp_util.debug('p_amount_applied_from =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied_from));
8203: arp_util.debug('p_line_discount =>'||to_char(p_llca_trx_lines_tbl(i).line_discount));
8204: arp_util.debug('p_tax_discount =>'||to_char(p_llca_trx_lines_tbl(i).tax_discount));
8205: -- arp_util.debug('p_freight_discount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8198: arp_util.debug('p_tax_amount =>'||to_char(p_llca_trx_lines_tbl(i).tax_amount));
8199: -- arp_util.debug('p_freight_amount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8200: -- arp_util.debug('p_charges_amount =>'||to_char(p_llca_trx_lines_tbl(i).charges_amount));
8201: arp_util.debug('p_amount_applied =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied));
8202: arp_util.debug('p_amount_applied_from =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied_from));
8203: arp_util.debug('p_line_discount =>'||to_char(p_llca_trx_lines_tbl(i).line_discount));
8204: arp_util.debug('p_tax_discount =>'||to_char(p_llca_trx_lines_tbl(i).tax_discount));
8205: -- arp_util.debug('p_freight_discount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8206: arp_util.debug('=======================================================');
8199: -- arp_util.debug('p_freight_amount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8200: -- arp_util.debug('p_charges_amount =>'||to_char(p_llca_trx_lines_tbl(i).charges_amount));
8201: arp_util.debug('p_amount_applied =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied));
8202: arp_util.debug('p_amount_applied_from =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied_from));
8203: arp_util.debug('p_line_discount =>'||to_char(p_llca_trx_lines_tbl(i).line_discount));
8204: arp_util.debug('p_tax_discount =>'||to_char(p_llca_trx_lines_tbl(i).tax_discount));
8205: -- arp_util.debug('p_freight_discount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8206: arp_util.debug('=======================================================');
8207: END IF;
8200: -- arp_util.debug('p_charges_amount =>'||to_char(p_llca_trx_lines_tbl(i).charges_amount));
8201: arp_util.debug('p_amount_applied =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied));
8202: arp_util.debug('p_amount_applied_from =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied_from));
8203: arp_util.debug('p_line_discount =>'||to_char(p_llca_trx_lines_tbl(i).line_discount));
8204: arp_util.debug('p_tax_discount =>'||to_char(p_llca_trx_lines_tbl(i).tax_discount));
8205: -- arp_util.debug('p_freight_discount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8206: arp_util.debug('=======================================================');
8207: END IF;
8208: End Loop;
8201: arp_util.debug('p_amount_applied =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied));
8202: arp_util.debug('p_amount_applied_from =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied_from));
8203: arp_util.debug('p_line_discount =>'||to_char(p_llca_trx_lines_tbl(i).line_discount));
8204: arp_util.debug('p_tax_discount =>'||to_char(p_llca_trx_lines_tbl(i).tax_discount));
8205: -- arp_util.debug('p_freight_discount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8206: arp_util.debug('=======================================================');
8207: END IF;
8208: End Loop;
8209: End If;
8202: arp_util.debug('p_amount_applied_from =>'||to_char(p_llca_trx_lines_tbl(i).amount_applied_from));
8203: arp_util.debug('p_line_discount =>'||to_char(p_llca_trx_lines_tbl(i).line_discount));
8204: arp_util.debug('p_tax_discount =>'||to_char(p_llca_trx_lines_tbl(i).tax_discount));
8205: -- arp_util.debug('p_freight_discount =>'||to_char(p_llca_trx_lines_tbl(i).freight_amount));
8206: arp_util.debug('=======================================================');
8207: END IF;
8208: End Loop;
8209: End If;
8210: End If;
8208: End Loop;
8209: End If;
8210: End If;
8211: IF PG_DEBUG in ('Y', 'C') THEN
8212: arp_util.debug('Populate_llca_gt ()- ');
8213: END IF;
8214:
8215: EXCEPTION
8216: WHEN others THEN
8214:
8215: EXCEPTION
8216: WHEN others THEN
8217: IF PG_DEBUG in ('Y', 'C') THEN
8218: arp_util.debug('EXCEPTION: (pouplate_llca_gt)');
8219: END IF;
8220: p_return_status := FND_API.G_RET_STS_ERROR;
8221: raise;
8222: End populate_llca_gt;
8228: p_invalid_value IN VARCHAR2
8229: ) IS
8230: Begin
8231: IF PG_DEBUG in ('Y', 'C') THEN
8232: arp_util.debug('Populate_errors_gt ()+ ');
8233: END IF;
8234:
8235: Insert into ar_llca_trx_errors_gt
8236: ( customer_trx_id,
8245: p_invalid_value
8246: );
8247:
8248: IF PG_DEBUG in ('Y', 'C') THEN
8249: arp_util.debug('Populate_errors_gt ()- ');
8250: END IF;
8251:
8252: EXCEPTION
8253: WHEN others THEN
8251:
8252: EXCEPTION
8253: WHEN others THEN
8254: IF PG_DEBUG in ('Y', 'C') THEN
8255: arp_util.debug('EXCEPTION: (pouplate_errors_gt)');
8256: END IF;
8257: raise;
8258: End populate_errors_gt;
8259: