DBA Data[Home] [Help]

APPS.IGS_ADMAPPLICATION_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) := 'RECORD_ACADEMIC_INDEX';
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:
70:
71:
72:

Line 342: igs_ad_gen_016.extract_msg_from_stack (

338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN
340: ROLLBACK TO RECORD_ACADEMIC_INDEX_pub;
341: x_return_status := FND_API.G_RET_STS_ERROR ;
342: igs_ad_gen_016.extract_msg_from_stack (
343: p_msg_at_index => l_msg_index,
344: p_return_status => l_return_status,
345: p_msg_count => x_msg_count,
346: p_msg_data => x_msg_data,

Line 366: igs_ad_gen_016.extract_msg_from_stack (

362: p_data => x_msg_data);
363:
364: WHEN OTHERS THEN
365: ROLLBACK TO RECORD_ACADEMIC_INDEX_pub;
366: igs_ad_gen_016.extract_msg_from_stack (
367: p_msg_at_index => l_msg_index,
368: p_return_status => l_return_status,
369: p_msg_count => x_msg_count,
370: p_msg_data => x_msg_data,

Line 510: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

506:
507: l_req_for_reconsideration_ind VARCHAR2(1);
508: v_message_name VARCHAR2(2000);
509:
510: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
511: l_msg_index NUMBER := 0;
512:
513: --begin apadegal ADTD001 IGS.M
514: lv_return_status VARCHAR2(10);

Line 1126: igs_ad_gen_016.extract_msg_from_stack(p_msg_at_index => l_msg_index,

1122: -- end apadegal adtd001 igs.m
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125: ROLLBACK TO Record_Outcome_AdmAppl_pub;
1126: igs_ad_gen_016.extract_msg_from_stack(p_msg_at_index => l_msg_index,
1127: p_return_status => x_return_status,
1128: p_msg_count => x_msg_count,
1129: p_msg_data => x_msg_data,
1130: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);

Line 1239: igs_ad_gen_016.extract_msg_from_stack(p_msg_at_index => l_msg_index,

1235: EXCEPTION
1236: WHEN FND_API.G_EXC_ERROR THEN
1237: ROLLBACK TO Record_Outcome_AdmAppl_pub;
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: igs_ad_gen_016.extract_msg_from_stack(p_msg_at_index => l_msg_index,
1240: p_return_status => x_return_status,
1241: p_msg_count => x_msg_count,
1242: p_msg_data => x_msg_data,
1243: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);

Line 1261: igs_ad_gen_016.extract_msg_from_stack(p_msg_at_index => l_msg_index,

1257: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1258: p_data => x_msg_data);
1259: WHEN OTHERS THEN
1260: ROLLBACK TO Record_Outcome_AdmAppl_pub;
1261: igs_ad_gen_016.extract_msg_from_stack(p_msg_at_index => l_msg_index,
1262: p_return_status => x_return_status,
1263: p_msg_count => x_msg_count,
1264: p_msg_data => x_msg_data,
1265: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);

Line 1720: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

1716: l_api_version CONSTANT NUMBER := '2.0';
1717: l_api_name CONSTANT VARCHAR2(30) := 'RECORD_OFFER_RESPONSE';
1718: l_msg_index NUMBER;
1719: l_return_status VARCHAR2(1);
1720: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1721: l_validation_success VARCHAR2(1);
1722: l_calc_actual_response_dt DATE;
1723: l_adm_offer_dfrmnt_status VARCHAR2(10);
1724:

Line 2055: igs_ad_gen_016.extract_msg_from_stack (

2051:
2052: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);
2053: ROLLBACK TO s_RECORD_OFFER_RESPONSE_pub;
2054: x_return_status := FND_API.G_RET_STS_ERROR ;
2055: igs_ad_gen_016.extract_msg_from_stack (
2056: p_msg_at_index => l_msg_index,
2057: p_return_status => l_return_status,
2058: p_msg_count => x_msg_count,
2059: p_msg_data => x_msg_data,

Line 2070: igs_ad_gen_016.extract_msg_from_stack (

2066: WHEN OTHERS THEN
2067: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);
2068: ROLLBACK TO s_RECORD_OFFER_RESPONSE_pub;
2069: x_return_status := FND_API.G_RET_STS_ERROR ;
2070: igs_ad_gen_016.extract_msg_from_stack (
2071: p_msg_at_index => l_msg_index,
2072: p_return_status => l_return_status,
2073: p_msg_count => x_msg_count,
2074: p_msg_data => x_msg_data,

Line 2104: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

2100: l_api_version CONSTANT NUMBER := '1.0';
2101: l_api_name CONSTANT VARCHAR2(30) := 'RECORD_QUALIFICATION_CODE';
2102: l_msg_index NUMBER;
2103: l_return_status VARCHAR2(1);
2104: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
2105:
2106: l_qualifying_type_code VARCHAR2(30);
2107: l_qualifying_code VARCHAR2(30);
2108: l_qualifying_value VARCHAR2(80);

Line 2350: igs_ad_gen_016.extract_msg_from_stack (

2346: EXCEPTION
2347: WHEN FND_API.G_EXC_ERROR THEN
2348: ROLLBACK TO RECORD_QUALIFICATION_CODE_pub;
2349: x_return_status := FND_API.G_RET_STS_ERROR ;
2350: igs_ad_gen_016.extract_msg_from_stack (
2351: p_msg_at_index => l_msg_index,
2352: p_return_status => l_return_status,
2353: p_msg_count => x_msg_count,
2354: p_msg_data => x_msg_data,

Line 2383: igs_ad_gen_016.extract_msg_from_stack (

2379: p_data => x_msg_data);
2380:
2381: WHEN OTHERS THEN
2382: ROLLBACK TO RECORD_QUALIFICATION_CODE_pub;
2383: igs_ad_gen_016.extract_msg_from_stack (
2384: p_msg_at_index => l_msg_index,
2385: p_return_status => l_return_status,
2386: p_msg_count => x_msg_count,
2387: p_msg_data => x_msg_data,

Line 2422: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

2418: l_api_version CONSTANT NUMBER := '1.0';
2419: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ENTRY_QUAL_STATUS';
2420: l_msg_index NUMBER;
2421: l_return_status VARCHAR2(1);
2422: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
2423: l_entry_qual_status VARCHAR2(10);
2424: v_message_name VARCHAR2(30);
2425:
2426:

Line 2709: igs_ad_gen_016.extract_msg_from_stack (

2705:
2706: ROLLBACK TO UPDATE_ENTRY_QUAL_STATUS_SAVE;
2707: x_return_status := FND_API.G_RET_STS_ERROR;
2708:
2709: igs_ad_gen_016.extract_msg_from_stack (
2710: p_msg_at_index => l_msg_index,
2711: p_return_status => l_return_status,
2712: p_msg_count => x_msg_count,
2713: p_msg_data => x_msg_data,

Line 2751: igs_ad_gen_016.extract_msg_from_stack (

2747:
2748: WHEN OTHERS THEN
2749:
2750: ROLLBACK TO UPDATE_ENTRY_QUAL_STATUS_SAVE;
2751: igs_ad_gen_016.extract_msg_from_stack (
2752: p_msg_at_index => l_msg_index,
2753: p_return_status => l_return_status,
2754: p_msg_count => x_msg_count,
2755: p_msg_data => x_msg_data,