DBA Data[Home] [Help]

APPS.AP_GENERATE_DISTRIBUTIONS_PKG dependencies on FND_MESSAGE

Line 523: FND_MESSAGE.SET_NAME('SQLAP', 'AP_INVOICE_UPDATED_REQUERY');

519:
520:
521: EXCEPTION WHEN OTHERS THEN
522: IF ( SQLCODE = -54 ) THEN
523: FND_MESSAGE.SET_NAME('SQLAP', 'AP_INVOICE_UPDATED_REQUERY');
524: IF (G_INVOICE_LINES_CURSOR%ISOPEN ) THEN
525: CLOSE G_Invoice_Lines_Cursor ;
526: END IF;
527: ELSIF (SQLCODE <> -20001) THEN

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

524: IF (G_INVOICE_LINES_CURSOR%ISOPEN ) THEN
525: CLOSE G_Invoice_Lines_Cursor ;
526: END IF;
527: ELSIF (SQLCODE <> -20001) THEN
528: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
529: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
530: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
531: FND_MESSAGE.SET_TOKEN('PARAMETERS',
532: 'Invoice Id = '|| to_char(p_invoice_id));

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

525: CLOSE G_Invoice_Lines_Cursor ;
526: END IF;
527: ELSIF (SQLCODE <> -20001) THEN
528: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
529: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
530: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
531: FND_MESSAGE.SET_TOKEN('PARAMETERS',
532: 'Invoice Id = '|| to_char(p_invoice_id));
533: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 530: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

526: END IF;
527: ELSIF (SQLCODE <> -20001) THEN
528: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
529: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
530: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
531: FND_MESSAGE.SET_TOKEN('PARAMETERS',
532: 'Invoice Id = '|| to_char(p_invoice_id));
533: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
534:

Line 531: FND_MESSAGE.SET_TOKEN('PARAMETERS',

527: ELSIF (SQLCODE <> -20001) THEN
528: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
529: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
530: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
531: FND_MESSAGE.SET_TOKEN('PARAMETERS',
532: 'Invoice Id = '|| to_char(p_invoice_id));
533: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
534:
535: IF (G_INVOICE_LINES_CURSOR%ISOPEN ) THEN

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

529: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
530: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
531: FND_MESSAGE.SET_TOKEN('PARAMETERS',
532: 'Invoice Id = '|| to_char(p_invoice_id));
533: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
534:
535: IF (G_INVOICE_LINES_CURSOR%ISOPEN ) THEN
536: CLOSE G_Invoice_Lines_Cursor ;
537: END IF;

Line 799: FND_MESSAGE.SET_NAME('SQLAP', 'AP_INVOICE_UPDATED_REQUERY');

795: RETURN(TRUE);
796:
797: EXCEPTION WHEN OTHERS THEN
798: IF ( SQLCODE = -54 ) THEN
799: FND_MESSAGE.SET_NAME('SQLAP', 'AP_INVOICE_UPDATED_REQUERY');
800: IF (G_INVOICE_LINES_CURSOR%ISOPEN ) THEN
801: CLOSE G_Invoice_Lines_Cursor ;
802: END IF;
803: ELSIF (SQLCODE <> -20001) THEN

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

800: IF (G_INVOICE_LINES_CURSOR%ISOPEN ) THEN
801: CLOSE G_Invoice_Lines_Cursor ;
802: END IF;
803: ELSIF (SQLCODE <> -20001) THEN
804: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
805: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
806: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
807: FND_MESSAGE.SET_TOKEN('PARAMETERS',
808: 'Invoice Id = '|| to_char(p_invoice_id)

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

801: CLOSE G_Invoice_Lines_Cursor ;
802: END IF;
803: ELSIF (SQLCODE <> -20001) THEN
804: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
805: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
806: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
807: FND_MESSAGE.SET_TOKEN('PARAMETERS',
808: 'Invoice Id = '|| to_char(p_invoice_id)
809: ||'Invoice Line Number = '||to_char(p_invoice_line_number));

Line 806: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

802: END IF;
803: ELSIF (SQLCODE <> -20001) THEN
804: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
805: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
806: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
807: FND_MESSAGE.SET_TOKEN('PARAMETERS',
808: 'Invoice Id = '|| to_char(p_invoice_id)
809: ||'Invoice Line Number = '||to_char(p_invoice_line_number));
810: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 807: FND_MESSAGE.SET_TOKEN('PARAMETERS',

803: ELSIF (SQLCODE <> -20001) THEN
804: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
805: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
806: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
807: FND_MESSAGE.SET_TOKEN('PARAMETERS',
808: 'Invoice Id = '|| to_char(p_invoice_id)
809: ||'Invoice Line Number = '||to_char(p_invoice_line_number));
810: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
811: IF (G_Invoice_Lines_Cursor%ISOPEN ) THEN

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

806: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
807: FND_MESSAGE.SET_TOKEN('PARAMETERS',
808: 'Invoice Id = '|| to_char(p_invoice_id)
809: ||'Invoice Line Number = '||to_char(p_invoice_line_number));
810: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
811: IF (G_Invoice_Lines_Cursor%ISOPEN ) THEN
812: CLOSE G_Invoice_Lines_Cursor ;
813: END IF;
814: END IF;

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

875:
876:
877: EXCEPTION WHEN OTHERS THEN
878: IF (SQLCODE <> -20001) THEN
879: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
880: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
881: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
882: FND_MESSAGE.SET_TOKEN('PARAMETERS',
883: 'Invoice Id = '|| to_char(p_invoice_id));

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

876:
877: EXCEPTION WHEN OTHERS THEN
878: IF (SQLCODE <> -20001) THEN
879: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
880: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
881: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
882: FND_MESSAGE.SET_TOKEN('PARAMETERS',
883: 'Invoice Id = '|| to_char(p_invoice_id));
884: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 881: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

877: EXCEPTION WHEN OTHERS THEN
878: IF (SQLCODE <> -20001) THEN
879: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
880: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
881: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
882: FND_MESSAGE.SET_TOKEN('PARAMETERS',
883: 'Invoice Id = '|| to_char(p_invoice_id));
884: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
885:

Line 882: FND_MESSAGE.SET_TOKEN('PARAMETERS',

878: IF (SQLCODE <> -20001) THEN
879: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
880: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
881: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
882: FND_MESSAGE.SET_TOKEN('PARAMETERS',
883: 'Invoice Id = '|| to_char(p_invoice_id));
884: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
885:
886: END IF;

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

880: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
881: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
882: FND_MESSAGE.SET_TOKEN('PARAMETERS',
883: 'Invoice Id = '|| to_char(p_invoice_id));
884: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
885:
886: END IF;
887:
888: APP_EXCEPTION.RAISE_EXCEPTION;