eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_UM_SUBSCRIPTIONS_PKG dependencies on JTF_DEBUG_PUB

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

1: package body JTF_UM_SUBSCRIPTIONS_PKG as
2: /* $Header: JTFUMSBB.pls 120.4 2006/01/16 01:26:40 vimohan ship $ */
3: MODULE_NAME CONSTANT VARCHAR2(50) := 'JTF.UM.PLSQL.JTF_UM_SUBSCRIPTIONS_PKG';
4: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME);
5:
6: procedure INSERT_ROW (
7: X_SUBSCRIPTION_ID out NOCOPY NUMBER,
8: X_APPLICATION_ID in NUMBER,

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

731: l_flag_value VARCHAR2(1) := 'N';
732:
733: begin
734:
735: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
736: p_message => l_procedure_name
737: );
738:
739: if l_is_debug_parameter_on then

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

736: p_message => l_procedure_name
737: );
738:
739: if l_is_debug_parameter_on then
740: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
741: p_message => 'p_subscription_reg_id:' || p_subscription_reg_id || '+' || 'p_grant_delegation_flag:' || JTF_DBSTRING_UTILS.getBooleanString(p_grant_delegation_flag)
742: );
743: end if;
744:

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

751:
752: UPDATE JTF_UM_SUBSCRIPTION_REG SET GRANT_DELEGATION_FLAG = l_flag_value
753: WHERE SUBSCRIPTION_REG_ID = p_subscription_reg_id ;
754:
755: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
756: p_message => l_procedure_name
757: );
758:
759: end update_grant_delegation_flag;

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

808: l_role_id NUMBER;
809:
810: begin
811:
812: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
813: p_message => l_procedure_name
814: );
815:
816: if l_is_debug_parameter_on then

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

813: p_message => l_procedure_name
814: );
815:
816: if l_is_debug_parameter_on then
817: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
818: p_message => 'p_subscription_reg_id:' || p_subscription_reg_id || '+' || 'p_grant_delegation_flag:'
819: || p_grant_delegation_flag || '+' || 'p_grant_delegation_role:' || p_grant_delegation_role
820: );
821: end if;

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

863: END IF;
864:
865: END IF;
866:
867: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
868: p_message => l_procedure_name
869: );
870:
871: END update_grant_delegation_flag;

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

906: l_grant_delegation_flag boolean := false;
907:
908: begin
909:
910: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
911: p_message => l_procedure_name
912: );
913:
914: if l_is_debug_parameter_on then

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

911: p_message => l_procedure_name
912: );
913:
914: if l_is_debug_parameter_on then
915: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
916: p_message => 'p_subscription_reg_id:' || p_subscription_reg_id || '+' || 'p_grant_delegation_flag:' || p_grant_delegation_flag
917: );
918: end if;
919:

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

926: p_subscription_reg_id => p_subscription_reg_id,
927: p_grant_delegation_flag => l_grant_delegation_flag
928: );
929:
930: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
931: p_message => l_procedure_name
932: );
933:
934: end update_grant_delegation_flag;

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

984: l_subscription_reg_id JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_REG_ID%TYPE;
985:
986: begin
987:
988: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
989: p_message => l_procedure_name
990: );
991:
992: if l_is_debug_parameter_on then

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

989: p_message => l_procedure_name
990: );
991:
992: if l_is_debug_parameter_on then
993: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
994: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_user_name:' || p_user_name || '+' || 'p_grant_delegation_flag:' || JTF_DBSTRING_UTILS.getBooleanString(p_grant_delegation_flag)
995: );
996: end if;
997:

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

1007:
1008: END IF;
1009: CLOSE FIND_REG_ID;
1010:
1011: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1012: p_message => l_procedure_name
1013: );
1014:
1015: end update_grant_delegation_flag;

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

1054: l_grant_delegation_flag boolean := false;
1055:
1056: begin
1057:
1058: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1059: p_message => l_procedure_name
1060: );
1061:
1062: if l_is_debug_parameter_on then

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

1059: p_message => l_procedure_name
1060: );
1061:
1062: if l_is_debug_parameter_on then
1063: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1064: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_user_name:' || p_user_name || '+' || 'p_grant_delegation_flag:' || p_grant_delegation_flag
1065: );
1066: end if;
1067:

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

1075: p_user_name => p_user_name,
1076: p_grant_delegation_flag => l_grant_delegation_flag
1077: );
1078:
1079: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1080: p_message => l_procedure_name
1081: );
1082:
1083:

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

1134: l_subscription_reg_id JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_REG_ID%TYPE;
1135:
1136: begin
1137:
1138: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1139: p_message => l_procedure_name
1140: );
1141:
1142: if l_is_debug_parameter_on then

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

1139: p_message => l_procedure_name
1140: );
1141:
1142: if l_is_debug_parameter_on then
1143: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1144: p_message => 'p_subscription_id:' || p_subscription_id || '+' || 'p_user_id:' || p_user_id || '+' || 'p_grant_delegation_flag:' || JTF_DBSTRING_UTILS.getBooleanString(p_grant_delegation_flag)
1145:
1146: );
1147: end if;

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

1157:
1158: END IF;
1159: CLOSE FIND_REG_ID;
1160:
1161: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1162: p_message => l_procedure_name
1163: );
1164:
1165: end update_grant_delegation_flag;

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

1206: l_grant_delegation_flag boolean := false;
1207:
1208: begin
1209:
1210: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1211: p_message => l_procedure_name
1212: );
1213:
1214:

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

1221: p_user_id => p_user_id,
1222: p_grant_delegation_flag => l_grant_delegation_flag
1223: );
1224:
1225: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1226: p_message => l_procedure_name
1227: );
1228:
1229:

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

1262: WHERE SUBSCRIPTION_ID = p_subscription_id;
1263:
1264: begin
1265:
1266: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1267: p_message => l_procedure_name
1268: );
1269:
1270: if l_is_debug_parameter_on then

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

1267: p_message => l_procedure_name
1268: );
1269:
1270: if l_is_debug_parameter_on then
1271: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1272: p_message => 'p_subscription_id:' || p_subscription_id
1273: );
1274: end if;
1275:

Line 1282: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,

1278: FETCH FIND_DELEGATION_ROLE INTO x_delegation_role;
1279:
1280: IF FIND_DELEGATION_ROLE%NOTFOUND THEN
1281: CLOSE FIND_DELEGATION_ROLE;
1282: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1283: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id')
1284: );
1285: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id'));
1286: END IF;

Line 1283: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id')

1279:
1280: IF FIND_DELEGATION_ROLE%NOTFOUND THEN
1281: CLOSE FIND_DELEGATION_ROLE;
1282: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1283: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id')
1284: );
1285: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id'));
1286: END IF;
1287:

Line 1285: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id'));

1281: CLOSE FIND_DELEGATION_ROLE;
1282: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1283: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id')
1284: );
1285: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id'));
1286: END IF;
1287:
1288:
1289:

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

1288:
1289:
1290: CLOSE FIND_DELEGATION_ROLE;
1291:
1292: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1293: p_message => l_procedure_name
1294: );
1295:
1296:

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

1338: l_flag_value varchar2(1);
1339:
1340: BEGIN
1341:
1342: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1343: p_message => l_procedure_name
1344: );
1345: if l_is_debug_parameter_on then
1346: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

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

1342: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1343: p_message => l_procedure_name
1344: );
1345: if l_is_debug_parameter_on then
1346: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1347: p_message => 'p_subscription_id:'||p_subscription_id || '+' || 'p_user_id:' || p_user_id
1348: );
1349: end if;
1350:

Line 1352: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,

1348: );
1349: end if;
1350:
1351: IF NOT JTF_UM_UTIL_PVT.VALIDATE_USER_ID(p_user_id) THEN
1352: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1353: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id')
1354: );
1355: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));
1356: END IF;

Line 1353: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id')

1349: end if;
1350:
1351: IF NOT JTF_UM_UTIL_PVT.VALIDATE_USER_ID(p_user_id) THEN
1352: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1353: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id')
1354: );
1355: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));
1356: END IF;
1357:

Line 1355: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));

1351: IF NOT JTF_UM_UTIL_PVT.VALIDATE_USER_ID(p_user_id) THEN
1352: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1353: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id')
1354: );
1355: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));
1356: END IF;
1357:
1358: IF NOT JTF_UM_UTIL_PVT.VALIDATE_SUBSCRIPTION_ID(p_subscription_id) THEN
1359: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,

Line 1359: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,

1355: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));
1356: END IF;
1357:
1358: IF NOT JTF_UM_UTIL_PVT.VALIDATE_SUBSCRIPTION_ID(p_subscription_id) THEN
1359: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1360: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id')
1361: );
1362: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id'));
1363: END IF;

Line 1360: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id')

1356: END IF;
1357:
1358: IF NOT JTF_UM_UTIL_PVT.VALIDATE_SUBSCRIPTION_ID(p_subscription_id) THEN
1359: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1360: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id')
1361: );
1362: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id'));
1363: END IF;
1364:

Line 1362: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id'));

1358: IF NOT JTF_UM_UTIL_PVT.VALIDATE_SUBSCRIPTION_ID(p_subscription_id) THEN
1359: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1360: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id')
1361: );
1362: RAISE_APPLICATION_ERROR(-20000,JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('subscription_id'));
1363: END IF;
1364:
1365:
1366: OPEN FIND_DELEGATION_FLAG;

Line 1372: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,

1368: FETCH FIND_DELEGATION_FLAG INTO l_flag_value;
1369:
1370: IF FIND_DELEGATION_FLAG%NOTFOUND THEN
1371: CLOSE FIND_DELEGATION_FLAG;
1372: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1373: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_USER_ENROLL_NO_ASGN')
1374: );
1375:
1376: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_USER_ENROLL_NO_ASGN'));

Line 1373: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_USER_ENROLL_NO_ASGN')

1369:
1370: IF FIND_DELEGATION_FLAG%NOTFOUND THEN
1371: CLOSE FIND_DELEGATION_FLAG;
1372: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1373: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_USER_ENROLL_NO_ASGN')
1374: );
1375:
1376: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_USER_ENROLL_NO_ASGN'));
1377: END IF;

Line 1376: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_USER_ENROLL_NO_ASGN'));

1372: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1373: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_USER_ENROLL_NO_ASGN')
1374: );
1375:
1376: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('JTA_UM_USER_ENROLL_NO_ASGN'));
1377: END IF;
1378:
1379: CLOSE FIND_DELEGATION_FLAG;
1380:

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

1383: ELSE
1384: x_result := FALSE;
1385: END IF;
1386:
1387: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1388: p_message => l_procedure_name
1389: );
1390:
1391: