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.INV_MGD_PURGE_CP dependencies on INV_ORGHIERARCHY_PVT

Line 121: l_org_code_list INV_ORGHIERARCHY_PVT.OrgID_tbl_type;

117: p_purge_name IN VARCHAR2,
118: p_request_limit IN NUMBER)
119: IS
120:
121: l_org_code_list INV_ORGHIERARCHY_PVT.OrgID_tbl_type;
122:
123: l_orgid hr_organization_units.organization_id%TYPE;
124: l_org_name VARCHAR2(240) := NULL;
125: l_purge_req_id NUMBER;

Line 158: INV_ORGHIERARCHY_PVT.Log_Initialize;

154:
155: BEGIN
156:
157: -- initialize log
158: INV_ORGHIERARCHY_PVT.Log_Initialize;
159:
160: -- initialize the message stack
161: FND_MSG_PUB.Initialize;
162:

Line 163: INV_ORGHIERARCHY_PVT.Get_Organization_List(p_org_hierarchy_id,

159:
160: -- initialize the message stack
161: FND_MSG_PUB.Initialize;
162:
163: INV_ORGHIERARCHY_PVT.Get_Organization_List(p_org_hierarchy_id,
164: p_org_hier_origin_id,
165: l_org_code_list,
166: 'Y');
167:

Line 179: INV_ORGHIERARCHY_PVT.Log

175:
176: l_orgid := l_org_code_list(l_index);
177:
178: IF G_DEBUG = 'Y' THEN
179: INV_ORGHIERARCHY_PVT.Log
180: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
181: ,'Organization Id: '|| to_char(l_orgid));
182: END IF;
183:

Line 180: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

176: l_orgid := l_org_code_list(l_index);
177:
178: IF G_DEBUG = 'Y' THEN
179: INV_ORGHIERARCHY_PVT.Log
180: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
181: ,'Organization Id: '|| to_char(l_orgid));
182: END IF;
183:
184: -- check whether the request being submitted lies within the request limit

Line 201: -- INV_ORGHIERARCHY_PVT.Log

197: -- OPEN c_org_name(l_orgid);
198: -- FETCH c_org_name
199: -- INTO l_org_name;
200: -- IF (c_org_name%NOTFOUND AND G_DEBUG = 'Y') THEN
201: -- INV_ORGHIERARCHY_PVT.Log
202: -- (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
203: -- ,'Inventory Organization Name not found for'
204: -- || to_char(l_orgid)
205: -- );

Line 202: -- (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

198: -- FETCH c_org_name
199: -- INTO l_org_name;
200: -- IF (c_org_name%NOTFOUND AND G_DEBUG = 'Y') THEN
201: -- INV_ORGHIERARCHY_PVT.Log
202: -- (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
203: -- ,'Inventory Organization Name not found for'
204: -- || to_char(l_orgid)
205: -- );
206: -- END IF;

Line 221: INV_ORGHIERARCHY_PVT.Log

217: -- Handle submission error --
218: RAISE submission_error_except;
219: ELSE
220: IF G_DEBUG = 'Y' THEN
221: INV_ORGHIERARCHY_PVT.Log
222: (INV_ORGHIERARCHY_PVT.G_LOG_EVENT
223: ,'Request Id:' || to_char(l_purge_req_id) ||
224: ' Organization Id:'|| to_char(l_orgid) ||
225: ' Name:' || l_org_name ||

Line 222: (INV_ORGHIERARCHY_PVT.G_LOG_EVENT

218: RAISE submission_error_except;
219: ELSE
220: IF G_DEBUG = 'Y' THEN
221: INV_ORGHIERARCHY_PVT.Log
222: (INV_ORGHIERARCHY_PVT.G_LOG_EVENT
223: ,'Request Id:' || to_char(l_purge_req_id) ||
224: ' Organization Id:'|| to_char(l_orgid) ||
225: ' Name:' || l_org_name ||
226: ' ' || 'Transaction Purge Submitted'

Line 271: INV_ORGHIERARCHY_PVT.Log

267: l_req_num := l_req_num - 1;
268:
269:
270: IF G_DEBUG = 'Y' THEN
271: INV_ORGHIERARCHY_PVT.Log
272: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
273: ,'Request id:' || to_char(l_req_id) || ' Request Status: Completed'
274: );
275: END IF;

Line 272: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

268:
269:
270: IF G_DEBUG = 'Y' THEN
271: INV_ORGHIERARCHY_PVT.Log
272: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
273: ,'Request id:' || to_char(l_req_id) || ' Request Status: Completed'
274: );
275: END IF;
276:

Line 289: INV_ORGHIERARCHY_PVT.Log

285:
286: END LOOP; -- organization list loop
287:
288: IF G_DEBUG = 'Y' THEN
289: INV_ORGHIERARCHY_PVT.Log
290: (INV_ORGHIERARCHY_PVT.G_LOG_EVENT
291: ,'All the purge requests submitted successfully'
292: );
293: END IF;

Line 290: (INV_ORGHIERARCHY_PVT.G_LOG_EVENT

286: END LOOP; -- organization list loop
287:
288: IF G_DEBUG = 'Y' THEN
289: INV_ORGHIERARCHY_PVT.Log
290: (INV_ORGHIERARCHY_PVT.G_LOG_EVENT
291: ,'All the purge requests submitted successfully'
292: );
293: END IF;
294:

Line 312: INV_ORGHIERARCHY_PVT.Log

308: DBMS_LOCK.sleep(l_sleep_time);
309: END LOOP; -- end while
310:
311: IF G_DEBUG = 'Y' THEN
312: INV_ORGHIERARCHY_PVT.Log
313: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
314: , 'All the purge requests completed'
315: );
316: END IF;

Line 313: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

309: END LOOP; -- end while
310:
311: IF G_DEBUG = 'Y' THEN
312: INV_ORGHIERARCHY_PVT.Log
313: ( INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
314: , 'All the purge requests completed'
315: );
316: END IF;
317:

Line 328: INV_ORGHIERARCHY_PVT.Log

324: l_errorcode := SQLCODE;
325: l_errortext := SUBSTR(SQLERRM,1,200);
326:
327: IF G_DEBUG = 'Y' THEN
328: INV_ORGHIERARCHY_PVT.Log
329: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
330: ,'submission error'
331: );
332: INV_ORGHIERARCHY_PVT.Log

Line 329: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

325: l_errortext := SUBSTR(SQLERRM,1,200);
326:
327: IF G_DEBUG = 'Y' THEN
328: INV_ORGHIERARCHY_PVT.Log
329: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
330: ,'submission error'
331: );
332: INV_ORGHIERARCHY_PVT.Log
333: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

Line 332: INV_ORGHIERARCHY_PVT.Log

328: INV_ORGHIERARCHY_PVT.Log
329: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
330: ,'submission error'
331: );
332: INV_ORGHIERARCHY_PVT.Log
333: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
334: ,to_char(l_errorcode) || l_errortext
335: );
336: END IF;

Line 333: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

329: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
330: ,'submission error'
331: );
332: INV_ORGHIERARCHY_PVT.Log
333: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
334: ,to_char(l_errorcode) || l_errortext
335: );
336: END IF;
337: x_retcode := RETCODE_ERROR;

Line 345: INV_ORGHIERARCHY_PVT.Log

341: l_errorcode := SQLCODE;
342: l_errortext := SUBSTR(SQLERRM,1,200);
343:
344: IF G_DEBUG = 'Y' THEN
345: INV_ORGHIERARCHY_PVT.Log
346: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
347: ,'set options error'
348: );
349: INV_ORGHIERARCHY_PVT.Log

Line 346: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

342: l_errortext := SUBSTR(SQLERRM,1,200);
343:
344: IF G_DEBUG = 'Y' THEN
345: INV_ORGHIERARCHY_PVT.Log
346: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
347: ,'set options error'
348: );
349: INV_ORGHIERARCHY_PVT.Log
350: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

Line 349: INV_ORGHIERARCHY_PVT.Log

345: INV_ORGHIERARCHY_PVT.Log
346: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
347: ,'set options error'
348: );
349: INV_ORGHIERARCHY_PVT.Log
350: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
351: ,to_char(l_errorcode) || l_errortext
352: );
353: END IF;

Line 350: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

346: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
347: ,'set options error'
348: );
349: INV_ORGHIERARCHY_PVT.Log
350: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
351: ,to_char(l_errorcode) || l_errortext
352: );
353: END IF;
354: x_retcode := RETCODE_ERROR;