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.IGI_IMP_IAC_WEBADI_PKG dependencies on IGI_IAC_DEBUG_PKG

Line 222: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'IAC is enabled');

218: IF NOT igi_gen.is_req_installed('IAC') THEN
219: RAISE e_iac_not_enabled;
220: END IF;
221:
222: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'IAC is enabled');
223:
224: -- Check if the profile option to use WebADI for import/export
225: -- is set to 'Y'
226: l_adi_enabled := fnd_profile.value('IGI_IMP_IAC_USE_WEB_ADI');

Line 233: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Web ADI is enabled');

229: l_valid := FALSE;
230: RAISE e_web_adi_not_enabled;
231: END IF;
232:
233: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Web ADI is enabled');
234:
235: -- validate if p_book_type_code exists in control table igi_imp_iac_controls
236: l_request_status := validate_book(p_book_code);
237: IF (l_request_status IS NULL) THEN

Line 246: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Book Validated');

242: /* open c_booK_class(p_book_code);
243: Fetch c_booK_class into l_booK_class;
244: Close c_book_class; */
245:
246: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Book Validated');
247:
248: -- validate the request status
249: IF UPPER(l_request_status) <> 'C' THEN
250: l_valid := FALSE;

Line 254: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Incomplete preparation');

250: l_valid := FALSE;
251: RAISE e_incomplete_preparation;
252: END IF;
253:
254: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Incomplete preparation');
255:
256: -- Validate the category id
257: l_count := validate_category(p_book_code,
258: p_category_desc);

Line 264: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Validated Category');

260: l_valid := FALSE;
261: RAISE e_invalid_category_id;
262: END IF;
263:
264: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Validated Category');
265:
266: -- validate the transfer, if complete, then record should not be updated
267: l_transfer_status := validate_transfer(p_book_code,
268: p_category_desc);

Line 274: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Transfer Status Validated');

270: l_valid := FALSE;
271: RAISE e_transfer_completed;
272: END IF;
273:
274: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Transfer Status Validated');
275:
276: -- validate the group_id
277: l_count := validate_groupid(p_book_code,
278: p_category_desc,

Line 297: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Asset Validated');

293: l_valid := FALSE;
294: RAISE e_asset_invalid;
295: END IF;
296:
297: igi_iac_debug_pkg.debug_other_string(g_state_level, g_path||'upload_data', 'Asset Validated');
298:
299: -- update the asset if it is has passed all validation
300:
301: l_deprn_flag := 'YES';

Line 348: igi_iac_debug_pkg.debug_other_string(g_event_level, g_path||'upload_data', 'Update successful');

344: IF SQL%ROWCOUNT = 0 THEN
345: RAISE e_update_error;
346: END IF;
347:
348: igi_iac_debug_pkg.debug_other_string(g_event_level, g_path||'upload_data', 'Update successful');
349:
350:
351: --ROLLBACK;
352:

Line 356: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);

352:
353: EXCEPTION
354: WHEN e_iac_not_enabled THEN
355: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
356: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);
357: FND_MESSAGE.Raise_Error;
358:
359: WHEN e_web_adi_not_enabled THEN
360: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_USE_IMP_BUTTON');

Line 361: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);

357: FND_MESSAGE.Raise_Error;
358:
359: WHEN e_web_adi_not_enabled THEN
360: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_USE_IMP_BUTTON');
361: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);
362: FND_MESSAGE.Raise_Error;
363:
364: WHEN e_invalid_book THEN
365: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INVALID_BOOK');

Line 367: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);

363:
364: WHEN e_invalid_book THEN
365: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INVALID_BOOK');
366: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',p_book_code);
367: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);
368: FND_MESSAGE.Raise_Error;
369:
370: WHEN e_incomplete_preparation THEN
371: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_PREP_NOT_COMPLETE');

Line 373: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);

369:
370: WHEN e_incomplete_preparation THEN
371: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_PREP_NOT_COMPLETE');
372: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',p_book_code);
373: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);
374: FND_MESSAGE.Raise_Error;
375:
376: WHEN e_transfer_completed THEN
377: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_ASSET_ERR_ADI');

Line 381: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);

377: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_ASSET_ERR_ADI');
378: FND_MESSAGE.Set_Token('ASSET_NUMBER',p_asset_number);
379: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',p_book_code);
380: FND_MESSAGE.Set_Token('CATEGORY_DESC',p_category_desc);
381: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);
382: FND_MESSAGE.Raise_Error;
383:
384: WHEN e_invalid_category_id THEN
385: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_CAT_ERR_ADI');

Line 388: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);

384: WHEN e_invalid_category_id THEN
385: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_CAT_ERR_ADI');
386: FND_MESSAGE.Set_Token('CATEGORY_DESC',p_category_desc);
387: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',p_book_code);
388: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);
389: FND_MESSAGE.Raise_Error;
390:
391: WHEN e_asset_invalid THEN
392: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INTFACE_ERR_ADI');

Line 394: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);

390:
391: WHEN e_asset_invalid THEN
392: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INTFACE_ERR_ADI');
393: FND_MESSAGE.Set_Token('ASSET_NUMBER',p_asset_number);
394: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);
395: FND_MESSAGE.Raise_Error;
396:
397: WHEN e_groupid_invalid THEN
398: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_GROUPID_ERR_ADI');

Line 403: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);

399: FND_MESSAGE.Set_Token('GROUP_ID',p_group_id);
400: FND_MESSAGE.Set_Token('ASSET_NUMBER',p_asset_number);
401: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',p_book_code);
402: FND_MESSAGE.Set_Token('CATEGORY_DESC',p_category_desc);
403: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);
404: FND_MESSAGE.Raise_Error;
405:
406: WHEN e_update_error THEN
407: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_UPDATE_ERR_ADI');

Line 411: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);

407: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_UPDATE_ERR_ADI');
408: FND_MESSAGE.Set_Token('ASSET_NUMBER',p_asset_number);
409: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',p_book_code);
410: FND_MESSAGE.Set_Token('CATEGORY_DESC',p_category_desc);
411: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);
412: FND_MESSAGE.Raise_Error;
413:
414: WHEN OTHERS THEN
415: igi_iac_debug_pkg.debug_unexpected_msg(g_path||'upload_data');

Line 415: igi_iac_debug_pkg.debug_unexpected_msg(g_path||'upload_data');

411: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);
412: FND_MESSAGE.Raise_Error;
413:
414: WHEN OTHERS THEN
415: igi_iac_debug_pkg.debug_unexpected_msg(g_path||'upload_data');
416: FND_MESSAGE.Raise_Error;
417: END Upload_Data;
418:
419: END IGI_IMP_IAC_WEBADI_PKG; -- Package body