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

Line 11: --g_msg_list VARCHAR2 := FND_API.g_false;

7: g_api_version CONSTANT NUMBER := 1.0;
8: g_api_name CONSTANT VARCHAR2(30) := 'igs_get_dynamic_sql';
9: g_pkg_name CONSTANT VARCHAR2(30) := 'igs_dynamic_perid_group';
10: g_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| g_api_name;
11: --g_msg_list VARCHAR2 := FND_API.g_false;
12:
13:
14: /*==========================================================================+
15: | Name: IGS_GET_DYNAMIC_SQL(). |

Line 97: p_Status := FND_API.g_ret_sts_success;

93: IF NVL(lv_found,'N') = 'N' THEN
94: RAISE NO_DATA_FOUND;
95: END IF;
96: END IF;
97: p_Status := FND_API.g_ret_sts_success;
98:
99: RETURN l_SQL;
100:
101: EXCEPTION

Line 103: p_Status := FND_API.g_ret_sts_unexp_error ;

99: RETURN l_SQL;
100:
101: EXCEPTION
102: WHEN NO_DATA_FOUND THEN
103: p_Status := FND_API.g_ret_sts_unexp_error ;
104:
105: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
106: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);
107: END IF;

Line 109: p_encoded => FND_API.g_false,

105: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
106: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);
107: END IF;
108: FND_MSG_PUB.count_and_get(
109: p_encoded => FND_API.g_false,
110: p_count => x_Count,
111: p_data => x_Data
112: );
113: RETURN l_SQL_exp;

Line 114: WHEN FND_API.g_exc_error THEN

110: p_count => x_Count,
111: p_data => x_Data
112: );
113: RETURN l_SQL_exp;
114: WHEN FND_API.g_exc_error THEN
115: p_Status := FND_API.g_ret_sts_error;
116: FND_MSG_PUB.count_and_get(
117: p_encoded => FND_API.g_false,
118: p_count => x_Count,

Line 115: p_Status := FND_API.g_ret_sts_error;

111: p_data => x_Data
112: );
113: RETURN l_SQL_exp;
114: WHEN FND_API.g_exc_error THEN
115: p_Status := FND_API.g_ret_sts_error;
116: FND_MSG_PUB.count_and_get(
117: p_encoded => FND_API.g_false,
118: p_count => x_Count,
119: p_data => x_Data

Line 117: p_encoded => FND_API.g_false,

113: RETURN l_SQL_exp;
114: WHEN FND_API.g_exc_error THEN
115: p_Status := FND_API.g_ret_sts_error;
116: FND_MSG_PUB.count_and_get(
117: p_encoded => FND_API.g_false,
118: p_count => x_Count,
119: p_data => x_Data
120: );
121: RETURN l_SQL_exp;

Line 122: WHEN FND_API.g_exc_unexpected_error THEN

118: p_count => x_Count,
119: p_data => x_Data
120: );
121: RETURN l_SQL_exp;
122: WHEN FND_API.g_exc_unexpected_error THEN
123: p_Status := FND_API.g_ret_sts_unexp_error ;
124: FND_MSG_PUB.count_and_get(
125: p_encoded => FND_API.g_false,
126: p_count => x_count,

Line 123: p_Status := FND_API.g_ret_sts_unexp_error ;

119: p_data => x_Data
120: );
121: RETURN l_SQL_exp;
122: WHEN FND_API.g_exc_unexpected_error THEN
123: p_Status := FND_API.g_ret_sts_unexp_error ;
124: FND_MSG_PUB.count_and_get(
125: p_encoded => FND_API.g_false,
126: p_count => x_count,
127: p_data => x_data

Line 125: p_encoded => FND_API.g_false,

121: RETURN l_SQL_exp;
122: WHEN FND_API.g_exc_unexpected_error THEN
123: p_Status := FND_API.g_ret_sts_unexp_error ;
124: FND_MSG_PUB.count_and_get(
125: p_encoded => FND_API.g_false,
126: p_count => x_count,
127: p_data => x_data
128: );
129: RETURN l_SQL_exp;

Line 209: p_Status := FND_API.g_ret_sts_success;

205: IF NVL(lv_found,'N') = 'N' THEN
206: RAISE NO_DATA_FOUND;
207: END IF;
208: END IF;
209: p_Status := FND_API.g_ret_sts_success;
210: p_group_type := lv_group_type;
211: RETURN l_SQL;
212:
213: EXCEPTION

Line 215: p_Status := FND_API.g_ret_sts_unexp_error ;

211: RETURN l_SQL;
212:
213: EXCEPTION
214: WHEN NO_DATA_FOUND THEN
215: p_Status := FND_API.g_ret_sts_unexp_error ;
216:
217: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
218: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);
219: END IF;

Line 221: p_encoded => FND_API.g_false,

217: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
218: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);
219: END IF;
220: FND_MSG_PUB.count_and_get(
221: p_encoded => FND_API.g_false,
222: p_count => x_Count,
223: p_data => x_Data
224: );
225: RETURN l_SQL_exp;

Line 226: WHEN FND_API.g_exc_error THEN

222: p_count => x_Count,
223: p_data => x_Data
224: );
225: RETURN l_SQL_exp;
226: WHEN FND_API.g_exc_error THEN
227: p_Status := FND_API.g_ret_sts_error;
228: FND_MSG_PUB.count_and_get(
229: p_encoded => FND_API.g_false,
230: p_count => x_Count,

Line 227: p_Status := FND_API.g_ret_sts_error;

223: p_data => x_Data
224: );
225: RETURN l_SQL_exp;
226: WHEN FND_API.g_exc_error THEN
227: p_Status := FND_API.g_ret_sts_error;
228: FND_MSG_PUB.count_and_get(
229: p_encoded => FND_API.g_false,
230: p_count => x_Count,
231: p_data => x_Data

Line 229: p_encoded => FND_API.g_false,

225: RETURN l_SQL_exp;
226: WHEN FND_API.g_exc_error THEN
227: p_Status := FND_API.g_ret_sts_error;
228: FND_MSG_PUB.count_and_get(
229: p_encoded => FND_API.g_false,
230: p_count => x_Count,
231: p_data => x_Data
232: );
233: RETURN l_SQL_exp;

Line 234: WHEN FND_API.g_exc_unexpected_error THEN

230: p_count => x_Count,
231: p_data => x_Data
232: );
233: RETURN l_SQL_exp;
234: WHEN FND_API.g_exc_unexpected_error THEN
235: p_Status := FND_API.g_ret_sts_unexp_error ;
236: FND_MSG_PUB.count_and_get(
237: p_encoded => FND_API.g_false,
238: p_count => x_count,

Line 235: p_Status := FND_API.g_ret_sts_unexp_error ;

231: p_data => x_Data
232: );
233: RETURN l_SQL_exp;
234: WHEN FND_API.g_exc_unexpected_error THEN
235: p_Status := FND_API.g_ret_sts_unexp_error ;
236: FND_MSG_PUB.count_and_get(
237: p_encoded => FND_API.g_false,
238: p_count => x_count,
239: p_data => x_data

Line 237: p_encoded => FND_API.g_false,

233: RETURN l_SQL_exp;
234: WHEN FND_API.g_exc_unexpected_error THEN
235: p_Status := FND_API.g_ret_sts_unexp_error ;
236: FND_MSG_PUB.count_and_get(
237: p_encoded => FND_API.g_false,
238: p_count => x_count,
239: p_data => x_data
240: );
241: RETURN l_SQL_exp;

Line 504: p_Status := FND_API.g_ret_sts_success;

500: IF NVL(lv_found,'N') = 'N' THEN
501: RAISE NO_DATA_FOUND;
502: END IF;
503:
504: p_Status := FND_API.g_ret_sts_success;
505:
506: RETURN l_SQL;
507:
508: EXCEPTION

Line 510: p_Status := FND_API.g_ret_sts_unexp_error ;

506: RETURN l_SQL;
507:
508: EXCEPTION
509: WHEN NO_DATA_FOUND THEN
510: p_Status := FND_API.g_ret_sts_unexp_error ;
511:
512: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
513: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);
514: END IF;

Line 516: p_encoded => FND_API.g_false,

512: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
513: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_api_name);
514: END IF;
515: FND_MSG_PUB.count_and_get(
516: p_encoded => FND_API.g_false,
517: p_count => x_Count,
518: p_data => x_Data
519: );
520: RETURN l_SQL_exp;

Line 521: WHEN FND_API.g_exc_error THEN

517: p_count => x_Count,
518: p_data => x_Data
519: );
520: RETURN l_SQL_exp;
521: WHEN FND_API.g_exc_error THEN
522: p_Status := FND_API.g_ret_sts_error;
523: FND_MSG_PUB.count_and_get(
524: p_encoded => FND_API.g_false,
525: p_count => x_Count,

Line 522: p_Status := FND_API.g_ret_sts_error;

518: p_data => x_Data
519: );
520: RETURN l_SQL_exp;
521: WHEN FND_API.g_exc_error THEN
522: p_Status := FND_API.g_ret_sts_error;
523: FND_MSG_PUB.count_and_get(
524: p_encoded => FND_API.g_false,
525: p_count => x_Count,
526: p_data => x_Data

Line 524: p_encoded => FND_API.g_false,

520: RETURN l_SQL_exp;
521: WHEN FND_API.g_exc_error THEN
522: p_Status := FND_API.g_ret_sts_error;
523: FND_MSG_PUB.count_and_get(
524: p_encoded => FND_API.g_false,
525: p_count => x_Count,
526: p_data => x_Data
527: );
528: RETURN l_SQL_exp;

Line 529: WHEN FND_API.g_exc_unexpected_error THEN

525: p_count => x_Count,
526: p_data => x_Data
527: );
528: RETURN l_SQL_exp;
529: WHEN FND_API.g_exc_unexpected_error THEN
530: p_Status := FND_API.g_ret_sts_unexp_error ;
531: FND_MSG_PUB.count_and_get(
532: p_encoded => FND_API.g_false,
533: p_count => x_count,

Line 530: p_Status := FND_API.g_ret_sts_unexp_error ;

526: p_data => x_Data
527: );
528: RETURN l_SQL_exp;
529: WHEN FND_API.g_exc_unexpected_error THEN
530: p_Status := FND_API.g_ret_sts_unexp_error ;
531: FND_MSG_PUB.count_and_get(
532: p_encoded => FND_API.g_false,
533: p_count => x_count,
534: p_data => x_data

Line 532: p_encoded => FND_API.g_false,

528: RETURN l_SQL_exp;
529: WHEN FND_API.g_exc_unexpected_error THEN
530: p_Status := FND_API.g_ret_sts_unexp_error ;
531: FND_MSG_PUB.count_and_get(
532: p_encoded => FND_API.g_false,
533: p_count => x_count,
534: p_data => x_data
535: );
536: RETURN l_SQL_exp;