23: p_param_value IN VARCHAR2,
24: p_param_name IN VARCHAR2 ) IS
25: BEGIN
26: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
27: fnd_message.set_name('IEX', 'IEX_API_ALL_INVALID_ARGUMENT');
28: fnd_message.set_token('API_NAME', p_api_name);
29: fnd_message.set_token('VALUE', p_param_value);
30: fnd_message.set_token('PARAMETER', p_param_name);
31: fnd_msg_pub.add;
24: p_param_name IN VARCHAR2 ) IS
25: BEGIN
26: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
27: fnd_message.set_name('IEX', 'IEX_API_ALL_INVALID_ARGUMENT');
28: fnd_message.set_token('API_NAME', p_api_name);
29: fnd_message.set_token('VALUE', p_param_value);
30: fnd_message.set_token('PARAMETER', p_param_name);
31: fnd_msg_pub.add;
32: END IF;
25: BEGIN
26: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
27: fnd_message.set_name('IEX', 'IEX_API_ALL_INVALID_ARGUMENT');
28: fnd_message.set_token('API_NAME', p_api_name);
29: fnd_message.set_token('VALUE', p_param_value);
30: fnd_message.set_token('PARAMETER', p_param_name);
31: fnd_msg_pub.add;
32: END IF;
33:
26: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
27: fnd_message.set_name('IEX', 'IEX_API_ALL_INVALID_ARGUMENT');
28: fnd_message.set_token('API_NAME', p_api_name);
29: fnd_message.set_token('VALUE', p_param_value);
30: fnd_message.set_token('PARAMETER', p_param_name);
31: fnd_msg_pub.add;
32: END IF;
33:
34:
42: ( p_api_name IN VARCHAR2,
43: p_param_name IN VARCHAR2 )IS
44: BEGIN
45: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
46: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
47: fnd_message.set_token('API_NAME', p_api_name);
48: fnd_message.set_token('MISSING_PARAM', p_param_name);
49: fnd_msg_pub.add;
50: END IF;
43: p_param_name IN VARCHAR2 )IS
44: BEGIN
45: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
46: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
47: fnd_message.set_token('API_NAME', p_api_name);
48: fnd_message.set_token('MISSING_PARAM', p_param_name);
49: fnd_msg_pub.add;
50: END IF;
51: END AddMissingArgMsg;
44: BEGIN
45: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
46: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
47: fnd_message.set_token('API_NAME', p_api_name);
48: fnd_message.set_token('MISSING_PARAM', p_param_name);
49: fnd_msg_pub.add;
50: END IF;
51: END AddMissingArgMsg;
52:
58: ( p_api_name IN VARCHAR2,
59: p_param_name IN VARCHAR2 )IS
60: BEGIN
61: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
62: fnd_message.set_name('IEX', 'IEX_API_ALL_NULL_PARAMETER');
63: fnd_message.set_token('API_NAME', p_api_name);
64: fnd_message.set_token('NULL_PARAM', p_param_name);
65: fnd_msg_pub.add;
66: END IF;
59: p_param_name IN VARCHAR2 )IS
60: BEGIN
61: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
62: fnd_message.set_name('IEX', 'IEX_API_ALL_NULL_PARAMETER');
63: fnd_message.set_token('API_NAME', p_api_name);
64: fnd_message.set_token('NULL_PARAM', p_param_name);
65: fnd_msg_pub.add;
66: END IF;
67:
60: BEGIN
61: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
62: fnd_message.set_name('IEX', 'IEX_API_ALL_NULL_PARAMETER');
63: fnd_message.set_token('API_NAME', p_api_name);
64: fnd_message.set_token('NULL_PARAM', p_param_name);
65: fnd_msg_pub.add;
66: END IF;
67:
68:
75: ( p_object IN VARCHAR2,
76: p_operation IN VARCHAR2 ) IS
77:
78: BEGIN
79: fnd_message.set_name('IEX', 'IEX_FAILED_OPERATION');
80: fnd_message.set_token('OBJECT', p_object);
81: fnd_message.set_token('OPERATION', p_operation);
82: fnd_msg_pub.add;
83:
76: p_operation IN VARCHAR2 ) IS
77:
78: BEGIN
79: fnd_message.set_name('IEX', 'IEX_FAILED_OPERATION');
80: fnd_message.set_token('OBJECT', p_object);
81: fnd_message.set_token('OPERATION', p_operation);
82: fnd_msg_pub.add;
83:
84: END AddfailMsg;
77:
78: BEGIN
79: fnd_message.set_name('IEX', 'IEX_FAILED_OPERATION');
80: fnd_message.set_token('OBJECT', p_object);
81: fnd_message.set_token('OPERATION', p_operation);
82: fnd_msg_pub.add;
83:
84: END AddfailMsg;
85:
977: IF FND_GLOBAL.User_Id IS NULL
978: THEN
979: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
980: THEN
981: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
982: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
983: FND_MSG_PUB.ADD;
984: END IF;
985: RAISE FND_API.G_EXC_ERROR;
978: THEN
979: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
980: THEN
981: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
982: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
983: FND_MSG_PUB.ADD;
984: END IF;
985: RAISE FND_API.G_EXC_ERROR;
986: END IF;
1390: IF FND_GLOBAL.User_Id IS NULL
1391: THEN
1392: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1393: THEN
1394: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
1395: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1396: FND_MSG_PUB.ADD;
1397: END IF;
1398: RAISE FND_API.G_EXC_ERROR;
1391: THEN
1392: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1393: THEN
1394: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
1395: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1396: FND_MSG_PUB.ADD;
1397: END IF;
1398: RAISE FND_API.G_EXC_ERROR;
1399: END IF;
1543: iex_debug_pub.logMessage('CreateCaseObjects: ' || 'Status of Create Case object PVT => '||l_return_status);
1544: END IF;
1545: -- Check return status from the above procedure call
1546: IF l_return_status = FND_API.G_RET_STS_ERROR then
1547: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CREATE_CO');
1548: FND_MSG_PUB.Add;
1549: raise FND_API.G_EXC_ERROR;
1550: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1551: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2015: IF FND_GLOBAL.User_Id IS NULL
2016: THEN
2017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2018: THEN
2019: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
2020: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2021: FND_MSG_PUB.ADD;
2022: END IF;
2023: RAISE FND_API.G_EXC_ERROR;
2016: THEN
2017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2018: THEN
2019: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
2020: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2021: FND_MSG_PUB.ADD;
2022: END IF;
2023: RAISE FND_API.G_EXC_ERROR;
2024: END IF;
2150: -- IF PG_DEBUG < 10 THEN
2151: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2152: iex_debug_pub.logmessage ('ReassignCaseObjects: ' || l_old_case_id || ' has later stage of delinquencies');
2153: END IF;
2154: fnd_message.set_name('IEX', 'IEX_ADVANCE_DEL_EXISTS');
2155: fnd_message.set_token('DEL_ID', x_del_id);
2156: fnd_message.set_token('CASE_ID',l_old_case_id);
2157: fnd_message.set_token('CON_NUM',l_contract_number);
2158: fnd_msg_pub.add;
2151: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2152: iex_debug_pub.logmessage ('ReassignCaseObjects: ' || l_old_case_id || ' has later stage of delinquencies');
2153: END IF;
2154: fnd_message.set_name('IEX', 'IEX_ADVANCE_DEL_EXISTS');
2155: fnd_message.set_token('DEL_ID', x_del_id);
2156: fnd_message.set_token('CASE_ID',l_old_case_id);
2157: fnd_message.set_token('CON_NUM',l_contract_number);
2158: fnd_msg_pub.add;
2159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: iex_debug_pub.logmessage ('ReassignCaseObjects: ' || l_old_case_id || ' has later stage of delinquencies');
2153: END IF;
2154: fnd_message.set_name('IEX', 'IEX_ADVANCE_DEL_EXISTS');
2155: fnd_message.set_token('DEL_ID', x_del_id);
2156: fnd_message.set_token('CASE_ID',l_old_case_id);
2157: fnd_message.set_token('CON_NUM',l_contract_number);
2158: fnd_msg_pub.add;
2159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2160:
2153: END IF;
2154: fnd_message.set_name('IEX', 'IEX_ADVANCE_DEL_EXISTS');
2155: fnd_message.set_token('DEL_ID', x_del_id);
2156: fnd_message.set_token('CASE_ID',l_old_case_id);
2157: fnd_message.set_token('CON_NUM',l_contract_number);
2158: fnd_msg_pub.add;
2159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2160:
2161: END IF;
2234: iex_debug_pub.logMessage('ReassignCaseObjects: ' || 'Status of Create Case object PVT => '||l_return_status);
2235: END IF;
2236: -- Check return status from the above procedure call
2237: IF l_return_status = FND_API.G_RET_STS_ERROR then
2238: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CREATE_CO');
2239: FND_MSG_PUB.Add;
2240: raise FND_API.G_EXC_ERROR;
2241: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
2242: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2576:
2577: if l_return_status <> 'S' THEN
2578:
2579: FND_MSG_PUB.initialize;
2580: fnd_message.set_name('IEX', 'IEX_CASE_NOTIFICATION');
2581: fnd_message.set_token('OLD_CASE',l_old_case_id);
2582: fnd_message.set_token('NEW_CASE',l_cas_id);
2583: fnd_message.set_token('CON_NUM',l_contract_number);
2584: fnd_msg_pub.add;
2577: if l_return_status <> 'S' THEN
2578:
2579: FND_MSG_PUB.initialize;
2580: fnd_message.set_name('IEX', 'IEX_CASE_NOTIFICATION');
2581: fnd_message.set_token('OLD_CASE',l_old_case_id);
2582: fnd_message.set_token('NEW_CASE',l_cas_id);
2583: fnd_message.set_token('CON_NUM',l_contract_number);
2584: fnd_msg_pub.add;
2585: x_return_status := 'N';
2578:
2579: FND_MSG_PUB.initialize;
2580: fnd_message.set_name('IEX', 'IEX_CASE_NOTIFICATION');
2581: fnd_message.set_token('OLD_CASE',l_old_case_id);
2582: fnd_message.set_token('NEW_CASE',l_cas_id);
2583: fnd_message.set_token('CON_NUM',l_contract_number);
2584: fnd_msg_pub.add;
2585: x_return_status := 'N';
2586: End if;
2579: FND_MSG_PUB.initialize;
2580: fnd_message.set_name('IEX', 'IEX_CASE_NOTIFICATION');
2581: fnd_message.set_token('OLD_CASE',l_old_case_id);
2582: fnd_message.set_token('NEW_CASE',l_cas_id);
2583: fnd_message.set_token('CON_NUM',l_contract_number);
2584: fnd_msg_pub.add;
2585: x_return_status := 'N';
2586: End if;
2587:
2691: IF FND_GLOBAL.User_Id IS NULL
2692: THEN
2693: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2694: THEN
2695: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
2696: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2697: FND_MSG_PUB.ADD;
2698: END IF;
2699: RAISE FND_API.G_EXC_ERROR;
2692: THEN
2693: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2694: THEN
2695: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
2696: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2697: FND_MSG_PUB.ADD;
2698: END IF;
2699: RAISE FND_API.G_EXC_ERROR;
2700: END IF;
2918: IF FND_GLOBAL.User_Id IS NULL
2919: THEN
2920: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2921: THEN
2922: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
2923: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2924: FND_MSG_PUB.ADD;
2925: END IF;
2926: RAISE FND_API.G_EXC_ERROR;
2919: THEN
2920: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2921: THEN
2922: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
2923: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2924: FND_MSG_PUB.ADD;
2925: END IF;
2926: RAISE FND_API.G_EXC_ERROR;
2927: END IF;