120:
121: EXCEPTION
122: WHEN OTHERS THEN
123: IF (SQLCODE <> -20001) THEN
124: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
125: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
126: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
127: FND_MESSAGE.SET_TOKEN('PARAMETERS',
128: ' P_Awt_Date = ' || to_char(P_Awt_Date) ||
121: EXCEPTION
122: WHEN OTHERS THEN
123: IF (SQLCODE <> -20001) THEN
124: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
125: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
126: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
127: FND_MESSAGE.SET_TOKEN('PARAMETERS',
128: ' P_Awt_Date = ' || to_char(P_Awt_Date) ||
129: ', P_Amount_Subject = ' || to_char(P_Amount_Subject) ||
122: WHEN OTHERS THEN
123: IF (SQLCODE <> -20001) THEN
124: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
125: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
126: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
127: FND_MESSAGE.SET_TOKEN('PARAMETERS',
128: ' P_Awt_Date = ' || to_char(P_Awt_Date) ||
129: ', P_Amount_Subject = ' || to_char(P_Amount_Subject) ||
130: ', P_Amount_Withheld = ' || to_char(P_Amount_Withheld) ||
123: IF (SQLCODE <> -20001) THEN
124: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
125: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
126: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
127: FND_MESSAGE.SET_TOKEN('PARAMETERS',
128: ' P_Awt_Date = ' || to_char(P_Awt_Date) ||
129: ', P_Amount_Subject = ' || to_char(P_Amount_Subject) ||
130: ', P_Amount_Withheld = ' || to_char(P_Amount_Withheld) ||
131: ', P_Vendor_Id = ' || to_char(P_Vendor_Id) ||
132: ', P_Tax_Name = ' || P_Tax_Name ||
133: ', P_Awt_Period_Name = ' || P_Awt_Period_Name ||
134: ', P_Period_limit = ' || to_char(P_Period_limit));
135:
136: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
137: END IF;
138: APP_EXCEPTION.RAISE_EXCEPTION;
139: END Do_AWT_Cut_Off;
140:
254: WHEN DO_NOT_UPDATE THEN
255: NULL;
256: WHEN OTHERS THEN
257: IF (SQLCODE <> -20001) THEN
258: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
259: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
260: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
261: FND_MESSAGE.SET_TOKEN('PARAMETERS',
262: ' P_Awt_Period_Name = ' || P_Awt_Period_Name ||
255: NULL;
256: WHEN OTHERS THEN
257: IF (SQLCODE <> -20001) THEN
258: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
259: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
260: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
261: FND_MESSAGE.SET_TOKEN('PARAMETERS',
262: ' P_Awt_Period_Name = ' || P_Awt_Period_Name ||
263: ', P_Amount_Subject = ' || to_char(P_Amount_Subject) ||
256: WHEN OTHERS THEN
257: IF (SQLCODE <> -20001) THEN
258: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
259: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
260: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
261: FND_MESSAGE.SET_TOKEN('PARAMETERS',
262: ' P_Awt_Period_Name = ' || P_Awt_Period_Name ||
263: ', P_Amount_Subject = ' || to_char(P_Amount_Subject) ||
264: ', P_Amount_Withheld = ' || to_char(P_Amount_Withheld) ||
257: IF (SQLCODE <> -20001) THEN
258: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
259: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
260: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
261: FND_MESSAGE.SET_TOKEN('PARAMETERS',
262: ' P_Awt_Period_Name = ' || P_Awt_Period_Name ||
263: ', P_Amount_Subject = ' || to_char(P_Amount_Subject) ||
264: ', P_Amount_Withheld = ' || to_char(P_Amount_Withheld) ||
265: ', P_Vendor_Id = ' || to_char(P_Vendor_Id) ||
264: ', P_Amount_Withheld = ' || to_char(P_Amount_Withheld) ||
265: ', P_Vendor_Id = ' || to_char(P_Vendor_Id) ||
266: ', P_Tax_Name = ' || P_Tax_Name ||
267: ', P_Calling_Module = ' || P_Calling_Module);
268: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
269: END IF;
270: APP_EXCEPTION.RAISE_EXCEPTION;
271:
272: END Handle_Bucket;
696:
697: EXCEPTION
698: WHEN OTHERS THEN
699: IF (SQLCODE <> -20001) THEN
700: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
701: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
703: FND_MESSAGE.SET_TOKEN('PARAMETERS',
704: ' Invoice Id = ' || to_char(InvoiceId) ||
697: EXCEPTION
698: WHEN OTHERS THEN
699: IF (SQLCODE <> -20001) THEN
700: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
701: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
703: FND_MESSAGE.SET_TOKEN('PARAMETERS',
704: ' Invoice Id = ' || to_char(InvoiceId) ||
705: ', Supplier Id = ' || to_char(SuppId) ||
698: WHEN OTHERS THEN
699: IF (SQLCODE <> -20001) THEN
700: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
701: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
703: FND_MESSAGE.SET_TOKEN('PARAMETERS',
704: ' Invoice Id = ' || to_char(InvoiceId) ||
705: ', Supplier Id = ' || to_char(SuppId) ||
706: ', Payment Num = ' || to_char(PaymentNum) ||
699: IF (SQLCODE <> -20001) THEN
700: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
701: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
703: FND_MESSAGE.SET_TOKEN('PARAMETERS',
704: ' Invoice Id = ' || to_char(InvoiceId) ||
705: ', Supplier Id = ' || to_char(SuppId) ||
706: ', Payment Num = ' || to_char(PaymentNum) ||
707: ', Group Id = ' || to_char(GroupId) ||
707: ', Group Id = ' || to_char(GroupId) ||
708: ', Tax Name = ' || TaxName ||
709: ', CodeCombinationId = ' || to_char(CodeCombinationId));
710:
711: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
712: END IF;
713: APP_EXCEPTION.RAISE_EXCEPTION;
714:
715: END Insert_Temp_Distribution;
1016: RETURN(group_name);
1017: EXCEPTION
1018: WHEN OTHERS THEN
1019: IF (SQLCODE <> -20001) THEN
1020: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1021: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1022: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1023: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1024: 'Group_Id = ' || to_char(GroupId));
1017: EXCEPTION
1018: WHEN OTHERS THEN
1019: IF (SQLCODE <> -20001) THEN
1020: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1021: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1022: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1023: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1024: 'Group_Id = ' || to_char(GroupId));
1025:
1018: WHEN OTHERS THEN
1019: IF (SQLCODE <> -20001) THEN
1020: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1021: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1022: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1023: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1024: 'Group_Id = ' || to_char(GroupId));
1025:
1026: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1019: IF (SQLCODE <> -20001) THEN
1020: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1021: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1022: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1023: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1024: 'Group_Id = ' || to_char(GroupId));
1025:
1026: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1027: END IF;
1022: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1023: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1024: 'Group_Id = ' || to_char(GroupId));
1025:
1026: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1027: END IF;
1028: APP_EXCEPTION.RAISE_EXCEPTION;
1029: END Get_Group_Name;
1030:
1082:
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: IF (SQLCODE <> -20001) THEN
1086: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1087: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1088: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1089: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1090: ' Code Combination Id = ' || to_char(CodeCombinationId) ||
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: IF (SQLCODE <> -20001) THEN
1086: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1087: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1088: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1089: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1090: ' Code Combination Id = ' || to_char(CodeCombinationId) ||
1091: ', Accounting Date = ' || to_char(AccountingDate));
1084: WHEN OTHERS THEN
1085: IF (SQLCODE <> -20001) THEN
1086: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1087: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1088: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1089: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1090: ' Code Combination Id = ' || to_char(CodeCombinationId) ||
1091: ', Accounting Date = ' || to_char(AccountingDate));
1092:
1085: IF (SQLCODE <> -20001) THEN
1086: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1087: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1088: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1089: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1090: ' Code Combination Id = ' || to_char(CodeCombinationId) ||
1091: ', Accounting Date = ' || to_char(AccountingDate));
1092:
1093: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1089: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1090: ' Code Combination Id = ' || to_char(CodeCombinationId) ||
1091: ', Accounting Date = ' || to_char(AccountingDate));
1092:
1093: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1094: END IF;
1095: APP_EXCEPTION.RAISE_EXCEPTION;
1096: END GL_Account_INVALID;
1097:
1153:
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: IF (SQLCODE <> -20001) THEN
1157: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1160: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1161: ' Invoice Num = ' || InvNum ||
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: IF (SQLCODE <> -20001) THEN
1157: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1160: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1161: ' Invoice Num = ' || InvNum ||
1162: ', Tax Name = ' || TaxName ||
1155: WHEN OTHERS THEN
1156: IF (SQLCODE <> -20001) THEN
1157: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1160: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1161: ' Invoice Num = ' || InvNum ||
1162: ', Tax Name = ' || TaxName ||
1163: ', Amt Subject = ' || to_char(AmtSubject) ||
1156: IF (SQLCODE <> -20001) THEN
1157: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1160: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1161: ' Invoice Num = ' || InvNum ||
1162: ', Tax Name = ' || TaxName ||
1163: ', Amt Subject = ' || to_char(AmtSubject) ||
1164: ', Curr Code = ' || CurrCode ||
1165: ', Op Date = ' || to_char(OpDate) ||
1166: ', Supp Id = ' || to_char(SuppId) ||
1167: ', Supp Site Id = ' || to_char(SuppSiteId));
1168:
1169: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1170: END IF;
1171: APP_EXCEPTION.RAISE_EXCEPTION;
1172:
1173: END Get_Withholding_On_Exception;
1229:
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: IF (SQLCODE <> -20001) THEN
1233: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1234: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1235: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1236: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1237: ' Tax Name = ' || TaxName ||
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: IF (SQLCODE <> -20001) THEN
1233: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1234: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1235: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1236: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1237: ' Tax Name = ' || TaxName ||
1238: ', Amount Subject = ' || to_char(AmtSubject) ||
1231: WHEN OTHERS THEN
1232: IF (SQLCODE <> -20001) THEN
1233: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1234: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1235: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1236: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1237: ' Tax Name = ' || TaxName ||
1238: ', Amount Subject = ' || to_char(AmtSubject) ||
1239: ', Currency Code = ' || CurrCode ||
1232: IF (SQLCODE <> -20001) THEN
1233: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1234: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1235: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1236: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1237: ' Tax Name = ' || TaxName ||
1238: ', Amount Subject = ' || to_char(AmtSubject) ||
1239: ', Currency Code = ' || CurrCode ||
1240: ', Op Date = ' || to_char(OpDate));
1238: ', Amount Subject = ' || to_char(AmtSubject) ||
1239: ', Currency Code = ' || CurrCode ||
1240: ', Op Date = ' || to_char(OpDate));
1241:
1242: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1243: END IF;
1244: APP_EXCEPTION.RAISE_EXCEPTION;
1245: END Get_Normal_Withholding;
1246:
1303:
1304: EXCEPTION
1305: WHEN OTHERS THEN
1306: IF (SQLCODE <> -20001) THEN
1307: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1308: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1309: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1310: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1311: ' Tax Name = ' || TaxName ||
1304: EXCEPTION
1305: WHEN OTHERS THEN
1306: IF (SQLCODE <> -20001) THEN
1307: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1308: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1309: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1310: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1311: ' Tax Name = ' || TaxName ||
1312: ', Amount Subject = ' || to_char(AmtSubject) ||
1305: WHEN OTHERS THEN
1306: IF (SQLCODE <> -20001) THEN
1307: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1308: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1309: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1310: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1311: ' Tax Name = ' || TaxName ||
1312: ', Amount Subject = ' || to_char(AmtSubject) ||
1313: ', Currency Code = ' || CurrCode ||
1306: IF (SQLCODE <> -20001) THEN
1307: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1308: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1309: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1310: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1311: ' Tax Name = ' || TaxName ||
1312: ', Amount Subject = ' || to_char(AmtSubject) ||
1313: ', Currency Code = ' || CurrCode ||
1314: ', Op Date = ' || to_char(OpDate) ||
1314: ', Op Date = ' || to_char(OpDate) ||
1315: ', Supplier Id = ' || to_char(SuppId) ||
1316: ', Supp Site Id = ' || to_char(SuppSiteId) );
1317:
1318: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1319: END IF;
1320: APP_EXCEPTION.RAISE_EXCEPTION;
1321:
1322: END Get_Withholding_On_Certificate;
1725: RangesWTAmount := 0;
1726:
1727: WHEN OTHERS THEN
1728: IF (SQLCODE <> -20001) THEN
1729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1732: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1733: ' GroupId = ' || to_char(GroupId) ||
1726:
1727: WHEN OTHERS THEN
1728: IF (SQLCODE <> -20001) THEN
1729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1732: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1733: ' GroupId = ' || to_char(GroupId) ||
1734: ', Tax Name = ' || TaxName ||
1727: WHEN OTHERS THEN
1728: IF (SQLCODE <> -20001) THEN
1729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1732: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1733: ' GroupId = ' || to_char(GroupId) ||
1734: ', Tax Name = ' || TaxName ||
1735: ', CodeCombinationId = ' || to_char(CodeCombinationId) ||
1728: IF (SQLCODE <> -20001) THEN
1729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1732: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1733: ' GroupId = ' || to_char(GroupId) ||
1734: ', Tax Name = ' || TaxName ||
1735: ', CodeCombinationId = ' || to_char(CodeCombinationId) ||
1736: ', GLPeriodName = ' || GLPeriodName ||
1741: ', PaymentNum = ' || to_char(PaymentNum) ||
1742: ', AmtSubject = ' || to_char(AmtSubject) ||
1743: ', ExchangeRate = ' || to_char(ExchangeRate));
1744:
1745: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1746: END IF;
1747: APP_EXCEPTION.RAISE_EXCEPTION;
1748:
1749: END Get_Withholding_On_Ranges;
2932: BEGIN
2933: P_AWT_Success := error_text;
2934:
2935: IF (SQLCODE <> -20001) THEN
2936: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2937: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2938: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2939: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2940: ' Invoice Id = ' || to_char(P_Invoice_Id) ||
2933: P_AWT_Success := error_text;
2934:
2935: IF (SQLCODE <> -20001) THEN
2936: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2937: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2938: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2939: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2940: ' Invoice Id = ' || to_char(P_Invoice_Id) ||
2941: ', Awt Date = ' || to_char(P_Awt_Date) ||
2934:
2935: IF (SQLCODE <> -20001) THEN
2936: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2937: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2938: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2939: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2940: ' Invoice Id = ' || to_char(P_Invoice_Id) ||
2941: ', Awt Date = ' || to_char(P_Awt_Date) ||
2942: ', Calling Module = ' || P_Calling_Module ||
2935: IF (SQLCODE <> -20001) THEN
2936: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2937: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2938: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2939: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2940: ' Invoice Id = ' || to_char(P_Invoice_Id) ||
2941: ', Awt Date = ' || to_char(P_Awt_Date) ||
2942: ', Calling Module = ' || P_Calling_Module ||
2943: ', Create Dists = ' || P_Create_Dists ||
2944: ', Amount = ' || to_char(P_Amount) ||
2945: ', Payment Num = ' || to_char(P_Payment_Num) ||
2946: ', Checkrun Name = ' || P_Checkrun_Name);
2947:
2948: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2949: END IF;
2950: APP_EXCEPTION.RAISE_EXCEPTION;
2951: END;
2952: