APPS.MSC_NET_RES_INST_AVAILABILITY dependencies on MSC_UTIL

Line 58: MSC_UTIL.MSC_DEBUG(FND_MESSAGE.Get);

54: EXCEPTION
55: WHEN no_data_found THEN
56: FND_MESSAGE.SET_NAME('MSC', 'MSC_NRA_NO_CALENDAR');
57: FND_MESSAGE.SET_TOKEN('ORG_ID', arg_organization_id);
58: MSC_UTIL.MSC_DEBUG(FND_MESSAGE.Get);
59:
60: END check_start_date;
61:
62: FUNCTION check_cutoff_date(arg_organization_id in number,

Line 87: MSC_UTIL.MSC_DEBUG(FND_MESSAGE.Get);

83: EXCEPTION
84: WHEN no_data_found THEN
85: FND_MESSAGE.SET_NAME('MSC', 'MSC_NRA_NO_CALENDAR');
86: FND_MESSAGE.SET_TOKEN('ORG_ID', arg_organization_id);
87: MSC_UTIL.MSC_DEBUG(FND_MESSAGE.Get);
88:
89: END check_cutoff_date;
90:
91: PROCEDURE update_avail( var_rowid in ROWID,

Line 123: MSC_UTIL.MSC_DEBUG('Error in update_avail:: ' || to_char(sqlcode) || ':' || substr(sqlerrm,1,60));

119: WHERE rowid = var_rowid;
120:
121: EXCEPTION
122: WHEN OTHERS THEN
123: MSC_UTIL.MSC_DEBUG('Error in update_avail:: ' || to_char(sqlcode) || ':' || substr(sqlerrm,1,60));
124: END update_avail;
125:
126: PROCEDURE delete_avail( var_rowid in ROWID) is
127: BEGIN

Line 248: MSC_UTIL.MSC_DEBUG('Error in insert_avail:: ' || to_char(sqlcode) || ':' || substr(sqlerrm,1,60));

244: -- dbms_output.put_line('last insert row count ' || sql%rowcount);
245:
246: EXCEPTION
247: WHEN OTHERS THEN
248: MSC_UTIL.MSC_DEBUG('Error in insert_avail:: ' || to_char(sqlcode) || ':' || substr(sqlerrm,1,60));
249:
250: END insert_avail;
251:
252:

Line 803: MSC_UTIL.MSC_DEBUG('Error in calc_ins_avail:: ' || to_char(sqlcode) || ':'

799: end if;
800:
801: EXCEPTION
802: WHEN OTHERS THEN
803: MSC_UTIL.MSC_DEBUG('Error in calc_ins_avail:: ' || to_char(sqlcode) || ':'
804: || substr(sqlerrm,1,60));
805: --dbms_output.put_line('Error in calc_ins_avail ' || sqlerrm);
806:
807: END calc_res_ins_avail;

Line 1020: MSC_UTIL.MSC_DEBUG('Error in populate_avail_res_instances:: ' || to_char(sqlcode) ||

1016:
1017:
1018: EXCEPTION
1019: WHEN OTHERS THEN
1020: MSC_UTIL.MSC_DEBUG('Error in populate_avail_res_instances:: ' || to_char(sqlcode) ||
1021: ':' || substr(sqlerrm,1,60));
1022:
1023:
1024: IF dept_res%isopen THEN CLOSE dept_res; END IF;

Line 1057: MSC_UTIL.MSC_DEBUG('Creating resource for all simulation set ....');

1053: LOG_MESSAGE('========================================================');
1054: LOG_MESSAGE('Populating Org Resources for the Org: '|| arg_organization_id);
1055: LOG_MESSAGE('========================================================');
1056:
1057: MSC_UTIL.MSC_DEBUG('Creating resource for all simulation set ....');
1058: MSC_UTIL.MSC_DEBUG('Org Id:' || to_char(arg_organization_id));
1059: MSC_UTIL.MSC_DEBUG('Instance:' || to_char(arg_sr_instance_id));
1060:
1061:

Line 1058: MSC_UTIL.MSC_DEBUG('Org Id:' || to_char(arg_organization_id));

1054: LOG_MESSAGE('Populating Org Resources for the Org: '|| arg_organization_id);
1055: LOG_MESSAGE('========================================================');
1056:
1057: MSC_UTIL.MSC_DEBUG('Creating resource for all simulation set ....');
1058: MSC_UTIL.MSC_DEBUG('Org Id:' || to_char(arg_organization_id));
1059: MSC_UTIL.MSC_DEBUG('Instance:' || to_char(arg_sr_instance_id));
1060:
1061:
1062: -- For complete refresh, the collection program will handle deleting all

Line 1059: MSC_UTIL.MSC_DEBUG('Instance:' || to_char(arg_sr_instance_id));

1055: LOG_MESSAGE('========================================================');
1056:
1057: MSC_UTIL.MSC_DEBUG('Creating resource for all simulation set ....');
1058: MSC_UTIL.MSC_DEBUG('Org Id:' || to_char(arg_organization_id));
1059: MSC_UTIL.MSC_DEBUG('Instance:' || to_char(arg_sr_instance_id));
1060:
1061:
1062: -- For complete refresh, the collection program will handle deleting all
1063: -- resource avail.