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_DEMAND_ODS_LOAD dependencies on MSC_UTIL

Line 40: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');

36: and ( source_org_instance_id is Null or source_org_instance_id = MSC_CL_COLLECTION.v_instance_id );
37:
38: BEGIN
39:
40: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
41: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Starting LINK_SUPP_SO_DEMAND_EXT ......');
42: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
43:
44: For c_rec in link_supply_demand

Line 41: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Starting LINK_SUPP_SO_DEMAND_EXT ......');

37:
38: BEGIN
39:
40: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
41: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Starting LINK_SUPP_SO_DEMAND_EXT ......');
42: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
43:
44: For c_rec in link_supply_demand
45: loop

Line 42: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');

38: BEGIN
39:
40: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
41: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Starting LINK_SUPP_SO_DEMAND_EXT ......');
42: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
43:
44: For c_rec in link_supply_demand
45: loop
46: BEGIN

Line 52: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');

48: lv_source_organization_id := NULL;
49: lv_source_sr_instance_id := NULL;
50: lv_11i_src_exists :=0;
51:
52: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
53: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'CUST_PO_NUMBER: '|| c_rec.CUST_PO_NUMBER);
54: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'CUSTOMER_LINE_NUMBER: '|| c_rec.CUSTOMER_LINE_NUMBER);
55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);
56:

Line 53: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'CUST_PO_NUMBER: '|| c_rec.CUST_PO_NUMBER);

49: lv_source_sr_instance_id := NULL;
50: lv_11i_src_exists :=0;
51:
52: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
53: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'CUST_PO_NUMBER: '|| c_rec.CUST_PO_NUMBER);
54: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'CUSTOMER_LINE_NUMBER: '|| c_rec.CUSTOMER_LINE_NUMBER);
55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);
56:
57: lv_supply_stmt :=

Line 54: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'CUSTOMER_LINE_NUMBER: '|| c_rec.CUSTOMER_LINE_NUMBER);

50: lv_11i_src_exists :=0;
51:
52: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
53: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'CUST_PO_NUMBER: '|| c_rec.CUST_PO_NUMBER);
54: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'CUSTOMER_LINE_NUMBER: '|| c_rec.CUSTOMER_LINE_NUMBER);
55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);
56:
57: lv_supply_stmt :=
58: 'SELECT /*+ index(a,MSC_SUPPLIES_N5)*/ TRANSACTION_ID ,ORGANIZATION_ID, SR_INSTANCE_ID '

Line 55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);

51:
52: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
53: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'CUST_PO_NUMBER: '|| c_rec.CUST_PO_NUMBER);
54: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'CUSTOMER_LINE_NUMBER: '|| c_rec.CUSTOMER_LINE_NUMBER);
55: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);
56:
57: lv_supply_stmt :=
58: 'SELECT /*+ index(a,MSC_SUPPLIES_N5)*/ TRANSACTION_ID ,ORGANIZATION_ID, SR_INSTANCE_ID '
59: ||' FROM MSC_SUPPLIES a '

Line 90: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'New Supply Id is: '||lv_supply_id);

86: where rowid = c_rec.rowid;
87: */
88: -- Moved this Update down so that 11i source is satisfied as well
89: -- bug 10421334
90: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'New Supply Id is: '||lv_supply_id);
91:
92: EXCEPTION WHEN NO_DATA_FOUND THEN
93: begin
94: if lv_11i_src_exists = 0 then

Line 103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'No link for External Sales Order:'||c_rec.sales_order_number||'inst='||to_char(MSC_CL_COLLECTION.v_instance_id) );

99: and rownum=1;
100: end if;
101: exception
102: when no_data_found then
103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'No link for External Sales Order:'||c_rec.sales_order_number||'inst='||to_char(MSC_CL_COLLECTION.v_instance_id) );
104: lv_11i_src_exists :=2; -- No need to check for 11i src again and again
105: end;
106: begin
107: if lv_11i_src_exists = 1 then

Line 108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Trying to find in 11i instance:'||c_rec.sales_order_number||'inst='||to_char(MSC_CL_COLLECTION.v_instance_id) );

104: lv_11i_src_exists :=2; -- No need to check for 11i src again and again
105: end;
106: begin
107: if lv_11i_src_exists = 1 then
108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Trying to find in 11i instance:'||c_rec.sales_order_number||'inst='||to_char(MSC_CL_COLLECTION.v_instance_id) );
109: EXECUTE IMMEDIATE lv_supply_stmt
110: INTO lv_supply_id, lv_source_organization_id, lv_source_sr_instance_id
111: USING c_rec.CUST_PO_NUMBER||'(1)', c_rec.CUSTOMER_LINE_NUMBER,c_rec.INVENTORY_ITEM_ID,c_rec.CUST_PO_NUMBER||'(2)', c_rec.CUSTOMER_LINE_NUMBER,c_rec.INVENTORY_ITEM_ID;
112:

Line 121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'No link for External Sales Order:'||c_rec.sales_order_number||'inst='||to_char(MSC_CL_COLLECTION.v_instance_id) );

117: where rowid = c_rec.rowid; */
118: end if;
119: exception
120: when no_data_found then
121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'No link for External Sales Order:'||c_rec.sales_order_number||'inst='||to_char(MSC_CL_COLLECTION.v_instance_id) );
122: end;
123: WHEN OTHERS THEN
124: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Error Message is: '||SQLERRM);
125: NULL;

Line 124: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Error Message is: '||SQLERRM);

120: when no_data_found then
121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'No link for External Sales Order:'||c_rec.sales_order_number||'inst='||to_char(MSC_CL_COLLECTION.v_instance_id) );
122: end;
123: WHEN OTHERS THEN
124: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Error Message is: '||SQLERRM);
125: NULL;
126: END;
127:
128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Hoping its coming before the end loop:'||c_rec.sales_order_number||'inst='||to_char(MSC_CL_COLLECTION.v_instance_id) );

Line 128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Hoping its coming before the end loop:'||c_rec.sales_order_number||'inst='||to_char(MSC_CL_COLLECTION.v_instance_id) );

124: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Error Message is: '||SQLERRM);
125: NULL;
126: END;
127:
128: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Hoping its coming before the end loop:'||c_rec.sales_order_number||'inst='||to_char(MSC_CL_COLLECTION.v_instance_id) );
129: Update msc_sales_orders
130: set supply_id = lv_supply_id,
131: source_organization_id = lv_source_organization_id,
132: source_org_instance_id = lv_source_sr_instance_id

Line 137: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Error Message is: '||SQLERRM);

133: where rowid = c_rec.rowid;
134: end loop;
135: commit;
136: EXCEPTION WHEN OTHERS THEN
137: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Error Message is: '||SQLERRM);
138: NULL;
139:
140: END LINK_SUPP_SO_DEMAND_EXT;
141:

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

162: and original_system_reference <> '-1'
163: and supply_id is not null;
164:
165: BEGIN
166: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
167: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
168: ELSE
169: lv_supply_tbl:= 'MSC_SUPPLIES';
170: END IF;

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

168: ELSE
169: lv_supply_tbl:= 'MSC_SUPPLIES';
170: END IF;
171:
172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
173: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Starting LINK_SUPP_SO_DEMAND_110 ......');
174: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Supply table is: '||lv_supply_tbl);
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
176:

Line 173: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Starting LINK_SUPP_SO_DEMAND_110 ......');

169: lv_supply_tbl:= 'MSC_SUPPLIES';
170: END IF;
171:
172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
173: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Starting LINK_SUPP_SO_DEMAND_110 ......');
174: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Supply table is: '||lv_supply_tbl);
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
176:
177: For c_rec in link_supply_demand (MSC_CL_COLLECTION.v_instance_id)

Line 174: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Supply table is: '||lv_supply_tbl);

170: END IF;
171:
172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
173: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Starting LINK_SUPP_SO_DEMAND_110 ......');
174: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Supply table is: '||lv_supply_tbl);
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
176:
177: For c_rec in link_supply_demand (MSC_CL_COLLECTION.v_instance_id)
178: loop

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

171:
172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
173: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Starting LINK_SUPP_SO_DEMAND_110 ......');
174: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Supply table is: '||lv_supply_tbl);
175: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
176:
177: For c_rec in link_supply_demand (MSC_CL_COLLECTION.v_instance_id)
178: loop
179: BEGIN

Line 184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');

180: lv_supply_id := NULL;
181: lv_source_organization_id := NULL;
182: lv_source_sr_instance_id := NULL;
183:
184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_REFERENCE: '||c_rec.ORIGINAL_SYSTEM_REFERENCE);
186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_LINE_REFERENCE: '|| c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE);
187: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);
188:

Line 185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_REFERENCE: '||c_rec.ORIGINAL_SYSTEM_REFERENCE);

181: lv_source_organization_id := NULL;
182: lv_source_sr_instance_id := NULL;
183:
184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_REFERENCE: '||c_rec.ORIGINAL_SYSTEM_REFERENCE);
186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_LINE_REFERENCE: '|| c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE);
187: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);
188:
189: lv_supply_stmt :=

Line 186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_LINE_REFERENCE: '|| c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE);

182: lv_source_sr_instance_id := NULL;
183:
184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_REFERENCE: '||c_rec.ORIGINAL_SYSTEM_REFERENCE);
186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_LINE_REFERENCE: '|| c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE);
187: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);
188:
189: lv_supply_stmt :=
190: 'SELECT TRANSACTION_ID ,ORGANIZATION_ID, SOURCE_SR_INSTANCE_ID '

Line 187: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);

183:
184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_REFERENCE: '||c_rec.ORIGINAL_SYSTEM_REFERENCE);
186: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_LINE_REFERENCE: '|| c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE);
187: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);
188:
189: lv_supply_stmt :=
190: 'SELECT TRANSACTION_ID ,ORGANIZATION_ID, SOURCE_SR_INSTANCE_ID '
191: ||' FROM '|| lv_supply_tbl

Line 215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'New Supply Id is: '||lv_supply_id);

211: and supply_id = c_rec.supply_id
212: and ORIGINAL_SYSTEM_REFERENCE = c_rec.ORIGINAL_SYSTEM_REFERENCE
213: and ORIGINAL_SYSTEM_LINE_REFERENCE = c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE ;
214:
215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'New Supply Id is: '||lv_supply_id);
216:
217: EXCEPTION WHEN NO_DATA_FOUND THEN
218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'No link for Internal Sales Order:'||c_rec.sales_order_number);
219: WHEN OTHERS THEN

Line 218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'No link for Internal Sales Order:'||c_rec.sales_order_number);

214:
215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'New Supply Id is: '||lv_supply_id);
216:
217: EXCEPTION WHEN NO_DATA_FOUND THEN
218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'No link for Internal Sales Order:'||c_rec.sales_order_number);
219: WHEN OTHERS THEN
220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error: '||SQLERRM);
221: END;
222: end loop;

Line 220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error: '||SQLERRM);

216:
217: EXCEPTION WHEN NO_DATA_FOUND THEN
218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'No link for Internal Sales Order:'||c_rec.sales_order_number);
219: WHEN OTHERS THEN
220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error: '||SQLERRM);
221: END;
222: end loop;
223: commit;
224: EXCEPTION WHEN OTHERS THEN

Line 225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error : '||SQLERRM);

221: END;
222: end loop;
223: commit;
224: EXCEPTION WHEN OTHERS THEN
225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error : '||SQLERRM);
226: NULL;
227:
228: END LINK_SUPP_SO_DEMAND_110;
229:

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

256: -- Bug 14318618
257: -- and supply_id is not null;
258:
259: BEGIN
260: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
261: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
262: ELSE
263: lv_supply_tbl:= 'MSC_SUPPLIES';
264: END IF;

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

262: ELSE
263: lv_supply_tbl:= 'MSC_SUPPLIES';
264: END IF;
265:
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Starting LINK_SUPP_SO_DEMAND_11I2 ......');
268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Supply table is: '||lv_supply_tbl);
269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
270:

Line 267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Starting LINK_SUPP_SO_DEMAND_11I2 ......');

263: lv_supply_tbl:= 'MSC_SUPPLIES';
264: END IF;
265:
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Starting LINK_SUPP_SO_DEMAND_11I2 ......');
268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Supply table is: '||lv_supply_tbl);
269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
270:
271: For c_rec in link_supply_demand (MSC_CL_COLLECTION.v_instance_id)

Line 268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Supply table is: '||lv_supply_tbl);

264: END IF;
265:
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Starting LINK_SUPP_SO_DEMAND_11I2 ......');
268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Supply table is: '||lv_supply_tbl);
269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
270:
271: For c_rec in link_supply_demand (MSC_CL_COLLECTION.v_instance_id)
272: loop

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

265:
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Starting LINK_SUPP_SO_DEMAND_11I2 ......');
268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Supply table is: '||lv_supply_tbl);
269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==========================================================');
270:
271: For c_rec in link_supply_demand (MSC_CL_COLLECTION.v_instance_id)
272: loop
273: BEGIN

Line 278: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');

274: lv_supply_id := NULL;
275: lv_source_organization_id := NULL;
276: lv_source_sr_instance_id := NULL;
277:
278: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_REFERENCE: '||c_rec.ORIGINAL_SYSTEM_REFERENCE);
280: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_LINE_REFERENCE: '|| c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE);
281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);
282:

Line 279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_REFERENCE: '||c_rec.ORIGINAL_SYSTEM_REFERENCE);

275: lv_source_organization_id := NULL;
276: lv_source_sr_instance_id := NULL;
277:
278: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_REFERENCE: '||c_rec.ORIGINAL_SYSTEM_REFERENCE);
280: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_LINE_REFERENCE: '|| c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE);
281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);
282:
283: lv_supply_stmt :=

Line 280: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_LINE_REFERENCE: '|| c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE);

276: lv_source_sr_instance_id := NULL;
277:
278: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_REFERENCE: '||c_rec.ORIGINAL_SYSTEM_REFERENCE);
280: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_LINE_REFERENCE: '|| c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE);
281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);
282:
283: lv_supply_stmt :=
284: 'SELECT TRANSACTION_ID ,ORGANIZATION_ID, SOURCE_SR_INSTANCE_ID '

Line 281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);

277:
278: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_REFERENCE: '||c_rec.ORIGINAL_SYSTEM_REFERENCE);
280: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ORIGINAL_SYSTEM_LINE_REFERENCE: '|| c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE);
281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Supply ID to be updated:'|| c_rec.supply_id);
282:
283: lv_supply_stmt :=
284: 'SELECT TRANSACTION_ID ,ORGANIZATION_ID, SOURCE_SR_INSTANCE_ID '
285: ||' FROM '|| lv_supply_tbl

Line 311: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'New Supply Id is: '||lv_supply_id);

307: and demand_source_line = c_rec.demand_source_line
308: and ORIGINAL_SYSTEM_REFERENCE = c_rec.ORIGINAL_SYSTEM_REFERENCE
309: and ORIGINAL_SYSTEM_LINE_REFERENCE = c_rec.ORIGINAL_SYSTEM_LINE_REFERENCE ;
310:
311: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'New Supply Id is: '||lv_supply_id);
312:
313:
314:
315: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 316: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'No link for Internal Sales Order:'||c_rec.sales_order_number);

312:
313:
314:
315: EXCEPTION WHEN NO_DATA_FOUND THEN
316: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'No link for Internal Sales Order:'||c_rec.sales_order_number);
317: WHEN OTHERS THEN
318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error: '||SQLERRM);
319: END;
320: end loop;

Line 318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error: '||SQLERRM);

314:
315: EXCEPTION WHEN NO_DATA_FOUND THEN
316: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'No link for Internal Sales Order:'||c_rec.sales_order_number);
317: WHEN OTHERS THEN
318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error: '||SQLERRM);
319: END;
320: end loop;
321: commit;
322: EXCEPTION WHEN OTHERS THEN

Line 323: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error : '||SQLERRM);

319: END;
320: end loop;
321: commit;
322: EXCEPTION WHEN OTHERS THEN
323: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error : '||SQLERRM);
324: NULL;
325:
326: END LINK_SUPP_SO_DEMAND_11I2;
327: -- Link the transaction id of the sales orders to supplies if

Line 360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index : DEMANDS_NX_'||MSC_CL_COLLECTION.v_instance_code);

356: INTO lv_drop_index
357: USING lv_msc_schema,lv_msc_schema;
358:
359: IF (lv_drop_index = 1) THEN
360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index : DEMANDS_NX_'||MSC_CL_COLLECTION.v_instance_code);
361: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
362: application_short_name => 'MSC',
363: statement_type => AD_DDL.DROP_INDEX,
364: statement =>

Line 368: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index : DEMANDS_NX_'||MSC_CL_COLLECTION.v_instance_code);

364: statement =>
365: 'drop index demands_nx_'||MSC_CL_COLLECTION.v_instance_code,
366: object_name => 'demands_nx_'||MSC_CL_COLLECTION.v_instance_code);
367:
368: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index : DEMANDS_NX_'||MSC_CL_COLLECTION.v_instance_code);
369: END IF;
370:
371: RETURN true;
372: EXCEPTION

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

373: WHEN NO_DATA_FOUND THEN
374: RETURN true;
375:
376: WHEN OTHERS THEN
377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
378: RETURN FALSE;
379: END drop_demands_tmp_ind;
380:
381:

Line 409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index : SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);

405: INTO lv_drop_index
406: USING lv_msc_schema, lv_msc_schema;
407:
408: IF (lv_drop_index = 1) THEN
409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index : SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);
410: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
411: application_short_name => 'MSC',
412: statement_type => AD_DDL.DROP_INDEX,
413: statement =>

Line 417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index : SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);

413: statement =>
414: 'drop index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code,
415: object_name => 'SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);
416:
417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropped the index : SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);
418: END IF;
419:
420: RETURN true;
421: EXCEPTION

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

422: WHEN NO_DATA_FOUND THEN
423: RETURN true;
424:
425: WHEN OTHERS THEN
426: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
427: RETURN FALSE;
428: END drop_sales_orders_tmp_ind;
429:
430: /* This is a new function added to Link the Sales orders line to its immediate

Line 447: lv_exchange_mode NUMBER:= MSC_UTIL.SYS_NO;

443: lv_upd_sql_stmt VARCHAR2(2000);
444: lv_tbl VARCHAR2(30);
445:
446: lv_refresh_no NUMBER;
447: lv_exchange_mode NUMBER:= MSC_UTIL.SYS_NO;
448: lv_task_start_time DATE;
449: lv_upd_count NUMBER := 0;
450:
451: lv_retval boolean;

Line 458: IF (MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') ) THEN

454: BEGIN
455:
456: lv_task_start_time := SYSDATE;
457:
458: IF (MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') ) THEN
459: lv_exchange_mode := MSC_UTIL.SYS_YES;
460: END IF;
461:
462: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 459: lv_exchange_mode := MSC_UTIL.SYS_YES;

455:
456: lv_task_start_time := SYSDATE;
457:
458: IF (MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') ) THEN
459: lv_exchange_mode := MSC_UTIL.SYS_YES;
460: END IF;
461:
462: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN
463: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;

Line 462: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN

458: IF (MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') ) THEN
459: lv_exchange_mode := MSC_UTIL.SYS_YES;
460: END IF;
461:
462: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN
463: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;
464: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
465:
466: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

Line 479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');

475: object_name => 'SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);
476:
477: msc_analyse_tables_pk.analyse_table( 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code, MSC_CL_COLLECTION.v_instance_id, -1);
478:
479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
480: ELSE
481: lv_tbl:= 'MSC_SALES_ORDERS';
482: END IF;
483:

Line 504: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'The Select statement: '||lv_sel_sql_stmt);

500: /* If incremental of Sales orders then select rows only for collected data */
501: lv_sel_sql_stmt := lv_sel_sql_stmt || ' AND mso1.REFRESH_NUMBER = ' || MSC_CL_COLLECTION.v_last_collection_id;
502: END IF;
503:
504: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'The Select statement: '||lv_sel_sql_stmt);
505:
506: OPEN c1 FOR lv_sel_sql_stmt; -- open the REF cursor
507:
508: LOOP

Line 536: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);

532:
533: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
534: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
535: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
536: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
537:
538: RETURN TRUE;
539:
540: EXCEPTION

Line 542: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error executing LINK_PARENT_SALES_ORDERS......');

538: RETURN TRUE;
539:
540: EXCEPTION
541: WHEN OTHERS THEN
542: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error executing LINK_PARENT_SALES_ORDERS......');
543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
544: RETURN FALSE;
545:
546: END LINK_PARENT_SALES_ORDERS;

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

539:
540: EXCEPTION
541: WHEN OTHERS THEN
542: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error executing LINK_PARENT_SALES_ORDERS......');
543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
544: RETURN FALSE;
545:
546: END LINK_PARENT_SALES_ORDERS;
547:

Line 565: lv_exchange_mode NUMBER:= MSC_UTIL.SYS_NO;

561: lv_upd_sql_stmt VARCHAR2(2000);
562: lv_tbl VARCHAR2(30);
563:
564: lv_refresh_no NUMBER;
565: lv_exchange_mode NUMBER:= MSC_UTIL.SYS_NO;
566: lv_upd_count NUMBER := 0;
567: lv_task_start_time DATE;
568:
569: lv_retval boolean;

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

572: BEGIN
573:
574: lv_task_start_time := SYSDATE;
575:
576: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
577: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
578: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
579:
580: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

Line 593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index DEMANDS_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');

589: object_name => 'demands_nx_'||MSC_CL_COLLECTION.v_instance_code);
590:
591: msc_analyse_tables_pk.analyse_table( 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code, MSC_CL_COLLECTION.v_instance_id, -1);
592:
593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Index DEMANDS_NX_'||MSC_CL_COLLECTION.v_instance_code||' created.');
594: ELSE
595: lv_tbl:= 'MSC_DEMANDS';
596: END IF;
597:

Line 615: IF (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) THEN

611: ||' AND md1.link_to_line_id IS NOT NULL ';
612:
613: /* If incremental of Sales Orders demands then select rows only for collected data */
614: IF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
615: IF (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) THEN
616: lv_sel_sql_stmt := lv_sel_sql_stmt || ' AND md1.REFRESH_NUMBER = ' || MSC_CL_COLLECTION.v_last_collection_id;
617: END IF;
618: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh) THEN
619: lv_sel_sql_stmt := lv_sel_sql_stmt || ' AND md1.REFRESH_NUMBER = ' || MSC_CL_COLLECTION.v_last_collection_id;

Line 622: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'The Select statement: '||lv_sel_sql_stmt);

618: ELSIF (MSC_CL_COLLECTION.v_is_incremental_refresh) THEN
619: lv_sel_sql_stmt := lv_sel_sql_stmt || ' AND md1.REFRESH_NUMBER = ' || MSC_CL_COLLECTION.v_last_collection_id;
620: END IF;
621:
622: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'The Select statement: '||lv_sel_sql_stmt);
623:
624: OPEN c1 FOR lv_sel_sql_stmt; -- open the REF cursor
625:
626: LOOP

Line 656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);

652:
653: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
654: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
655: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' '||FND_MESSAGE.GET);
657:
658: RETURN TRUE;
659:
660: EXCEPTION

Line 662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error executing LINK_PARENT_SALES_ORDERS_MDS......');

658: RETURN TRUE;
659:
660: EXCEPTION
661: WHEN OTHERS THEN
662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error executing LINK_PARENT_SALES_ORDERS_MDS......');
663: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
664:
665: RETURN FALSE;
666:

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

659:
660: EXCEPTION
661: WHEN OTHERS THEN
662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error executing LINK_PARENT_SALES_ORDERS_MDS......');
663: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
664:
665: RETURN FALSE;
666:
667: END LINK_PARENT_SALES_ORDERS_MDS;

Line 681: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES

677: FROM MSC_ITEM_ID_LID t1,
678: MSC_ST_DEMANDS msd
679: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
680: AND msd.ORIGINATION_TYPE = 29
681: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES
682: AND t1.SR_INVENTORY_ITEM_ID(+)= msd.inventory_item_id
683: AND t1.sr_instance_id(+)= MSC_CL_COLLECTION.v_instance_id;
684:
685: /* for bug: 2351354, made the changes to cursor to select the customer_id and the ship_to_site_id

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

744: lv_sql_ins VARCHAR2(5000);
745:
746: BEGIN
747:
748: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
749: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
750: ELSE
751: lv_tbl:= 'MSC_DEMANDS';
752: END IF;

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

852: WHEN OTHERS THEN
853:
854: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
855:
856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
857: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
858: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
859: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

856: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
857: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
858: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
859: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
861:
862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
863: RAISE;
864:

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

858: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
859: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
861:
862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
863: RAISE;
864:
865: ELSE
866: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

862: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
863: RAISE;
864:
865: ELSE
866: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
868: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
869: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
870: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');

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

863: RAISE;
864:
865: ELSE
866: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
868: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
869: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
870: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
868: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
869: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
870: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
873: END IF;
874: END;
875:

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

868: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
869: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
870: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
873: END IF;
874: END;
875:
876: ELSE

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

1059: WHEN OTHERS THEN
1060:
1061: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1062:
1063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1064: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1065: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1066: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1063: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1064: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1065: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1066: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1068:
1069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1070: RAISE;
1071:

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

1065: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1066: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1068:
1069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1070: RAISE;
1071:
1072: ELSE
1073: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

1069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1070: RAISE;
1071:
1072: ELSE
1073: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1074:
1075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');

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

1071:
1072: ELSE
1073: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1074:
1075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1076: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1077: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECASTS');
1078: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
1079: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1080:
1081: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1082: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1083: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

1080:
1081: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1082: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
1083: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
1084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1085:
1086:
1087: /*
1088: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');

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

1089: FND_MESSAGE.SET_TOKEN('COLUMN', 'FORECAST_DESIGNATOR');
1090: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.forecast_designator);
1091: */
1092:
1093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1094:
1095: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1096: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');
1097: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);

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

1095: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1096: FND_MESSAGE.SET_TOKEN('COLUMN', 'SCHEDULE_DESIGNATOR_ID');
1097: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.schedule_designator_id);
1098:
1099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1100:
1101:
1102: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1103: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1103: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1104: FND_MESSAGE.SET_TOKEN('VALUE',
1105: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1106: MSC_CL_COLLECTION.v_instance_id));
1107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1108:
1109: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1110: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1111: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));

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

1108:
1109: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1110: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
1111: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DEMAND_TYPE));
1112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1113:
1114: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1115: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1116: FND_MESSAGE.SET_TOKEN('VALUE',

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

1115: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
1116: FND_MESSAGE.SET_TOKEN('VALUE',
1117: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1118: c_rec.ORIGINATION_TYPE));
1119: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1120:
1121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1122: END IF;
1123:

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

1117: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
1118: c_rec.ORIGINATION_TYPE));
1119: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1120:
1121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1122: END IF;
1123:
1124: END;
1125:

Line 1141: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES;

1137: MSD.ORGANIZATION_ID,
1138: MSD.SR_INSTANCE_ID
1139: from MSC_ST_DESIGNATORS MSD
1140: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1141: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES;
1142:
1143: CURSOR c1 IS
1144: SELECT
1145: msd.DESIGNATOR,

Line 1201: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

1197: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1198: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
1199: and designator = c_rec.designator
1200: and designator_type = 6
1201: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1202:
1203: END LOOP;
1204:
1205: COMMIT;

Line 1265: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

1261: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1262: WHERE DESIGNATOR= c_rec.DESIGNATOR
1263: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
1264: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1265: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1266:
1267: IF SQL%NOTFOUND THEN
1268:
1269:

Line 1320: MSC_UTIL.SYS_YES,

1316: c_rec.CUSTOMER_ID,
1317: c_rec.SHIP_ID,
1318: c_rec.BILL_ID,
1319: c_rec.BUCKET_TYPE,
1320: MSC_UTIL.SYS_YES,
1321: c_rec.SR_INSTANCE_ID,
1322: MSC_CL_COLLECTION.v_last_collection_id,
1323: MSC_CL_COLLECTION.v_current_date,
1324: MSC_CL_COLLECTION.v_current_user,

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

1340: WHEN OTHERS THEN
1341:
1342: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1343:
1344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1345: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1346: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1347: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1345: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1346: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1347: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1349:
1350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1351: RAISE;
1352:

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

1346: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1347: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1349:
1350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1351: RAISE;
1352:
1353: ELSE
1354: IF SQLCODE = -00001 THEN

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

1351: RAISE;
1352:
1353: ELSE
1354: IF SQLCODE = -00001 THEN
1355: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1357: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1358: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1359: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');

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

1352:
1353: ELSE
1354: IF SQLCODE = -00001 THEN
1355: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1357: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1358: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1359: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1357: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1358: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1359: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1360: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1361:
1362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1363: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1364: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));

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

1361:
1362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1363: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1364: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1366:
1367:
1368:
1369: ELSE

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

1367:
1368:
1369: ELSE
1370:
1371: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1372:
1373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1374: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1375: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');

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

1369: ELSE
1370:
1371: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1372:
1373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1374: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1375: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1376: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1374: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1375: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_FORECASTS');
1376: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1378:
1379: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1380: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1381: FND_MESSAGE.SET_TOKEN('VALUE',

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

1380: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1381: FND_MESSAGE.SET_TOKEN('VALUE',
1382: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1383: MSC_CL_COLLECTION.v_instance_id));
1384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1385:
1386: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1387: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1388: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);

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

1385:
1386: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1387: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1388: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1390:
1391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1392: END IF;
1393: END IF;

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

1387: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1388: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1390:
1391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1392: END IF;
1393: END IF;
1394: END;
1395:

Line 1419: WHERE msd.DELETED_FLAG = MSC_UTIL.SYS_NO

1415: msd.INVENTORY_ATP_FLAG,
1416: msd.DISABLE_DATE,
1417: msd.SR_INSTANCE_ID
1418: FROM MSC_ST_DESIGNATORS msd
1419: WHERE msd.DELETED_FLAG = MSC_UTIL.SYS_NO
1420: AND msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1421: AND msd.DESIGNATOR_TYPE in (12,13);
1422:
1423: CURSOR c_del IS

Line 1429: WHERE msd.deleted_flag = MSC_UTIL.SYS_YES

1425: msd.SRC_DESIGNATOR,
1426: msd.ORGANIZATION_ID,
1427: msd.SR_INSTANCE_ID
1428: FROM MSC_ST_DESIGNATORS msd
1429: WHERE msd.deleted_flag = MSC_UTIL.SYS_YES
1430: AND msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1431: AND msd.DESIGNATOR_TYPE in (12,13);
1432:
1433:

Line 1441: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_CMRO_EAM_FORECASTS ');

1437: lv_tbl VARCHAR2(30);
1438: lv_cursor_stmt VARCHAR2(5000);
1439:
1440: BEGIN
1441: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'In Procedure LOAD_CMRO_EAM_FORECASTS ');
1442:
1443: FOR c_rec IN c_del LOOP
1444: BEGIN
1445:

Line 1456: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

1452: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
1453: and DESIGNATOR = c_rec.designator
1454: and SRC_DESIGNATOR = c_rec.src_designator
1455: and DESIGNATOR_TYPE in (12,13)
1456: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1457:
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

Line 1460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

1456: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1457:
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
1461: 'An error has occurred during deletion of CMRO/Eam forecasts');
1462: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1463: RAISE;
1464: END;

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

1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
1461: 'An error has occurred during deletion of CMRO/Eam forecasts');
1462: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1463: RAISE;
1464: END;
1465: END LOOP;
1466:

Line 1490: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

1486: AND SRC_DESIGNATOR= c_rec.SRC_DESIGNATOR
1487: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
1488: AND SRC_SIM_FCST_ID =c_rec.SRC_SIM_FCST_ID
1489: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1490: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1491:
1492:
1493: IF SQL%NOTFOUND THEN
1494: INSERT INTO MSC_DESIGNATORS

Line 1523: MSC_UTIL.SYS_YES,

1519: c_rec.ORGANIZATION_ID,
1520: c_rec.MPS_RELIEF,
1521: c_rec.INVENTORY_ATP_FLAG,
1522: c_rec.DISABLE_DATE,
1523: MSC_UTIL.SYS_YES,
1524: c_rec.SR_INSTANCE_ID,
1525: MSC_CL_COLLECTION.v_last_collection_id,
1526: MSC_CL_COLLECTION.v_current_date,
1527: MSC_CL_COLLECTION.v_current_user,

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

1543: WHEN OTHERS THEN
1544:
1545: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1546:
1547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1548: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1549: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1550: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1548: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1549: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1550: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1552:
1553: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1554: RAISE;
1555:

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

1549: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1550: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1552:
1553: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1554: RAISE;
1555:
1556: ELSE
1557: IF SQLCODE = -00001 THEN

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

1554: RAISE;
1555:
1556: ELSE
1557: IF SQLCODE = -00001 THEN
1558: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1560: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1561: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1562: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');

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

1555:
1556: ELSE
1557: IF SQLCODE = -00001 THEN
1558: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1560: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1561: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1562: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1560: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1561: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1562: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1564:
1565: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1566: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1567: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));

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

1564:
1565: FND_MESSAGE.SET_NAME('MSC', 'MSC_DESIGNATOR_UNIQUE');
1566: FND_MESSAGE.SET_TOKEN('DESIGNATOR', c_rec.DESIGNATOR);
1567: FND_MESSAGE.SET_TOKEN('ORGANIZATION', MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,MSC_CL_COLLECTION.v_instance_id));
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1569:
1570:
1571:
1572: ELSE

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

1570:
1571:
1572: ELSE
1573:
1574: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1575:
1576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1577: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');

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

1572: ELSE
1573:
1574: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1575:
1576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1577: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

1576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1577: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1578: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CMRO_EAM_FORECASTS');
1579: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
1580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1581:
1582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1583: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1584: FND_MESSAGE.SET_TOKEN('VALUE',

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

1583: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1584: FND_MESSAGE.SET_TOKEN('VALUE',
1585: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
1586: MSC_CL_COLLECTION.v_instance_id));
1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1588:
1589: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1590: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1591: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);

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

1588:
1589: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1590: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1591: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593:
1594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1595: END IF;
1596: END IF;

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

1590: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
1591: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
1592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1593:
1594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1595: END IF;
1596: END IF;
1597:
1598:

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

1740: lb_ship_to_location_id NumTblTyp;
1741: lb_LINK_TO_LINE_ID NumTblTyp;
1742: BEGIN
1743:
1744: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1745: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
1746: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1747: ELSE
1748: lv_tbl:= 'MSC_DEMANDS';

Line 1755: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_NO) AND

1751:
1752: /** PREPLACE CHANGE START **/
1753:
1754: IF (MSC_CL_COLLECTION.v_is_partial_refresh AND
1755: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_NO) AND
1756: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_NO) AND
1757: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_NO) AND
1758: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_NO) AND
1759: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN

Line 1756: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_NO) AND

1752: /** PREPLACE CHANGE START **/
1753:
1754: IF (MSC_CL_COLLECTION.v_is_partial_refresh AND
1755: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_NO) AND
1756: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_NO) AND
1757: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_NO) AND
1758: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_NO) AND
1759: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN
1760:

Line 1757: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_NO) AND

1753:
1754: IF (MSC_CL_COLLECTION.v_is_partial_refresh AND
1755: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_NO) AND
1756: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_NO) AND
1757: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_NO) AND
1758: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_NO) AND
1759: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN
1760:
1761: lv_supply_tbl := 'MSC_SUPPLIES';

Line 1758: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_NO) AND

1754: IF (MSC_CL_COLLECTION.v_is_partial_refresh AND
1755: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_NO) AND
1756: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_NO) AND
1757: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_NO) AND
1758: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_NO) AND
1759: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN
1760:
1761: lv_supply_tbl := 'MSC_SUPPLIES';
1762:

Line 1759: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN

1755: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_NO) AND
1756: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_NO) AND
1757: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_NO) AND
1758: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_NO) AND
1759: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN
1760:
1761: lv_supply_tbl := 'MSC_SUPPLIES';
1762:
1763: ELSIF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 1763: ELSIF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

1759: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN
1760:
1761: lv_supply_tbl := 'MSC_SUPPLIES';
1762:
1763: ELSIF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1764:
1765: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1766:
1767: END IF;

Line 1773: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR

1769: /** PREPLACE CHANGE END **/
1770:
1771: /* In cont. collections if any of the Supply is targeted */
1772: IF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
1773: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
1774: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
1775: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
1776: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
1777: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN

Line 1774: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR

1770:
1771: /* In cont. collections if any of the Supply is targeted */
1772: IF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
1773: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
1774: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
1775: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
1776: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
1777: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN
1778:

Line 1775: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR

1771: /* In cont. collections if any of the Supply is targeted */
1772: IF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
1773: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
1774: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
1775: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
1776: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
1777: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN
1778:
1779: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;

Line 1776: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR

1772: IF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
1773: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
1774: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
1775: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
1776: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
1777: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN
1778:
1779: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1780: ELSE

Line 1777: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN

1773: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
1774: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
1775: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
1776: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
1777: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN
1778:
1779: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1780: ELSE
1781: lv_supply_tbl := 'MSC_SUPPLIES';

Line 1975: IF (MSC_CL_COLLECTION.v_apps_ver = MSC_UTIL.G_APPS110 OR MSC_CL_COLLECTION.v_is_legacy_refresh) THEN -- Version

1971: AND lb_OR_SYSTEM_REFERENCE(j) <> '-1'
1972: AND lb_OR_SYSTEM_LINE_REFERENCE(j) <> '-1' ) THEN -- Internal Sales Orders
1973:
1974:
1975: IF (MSC_CL_COLLECTION.v_apps_ver = MSC_UTIL.G_APPS110 OR MSC_CL_COLLECTION.v_is_legacy_refresh) THEN -- Version
1976: BEGIN
1977: MSC_CL_COLLECTION.v_supply_id := Null;
1978: MSC_CL_COLLECTION.v_source_organization_id := Null;
1979: MSC_CL_COLLECTION.v_source_sr_instance_id := Null;

Line 2001: ELSIF MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115 THEN --Version

1997: WHEN NO_DATA_FOUND THEN NULL;
1998: WHEN OTHERS THEN NULL;
1999:
2000: END ;
2001: ELSIF MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115 THEN --Version
2002:
2003: BEGIN --R11i2
2004: MSC_CL_COLLECTION.v_supply_id := Null;
2005: MSC_CL_COLLECTION.v_source_organization_id := Null;

Line 2034: IF lb_DELETED_FLAG(j) = MSC_UTIL.SYS_YES THEN

2030:
2031: --================= mds demands ==================
2032: IF lb_ORIGINATION_TYPE(j) IN ( 6,7,15,24,42) THEN
2033:
2034: IF lb_DELETED_FLAG(j) = MSC_UTIL.SYS_YES THEN
2035:
2036: UPDATE MSC_DEMANDS
2037: SET USING_REQUIREMENT_QUANTITY= 0,
2038: DAILY_DEMAND_RATE= 0,

Line 2106: IF lb_DELETED_FLAG(j)= MSC_UTIL.SYS_YES THEN

2102: END IF; -- DELETED_FLAG
2103:
2104: ELSIF lb_ORIGINATION_TYPE(j)=8 THEN /* Manual MDS */
2105:
2106: IF lb_DELETED_FLAG(j)= MSC_UTIL.SYS_YES THEN
2107:
2108: UPDATE MSC_DEMANDS
2109: SET USING_REQUIREMENT_QUANTITY= 0,
2110: DAILY_DEMAND_RATE= 0,

Line 2181: ( lb_DELETED_FLAG(j)<> MSC_UTIL.SYS_YES AND SQL%NOTFOUND) THEN

2177: END IF; -- refresh mode
2178:
2179: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR
2180:
2181: ( lb_DELETED_FLAG(j)<> MSC_UTIL.SYS_YES AND SQL%NOTFOUND) THEN
2182:
2183: EXECUTE IMMEDIATE lv_sql_stmt
2184: USING
2185: lb_INVENTORY_ITEM_ID(j),

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

2246: WHEN OTHERS THEN
2247:
2248: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2249:
2250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2251: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2252: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2253: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2251: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2252: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2253: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2255:
2256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2257: RAISE;
2258:

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

2252: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2253: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2255:
2256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2257: RAISE;
2258:
2259: ELSE
2260:

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

2257: RAISE;
2258:
2259: ELSE
2260:
2261: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2262:
2263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2264: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2265: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');

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

2259: ELSE
2260:
2261: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2262:
2263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2264: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2265: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2266: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

2263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2264: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2265: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DEMAND');
2266: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
2267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2268:
2269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2270: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2271: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));

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

2268:
2269: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2270: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
2271: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( lb_INVENTORY_ITEM_ID(j)));
2272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2273:
2274: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2275: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2276: FND_MESSAGE.SET_TOKEN('VALUE',

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

2275: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2276: FND_MESSAGE.SET_TOKEN('VALUE',
2277: MSC_GET_NAME.ORG_CODE( lb_ORGANIZATION_ID(j),
2278: MSC_CL_COLLECTION.v_instance_id));
2279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2280:
2281: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2282: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2283: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));

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

2280:
2281: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2282: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
2283: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lb_ORGANIZATION_ID(j)));
2284: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2285:
2286: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2287: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
2288: FND_MESSAGE.SET_TOKEN('VALUE',

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

2287: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
2288: FND_MESSAGE.SET_TOKEN('VALUE',
2289: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
2290: lb_ORIGINATION_TYPE(j)));
2291: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2292:
2293: IF lb_DEMAND_SCHEDULE_NAME(j) IS NOT NULL THEN
2294: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2295: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');

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

2293: IF lb_DEMAND_SCHEDULE_NAME(j) IS NOT NULL THEN
2294: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2295: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_SCHEDULE_NAME');
2296: FND_MESSAGE.SET_TOKEN('VALUE', lb_DEMAND_SCHEDULE_NAME(j));
2297: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2298: END IF;
2299:
2300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2301: END IF;

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

2296: FND_MESSAGE.SET_TOKEN('VALUE', lb_DEMAND_SCHEDULE_NAME(j));
2297: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2298: END IF;
2299:
2300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2301: END IF;
2302:
2303: END;
2304:

Line 2312: IF (MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115) then

2308: CLOSE c1;
2309:
2310: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN COMMIT; END IF;
2311:
2312: IF (MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115) then
2313: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR (MSC_CL_COLLECTION.v_is_cont_refresh and MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) THEN --Version
2314: /* call the function to link the Demand_id and Parent_id in MSC_DEMANDS
2315: if mds is incremental*/
2316: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_NO;

Line 2313: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR (MSC_CL_COLLECTION.v_is_cont_refresh and MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) THEN --Version

2309:
2310: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN COMMIT; END IF;
2311:
2312: IF (MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115) then
2313: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR (MSC_CL_COLLECTION.v_is_cont_refresh and MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) THEN --Version
2314: /* call the function to link the Demand_id and Parent_id in MSC_DEMANDS
2315: if mds is incremental*/
2316: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_NO;
2317: IF MSC_CL_DEMAND_ODS_LOAD.LINK_PARENT_SALES_ORDERS_MDS THEN

Line 2316: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_NO;

2312: IF (MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115) then
2313: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR (MSC_CL_COLLECTION.v_is_cont_refresh and MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_INCR) THEN --Version
2314: /* call the function to link the Demand_id and Parent_id in MSC_DEMANDS
2315: if mds is incremental*/
2316: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_NO;
2317: IF MSC_CL_DEMAND_ODS_LOAD.LINK_PARENT_SALES_ORDERS_MDS THEN
2318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Linking of Sales Order line in MDS to its Parent Sales orders is successful.....');
2319: ELSE
2320: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in Linking Sales order line in MDS to its parent Sales order......');

Line 2318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Linking of Sales Order line in MDS to its Parent Sales orders is successful.....');

2314: /* call the function to link the Demand_id and Parent_id in MSC_DEMANDS
2315: if mds is incremental*/
2316: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_NO;
2317: IF MSC_CL_DEMAND_ODS_LOAD.LINK_PARENT_SALES_ORDERS_MDS THEN
2318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Linking of Sales Order line in MDS to its Parent Sales orders is successful.....');
2319: ELSE
2320: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in Linking Sales order line in MDS to its parent Sales order......');
2321: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2322: END IF;

Line 2320: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in Linking Sales order line in MDS to its parent Sales order......');

2316: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_NO;
2317: IF MSC_CL_DEMAND_ODS_LOAD.LINK_PARENT_SALES_ORDERS_MDS THEN
2318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Linking of Sales Order line in MDS to its Parent Sales orders is successful.....');
2319: ELSE
2320: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in Linking Sales order line in MDS to its parent Sales order......');
2321: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2322: END IF;
2323: END IF;
2324: END IF;

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

2317: IF MSC_CL_DEMAND_ODS_LOAD.LINK_PARENT_SALES_ORDERS_MDS THEN
2318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Linking of Sales Order line in MDS to its Parent Sales orders is successful.....');
2319: ELSE
2320: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in Linking Sales order line in MDS to its parent Sales order......');
2321: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2322: END IF;
2323: END IF;
2324: END IF;
2325:

Line 2333: IF (MSC_CL_COLLECTION.v_apps_ver = MSC_UTIL.G_APPS110 OR MSC_CL_COLLECTION.v_is_legacy_refresh) THEN -- Version

2329:
2330: PROCEDURE link_ISO_IR(pSOtbl varchar2,pSupplyTbl varchar2) IS
2331: lv_sql VARCHAR2(4000);
2332: BEGIN
2333: IF (MSC_CL_COLLECTION.v_apps_ver = MSC_UTIL.G_APPS110 OR MSC_CL_COLLECTION.v_is_legacy_refresh) THEN -- Version
2334: lv_sql:=
2335: 'UPDATE '||pSOtbl||' a
2336: SET (SUPPLY_ID, SOURCE_ORGANIZATION_ID, SOURCE_ORG_INSTANCE_ID)
2337: = (SELECT b.TRANSACTION_ID ,b.ORGANIZATION_ID, b.SOURCE_SR_INSTANCE_ID

Line 2378: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'link_ISO_IR: Rows updated - '||SQL%ROWCOUNT);

2374: END IF;
2375:
2376: EXECUTE IMMEDIATE lv_sql;
2377: commit;
2378: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'link_ISO_IR: Rows updated - '||SQL%ROWCOUNT);
2379:
2380: END;
2381:
2382: -- ========================= LOAD SALES ORDER ==============

Line 2389: lv_exchange_mode NUMBER:= MSC_UTIL.SYS_NO;

2385:
2386: lv_tbl VARCHAR2(30);
2387: lv_supply_tbl VARCHAR2(30);
2388: ln_rows_to_fetch Number := nvl(TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE')),75000);
2389: lv_exchange_mode NUMBER:= MSC_UTIL.SYS_NO;
2390: lv_sql_stmt VARCHAR2(32767);
2391: lv_sql1_1 VARCHAR2(4000);
2392: lv_sql1_2 VARCHAR2(1000);
2393: lv_sql1_3 VARCHAR2(4000);

Line 2401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' LOAD_SALES_ORDER started');

2397: lv_sql5 VARCHAR2(30000);
2398:
2399:
2400: BEGIN
2401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' LOAD_SALES_ORDER started');
2402:
2403: IF MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND
2404: MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') THEN
2405: lv_exchange_mode := MSC_UTIL.SYS_YES;

Line 2403: IF MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND

2399:
2400: BEGIN
2401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' LOAD_SALES_ORDER started');
2402:
2403: IF MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND
2404: MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') THEN
2405: lv_exchange_mode := MSC_UTIL.SYS_YES;
2406: END IF;
2407:

Line 2405: lv_exchange_mode := MSC_UTIL.SYS_YES;

2401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' LOAD_SALES_ORDER started');
2402:
2403: IF MSC_CL_COLLECTION.v_so_exchange_mode= MSC_UTIL.SYS_YES AND
2404: MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') THEN
2405: lv_exchange_mode := MSC_UTIL.SYS_YES;
2406: END IF;
2407:
2408: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN
2409: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;

Line 2408: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN

2404: MSC_CL_COLLECTION.is_msctbl_partitioned('MSC_SALES_ORDERS') THEN
2405: lv_exchange_mode := MSC_UTIL.SYS_YES;
2406: END IF;
2407:
2408: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN
2409: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;
2410: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2411: ELSE
2412: lv_tbl:= 'MSC_SALES_ORDERS';

Line 2419: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_NO) AND

2415:
2416: /** PREPLACE CHANGE START **/
2417:
2418: IF (MSC_CL_COLLECTION.v_is_partial_refresh AND
2419: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_NO) AND
2420: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_NO) AND
2421: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_NO) AND
2422: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_NO) AND
2423: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN

Line 2420: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_NO) AND

2416: /** PREPLACE CHANGE START **/
2417:
2418: IF (MSC_CL_COLLECTION.v_is_partial_refresh AND
2419: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_NO) AND
2420: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_NO) AND
2421: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_NO) AND
2422: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_NO) AND
2423: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN
2424:

Line 2421: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_NO) AND

2417:
2418: IF (MSC_CL_COLLECTION.v_is_partial_refresh AND
2419: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_NO) AND
2420: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_NO) AND
2421: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_NO) AND
2422: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_NO) AND
2423: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN
2424:
2425: lv_supply_tbl := 'MSC_SUPPLIES';

Line 2422: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_NO) AND

2418: IF (MSC_CL_COLLECTION.v_is_partial_refresh AND
2419: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_NO) AND
2420: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_NO) AND
2421: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_NO) AND
2422: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_NO) AND
2423: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN
2424:
2425: lv_supply_tbl := 'MSC_SUPPLIES';
2426:

Line 2423: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN

2419: (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_NO) AND
2420: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_NO) AND
2421: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_NO) AND
2422: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_NO) AND
2423: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN
2424:
2425: lv_supply_tbl := 'MSC_SUPPLIES';
2426:
2427: ELSIF lv_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 2427: ELSIF lv_exchange_mode=MSC_UTIL.SYS_YES THEN

2423: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO) ) THEN
2424:
2425: lv_supply_tbl := 'MSC_SUPPLIES';
2426:
2427: ELSIF lv_exchange_mode=MSC_UTIL.SYS_YES THEN
2428:
2429: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2430:
2431: END IF;

Line 2437: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR

2433:
2434:
2435: /* In cont. collections if any of the Supply is targeted */
2436: IF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2437: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
2438: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
2439: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
2440: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
2441: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN

Line 2438: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR

2434:
2435: /* In cont. collections if any of the Supply is targeted */
2436: IF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2437: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
2438: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
2439: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
2440: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
2441: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN
2442: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;

Line 2439: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR

2435: /* In cont. collections if any of the Supply is targeted */
2436: IF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2437: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
2438: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
2439: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
2440: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
2441: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN
2442: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2443: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_YES ;-- bug 8424335

Line 2440: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR

2436: IF (MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2437: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
2438: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
2439: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
2440: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
2441: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN
2442: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2443: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_YES ;-- bug 8424335
2444: ELSE

Line 2441: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN

2437: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) OR
2438: (MSC_CL_COLLECTION.v_coll_prec.mps_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.mps_sn_flag = MSC_UTIL.SYS_TGT) OR
2439: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
2440: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
2441: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN
2442: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2443: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_YES ;-- bug 8424335
2444: ELSE
2445: lv_supply_tbl := 'MSC_SUPPLIES';

Line 2443: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_YES ;-- bug 8424335

2439: (MSC_CL_COLLECTION.v_coll_prec.po_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.po_sn_flag = MSC_UTIL.SYS_TGT) OR
2440: (MSC_CL_COLLECTION.v_coll_prec.oh_flag = MSC_UTIL.SYS_YES AND MSC_CL_COLLECTION.v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) OR
2441: (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and MSC_CL_COLLECTION.v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) THEN
2442: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2443: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_YES ;-- bug 8424335
2444: ELSE
2445: lv_supply_tbl := 'MSC_SUPPLIES';
2446: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_NO ; -- bug 8424335
2447: END IF;

Line 2446: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_NO ; -- bug 8424335

2442: lv_supply_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2443: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_YES ;-- bug 8424335
2444: ELSE
2445: lv_supply_tbl := 'MSC_SUPPLIES';
2446: MSC_CL_COLLECTION.v_exchange_mode := MSC_UTIL.SYS_NO ; -- bug 8424335
2447: END IF;
2448: END IF;
2449:
2450: /* 2140727 - Insert project_id and task_id also */

Line 2455: IF lv_exchange_mode=MSC_UTIL.SYS_NO THEN

2451:
2452: -- delete records
2453: IF MSC_CL_COLLECTION.v_is_so_complete_refresh THEN -- complete refresh
2454:
2455: IF lv_exchange_mode=MSC_UTIL.SYS_NO THEN
2456:
2457: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2458: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL);
2459: ELSE

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

2453: IF MSC_CL_COLLECTION.v_is_so_complete_refresh THEN -- complete refresh
2454:
2455: IF lv_exchange_mode=MSC_UTIL.SYS_NO THEN
2456:
2457: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2458: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL);
2459: ELSE
2460: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2461: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);

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

2456:
2457: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
2458: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL);
2459: ELSE
2460: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2461: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);
2462: END IF;
2463:
2464: END IF;

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

2464: END IF;
2465:
2466: BEGIN
2467:
2468: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS) AND (lv_exchange_mode=MSC_UTIL.SYS_YES)) THEN
2469:
2470: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;
2471:
2472: lv_sql_stmt:=

Line 2473: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl

2469:
2470: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;
2471:
2472: lv_sql_stmt:=
2473: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2474: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_SALES_ORDERS'
2475: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2476: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2477:

Line 2474: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_SALES_ORDERS'

2470: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;
2471:
2472: lv_sql_stmt:=
2473: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2474: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_SALES_ORDERS'
2475: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2476: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2477:
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

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

2472: lv_sql_stmt:=
2473: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2474: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_SALES_ORDERS'
2475: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2476: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2477:
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
2479: EXECUTE IMMEDIATE lv_sql_stmt;
2480: COMMIT;

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

2474: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_SALES_ORDERS'
2475: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2476: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2477:
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
2479: EXECUTE IMMEDIATE lv_sql_stmt;
2480: COMMIT;
2481: END IF;
2482:

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

2482:
2483: EXCEPTION
2484: WHEN OTHERS THEN
2485:
2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2487: RAISE;
2488: END;
2489:
2490: ELSE

Line 2501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'NetCHg DELETE1 ROWSDELETED :'||SQL%rowcount);

2497: FROM MSC_ST_SALES_ORDERS so
2498: WHERE so.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
2499: AND so.ROW_TYPE = 2 )
2500: AND ROWNUM <= ln_rows_to_fetch;
2501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'NetCHg DELETE1 ROWSDELETED :'||SQL%rowcount);
2502: EXIT WHEN SQL%ROWCOUNT = 0;
2503: COMMIT;
2504: END LOOP;
2505:

Line 2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'NetCHg DELETE2 ROWSDELETED :'||SQL%rowcount);

2510: FROM MSC_ST_SALES_ORDERS so
2511: WHERE so.DELETED_FLAG = 1
2512: AND so.sr_instance_id = MSC_CL_COLLECTION.v_instance_id)
2513: AND ROWNUM <= ln_rows_to_fetch;
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'NetCHg DELETE2 ROWSDELETED :'||SQL%rowcount);
2515: EXIT WHEN SQL%ROWCOUNT = 0;
2516: COMMIT;
2517: END LOOP;
2518:

Line 2880: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);

2876: lv_sql5 := REPLACE (lv_sql5,'xxx_ROW_TYPE',1);
2877: lv_sql5 := REPLACE (lv_sql5,'xxx_RESERVATION_QUANTITY',' decode (s.COMPLETED_QUANTITY,
2878: 0, d.RESERVATION_QUANTITY,
2879: d.old_reservation_quantity) ');
2880: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
2881: EXECUTE IMMEDIATE lv_sql5;
2882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS MERGED :'||SQL%ROWCOUNT);
2883: COMMIT;
2884: ELSE -- for target Coll

Line 2882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS MERGED :'||SQL%ROWCOUNT);

2878: 0, d.RESERVATION_QUANTITY,
2879: d.old_reservation_quantity) ');
2880: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
2881: EXECUTE IMMEDIATE lv_sql5;
2882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS MERGED :'||SQL%ROWCOUNT);
2883: COMMIT;
2884: ELSE -- for target Coll
2885: lv_sql5 := ' INSERT INTO '||lv_tbl||' d '
2886: || lv_sql3

Line 2893: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);

2889: lv_sql5 := REPLACE (lv_sql5,'xxx_ROW_TYPE',1);
2890: lv_sql5 := REPLACE (lv_sql5,'xxx_RESERVATION_QUANTITY',' decode (s.COMPLETED_QUANTITY,
2891: 0, d.RESERVATION_QUANTITY,
2892: d.old_reservation_quantity) ');
2893: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
2894: EXECUTE IMMEDIATE lv_sql5;
2895: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS INSERTED :'||SQL%ROWCOUNT);
2896: COMMIT;
2897: END IF;

Line 2895: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS INSERTED :'||SQL%ROWCOUNT);

2891: 0, d.RESERVATION_QUANTITY,
2892: d.old_reservation_quantity) ');
2893: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
2894: EXECUTE IMMEDIATE lv_sql5;
2895: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS INSERTED :'||SQL%ROWCOUNT);
2896: COMMIT;
2897: END IF;
2898: -- end row type 1
2899:

Line 2915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);

2911: || lv_sql3
2912: ||lv_sql4;
2913: lv_sql5 := REPLACE (lv_sql5,'xxx_ROW_TYPE',2);
2914: lv_sql5 := REPLACE (lv_sql5,'xxx_RESERVATION_QUANTITY','d.RESERVATION_QUANTITY');
2915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
2916: EXECUTE IMMEDIATE lv_sql5;
2917: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS MERGED :'||SQL%ROWCOUNT);
2918: COMMIT;
2919: ELSE -- for target Coll

Line 2917: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS MERGED :'||SQL%ROWCOUNT);

2913: lv_sql5 := REPLACE (lv_sql5,'xxx_ROW_TYPE',2);
2914: lv_sql5 := REPLACE (lv_sql5,'xxx_RESERVATION_QUANTITY','d.RESERVATION_QUANTITY');
2915: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
2916: EXECUTE IMMEDIATE lv_sql5;
2917: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS MERGED :'||SQL%ROWCOUNT);
2918: COMMIT;
2919: ELSE -- for target Coll
2920: lv_sql5 := ' INSERT INTO '||lv_tbl||' d '
2921: || lv_sql3

Line 2930: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);

2926: ) IS NOT NULL '
2927: ;
2928: lv_sql5 := REPLACE (lv_sql5,'xxx_ROW_TYPE',2);
2929: lv_sql5 := REPLACE (lv_sql5,'xxx_RESERVATION_QUANTITY','d.RESERVATION_QUANTITY');
2930: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
2931: EXECUTE IMMEDIATE lv_sql5;
2932: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS INSERTED :'||SQL%ROWCOUNT);
2933: COMMIT;
2934: END IF;

Line 2932: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS INSERTED :'||SQL%ROWCOUNT);

2928: lv_sql5 := REPLACE (lv_sql5,'xxx_ROW_TYPE',2);
2929: lv_sql5 := REPLACE (lv_sql5,'xxx_RESERVATION_QUANTITY','d.RESERVATION_QUANTITY');
2930: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
2931: EXECUTE IMMEDIATE lv_sql5;
2932: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS INSERTED :'||SQL%ROWCOUNT);
2933: COMMIT;
2934: END IF;
2935: -- Update Reservation Qty
2936:

Line 2943: and msso.deleted_flag=MSC_UTIL.SYS_NO )

2939: where msso.sr_instance_id= MSC_CL_COLLECTION.v_instance_id
2940: AND ROW_TYPE=1
2941: and msso.demand_source_line IS NOT NULL
2942: and msso.reservation_type = 2
2943: and msso.deleted_flag=MSC_UTIL.SYS_NO )
2944: LOOP
2945: UPDATE MSC_SALES_ORDERS
2946: SET RESERVATION_QUANTITY = ( SELECT SUM(NVL(mso.primary_uom_quantity,0))
2947: FROM msc_sales_orders mso

Line 2972: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);

2968: || lv_sql1_1 ||lv_sql1_2 || lv_sql1_3
2969: ;
2970: lv_sql5 := REPLACE (lv_sql5,'xxx_ROW_TYPE',3);
2971: lv_sql5 := REPLACE (lv_sql5,'xxx_RESERVATION_QUANTITY','d.RESERVATION_QUANTITY');
2972: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
2973: EXECUTE IMMEDIATE lv_sql5;
2974: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS INSERTED :'||SQL%ROWCOUNT);
2975: COMMIT;
2976: -- end row type 3

Line 2974: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS INSERTED :'||SQL%ROWCOUNT);

2970: lv_sql5 := REPLACE (lv_sql5,'xxx_ROW_TYPE',3);
2971: lv_sql5 := REPLACE (lv_sql5,'xxx_RESERVATION_QUANTITY','d.RESERVATION_QUANTITY');
2972: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
2973: EXECUTE IMMEDIATE lv_sql5;
2974: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS INSERTED :'||SQL%ROWCOUNT);
2975: COMMIT;
2976: -- end row type 3
2977:
2978: -- row type4

Line 2989: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);

2985: || lv_sql3
2986: ||lv_sql4;
2987: lv_sql5 := REPLACE (lv_sql5,'xxx_ROW_TYPE',4);
2988: lv_sql5 := REPLACE (lv_sql5,'xxx_RESERVATION_QUANTITY','d.RESERVATION_QUANTITY');
2989: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
2990: EXECUTE IMMEDIATE lv_sql5;
2991: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS MERGED :'||SQL%ROWCOUNT);
2992: COMMIT;
2993: ELSE -- for target Coll

Line 2991: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS MERGED :'||SQL%ROWCOUNT);

2987: lv_sql5 := REPLACE (lv_sql5,'xxx_ROW_TYPE',4);
2988: lv_sql5 := REPLACE (lv_sql5,'xxx_RESERVATION_QUANTITY','d.RESERVATION_QUANTITY');
2989: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
2990: EXECUTE IMMEDIATE lv_sql5;
2991: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS MERGED :'||SQL%ROWCOUNT);
2992: COMMIT;
2993: ELSE -- for target Coll
2994: lv_sql5 := ' INSERT INTO '||lv_tbl||' d '
2995: || lv_sql3

Line 3000: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);

2996: || lv_sql1_1 ||lv_sql1_2 || lv_sql1_3
2997: ;
2998: lv_sql5 := REPLACE (lv_sql5,'xxx_ROW_TYPE',4);
2999: lv_sql5 := REPLACE (lv_sql5,'xxx_RESERVATION_QUANTITY','d.RESERVATION_QUANTITY');
3000: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
3001: EXECUTE IMMEDIATE lv_sql5;
3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS INSERTED :'||SQL%ROWCOUNT);
3003: COMMIT;
3004: END IF;

Line 3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS INSERTED :'||SQL%ROWCOUNT);

2998: lv_sql5 := REPLACE (lv_sql5,'xxx_ROW_TYPE',4);
2999: lv_sql5 := REPLACE (lv_sql5,'xxx_RESERVATION_QUANTITY','d.RESERVATION_QUANTITY');
3000: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Stmt Executed :'||lv_sql5);
3001: EXECUTE IMMEDIATE lv_sql5;
3002: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ROWS INSERTED :'||SQL%ROWCOUNT);
3003: COMMIT;
3004: END IF;
3005: -- end row type 4
3006:

Line 3021: /* MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

3017: /*
3018:
3019: IF SQLCODE <> -54 THEN /* NO_WAIT failed */
3020:
3021: /* MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3022:
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3024: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3025: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');

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

3019: IF SQLCODE <> -54 THEN /* NO_WAIT failed */
3020:
3021: /* MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3022:
3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3024: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3025: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
3026: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/

Line 3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/

3023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3024: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3025: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SALES_ORDER');
3026: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SALES_ORDERS');
3027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3028:
3029: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3030: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3031: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));

Line 3032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/

3028:
3029: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3030: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3031: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.item_name( c_rec.INVENTORY_ITEM_ID));
3032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3033:
3034: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3036: FND_MESSAGE.SET_TOKEN('VALUE',

Line 3043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/

3039:
3040: /* FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3041: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_ID');
3042: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.SR_DEMAND_ID));
3043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);*/
3044:
3045: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
3046: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3047: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');

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

3045: /* IF c_rec.SALES_ORDER_NUMBER IS NOT NULL THEN
3046: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3047: FND_MESSAGE.SET_TOKEN('COLUMN', 'SALES_ORDER_NUMBER');
3048: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SALES_ORDER_NUMBER);
3049: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3050: END IF;*/
3051:
3052: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3053: RAISE;

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

3048: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.SALES_ORDER_NUMBER);
3049: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3050: END IF;*/
3051:
3052: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3053: RAISE;
3054:
3055: /* END IF;*/
3056:

Line 3087: AND mshr.DELETED_FLAG= MSC_UTIL.SYS_NO

3083: mshr.DEMAND_SOURCE_LINE_ID
3084: FROM MSC_ITEM_ID_LID t1, /* bug fix 1084440 */
3085: MSC_ST_RESERVATIONS mshr
3086: WHERE mshr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3087: AND mshr.DELETED_FLAG= MSC_UTIL.SYS_NO
3088: AND t1.SR_INVENTORY_ITEM_ID= mshr.INVENTORY_ITEM_ID
3089: AND t1.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
3090:
3091: Cursor c1_d IS

Line 3103: AND DELETED_FLAG= MSC_UTIL.SYS_YES ; /* Changed For Bug 6144734 */

3099: DISPOSITION_ID,
3100: DISPOSITION_TYPE
3101: FROM MSC_ST_RESERVATIONS mshr
3102: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3103: AND DELETED_FLAG= MSC_UTIL.SYS_YES ; /* Changed For Bug 6144734 */
3104:
3105: c_count NUMBER:= 0;
3106: print_all_debug_msg boolean := TRUE; -- BUG 12740169
3107: BEGIN

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

3110: -- We want to delete all HARD_RESERV related data and get new stuff.
3111:
3112: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
3113:
3114: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3115: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
3116: ELSE
3117: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3118: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

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

3113:
3114: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3115: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
3116: ELSE
3117: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3118: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
3119: END IF;
3120:
3121: END IF;

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

3320: WHEN OTHERS THEN
3321:
3322: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3323:
3324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3325: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3326: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3327: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3328: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3325: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3326: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3327: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3328: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3329:
3330: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3331: RAISE;
3332:

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

3326: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3327: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3328: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3329:
3330: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3331: RAISE;
3332:
3333: ELSE
3334:

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

3331: RAISE;
3332:
3333: ELSE
3334:
3335: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3336: IF (print_all_debug_msg) THEN
3337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3338: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3339: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');

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

3333: ELSE
3334:
3335: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3336: IF (print_all_debug_msg) THEN
3337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3338: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3339: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3340: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3341: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3338: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3339: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_HARD_RESERVATION');
3340: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESERVATIONS');
3341: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3342:
3343: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3344: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3345: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));

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

3342:
3343: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3344: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');
3345: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( c_rec.INVENTORY_ITEM_ID));
3346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3347:
3348: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3349: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3350: FND_MESSAGE.SET_TOKEN('VALUE',

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

3349: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3350: FND_MESSAGE.SET_TOKEN('VALUE',
3351: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3352: MSC_CL_COLLECTION.v_instance_id));
3353: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3354:
3355: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3356: FND_MESSAGE.SET_TOKEN('COLUMN', 'TRANSACTION_ID');
3357: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));

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

3354:
3355: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3356: FND_MESSAGE.SET_TOKEN('COLUMN', 'TRANSACTION_ID');
3357: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.TRANSACTION_ID));
3358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3359:
3360: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3361: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3362: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));

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

3359:
3360: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3361: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3362: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));
3363: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3364:
3365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3366: END IF;
3367: -- bug12740169

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

3361: FND_MESSAGE.SET_TOKEN('COLUMN', 'DISPOSITION_ID');
3362: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(c_rec.DISPOSITION_ID));
3363: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3364:
3365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3366: END IF;
3367: -- bug12740169
3368: -- We would print all messages only when the profile option
3369: -- 'MSC:Coll Error Debug Mode' is set to DEV.

Line 3374: MSC_UTIL.Check_MSG_Level (MSC_UTIL.G_LVL_DEV)) THEN

3370: -- Otherwise, we will print only the 1st occurance of
3371: -- of the error.
3372:
3373: IF (print_all_debug_msg AND
3374: MSC_UTIL.Check_MSG_Level (MSC_UTIL.G_LVL_DEV)) THEN
3375: print_all_debug_msg := TRUE;
3376: ELSE
3377: IF (print_all_debug_msg) THEN
3378:

Line 3379: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

3375: print_all_debug_msg := TRUE;
3376: ELSE
3377: IF (print_all_debug_msg) THEN
3378:
3379: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
3380: 'Stopping the printing of more warnings in ' ||
3381: ' log file for PROCEDURE LOAD_HARD_RESERVATION');
3382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
3383: 'Please set profile "MSC:Coll Error Debug Mode"' ||

Line 3382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,

3378:
3379: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
3380: 'Stopping the printing of more warnings in ' ||
3381: ' log file for PROCEDURE LOAD_HARD_RESERVATION');
3382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
3383: 'Please set profile "MSC:Coll Error Debug Mode"' ||
3384: ' to DEV to see all warnings.');
3385: END IF;
3386: print_all_debug_msg := FALSE;

Line 3435: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES; */

3431: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
3432: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
3433: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3434: AND designator_type <> 6 -- Added This condition for Bug# 2022521
3435: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES; */
3436:
3437:
3438: lv_sql_stmt:= 'UPDATE MSC_DESIGNATORS '
3439: ||' SET DISABLE_DATE = :v_current_date, '

Line 3452: ||' AND COLLECTED_FLAG = '||MSC_UTIL.SYS_YES;

3448: ||'(designator_type = (select decode(mps,1,2,-1) '
3449: ||' from msc_coll_parameters '
3450: ||' where instance_id = :v_instance_id)) '
3451: ||' ) '
3452: ||' AND COLLECTED_FLAG = '||MSC_UTIL.SYS_YES;
3453:
3454: if MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS then
3455:
3456: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_COLLECTION.v_current_date,

Line 3454: if MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS then

3450: ||' where instance_id = :v_instance_id)) '
3451: ||' ) '
3452: ||' AND COLLECTED_FLAG = '||MSC_UTIL.SYS_YES;
3453:
3454: if MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS then
3455:
3456: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_COLLECTION.v_current_date,
3457: MSC_CL_COLLECTION.v_last_collection_id,
3458: MSC_CL_COLLECTION.v_current_date,

Line 3462: lv_sql_stmt :=lv_sql_stmt||' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

3458: MSC_CL_COLLECTION.v_current_date,
3459: MSC_CL_COLLECTION.v_current_user,
3460: MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_id,MSC_CL_COLLECTION.v_instance_id;
3461: else
3462: lv_sql_stmt :=lv_sql_stmt||' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3463:
3464: EXECUTE IMMEDIATE lv_sql_stmt USING MSC_CL_COLLECTION.v_current_date,
3465: MSC_CL_COLLECTION.v_last_collection_id,
3466: MSC_CL_COLLECTION.v_current_date,

Line 3498: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;

3494: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
3495: WHERE DESIGNATOR= c_rec.DESIGNATOR
3496: AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
3497: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3498: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
3499:
3500: IF SQL%NOTFOUND THEN
3501:
3502: INSERT INTO MSC_DESIGNATORS

Line 3535: MSC_UTIL.SYS_YES,

3531: c_rec.ORGANIZATION_SELECTION,
3532: c_rec.PRODUCTION,
3533: c_rec.RECOMMENDATION_RELEASE,
3534: c_rec.DESIGNATOR_TYPE,
3535: MSC_UTIL.SYS_YES,
3536: c_rec.SR_INSTANCE_ID,
3537: MSC_CL_COLLECTION.v_last_collection_id,
3538: MSC_CL_COLLECTION.v_current_date,
3539: MSC_CL_COLLECTION.v_current_user,

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

3553: WHEN OTHERS THEN
3554:
3555: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3556:
3557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3562:
3563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3564: RAISE;
3565:

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

3559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3562:
3563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3564: RAISE;
3565:
3566: ELSE
3567: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

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

3563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3564: RAISE;
3565:
3566: ELSE
3567: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3568:
3569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3570: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3571: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');

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

3565:
3566: ELSE
3567: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3568:
3569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3570: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3571: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3572: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

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

3569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3570: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3571: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DESIGNATOR');
3572: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DESIGNATORS');
3573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3574:
3575: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3576: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3577: FND_MESSAGE.SET_TOKEN('VALUE',

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

3576: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3577: FND_MESSAGE.SET_TOKEN('VALUE',
3578: MSC_GET_NAME.ORG_CODE( c_rec.ORGANIZATION_ID,
3579: MSC_CL_COLLECTION.v_instance_id));
3580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3581:
3582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3583: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3584: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);

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

3581:
3582: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3583: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3584: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
3585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3586:
3587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3588: END IF;
3589:

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

3583: FND_MESSAGE.SET_TOKEN('COLUMN', 'DESIGNATOR');
3584: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.DESIGNATOR);
3585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3586:
3587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3588: END IF;
3589:
3590: END;
3591:

Line 3610: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl

3606: BEGIN
3607:
3608: lv_temp_demand_tbl := 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
3609: lv_sql_stmt:=
3610: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl
3611: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS '
3612: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
3613: ||' AND plan_id = -1 '
3614: ||' AND (' ;--( origination_type NOT IN (';

Line 3611: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS '

3607:
3608: lv_temp_demand_tbl := 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
3609: lv_sql_stmt:=
3610: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl
3611: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS '
3612: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
3613: ||' AND plan_id = -1 '
3614: ||' AND (' ;--( origination_type NOT IN (';
3615:

Line 3616: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'PREC Flag is ' || TO_CHAR(MSC_CL_COLLECTION.v_coll_prec.mds_flag));

3612: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
3613: ||' AND plan_id = -1 '
3614: ||' AND (' ;--( origination_type NOT IN (';
3615:
3616: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'PREC Flag is ' || TO_CHAR(MSC_CL_COLLECTION.v_coll_prec.mds_flag));
3617:
3618: -- MSC_CL_PULL.GET_DEPOT_ORG_STRINGS(MSC_CL_COLLECTION.v_instance_id); -- For Bug 5909379
3619: -- MSC_UTIL.v_depot_org_str := MSC_CL_PULL.g_depot_org_str;
3620: -- MSC_UTIL.v_non_depot_org_str := MSC_CL_PULL.g_non_depot_org_str;

Line 3619: -- MSC_UTIL.v_depot_org_str := MSC_CL_PULL.g_depot_org_str;

3615:
3616: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'PREC Flag is ' || TO_CHAR(MSC_CL_COLLECTION.v_coll_prec.mds_flag));
3617:
3618: -- MSC_CL_PULL.GET_DEPOT_ORG_STRINGS(MSC_CL_COLLECTION.v_instance_id); -- For Bug 5909379
3619: -- MSC_UTIL.v_depot_org_str := MSC_CL_PULL.g_depot_org_str;
3620: -- MSC_UTIL.v_non_depot_org_str := MSC_CL_PULL.g_non_depot_org_str;
3621:
3622:
3623: IF MSC_CL_COLLECTION.v_coll_prec.mds_flag = MSC_UTIL.SYS_YES THEN

Line 3620: -- MSC_UTIL.v_non_depot_org_str := MSC_CL_PULL.g_non_depot_org_str;

3616: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'PREC Flag is ' || TO_CHAR(MSC_CL_COLLECTION.v_coll_prec.mds_flag));
3617:
3618: -- MSC_CL_PULL.GET_DEPOT_ORG_STRINGS(MSC_CL_COLLECTION.v_instance_id); -- For Bug 5909379
3619: -- MSC_UTIL.v_depot_org_str := MSC_CL_PULL.g_depot_org_str;
3620: -- MSC_UTIL.v_non_depot_org_str := MSC_CL_PULL.g_non_depot_org_str;
3621:
3622:
3623: IF MSC_CL_COLLECTION.v_coll_prec.mds_flag = MSC_UTIL.SYS_YES THEN
3624: if (MSC_CL_COLLECTION.v_is_cont_refresh) then

Line 3623: IF MSC_CL_COLLECTION.v_coll_prec.mds_flag = MSC_UTIL.SYS_YES THEN

3619: -- MSC_UTIL.v_depot_org_str := MSC_CL_PULL.g_depot_org_str;
3620: -- MSC_UTIL.v_non_depot_org_str := MSC_CL_PULL.g_non_depot_org_str;
3621:
3622:
3623: IF MSC_CL_COLLECTION.v_coll_prec.mds_flag = MSC_UTIL.SYS_YES THEN
3624: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3625: if (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_TGT) then
3626: lv_where_clause := '6,7,8,15,24';
3627: end if;

Line 3625: if (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_TGT) then

3621:
3622:
3623: IF MSC_CL_COLLECTION.v_coll_prec.mds_flag = MSC_UTIL.SYS_YES THEN
3624: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3625: if (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_TGT) then
3626: lv_where_clause := '6,7,8,15,24';
3627: end if;
3628: else
3629: lv_where_clause := '6,7,8,15,24';

Line 3634: IF (MSC_CL_COLLECTION.v_coll_prec.payback_demand_supply_flag = MSC_UTIL.SYS_YES) THEN

3630: end if;
3631: END IF;
3632:
3633:
3634: IF (MSC_CL_COLLECTION.v_coll_prec.payback_demand_supply_flag = MSC_UTIL.SYS_YES) THEN
3635: IF (lv_where_clause IS NULL) THEN
3636: lv_where_clause := '27';
3637: ELSE
3638: lv_where_clause := lv_where_clause||', 27';

Line 3642: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) THEN

3638: lv_where_clause := lv_where_clause||', 27';
3639: END IF;
3640: END IF;
3641:
3642: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) THEN
3643: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3644: if (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then
3645: IF (lv_where_clause IS NULL) THEN
3646: lv_where_clause := '2,3,4,25,50';

Line 3644: if (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then

3640: END IF;
3641:
3642: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) THEN
3643: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3644: if (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT) then
3645: IF (lv_where_clause IS NULL) THEN
3646: lv_where_clause := '2,3,4,25,50';
3647: ELSE
3648: lv_where_clause := lv_where_clause||', 2,3,4,25,50';

Line 3662: IF (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_YES)

3658: END IF;
3659:
3660: lv_add_whr_clause := '';
3661:
3662: IF (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_YES)
3663: AND (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_NO) THEN
3664: lv_add_whr_clause := ' NOT ( origination_type =92 '
3665: ||' AND MAINTENANCE_OBJECT_SOURCE =2 ) ' ;
3666: ELSIF (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)

Line 3663: AND (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_NO) THEN

3659:
3660: lv_add_whr_clause := '';
3661:
3662: IF (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_YES)
3663: AND (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_NO) THEN
3664: lv_add_whr_clause := ' NOT ( origination_type =92 '
3665: ||' AND MAINTENANCE_OBJECT_SOURCE =2 ) ' ;
3666: ELSIF (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)
3667: AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_NO) THEN

Line 3666: ELSIF (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)

3662: IF (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_YES)
3663: AND (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_NO) THEN
3664: lv_add_whr_clause := ' NOT ( origination_type =92 '
3665: ||' AND MAINTENANCE_OBJECT_SOURCE =2 ) ' ;
3666: ELSIF (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)
3667: AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_NO) THEN
3668: lv_add_whr_clause := ' NOT ( origination_type =92 '
3669: ||' AND MAINTENANCE_OBJECT_SOURCE =1 ) ' ;
3670: ELSIF (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)

Line 3667: AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_NO) THEN

3663: AND (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_NO) THEN
3664: lv_add_whr_clause := ' NOT ( origination_type =92 '
3665: ||' AND MAINTENANCE_OBJECT_SOURCE =2 ) ' ;
3666: ELSIF (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)
3667: AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_NO) THEN
3668: lv_add_whr_clause := ' NOT ( origination_type =92 '
3669: ||' AND MAINTENANCE_OBJECT_SOURCE =1 ) ' ;
3670: ELSIF (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)
3671: AND (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES) THEN

Line 3670: ELSIF (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)

3666: ELSIF (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)
3667: AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_NO) THEN
3668: lv_add_whr_clause := ' NOT ( origination_type =92 '
3669: ||' AND MAINTENANCE_OBJECT_SOURCE =1 ) ' ;
3670: ELSIF (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)
3671: AND (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES) THEN
3672: lv_add_whr_clause := ' NOT(origination_type =92)' ;
3673:
3674: END IF;

Line 3671: AND (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES) THEN

3667: AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_NO) THEN
3668: lv_add_whr_clause := ' NOT ( origination_type =92 '
3669: ||' AND MAINTENANCE_OBJECT_SOURCE =1 ) ' ;
3670: ELSIF (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)
3671: AND (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES) THEN
3672: lv_add_whr_clause := ' NOT(origination_type =92)' ;
3673:
3674: END IF;
3675:

Line 3676: IF (MSC_CL_COLLECTION.v_coll_prec.forecast_flag = MSC_UTIL.SYS_YES) THEN

3672: lv_add_whr_clause := ' NOT(origination_type =92)' ;
3673:
3674: END IF;
3675:
3676: IF (MSC_CL_COLLECTION.v_coll_prec.forecast_flag = MSC_UTIL.SYS_YES) THEN
3677: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3678: if (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_TGT) then
3679: IF (lv_where_clause IS NULL) THEN
3680: lv_where_clause := '29';

Line 3678: if (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_TGT) then

3674: END IF;
3675:
3676: IF (MSC_CL_COLLECTION.v_coll_prec.forecast_flag = MSC_UTIL.SYS_YES) THEN
3677: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3678: if (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_TGT) then
3679: IF (lv_where_clause IS NULL) THEN
3680: lv_where_clause := '29';
3681: ELSE
3682: lv_where_clause := lv_where_clause||', 29';

Line 3694: IF (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) THEN

3690: END IF;
3691: end if;
3692: END IF;
3693:
3694: IF (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) THEN
3695: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3696: if (MSC_CL_COLLECTION.v_coll_prec.udmd_sn_flag = MSC_UTIL.SYS_TGT) then
3697: IF (lv_where_clause IS NULL) THEN
3698: lv_where_clause := '42';

Line 3696: if (MSC_CL_COLLECTION.v_coll_prec.udmd_sn_flag = MSC_UTIL.SYS_TGT) then

3692: END IF;
3693:
3694: IF (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) THEN
3695: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3696: if (MSC_CL_COLLECTION.v_coll_prec.udmd_sn_flag = MSC_UTIL.SYS_TGT) then
3697: IF (lv_where_clause IS NULL) THEN
3698: lv_where_clause := '42';
3699: ELSE
3700: lv_where_clause := lv_where_clause||', 42';

Line 3715: IF (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES) THEN

3711:
3712:
3713:
3714:
3715: IF (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES) THEN
3716:
3717: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3718: NULL;
3719: Else

Line 3731: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES) THEN

3727:
3728: end if;
3729: END IF; -- Additions for 5909379 for SRP
3730:
3731: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES) THEN
3732:
3733: if (MSC_CL_COLLECTION.v_is_cont_refresh) then
3734: NULL;
3735: Else

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

3745: END IF; -- Additions for 5909379 for SRP
3746:
3747: /* lv_sql_stmt := lv_sql_stmt||lv_where_clause ||' )'||lv_add_whr_clause ||' )';
3748:
3749: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3750: null;
3751: ELSE*/
3752:
3753: IF NOT MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

Line 3753: IF NOT MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

3749: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3750: null;
3751: ELSE*/
3752:
3753: IF NOT MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3754: lv_sql_stmt := lv_sql_stmt||' organization_id NOT '||MSC_UTIL.v_in_org_str;
3755: END IF;
3756:
3757: IF NOT MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS

Line 3754: lv_sql_stmt := lv_sql_stmt||' organization_id NOT '||MSC_UTIL.v_in_org_str;

3750: null;
3751: ELSE*/
3752:
3753: IF NOT MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3754: lv_sql_stmt := lv_sql_stmt||' organization_id NOT '||MSC_UTIL.v_in_org_str;
3755: END IF;
3756:
3757: IF NOT MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS
3758: AND NOT (MSC_CL_COLLECTION.v_is_complete_refresh) THEN

Line 3757: IF NOT MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS

3753: IF NOT MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3754: lv_sql_stmt := lv_sql_stmt||' organization_id NOT '||MSC_UTIL.v_in_org_str;
3755: END IF;
3756:
3757: IF NOT MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS
3758: AND NOT (MSC_CL_COLLECTION.v_is_complete_refresh) THEN
3759: lv_sql_stmt := lv_sql_stmt||' OR ( ';
3760: END IF;
3761:

Line 3779: IF NOT MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN

3775: END IF;
3776:
3777: lv_sql_stmt := lv_sql_stmt||lv_add_whr_clause ;
3778:
3779: IF NOT MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3780: lv_sql_stmt := lv_sql_stmt||' )';
3781: END IF;
3782: END IF;
3783:

Line 3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Load ODS Demand :sql stmt being executed: '||lv_sql_stmt);

3784:
3785: lv_sql_stmt := lv_sql_stmt ||' )';
3786:
3787:
3788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Load ODS Demand :sql stmt being executed: '||lv_sql_stmt);
3789: EXECUTE IMMEDIATE lv_sql_stmt;
3790:
3791: COMMIT;
3792:

Line 3799: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_NO) AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN

3795: IF NOT MSC_CL_COLLECTION.v_is_complete_refresh THEN -- This part of the code should be called only fro Targeted Colelction of repair orders
3796:
3797:
3798:
3799: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_NO) AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
3800:
3801: lv_sql_stmt2 := 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl
3802: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_depot_org_str || ' and sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id || ' and plan_id = -1 ';
3803:

Line 3801: lv_sql_stmt2 := 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl

3797:
3798:
3799: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_NO) AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
3800:
3801: lv_sql_stmt2 := 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl
3802: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_depot_org_str || ' and sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id || ' and plan_id = -1 ';
3803:
3804: EXECUTE IMMEDIATE lv_sql_stmt2;
3805:

Line 3802: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_depot_org_str || ' and sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id || ' and plan_id = -1 ';

3798:
3799: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_NO) AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
3800:
3801: lv_sql_stmt2 := 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl
3802: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_depot_org_str || ' and sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id || ' and plan_id = -1 ';
3803:
3804: EXECUTE IMMEDIATE lv_sql_stmt2;
3805:
3806: Commit ;

Line 3809: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_NO) AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN

3805:
3806: Commit ;
3807: END if ;
3808:
3809: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_NO) AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
3810:
3811: lv_sql_stmt2 := 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl
3812: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_non_depot_org_str || ' and sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id || ' and plan_id = -1 ';
3813:

Line 3811: lv_sql_stmt2 := 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl

3807: END if ;
3808:
3809: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_NO) AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
3810:
3811: lv_sql_stmt2 := 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl
3812: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_non_depot_org_str || ' and sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id || ' and plan_id = -1 ';
3813:
3814: EXECUTE IMMEDIATE lv_sql_stmt2;
3815:

Line 3812: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_non_depot_org_str || ' and sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id || ' and plan_id = -1 ';

3808:
3809: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag = MSC_UTIL.SYS_NO) AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
3810:
3811: lv_sql_stmt2 := 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_temp_demand_tbl
3812: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_DEMANDS Where origination_type =77 and organization_id '||MSC_UTIL.v_non_depot_org_str || ' and sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id || ' and plan_id = -1 ';
3813:
3814: EXECUTE IMMEDIATE lv_sql_stmt2;
3815:
3816: Commit ;

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

3820: ------------------------------------------
3821:
3822: EXCEPTION
3823: WHEN OTHERS THEN
3824: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3825: RAISE;
3826:
3827: END LOAD_ODS_DEMAND;
3828:

Line 3853: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'PREC Flag is ' || TO_CHAR(MSC_CL_COLLECTION.v_coll_prec.mds_flag));

3849: || ' WHERE sr_instance_id = '
3850: || MSC_CL_COLLECTION.v_instance_id
3851: || ' AND plan_id = -1 '; -- ||' AND ( origination_type NOT IN (';
3852:
3853: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'PREC Flag is ' || TO_CHAR(MSC_CL_COLLECTION.v_coll_prec.mds_flag));
3854:
3855: -- MSC_CL_PULL.GET_DEPOT_ORG_STRINGS(MSC_CL_COLLECTION.v_instance_id); -- For Bug 5909379
3856: -- MSC_UTIL.v_depot_org_str := MSC_CL_PULL.g_depot_org_str;
3857: -- MSC_UTIL.v_non_depot_org_str := MSC_CL_PULL.g_non_depot_org_str;

Line 3856: -- MSC_UTIL.v_depot_org_str := MSC_CL_PULL.g_depot_org_str;

3852:
3853: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'PREC Flag is ' || TO_CHAR(MSC_CL_COLLECTION.v_coll_prec.mds_flag));
3854:
3855: -- MSC_CL_PULL.GET_DEPOT_ORG_STRINGS(MSC_CL_COLLECTION.v_instance_id); -- For Bug 5909379
3856: -- MSC_UTIL.v_depot_org_str := MSC_CL_PULL.g_depot_org_str;
3857: -- MSC_UTIL.v_non_depot_org_str := MSC_CL_PULL.g_non_depot_org_str;
3858:
3859:
3860: IF MSC_CL_COLLECTION.v_coll_prec.mds_flag = MSC_UTIL.SYS_YES

Line 3857: -- MSC_UTIL.v_non_depot_org_str := MSC_CL_PULL.g_non_depot_org_str;

3853: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'PREC Flag is ' || TO_CHAR(MSC_CL_COLLECTION.v_coll_prec.mds_flag));
3854:
3855: -- MSC_CL_PULL.GET_DEPOT_ORG_STRINGS(MSC_CL_COLLECTION.v_instance_id); -- For Bug 5909379
3856: -- MSC_UTIL.v_depot_org_str := MSC_CL_PULL.g_depot_org_str;
3857: -- MSC_UTIL.v_non_depot_org_str := MSC_CL_PULL.g_non_depot_org_str;
3858:
3859:
3860: IF MSC_CL_COLLECTION.v_coll_prec.mds_flag = MSC_UTIL.SYS_YES
3861: THEN

Line 3860: IF MSC_CL_COLLECTION.v_coll_prec.mds_flag = MSC_UTIL.SYS_YES

3856: -- MSC_UTIL.v_depot_org_str := MSC_CL_PULL.g_depot_org_str;
3857: -- MSC_UTIL.v_non_depot_org_str := MSC_CL_PULL.g_non_depot_org_str;
3858:
3859:
3860: IF MSC_CL_COLLECTION.v_coll_prec.mds_flag = MSC_UTIL.SYS_YES
3861: THEN
3862: IF (MSC_CL_COLLECTION.v_is_cont_refresh)
3863: THEN
3864: IF (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_TGT)

Line 3864: IF (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_TGT)

3860: IF MSC_CL_COLLECTION.v_coll_prec.mds_flag = MSC_UTIL.SYS_YES
3861: THEN
3862: IF (MSC_CL_COLLECTION.v_is_cont_refresh)
3863: THEN
3864: IF (MSC_CL_COLLECTION.v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_TGT)
3865: THEN
3866: lv_collected_ordertypes := '6,7,8,15,24';
3867: END IF;
3868: ELSE

Line 3875: MSC_UTIL.SYS_YES)

3871: END IF;
3872:
3873:
3874: IF (MSC_CL_COLLECTION.v_coll_prec.payback_demand_supply_flag =
3875: MSC_UTIL.SYS_YES)
3876: THEN
3877: IF (lv_collected_ordertypes IS NULL)
3878: THEN
3879: lv_collected_ordertypes := '27';

Line 3885: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES)

3881: lv_collected_ordertypes := lv_collected_ordertypes || ', 27';
3882: END IF;
3883: END IF;
3884:
3885: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES)
3886: THEN
3887: IF (MSC_CL_COLLECTION.v_is_cont_refresh)
3888: THEN
3889: IF (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT)

Line 3889: IF (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT)

3885: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES)
3886: THEN
3887: IF (MSC_CL_COLLECTION.v_is_cont_refresh)
3888: THEN
3889: IF (MSC_CL_COLLECTION.v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_TGT)
3890: THEN
3891: IF (lv_collected_ordertypes IS NULL)
3892: THEN
3893: lv_collected_ordertypes := '2,3,4,25,50';

Line 3911: IF (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_YES)THEN

3907: END IF;
3908: END IF;
3909:
3910: /* lv_add_whr_clause := '';
3911: IF (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_YES)THEN
3912: IF (lv_collected_ordertypes IS NULL) THEN
3913: lv_collected_ordertypes := '50';
3914: ELSE
3915: lv_collected_ordertypes := lv_collected_ordertypes||', 50';

Line 3919: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES)

3915: lv_collected_ordertypes := lv_collected_ordertypes||', 50';
3916: END IF;
3917: END IF;
3918:
3919: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES)
3920: -- AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_NO)
3921: THEN
3922: IF (lv_collected_ordertypes IS NULL)
3923: THEN

Line 3920: -- AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_NO)

3916: END IF;
3917: END IF;
3918:
3919: IF (MSC_CL_COLLECTION.v_coll_prec.wip_flag = MSC_UTIL.SYS_YES)
3920: -- AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_NO)
3921: THEN
3922: IF (lv_collected_ordertypes IS NULL)
3923: THEN
3924: lv_collected_ordertypes := '50';

Line 3930: IF (MSC_CL_COLLECTION.v_coll_prec.forecast_flag = MSC_UTIL.SYS_YES)

3926: lv_collected_ordertypes := lv_collected_ordertypes || ', 50';
3927: END IF;
3928: END IF;
3929:
3930: IF (MSC_CL_COLLECTION.v_coll_prec.forecast_flag = MSC_UTIL.SYS_YES)
3931: THEN
3932: IF (MSC_CL_COLLECTION.v_is_cont_refresh)
3933: THEN
3934: IF (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_TGT)

Line 3934: IF (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_TGT)

3930: IF (MSC_CL_COLLECTION.v_coll_prec.forecast_flag = MSC_UTIL.SYS_YES)
3931: THEN
3932: IF (MSC_CL_COLLECTION.v_is_cont_refresh)
3933: THEN
3934: IF (MSC_CL_COLLECTION.v_coll_prec.fcst_sn_flag = MSC_UTIL.SYS_TGT)
3935: THEN
3936: IF (lv_collected_ordertypes IS NULL)
3937: THEN
3938: lv_collected_ordertypes := '29';

Line 3954: MSC_UTIL.SYS_YES)

3950: END IF;
3951: END IF;
3952:
3953: IF (MSC_CL_COLLECTION.v_coll_prec.user_supply_demand_flag =
3954: MSC_UTIL.SYS_YES)
3955: THEN
3956: IF (MSC_CL_COLLECTION.v_is_cont_refresh)
3957: THEN
3958: IF (MSC_CL_COLLECTION.v_coll_prec.udmd_sn_flag = MSC_UTIL.SYS_TGT)

Line 3958: IF (MSC_CL_COLLECTION.v_coll_prec.udmd_sn_flag = MSC_UTIL.SYS_TGT)

3954: MSC_UTIL.SYS_YES)
3955: THEN
3956: IF (MSC_CL_COLLECTION.v_is_cont_refresh)
3957: THEN
3958: IF (MSC_CL_COLLECTION.v_coll_prec.udmd_sn_flag = MSC_UTIL.SYS_TGT)
3959: THEN
3960: IF (lv_collected_ordertypes IS NULL)
3961: THEN
3962: lv_collected_ordertypes := '42';

Line 3980: MSC_UTIL.SYS_YES)

3976:
3977:
3978:
3979: IF (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag =
3980: MSC_UTIL.SYS_YES)
3981: THEN
3982: IF (MSC_CL_COLLECTION.v_is_cont_refresh)
3983: THEN
3984: NULL;

Line 3996: MSC_UTIL.SYS_YES)

3992: END IF;
3993: END IF; -- Additions for 5909379 for SRP
3994:
3995: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag =
3996: MSC_UTIL.SYS_YES)
3997: THEN
3998: IF (MSC_CL_COLLECTION.v_is_cont_refresh)
3999: THEN
4000: NULL;

Line 4014: MSC_UTIL.SYS_YES)

4010:
4011: /* start of code to prepare lv_collected_entites_filter2
4012:
4013: IF ( (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag =
4014: MSC_UTIL.SYS_YES)
4015: AND (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag =
4016: MSC_UTIL.SYS_YES))
4017: THEN
4018: lv_collected_entites_filter2 := '(origination_type =92)';

Line 4016: MSC_UTIL.SYS_YES))

4012:
4013: IF ( (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag =
4014: MSC_UTIL.SYS_YES)
4015: AND (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag =
4016: MSC_UTIL.SYS_YES))
4017: THEN
4018: lv_collected_entites_filter2 := '(origination_type =92)';
4019: ELSIF ( (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag =
4020: MSC_UTIL.SYS_NO)

Line 4020: MSC_UTIL.SYS_NO)

4016: MSC_UTIL.SYS_YES))
4017: THEN
4018: lv_collected_entites_filter2 := '(origination_type =92)';
4019: ELSIF ( (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag =
4020: MSC_UTIL.SYS_NO)
4021: AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag =
4022: MSC_UTIL.SYS_YES))
4023: THEN
4024: Lv_collected_entites_filter2 :=

Line 4022: MSC_UTIL.SYS_YES))

4018: lv_collected_entites_filter2 := '(origination_type =92)';
4019: ELSIF ( (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag =
4020: MSC_UTIL.SYS_NO)
4021: AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag =
4022: MSC_UTIL.SYS_YES))
4023: THEN
4024: Lv_collected_entites_filter2 :=
4025: '( origination_type =92 AND MAINTENANCE_OBJECT_SOURCE =2 ) ';
4026: ELSIF ( (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag =

Line 4027: MSC_UTIL.SYS_YES)

4023: THEN
4024: Lv_collected_entites_filter2 :=
4025: '( origination_type =92 AND MAINTENANCE_OBJECT_SOURCE =2 ) ';
4026: ELSIF ( (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag =
4027: MSC_UTIL.SYS_YES)
4028: AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag =
4029: MSC_UTIL.SYS_NO))
4030: THEN
4031: lv_collected_entites_filter2 :=

Line 4029: MSC_UTIL.SYS_NO))

4025: '( origination_type =92 AND MAINTENANCE_OBJECT_SOURCE =2 ) ';
4026: ELSIF ( (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag =
4027: MSC_UTIL.SYS_YES)
4028: AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag =
4029: MSC_UTIL.SYS_NO))
4030: THEN
4031: lv_collected_entites_filter2 :=
4032: '( origination_type =92 AND MAINTENANCE_OBJECT_SOURCE =1 ) ';
4033: ELSIF ( (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag =

Line 4034: MSC_UTIL.SYS_NO)

4030: THEN
4031: lv_collected_entites_filter2 :=
4032: '( origination_type =92 AND MAINTENANCE_OBJECT_SOURCE =1 ) ';
4033: ELSIF ( (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag =
4034: MSC_UTIL.SYS_NO)
4035: AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag =
4036: MSC_UTIL.SYS_NO))
4037: THEN
4038: lv_collected_entites_filter2 := NULL;

Line 4036: MSC_UTIL.SYS_NO))

4032: '( origination_type =92 AND MAINTENANCE_OBJECT_SOURCE =1 ) ';
4033: ELSIF ( (MSC_CL_COLLECTION.v_coll_prec.eam_forecasts_flag =
4034: MSC_UTIL.SYS_NO)
4035: AND (MSC_CL_COLLECTION.v_coll_prec.cmro_forecasts_flag =
4036: MSC_UTIL.SYS_NO))
4037: THEN
4038: lv_collected_entites_filter2 := NULL;
4039: END IF;
4040:

Line 4047: MSC_UTIL.G_ALL_ORGANIZATIONS)

4043: /* start of code to prepare lv_copySQL_variablepart
4044: firstcondn := TRUE;
4045:
4046: IF (NOT MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
4047: MSC_UTIL.G_ALL_ORGANIZATIONS)
4048: THEN
4049: IF (NOT firstcondn)
4050: THEN
4051: lv_copySQL_variablepart := lv_copySQL_variablepart || ' AND ';

Line 4055: '(ORGANIZATION_ID NOT ' || MSC_UTIL.v_in_org_str || ')';

4051: lv_copySQL_variablepart := lv_copySQL_variablepart || ' AND ';
4052: END IF;
4053:
4054: lv_copySQL_variablepart :=
4055: '(ORGANIZATION_ID NOT ' || MSC_UTIL.v_in_org_str || ')';
4056: firstcondn := FALSE;
4057: END IF;
4058:
4059: IF NOT ( MSC_CL_COLLECTION.v_is_complete_refresh)

Line 4109: MSC_UTIL.LOG_MSG (

4105: || lv_copySQL_variablepart
4106: || ')';
4107: END IF;
4108:
4109: MSC_UTIL.LOG_MSG (
4110: MSC_UTIL.G_D_STATUS,
4111: 'Load ODS demands : lv_copySQL_variablepart -'
4112: || lv_copySQL_variablepart);
4113: MSC_UTIL.LOG_MSG (

Line 4110: MSC_UTIL.G_D_STATUS,

4106: || ')';
4107: END IF;
4108:
4109: MSC_UTIL.LOG_MSG (
4110: MSC_UTIL.G_D_STATUS,
4111: 'Load ODS demands : lv_copySQL_variablepart -'
4112: || lv_copySQL_variablepart);
4113: MSC_UTIL.LOG_MSG (
4114: MSC_UTIL.G_D_STATUS,

Line 4113: MSC_UTIL.LOG_MSG (

4109: MSC_UTIL.LOG_MSG (
4110: MSC_UTIL.G_D_STATUS,
4111: 'Load ODS demands : lv_copySQL_variablepart -'
4112: || lv_copySQL_variablepart);
4113: MSC_UTIL.LOG_MSG (
4114: MSC_UTIL.G_D_STATUS,
4115: 'Load ODS demandds :sql stmt being executed: ' || lv_sql_stmt);
4116:
4117: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS,'Load ODS demand : lv_copySQL_variablepart -' || lv_copySQL_variablepart);

Line 4114: MSC_UTIL.G_D_STATUS,

4110: MSC_UTIL.G_D_STATUS,
4111: 'Load ODS demands : lv_copySQL_variablepart -'
4112: || lv_copySQL_variablepart);
4113: MSC_UTIL.LOG_MSG (
4114: MSC_UTIL.G_D_STATUS,
4115: 'Load ODS demandds :sql stmt being executed: ' || lv_sql_stmt);
4116:
4117: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS,'Load ODS demand : lv_copySQL_variablepart -' || lv_copySQL_variablepart);
4118: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS, 'Load ODS demand :sql stmt being executed: ' || lv_sql_stmt);

Line 4117: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS,'Load ODS demand : lv_copySQL_variablepart -' || lv_copySQL_variablepart);

4113: MSC_UTIL.LOG_MSG (
4114: MSC_UTIL.G_D_STATUS,
4115: 'Load ODS demandds :sql stmt being executed: ' || lv_sql_stmt);
4116:
4117: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS,'Load ODS demand : lv_copySQL_variablepart -' || lv_copySQL_variablepart);
4118: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS, 'Load ODS demand :sql stmt being executed: ' || lv_sql_stmt);
4119: EXECUTE IMMEDIATE lv_sql_stmt;
4120:
4121: COMMIT;

Line 4118: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS, 'Load ODS demand :sql stmt being executed: ' || lv_sql_stmt);

4114: MSC_UTIL.G_D_STATUS,
4115: 'Load ODS demandds :sql stmt being executed: ' || lv_sql_stmt);
4116:
4117: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS,'Load ODS demand : lv_copySQL_variablepart -' || lv_copySQL_variablepart);
4118: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS, 'Load ODS demand :sql stmt being executed: ' || lv_sql_stmt);
4119: EXECUTE IMMEDIATE lv_sql_stmt;
4120:
4121: COMMIT;
4122:

Line 4128: MSC_UTIL.SYS_YES)

4124: ---------------------------------------
4125: IF NOT MSC_CL_COLLECTION.v_is_complete_refresh
4126: THEN -- This part of the code should be called only fro Targeted Colelction of repair orders
4127: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag =
4128: MSC_UTIL.SYS_YES)
4129: AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag =
4130: MSC_UTIL.SYS_NO)
4131: AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y')
4132: THEN

Line 4130: MSC_UTIL.SYS_NO)

4126: THEN -- This part of the code should be called only fro Targeted Colelction of repair orders
4127: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag =
4128: MSC_UTIL.SYS_YES)
4129: AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag =
4130: MSC_UTIL.SYS_NO)
4131: AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y')
4132: THEN
4133: lv_sql_stmt2 :=
4134: 'INSERT INTO '

Line 4131: AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y')

4127: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag =
4128: MSC_UTIL.SYS_YES)
4129: AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag =
4130: MSC_UTIL.SYS_NO)
4131: AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y')
4132: THEN
4133: lv_sql_stmt2 :=
4134: 'INSERT INTO '
4135: || lv_temp_demand_tbl

Line 4137: || MSC_UTIL.v_depot_org_str

4133: lv_sql_stmt2 :=
4134: 'INSERT INTO '
4135: || lv_temp_demand_tbl
4136: || ' SELECT * from MSC_DEMANDS Where origination_type =77 and organization_id '
4137: || MSC_UTIL.v_depot_org_str
4138: || ' and sr_instance_id = '
4139: || MSC_CL_COLLECTION.v_instance_id
4140: || ' and plan_id = -1 ';
4141:

Line 4148: MSC_UTIL.SYS_NO)

4144: COMMIT;
4145: END IF;
4146:
4147: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag =
4148: MSC_UTIL.SYS_NO)
4149: AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag =
4150: MSC_UTIL.SYS_YES)
4151: AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y')
4152: THEN

Line 4150: MSC_UTIL.SYS_YES)

4146:
4147: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag =
4148: MSC_UTIL.SYS_NO)
4149: AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag =
4150: MSC_UTIL.SYS_YES)
4151: AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y')
4152: THEN
4153: lv_sql_stmt2 :=
4154: 'INSERT INTO '

Line 4151: AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y')

4147: IF (MSC_CL_COLLECTION.v_coll_prec.external_repair_flag =
4148: MSC_UTIL.SYS_NO)
4149: AND (MSC_CL_COLLECTION.v_coll_prec.internal_repair_flag =
4150: MSC_UTIL.SYS_YES)
4151: AND (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y')
4152: THEN
4153: lv_sql_stmt2 :=
4154: 'INSERT INTO '
4155: || lv_temp_demand_tbl

Line 4157: || MSC_UTIL.v_non_depot_org_str

4153: lv_sql_stmt2 :=
4154: 'INSERT INTO '
4155: || lv_temp_demand_tbl
4156: || ' SELECT * from MSC_DEMANDS Where origination_type =77 and organization_id '
4157: || MSC_UTIL.v_non_depot_org_str
4158: || ' and sr_instance_id = '
4159: || MSC_CL_COLLECTION.v_instance_id
4160: || ' and plan_id = -1 ';
4161:

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

4168:
4169: EXCEPTION
4170: WHEN OTHERS
4171: THEN
4172: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS, SQLERRM);
4173: RAISE;
4174: END LOAD_ODS_DEMAND;*/
4175:
4176: PROCEDURE LOAD_PAYBACK_DEMANDS IS

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

4178: lv_sql_ins VARCHAR2(32767);
4179: LV_SUPPLY_TBL VARCHAR2(1000);
4180: BEGIN
4181:
4182: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
4183: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
4184: ELSE
4185: lv_tbl:= 'MSC_DEMANDS';
4186: END IF;

Line 4230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,lv_sql_ins);

4226: FROM MSC_ST_OPEN_PAYBACKS MOP, MSC_ITEM_ID_LID MIIL
4227: WHERE MIIL.SR_INVENTORY_ITEM_ID = MOP.inventory_item_id
4228: AND MIIL.sr_instance_id = MOP.sr_instance_id
4229: AND MOP.sr_instance_id = :v_instance_id';
4230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,lv_sql_ins);
4231: EXECUTE IMMEDIATE lv_sql_ins
4232: USING MSC_CL_COLLECTION.v_current_date,
4233: MSC_CL_COLLECTION.v_current_user,
4234: MSC_CL_COLLECTION.v_current_date,

Line 4237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'rows inserted :- '||SQL%ROWCOUNT);

4233: MSC_CL_COLLECTION.v_current_user,
4234: MSC_CL_COLLECTION.v_current_date,
4235: MSC_CL_COLLECTION.v_current_user,
4236: MSC_CL_COLLECTION.v_instance_id;
4237: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'rows inserted :- '||SQL%ROWCOUNT);
4238:
4239: COMMIT;
4240:
4241: END LOAD_PAYBACK_DEMANDS;