351: --ROLLBACK;
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
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');
361: igi_iac_debug_pkg.debug_other_msg(g_error_level, g_path||'upload_data', FALSE);
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');
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
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');
366: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',p_book_code);
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');
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:
362: FND_MESSAGE.Raise_Error;
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
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');
372: 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');
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:
368: FND_MESSAGE.Raise_Error;
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
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');
378: FND_MESSAGE.Set_Token('ASSET_NUMBER',p_asset_number);
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');
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);
374: FND_MESSAGE.Raise_Error;
375:
376: WHEN e_transfer_completed THEN
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;
375:
376: WHEN e_transfer_completed THEN
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:
376: WHEN e_transfer_completed THEN
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
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');
386: 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');
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;
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');
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:
383:
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
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');
393: FND_MESSAGE.Set_Token('ASSET_NUMBER',p_asset_number);
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');
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:
389: FND_MESSAGE.Raise_Error;
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
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');
399: FND_MESSAGE.Set_Token('GROUP_ID',p_group_id);
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');
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);
395: FND_MESSAGE.Raise_Error;
396:
397: WHEN e_groupid_invalid THEN
398: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_GROUPID_ERR_ADI');
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);
396:
397: WHEN e_groupid_invalid THEN
398: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_GROUPID_ERR_ADI');
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;
397: WHEN e_groupid_invalid THEN
398: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_GROUPID_ERR_ADI');
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:
398: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_GROUPID_ERR_ADI');
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
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');
408: FND_MESSAGE.Set_Token('ASSET_NUMBER',p_asset_number);
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');
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);
404: FND_MESSAGE.Raise_Error;
405:
406: WHEN e_update_error THEN
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;
405:
406: WHEN e_update_error THEN
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:
406: WHEN e_update_error THEN
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
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');
416: FND_MESSAGE.Raise_Error;
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
420: