APPS.CSY_KPI_PKG dependencies on FND_API

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

18: -- no need to return negative number
19: if (p_end_date <= p_start_date) then
20: return 0;
21: end if;
22: jtf_calendar_pub_24hr.get_resource_shifts(1,fnd_api.g_false,p_resource_id,
23: 'RS_EMPLOYEE',
24: p_start_date, p_end_date,
25: x_ret_stat,
26: x_msg_count,

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

48:
49: END IF;
50: */
51: l_total_time := 0;
52: if (x_ret_stat = fnd_api.g_ret_sts_success) then
53: for lp_cnt in 1..x_shifts.count loop
54: /*
55: dbms_output.put_line('Start Dt:'||
56: to_char(x_shifts(lp_cnt).start_time,'dd-mon-yyyy hh24:mi:ss')||

Line 835: raise fnd_api.g_exc_unexpected_error;

831: --
832: exception
833: when others then
834: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
835: raise fnd_api.g_exc_unexpected_error;
836: end get_resolution_timings;
837: procedure upload_first_resolutions(p_sql varchar2,
838: p_owner_type varchar2,
839: p_from_date date,

Line 946: raise fnd_api.g_exc_unexpected_error;

942: close c_first_resolutions;
943: exception
944: when others then
945: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
946: raise fnd_api.g_exc_unexpected_error;
947: end;
948: procedure get_sr_resolutions (p_from_date in date,
949: p_to_date in date) is
950: --cursor c_agent_resolutions is

Line 1178: raise fnd_api.g_exc_unexpected_error;

1174: ---
1175: exception
1176: when others then
1177: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
1178: raise fnd_api.g_exc_unexpected_error;
1179: end;
1180: procedure upload_assignments(p_sql varchar2,
1181: p_load_type varchar2,
1182: p_owner_type varchar2,

Line 1497: raise fnd_api.g_exc_unexpected_error;

1493: */
1494: exception
1495: when others then
1496: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
1497: raise fnd_api.g_exc_unexpected_error;
1498: end;
1499: procedure get_sr_group_assignments(p_from_date in date,
1500: p_to_date in date) is
1501: begin

Line 2008: raise fnd_api.g_exc_unexpected_error;

2004: --
2005: exception
2006: when others then
2007: fnd_file.put_line(fnd_file.log,'Error:'||sqlerrm);
2008: raise fnd_api.g_exc_unexpected_error;
2009: end;
2010: procedure update_group_data (p_from_date date,
2011: p_to_date date) is
2012: cursor c_group_data is