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 158: if not fnd_api.compatible_api_call (

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

Line 165: raise fnd_api.g_exc_unexpected_error;

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

Line 169: if fnd_api.to_boolean(p_init_msg_list)

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

Line 186: X_return_status := fnd_api.g_ret_sts_error;

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

Line 195: X_return_status := fnd_api.g_ret_sts_error;

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

Line 205: X_return_status := fnd_api.g_ret_sts_error;

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

Line 288: if fnd_api.to_boolean(p_commit)

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

Line 293: x_return_status := fnd_api.g_ret_sts_success;

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

Line 300: X_return_status := fnd_api.g_ret_sts_success;

296: --When the required skill to be inserted into csf_required_skills_b table already exist for
297: --the given task, Procedure create_row() must return status 'E' to calling function.
298: else
299: if g_called_from_hook = 'T' then
300: X_return_status := fnd_api.g_ret_sts_success;
301: else
302: X_return_status := fnd_api.g_ret_sts_error;
303: X_msg_count := 1;
304: 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 302: X_return_status := fnd_api.g_ret_sts_error;

298: else
299: if g_called_from_hook = 'T' then
300: X_return_status := fnd_api.g_ret_sts_success;
301: else
302: X_return_status := fnd_api.g_ret_sts_error;
303: X_msg_count := 1;
304: 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';
305: end if;
306: end if;

Line 308: when fnd_api.g_exc_error then

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

Line 309: x_return_status := fnd_api.g_ret_sts_error;

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

Line 314: when fnd_api.g_exc_unexpected_error then

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

Line 315: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 320: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 394: , p_init_msg_list => FND_API.G_FALSE

390: then
391:
392: create_row
393: ( p_api_version => 1
394: , p_init_msg_list => FND_API.G_FALSE
395: , p_commit => FND_API.G_FALSE
396: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
397: , x_return_status => l_return_status
398: , x_msg_count => l_msg_count

Line 395: , p_commit => FND_API.G_FALSE

391:
392: create_row
393: ( p_api_version => 1
394: , p_init_msg_list => FND_API.G_FALSE
395: , p_commit => FND_API.G_FALSE
396: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
397: , x_return_status => l_return_status
398: , x_msg_count => l_msg_count
399: , x_msg_data => l_msg_data

Line 396: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

392: create_row
393: ( p_api_version => 1
394: , p_init_msg_list => FND_API.G_FALSE
395: , p_commit => FND_API.G_FALSE
396: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
397: , x_return_status => l_return_status
398: , x_msg_count => l_msg_count
399: , x_msg_data => l_msg_data
400: , p_task_id => l_task_id

Line 425: , p_init_msg_list => FND_API.G_FALSE

421: then
422:
423: create_row
424: ( p_api_version => 1
425: , p_init_msg_list => FND_API.G_FALSE
426: , p_commit => FND_API.G_FALSE
427: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
428: , x_return_status => l_return_status
429: , x_msg_count => l_msg_count

Line 426: , p_commit => FND_API.G_FALSE

422:
423: create_row
424: ( p_api_version => 1
425: , p_init_msg_list => FND_API.G_FALSE
426: , p_commit => FND_API.G_FALSE
427: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
428: , x_return_status => l_return_status
429: , x_msg_count => l_msg_count
430: , x_msg_data => l_msg_data

Line 427: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

423: create_row
424: ( p_api_version => 1
425: , p_init_msg_list => FND_API.G_FALSE
426: , p_commit => FND_API.G_FALSE
427: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
428: , x_return_status => l_return_status
429: , x_msg_count => l_msg_count
430: , x_msg_data => l_msg_data
431: , p_task_id => l_task_id

Line 441: ,fnd_api.g_ret_sts_success );

437: end if;
438: end if;
439: g_called_from_hook := 'F';
440: x_return_status := nvl( l_return_status
441: ,fnd_api.g_ret_sts_success );
442: EXCEPTION
443: when others then
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )

Line 444: x_return_status := fnd_api.g_ret_sts_unexp_error;

440: x_return_status := nvl( l_return_status
441: ,fnd_api.g_ret_sts_success );
442: EXCEPTION
443: when others then
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
446: then
447: fnd_msg_pub.add_exc_msg ( g_package_name, l_api_name );
448: end if;

Line 483: , p_init_msg_list => FND_API.G_FALSE

479:
480: for r_skills in c_skills loop
481: create_row
482: ( p_api_version => 1
483: , p_init_msg_list => FND_API.G_FALSE
484: , p_commit => FND_API.G_FALSE
485: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
486: , x_return_status => l_return_status
487: , x_msg_count => l_msg_count

Line 484: , p_commit => FND_API.G_FALSE

480: for r_skills in c_skills loop
481: create_row
482: ( p_api_version => 1
483: , p_init_msg_list => FND_API.G_FALSE
484: , p_commit => FND_API.G_FALSE
485: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
486: , x_return_status => l_return_status
487: , x_msg_count => l_msg_count
488: , x_msg_data => l_msg_data

Line 485: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

481: create_row
482: ( p_api_version => 1
483: , p_init_msg_list => FND_API.G_FALSE
484: , p_commit => FND_API.G_FALSE
485: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
486: , x_return_status => l_return_status
487: , x_msg_count => l_msg_count
488: , x_msg_data => l_msg_data
489: , p_task_id => l_task_id

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

490: , p_skill_type_id => r_skills.skill_type_id
491: , p_skill_id => r_skills.skill_id
492: , p_skill_level_id => r_skills.skill_level_id);
493:
494: If l_return_status = fnd_api.g_ret_sts_error -- there's an error.
495: Then
496: Exit;
497: End if;
498: end loop;

Line 501: ,fnd_api.g_ret_sts_success );

497: End if;
498: end loop;
499: g_called_from_hook := 'F';
500: x_return_status := nvl( l_return_status
501: ,fnd_api.g_ret_sts_success );
502: EXCEPTION
503: when others then
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )

Line 504: x_return_status := fnd_api.g_ret_sts_unexp_error;

500: x_return_status := nvl( l_return_status
501: ,fnd_api.g_ret_sts_success );
502: EXCEPTION
503: when others then
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
506: then
507: fnd_msg_pub.add_exc_msg ( g_package_name, l_api_name );
508: end if;

Line 563: , p_init_msg_list => FND_API.G_FALSE

559: -- retrieving default values for skill type and level.
560: -- l_skill_level_id := fnd_profile.value('CSF_DFLT_SKILL_LEVEL');
561: create_row
562: ( p_api_version => 1
563: , p_init_msg_list => FND_API.G_FALSE
564: , p_commit => FND_API.G_FALSE
565: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
566: , x_return_status => l_return_status
567: , x_msg_count => l_msg_count

Line 564: , p_commit => FND_API.G_FALSE

560: -- l_skill_level_id := fnd_profile.value('CSF_DFLT_SKILL_LEVEL');
561: create_row
562: ( p_api_version => 1
563: , p_init_msg_list => FND_API.G_FALSE
564: , p_commit => FND_API.G_FALSE
565: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
566: , x_return_status => l_return_status
567: , x_msg_count => l_msg_count
568: , x_msg_data => l_msg_data

Line 565: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

561: create_row
562: ( p_api_version => 1
563: , p_init_msg_list => FND_API.G_FALSE
564: , p_commit => FND_API.G_FALSE
565: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
566: , x_return_status => l_return_status
567: , x_msg_count => l_msg_count
568: , x_msg_data => l_msg_data
569: , p_task_id => l_task_id

Line 579: x_return_status := nvl( l_return_status ,fnd_api.g_ret_sts_success );

575: end if;
576: close c_parent_task_id;
577:
578: g_called_from_hook := 'F';
579: x_return_status := nvl( l_return_status ,fnd_api.g_ret_sts_success );
580: EXCEPTION
581: when others then
582: x_return_status := fnd_api.g_ret_sts_unexp_error;
583: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )

Line 582: x_return_status := fnd_api.g_ret_sts_unexp_error;

578: g_called_from_hook := 'F';
579: x_return_status := nvl( l_return_status ,fnd_api.g_ret_sts_success );
580: EXCEPTION
581: when others then
582: x_return_status := fnd_api.g_ret_sts_unexp_error;
583: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
584: then
585: fnd_msg_pub.add_exc_msg ( g_package_name, l_api_name );
586: end if;