DBA Data[Home] [Help]

APPS.MSC_ATP_24X7 dependencies on MSC_POST_PRO

Line 118: RETCODE := MSC_POST_PRO.G_SUCCESS;

114: l_new_plan_id number;
115:
116: BEGIN
117:
118: RETCODE := MSC_POST_PRO.G_SUCCESS;
119: G_TFS_ERROR := null;
120: G_TFS_ERRCODE := MSC_POST_PRO.G_SUCCESS;
121:
122:

Line 120: G_TFS_ERRCODE := MSC_POST_PRO.G_SUCCESS;

116: BEGIN
117:
118: RETCODE := MSC_POST_PRO.G_SUCCESS;
119: G_TFS_ERROR := null;
120: G_TFS_ERRCODE := MSC_POST_PRO.G_SUCCESS;
121:
122:
123: conc_log ('---------------Call_Synchronize -------------------');
124:

Line 130: RETCODE := MSC_POST_PRO.G_WARNING;

126: conc_log (' ');
127:
128: if (p_old_plan_id is NULL) then
129: conc_log ('Plan ID is NULL. Please specify a plan ID');
130: RETCODE := MSC_POST_PRO.G_WARNING;
131: RETURN;
132: end if;
133:
134: conc_debug ('Fetching New PLAN ID from the database ...');

Line 143: RETCODE := MSC_POST_PRO.G_ERROR;

139: where copy_plan_id = p_old_plan_id;
140: EXCEPTION
141: when OTHERS then
142: conc_log ('Unable to retrieve the copy plan ID for the old plan');
143: RETCODE := MSC_POST_PRO.G_ERROR;
144: ERRBUF := sqlerrm;
145: RETURN;
146: END;
147:

Line 216: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;

212: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
213: conc_log (' Cannot update ATP Summary status flag.');
214: ATP_Sync_Error(p_old_plan_id, p_new_plan_id);
215: G_TFS_ERROR := 'Unable to update Plan Information';
216: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;
217: commit;
218: return;
219: end if;
220:

Line 276: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;

272:
273: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
274: ATP_Sync_Error (p_old_plan_id, p_new_plan_id);
275: G_TFS_ERROR := 'Unable to get records for synchronization';
276: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;
277:
278: commit;
279: return;
280: end if;

Line 311: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;

307: conc_log ('Something wrong in call to ATP Downtime Init');
308: -- Rollback changes made by ATP downtim INIt
309: rollback;
310: G_TFS_ERROR := 'Unable to Initiate ATP Downtime';
311: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;
312:
313: ATP_Sync_Error (p_old_plan_id, p_new_plan_id);
314: commit;
315: return;

Line 334: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;

330:
331: if (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
332: ROLLBACK;
333: G_TFS_ERROR := 'Call to ATP API for Synchronization failed';
334: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;
335: ATP_Sync_Error (p_old_plan_id, p_new_plan_id);
336: commit;
337: return;
338: end if;

Line 358: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;

354: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
355: conc_log ('Unable to update sync flag ');
356: ROLLBACK;
357: G_TFS_ERROR := 'Unable to update Plan Information';
358: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;
359:
360: ATP_Sync_Error (p_old_plan_id, p_new_plan_id);
361: commit;
362: return;

Line 483: G_TFS_ERRCODE := MSC_POST_PRO.G_WARNING;

479: ROLLBACK;
480: conc_log ('Something wrong in call to ATP');
481: conc_log ('Stray records do exist, and may not be synchronized');
482: G_TFS_ERROR := 'Error in call to ATP API for Extended Synchronization';
483: G_TFS_ERRCODE := MSC_POST_PRO.G_WARNING;
484: return;
485: end if;
486:
487: l_atp_rec.attribute_03 := l_demand_id_arr;

Line 512: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;

508: conc_log ('Exception in Atp_synchronize');
509: conc_log ('Error is : ' || sqlerrm);
510:
511: G_TFS_ERROR := sqlerrm;
512: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514:
515: END ATP_SYNCHRONIZE;
516:

Line 898: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;

894: conc_log ('Get_Records_Pre_Coll: Error while getting records from old plan');
895: conc_log ('Error Is : ' || sqlerrm);
896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
897: G_TFS_ERROR := sqlerrm;
898: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;
899:
900: END;
901: END Get_Records_Pre_Collections;
902:

Line 1229: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;

1225: conc_log ('Get_Records_Post_Coll: Error while getting records from old plan');
1226: conc_log ('Error Is : ' || sqlerrm);
1227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1228: G_TFS_ERROR := sqlerrm;
1229: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;
1230:
1231: END;
1232: END Get_Records_Post_Collections;
1233:

Line 1376: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;

1372: conc_log ('Concurrent program error. Code : ' || sqlcode);
1373: conc_log (' Error : ' || sqlerrm);
1374: x_return_status := FND_API.G_RET_STS_ERROR;
1375: G_TFS_ERROR := 'Unable to switch plans';
1376: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;
1377: return;
1378: END;
1379:
1380: conc_log ('Switch Plans launched with request ID ' || l_request_id);

Line 1398: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;

1394: if (l_dev_status <> 'NORMAL') then
1395: conc_log ('Switch plans returned with ' || l_dev_status);
1396: x_return_status := FND_API.G_RET_STS_ERROR;
1397: G_TFS_ERROR := 'Unable to switch plans - program returned with error';
1398: G_TFS_ERRCODE := MSC_POST_PRO.G_ERROR;
1399:
1400: return;
1401: end if;
1402: