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_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 296: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

292:
293: EXCEPTION
294: WHEN OTHERS THEN
295: if (SQLCODE <> -20001) then
296: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
297: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
298: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
299: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||X_Invoice_Id
300: ||',Total = '||X_Total

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

293: EXCEPTION
294: WHEN OTHERS THEN
295: if (SQLCODE <> -20001) then
296: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
297: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
298: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
299: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||X_Invoice_Id
300: ||',Total = '||X_Total
301: ||',Total RTOT DB = '||

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

294: WHEN OTHERS THEN
295: if (SQLCODE <> -20001) then
296: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
297: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
298: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
299: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||X_Invoice_Id
300: ||',Total = '||X_Total
301: ||',Total RTOT DB = '||
302: X_Total_Rtot_DB);

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

295: if (SQLCODE <> -20001) then
296: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
297: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
298: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
299: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||X_Invoice_Id
300: ||',Total = '||X_Total
301: ||',Total RTOT DB = '||
302: X_Total_Rtot_DB);
303: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

299: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||X_Invoice_Id
300: ||',Total = '||X_Total
301: ||',Total RTOT DB = '||
302: X_Total_Rtot_DB);
303: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
304: end if;
305: APP_EXCEPTION.RAISE_EXCEPTION;
306: END Select_Summary;
307:

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

334:
335: EXCEPTION
336: WHEN OTHERS THEN
337: if (SQLCODE <> -20001) then
338: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
339: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
340: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
341: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
342: ||', Packet Id = '||X_Packet_Id);

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

335: EXCEPTION
336: WHEN OTHERS THEN
337: if (SQLCODE <> -20001) then
338: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
339: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
340: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
341: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
342: ||', Packet Id = '||X_Packet_Id);
343: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

336: WHEN OTHERS THEN
337: if (SQLCODE <> -20001) then
338: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
339: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
340: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
341: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
342: ||', Packet Id = '||X_Packet_Id);
343: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
344: end if;

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

337: if (SQLCODE <> -20001) then
338: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
339: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
340: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
341: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
342: ||', Packet Id = '||X_Packet_Id);
343: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
344: end if;
345: APP_EXCEPTION.RAISE_EXCEPTION;

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

339: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
340: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
341: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
342: ||', Packet Id = '||X_Packet_Id);
343: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
344: end if;
345: APP_EXCEPTION.RAISE_EXCEPTION;
346:
347: END Set_Inv_Packet_Id;

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

382: WHEN NO_DATA_FOUND THEN
383: RETURN(FALSE);
384: WHEN OTHERS THEN
385: if (SQLCODE <> -20001) then
386: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
387: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
388: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
389: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_Rowid
390: ||', Packet Id = '||X_Packet_Id);

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

383: RETURN(FALSE);
384: WHEN OTHERS THEN
385: if (SQLCODE <> -20001) then
386: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
387: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
388: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
389: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_Rowid
390: ||', Packet Id = '||X_Packet_Id);
391: end if;

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

384: WHEN OTHERS THEN
385: if (SQLCODE <> -20001) then
386: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
387: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
388: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
389: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_Rowid
390: ||', Packet Id = '||X_Packet_Id);
391: end if;
392: APP_EXCEPTION.RAISE_EXCEPTION;

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

385: if (SQLCODE <> -20001) then
386: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
387: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
388: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
389: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||X_Rowid
390: ||', Packet Id = '||X_Packet_Id);
391: end if;
392: APP_EXCEPTION.RAISE_EXCEPTION;
393: END Query_New_Packet_Id;

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

431: WHEN NO_DATA_FOUND THEN
432: RETURN(FALSE);
433: WHEN OTHERS THEN
434: if (SQLCODE <> -20001) then
435: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
436: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
437: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
438: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
439: ||', Rowid = '||X_Rowid);

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

432: RETURN(FALSE);
433: WHEN OTHERS THEN
434: if (SQLCODE <> -20001) then
435: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
436: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
437: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
438: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
439: ||', Rowid = '||X_Rowid);
440: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

433: WHEN OTHERS THEN
434: if (SQLCODE <> -20001) then
435: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
436: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
437: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
438: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
439: ||', Rowid = '||X_Rowid);
440: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
441: end if;

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

434: if (SQLCODE <> -20001) then
435: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
436: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
437: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
438: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
439: ||', Rowid = '||X_Rowid);
440: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
441: end if;
442: APP_EXCEPTION.RAISE_EXCEPTION;

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

436: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
437: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
438: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id
439: ||', Rowid = '||X_Rowid);
440: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
441: end if;
442: APP_EXCEPTION.RAISE_EXCEPTION;
443: END All_Encumbered;
444:

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

529:
530: EXCEPTION
531: WHEN OTHERS THEN
532: if (SQLCODE <> -20001) then
533: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id);
537: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

530: EXCEPTION
531: WHEN OTHERS THEN
532: if (SQLCODE <> -20001) then
533: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id);
537: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
538: end if;

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

531: WHEN OTHERS THEN
532: if (SQLCODE <> -20001) then
533: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id);
537: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
538: end if;
539: APP_EXCEPTION.RAISE_EXCEPTION;

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

532: if (SQLCODE <> -20001) then
533: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id);
537: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
538: end if;
539: APP_EXCEPTION.RAISE_EXCEPTION;
540:

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

533: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||X_Invoice_Id);
537: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
538: end if;
539: APP_EXCEPTION.RAISE_EXCEPTION;
540:
541: END Check_Cash_Basis_Paid;

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

633:
634: EXCEPTION
635: WHEN OTHERS THEN
636: if (SQLCODE <> -20001) then
637: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
638: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
639: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
640: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||
641: X_PO_Distribution_Id||', Line location Id = '||

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

634: EXCEPTION
635: WHEN OTHERS THEN
636: if (SQLCODE <> -20001) then
637: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
638: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
639: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
640: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||
641: X_PO_Distribution_Id||', Line location Id = '||
642: X_Line_Location_Id||', Quantity Billed = '||

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

635: WHEN OTHERS THEN
636: if (SQLCODE <> -20001) then
637: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
638: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
639: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
640: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||
641: X_PO_Distribution_Id||', Line location Id = '||
642: X_Line_Location_Id||', Quantity Billed = '||
643: X_Quantity_Billed||', Amount Billed = '||

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

636: if (SQLCODE <> -20001) then
637: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
638: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
639: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
640: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||
641: X_PO_Distribution_Id||', Line location Id = '||
642: X_Line_Location_Id||', Quantity Billed = '||
643: X_Quantity_Billed||', Amount Billed = '||
644: X_Amount_Billed);

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

641: X_PO_Distribution_Id||', Line location Id = '||
642: X_Line_Location_Id||', Quantity Billed = '||
643: X_Quantity_Billed||', Amount Billed = '||
644: X_Amount_Billed);
645: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
646: end if;
647: APP_EXCEPTION.RAISE_EXCEPTION;
648:
649: END Adjust_PO;

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

683:
684: EXCEPTION
685: WHEN OTHERS THEN
686: if (SQLCODE <> -20001) then
687: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
688: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
689: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
690: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'String = '||X_String
691: ||', Start = '||X_Start

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

684: EXCEPTION
685: WHEN OTHERS THEN
686: if (SQLCODE <> -20001) then
687: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
688: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
689: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
690: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'String = '||X_String
691: ||', Start = '||X_Start
692: ||', End = '||X_End);

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

685: WHEN OTHERS THEN
686: if (SQLCODE <> -20001) then
687: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
688: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
689: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
690: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'String = '||X_String
691: ||', Start = '||X_Start
692: ||', End = '||X_End);
693: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

686: if (SQLCODE <> -20001) then
687: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
688: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
689: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
690: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'String = '||X_String
691: ||', Start = '||X_Start
692: ||', End = '||X_End);
693: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
694: END IF;

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

689: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
690: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'String = '||X_String
691: ||', Start = '||X_Start
692: ||', End = '||X_End);
693: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
694: END IF;
695: APP_EXCEPTION.RAISE_EXCEPTION;
696:
697: END Substrbyte;

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

1853: X_msg_data => l_msg_data,
1854: X_BILLABLE_FLAG => l_billable_flag);
1855:
1856: IF (l_msg_data is not null) THEN
1857: FND_MESSAGE.SET_NAME(l_msg_application, l_msg_data);
1858: -- For bug3469917. Need to add token values for non-PA applications.
1859:
1860: if (l_msg_application <> 'PA') Then
1861:

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

1860: if (l_msg_application <> 'PA') Then
1861:
1862:
1863: IF (l_msg_token1 IS NOT NULL) THEN
1864: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
1865: ELSE
1866: fnd_message.set_token('PATC_MSG_TOKEN1',app_api.G_NULL_CHAR);
1867: END IF;
1868: IF (l_msg_token2 IS NOT NULL) THEN

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

1862:
1863: IF (l_msg_token1 IS NOT NULL) THEN
1864: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
1865: ELSE
1866: fnd_message.set_token('PATC_MSG_TOKEN1',app_api.G_NULL_CHAR);
1867: END IF;
1868: IF (l_msg_token2 IS NOT NULL) THEN
1869: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
1870: ELSE

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

1865: ELSE
1866: fnd_message.set_token('PATC_MSG_TOKEN1',app_api.G_NULL_CHAR);
1867: END IF;
1868: IF (l_msg_token2 IS NOT NULL) THEN
1869: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
1870: ELSE
1871: fnd_message.set_token('PATC_MSG_TOKEN2',app_api.G_NULL_CHAR);
1872: END IF;
1873: IF (l_msg_token3 IS NOT NULL) THEN

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

1867: END IF;
1868: IF (l_msg_token2 IS NOT NULL) THEN
1869: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
1870: ELSE
1871: fnd_message.set_token('PATC_MSG_TOKEN2',app_api.G_NULL_CHAR);
1872: END IF;
1873: IF (l_msg_token3 IS NOT NULL) THEN
1874: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
1875: ELSE

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

1870: ELSE
1871: fnd_message.set_token('PATC_MSG_TOKEN2',app_api.G_NULL_CHAR);
1872: END IF;
1873: IF (l_msg_token3 IS NOT NULL) THEN
1874: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
1875: ELSE
1876: fnd_message.set_token('PATC_MSG_TOKEN3',app_api.G_NULL_CHAR);
1877: END IF;
1878:

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

1872: END IF;
1873: IF (l_msg_token3 IS NOT NULL) THEN
1874: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
1875: ELSE
1876: fnd_message.set_token('PATC_MSG_TOKEN3',app_api.G_NULL_CHAR);
1877: END IF;
1878:
1879: end if;
1880:

Line 1946: fnd_message.set_encoded(l_errmsg);

1942: x_concat_descrs => l_concat_descrs,
1943: x_error_message => l_errmsg,
1944: x_award_set_id => l_award_id )) THEN
1945:
1946: fnd_message.set_encoded(l_errmsg);
1947: app_exception.raise_exception;
1948: END IF;
1949: */
1950: /* null;

Line 2002: FND_MESSAGE.SET_ENCODED(l_errmsg);

1998: x_concat_descrs => l_concat_descrs,
1999: x_error_message => l_errmsg,
2000: x_award_set_id => l_award_id )) THEN
2001:
2002: FND_MESSAGE.SET_ENCODED(l_errmsg);
2003: app_exception.raise_exception;
2004:
2005: END IF;
2006: */

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

2046:
2047: EXCEPTION
2048: WHEN OTHERS THEN
2049: IF (SQLCODE <> -20001) THEN
2050: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2051: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2052: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2053: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2054: 'X_invoice_id = ' ||X_invoice_id

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

2047: EXCEPTION
2048: WHEN OTHERS THEN
2049: IF (SQLCODE <> -20001) THEN
2050: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2051: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2052: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2053: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2054: 'X_invoice_id = ' ||X_invoice_id
2055: ||', X_line_number = ' ||X_line_number

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

2048: WHEN OTHERS THEN
2049: IF (SQLCODE <> -20001) THEN
2050: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2051: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2052: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2053: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2054: 'X_invoice_id = ' ||X_invoice_id
2055: ||', X_line_number = ' ||X_line_number
2056: ||', X_type_1099 = ' ||X_type_1099

Line 2053: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2049: IF (SQLCODE <> -20001) THEN
2050: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2051: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2052: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2053: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2054: 'X_invoice_id = ' ||X_invoice_id
2055: ||', X_line_number = ' ||X_line_number
2056: ||', X_type_1099 = ' ||X_type_1099
2057: ||', X_income_tax_region = ' ||X_income_tax_region

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

2059: ||', X_update_base = ' ||X_update_base
2060: ||', X_reset_match_status = ' ||X_reset_match_status
2061: ||', X_update_occurred = ' ||X_update_occurred
2062: );
2063: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2064: END IF;
2065: APP_EXCEPTION.RAISE_EXCEPTION;
2066: END Update_Distributions;
2067:

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

2347:
2348: EXCEPTION
2349: WHEN OTHERS THEN
2350: if (SQLCODE <> -20001) then
2351: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2352: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2353: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2354: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2355: end if;

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

2348: EXCEPTION
2349: WHEN OTHERS THEN
2350: if (SQLCODE <> -20001) then
2351: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2352: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2353: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2354: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2355: end if;
2356: APP_EXCEPTION.RAISE_EXCEPTION;

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

2349: WHEN OTHERS THEN
2350: if (SQLCODE <> -20001) then
2351: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2352: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2353: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2354: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2355: end if;
2356: APP_EXCEPTION.RAISE_EXCEPTION;
2357:

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

2350: if (SQLCODE <> -20001) then
2351: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2352: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2353: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2354: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2355: end if;
2356: APP_EXCEPTION.RAISE_EXCEPTION;
2357:
2358: END Insert_Row;

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

2674: FETCH C INTO Recinfo;
2675: if (C%NOTFOUND) then
2676: debug_info := 'Close cursor C - ROW NOTFOUND';
2677: CLOSE C;
2678: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
2679: APP_EXCEPTION.Raise_Exception;
2680: end if;
2681: debug_info := 'Close cursor C';
2682: CLOSE C;

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

2690:
2691: IF (D%NOTFOUND) THEN
2692: debug_info := 'Close cursor D - ROW NOTFOUND';
2693: CLOSE D;
2694: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
2695: APP_EXCEPTION.Raise_Exception;
2696: END IF;
2697:
2698: debug_info := 'Close cursor D';

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

2793: OR ( (Recinfo.attribute13 IS NULL)
2794: AND (X_Attribute13 IS NULL)))) then
2795: null;
2796: else
2797: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2798: APP_EXCEPTION.Raise_Exception;
2799: end if;
2800:
2801: if (

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

2934:
2935: ) then
2936: null;
2937: else
2938: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2939: APP_EXCEPTION.Raise_Exception;
2940: end if;
2941:
2942: if (

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

3005: AND (X_global_attribute20 IS NULL)))
3006: ) then
3007: return;
3008: else
3009: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
3010: APP_EXCEPTION.Raise_Exception;
3011: end if;
3012:
3013: -- Invoice Lines Project Stage 1

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

3035: AND (X_INTENDED_USE IS NULL)))
3036: ) then
3037: return;
3038: else
3039: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
3040: APP_EXCEPTION.Raise_Exception;
3041: end if;
3042:
3043: EXCEPTION

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

3043: EXCEPTION
3044: WHEN OTHERS THEN
3045: if (SQLCODE <> -20001) then
3046: IF (SQLCODE = -54) THEN
3047: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
3048: ELSE
3049: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3050: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3051: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

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

3045: if (SQLCODE <> -20001) then
3046: IF (SQLCODE = -54) THEN
3047: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
3048: ELSE
3049: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3050: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3051: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3052: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3053: END IF;

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

3046: IF (SQLCODE = -54) THEN
3047: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
3048: ELSE
3049: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3050: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3051: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3052: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3053: END IF;
3054: end if;

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

3047: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
3048: ELSE
3049: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3050: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3051: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3052: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3053: END IF;
3054: end if;
3055: APP_EXCEPTION.RAISE_EXCEPTION;

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

3048: ELSE
3049: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3050: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3051: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3052: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3053: END IF;
3054: end if;
3055: APP_EXCEPTION.RAISE_EXCEPTION;
3056:

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

3351:
3352: EXCEPTION
3353: WHEN OTHERS THEN
3354: if (SQLCODE <> -20001) then
3355: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3356: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3358: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3359: end if;

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

3352: EXCEPTION
3353: WHEN OTHERS THEN
3354: if (SQLCODE <> -20001) then
3355: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3356: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3358: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3359: end if;
3360: APP_EXCEPTION.RAISE_EXCEPTION;

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

3353: WHEN OTHERS THEN
3354: if (SQLCODE <> -20001) then
3355: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3356: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3358: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3359: end if;
3360: APP_EXCEPTION.RAISE_EXCEPTION;
3361:

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

3354: if (SQLCODE <> -20001) then
3355: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3356: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3358: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3359: end if;
3360: APP_EXCEPTION.RAISE_EXCEPTION;
3361:
3362: END Update_Row;

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

3381:
3382: EXCEPTION
3383: WHEN OTHERS THEN
3384: if (SQLCODE <> -20001) then
3385: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3386: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3387: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3388: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3389: end if;

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

3382: EXCEPTION
3383: WHEN OTHERS THEN
3384: if (SQLCODE <> -20001) then
3385: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3386: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3387: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3388: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3389: end if;
3390: APP_EXCEPTION.RAISE_EXCEPTION;

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

3383: WHEN OTHERS THEN
3384: if (SQLCODE <> -20001) then
3385: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3386: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3387: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3388: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3389: end if;
3390: APP_EXCEPTION.RAISE_EXCEPTION;
3391:

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

3384: if (SQLCODE <> -20001) then
3385: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3386: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3387: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3388: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3389: end if;
3390: APP_EXCEPTION.RAISE_EXCEPTION;
3391:
3392: END Delete_Row;

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

3777:
3778: EXCEPTION
3779: WHEN OTHERS THEN
3780: IF (SQLCODE <> -20001) THEN
3781: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3782: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3783: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3784: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3785: END IF;

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

3778: EXCEPTION
3779: WHEN OTHERS THEN
3780: IF (SQLCODE <> -20001) THEN
3781: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3782: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3783: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3784: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3785: END IF;
3786: APP_EXCEPTION.RAISE_EXCEPTION;

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

3779: WHEN OTHERS THEN
3780: IF (SQLCODE <> -20001) THEN
3781: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3782: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3783: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3784: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3785: END IF;
3786: APP_EXCEPTION.RAISE_EXCEPTION;
3787:

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

3780: IF (SQLCODE <> -20001) THEN
3781: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
3782: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
3783: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
3784: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
3785: END IF;
3786: APP_EXCEPTION.RAISE_EXCEPTION;
3787:
3788: END Round_Biggest_Distribution;

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

4397: IF (l_msg_data is not null) THEN
4398: X_msg_application := l_msg_application;
4399: X_msg_data := l_msg_data;
4400: --bugfix:5725904
4401: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
4402: /*bug 6682104 setting the token values*/
4403: IF (l_msg_token1 IS NOT NULL) THEN
4404: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
4405: ELSE

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

4400: --bugfix:5725904
4401: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
4402: /*bug 6682104 setting the token values*/
4403: IF (l_msg_token1 IS NOT NULL) THEN
4404: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
4405: ELSE
4406: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
4407: END IF;
4408:

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

4402: /*bug 6682104 setting the token values*/
4403: IF (l_msg_token1 IS NOT NULL) THEN
4404: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
4405: ELSE
4406: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
4407: END IF;
4408:
4409: IF (l_msg_token2 IS NOT NULL) THEN
4410: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

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

4406: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
4407: END IF;
4408:
4409: IF (l_msg_token2 IS NOT NULL) THEN
4410: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
4411: ELSE
4412: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
4413: END IF;
4414:

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

4408:
4409: IF (l_msg_token2 IS NOT NULL) THEN
4410: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
4411: ELSE
4412: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
4413: END IF;
4414:
4415: IF (l_msg_token3 IS NOT NULL) THEN
4416: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

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

4412: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
4413: END IF;
4414:
4415: IF (l_msg_token3 IS NOT NULL) THEN
4416: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
4417: ELSE
4418: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
4419: END IF;
4420: l_message_text := Fnd_Message.get;

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

4414:
4415: IF (l_msg_token3 IS NOT NULL) THEN
4416: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
4417: ELSE
4418: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
4419: END IF;
4420: l_message_text := Fnd_Message.get;
4421: X_Error_Code := l_message_text;
4422:

Line 4420: l_message_text := Fnd_Message.get;

4416: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
4417: ELSE
4418: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
4419: END IF;
4420: l_message_text := Fnd_Message.get;
4421: X_Error_Code := l_message_text;
4422:
4423: return(FALSE);
4424: END IF;

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

6322: if (l_msg_data is not null) then
6323: X_msg_application := l_msg_application;
6324: X_msg_data := l_msg_data;
6325: --bugfix:5725904
6326: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
6327: /*bug 6682104 setting the token values*/
6328: IF (l_msg_token1 IS NOT NULL) THEN
6329: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
6330: ELSE

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

6325: --bugfix:5725904
6326: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
6327: /*bug 6682104 setting the token values*/
6328: IF (l_msg_token1 IS NOT NULL) THEN
6329: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
6330: ELSE
6331: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
6332: END IF;
6333:

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

6327: /*bug 6682104 setting the token values*/
6328: IF (l_msg_token1 IS NOT NULL) THEN
6329: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
6330: ELSE
6331: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
6332: END IF;
6333:
6334: IF (l_msg_token2 IS NOT NULL) THEN
6335: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

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

6331: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
6332: END IF;
6333:
6334: IF (l_msg_token2 IS NOT NULL) THEN
6335: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
6336: ELSE
6337: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
6338: END IF;
6339:

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

6333:
6334: IF (l_msg_token2 IS NOT NULL) THEN
6335: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
6336: ELSE
6337: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
6338: END IF;
6339:
6340: IF (l_msg_token3 IS NOT NULL) THEN
6341: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

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

6337: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
6338: END IF;
6339:
6340: IF (l_msg_token3 IS NOT NULL) THEN
6341: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
6342: ELSE
6343: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
6344: END IF;
6345: l_message_text := Fnd_Message.get;

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

6339:
6340: IF (l_msg_token3 IS NOT NULL) THEN
6341: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
6342: ELSE
6343: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
6344: END IF;
6345: l_message_text := Fnd_Message.get;
6346: x_error_code := l_message_text;
6347:

Line 6345: l_message_text := Fnd_Message.get;

6341: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
6342: ELSE
6343: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
6344: END IF;
6345: l_message_text := Fnd_Message.get;
6346: x_error_code := l_message_text;
6347:
6348: return(FALSE);
6349:

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

8843:
8844: EXCEPTION
8845: WHEN OTHERS THEN
8846: IF (SQLCODE <> -20001) then
8847: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8848: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8849: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8850: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'distribution Id = '
8851: || X_distribution_Id);

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

8844: EXCEPTION
8845: WHEN OTHERS THEN
8846: IF (SQLCODE <> -20001) then
8847: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8848: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8849: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8850: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'distribution Id = '
8851: || X_distribution_Id);
8852: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

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

8845: WHEN OTHERS THEN
8846: IF (SQLCODE <> -20001) then
8847: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8848: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8849: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8850: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'distribution Id = '
8851: || X_distribution_Id);
8852: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
8853: END IF;

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

8846: IF (SQLCODE <> -20001) then
8847: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8848: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8849: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8850: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'distribution Id = '
8851: || X_distribution_Id);
8852: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
8853: END IF;
8854:

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

8848: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8849: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8850: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'distribution Id = '
8851: || X_distribution_Id);
8852: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
8853: END IF;
8854:
8855: l_debug_info := 'CALCULATE_VARIANCE - OTHERS exception exists';
8856: x_debug_info := l_debug_info;

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

8907:
8908: Exception
8909: WHEN OTHERS THEN
8910: If (SQLCODE <> -20001) Then
8911: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8912: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8913: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8914: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
8915: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

8908: Exception
8909: WHEN OTHERS THEN
8910: If (SQLCODE <> -20001) Then
8911: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8912: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8913: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8914: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
8915: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
8916: End If;

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

8909: WHEN OTHERS THEN
8910: If (SQLCODE <> -20001) Then
8911: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8912: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8913: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8914: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
8915: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
8916: End If;
8917: APP_EXCEPTION.RAISE_EXCEPTION;

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

8910: If (SQLCODE <> -20001) Then
8911: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8912: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8913: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8914: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
8915: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
8916: End If;
8917: APP_EXCEPTION.RAISE_EXCEPTION;
8918:

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

8911: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8912: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8913: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8914: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
8915: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
8916: End If;
8917: APP_EXCEPTION.RAISE_EXCEPTION;
8918:
8919:

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

8979:
8980: Exception
8981: WHEN OTHERS THEN
8982: If (SQLCODE <> -20001) Then
8983: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8984: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8986: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
8987: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

8980: Exception
8981: WHEN OTHERS THEN
8982: If (SQLCODE <> -20001) Then
8983: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8984: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8986: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
8987: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
8988: End If;

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

8981: WHEN OTHERS THEN
8982: If (SQLCODE <> -20001) Then
8983: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8984: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8986: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
8987: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
8988: End If;
8989: APP_EXCEPTION.RAISE_EXCEPTION;

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

8982: If (SQLCODE <> -20001) Then
8983: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8984: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8986: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
8987: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
8988: End If;
8989: APP_EXCEPTION.RAISE_EXCEPTION;
8990: END Chrg_Refer_Active_Dist;

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

8983: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
8984: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
8985: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
8986: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
8987: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
8988: End If;
8989: APP_EXCEPTION.RAISE_EXCEPTION;
8990: END Chrg_Refer_Active_Dist;
8991:

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

9039:
9040: Exception
9041: WHEN OTHERS THEN
9042: If (SQLCODE <> -20001) Then
9043: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9044: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9045: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9046: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
9047: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

9040: Exception
9041: WHEN OTHERS THEN
9042: If (SQLCODE <> -20001) Then
9043: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9044: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9045: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9046: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
9047: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
9048: End If;

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

9041: WHEN OTHERS THEN
9042: If (SQLCODE <> -20001) Then
9043: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9044: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9045: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9046: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
9047: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
9048: End If;
9049: APP_EXCEPTION.RAISE_EXCEPTION;

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

9042: If (SQLCODE <> -20001) Then
9043: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9044: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9045: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9046: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
9047: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
9048: End If;
9049: APP_EXCEPTION.RAISE_EXCEPTION;
9050:

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

9043: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9044: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9045: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9046: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
9047: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
9048: End If;
9049: APP_EXCEPTION.RAISE_EXCEPTION;
9050:
9051: END Dist_Refer_Active_Corr_Wrap;

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

9100:
9101: Exception
9102: WHEN OTHERS THEN
9103: If (SQLCODE <> -20001) Then
9104: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9105: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9106: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9107: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
9108: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

9101: Exception
9102: WHEN OTHERS THEN
9103: If (SQLCODE <> -20001) Then
9104: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9105: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9106: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9107: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
9108: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
9109: End If;

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

9102: WHEN OTHERS THEN
9103: If (SQLCODE <> -20001) Then
9104: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9105: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9106: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9107: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
9108: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
9109: End If;
9110: APP_EXCEPTION.RAISE_EXCEPTION;

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

9103: If (SQLCODE <> -20001) Then
9104: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9105: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9106: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9107: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
9108: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
9109: End If;
9110: APP_EXCEPTION.RAISE_EXCEPTION;
9111: END Chrg_Refer_Active_Dist_Wrap;

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

9104: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9105: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9106: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9107: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Distribution Id = '||P_Invoice_Dist_Id);
9108: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
9109: End If;
9110: APP_EXCEPTION.RAISE_EXCEPTION;
9111: END Chrg_Refer_Active_Dist_Wrap;
9112:

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

9194:
9195: EXCEPTION
9196: WHEN OTHERS THEN
9197: IF (SQLCODE <> -20001) THEN
9198: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9199: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9200: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9201: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||P_Invoice_Id);
9202: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

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

9195: EXCEPTION
9196: WHEN OTHERS THEN
9197: IF (SQLCODE <> -20001) THEN
9198: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9199: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9200: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9201: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||P_Invoice_Id);
9202: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
9203: END IF;

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

9196: WHEN OTHERS THEN
9197: IF (SQLCODE <> -20001) THEN
9198: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9199: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9200: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9201: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||P_Invoice_Id);
9202: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
9203: END IF;
9204: APP_EXCEPTION.RAISE_EXCEPTION;

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

9197: IF (SQLCODE <> -20001) THEN
9198: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9199: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9200: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9201: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||P_Invoice_Id);
9202: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
9203: END IF;
9204: APP_EXCEPTION.RAISE_EXCEPTION;
9205:

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

9198: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9199: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9200: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
9201: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Id = '||P_Invoice_Id);
9202: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
9203: END IF;
9204: APP_EXCEPTION.RAISE_EXCEPTION;
9205:
9206: END Make_Distributions_Permanent;

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

9243:
9244: EXCEPTION
9245: WHEN OTHERS THEN
9246: IF (SQLCODE <> -20001) THEN
9247: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9248: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9249: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Distribution Id = '
9250: ||P_Invoice_Distribution_Id);
9251: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

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

9244: EXCEPTION
9245: WHEN OTHERS THEN
9246: IF (SQLCODE <> -20001) THEN
9247: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9248: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9249: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Distribution Id = '
9250: ||P_Invoice_Distribution_Id);
9251: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
9252: END IF;

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

9245: WHEN OTHERS THEN
9246: IF (SQLCODE <> -20001) THEN
9247: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9248: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9249: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Distribution Id = '
9250: ||P_Invoice_Distribution_Id);
9251: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
9252: END IF;
9253: APP_EXCEPTION.RAISE_EXCEPTION;

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

9247: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
9248: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
9249: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Invoice Distribution Id = '
9250: ||P_Invoice_Distribution_Id);
9251: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
9252: END IF;
9253: APP_EXCEPTION.RAISE_EXCEPTION;
9254:
9255: END Associated_Charges;