DBA Data[Home] [Help]

APPS.AP_AI_TABLE_HANDLER_PKG dependencies on FND_MESSAGE

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

34: AND ((p_ROWID is null) OR
35: (rowid <> p_ROWID));
36:
37: IF (dummy_a >= 1) THEN
38: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
39: app_exception.raise_exception;
40: END IF;
41:
42: debug_info := 'Count for same vendor_id,party_site_id and invoice_num amount purged invoices'; /*Bug9105666*/

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

52: AND (ass.party_site_id = P_PARTY_SITE_ID /*Bug9105666*/
53: OR (ass.party_site_id is null and P_PARTY_SITE_ID is null)); /*Bug9105666*/
54:
55: IF (dummy_b >= 1) THEN
56: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
57: app_exception.raise_exception;
58: END IF;
59:
60: EXCEPTION

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

59:
60: EXCEPTION
61: WHEN OTHERS THEN
62: IF (SQLCODE <> -20001) THEN
63: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
64: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
65: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
66: current_calling_sequence);
67: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

60: EXCEPTION
61: WHEN OTHERS THEN
62: IF (SQLCODE <> -20001) THEN
63: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
64: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
65: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
66: current_calling_sequence);
67: FND_MESSAGE.SET_TOKEN('PARAMETERS',
68: 'p_Rowid = ' ||p_Rowid

Line 65: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

61: WHEN OTHERS THEN
62: IF (SQLCODE <> -20001) THEN
63: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
64: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
65: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
66: current_calling_sequence);
67: FND_MESSAGE.SET_TOKEN('PARAMETERS',
68: 'p_Rowid = ' ||p_Rowid
69: ||', p_INVOICE_NUM = '||p_INVOICE_NUM

Line 67: FND_MESSAGE.SET_TOKEN('PARAMETERS',

63: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
64: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
65: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
66: current_calling_sequence);
67: FND_MESSAGE.SET_TOKEN('PARAMETERS',
68: 'p_Rowid = ' ||p_Rowid
69: ||', p_INVOICE_NUM = '||p_INVOICE_NUM
70: ||', p_VENDOR_ID = ' ||p_VENDOR_ID
71: ||', P_VENDOR_SITE_ID = '||P_VENDOR_SITE_ID /*Bug9105666*/

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

70: ||', p_VENDOR_ID = ' ||p_VENDOR_ID
71: ||', P_VENDOR_SITE_ID = '||P_VENDOR_SITE_ID /*Bug9105666*/
72: ||', P_PARTY_SITE_ID = '||P_PARTY_SITE_ID /*Bug9105666*/
73: );
74: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
75: END IF;
76: APP_EXCEPTION.RAISE_EXCEPTION;
77:
78: END CHECK_UNIQUE;

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

641:
642: EXCEPTION
643: WHEN OTHERS THEN
644: IF (SQLCODE <> -20001) THEN
645: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
646: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
647: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
648: current_calling_sequence);
649: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

642: EXCEPTION
643: WHEN OTHERS THEN
644: IF (SQLCODE <> -20001) THEN
645: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
646: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
647: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
648: current_calling_sequence);
649: FND_MESSAGE.SET_TOKEN('PARAMETERS',
650: 'p_Rowid = '||p_Rowid

Line 647: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

643: WHEN OTHERS THEN
644: IF (SQLCODE <> -20001) THEN
645: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
646: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
647: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
648: current_calling_sequence);
649: FND_MESSAGE.SET_TOKEN('PARAMETERS',
650: 'p_Rowid = '||p_Rowid
651: ||', p_invoice_id = '||p_invoice_id

Line 649: FND_MESSAGE.SET_TOKEN('PARAMETERS',

645: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
646: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
647: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
648: current_calling_sequence);
649: FND_MESSAGE.SET_TOKEN('PARAMETERS',
650: 'p_Rowid = '||p_Rowid
651: ||', p_invoice_id = '||p_invoice_id
652: );
653: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

649: FND_MESSAGE.SET_TOKEN('PARAMETERS',
650: 'p_Rowid = '||p_Rowid
651: ||', p_invoice_id = '||p_invoice_id
652: );
653: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
654: END IF;
655: APP_EXCEPTION.RAISE_EXCEPTION;
656:
657: END Insert_Row;

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

1016:
1017: EXCEPTION
1018: WHEN OTHERS THEN
1019: IF (SQLCODE <> -20001) THEN
1020: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1021: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1022: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1023: current_calling_sequence);
1024: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

1017: EXCEPTION
1018: WHEN OTHERS THEN
1019: IF (SQLCODE <> -20001) THEN
1020: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1021: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1022: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1023: current_calling_sequence);
1024: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1025: 'p_Rowid = '||p_Rowid

Line 1022: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

1018: WHEN OTHERS THEN
1019: IF (SQLCODE <> -20001) THEN
1020: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1021: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1022: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1023: current_calling_sequence);
1024: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1025: 'p_Rowid = '||p_Rowid
1026: ||', p_invoice_id = '||p_invoice_id

Line 1024: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1020: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1021: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1022: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1023: current_calling_sequence);
1024: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1025: 'p_Rowid = '||p_Rowid
1026: ||', p_invoice_id = '||p_invoice_id
1027: );
1028: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

1024: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1025: 'p_Rowid = '||p_Rowid
1026: ||', p_invoice_id = '||p_invoice_id
1027: );
1028: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1029: END IF;
1030: APP_EXCEPTION.RAISE_EXCEPTION;
1031:
1032:

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

1168:
1169: EXCEPTION
1170: WHEN OTHERS THEN
1171: IF (SQLCODE <> -20001) THEN
1172: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1173: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1174: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1175: current_calling_sequence);
1176: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

1169: EXCEPTION
1170: WHEN OTHERS THEN
1171: IF (SQLCODE <> -20001) THEN
1172: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1173: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1174: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1175: current_calling_sequence);
1176: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1177: 'p_Rowid = '||p_Rowid

Line 1174: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

1170: WHEN OTHERS THEN
1171: IF (SQLCODE <> -20001) THEN
1172: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1173: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1174: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1175: current_calling_sequence);
1176: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1177: 'p_Rowid = '||p_Rowid
1178: );

Line 1176: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1172: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1173: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1174: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1175: current_calling_sequence);
1176: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1177: 'p_Rowid = '||p_Rowid
1178: );
1179: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1180: END IF;

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

1175: current_calling_sequence);
1176: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1177: 'p_Rowid = '||p_Rowid
1178: );
1179: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1180: END IF;
1181: APP_EXCEPTION.RAISE_EXCEPTION;
1182:
1183: