APPS.MSC_CL_OTHER_ODS_LOAD dependencies on FND_MESSAGE

Line 133: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

129:
130: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
131:
132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
133: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
134: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
135: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
137:

Line 134: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');

130: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
131:
132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
133: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
134: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
135: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
137:
138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 135: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');

131:
132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
133: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
134: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
135: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
137:
138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
139: RAISE;

Line 136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
133: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
134: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
135: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
137:
138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
139: RAISE;
140:

Line 145: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

141: ELSE
142: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
143:
144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
145: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
146: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
147: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
149:

Line 146: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');

142: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
143:
144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
145: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
146: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
147: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
149:
150: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 147: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');

143:
144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
145: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
146: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
147: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
149:
150: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

Line 148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
145: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
146: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
147: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
149:
150: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
152: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

Line 150: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

146: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
147: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
149:
150: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
152: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
154:

Line 151: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');

147: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
149:
150: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
152: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
154:
155: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 152: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
149:
150: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
152: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
154:
155: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

149:
150: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
152: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
154:
155: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
157: FND_MESSAGE.SET_TOKEN('VALUE',

Line 155: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

151: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
152: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
154:
155: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
157: FND_MESSAGE.SET_TOKEN('VALUE',
158: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
159: MSC_CL_COLLECTION.v_instance_id));

Line 156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

152: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
154:
155: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
157: FND_MESSAGE.SET_TOKEN('VALUE',
158: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
159: MSC_CL_COLLECTION.v_instance_id));
160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 157: FND_MESSAGE.SET_TOKEN('VALUE',

153: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
154:
155: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
157: FND_MESSAGE.SET_TOKEN('VALUE',
158: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
159: MSC_CL_COLLECTION.v_instance_id));
160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
161:

Line 160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

156: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
157: FND_MESSAGE.SET_TOKEN('VALUE',
158: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
159: MSC_CL_COLLECTION.v_instance_id));
160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
161:
162: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
163: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_START_DATE');
164: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PERIOD_START_DATE));

Line 162: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

158: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
159: MSC_CL_COLLECTION.v_instance_id));
160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
161:
162: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
163: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_START_DATE');
164: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PERIOD_START_DATE));
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
166:

Line 163: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_START_DATE');

159: MSC_CL_COLLECTION.v_instance_id));
160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
161:
162: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
163: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_START_DATE');
164: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PERIOD_START_DATE));
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
166:
167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 164: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PERIOD_START_DATE));

160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
161:
162: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
163: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_START_DATE');
164: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PERIOD_START_DATE));
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
166:
167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
168: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');

Line 165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

161:
162: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
163: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_START_DATE');
164: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PERIOD_START_DATE));
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
166:
167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
168: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PROJECT_ID));

Line 167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

163: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_START_DATE');
164: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PERIOD_START_DATE));
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
166:
167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
168: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PROJECT_ID));
170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
171:

Line 168: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');

164: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PERIOD_START_DATE));
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
166:
167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
168: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PROJECT_ID));
170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
171:
172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PROJECT_ID));

165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
166:
167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
168: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PROJECT_ID));
170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
171:
172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
173: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_ID');

Line 170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

166:
167: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
168: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PROJECT_ID));
170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
171:
172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
173: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_ID');
174: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TASK_ID));

Line 172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

168: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PROJECT_ID));
170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
171:
172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
173: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_ID');
174: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TASK_ID));
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
176:

Line 173: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_ID');

169: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.PROJECT_ID));
170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
171:
172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
173: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_ID');
174: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TASK_ID));
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
176:
177: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 174: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TASK_ID));

170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
171:
172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
173: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_ID');
174: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TASK_ID));
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
176:
177: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
178: END IF;

Line 175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

171:
172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
173: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_ID');
174: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TASK_ID));
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
176:
177: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
178: END IF;
179:

Line 558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

554:
555: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
556:
557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
562:

Line 559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

555: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
556:
557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
562:
563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');

556:
557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
562:
563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
564: RAISE;

Line 561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
562:
563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
564: RAISE;
565:

Line 571: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

567:
568: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
569:
570: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
571: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
572: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
573: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
575:

Line 572: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

568: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
569:
570: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
571: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
572: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
573: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
575:
576: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 573: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');

569:
570: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
571: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
572: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
573: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
575:
576: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
577: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSIGNMENT_SET_NAME');

Line 574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

570: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
571: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
572: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
573: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
575:
576: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
577: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSIGNMENT_SET_NAME');
578: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ASSIGNMENT_SET_NAME);

Line 576: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

572: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
573: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
575:
576: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
577: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSIGNMENT_SET_NAME');
578: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ASSIGNMENT_SET_NAME);
579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
580:

Line 577: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSIGNMENT_SET_NAME');

573: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
575:
576: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
577: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSIGNMENT_SET_NAME');
578: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ASSIGNMENT_SET_NAME);
579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
580:
581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 578: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ASSIGNMENT_SET_NAME);

574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
575:
576: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
577: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSIGNMENT_SET_NAME');
578: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ASSIGNMENT_SET_NAME);
579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
580:
581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
582: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_ASSIGNMENT_SET_ID');

Line 579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

575:
576: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
577: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSIGNMENT_SET_NAME');
578: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ASSIGNMENT_SET_NAME);
579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
580:
581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
582: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_ASSIGNMENT_SET_ID');
583: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_ASSIGNMENT_SET_ID));

Line 581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

577: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSIGNMENT_SET_NAME');
578: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ASSIGNMENT_SET_NAME);
579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
580:
581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
582: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_ASSIGNMENT_SET_ID');
583: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_ASSIGNMENT_SET_ID));
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
585:

Line 582: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_ASSIGNMENT_SET_ID');

578: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ASSIGNMENT_SET_NAME);
579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
580:
581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
582: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_ASSIGNMENT_SET_ID');
583: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_ASSIGNMENT_SET_ID));
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
585:
586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 583: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_ASSIGNMENT_SET_ID));

579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
580:
581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
582: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_ASSIGNMENT_SET_ID');
583: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_ASSIGNMENT_SET_ID));
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
585:
586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
587: END IF;

Line 584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

580:
581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
582: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_ASSIGNMENT_SET_ID');
583: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_ASSIGNMENT_SET_ID));
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
585:
586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
587: END IF;
588:

Line 699: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

695: WHEN OTHERS THEN
696: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
697:
698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
699: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
700: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
701: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
703:

Line 700: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

696: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
697:
698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
699: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
700: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
701: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
703:
704: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 701: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');

697:
698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
699: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
700: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
701: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
703:
704: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
705: RAISE;

Line 702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
699: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
700: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
701: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
703:
704: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
705: RAISE;
706:

Line 711: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

707: ELSE
708: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
709:
710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
711: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
712: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
713: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
715:

Line 712: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

708: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
709:
710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
711: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
712: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
713: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
715:
716: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 713: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');

709:
710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
711: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
712: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
713: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
715:
716: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
717: FND_MESSAGE.SET_TOKEN('COLUMN', 'SOURCING_RULE_NAME');

Line 714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
711: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
712: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
713: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
715:
716: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
717: FND_MESSAGE.SET_TOKEN('COLUMN', 'SOURCING_RULE_NAME');
718: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SOURCING_RULE_NAME);

Line 716: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

712: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
713: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
715:
716: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
717: FND_MESSAGE.SET_TOKEN('COLUMN', 'SOURCING_RULE_NAME');
718: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SOURCING_RULE_NAME);
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:

Line 717: FND_MESSAGE.SET_TOKEN('COLUMN', 'SOURCING_RULE_NAME');

713: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
715:
716: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
717: FND_MESSAGE.SET_TOKEN('COLUMN', 'SOURCING_RULE_NAME');
718: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SOURCING_RULE_NAME);
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:
721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 718: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SOURCING_RULE_NAME);

714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
715:
716: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
717: FND_MESSAGE.SET_TOKEN('COLUMN', 'SOURCING_RULE_NAME');
718: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SOURCING_RULE_NAME);
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:
721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
722: END IF;

Line 719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

715:
716: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
717: FND_MESSAGE.SET_TOKEN('COLUMN', 'SOURCING_RULE_NAME');
718: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SOURCING_RULE_NAME);
719: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
720:
721: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
722: END IF;
723:

Line 835: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

831:
832: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
833:
834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
835: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
836: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
839:

Line 836: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

832: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
833:
834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
835: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
836: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
839:
840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');

833:
834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
835: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
836: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
839:
840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
841: RAISE;

Line 838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
835: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
836: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
839:
840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
841: RAISE;
842:

Line 848: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

844:
845: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
846:
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
848: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
849: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
850: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:

Line 849: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

845: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
846:
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
848: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
849: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
850: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 850: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');

846:
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
848: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
849: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
850: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
854: END IF;

Line 851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
848: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
849: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
850: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
852:
853: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
854: END IF;
855:

Line 964: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

960:
961: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
962:
963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
964: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
965: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
966: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
967: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
968:

Line 965: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

961: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
962:
963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
964: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
965: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
966: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
967: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
968:
969: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 966: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');

962:
963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
964: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
965: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
966: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
967: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
968:
969: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
970: RAISE;

Line 967: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
964: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
965: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
966: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
967: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
968:
969: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
970: RAISE;
971:

Line 977: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

973:
974: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
975:
976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
977: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
979: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
980: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
981:

Line 978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

974: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
975:
976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
977: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
979: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
980: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
981:
982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 979: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');

975:
976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
977: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
979: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
980: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
981:
982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
983: END IF;

Line 980: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
977: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
979: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_ASSIGNMENTS');
980: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
981:
982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
983: END IF;
984:

Line 1098: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1094:
1095: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1096:
1097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1098: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1099: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1100: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1102:

Line 1099: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1095: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1096:
1097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1098: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1099: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1100: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1102:
1103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1100: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');

1096:
1097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1098: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1099: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1100: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1102:
1103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1104: RAISE;

Line 1101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1098: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1099: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1100: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1102:
1103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1104: RAISE;
1105:

Line 1110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1106: ELSE
1107: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1108:
1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1114:

Line 1111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1107: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1108:
1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1114:
1115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');

1108:
1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1114:
1115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1116: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_RECEIPT_ID');

Line 1113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1110: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1114:
1115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1116: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_RECEIPT_ID');
1117: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_RECEIPT_ID));

Line 1115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1111: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1114:
1115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1116: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_RECEIPT_ID');
1117: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_RECEIPT_ID));
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:

Line 1116: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_RECEIPT_ID');

1112: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_RECEIPT_ORG');
1113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1114:
1115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1116: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_RECEIPT_ID');
1117: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_RECEIPT_ID));
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:
1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1117: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_RECEIPT_ID));

1113: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1114:
1115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1116: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_RECEIPT_ID');
1117: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_RECEIPT_ID));
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:
1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1121: END IF;

Line 1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1114:
1115: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1116: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_RECEIPT_ID');
1117: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_RECEIPT_ID));
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:
1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1121: END IF;
1122:

Line 1243: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1239:
1240: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1241:
1242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1243: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1244: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1245: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1246: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1247:

Line 1244: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1240: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1241:
1242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1243: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1244: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1245: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1246: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1247:
1248: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1245: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');

1241:
1242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1243: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1244: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1245: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1246: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1247:
1248: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1249: RAISE;

Line 1246: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1243: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1244: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1245: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1246: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1247:
1248: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1249: RAISE;
1250:

Line 1255: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1251: ELSE
1252: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1253:
1254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1255: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1256: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1257: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1259:

Line 1256: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1252: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1253:
1254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1255: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1256: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1257: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1259:
1260: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1257: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');

1253:
1254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1255: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1256: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1257: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1259:
1260: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1261: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_SR_SOURCE_ID');

Line 1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1255: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1256: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1257: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1259:
1260: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1261: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_SR_SOURCE_ID');
1262: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_SR_SOURCE_ID));

Line 1260: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1256: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1257: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1259:
1260: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1261: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_SR_SOURCE_ID');
1262: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_SR_SOURCE_ID));
1263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1264:

Line 1261: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_SR_SOURCE_ID');

1257: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1259:
1260: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1261: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_SR_SOURCE_ID');
1262: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_SR_SOURCE_ID));
1263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1264:
1265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1262: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_SR_SOURCE_ID));

1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1259:
1260: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1261: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_SR_SOURCE_ID');
1262: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_SR_SOURCE_ID));
1263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1264:
1265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1266: END IF;

Line 1263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1259:
1260: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1261: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_SR_SOURCE_ID');
1262: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_SR_SOURCE_ID));
1263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1264:
1265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1266: END IF;
1267:

Line 1398: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1394:
1395: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1396:
1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1398: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1399: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1400: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1402:

Line 1399: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1395: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1396:
1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1398: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1399: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1400: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1402:
1403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1400: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');

1396:
1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1398: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1399: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1400: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1402:
1403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1404: RAISE;

Line 1401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1398: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1399: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1400: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1402:
1403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1404: RAISE;
1405:

Line 1410: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1406: ELSE
1407: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1408:
1409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1410: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1411: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1412: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1414:

Line 1411: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1407: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1408:
1409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1410: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1411: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1412: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1414:
1415: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1412: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');

1408:
1409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1410: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1411: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1412: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1414:
1415: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1416: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_ORGANIZATION_CODE');

Line 1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1410: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1411: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1412: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1414:
1415: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1416: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_ORGANIZATION_CODE');
1417: FND_MESSAGE.SET_TOKEN('VALUE',

Line 1415: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1411: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1412: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1414:
1415: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1416: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_ORGANIZATION_CODE');
1417: FND_MESSAGE.SET_TOKEN('VALUE',
1418: MSC_GET_NAME.ORG_CODE( c_rec.FROM_ORGANIZATION_ID,
1419: MSC_CL_COLLECTION.v_instance_id));

Line 1416: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_ORGANIZATION_CODE');

1412: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1414:
1415: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1416: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_ORGANIZATION_CODE');
1417: FND_MESSAGE.SET_TOKEN('VALUE',
1418: MSC_GET_NAME.ORG_CODE( c_rec.FROM_ORGANIZATION_ID,
1419: MSC_CL_COLLECTION.v_instance_id));
1420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1417: FND_MESSAGE.SET_TOKEN('VALUE',

1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1414:
1415: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1416: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_ORGANIZATION_CODE');
1417: FND_MESSAGE.SET_TOKEN('VALUE',
1418: MSC_GET_NAME.ORG_CODE( c_rec.FROM_ORGANIZATION_ID,
1419: MSC_CL_COLLECTION.v_instance_id));
1420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1421:

Line 1420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1416: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_ORGANIZATION_CODE');
1417: FND_MESSAGE.SET_TOKEN('VALUE',
1418: MSC_GET_NAME.ORG_CODE( c_rec.FROM_ORGANIZATION_ID,
1419: MSC_CL_COLLECTION.v_instance_id));
1420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1421:
1422: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1423: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_ORGANIZATION_CODE');
1424: FND_MESSAGE.SET_TOKEN('VALUE',

Line 1422: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1418: MSC_GET_NAME.ORG_CODE( c_rec.FROM_ORGANIZATION_ID,
1419: MSC_CL_COLLECTION.v_instance_id));
1420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1421:
1422: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1423: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_ORGANIZATION_CODE');
1424: FND_MESSAGE.SET_TOKEN('VALUE',
1425: MSC_GET_NAME.ORG_CODE( c_rec.TO_ORGANIZATION_ID,
1426: MSC_CL_COLLECTION.v_instance_id));

Line 1423: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_ORGANIZATION_CODE');

1419: MSC_CL_COLLECTION.v_instance_id));
1420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1421:
1422: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1423: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_ORGANIZATION_CODE');
1424: FND_MESSAGE.SET_TOKEN('VALUE',
1425: MSC_GET_NAME.ORG_CODE( c_rec.TO_ORGANIZATION_ID,
1426: MSC_CL_COLLECTION.v_instance_id));
1427: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1424: FND_MESSAGE.SET_TOKEN('VALUE',

1420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1421:
1422: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1423: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_ORGANIZATION_CODE');
1424: FND_MESSAGE.SET_TOKEN('VALUE',
1425: MSC_GET_NAME.ORG_CODE( c_rec.TO_ORGANIZATION_ID,
1426: MSC_CL_COLLECTION.v_instance_id));
1427: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1428:

Line 1427: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1423: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_ORGANIZATION_CODE');
1424: FND_MESSAGE.SET_TOKEN('VALUE',
1425: MSC_GET_NAME.ORG_CODE( c_rec.TO_ORGANIZATION_ID,
1426: MSC_CL_COLLECTION.v_instance_id));
1427: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1428:
1429: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1430: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_LOCATION_ID');
1431: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_LOCATION_ID));

Line 1429: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1425: MSC_GET_NAME.ORG_CODE( c_rec.TO_ORGANIZATION_ID,
1426: MSC_CL_COLLECTION.v_instance_id));
1427: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1428:
1429: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1430: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_LOCATION_ID');
1431: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_LOCATION_ID));
1432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1433:

Line 1430: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_LOCATION_ID');

1426: MSC_CL_COLLECTION.v_instance_id));
1427: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1428:
1429: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1430: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_LOCATION_ID');
1431: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_LOCATION_ID));
1432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1433:
1434: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1431: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_LOCATION_ID));

1427: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1428:
1429: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1430: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_LOCATION_ID');
1431: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_LOCATION_ID));
1432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1433:
1434: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1435: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_LOCATION_ID');

Line 1432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1428:
1429: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1430: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_LOCATION_ID');
1431: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_LOCATION_ID));
1432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1433:
1434: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1435: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_LOCATION_ID');
1436: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TO_LOCATION_ID));

Line 1434: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1430: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_LOCATION_ID');
1431: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_LOCATION_ID));
1432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1433:
1434: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1435: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_LOCATION_ID');
1436: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TO_LOCATION_ID));
1437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1438:

Line 1435: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_LOCATION_ID');

1431: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_LOCATION_ID));
1432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1433:
1434: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1435: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_LOCATION_ID');
1436: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TO_LOCATION_ID));
1437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1438:
1439: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 1436: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TO_LOCATION_ID));

1432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1433:
1434: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1435: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_LOCATION_ID');
1436: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TO_LOCATION_ID));
1437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1438:
1439: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1440: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIP_METHOD');

Line 1437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1433:
1434: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1435: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_LOCATION_ID');
1436: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TO_LOCATION_ID));
1437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1438:
1439: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1440: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIP_METHOD');
1441: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SHIP_METHOD);

Line 1439: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

1435: FND_MESSAGE.SET_TOKEN('COLUMN', 'TO_LOCATION_ID');
1436: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TO_LOCATION_ID));
1437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1438:
1439: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1440: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIP_METHOD');
1441: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SHIP_METHOD);
1442: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1443:

Line 1440: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIP_METHOD');

1436: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TO_LOCATION_ID));
1437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1438:
1439: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1440: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIP_METHOD');
1441: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SHIP_METHOD);
1442: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1443:
1444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1441: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SHIP_METHOD);

1437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1438:
1439: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1440: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIP_METHOD');
1441: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SHIP_METHOD);
1442: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1443:
1444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1445: END IF;

Line 1442: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1438:
1439: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1440: FND_MESSAGE.SET_TOKEN('COLUMN', 'SHIP_METHOD');
1441: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SHIP_METHOD);
1442: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1443:
1444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1445: END IF;
1446:

Line 1577: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1573:
1574: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1575:
1576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1577: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:

Line 1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1574: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1575:
1576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1577: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');

1575:
1576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1577: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1583: RAISE;

Line 1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1577: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1583: RAISE;
1584:

Line 1589: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1585: ELSE
1586: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1587:
1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1589: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1590: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1591: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1590: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1586: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1587:
1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1589: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1590: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1591: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1594: END IF;

Line 1591: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');

1587:
1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1589: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1590: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1591: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1594: END IF;
1595: END; -- load for MSC_REGIONS

Line 1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1589: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1590: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1591: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGIONS');
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1594: END IF;
1595: END; -- load for MSC_REGIONS
1596:

Line 1672: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1668:
1669: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1670:
1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1672: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1673: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1674: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1675: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1676:

Line 1673: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1669: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1670:
1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1672: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1673: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1674: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1675: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1676:
1677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1674: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');

1670:
1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1672: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1673: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1674: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1675: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1676:
1677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1678: RAISE;

Line 1675: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1672: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1673: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1674: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1675: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1676:
1677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1678: RAISE;
1679:

Line 1684: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1680: ELSE
1681: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1682:
1683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1684: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1685: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1686: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1687: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1685: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1681: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1682:
1683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1684: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1685: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1686: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1687: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1689: END IF;

Line 1686: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');

1682:
1683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1684: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1685: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1686: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1687: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1689: END IF;
1690: END; -- load for MSC_ZONE_REGIONS

Line 1687: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1684: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1685: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1686: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ZONE_REGIONS');
1687: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1689: END IF;
1690: END; -- load for MSC_ZONE_REGIONS
1691:

Line 1765: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1761:
1762: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1763:
1764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1765: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1766: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1767: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1769:

Line 1766: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1762: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1763:
1764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1765: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1766: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1767: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1769:
1770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1767: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');

1763:
1764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1765: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1766: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1767: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1769:
1770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1771: RAISE;

Line 1768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1765: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1766: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1767: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1769:
1770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1771: RAISE;
1772:

Line 1777: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1773: ELSE
1774: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1775:
1776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1777: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1778: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1779: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1780: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1781: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1778: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1774: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1775:
1776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1777: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1778: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1779: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1780: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1781: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1782: END IF;

Line 1779: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');

1775:
1776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1777: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1778: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1779: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1780: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1781: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1782: END IF;
1783: END; -- load for MSC_REGION_LOCATIONS

Line 1780: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1777: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1778: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1779: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_LOCATIONS');
1780: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1781: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1782: END IF;
1783: END; -- load for MSC_REGION_LOCATIONS
1784: END IF; --IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)) THEN

Line 1846: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1842: WHEN OTHERS THEN
1843: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1844:
1845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1846: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1847: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1848: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1849: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1850:

Line 1847: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1843: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1844:
1845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1846: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1847: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1848: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1849: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1850:
1851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1848: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');

1844:
1845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1846: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1847: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1848: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1849: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1850:
1851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1852: RAISE;

Line 1849: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1846: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1847: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1848: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1849: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1850:
1851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1852: RAISE;
1853:

Line 1858: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1854: ELSE
1855: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1856:
1857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1858: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1860: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1862:

Line 1859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1855: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1856:
1857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1858: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1860: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1862:
1863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1860: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');

1856:
1857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1858: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1860: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1862:
1863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1864: END IF;

Line 1861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1858: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1860: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1862:
1863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1864: END IF;
1865:

Line 1916: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1912: WHEN OTHERS THEN
1913: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1914:
1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1916: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1917: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1918: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CARRIER_SERVICES');
1919: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1920:

Line 1917: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1913: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1914:
1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1916: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1917: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1918: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CARRIER_SERVICES');
1919: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1920:
1921: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1918: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CARRIER_SERVICES');

1914:
1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1916: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1917: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1918: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CARRIER_SERVICES');
1919: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1920:
1921: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1922: RAISE;

Line 1919: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1916: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1917: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1918: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CARRIER_SERVICES');
1919: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1920:
1921: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1922: RAISE;
1923:

Line 1928: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

1924: ELSE
1925: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1926:
1927: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1928: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1929: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1930: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1932:

Line 1929: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');

1925: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1926:
1927: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1928: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1929: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1930: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1932:
1933: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 1930: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');

1926:
1927: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1928: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1929: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1930: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1932:
1933: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1934: END IF;

Line 1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1927: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1928: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1929: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1930: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_REGION_SITES');
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1932:
1933: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1934: END IF;
1935:

Line 2060: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2056:
2057: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2058:
2059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2060: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2061: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2062: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2064:

Line 2061: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');

2057: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2058:
2059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2060: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2061: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2062: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2064:
2065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2062: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');

2058:
2059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2060: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2061: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2062: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2064:
2065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2066: RAISE;

Line 2063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2059: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2060: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2061: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2062: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2064:
2065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2066: RAISE;
2067:

Line 2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2068: ELSE
2069: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2070:
2071: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2073: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2074: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2076:

Line 2073: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');

2069: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2070:
2071: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2073: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2074: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2076:
2077: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2074: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');

2070:
2071: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2073: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2074: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2076:
2077: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2078: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 2075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2071: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2073: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2074: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2076:
2077: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2078: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2079: FND_MESSAGE.SET_TOKEN('VALUE',

Line 2077: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2073: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUB_INVENTORY');
2074: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2076:
2077: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2078: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2079: FND_MESSAGE.SET_TOKEN('VALUE',
2080: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2081: MSC_CL_COLLECTION.v_instance_id));

Line 2078: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

2074: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUB_INVENTORIES');
2075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2076:
2077: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2078: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2079: FND_MESSAGE.SET_TOKEN('VALUE',
2080: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2081: MSC_CL_COLLECTION.v_instance_id));
2082: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2079: FND_MESSAGE.SET_TOKEN('VALUE',

2075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2076:
2077: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2078: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2079: FND_MESSAGE.SET_TOKEN('VALUE',
2080: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2081: MSC_CL_COLLECTION.v_instance_id));
2082: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2083:

Line 2082: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2078: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2079: FND_MESSAGE.SET_TOKEN('VALUE',
2080: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2081: MSC_CL_COLLECTION.v_instance_id));
2082: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2083:
2084: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2085: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUB_INVENTORY_CODE');
2086: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SUB_INVENTORY_CODE);

Line 2084: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2080: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2081: MSC_CL_COLLECTION.v_instance_id));
2082: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2083:
2084: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2085: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUB_INVENTORY_CODE');
2086: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SUB_INVENTORY_CODE);
2087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2088:

Line 2085: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUB_INVENTORY_CODE');

2081: MSC_CL_COLLECTION.v_instance_id));
2082: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2083:
2084: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2085: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUB_INVENTORY_CODE');
2086: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SUB_INVENTORY_CODE);
2087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2088:
2089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2086: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SUB_INVENTORY_CODE);

2082: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2083:
2084: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2085: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUB_INVENTORY_CODE');
2086: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SUB_INVENTORY_CODE);
2087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2088:
2089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2090: END IF;

Line 2087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2083:
2084: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2085: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUB_INVENTORY_CODE');
2086: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SUB_INVENTORY_CODE);
2087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2088:
2089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2090: END IF;
2091: END;

Line 2194: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2190:
2191: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2192:
2193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2194: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2195: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2196: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2198:

Line 2195: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');

2191: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2192:
2193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2194: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2195: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2196: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2198:
2199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2196: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');

2192:
2193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2194: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2195: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2196: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2198:
2199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2200: RAISE;

Line 2197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2194: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2195: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2196: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2197: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2198:
2199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2200: RAISE;
2201:

Line 2206: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2202: ELSE
2203: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2204:
2205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2206: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2207: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2208: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2210:

Line 2207: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');

2203: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2204:
2205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2206: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2207: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2208: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2210:
2211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2208: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');

2204:
2205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2206: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2207: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2208: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2210:
2211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2212: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIT_NUMBER');

Line 2209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2206: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2207: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2208: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2210:
2211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2212: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIT_NUMBER');
2213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.UNIT_NUMBER);

Line 2211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2207: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UNIT_NUMBER');
2208: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2210:
2211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2212: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIT_NUMBER');
2213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.UNIT_NUMBER);
2214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2215:

Line 2212: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIT_NUMBER');

2208: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UNIT_NUMBERS');
2209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2210:
2211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2212: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIT_NUMBER');
2213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.UNIT_NUMBER);
2214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2215:
2216: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.UNIT_NUMBER);

2209: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2210:
2211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2212: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIT_NUMBER');
2213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.UNIT_NUMBER);
2214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2215:
2216: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2217: FND_MESSAGE.SET_TOKEN('COLUMN', 'END_ITEM_ID');

Line 2214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2210:
2211: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2212: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIT_NUMBER');
2213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.UNIT_NUMBER);
2214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2215:
2216: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2217: FND_MESSAGE.SET_TOKEN('COLUMN', 'END_ITEM_ID');
2218: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(c_rec.END_ITEM_ID));

Line 2216: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2212: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIT_NUMBER');
2213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.UNIT_NUMBER);
2214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2215:
2216: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2217: FND_MESSAGE.SET_TOKEN('COLUMN', 'END_ITEM_ID');
2218: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(c_rec.END_ITEM_ID));
2219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2220:

Line 2217: FND_MESSAGE.SET_TOKEN('COLUMN', 'END_ITEM_ID');

2213: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.UNIT_NUMBER);
2214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2215:
2216: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2217: FND_MESSAGE.SET_TOKEN('COLUMN', 'END_ITEM_ID');
2218: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(c_rec.END_ITEM_ID));
2219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2220:
2221: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2218: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(c_rec.END_ITEM_ID));

2214: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2215:
2216: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2217: FND_MESSAGE.SET_TOKEN('COLUMN', 'END_ITEM_ID');
2218: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(c_rec.END_ITEM_ID));
2219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2220:
2221: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2222: FND_MESSAGE.SET_TOKEN('COLUMN', 'MASTER_ORGANIZATION_CODE');

Line 2219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2215:
2216: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2217: FND_MESSAGE.SET_TOKEN('COLUMN', 'END_ITEM_ID');
2218: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(c_rec.END_ITEM_ID));
2219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2220:
2221: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2222: FND_MESSAGE.SET_TOKEN('COLUMN', 'MASTER_ORGANIZATION_CODE');
2223: FND_MESSAGE.SET_TOKEN('VALUE',

Line 2221: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2217: FND_MESSAGE.SET_TOKEN('COLUMN', 'END_ITEM_ID');
2218: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(c_rec.END_ITEM_ID));
2219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2220:
2221: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2222: FND_MESSAGE.SET_TOKEN('COLUMN', 'MASTER_ORGANIZATION_CODE');
2223: FND_MESSAGE.SET_TOKEN('VALUE',
2224: MSC_GET_NAME.ORG_CODE(
2225: c_rec.MASTER_ORGANIZATION_ID,

Line 2222: FND_MESSAGE.SET_TOKEN('COLUMN', 'MASTER_ORGANIZATION_CODE');

2218: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME(c_rec.END_ITEM_ID));
2219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2220:
2221: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2222: FND_MESSAGE.SET_TOKEN('COLUMN', 'MASTER_ORGANIZATION_CODE');
2223: FND_MESSAGE.SET_TOKEN('VALUE',
2224: MSC_GET_NAME.ORG_CODE(
2225: c_rec.MASTER_ORGANIZATION_ID,
2226: MSC_CL_COLLECTION.v_instance_id));

Line 2223: FND_MESSAGE.SET_TOKEN('VALUE',

2219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2220:
2221: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2222: FND_MESSAGE.SET_TOKEN('COLUMN', 'MASTER_ORGANIZATION_CODE');
2223: FND_MESSAGE.SET_TOKEN('VALUE',
2224: MSC_GET_NAME.ORG_CODE(
2225: c_rec.MASTER_ORGANIZATION_ID,
2226: MSC_CL_COLLECTION.v_instance_id));
2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2223: FND_MESSAGE.SET_TOKEN('VALUE',
2224: MSC_GET_NAME.ORG_CODE(
2225: c_rec.MASTER_ORGANIZATION_ID,
2226: MSC_CL_COLLECTION.v_instance_id));
2227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2228:
2229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2230: END IF;
2231:

Line 2394: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2390:
2391: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2392:
2393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2394: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2395: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2396: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2398:

Line 2395: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');

2391: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2392:
2393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2394: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2395: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2396: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2398:
2399: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2396: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');

2392:
2393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2394: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2395: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2396: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2398:
2399: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2400: RAISE;

Line 2397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2393: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2394: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2395: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2396: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2398:
2399: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2400: RAISE;
2401:

Line 2407: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2403:
2404: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2405:
2406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2407: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2408: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2409: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2411:

Line 2408: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');

2404: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2405:
2406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2407: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2408: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2409: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2411:
2412: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2409: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');

2405:
2406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2407: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2408: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2409: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2411:
2412: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2413: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 2410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2407: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2408: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2409: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2411:
2412: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2413: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2414: FND_MESSAGE.SET_TOKEN('VALUE',

Line 2412: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2408: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2409: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2411:
2412: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2413: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2414: FND_MESSAGE.SET_TOKEN('VALUE',
2415: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2416: MSC_CL_COLLECTION.v_instance_id));

Line 2413: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

2409: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECTS');
2410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2411:
2412: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2413: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2414: FND_MESSAGE.SET_TOKEN('VALUE',
2415: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2416: MSC_CL_COLLECTION.v_instance_id));
2417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2414: FND_MESSAGE.SET_TOKEN('VALUE',

2410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2411:
2412: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2413: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2414: FND_MESSAGE.SET_TOKEN('VALUE',
2415: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2416: MSC_CL_COLLECTION.v_instance_id));
2417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2418:

Line 2417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2413: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2414: FND_MESSAGE.SET_TOKEN('VALUE',
2415: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2416: MSC_CL_COLLECTION.v_instance_id));
2417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2418:
2419: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2420: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_NAME');
2421: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_NAME);

Line 2419: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2415: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2416: MSC_CL_COLLECTION.v_instance_id));
2417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2418:
2419: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2420: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_NAME');
2421: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_NAME);
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2423:

Line 2420: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_NAME');

2416: MSC_CL_COLLECTION.v_instance_id));
2417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2418:
2419: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2420: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_NAME');
2421: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_NAME);
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2423:
2424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2421: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_NAME);

2417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2418:
2419: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2420: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_NAME');
2421: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_NAME);
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2423:
2424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2425: END IF;

Line 2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2418:
2419: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2420: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_NAME');
2421: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_NAME);
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2423:
2424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2425: END IF;
2426:

Line 2529: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2525:
2526: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2527:
2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2529: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2530: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2531: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2533:

Line 2530: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');

2526: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2527:
2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2529: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2530: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2531: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2533:
2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2531: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');

2527:
2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2529: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2530: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2531: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2533:
2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2535: RAISE;

Line 2532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2529: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2530: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2531: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2533:
2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2535: RAISE;
2536:

Line 2542: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2538:
2539: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2540:
2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2542: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2543: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2544: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2546:

Line 2543: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');

2539: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2540:
2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2542: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2543: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2544: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2546:
2547: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2544: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');

2540:
2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2542: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2543: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2544: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2546:
2547: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2548: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2542: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2543: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2544: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2546:
2547: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2548: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2549: FND_MESSAGE.SET_TOKEN('VALUE',

Line 2547: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2543: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PROJECT');
2544: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2546:
2547: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2548: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2549: FND_MESSAGE.SET_TOKEN('VALUE',
2550: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2551: MSC_CL_COLLECTION.v_instance_id));

Line 2548: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

2544: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PROJECT_TASKS');
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2546:
2547: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2548: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2549: FND_MESSAGE.SET_TOKEN('VALUE',
2550: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2551: MSC_CL_COLLECTION.v_instance_id));
2552: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2549: FND_MESSAGE.SET_TOKEN('VALUE',

2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2546:
2547: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2548: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2549: FND_MESSAGE.SET_TOKEN('VALUE',
2550: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2551: MSC_CL_COLLECTION.v_instance_id));
2552: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2553:

Line 2552: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2548: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2549: FND_MESSAGE.SET_TOKEN('VALUE',
2550: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2551: MSC_CL_COLLECTION.v_instance_id));
2552: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2553:
2554: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2555: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
2556: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_ID);

Line 2554: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2550: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2551: MSC_CL_COLLECTION.v_instance_id));
2552: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2553:
2554: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2555: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
2556: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_ID);
2557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2558:

Line 2555: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');

2551: MSC_CL_COLLECTION.v_instance_id));
2552: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2553:
2554: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2555: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
2556: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_ID);
2557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2558:
2559: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2556: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_ID);

2552: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2553:
2554: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2555: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
2556: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_ID);
2557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2558:
2559: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2560: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_NAME');

Line 2557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2553:
2554: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2555: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
2556: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_ID);
2557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2558:
2559: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2560: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_NAME');
2561: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TASK_NAME);

Line 2559: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2555: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROJECT_ID');
2556: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_ID);
2557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2558:
2559: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2560: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_NAME');
2561: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TASK_NAME);
2562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2563:

Line 2560: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_NAME');

2556: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PROJECT_ID);
2557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2558:
2559: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2560: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_NAME');
2561: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TASK_NAME);
2562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2563:
2564: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2561: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TASK_NAME);

2557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2558:
2559: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2560: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_NAME');
2561: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TASK_NAME);
2562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2563:
2564: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2565: END IF;

Line 2562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2558:
2559: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2560: FND_MESSAGE.SET_TOKEN('COLUMN', 'TASK_NAME');
2561: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TASK_NAME);
2562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2563:
2564: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2565: END IF;
2566:

Line 2663: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2659:
2660: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2661:
2662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2663: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2664: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2665: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2667:

Line 2664: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

2660: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2661:
2662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2663: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2664: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2665: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2667:
2668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2665: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');

2661:
2662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2663: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2664: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2665: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2667:
2668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2669: RAISE;

Line 2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2663: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2664: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2665: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2667:
2668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2669: RAISE;
2670:

Line 2675: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2671: ELSE
2672: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2673:
2674: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2675: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2676: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2677: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2679:

Line 2676: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

2672: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2673:
2674: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2675: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2676: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2677: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2679:
2680: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2677: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');

2673:
2674: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2675: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2676: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2677: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2679:
2680: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2681: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');

Line 2678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2674: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2675: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2676: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2677: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2679:
2680: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2681: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2682: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));

Line 2680: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2676: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2677: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2679:
2680: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2681: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2682: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2684:

Line 2681: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');

2677: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERFORMANCE_MEASURES');
2678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2679:
2680: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2681: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2682: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2684:
2685: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2682: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));

2678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2679:
2680: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2681: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2682: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2684:
2685: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2686: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_DIMENSION_ID');

Line 2683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2679:
2680: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2681: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2682: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2684:
2685: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2686: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_DIMENSION_ID');
2687: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_DIMENSION_ID);

Line 2685: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2681: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2682: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2684:
2685: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2686: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_DIMENSION_ID');
2687: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_DIMENSION_ID);
2688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2689:

Line 2686: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_DIMENSION_ID');

2682: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2684:
2685: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2686: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_DIMENSION_ID');
2687: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_DIMENSION_ID);
2688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2689:
2690: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2687: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_DIMENSION_ID);

2683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2684:
2685: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2686: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_DIMENSION_ID');
2687: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_DIMENSION_ID);
2688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2689:
2690: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2691: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_DIMENSION_ID');

Line 2688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2684:
2685: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2686: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_DIMENSION_ID');
2687: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_DIMENSION_ID);
2688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2689:
2690: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2691: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_DIMENSION_ID');
2692: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_DIMENSION_ID);

Line 2690: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2686: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_DIMENSION_ID');
2687: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_DIMENSION_ID);
2688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2689:
2690: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2691: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_DIMENSION_ID');
2692: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_DIMENSION_ID);
2693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2694:

Line 2691: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_DIMENSION_ID');

2687: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_DIMENSION_ID);
2688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2689:
2690: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2691: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_DIMENSION_ID');
2692: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_DIMENSION_ID);
2693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2694:
2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2692: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_DIMENSION_ID);

2688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2689:
2690: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2691: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_DIMENSION_ID');
2692: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_DIMENSION_ID);
2693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2694:
2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2696: END IF;

Line 2693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2689:
2690: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2691: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_DIMENSION_ID');
2692: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_DIMENSION_ID);
2693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2694:
2695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2696: END IF;
2697:

Line 2816: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2812:
2813: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2814:
2815: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2816: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2817: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2818: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2820:

Line 2817: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

2813: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2814:
2815: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2816: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2817: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2818: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2820:
2821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2818: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');

2814:
2815: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2816: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2817: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2818: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2820:
2821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2822: RAISE;

Line 2819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2815: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2816: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2817: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2818: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2819: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2820:
2821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2822: RAISE;
2823:

Line 2829: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2825:
2826: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2827:
2828: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2829: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2833:

Line 2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

2826: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2827:
2828: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2829: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2833:
2834: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');

2827:
2828: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2829: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2833:
2834: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2835: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');

Line 2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2828: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2829: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2833:
2834: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2835: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
2836: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TARGET_LEVEL_ID);

Line 2834: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2833:
2834: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2835: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
2836: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TARGET_LEVEL_ID);
2837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2838:

Line 2835: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');

2831: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGET_LEVELS');
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2833:
2834: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2835: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
2836: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TARGET_LEVEL_ID);
2837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2838:
2839: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2836: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TARGET_LEVEL_ID);

2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2833:
2834: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2835: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
2836: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TARGET_LEVEL_ID);
2837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2838:
2839: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2840: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');

Line 2837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2833:
2834: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2835: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
2836: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TARGET_LEVEL_ID);
2837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2838:
2839: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2840: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2841: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));

Line 2839: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2835: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
2836: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TARGET_LEVEL_ID);
2837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2838:
2839: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2840: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2841: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2843:

Line 2840: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');

2836: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TARGET_LEVEL_ID);
2837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2838:
2839: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2840: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2841: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2843:
2844: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2841: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));

2837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2838:
2839: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2840: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2841: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2843:
2844: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2845: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');

Line 2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2838:
2839: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2840: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2841: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2843:
2844: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2845: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
2846: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_ID);

Line 2844: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2840: FND_MESSAGE.SET_TOKEN('COLUMN', 'MEASURE_ID');
2841: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2843:
2844: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2845: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
2846: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_ID);
2847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2848:

Line 2845: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');

2841: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.MEASURE_ID));
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2843:
2844: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2845: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
2846: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_ID);
2847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2848:
2849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2846: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_ID);

2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2843:
2844: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2845: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
2846: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_ID);
2847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2848:
2849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2850: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');

Line 2847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2843:
2844: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2845: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
2846: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_ID);
2847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2848:
2849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2850: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
2851: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_ID);

Line 2849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2845: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
2846: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_ID);
2847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2848:
2849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2850: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
2851: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_ID);
2852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2853:

Line 2850: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');

2846: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_ID);
2847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2848:
2849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2850: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
2851: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_ID);
2852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2853:
2854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2851: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_ID);

2847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2848:
2849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2850: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
2851: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_ID);
2852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2853:
2854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2855: END IF;

Line 2852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2848:
2849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2850: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
2851: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_ID);
2852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2853:
2854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2855: END IF;
2856:

Line 2982: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2978:
2979: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2980:
2981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2982: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2983: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2984: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2986:

Line 2983: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

2979: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2980:
2981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2982: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2983: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2984: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2986:
2987: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2984: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');

2980:
2981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2982: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2983: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2984: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2986:
2987: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2988: RAISE;

Line 2985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2982: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2983: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2984: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2986:
2987: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2988: RAISE;
2989:

Line 2994: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

2990: ELSE
2991: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2992:
2993: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2994: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2995: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2996: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2998:

Line 2995: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

2991: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2992:
2993: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2994: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2995: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2996: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2998:
2999: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 2996: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');

2992:
2993: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2994: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2995: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2996: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2998:
2999: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3000: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_ID');

Line 2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2993: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2994: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2995: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2996: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2998:
2999: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3000: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_ID');
3001: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_ID));

Line 2999: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

2995: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
2996: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2998:
2999: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3000: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_ID');
3001: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_ID));
3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3003:

Line 3000: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_ID');

2996: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_TARGETS');
2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2998:
2999: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3000: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_ID');
3001: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_ID));
3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3003:
3004: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3001: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_ID));

2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2998:
2999: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3000: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_ID');
3001: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_ID));
3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3003:
3004: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3005: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');

Line 3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2998:
2999: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3000: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_ID');
3001: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_ID));
3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3003:
3004: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3005: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
3006: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_LEVEL_ID));

Line 3004: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3000: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_ID');
3001: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_ID));
3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3003:
3004: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3005: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
3006: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_LEVEL_ID));
3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3008:

Line 3005: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');

3001: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_ID));
3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3003:
3004: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3005: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
3006: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_LEVEL_ID));
3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3008:
3009: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3006: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_LEVEL_ID));

3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3003:
3004: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3005: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
3006: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_LEVEL_ID));
3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3008:
3009: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3010: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');

Line 3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3003:
3004: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3005: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
3006: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_LEVEL_ID));
3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3008:
3009: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3010: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3011: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));

Line 3009: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3005: FND_MESSAGE.SET_TOKEN('COLUMN', 'TARGET_LEVEL_ID');
3006: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_LEVEL_ID));
3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3008:
3009: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3010: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3011: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3012: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3013:

Line 3010: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');

3006: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TARGET_LEVEL_ID));
3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3008:
3009: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3010: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3011: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3012: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3013:
3014: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3011: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));

3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3008:
3009: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3010: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3011: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3012: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3013:
3014: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3015: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');

Line 3012: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3008:
3009: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3010: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3011: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3012: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3013:
3014: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3015: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
3016: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_VALUE_ID);

Line 3014: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3010: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3011: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3012: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3013:
3014: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3015: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
3016: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_VALUE_ID);
3017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3018:

Line 3015: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');

3011: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3012: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3013:
3014: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3015: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
3016: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_VALUE_ID);
3017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3018:
3019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3016: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_VALUE_ID);

3012: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3013:
3014: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3015: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
3016: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_VALUE_ID);
3017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3018:
3019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3020: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');

Line 3017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3013:
3014: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3015: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
3016: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_VALUE_ID);
3017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3018:
3019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3020: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_VALUE_ID);

Line 3019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3015: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORG_LEVEL_ID');
3016: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_VALUE_ID);
3017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3018:
3019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3020: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_VALUE_ID);
3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:

Line 3020: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');

3016: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ORG_LEVEL_VALUE_ID);
3017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3018:
3019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3020: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_VALUE_ID);
3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:
3024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3021: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_VALUE_ID);

3017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3018:
3019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3020: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_VALUE_ID);
3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:
3024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3025: END IF;

Line 3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3018:
3019: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3020: FND_MESSAGE.SET_TOKEN('COLUMN', 'TIME_LEVEL_ID');
3021: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.TIME_LEVEL_VALUE_ID);
3022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3023:
3024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3025: END IF;
3026:

Line 3104: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3100:
3101: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3102:
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3104: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3108:

Line 3105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

3101: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3102:
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3104: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3108:
3109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');

3102:
3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3104: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3108:
3109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3110: RAISE;

Line 3107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3104: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3108:
3109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3110: RAISE;
3111:

Line 3117: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3113:
3114: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3115:
3116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3117: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3118: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3119: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3121:

Line 3118: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

3114: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3115:
3116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3117: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3118: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3119: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3121:
3122: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3119: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');

3115:
3116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3117: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3118: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3119: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3121:
3122: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3123: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');

Line 3120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3117: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3118: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3119: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3121:
3122: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3123: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3124: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));

Line 3122: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3118: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3119: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3121:
3122: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3123: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3124: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3126:

Line 3123: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');

3119: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_BUSINESS_PLANS');
3120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3121:
3122: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3123: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3124: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3126:
3127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3124: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));

3120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3121:
3122: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3123: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3124: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3126:
3127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3128: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERSION_NO');

Line 3125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3121:
3122: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3123: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3124: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3126:
3127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3128: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERSION_NO');
3129: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.VERSION_NO));

Line 3127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3123: FND_MESSAGE.SET_TOKEN('COLUMN', 'BUSINESS_PLAN_ID');
3124: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3126:
3127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3128: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERSION_NO');
3129: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.VERSION_NO));
3130: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3131:

Line 3128: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERSION_NO');

3124: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.BUSINESS_PLAN_ID));
3125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3126:
3127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3128: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERSION_NO');
3129: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.VERSION_NO));
3130: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3131:
3132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3129: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.VERSION_NO));

3125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3126:
3127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3128: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERSION_NO');
3129: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.VERSION_NO));
3130: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3131:
3132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3133: END IF;

Line 3130: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3126:
3127: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3128: FND_MESSAGE.SET_TOKEN('COLUMN', 'VERSION_NO');
3129: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.VERSION_NO));
3130: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3131:
3132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3133: END IF;
3134:

Line 3266: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3262:
3263: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3264:
3265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3266: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3267: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3268: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3270:

Line 3267: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

3263: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3264:
3265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3266: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3267: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3268: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3270:
3271: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3268: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');

3264:
3265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3266: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3267: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3268: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3270:
3271: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3272: RAISE;

Line 3269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3266: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3267: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3268: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3270:
3271: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3272: RAISE;
3273:

Line 3278: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3274: ELSE
3275: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3276:
3277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3278: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3279: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3282:

Line 3279: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');

3275: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3276:
3277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3278: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3279: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3282:
3283: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');

3276:
3277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3278: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3279: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3282:
3283: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3284: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 3281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3278: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3279: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3282:
3283: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3284: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3285: FND_MESSAGE.SET_TOKEN('VALUE',

Line 3283: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3279: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3282:
3283: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3284: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3285: FND_MESSAGE.SET_TOKEN('VALUE',
3286: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3287: MSC_CL_COLLECTION.v_instance_id));

Line 3284: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

3280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3282:
3283: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3284: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3285: FND_MESSAGE.SET_TOKEN('VALUE',
3286: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3287: MSC_CL_COLLECTION.v_instance_id));
3288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3285: FND_MESSAGE.SET_TOKEN('VALUE',

3281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3282:
3283: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3284: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3285: FND_MESSAGE.SET_TOKEN('VALUE',
3286: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3287: MSC_CL_COLLECTION.v_instance_id));
3288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3289:

Line 3288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3284: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3285: FND_MESSAGE.SET_TOKEN('VALUE',
3286: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3287: MSC_CL_COLLECTION.v_instance_id));
3288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3289:
3290: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3291: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_SET_NAME');
3292: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_SET_NAME);

Line 3290: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3286: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3287: MSC_CL_COLLECTION.v_instance_id));
3288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3289:
3290: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3291: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_SET_NAME');
3292: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_SET_NAME);
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3294:

Line 3291: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_SET_NAME');

3287: MSC_CL_COLLECTION.v_instance_id));
3288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3289:
3290: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3291: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_SET_NAME');
3292: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_SET_NAME);
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3294:
3295: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3292: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_SET_NAME);

3288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3289:
3290: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3291: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_SET_NAME');
3292: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_SET_NAME);
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3294:
3295: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3296: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_NAME');

Line 3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3289:
3290: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3291: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_SET_NAME');
3292: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_SET_NAME);
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3294:
3295: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3296: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_NAME');
3297: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_NAME);

Line 3295: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3291: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_SET_NAME');
3292: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_SET_NAME);
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3294:
3295: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3296: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_NAME');
3297: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_NAME);
3298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3299:

Line 3296: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_NAME');

3292: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_SET_NAME);
3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3294:
3295: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3296: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_NAME');
3297: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_NAME);
3298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3299:
3300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3297: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_NAME);

3293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3294:
3295: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3296: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_NAME');
3297: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_NAME);
3298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3299:
3300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3301: END IF;

Line 3298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3294:
3295: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3296: FND_MESSAGE.SET_TOKEN('COLUMN', 'PERIOD_NAME');
3297: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PERIOD_NAME);
3298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3299:
3300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3301: END IF;
3302:

Line 3484: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3480:
3481: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3482:
3483: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3484: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3488:

Line 3485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');

3481: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3482:
3483: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3484: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3488:
3489: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');

3482:
3483: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3484: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3488:
3489: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3490: RAISE;

Line 3487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3483: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3484: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3488:
3489: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3490: RAISE;
3491:

Line 3496: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3492: ELSE
3493: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3494:
3495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3496: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3497: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3498: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3499: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3500:

Line 3497: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');

3493: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3494:
3495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3496: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3497: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3498: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3499: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3500:
3501: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3498: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');

3494:
3495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3496: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3497: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3498: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3499: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3500:
3501: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3502: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_ID');

Line 3499: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3496: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3497: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3498: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3499: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3500:
3501: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3502: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_ID');
3503: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RULE_ID));

Line 3501: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3497: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ATP_RULES');
3498: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3499: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3500:
3501: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3502: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_ID');
3503: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RULE_ID));
3504: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3505:

Line 3502: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_ID');

3498: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ATP_RULES');
3499: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3500:
3501: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3502: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_ID');
3503: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RULE_ID));
3504: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3505:
3506: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3503: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RULE_ID));

3499: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3500:
3501: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3502: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_ID');
3503: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RULE_ID));
3504: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3505:
3506: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3507: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_NAME');

Line 3504: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3500:
3501: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3502: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_ID');
3503: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RULE_ID));
3504: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3505:
3506: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3507: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_NAME');
3508: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RULE_NAME);

Line 3506: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3502: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_ID');
3503: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RULE_ID));
3504: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3505:
3506: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3507: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_NAME');
3508: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RULE_NAME);
3509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3510:

Line 3507: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_NAME');

3503: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.RULE_ID));
3504: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3505:
3506: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3507: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_NAME');
3508: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RULE_NAME);
3509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3510:
3511: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3508: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RULE_NAME);

3504: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3505:
3506: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3507: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_NAME');
3508: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RULE_NAME);
3509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3510:
3511: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3512: END IF;

Line 3509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3505:
3506: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3507: FND_MESSAGE.SET_TOKEN('COLUMN', 'RULE_NAME');
3508: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.RULE_NAME);
3509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3510:
3511: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3512: END IF;
3513:

Line 3616: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3612:
3613: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3614:
3615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3616: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3617: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3618: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3620:

Line 3617: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');

3613: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3614:
3615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3616: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3617: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3618: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3620:
3621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3618: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');

3614:
3615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3616: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3617: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3618: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3620:
3621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3622: RAISE;

Line 3619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3616: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3617: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3618: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3620:
3621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3622: RAISE;
3623:

Line 3628: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3624: ELSE
3625: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3626:
3627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3628: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3630: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3632:

Line 3629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');

3625: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3626:
3627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3628: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3630: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3632:
3633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3630: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');

3626:
3627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3628: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3630: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3632:
3633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3634: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 3631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3628: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3630: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3632:
3633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3634: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3635: FND_MESSAGE.SET_TOKEN('VALUE',

Line 3633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3630: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3632:
3633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3634: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3635: FND_MESSAGE.SET_TOKEN('VALUE',
3636: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3637: MSC_CL_COLLECTION.v_instance_id));

Line 3634: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

3630: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_PLANNERS');
3631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3632:
3633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3634: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3635: FND_MESSAGE.SET_TOKEN('VALUE',
3636: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3637: MSC_CL_COLLECTION.v_instance_id));
3638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3635: FND_MESSAGE.SET_TOKEN('VALUE',

3631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3632:
3633: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3634: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3635: FND_MESSAGE.SET_TOKEN('VALUE',
3636: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3637: MSC_CL_COLLECTION.v_instance_id));
3638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3639:

Line 3638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3634: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3635: FND_MESSAGE.SET_TOKEN('VALUE',
3636: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3637: MSC_CL_COLLECTION.v_instance_id));
3638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3639:
3640: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3641: FND_MESSAGE.SET_TOKEN('COLUMN', 'PLANNER_CODE');
3642: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PLANNER_CODE);

Line 3640: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3636: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3637: MSC_CL_COLLECTION.v_instance_id));
3638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3639:
3640: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3641: FND_MESSAGE.SET_TOKEN('COLUMN', 'PLANNER_CODE');
3642: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PLANNER_CODE);
3643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3644:

Line 3641: FND_MESSAGE.SET_TOKEN('COLUMN', 'PLANNER_CODE');

3637: MSC_CL_COLLECTION.v_instance_id));
3638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3639:
3640: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3641: FND_MESSAGE.SET_TOKEN('COLUMN', 'PLANNER_CODE');
3642: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PLANNER_CODE);
3643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3644:
3645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3642: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PLANNER_CODE);

3638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3639:
3640: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3641: FND_MESSAGE.SET_TOKEN('COLUMN', 'PLANNER_CODE');
3642: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PLANNER_CODE);
3643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3644:
3645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3646: END IF;

Line 3643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3639:
3640: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3641: FND_MESSAGE.SET_TOKEN('COLUMN', 'PLANNER_CODE');
3642: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.PLANNER_CODE);
3643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3644:
3645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3646: END IF;
3647:

Line 3669: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3665:
3666: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3667:
3668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3669: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3670: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3671: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_USER');
3672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3673:

Line 3670: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');

3666: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3667:
3668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3669: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3670: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3671: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_USER');
3672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3673:
3674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3671: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_USER');

3667:
3668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3669: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3670: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3671: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_USER');
3672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3673:
3674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3675: FND_MESSAGE.SET_TOKEN('COLUMN', 'USER_NAME');

Line 3672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3669: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3670: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3671: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_USER');
3672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3673:
3674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3675: FND_MESSAGE.SET_TOKEN('COLUMN', 'USER_NAME');
3676: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.USER_NAME);

Line 3674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3670: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3671: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_USER');
3672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3673:
3674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3675: FND_MESSAGE.SET_TOKEN('COLUMN', 'USER_NAME');
3676: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.USER_NAME);
3677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3678:

Line 3675: FND_MESSAGE.SET_TOKEN('COLUMN', 'USER_NAME');

3671: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_USER');
3672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3673:
3674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3675: FND_MESSAGE.SET_TOKEN('COLUMN', 'USER_NAME');
3676: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.USER_NAME);
3677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3678:
3679: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3676: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.USER_NAME);

3672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3673:
3674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3675: FND_MESSAGE.SET_TOKEN('COLUMN', 'USER_NAME');
3676: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.USER_NAME);
3677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3678:
3679: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3680:

Line 3677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3673:
3674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3675: FND_MESSAGE.SET_TOKEN('COLUMN', 'USER_NAME');
3676: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.USER_NAME);
3677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3678:
3679: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3680:
3681: END;

Line 3772: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3768:
3769: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3770:
3771: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3772: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3773: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3774: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3775: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3776:

Line 3773: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');

3769: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3770:
3771: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3772: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3773: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3774: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3775: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3776:
3777: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3774: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');

3770:
3771: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3772: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3773: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3774: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3775: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3776:
3777: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3778: RAISE;

Line 3775: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3771: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3772: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3773: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3774: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3775: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3776:
3777: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3778: RAISE;
3779:

Line 3785: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

3781:
3782: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3783:
3784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3785: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3786: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3787: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3789:

Line 3786: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');

3782: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3783:
3784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3785: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3786: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3787: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3789:
3790: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 3787: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');

3783:
3784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3785: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3786: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3787: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3789:
3790: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3791: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_CLASS');

Line 3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3784: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3785: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3786: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3787: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3789:
3790: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3791: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_CLASS');
3792: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEMAND_CLASS);

Line 3790: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

3786: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND_CLASS');
3787: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3789:
3790: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3791: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_CLASS');
3792: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEMAND_CLASS);
3793: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3794:

Line 3791: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_CLASS');

3787: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMAND_CLASSES');
3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3789:
3790: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3791: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_CLASS');
3792: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEMAND_CLASS);
3793: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3794:
3795: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 3792: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEMAND_CLASS);

3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3789:
3790: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3791: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_CLASS');
3792: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEMAND_CLASS);
3793: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3794:
3795: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3796: END IF;

Line 3793: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3789:
3790: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3791: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_CLASS');
3792: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DEMAND_CLASS);
3793: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3794:
3795: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3796: END IF;
3797:

Line 4124: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

4120:
4121: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
4122:
4123: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4124: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4125: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4126: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4128:

Line 4125: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');

4121: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
4122:
4123: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4124: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4125: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4126: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4128:
4129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 4126: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');

4122:
4123: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4124: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4125: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4126: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4128:
4129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4130: RAISE;

Line 4127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

4123: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4124: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4125: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4126: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4128:
4129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4130: RAISE;
4131:

Line 4136: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

4132: ELSE
4133: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4134:
4135: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4136: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4137: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4138: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4140:

Line 4137: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');

4133: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4134:
4135: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4136: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4137: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4138: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4140:
4141:

Line 4138: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');

4134:
4135: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4136: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4137: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4138: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4140:
4141:
4142: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 4139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

4135: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4136: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4137: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4138: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4140:
4141:
4142: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4143: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');

Line 4142: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

4138: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4140:
4141:
4142: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4143: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
4144: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.NAME);
4145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 4143: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');

4139: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4140:
4141:
4142: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4143: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
4144: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.NAME);
4145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4147:

Line 4144: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.NAME);

4140:
4141:
4142: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4143: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
4144: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.NAME);
4145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4147:
4148: END IF;

Line 4145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

4141:
4142: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4143: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
4144: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.NAME);
4145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4147:
4148: END IF;
4149:

Line 4228: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

4224:
4225: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
4226:
4227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4228: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4229: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4230: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4232:

Line 4229: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');

4225: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
4226:
4227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4228: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4229: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4230: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4232:
4233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 4230: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');

4226:
4227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4228: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4229: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4230: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4232:
4233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4234: RAISE;

Line 4231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

4227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4228: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4229: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4230: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4232:
4233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4234: RAISE;
4235:

Line 4240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

4236: ELSE
4237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4238:
4239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4244:

Line 4241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');

4237: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4238:
4239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4244:
4245:

Line 4242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');

4238:
4239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4244:
4245:
4246: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

Line 4243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

4239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4244:
4245:
4246: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4247: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOP_ID');

Line 4246: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

4242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4244:
4245:
4246: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4247: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOP_ID');
4248: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.STOP_ID));
4249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4250:

Line 4247: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOP_ID');

4243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4244:
4245:
4246: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4247: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOP_ID');
4248: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.STOP_ID));
4249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4250:
4251: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 4248: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.STOP_ID));

4244:
4245:
4246: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4247: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOP_ID');
4248: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.STOP_ID));
4249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4250:
4251: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4252:

Line 4249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

4245:
4246: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4247: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOP_ID');
4248: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR( c_rec.STOP_ID));
4249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4250:
4251: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4252:
4253: END IF;