52: return v_start_date;
53:
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;
53:
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:
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,
81: return v_cutoff_date;
82:
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;
82:
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:
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,
1150:
1151: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1152:
1153: LOG_MESSAGE('========================================');
1154: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1155: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_ORG_RES_INSTANCES');
1156: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RES_INST_AVAIL');
1157: LOG_MESSAGE(FND_MESSAGE.GET);
1158:
1151: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
1152:
1153: LOG_MESSAGE('========================================');
1154: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1155: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_ORG_RES_INSTANCES');
1156: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RES_INST_AVAIL');
1157: LOG_MESSAGE(FND_MESSAGE.GET);
1158:
1159: LOG_MESSAGE(SQLERRM);
1152:
1153: LOG_MESSAGE('========================================');
1154: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1155: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_ORG_RES_INSTANCES');
1156: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RES_INST_AVAIL');
1157: LOG_MESSAGE(FND_MESSAGE.GET);
1158:
1159: LOG_MESSAGE(SQLERRM);
1160:
1153: LOG_MESSAGE('========================================');
1154: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1155: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'POPULATE_ORG_RES_INSTANCES');
1156: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RES_INST_AVAIL');
1157: LOG_MESSAGE(FND_MESSAGE.GET);
1158:
1159: LOG_MESSAGE(SQLERRM);
1160:
1161: