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

Line 42: p_init_msg_list => FND_API.g_false,

38: CLOSE c_resource ;
39: -- Note API to Update Approval Notes
40: AMS_ObjectAttribute_PVT.modify_object_attribute(
41: p_api_version => 1.0,
42: p_init_msg_list => FND_API.g_false,
43: p_commit => FND_API.g_false,
44: p_validation_level => FND_API.g_valid_level_full,
45: x_return_status => x_return_status,
46: x_msg_count => x_msg_count,

Line 43: p_commit => FND_API.g_false,

39: -- Note API to Update Approval Notes
40: AMS_ObjectAttribute_PVT.modify_object_attribute(
41: p_api_version => 1.0,
42: p_init_msg_list => FND_API.g_false,
43: p_commit => FND_API.g_false,
44: p_validation_level => FND_API.g_valid_level_full,
45: x_return_status => x_return_status,
46: x_msg_count => x_msg_count,
47: x_msg_data => x_msg_data,

Line 44: p_validation_level => FND_API.g_valid_level_full,

40: AMS_ObjectAttribute_PVT.modify_object_attribute(
41: p_api_version => 1.0,
42: p_init_msg_list => FND_API.g_false,
43: p_commit => FND_API.g_false,
44: p_validation_level => FND_API.g_valid_level_full,
45: x_return_status => x_return_status,
46: x_msg_count => x_msg_count,
47: x_msg_data => x_msg_data,
48: p_object_type => p_activity_type,

Line 53: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

49: p_object_id => p_activity_id ,
50: p_attr => 'NOTE',
51: p_attr_defined_flag => 'Y'
52: );
53: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
54: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
55: FND_MESSAGE.Set_Token('ROW', sqlerrm );
56: FND_MSG_PUB.Add;
57: END IF;

Line 75: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

71: x_jtf_note_id => l_id ,
72: p_note_type => 'AMS_APPROVAL' ,
73: p_last_update_date => SYSDATE ,
74: p_creation_date => SYSDATE ) ;
75: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
76: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
77: FND_MESSAGE.Set_Token('ROW', sqlerrm );
78: FND_MSG_PUB.Add;
79: END IF;

Line 106: x_return_status := FND_API.G_RET_STS_SUCCESS;

102: FROM ams_jtf_rs_emp_v
103: WHERE resource_id = p_user_id ;
104: l_person_id number;
105: BEGIN
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107: OPEN c_resource ;
108: FETCH c_resource INTO l_person_id ;
109: IF c_resource%NOTFOUND THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107: OPEN c_resource ;
108: FETCH c_resource INTO l_person_id ;
109: IF c_resource%NOTFOUND THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');
112: FND_MSG_PUB.Add;
113: END IF;
114: CLOSE c_resource ;

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: p_orig_system_id => l_person_id ,
119: p_name => x_role_name,
120: p_display_name => x_role_display_name );
121: IF x_role_name is null then
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
124: FND_MSG_PUB.Add;
125: END IF;
126: END Get_User_Role;

Line 136: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

132: x_resource_disp_name OUT NOCOPY VARCHAR2,
133: x_return_status OUT NOCOPY VARCHAR2)
134:
135: IS
136: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
137: l_email VARCHAR2(360);
138: l_notif_pref VARCHAR2(30);
139: l_language VARCHAR2(30);
140: l_territory VARCHAR2(30);

Line 161: l_return_status := Fnd_Api.G_RET_STS_ERROR;

157:
158: OPEN c_res_details(p_responder);
159: FETCH c_res_details INTO x_resource_id;
160: IF c_res_details%NOTFOUND THEN
161: l_return_status := Fnd_Api.G_RET_STS_ERROR;
162: END IF;
163: CLOSE c_res_details;
164:
165: x_return_status := l_return_status;

Line 194: x_required_flag := FND_API.G_FALSE;

190: OPEN c_check_app;
191: FETCH c_check_app
192: INTO x_next_seq;
193: IF c_check_app%NOTFOUND THEN
194: x_required_flag := FND_API.G_FALSE;
195: ELSE
196: x_required_flag := FND_API.G_TRUE;
197: END IF;
198: CLOSE c_check_app;

Line 196: x_required_flag := FND_API.G_TRUE;

192: INTO x_next_seq;
193: IF c_check_app%NOTFOUND THEN
194: x_required_flag := FND_API.G_FALSE;
195: ELSE
196: x_required_flag := FND_API.G_TRUE;
197: END IF;
198: CLOSE c_check_app;
199: END Check_Approval_Required;
200:

Line 305: x_return_status := FND_API.G_RET_STS_SUCCESS;

301: FROM ams_object_rules_b
302: WHERE OBJECT_RULE_ID = id_in;
303:
304: BEGIN
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306: OPEN c_approver_info;
307: FETCH c_approver_info
308: INTO x_approver_id,
309: x_approver_type,

Line 322: x_return_status := FND_API.G_RET_STS_ERROR;

318: CLOSE c_rule_name;
319: Fnd_Message.Set_Name('AMS','AMS_NO_APPR_FOR_RULE');
320: Fnd_Message.Set_Token('RULE_NAME',l_rule_name);
321: FND_MSG_PUB.Add;
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: return;
324: END IF;
325:
326: /*

Line 335: x_return_status := FND_API.G_RET_STS_ERROR;

331: CLOSE c_API_Name;
332: --dbms_output.put_line('In Role Check 2');
333: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_API_NAME');
334: FND_MSG_PUB.Add;
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: return;
337: END IF;
338: CLOSE c_API_Name;
339: dml_str := 'BEGIN ' || l_pkg_name||'.'||l_proc_name||'(:x_approver_id,:x_approver_type,:x_msg_count, x_msg_data,:x_return_status); END;';

Line 341: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

337: END IF;
338: CLOSE c_API_Name;
339: dml_str := 'BEGIN ' || l_pkg_name||'.'||l_proc_name||'(:x_approver_id,:x_approver_type,:x_msg_count, x_msg_data,:x_return_status); END;';
340: EXECUTE IMMEDIATE dml_str USING OUT x_approver_id,OUT x_approver_type, OUT x_msg_count, OUT x_msg_data,OUT x_return_status;
341: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
342: FND_MESSAGE.Set_Name('AMS','AMS_APPR_FUNCTION_API_FAIL');
343: FND_MSG_PUB.Add;
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: return;

Line 344: x_return_status := FND_API.G_RET_STS_ERROR;

340: EXECUTE IMMEDIATE dml_str USING OUT x_approver_id,OUT x_approver_type, OUT x_msg_count, OUT x_msg_data,OUT x_return_status;
341: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
342: FND_MESSAGE.Set_Name('AMS','AMS_APPR_FUNCTION_API_FAIL');
343: FND_MSG_PUB.Add;
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: return;
346: END IF;
347: END IF;
348: */

Line 360: x_return_status := FND_API.G_RET_STS_ERROR;

356: CLOSE c_default_role_info ;
357: Fnd_Message.Set_Name('AMS','AMS_NO_DEFAULT_ROLE'); -- VMODUR added
358: --FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
359: FND_MSG_PUB.Add;
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: return;
362: END IF;
363: CLOSE c_default_role_info ;
364: end if;

Line 375: x_return_status := FND_API.G_RET_STS_ERROR;

371: --dbms_output.put_line('In Role Check 2');
372: Fnd_Message.Set_Name('AMS','AMS_MANY_DEFAULT_ROLE'); -- VMODUR added
373: --FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
374: FND_MSG_PUB.Add;
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: return;
377: END IF;
378: CLOSE c_role_info_count;
379: OPEN c_role_info;

Line 387: x_return_status := FND_API.G_RET_STS_ERROR;

383: CLOSE c_role_info;
384: --dbms_output.put_line('In Role Check 3');
385: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
386: FND_MSG_PUB.Add;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: return;
389: END IF;
390: CLOSE c_role_info;
391: END IF; --x_approval_type = ROLE;

Line 467: p_encoded => FND_API.G_FALSE,

463: WHILE l_cnt < p_msg_count
464: LOOP
465: FND_MSG_PUB.Get
466: (p_msg_index => l_cnt + 1,
467: p_encoded => FND_API.G_FALSE,
468: p_data => l_msg_data,
469: p_msg_index_out => l_msg_index ) ;
470: l_final_data := l_final_data ||l_msg_index||': '
471: ||l_msg_data||fnd_global.local_chr(10) ;

Line 539: l_amount NUMBER := 0; -- FND_API.G_MISS_NUM

535: x_approver_seq OUT NOCOPY NUMBER,
536: x_return_status OUT NOCOPY VARCHAR2)
537: IS
538:
539: l_amount NUMBER := 0; -- FND_API.G_MISS_NUM
540: l_business_unit_id NUMBER := -9999; -- FND_API.G_MISS_NUM
541: l_country_code VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
542: l_org_id NUMBER := -9999; -- FND_API.G_MISS_NUM
543: l_setup_type_id NUMBER := -9999; -- FND_API.G_MISS_NUM

Line 540: l_business_unit_id NUMBER := -9999; -- FND_API.G_MISS_NUM

536: x_return_status OUT NOCOPY VARCHAR2)
537: IS
538:
539: l_amount NUMBER := 0; -- FND_API.G_MISS_NUM
540: l_business_unit_id NUMBER := -9999; -- FND_API.G_MISS_NUM
541: l_country_code VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
542: l_org_id NUMBER := -9999; -- FND_API.G_MISS_NUM
543: l_setup_type_id NUMBER := -9999; -- FND_API.G_MISS_NUM
544: l_object_type VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR

Line 541: l_country_code VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR

537: IS
538:
539: l_amount NUMBER := 0; -- FND_API.G_MISS_NUM
540: l_business_unit_id NUMBER := -9999; -- FND_API.G_MISS_NUM
541: l_country_code VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
542: l_org_id NUMBER := -9999; -- FND_API.G_MISS_NUM
543: l_setup_type_id NUMBER := -9999; -- FND_API.G_MISS_NUM
544: l_object_type VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
545: l_priority VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR

Line 542: l_org_id NUMBER := -9999; -- FND_API.G_MISS_NUM

538:
539: l_amount NUMBER := 0; -- FND_API.G_MISS_NUM
540: l_business_unit_id NUMBER := -9999; -- FND_API.G_MISS_NUM
541: l_country_code VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
542: l_org_id NUMBER := -9999; -- FND_API.G_MISS_NUM
543: l_setup_type_id NUMBER := -9999; -- FND_API.G_MISS_NUM
544: l_object_type VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
545: l_priority VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
546: l_approver_id NUMBER;

Line 543: l_setup_type_id NUMBER := -9999; -- FND_API.G_MISS_NUM

539: l_amount NUMBER := 0; -- FND_API.G_MISS_NUM
540: l_business_unit_id NUMBER := -9999; -- FND_API.G_MISS_NUM
541: l_country_code VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
542: l_org_id NUMBER := -9999; -- FND_API.G_MISS_NUM
543: l_setup_type_id NUMBER := -9999; -- FND_API.G_MISS_NUM
544: l_object_type VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
545: l_priority VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
546: l_approver_id NUMBER;
547: l_object_details ObjRecTyp;

Line 544: l_object_type VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR

540: l_business_unit_id NUMBER := -9999; -- FND_API.G_MISS_NUM
541: l_country_code VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
542: l_org_id NUMBER := -9999; -- FND_API.G_MISS_NUM
543: l_setup_type_id NUMBER := -9999; -- FND_API.G_MISS_NUM
544: l_object_type VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
545: l_priority VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
546: l_approver_id NUMBER;
547: l_object_details ObjRecTyp;
548: l_activity_type VARCHAR2(30);

Line 545: l_priority VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR

541: l_country_code VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
542: l_org_id NUMBER := -9999; -- FND_API.G_MISS_NUM
543: l_setup_type_id NUMBER := -9999; -- FND_API.G_MISS_NUM
544: l_object_type VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
545: l_priority VARCHAR2(30) := '-9999'; -- FND_API.G_MISS_CHAR
546: l_approver_id NUMBER;
547: l_object_details ObjRecTyp;
548: l_activity_type VARCHAR2(30);
549: l_activity_id NUMBER;

Line 626: x_return_status := FND_API.G_RET_STS_SUCCESS;

622: WHERE ACTIVITY_BUDGET_ID = p_act_budget_id;
623: */
624: l_seeded_flag varchar2(1);
625: BEGIN
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627:
628: -- Start: Added for fixing the bug#6340621
629: IF (p_activity_type='FREQ') THEN
630:

Line 680: x_return_status := FND_API.G_RET_STS_ERROR;

676: IF c_approver_def%NOTFOUND THEN
677: CLOSE c_approver_def ;
678: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVAL_DETAIL_ID');
679: FND_MSG_PUB.Add;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: return;
682: END IF;
683: CLOSE c_approver_def ;
684: ELSE

Line 695: x_return_status := FND_API.G_RET_STS_ERROR;

691: CLOSE c_approver_seq;
692: IF l_seeded_flag = 'Y' THEN
693: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVER_SEQUENCE');
694: FND_MSG_PUB.Add;
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: return;
697: else
698: OPEN c_approver_def ;
699: FETCH c_approver_def INTO x_approval_detail_id, l_seeded_flag;

Line 704: x_return_status := FND_API.G_RET_STS_ERROR;

700: IF c_approver_def%NOTFOUND THEN
701: CLOSE c_approver_def ;
702: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVAL_DETAIL_ID');
703: FND_MSG_PUB.Add;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: return;
706: END IF;
707: CLOSE c_approver_def ;
708: OPEN c_approver_seq ;

Line 714: x_return_status := FND_API.G_RET_STS_ERROR;

710: IF c_approver_seq%NOTFOUND THEN
711: CLOSE c_approver_seq;
712: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVER_SEQUENCE');
713: FND_MSG_PUB.Add;
714: x_return_status := FND_API.G_RET_STS_ERROR;
715: return;
716: END IF;
717: END IF;
718: END IF;

Line 813: p_init_msg_list => FND_API.G_FALSE,

809: -- Delete any previous approval history
810:
811: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
812: p_api_version_number => 1.0,
813: p_init_msg_list => FND_API.G_FALSE,
814: p_commit => FND_API.G_FALSE,
815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
816: x_return_status => l_return_status,
817: x_msg_count => l_msg_count,

Line 814: p_commit => FND_API.G_FALSE,

810:
811: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
812: p_api_version_number => 1.0,
813: p_init_msg_list => FND_API.G_FALSE,
814: p_commit => FND_API.G_FALSE,
815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
816: x_return_status => l_return_status,
817: x_msg_count => l_msg_count,
818: x_msg_data => l_msg_data,

Line 815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

811: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
812: p_api_version_number => 1.0,
813: p_init_msg_list => FND_API.G_FALSE,
814: p_commit => FND_API.G_FALSE,
815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
816: x_return_status => l_return_status,
817: x_msg_count => l_msg_count,
818: x_msg_data => l_msg_data,
819: p_object_id => p_activity_id,

Line 826: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

822: p_action_code => null,
823: p_object_version_num => null,
824: p_approval_type => p_approval_type);
825:
826: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
827: RAISE Fnd_Api.G_EXC_ERROR;
828: END IF;
829:
830:

Line 827: RAISE Fnd_Api.G_EXC_ERROR;

823: p_object_version_num => null,
824: p_approval_type => p_approval_type);
825:
826: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
827: RAISE Fnd_Api.G_EXC_ERROR;
828: END IF;
829:
830:
831: AMS_Utility_PVT.debug_message('Start :Item Type : '||itemtype

Line 940: l_return_status := FND_API.G_RET_STS_SUCCESS;

936: itemkey => itemkey,
937: aname => 'AMS_REQUESTER_ID',
938: avalue => p_requester_userid );
939:
940: l_return_status := FND_API.G_RET_STS_SUCCESS;
941:
942:
943: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
944: itemkey => itemkey,

Line 954: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

950: x_role_name => l_requester_role,
951: x_role_display_name => l_display_name,
952: x_return_status => l_return_status);
953:
954: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
955: RAISE FND_API.G_EXC_ERROR;
956: END IF;
957:
958:

Line 955: RAISE FND_API.G_EXC_ERROR;

951: x_role_display_name => l_display_name,
952: x_return_status => l_return_status);
953:
954: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
955: RAISE FND_API.G_EXC_ERROR;
956: END IF;
957:
958:
959: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 995: p_init_msg_list => FND_API.G_FALSE,

991: l_appr_hist_rec.approver_type := 'USER'; -- User always submits
992: --
993: AMS_Appr_Hist_PVT.Create_Appr_Hist(
994: p_api_version_number => 1.0,
995: p_init_msg_list => FND_API.G_FALSE,
996: p_commit => FND_API.G_FALSE,
997: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
998: x_return_status => l_return_status,
999: x_msg_count => l_msg_count,

Line 996: p_commit => FND_API.G_FALSE,

992: --
993: AMS_Appr_Hist_PVT.Create_Appr_Hist(
994: p_api_version_number => 1.0,
995: p_init_msg_list => FND_API.G_FALSE,
996: p_commit => FND_API.G_FALSE,
997: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
998: x_return_status => l_return_status,
999: x_msg_count => l_msg_count,
1000: x_msg_data => l_msg_data,

Line 997: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

993: AMS_Appr_Hist_PVT.Create_Appr_Hist(
994: p_api_version_number => 1.0,
995: p_init_msg_list => FND_API.G_FALSE,
996: p_commit => FND_API.G_FALSE,
997: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
998: x_return_status => l_return_status,
999: x_msg_count => l_msg_count,
1000: x_msg_data => l_msg_data,
1001: p_appr_hist_rec => l_appr_hist_rec

Line 1004: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

1000: x_msg_data => l_msg_data,
1001: p_appr_hist_rec => l_appr_hist_rec
1002: );
1003:
1004: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1005: RAISE Fnd_Api.G_EXC_ERROR;
1006: END IF;
1007: -- wf_engine.threshold := l_save_threshold ;
1008: EXCEPTION

Line 1005: RAISE Fnd_Api.G_EXC_ERROR;

1001: p_appr_hist_rec => l_appr_hist_rec
1002: );
1003:
1004: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1005: RAISE Fnd_Api.G_EXC_ERROR;
1006: END IF;
1007: -- wf_engine.threshold := l_save_threshold ;
1008: EXCEPTION
1009:

Line 1010: WHEN FND_API.G_EXC_ERROR THEN

1006: END IF;
1007: -- wf_engine.threshold := l_save_threshold ;
1008: EXCEPTION
1009:
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: -- wf_engine.threshold := l_save_threshold ;
1012: FND_MSG_PUB.Count_And_Get (
1013: p_encoded => FND_API.G_FALSE,
1014: p_count => l_msg_count,

Line 1013: p_encoded => FND_API.G_FALSE,

1009:
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: -- wf_engine.threshold := l_save_threshold ;
1012: FND_MSG_PUB.Count_And_Get (
1013: p_encoded => FND_API.G_FALSE,
1014: p_count => l_msg_count,
1015: p_data => l_msg_data);
1016:
1017: Handle_Err

Line 1031: p_encoded => FND_API.G_FALSE,

1027: if(l_msg_count > 0)then
1028: for I in 1 .. l_msg_count LOOP
1029: fnd_msg_pub.Get
1030: (p_msg_index => FND_MSG_PUB.G_NEXT,
1031: p_encoded => FND_API.G_FALSE,
1032: p_data => l_msg_data,
1033: p_msg_index_out => l_index);
1034: dbms_output.put_line('message :'||l_msg_data);
1035: end loop;

Line 1044: p_encoded => FND_API.G_FALSE,

1040: RAISE;
1041: WHEN OTHERS THEN
1042: -- wf_engine.threshold := l_save_threshold ;
1043: FND_MSG_PUB.Count_And_Get (
1044: p_encoded => FND_API.G_FALSE,
1045: p_count => l_msg_count,
1046: p_data => l_msg_data);
1047:
1048:

Line 1053: p_encoded => FND_API.G_FALSE,

1049: if(l_msg_count > 0)then
1050: for I in 1 .. l_msg_count LOOP
1051: fnd_msg_pub.Get
1052: (p_msg_index => FND_MSG_PUB.G_NEXT,
1053: p_encoded => FND_API.G_FALSE,
1054: p_data => l_msg_data,
1055: p_msg_index_out => l_index);
1056: dbms_output.put_line('message :'||l_msg_data);
1057: end loop;

Line 1135: RAISE FND_API.G_EXC_ERROR;

1131: EXECUTE IMMEDIATE dml_str USING IN itemtype,IN itemkey,IN actid,IN funcmode, OUT resultout;
1132:
1133: -- [BEGIN OF BUG2540804 FIXING 08/29/2002 - mchnag]
1134: ELSE
1135: RAISE FND_API.G_EXC_ERROR;
1136: END IF;
1137:
1138: --resultout := 'COMPLETE:SUCCESS';
1139: -- [END OF BUG2540804 FIXING]

Line 1162: WHEN FND_API.G_EXC_ERROR THEN

1158: END IF;
1159: --
1160:
1161: EXCEPTION
1162: WHEN FND_API.G_EXC_ERROR THEN
1163: wf_core.context('ams_gen_approval_pvt','Set_Activity_Details',
1164: itemtype,itemkey,actid,funcmode,l_error_msg);
1165: raise;
1166: WHEN OTHERS THEN

Line 1168: p_encoded => FND_API.G_FALSE,

1164: itemtype,itemkey,actid,funcmode,l_error_msg);
1165: raise;
1166: WHEN OTHERS THEN
1167: FND_MSG_PUB.Count_And_Get (
1168: p_encoded => FND_API.G_FALSE,
1169: p_count => l_msg_count,
1170: p_data => l_msg_data
1171: );
1172: Handle_Err

Line 1326: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

1322: x_notification_type => l_notification_type,
1323: x_notification_timeout => l_notification_type,
1324: x_return_status => l_return_status);
1325:
1326: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1327: RAISE FND_API.G_EXC_ERROR;
1328: --RETURN;
1329: END IF;
1330:

Line 1327: RAISE FND_API.G_EXC_ERROR;

1323: x_notification_timeout => l_notification_type,
1324: x_return_status => l_return_status);
1325:
1326: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1327: RAISE FND_API.G_EXC_ERROR;
1328: --RETURN;
1329: END IF;
1330:
1331: -- Bug 2729108 Fix

Line 1357: p_init_msg_list => FND_API.G_FALSE,

1353: l_appr_hist_rec.approver_id := l_obj_appr_id;
1354:
1355: AMS_Appr_Hist_PVT.Create_Appr_Hist(
1356: p_api_version_number => 1.0,
1357: p_init_msg_list => FND_API.G_FALSE,
1358: p_commit => FND_API.G_FALSE,
1359: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1360: x_return_status => l_return_status,
1361: x_msg_count => l_msg_count,

Line 1358: p_commit => FND_API.G_FALSE,

1354:
1355: AMS_Appr_Hist_PVT.Create_Appr_Hist(
1356: p_api_version_number => 1.0,
1357: p_init_msg_list => FND_API.G_FALSE,
1358: p_commit => FND_API.G_FALSE,
1359: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1360: x_return_status => l_return_status,
1361: x_msg_count => l_msg_count,
1362: x_msg_data => l_msg_data,

Line 1359: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1355: AMS_Appr_Hist_PVT.Create_Appr_Hist(
1356: p_api_version_number => 1.0,
1357: p_init_msg_list => FND_API.G_FALSE,
1358: p_commit => FND_API.G_FALSE,
1359: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1360: x_return_status => l_return_status,
1361: x_msg_count => l_msg_count,
1362: x_msg_data => l_msg_data,
1363: p_appr_hist_rec => l_appr_hist_rec

Line 1366: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

1362: x_msg_data => l_msg_data,
1363: p_appr_hist_rec => l_appr_hist_rec
1364: );
1365:
1366: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1367: RAISE FND_API.G_EXC_ERROR;
1368: END IF;
1369:
1370: END LOOP;

Line 1367: RAISE FND_API.G_EXC_ERROR;

1363: p_appr_hist_rec => l_appr_hist_rec
1364: );
1365:
1366: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1367: RAISE FND_API.G_EXC_ERROR;
1368: END IF;
1369:
1370: END LOOP;
1371: CLOSE c_approver;

Line 1374: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1370: END LOOP;
1371: CLOSE c_approver;
1372: END IF;
1373:
1374: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1375: IF (l_approver_type = 'FUNCTION') THEN
1376: open c_API_Name(l_object_approver_id);
1377: fetch c_API_Name into l_pkg_name, l_proc_name;
1378: IF (c_Api_Name%FOUND) THEN

Line 1390: RAISE FND_API.G_EXC_ERROR;

1386: END IF;
1387: close c_API_Name;
1388: END IF;
1389: ELSE
1390: RAISE FND_API.G_EXC_ERROR;
1391: END IF;
1392:
1393:
1394: Get_User_Role(p_user_id => l_object_approver_id ,

Line 1399: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1395: x_role_name => l_approver,
1396: x_role_display_name => l_approver_display_name,
1397: x_return_status => l_return_status);
1398:
1399: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: -- Change for Bug 2535600
1403: l_prev_approver_disp_name := wf_engine.GetItemAttrText(

Line 1400: RAISE FND_API.G_EXC_ERROR;

1396: x_role_display_name => l_approver_display_name,
1397: x_return_status => l_return_status);
1398:
1399: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: -- Change for Bug 2535600
1403: l_prev_approver_disp_name := wf_engine.GetItemAttrText(
1404: itemtype => itemtype,

Line 1460: p_init_msg_list => FND_API.G_FALSE,

1456: l_appr_hist_rec.approver_id := l_object_approver_id;
1457:
1458: AMS_Appr_Hist_PVT.Update_Appr_Hist(
1459: p_api_version_number => 1.0,
1460: p_init_msg_list => FND_API.G_FALSE,
1461: p_commit => FND_API.G_FALSE,
1462: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1463: x_return_status => l_return_status,
1464: x_msg_count => l_msg_count,

Line 1461: p_commit => FND_API.G_FALSE,

1457:
1458: AMS_Appr_Hist_PVT.Update_Appr_Hist(
1459: p_api_version_number => 1.0,
1460: p_init_msg_list => FND_API.G_FALSE,
1461: p_commit => FND_API.G_FALSE,
1462: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1463: x_return_status => l_return_status,
1464: x_msg_count => l_msg_count,
1465: x_msg_data => l_msg_data,

Line 1462: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1458: AMS_Appr_Hist_PVT.Update_Appr_Hist(
1459: p_api_version_number => 1.0,
1460: p_init_msg_list => FND_API.G_FALSE,
1461: p_commit => FND_API.G_FALSE,
1462: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1463: x_return_status => l_return_status,
1464: x_msg_count => l_msg_count,
1465: x_msg_data => l_msg_data,
1466: p_appr_hist_rec => l_appr_hist_rec

Line 1469: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

1465: x_msg_data => l_msg_data,
1466: p_appr_hist_rec => l_appr_hist_rec
1467: );
1468:
1469: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1470: RAISE Fnd_Api.G_EXC_ERROR;
1471: END IF;
1472:
1473: resultout := 'COMPLETE:SUCCESS';

Line 1470: RAISE Fnd_Api.G_EXC_ERROR;

1466: p_appr_hist_rec => l_appr_hist_rec
1467: );
1468:
1469: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1470: RAISE Fnd_Api.G_EXC_ERROR;
1471: END IF;
1472:
1473: resultout := 'COMPLETE:SUCCESS';
1474: END IF;

Line 1493: WHEN FND_API.G_EXC_ERROR THEN

1489: return;
1490: END IF;
1491:
1492: EXCEPTION
1493: WHEN FND_API.G_EXC_ERROR THEN
1494: FND_MSG_PUB.Count_And_Get (
1495: p_encoded => FND_API.G_FALSE,
1496: p_count => l_msg_count,
1497: p_data => l_msg_data

Line 1495: p_encoded => FND_API.G_FALSE,

1491:
1492: EXCEPTION
1493: WHEN FND_API.G_EXC_ERROR THEN
1494: FND_MSG_PUB.Count_And_Get (
1495: p_encoded => FND_API.G_FALSE,
1496: p_count => l_msg_count,
1497: p_data => l_msg_data
1498: );
1499: Handle_Err

Line 1514: p_encoded => FND_API.G_FALSE,

1510: resultout := 'COMPLETE:ERROR';
1511: --RAISE;
1512: WHEN OTHERS THEN
1513: FND_MSG_PUB.Count_And_Get (
1514: p_encoded => FND_API.G_FALSE,
1515: p_count => l_msg_count,
1516: p_data => l_msg_data
1517: );
1518: Handle_Err

Line 1633: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

1629: x_resource_id => l_approver_id,
1630: x_resource_disp_name => l_appr_display_name,
1631: x_return_status => l_return_status);
1632:
1633: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1634: RAISE Fnd_Api.G_EXC_ERROR;
1635: END IF;
1636:
1637: -- Set the WF Attributes

Line 1634: RAISE Fnd_Api.G_EXC_ERROR;

1630: x_resource_disp_name => l_appr_display_name,
1631: x_return_status => l_return_status);
1632:
1633: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1634: RAISE Fnd_Api.G_EXC_ERROR;
1635: END IF;
1636:
1637: -- Set the WF Attributes
1638: wf_engine.SetItemAttrText( itemtype => itemtype,

Line 1678: p_init_msg_list => FND_API.G_FALSE,

1674: l_appr_hist_rec.action_date := sysdate;
1675:
1676: AMS_Appr_Hist_PVT.Update_Appr_Hist(
1677: p_api_version_number => 1.0,
1678: p_init_msg_list => FND_API.G_FALSE,
1679: p_commit => FND_API.G_FALSE,
1680: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1681: x_return_status => l_return_status,
1682: x_msg_count => l_msg_count,

Line 1679: p_commit => FND_API.G_FALSE,

1675:
1676: AMS_Appr_Hist_PVT.Update_Appr_Hist(
1677: p_api_version_number => 1.0,
1678: p_init_msg_list => FND_API.G_FALSE,
1679: p_commit => FND_API.G_FALSE,
1680: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1681: x_return_status => l_return_status,
1682: x_msg_count => l_msg_count,
1683: x_msg_data => l_msg_data,

Line 1680: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1676: AMS_Appr_Hist_PVT.Update_Appr_Hist(
1677: p_api_version_number => 1.0,
1678: p_init_msg_list => FND_API.G_FALSE,
1679: p_commit => FND_API.G_FALSE,
1680: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1681: x_return_status => l_return_status,
1682: x_msg_count => l_msg_count,
1683: x_msg_data => l_msg_data,
1684: p_appr_hist_rec => l_appr_hist_rec

Line 1687: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

1683: x_msg_data => l_msg_data,
1684: p_appr_hist_rec => l_appr_hist_rec
1685: );
1686:
1687: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1688: RAISE Fnd_Api.G_EXC_ERROR;
1689: END IF;
1690:
1691: Check_Approval_Required

Line 1688: RAISE Fnd_Api.G_EXC_ERROR;

1684: p_appr_hist_rec => l_appr_hist_rec
1685: );
1686:
1687: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1688: RAISE Fnd_Api.G_EXC_ERROR;
1689: END IF;
1690:
1691: Check_Approval_Required
1692: ( p_approval_detail_id => l_approval_detail_id,

Line 1723: WHEN FND_API.G_EXC_ERROR THEN

1719: resultout := 'COMPLETE:';
1720: return;
1721: END IF;
1722: EXCEPTION
1723: WHEN FND_API.G_EXC_ERROR THEN
1724: FND_MSG_PUB.Count_And_Get (
1725: p_encoded => FND_API.G_FALSE,
1726: p_count => l_msg_count,
1727: p_data => l_msg_data

Line 1725: p_encoded => FND_API.G_FALSE,

1721: END IF;
1722: EXCEPTION
1723: WHEN FND_API.G_EXC_ERROR THEN
1724: FND_MSG_PUB.Count_And_Get (
1725: p_encoded => FND_API.G_FALSE,
1726: p_count => l_msg_count,
1727: p_data => l_msg_data
1728: );
1729: Handle_Err

Line 1743: p_encoded => FND_API.G_FALSE,

1739: itemtype, itemkey,to_char(actid),l_error_msg);
1740: RAISE;
1741: WHEN OTHERS THEN
1742: FND_MSG_PUB.Count_And_Get (
1743: p_encoded => FND_API.G_FALSE,
1744: p_count => l_msg_count,
1745: p_data => l_msg_data
1746: );
1747: Handle_Err

Line 1841: p_encoded => FND_API.G_FALSE,

1837:
1838: IF resultout = 'COMPLETE:ERROR' then -- added VMODUR 10-Jun-2002
1839:
1840: FND_MSG_PUB.Count_And_Get (
1841: p_encoded => FND_API.G_FALSE,
1842: p_count => l_msg_count,
1843: p_data => l_msg_data
1844: );
1845: Handle_Err

Line 1857: p_init_msg_list => FND_API.G_FALSE,

1853: ELSE
1854: -- Delete all rows
1855: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
1856: p_api_version_number => 1.0,
1857: p_init_msg_list => FND_API.G_FALSE,
1858: p_commit => FND_API.G_FALSE,
1859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1860: x_return_status => l_return_status,
1861: x_msg_count => l_msg_count,

Line 1858: p_commit => FND_API.G_FALSE,

1854: -- Delete all rows
1855: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
1856: p_api_version_number => 1.0,
1857: p_init_msg_list => FND_API.G_FALSE,
1858: p_commit => FND_API.G_FALSE,
1859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1860: x_return_status => l_return_status,
1861: x_msg_count => l_msg_count,
1862: x_msg_data => l_msg_data,

Line 1859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1855: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
1856: p_api_version_number => 1.0,
1857: p_init_msg_list => FND_API.G_FALSE,
1858: p_commit => FND_API.G_FALSE,
1859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1860: x_return_status => l_return_status,
1861: x_msg_count => l_msg_count,
1862: x_msg_data => l_msg_data,
1863: p_object_id => l_activity_id,

Line 1870: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

1866: p_action_code => null,
1867: p_object_version_num => l_version,
1868: p_approval_type => l_approval_type);
1869:
1870: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1871: RAISE Fnd_Api.G_EXC_ERROR;
1872: END IF;
1873:
1874: END IF; -- VM

Line 1871: RAISE Fnd_Api.G_EXC_ERROR;

1867: p_object_version_num => l_version,
1868: p_approval_type => l_approval_type);
1869:
1870: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1871: RAISE Fnd_Api.G_EXC_ERROR;
1872: END IF;
1873:
1874: END IF; -- VM
1875:

Line 1897: WHEN FND_API.G_EXC_ERROR THEN

1893: END IF;
1894: --
1895:
1896: EXCEPTION
1897: WHEN FND_API.G_EXC_ERROR THEN
1898: FND_MSG_PUB.Count_And_Get (
1899: p_encoded => FND_API.G_FALSE,
1900: p_count => l_msg_count,
1901: p_data => l_msg_data

Line 1899: p_encoded => FND_API.G_FALSE,

1895:
1896: EXCEPTION
1897: WHEN FND_API.G_EXC_ERROR THEN
1898: FND_MSG_PUB.Count_And_Get (
1899: p_encoded => FND_API.G_FALSE,
1900: p_count => l_msg_count,
1901: p_data => l_msg_data
1902: );
1903: Handle_Err

Line 1918: p_encoded => FND_API.G_FALSE,

1914: resultout := 'COMPLETE:ERROR';
1915: --RAISE;
1916: WHEN OTHERS THEN
1917: FND_MSG_PUB.Count_And_Get (
1918: p_encoded => FND_API.G_FALSE,
1919: p_count => l_msg_count,
1920: p_data => l_msg_data
1921: );
1922: Handle_Err

Line 2064: p_encoded => FND_API.G_FALSE,

2060: /*
2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: FND_MSG_PUB.Count_And_Get (
2064: p_encoded => FND_API.G_FALSE,
2065: p_count => l_msg_count,
2066: p_data => l_msg_data
2067: );
2068: Handle_Err

Line 2132: p_encoded => FND_API.G_FALSE,

2128: /*
2129: EXCEPTION
2130: WHEN OTHERS THEN
2131: FND_MSG_PUB.Count_And_Get (
2132: p_encoded => FND_API.G_FALSE,
2133: p_count => l_msg_count,
2134: p_data => l_msg_data
2135: );
2136: Handle_Err

Line 2202: p_encoded => FND_API.G_FALSE,

2198: /*
2199: EXCEPTION
2200: WHEN OTHERS THEN
2201: FND_MSG_PUB.Count_And_Get (
2202: p_encoded => FND_API.G_FALSE,
2203: p_count => l_msg_count,
2204: p_data => l_msg_data
2205: );
2206: Handle_Err

Line 2271: p_encoded => FND_API.G_FALSE,

2267: /*
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: FND_MSG_PUB.Count_And_Get (
2271: p_encoded => FND_API.G_FALSE,
2272: p_count => l_msg_count,
2273: p_data => l_msg_data
2274: );
2275: Handle_Err

Line 2339: p_encoded => FND_API.G_FALSE,

2335: /*
2336: EXCEPTION
2337: WHEN OTHERS THEN
2338: FND_MSG_PUB.Count_And_Get (
2339: p_encoded => FND_API.G_FALSE,
2340: p_count => l_msg_count,
2341: p_data => l_msg_data
2342: );
2343: Handle_Err

Line 2609: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

2605: x_resource_id => l_approver_id,
2606: x_resource_disp_name => l_appr_display_name,
2607: x_return_status => l_return_status);
2608:
2609: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
2610: RAISE Fnd_Api.G_EXC_ERROR;
2611: END IF;
2612:
2613: -- Set the WF Attributes

Line 2610: RAISE Fnd_Api.G_EXC_ERROR;

2606: x_resource_disp_name => l_appr_display_name,
2607: x_return_status => l_return_status);
2608:
2609: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
2610: RAISE Fnd_Api.G_EXC_ERROR;
2611: END IF;
2612:
2613: -- Set the WF Attributes
2614: wf_engine.SetItemAttrText( itemtype => itemtype,

Line 2657: p_init_msg_list => FND_API.G_FALSE,

2653: l_appr_hist_rec.approver_id := l_approver_id;
2654:
2655: AMS_Appr_Hist_PVT.Update_Appr_Hist(
2656: p_api_version_number => 1.0,
2657: p_init_msg_list => FND_API.G_FALSE,
2658: p_commit => FND_API.G_FALSE,
2659: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2660: x_return_status => l_return_status,
2661: x_msg_count => l_msg_count,

Line 2658: p_commit => FND_API.G_FALSE,

2654:
2655: AMS_Appr_Hist_PVT.Update_Appr_Hist(
2656: p_api_version_number => 1.0,
2657: p_init_msg_list => FND_API.G_FALSE,
2658: p_commit => FND_API.G_FALSE,
2659: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2660: x_return_status => l_return_status,
2661: x_msg_count => l_msg_count,
2662: x_msg_data => l_msg_data,

Line 2659: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2655: AMS_Appr_Hist_PVT.Update_Appr_Hist(
2656: p_api_version_number => 1.0,
2657: p_init_msg_list => FND_API.G_FALSE,
2658: p_commit => FND_API.G_FALSE,
2659: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2660: x_return_status => l_return_status,
2661: x_msg_count => l_msg_count,
2662: x_msg_data => l_msg_data,
2663: p_appr_hist_rec => l_appr_hist_rec

Line 2666: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

2662: x_msg_data => l_msg_data,
2663: p_appr_hist_rec => l_appr_hist_rec
2664: );
2665:
2666: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
2667: RAISE Fnd_Api.G_EXC_ERROR;
2668: END IF;
2669:
2670: -- Delete any 'OPEN' rows

Line 2667: RAISE Fnd_Api.G_EXC_ERROR;

2663: p_appr_hist_rec => l_appr_hist_rec
2664: );
2665:
2666: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
2667: RAISE Fnd_Api.G_EXC_ERROR;
2668: END IF;
2669:
2670: -- Delete any 'OPEN' rows
2671: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

Line 2673: p_init_msg_list => FND_API.G_FALSE,

2669:
2670: -- Delete any 'OPEN' rows
2671: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
2672: p_api_version_number => 1.0,
2673: p_init_msg_list => FND_API.G_FALSE,
2674: p_commit => FND_API.G_FALSE,
2675: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2676: x_return_status => l_return_status,
2677: x_msg_count => l_msg_count,

Line 2674: p_commit => FND_API.G_FALSE,

2670: -- Delete any 'OPEN' rows
2671: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
2672: p_api_version_number => 1.0,
2673: p_init_msg_list => FND_API.G_FALSE,
2674: p_commit => FND_API.G_FALSE,
2675: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2676: x_return_status => l_return_status,
2677: x_msg_count => l_msg_count,
2678: x_msg_data => l_msg_data,

Line 2675: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2671: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
2672: p_api_version_number => 1.0,
2673: p_init_msg_list => FND_API.G_FALSE,
2674: p_commit => FND_API.G_FALSE,
2675: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2676: x_return_status => l_return_status,
2677: x_msg_count => l_msg_count,
2678: x_msg_data => l_msg_data,
2679: p_object_id => l_activity_id,

Line 2686: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

2682: p_action_code => 'OPEN',
2683: p_object_version_num => l_version,
2684: p_approval_type => l_approval_type);
2685:
2686: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
2687: RAISE Fnd_Api.G_EXC_ERROR;
2688: END IF;
2689:
2690: -- This needs to be last as it would change version number

Line 2687: RAISE Fnd_Api.G_EXC_ERROR;

2683: p_object_version_num => l_version,
2684: p_approval_type => l_approval_type);
2685:
2686: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
2687: RAISE Fnd_Api.G_EXC_ERROR;
2688: END IF;
2689:
2690: -- This needs to be last as it would change version number
2691: Update_Status(itemtype => itemtype,

Line 2698: WHEN FND_API.G_EXC_ERROR THEN

2694: funcmode => funcmode,
2695: resultout => resultout);
2696:
2697: EXCEPTION
2698: WHEN FND_API.G_EXC_ERROR THEN
2699: FND_MSG_PUB.Count_And_Get (
2700: p_encoded => FND_API.G_FALSE,
2701: p_count => l_msg_count,
2702: p_data => l_msg_data

Line 2700: p_encoded => FND_API.G_FALSE,

2696:
2697: EXCEPTION
2698: WHEN FND_API.G_EXC_ERROR THEN
2699: FND_MSG_PUB.Count_And_Get (
2700: p_encoded => FND_API.G_FALSE,
2701: p_count => l_msg_count,
2702: p_data => l_msg_data
2703: );
2704: Handle_Err

Line 2719: p_encoded => FND_API.G_FALSE,

2715: resultout := 'COMPLETE:ERROR';
2716: --RAISE;
2717: WHEN OTHERS THEN
2718: FND_MSG_PUB.Count_And_Get (
2719: p_encoded => FND_API.G_FALSE,
2720: p_count => l_msg_count,
2721: p_data => l_msg_data
2722: );
2723: Handle_Err

Line 2909: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2905: l_msg_data VARCHAR2(4000);
2906: l_error_msg VARCHAR2(4000);
2907:
2908: BEGIN
2909: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2910: IF p_activity_type = 'PRIC' THEN
2911:
2912: OPEN l_obj_details FOR
2913: SELECT name -- name

Line 3001: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2997: ELSE
2998: -- add exception
2999: Fnd_Message.Set_Name('AMS','AMS_BAD_APPROVAL_OBJECT_TYPE');
3000: Fnd_Msg_Pub.ADD;
3001: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3002: END IF ;
3003:
3004: -- check here
3005: FETCH l_obj_details INTO x_object_details;

Line 3010: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3006: IF l_obj_details%NOTFOUND THEN
3007: CLOSE l_obj_details;
3008: Fnd_Message.Set_Name('AMS','AMS_APPR_BAD_DETAILS');
3009: Fnd_Msg_Pub.ADD;
3010: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3011: RETURN;
3012: END IF;
3013: CLOSE l_obj_details;
3014: EXCEPTION

Line 3017: p_encoded => FND_API.G_FALSE,

3013: CLOSE l_obj_details;
3014: EXCEPTION
3015: WHEN OTHERS THEN
3016: FND_MSG_PUB.Count_And_Get (
3017: p_encoded => FND_API.G_FALSE,
3018: p_count => l_msg_count,
3019: p_data => l_msg_data
3020: );
3021:

Line 3147: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

3143: x_resource_id => l_new_approver_id,
3144: x_resource_disp_name => l_appr_display_name,
3145: x_return_status => l_return_status);
3146:
3147: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
3148: RAISE Fnd_Api.G_EXC_ERROR;
3149: END IF;
3150:
3151: -- Set the WF Attributes

Line 3148: RAISE Fnd_Api.G_EXC_ERROR;

3144: x_resource_disp_name => l_appr_display_name,
3145: x_return_status => l_return_status);
3146:
3147: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
3148: RAISE Fnd_Api.G_EXC_ERROR;
3149: END IF;
3150:
3151: -- Set the WF Attributes
3152: wf_engine.SetItemAttrText( itemtype => itemtype,

Line 3205: p_init_msg_list => FND_API.G_FALSE,

3201: l_appr_hist_rec.approver_id := l_new_approver_id;
3202:
3203: AMS_Appr_Hist_PVT.Update_Appr_Hist(
3204: p_api_version_number => 1.0,
3205: p_init_msg_list => FND_API.G_FALSE,
3206: p_commit => FND_API.G_FALSE,
3207: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3208: x_return_status => l_return_status,
3209: x_msg_count => l_msg_count,

Line 3206: p_commit => FND_API.G_FALSE,

3202:
3203: AMS_Appr_Hist_PVT.Update_Appr_Hist(
3204: p_api_version_number => 1.0,
3205: p_init_msg_list => FND_API.G_FALSE,
3206: p_commit => FND_API.G_FALSE,
3207: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3208: x_return_status => l_return_status,
3209: x_msg_count => l_msg_count,
3210: x_msg_data => l_msg_data,

Line 3207: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3203: AMS_Appr_Hist_PVT.Update_Appr_Hist(
3204: p_api_version_number => 1.0,
3205: p_init_msg_list => FND_API.G_FALSE,
3206: p_commit => FND_API.G_FALSE,
3207: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3208: x_return_status => l_return_status,
3209: x_msg_count => l_msg_count,
3210: x_msg_data => l_msg_data,
3211: p_appr_hist_rec => l_appr_hist_rec

Line 3214: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

3210: x_msg_data => l_msg_data,
3211: p_appr_hist_rec => l_appr_hist_rec
3212: );
3213:
3214: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
3215: RAISE Fnd_Api.G_EXC_ERROR;
3216: END IF;
3217:
3218: resultout := 'COMPLETE';

Line 3215: RAISE Fnd_Api.G_EXC_ERROR;

3211: p_appr_hist_rec => l_appr_hist_rec
3212: );
3213:
3214: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
3215: RAISE Fnd_Api.G_EXC_ERROR;
3216: END IF;
3217:
3218: resultout := 'COMPLETE';
3219:

Line 3222: WHEN Fnd_Api.G_EXC_ERROR THEN

3218: resultout := 'COMPLETE';
3219:
3220: END IF;
3221: EXCEPTION
3222: WHEN Fnd_Api.G_EXC_ERROR THEN
3223: Fnd_Msg_Pub.Count_And_Get (
3224: p_encoded => Fnd_Api.G_FALSE,
3225: p_count => l_msg_count,
3226: p_data => l_msg_data

Line 3224: p_encoded => Fnd_Api.G_FALSE,

3220: END IF;
3221: EXCEPTION
3222: WHEN Fnd_Api.G_EXC_ERROR THEN
3223: Fnd_Msg_Pub.Count_And_Get (
3224: p_encoded => Fnd_Api.G_FALSE,
3225: p_count => l_msg_count,
3226: p_data => l_msg_data
3227: );
3228: Handle_Err