APPS.IGS_PRECREATE_APPL_PUB dependencies on IGS_AD_GEN_016

Line 74: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

70: l_api_version CONSTANT NUMBER := '1.0';
71: l_api_name CONSTANT VARCHAR2(30) := 'PRE_CREATE_APPLICATION';
72: l_msg_index NUMBER;
73: l_return_status VARCHAR2(1);
74: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
75:
76: -- Cursor to validate person
77: CURSOR c_person(p_person_id hz_parties.party_id%TYPE) IS
78: SELECT party_id

Line 671: igs_ad_gen_016.extract_msg_from_stack (

667: -- Exception Handling
668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN
670: ROLLBACK TO PRE_CREATE_APPLICATION_pub;
671: igs_ad_gen_016.extract_msg_from_stack (
672: p_msg_at_index => l_msg_index,
673: p_return_status => l_return_status,
674: p_msg_count => x_msg_count,
675: p_msg_data => x_msg_data,

Line 689: igs_ad_gen_016.extract_msg_from_stack (

685: x_msg_count := x_msg_count-1;
686:
687: WHEN OTHERS THEN
688: ROLLBACK TO PRE_CREATE_APPLICATION_pub;
689: igs_ad_gen_016.extract_msg_from_stack (
690: p_msg_at_index => l_msg_index,
691: p_return_status => l_return_status,
692: p_msg_count => x_msg_count,
693: p_msg_data => x_msg_data,

Line 771: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

767: l_api_version CONSTANT NUMBER := '1.0';
768: l_api_name CONSTANT VARCHAR2(30) := 'PRE_CREATE_APPLICATION_INST';
769: l_msg_index NUMBER;
770: l_return_status VARCHAR2(1);
771: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
772:
773: /* ****************** PUT CURSOR DEFINITIONS FOR VALIDATION PURPOSE HERE ************************** */
774:
775: -- Cursor to validate Parent Application's Application Identifier

Line 1694: igs_ad_gen_016.extract_msg_from_stack (

1690: -- Exception Handling
1691: EXCEPTION
1692: WHEN FND_API.G_EXC_ERROR THEN
1693: ROLLBACK TO PRE_CREATE_APPL_INST_pub;
1694: igs_ad_gen_016.extract_msg_from_stack (
1695: p_msg_at_index => l_msg_index,
1696: p_return_status => l_return_status,
1697: p_msg_count => x_msg_count,
1698: p_msg_data => x_msg_data,

Line 1713: igs_ad_gen_016.extract_msg_from_stack (

1709:
1710:
1711: WHEN OTHERS THEN
1712: ROLLBACK TO PRE_CREATE_APPL_INST_pub;
1713: igs_ad_gen_016.extract_msg_from_stack (
1714: p_msg_at_index => l_msg_index,
1715: p_return_status => l_return_status,
1716: p_msg_count => x_msg_count,
1717: p_msg_data => x_msg_data,

Line 1762: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

1758: l_api_version CONSTANT NUMBER := '1.0';
1759: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_STG_FEE_REQ_DET';
1760: l_msg_index NUMBER;
1761: l_return_status VARCHAR2(1);
1762: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1763:
1764: CURSOR C_FEE_TYPE(p_APPL_FEE_TYPE IGS_AD_CODE_CLASSES.CODE_ID%TYPE) IS
1765: SELECT CC.CODE_ID
1766: FROM IGS_AD_CODE_CLASSES CC

Line 2019: igs_ad_gen_016.extract_msg_from_stack (

2015: EXCEPTION
2016: WHEN FND_API.G_EXC_ERROR THEN
2017:
2018: ROLLBACK TO INSERT_STG_FEE_REQ_DET_PUB;
2019: igs_ad_gen_016.extract_msg_from_stack (
2020: p_msg_at_index => l_msg_index,
2021: p_return_status => l_return_status,
2022: p_msg_count => x_msg_count,
2023: p_msg_data => x_msg_data,

Line 2038: igs_ad_gen_016.extract_msg_from_stack (

2034:
2035: WHEN OTHERS THEN
2036:
2037: ROLLBACK TO INSERT_STG_FEE_REQ_DET_PUB;
2038: igs_ad_gen_016.extract_msg_from_stack (
2039: p_msg_at_index => l_msg_index,
2040: p_return_status => l_return_status,
2041: p_msg_count => x_msg_count,
2042: p_msg_data => x_msg_data,