DBA Data[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on FND_FILE

Line 50: psp_message_s.print_error(p_mode => FND_FILE.LOG,

46: --retcode := 2;
47: --return;
48: END IF;
49:
50: psp_message_s.print_error(p_mode => FND_FILE.LOG,
51: p_print_header => FND_API.G_FALSE);
52:
53: fnd_msg_pub.initialize;
54:

Line 89: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for psp_enc_summary_lines');

85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87:
88: -- Bug 6118274
89: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for psp_enc_summary_lines');
90: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
91: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for psp_enc_summary_lines');
92: -- Bug 6118274
93:

Line 91: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for psp_enc_summary_lines');

87:
88: -- Bug 6118274
89: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for psp_enc_summary_lines');
90: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
91: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for psp_enc_summary_lines');
92: -- Bug 6118274
93:
94: -- Check the target system status and do the tieback
95: gms_tie_back(p_adj_sum_batch_name,

Line 158: psp_message_s.print_error(p_mode => FND_FILE.LOG,

154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157: if fnd_msg_pub.Count_Msg > 0 then
158: psp_message_s.print_error(p_mode => FND_FILE.LOG,
159: p_print_header => FND_API.G_FALSE);
160: else
161: PSP_MESSAGE_S.Print_success;
162: end if;

Line 170: psp_message_s.print_error(p_mode => FND_FILE.LOG,

166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: -- Bug 1776606 : Introduced Rollback ,
168: rollback;
169:
170: psp_message_s.print_error(p_mode => FND_FILE.LOG,
171: p_print_header => FND_API.G_TRUE);
172: retcode := 2;
173: WHEN OTHERS THEN
174: --Bug 1776606 : Introduced Rollback

Line 176: psp_message_s.print_error(p_mode => FND_FILE.LOG,

172: retcode := 2;
173: WHEN OTHERS THEN
174: --Bug 1776606 : Introduced Rollback
175: rollback;
176: psp_message_s.print_error(p_mode => FND_FILE.LOG,
177: p_print_header => FND_API.G_TRUE);
178: retcode := 2;
179: END;
180:

Line 3644: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for pa_transaction_interface_all');

3640:
3641: BEGIN
3642:
3643: /*Bug 6118274*/
3644: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for pa_transaction_interface_all');
3645: fnd_stats.gather_table_stats('PA', 'PA_TRANSACTION_INTERFACE_ALL');
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for pa_transaction_interface_all');
3647: /*Bug 6118274*/
3648:

Line 3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for pa_transaction_interface_all');

3642:
3643: /*Bug 6118274*/
3644: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for pa_transaction_interface_all');
3645: fnd_stats.gather_table_stats('PA', 'PA_TRANSACTION_INTERFACE_ALL');
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for pa_transaction_interface_all');
3647: /*Bug 6118274*/
3648:
3649: open pc_batch_cur;
3650: loop

Line 3686: --fnd_file.put_line(fnd_file.log, 'after user hook');

3682: pc_batch_rec.batch_name,
3683: l_gms_batch_name ,
3684: p_business_group_id,
3685: p_set_of_books_id );
3686: --fnd_file.put_line(fnd_file.log, 'after user hook');
3687: hr_utility.trace('after userhook - ');
3688:
3689:
3690: OPEN transaction_source_cur;