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.

[Home] [Help]

APPS.AMS_GEN_APPROVAL_PVT dependencies on FND_MESSAGE

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

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

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

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

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

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;
58:

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

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;
58:
59: JTF_NOTES_PUB.Create_note(

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

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;
80: END Update_Note;

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

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;
80: END Update_Note;
81:

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

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 ;
115: -- Pass the Employee ID to get the Role

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

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;
127: -------------------------------------------------------------------

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

315:
316: OPEN c_rule_name;
317: FETCH c_rule_name INTO l_rule_name;
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;

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

316: OPEN c_rule_name;
317: FETCH c_rule_name INTO l_rule_name;
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;

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

329: FETCH c_API_Name INTO l_pkg_name, l_proc_name;
330: IF c_API_Name%NOTFOUND THEN
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;

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

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;
346: END IF;

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

353: INTO x_object_approver_id;
354: --dbms_output.put_line('In Role Check 1');
355: IF c_default_role_info%NOTFOUND THEN
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;

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

354: --dbms_output.put_line('In Role Check 1');
355: IF c_default_role_info%NOTFOUND THEN
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;

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

368: INTO l_count;
369: IF l_count > 1 THEN
370: CLOSE c_role_info_count;
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;

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

369: IF l_count > 1 THEN
370: CLOSE c_role_info_count;
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;

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

381: INTO x_object_approver_id,x_role_name;
382: IF c_role_info%NOTFOUND THEN
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;

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

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

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

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

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

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

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

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

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

674: OPEN c_approver_def ;
675: FETCH c_approver_def INTO x_approval_detail_id, l_seeded_flag;
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;

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

689: FETCH c_approver_seq INTO x_approver_seq ;
690: IF c_approver_seq%NOTFOUND THEN
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

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

698: OPEN c_approver_def ;
699: FETCH c_approver_def INTO x_approval_detail_id, l_seeded_flag;
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;

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

708: OPEN c_approver_seq ;
709: FETCH c_approver_seq INTO x_approver_seq ;
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;

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

2424: itemtype => l_itemtype,
2425: itemkey => l_itemkey,
2426: aname => 'AMS_ERROR_MSG');
2427:
2428: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_BODY');
2429: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
2430: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
2431: fnd_message.set_token ('ERR_MSG', l_errmsg, FALSE);
2432: l_body_string := SUBSTR(fnd_message.get,1,10000);

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

2425: itemkey => l_itemkey,
2426: aname => 'AMS_ERROR_MSG');
2427:
2428: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_BODY');
2429: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
2430: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
2431: fnd_message.set_token ('ERR_MSG', l_errmsg, FALSE);
2432: l_body_string := SUBSTR(fnd_message.get,1,10000);
2433:

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

2426: aname => 'AMS_ERROR_MSG');
2427:
2428: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_BODY');
2429: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
2430: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
2431: fnd_message.set_token ('ERR_MSG', l_errmsg, FALSE);
2432: l_body_string := SUBSTR(fnd_message.get,1,10000);
2433:
2434: document_type := 'text/plain';

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

2427:
2428: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_BODY');
2429: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
2430: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
2431: fnd_message.set_token ('ERR_MSG', l_errmsg, FALSE);
2432: l_body_string := SUBSTR(fnd_message.get,1,10000);
2433:
2434: document_type := 'text/plain';
2435: document := l_body_string;

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

2428: fnd_message.set_name ('AMS', 'AMS_GEN_NTF_ERROR_BODY');
2429: fnd_message.set_token ('OBJ_MEANING', l_appr_meaning, FALSE);
2430: fnd_message.set_token ('OBJ_NAME', l_appr_obj_name, FALSE);
2431: fnd_message.set_token ('ERR_MSG', l_errmsg, FALSE);
2432: l_body_string := SUBSTR(fnd_message.get,1,10000);
2433:
2434: document_type := 'text/plain';
2435: document := l_body_string;
2436: end if;

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

2995: AND act1.act_budget_used_by_id = fund.fund_id;
2996: -- Add Offer Adjustments
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:

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

3004: -- check here
3005: FETCH l_obj_details INTO x_object_details;
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;