eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_SUM_TRANS dependencies on FND_API

Line 107: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

103: p_business_group_id,
104: p_set_of_books_id,
105: l_return_status);
106:
107: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' FIRST NORMAL RUN');

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

104: p_set_of_books_id,
105: l_return_status);
106:
107: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' FIRST NORMAL RUN');
112: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling create_gl_sum_lines');

Line 124: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

120: p_batch_name,
121: p_business_group_id,
122: p_set_of_books_id,
123: l_return_status);
124: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128: -- call the user extension to populate attribute1 through attribute30

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

121: p_business_group_id,
122: p_set_of_books_id,
123: l_return_status);
124: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128: -- call the user extension to populate attribute1 through attribute30
129: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

Line 150: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

146: p_business_group_id,
147: p_set_of_books_id,
148: l_return_status);
149:
150: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153:
154: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling create_gms_sum_lines');

Line 151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

147: p_set_of_books_id,
148: l_return_status);
149:
150: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153:
154: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling create_gms_sum_lines');
155:

Line 163: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

159: p_batch_name,
160: p_business_group_id,
161: p_set_of_books_id,
162: l_return_status);
163: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167: -- Call the user extension to populate attribute1 thru attribute 30.

Line 164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

160: p_business_group_id,
161: p_set_of_books_id,
162: l_return_status);
163: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167: -- Call the user extension to populate attribute1 thru attribute 30.
168: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

Line 188: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

184: p_business_group_id,
185: p_set_of_books_id,
186: l_return_status);
187:
188: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' SECOND RUN TO TAKE CARE OF TIE-BACK');

Line 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

185: p_set_of_books_id,
186: l_return_status);
187:
188: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' SECOND RUN TO TAKE CARE OF TIE-BACK');
193:

Line 207: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

203: p_business_group_id,
204: p_set_of_books_id,
205: l_return_status);
206:
207: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210:
211: -- Call the user extension to populate attribute1 thru attribute 30.

Line 208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

204: p_set_of_books_id,
205: l_return_status);
206:
207: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210:
211: -- Call the user extension to populate attribute1 thru attribute 30.
212: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

Line 232: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

228: p_business_group_id,
229: p_set_of_books_id,
230: l_return_status);
231:
232: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235:
236:

Line 233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

229: p_set_of_books_id,
230: l_return_status);
231:
232: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235:
236:
237: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' calling create_gms_sum_lines');

Line 247: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

243: p_business_group_id,
244: p_set_of_books_id,
245: l_return_status);
246:
247: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END IF;
250:
251: -- call the user extension to populate attribute1 through attribute30

Line 248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

244: p_set_of_books_id,
245: l_return_status);
246:
247: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END IF;
250:
251: -- call the user extension to populate attribute1 through attribute30
252: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

Line 273: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

269: p_business_group_id,
270: p_set_of_books_id,
271: l_return_status);
272:
273: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
275: END IF;
276: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' calling mark_batch_end');
277:

Line 274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

270: p_set_of_books_id,
271: l_return_status);
272:
273: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
275: END IF;
276: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' calling mark_batch_end');
277:
278:

Line 287: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

283: p_business_group_id,
284: p_set_of_books_id,
285: l_return_status);
286:
287: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: END IF;
290:
291: PSP_MESSAGE_S.Print_success;

Line 288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

284: p_set_of_books_id,
285: l_return_status);
286:
287: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: END IF;
290:
291: PSP_MESSAGE_S.Print_success;
292:

Line 294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

290:
291: PSP_MESSAGE_S.Print_success;
292:
293: EXCEPTION
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295:
296: /* Introduced as part of bug fix #1776606 */
297: ROLLBACK;
298: /* Commented as part of Bug fix #1776606

Line 307: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

303: p_business_group_id,
304: p_set_of_books_id,
305: l_return_status);
306:
307: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: END IF;
310:
311: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,

Line 308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

304: p_set_of_books_id,
305: l_return_status);
306:
307: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: END IF;
310:
311: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
312: p_encoded => FND_API.G_FALSE,

Line 312: p_encoded => FND_API.G_FALSE,

308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: END IF;
310:
311: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
312: p_encoded => FND_API.G_FALSE,
313: p_data => l_msg_data,
314: p_msg_index_out => l_msg_count); */
315:
316: g_error_api_path := 'SUM_AND_TRANSFER:'||g_error_api_path;

Line 319: p_print_header => FND_API.G_TRUE);

315:
316: g_error_api_path := 'SUM_AND_TRANSFER:'||g_error_api_path;
317: errbuf := SUBSTR(l_msg_data || fnd_global.local_chr(10) ||fnd_global.local_chr(10)||g_error_api_path,1,230);
318: psp_message_s.print_error(p_mode => FND_FILE.LOG,
319: p_print_header => FND_API.G_TRUE);
320: retcode := 2;
321: WHEN OTHERS THEN
322: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
323:

Line 336: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

332: p_business_group_id,
333: p_set_of_books_id,
334: l_return_status);
335:
336: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339:
340: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');

Line 337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

333: p_set_of_books_id,
334: l_return_status);
335:
336: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339:
340: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');
341: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,

Line 342: p_encoded => FND_API.G_FALSE,

338: END IF;
339:
340: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');
341: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
342: p_encoded => FND_API.G_FALSE,
343: p_data => l_msg_data,
344: p_msg_index_out => l_msg_count); */
345:
346: g_error_api_path := 'SUM_AND_TRANSFER:'||g_error_api_path;

Line 349: p_print_header => FND_API.G_TRUE);

345:
346: g_error_api_path := 'SUM_AND_TRANSFER:'||g_error_api_path;
347: errbuf := SUBSTR(l_msg_data || fnd_global.local_chr(10) ||fnd_global.local_chr(10)||g_error_api_path,1,230);
348: psp_message_s.print_error(p_mode => FND_FILE.LOG,
349: p_print_header => FND_API.G_TRUE);
350: retcode := 2;
351: END;
352:
353: -------------------- MARK BATCH BEGIN --------------------------------------------

Line 439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

435: fnd_message.set_name('PSP','PSP_TI_DID_NOT_COMPLETE');
436: fnd_message.set_token('PAYROLL_CONTROL_ID', payroll_control_rec.payroll_control_id);
437: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);
438: fnd_msg_pub.add;
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: end if;
441:
442: end if;
443:

Line 453: p_return_status := fnd_api.g_ret_sts_unexp_error;

449: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
450:
451: g_error_api_path := 'MARK_BATCH_BEGIN: ' || g_error_api_path;
452: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_BEGIN');
453: p_return_status := fnd_api.g_ret_sts_unexp_error;
454: RAISE;
455: END;
456: -------------------- MARK BATCH END ---------------------------------------------
457:

Line 513: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

509: p_source_code ,
510: p_time_period_id,
511: p_batch_name,
512: l_return_status);
513: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516:
517:

Line 514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

510: p_time_period_id,
511: p_batch_name,
512: l_return_status);
513: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516:
517:
518: End IF;

Line 626: p_return_status := fnd_api.g_ret_sts_unexp_error;

622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
623:
624: g_error_api_path := 'MARK_BATCH_END: ' || g_error_api_path;
625: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_END');
626: p_return_status := fnd_api.g_ret_sts_unexp_error;
627: RAISE;
628: END;
629: -------------------- CREATE GL SUM LINES -----------------------------------------------
630:

Line 861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

857: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
858: fnd_message.set_token('VALUE',l_value);
859: fnd_message.set_token('TABLE',l_table);
860: fnd_msg_pub.add;
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END;
863:
864:
865: -- Made the following call for Bug 2916848 to populate l_precision , l_ext_precision

Line 876: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

872: p_set_of_books_id,
873: l_precision,-- Introduced for Bug 2916848
874: l_return_status);
875:
876: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;
879:
880: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' openinging gl_sum_lines_cursor');

Line 877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

873: l_precision,-- Introduced for Bug 2916848
874: l_return_status);
875:
876: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;
879:
880: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' openinging gl_sum_lines_cursor');
881:

Line 982: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

978: l_attribute9,
979: l_attribute10,
980: l_return_status);
981:
982: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
984: END IF;
985:
986:

Line 983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

979: l_attribute10,
980: l_return_status);
981:
982: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
984: END IF;
985:
986:
987: FOR j IN 1 .. dist_line_id.COUNT LOOP

Line 1081: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1077: l_attribute10,
1078: l_return_status);
1079:
1080:
1081: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: END IF;
1084:
1085:

Line 1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1078: l_return_status);
1079:
1080:
1081: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: END IF;
1084:
1085:
1086:

Line 1113: p_return_status := fnd_api.g_ret_sts_success;

1109: END IF;
1110:
1111: END LOOP;
1112: --
1113: p_return_status := fnd_api.g_ret_sts_success;
1114:
1115: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving create_gl_sum_lines');
1116:
1117: EXCEPTION

Line 1119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1115: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving create_gl_sum_lines');
1116:
1117: EXCEPTION
1118:
1119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1120: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1121: p_return_status := fnd_api.g_ret_sts_unexp_error;
1122: WHEN OTHERS THEN
1123: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 1121: p_return_status := fnd_api.g_ret_sts_unexp_error;

1117: EXCEPTION
1118:
1119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1120: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1121: p_return_status := fnd_api.g_ret_sts_unexp_error;
1122: WHEN OTHERS THEN
1123: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1124:
1125: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;

Line 1127: p_return_status := fnd_api.g_ret_sts_unexp_error;

1123: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1124:
1125: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1126: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');
1127: p_return_status := fnd_api.g_ret_sts_unexp_error;
1128:
1129: END;
1130:
1131:

Line 1270: p_return_status := fnd_api.g_ret_sts_success;

1266: p_attribute10,
1267: p_org_id -- R12 MOAC uptake
1268: );
1269: --
1270: p_return_status := fnd_api.g_ret_sts_success;
1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1274:

Line 1278: p_return_status := fnd_api.g_ret_sts_unexp_error;

1274:
1275: --dbms_output.put_line('Errrrrrrrrrrrrrrrrrrrrrrrrrrorrrrrrrrrrr.........');
1276: g_error_api_path := 'INSERT_INTO_SUMMARY_LINES:'||g_error_api_path;
1277: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_SUMMARY_LINES');
1278: p_return_status := fnd_api.g_ret_sts_unexp_error;
1279: END;
1280:
1281: ------------------------ GL INTERFACE --------------------------------------------------
1282:

Line 1411: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1407: -- get the source name
1408: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' entered transfer_to_gl_interface');
1409: get_gl_je_sources(l_user_je_source_name,
1410: l_return_status);
1411: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1413: END IF;
1414:
1415: -- get the category name

Line 1412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1408: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' entered transfer_to_gl_interface');
1409: get_gl_je_sources(l_user_je_source_name,
1410: l_return_status);
1411: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1413: END IF;
1414:
1415: -- get the category name
1416: get_gl_je_categories(l_user_je_category_name,

Line 1418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1414:
1415: -- get the category name
1416: get_gl_je_categories(l_user_je_category_name,
1417: l_return_status);
1418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: END IF;
1421:
1422: /* Changed the following code for Bug 3112053 , so as to submit one journal import for a batch having same

Line 1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1415: -- get the category name
1416: get_gl_je_categories(l_user_je_category_name,
1417: l_return_status);
1418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: END IF;
1421:
1422: /* Changed the following code for Bug 3112053 , so as to submit one journal import for a batch having same
1423: source_code,source_type,time_period_id,batch_name combination */

Line 1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1452: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1453: fnd_message.set_token('VALUE',l_value);
1454: fnd_message.set_token('TABLE',l_table);
1455: fnd_msg_pub.add;
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END;
1458:
1459: If gl_batch_rec.phase = 'Summarize_GL_Lines' then --- added for 2444657
1460: l_reference1 := gl_batch_rec.source_type||':'||gl_batch_rec.payroll_source_code||':'||l_period_name||':'||gl_batch_rec.batch_name;

Line 1538: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1534: GL_INTERFACE_REC.ACCOUNTING_DATE,
1535: -- Introduced for Bug 2916848
1536: L_RETURN_STATUS);
1537:
1538: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1539: --dbms_output.put_line('Faaaaaaiiiiiiilllllllleeeeeeeeeddddddd......');
1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: END IF;
1542:

Line 1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1536: L_RETURN_STATUS);
1537:
1538: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1539: --dbms_output.put_line('Faaaaaaiiiiiiilllllllleeeeeeeeeddddddd......');
1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: END IF;
1542:
1543: END LOOP; -- End of gl_interface_cursor
1544:

Line 1621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1617: IF req_id = 0 THEN
1618:
1619: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
1620: fnd_msg_pub.add;
1621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1622:
1623: ELSE
1624:
1625: -- Added the update for Rollback purposes.

Line 1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1645: IF call_status = FALSE THEN
1646:
1647: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
1648: fnd_msg_pub.add;
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1650:
1651: END IF;
1652:
1653: END IF; -- End for check req_id = 0

Line 1686: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1682:
1683: /* Bug 1617846 LD Recovery LOV not showing up fialed S and T */
1684: /* introduced ELSE clause */
1685:
1686: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1687: CLOSE gl_payroll_control_cursor;
1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1689: END IF;
1690:

Line 1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1684: /* introduced ELSE clause */
1685:
1686: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1687: CLOSE gl_payroll_control_cursor;
1688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1689: END IF;
1690:
1691: END LOOP;
1692: CLOSE gl_payroll_control_cursor;

Line 1700: p_return_status := fnd_api.g_ret_sts_success;

1696: END LOOP; -- End of gl_batch_csr
1697:
1698: /* End of code changes for Bug 3112053 */
1699:
1700: p_return_status := fnd_api.g_ret_sts_success;
1701:
1702: EXCEPTION
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: --dbms_output.put_line('Gone to one level top ..................');

Line 1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1699:
1700: p_return_status := fnd_api.g_ret_sts_success;
1701:
1702: EXCEPTION
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: --dbms_output.put_line('Gone to one level top ..................');
1705: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1706: p_return_status := fnd_api.g_ret_sts_unexp_error;
1707:

Line 1706: p_return_status := fnd_api.g_ret_sts_unexp_error;

1702: EXCEPTION
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: --dbms_output.put_line('Gone to one level top ..................');
1705: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1706: p_return_status := fnd_api.g_ret_sts_unexp_error;
1707:
1708: WHEN RETURN_BACK THEN
1709: p_return_status := fnd_api.g_ret_sts_success;
1710:

Line 1709: p_return_status := fnd_api.g_ret_sts_success;

1705: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1706: p_return_status := fnd_api.g_ret_sts_unexp_error;
1707:
1708: WHEN RETURN_BACK THEN
1709: p_return_status := fnd_api.g_ret_sts_success;
1710:
1711: WHEN OTHERS THEN
1712: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1713:

Line 1716: p_return_status := fnd_api.g_ret_sts_unexp_error;

1712: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1713:
1714: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1715: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1716: p_return_status := fnd_api.g_ret_sts_unexp_error;
1717: END;
1718:
1719: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------
1720: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,

Line 1737: p_return_status := fnd_api.g_ret_sts_unexp_error;

1733: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1734: fnd_message.set_token('ERROR',l_error);
1735: fnd_message.set_token('PRODUCT',l_product);
1736: fnd_msg_pub.add;
1737: p_return_status := fnd_api.g_ret_sts_unexp_error;
1738: WHEN OTHERS THEN
1739: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1740:
1741: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;

Line 1743: p_return_status := fnd_api.g_ret_sts_unexp_error;

1739: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1740:
1741: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1742: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1743: p_return_status := fnd_api.g_ret_sts_unexp_error;
1744: END;
1745:
1746: ---------------------- GET_GL_CATEGORIES --------------------------------------------------
1747: PROCEDURE get_gl_je_categories(P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,

Line 1764: p_return_status := fnd_api.g_ret_sts_unexp_error;

1760: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1761: fnd_message.set_token('ERROR',l_error);
1762: fnd_message.set_token('PRODUCT',l_product);
1763: fnd_msg_pub.add;
1764: p_return_status := fnd_api.g_ret_sts_unexp_error;
1765: WHEN OTHERS THEN
1766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1767:
1768: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;

Line 1770: p_return_status := fnd_api.g_ret_sts_unexp_error;

1766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1767:
1768: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;
1769: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');
1770: p_return_status := fnd_api.g_ret_sts_unexp_error;
1771: END;
1772:
1773: ---------------------- GET_ENCUM_TYPE_ID -----------------------------------------------
1774: PROCEDURE get_encum_type_id(P_ENCUMBRANCE_TYPE_ID OUT NOCOPY VARCHAR2,

Line 1793: p_return_status := fnd_api.g_ret_sts_unexp_error;

1789: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1790: fnd_message.set_token('ERROR',l_error);
1791: fnd_message.set_token('PRODUCT',l_product);
1792: fnd_msg_pub.add;
1793: p_return_status := fnd_api.g_ret_sts_unexp_error;
1794: WHEN OTHERS THEN
1795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1796:
1797: g_error_api_path := 'ENCUMBRANCE_TYPE_ID:'||g_error_api_path;

Line 1799: p_return_status := fnd_api.g_ret_sts_unexp_error;

1795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1796:
1797: g_error_api_path := 'ENCUMBRANCE_TYPE_ID:'||g_error_api_path;
1798: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','ENCUMBRANCE_TYPE_ID');
1799: p_return_status := fnd_api.g_ret_sts_unexp_error;
1800: END;
1801:
1802:
1803: -------------------- GL TIE BACK -----------------------------------------------------

Line 2062: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2058: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling get_gl_je_source');
2059:
2060: get_gl_je_sources(l_user_je_source_name,
2061: l_return_status);
2062: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064: END IF;
2065:
2066: delete gl_interface_Control

Line 2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2059:
2060: get_gl_je_sources(l_user_je_source_name,
2061: l_return_status);
2062: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064: END IF;
2065:
2066: delete gl_interface_Control
2067: where group_id = p_group_id

Line 2088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2084: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
2085: fnd_message.set_token('GROUP_ID',p_group_id);
2086: fnd_msg_pub.add;
2087: -- uncommented following statement for 2444657
2088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2089:
2090: end if;
2091:
2092: SELECT count(*)

Line 2267: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR

2263: p_business_group_id => p_business_group_id,
2264: ret_expenditure_type => l_new_expenditure_type,
2265: ret_gl_code_combination_id => l_new_glccid,
2266: retcode => l_auto_pop_status);
2267: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2268: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
2269: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2270: if l_acct_type ='N' then
2271: l_auto_status := 'AUTO_POP_NA_ERROR';

Line 2268: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN

2264: ret_expenditure_type => l_new_expenditure_type,
2265: ret_gl_code_combination_id => l_new_glccid,
2266: retcode => l_auto_pop_status);
2267: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2268: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
2269: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2270: if l_acct_type ='N' then
2271: l_auto_status := 'AUTO_POP_NA_ERROR';
2272: else

Line 2269: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2265: ret_gl_code_combination_id => l_new_glccid,
2266: retcode => l_auto_pop_status);
2267: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2268: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
2269: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2270: if l_acct_type ='N' then
2271: l_auto_status := 'AUTO_POP_NA_ERROR';
2272: else
2273: l_auto_status :='AUTO_POP_EXP_ERROR';

Line 2275: elsif l_auto_pop_status = FND_API.G_RET_STS_ERROR THEN

2271: l_auto_status := 'AUTO_POP_NA_ERROR';
2272: else
2273: l_auto_status :='AUTO_POP_EXP_ERROR';
2274: end if;
2275: elsif l_auto_pop_status = FND_API.G_RET_STS_ERROR THEN
2276: l_auto_status := 'AUTO_POP_NO_VALUE';
2277: end if;
2278: open get_asg_details;
2279: fetch get_asg_details into l_person_name, l_assignment_number, l_element_type, l_auto_org_name;

Line 2382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2378: END LOOP;
2379: ---2445196: cleanup gl interface b'cos rejection is available in rejected summary lines
2380: get_gl_je_sources(l_user_je_source_name,
2381: l_return_status);
2382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2384: END IF;
2385:
2386: delete gl_interface

Line 2383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2379: ---2445196: cleanup gl interface b'cos rejection is available in rejected summary lines
2380: get_gl_je_sources(l_user_je_source_name,
2381: l_return_status);
2382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2384: END IF;
2385:
2386: delete gl_interface
2387: where group_id = p_group_id

Line 2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2446: g_batch_name,
2447: p_business_group_id,
2448: p_set_of_books_id,
2449: l_return_status);
2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2451: end if;
2452: END IF;
2453:
2454: IF l_suspense_ac_failed = 'Y' or

Line 2518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2514: g_batch_name,
2515: p_business_group_id,
2516: p_set_of_books_id,
2517: l_return_status);
2518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2519: end if;
2520: END IF;
2521:
2522: IF l_suspense_ac_not_found = 'Y' THEN

Line 2543: --- RAISE FND_API.G_EXC_UNEXPECTED_ERROR; commented for 2479579

2539: g_batch_name,
2540: p_business_group_id,
2541: p_set_of_books_id,
2542: l_return_status);
2543: --- RAISE FND_API.G_EXC_UNEXPECTED_ERROR; commented for 2479579
2544: -- introduced following if stmnt for 2479579
2545: if l_susp_exception = 'NO_G_AC' then
2546: RAISE no_global_acct_exists;
2547: elsif l_susp_exception = 'NO_DT_MCH' then

Line 2689: p_return_status := fnd_api.g_ret_sts_success;

2685:
2686:
2687: END IF;
2688: --
2689: p_return_status := fnd_api.g_ret_sts_success;
2690: EXCEPTION
2691:
2692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2693: --dbms_output.put_line('Gone to one level top ..................');

Line 2692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2688: --
2689: p_return_status := fnd_api.g_ret_sts_success;
2690: EXCEPTION
2691:
2692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2693: --dbms_output.put_line('Gone to one level top ..................');
2694: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
2695: p_return_status := fnd_api.g_ret_sts_unexp_error;
2696:

Line 2695: p_return_status := fnd_api.g_ret_sts_unexp_error;

2691:
2692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2693: --dbms_output.put_line('Gone to one level top ..................');
2694: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
2695: p_return_status := fnd_api.g_ret_sts_unexp_error;
2696:
2697: /* Added Exceptions for bug 2056877 */
2698: WHEN NO_PROFILE_EXISTS THEN
2699: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);

Line 2702: p_return_status := fnd_api.g_ret_sts_unexp_error;

2698: WHEN NO_PROFILE_EXISTS THEN
2699: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2700: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
2701: fnd_msg_pub.add;
2702: p_return_status := fnd_api.g_ret_sts_unexp_error;
2703:
2704: WHEN NO_VAL_DATE_MATCHES THEN
2705: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2706: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

Line 2710: p_return_status := fnd_api.g_ret_sts_unexp_error;

2706: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2707: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2708: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2709: fnd_msg_pub.add;
2710: p_return_status := fnd_api.g_ret_sts_unexp_error;
2711:
2712: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2713: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2714: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

Line 2718: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.

2714: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2715: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2716: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2717: fnd_msg_pub.add;
2718: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.
2719:
2720: WHEN OTHERS THEN
2721: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2722:

Line 2725: p_return_status := fnd_api.g_ret_sts_unexp_error;

2721: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2722:
2723: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
2724: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
2725: p_return_status := fnd_api.g_ret_sts_unexp_error;
2726: END;
2727:
2728:
2729: ------------------ CREATE BALANCING TRANSACTIONS FOR GL ------------------------------

Line 2851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2847:
2848: IF l_cr_amount <> l_dr_amount then
2849: fnd_message.set_name('PSP','PSP_GL_REV_AMT_NOT_EQUAL');
2850: fnd_msg_pub.add;
2851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2852: END IF;
2853:
2854: ELSIF p_source_type = 'P' THEN
2855: SELECT payroll_id INTO l_payroll_id

Line 2870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2866: EXCEPTION
2867: WHEN NO_DATA_FOUND THEN
2868: fnd_message.set_name('PSP','PSP_TR_CLRG_AC_NOT_SET_UP');
2869: fnd_msg_pub.add;
2870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2871: END;
2872:
2873: delete from psp_pre_gen_dist_lines
2874: where reversal_entry_flag = 'Y'

Line 2928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2924:
2925: IF l_cr_amount <> l_dr_amount then
2926: fnd_message.set_name('PSP','PSP_GL_UNBALANCED_BATCH');
2927: fnd_msg_pub.add;
2928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2929: END IF;
2930:
2931: END IF;
2932: --

Line 2933: p_return_status := fnd_api.g_ret_sts_success;

2929: END IF;
2930:
2931: END IF;
2932: --
2933: p_return_status := fnd_api.g_ret_sts_success;
2934: EXCEPTION
2935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2936: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2937: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2931: END IF;
2932: --
2933: p_return_status := fnd_api.g_ret_sts_success;
2934: EXCEPTION
2935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2936: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2937: p_return_status := fnd_api.g_ret_sts_unexp_error;
2938:
2939: WHEN OTHERS THEN

Line 2937: p_return_status := fnd_api.g_ret_sts_unexp_error;

2933: p_return_status := fnd_api.g_ret_sts_success;
2934: EXCEPTION
2935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2936: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2937: p_return_status := fnd_api.g_ret_sts_unexp_error;
2938:
2939: WHEN OTHERS THEN
2940: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2941:

Line 2944: p_return_status := fnd_api.g_ret_sts_unexp_error;

2940: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2941:
2942: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2943: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');
2944: p_return_status := fnd_api.g_ret_sts_unexp_error;
2945: END;
2946:
2947: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------
2948:

Line 3112: p_return_status := fnd_api.g_ret_sts_success;

3108: P_ATTRIBUTE30,
3109: P_CURRENCY_CONVERSION_TYPE,-- Introduced the following code for Bug fix 2916848
3110: DECODE(p_currency_conversion_type, NULL, NULL, P_CURRENCY_CONVERSION_DATE));-- Introduced the following code for Bug fix 2916848
3111: --dbms_output.put_line('DDDDDDDDDDDDDDDDDGL Interface Inserted ....................');
3112: p_return_status := fnd_api.g_ret_sts_success;
3113: EXCEPTION
3114: WHEN OTHERS THEN
3115: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3116:

Line 3120: p_return_status := fnd_api.g_ret_sts_unexp_error;

3116:
3117: --dbms_output.put_line('Error while inserting .........................');
3118: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
3119: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');
3120: p_return_status := fnd_api.g_ret_sts_unexp_error;
3121: END;
3122:
3123: -------------------- CREATE GMS SUM LINES -----------------------------------------------
3124: PROCEDURE create_gms_sum_lines(p_source_type IN VARCHAR2,

Line 3385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3381: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3382: fnd_message.set_token('VALUE',l_value);
3383: fnd_message.set_token('TABLE',l_table);
3384: fnd_msg_pub.add;
3385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3386: END;
3387:
3388: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' opening gms_sum_lines_cursor');
3389:

Line 3512: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3508: l_return_status,
3509: l_org_id -- R12 MOAC Uptake
3510: );
3511:
3512: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3514: END IF;
3515:
3516: FOR j IN 1 .. dist_line_id.COUNT LOOP

Line 3513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3509: l_org_id -- R12 MOAC Uptake
3510: );
3511:
3512: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3514: END IF;
3515:
3516: FOR j IN 1 .. dist_line_id.COUNT LOOP
3517: l_dist_line_id := dist_line_id(j);

Line 3613: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3609: l_return_status,
3610: l_org_id -- R12 MOAC uptake
3611: );
3612:
3613: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3615: END IF;
3616:
3617: FOR j IN 1 .. dist_line_id.COUNT LOOP

Line 3614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3610: l_org_id -- R12 MOAC uptake
3611: );
3612:
3613: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3615: END IF;
3616:
3617: FOR j IN 1 .. dist_line_id.COUNT LOOP
3618: l_dist_line_id := dist_line_id(j);

Line 3637: p_return_status := fnd_api.g_ret_sts_success;

3633: dist_line_id.delete;
3634: END IF;
3635: END LOOP;
3636: --
3637: p_return_status := fnd_api.g_ret_sts_success;
3638:
3639:
3640: EXCEPTION
3641:

Line 3642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3638:
3639:
3640: EXCEPTION
3641:
3642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3643: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3644: p_return_status := fnd_api.g_ret_sts_unexp_error;
3645: WHEN OTHERS THEN
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 3644: p_return_status := fnd_api.g_ret_sts_unexp_error;

3640: EXCEPTION
3641:
3642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3643: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3644: p_return_status := fnd_api.g_ret_sts_unexp_error;
3645: WHEN OTHERS THEN
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3647:
3648: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;

Line 3650: p_return_status := fnd_api.g_ret_sts_unexp_error;

3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3647:
3648: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3649: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');
3650: p_return_status := fnd_api.g_ret_sts_unexp_error;
3651:
3652: END;
3653:
3654: ----------------------------- GMS INTERFACE ---------------------------------------------

Line 3787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3783: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3784: fnd_message.set_token('ERROR',l_error);
3785: fnd_message.set_token('PRODUCT',l_product);
3786: fnd_msg_pub.add;
3787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3788: END;
3789:
3790: if (l_gms_install) then -- Changed site_enabled check to l_gms_install check for bug fix 2908859
3791: BEGIN

Line 3804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3800: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3801: fnd_message.set_token('ERROR',l_error);
3802: fnd_message.set_token('PRODUCT',l_product);
3803: fnd_msg_pub.add;
3804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3805: END;
3806: end if;
3807:
3808: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' open gms_batch_cursor');

Line 3834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3830: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3831: fnd_message.set_token('VALUE',l_value);
3832: fnd_message.set_token('TABLE',l_table);
3833: fnd_msg_pub.add;
3834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3835: END;
3836:
3837: -- R12 MOAC Uptake .. org_id array to always populate 5090047
3838: -- moved If condin below

Line 3909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3905: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3906: fnd_message.set_token('VALUE',l_value);
3907: fnd_message.set_token('TABLE',l_table);
3908: fnd_msg_pub.add;
3909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3910: END;
3911:
3912: -- get the employee's organization name
3913: BEGIN

Line 3927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3923: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3924: fnd_message.set_token('VALUE',l_value);
3925: fnd_message.set_token('TABLE',l_table);
3926: fnd_msg_pub.add;
3927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3928: --l_org_name := NULL;
3929: --l_org_name := 'LDM_ORG_NAME_INVALID';
3930: END;
3931:

Line 3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3942: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3943: fnd_message.set_token('VALUE',l_value);
3944: fnd_message.set_token('TABLE',l_table);
3945: fnd_msg_pub.add;
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END;
3948:
3949: -- R12 MOAC Uptake. Org_id is stored in psp_summary_line Table
3950: /*

Line 3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3961: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
3962: fnd_message.set_token('VALUE',l_value);
3963: fnd_message.set_token('TABLE',l_table);
3964: fnd_msg_pub.add;
3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3966: END;
3967: */
3968:
3969: -- get the task number

Line 3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3979: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3980: fnd_message.set_token('VALUE',l_value);
3981: fnd_message.set_token('TABLE',l_table);
3982: fnd_msg_pub.add;
3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3984: END;
3985:
3986: -- Get the transaction_interface_id. We need this to populate the gms_interface table.
3987:

Line 4067: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4063: gms_interface_rec.accounting_date,-- Introduced for bug 2916848 Ilo Ehn Mrc
4064: p_business_group_id,--Introduced for bug 2935850
4065: L_RETURN_STATUS);
4066:
4067: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4068: --dbms_output.put_line('Faaaaaaiiiiiiilllllllleeeeeeeeeddddddd......');
4069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4070: END IF;
4071:

Line 4069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4065: L_RETURN_STATUS);
4066:
4067: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4068: --dbms_output.put_line('Faaaaaaiiiiiiilllllllleeeeeeeeeddddddd......');
4069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4070: END IF;
4071:
4072: ELSE
4073: insert_into_pa_interface(l_txn_interface_id,

Line 4107: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4103: gms_interface_rec.accounting_date,-- Introduced for bug 2916848 Ilo Ehn Mrc
4104: p_business_group_id,--Introduced for bug 2935850
4105: L_RETURN_STATUS);
4106:
4107: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4109: END IF;
4110:
4111: END IF;

Line 4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4104: p_business_group_id,--Introduced for bug 2935850
4105: L_RETURN_STATUS);
4106:
4107: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4109: END IF;
4110:
4111: END IF;
4112:

Line 4136: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4132: GMS_REC.FUNDING_PATTERN_ID := NULL;
4133:
4134: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
4135:
4136: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4138: END IF;
4139:
4140: end if;

Line 4137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4133:
4134: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
4135:
4136: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4138: END IF;
4139:
4140: end if;
4141:

Line 4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4192:
4193: IF req_id = 0 THEN
4194: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
4195: fnd_msg_pub.add;
4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4197: END IF;
4198: END LOOP;
4199:
4200: END IF; -- g_create_stat_batch_in_gms -- change

Line 4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4215: rphase, rstatus, dphase, dstatus, message);
4216: IF call_status_tab(I) = FALSE then
4217: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
4218: fnd_msg_pub.add;
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4220: END IF;
4221: END LOOP;
4222:
4223: END IF; -- g_skip_flag_gms -- change

Line 4269: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4265:
4266: /* Bug 1617846 LD Recovery LOV not showing up fialed S and T */
4267: /* introduced ELSE clause */
4268:
4269: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271: -- ELSE --Commented for R12 MOAc uptake;
4272: --- moved update psp_payroll_control phase = Tie back inside gms_tie_back
4273: --- for 2444657

Line 4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4266: /* Bug 1617846 LD Recovery LOV not showing up fialed S and T */
4267: /* introduced ELSE clause */
4268:
4269: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271: -- ELSE --Commented for R12 MOAc uptake;
4272: --- moved update psp_payroll_control phase = Tie back inside gms_tie_back
4273: --- for 2444657
4274: -- commit; --Commented for R12 MOAc uptake

Line 4282: p_return_status := fnd_api.g_ret_sts_success;

4278: END IF;
4279: END LOOP;
4280:
4281: --
4282: p_return_status := fnd_api.g_ret_sts_success;
4283: EXCEPTION
4284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4285: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4286: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4280:
4281: --
4282: p_return_status := fnd_api.g_ret_sts_success;
4283: EXCEPTION
4284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4285: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4286: p_return_status := fnd_api.g_ret_sts_unexp_error;
4287:
4288: WHEN RETURN_BACK THEN

Line 4286: p_return_status := fnd_api.g_ret_sts_unexp_error;

4282: p_return_status := fnd_api.g_ret_sts_success;
4283: EXCEPTION
4284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4285: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4286: p_return_status := fnd_api.g_ret_sts_unexp_error;
4287:
4288: WHEN RETURN_BACK THEN
4289: p_return_status := fnd_api.g_ret_sts_success;
4290:

Line 4289: p_return_status := fnd_api.g_ret_sts_success;

4285: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4286: p_return_status := fnd_api.g_ret_sts_unexp_error;
4287:
4288: WHEN RETURN_BACK THEN
4289: p_return_status := fnd_api.g_ret_sts_success;
4290:
4291: WHEN OTHERS THEN
4292: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
4293:

Line 4296: p_return_status := fnd_api.g_ret_sts_unexp_error;

4292: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
4293:
4294: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4295: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GMS_INTERFACE');
4296: p_return_status := fnd_api.g_ret_sts_unexp_error;
4297: END;
4298:
4299:
4300: ------------------------- GMS TIE BACK ---------------------------------------------------

Line 4634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4630: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_RUN');
4631: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
4632: fnd_message.set_token('GMS_BATCH_NAME',p_gms_batch_name);
4633: fnd_msg_pub.add;
4634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4635: end if;
4636: end if;
4637: hr_utility.trace('entered gms_tie_back2');
4638: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' entered gms_tie_back2');

Line 5000: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR

4996: p_business_group_id => p_business_group_id,
4997: ret_expenditure_type => l_new_expenditure_type,
4998: ret_gl_code_combination_id => l_new_glccid,
4999: retcode => l_auto_pop_status);
5000: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
5001: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
5002: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5003: if l_acct_type ='N' then
5004: l_auto_status := 'AUTO_POP_NA_ERROR';

Line 5001: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN

4997: ret_expenditure_type => l_new_expenditure_type,
4998: ret_gl_code_combination_id => l_new_glccid,
4999: retcode => l_auto_pop_status);
5000: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
5001: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
5002: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5003: if l_acct_type ='N' then
5004: l_auto_status := 'AUTO_POP_NA_ERROR';
5005: else

Line 5002: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4998: ret_gl_code_combination_id => l_new_glccid,
4999: retcode => l_auto_pop_status);
5000: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
5001: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
5002: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5003: if l_acct_type ='N' then
5004: l_auto_status := 'AUTO_POP_NA_ERROR';
5005: else
5006: l_auto_status :='AUTO_POP_EXP_ERROR';

Line 5008: elsif l_auto_pop_status = FND_API.G_RET_STS_ERROR THEN

5004: l_auto_status := 'AUTO_POP_NA_ERROR';
5005: else
5006: l_auto_status :='AUTO_POP_EXP_ERROR';
5007: end if;
5008: elsif l_auto_pop_status = FND_API.G_RET_STS_ERROR THEN
5009: l_auto_status := 'AUTO_POP_NO_VALUE';
5010: end if;
5011: open get_asg_details;
5012: fetch get_asg_details into l_person_name, l_assignment_number, l_element_type, l_auto_org_name;

Line 5193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5189: g_batch_name,
5190: p_business_group_id,
5191: p_set_of_books_id,
5192: l_return_status);
5193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5194: end if;
5195: END IF;
5196:
5197: IF l_suspense_ac_not_found = 'Y' THEN

Line 5249: --- RAISE FND_API.G_EXC_UNEXPECTED_ERROR; commented for 2479579

5245: g_batch_name,
5246: p_business_group_id,
5247: p_set_of_books_id,
5248: l_return_status);
5249: --- RAISE FND_API.G_EXC_UNEXPECTED_ERROR; commented for 2479579
5250: -- introduced following if stmnt for 2479579
5251: if l_susp_exception = 'NO_G_AC' then
5252: RAISE no_global_acct_exists;
5253: elsif l_susp_exception = 'NO_DT_MCH' then

Line 5463: p_return_status := fnd_api.g_ret_sts_success;

5459: delete gms_transaction_interface_all
5460: where transaction_source = p_txn_source
5461: and batch_name = p_gms_batch_name;
5462: End of bug fix 2643228 *****/
5463: p_return_status := fnd_api.g_ret_sts_success;
5464: EXCEPTION
5465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5466: --dbms_output.put_line('Gone to one level top ..................');
5467: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;

Line 5465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5461: and batch_name = p_gms_batch_name;
5462: End of bug fix 2643228 *****/
5463: p_return_status := fnd_api.g_ret_sts_success;
5464: EXCEPTION
5465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5466: --dbms_output.put_line('Gone to one level top ..................');
5467: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
5468: p_return_status := fnd_api.g_ret_sts_unexp_error;
5469: /* Added Exceptions for bug 2056877 */

Line 5468: p_return_status := fnd_api.g_ret_sts_unexp_error;

5464: EXCEPTION
5465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5466: --dbms_output.put_line('Gone to one level top ..................');
5467: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
5468: p_return_status := fnd_api.g_ret_sts_unexp_error;
5469: /* Added Exceptions for bug 2056877 */
5470: WHEN NO_PROFILE_EXISTS THEN
5471: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5472: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');

Line 5474: p_return_status := fnd_api.g_ret_sts_unexp_error;

5470: WHEN NO_PROFILE_EXISTS THEN
5471: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5472: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
5473: fnd_msg_pub.add;
5474: p_return_status := fnd_api.g_ret_sts_unexp_error;
5475:
5476: WHEN NO_VAL_DATE_MATCHES THEN
5477: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5478: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

Line 5482: p_return_status := fnd_api.g_ret_sts_unexp_error;

5478: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5479: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5480: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5481: fnd_msg_pub.add;
5482: p_return_status := fnd_api.g_ret_sts_unexp_error;
5483:
5484: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5485: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5486: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

Line 5490: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.

5486: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5487: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5488: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5489: fnd_msg_pub.add;
5490: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
5491:
5492: WHEN OTHERS THEN
5493: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5494: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;

Line 5496: p_return_status := fnd_api.g_ret_sts_unexp_error;

5492: WHEN OTHERS THEN
5493: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5494: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
5495: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GMS_TIE_BACK');
5496: p_return_status := fnd_api.g_ret_sts_unexp_error;
5497: END;
5498:
5499: ------------------ INSERT INTO GMS INTERFACE -----------------------------------------------
5500:

Line 5618: p_return_status := fnd_api.g_ret_sts_success;

5614: DECODE(p_acct_rate_type, NULL, NULL, P_ACCT_RATE_DATE),
5615: -- Bug 8984069
5616: l_unmatched_nve_txn_flag);
5617:
5618: p_return_status := fnd_api.g_ret_sts_success;
5619: EXCEPTION
5620:
5621: WHEN OTHERS THEN
5622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 5626: p_return_status := fnd_api.g_ret_sts_unexp_error;

5622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5623: -- dbms_output.put_line('Error while inserting .........................');
5624: g_error_api_path := 'INSERT_INTO_PA_INTERFACE:'||g_error_api_path;
5625: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_PA_INTERFACE');
5626: p_return_status := fnd_api.g_ret_sts_unexp_error;
5627: END;
5628:
5629: /* Created this procedure on 4-Nov-2004.
5630: Following procedure is introduced for Effort reports Enhancement.

Line 6518: p_return_status := fnd_api.g_ret_sts_success;

6514: --- comment trace.. debug
6515: ---hr_utility.trace_on('Y','ZX');
6516: hr_utility.trace( 'SandT_Supercede--> Begin p_run_id='||p_run_id);
6517: fnd_signon.set_session(to_char(sysdate,'dd-mon-yyyy'));
6518: p_return_status := fnd_api.g_ret_sts_success;
6519: l_S_and_T_reqid := fnd_global.conc_request_id;
6520: fnd_stats.gather_table_stats(ownname => 'PSP',
6521: tabname => 'PSP_SUPERCEDE_PERSONS_GT');
6522: open check_er_template_h;

Line 6699: raise fnd_api.g_exc_unexpected_error;

6695: p_exp_type_segment => l_exp_type_segment);
6696: IF (l_proj_segment is null) OR (l_tsk_segment is null) OR (l_awd_sgement is null) OR
6697: (l_exp_org_segment is null) OR (l_exp_type_segment is null) THEN
6698: fnd_message.set_name('PSP', 'PSP_GL_PTAOE_NOT_MAPPED');
6699: raise fnd_api.g_exc_unexpected_error;
6700: END IF;
6701: l_sql_string := replace(l_sql_string,'psl','erd');
6702: l_sql_string := replace(l_sql_string,'gcc','erd');
6703: l_sql_string := replace(l_sql_string,l_proj_segment,'PROJECT_ID');

Line 6752: raise fnd_api.g_exc_unexpected_error;

6748: p_exp_type_segment => l_exp_type_segment);
6749: IF (l_proj_segment is null) OR (l_tsk_segment is null) OR (l_awd_sgement is null) OR
6750: (l_exp_org_segment is null) OR (l_exp_type_segment is null) THEN
6751: fnd_message.set_name('PSP', 'PSP_GL_PTAOE_NOT_MAPPED');
6752: raise fnd_api.g_exc_unexpected_error;
6753: END IF;
6754: l_sql_string := replace(l_sql_string,'psl','erd');
6755: l_sql_string := replace(l_sql_string,'gcc','erd');
6756: l_sql_string := replace(l_sql_string,l_proj_segment,'PROJECT_ID');

Line 6882: p_return_status := fnd_api.g_ret_sts_unexp_error;

6878: when others then
6879: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6880: hr_utility.trace( 'SandT_Supercede--> when others in supercede_er'||sqlerrm) ;
6881: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS', 'SUPERCEDE_ER');
6882: p_return_status := fnd_api.g_ret_sts_unexp_error;
6883: END supercede_er;
6884:
6885: END PSP_SUM_TRANS;