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

APPS.MSC_CL_ITEM_ODS_LOAD dependencies on MSC_UTIL

Line 7: -- v_warning_flag NUMBER:= MSC_UTIL.SYS_NO; --2 be changed

3:
4: v_sql_stmt VARCHAR2(4000);
5: lv_sql_stmt1 VARCHAR2(4000);
6: v_sub_str VARCHAR2(4000);
7: -- v_warning_flag NUMBER:= MSC_UTIL.SYS_NO; --2 be changed
8:
9: -- G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');
10: -- To collect SRP Data when this profile is set to Yes neds to be deleted
11: -- v_is_cont_refresh BOOLEAN; -- 2 be changed

Line 53: IF (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES ) THEN

49: lv_inventory_item_id Number;
50: lv_organization_id Number ;
51: lv_min_last_item_coll_date DATE;
52: BEGIN
53: IF (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES ) THEN
54: lv_table_name:= 'SYSTEM_ITEMS_' || MSC_CL_COLLECTION.v_INSTANCE_CODE;
55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in ADD_NEW_IMPL_ITEM_ASL is ' || lv_table_name);
56: else
57: lv_table_name:= 'MSC_SYSTEM_ITEMS';

Line 55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in ADD_NEW_IMPL_ITEM_ASL is ' || lv_table_name);

51: lv_min_last_item_coll_date DATE;
52: BEGIN
53: IF (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES ) THEN
54: lv_table_name:= 'SYSTEM_ITEMS_' || MSC_CL_COLLECTION.v_INSTANCE_CODE;
55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in ADD_NEW_IMPL_ITEM_ASL is ' || lv_table_name);
56: else
57: lv_table_name:= 'MSC_SYSTEM_ITEMS';
58: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in ADD_NEW_IMPL_ITEM_ASL is ' || lv_table_name);
59: End if;

Line 58: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in ADD_NEW_IMPL_ITEM_ASL is ' || lv_table_name);

54: lv_table_name:= 'SYSTEM_ITEMS_' || MSC_CL_COLLECTION.v_INSTANCE_CODE;
55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in ADD_NEW_IMPL_ITEM_ASL is ' || lv_table_name);
56: else
57: lv_table_name:= 'MSC_SYSTEM_ITEMS';
58: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in ADD_NEW_IMPL_ITEM_ASL is ' || lv_table_name);
59: End if;
60:
61: v_sql_stmt := 'Select min (nvl(LAST_SUCC_ITEM_REF_TIME,SYSDATE-365000))'
62: ||' From msc_instance_orgs '

Line 64: ||' And organization_id '|| MSC_UTIL.v_in_org_str;

60:
61: v_sql_stmt := 'Select min (nvl(LAST_SUCC_ITEM_REF_TIME,SYSDATE-365000))'
62: ||' From msc_instance_orgs '
63: ||' Where sr_instance_id = ' || MSC_CL_COLLECTION.v_instance_id
64: ||' And organization_id '|| MSC_UTIL.v_in_org_str;
65:
66: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
67:
68: EXECUTE IMMEDIATE v_sql_stmt into lv_min_last_item_coll_date;

Line 66: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);

62: ||' From msc_instance_orgs '
63: ||' Where sr_instance_id = ' || MSC_CL_COLLECTION.v_instance_id
64: ||' And organization_id '|| MSC_UTIL.v_in_org_str;
65:
66: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
67:
68: EXECUTE IMMEDIATE v_sql_stmt into lv_min_last_item_coll_date;
69:
70: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);

Line 70: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);

66: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
67:
68: EXECUTE IMMEDIATE v_sql_stmt into lv_min_last_item_coll_date;
69:
70: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
71: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'minimum of last successful ITEM Collection refresh time is '||lv_min_last_item_coll_date);
72:
73: lv_sql_stmt := 'select x.inventory_item_id , x.organization_id '
74: ||' FROM ' || lv_table_name ||' x , MSC_INSTANCE_ORGS mio'

Line 71: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'minimum of last successful ITEM Collection refresh time is '||lv_min_last_item_coll_date);

67:
68: EXECUTE IMMEDIATE v_sql_stmt into lv_min_last_item_coll_date;
69:
70: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
71: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'minimum of last successful ITEM Collection refresh time is '||lv_min_last_item_coll_date);
72:
73: lv_sql_stmt := 'select x.inventory_item_id , x.organization_id '
74: ||' FROM ' || lv_table_name ||' x , MSC_INSTANCE_ORGS mio'
75: ||' WHERE '

Line 78: ||' AND x.organization_id '|| MSC_UTIL.v_in_org_str

74: ||' FROM ' || lv_table_name ||' x , MSC_INSTANCE_ORGS mio'
75: ||' WHERE '
76: ||' x.organization_id = mio.organization_id '
77: ||' AND x.sr_instance_id = mio.sr_instance_id '
78: ||' AND x.organization_id '|| MSC_UTIL.v_in_org_str
79: ||' AND x.item_creation_date > nvl(mio.LAST_SUCC_ITEM_REF_TIME, SYSDATE-365000)'
80: ||' AND x.item_creation_date>:lv_min_last_item_coll_date'
81: ||' AND x.sr_instance_id = ' || MSC_CL_COLLECTION.v_instance_id
82: ||' AND x.plan_id =-1 ';

Line 84: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'the sql statement is ' || lv_sql_stmt);

80: ||' AND x.item_creation_date>:lv_min_last_item_coll_date'
81: ||' AND x.sr_instance_id = ' || MSC_CL_COLLECTION.v_instance_id
82: ||' AND x.plan_id =-1 ';
83:
84: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'the sql statement is ' || lv_sql_stmt);
85:
86: Open c1 for lv_sql_stmt using lv_min_last_item_coll_date ;
87: IF (c1%ISOPEN ) THEN
88: LOOP

Line 189: || ' AND ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str || ' ) a ';

185: || ' WHERE SR_INSTANCE_ID =' || MSC_CL_COLLECTION.v_instance_id
186: || ' AND PLAN_ID =-1 '
187: || ' AND USING_ORGANIZATION_ID =-1 '
188: || ' AND INVENTORY_ITEM_ID =' ||lv_inventory_item_id
189: || ' AND ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str || ' ) a ';
190:
191: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql in inser_Asl ' || lv_sql_stmt1);
192:
193: EXECUTE IMMEDIATE lv_sql_stmt1

Line 191: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql in inser_Asl ' || lv_sql_stmt1);

187: || ' AND USING_ORGANIZATION_ID =-1 '
188: || ' AND INVENTORY_ITEM_ID =' ||lv_inventory_item_id
189: || ' AND ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str || ' ) a ';
190:
191: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql in inser_Asl ' || lv_sql_stmt1);
192:
193: EXECUTE IMMEDIATE lv_sql_stmt1
194: USING lv_organization_id ,MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
195:

Line 196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows inserted in ADD_NEW_IMPL_ITEM_ASL ' || SQL%ROWCOUNT);

192:
193: EXECUTE IMMEDIATE lv_sql_stmt1
194: USING lv_organization_id ,MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
195:
196: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows inserted in ADD_NEW_IMPL_ITEM_ASL ' || SQL%ROWCOUNT);
197: commit ;
198: END LOOP;
199:
200: END IF ;

Line 206: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

202: CLOSE c1 ;
203: EXCEPTION
204:
205: WHEN OTHERS THEN
206: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
207:
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
209: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'ADD_NEW_IMPL_ITEM_ASL');

Line 208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

204:
205: WHEN OTHERS THEN
206: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
207:
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
209: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'ADD_NEW_IMPL_ITEM_ASL');
211: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
209: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
210: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'ADD_NEW_IMPL_ITEM_ASL');
211: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
212: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
213:
214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
215: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
216: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lv_inventory_item_id));

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

213:
214: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
215: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
216: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lv_inventory_item_id));
217: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
218:
219: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
220: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
221: FND_MESSAGE.SET_TOKEN('VALUE',

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

220: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
221: FND_MESSAGE.SET_TOKEN('VALUE',
222: MSC_GET_NAME.ORG_CODE( lv_organization_id,
223: MSC_CL_COLLECTION.v_instance_id));
224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
225:
226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
227:
228: END ADD_NEW_IMPL_ITEM_ASL;

Line 226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

222: MSC_GET_NAME.ORG_CODE( lv_organization_id,
223: MSC_CL_COLLECTION.v_instance_id));
224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
225:
226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
227:
228: END ADD_NEW_IMPL_ITEM_ASL;
229:
230: FUNCTION ITEM_NAME ( p_item_id IN NUMBER)

Line 289: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');

285:
286: EXCEPTION
287: WHEN OTHERS THEN
288: ROLLBACK;
289: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
290: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
291:
292: END UPDATE_LEADTIME;
293:

Line 290: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

286: EXCEPTION
287: WHEN OTHERS THEN
288: ROLLBACK;
289: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'An error has occurred.');
290: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
291:
292: END UPDATE_LEADTIME;
293:
294: PROCEDURE LOAD_ABC_CLASSES IS

Line 300: OR (MSC_CL_COLLECTION.v_is_incremental_refresh AND MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS120)) THEN

296: lv_sql_stmt VARCHAR2(7500);
297: BEGIN
298:
299: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh
300: OR (MSC_CL_COLLECTION.v_is_incremental_refresh AND MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS120)) THEN
301:
302: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
303: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ABC_CLASSES', MSC_CL_COLLECTION.v_instance_id,NULL );
304: ELSE

Line 302: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

298:
299: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh
300: OR (MSC_CL_COLLECTION.v_is_incremental_refresh AND MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS120)) THEN
301:
302: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
303: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ABC_CLASSES', MSC_CL_COLLECTION.v_instance_id,NULL );
304: ELSE
305: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
306: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ABC_CLASSES', MSC_CL_COLLECTION.v_instance_id,NULL,v_sub_str);

Line 305: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

301:
302: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
303: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ABC_CLASSES', MSC_CL_COLLECTION.v_instance_id,NULL );
304: ELSE
305: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
306: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ABC_CLASSES', MSC_CL_COLLECTION.v_instance_id,NULL,v_sub_str);
307: END IF;
308: /*changed for bug:4765403*/
309: IF MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS120 THEN

Line 309: IF MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS120 THEN

305: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
306: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ABC_CLASSES', MSC_CL_COLLECTION.v_instance_id,NULL,v_sub_str);
307: END IF;
308: /*changed for bug:4765403*/
309: IF MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS120 THEN
310:
311: lv_temp_sql_stmt :=
312: ' SELECT'
313: ||' msa.abc_class_id,'

Line 369: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

365: EXCEPTION
366: WHEN OTHERS THEN
367: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
368:
369: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
370: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
371: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
372: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

369: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
370: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
371: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
372: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
374:
375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
376: RAISE;
377:

Line 375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

371: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
372: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
374:
375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
376: RAISE;
377:
378: ELSE
379: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 379: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
376: RAISE;
377:
378: ELSE
379: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
380: null;
381:
382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
383: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');

Line 382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

378: ELSE
379: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
380: null;
381:
382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
383: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
384: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
385: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
383: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
384: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
385: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
387:
388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
389: END IF;
390:

Line 388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

384: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ABC_CLASSES');
385: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ABC_CLASSES');
386: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
387:
388: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
389: END IF;
390:
391: END;
392: END IF;

Line 439: AND msis.deleted_flag=MSC_UTIL.SYS_NO;

435: AND tps.SR_INSTANCE_ID(+)= msis.SR_INSTANCE_ID
436: AND tps.PARTNER_TYPE(+)= 2
437: AND msis.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
438: AND msis.relationship_type=2
439: AND msis.deleted_flag=MSC_UTIL.SYS_NO;
440:
441: CURSOR c2 IS
442: SELECT
443: t1.INVENTORY_ITEM_ID HIGHER_ITEM_ID,

Line 463: AND msis.deleted_flag=MSC_UTIL.SYS_NO;

459: AND t2.SR_INVENTORY_ITEM_ID = msis.LOWER_ITEM_ID
460: AND t2.SR_INSTANCE_ID = msis.SR_INSTANCE_ID
461: AND msis.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
462: AND msis.relationship_type in (5,8,18)
463: AND msis.deleted_flag=MSC_UTIL.SYS_NO;
464:
465: TYPE CharTblTyp IS TABLE OF VARCHAR2(70);
466: TYPE NumTblTyp IS TABLE OF NUMBER;
467: TYPE dateTblTyp IS TABLE OF DATE;

Line 487: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

483:
484: BEGIN
485:
486:
487: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
488: lv_tbl:= 'ITEM_SUBSTITUTES_'||MSC_CL_COLLECTION.v_INSTANCE_CODE;
489: ELSE
490: lv_tbl:= ' MSC_ITEM_SUBSTITUTES ';
491: END IF;

Line 641: ||' AND nvl(msis.deleted_flag,2)='||MSC_UTIL.SYS_NO;

637: ||' AND tps.SR_INSTANCE_ID(+)= msis.SR_INSTANCE_ID'
638: ||' AND tps.PARTNER_TYPE(+)= 2'
639: ||' AND msis.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
640: ||' AND msis. RELATIONSHIP_TYPE =2'
641: ||' AND nvl(msis.deleted_flag,2)='||MSC_UTIL.SYS_NO;
642:
643:
644: lv_cursor_stmt1:=
645: 'INSERT INTO '||lv_tbl

Line 693: ||' AND nvl(msis.deleted_flag,2)='||MSC_UTIL.SYS_NO;

689: ||' AND t2.SR_INVENTORY_ITEM_ID = msis.LOWER_ITEM_ID'
690: ||' AND t2.SR_INSTANCE_ID = msis.SR_INSTANCE_ID'
691: ||' AND msis.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
692: ||' AND msis. RELATIONSHIP_TYPE in (5,8,18)'
693: ||' AND nvl(msis.deleted_flag,2)='||MSC_UTIL.SYS_NO;
694:
695: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) AND
696: MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
697: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

Line 696: MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN

692: ||' AND msis. RELATIONSHIP_TYPE in (5,8,18)'
693: ||' AND nvl(msis.deleted_flag,2)='||MSC_UTIL.SYS_NO;
694:
695: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) AND
696: MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
697: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
698: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);
699: ELSE
700: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 697: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

693: ||' AND nvl(msis.deleted_flag,2)='||MSC_UTIL.SYS_NO;
694:
695: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) AND
696: MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
697: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
698: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);
699: ELSE
700: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
701: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 700: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

696: MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
697: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
698: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);
699: ELSE
700: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
701: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
702: END IF;
703: END IF;
704:

Line 720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

716:
717: EXCEPTION
718: WHEN OTHERS THEN
719: --LOG_MESSAGE(SQLERRM);
720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
721: IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
722:
723: end;
724: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' AND MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115) THEN

Line 724: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' AND MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115) THEN

720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
721: IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
722:
723: end;
724: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' AND MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
725:
726: begin
727: EXECUTE IMMEDIATE lv_cursor_stmt1
728: USING MSC_CL_COLLECTION.v_last_collection_id,

Line 738: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

734:
735: EXCEPTION
736: WHEN OTHERS THEN
737: -- LOG_MESSAGE(SQLERRM);
738: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
739: IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
740: end;
741:
742: END IF ;

Line 852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

848: MSC_CL_COLLECTION.v_current_user;
849: EXCEPTION
850: WHEN OTHERS THEN
851: -- LOG_MESSAGE(SQLERRM);
852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
853: IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
854: end;
855: END IF;
856:

Line 872: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' AND (MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115 OR MSC_CL_COLLECTION.v_is_legacy_refresh)) THEN

868:
869: lb_FetchComplete := FALSE;
870:
871:
872: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' AND (MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115 OR MSC_CL_COLLECTION.v_is_legacy_refresh)) THEN
873: Open c2;
874:
875: IF (c2%ISOPEN) THEN
876: LOOP

Line 945: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

941:
942: EXCEPTION
943: WHEN OTHERS THEN
944: -- LOG_MESSAGE(SQLERRM);
945: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
946: IF NOT Handle_Exception(SQLCODE) THEN RAISE; END IF;
947: end;
948: END IF;
949:

Line 966: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

962: CLOSE c2;
963: END IF; -- End of Net Change
964:
965:
966: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
967:
968: lv_tbl:= 'ITEM_SUBSTITUTES_'||MSC_CL_COLLECTION.v_INSTANCE_CODE;
969:
970: lv_sql_stmt:=

Line 975: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

971: 'INSERT INTO '||lv_tbl
972: ||' SELECT * from MSC_ITEM_SUBSTITUTES'
973: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
974: ||' AND plan_id = -1 '
975: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
976:
977: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
978: EXECUTE IMMEDIATE lv_sql_stmt;
979:

Line 977: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

973: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
974: ||' AND plan_id = -1 '
975: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
976:
977: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
978: EXECUTE IMMEDIATE lv_sql_stmt;
979:
980: COMMIT;
981:

Line 984: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

980: COMMIT;
981:
982: END IF;
983:
984: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
985: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
986: lv_retcode,
987: 'MSC_ITEM_SUBSTITUTES',
988: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 989: MSC_UTIL.G_WARNING

985: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
986: lv_retcode,
987: 'MSC_ITEM_SUBSTITUTES',
988: MSC_CL_COLLECTION.v_INSTANCE_CODE,
989: MSC_UTIL.G_WARNING
990: );
991:
992:
993: IF lv_retcode = MSC_UTIL.G_WARNING THEN

Line 993: IF lv_retcode = MSC_UTIL.G_WARNING THEN

989: MSC_UTIL.G_WARNING
990: );
991:
992:
993: IF lv_retcode = MSC_UTIL.G_WARNING THEN
994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
995: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
996: END IF;
997:

Line 994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

990: );
991:
992:
993: IF lv_retcode = MSC_UTIL.G_WARNING THEN
994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
995: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
996: END IF;
997:
998: END IF;

Line 995: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

991:
992:
993: IF lv_retcode = MSC_UTIL.G_WARNING THEN
994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
995: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
996: END IF;
997:
998: END IF;
999:

Line 1005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1001: EXCEPTION
1002: WHEN OTHERS THEN
1003: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1004:
1005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1006: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1007: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1008: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1009: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1005: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1006: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1007: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1008: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1009: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1010:
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1012: RAISE;
1013:

Line 1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1007: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1008: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1009: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1010:
1011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1012: RAISE;
1013:
1014: ELSE
1015:

Line 1016: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1012: RAISE;
1013:
1014: ELSE
1015:
1016: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1017:
1018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1019: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1020: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');

Line 1018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1014: ELSE
1015:
1016: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1017:
1018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1019: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1020: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1021: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1019: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1020: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_SUBSTITUTES');
1021: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUBSTITUTES');
1022: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1023:
1024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1025: FND_MESSAGE.SET_TOKEN('COLUMN', 'HIGHER_ITEM_ID');
1026: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.HIGHER_ITEM_ID) );

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

1023:
1024: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1025: FND_MESSAGE.SET_TOKEN('COLUMN', 'HIGHER_ITEM_ID');
1026: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.HIGHER_ITEM_ID) );
1027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1028:
1029: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1030: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOWER_ITEM_ID');
1031: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.LOWER_ITEM_ID) );

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

1028:
1029: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1030: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOWER_ITEM_ID');
1031: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.LOWER_ITEM_ID) );
1032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1033:
1034: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1035: END IF;
1036:

Line 1034: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1030: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOWER_ITEM_ID');
1031: -- FND_MESSAGE.SET_TOKEN('VALUE',TO_CHAR(c_rec.LOWER_ITEM_ID) );
1032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1033:
1034: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1035: END IF;
1036:
1037:
1038: COMMIT;

Line 1067: AND msic.DELETED_FLAG= MSC_UTIL.SYS_NO;

1063: AND t1.sr_instance_id= msic.sr_instance_id
1064: AND mcsil.SR_Category_Set_ID= msic.SR_Category_Set_ID
1065: AND mcsil.SR_Instance_ID= msic.SR_Instance_ID
1066: AND msic.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1067: AND msic.DELETED_FLAG= MSC_UTIL.SYS_NO;
1068:
1069: CURSOR c1_d IS
1070: SELECT
1071: msic.ORGANIZATION_ID,

Line 1084: AND msic.DELETED_FLAG= MSC_UTIL.SYS_YES;

1080: AND t1.sr_instance_id= msic.sr_instance_id
1081: AND mcsil.SR_Category_Set_ID= msic.SR_Category_Set_ID
1082: AND mcsil.SR_Instance_ID= msic.SR_Instance_ID
1083: AND msic.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1084: AND msic.DELETED_FLAG= MSC_UTIL.SYS_YES;
1085:
1086: c_count NUMBER:= 0;
1087: lv_tbl VARCHAR2(30);
1088: lv_sql_stmt VARCHAR2(5000);

Line 1118: if (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO) then

1114:
1115: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1116: -- We want to delete all CATEGORY related data and get new stuff.
1117:
1118: if (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO) then
1119: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);
1120:
1121: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1122: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);

Line 1121: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

1117:
1118: if (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO) then
1119: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);
1120:
1121: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1122: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);
1123: ELSE
1124: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1125: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL,v_sub_str);

Line 1124: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1120:
1121: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1122: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);
1123: ELSE
1124: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1125: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL,v_sub_str);
1126: END IF;
1127: end if;
1128:

Line 1131: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

1127: end if;
1128:
1129: END IF;
1130:
1131: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1132: lv_tbl:= 'ITEM_CATEGORIES_'||MSC_CL_COLLECTION.v_INSTANCE_CODE;
1133: ELSE
1134: lv_tbl:= 'MSC_ITEM_CATEGORIES';
1135: END IF;

Line 1195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1191: commit;
1192: EXCEPTION
1193: WHEN OTHERS THEN
1194:
1195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1196: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1197: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1198: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1196: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1197: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1198: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1200:
1201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1202: RAISE;
1203:

Line 1201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1197: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1198: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1200:
1201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1202: RAISE;
1203:
1204: END;
1205: ELSE

Line 1368: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1364: WHEN OTHERS THEN
1365:
1366: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1367:
1368: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1369: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1370: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1371: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1368: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1369: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1370: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1371: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1373:
1374: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1375: RAISE;
1376:

Line 1374: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1370: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1371: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1373:
1374: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1375: RAISE;
1376:
1377: ELSE
1378:

Line 1379: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1375: RAISE;
1376:
1377: ELSE
1378:
1379: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1380:
1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1382: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1383: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');

Line 1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1377: ELSE
1378:
1379: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1380:
1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1382: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1383: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1384: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1382: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1383: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1384: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1386:
1387: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1388: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1389: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_inventory_item_id(J)));

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

1386:
1387: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1388: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1389: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_inventory_item_id(J)));
1390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1391:
1392: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1394: FND_MESSAGE.SET_TOKEN('VALUE',

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

1393: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1394: FND_MESSAGE.SET_TOKEN('VALUE',
1395: MSC_GET_NAME.ORG_CODE( lb_organization_id(j),
1396: MSC_CL_COLLECTION.v_instance_id));
1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1398:
1399: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1400: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_NAME');
1401: FND_MESSAGE.SET_TOKEN('VALUE', lb_category_name(j));

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

1398:
1399: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1400: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_NAME');
1401: FND_MESSAGE.SET_TOKEN('VALUE', lb_category_name(j));
1402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1403:
1404: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1405: END IF;
1406:

Line 1404: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1400: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_NAME');
1401: FND_MESSAGE.SET_TOKEN('VALUE', lb_category_name(j));
1402: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1403:
1404: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1405: END IF;
1406:
1407: END;
1408:

Line 1418: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

1414: COMMIT;
1415:
1416: BEGIN
1417:
1418: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
1419:
1420: lv_tbl:= 'ITEM_CATEGORIES_'||MSC_CL_COLLECTION.v_INSTANCE_CODE;
1421:
1422: lv_sql_stmt:=

Line 1426: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

1422: lv_sql_stmt:=
1423: 'INSERT INTO '||lv_tbl
1424: ||' SELECT * from MSC_ITEM_CATEGORIES'
1425: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1426: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1427:
1428: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
1429: EXECUTE IMMEDIATE lv_sql_stmt;
1430:

Line 1428: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

1424: ||' SELECT * from MSC_ITEM_CATEGORIES'
1425: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1426: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1427:
1428: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
1429: EXECUTE IMMEDIATE lv_sql_stmt;
1430:
1431: COMMIT;
1432:

Line 1435: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

1431: COMMIT;
1432:
1433: END IF;
1434:
1435: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1436: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1437: lv_retcode,
1438: 'MSC_ITEM_CATEGORIES',
1439: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 1440: MSC_UTIL.G_ERROR

1436: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1437: lv_retcode,
1438: 'MSC_ITEM_CATEGORIES',
1439: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1440: MSC_UTIL.G_ERROR
1441: );
1442:
1443: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 1443: IF lv_retcode = MSC_UTIL.G_ERROR THEN

1439: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1440: MSC_UTIL.G_ERROR
1441: );
1442:
1443: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1445: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1446: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1447: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 1444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

1440: MSC_UTIL.G_ERROR
1441: );
1442:
1443: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1445: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1446: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1447: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1448: END IF;

Line 1446: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

1442:
1443: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1445: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1446: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1447: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1448: END IF;
1449:
1450: END IF;

Line 1447: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1443: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1445: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1446: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1447: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1448: END IF;
1449:
1450: END IF;
1451:

Line 1455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1451:
1452: EXCEPTION
1453: WHEN OTHERS THEN
1454:
1455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1456: RAISE;
1457: END;
1458:
1459: END LOAD_CATEGORY;

Line 1520: lv_items_stat_stale NUMBER := MSC_UTIL.SYS_NO;

1516: lv_control_flag NUMBER;
1517:
1518: lv_item_id_count NUMBER := 0;
1519: lv_cat_id_count NUMBER := 0;
1520: lv_items_stat_stale NUMBER := MSC_UTIL.SYS_NO;
1521: lv_cat_stat_stale NUMBER := MSC_UTIL.SYS_NO;
1522: lv_ins_records NUMBER := 0;
1523:
1524: BEGIN

Line 1521: lv_cat_stat_stale NUMBER := MSC_UTIL.SYS_NO;

1517:
1518: lv_item_id_count NUMBER := 0;
1519: lv_cat_id_count NUMBER := 0;
1520: lv_items_stat_stale NUMBER := MSC_UTIL.SYS_NO;
1521: lv_cat_stat_stale NUMBER := MSC_UTIL.SYS_NO;
1522: lv_ins_records NUMBER := 0;
1523:
1524: BEGIN
1525:

Line 1535: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )

1531: INTO lv_control_flag
1532: FROM dual;
1533:
1534: begin
1535: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
1536: into lv_item_id_count, lv_items_stat_stale
1537: from dba_TAB_STATISTICS
1538: where table_name = 'MSC_ITEM_ID_LID';
1539: exception when no_data_found then

Line 1540: lv_items_stat_stale := MSC_UTIL.SYS_YES ;

1536: into lv_item_id_count, lv_items_stat_stale
1537: from dba_TAB_STATISTICS
1538: where table_name = 'MSC_ITEM_ID_LID';
1539: exception when no_data_found then
1540: lv_items_stat_stale := MSC_UTIL.SYS_YES ;
1541: end;
1542:
1543: begin
1544: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )

Line 1544: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )

1540: lv_items_stat_stale := MSC_UTIL.SYS_YES ;
1541: end;
1542:
1543: begin
1544: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
1545: into lv_cat_id_count, lv_cat_stat_stale
1546: from dba_TAB_STATISTICS
1547: where table_name ='MSC_CATEGORY_SET_ID_LID';
1548: exception when no_data_found then

Line 1549: lv_cat_stat_stale := MSC_UTIL.SYS_YES ;

1545: into lv_cat_id_count, lv_cat_stat_stale
1546: from dba_TAB_STATISTICS
1547: where table_name ='MSC_CATEGORY_SET_ID_LID';
1548: exception when no_data_found then
1549: lv_cat_stat_stale := MSC_UTIL.SYS_YES ;
1550: end;
1551:
1552:
1553: /* if complete refresh, regen the key mapping data */

Line 1558: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

1554: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
1555:
1556: IF lv_control_flag = 2 THEN
1557:
1558: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1559: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1560: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1561: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1562: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;

Line 1563: lv_items_stat_stale := MSC_UTIL.SYS_YES;

1559: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1560: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1561: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1562: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1563: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1564: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1565: END IF;
1566:
1567: ELSE

Line 1564: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

1560: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1561: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1562: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1563: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1564: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1565: END IF;
1566:
1567: ELSE
1568:

Line 1569: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

1565: END IF;
1566:
1567: ELSE
1568:
1569: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1570: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1571: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1572: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1573: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

Line 1572: lv_items_stat_stale := MSC_UTIL.SYS_YES;

1568:
1569: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1570: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1571: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1572: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1573: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1574: END IF;
1575:
1576: END IF;

Line 1573: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

1569: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1570: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1571: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1572: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1573: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1574: END IF;
1575:
1576: END IF;
1577:

Line 1584: IF (MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.org_group_flag =MSC_UTIL.G_ALL_ORGANIZATIONS ) THEN

1580: /*************** PREPLACE CHANGE START *****************/
1581:
1582: IF MSC_CL_COLLECTION.v_is_partial_refresh THEN
1583:
1584: IF (MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.org_group_flag =MSC_UTIL.G_ALL_ORGANIZATIONS ) THEN
1585:
1586: IF lv_control_flag = 2 THEN
1587: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1588: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line 1591: lv_items_stat_stale := MSC_UTIL.SYS_YES;

1587: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1588: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1589: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1590: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1591: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1592: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1593: ELSE
1594: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1595: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');

Line 1592: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

1588: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1589: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1590: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1591: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1592: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1593: ELSE
1594: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1595: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1596: lv_items_stat_stale := MSC_UTIL.SYS_YES;

Line 1596: lv_items_stat_stale := MSC_UTIL.SYS_YES;

1592: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1593: ELSE
1594: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1595: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1596: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1597: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1598: END IF;
1599:
1600: END IF;

Line 1597: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

1593: ELSE
1594: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1595: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1596: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1597: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1598: END IF;
1599:
1600: END IF;
1601:

Line 1609: IF (MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES) and

1605:
1606: --agmcont
1607: IF MSC_CL_COLLECTION.v_is_cont_refresh THEN
1608:
1609: IF (MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES) and
1610: (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_TGT) and (MSC_CL_COLLECTION.v_coll_prec.org_group_flag=MSC_UTIL.G_ALL_ORGANIZATIONS) THEN
1611:
1612: IF lv_control_flag = 2 THEN
1613: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line 1610: (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_TGT) and (MSC_CL_COLLECTION.v_coll_prec.org_group_flag=MSC_UTIL.G_ALL_ORGANIZATIONS) THEN

1606: --agmcont
1607: IF MSC_CL_COLLECTION.v_is_cont_refresh THEN
1608:
1609: IF (MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES) and
1610: (MSC_CL_COLLECTION.v_coll_prec.item_sn_flag = MSC_UTIL.SYS_TGT) and (MSC_CL_COLLECTION.v_coll_prec.org_group_flag=MSC_UTIL.G_ALL_ORGANIZATIONS) THEN
1611:
1612: IF lv_control_flag = 2 THEN
1613: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1614: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line 1617: lv_items_stat_stale := MSC_UTIL.SYS_YES;

1613: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1614: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1615: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1616: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1617: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1618: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1619: ELSE
1620: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1621: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');

Line 1618: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

1614: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1615: DELETE MSC_ITEM_ID_LID WHERE SR_INSTANCE_ID= -1;
1616: DELETE MSC_CATEGORY_SET_ID_LID WHERE SR_INSTANCE_ID= -1;
1617: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1618: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1619: ELSE
1620: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1621: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1622: lv_items_stat_stale := MSC_UTIL.SYS_YES;

Line 1622: lv_items_stat_stale := MSC_UTIL.SYS_YES;

1618: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1619: ELSE
1620: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1621: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1622: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1623: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1624: END IF;
1625:
1626: END IF;

Line 1623: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

1619: ELSE
1620: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_ITEM_ID_LID');
1621: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_CATEGORY_SET_ID_LID');
1622: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1623: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1624: END IF;
1625:
1626: END IF;
1627:

Line 1660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1656: NULL;
1657:
1658: WHEN OTHERS THEN
1659:
1660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1661: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1662: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1663: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEMS');
1664: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1661: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1662: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1663: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEMS');
1664: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1665:
1666: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1667: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1668: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ITEM_NAME);

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

1665:
1666: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1667: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1668: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ITEM_NAME);
1669: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1670:
1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1672:
1673: ERRBUF := sqlerrm;

Line 1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1667: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1668: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.ITEM_NAME);
1669: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1670:
1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1672:
1673: ERRBUF := sqlerrm;
1674: RETCODE := MSC_UTIL.G_ERROR;
1675: RAISE;

Line 1674: RETCODE := MSC_UTIL.G_ERROR;

1670:
1671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1672:
1673: ERRBUF := sqlerrm;
1674: RETCODE := MSC_UTIL.G_ERROR;
1675: RAISE;
1676:
1677: END;
1678:

Line 1706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1702: WHEN OTHERS THEN
1703:
1704: IF SQLCODE IN (-1653,-1654) THEN
1705:
1706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1711:
1712: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1713: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1714: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

1711:
1712: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1713: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1714: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1716:
1717: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1718: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1719: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));

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

1716:
1717: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1718: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1719: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));
1720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1721:
1722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1723:
1724: ERRBUF := sqlerrm;

Line 1722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1718: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1719: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));
1720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1721:
1722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1723:
1724: ERRBUF := sqlerrm;
1725: RETCODE := MSC_UTIL.G_ERROR;
1726: RAISE;

Line 1725: RETCODE := MSC_UTIL.G_ERROR;

1721:
1722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1723:
1724: ERRBUF := sqlerrm;
1725: RETCODE := MSC_UTIL.G_ERROR;
1726: RAISE;
1727:
1728: ELSE
1729:

Line 1730: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1726: RAISE;
1727:
1728: ELSE
1729:
1730: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1731:
1732: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1733: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1734: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');

Line 1732: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1728: ELSE
1729:
1730: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1731:
1732: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1733: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1734: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1735: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1732: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1733: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1734: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1735: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_ID_LID');
1736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1737:
1738: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1739: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1740: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

1737:
1738: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1739: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
1740: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1741: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1742:
1743: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1744: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1745: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));

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

1742:
1743: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1744: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1745: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));
1746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1747:
1748: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1749:
1750: ERRBUF := sqlerrm;

Line 1748: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1744: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
1745: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_INVENTORY_ITEM_ID));
1746: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1747:
1748: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1749:
1750: ERRBUF := sqlerrm;
1751: RETCODE := MSC_UTIL.G_WARNING;
1752:

Line 1751: RETCODE := MSC_UTIL.G_WARNING;

1747:
1748: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1749:
1750: ERRBUF := sqlerrm;
1751: RETCODE := MSC_UTIL.G_WARNING;
1752:
1753: END IF;
1754:
1755: END;

Line 1762: IF lv_items_stat_stale = MSC_UTIL.SYS_NO AND lv_ins_records > lv_item_id_count * 0.2 THEN

1758:
1759: COMMIT;
1760:
1761: /* Bug 7653761 - If inserted records are more than 20% */
1762: IF lv_items_stat_stale = MSC_UTIL.SYS_NO AND lv_ins_records > lv_item_id_count * 0.2 THEN
1763: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1764: END IF;
1765:
1766: --========== CATEGORY SET ==========

Line 1763: lv_items_stat_stale := MSC_UTIL.SYS_YES;

1759: COMMIT;
1760:
1761: /* Bug 7653761 - If inserted records are more than 20% */
1762: IF lv_items_stat_stale = MSC_UTIL.SYS_NO AND lv_ins_records > lv_item_id_count * 0.2 THEN
1763: lv_items_stat_stale := MSC_UTIL.SYS_YES;
1764: END IF;
1765:
1766: --========== CATEGORY SET ==========
1767:

Line 1803: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1799: NULL;
1800:
1801: WHEN OTHERS THEN
1802:
1803: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1804: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1805: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1806: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1803: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1804: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1805: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1806: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1808:
1809: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1810: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1811: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);

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

1808:
1809: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1810: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1811: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1812: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1813:
1814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1815:
1816: ERRBUF := sqlerrm;

Line 1814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1810: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1811: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1812: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1813:
1814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1815:
1816: ERRBUF := sqlerrm;
1817: RETCODE := MSC_UTIL.G_ERROR;
1818: RAISE;

Line 1817: RETCODE := MSC_UTIL.G_ERROR;

1813:
1814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1815:
1816: ERRBUF := sqlerrm;
1817: RETCODE := MSC_UTIL.G_ERROR;
1818: RAISE;
1819:
1820: END;
1821:

Line 1848: IF lv_cat_stat_stale = MSC_UTIL.SYS_NO AND lv_ins_records > lv_cat_id_count * 0.2 THEN

1844:
1845: COMMIT;
1846:
1847: /* Bug 7653761 - If inserted records are more than 20%*/
1848: IF lv_cat_stat_stale = MSC_UTIL.SYS_NO AND lv_ins_records > lv_cat_id_count * 0.2 THEN
1849: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1850: END IF;
1851:
1852: /* in order to set default flag, access the lock on the table first*/

Line 1849: lv_cat_stat_stale := MSC_UTIL.SYS_YES;

1845: COMMIT;
1846:
1847: /* Bug 7653761 - If inserted records are more than 20%*/
1848: IF lv_cat_stat_stale = MSC_UTIL.SYS_NO AND lv_ins_records > lv_cat_id_count * 0.2 THEN
1849: lv_cat_stat_stale := MSC_UTIL.SYS_YES;
1850: END IF;
1851:
1852: /* in order to set default flag, access the lock on the table first*/
1853: LOCK TABLE MSC_CATEGORY_SETS IN EXCLUSIVE MODE;

Line 1883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1879: WHEN OTHERS THEN
1880:
1881: IF SQLCODE IN (-1653,-1654) THEN
1882:
1883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1884: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1885: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1886: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1884: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1885: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1886: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1887: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1888:
1889: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1890: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1891: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);

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

1888:
1889: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1890: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1891: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1893:
1894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1895:
1896: ERRBUF := sqlerrm;

Line 1894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1890: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1891: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1893:
1894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1895:
1896: ERRBUF := sqlerrm;
1897: RETCODE := MSC_UTIL.G_ERROR;
1898: RAISE;

Line 1897: RETCODE := MSC_UTIL.G_ERROR;

1893:
1894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1895:
1896: ERRBUF := sqlerrm;
1897: RETCODE := MSC_UTIL.G_ERROR;
1898: RAISE;
1899:
1900: ELSE
1901:

Line 1902: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1898: RAISE;
1899:
1900: ELSE
1901:
1902: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1903:
1904: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1905: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1906: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');

Line 1904: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1900: ELSE
1901:
1902: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1903:
1904: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1905: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1906: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1907: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1904: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1905: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1906: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_ITEM_KEYS');
1907: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CATEGORY_SETS');
1908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1909:
1910: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1911: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1912: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);

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

1909:
1910: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1911: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1912: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1913: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1914:
1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1916:
1917: ERRBUF := sqlerrm;

Line 1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1911: FND_MESSAGE.SET_TOKEN('COLUMN', 'CATEGORY_SET_NAME');
1912: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CATEGORY_SET_NAME);
1913: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1914:
1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1916:
1917: ERRBUF := sqlerrm;
1918: RETCODE := MSC_UTIL.G_WARNING;
1919:

Line 1918: RETCODE := MSC_UTIL.G_WARNING;

1914:
1915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1916:
1917: ERRBUF := sqlerrm;
1918: RETCODE := MSC_UTIL.G_WARNING;
1919:
1920: END IF;
1921:
1922: END;

Line 1938: IF MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES THEN

1934:
1935: COMMIT;
1936:
1937: /* analyse the key mapping tables */
1938: IF MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES THEN
1939: IF lv_items_stat_stale = MSC_UTIL.SYS_YES THEN
1940: msc_analyse_tables_pk.analyse_table( 'MSC_ITEM_ID_LID');
1941: END IF;
1942: IF lv_cat_stat_stale = MSC_UTIL.SYS_YES THEN

Line 1939: IF lv_items_stat_stale = MSC_UTIL.SYS_YES THEN

1935: COMMIT;
1936:
1937: /* analyse the key mapping tables */
1938: IF MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES THEN
1939: IF lv_items_stat_stale = MSC_UTIL.SYS_YES THEN
1940: msc_analyse_tables_pk.analyse_table( 'MSC_ITEM_ID_LID');
1941: END IF;
1942: IF lv_cat_stat_stale = MSC_UTIL.SYS_YES THEN
1943: msc_analyse_tables_pk.analyse_table( 'MSC_CATEGORY_SET_ID_LID');

Line 1942: IF lv_cat_stat_stale = MSC_UTIL.SYS_YES THEN

1938: IF MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES THEN
1939: IF lv_items_stat_stale = MSC_UTIL.SYS_YES THEN
1940: msc_analyse_tables_pk.analyse_table( 'MSC_ITEM_ID_LID');
1941: END IF;
1942: IF lv_cat_stat_stale = MSC_UTIL.SYS_YES THEN
1943: msc_analyse_tables_pk.analyse_table( 'MSC_CATEGORY_SET_ID_LID');
1944: END IF;
1945: END IF;
1946:

Line 1951: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1947: EXCEPTION
1948:
1949: WHEN OTHERS THEN
1950:
1951: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1952:
1953: ERRBUF := sqlerrm;
1954: RETCODE := MSC_UTIL.G_ERROR;
1955: RAISE;

Line 1954: RETCODE := MSC_UTIL.G_ERROR;

1950:
1951: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1952:
1953: ERRBUF := sqlerrm;
1954: RETCODE := MSC_UTIL.G_ERROR;
1955: RAISE;
1956:
1957: END GENERATE_ITEM_KEYS;
1958:

Line 2014: AND nvl(msis.process_flag, -99) <> MSC_UTIL.G_ERROR

2010: AND mtsil.SR_INSTANCE_ID(+)= msis.SR_Instance_ID
2011: AND mtsil.Partner_Type(+)= 1
2012: /* SCE Change starts */
2013: -- Pull only valid records
2014: AND nvl(msis.process_flag, -99) <> MSC_UTIL.G_ERROR
2015: -- Make a join with company_id
2016: -- If company_id is null then it means the record is owned by the Application
2017: -- owner company.
2018: AND nvl(msis.company_id, -1) = nvl(mtil.sr_company_id, -1)

Line 2051: AND mssc.DELETED_FLAG= MSC_UTIL.SYS_NO

2047: AND mtsil.SR_TP_SITE_ID(+)= mssc.Supplier_Site_ID
2048: AND mtsil.SR_INSTANCE_ID(+)= mssc.SR_Instance_ID
2049: AND mtsil.Partner_Type(+)= 1
2050: AND mssc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2051: AND mssc.DELETED_FLAG= MSC_UTIL.SYS_NO
2052: AND NVL(decode( MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag, MSC_UTIL.ASL_YES, 1,
2053: MSC_UTIL.ASL_YES_RETAIN_CP, (select distinct 0
2054: from msc_supplier_capacities msc1
2055: where msc1.SR_INSTANCE_ID = mssc.SR_INSTANCE_ID

Line 2052: AND NVL(decode( MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag, MSC_UTIL.ASL_YES, 1,

2048: AND mtsil.SR_INSTANCE_ID(+)= mssc.SR_Instance_ID
2049: AND mtsil.Partner_Type(+)= 1
2050: AND mssc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2051: AND mssc.DELETED_FLAG= MSC_UTIL.SYS_NO
2052: AND NVL(decode( MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag, MSC_UTIL.ASL_YES, 1,
2053: MSC_UTIL.ASL_YES_RETAIN_CP, (select distinct 0
2054: from msc_supplier_capacities msc1
2055: where msc1.SR_INSTANCE_ID = mssc.SR_INSTANCE_ID
2056: and msc1.ORGANIZATION_ID = mssc.ORGANIZATION_ID

Line 2053: MSC_UTIL.ASL_YES_RETAIN_CP, (select distinct 0

2049: AND mtsil.Partner_Type(+)= 1
2050: AND mssc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2051: AND mssc.DELETED_FLAG= MSC_UTIL.SYS_NO
2052: AND NVL(decode( MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag, MSC_UTIL.ASL_YES, 1,
2053: MSC_UTIL.ASL_YES_RETAIN_CP, (select distinct 0
2054: from msc_supplier_capacities msc1
2055: where msc1.SR_INSTANCE_ID = mssc.SR_INSTANCE_ID
2056: and msc1.ORGANIZATION_ID = mssc.ORGANIZATION_ID
2057: and msc1.INVENTORY_ITEM_ID = t1.INVENTORY_ITEM_ID

Line 2085: AND mssc.DELETED_FLAG= MSC_UTIL.SYS_YES;

2081: AND mtsil.SR_TP_SITE_ID(+)= mssc.Supplier_Site_ID
2082: AND mtsil.SR_INSTANCE_ID(+)= mssc.SR_Instance_ID
2083: AND mtsil.Partner_Type(+)= 1
2084: AND mssc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2085: AND mssc.DELETED_FLAG= MSC_UTIL.SYS_YES;
2086:
2087: CURSOR c5d IS
2088: SELECT mssc.ORGANIZATION_ID,
2089: mssc.USING_ORGANIZATION_ID,

Line 2115: AND decode(MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag , MSC_UTIL.ASL_YES,1,0)= 1;

2111: AND msc1.organization_id = mssc.organization_id
2112: AND msc1.sr_instance_id = mssc.sr_instance_id
2113: AND mssc.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2114: AND msc1.collected_flag = 3
2115: AND decode(MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag , MSC_UTIL.ASL_YES,1,0)= 1;
2116:
2117: CURSOR c3 IS
2118: SELECT
2119: mtil.TP_ID SUPPLIER_ID,

Line 2157: AND nvl(msis.process_flag, -99) <> MSC_UTIL.G_ERROR

2153: AND mtil.PARTNER_TYPE = 1
2154: AND mtsil.SR_TP_SITE_ID (+)= msis.Supplier_Site_ID
2155: AND mtsil.SR_INSTANCE_ID (+)= msis.SR_Instance_ID
2156: AND mtsil.Partner_Type (+)= 1
2157: AND nvl(msis.process_flag, -99) <> MSC_UTIL.G_ERROR
2158: AND nvl(msis.company_id, -1) = nvl (mtil.sr_company_id, -1)
2159: AND nvl(msis.company_id, -1) = nvl (mtsil.sr_company_id, -1)
2160: AND msis.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2161: And msis.deleted_flag=MSC_UTIL.SYS_YES

Line 2161: And msis.deleted_flag=MSC_UTIL.SYS_YES

2157: AND nvl(msis.process_flag, -99) <> MSC_UTIL.G_ERROR
2158: AND nvl(msis.company_id, -1) = nvl (mtil.sr_company_id, -1)
2159: AND nvl(msis.company_id, -1) = nvl (mtsil.sr_company_id, -1)
2160: AND msis.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2161: And msis.deleted_flag=MSC_UTIL.SYS_YES
2162: ;
2163:
2164:
2165: CURSOR c4 IS

Line 2213: AND nvl (msis.process_flag, -99) <> MSC_UTIL.G_ERROR

2209: AND mtil.PARTNER_TYPE = 1
2210: AND mtsil.SR_TP_SITE_ID (+)= msis.Supplier_Site_ID
2211: AND mtsil.SR_INSTANCE_ID (+)= msis.SR_Instance_ID
2212: AND mtsil.Partner_Type (+)= 1
2213: AND nvl (msis.process_flag, -99) <> MSC_UTIL.G_ERROR
2214: AND nvl (msis.company_id, -1) = nvl (mtil.sr_company_id, -1)
2215: AND nvl (msis.company_id, -1) = nvl (mtsil.sr_company_id, -1)
2216: AND nvl (msis.purchasing_unit_of_measure, '-99') = muom.unit_of_measure (+)
2217: AND msis.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 2218: AND msis.deleted_flag=MSC_UTIL.SYS_NO ;

2214: AND nvl (msis.company_id, -1) = nvl (mtil.sr_company_id, -1)
2215: AND nvl (msis.company_id, -1) = nvl (mtsil.sr_company_id, -1)
2216: AND nvl (msis.purchasing_unit_of_measure, '-99') = muom.unit_of_measure (+)
2217: AND msis.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2218: AND msis.deleted_flag=MSC_UTIL.SYS_NO ;
2219:
2220: lv_table_name VARCHAR2(100);
2221: lv_sql_stmt VARCHAR2(5000);
2222: lv_last_asl_collection_date DATE;

Line 2231: IF (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES ) THEN

2227:
2228: BEGIN
2229:
2230: /*ASL */
2231: IF (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES ) THEN
2232: lv_table_name:= 'SYSTEM_ITEMS_' || MSC_CL_COLLECTION.v_INSTANCE_CODE;
2233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in LOAD_SUPPLIER_CAPACITY is ' || lv_table_name);
2234: else
2235: lv_table_name:= 'MSC_SYSTEM_ITEMS';

Line 2233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in LOAD_SUPPLIER_CAPACITY is ' || lv_table_name);

2229:
2230: /*ASL */
2231: IF (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.item_flag = MSC_UTIL.SYS_YES ) THEN
2232: lv_table_name:= 'SYSTEM_ITEMS_' || MSC_CL_COLLECTION.v_INSTANCE_CODE;
2233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in LOAD_SUPPLIER_CAPACITY is ' || lv_table_name);
2234: else
2235: lv_table_name:= 'MSC_SYSTEM_ITEMS';
2236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in LOAD_SUPPLIER_CAPACITY is ' || lv_table_name);
2237: End if;

Line 2236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in LOAD_SUPPLIER_CAPACITY is ' || lv_table_name);

2232: lv_table_name:= 'SYSTEM_ITEMS_' || MSC_CL_COLLECTION.v_INSTANCE_CODE;
2233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in LOAD_SUPPLIER_CAPACITY is ' || lv_table_name);
2234: else
2235: lv_table_name:= 'MSC_SYSTEM_ITEMS';
2236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in LOAD_SUPPLIER_CAPACITY is ' || lv_table_name);
2237: End if;
2238:
2239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name is ' || lv_table_name);
2240:

Line 2239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name is ' || lv_table_name);

2235: lv_table_name:= 'MSC_SYSTEM_ITEMS';
2236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name in LOAD_SUPPLIER_CAPACITY is ' || lv_table_name);
2237: End if;
2238:
2239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' table name is ' || lv_table_name);
2240:
2241: /*ASL */
2242:
2243: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN

Line 2248: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

2244:
2245:
2246: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1, 'AND nvl(COLLECTED_FLAG,1) <> 2');
2247:
2248: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2249: v_sub_str := 'AND nvl(COLLECTED_FLAG,1) <> 2';
2250: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2251: ELSE
2252: v_sub_str := ' AND nvl(COLLECTED_FLAG,1) <> 2'

Line 2253: ||' AND ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

2249: v_sub_str := 'AND nvl(COLLECTED_FLAG,1) <> 2';
2250: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2251: ELSE
2252: v_sub_str := ' AND nvl(COLLECTED_FLAG,1) <> 2'
2253: ||' AND ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2254: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_SUPPLIERS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2255: END IF;
2256:
2257: END IF;

Line 2311: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=

2307: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
2308: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
2309: AND USING_ORGANIZATION_ID= c_rec.USING_ORGANIZATION_ID
2310: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
2311: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
2312: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE);
2313:
2314: END IF;
2315:

Line 2312: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE);

2308: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
2309: AND USING_ORGANIZATION_ID= c_rec.USING_ORGANIZATION_ID
2310: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
2311: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
2312: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE);
2313:
2314: END IF;
2315:
2316: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN

Line 2418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2414: WHEN OTHERS THEN
2415:
2416: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2417:
2418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2419: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2420: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2421: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2419: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2420: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2421: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
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: RAISE;
2426:

Line 2424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2420: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2421: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
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: RAISE;
2426:
2427: ELSE
2428: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 2428: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

2424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2425: RAISE;
2426:
2427: ELSE
2428: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2429:
2430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2431: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2432: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

Line 2430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2426:
2427: ELSE
2428: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2429:
2430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2431: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2432: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2433: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2431: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2432: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2433: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2435:
2436: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2437: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2438: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

2435:
2436: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2437: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2438: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
2439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2440:
2441: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2442: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2443: FND_MESSAGE.SET_TOKEN('VALUE',

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

2442: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2443: FND_MESSAGE.SET_TOKEN('VALUE',
2444: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
2445: MSC_CL_COLLECTION.v_instance_id));
2446: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2447:
2448: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2449: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2450: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));

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

2447:
2448: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2449: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2450: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
2451: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2452:
2453: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2454: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2455: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));

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

2452:
2453: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2454: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2455: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
2456: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2457:
2458: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2459: END IF;
2460:

Line 2458: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2454: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2455: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
2456: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2457:
2458: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2459: END IF;
2460:
2461: END;
2462:

Line 2471: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'INCREMENTAL ASL CODE START ');

2467:
2468: /* ASL */
2469: IF (MSC_CL_COLLECTION.v_is_incremental_refresh and not MSC_CL_COLLECTION.v_is_legacy_refresh) THEN
2470:
2471: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'INCREMENTAL ASL CODE START ');
2472: /*NOT REQUIRED
2473: IF (MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag=MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.item_flag=MSC_UTIL.SYS_YES AND NOT MSC_CL_COLLECTION.v_is_legacy_refresh) THEN
2474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ADD_NEW_IMPL_ITEM_ASL PROCEDURE BEING CALLED FROM LOAD_SUPPLIER_CAPACITY PROCEDURE ');
2475: ADD_NEW_IMPL_ITEM_ASL;

Line 2473: IF (MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag=MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.item_flag=MSC_UTIL.SYS_YES AND NOT MSC_CL_COLLECTION.v_is_legacy_refresh) THEN

2469: IF (MSC_CL_COLLECTION.v_is_incremental_refresh and not MSC_CL_COLLECTION.v_is_legacy_refresh) THEN
2470:
2471: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'INCREMENTAL ASL CODE START ');
2472: /*NOT REQUIRED
2473: IF (MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag=MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.item_flag=MSC_UTIL.SYS_YES AND NOT MSC_CL_COLLECTION.v_is_legacy_refresh) THEN
2474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ADD_NEW_IMPL_ITEM_ASL PROCEDURE BEING CALLED FROM LOAD_SUPPLIER_CAPACITY PROCEDURE ');
2475: ADD_NEW_IMPL_ITEM_ASL;
2476: END IF ;
2477: */

Line 2474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ADD_NEW_IMPL_ITEM_ASL PROCEDURE BEING CALLED FROM LOAD_SUPPLIER_CAPACITY PROCEDURE ');

2470:
2471: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'INCREMENTAL ASL CODE START ');
2472: /*NOT REQUIRED
2473: IF (MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag=MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.item_flag=MSC_UTIL.SYS_YES AND NOT MSC_CL_COLLECTION.v_is_legacy_refresh) THEN
2474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ADD_NEW_IMPL_ITEM_ASL PROCEDURE BEING CALLED FROM LOAD_SUPPLIER_CAPACITY PROCEDURE ');
2475: ADD_NEW_IMPL_ITEM_ASL;
2476: END IF ;
2477: */
2478:

Line 2482: ||' And organization_id '|| MSC_UTIL.v_in_org_str;

2478:
2479: lv_sql_stmt := 'Select min (nvl(LAST_SUCC_ASL_REF_TIME,SYSDATE-365000))'
2480: ||' From msc_instance_orgs '
2481: ||' Where sr_instance_id = ' || MSC_CL_COLLECTION.v_instance_id
2482: ||' And organization_id '|| MSC_UTIL.v_in_org_str;
2483:
2484: EXECUTE IMMEDIATE lv_sql_stmt into lv_last_asl_collection_date;
2485: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'last successful ASL Collection refresh time is '||lv_last_asl_collection_date);
2486: c_count:= 0;

Line 2485: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'last successful ASL Collection refresh time is '||lv_last_asl_collection_date);

2481: ||' Where sr_instance_id = ' || MSC_CL_COLLECTION.v_instance_id
2482: ||' And organization_id '|| MSC_UTIL.v_in_org_str;
2483:
2484: EXECUTE IMMEDIATE lv_sql_stmt into lv_last_asl_collection_date;
2485: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'last successful ASL Collection refresh time is '||lv_last_asl_collection_date);
2486: c_count:= 0;
2487: FOR del_rec in del_asl LOOP
2488: BEGIN
2489: lv_sql_stmt:= 'Delete MSC_ITEM_SUPPLIERS mis'

Line 2496: ||' AND mis.ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str;

2492: ||' AND mis.SUPPLIER_ID = ' || del_rec.SUPPLIER_ID
2493: ||' AND nvl(mis.SUPPLIER_SITE_ID, -1) = nvl( :SUPPLIER_SITE_ID , -1)'
2494: ||' AND mis.sr_instance_id = ' || MSC_CL_COLLECTION.v_instance_id
2495: ||' AND mis.plan_id = -1 '
2496: ||' AND mis.ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str;
2497:
2498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'delete query is ' || lv_sql_stmt);
2499:
2500: EXECUTE IMMEDIATE lv_sql_stmt using del_rec.SUPPLIER_SITE_ID;

Line 2498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'delete query is ' || lv_sql_stmt);

2494: ||' AND mis.sr_instance_id = ' || MSC_CL_COLLECTION.v_instance_id
2495: ||' AND mis.plan_id = -1 '
2496: ||' AND mis.ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str;
2497:
2498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'delete query is ' || lv_sql_stmt);
2499:
2500: EXECUTE IMMEDIATE lv_sql_stmt using del_rec.SUPPLIER_SITE_ID;
2501:
2502: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'the number of rows deleted '|| SQL%ROWCOUNT);

Line 2502: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'the number of rows deleted '|| SQL%ROWCOUNT);

2498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'delete query is ' || lv_sql_stmt);
2499:
2500: EXECUTE IMMEDIATE lv_sql_stmt using del_rec.SUPPLIER_SITE_ID;
2501:
2502: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'the number of rows deleted '|| SQL%ROWCOUNT);
2503: EXCEPTION
2504: WHEN OTHERS THEN
2505:
2506: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN

Line 2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2504: WHEN OTHERS THEN
2505:
2506: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2507:
2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2509: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2510: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2511: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2509: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2510: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2511: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2513:
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2515: RAISE;
2516:

Line 2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2510: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2511: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2513:
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2515: RAISE;
2516:
2517: ELSE
2518: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 2518: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2515: RAISE;
2516:
2517: ELSE
2518: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2519:
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2521: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2522: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

Line 2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2516:
2517: ELSE
2518: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2519:
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2521: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2522: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2523: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2521: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2522: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2523: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2525:
2526: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2527: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2528: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( del_rec.INVENTORY_ITEM_ID));

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

2525:
2526: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2527: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
2528: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( del_rec.INVENTORY_ITEM_ID));
2529: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2530:
2531: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2532: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2533: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_ID));

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

2530:
2531: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2532: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
2533: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_ID));
2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2535:
2536: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2537: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2538: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_SITE_ID));

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

2535:
2536: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2537: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2538: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_SITE_ID));
2539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2540:
2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2542: END IF ;
2543: END ;

Line 2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2537: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
2538: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(del_rec.SUPPLIER_SITE_ID));
2539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2540:
2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2542: END IF ;
2543: END ;
2544:
2545: END LOOP;

Line 2546: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'number of row deleted ' || c_count);

2542: END IF ;
2543: END ;
2544:
2545: END LOOP;
2546: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'number of row deleted ' || c_count);
2547: COMMIT;
2548:
2549: /*Insert Logic */
2550: FOR c_rec in c4 LOOP

Line 2590: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=

2586: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
2587: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
2588: AND USING_ORGANIZATION_ID= c_rec.USING_ORGANIZATION_ID
2589: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
2590: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
2591: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE);
2592:
2593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROW UPDATED ' || SQL%ROWCOUNT);
2594:

Line 2591: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE);

2587: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
2588: AND USING_ORGANIZATION_ID= c_rec.USING_ORGANIZATION_ID
2589: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
2590: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
2591: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE);
2592:
2593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROW UPDATED ' || SQL%ROWCOUNT);
2594:
2595: IF SQL%NOTFOUND THEN

Line 2593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROW UPDATED ' || SQL%ROWCOUNT);

2589: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
2590: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
2591: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE);
2592:
2593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROW UPDATED ' || SQL%ROWCOUNT);
2594:
2595: IF SQL%NOTFOUND THEN
2596: IF c_rec.using_organization_id =-1 THEN
2597: lv_sql_stmt:= 'INSERT INTO MSC_ITEM_SUPPLIERS'

Line 2676: ||' and msi.organization_id ' || MSC_UTIL.v_in_org_str

2672: ||' :v_current_user '
2673: ||' FROM '
2674: || lv_table_name ||' msi '
2675: ||' WHERE msi.inventory_item_id = '|| c_rec.INVENTORY_ITEM_ID
2676: ||' and msi.organization_id ' || MSC_UTIL.v_in_org_str
2677: ||' and msi.sr_instance_id = '|| MSC_CL_COLLECTION.v_instance_id
2678: ||' and msi.plan_id =-1 ' ;
2679:
2680: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'the insert statement is ' || lv_sql_stmt );

Line 2680: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'the insert statement is ' || lv_sql_stmt );

2676: ||' and msi.organization_id ' || MSC_UTIL.v_in_org_str
2677: ||' and msi.sr_instance_id = '|| MSC_CL_COLLECTION.v_instance_id
2678: ||' and msi.plan_id =-1 ' ;
2679:
2680: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'the insert statement is ' || lv_sql_stmt );
2681:
2682: execute immediate lv_sql_stmt using c_rec.USING_ORGANIZATION_ID,
2683: c_rec.SUPPLIER_ID,
2684: c_rec.SUPPLIER_SITE_ID,

Line 2715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROW INSERTED WITH USING ORG -1 ' || SQL%ROWCOUNT);

2711: c_rec.FORECAST_HORIZON,
2712: c_rec.FIXED_ORDER_QUANTITY,
2713: MSC_CL_COLLECTION.v_current_user ;
2714:
2715: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROW INSERTED WITH USING ORG -1 ' || SQL%ROWCOUNT);
2716:
2717: ELSE
2718: INSERT INTO MSC_ITEM_SUPPLIERS
2719: ( PLAN_ID,

Line 2799: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROW INSERTED WITH USING org id not -1 ' || SQL%ROWCOUNT);

2795: c_rec.FIXED_ORDER_QUANTITY,
2796: 1,
2797: MSC_CL_COLLECTION.v_current_user );
2798:
2799: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROW INSERTED WITH USING org id not -1 ' || SQL%ROWCOUNT);
2800:
2801: END IF ;
2802: END IF ;
2803:

Line 2804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the item id ' || c_rec.INVENTORY_ITEM_ID);

2800:
2801: END IF ;
2802: END IF ;
2803:
2804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the item id ' || c_rec.INVENTORY_ITEM_ID);
2805: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the using organization_id is ' || c_rec.USING_ORGANIZATION_ID);
2806: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the supplier id is ' || c_rec.SUPPLIER_ID);
2807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the supplier site id is ' || c_rec.SUPPLIER_SITE_ID);
2808:

Line 2805: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the using organization_id is ' || c_rec.USING_ORGANIZATION_ID);

2801: END IF ;
2802: END IF ;
2803:
2804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the item id ' || c_rec.INVENTORY_ITEM_ID);
2805: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the using organization_id is ' || c_rec.USING_ORGANIZATION_ID);
2806: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the supplier id is ' || c_rec.SUPPLIER_ID);
2807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the supplier site id is ' || c_rec.SUPPLIER_SITE_ID);
2808:
2809: EXCEPTION

Line 2806: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the supplier id is ' || c_rec.SUPPLIER_ID);

2802: END IF ;
2803:
2804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the item id ' || c_rec.INVENTORY_ITEM_ID);
2805: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the using organization_id is ' || c_rec.USING_ORGANIZATION_ID);
2806: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the supplier id is ' || c_rec.SUPPLIER_ID);
2807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the supplier site id is ' || c_rec.SUPPLIER_SITE_ID);
2808:
2809: EXCEPTION
2810: WHEN OTHERS THEN

Line 2807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the supplier site id is ' || c_rec.SUPPLIER_SITE_ID);

2803:
2804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the item id ' || c_rec.INVENTORY_ITEM_ID);
2805: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the using organization_id is ' || c_rec.USING_ORGANIZATION_ID);
2806: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the supplier id is ' || c_rec.SUPPLIER_ID);
2807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' the supplier site id is ' || c_rec.SUPPLIER_SITE_ID);
2808:
2809: EXCEPTION
2810: WHEN OTHERS THEN
2811:

Line 2814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2810: WHEN OTHERS THEN
2811:
2812: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2813:
2814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2815: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2816: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2817: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

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

Line 2820: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2816: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2817: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2819:
2820: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2821: RAISE;
2822:
2823: ELSE
2824:

Line 2825: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

2821: RAISE;
2822:
2823: ELSE
2824:
2825: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2826:
2827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2828: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

Line 2827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2823: ELSE
2824:
2825: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2826:
2827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2828: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2828: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2832:
2833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2834: END IF;-- exception end
2835: END ; -- begin end

Line 2833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2829: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2830: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_SUPPLIERS');
2831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2832:
2833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2834: END IF;-- exception end
2835: END ; -- begin end
2836: END LOOP; -- loop insert or update
2837: COMMIT ;

Line 2843: IF MSC_CL_COLLECTION.v_apps_ver <> MSC_UTIL.G_APPS107 AND

2839: END IF ; -- v_is_incremental
2840:
2841: /*ASL */
2842:
2843: IF MSC_CL_COLLECTION.v_apps_ver <> MSC_UTIL.G_APPS107 AND
2844: MSC_CL_COLLECTION.v_apps_ver <> MSC_UTIL.G_APPS110 THEN
2845:
2846: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2847:

Line 2844: MSC_CL_COLLECTION.v_apps_ver <> MSC_UTIL.G_APPS110 THEN

2840:
2841: /*ASL */
2842:
2843: IF MSC_CL_COLLECTION.v_apps_ver <> MSC_UTIL.G_APPS107 AND
2844: MSC_CL_COLLECTION.v_apps_ver <> MSC_UTIL.G_APPS110 THEN
2845:
2846: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2847:
2848: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1);

Line 2850: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

2846: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2847:
2848: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1);
2849:
2850: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2851: if MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag= MSC_UTIL.ASL_YES_RETAIN_CP THEN
2852: v_sub_str :=' AND COLLECTED_FLAG <> 3';
2853: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2854: else

Line 2851: if MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag= MSC_UTIL.ASL_YES_RETAIN_CP THEN

2847:
2848: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1);
2849:
2850: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2851: if MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag= MSC_UTIL.ASL_YES_RETAIN_CP THEN
2852: v_sub_str :=' AND COLLECTED_FLAG <> 3';
2853: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2854: else
2855: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1);

Line 2858: if MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag= MSC_UTIL.ASL_YES_RETAIN_CP THEN

2854: else
2855: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1);
2856: end if ;
2857: ELSE
2858: if MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag= MSC_UTIL.ASL_YES_RETAIN_CP THEN
2859: v_sub_str :=' AND COLLECTED_FLAG <> 3 AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2860: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2861: else
2862: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 2859: v_sub_str :=' AND COLLECTED_FLAG <> 3 AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

2855: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1);
2856: end if ;
2857: ELSE
2858: if MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag= MSC_UTIL.ASL_YES_RETAIN_CP THEN
2859: v_sub_str :=' AND COLLECTED_FLAG <> 3 AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2860: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2861: else
2862: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2863: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 2862: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

2858: if MSC_CL_COLLECTION.v_coll_prec.app_supp_cap_flag= MSC_UTIL.ASL_YES_RETAIN_CP THEN
2859: v_sub_str :=' AND COLLECTED_FLAG <> 3 AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2860: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2861: else
2862: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2863: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_CAPACITIES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
2864: end if ;
2865: END IF;
2866:

Line 2887: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=

2883: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
2884: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
2885: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
2886: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
2887: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
2888: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)
2889: AND FROM_DATE= c_rec.FROM_DATE
2890: AND COLLECTED_FLAG=1;
2891:

Line 2888: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)

2884: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
2885: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
2886: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
2887: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
2888: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)
2889: AND FROM_DATE= c_rec.FROM_DATE
2890: AND COLLECTED_FLAG=1;
2891:
2892: END LOOP;

Line 2902: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=

2898: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
2899: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
2900: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
2901: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
2902: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
2903: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)
2904: AND COLLECTED_FLAG=3;
2905:
2906: END LOOP;

Line 2903: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)

2899: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
2900: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
2901: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
2902: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
2903: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)
2904: AND COLLECTED_FLAG=3;
2905:
2906: END LOOP;
2907:

Line 2934: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=

2930: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
2931: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
2932: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
2933: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
2934: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
2935: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)
2936: AND FROM_DATE= c_rec.FROM_DATE
2937: AND COLLECTED_FLAG=1;
2938:

Line 2935: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)

2931: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
2932: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
2933: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
2934: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
2935: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)
2936: AND FROM_DATE= c_rec.FROM_DATE
2937: AND COLLECTED_FLAG=1;
2938:
2939: END IF;

Line 2995: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2991: WHEN OTHERS THEN
2992:
2993: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2994:
2995: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2996: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2997: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2998: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
2999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2995: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2996: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2997: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2998: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
2999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3000:
3001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3002: RAISE;
3003:

Line 3001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2997: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
2998: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
2999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3000:
3001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3002: RAISE;
3003:
3004: ELSE
3005: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 3005: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

3001: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3002: RAISE;
3003:
3004: ELSE
3005: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3006:
3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

Line 3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

3003:
3004: ELSE
3005: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3006:
3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
3011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3007: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3008: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3009: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3010: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_CAPACITIES');
3011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3012:
3013: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3014: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3015: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

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

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

3019: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3020: FND_MESSAGE.SET_TOKEN('VALUE',
3021: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3022: MSC_CL_COLLECTION.v_instance_id));
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3024:
3025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3026: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3027: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));

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

3024:
3025: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3026: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3027: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
3028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3029:
3030: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3031: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3032: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));

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

3029:
3030: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3031: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3032: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3034:
3035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3036: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_DATE');
3037: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_DATE));

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

3034:
3035: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3036: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_DATE');
3037: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_DATE));
3038: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3039:
3040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3041: END IF;
3042:

Line 3040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

3036: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_DATE');
3037: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FROM_DATE));
3038: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3039:
3040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3041: END IF;
3042:
3043: END;
3044:

Line 3053: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

3049: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
3050:
3051: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1);
3052:
3053: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3054: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1);
3055: ELSE
3056: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3057: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 3056: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

3052:
3053: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3054: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1);
3055: ELSE
3056: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3057: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
3058: END IF;
3059:
3060: END IF;

Line 3082: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=

3078: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
3079: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
3080: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
3081: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
3082: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
3083: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)
3084: AND FENCE_DAYS= c_rec.FENCE_DAYS;
3085:
3086: END IF;

Line 3083: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)

3079: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
3080: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
3081: AND SUPPLIER_ID= c_rec.SUPPLIER_ID
3082: AND NVL(SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)=
3083: NVL(c_rec.SUPPLIER_SITE_ID,MSC_UTIL.NULL_VALUE)
3084: AND FENCE_DAYS= c_rec.FENCE_DAYS;
3085:
3086: END IF;
3087:

Line 3138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

3134: WHEN OTHERS THEN
3135:
3136: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3137:
3138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3139: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3140: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3141: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3142: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3139: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3140: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3141: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3142: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3143:
3144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3145: RAISE;
3146:

Line 3144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

3140: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3141: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3142: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3143:
3144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3145: RAISE;
3146:
3147: ELSE
3148: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 3148: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

3144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3145: RAISE;
3146:
3147: ELSE
3148: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3149:
3150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3151: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3152: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');

Line 3150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

3146:
3147: ELSE
3148: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3149:
3150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3151: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3152: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3153: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3151: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3152: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3153: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3155:
3156: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3157: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3158: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

3155:
3156: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3157: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3158: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3160:
3161: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3162: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3163: FND_MESSAGE.SET_TOKEN('VALUE',

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

3162: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3163: FND_MESSAGE.SET_TOKEN('VALUE',
3164: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3165: MSC_CL_COLLECTION.v_instance_id));
3166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3167:
3168: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3169: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3170: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));

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

3167:
3168: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3169: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_ID');
3170: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_ID));
3171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3172:
3173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));

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

3172:
3173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SUPPLIER_SITE_ID');
3175: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SUPPLIER_SITE_ID));
3176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3177:
3178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3179: FND_MESSAGE.SET_TOKEN('COLUMN', 'FENCE_DAYS');
3180: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FENCE_DAYS));

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

3177:
3178: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3179: FND_MESSAGE.SET_TOKEN('COLUMN', 'FENCE_DAYS');
3180: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FENCE_DAYS));
3181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3182:
3183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3184: END IF;
3185:

Line 3183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

3179: FND_MESSAGE.SET_TOKEN('COLUMN', 'FENCE_DAYS');
3180: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.FENCE_DAYS));
3181: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3182:
3183: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3184: END IF;
3185:
3186: END;
3187:

Line 3376: lv_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), MSC_UTIL.G_CONF_APS);

3372: lv_sql_stmt VARCHAR2(7500);
3373: lv_sql_ins vARCHAR2(8000);
3374: lb_FetchComplete Boolean;
3375: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
3376: lv_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), MSC_UTIL.G_CONF_APS);
3377:
3378: TYPE CharTblTyp IS TABLE OF VARCHAR2(270);
3379: TYPE NumTblTyp IS TABLE OF NUMBER;
3380: TYPE dateTblTyp IS TABLE OF DATE;

Line 3518: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

3514: lv_retcode NUMBER;
3515:
3516: BEGIN
3517:
3518: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
3519: lv_tbl:= 'SYSTEM_ITEMS_'||MSC_CL_COLLECTION.v_INSTANCE_CODE;
3520: ELSE
3521: lv_tbl:= 'MSC_SYSTEM_ITEMS';
3522: END IF;

Line 3801: MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN

3797: ||' :PEGGING_DEMAND_WINDOW_DAYS,'
3798: ||' :PEGGING_SUPPLY_WINDOW_DAYS )';
3799:
3800: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) AND
3801: MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
3802:
3803: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3804: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1);
3805: ELSE

Line 3803: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

3799:
3800: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) AND
3801: MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
3802:
3803: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3804: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1);
3805: ELSE
3806: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3807: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 3806: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

3802:
3803: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3804: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1);
3805: ELSE
3806: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3807: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SYSTEM_ITEMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
3808: END IF;
3809: END IF;
3810:

Line 4111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

4107: commit;
4108: EXCEPTION
4109: WHEN OTHERS THEN
4110:
4111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

4111: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4112: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4116:
4117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4118: RAISE;
4119:

Line 4117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

4113: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4114: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4115: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4116:
4117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4118: RAISE;
4119:
4120: END;
4121: END IF;

Line 4124: lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR

4120: END;
4121: END IF;
4122:
4123: IF (MSC_CL_COLLECTION.v_is_incremental_refresh OR
4124: lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
4125: lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
4126: c_count :=0;
4127:
4128: OPEN c1;

Line 4125: lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN

4121: END IF;
4122:
4123: IF (MSC_CL_COLLECTION.v_is_incremental_refresh OR
4124: lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
4125: lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
4126: c_count :=0;
4127:
4128: OPEN c1;
4129: IF (c1%ISOPEN) THEN

Line 4571: IF ( lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR

4567: lb_PEGGING_SUPPLY_WINDOW_DAYS(j);
4568:
4569: END IF;
4570: END IF;
4571: IF ( lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
4572: lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
4573: UPDATE MSC_ITEMS
4574: SET description= lb_DESCRIPTION(j)
4575: WHERE inventory_item_id = lb_INVENTORY_ITEM_ID(j);

Line 4572: lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN

4568:
4569: END IF;
4570: END IF;
4571: IF ( lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
4572: lv_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
4573: UPDATE MSC_ITEMS
4574: SET description= lb_DESCRIPTION(j)
4575: WHERE inventory_item_id = lb_INVENTORY_ITEM_ID(j);
4576: END IF;

Line 4591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

4587: EXCEPTION
4588: WHEN OTHERS THEN
4589: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
4590:
4591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4592: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4593: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4594: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

4591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4592: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4593: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4594: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4596:
4597: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4598: RAISE;
4599:

Line 4597: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

4593: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4594: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4596:
4597: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4598: RAISE;
4599:
4600: ELSE
4601:

Line 4602: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

4598: RAISE;
4599:
4600: ELSE
4601:
4602: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4603:
4604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4605: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');

Line 4604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

4600: ELSE
4601:
4602: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4603:
4604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4605: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

4604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4605: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4606: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM');
4607: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SYSTEM_ITEMS');
4608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4609:
4610: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4611: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
4612: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_INVENTORY_ITEM_ID(j)));

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

4609:
4610: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4611: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
4612: FND_MESSAGE.SET_TOKEN('VALUE', ITEM_NAME( lb_INVENTORY_ITEM_ID(j)));
4613: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4614:
4615: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4616: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
4617: FND_MESSAGE.SET_TOKEN('VALUE',

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

4616: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
4617: FND_MESSAGE.SET_TOKEN('VALUE',
4618: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
4619: MSC_CL_COLLECTION.v_instance_id));
4620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4621:
4622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4623: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
4624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_SR_INVENTORY_ITEM_ID(j)));

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

4621:
4622: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4623: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
4624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_SR_INVENTORY_ITEM_ID(j)));
4625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4626:
4627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4628: END IF;
4629:

Line 4627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

4623: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_INVENTORY_ITEM_ID');
4624: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_SR_INVENTORY_ITEM_ID(j)));
4625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4626:
4627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4628: END IF;
4629:
4630: END;
4631: END LOOP;

Line 4641: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

4637: END IF;
4638:
4639: BEGIN
4640:
4641: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
4642:
4643: lv_tbl:= 'SYSTEM_ITEMS_'||MSC_CL_COLLECTION.v_INSTANCE_CODE;
4644:
4645: lv_sql_stmt:=

Line 4650: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

4646: 'INSERT INTO '||lv_tbl
4647: ||' SELECT * from MSC_SYSTEM_ITEMS'
4648: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
4649: ||' AND plan_id = -1 '
4650: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
4651:
4652: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
4653: EXECUTE IMMEDIATE lv_sql_stmt;
4654:

Line 4652: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

4648: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
4649: ||' AND plan_id = -1 '
4650: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
4651:
4652: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
4653: EXECUTE IMMEDIATE lv_sql_stmt;
4654:
4655: COMMIT;
4656:

Line 4659: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

4655: COMMIT;
4656:
4657: END IF;
4658:
4659: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
4660: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
4661: lv_retcode,
4662: 'MSC_SYSTEM_ITEMS',
4663: MSC_CL_COLLECTION.v_INSTANCE_CODE,

Line 4664: MSC_UTIL.G_ERROR

4660: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
4661: lv_retcode,
4662: 'MSC_SYSTEM_ITEMS',
4663: MSC_CL_COLLECTION.v_INSTANCE_CODE,
4664: MSC_UTIL.G_ERROR
4665: );
4666:
4667: IF lv_retcode = MSC_UTIL.G_ERROR THEN
4668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 4667: IF lv_retcode = MSC_UTIL.G_ERROR THEN

4663: MSC_CL_COLLECTION.v_INSTANCE_CODE,
4664: MSC_UTIL.G_ERROR
4665: );
4666:
4667: IF lv_retcode = MSC_UTIL.G_ERROR THEN
4668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
4669: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
4670: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
4671: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 4668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

4664: MSC_UTIL.G_ERROR
4665: );
4666:
4667: IF lv_retcode = MSC_UTIL.G_ERROR THEN
4668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
4669: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
4670: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
4671: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4672: END IF;

Line 4670: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

4666:
4667: IF lv_retcode = MSC_UTIL.G_ERROR THEN
4668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
4669: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
4670: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
4671: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4672: END IF;
4673:
4674: END IF;

Line 4671: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

4667: IF lv_retcode = MSC_UTIL.G_ERROR THEN
4668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
4669: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
4670: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
4671: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4672: END IF;
4673:
4674: END IF;
4675:

Line 4678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ADD_NEW_IMPL_ITEM_ASL PROCEDURE BEING CALLED FROM ITEM PROCEDURE ');

4674: END IF;
4675:
4676: /*call to insert ASL */
4677: IF ( NOT MSC_CL_COLLECTION.v_is_legacy_refresh) THEN
4678: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ADD_NEW_IMPL_ITEM_ASL PROCEDURE BEING CALLED FROM ITEM PROCEDURE ');
4679: ADD_NEW_IMPL_ITEM_ASL;
4680: END IF ;
4681:
4682: EXCEPTION

Line 4685: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

4681:
4682: EXCEPTION
4683: WHEN OTHERS THEN
4684:
4685: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4686: RAISE;
4687: END;
4688: COMMIT;
4689: