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 73: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

69: p_business_group_id,
70: p_set_of_books_id,
71: l_return_status);
72:
73: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76:
77:

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

70: p_set_of_books_id,
71: l_return_status);
72:
73: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76:
77:
78: -- FIRST NORMAL RUN

Line 87: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

83: p_batch_name,
84: p_business_group_id,
85: p_set_of_books_id,
86: l_return_status);
87: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91: -- call the user extension to populate attribute1 through attribute30

Line 88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

84: p_business_group_id,
85: p_set_of_books_id,
86: l_return_status);
87: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91: -- call the user extension to populate attribute1 through attribute30
92: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

Line 111: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

107: p_business_group_id,
108: p_set_of_books_id,
109: l_return_status);
110:
111: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: END IF;
114:
115: create_gms_sum_lines(p_source_type,

Line 112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

108: p_set_of_books_id,
109: l_return_status);
110:
111: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: END IF;
114:
115: create_gms_sum_lines(p_source_type,
116: p_source_code,

Line 122: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

118: p_batch_name,
119: p_business_group_id,
120: p_set_of_books_id,
121: l_return_status);
122: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END IF;
125:
126: -- Call the user extension to populate attribute1 thru attribute 30.

Line 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

119: p_business_group_id,
120: p_set_of_books_id,
121: l_return_status);
122: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END IF;
125:
126: -- Call the user extension to populate attribute1 thru attribute 30.
127: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

Line 146: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

142: p_business_group_id,
143: p_set_of_books_id,
144: l_return_status);
145:
146: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149:
150: -- SECOND RUN TO TAKE CARE OF TIE-BACK

Line 147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

143: p_set_of_books_id,
144: l_return_status);
145:
146: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149:
150: -- SECOND RUN TO TAKE CARE OF TIE-BACK
151: -- initiate the gl summarization

Line 160: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 184: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

180: p_business_group_id,
181: p_set_of_books_id,
182: l_return_status);
183:
184: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: END IF;
187:
188:

Line 185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

181: p_set_of_books_id,
182: l_return_status);
183:
184: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: END IF;
187:
188:
189:

Line 198: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

194: p_business_group_id,
195: p_set_of_books_id,
196: l_return_status);
197:
198: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:
202: -- call the user extension to populate attribute1 through attribute30

Line 199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

195: p_set_of_books_id,
196: l_return_status);
197:
198: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:
202: -- call the user extension to populate attribute1 through attribute30
203: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

Line 223: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

219: p_business_group_id,
220: p_set_of_books_id,
221: l_return_status);
222:
223: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: mark_batch_end(p_source_type,

Line 224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

220: p_set_of_books_id,
221: l_return_status);
222:
223: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: mark_batch_end(p_source_type,
228: p_source_code,

Line 235: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

231: p_business_group_id,
232: p_set_of_books_id,
233: l_return_status);
234:
235: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: PSP_MESSAGE_S.Print_success;

Line 236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

232: p_set_of_books_id,
233: l_return_status);
234:
235: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: PSP_MESSAGE_S.Print_success;
240:

Line 242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

238:
239: PSP_MESSAGE_S.Print_success;
240:
241: EXCEPTION
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243:
244: /* Introduced as part of bug fix #1776606 */
245: ROLLBACK;
246: /* Commented as part of Bug fix #1776606

Line 255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

251: p_business_group_id,
252: p_set_of_books_id,
253: l_return_status);
254:
255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:
259: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252: p_set_of_books_id,
253: l_return_status);
254:
255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:
259: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
260: p_encoded => FND_API.G_FALSE,

Line 260: p_encoded => FND_API.G_FALSE,

256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:
259: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
260: p_encoded => FND_API.G_FALSE,
261: p_data => l_msg_data,
262: p_msg_index_out => l_msg_count); */
263:
264: g_error_api_path := 'SUM_AND_TRANSFER:'||g_error_api_path;

Line 267: p_print_header => FND_API.G_TRUE);

263:
264: g_error_api_path := 'SUM_AND_TRANSFER:'||g_error_api_path;
265: errbuf := SUBSTR(l_msg_data || fnd_global.local_chr(10) ||fnd_global.local_chr(10)||g_error_api_path,1,230);
266: psp_message_s.print_error(p_mode => FND_FILE.LOG,
267: p_print_header => FND_API.G_TRUE);
268: retcode := 2;
269: WHEN OTHERS THEN
270:
271: /* Introduced as part of Bug fix #1776606 */

Line 283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

279: p_business_group_id,
280: p_set_of_books_id,
281: l_return_status);
282:
283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');

Line 284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

280: p_set_of_books_id,
281: l_return_status);
282:
283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');
288: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,

Line 289: p_encoded => FND_API.G_FALSE,

285: END IF;
286:
287: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');
288: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
289: p_encoded => FND_API.G_FALSE,
290: p_data => l_msg_data,
291: p_msg_index_out => l_msg_count); */
292:
293: g_error_api_path := 'SUM_AND_TRANSFER:'||g_error_api_path;

Line 296: p_print_header => FND_API.G_TRUE);

292:
293: g_error_api_path := 'SUM_AND_TRANSFER:'||g_error_api_path;
294: errbuf := SUBSTR(l_msg_data || fnd_global.local_chr(10) ||fnd_global.local_chr(10)||g_error_api_path,1,230);
295: psp_message_s.print_error(p_mode => FND_FILE.LOG,
296: p_print_header => FND_API.G_TRUE);
297: retcode := 2;
298: END;
299:
300: -------------------- MARK BATCH BEGIN --------------------------------------------

Line 386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

382: fnd_message.set_name('PSP','PSP_TI_DID_NOT_COMPLETE');
383: fnd_message.set_token('PAYROLL_CONTROL_ID', payroll_control_rec.payroll_control_id);
384: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);
385: fnd_msg_pub.add;
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: end if;
388:
389: end if;
390:

Line 398: p_return_status := fnd_api.g_ret_sts_unexp_error;

394: EXCEPTION
395: WHEN OTHERS THEN
396: g_error_api_path := 'MARK_BATCH_BEGIN: ' || g_error_api_path;
397: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_BEGIN');
398: p_return_status := fnd_api.g_ret_sts_unexp_error;
399: RAISE;
400: END;
401: -------------------- MARK BATCH END ---------------------------------------------
402:

Line 458: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

454: p_source_code ,
455: p_time_period_id,
456: p_batch_name,
457: l_return_status);
458: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461:
462:

Line 459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

455: p_time_period_id,
456: p_batch_name,
457: l_return_status);
458: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461:
462:
463: End IF;

Line 569: p_return_status := fnd_api.g_ret_sts_unexp_error;

565: EXCEPTION
566: WHEN OTHERS THEN
567: g_error_api_path := 'MARK_BATCH_END: ' || g_error_api_path;
568: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_END');
569: p_return_status := fnd_api.g_ret_sts_unexp_error;
570: RAISE;
571: END;
572: -------------------- CREATE GL SUM LINES -----------------------------------------------
573:

Line 802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

798: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
799: fnd_message.set_token('VALUE',l_value);
800: fnd_message.set_token('TABLE',l_table);
801: fnd_msg_pub.add;
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: END;
804:
805:
806: -- Made the following call for Bug 2916848 to populate l_precision , l_ext_precision

Line 817: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

813: p_set_of_books_id,
814: l_precision,-- Introduced for Bug 2916848
815: l_return_status);
816:
817: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;
820:
821: OPEN gl_sum_lines_cursor(payroll_control_rec.payroll_control_id);

Line 818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

814: l_precision,-- Introduced for Bug 2916848
815: l_return_status);
816:
817: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;
820:
821: OPEN gl_sum_lines_cursor(payroll_control_rec.payroll_control_id);
822: l_rec_count := 0;

Line 918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

914: l_attribute9,
915: l_attribute10,
916: l_return_status);
917:
918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
920: END IF;
921:
922:

Line 919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

915: l_attribute10,
916: l_return_status);
917:
918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
920: END IF;
921:
922:
923: FOR j IN 1 .. dist_line_id.COUNT LOOP

Line 1007: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1003: l_attribute10,
1004: l_return_status);
1005:
1006:
1007: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1009: END IF;
1010:
1011:

Line 1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1004: l_return_status);
1005:
1006:
1007: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1009: END IF;
1010:
1011:
1012:

Line 1034: p_return_status := fnd_api.g_ret_sts_success;

1030: END IF;
1031:
1032: END LOOP;
1033: --
1034: p_return_status := fnd_api.g_ret_sts_success;
1035:
1036: EXCEPTION
1037:
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1034: p_return_status := fnd_api.g_ret_sts_success;
1035:
1036: EXCEPTION
1037:
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1040: p_return_status := fnd_api.g_ret_sts_unexp_error;
1041: WHEN OTHERS THEN
1042: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;

Line 1040: p_return_status := fnd_api.g_ret_sts_unexp_error;

1036: EXCEPTION
1037:
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1040: p_return_status := fnd_api.g_ret_sts_unexp_error;
1041: WHEN OTHERS THEN
1042: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1043: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');
1044: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1044: p_return_status := fnd_api.g_ret_sts_unexp_error;

1040: p_return_status := fnd_api.g_ret_sts_unexp_error;
1041: WHEN OTHERS THEN
1042: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1043: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');
1044: p_return_status := fnd_api.g_ret_sts_unexp_error;
1045:
1046: END;
1047:
1048:

Line 1187: p_return_status := fnd_api.g_ret_sts_success;

1183: p_attribute10,
1184: p_org_id -- R12 MOAC uptake
1185: );
1186: --
1187: p_return_status := fnd_api.g_ret_sts_success;
1188: EXCEPTION
1189: WHEN OTHERS THEN
1190: --dbms_output.put_line('Errrrrrrrrrrrrrrrrrrrrrrrrrrorrrrrrrrrrr.........');
1191: g_error_api_path := 'INSERT_INTO_SUMMARY_LINES:'||g_error_api_path;

Line 1193: p_return_status := fnd_api.g_ret_sts_unexp_error;

1189: WHEN OTHERS THEN
1190: --dbms_output.put_line('Errrrrrrrrrrrrrrrrrrrrrrrrrrorrrrrrrrrrr.........');
1191: g_error_api_path := 'INSERT_INTO_SUMMARY_LINES:'||g_error_api_path;
1192: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_SUMMARY_LINES');
1193: p_return_status := fnd_api.g_ret_sts_unexp_error;
1194: END;
1195:
1196: ------------------------ GL INTERFACE --------------------------------------------------
1197:

Line 1325: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1321:
1322: -- get the source name
1323: get_gl_je_sources(l_user_je_source_name,
1324: l_return_status);
1325: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: END IF;
1328:
1329: -- get the category name

Line 1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1322: -- get the source name
1323: get_gl_je_sources(l_user_je_source_name,
1324: l_return_status);
1325: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327: END IF;
1328:
1329: -- get the category name
1330: get_gl_je_categories(l_user_je_category_name,

Line 1332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1328:
1329: -- get the category name
1330: get_gl_je_categories(l_user_je_category_name,
1331: l_return_status);
1332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335:
1336: /* Changed the following code for Bug 3112053 , so as to submit one journal import for a batch having same

Line 1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1329: -- get the category name
1330: get_gl_je_categories(l_user_je_category_name,
1331: l_return_status);
1332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335:
1336: /* Changed the following code for Bug 3112053 , so as to submit one journal import for a batch having same
1337: source_code,source_type,time_period_id,batch_name combination */

Line 1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1365: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1366: fnd_message.set_token('VALUE',l_value);
1367: fnd_message.set_token('TABLE',l_table);
1368: fnd_msg_pub.add;
1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1370: END;
1371:
1372: If gl_batch_rec.phase = 'Summarize_GL_Lines' then --- added for 2444657
1373: l_reference1 := gl_batch_rec.source_type||':'||gl_batch_rec.payroll_source_code||':'||l_period_name||':'||gl_batch_rec.batch_name;

Line 1442: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1438: GL_INTERFACE_REC.ACCOUNTING_DATE,
1439: -- Introduced for Bug 2916848
1440: L_RETURN_STATUS);
1441:
1442: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1443: --dbms_output.put_line('Faaaaaaiiiiiiilllllllleeeeeeeeeddddddd......');
1444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1445: END IF;
1446:

Line 1444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1440: L_RETURN_STATUS);
1441:
1442: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1443: --dbms_output.put_line('Faaaaaaiiiiiiilllllllleeeeeeeeeddddddd......');
1444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1445: END IF;
1446:
1447: END LOOP; -- End of gl_interface_cursor
1448:

Line 1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1519: IF req_id = 0 THEN
1520:
1521: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
1522: fnd_msg_pub.add;
1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1524:
1525: ELSE
1526:
1527: -- Added the update for Rollback purposes.

Line 1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1545: IF call_status = FALSE THEN
1546:
1547: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
1548: fnd_msg_pub.add;
1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1550:
1551: END IF;
1552:
1553: END IF; -- End for check req_id = 0

Line 1584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1580:
1581: /* Bug 1617846 LD Recovery LOV not showing up fialed S and T */
1582: /* introduced ELSE clause */
1583:
1584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1585: CLOSE gl_payroll_control_cursor;
1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1587: END IF;
1588:

Line 1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1582: /* introduced ELSE clause */
1583:
1584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1585: CLOSE gl_payroll_control_cursor;
1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1587: END IF;
1588:
1589: END LOOP;
1590: CLOSE gl_payroll_control_cursor;

Line 1598: p_return_status := fnd_api.g_ret_sts_success;

1594: END LOOP; -- End of gl_batch_csr
1595:
1596: /* End of code changes for Bug 3112053 */
1597:
1598: p_return_status := fnd_api.g_ret_sts_success;
1599:
1600: EXCEPTION
1601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1602: --dbms_output.put_line('Gone to one level top ..................');

Line 1601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1597:
1598: p_return_status := fnd_api.g_ret_sts_success;
1599:
1600: EXCEPTION
1601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1602: --dbms_output.put_line('Gone to one level top ..................');
1603: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1604: p_return_status := fnd_api.g_ret_sts_unexp_error;
1605:

Line 1604: p_return_status := fnd_api.g_ret_sts_unexp_error;

1600: EXCEPTION
1601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1602: --dbms_output.put_line('Gone to one level top ..................');
1603: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1604: p_return_status := fnd_api.g_ret_sts_unexp_error;
1605:
1606: WHEN RETURN_BACK THEN
1607: p_return_status := fnd_api.g_ret_sts_success;
1608:

Line 1607: p_return_status := fnd_api.g_ret_sts_success;

1603: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1604: p_return_status := fnd_api.g_ret_sts_unexp_error;
1605:
1606: WHEN RETURN_BACK THEN
1607: p_return_status := fnd_api.g_ret_sts_success;
1608:
1609: WHEN OTHERS THEN
1610: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1611: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');

Line 1612: p_return_status := fnd_api.g_ret_sts_unexp_error;

1608:
1609: WHEN OTHERS THEN
1610: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1611: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1612: p_return_status := fnd_api.g_ret_sts_unexp_error;
1613: END;
1614:
1615: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------
1616: PROCEDURE get_gl_je_sources(P_USER_JE_SOURCE_NAME OUT NOCOPY VARCHAR2,

Line 1633: p_return_status := fnd_api.g_ret_sts_unexp_error;

1629: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1630: fnd_message.set_token('ERROR',l_error);
1631: fnd_message.set_token('PRODUCT',l_product);
1632: fnd_msg_pub.add;
1633: p_return_status := fnd_api.g_ret_sts_unexp_error;
1634: WHEN OTHERS THEN
1635: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1636: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1637: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1637: p_return_status := fnd_api.g_ret_sts_unexp_error;

1633: p_return_status := fnd_api.g_ret_sts_unexp_error;
1634: WHEN OTHERS THEN
1635: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1636: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1637: p_return_status := fnd_api.g_ret_sts_unexp_error;
1638: END;
1639:
1640: ---------------------- GET_GL_CATEGORIES --------------------------------------------------
1641: PROCEDURE get_gl_je_categories(P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,

Line 1658: p_return_status := fnd_api.g_ret_sts_unexp_error;

1654: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1655: fnd_message.set_token('ERROR',l_error);
1656: fnd_message.set_token('PRODUCT',l_product);
1657: fnd_msg_pub.add;
1658: p_return_status := fnd_api.g_ret_sts_unexp_error;
1659: WHEN OTHERS THEN
1660: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;
1661: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');
1662: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1662: p_return_status := fnd_api.g_ret_sts_unexp_error;

1658: p_return_status := fnd_api.g_ret_sts_unexp_error;
1659: WHEN OTHERS THEN
1660: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;
1661: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');
1662: p_return_status := fnd_api.g_ret_sts_unexp_error;
1663: END;
1664:
1665: ---------------------- GET_ENCUM_TYPE_ID -----------------------------------------------
1666: PROCEDURE get_encum_type_id(P_ENCUMBRANCE_TYPE_ID OUT NOCOPY VARCHAR2,

Line 1685: p_return_status := fnd_api.g_ret_sts_unexp_error;

1681: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1682: fnd_message.set_token('ERROR',l_error);
1683: fnd_message.set_token('PRODUCT',l_product);
1684: fnd_msg_pub.add;
1685: p_return_status := fnd_api.g_ret_sts_unexp_error;
1686: WHEN OTHERS THEN
1687: g_error_api_path := 'ENCUMBRANCE_TYPE_ID:'||g_error_api_path;
1688: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','ENCUMBRANCE_TYPE_ID');
1689: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1689: p_return_status := fnd_api.g_ret_sts_unexp_error;

1685: p_return_status := fnd_api.g_ret_sts_unexp_error;
1686: WHEN OTHERS THEN
1687: g_error_api_path := 'ENCUMBRANCE_TYPE_ID:'||g_error_api_path;
1688: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','ENCUMBRANCE_TYPE_ID');
1689: p_return_status := fnd_api.g_ret_sts_unexp_error;
1690: END;
1691:
1692:
1693: -------------------- GL TIE BACK -----------------------------------------------------

Line 1943: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1939:
1940: -- get the source name
1941: get_gl_je_sources(l_user_je_source_name,
1942: l_return_status);
1943: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: END IF;
1946:
1947: delete gl_interface_Control

Line 1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1940: -- get the source name
1941: get_gl_je_sources(l_user_je_source_name,
1942: l_return_status);
1943: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: END IF;
1946:
1947: delete gl_interface_Control
1948: where group_id = p_group_id

Line 1964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1960: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
1961: fnd_message.set_token('GROUP_ID',p_group_id);
1962: fnd_msg_pub.add;
1963: -- uncommented following statement for 2444657
1964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1965:
1966: end if;
1967:
1968: SELECT count(*)

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

2136: p_business_group_id => p_business_group_id,
2137: ret_expenditure_type => l_new_expenditure_type,
2138: ret_gl_code_combination_id => l_new_glccid,
2139: retcode => l_auto_pop_status);
2140: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2141: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
2142: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2143: if l_acct_type ='N' then
2144: l_auto_status := 'AUTO_POP_NA_ERROR';

Line 2141: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN

2137: ret_expenditure_type => l_new_expenditure_type,
2138: ret_gl_code_combination_id => l_new_glccid,
2139: retcode => l_auto_pop_status);
2140: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2141: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
2142: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2143: if l_acct_type ='N' then
2144: l_auto_status := 'AUTO_POP_NA_ERROR';
2145: else

Line 2142: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2138: ret_gl_code_combination_id => l_new_glccid,
2139: retcode => l_auto_pop_status);
2140: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
2141: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
2142: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2143: if l_acct_type ='N' then
2144: l_auto_status := 'AUTO_POP_NA_ERROR';
2145: else
2146: l_auto_status :='AUTO_POP_EXP_ERROR';

Line 2148: elsif l_auto_pop_status = FND_API.G_RET_STS_ERROR THEN

2144: l_auto_status := 'AUTO_POP_NA_ERROR';
2145: else
2146: l_auto_status :='AUTO_POP_EXP_ERROR';
2147: end if;
2148: elsif l_auto_pop_status = FND_API.G_RET_STS_ERROR THEN
2149: l_auto_status := 'AUTO_POP_NO_VALUE';
2150: end if;
2151: open get_asg_details;
2152: fetch get_asg_details into l_person_name, l_assignment_number, l_element_type, l_auto_org_name;

Line 2249: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2245: END LOOP;
2246: ---2445196: cleanup gl interface b'cos rejection is available in rejected summary lines
2247: get_gl_je_sources(l_user_je_source_name,
2248: l_return_status);
2249: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2251: END IF;
2252:
2253: delete gl_interface

Line 2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2246: ---2445196: cleanup gl interface b'cos rejection is available in rejected summary lines
2247: get_gl_je_sources(l_user_je_source_name,
2248: l_return_status);
2249: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2251: END IF;
2252:
2253: delete gl_interface
2254: where group_id = p_group_id

Line 2307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2303: g_batch_name,
2304: p_business_group_id,
2305: p_set_of_books_id,
2306: l_return_status);
2307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2308: end if;
2309: END IF;
2310:
2311: IF l_suspense_ac_failed = 'Y' or

Line 2363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2359: g_batch_name,
2360: p_business_group_id,
2361: p_set_of_books_id,
2362: l_return_status);
2363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2364: end if;
2365: END IF;
2366:
2367: IF l_suspense_ac_not_found = 'Y' THEN

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

2380: g_batch_name,
2381: p_business_group_id,
2382: p_set_of_books_id,
2383: l_return_status);
2384: --- RAISE FND_API.G_EXC_UNEXPECTED_ERROR; commented for 2479579
2385: -- introduced following if stmnt for 2479579
2386: if l_susp_exception = 'NO_G_AC' then
2387: RAISE no_global_acct_exists;
2388: elsif l_susp_exception = 'NO_DT_MCH' then

Line 2513: p_return_status := fnd_api.g_ret_sts_success;

2509: WHERE payroll_control_id = p_payroll_control_id;
2510:
2511: END IF;
2512: --
2513: p_return_status := fnd_api.g_ret_sts_success;
2514: EXCEPTION
2515:
2516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2517: --dbms_output.put_line('Gone to one level top ..................');

Line 2516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2512: --
2513: p_return_status := fnd_api.g_ret_sts_success;
2514: EXCEPTION
2515:
2516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2517: --dbms_output.put_line('Gone to one level top ..................');
2518: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
2519: p_return_status := fnd_api.g_ret_sts_unexp_error;
2520:

Line 2519: p_return_status := fnd_api.g_ret_sts_unexp_error;

2515:
2516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2517: --dbms_output.put_line('Gone to one level top ..................');
2518: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
2519: p_return_status := fnd_api.g_ret_sts_unexp_error;
2520:
2521: /* Added Exceptions for bug 2056877 */
2522: WHEN NO_PROFILE_EXISTS THEN
2523: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);

Line 2526: p_return_status := fnd_api.g_ret_sts_unexp_error;

2522: WHEN NO_PROFILE_EXISTS THEN
2523: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2524: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
2525: fnd_msg_pub.add;
2526: p_return_status := fnd_api.g_ret_sts_unexp_error;
2527:
2528: WHEN NO_VAL_DATE_MATCHES THEN
2529: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2530: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

Line 2534: p_return_status := fnd_api.g_ret_sts_unexp_error;

2530: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2531: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2532: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2533: fnd_msg_pub.add;
2534: p_return_status := fnd_api.g_ret_sts_unexp_error;
2535:
2536: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2537: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2538: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

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

2538: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2539: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2540: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2541: fnd_msg_pub.add;
2542: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.
2543:
2544: WHEN OTHERS THEN
2545: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
2546: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');

Line 2547: p_return_status := fnd_api.g_ret_sts_unexp_error;

2543:
2544: WHEN OTHERS THEN
2545: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
2546: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
2547: p_return_status := fnd_api.g_ret_sts_unexp_error;
2548: END;
2549:
2550:
2551: ------------------ CREATE BALANCING TRANSACTIONS FOR GL ------------------------------

Line 2673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2669:
2670: IF l_cr_amount <> l_dr_amount then
2671: fnd_message.set_name('PSP','PSP_GL_REV_AMT_NOT_EQUAL');
2672: fnd_msg_pub.add;
2673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2674: END IF;
2675:
2676: ELSIF p_source_type = 'P' THEN
2677: SELECT payroll_id INTO l_payroll_id

Line 2692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2688: EXCEPTION
2689: WHEN NO_DATA_FOUND THEN
2690: fnd_message.set_name('PSP','PSP_TR_CLRG_AC_NOT_SET_UP');
2691: fnd_msg_pub.add;
2692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2693: END;
2694:
2695: delete from psp_pre_gen_dist_lines
2696: where reversal_entry_flag = 'Y'

Line 2750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2746:
2747: IF l_cr_amount <> l_dr_amount then
2748: fnd_message.set_name('PSP','PSP_GL_UNBALANCED_BATCH');
2749: fnd_msg_pub.add;
2750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2751: END IF;
2752:
2753: END IF;
2754: --

Line 2755: p_return_status := fnd_api.g_ret_sts_success;

2751: END IF;
2752:
2753: END IF;
2754: --
2755: p_return_status := fnd_api.g_ret_sts_success;
2756: EXCEPTION
2757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2758: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2759: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2753: END IF;
2754: --
2755: p_return_status := fnd_api.g_ret_sts_success;
2756: EXCEPTION
2757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2758: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2759: p_return_status := fnd_api.g_ret_sts_unexp_error;
2760:
2761: WHEN OTHERS THEN

Line 2759: p_return_status := fnd_api.g_ret_sts_unexp_error;

2755: p_return_status := fnd_api.g_ret_sts_success;
2756: EXCEPTION
2757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2758: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2759: p_return_status := fnd_api.g_ret_sts_unexp_error;
2760:
2761: WHEN OTHERS THEN
2762: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2763: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');

Line 2764: p_return_status := fnd_api.g_ret_sts_unexp_error;

2760:
2761: WHEN OTHERS THEN
2762: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2763: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');
2764: p_return_status := fnd_api.g_ret_sts_unexp_error;
2765: END;
2766:
2767: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------
2768:

Line 2932: p_return_status := fnd_api.g_ret_sts_success;

2928: P_ATTRIBUTE30,
2929: P_CURRENCY_CONVERSION_TYPE,-- Introduced the following code for Bug fix 2916848
2930: DECODE(p_currency_conversion_type, NULL, NULL, P_CURRENCY_CONVERSION_DATE));-- Introduced the following code for Bug fix 2916848
2931: --dbms_output.put_line('DDDDDDDDDDDDDDDDDGL Interface Inserted ....................');
2932: p_return_status := fnd_api.g_ret_sts_success;
2933: EXCEPTION
2934: WHEN OTHERS THEN
2935: --dbms_output.put_line('Error while inserting .........................');
2936: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;

Line 2938: p_return_status := fnd_api.g_ret_sts_unexp_error;

2934: WHEN OTHERS THEN
2935: --dbms_output.put_line('Error while inserting .........................');
2936: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
2937: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');
2938: p_return_status := fnd_api.g_ret_sts_unexp_error;
2939: END;
2940:
2941: -------------------- CREATE GMS SUM LINES -----------------------------------------------
2942: PROCEDURE create_gms_sum_lines(p_source_type IN VARCHAR2,

Line 3200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3196: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3197: fnd_message.set_token('VALUE',l_value);
3198: fnd_message.set_token('TABLE',l_table);
3199: fnd_msg_pub.add;
3200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3201: END;
3202:
3203:
3204: OPEN gms_sum_lines_cursor(payroll_control_rec.payroll_control_id);

Line 3323: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3319: l_return_status,
3320: l_org_id -- R12 MOAC Uptake
3321: );
3322:
3323: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3325: END IF;
3326:
3327: FOR j IN 1 .. dist_line_id.COUNT LOOP

Line 3324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3320: l_org_id -- R12 MOAC Uptake
3321: );
3322:
3323: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3325: END IF;
3326:
3327: FOR j IN 1 .. dist_line_id.COUNT LOOP
3328: l_dist_line_id := dist_line_id(j);

Line 3424: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3420: l_return_status,
3421: l_org_id -- R12 MOAC uptake
3422: );
3423:
3424: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3426: END IF;
3427:
3428: FOR j IN 1 .. dist_line_id.COUNT LOOP

Line 3425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3421: l_org_id -- R12 MOAC uptake
3422: );
3423:
3424: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3426: END IF;
3427:
3428: FOR j IN 1 .. dist_line_id.COUNT LOOP
3429: l_dist_line_id := dist_line_id(j);

Line 3448: p_return_status := fnd_api.g_ret_sts_success;

3444: dist_line_id.delete;
3445: END IF;
3446: END LOOP;
3447: --
3448: p_return_status := fnd_api.g_ret_sts_success;
3449:
3450:
3451: EXCEPTION
3452:

Line 3453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3449:
3450:
3451: EXCEPTION
3452:
3453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3454: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3455: p_return_status := fnd_api.g_ret_sts_unexp_error;
3456: WHEN OTHERS THEN
3457: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;

Line 3455: p_return_status := fnd_api.g_ret_sts_unexp_error;

3451: EXCEPTION
3452:
3453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3454: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3455: p_return_status := fnd_api.g_ret_sts_unexp_error;
3456: WHEN OTHERS THEN
3457: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3458: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');
3459: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3459: p_return_status := fnd_api.g_ret_sts_unexp_error;

3455: p_return_status := fnd_api.g_ret_sts_unexp_error;
3456: WHEN OTHERS THEN
3457: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3458: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');
3459: p_return_status := fnd_api.g_ret_sts_unexp_error;
3460:
3461: END;
3462:
3463: ----------------------------- GMS INTERFACE ---------------------------------------------

Line 3594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3590: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3591: fnd_message.set_token('ERROR',l_error);
3592: fnd_message.set_token('PRODUCT',l_product);
3593: fnd_msg_pub.add;
3594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3595: END;
3596:
3597: if (l_gms_install) then -- Changed site_enabled check to l_gms_install check for bug fix 2908859
3598: BEGIN

Line 3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3607: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3608: fnd_message.set_token('ERROR',l_error);
3609: fnd_message.set_token('PRODUCT',l_product);
3610: fnd_msg_pub.add;
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END;
3613: end if;
3614:
3615: OPEN gms_batch_cursor;

Line 3639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3635: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3636: fnd_message.set_token('VALUE',l_value);
3637: fnd_message.set_token('TABLE',l_table);
3638: fnd_msg_pub.add;
3639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3640: END;
3641:
3642: -- R12 MOAC Uptake .. org_id array to always populate 5090047
3643: -- moved If condin below

Line 3709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3705: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3706: fnd_message.set_token('VALUE',l_value);
3707: fnd_message.set_token('TABLE',l_table);
3708: fnd_msg_pub.add;
3709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3710: END;
3711:
3712: -- get the employee's organization name
3713: BEGIN

Line 3727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3723: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3724: fnd_message.set_token('VALUE',l_value);
3725: fnd_message.set_token('TABLE',l_table);
3726: fnd_msg_pub.add;
3727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3728: --l_org_name := NULL;
3729: --l_org_name := 'LDM_ORG_NAME_INVALID';
3730: END;
3731:

Line 3746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3742: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3743: fnd_message.set_token('VALUE',l_value);
3744: fnd_message.set_token('TABLE',l_table);
3745: fnd_msg_pub.add;
3746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3747: END;
3748:
3749: -- R12 MOAC Uptake. Org_id is stored in psp_summary_line Table
3750: /*

Line 3765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3761: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
3762: fnd_message.set_token('VALUE',l_value);
3763: fnd_message.set_token('TABLE',l_table);
3764: fnd_msg_pub.add;
3765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3766: END;
3767: */
3768:
3769: -- get the task number

Line 3783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3779: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3780: fnd_message.set_token('VALUE',l_value);
3781: fnd_message.set_token('TABLE',l_table);
3782: fnd_msg_pub.add;
3783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3784: END;
3785:
3786: -- Get the transaction_interface_id. We need this to populate the gms_interface table.
3787:

Line 3848: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3844: gms_interface_rec.accounting_date,-- Introduced for bug 2916848 Ilo Ehn Mrc
3845: p_business_group_id,--Introduced for bug 2935850
3846: L_RETURN_STATUS);
3847:
3848: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3849: --dbms_output.put_line('Faaaaaaiiiiiiilllllllleeeeeeeeeddddddd......');
3850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3851: END IF;
3852:

Line 3850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3846: L_RETURN_STATUS);
3847:
3848: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3849: --dbms_output.put_line('Faaaaaaiiiiiiilllllllleeeeeeeeeddddddd......');
3850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3851: END IF;
3852:
3853: ELSE
3854: insert_into_pa_interface(l_txn_interface_id,

Line 3871: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3867: gms_interface_rec.accounting_date,-- Introduced for bug 2916848 Ilo Ehn Mrc
3868: p_business_group_id,--Introduced for bug 2935850
3869: L_RETURN_STATUS);
3870:
3871: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3873: END IF;
3874:
3875: END IF;

Line 3872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3868: p_business_group_id,--Introduced for bug 2935850
3869: L_RETURN_STATUS);
3870:
3871: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3873: END IF;
3874:
3875: END IF;
3876:

Line 3900: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3896: GMS_REC.FUNDING_PATTERN_ID := NULL;
3897:
3898: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
3899:
3900: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3902: END IF;
3903:
3904: end if;

Line 3901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3897:
3898: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
3899:
3900: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3902: END IF;
3903:
3904: end if;
3905:

Line 3947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3943:
3944: IF req_id = 0 THEN
3945: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3946: fnd_msg_pub.add;
3947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3948: END IF;
3949: END LOOP;
3950: update psp_payroll_controls
3951: set phase = 'Submitted_TI_Request'

Line 3963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3959: rphase, rstatus, dphase, dstatus, message);
3960: IF call_status_tab(I) = FALSE then
3961: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3962: fnd_msg_pub.add;
3963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3964: END IF;
3965: END LOOP;
3966: gms_batch_rec.phase := 'Submitted_TI_Request'; ---2444657
3967: END IF; --- 2444657 end rec_count > 0

Line 4008: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4004:
4005: /* Bug 1617846 LD Recovery LOV not showing up fialed S and T */
4006: /* introduced ELSE clause */
4007:
4008: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4010: -- ELSE --Commented for R12 MOAc uptake;
4011: --- moved update psp_payroll_control phase = Tie back inside gms_tie_back
4012: --- for 2444657

Line 4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4005: /* Bug 1617846 LD Recovery LOV not showing up fialed S and T */
4006: /* introduced ELSE clause */
4007:
4008: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4010: -- ELSE --Commented for R12 MOAc uptake;
4011: --- moved update psp_payroll_control phase = Tie back inside gms_tie_back
4012: --- for 2444657
4013: -- commit; --Commented for R12 MOAc uptake

Line 4021: p_return_status := fnd_api.g_ret_sts_success;

4017: END IF;
4018: END LOOP;
4019:
4020: --
4021: p_return_status := fnd_api.g_ret_sts_success;
4022: EXCEPTION
4023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4024: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4025: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4019:
4020: --
4021: p_return_status := fnd_api.g_ret_sts_success;
4022: EXCEPTION
4023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4024: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4025: p_return_status := fnd_api.g_ret_sts_unexp_error;
4026:
4027: WHEN RETURN_BACK THEN

Line 4025: p_return_status := fnd_api.g_ret_sts_unexp_error;

4021: p_return_status := fnd_api.g_ret_sts_success;
4022: EXCEPTION
4023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4024: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4025: p_return_status := fnd_api.g_ret_sts_unexp_error;
4026:
4027: WHEN RETURN_BACK THEN
4028: p_return_status := fnd_api.g_ret_sts_success;
4029:

Line 4028: p_return_status := fnd_api.g_ret_sts_success;

4024: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4025: p_return_status := fnd_api.g_ret_sts_unexp_error;
4026:
4027: WHEN RETURN_BACK THEN
4028: p_return_status := fnd_api.g_ret_sts_success;
4029:
4030: WHEN OTHERS THEN
4031: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4032: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GMS_INTERFACE');

Line 4033: p_return_status := fnd_api.g_ret_sts_unexp_error;

4029:
4030: WHEN OTHERS THEN
4031: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4032: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GMS_INTERFACE');
4033: p_return_status := fnd_api.g_ret_sts_unexp_error;
4034: END;
4035:
4036:
4037: ------------------------- GMS TIE BACK ---------------------------------------------------

Line 4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4351: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_RUN');
4352: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
4353: fnd_message.set_token('GMS_BATCH_NAME',p_gms_batch_name);
4354: fnd_msg_pub.add;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4356: end if;
4357: end if;
4358: hr_utility.trace('entered gms_tie_back2');
4359:

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

4661: p_business_group_id => p_business_group_id,
4662: ret_expenditure_type => l_new_expenditure_type,
4663: ret_gl_code_combination_id => l_new_glccid,
4664: retcode => l_auto_pop_status);
4665: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
4666: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
4667: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4668: if l_acct_type ='N' then
4669: l_auto_status := 'AUTO_POP_NA_ERROR';

Line 4666: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN

4662: ret_expenditure_type => l_new_expenditure_type,
4663: ret_gl_code_combination_id => l_new_glccid,
4664: retcode => l_auto_pop_status);
4665: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
4666: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
4667: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4668: if l_acct_type ='N' then
4669: l_auto_status := 'AUTO_POP_NA_ERROR';
4670: else

Line 4667: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4663: ret_gl_code_combination_id => l_new_glccid,
4664: retcode => l_auto_pop_status);
4665: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
4666: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
4667: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4668: if l_acct_type ='N' then
4669: l_auto_status := 'AUTO_POP_NA_ERROR';
4670: else
4671: l_auto_status :='AUTO_POP_EXP_ERROR';

Line 4673: elsif l_auto_pop_status = FND_API.G_RET_STS_ERROR THEN

4669: l_auto_status := 'AUTO_POP_NA_ERROR';
4670: else
4671: l_auto_status :='AUTO_POP_EXP_ERROR';
4672: end if;
4673: elsif l_auto_pop_status = FND_API.G_RET_STS_ERROR THEN
4674: l_auto_status := 'AUTO_POP_NO_VALUE';
4675: end if;
4676: open get_asg_details;
4677: fetch get_asg_details into l_person_name, l_assignment_number, l_element_type, l_auto_org_name;

Line 4830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4826: g_batch_name,
4827: p_business_group_id,
4828: p_set_of_books_id,
4829: l_return_status);
4830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4831: end if;
4832: END IF;
4833:
4834: IF l_suspense_ac_not_found = 'Y' THEN

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

4871: g_batch_name,
4872: p_business_group_id,
4873: p_set_of_books_id,
4874: l_return_status);
4875: --- RAISE FND_API.G_EXC_UNEXPECTED_ERROR; commented for 2479579
4876: -- introduced following if stmnt for 2479579
4877: if l_susp_exception = 'NO_G_AC' then
4878: RAISE no_global_acct_exists;
4879: elsif l_susp_exception = 'NO_DT_MCH' then

Line 5054: p_return_status := fnd_api.g_ret_sts_success;

5050: delete gms_transaction_interface_all
5051: where transaction_source = p_txn_source
5052: and batch_name = p_gms_batch_name;
5053: End of bug fix 2643228 *****/
5054: p_return_status := fnd_api.g_ret_sts_success;
5055: EXCEPTION
5056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5057: --dbms_output.put_line('Gone to one level top ..................');
5058: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;

Line 5056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5052: and batch_name = p_gms_batch_name;
5053: End of bug fix 2643228 *****/
5054: p_return_status := fnd_api.g_ret_sts_success;
5055: EXCEPTION
5056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5057: --dbms_output.put_line('Gone to one level top ..................');
5058: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
5059: p_return_status := fnd_api.g_ret_sts_unexp_error;
5060: /* Added Exceptions for bug 2056877 */

Line 5059: p_return_status := fnd_api.g_ret_sts_unexp_error;

5055: EXCEPTION
5056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5057: --dbms_output.put_line('Gone to one level top ..................');
5058: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
5059: p_return_status := fnd_api.g_ret_sts_unexp_error;
5060: /* Added Exceptions for bug 2056877 */
5061: WHEN NO_PROFILE_EXISTS THEN
5062: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5063: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');

Line 5065: p_return_status := fnd_api.g_ret_sts_unexp_error;

5061: WHEN NO_PROFILE_EXISTS THEN
5062: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5063: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
5064: fnd_msg_pub.add;
5065: p_return_status := fnd_api.g_ret_sts_unexp_error;
5066:
5067: WHEN NO_VAL_DATE_MATCHES THEN
5068: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5069: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

Line 5073: p_return_status := fnd_api.g_ret_sts_unexp_error;

5069: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5070: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5071: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5072: fnd_msg_pub.add;
5073: p_return_status := fnd_api.g_ret_sts_unexp_error;
5074:
5075: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5076: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5077: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

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

5077: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5078: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5079: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5080: fnd_msg_pub.add;
5081: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
5082:
5083: WHEN OTHERS THEN
5084: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
5085: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GMS_TIE_BACK');

Line 5086: p_return_status := fnd_api.g_ret_sts_unexp_error;

5082:
5083: WHEN OTHERS THEN
5084: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
5085: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GMS_TIE_BACK');
5086: p_return_status := fnd_api.g_ret_sts_unexp_error;
5087: END;
5088:
5089: ------------------ INSERT INTO GMS INTERFACE -----------------------------------------------
5090:

Line 5196: p_return_status := fnd_api.g_ret_sts_success;

5192: -- Introduced the following columns for bug fix 2916848
5193: P_ACCT_RATE_TYPE,
5194: DECODE(p_acct_rate_type, NULL, NULL, P_ACCT_RATE_DATE));
5195:
5196: p_return_status := fnd_api.g_ret_sts_success;
5197: EXCEPTION
5198:
5199: WHEN OTHERS THEN
5200: -- dbms_output.put_line('Error while inserting .........................');

Line 5203: p_return_status := fnd_api.g_ret_sts_unexp_error;

5199: WHEN OTHERS THEN
5200: -- dbms_output.put_line('Error while inserting .........................');
5201: g_error_api_path := 'INSERT_INTO_PA_INTERFACE:'||g_error_api_path;
5202: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_PA_INTERFACE');
5203: p_return_status := fnd_api.g_ret_sts_unexp_error;
5204: END;
5205:
5206: /* Created this procedure on 4-Nov-2004.
5207: Following procedure is introduced for Effort reports Enhancement.

Line 6091: p_return_status := fnd_api.g_ret_sts_success;

6087: --- comment trace.. debug
6088: ---hr_utility.trace_on('Y','ZX');
6089: hr_utility.trace( 'SandT_Supercede--> Begin p_run_id='||p_run_id);
6090: fnd_signon.set_session(to_char(sysdate,'dd-mon-yyyy'));
6091: p_return_status := fnd_api.g_ret_sts_success;
6092: l_S_and_T_reqid := fnd_global.conc_request_id;
6093: fnd_stats.gather_table_stats(ownname => 'PSP',
6094: tabname => 'PSP_SUPERCEDE_PERSONS_GT');
6095: open check_er_template_h;

Line 6272: raise fnd_api.g_exc_unexpected_error;

6268: p_exp_type_segment => l_exp_type_segment);
6269: IF (l_proj_segment is null) OR (l_tsk_segment is null) OR (l_awd_sgement is null) OR
6270: (l_exp_org_segment is null) OR (l_exp_type_segment is null) THEN
6271: fnd_message.set_name('PSP', 'PSP_GL_PTAOE_NOT_MAPPED');
6272: raise fnd_api.g_exc_unexpected_error;
6273: END IF;
6274: l_sql_string := replace(l_sql_string,'psl','erd');
6275: l_sql_string := replace(l_sql_string,'gcc','erd');
6276: l_sql_string := replace(l_sql_string,l_proj_segment,'PROJECT_ID');

Line 6325: raise fnd_api.g_exc_unexpected_error;

6321: p_exp_type_segment => l_exp_type_segment);
6322: IF (l_proj_segment is null) OR (l_tsk_segment is null) OR (l_awd_sgement is null) OR
6323: (l_exp_org_segment is null) OR (l_exp_type_segment is null) THEN
6324: fnd_message.set_name('PSP', 'PSP_GL_PTAOE_NOT_MAPPED');
6325: raise fnd_api.g_exc_unexpected_error;
6326: END IF;
6327: l_sql_string := replace(l_sql_string,'psl','erd');
6328: l_sql_string := replace(l_sql_string,'gcc','erd');
6329: l_sql_string := replace(l_sql_string,l_proj_segment,'PROJECT_ID');

Line 6454: p_return_status := fnd_api.g_ret_sts_unexp_error;

6450: EXCEPTION
6451: when others then
6452: hr_utility.trace( 'SandT_Supercede--> when others in supercede_er'||sqlerrm) ;
6453: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS', 'SUPERCEDE_ER');
6454: p_return_status := fnd_api.g_ret_sts_unexp_error;
6455: END supercede_er;
6456:
6457: END PSP_SUM_TRANS;