DBA Data[Home] [Help]

APPS.PSP_ADJ_DRIVER dependencies on FND_API

Line 1307: p_encoded => FND_API.G_FALSE,

1303:
1304: WHEN OTHERS THEN
1305: g_error_api_path := 'LOAD_TABLE:'||g_error_api_path;
1306: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
1307: p_encoded => FND_API.G_FALSE,
1308: p_data => l_msg_data,
1309: p_msg_index_out => l_msg_count);
1310: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
1311: retcode := 2;

Line 1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1414: l_begin_date,
1415: l_end_date;
1416: if app_dates_c%NOTFOUND then
1417: close app_dates_c;
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: else
1420: close app_dates_c;
1421: end if;
1422:

Line 1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1426: l_employee_number,
1427: l_assignment_number;
1428: if app_header_c%NOTFOUND then
1429: close app_header_c;
1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1431: else
1432: close app_header_c;
1433: end if;
1434:

Line 1455: p_encoded => FND_API.G_FALSE,

1451: EXCEPTION
1452: WHEN OTHERS THEN
1453: g_error_api_path := 'GET_APPROVAL_HEADER:'||g_error_api_path;
1454: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
1455: p_encoded => FND_API.G_FALSE,
1456: p_data => l_msg_data,
1457: p_msg_index_out => l_msg_count);
1458: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
1459: retcode := 2;

Line 1992: p_encoded => FND_API.G_FALSE,

1988:
1989: WHEN OTHERS THEN
1990: g_error_api_path := 'LOAD_TABLE:'||g_error_api_path;
1991: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
1992: p_encoded => FND_API.G_FALSE,
1993: p_data => l_msg_data,
1994: p_msg_index_out => l_msg_count);
1995: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
1996: retcode := 2;

Line 2146: p_return_status := fnd_api.g_ret_sts_success;

2142: fnd_global.user_id,
2143: fnd_global.login_id,
2144: fnd_global.user_id,
2145: sysdate);
2146: p_return_status := fnd_api.g_ret_sts_success;
2147:
2148: EXCEPTION
2149: WHEN OTHERS THEN
2150: g_error_api_path := 'INSERT_ADJ_LINES:Batch Name '||p_batch_name||':'||g_error_api_path;

Line 2151: p_return_status := fnd_api.g_ret_sts_unexp_error;

2147:
2148: EXCEPTION
2149: WHEN OTHERS THEN
2150: g_error_api_path := 'INSERT_ADJ_LINES:Batch Name '||p_batch_name||':'||g_error_api_path;
2151: p_return_status := fnd_api.g_ret_sts_unexp_error;
2152:
2153: end;
2154: --------------------------------------------------------------------
2155:

Line 2220: p_return_status := fnd_api.g_ret_sts_success;

2216: p_currency_code, -- Introduced for bug fix 2916848
2217: p_business_group_id,
2218: p_set_of_books_id,
2219: p_adjust_by); --- added for DA-ENH
2220: p_return_status := fnd_api.g_ret_sts_success;
2221:
2222: EXCEPTION
2223: --************************************************************
2224: WHEN DUP_VAL_ON_INDEX THEN

Line 2230: p_return_status := fnd_api.g_ret_sts_unexp_error;

2226: --************************************************************
2227:
2228: WHEN OTHERS THEN
2229: g_error_api_path := 'INSERT_ADJUSTMENT_CONTROL:Batch Name '||p_batch_name||':'||g_error_api_path;
2230: p_return_status := fnd_api.g_ret_sts_unexp_error;
2231: end;
2232: -----------------------------------------------------------------------
2233:
2234:

Line 2278: p_encoded => FND_API.G_FALSE,

2274: EXCEPTION
2275: WHEN OTHERS THEN
2276: g_error_api_path := 'UPDATE_ADJUSTMENT_CONTROL:'||g_error_api_path;
2277: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
2278: p_encoded => FND_API.G_FALSE,
2279: p_data => l_msg_data,
2280: p_msg_index_out => l_msg_count);
2281: errbuf := l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
2282: retcode := 2;

Line 2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2362: fetch time_periods_c into l_time_period_id;
2363: if time_periods_c%NOTFOUND then
2364: close time_periods_c;
2365: g_error_api_path := 'Error opening cursor time_periods_c: '||g_error_api_path;
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367: end if;
2368:
2369:
2370: open tot_dr_c;

Line 2540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2536: and business_group_id = p_business_group_id
2537: and set_of_books_id = p_set_of_books_id;
2538: IF SQL%NOTFOUND THEN
2539: close time_periods_c;
2540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2541: END IF;
2542:
2543: end loop;
2544:

Line 2545: p_return_status := fnd_api.g_ret_sts_success;

2541: END IF;
2542:
2543: end loop;
2544:
2545: p_return_status := fnd_api.g_ret_sts_success;
2546:
2547: EXCEPTION
2548: WHEN OTHERS THEN
2549: g_error_api_path := 'UPDATE_PAYROLL_CONTROL:Batch Name '||p_batch_name||':'||g_error_api_path;

Line 2550: p_return_status := fnd_api.g_ret_sts_unexp_error;

2546:
2547: EXCEPTION
2548: WHEN OTHERS THEN
2549: g_error_api_path := 'UPDATE_PAYROLL_CONTROL:Batch Name '||p_batch_name||':'||g_error_api_path;
2550: p_return_status := fnd_api.g_ret_sts_unexp_error;
2551: end;
2552: --------------------------------------------------------------------------------
2553:
2554:

Line 2660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2656: l_end_date;
2657: if effort_templates_c%NOTFOUND then
2658: close effort_templates_c;
2659: g_error_api_path := 'Error opening cursor effort_templates_c: '||g_error_api_path;
2660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2661: end if;
2662: ******************************************* /
2663:
2664: if l_dist_date between l_begin_date and l_end_date then

Line 2714: p_return_status := fnd_api.g_ret_sts_success;

2710: (SELECT pere.element_type_id
2711: FROM psp_effort_report_elements pere
2712: WHERE pere.use_in_effort_report = 'Y'));
2713: -- End of bug fix 2724110
2714: p_return_status := fnd_api.g_ret_sts_success;
2715:
2716: EXCEPTION
2717: WHEN OTHERS THEN
2718: g_error_api_path := 'UPDATE_EFFORT_REPORTS:Batch Name '||p_batch_name||':'||g_error_api_path;

Line 2719: p_return_status := fnd_api.g_ret_sts_unexp_error;

2715:
2716: EXCEPTION
2717: WHEN OTHERS THEN
2718: g_error_api_path := 'UPDATE_EFFORT_REPORTS:Batch Name '||p_batch_name||':'||g_error_api_path;
2719: p_return_status := fnd_api.g_ret_sts_unexp_error;
2720: end;
2721: --------------------------------------------------------------------------------
2722:
2723:

Line 3142: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3138: p_adjust_by); --- added param for DA-ENH
3139:
3140: IF l_return_status = g_constraint_violation THEN
3141: RAISE e_constraint_violation;
3142: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3144: END IF;
3145:
3146: --Reversal Lines Generation

Line 3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3139:
3140: IF l_return_status = g_constraint_violation THEN
3141: RAISE e_constraint_violation;
3142: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3144: END IF;
3145:
3146: --Reversal Lines Generation
3147:

Line 3916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3912: update_effort_reports(p_batch_name,
3913: p_business_group_id,
3914: p_set_of_books_id,
3915: l_return_status);
3916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3918: END IF;
3919:
3920:

Line 3917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3913: p_business_group_id,
3914: p_set_of_books_id,
3915: l_return_status);
3916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3918: END IF;
3919:
3920:
3921: END IF;

Line 3936: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3932: p_set_of_books_id,
3933: p_currency_code, -- Introduced for bug fix 2916848
3934: l_return_status,
3935: p_gl_posting_override_date);
3936: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3938: END IF;
3939:
3940: delete from psp_temp_orig_lines where run_id = p_run_id;

Line 3937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3933: p_currency_code, -- Introduced for bug fix 2916848
3934: l_return_status,
3935: p_gl_posting_override_date);
3936: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3938: END IF;
3939:
3940: delete from psp_temp_orig_lines where run_id = p_run_id;
3941: delete from psp_temp_orig_sumlines where run_id = p_run_id;

Line 4036: p_encoded => FND_API.G_FALSE,

4032: delete from psp_temp_dest_sumlines;
4033: End of comment for bug fix 4507892 *****/
4034: g_error_api_path := 'GENERATE_LINES:'||g_error_api_path||sqlerrm;
4035: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
4036: p_encoded => FND_API.G_FALSE,
4037: p_data => l_msg_data,
4038: p_msg_index_out => l_msg_count);
4039: errbuf := errbuf || l_msg_data || fnd_global.local_chr(10) || g_error_api_path;
4040: retcode := 2;