APPS.IGS_RATINGS_PUB dependencies on IGS_AD_GEN_016

Line 77: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

73: l_api_version CONSTANT NUMBER := 1.0;
74: l_api_name CONSTANT VARCHAR2(30) := 'REC_PGM_APPROVAL';
75: l_msg_index NUMBER := 0;
76: l_return_status VARCHAR2(1);
77: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
78: lv_rowid ROWID;
79: l_appl_pgmapprv_id NUMBER;
80:
81: BEGIN

Line 159: igs_ad_gen_016.extract_msg_from_stack (

155: WHEN FND_API.G_EXC_ERROR THEN
156: ROLLBACK TO Rec_Pgm_Approval_PUB;
157: x_return_status := FND_API.G_RET_STS_ERROR ;
158: -- Add message to API message list.
159: igs_ad_gen_016.extract_msg_from_stack (
160: p_msg_at_index => l_msg_index,
161: p_return_status => l_return_status,
162: p_msg_count => x_msg_count,
163: p_msg_data => x_msg_data,

Line 179: igs_ad_gen_016.extract_msg_from_stack (

175: WHEN OTHERS THEN
176: ROLLBACK TO Rec_Pgm_Approval_PUB;
177: x_return_status := FND_API.G_RET_STS_ERROR ;
178: -- Add message to API message list.
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 351: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

347: l_api_version CONSTANT NUMBER := 1.0;
348: l_api_name CONSTANT VARCHAR2(30) := 'ASSIGN_EVALUATORS_TO_AI';
349: l_msg_index NUMBER := 0;
350: l_return_status VARCHAR2(1);
351: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
352:
353: l_appl_arp_id igs_ad_appl_arp.appl_arp_id%TYPE ;
354: lv_rowid VARCHAR2(25) ;
355: l_errbuf VARCHAR2(100);

Line 545: igs_ad_gen_016.extract_msg_from_stack (

541:
542: EXCEPTION
543: WHEN OTHERS THEN
544: ROLLBACK TO ASSIGN_EVALUATORS_TO_AI_PUB;
545: igs_ad_gen_016.extract_msg_from_stack (
546: p_msg_at_index => l_msg_index,
547: p_return_status => l_return_status,
548: p_msg_count => x_msg_count,
549: p_msg_data => x_msg_data,

Line 570: igs_ad_gen_016.extract_msg_from_stack (

566: WHEN FND_API.G_EXC_ERROR THEN
567: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);
568: x_return_status := FND_API.G_RET_STS_ERROR ;
569: ROLLBACK TO ASSIGN_EVALUATORS_TO_AI_PUB;
570: igs_ad_gen_016.extract_msg_from_stack (
571: p_msg_at_index => l_msg_index,
572: p_return_status => l_return_status,
573: p_msg_count => x_msg_count,
574: p_msg_data => x_msg_data,

Line 581: igs_ad_gen_016.extract_msg_from_stack (

577: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'aFTER STACK Exception in API: FND_API.G_EXC_ERROR : '|| l_hash_msg_name_text_type_tab(x_msg_count-2).text);
578:
579: WHEN OTHERS THEN
580: ROLLBACK TO ASSIGN_EVALUATORS_TO_AI_PUB;
581: igs_ad_gen_016.extract_msg_from_stack (
582: p_msg_at_index => l_msg_index,
583: p_return_status => l_return_status,
584: p_msg_count => x_msg_count,
585: p_msg_data => x_msg_data,