DBA Data[Home] [Help]

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on FND_MESSAGE

Line 55: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');

51: distribution_line_number = X_DISTRIBUTION_LINE_NUMBER)
52: and ((X_ROWID is null) or (rowid <> X_ROWID));
53:
54: if (dummy >= 1) then
55: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
56: app_exception.raise_exception;
57: end if;
58:
59: EXCEPTION

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

58:
59: EXCEPTION
60: WHEN OTHERS THEN
61: if (SQLCODE <> -20001) then
62: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
63: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
64: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
65: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_ROWID
66: ||', Invoice Id = '||X_INVOICE_ID

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

59: EXCEPTION
60: WHEN OTHERS THEN
61: if (SQLCODE <> -20001) then
62: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
63: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
64: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
65: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_ROWID
66: ||', Invoice Id = '||X_INVOICE_ID
67: ||', Distribution line number = '||

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

60: WHEN OTHERS THEN
61: if (SQLCODE <> -20001) then
62: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
63: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
64: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
65: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_ROWID
66: ||', Invoice Id = '||X_INVOICE_ID
67: ||', Distribution line number = '||
68: X_DISTRIBUTION_LINE_NUMBER);

Line 65: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_ROWID

61: if (SQLCODE <> -20001) then
62: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
63: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
64: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
65: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_ROWID
66: ||', Invoice Id = '||X_INVOICE_ID
67: ||', Distribution line number = '||
68: X_DISTRIBUTION_LINE_NUMBER);
69: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

65: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_ROWID
66: ||', Invoice Id = '||X_INVOICE_ID
67: ||', Distribution line number = '||
68: X_DISTRIBUTION_LINE_NUMBER);
69: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
70: end if;
71: APP_EXCEPTION.RAISE_EXCEPTION;
72: end CHECK_UNIQUE;
73:

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

284:
285: EXCEPTION
286: WHEN OTHERS THEN
287: if (SQLCODE <> -20001) then
288: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
289: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
290: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
291: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||X_Invoice_Id
292: ||',Total = '||X_Total

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

285: EXCEPTION
286: WHEN OTHERS THEN
287: if (SQLCODE <> -20001) then
288: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
289: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
290: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
291: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||X_Invoice_Id
292: ||',Total = '||X_Total
293: ||',Total RTOT DB = '||

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

286: WHEN OTHERS THEN
287: if (SQLCODE <> -20001) then
288: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
289: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
290: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
291: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||X_Invoice_Id
292: ||',Total = '||X_Total
293: ||',Total RTOT DB = '||
294: X_Total_Rtot_DB);

Line 291: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||X_Invoice_Id

287: if (SQLCODE <> -20001) then
288: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
289: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
290: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
291: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||X_Invoice_Id
292: ||',Total = '||X_Total
293: ||',Total RTOT DB = '||
294: X_Total_Rtot_DB);
295: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

291: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||X_Invoice_Id
292: ||',Total = '||X_Total
293: ||',Total RTOT DB = '||
294: X_Total_Rtot_DB);
295: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
296: end if;
297: APP_EXCEPTION.RAISE_EXCEPTION;
298: END Select_Summary;
299:

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

326:
327: EXCEPTION
328: WHEN OTHERS THEN
329: if (SQLCODE <> -20001) then
330: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
331: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
332: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
333: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
334: ||', Packet Id = '||X_Packet_Id);

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

327: EXCEPTION
328: WHEN OTHERS THEN
329: if (SQLCODE <> -20001) then
330: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
331: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
332: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
333: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
334: ||', Packet Id = '||X_Packet_Id);
335: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

328: WHEN OTHERS THEN
329: if (SQLCODE <> -20001) then
330: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
331: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
332: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
333: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
334: ||', Packet Id = '||X_Packet_Id);
335: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
336: end if;

Line 333: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id

329: if (SQLCODE <> -20001) then
330: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
331: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
332: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
333: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
334: ||', Packet Id = '||X_Packet_Id);
335: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
336: end if;
337: APP_EXCEPTION.RAISE_EXCEPTION;

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

331: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
332: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
333: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
334: ||', Packet Id = '||X_Packet_Id);
335: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
336: end if;
337: APP_EXCEPTION.RAISE_EXCEPTION;
338:
339: END Set_Inv_Packet_Id;

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

374: WHEN NO_DATA_FOUND THEN
375: RETURN(FALSE);
376: WHEN OTHERS THEN
377: if (SQLCODE <> -20001) then
378: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
379: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
380: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
381: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_Rowid
382: ||', Packet Id = '||X_Packet_Id);

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

375: RETURN(FALSE);
376: WHEN OTHERS THEN
377: if (SQLCODE <> -20001) then
378: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
379: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
380: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
381: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_Rowid
382: ||', Packet Id = '||X_Packet_Id);
383: end if;

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

376: WHEN OTHERS THEN
377: if (SQLCODE <> -20001) then
378: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
379: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
380: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
381: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_Rowid
382: ||', Packet Id = '||X_Packet_Id);
383: end if;
384: APP_EXCEPTION.RAISE_EXCEPTION;

Line 381: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_Rowid

377: if (SQLCODE <> -20001) then
378: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
379: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
380: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
381: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_Rowid
382: ||', Packet Id = '||X_Packet_Id);
383: end if;
384: APP_EXCEPTION.RAISE_EXCEPTION;
385: END Query_New_Packet_Id;

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

423: WHEN NO_DATA_FOUND THEN
424: RETURN(FALSE);
425: WHEN OTHERS THEN
426: if (SQLCODE <> -20001) then
427: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
428: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
429: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
430: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
431: ||', Rowid = '||X_Rowid);

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

424: RETURN(FALSE);
425: WHEN OTHERS THEN
426: if (SQLCODE <> -20001) then
427: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
428: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
429: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
430: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
431: ||', Rowid = '||X_Rowid);
432: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

425: WHEN OTHERS THEN
426: if (SQLCODE <> -20001) then
427: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
428: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
429: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
430: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
431: ||', Rowid = '||X_Rowid);
432: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
433: end if;

Line 430: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id

426: if (SQLCODE <> -20001) then
427: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
428: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
429: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
430: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
431: ||', Rowid = '||X_Rowid);
432: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
433: end if;
434: APP_EXCEPTION.RAISE_EXCEPTION;

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

428: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
429: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
430: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
431: ||', Rowid = '||X_Rowid);
432: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
433: end if;
434: APP_EXCEPTION.RAISE_EXCEPTION;
435: END All_Encumbered;
436:

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

521:
522: EXCEPTION
523: WHEN OTHERS THEN
524: if (SQLCODE <> -20001) then
525: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
526: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
527: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
528: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id);
529: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

522: EXCEPTION
523: WHEN OTHERS THEN
524: if (SQLCODE <> -20001) then
525: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
526: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
527: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
528: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id);
529: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
530: end if;

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

523: WHEN OTHERS THEN
524: if (SQLCODE <> -20001) then
525: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
526: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
527: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
528: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id);
529: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
530: end if;
531: APP_EXCEPTION.RAISE_EXCEPTION;

Line 528: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id);

524: if (SQLCODE <> -20001) then
525: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
526: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
527: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
528: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id);
529: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
530: end if;
531: APP_EXCEPTION.RAISE_EXCEPTION;
532:

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

525: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
526: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
527: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
528: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id);
529: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
530: end if;
531: APP_EXCEPTION.RAISE_EXCEPTION;
532:
533: END Check_Cash_Basis_Paid;

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

625:
626: EXCEPTION
627: WHEN OTHERS THEN
628: if (SQLCODE <> -20001) then
629: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
630: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
631: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
632: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||
633: X_PO_Distribution_Id||', Line location Id = '||

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

626: EXCEPTION
627: WHEN OTHERS THEN
628: if (SQLCODE <> -20001) then
629: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
630: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
631: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
632: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||
633: X_PO_Distribution_Id||', Line location Id = '||
634: X_Line_Location_Id||', Quantity Billed = '||

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

627: WHEN OTHERS THEN
628: if (SQLCODE <> -20001) then
629: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
630: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
631: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
632: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||
633: X_PO_Distribution_Id||', Line location Id = '||
634: X_Line_Location_Id||', Quantity Billed = '||
635: X_Quantity_Billed||', Amount Billed = '||

Line 632: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||

628: if (SQLCODE <> -20001) then
629: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
630: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
631: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
632: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||
633: X_PO_Distribution_Id||', Line location Id = '||
634: X_Line_Location_Id||', Quantity Billed = '||
635: X_Quantity_Billed||', Amount Billed = '||
636: X_Amount_Billed);

Line 637: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

633: X_PO_Distribution_Id||', Line location Id = '||
634: X_Line_Location_Id||', Quantity Billed = '||
635: X_Quantity_Billed||', Amount Billed = '||
636: X_Amount_Billed);
637: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
638: end if;
639: APP_EXCEPTION.RAISE_EXCEPTION;
640:
641: END Adjust_PO;

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

675:
676: EXCEPTION
677: WHEN OTHERS THEN
678: if (SQLCODE <> -20001) then
679: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
680: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
681: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
682: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'String = '||X_String
683: ||', Start = '||X_Start

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

676: EXCEPTION
677: WHEN OTHERS THEN
678: if (SQLCODE <> -20001) then
679: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
680: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
681: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
682: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'String = '||X_String
683: ||', Start = '||X_Start
684: ||', End = '||X_End);

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

677: WHEN OTHERS THEN
678: if (SQLCODE <> -20001) then
679: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
680: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
681: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
682: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'String = '||X_String
683: ||', Start = '||X_Start
684: ||', End = '||X_End);
685: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

Line 682: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'String = '||X_String

678: if (SQLCODE <> -20001) then
679: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
680: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
681: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
682: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'String = '||X_String
683: ||', Start = '||X_Start
684: ||', End = '||X_End);
685: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
686: END IF;

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

681: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
682: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'String = '||X_String
683: ||', Start = '||X_Start
684: ||', End = '||X_End);
685: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
686: END IF;
687: APP_EXCEPTION.RAISE_EXCEPTION;
688:
689: END Substrbyte;

Line 1764: FND_MESSAGE.SET_NAME(l_msg_application, l_msg_data);

1760: X_msg_data => l_msg_data,
1761: X_BILLABLE_FLAG => l_billable_flag);
1762:
1763: IF (l_msg_data is not null) THEN
1764: FND_MESSAGE.SET_NAME(l_msg_application, l_msg_data);
1765: -- For bug3469917. Need to add token values for non-PA applications.
1766:
1767: if (l_msg_application <> 'PA') Then
1768:

Line 1771: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);

1767: if (l_msg_application <> 'PA') Then
1768:
1769:
1770: IF (l_msg_token1 IS NOT NULL) THEN
1771: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
1772: ELSE
1773: fnd_message.set_token('PATC_MSG_TOKEN1',app_api.G_NULL_CHAR);
1774: END IF;
1775: IF (l_msg_token2 IS NOT NULL) THEN

Line 1773: fnd_message.set_token('PATC_MSG_TOKEN1',app_api.G_NULL_CHAR);

1769:
1770: IF (l_msg_token1 IS NOT NULL) THEN
1771: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
1772: ELSE
1773: fnd_message.set_token('PATC_MSG_TOKEN1',app_api.G_NULL_CHAR);
1774: END IF;
1775: IF (l_msg_token2 IS NOT NULL) THEN
1776: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
1777: ELSE

Line 1776: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

1772: ELSE
1773: fnd_message.set_token('PATC_MSG_TOKEN1',app_api.G_NULL_CHAR);
1774: END IF;
1775: IF (l_msg_token2 IS NOT NULL) THEN
1776: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
1777: ELSE
1778: fnd_message.set_token('PATC_MSG_TOKEN2',app_api.G_NULL_CHAR);
1779: END IF;
1780: IF (l_msg_token3 IS NOT NULL) THEN

Line 1778: fnd_message.set_token('PATC_MSG_TOKEN2',app_api.G_NULL_CHAR);

1774: END IF;
1775: IF (l_msg_token2 IS NOT NULL) THEN
1776: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
1777: ELSE
1778: fnd_message.set_token('PATC_MSG_TOKEN2',app_api.G_NULL_CHAR);
1779: END IF;
1780: IF (l_msg_token3 IS NOT NULL) THEN
1781: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
1782: ELSE

Line 1781: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

1777: ELSE
1778: fnd_message.set_token('PATC_MSG_TOKEN2',app_api.G_NULL_CHAR);
1779: END IF;
1780: IF (l_msg_token3 IS NOT NULL) THEN
1781: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
1782: ELSE
1783: fnd_message.set_token('PATC_MSG_TOKEN3',app_api.G_NULL_CHAR);
1784: END IF;
1785:

Line 1783: fnd_message.set_token('PATC_MSG_TOKEN3',app_api.G_NULL_CHAR);

1779: END IF;
1780: IF (l_msg_token3 IS NOT NULL) THEN
1781: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
1782: ELSE
1783: fnd_message.set_token('PATC_MSG_TOKEN3',app_api.G_NULL_CHAR);
1784: END IF;
1785:
1786: end if;
1787:

Line 1853: fnd_message.set_encoded(l_errmsg);

1849: x_concat_descrs => l_concat_descrs,
1850: x_error_message => l_errmsg,
1851: x_award_set_id => l_award_id )) THEN
1852:
1853: fnd_message.set_encoded(l_errmsg);
1854: app_exception.raise_exception;
1855: END IF;
1856: */
1857: /* null;

Line 1909: FND_MESSAGE.SET_ENCODED(l_errmsg);

1905: x_concat_descrs => l_concat_descrs,
1906: x_error_message => l_errmsg,
1907: x_award_set_id => l_award_id )) THEN
1908:
1909: FND_MESSAGE.SET_ENCODED(l_errmsg);
1910: app_exception.raise_exception;
1911:
1912: END IF;
1913: */

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

1953:
1954: EXCEPTION
1955: WHEN OTHERS THEN
1956: IF (SQLCODE <> -20001) THEN
1957: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1958: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1959: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1960: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1961: 'X_invoice_id = ' ||X_invoice_id

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

1954: EXCEPTION
1955: WHEN OTHERS THEN
1956: IF (SQLCODE <> -20001) THEN
1957: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1958: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1959: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1960: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1961: 'X_invoice_id = ' ||X_invoice_id
1962: ||', X_line_number = ' ||X_line_number

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

1955: WHEN OTHERS THEN
1956: IF (SQLCODE <> -20001) THEN
1957: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1958: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1959: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1960: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1961: 'X_invoice_id = ' ||X_invoice_id
1962: ||', X_line_number = ' ||X_line_number
1963: ||', X_type_1099 = ' ||X_type_1099

Line 1960: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1956: IF (SQLCODE <> -20001) THEN
1957: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1958: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1959: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1960: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1961: 'X_invoice_id = ' ||X_invoice_id
1962: ||', X_line_number = ' ||X_line_number
1963: ||', X_type_1099 = ' ||X_type_1099
1964: ||', X_income_tax_region = ' ||X_income_tax_region

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

1966: ||', X_update_base = ' ||X_update_base
1967: ||', X_reset_match_status = ' ||X_reset_match_status
1968: ||', X_update_occurred = ' ||X_update_occurred
1969: );
1970: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1971: END IF;
1972: APP_EXCEPTION.RAISE_EXCEPTION;
1973: END Update_Distributions;
1974:

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

2254:
2255: EXCEPTION
2256: WHEN OTHERS THEN
2257: if (SQLCODE <> -20001) then
2258: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2259: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2260: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2261: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2262: end if;

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

2255: EXCEPTION
2256: WHEN OTHERS THEN
2257: if (SQLCODE <> -20001) then
2258: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2259: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2260: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2261: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2262: end if;
2263: APP_EXCEPTION.RAISE_EXCEPTION;

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

2256: WHEN OTHERS THEN
2257: if (SQLCODE <> -20001) then
2258: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2259: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2260: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2261: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2262: end if;
2263: APP_EXCEPTION.RAISE_EXCEPTION;
2264:

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

2257: if (SQLCODE <> -20001) then
2258: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2259: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2260: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2261: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2262: end if;
2263: APP_EXCEPTION.RAISE_EXCEPTION;
2264:
2265: END Insert_Row;

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

2571: FETCH C INTO Recinfo;
2572: if (C%NOTFOUND) then
2573: debug_info := 'Close cursor C - ROW NOTFOUND';
2574: CLOSE C;
2575: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
2576: APP_EXCEPTION.Raise_Exception;
2577: end if;
2578: debug_info := 'Close cursor C';
2579: CLOSE C;

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

2666: OR ( (Recinfo.attribute13 IS NULL)
2667: AND (X_Attribute13 IS NULL)))) then
2668: null;
2669: else
2670: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2671: APP_EXCEPTION.Raise_Exception;
2672: end if;
2673:
2674: if (

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

2807:
2808: ) then
2809: null;
2810: else
2811: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2812: APP_EXCEPTION.Raise_Exception;
2813: end if;
2814:
2815: if (

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

2878: AND (X_global_attribute20 IS NULL)))
2879: ) then
2880: return;
2881: else
2882: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2883: APP_EXCEPTION.Raise_Exception;
2884: end if;
2885:
2886: -- Invoice Lines Project Stage 1

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

2908: AND (X_INTENDED_USE IS NULL)))
2909: ) then
2910: return;
2911: else
2912: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2913: APP_EXCEPTION.Raise_Exception;
2914: end if;
2915:
2916: EXCEPTION

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

2916: EXCEPTION
2917: WHEN OTHERS THEN
2918: if (SQLCODE <> -20001) then
2919: IF (SQLCODE = -54) THEN
2920: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
2921: ELSE
2922: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2923: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

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

2918: if (SQLCODE <> -20001) then
2919: IF (SQLCODE = -54) THEN
2920: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
2921: ELSE
2922: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2923: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2925: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2926: END IF;

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

2919: IF (SQLCODE = -54) THEN
2920: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
2921: ELSE
2922: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2923: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2925: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2926: END IF;
2927: end if;

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

2920: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
2921: ELSE
2922: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2923: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2925: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2926: END IF;
2927: end if;
2928: APP_EXCEPTION.RAISE_EXCEPTION;

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

2921: ELSE
2922: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2923: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2925: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2926: END IF;
2927: end if;
2928: APP_EXCEPTION.RAISE_EXCEPTION;
2929:

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

3182:
3183: EXCEPTION
3184: WHEN OTHERS THEN
3185: if (SQLCODE <> -20001) then
3186: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3187: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3189: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3190: end if;

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

3183: EXCEPTION
3184: WHEN OTHERS THEN
3185: if (SQLCODE <> -20001) then
3186: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3187: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3189: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3190: end if;
3191: APP_EXCEPTION.RAISE_EXCEPTION;

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

3184: WHEN OTHERS THEN
3185: if (SQLCODE <> -20001) then
3186: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3187: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3189: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3190: end if;
3191: APP_EXCEPTION.RAISE_EXCEPTION;
3192:

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

3185: if (SQLCODE <> -20001) then
3186: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3187: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3189: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3190: end if;
3191: APP_EXCEPTION.RAISE_EXCEPTION;
3192:
3193: END Update_Row;

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

3212:
3213: EXCEPTION
3214: WHEN OTHERS THEN
3215: if (SQLCODE <> -20001) then
3216: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3217: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3218: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3219: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3220: end if;

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

3213: EXCEPTION
3214: WHEN OTHERS THEN
3215: if (SQLCODE <> -20001) then
3216: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3217: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3218: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3219: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3220: end if;
3221: APP_EXCEPTION.RAISE_EXCEPTION;

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

3214: WHEN OTHERS THEN
3215: if (SQLCODE <> -20001) then
3216: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3217: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3218: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3219: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3220: end if;
3221: APP_EXCEPTION.RAISE_EXCEPTION;
3222:

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

3215: if (SQLCODE <> -20001) then
3216: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3217: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3218: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3219: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3220: end if;
3221: APP_EXCEPTION.RAISE_EXCEPTION;
3222:
3223: END Delete_Row;

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

3607:
3608: EXCEPTION
3609: WHEN OTHERS THEN
3610: IF (SQLCODE <> -20001) THEN
3611: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3612: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3613: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3614: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3615: END IF;

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

3608: EXCEPTION
3609: WHEN OTHERS THEN
3610: IF (SQLCODE <> -20001) THEN
3611: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3612: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3613: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3614: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3615: END IF;
3616: APP_EXCEPTION.RAISE_EXCEPTION;

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

3609: WHEN OTHERS THEN
3610: IF (SQLCODE <> -20001) THEN
3611: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3612: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3613: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3614: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3615: END IF;
3616: APP_EXCEPTION.RAISE_EXCEPTION;
3617:

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

3610: IF (SQLCODE <> -20001) THEN
3611: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3612: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3613: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3614: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3615: END IF;
3616: APP_EXCEPTION.RAISE_EXCEPTION;
3617:
3618: END Round_Biggest_Distribution;

Line 4120: Fnd_Message.Set_Name(l_msg_application, l_msg_data);

4116: IF (l_msg_data is not null) THEN
4117: X_msg_application := l_msg_application;
4118: X_msg_data := l_msg_data;
4119: --bugfix:5725904
4120: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
4121: /*bug 6682104 setting the token values*/
4122: IF (l_msg_token1 IS NOT NULL) THEN
4123: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
4124: ELSE

Line 4123: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);

4119: --bugfix:5725904
4120: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
4121: /*bug 6682104 setting the token values*/
4122: IF (l_msg_token1 IS NOT NULL) THEN
4123: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
4124: ELSE
4125: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
4126: END IF;
4127:

Line 4125: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);

4121: /*bug 6682104 setting the token values*/
4122: IF (l_msg_token1 IS NOT NULL) THEN
4123: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
4124: ELSE
4125: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
4126: END IF;
4127:
4128: IF (l_msg_token2 IS NOT NULL) THEN
4129: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

Line 4129: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

4125: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
4126: END IF;
4127:
4128: IF (l_msg_token2 IS NOT NULL) THEN
4129: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
4130: ELSE
4131: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
4132: END IF;
4133:

Line 4131: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);

4127:
4128: IF (l_msg_token2 IS NOT NULL) THEN
4129: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
4130: ELSE
4131: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
4132: END IF;
4133:
4134: IF (l_msg_token3 IS NOT NULL) THEN
4135: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

Line 4135: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

4131: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
4132: END IF;
4133:
4134: IF (l_msg_token3 IS NOT NULL) THEN
4135: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
4136: ELSE
4137: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
4138: END IF;
4139: l_message_text := Fnd_Message.get;

Line 4137: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);

4133:
4134: IF (l_msg_token3 IS NOT NULL) THEN
4135: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
4136: ELSE
4137: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
4138: END IF;
4139: l_message_text := Fnd_Message.get;
4140: X_Error_Code := l_message_text;
4141:

Line 4139: l_message_text := Fnd_Message.get;

4135: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
4136: ELSE
4137: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
4138: END IF;
4139: l_message_text := Fnd_Message.get;
4140: X_Error_Code := l_message_text;
4141:
4142: return(FALSE);
4143: END IF;

Line 4978: Fnd_Message.Set_Name(l_msg_application, l_msg_data);

4974: if (l_msg_data is not null) then
4975: X_msg_application := l_msg_application;
4976: X_msg_data := l_msg_data;
4977: --bugfix:5725904
4978: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
4979: /*bug 6682104 setting the token values*/
4980: IF (l_msg_token1 IS NOT NULL) THEN
4981: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
4982: ELSE

Line 4981: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);

4977: --bugfix:5725904
4978: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
4979: /*bug 6682104 setting the token values*/
4980: IF (l_msg_token1 IS NOT NULL) THEN
4981: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
4982: ELSE
4983: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
4984: END IF;
4985:

Line 4983: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);

4979: /*bug 6682104 setting the token values*/
4980: IF (l_msg_token1 IS NOT NULL) THEN
4981: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
4982: ELSE
4983: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
4984: END IF;
4985:
4986: IF (l_msg_token2 IS NOT NULL) THEN
4987: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

Line 4987: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

4983: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
4984: END IF;
4985:
4986: IF (l_msg_token2 IS NOT NULL) THEN
4987: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
4988: ELSE
4989: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
4990: END IF;
4991:

Line 4989: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);

4985:
4986: IF (l_msg_token2 IS NOT NULL) THEN
4987: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
4988: ELSE
4989: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
4990: END IF;
4991:
4992: IF (l_msg_token3 IS NOT NULL) THEN
4993: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

Line 4993: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

4989: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
4990: END IF;
4991:
4992: IF (l_msg_token3 IS NOT NULL) THEN
4993: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
4994: ELSE
4995: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
4996: END IF;
4997: l_message_text := Fnd_Message.get;

Line 4995: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);

4991:
4992: IF (l_msg_token3 IS NOT NULL) THEN
4993: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
4994: ELSE
4995: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
4996: END IF;
4997: l_message_text := Fnd_Message.get;
4998: x_error_code := l_message_text;
4999:

Line 4997: l_message_text := Fnd_Message.get;

4993: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
4994: ELSE
4995: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
4996: END IF;
4997: l_message_text := Fnd_Message.get;
4998: x_error_code := l_message_text;
4999:
5000: return(FALSE);
5001:

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

7130:
7131: EXCEPTION
7132: WHEN OTHERS THEN
7133: IF (SQLCODE <> -20001) then
7134: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7135: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7136: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7137: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'distribution Id = '
7138: || X_distribution_Id);

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

7131: EXCEPTION
7132: WHEN OTHERS THEN
7133: IF (SQLCODE <> -20001) then
7134: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7135: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7136: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7137: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'distribution Id = '
7138: || X_distribution_Id);
7139: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

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

7132: WHEN OTHERS THEN
7133: IF (SQLCODE <> -20001) then
7134: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7135: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7136: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7137: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'distribution Id = '
7138: || X_distribution_Id);
7139: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7140: END IF;

Line 7137: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'distribution Id = '

7133: IF (SQLCODE <> -20001) then
7134: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7135: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7136: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7137: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'distribution Id = '
7138: || X_distribution_Id);
7139: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7140: END IF;
7141:

Line 7139: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

7135: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7136: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7137: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'distribution Id = '
7138: || X_distribution_Id);
7139: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7140: END IF;
7141:
7142: l_debug_info := 'CALCULATE_VARIANCE - OTHERS exception exists';
7143: x_debug_info := l_debug_info;

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

7194:
7195: Exception
7196: WHEN OTHERS THEN
7197: If (SQLCODE <> -20001) Then
7198: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7199: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7200: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7201: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
7202: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

7195: Exception
7196: WHEN OTHERS THEN
7197: If (SQLCODE <> -20001) Then
7198: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7199: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7200: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7201: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
7202: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
7203: End If;

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

7196: WHEN OTHERS THEN
7197: If (SQLCODE <> -20001) Then
7198: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7199: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7200: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7201: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
7202: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
7203: End If;
7204: APP_EXCEPTION.RAISE_EXCEPTION;

Line 7201: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);

7197: If (SQLCODE <> -20001) Then
7198: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7199: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7200: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7201: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
7202: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
7203: End If;
7204: APP_EXCEPTION.RAISE_EXCEPTION;
7205:

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

7198: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7199: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7200: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7201: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
7202: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
7203: End If;
7204: APP_EXCEPTION.RAISE_EXCEPTION;
7205:
7206:

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

7257:
7258: Exception
7259: WHEN OTHERS THEN
7260: If (SQLCODE <> -20001) Then
7261: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7262: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7263: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7264: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
7265: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

7258: Exception
7259: WHEN OTHERS THEN
7260: If (SQLCODE <> -20001) Then
7261: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7262: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7263: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7264: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
7265: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
7266: End If;

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

7259: WHEN OTHERS THEN
7260: If (SQLCODE <> -20001) Then
7261: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7262: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7263: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7264: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
7265: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
7266: End If;
7267: APP_EXCEPTION.RAISE_EXCEPTION;

Line 7264: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);

7260: If (SQLCODE <> -20001) Then
7261: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7262: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7263: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7264: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
7265: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
7266: End If;
7267: APP_EXCEPTION.RAISE_EXCEPTION;
7268: END Chrg_Refer_Active_Dist;

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

7261: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7262: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7263: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7264: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
7265: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
7266: End If;
7267: APP_EXCEPTION.RAISE_EXCEPTION;
7268: END Chrg_Refer_Active_Dist;
7269:

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

7352:
7353: EXCEPTION
7354: WHEN OTHERS THEN
7355: IF (SQLCODE <> -20001) THEN
7356: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7357: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7358: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7359: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||P_Invoice_Id);
7360: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

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

7353: EXCEPTION
7354: WHEN OTHERS THEN
7355: IF (SQLCODE <> -20001) THEN
7356: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7357: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7358: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7359: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||P_Invoice_Id);
7360: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7361: END IF;

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

7354: WHEN OTHERS THEN
7355: IF (SQLCODE <> -20001) THEN
7356: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7357: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7358: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7359: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||P_Invoice_Id);
7360: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7361: END IF;
7362: APP_EXCEPTION.RAISE_EXCEPTION;

Line 7359: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||P_Invoice_Id);

7355: IF (SQLCODE <> -20001) THEN
7356: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7357: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7358: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7359: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||P_Invoice_Id);
7360: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7361: END IF;
7362: APP_EXCEPTION.RAISE_EXCEPTION;
7363:

Line 7360: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

7356: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7357: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7358: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
7359: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||P_Invoice_Id);
7360: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7361: END IF;
7362: APP_EXCEPTION.RAISE_EXCEPTION;
7363:
7364: END Make_Distributions_Permanent;

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

7401:
7402: EXCEPTION
7403: WHEN OTHERS THEN
7404: IF (SQLCODE <> -20001) THEN
7405: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7406: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7407: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Distribution Id = '
7408: ||P_Invoice_Distribution_Id);
7409: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

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

7402: EXCEPTION
7403: WHEN OTHERS THEN
7404: IF (SQLCODE <> -20001) THEN
7405: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7406: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7407: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Distribution Id = '
7408: ||P_Invoice_Distribution_Id);
7409: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7410: END IF;

Line 7407: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Distribution Id = '

7403: WHEN OTHERS THEN
7404: IF (SQLCODE <> -20001) THEN
7405: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7406: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7407: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Distribution Id = '
7408: ||P_Invoice_Distribution_Id);
7409: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7410: END IF;
7411: APP_EXCEPTION.RAISE_EXCEPTION;

Line 7409: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

7405: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
7406: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
7407: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Distribution Id = '
7408: ||P_Invoice_Distribution_Id);
7409: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7410: END IF;
7411: APP_EXCEPTION.RAISE_EXCEPTION;
7412:
7413: END Associated_Charges;