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_MESSAGE

Line 36: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

32: BEGIN
33: OPEN c_resource ;
34: FETCH c_resource INTO l_user ;
35: IF c_resource%NOTFOUND THEN
36: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
37: FND_MESSAGE.Set_Token('ROW', sqlerrm );
38: FND_MSG_PUB.Add;
39: END IF;
40: CLOSE c_resource ;

Line 37: FND_MESSAGE.Set_Token('ROW', sqlerrm );

33: OPEN c_resource ;
34: FETCH c_resource INTO l_user ;
35: IF c_resource%NOTFOUND THEN
36: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
37: FND_MESSAGE.Set_Token('ROW', sqlerrm );
38: FND_MSG_PUB.Add;
39: END IF;
40: CLOSE c_resource ;
41: -- Note API to Update Approval Notes

Line 56: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

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

Line 57: FND_MESSAGE.Set_Token('ROW', sqlerrm );

53: p_attr_defined_flag => 'Y'
54: );
55: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
56: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
57: FND_MESSAGE.Set_Token('ROW', sqlerrm );
58: FND_MSG_PUB.Add;
59: END IF;
60:
61: JTF_NOTES_PUB.Create_note(

Line 78: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

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

Line 79: FND_MESSAGE.Set_Token('ROW', sqlerrm );

75: p_last_update_date => SYSDATE ,
76: p_creation_date => SYSDATE ) ;
77: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
78: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
79: FND_MESSAGE.Set_Token('ROW', sqlerrm );
80: FND_MSG_PUB.Add;
81: END IF;
82: END Update_Note;
83:

Line 113: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');

109: OPEN c_resource ;
110: FETCH c_resource INTO l_person_id ;
111: IF c_resource%NOTFOUND THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');
114: FND_MSG_PUB.Add;
115: END IF;
116: CLOSE c_resource ;
117: -- Pass the Employee ID to get the Role

Line 125: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');

121: p_name => x_role_name,
122: p_display_name => x_role_display_name );
123: IF x_role_name is null then
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
126: FND_MSG_PUB.Add;
127: END IF;
128: END Get_User_Role;
129: -------------------------------------------------------------------

Line 321: Fnd_Message.Set_Name('AMS','AMS_NO_APPR_FOR_RULE');

317:
318: OPEN c_rule_name;
319: FETCH c_rule_name INTO l_rule_name;
320: CLOSE c_rule_name;
321: Fnd_Message.Set_Name('AMS','AMS_NO_APPR_FOR_RULE');
322: Fnd_Message.Set_Token('RULE_NAME',l_rule_name);
323: FND_MSG_PUB.Add;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: return;

Line 322: Fnd_Message.Set_Token('RULE_NAME',l_rule_name);

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

Line 335: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_API_NAME');

331: FETCH c_API_Name INTO l_pkg_name, l_proc_name;
332: IF c_API_Name%NOTFOUND THEN
333: CLOSE c_API_Name;
334: --dbms_output.put_line('In Role Check 2');
335: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_API_NAME');
336: FND_MSG_PUB.Add;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: return;
339: END IF;

Line 344: FND_MESSAGE.Set_Name('AMS','AMS_APPR_FUNCTION_API_FAIL');

340: CLOSE c_API_Name;
341: 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;';
342: 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;
343: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
344: FND_MESSAGE.Set_Name('AMS','AMS_APPR_FUNCTION_API_FAIL');
345: FND_MSG_PUB.Add;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: return;
348: END IF;

Line 359: Fnd_Message.Set_Name('AMS','AMS_NO_DEFAULT_ROLE'); -- VMODUR added

355: INTO x_object_approver_id;
356: --dbms_output.put_line('In Role Check 1');
357: IF c_default_role_info%NOTFOUND THEN
358: CLOSE c_default_role_info ;
359: Fnd_Message.Set_Name('AMS','AMS_NO_DEFAULT_ROLE'); -- VMODUR added
360: --FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
361: FND_MSG_PUB.Add;
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: return;

Line 360: --FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');

356: --dbms_output.put_line('In Role Check 1');
357: IF c_default_role_info%NOTFOUND THEN
358: CLOSE c_default_role_info ;
359: Fnd_Message.Set_Name('AMS','AMS_NO_DEFAULT_ROLE'); -- VMODUR added
360: --FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
361: FND_MSG_PUB.Add;
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: return;
364: END IF;

Line 374: Fnd_Message.Set_Name('AMS','AMS_MANY_DEFAULT_ROLE'); -- VMODUR added

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

Line 375: --FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');

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

Line 387: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');

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

Line 493: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_SUB');

489: itemtype => p_itemtype,
490: itemkey => p_itemkey,
491: aname => 'AMS_APPROVAL_OBJECT_NAME');
492: --
493: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_SUB');
494: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
495: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
496:
497: l_gen_err_sub := SUBSTR(fnd_message.get,1,240);

Line 494: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);

490: itemkey => p_itemkey,
491: aname => 'AMS_APPROVAL_OBJECT_NAME');
492: --
493: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_SUB');
494: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
495: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
496:
497: l_gen_err_sub := SUBSTR(fnd_message.get,1,240);
498:

Line 495: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);

491: aname => 'AMS_APPROVAL_OBJECT_NAME');
492: --
493: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_SUB');
494: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
495: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
496:
497: l_gen_err_sub := SUBSTR(fnd_message.get,1,240);
498:
499: Wf_Engine.SetItemAttrText

Line 497: l_gen_err_sub := SUBSTR(fnd_message.get,1,240);

493: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_SUB');
494: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
495: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
496:
497: l_gen_err_sub := SUBSTR(fnd_message.get,1,240);
498:
499: Wf_Engine.SetItemAttrText
500: (itemtype => p_itemtype,
501: itemkey => p_itemkey ,

Line 770: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVAL_DETAIL_ID');

766: OPEN c_approver_def ;
767: FETCH c_approver_def INTO x_approval_detail_id, l_seeded_flag;
768: IF c_approver_def%NOTFOUND THEN
769: CLOSE c_approver_def ;
770: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVAL_DETAIL_ID');
771: FND_MSG_PUB.Add;
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: return;
774: END IF;

Line 790: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVAL_DETAIL_ID');

786: OPEN c_approver_def ;
787: FETCH c_approver_def INTO x_approval_detail_id, l_seeded_flag;
788: IF c_approver_def%NOTFOUND THEN
789: CLOSE c_approver_def ;
790: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVAL_DETAIL_ID');
791: FND_MSG_PUB.Add;
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: return;
794: END IF;

Line 806: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVER_SEQUENCE');

802: FETCH c_approver_seq INTO x_approver_seq ;
803: IF c_approver_seq%NOTFOUND THEN
804: CLOSE c_approver_seq;
805: IF l_seeded_flag = 'Y' THEN
806: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVER_SEQUENCE');
807: FND_MSG_PUB.Add;
808: x_return_status := FND_API.G_RET_STS_ERROR;
809: return;
810: else

Line 815: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVAL_DETAIL_ID');

811: OPEN c_approver_def ;
812: FETCH c_approver_def INTO x_approval_detail_id, l_seeded_flag;
813: IF c_approver_def%NOTFOUND THEN
814: CLOSE c_approver_def ;
815: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVAL_DETAIL_ID');
816: FND_MSG_PUB.Add;
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: return;
819: END IF;

Line 825: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVER_SEQUENCE');

821: OPEN c_approver_seq ;
822: FETCH c_approver_seq INTO x_approver_seq ;
823: IF c_approver_seq%NOTFOUND THEN
824: CLOSE c_approver_seq;
825: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVER_SEQUENCE');
826: FND_MSG_PUB.Add;
827: x_return_status := FND_API.G_RET_STS_ERROR;
828: return;
829: END IF;

Line 2541: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_BODY');

2537: itemtype => l_itemtype,
2538: itemkey => l_itemkey,
2539: aname => 'AMS_ERROR_MSG');
2540:
2541: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_BODY');
2542: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
2543: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
2544: fnd_message.set_token ('ERR_MSG', l_errmsg, FALSE);
2545: l_body_string := SUBSTR(fnd_message.get,1,10000);

Line 2542: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);

2538: itemkey => l_itemkey,
2539: aname => 'AMS_ERROR_MSG');
2540:
2541: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_BODY');
2542: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
2543: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
2544: fnd_message.set_token ('ERR_MSG', l_errmsg, FALSE);
2545: l_body_string := SUBSTR(fnd_message.get,1,10000);
2546:

Line 2543: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);

2539: aname => 'AMS_ERROR_MSG');
2540:
2541: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_BODY');
2542: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
2543: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
2544: fnd_message.set_token ('ERR_MSG', l_errmsg, FALSE);
2545: l_body_string := SUBSTR(fnd_message.get,1,10000);
2546:
2547: document_type := 'text/plain';

Line 2544: fnd_message.set_token ('ERR_MSG', l_errmsg, FALSE);

2540:
2541: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_BODY');
2542: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
2543: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
2544: fnd_message.set_token ('ERR_MSG', l_errmsg, FALSE);
2545: l_body_string := SUBSTR(fnd_message.get,1,10000);
2546:
2547: document_type := 'text/plain';
2548: document := l_body_string;

Line 2545: l_body_string := SUBSTR(fnd_message.get,1,10000);

2541: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_BODY');
2542: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
2543: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
2544: fnd_message.set_token ('ERR_MSG', l_errmsg, FALSE);
2545: l_body_string := SUBSTR(fnd_message.get,1,10000);
2546:
2547: document_type := 'text/plain';
2548: document := l_body_string;
2549: end if;

Line 3123: Fnd_Message.Set_Name('AMS','AMS_BAD_APPROVAL_OBJECT_TYPE');

3119: AND act1.act_budget_used_by_id = fund.fund_id;
3120: -- Add Offer Adjustments
3121: ELSE
3122: -- add exception
3123: Fnd_Message.Set_Name('AMS','AMS_BAD_APPROVAL_OBJECT_TYPE');
3124: Fnd_Msg_Pub.ADD;
3125: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3126: END IF ;
3127:

Line 3132: Fnd_Message.Set_Name('AMS','AMS_APPR_BAD_DETAILS');

3128: -- check here
3129: FETCH l_obj_details INTO x_object_details;
3130: IF l_obj_details%NOTFOUND THEN
3131: CLOSE l_obj_details;
3132: Fnd_Message.Set_Name('AMS','AMS_APPR_BAD_DETAILS');
3133: Fnd_Msg_Pub.ADD;
3134: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3135: RETURN;
3136: END IF;