DBA Data[Home] [Help]

APPS.AP_AI_TABLE_HANDLER_PKG dependencies on FND_MESSAGE

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

30: AND ((p_ROWID is null) OR
31: (rowid <> p_ROWID));
32:
33: IF (dummy_a >= 1) THEN
34: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
35: app_exception.raise_exception;
36: END IF;
37:
38: debug_info := 'Count for same vendor_id, invoice_num amount purged invoices';

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

43: AND vendor_id = p_VENDOR_ID
44: AND org_id = p_ORG_ID; -- Bug 5407785
45:
46: IF (dummy_b >= 1) THEN
47: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
48: app_exception.raise_exception;
49: END IF;
50:
51: EXCEPTION

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

50:
51: EXCEPTION
52: WHEN OTHERS THEN
53: IF (SQLCODE <> -20001) THEN
54: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
55: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
56: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
57: current_calling_sequence);
58: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

51: EXCEPTION
52: WHEN OTHERS THEN
53: IF (SQLCODE <> -20001) THEN
54: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
55: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
56: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
57: current_calling_sequence);
58: FND_MESSAGE.SET_TOKEN('PARAMETERS',
59: 'p_Rowid = ' ||p_Rowid

Line 56: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

52: WHEN OTHERS THEN
53: IF (SQLCODE <> -20001) THEN
54: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
55: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
56: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
57: current_calling_sequence);
58: FND_MESSAGE.SET_TOKEN('PARAMETERS',
59: 'p_Rowid = ' ||p_Rowid
60: ||', p_INVOICE_NUM = '||p_INVOICE_NUM

Line 58: FND_MESSAGE.SET_TOKEN('PARAMETERS',

54: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
55: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
56: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
57: current_calling_sequence);
58: FND_MESSAGE.SET_TOKEN('PARAMETERS',
59: 'p_Rowid = ' ||p_Rowid
60: ||', p_INVOICE_NUM = '||p_INVOICE_NUM
61: ||', p_VENDOR_ID = ' ||p_VENDOR_ID
62: );

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

59: 'p_Rowid = ' ||p_Rowid
60: ||', p_INVOICE_NUM = '||p_INVOICE_NUM
61: ||', p_VENDOR_ID = ' ||p_VENDOR_ID
62: );
63: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
64: END IF;
65: APP_EXCEPTION.RAISE_EXCEPTION;
66:
67: END CHECK_UNIQUE;

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

628:
629: EXCEPTION
630: WHEN OTHERS THEN
631: IF (SQLCODE <> -20001) THEN
632: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
633: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
634: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
635: current_calling_sequence);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

629: EXCEPTION
630: WHEN OTHERS THEN
631: IF (SQLCODE <> -20001) THEN
632: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
633: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
634: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
635: current_calling_sequence);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
637: 'p_Rowid = '||p_Rowid

Line 634: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

630: WHEN OTHERS THEN
631: IF (SQLCODE <> -20001) THEN
632: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
633: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
634: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
635: current_calling_sequence);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
637: 'p_Rowid = '||p_Rowid
638: ||', p_invoice_id = '||p_invoice_id

Line 636: FND_MESSAGE.SET_TOKEN('PARAMETERS',

632: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
633: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
634: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
635: current_calling_sequence);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
637: 'p_Rowid = '||p_Rowid
638: ||', p_invoice_id = '||p_invoice_id
639: );
640: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
637: 'p_Rowid = '||p_Rowid
638: ||', p_invoice_id = '||p_invoice_id
639: );
640: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
641: END IF;
642: APP_EXCEPTION.RAISE_EXCEPTION;
643:
644: END Insert_Row;

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

1001:
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: IF (SQLCODE <> -20001) THEN
1005: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1006: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1008: current_calling_sequence);
1009: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: IF (SQLCODE <> -20001) THEN
1005: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1006: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1008: current_calling_sequence);
1009: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1010: 'p_Rowid = '||p_Rowid

Line 1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

1003: WHEN OTHERS THEN
1004: IF (SQLCODE <> -20001) THEN
1005: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1006: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1008: current_calling_sequence);
1009: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1010: 'p_Rowid = '||p_Rowid
1011: ||', p_invoice_id = '||p_invoice_id

Line 1009: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1005: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1006: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1008: current_calling_sequence);
1009: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1010: 'p_Rowid = '||p_Rowid
1011: ||', p_invoice_id = '||p_invoice_id
1012: );
1013: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

1009: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1010: 'p_Rowid = '||p_Rowid
1011: ||', p_invoice_id = '||p_invoice_id
1012: );
1013: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1014: END IF;
1015: APP_EXCEPTION.RAISE_EXCEPTION;
1016:
1017:

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

1153:
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: IF (SQLCODE <> -20001) THEN
1157: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1160: current_calling_sequence);
1161: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: IF (SQLCODE <> -20001) THEN
1157: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1160: current_calling_sequence);
1161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1162: 'p_Rowid = '||p_Rowid

Line 1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

1155: WHEN OTHERS THEN
1156: IF (SQLCODE <> -20001) THEN
1157: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1160: current_calling_sequence);
1161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1162: 'p_Rowid = '||p_Rowid
1163: );

Line 1161: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1157: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1160: current_calling_sequence);
1161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1162: 'p_Rowid = '||p_Rowid
1163: );
1164: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1165: END IF;

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

1160: current_calling_sequence);
1161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1162: 'p_Rowid = '||p_Rowid
1163: );
1164: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1165: END IF;
1166: APP_EXCEPTION.RAISE_EXCEPTION;
1167:
1168: