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 38: FND_MSG_PUB.Add;

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

Line 58: FND_MSG_PUB.Add;

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

Line 80: FND_MSG_PUB.Add;

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

Line 114: FND_MSG_PUB.Add;

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

Line 126: FND_MSG_PUB.Add;

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

Line 323: FND_MSG_PUB.Add;

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

Line 336: FND_MSG_PUB.Add;

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

Line 345: FND_MSG_PUB.Add;

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

Line 361: FND_MSG_PUB.Add;

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

Line 376: FND_MSG_PUB.Add;

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

Line 388: FND_MSG_PUB.Add;

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

Line 463: -- Retriveing Error Message from FND_MSG_PUB

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

Line 467: FND_MSG_PUB.Get

463: -- Retriveing Error Message from FND_MSG_PUB
464: -- Called by most of the procedures if it encounter error
465: WHILE l_cnt < p_msg_count
466: LOOP
467: FND_MSG_PUB.Get
468: (p_msg_index => l_cnt + 1,
469: p_encoded => FND_API.G_FALSE,
470: p_data => l_msg_data,
471: p_msg_index_out => l_msg_index ) ;

Line 771: FND_MSG_PUB.Add;

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

Line 791: FND_MSG_PUB.Add;

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

Line 807: FND_MSG_PUB.Add;

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

Line 816: FND_MSG_PUB.Add;

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

Line 826: FND_MSG_PUB.Add;

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

Line 919: FND_MSG_PUB.initialize();

915: SELECT resource_id ,employee_id source_id,full_name resource_name
916: FROM ams_jtf_rs_emp_v
917: WHERE user_id = x_resource_id ;
918: BEGIN
919: FND_MSG_PUB.initialize();
920:
921: -- 11.5.9
922: -- Delete any previous approval history
923:

Line 1125: FND_MSG_PUB.Count_And_Get (

1121: EXCEPTION
1122:
1123: WHEN FND_API.G_EXC_ERROR THEN
1124: -- wf_engine.threshold := l_save_threshold ;
1125: FND_MSG_PUB.Count_And_Get (
1126: p_encoded => FND_API.G_FALSE,
1127: p_count => l_msg_count,
1128: p_data => l_msg_data);
1129:

Line 1142: fnd_msg_pub.Get

1138: RAISE;
1139: /*
1140: if(l_msg_count > 0)then
1141: for I in 1 .. l_msg_count LOOP
1142: fnd_msg_pub.Get
1143: (p_msg_index => FND_MSG_PUB.G_NEXT,
1144: p_encoded => FND_API.G_FALSE,
1145: p_data => l_msg_data,
1146: p_msg_index_out => l_index);

Line 1143: (p_msg_index => FND_MSG_PUB.G_NEXT,

1139: /*
1140: if(l_msg_count > 0)then
1141: for I in 1 .. l_msg_count LOOP
1142: fnd_msg_pub.Get
1143: (p_msg_index => FND_MSG_PUB.G_NEXT,
1144: p_encoded => FND_API.G_FALSE,
1145: p_data => l_msg_data,
1146: p_msg_index_out => l_index);
1147: dbms_output.put_line('message :'||l_msg_data);

Line 1156: FND_MSG_PUB.Count_And_Get (

1152: ,p_activity_id ,l_error_msg);
1153: RAISE;
1154: WHEN OTHERS THEN
1155: -- wf_engine.threshold := l_save_threshold ;
1156: FND_MSG_PUB.Count_And_Get (
1157: p_encoded => FND_API.G_FALSE,
1158: p_count => l_msg_count,
1159: p_data => l_msg_data);
1160:

Line 1164: fnd_msg_pub.Get

1160:
1161:
1162: if(l_msg_count > 0)then
1163: for I in 1 .. l_msg_count LOOP
1164: fnd_msg_pub.Get
1165: (p_msg_index => FND_MSG_PUB.G_NEXT,
1166: p_encoded => FND_API.G_FALSE,
1167: p_data => l_msg_data,
1168: p_msg_index_out => l_index);

Line 1165: (p_msg_index => FND_MSG_PUB.G_NEXT,

1161:
1162: if(l_msg_count > 0)then
1163: for I in 1 .. l_msg_count LOOP
1164: fnd_msg_pub.Get
1165: (p_msg_index => FND_MSG_PUB.G_NEXT,
1166: p_encoded => FND_API.G_FALSE,
1167: p_data => l_msg_data,
1168: p_msg_index_out => l_index);
1169: dbms_output.put_line('message :'||l_msg_data);

Line 1221: FND_MSG_PUB.initialize();

1217: l_return_stat varchar2(1);
1218: dml_str VARCHAR2(2000);
1219:
1220: BEGIN
1221: FND_MSG_PUB.initialize();
1222: IF (funcmode = 'RUN') THEN
1223: -- get the acitvity id
1224: l_activity_id := wf_engine.GetItemAttrNumber(
1225: itemtype => itemtype,

Line 1280: FND_MSG_PUB.Count_And_Get (

1276: wf_core.context('ams_gen_approval_pvt','Set_Activity_Details',
1277: itemtype,itemkey,actid,funcmode,l_error_msg);
1278: raise;
1279: WHEN OTHERS THEN
1280: FND_MSG_PUB.Count_And_Get (
1281: p_encoded => FND_API.G_FALSE,
1282: p_count => l_msg_count,
1283: p_data => l_msg_data
1284: );

Line 1312: FND_MSG_PUB.initialize();

1308: funcmode in varchar2,
1309: resultout OUT NOCOPY varchar2 )
1310: IS
1311: BEGIN
1312: FND_MSG_PUB.initialize();
1313: IF (funcmode = 'RUN') THEN
1314: resultout := 'COMPLETE:SUCCESS';
1315: END IF;
1316:

Line 1394: FND_MSG_PUB.initialize();

1390: FROM ams_object_rules_b
1391: WHERE OBJECT_RULE_ID = rule_id_in;
1392:
1393: BEGIN
1394: FND_MSG_PUB.initialize();
1395: IF (funcmode = 'RUN') THEN
1396: l_approval_detail_id := wf_engine.GetItemAttrNumber(
1397: itemtype => itemtype,
1398: itemkey => itemkey,

Line 1607: FND_MSG_PUB.Count_And_Get (

1603: END IF;
1604:
1605: EXCEPTION
1606: WHEN FND_API.G_EXC_ERROR THEN
1607: FND_MSG_PUB.Count_And_Get (
1608: p_encoded => FND_API.G_FALSE,
1609: p_count => l_msg_count,
1610: p_data => l_msg_data
1611: );

Line 1626: FND_MSG_PUB.Count_And_Get (

1622: itemtype, itemkey,to_char(actid),l_error_msg);
1623: resultout := 'COMPLETE:ERROR';
1624: --RAISE;
1625: WHEN OTHERS THEN
1626: FND_MSG_PUB.Count_And_Get (
1627: p_encoded => FND_API.G_FALSE,
1628: p_count => l_msg_count,
1629: p_data => l_msg_data
1630: );

Line 1680: FND_MSG_PUB.initialize();

1676: l_forward_nid NUMBER;
1677: l_responder VARCHAR2(320);
1678: l_appr_display_name VARCHAR2(360);
1679: BEGIN
1680: FND_MSG_PUB.initialize();
1681: IF (funcmode = 'RUN') THEN
1682: l_approval_detail_id := wf_engine.GetItemAttrNumber(
1683: itemtype => itemtype,
1684: itemkey => itemkey,

Line 1837: FND_MSG_PUB.Count_And_Get (

1833: return;
1834: END IF;
1835: EXCEPTION
1836: WHEN FND_API.G_EXC_ERROR THEN
1837: FND_MSG_PUB.Count_And_Get (
1838: p_encoded => FND_API.G_FALSE,
1839: p_count => l_msg_count,
1840: p_data => l_msg_data
1841: );

Line 1855: FND_MSG_PUB.Count_And_Get (

1851: 'set_further_approvals',
1852: itemtype, itemkey,to_char(actid),l_error_msg);
1853: RAISE;
1854: WHEN OTHERS THEN
1855: FND_MSG_PUB.Count_And_Get (
1856: p_encoded => FND_API.G_FALSE,
1857: p_count => l_msg_count,
1858: p_data => l_msg_data
1859: );

Line 1899: FND_MSG_PUB.initialize();

1895: l_version NUMBER;
1896: l_approval_type VARCHAR2(30);
1897: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
1898: BEGIN
1899: FND_MSG_PUB.initialize();
1900: /*
1901: UPDATE AMS_CAMPAIGNS_ALL_B
1902: SET user_status_id = 100,
1903: status_code = 'New',

Line 1953: FND_MSG_PUB.Count_And_Get (

1949: resultout => resultout);
1950:
1951: IF resultout = 'COMPLETE:ERROR' then -- added VMODUR 10-Jun-2002
1952:
1953: FND_MSG_PUB.Count_And_Get (
1954: p_encoded => FND_API.G_FALSE,
1955: p_count => l_msg_count,
1956: p_data => l_msg_data
1957: );

Line 2011: FND_MSG_PUB.Count_And_Get (

2007: --
2008:
2009: EXCEPTION
2010: WHEN FND_API.G_EXC_ERROR THEN
2011: FND_MSG_PUB.Count_And_Get (
2012: p_encoded => FND_API.G_FALSE,
2013: p_count => l_msg_count,
2014: p_data => l_msg_data
2015: );

Line 2030: FND_MSG_PUB.Count_And_Get (

2026: itemtype, itemkey,to_char(actid),l_error_msg);
2027: resultout := 'COMPLETE:ERROR';
2028: --RAISE;
2029: WHEN OTHERS THEN
2030: FND_MSG_PUB.Count_And_Get (
2031: p_encoded => FND_API.G_FALSE,
2032: p_count => l_msg_count,
2033: p_data => l_msg_data
2034: );

Line 2176: FND_MSG_PUB.Count_And_Get (

2172: end if;
2173: /*
2174: EXCEPTION
2175: WHEN OTHERS THEN
2176: FND_MSG_PUB.Count_And_Get (
2177: p_encoded => FND_API.G_FALSE,
2178: p_count => l_msg_count,
2179: p_data => l_msg_data
2180: );

Line 2244: FND_MSG_PUB.Count_And_Get (

2240: end if;
2241: /*
2242: EXCEPTION
2243: WHEN OTHERS THEN
2244: FND_MSG_PUB.Count_And_Get (
2245: p_encoded => FND_API.G_FALSE,
2246: p_count => l_msg_count,
2247: p_data => l_msg_data
2248: );

Line 2314: FND_MSG_PUB.Count_And_Get (

2310:
2311: /*
2312: EXCEPTION
2313: WHEN OTHERS THEN
2314: FND_MSG_PUB.Count_And_Get (
2315: p_encoded => FND_API.G_FALSE,
2316: p_count => l_msg_count,
2317: p_data => l_msg_data
2318: );

Line 2383: FND_MSG_PUB.Count_And_Get (

2379:
2380: /*
2381: EXCEPTION
2382: WHEN OTHERS THEN
2383: FND_MSG_PUB.Count_And_Get (
2384: p_encoded => FND_API.G_FALSE,
2385: p_count => l_msg_count,
2386: p_data => l_msg_data
2387: );

Line 2451: FND_MSG_PUB.Count_And_Get (

2447:
2448: /*
2449: EXCEPTION
2450: WHEN OTHERS THEN
2451: FND_MSG_PUB.Count_And_Get (
2452: p_encoded => FND_API.G_FALSE,
2453: p_count => l_msg_count,
2454: p_data => l_msg_data
2455: );

Line 2812: FND_MSG_PUB.Count_And_Get (

2808: resultout => resultout);
2809:
2810: EXCEPTION
2811: WHEN FND_API.G_EXC_ERROR THEN
2812: FND_MSG_PUB.Count_And_Get (
2813: p_encoded => FND_API.G_FALSE,
2814: p_count => l_msg_count,
2815: p_data => l_msg_data
2816: );

Line 2831: FND_MSG_PUB.Count_And_Get (

2827: itemtype, itemkey,to_char(actid),l_error_msg);
2828: resultout := 'COMPLETE:ERROR';
2829: --RAISE;
2830: WHEN OTHERS THEN
2831: FND_MSG_PUB.Count_And_Get (
2832: p_encoded => FND_API.G_FALSE,
2833: p_count => l_msg_count,
2834: p_data => l_msg_data
2835: );

Line 2940: Fnd_Msg_Pub.initialize();

2936: l_note VARCHAR2(3000);
2937:
2938:
2939: BEGIN
2940: Fnd_Msg_Pub.initialize();
2941: --
2942: -- RUN mode
2943: --
2944: IF (funcmode = 'RUN') THEN

Line 3124: Fnd_Msg_Pub.ADD;

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

Line 3133: Fnd_Msg_Pub.ADD;

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

Line 3140: FND_MSG_PUB.Count_And_Get (

3136: END IF;
3137: CLOSE l_obj_details;
3138: EXCEPTION
3139: WHEN OTHERS THEN
3140: FND_MSG_PUB.Count_And_Get (
3141: p_encoded => FND_API.G_FALSE,
3142: p_count => l_msg_count,
3143: p_data => l_msg_data
3144: );

Line 3347: Fnd_Msg_Pub.Count_And_Get (

3343:
3344: END IF;
3345: EXCEPTION
3346: WHEN Fnd_Api.G_EXC_ERROR THEN
3347: Fnd_Msg_Pub.Count_And_Get (
3348: p_encoded => Fnd_Api.G_FALSE,
3349: p_count => l_msg_count,
3350: p_data => l_msg_data
3351: );