DBA Data[Home] [Help]

APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on JTF_DEBUG_PUB

Line 5: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME);

1: PACKAGE BODY JTF_UM_USERTYPE_CREDENTIALS as
2: /* $Header: JTFUMUCB.pls 120.18.12020000.2 2012/07/18 16:11:01 anurtrip ship $ */
3:
4: MODULE_NAME CONSTANT VARCHAR2(50) := 'JTF.UM.PLSQL.JTF_UM_USERTYPE_CREDENTIALS';
5: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME);
6:
7:
8:
9: PROCEDURE CREATE_ACCOUNT

Line 37: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

33: l_procedure_name varchar2(30) := 'CREATE_ACCOUNT';
34:
35: l_gen_cust_no VARCHAR2(1);
36: BEGIN
37: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
38: p_message => l_procedure_name);
39:
40:
41:

Line 46: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

42:
43: l_party_type := JTF_UM_UTIL_PVT.check_party_type(P_PARTY_ID);
44:
45: if l_is_debug_parameter_on then
46: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
47: p_message =>'l_party_type:' || l_party_type
48: );
49: end if;
50:

Line 115: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

111: x_profile_id => x_profile_id
112: );
113:
114: if l_is_debug_parameter_on then
115: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
116: p_message =>'X_return_status@create_account:' ||x_return_status
117: );
118: end if;
119:

Line 123: jtf_debug_pub.log_exception(p_module => MODULE_NAME

119:
120: end if;
121: if(x_return_status <> fnd_api.g_ret_sts_success)
122: then
123: jtf_debug_pub.log_exception(p_module => MODULE_NAME
124: ,p_message => ' message stack in account creation:'||x_msg_data);
125: raise_application_error(-20101,'Failed to create account:'||x_msg_data);
126:
127: end if;

Line 204: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

200: */
201:
202:
203: BEGIN
204: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
205: p_message => l_procedure_name);
206:
207:
208:

Line 210: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

206:
207:
208:
209: if l_is_debug_parameter_on then
210: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
211: p_message =>'X_USER_ID:' || X_USER_ID
212: );
213: end if;
214: OPEN CUSTOMER_ID;

Line 240: JTF_DEBUG_PUB.LOG_PARAMETERS

236:
237:
238:
239: IF l_is_debug_parameter_on THEN
240: JTF_DEBUG_PUB.LOG_PARAMETERS
241: (p_module => MODULE_NAME,
242: p_message =>'P_PARTY_ID' ||P_PARTY_ID||'+ P_SUBJECT_ID'||P_SUBJECT_ID
243: );
244: END IF;

Line 271: JTF_DEBUG_PUB.LOG_PARAMETERS

267: END IF;
268:
269:
270: if l_is_debug_parameter_on then
271: JTF_DEBUG_PUB.LOG_PARAMETERS
272: (p_module => MODULE_NAME,
273: p_message =>'L_ACCT_CNT:'||L_ACCT_CNT
274: );
275: end if;

Line 528: jtf_debug_pub.log_exception(p_module => MODULE_NAME,p_message => ' Error in setApproverNotifPref code:'||errCode||', msg: '||errMsg);

524: when others then
525: begin
526: errCode := sqlcode;
527: errMsg := sqlerrm;
528: jtf_debug_pub.log_exception(p_module => MODULE_NAME,p_message => ' Error in setApproverNotifPref code:'||errCode||', msg: '||errMsg);
529: exception
530: when others then
531: null;
532: end;

Line 595: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

591:
592:
593: BEGIN
594:
595: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
596: p_message => l_procedure_name
597: );
598:
599: if l_is_debug_parameter_on then

Line 600: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

596: p_message => l_procedure_name
597: );
598:
599: if l_is_debug_parameter_on then
600: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
601: p_message => 'X_USER_NAME:' || X_USER_NAME || '+' || 'X_USER_ID:' || X_USER_ID || '+' || 'X_USERTYPE_ID:' || X_USERTYPE_ID
602: );
603: end if;
604:

Line 748: JTF_DEBUG_PUB.LOG_DEBUG (2, MODULE_NAME, 'Start Raising Event');

744:
745: -- raise event for Approval : 4276972
746: -- Get the values for creation of parameters for the event
747:
748: JTF_DEBUG_PUB.LOG_DEBUG (2, MODULE_NAME, 'Start Raising Event');
749:
750: Select ut.APPLICATION_ID,ut.USERTYPE_KEY,reg.USERTYPE_REG_ID
751: Into l_app_id, l_usertype_key, l_usertype_reg_id
752: From JTF_UM_USERTYPES_B ut , JTF_UM_USERTYPE_REG reg

Line 757: JTF_DEBUG_PUB.LOG_DEBUG (2, MODULE_NAME, 'Parameters '|| l_app_id ||' '||l_usertype_key|| ' '||l_usertype_reg_id );

753: where ut.USERTYPE_ID=reg.USERTYPE_ID and reg.USER_ID=X_USER_ID
754: and reg.status_code='APPROVED' and
755: nvl(reg.EFFECTIVE_END_DATE,sysdate+1) > sysdate;
756:
757: JTF_DEBUG_PUB.LOG_DEBUG (2, MODULE_NAME, 'Parameters '|| l_app_id ||' '||l_usertype_key|| ' '||l_usertype_reg_id );
758:
759: -- create the parameter list
760: wf_event.AddParameterToList(
761: p_name => 'USERTYPEREG_ID',

Line 789: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

785:
786: -- end of event handling
787:
788:
789: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
790: p_message => l_procedure_name
791: );
792:
793:

Line 825: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

821: cust_acct_roles_rec HZ_CUST_ACCOUNT_ROLE_V2PUB.CUST_ACCOUNT_ROLE_REC_TYPE;
822:
823: l_procedure_name varchar2(30) := 'ASSIGN_ACCOUNT';
824: BEGIN
825: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
826: p_message => l_procedure_name);
827:
828:
829:

Line 838: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

834:
835: l_party_type := JTF_UM_UTIL_PVT.check_party_type(P_PARTY_ID);
836:
837: if l_is_debug_parameter_on then
838: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
839: p_message =>'l_party_type:' || l_party_type
840: );
841: end if;
842:

Line 893: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

889: x_party_number => x_party_number,
890: x_profile_id => x_profile_id
891: );
892: if l_is_debug_parameter_on then
893: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
894: p_message =>'X_return_status@create_account:' ||x_return_status
895: );
896: end if;
897:

Line 901: jtf_debug_pub.log_exception(p_module => MODULE_NAME

897:
898: end if;
899: if(x_return_status <> fnd_api.g_ret_sts_success)
900: then
901: jtf_debug_pub.log_exception(p_module => MODULE_NAME
902: ,p_message => ' message stack in account creation:'||x_msg_data);
903: raise_application_error(-20101,'Failed to create account:'||x_msg_data);
904:
905: end if;

Line 1129: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1125: AND UTRESP.RESPONSIBILITY_KEY = FURESP.RESPONSIBILITY_KEY;
1126:
1127: BEGIN
1128:
1129: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1130: p_message => l_procedure_name
1131: );
1132: if l_is_debug_parameter_on then
1133: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

Line 1133: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1129: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1130: p_message => l_procedure_name
1131: );
1132: if l_is_debug_parameter_on then
1133: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1134: p_message => 'p_usertype_id:' || p_usertype_id
1135: );
1136: end if;
1137:

Line 1142: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

1138: OPEN FIND_UT_RESP;
1139: FETCH FIND_UT_RESP INTO p_app_id, p_resp_id;
1140: CLOSE FIND_UT_RESP;
1141:
1142: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1143: p_message => l_procedure_name
1144: );
1145:
1146: END get_usertype_resp;

Line 1260: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1256: p_assign_def_appl boolean;
1257:
1258: BEGIN
1259:
1260: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1261: p_message => l_procedure_name
1262: );
1263: if l_is_debug_parameter_on then
1264: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

Line 1264: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1260: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1261: p_message => l_procedure_name
1262: );
1263: if l_is_debug_parameter_on then
1264: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1265: p_message => 'p_user_id:' || p_user_id || '+' || 'p_resp_id:' || p_resp_id || '+' || 'p_app_id:' || p_app_id
1266: );
1267: end if;
1268:

Line 1281: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

1277: X_VALUE => p_app_id,
1278: X_LEVEL_NAME => 'USER',
1279: X_LEVEL_VALUE => p_user_id);
1280:
1281: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1282: p_message => l_procedure_name
1283: );
1284: END set_default_login_resp;
1285:

Line 1320: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1316: l_procedure_name CONSTANT varchar2(30) := 'set_default_login_resp';
1317:
1318: BEGIN
1319:
1320: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1321: p_message => l_procedure_name
1322: );
1323: if l_is_debug_parameter_on then
1324: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

Line 1324: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1320: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1321: p_message => l_procedure_name
1322: );
1323: if l_is_debug_parameter_on then
1324: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1325: p_message => 'p_user_name:' || p_user_name || '+' || 'p_resp_id:' || p_resp_id || '+' || 'p_app_id:' || p_app_id
1326: );
1327: end if;
1328:

Line 1337: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

1333: p_app_id => p_app_id
1334: );
1335:
1336:
1337: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1338: p_message => l_procedure_name
1339: );
1340:
1341: END set_default_login_resp;

Line 1384: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1380:
1381:
1382: BEGIN
1383:
1384: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1385: p_message => l_procedure_name
1386: );
1387: if l_is_debug_parameter_on then
1388: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

Line 1388: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1384: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1385: p_message => l_procedure_name
1386: );
1387: if l_is_debug_parameter_on then
1388: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1389: p_message => 'p_user_name:' || p_user_name
1390: );
1391: end if;
1392:

Line 1403: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

1399: x_resp_name => x_resp_name
1400: );
1401:
1402:
1403: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1404: p_message => l_procedure_name
1405: );
1406:
1407: END get_default_login_resp;

Line 1455: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1451: AND APPLICATION_ID = x_app_id;
1452:
1453: BEGIN
1454:
1455: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1456: p_message => l_procedure_name
1457: );
1458: if l_is_debug_parameter_on then
1459: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

Line 1459: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1455: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1456: p_message => l_procedure_name
1457: );
1458: if l_is_debug_parameter_on then
1459: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1460: p_message => 'p_user_id:' || p_user_id
1461: );
1462: end if;
1463:

Line 1482: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

1478: OPEN FIND_RESP_INFO;
1479: FETCH FIND_RESP_INFO INTO x_resp_key,x_resp_name;
1480: CLOSE FIND_RESP_INFO;
1481:
1482: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1483: p_message => l_procedure_name
1484: );
1485:
1486: