DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on FND_MESSAGE

Line 1051: fnd_message.set_name('SQLAP', p_message_name);

1047: PROCEDURE print_prob_pmt_detail (p_prob_pmt_list prob_pmt_tab
1048: , p_message_name varchar2) IS
1049: BEGIN
1050: if p_prob_pmt_list.exists(1) then
1051: fnd_message.set_name('SQLAP', p_message_name);
1052: l_debug_info := fnd_message.get;
1053: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
1054:
1055: for i in l_prob_pmt_list.FIRST .. l_prob_pmt_list.LAST

Line 1052: l_debug_info := fnd_message.get;

1048: , p_message_name varchar2) IS
1049: BEGIN
1050: if p_prob_pmt_list.exists(1) then
1051: fnd_message.set_name('SQLAP', p_message_name);
1052: l_debug_info := fnd_message.get;
1053: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
1054:
1055: for i in l_prob_pmt_list.FIRST .. l_prob_pmt_list.LAST
1056: loop

Line 1057: fnd_message.set_name('SQLAP', 'AP_IBY_PMT_MISMATCH_DETAIL');

1053: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
1054:
1055: for i in l_prob_pmt_list.FIRST .. l_prob_pmt_list.LAST
1056: loop
1057: fnd_message.set_name('SQLAP', 'AP_IBY_PMT_MISMATCH_DETAIL');
1058: fnd_message.set_token('PAYMENT_REFERENCE_NUMBER', l_prob_pmt_list(i).payment_reference_number);
1059: fnd_message.set_token('PAYMENT_ID', l_prob_pmt_list(i).payment_id);
1060: fnd_message.set_token('PAYMENT_INSTRUCTION_ID', l_prob_pmt_list(i).payment_instruction_id);
1061: fnd_message.set_token('INVOICE_ID', l_prob_pmt_list(i).invoice_id);

Line 1058: fnd_message.set_token('PAYMENT_REFERENCE_NUMBER', l_prob_pmt_list(i).payment_reference_number);

1054:
1055: for i in l_prob_pmt_list.FIRST .. l_prob_pmt_list.LAST
1056: loop
1057: fnd_message.set_name('SQLAP', 'AP_IBY_PMT_MISMATCH_DETAIL');
1058: fnd_message.set_token('PAYMENT_REFERENCE_NUMBER', l_prob_pmt_list(i).payment_reference_number);
1059: fnd_message.set_token('PAYMENT_ID', l_prob_pmt_list(i).payment_id);
1060: fnd_message.set_token('PAYMENT_INSTRUCTION_ID', l_prob_pmt_list(i).payment_instruction_id);
1061: fnd_message.set_token('INVOICE_ID', l_prob_pmt_list(i).invoice_id);
1062: fnd_message.set_token('PAYMENT_NUM', l_prob_pmt_list(i).payment_num);

Line 1059: fnd_message.set_token('PAYMENT_ID', l_prob_pmt_list(i).payment_id);

1055: for i in l_prob_pmt_list.FIRST .. l_prob_pmt_list.LAST
1056: loop
1057: fnd_message.set_name('SQLAP', 'AP_IBY_PMT_MISMATCH_DETAIL');
1058: fnd_message.set_token('PAYMENT_REFERENCE_NUMBER', l_prob_pmt_list(i).payment_reference_number);
1059: fnd_message.set_token('PAYMENT_ID', l_prob_pmt_list(i).payment_id);
1060: fnd_message.set_token('PAYMENT_INSTRUCTION_ID', l_prob_pmt_list(i).payment_instruction_id);
1061: fnd_message.set_token('INVOICE_ID', l_prob_pmt_list(i).invoice_id);
1062: fnd_message.set_token('PAYMENT_NUM', l_prob_pmt_list(i).payment_num);
1063: l_debug_info := fnd_message.get;

Line 1060: fnd_message.set_token('PAYMENT_INSTRUCTION_ID', l_prob_pmt_list(i).payment_instruction_id);

1056: loop
1057: fnd_message.set_name('SQLAP', 'AP_IBY_PMT_MISMATCH_DETAIL');
1058: fnd_message.set_token('PAYMENT_REFERENCE_NUMBER', l_prob_pmt_list(i).payment_reference_number);
1059: fnd_message.set_token('PAYMENT_ID', l_prob_pmt_list(i).payment_id);
1060: fnd_message.set_token('PAYMENT_INSTRUCTION_ID', l_prob_pmt_list(i).payment_instruction_id);
1061: fnd_message.set_token('INVOICE_ID', l_prob_pmt_list(i).invoice_id);
1062: fnd_message.set_token('PAYMENT_NUM', l_prob_pmt_list(i).payment_num);
1063: l_debug_info := fnd_message.get;
1064: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);

Line 1061: fnd_message.set_token('INVOICE_ID', l_prob_pmt_list(i).invoice_id);

1057: fnd_message.set_name('SQLAP', 'AP_IBY_PMT_MISMATCH_DETAIL');
1058: fnd_message.set_token('PAYMENT_REFERENCE_NUMBER', l_prob_pmt_list(i).payment_reference_number);
1059: fnd_message.set_token('PAYMENT_ID', l_prob_pmt_list(i).payment_id);
1060: fnd_message.set_token('PAYMENT_INSTRUCTION_ID', l_prob_pmt_list(i).payment_instruction_id);
1061: fnd_message.set_token('INVOICE_ID', l_prob_pmt_list(i).invoice_id);
1062: fnd_message.set_token('PAYMENT_NUM', l_prob_pmt_list(i).payment_num);
1063: l_debug_info := fnd_message.get;
1064: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
1065: end loop;

Line 1062: fnd_message.set_token('PAYMENT_NUM', l_prob_pmt_list(i).payment_num);

1058: fnd_message.set_token('PAYMENT_REFERENCE_NUMBER', l_prob_pmt_list(i).payment_reference_number);
1059: fnd_message.set_token('PAYMENT_ID', l_prob_pmt_list(i).payment_id);
1060: fnd_message.set_token('PAYMENT_INSTRUCTION_ID', l_prob_pmt_list(i).payment_instruction_id);
1061: fnd_message.set_token('INVOICE_ID', l_prob_pmt_list(i).invoice_id);
1062: fnd_message.set_token('PAYMENT_NUM', l_prob_pmt_list(i).payment_num);
1063: l_debug_info := fnd_message.get;
1064: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
1065: end loop;
1066: end if;

Line 1063: l_debug_info := fnd_message.get;

1059: fnd_message.set_token('PAYMENT_ID', l_prob_pmt_list(i).payment_id);
1060: fnd_message.set_token('PAYMENT_INSTRUCTION_ID', l_prob_pmt_list(i).payment_instruction_id);
1061: fnd_message.set_token('INVOICE_ID', l_prob_pmt_list(i).invoice_id);
1062: fnd_message.set_token('PAYMENT_NUM', l_prob_pmt_list(i).payment_num);
1063: l_debug_info := fnd_message.get;
1064: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
1065: end loop;
1066: end if;
1067: END print_prob_pmt_detail;

Line 2775: FND_MESSAGE.set_name('SQLAP', 'AP_IBY_PMT_MISMATCH');

2771: (l_total_docs_count <> l_iby_docs_count) THEN
2772:
2773: x_return_status := FND_API.G_RET_STS_ERROR;
2774:
2775: FND_MESSAGE.set_name('SQLAP', 'AP_IBY_PMT_MISMATCH');
2776:
2777: --Bug 9074840 Add additional debug queries
2778:
2779: --As this is an error condition it will be written to the concurrent log

Line 2782: l_debug_info := fnd_message.get;

2778:
2779: --As this is an error condition it will be written to the concurrent log
2780: --regardless of the runtime fnd log level.
2781: FND_FILE.PUT_LINE(FND_FILE.LOG, G_MODULE_NAME);
2782: l_debug_info := fnd_message.get;
2783: FND_FILE.PUT_LINE(FND_FILE.LOG, l_debug_info);
2784:
2785: OPEN c_prob_iby_payments;
2786: FETCH c_prob_iby_payments BULK COLLECT INTO l_prob_pmt_list;

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

2825: EXCEPTION
2826:
2827: WHEN SUBSCRIBE_EXCEPTION THEN
2828:
2829: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2830: FND_MESSAGE.SET_TOKEN('ERROR',l_msg_data);
2831: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_current_calling_sequence);
2832: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2833:

Line 2830: FND_MESSAGE.SET_TOKEN('ERROR',l_msg_data);

2826:
2827: WHEN SUBSCRIBE_EXCEPTION THEN
2828:
2829: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2830: FND_MESSAGE.SET_TOKEN('ERROR',l_msg_data);
2831: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_current_calling_sequence);
2832: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2833:
2834: /* Start - BUG 14364091 - Logging */

Line 2831: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_current_calling_sequence);

2827: WHEN SUBSCRIBE_EXCEPTION THEN
2828:
2829: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2830: FND_MESSAGE.SET_TOKEN('ERROR',l_msg_data);
2831: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_current_calling_sequence);
2832: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2833:
2834: /* Start - BUG 14364091 - Logging */
2835: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);

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

2828:
2829: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2830: FND_MESSAGE.SET_TOKEN('ERROR',l_msg_data);
2831: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_current_calling_sequence);
2832: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2833:
2834: /* Start - BUG 14364091 - Logging */
2835: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);
2836: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Msg : ' || SQLERRM);

Line 2845: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');

2841: APP_EXCEPTION.RAISE_EXCEPTION;
2842:
2843: WHEN OTHERS THEN
2844: IF (SQLCODE <> -20001) THEN
2845: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
2846: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
2847: FND_MESSAGE.set_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
2848: FND_MESSAGE.set_TOKEN('PARAMETERS',
2849: 'Complted Payments Group id = ' || to_char(p_completed_pmts_group_id));

Line 2846: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

2842:
2843: WHEN OTHERS THEN
2844: IF (SQLCODE <> -20001) THEN
2845: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
2846: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
2847: FND_MESSAGE.set_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
2848: FND_MESSAGE.set_TOKEN('PARAMETERS',
2849: 'Complted Payments Group id = ' || to_char(p_completed_pmts_group_id));
2850: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);

Line 2847: FND_MESSAGE.set_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);

2843: WHEN OTHERS THEN
2844: IF (SQLCODE <> -20001) THEN
2845: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
2846: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
2847: FND_MESSAGE.set_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
2848: FND_MESSAGE.set_TOKEN('PARAMETERS',
2849: 'Complted Payments Group id = ' || to_char(p_completed_pmts_group_id));
2850: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
2851: END IF;

Line 2848: FND_MESSAGE.set_TOKEN('PARAMETERS',

2844: IF (SQLCODE <> -20001) THEN
2845: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
2846: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
2847: FND_MESSAGE.set_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
2848: FND_MESSAGE.set_TOKEN('PARAMETERS',
2849: 'Complted Payments Group id = ' || to_char(p_completed_pmts_group_id));
2850: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
2851: END IF;
2852:

Line 2850: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);

2846: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
2847: FND_MESSAGE.set_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
2848: FND_MESSAGE.set_TOKEN('PARAMETERS',
2849: 'Complted Payments Group id = ' || to_char(p_completed_pmts_group_id));
2850: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
2851: END IF;
2852:
2853: /* Start - BUG 14364091 - Logging */
2854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);