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_MSG_PUB

Line 36: FND_MSG_PUB.Add;

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
40: AMS_ObjectAttribute_PVT.modify_object_attribute(

Line 56: FND_MSG_PUB.Add;

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(
60: p_api_version => 1.0 ,

Line 78: FND_MSG_PUB.Add;

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:
82: -------------------------------------------------------------------------------

Line 112: FND_MSG_PUB.Add;

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
116: WF_DIRECTORY.getrolename(

Line 124: FND_MSG_PUB.Add;

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: -------------------------------------------------------------------
128: -- Get the forward/reassigned resource details

Line 321: FND_MSG_PUB.Add;

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

Line 334: FND_MSG_PUB.Add;

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;
338: CLOSE c_API_Name;

Line 343: FND_MSG_PUB.Add;

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

Line 359: FND_MSG_PUB.Add;

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;
363: CLOSE c_default_role_info ;

Line 374: FND_MSG_PUB.Add;

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;
378: CLOSE c_role_info_count;

Line 386: FND_MSG_PUB.Add;

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;
390: CLOSE c_role_info;

Line 461: -- Retriveing Error Message from FND_MSG_PUB

457: l_appr_meaning VARCHAR2(240);
458: l_appr_obj_name VARCHAR2(240);
459: l_gen_err_sub VARCHAR2(240);
460: BEGIN
461: -- Retriveing Error Message from FND_MSG_PUB
462: -- Called by most of the procedures if it encounter error
463: WHILE l_cnt < p_msg_count
464: LOOP
465: FND_MSG_PUB.Get

Line 465: FND_MSG_PUB.Get

461: -- Retriveing Error Message from FND_MSG_PUB
462: -- Called by most of the procedures if it encounter error
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 ) ;

Line 679: FND_MSG_PUB.Add;

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;
683: CLOSE c_approver_def ;

Line 694: FND_MSG_PUB.Add;

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
698: OPEN c_approver_def ;

Line 703: FND_MSG_PUB.Add;

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;
707: CLOSE c_approver_def ;

Line 713: FND_MSG_PUB.Add;

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

Line 806: FND_MSG_PUB.initialize();

802: SELECT resource_id ,employee_id source_id,full_name resource_name
803: FROM ams_jtf_rs_emp_v
804: WHERE user_id = x_resource_id ;
805: BEGIN
806: FND_MSG_PUB.initialize();
807:
808: -- 11.5.9
809: -- Delete any previous approval history
810:

Line 1012: FND_MSG_PUB.Count_And_Get (

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,
1015: p_data => l_msg_data);
1016:

Line 1029: fnd_msg_pub.Get

1025: RAISE;
1026: /*
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);

Line 1030: (p_msg_index => FND_MSG_PUB.G_NEXT,

1026: /*
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);

Line 1043: FND_MSG_PUB.Count_And_Get (

1039: ,p_activity_id ,l_error_msg);
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:

Line 1051: fnd_msg_pub.Get

1047:
1048:
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);

Line 1052: (p_msg_index => FND_MSG_PUB.G_NEXT,

1048:
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);

Line 1108: FND_MSG_PUB.initialize();

1104: l_return_stat varchar2(1);
1105: dml_str VARCHAR2(2000);
1106:
1107: BEGIN
1108: FND_MSG_PUB.initialize();
1109: IF (funcmode = 'RUN') THEN
1110: -- get the acitvity id
1111: l_activity_id := wf_engine.GetItemAttrNumber(
1112: itemtype => itemtype,

Line 1167: FND_MSG_PUB.Count_And_Get (

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

Line 1199: FND_MSG_PUB.initialize();

1195: funcmode in varchar2,
1196: resultout OUT NOCOPY varchar2 )
1197: IS
1198: BEGIN
1199: FND_MSG_PUB.initialize();
1200: IF (funcmode = 'RUN') THEN
1201: resultout := 'COMPLETE:SUCCESS';
1202: END IF;
1203:

Line 1281: FND_MSG_PUB.initialize();

1277: FROM ams_object_rules_b
1278: WHERE OBJECT_RULE_ID = rule_id_in;
1279:
1280: BEGIN
1281: FND_MSG_PUB.initialize();
1282: IF (funcmode = 'RUN') THEN
1283: l_approval_detail_id := wf_engine.GetItemAttrNumber(
1284: itemtype => itemtype,
1285: itemkey => itemkey,

Line 1494: FND_MSG_PUB.Count_And_Get (

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
1498: );

Line 1513: FND_MSG_PUB.Count_And_Get (

1509: itemtype, itemkey,to_char(actid),l_error_msg);
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: );

Line 1567: FND_MSG_PUB.initialize();

1563: l_forward_nid NUMBER;
1564: l_responder VARCHAR2(320);
1565: l_appr_display_name VARCHAR2(360);
1566: BEGIN
1567: FND_MSG_PUB.initialize();
1568: IF (funcmode = 'RUN') THEN
1569: l_approval_detail_id := wf_engine.GetItemAttrNumber(
1570: itemtype => itemtype,
1571: itemkey => itemkey,

Line 1724: FND_MSG_PUB.Count_And_Get (

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
1728: );

Line 1742: FND_MSG_PUB.Count_And_Get (

1738: 'set_further_approvals',
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: );

Line 1786: FND_MSG_PUB.initialize();

1782: l_version NUMBER;
1783: l_approval_type VARCHAR2(30);
1784: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
1785: BEGIN
1786: FND_MSG_PUB.initialize();
1787: /*
1788: UPDATE AMS_CAMPAIGNS_ALL_B
1789: SET user_status_id = 100,
1790: status_code = 'New',

Line 1840: FND_MSG_PUB.Count_And_Get (

1836: resultout => resultout);
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: );

Line 1898: FND_MSG_PUB.Count_And_Get (

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
1902: );

Line 1917: FND_MSG_PUB.Count_And_Get (

1913: itemtype, itemkey,to_char(actid),l_error_msg);
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: );

Line 2063: FND_MSG_PUB.Count_And_Get (

2059: end if;
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: );

Line 2131: FND_MSG_PUB.Count_And_Get (

2127: end if;
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: );

Line 2201: FND_MSG_PUB.Count_And_Get (

2197:
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: );

Line 2270: FND_MSG_PUB.Count_And_Get (

2266:
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: );

Line 2338: FND_MSG_PUB.Count_And_Get (

2334:
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: );

Line 2699: FND_MSG_PUB.Count_And_Get (

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
2703: );

Line 2718: FND_MSG_PUB.Count_And_Get (

2714: itemtype, itemkey,to_char(actid),l_error_msg);
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: );

Line 2826: Fnd_Msg_Pub.initialize();

2822: l_approver NUMBER;
2823:
2824:
2825: BEGIN
2826: Fnd_Msg_Pub.initialize();
2827: --
2828: -- RUN mode
2829: --
2830: IF (funcmode = 'RUN') THEN

Line 3000: Fnd_Msg_Pub.ADD;

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:
3004: -- check here

Line 3009: Fnd_Msg_Pub.ADD;

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;
3013: CLOSE l_obj_details;

Line 3016: FND_MSG_PUB.Count_And_Get (

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

Line 3223: Fnd_Msg_Pub.Count_And_Get (

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
3227: );