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_ADJ_DRIVER dependencies on FND_API

Line 1313: p_encoded => FND_API.G_FALSE,

1309:
1310: WHEN OTHERS THEN
1311: g_error_api_path := 'LOAD_TABLE:'||g_error_api_path;
1312: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
1313: p_encoded => FND_API.G_FALSE,
1314: p_data => l_msg_data,
1315: p_msg_index_out => l_msg_count);
1316: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
1317: retcode := 2;

Line 1427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1423: l_begin_date,
1424: l_end_date;
1425: if app_dates_c%NOTFOUND then
1426: close app_dates_c;
1427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1428: else
1429: close app_dates_c;
1430: end if;
1431:

Line 1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1435: l_employee_number,
1436: l_assignment_number;
1437: if app_header_c%NOTFOUND then
1438: close app_header_c;
1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1440: else
1441: close app_header_c;
1442: end if;
1443:

Line 1464: p_encoded => FND_API.G_FALSE,

1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: g_error_api_path := 'GET_APPROVAL_HEADER:'||g_error_api_path;
1463: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
1464: p_encoded => FND_API.G_FALSE,
1465: p_data => l_msg_data,
1466: p_msg_index_out => l_msg_count);
1467: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
1468: retcode := 2;

Line 2001: p_encoded => FND_API.G_FALSE,

1997:
1998: WHEN OTHERS THEN
1999: g_error_api_path := 'LOAD_TABLE:'||g_error_api_path;
2000: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
2001: p_encoded => FND_API.G_FALSE,
2002: p_data => l_msg_data,
2003: p_msg_index_out => l_msg_count);
2004: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
2005: retcode := 2;

Line 2155: p_return_status := fnd_api.g_ret_sts_success;

2151: fnd_global.user_id,
2152: fnd_global.login_id,
2153: fnd_global.user_id,
2154: sysdate);
2155: p_return_status := fnd_api.g_ret_sts_success;
2156:
2157: EXCEPTION
2158: WHEN OTHERS THEN
2159: g_error_api_path := 'INSERT_ADJ_LINES:Batch Name '||p_batch_name||':'||g_error_api_path;

Line 2160: p_return_status := fnd_api.g_ret_sts_unexp_error;

2156:
2157: EXCEPTION
2158: WHEN OTHERS THEN
2159: g_error_api_path := 'INSERT_ADJ_LINES:Batch Name '||p_batch_name||':'||g_error_api_path;
2160: p_return_status := fnd_api.g_ret_sts_unexp_error;
2161:
2162: end;
2163: --------------------------------------------------------------------
2164:

Line 2229: p_return_status := fnd_api.g_ret_sts_success;

2225: p_currency_code, -- Introduced for bug fix 2916848
2226: p_business_group_id,
2227: p_set_of_books_id,
2228: p_adjust_by); --- added for DA-ENH
2229: p_return_status := fnd_api.g_ret_sts_success;
2230:
2231: EXCEPTION
2232: --************************************************************
2233: WHEN DUP_VAL_ON_INDEX THEN

Line 2239: p_return_status := fnd_api.g_ret_sts_unexp_error;

2235: --************************************************************
2236:
2237: WHEN OTHERS THEN
2238: g_error_api_path := 'INSERT_ADJUSTMENT_CONTROL:Batch Name '||p_batch_name||':'||g_error_api_path;
2239: p_return_status := fnd_api.g_ret_sts_unexp_error;
2240: end;
2241: -----------------------------------------------------------------------
2242:
2243:

Line 2287: p_encoded => FND_API.G_FALSE,

2283: EXCEPTION
2284: WHEN OTHERS THEN
2285: g_error_api_path := 'UPDATE_ADJUSTMENT_CONTROL:'||g_error_api_path;
2286: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
2287: p_encoded => FND_API.G_FALSE,
2288: p_data => l_msg_data,
2289: p_msg_index_out => l_msg_count);
2290: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
2291: retcode := 2;

Line 2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2371: fetch time_periods_c into l_time_period_id;
2372: if time_periods_c%NOTFOUND then
2373: close time_periods_c;
2374: g_error_api_path := 'Error opening cursor time_periods_c: '||g_error_api_path;
2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2376: end if;
2377:
2378:
2379: open tot_dr_c;

Line 2549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2545: and business_group_id = p_business_group_id
2546: and set_of_books_id = p_set_of_books_id;
2547: IF SQL%NOTFOUND THEN
2548: close time_periods_c;
2549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2550: END IF;
2551:
2552: end loop;
2553:

Line 2554: p_return_status := fnd_api.g_ret_sts_success;

2550: END IF;
2551:
2552: end loop;
2553:
2554: p_return_status := fnd_api.g_ret_sts_success;
2555:
2556: EXCEPTION
2557: WHEN OTHERS THEN
2558: g_error_api_path := 'UPDATE_PAYROLL_CONTROL:Batch Name '||p_batch_name||':'||g_error_api_path;

Line 2559: p_return_status := fnd_api.g_ret_sts_unexp_error;

2555:
2556: EXCEPTION
2557: WHEN OTHERS THEN
2558: g_error_api_path := 'UPDATE_PAYROLL_CONTROL:Batch Name '||p_batch_name||':'||g_error_api_path;
2559: p_return_status := fnd_api.g_ret_sts_unexp_error;
2560: end;
2561: --------------------------------------------------------------------------------
2562:
2563:

Line 2669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2665: l_end_date;
2666: if effort_templates_c%NOTFOUND then
2667: close effort_templates_c;
2668: g_error_api_path := 'Error opening cursor effort_templates_c: '||g_error_api_path;
2669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2670: end if;
2671: ******************************************* /
2672:
2673: if l_dist_date between l_begin_date and l_end_date then

Line 2723: p_return_status := fnd_api.g_ret_sts_success;

2719: (SELECT pere.element_type_id
2720: FROM psp_effort_report_elements pere
2721: WHERE pere.use_in_effort_report = 'Y'));
2722: -- End of bug fix 2724110
2723: p_return_status := fnd_api.g_ret_sts_success;
2724:
2725: EXCEPTION
2726: WHEN OTHERS THEN
2727: g_error_api_path := 'UPDATE_EFFORT_REPORTS:Batch Name '||p_batch_name||':'||g_error_api_path;

Line 2728: p_return_status := fnd_api.g_ret_sts_unexp_error;

2724:
2725: EXCEPTION
2726: WHEN OTHERS THEN
2727: g_error_api_path := 'UPDATE_EFFORT_REPORTS:Batch Name '||p_batch_name||':'||g_error_api_path;
2728: p_return_status := fnd_api.g_ret_sts_unexp_error;
2729: end;
2730: --------------------------------------------------------------------------------
2731:
2732:

Line 3151: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3147: p_adjust_by); --- added param for DA-ENH
3148:
3149: IF l_return_status = g_constraint_violation THEN
3150: RAISE e_constraint_violation;
3151: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3153: END IF;
3154:
3155: --Reversal Lines Generation

Line 3152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3148:
3149: IF l_return_status = g_constraint_violation THEN
3150: RAISE e_constraint_violation;
3151: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3153: END IF;
3154:
3155: --Reversal Lines Generation
3156:

Line 3925: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3921: update_effort_reports(p_batch_name,
3922: p_business_group_id,
3923: p_set_of_books_id,
3924: l_return_status);
3925: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3927: END IF;
3928:
3929:

Line 3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3922: p_business_group_id,
3923: p_set_of_books_id,
3924: l_return_status);
3925: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3927: END IF;
3928:
3929:
3930: END IF;

Line 3945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3941: p_set_of_books_id,
3942: p_currency_code, -- Introduced for bug fix 2916848
3943: l_return_status,
3944: p_gl_posting_override_date);
3945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END IF;
3948:
3949: delete from psp_temp_orig_lines where run_id = p_run_id;

Line 3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3942: p_currency_code, -- Introduced for bug fix 2916848
3943: l_return_status,
3944: p_gl_posting_override_date);
3945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END IF;
3948:
3949: delete from psp_temp_orig_lines where run_id = p_run_id;
3950: delete from psp_temp_orig_sumlines where run_id = p_run_id;

Line 4045: p_encoded => FND_API.G_FALSE,

4041: delete from psp_temp_dest_sumlines;
4042: End of comment for bug fix 4507892 *****/
4043: g_error_api_path := 'GENERATE_LINES:'||g_error_api_path||sqlerrm;
4044: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
4045: p_encoded => FND_API.G_FALSE,
4046: p_data => l_msg_data,
4047: p_msg_index_out => l_msg_count);
4048: errbuf := errbuf || l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
4049: retcode := 2;