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

Line 35: x_return_status := FND_API.G_RET_STS_SUCCESS;

31: x_role_display_name OUT NOCOPY VARCHAR2 ,
32: x_return_status OUT NOCOPY VARCHAR2) IS
33: l_employee_id FND_USER.EMPLOYEE_ID%TYPE ;
34: BEGIN
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36:
37: /*
38: -- The parameter p_user_id is the FND_USER.USER_ID
39: -- Get the Person Id (which is the Employee Id) for this USER_ID

Line 48: x_return_status := FND_API.G_RET_STS_ERROR;

44: where user_id = p_user_id ;
45: exception
46: when no_data_found
47: then
48: x_return_status := FND_API.G_RET_STS_ERROR;
49: FND_MESSAGE.Set_Name('AMW','AMW_APPR_INVALID_ROLE');
50: FND_MSG_PUB.Add;
51:
52: return ;

Line 65: x_return_status := FND_API.G_RET_STS_ERROR;

61: p_display_name => x_role_display_name );
62:
63: IF x_role_name is null
64: then
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: FND_MESSAGE.Set_Name('AMW','AMW_APPR_INVALID_ROLE');
67: FND_MSG_PUB.Add;
68: END IF;
69: END Get_User_Role;

Line 87: x_return_status := FND_API.G_RET_STS_SUCCESS;

83: from FND_USER
84: where user_id = p_user_id ;
85: -- Obtain and populate the Role Name and Display Name from the USER ID
86: BEGIN
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88: OPEN c_person_id ;
89: FETCH c_person_id INTO x_person_id ;
90: CLOSE c_person_id;
91: exception

Line 94: x_return_status := FND_API.G_RET_STS_ERROR;

90: CLOSE c_person_id;
91: exception
92: when no_data_found
93: then
94: x_return_status := FND_API.G_RET_STS_ERROR;
95: FND_MESSAGE.Set_Name('AMW','AMW_APPR_INVALID_ROLE');
96: FND_MSG_PUB.Add;
97: RAISE FND_API.G_EXC_ERROR;
98: end ;

Line 97: RAISE FND_API.G_EXC_ERROR;

93: then
94: x_return_status := FND_API.G_RET_STS_ERROR;
95: FND_MESSAGE.Set_Name('AMW','AMW_APPR_INVALID_ROLE');
96: FND_MSG_PUB.Add;
97: RAISE FND_API.G_EXC_ERROR;
98: end ;
99:
100:
101: -------------------------------------------------------------------------------

Line 115: x_required_flag := FND_API.G_TRUE;

111:
112:
113: BEGIN
114:
115: x_required_flag := FND_API.G_TRUE;
116:
117: END Check_Approval_Required;
118:
119: -------------------------------------------------------------------------------

Line 161: p_encoded => FND_API.G_FALSE,

157: WHILE l_cnt < p_msg_count
158: LOOP
159: FND_MSG_PUB.Get
160: (p_msg_index => l_cnt + 1,
161: p_encoded => FND_API.G_FALSE,
162: p_data => l_msg_data,
163: p_msg_index_out => l_msg_index ) ;
164: l_final_data := l_final_data ||l_msg_index||': '
165: ||l_msg_data||fnd_global.local_chr(10) ;

Line 279: x_return_status := FND_API.g_ret_sts_success;

275: -- WHERE user_id = x_resource_id ; need to change
276: BEGIN
277: --FND_MSG_PUB.initialize();
278: savepoint start_process ;
279: x_return_status := FND_API.g_ret_sts_success;
280:
281: AMW_Utility_PVT.debug_message('Start :Item Type : '||itemtype
282: ||' Item key : '||itemkey);
283:

Line 360: l_return_status := FND_API.G_RET_STS_SUCCESS;

356: itemkey => itemkey,
357: aname => 'AMW_APPROVAL_TYPE',
358: avalue => p_approval_type );
359:
360: l_return_status := FND_API.G_RET_STS_SUCCESS;
361:
362: get_person_id(
363: p_user_id =>p_requestor_userid,
364: x_person_id =>l_employee_id,

Line 367: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

363: p_user_id =>p_requestor_userid,
364: x_person_id =>l_employee_id,
365: x_return_status =>l_return_status);
366:
367: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
368: RAISE FND_API.G_EXC_ERROR;
369: END IF;
370:
371: -- Pass the Employee Id (which is Person Id) to get the Role

Line 368: RAISE FND_API.G_EXC_ERROR;

364: x_person_id =>l_employee_id,
365: x_return_status =>l_return_status);
366:
367: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
368: RAISE FND_API.G_EXC_ERROR;
369: END IF;
370:
371: -- Pass the Employee Id (which is Person Id) to get the Role
372: WF_DIRECTORY.getrolename(

Line 401: WHEN FND_API.G_EXC_ERROR THEN

397:
398: -- wf_engine.threshold := l_save_threshold ;
399: EXCEPTION
400:
401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO start_process;
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: -- Standard call to get message count and if count=1, get the message
405: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 403: x_return_status := FND_API.G_RET_STS_ERROR;

399: EXCEPTION
400:
401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO start_process;
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: -- Standard call to get message count and if count=1, get the message
405: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
406:
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 405: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO start_process;
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: -- Standard call to get message count and if count=1, get the message
405: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
406:
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: ROLLBACK TO start_process;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

403: x_return_status := FND_API.G_RET_STS_ERROR;
404: -- Standard call to get message count and if count=1, get the message
405: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
406:
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: ROLLBACK TO start_process;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: -- Standard call to get message count and if count=1, get the message
411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

405: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
406:
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: ROLLBACK TO start_process;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: -- Standard call to get message count and if count=1, get the message
411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
412:
413: WHEN OTHERS THEN

Line 411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: ROLLBACK TO start_process;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: -- Standard call to get message count and if count=1, get the message
411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
412:
413: WHEN OTHERS THEN
414: ROLLBACK TO start_process;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
412:
413: WHEN OTHERS THEN
414: ROLLBACK TO start_process;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
417: THEN
418: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
419: END IF;

Line 421: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

417: THEN
418: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
419: END IF;
420: -- Standard call to get message count and if count=1, get the message
421: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
422:
423: END StartProcess;
424:
425: /*****************************************************************

Line 485: RAISE FND_API.G_EXC_ERROR;

481: resultout := 'COMPLETE:SUCCESS';
482:
483: return ;
484: ELSE
485: RAISE FND_API.G_EXC_ERROR;
486: END IF;
487:
488: END IF;
489:

Line 508: WHEN FND_API.G_EXC_ERROR THEN

504: END IF;
505: --
506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: wf_core.context('amw_gen_approval_pvt','Set_OBJECT_Details',
510: itemtype,itemkey,actid,funcmode,l_error_msg);
511: raise;
512: WHEN OTHERS THEN

Line 514: p_encoded => FND_API.G_FALSE,

510: itemtype,itemkey,actid,funcmode,l_error_msg);
511: raise;
512: WHEN OTHERS THEN
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => l_msg_count,
516: p_data => l_msg_data
517: );
518: Handle_Err

Line 730: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

726: x_role_name => l_approver,
727: x_role_display_name => l_approver_display_name,
728: x_return_status => l_return_status ) ;
729:
730: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
731: RAISE FND_API.G_EXC_ERROR ;
732: END IF ;
733:
734: -- Get the current approver's display name, person who just approved the object

Line 731: RAISE FND_API.G_EXC_ERROR ;

727: x_role_display_name => l_approver_display_name,
728: x_return_status => l_return_status ) ;
729:
730: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
731: RAISE FND_API.G_EXC_ERROR ;
732: END IF ;
733:
734: -- Get the current approver's display name, person who just approved the object
735: l_prev_approver_disp_name := wf_engine.GetItemAttrText(

Line 802: WHEN FND_API.G_EXC_ERROR THEN

798: return;
799: END IF;
800:
801: EXCEPTION
802: WHEN FND_API.G_EXC_ERROR THEN
803: FND_MSG_PUB.Count_And_Get (
804: p_encoded => FND_API.G_FALSE,
805: p_count => l_msg_count,
806: p_data => l_msg_data

Line 804: p_encoded => FND_API.G_FALSE,

800:
801: EXCEPTION
802: WHEN FND_API.G_EXC_ERROR THEN
803: FND_MSG_PUB.Count_And_Get (
804: p_encoded => FND_API.G_FALSE,
805: p_count => l_msg_count,
806: p_data => l_msg_data
807: );
808: Handle_Err

Line 823: p_encoded => FND_API.G_FALSE,

819: resultout := 'COMPLETE:ERROR';
820: --RAISE;
821: WHEN OTHERS THEN
822: FND_MSG_PUB.Count_And_Get (
823: p_encoded => FND_API.G_FALSE,
824: p_count => l_msg_count,
825: p_data => l_msg_data
826: );
827: Handle_Err

Line 953: WHEN FND_API.G_EXC_ERROR THEN

949: resultout := 'COMPLETE:';
950: return;
951: END IF;
952: EXCEPTION
953: WHEN FND_API.G_EXC_ERROR THEN
954: FND_MSG_PUB.Count_And_Get (
955: p_encoded => FND_API.G_FALSE,
956: p_count => l_msg_count,
957: p_data => l_msg_data

Line 955: p_encoded => FND_API.G_FALSE,

951: END IF;
952: EXCEPTION
953: WHEN FND_API.G_EXC_ERROR THEN
954: FND_MSG_PUB.Count_And_Get (
955: p_encoded => FND_API.G_FALSE,
956: p_count => l_msg_count,
957: p_data => l_msg_data
958: );
959: Handle_Err

Line 973: p_encoded => FND_API.G_FALSE,

969: itemtype, itemkey,to_char(actid),l_error_msg);
970: RAISE;
971: WHEN OTHERS THEN
972: FND_MSG_PUB.Count_And_Get (
973: p_encoded => FND_API.G_FALSE,
974: p_count => l_msg_count,
975: p_data => l_msg_data
976: );
977: Handle_Err

Line 1078: p_encoded => FND_API.G_FALSE,

1074:
1075: IF resultout = 'COMPLETE:ERROR' then
1076:
1077: FND_MSG_PUB.Count_And_Get (
1078: p_encoded => FND_API.G_FALSE,
1079: p_count => l_msg_count,
1080: p_data => l_msg_data
1081: );
1082: Handle_Err

Line 1113: WHEN FND_API.G_EXC_ERROR THEN

1109: END IF;
1110: --
1111:
1112: EXCEPTION
1113: WHEN FND_API.G_EXC_ERROR THEN
1114: FND_MSG_PUB.Count_And_Get (
1115: p_encoded => FND_API.G_FALSE,
1116: p_count => l_msg_count,
1117: p_data => l_msg_data

Line 1115: p_encoded => FND_API.G_FALSE,

1111:
1112: EXCEPTION
1113: WHEN FND_API.G_EXC_ERROR THEN
1114: FND_MSG_PUB.Count_And_Get (
1115: p_encoded => FND_API.G_FALSE,
1116: p_count => l_msg_count,
1117: p_data => l_msg_data
1118: );
1119: Handle_Err

Line 1134: p_encoded => FND_API.G_FALSE,

1130: resultout := 'COMPLETE:ERROR';
1131: --RAISE;
1132: WHEN OTHERS THEN
1133: FND_MSG_PUB.Count_And_Get (
1134: p_encoded => FND_API.G_FALSE,
1135: p_count => l_msg_count,
1136: p_data => l_msg_data
1137: );
1138: Handle_Err

Line 1287: p_encoded => FND_API.G_FALSE,

1283: /*
1284: EXCEPTION
1285: WHEN OTHERS THEN
1286: FND_MSG_PUB.Count_And_Get (
1287: p_encoded => FND_API.G_FALSE,
1288: p_count => l_msg_count,
1289: p_data => l_msg_data
1290: );
1291: Handle_Err

Line 1361: p_encoded => FND_API.G_FALSE,

1357: /*
1358: EXCEPTION
1359: WHEN OTHERS THEN
1360: FND_MSG_PUB.Count_And_Get (
1361: p_encoded => FND_API.G_FALSE,
1362: p_count => l_msg_count,
1363: p_data => l_msg_data
1364: );
1365: Handle_Err

Line 1437: p_encoded => FND_API.G_FALSE,

1433: /*
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: FND_MSG_PUB.Count_And_Get (
1437: p_encoded => FND_API.G_FALSE,
1438: p_count => l_msg_count,
1439: p_data => l_msg_data
1440: );
1441: Handle_Err

Line 1512: p_encoded => FND_API.G_FALSE,

1508: /*
1509: EXCEPTION
1510: WHEN OTHERS THEN
1511: FND_MSG_PUB.Count_And_Get (
1512: p_encoded => FND_API.G_FALSE,
1513: p_count => l_msg_count,
1514: p_data => l_msg_data
1515: );
1516: Handle_Err

Line 1587: p_encoded => FND_API.G_FALSE,

1583: /*
1584: EXCEPTION
1585: WHEN OTHERS THEN
1586: FND_MSG_PUB.Count_And_Get (
1587: p_encoded => FND_API.G_FALSE,
1588: p_count => l_msg_count,
1589: p_data => l_msg_data
1590: );
1591: Handle_Err

Line 1896: WHEN FND_API.G_EXC_ERROR THEN

1892: funcmode => funcmode,
1893: resultout => resultout);
1894:
1895: EXCEPTION
1896: WHEN FND_API.G_EXC_ERROR THEN
1897: FND_MSG_PUB.Count_And_Get (
1898: p_encoded => FND_API.G_FALSE,
1899: p_count => l_msg_count,
1900: p_data => l_msg_data

Line 1898: p_encoded => FND_API.G_FALSE,

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

Line 1917: p_encoded => FND_API.G_FALSE,

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