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.CSF_REQUIRED_SKILLS_PKG dependencies on FND_API

Line 157: if not fnd_api.compatible_api_call (

153: l_api_version constant number := 1.0;
154: l_req_skill_id number;
155: BEGIN
156: -- standard call to check for call compatibility
157: if not fnd_api.compatible_api_call (
158: l_api_version
159: , p_api_version
160: , l_api_name
161: , g_package_name

Line 164: raise fnd_api.g_exc_unexpected_error;

160: , l_api_name
161: , g_package_name
162: )
163: then
164: raise fnd_api.g_exc_unexpected_error;
165: end if;
166:
167: -- initialize message list if p_init_msg_list is set to true
168: if fnd_api.to_boolean(p_init_msg_list)

Line 168: if fnd_api.to_boolean(p_init_msg_list)

164: raise fnd_api.g_exc_unexpected_error;
165: end if;
166:
167: -- initialize message list if p_init_msg_list is set to true
168: if fnd_api.to_boolean(p_init_msg_list)
169: then
170: fnd_msg_pub.initialize;
171: end if;
172:

Line 185: X_return_status := fnd_api.g_ret_sts_error;

181: then
182:
183: /* Checks if task exist in JTF_TASK_B table. */
184: If not task_exists (p_task_id) then
185: X_return_status := fnd_api.g_ret_sts_error;
186: X_msg_count := 1;
187: X_msg_data := 'Task Id ('||to_char(p_task_id)||
188: ') does not exist in JTF_TASKS_B table.';
189: return;

Line 194: X_return_status := fnd_api.g_ret_sts_error;

190: end if;
191:
192: /* Checks if skill type and id exist. */
193: If not skill_exists (p_skill_type_id, p_skill_id) then
194: X_return_status := fnd_api.g_ret_sts_error;
195: X_msg_count := 1;
196: X_msg_data := 'Combination of skill id ('||p_skill_id||') '||
197: 'and skill type id ('||p_skill_type_id||') '||
198: 'does not exist in CSF_SKILLS_B table.';

Line 204: X_return_status := fnd_api.g_ret_sts_error;

200: end if;
201:
202: /* Checks if skill level exists in CSF_SKILL_LEVELS_B. */
203: If not skill_level_exists (p_skill_level_id) then
204: X_return_status := fnd_api.g_ret_sts_error;
205: X_msg_count := 1;
206: X_msg_data := 'Skill level id ('||p_skill_level_id||') '||
207: 'does not exist in CSF_SKILL_LEVELS_B table.';
208: return;

Line 287: if fnd_api.to_boolean(p_commit)

283: , null
284: , null
285: , null);
286:
287: if fnd_api.to_boolean(p_commit)
288: then
289: commit;
290: end if;
291:

Line 292: x_return_status := fnd_api.g_ret_sts_success;

288: then
289: commit;
290: end if;
291:
292: x_return_status := fnd_api.g_ret_sts_success;
293:
294: --Bug Fixed 3884408
295: --When the required skill to be inserted into csf_required_skills_b table already exist for
296: --the given task, Procedure create_row() must return status 'E' to calling function.

Line 299: X_return_status := fnd_api.g_ret_sts_success;

295: --When the required skill to be inserted into csf_required_skills_b table already exist for
296: --the given task, Procedure create_row() must return status 'E' to calling function.
297: else
298: if g_called_from_hook = 'T' then
299: X_return_status := fnd_api.g_ret_sts_success;
300: else
301: X_return_status := fnd_api.g_ret_sts_error;
302: X_msg_count := 1;
303: X_msg_data := 'Combination of Skill id ('||p_skill_id||') and Skill type id ('||p_skill_type_id||') to be inserted does exist for Task ('||to_char(p_task_id)|| ') in CSF_REQUIRED_SKILLS_B table';

Line 301: X_return_status := fnd_api.g_ret_sts_error;

297: else
298: if g_called_from_hook = 'T' then
299: X_return_status := fnd_api.g_ret_sts_success;
300: else
301: X_return_status := fnd_api.g_ret_sts_error;
302: X_msg_count := 1;
303: X_msg_data := 'Combination of Skill id ('||p_skill_id||') and Skill type id ('||p_skill_type_id||') to be inserted does exist for Task ('||to_char(p_task_id)|| ') in CSF_REQUIRED_SKILLS_B table';
304: end if;
305: end if;

Line 307: when fnd_api.g_exc_error then

303: X_msg_data := 'Combination of Skill id ('||p_skill_id||') and Skill type id ('||p_skill_type_id||') to be inserted does exist for Task ('||to_char(p_task_id)|| ') in CSF_REQUIRED_SKILLS_B table';
304: end if;
305: end if;
306: EXCEPTION
307: when fnd_api.g_exc_error then
308: x_return_status := fnd_api.g_ret_sts_error;
309:
310: fnd_msg_pub.count_and_get ( p_count => x_msg_count
311: , p_data => x_msg_data );

Line 308: x_return_status := fnd_api.g_ret_sts_error;

304: end if;
305: end if;
306: EXCEPTION
307: when fnd_api.g_exc_error then
308: x_return_status := fnd_api.g_ret_sts_error;
309:
310: fnd_msg_pub.count_and_get ( p_count => x_msg_count
311: , p_data => x_msg_data );
312:

Line 313: when fnd_api.g_exc_unexpected_error then

309:
310: fnd_msg_pub.count_and_get ( p_count => x_msg_count
311: , p_data => x_msg_data );
312:
313: when fnd_api.g_exc_unexpected_error then
314: x_return_status := fnd_api.g_ret_sts_unexp_error;
315: fnd_msg_pub.count_and_get ( p_count => x_msg_count
316: , p_data => x_msg_data );
317:

Line 314: x_return_status := fnd_api.g_ret_sts_unexp_error;

310: fnd_msg_pub.count_and_get ( p_count => x_msg_count
311: , p_data => x_msg_data );
312:
313: when fnd_api.g_exc_unexpected_error then
314: x_return_status := fnd_api.g_ret_sts_unexp_error;
315: fnd_msg_pub.count_and_get ( p_count => x_msg_count
316: , p_data => x_msg_data );
317:
318: when others then

Line 319: x_return_status := fnd_api.g_ret_sts_unexp_error;

315: fnd_msg_pub.count_and_get ( p_count => x_msg_count
316: , p_data => x_msg_data );
317:
318: when others then
319: x_return_status := fnd_api.g_ret_sts_unexp_error;
320: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
321: then
322: fnd_msg_pub.add_exc_msg ( g_package_name, l_api_name );
323: end if;

Line 373: , p_init_msg_list => FND_API.G_FALSE

369: then
370:
371: create_row
372: ( p_api_version => 1
373: , p_init_msg_list => FND_API.G_FALSE
374: , p_commit => FND_API.G_FALSE
375: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
376: , x_return_status => l_return_status
377: , x_msg_count => l_msg_count

Line 374: , p_commit => FND_API.G_FALSE

370:
371: create_row
372: ( p_api_version => 1
373: , p_init_msg_list => FND_API.G_FALSE
374: , p_commit => FND_API.G_FALSE
375: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
376: , x_return_status => l_return_status
377: , x_msg_count => l_msg_count
378: , x_msg_data => l_msg_data

Line 375: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

371: create_row
372: ( p_api_version => 1
373: , p_init_msg_list => FND_API.G_FALSE
374: , p_commit => FND_API.G_FALSE
375: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
376: , x_return_status => l_return_status
377: , x_msg_count => l_msg_count
378: , x_msg_data => l_msg_data
379: , p_task_id => l_task_id

Line 389: ,fnd_api.g_ret_sts_success );

385: end if;
386: end if;
387: g_called_from_hook := 'F';
388: x_return_status := nvl( l_return_status
389: ,fnd_api.g_ret_sts_success );
390: EXCEPTION
391: when others then
392: x_return_status := fnd_api.g_ret_sts_unexp_error;
393: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )

Line 392: x_return_status := fnd_api.g_ret_sts_unexp_error;

388: x_return_status := nvl( l_return_status
389: ,fnd_api.g_ret_sts_success );
390: EXCEPTION
391: when others then
392: x_return_status := fnd_api.g_ret_sts_unexp_error;
393: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
394: then
395: fnd_msg_pub.add_exc_msg ( g_package_name, l_api_name );
396: end if;

Line 431: , p_init_msg_list => FND_API.G_FALSE

427:
428: for r_skills in c_skills loop
429: create_row
430: ( p_api_version => 1
431: , p_init_msg_list => FND_API.G_FALSE
432: , p_commit => FND_API.G_FALSE
433: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
434: , x_return_status => l_return_status
435: , x_msg_count => l_msg_count

Line 432: , p_commit => FND_API.G_FALSE

428: for r_skills in c_skills loop
429: create_row
430: ( p_api_version => 1
431: , p_init_msg_list => FND_API.G_FALSE
432: , p_commit => FND_API.G_FALSE
433: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
434: , x_return_status => l_return_status
435: , x_msg_count => l_msg_count
436: , x_msg_data => l_msg_data

Line 433: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

429: create_row
430: ( p_api_version => 1
431: , p_init_msg_list => FND_API.G_FALSE
432: , p_commit => FND_API.G_FALSE
433: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
434: , x_return_status => l_return_status
435: , x_msg_count => l_msg_count
436: , x_msg_data => l_msg_data
437: , p_task_id => l_task_id

Line 442: If l_return_status = fnd_api.g_ret_sts_error -- there's an error.

438: , p_skill_type_id => r_skills.skill_type_id
439: , p_skill_id => r_skills.skill_id
440: , p_skill_level_id => r_skills.skill_level_id);
441:
442: If l_return_status = fnd_api.g_ret_sts_error -- there's an error.
443: Then
444: Exit;
445: End if;
446: end loop;

Line 449: ,fnd_api.g_ret_sts_success );

445: End if;
446: end loop;
447: g_called_from_hook := 'F';
448: x_return_status := nvl( l_return_status
449: ,fnd_api.g_ret_sts_success );
450: EXCEPTION
451: when others then
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )

Line 452: x_return_status := fnd_api.g_ret_sts_unexp_error;

448: x_return_status := nvl( l_return_status
449: ,fnd_api.g_ret_sts_success );
450: EXCEPTION
451: when others then
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
454: then
455: fnd_msg_pub.add_exc_msg ( g_package_name, l_api_name );
456: end if;