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

Line 344: ( p_init_msg_list in varchar2 default fnd_api.g_false

340: -- Description : Checks if there is a mismatch in task group template when item,
341: -- item category, type, problem code change on updating a SR
342: -- -------------------------------------------------------------------------
343: procedure task_group_template_mismatch
344: ( p_init_msg_list in varchar2 default fnd_api.g_false
345: , p_old_inv_category in number
346: , p_new_inv_category in number
347: , p_old_inv_item in number
348: , p_new_inv_item in number

Line 384: if fnd_api.to_boolean( p_init_msg_list ) then

380: where task_template_group_id = l_templ_grp_id;
381: --
382: begin
383: --
384: if fnd_api.to_boolean( p_init_msg_list ) then
385: fnd_msg_pub.initialize;
386: end if;
387: --
388: x_return_status := fnd_api.g_ret_sts_success;

Line 388: x_return_status := fnd_api.g_ret_sts_success;

384: if fnd_api.to_boolean( p_init_msg_list ) then
385: fnd_msg_pub.initialize;
386: end if;
387: --
388: x_return_status := fnd_api.g_ret_sts_success;
389: --
390: if (p_old_inv_category <> p_new_inv_category) or
391: (p_old_inv_item <> p_new_inv_item) or
392: (p_old_inc_type <> p_new_inc_type) or

Line 402: , p_commit => fnd_api.g_false

398: p_task_template_search_rec.problem_code := p_new_prob_code;
399: --
400: cs_autogen_task_pvt.get_task_template_group( p_api_version => 1.0
401: , p_init_msg_list => 'T'
402: , p_commit => fnd_api.g_false
403: , p_validation_level => fnd_api.g_valid_level_full
404: , p_task_template_search_rec => p_task_template_search_rec
405: , x_task_template_group_tbl => l_task_template_group_tbl
406: , x_return_status => x_return_status

Line 403: , p_validation_level => fnd_api.g_valid_level_full

399: --
400: cs_autogen_task_pvt.get_task_template_group( p_api_version => 1.0
401: , p_init_msg_list => 'T'
402: , p_commit => fnd_api.g_false
403: , p_validation_level => fnd_api.g_valid_level_full
404: , p_task_template_search_rec => p_task_template_search_rec
405: , x_task_template_group_tbl => l_task_template_group_tbl
406: , x_return_status => x_return_status
407: , x_msg_count => x_msg_count

Line 411: if (x_return_status = fnd_api.g_ret_sts_error) then

407: , x_msg_count => x_msg_count
408: , x_msg_data => x_msg_data
409: );
410: --
411: if (x_return_status = fnd_api.g_ret_sts_error) then
412: raise fnd_api.g_exc_error;
413: elsif (x_return_status = fnd_api.g_ret_sts_unexp_error) then
414: raise fnd_api.g_exc_unexpected_error;
415: elsif (x_return_status = fnd_api.g_ret_sts_success) then

Line 412: raise fnd_api.g_exc_error;

408: , x_msg_data => x_msg_data
409: );
410: --
411: if (x_return_status = fnd_api.g_ret_sts_error) then
412: raise fnd_api.g_exc_error;
413: elsif (x_return_status = fnd_api.g_ret_sts_unexp_error) then
414: raise fnd_api.g_exc_unexpected_error;
415: elsif (x_return_status = fnd_api.g_ret_sts_success) then
416: --

Line 413: elsif (x_return_status = fnd_api.g_ret_sts_unexp_error) then

409: );
410: --
411: if (x_return_status = fnd_api.g_ret_sts_error) then
412: raise fnd_api.g_exc_error;
413: elsif (x_return_status = fnd_api.g_ret_sts_unexp_error) then
414: raise fnd_api.g_exc_unexpected_error;
415: elsif (x_return_status = fnd_api.g_ret_sts_success) then
416: --
417: if l_task_template_group_tbl.count > 1 then

Line 414: raise fnd_api.g_exc_unexpected_error;

410: --
411: if (x_return_status = fnd_api.g_ret_sts_error) then
412: raise fnd_api.g_exc_error;
413: elsif (x_return_status = fnd_api.g_ret_sts_unexp_error) then
414: raise fnd_api.g_exc_unexpected_error;
415: elsif (x_return_status = fnd_api.g_ret_sts_success) then
416: --
417: if l_task_template_group_tbl.count > 1 then
418: --

Line 415: elsif (x_return_status = fnd_api.g_ret_sts_success) then

411: if (x_return_status = fnd_api.g_ret_sts_error) then
412: raise fnd_api.g_exc_error;
413: elsif (x_return_status = fnd_api.g_ret_sts_unexp_error) then
414: raise fnd_api.g_exc_unexpected_error;
415: elsif (x_return_status = fnd_api.g_ret_sts_success) then
416: --
417: if l_task_template_group_tbl.count > 1 then
418: --
419: for i in l_task_template_group_tbl.first..l_task_template_group_tbl.last loop

Line 477: when fnd_api.g_exc_error then

473:
474: --
475: exception
476: --
477: when fnd_api.g_exc_error then
478: --
479: x_return_status := fnd_api.g_ret_sts_success;
480: if fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_success ) then
481: fnd_message.set_name('CS', 'CS_SR_TASK_TEMP_GRP_API_ERROR');

Line 479: x_return_status := fnd_api.g_ret_sts_success;

475: exception
476: --
477: when fnd_api.g_exc_error then
478: --
479: x_return_status := fnd_api.g_ret_sts_success;
480: if fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_success ) then
481: fnd_message.set_name('CS', 'CS_SR_TASK_TEMP_GRP_API_ERROR');
482: fnd_msg_pub.add_detail(p_message_type => fnd_msg_pub.G_WARNING_MSG);
483: end if;

Line 489: when fnd_api.g_exc_unexpected_error then

485: fnd_msg_pub.count_and_get
486: ( p_count => x_msg_count
487: , p_data => x_msg_data
488: );
489: when fnd_api.g_exc_unexpected_error then
490: --
491: x_return_status := fnd_api.g_ret_sts_success;
492: if fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_success ) then
493: fnd_message.set_name('CS', 'CS_SR_TASK_TEMP_GRP_API_ERROR');

Line 491: x_return_status := fnd_api.g_ret_sts_success;

487: , p_data => x_msg_data
488: );
489: when fnd_api.g_exc_unexpected_error then
490: --
491: x_return_status := fnd_api.g_ret_sts_success;
492: if fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_success ) then
493: fnd_message.set_name('CS', 'CS_SR_TASK_TEMP_GRP_API_ERROR');
494: fnd_msg_pub.add_detail(p_message_type => fnd_msg_pub.G_WARNING_MSG);
495: end if;

Line 511: x_return_status := fnd_api.g_ret_sts_success;

507: if c_task_temp_grp_name%isopen then
508: close c_task_temp_grp_name;
509: end if;
510: --
511: x_return_status := fnd_api.g_ret_sts_success;
512: if fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_success ) then
513: fnd_message.set_name('CS', 'CS_SR_TASK_TEMP_GRP_API_ERROR');
514: fnd_msg_pub.add_detail(p_message_type => fnd_msg_pub.G_WARNING_MSG);
515: end if;

Line 537: , p_get_contact in varchar2 default fnd_api.g_false

533: , p_inc_type_id in number default fnd_profile.value('INC_DEFAULT_INCIDENT_TYPE')
534: , p_severity_id in number default fnd_profile.value('INC_DEFAULT_INCIDENT_SEVERITY')
535: , p_request_date in date default sysdate
536: , p_timezone_id in number default fnd_profile.value('SERVER_TIMEZONE_ID')
537: , p_get_contact in varchar2 default fnd_api.g_false
538: , x_contact_id out nocopy number
539: , x_contact_type out nocopy varchar2
540: , x_contract_id out nocopy number
541: , x_contract_number out nocopy varchar2

Line 594: if p_get_contact = fnd_api.g_true then

590: and subject_id = l_subject_id;
591: --
592: begin
593: --
594: if p_get_contact = fnd_api.g_true then
595: --
596: for r_contact in c_contact
597: --
598: loop

Line 650: if x_return_status = fnd_api.g_ret_sts_success then

646: , x_msg_data
647: , x_ent_contracts
648: );
649: --
650: if x_return_status = fnd_api.g_ret_sts_success then
651: --
652: if x_ent_contracts.count > 0 then
653: x_contract_id := x_ent_contracts(1).contract_id;
654: x_contract_number := x_ent_contracts(1).contract_number;

Line 673: raise fnd_api.g_exc_error;

669: --
670: end if;
671: --
672: else
673: raise fnd_api.g_exc_error;
674: end if;
675: --
676: --
677: exception

Line 679: when fnd_api.g_exc_error then

675: --
676: --
677: exception
678: --
679: when fnd_api.g_exc_error then
680: null;
681: --
682: when others then
683: --

Line 968: RAISE fnd_api.g_exc_error;

964: (
965: p_count => x_msg_count,
966: p_data => x_msg_data
967: );
968: RAISE fnd_api.g_exc_error;
969: END;
970:
971:
972: Exception

Line 974: WHEN fnd_api.g_exc_error THEN

970:
971:
972: Exception
973:
974: WHEN fnd_api.g_exc_error THEN
975: x_return_status := 'E';
976: fnd_msg_pub.Count_and_Get
977: (
978: p_count => x_msg_count,

Line 982: WHEN fnd_api.g_exc_unexpected_error THEN

978: p_count => x_msg_count,
979: p_data => x_msg_data
980: );
981:
982: WHEN fnd_api.g_exc_unexpected_error THEN
983: x_return_status := 'U';
984: fnd_msg_pub.Count_and_Get
985: (
986: p_count => x_msg_count,

Line 1071: RAISE fnd_api.g_exc_error;

1067: (
1068: p_count => x_msg_count,
1069: p_data => x_msg_data
1070: );
1071: RAISE fnd_api.g_exc_error;
1072: END;
1073:
1074: -- If the return status is Success or if the OUT param l_uwqm_workitem_data
1075: -- has values. Then retrieve the first row and get the incident_id

Line 1101: WHEN fnd_api.g_exc_error THEN

1097: end if;
1098:
1099: Exception
1100:
1101: WHEN fnd_api.g_exc_error THEN
1102: x_return_status := 'E';
1103: fnd_msg_pub.Count_and_Get
1104: (
1105: p_count => x_msg_count,

Line 1109: WHEN fnd_api.g_exc_unexpected_error THEN

1105: p_count => x_msg_count,
1106: p_data => x_msg_data
1107: );
1108:
1109: WHEN fnd_api.g_exc_unexpected_error THEN
1110: x_return_status := 'U';
1111: fnd_msg_pub.Count_and_Get
1112: (
1113: p_count => x_msg_count,