APPS.CSY_KPI_PKG dependencies on FND_API

Line 60: jtf_calendar_pub_24hr.get_resource_shifts(1,fnd_api.g_false,p_resource_id,

56: -- no need to return negative number
57: if (p_end_date <= p_start_date) then
58: return 0;
59: end if;
60: jtf_calendar_pub_24hr.get_resource_shifts(1,fnd_api.g_false,p_resource_id,
61: 'RS_EMPLOYEE',
62: p_start_date, p_end_date,
63: x_ret_stat,
64: x_msg_count,

Line 90: if (x_ret_stat = fnd_api.g_ret_sts_success) then

86:
87: END IF;
88: */
89: l_total_time := 0;
90: if (x_ret_stat = fnd_api.g_ret_sts_success) then
91: for lp_cnt in 1..x_shifts.count loop
92: /*
93: dbms_output.put_line('Start Dt:'||
94: to_char(x_shifts(lp_cnt).start_time,'dd-mon-yyyy hh24:mi:ss')||

Line 873: raise fnd_api.g_exc_unexpected_error;

869: --
870: exception
871: when others then
872: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
873: raise fnd_api.g_exc_unexpected_error;
874: end get_resolution_timings;
875: procedure upload_first_resolutions(p_sql varchar2,
876: p_owner_type varchar2,
877: p_from_date date,

Line 984: raise fnd_api.g_exc_unexpected_error;

980: close c_first_resolutions;
981: exception
982: when others then
983: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
984: raise fnd_api.g_exc_unexpected_error;
985: end;
986: procedure get_sr_resolutions (p_from_date in date,
987: p_to_date in date) is
988: --cursor c_agent_resolutions is

Line 1216: raise fnd_api.g_exc_unexpected_error;

1212: ---
1213: exception
1214: when others then
1215: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
1216: raise fnd_api.g_exc_unexpected_error;
1217: end;
1218: procedure upload_assignments(p_sql varchar2,
1219: p_load_type varchar2,
1220: p_owner_type varchar2,

Line 1535: raise fnd_api.g_exc_unexpected_error;

1531: */
1532: exception
1533: when others then
1534: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
1535: raise fnd_api.g_exc_unexpected_error;
1536: end;
1537: procedure get_sr_group_assignments(p_from_date in date,
1538: p_to_date in date) is
1539: begin

Line 2050: raise fnd_api.g_exc_unexpected_error;

2046: --
2047: exception
2048: when others then
2049: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
2050: raise fnd_api.g_exc_unexpected_error;
2051: end;
2052: procedure update_group_data (p_from_date date,
2053: p_to_date date) is
2054: cursor c_group_data is