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_UTILITY_PVT dependencies on FND_API

Line 91: RETURN FND_API.g_false;

87: l_count := 0;
88: END;
89:
90: IF l_count = 0 THEN
91: RETURN FND_API.g_false;
92: ELSE
93: RETURN FND_API.g_true;
94: END IF;
95:

Line 93: RETURN FND_API.g_true;

89:
90: IF l_count = 0 THEN
91: RETURN FND_API.g_false;
92: ELSE
93: RETURN FND_API.g_true;
94: END IF;
95:
96: END check_fk_exists;
97:

Line 143: RETURN FND_API.g_false;

139: WHEN NO_DATA_FOUND THEN
140: l_count := 0;
141: END;
142: IF l_count = 0 THEN
143: RETURN FND_API.g_false;
144: ELSE
145: RETURN FND_API.g_true;
146: END IF;
147: END IF;

Line 145: RETURN FND_API.g_true;

141: END;
142: IF l_count = 0 THEN
143: RETURN FND_API.g_false;
144: ELSE
145: RETURN FND_API.g_true;
146: END IF;
147: END IF;
148:
149: END check_lookup_exists;

Line 196: RETURN FND_API.g_false;

192: FETCH cur_check_lookup_exists INTO l_count;
193: CLOSE cur_check_lookup_exists;
194:
195: IF l_count = 0 THEN
196: RETURN FND_API.g_false;
197: ELSE
198: RETURN FND_API.g_true;
199: END IF;
200:

Line 198: RETURN FND_API.g_true;

194:
195: IF l_count = 0 THEN
196: RETURN FND_API.g_false;
197: ELSE
198: RETURN FND_API.g_true;
199: END IF;
200:
201: END check_lookup_exists;
202:

Line 274: RETURN FND_API.g_true;

270: l_count := 0;
271: END;
272:
273: IF l_count = 0 THEN
274: RETURN FND_API.g_true;
275: ELSE
276: RETURN FND_API.g_false;
277: END IF;
278:

Line 276: RETURN FND_API.g_false;

272:
273: IF l_count = 0 THEN
274: RETURN FND_API.g_true;
275: ELSE
276: RETURN FND_API.g_false;
277: END IF;
278:
279: END check_uniqueness;
280:

Line 296: RETURN FND_API.g_true;

292: RETURN VARCHAR2
293: IS
294: BEGIN
295: IF p_value = 'Y' or p_value = 'N' THEN
296: RETURN FND_API.g_true;
297: ELSE
298: RETURN FND_API.g_false;
299: END IF;
300: END is_Y_or_N;

Line 298: RETURN FND_API.g_false;

294: BEGIN
295: IF p_value = 'Y' or p_value = 'N' THEN
296: RETURN FND_API.g_true;
297: ELSE
298: RETURN FND_API.g_false;
299: END IF;
300: END is_Y_or_N;
301:
302:

Line 318: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));

314: IS
315: BEGIN
316: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
317: FND_MESSAGE.set_name('AMW', 'AMW_API_DEBUG_MESSAGE');
318: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));
319: FND_MSG_PUB.add;
320: END IF;
321: END debug_message;
322:

Line 362: l_msg := FND_MSG_PUB.get(i, FND_API.g_false);

358: l_msg VARCHAR2(2000);
359: BEGIN
360: l_count := FND_MSG_PUB.count_msg;
361: FOR i IN 1 .. l_count LOOP
362: l_msg := FND_MSG_PUB.get(i, FND_API.g_false);
363: -- DBMS_OUTPUT.put_line('(' || i || ') ' || l_msg);
364: END LOOP;
365: END display_messages;
366:

Line 421: RAISE FND_API.g_exc_unexpected_error;

417: -- operator.
418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
419: FND_MESSAGE.set_name('AMW', 'AMW_UTIL_NO_WHERE_OPERATOR');
420: FND_MSG_PUB.add;
421: RAISE FND_API.g_exc_unexpected_error;
422: END IF;
423: ELSIF l_eq_pos > 0 AND l_not_pos = 0 THEN
424: l_curr_pos := l_eq_pos;
425: x_col_val_tbl(i).col_op := '=';

Line 478: x_return_status := FND_API.G_RET_STS_SUCCESS;

474: x_role_display_name OUT NOCOPY VARCHAR2 ,
475: x_return_status OUT NOCOPY VARCHAR2) IS
476: l_employee_id FND_USER.EMPLOYEE_ID%TYPE ;
477: BEGIN
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479:
480:
481: -- Pass the Employee Id (which is Person Id) to get the Role
482: WF_DIRECTORY.getrolename(

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: p_name => x_role_name,
486: p_display_name => x_role_display_name );
487:
488: IF x_role_name is null then
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MESSAGE.Set_Name('AMW','AMW_APPR_INVALID_ROLE');
491: FND_MSG_PUB.Add;
492: END IF;
493: END Get_person_Role;

Line 546: x_return_status := FND_API.G_RET_STS_SUCCESS;

542: l_display_role_name VARCHAR2(240);
543: l_notif_id NUMBER;
544:
545: BEGIN
546: x_return_status := FND_API.G_RET_STS_SUCCESS;
547: IF p_send_to_role_name IS NULL THEN
548:
549: AMW_UTILITY_PVT.get_person_role
550: ( p_person_id => p_send_to_person_id,

Line 556: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

552: x_role_display_name => l_display_role_name,
553: x_return_status => x_return_status
554: );
555:
556: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
557: return;
558: END IF;
559: END IF;
560: l_notif_id := WF_NOTIFICATION.Send

Line 720: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

716: p_status OUT nocopy varchar2,
717: p_dev_phase OUT nocopy varchar2,
718: p_dev_status OUT nocopy varchar2,
719: p_message OUT nocopy varchar2,
720: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
721: x_return_status out nocopy varchar2,
722: x_msg_count out nocopy number,
723: x_msg_data out nocopy varchar2
724: ) is

Line 731: x_return_status := FND_API.G_RET_STS_SUCCESS;

727: wait boolean;
728:
729: begin
730:
731: x_return_status := FND_API.G_RET_STS_SUCCESS;
732: IF FND_API.to_Boolean( p_init_msg_list ) THEN
733: FND_MSG_PUB.initialize;
734: END IF;
735: IF FND_GLOBAL.User_Id IS NULL THEN

Line 732: IF FND_API.to_Boolean( p_init_msg_list ) THEN

728:
729: begin
730:
731: x_return_status := FND_API.G_RET_STS_SUCCESS;
732: IF FND_API.to_Boolean( p_init_msg_list ) THEN
733: FND_MSG_PUB.initialize;
734: END IF;
735: IF FND_GLOBAL.User_Id IS NULL THEN
736: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 737: RAISE FND_API.G_EXC_ERROR;

733: FND_MSG_PUB.initialize;
734: END IF;
735: IF FND_GLOBAL.User_Id IS NULL THEN
736: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739:
740: wait := FND_CONCURRENT.WAIT_FOR_REQUEST(p_request_id, p_interval, p_max_wait, p_phase, p_status, p_dev_phase, p_dev_status, p_message);
741:

Line 744: WHEN FND_API.G_EXC_ERROR THEN

740: wait := FND_CONCURRENT.WAIT_FOR_REQUEST(p_request_id, p_interval, p_max_wait, p_phase, p_status, p_dev_phase, p_dev_status, p_message);
741:
742: exception
743:
744: WHEN FND_API.G_EXC_ERROR THEN
745: ROLLBACK;
746: x_return_status := FND_API.G_RET_STS_ERROR;
747: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
748:

Line 746: x_return_status := FND_API.G_RET_STS_ERROR;

742: exception
743:
744: WHEN FND_API.G_EXC_ERROR THEN
745: ROLLBACK;
746: x_return_status := FND_API.G_RET_STS_ERROR;
747: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK;

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

743:
744: WHEN FND_API.G_EXC_ERROR THEN
745: ROLLBACK;
746: x_return_status := FND_API.G_RET_STS_ERROR;
747: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

745: ROLLBACK;
746: x_return_status := FND_API.G_RET_STS_ERROR;
747: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
753:

Line 751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

747: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
753:
754: WHEN OTHERS THEN
755: ROLLBACK;

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

748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
753:
754: WHEN OTHERS THEN
755: ROLLBACK;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

752: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
753:
754: WHEN OTHERS THEN
755: ROLLBACK;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
758: THEN
759: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
760: END IF;

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

757: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
758: THEN
759: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
760: END IF;
761: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
762:
763: end wait_for_req;
764:
765:

Line 1008: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1004: p_pk IN number,
1005: p_userid IN number,
1006: p_objectContext IN varchar2,
1007: p_retval OUT nocopy varchar2,
1008: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1009: x_return_status out nocopy varchar2,
1010: x_msg_count out nocopy number,
1011: x_msg_data out nocopy varchar2
1012: ) is

Line 1020: x_return_status := FND_API.G_RET_STS_SUCCESS;

1016: f_party number;
1017:
1018: begin
1019:
1020: x_return_status := FND_API.G_RET_STS_SUCCESS;
1021: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1022: FND_MSG_PUB.initialize;
1023: END IF;
1024: IF FND_GLOBAL.User_Id IS NULL THEN

Line 1021: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1017:
1018: begin
1019:
1020: x_return_status := FND_API.G_RET_STS_SUCCESS;
1021: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1022: FND_MSG_PUB.initialize;
1023: END IF;
1024: IF FND_GLOBAL.User_Id IS NULL THEN
1025: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 1026: RAISE FND_API.G_EXC_ERROR;

1022: FND_MSG_PUB.initialize;
1023: END IF;
1024: IF FND_GLOBAL.User_Id IS NULL THEN
1025: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028:
1029: if (p_pk is null) or (p_userid is null) or (p_objectContext is null) then
1030: p_retval := 'N';

Line 1059: WHEN FND_API.G_EXC_ERROR THEN

1055:
1056:
1057: exception
1058:
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: ROLLBACK;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1063:

Line 1061: x_return_status := FND_API.G_RET_STS_ERROR;

1057: exception
1058:
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: ROLLBACK;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: ROLLBACK;

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

1058:
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: ROLLBACK;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: ROLLBACK;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1060: ROLLBACK;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: ROLLBACK;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1068:

Line 1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1062: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: ROLLBACK;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1068:
1069: WHEN OTHERS THEN
1070: ROLLBACK;

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

1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: ROLLBACK;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1068:
1069: WHEN OTHERS THEN
1070: ROLLBACK;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1067: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1068:
1069: WHEN OTHERS THEN
1070: ROLLBACK;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1073: THEN
1074: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1075: END IF;

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

1072: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1073: THEN
1074: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1075: END IF;
1076: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1077:
1078: end isUserProcessOwner;
1079:
1080: ---------------------------------------------------------------------