eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_HOLDS_PKG dependencies on FND_MESSAGE

Line 193: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

189:
190: EXCEPTION
191: WHEN OTHERS THEN
192: IF (SQLCODE <> -20001) THEN
193: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
194: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
195: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
196: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
197: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||

Line 194: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

190: EXCEPTION
191: WHEN OTHERS THEN
192: IF (SQLCODE <> -20001) THEN
193: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
194: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
195: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
196: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
197: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||
198: ', LINE_LOCATION_ID = ' || TO_CHAR(X_Line_Location_Id) ||

Line 195: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

191: WHEN OTHERS THEN
192: IF (SQLCODE <> -20001) THEN
193: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
194: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
195: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
196: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
197: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||
198: ', LINE_LOCATION_ID = ' || TO_CHAR(X_Line_Location_Id) ||
199: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);

Line 196: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

192: IF (SQLCODE <> -20001) THEN
193: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
194: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
195: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
196: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
197: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||
198: ', LINE_LOCATION_ID = ' || TO_CHAR(X_Line_Location_Id) ||
199: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
200: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 200: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

196: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
197: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||
198: ', LINE_LOCATION_ID = ' || TO_CHAR(X_Line_Location_Id) ||
199: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
200: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
201: END IF;
202: APP_EXCEPTION.RAISE_EXCEPTION;
203:
204:

Line 262: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

258: FETCH C INTO Recinfo;
259: if (C%NOTFOUND) then
260: debug_info := 'Close cursor C - ROW NOTFOUND';
261: CLOSE C;
262: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
263: APP_EXCEPTION.Raise_Exception;
264: end if;
265: debug_info := 'Close cursor C';
266: CLOSE C;

Line 345: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

341: AND (X_Org_Id IS NULL)))
342: ) then
343: return;
344: else
345: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
346: APP_EXCEPTION.Raise_Exception;
347: end if;
348:
349: EXCEPTION

Line 353: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');

349: EXCEPTION
350: WHEN OTHERS THEN
351: IF (SQLCODE <> -20001) THEN
352: IF (SQLCODE = -54) THEN
353: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
354: ELSE
355: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
356: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

Line 355: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

351: IF (SQLCODE <> -20001) THEN
352: IF (SQLCODE = -54) THEN
353: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
354: ELSE
355: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
356: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
358: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
359: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||

Line 356: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

352: IF (SQLCODE = -54) THEN
353: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
354: ELSE
355: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
356: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
358: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
359: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||
360: ', LINE_LOCATION_ID = ' || TO_CHAR(X_Line_Location_Id) ||

Line 357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

353: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
354: ELSE
355: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
356: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
358: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
359: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||
360: ', LINE_LOCATION_ID = ' || TO_CHAR(X_Line_Location_Id) ||
361: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);

Line 358: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

354: ELSE
355: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
356: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
358: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
359: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||
360: ', LINE_LOCATION_ID = ' || TO_CHAR(X_Line_Location_Id) ||
361: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
362: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 362: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

358: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
359: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||
360: ', LINE_LOCATION_ID = ' || TO_CHAR(X_Line_Location_Id) ||
361: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
362: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
363: END IF;
364: END IF;
365: APP_EXCEPTION.RAISE_EXCEPTION;
366:

Line 513: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_CANNOT_REL_TAX_HOLDS');

509: p_error_code => l_error_code,
510: p_calling_sequence => current_calling_sequence);
511:
512: IF (NOT l_success) THEN
513: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_CANNOT_REL_TAX_HOLDS');
514: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
515: APP_EXCEPTION.RAISE_EXCEPTION;
516: END IF;
517:

Line 514: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);

510: p_calling_sequence => current_calling_sequence);
511:
512: IF (NOT l_success) THEN
513: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_CANNOT_REL_TAX_HOLDS');
514: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
515: APP_EXCEPTION.RAISE_EXCEPTION;
516: END IF;
517:
518: END IF;

Line 546: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_CANNOT_FRZ_INV');

542: p_calling_sequence => current_calling_sequence);
543:
544: IF (not l_success) THEN
545:
546: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_CANNOT_FRZ_INV');
547: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
548: APP_EXCEPTION.RAISE_EXCEPTION;
549:
550: END IF;

Line 547: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);

543:
544: IF (not l_success) THEN
545:
546: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_CANNOT_FRZ_INV');
547: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
548: APP_EXCEPTION.RAISE_EXCEPTION;
549:
550: END IF;
551:

Line 565: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

561:
562: EXCEPTION
563: WHEN OTHERS THEN
564: IF (SQLCODE <> -20001) THEN
565: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
566: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
567: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
568: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
569: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||

Line 566: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

562: EXCEPTION
563: WHEN OTHERS THEN
564: IF (SQLCODE <> -20001) THEN
565: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
566: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
567: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
568: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
569: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||
570: ', LINE_LOCATION_ID = ' || TO_CHAR(X_Line_Location_Id) ||

Line 567: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

563: WHEN OTHERS THEN
564: IF (SQLCODE <> -20001) THEN
565: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
566: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
567: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
568: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
569: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||
570: ', LINE_LOCATION_ID = ' || TO_CHAR(X_Line_Location_Id) ||
571: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);

Line 568: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

564: IF (SQLCODE <> -20001) THEN
565: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
566: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
567: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
568: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
569: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||
570: ', LINE_LOCATION_ID = ' || TO_CHAR(X_Line_Location_Id) ||
571: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
572: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 572: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

568: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
569: ', INVOICE_ID == ' || TO_CHAR(X_Invoice_Id) ||
570: ', LINE_LOCATION_ID = ' || TO_CHAR(X_Line_Location_Id) ||
571: ', HOLD_LOOKUP_CODE = ' || X_Hold_Lookup_Code);
572: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
573: END IF;
574: APP_EXCEPTION.RAISE_EXCEPTION;
575:
576: END Update_Row;

Line 617: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

613:
614: EXCEPTION
615: WHEN OTHERS THEN
616: IF (SQLCODE <> -20001) THEN
617: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
618: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
619: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
620: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 618: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

614: EXCEPTION
615: WHEN OTHERS THEN
616: IF (SQLCODE <> -20001) THEN
617: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
618: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
619: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
620: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
622: END IF;

Line 619: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

615: WHEN OTHERS THEN
616: IF (SQLCODE <> -20001) THEN
617: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
618: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
619: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
620: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
622: END IF;
623: APP_EXCEPTION.RAISE_EXCEPTION;

Line 620: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);

616: IF (SQLCODE <> -20001) THEN
617: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
618: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
619: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
620: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
622: END IF;
623: APP_EXCEPTION.RAISE_EXCEPTION;
624:

Line 621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

617: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
618: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
619: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
620: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
622: END IF;
623: APP_EXCEPTION.RAISE_EXCEPTION;
624:
625: END Delete_Row;

Line 779: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

775:
776: EXCEPTION
777: WHEN OTHERS THEN
778: IF (SQLCODE <> -20001) THEN
779: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
780: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
781: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
782: current_calling_sequence);
783:

Line 780: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

776: EXCEPTION
777: WHEN OTHERS THEN
778: IF (SQLCODE <> -20001) THEN
779: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
780: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
781: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
782: current_calling_sequence);
783:
784: FND_MESSAGE.SET_TOKEN('PARAMETERS',

Line 781: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

777: WHEN OTHERS THEN
778: IF (SQLCODE <> -20001) THEN
779: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
780: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
781: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
782: current_calling_sequence);
783:
784: FND_MESSAGE.SET_TOKEN('PARAMETERS',
785: 'X_invoice_id = ' ||X_invoice_id

Line 784: FND_MESSAGE.SET_TOKEN('PARAMETERS',

780: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
781: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
782: current_calling_sequence);
783:
784: FND_MESSAGE.SET_TOKEN('PARAMETERS',
785: 'X_invoice_id = ' ||X_invoice_id
786: ||', X_hold_lookup_code = '||X_hold_lookup_code
787: ||', X_hold_type = ' ||X_hold_type
788: ||', X_hold_reason = ' ||X_hold_reason

Line 792: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

788: ||', X_hold_reason = ' ||X_hold_reason
789: ||', X_held_by = ' ||X_held_by
790: );
791:
792: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
793: END IF;
794: APP_EXCEPTION.RAISE_EXCEPTION;
795:
796: END insert_single_hold;

Line 874: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

870:
871: EXCEPTION
872: WHEN OTHERS THEN
873: IF (SQLCODE <> -20001) THEN
874: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
875: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
876: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
877: current_calling_sequence);
878: FND_MESSAGE.SET_TOKEN('PARAMETERS',

Line 875: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

871: EXCEPTION
872: WHEN OTHERS THEN
873: IF (SQLCODE <> -20001) THEN
874: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
875: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
876: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
877: current_calling_sequence);
878: FND_MESSAGE.SET_TOKEN('PARAMETERS',
879: 'X_invoice_id = ' ||X_invoice_id

Line 876: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

872: WHEN OTHERS THEN
873: IF (SQLCODE <> -20001) THEN
874: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
875: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
876: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
877: current_calling_sequence);
878: FND_MESSAGE.SET_TOKEN('PARAMETERS',
879: 'X_invoice_id = ' ||X_invoice_id
880: ||', X_hold_lookup_code = ' ||X_hold_lookup_code

Line 878: FND_MESSAGE.SET_TOKEN('PARAMETERS',

874: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
875: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
876: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
877: current_calling_sequence);
878: FND_MESSAGE.SET_TOKEN('PARAMETERS',
879: 'X_invoice_id = ' ||X_invoice_id
880: ||', X_hold_lookup_code = ' ||X_hold_lookup_code
881: ||', X_release_lookup_code= '||X_release_lookup_code
882: ||', X_held_by = ' ||X_held_by

Line 884: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

880: ||', X_hold_lookup_code = ' ||X_hold_lookup_code
881: ||', X_release_lookup_code= '||X_release_lookup_code
882: ||', X_held_by = ' ||X_held_by
883: );
884: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
885: END IF;
886: APP_EXCEPTION.RAISE_EXCEPTION;
887:
888: END release_single_hold;

Line 1050: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_CANNOT_REL_TAX_HOLDS');

1046: p_error_code => l_error_code,
1047: p_calling_sequence => current_calling_sequence);
1048:
1049: IF (not l_success) THEN
1050: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_CANNOT_REL_TAX_HOLDS');
1051: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
1052: APP_EXCEPTION.RAISE_EXCEPTION;
1053: END IF;
1054:

Line 1051: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);

1047: p_calling_sequence => current_calling_sequence);
1048:
1049: IF (not l_success) THEN
1050: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_CANNOT_REL_TAX_HOLDS');
1051: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
1052: APP_EXCEPTION.RAISE_EXCEPTION;
1053: END IF;
1054:
1055: END IF;

Line 1068: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_CANNOT_FRZ_INV');

1064: p_calling_sequence => current_calling_sequence);
1065:
1066: IF (not l_success) THEN
1067:
1068: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_CANNOT_FRZ_INV');
1069: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
1070: APP_EXCEPTION.RAISE_EXCEPTION;
1071:
1072: END IF;

Line 1069: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);

1065:
1066: IF (not l_success) THEN
1067:
1068: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_CANNOT_FRZ_INV');
1069: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
1070: APP_EXCEPTION.RAISE_EXCEPTION;
1071:
1072: END IF;
1073:

Line 1088: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1084:
1085: EXCEPTION
1086: WHEN OTHERS THEN
1087: IF (SQLCODE <> -20001) THEN
1088: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1089: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1090: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1091: current_calling_sequence);
1092: FND_MESSAGE.SET_TOKEN('PARAMETERS',

Line 1089: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1085: EXCEPTION
1086: WHEN OTHERS THEN
1087: IF (SQLCODE <> -20001) THEN
1088: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1089: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1090: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1091: current_calling_sequence);
1092: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1093: 'X_invoice_id = ' ||TO_CHAR(X_invoice_id)

Line 1090: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

1086: WHEN OTHERS THEN
1087: IF (SQLCODE <> -20001) THEN
1088: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1089: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1090: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1091: current_calling_sequence);
1092: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1093: 'X_invoice_id = ' ||TO_CHAR(X_invoice_id)
1094: ||', X_hold_lookup_code = ' ||X_hold_lookup_code

Line 1092: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1088: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1089: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1090: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1091: current_calling_sequence);
1092: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1093: 'X_invoice_id = ' ||TO_CHAR(X_invoice_id)
1094: ||', X_hold_lookup_code = ' ||X_hold_lookup_code
1095: ||', X_release_lookup_code= '||X_release_lookup_code
1096: ||', X_release_reason= '||X_release_reason

Line 1104: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

1100: ||', X_holds_count= '||TO_CHAR(X_holds_count)
1101: ||', X_approval_status_lookup_code= '||
1102: X_approval_status_lookup_code
1103: );
1104: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1105: END IF;
1106: APP_EXCEPTION.RAISE_EXCEPTION;
1107:
1108: END quick_release;