APPS.IGS_PERSONSTATS_PUB dependencies on IGS_AD_GEN_016

Line 68: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

64: l_api_version CONSTANT NUMBER := '1.0';
65: l_api_name CONSTANT VARCHAR2(30) := 'REDERIVE_PERSONSTATS';
66: l_msg_index NUMBER;
67: l_return_status VARCHAR2(1);
68: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
69: l_ctr NUMBER DEFAULT 0;
70: l_person_id NUMBER;
71: l_group_id NUMBER;
72: l_ind_g_exec_error BOOLEAN DEFAULT FALSE; -- individual unexpected err occured

Line 162: igs_ad_gen_016.extract_msg_from_stack (

158: EXCEPTION
159: WHEN FND_API.G_EXC_ERROR THEN
160: ROLLBACK TO REDERIVE_PERSON_STATS_PUB;
161: x_return_status := FND_API.G_RET_STS_ERROR ;
162: igs_ad_gen_016.extract_msg_from_stack (
163: p_msg_at_index => l_msg_index,
164: p_return_status => l_return_status,
165: p_msg_count => x_msg_count,
166: p_msg_data => x_msg_data,

Line 179: igs_ad_gen_016.extract_msg_from_stack (

175: p_data => x_msg_data);
176:
177: WHEN OTHERS THEN
178: ROLLBACK TO REDERIVE_PERSON_STATS_PUB;
179: igs_ad_gen_016.extract_msg_from_stack (
180: p_msg_at_index => l_msg_index,
181: p_return_status => l_return_status,
182: p_msg_count => x_msg_count,
183: p_msg_data => x_msg_data,

Line 216: igs_ad_gen_016.extract_msg_from_stack (

212: WHEN FND_API.G_EXC_ERROR THEN
213: l_ind_g_exec_error := TRUE;
214: ROLLBACK TO REDERIVE_PERSON_STATS_PUB;
215: x_return_status_tbl(l_ctr).sub_return_status := FND_API.G_RET_STS_ERROR ;
216: igs_ad_gen_016.extract_msg_from_stack (
217: p_msg_at_index => l_msg_index,
218: p_return_status => l_return_status,
219: p_msg_count => x_return_status_tbl(l_ctr).sub_msg_count,
220: p_msg_data => x_return_status_tbl(l_ctr).sub_msg_data,

Line 236: igs_ad_gen_016.extract_msg_from_stack (

232: WHEN OTHERS THEN
233:
234: ROLLBACK TO REDERIVE_PERSON_STATS_PUB;
235:
236: igs_ad_gen_016.extract_msg_from_stack (
237: p_msg_at_index => l_msg_index,
238: p_return_status => l_return_status,
239: p_msg_count => x_return_status_tbl(l_ctr).sub_msg_count,
240: p_msg_data => x_return_status_tbl(l_ctr).sub_msg_data,

Line 267: igs_ad_gen_016.extract_msg_from_stack (

263: EXCEPTION ---- This expection block is for the whole api.
264: WHEN FND_API.G_EXC_ERROR THEN
265:
266: x_return_status := FND_API.G_RET_STS_ERROR ;
267: igs_ad_gen_016.extract_msg_from_stack (
268: p_msg_at_index => l_msg_index,
269: p_return_status => l_return_status,
270: p_msg_count => x_msg_count,
271: p_msg_data => x_msg_data,

Line 285: igs_ad_gen_016.extract_msg_from_stack (

281:
282: WHEN OTHERS THEN
283:
284:
285: igs_ad_gen_016.extract_msg_from_stack (
286: p_msg_at_index => l_msg_index,
287: p_return_status => l_return_status,
288: p_msg_count => x_msg_count,
289: p_msg_data => x_msg_data,