APPS.IEX_CHECKLIST_UTILITY dependencies on IEX_CHECKLIST_UTILITY

Line 1: PACKAGE BODY IEX_CHECKLIST_UTILITY AS

1: PACKAGE BODY IEX_CHECKLIST_UTILITY AS
2: /* $Header: iexvchkb.pls 120.20.12020000.2 2012/07/24 19:13:26 schekuri ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_CHECKLIST_UTILITY';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvchkb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_CHECKLIST_UTILITY';

1: PACKAGE BODY IEX_CHECKLIST_UTILITY AS
2: /* $Header: iexvchkb.pls 120.20.12020000.2 2012/07/24 19:13:26 schekuri ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEX_CHECKLIST_UTILITY';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvchkb.pls';
6: G_APPL_ID NUMBER;
7: G_LOGIN_ID NUMBER;
8: G_PROGRAM_ID NUMBER;

Line 1463: iex_debug_pub.logmessage(' Start IEX_CHECKLIST_UTILITY.CHANGE_MULTIPLE_LEVEL procedure. Setting profiles');

1459: ELSE
1460: l_strategy_enabled := 'Y';
1461: END IF;
1462:
1463: iex_debug_pub.logmessage(' Start IEX_CHECKLIST_UTILITY.CHANGE_MULTIPLE_LEVEL procedure. Setting profiles');
1464: iex_debug_pub.logmessage (' Values of levels set -- Customer Level' || p_customer_level || 'Account Level' || p_account_level || 'BillTo Level' || p_billto_level);
1465: iex_debug_pub.logmessage ( ' Delinquency Level ' || p_delinquency_level || 'Party Override' || p_override_party_level || 'Operating Unit Override' || p_ou_running_level);
1466: iex_debug_pub.logmessage ( ' Promise enabled ' || l_promise_enabled || 'Strategy enabled ' || l_strategy_enabled);
1467:

Line 1732: iex_debug_pub.logmessage(' End procedure IEX_CHECKLIST_UTILITY.CHANGE_MULTIPLE_LEVEL . Successfully set the profile values');

1728: END IF;
1729: -- end bug 9818211
1730: END IF;
1731: x_return_status := 'S';
1732: iex_debug_pub.logmessage(' End procedure IEX_CHECKLIST_UTILITY.CHANGE_MULTIPLE_LEVEL . Successfully set the profile values');
1733:
1734: EXCEPTION
1735: WHEN OTHERS THEN
1736: x_return_status := 'F';

Line 1771: iex_debug_pub.logmessage(' In procedure IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP Begin updating multi level strategy set up in questionnaire table');

1767: open c_questionnaire_details;
1768: fetch c_questionnaire_details into l_business_level,l_using_customer_level,l_using_account_level,l_using_billto_level,
1769: l_using_delinquency_level,l_define_ou_running_level,l_define_party_running_level;
1770: close c_questionnaire_details;
1771: iex_debug_pub.logmessage(' In procedure IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP Begin updating multi level strategy set up in questionnaire table');
1772:
1773: c_str_upd := 'update iex_questionnaire_items set ';
1774: l_count := 0;
1775:

Line 1864: iex_debug_pub.logmessage('End Procedure IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP updating multi level set up in questionnaire table');

1860: Exception
1861: when others then
1862: iex_debug_pub.logmessage( ' Exception in executing SQL statement ' );
1863: End;
1864: iex_debug_pub.logmessage('End Procedure IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP updating multi level set up in questionnaire table');
1865:
1866: Exception
1867: When Others then
1868: iex_debug_pub.logmessage( ' Exception in updating ml set up' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

Line 1882: END IEX_CHECKLIST_UTILITY;

1878: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1879: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1880: G_USER_ID := FND_GLOBAL.User_Id;
1881: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
1882: END IEX_CHECKLIST_UTILITY;