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_IAC_WEBADI_PKG dependencies on FND_MESSAGE

Line 396: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PER_ERROR');

392: If p_upload_record.tolerance_amount is null Then
393: If p_upload_record.percentage_diff >
394: abs(p_upload_record.tolerance_percent) Then
395: p_upload_record.line_status_flag := 'L';
396: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PER_ERROR');
397: p_upload_record.exception_message := Fnd_Message.Get;
398: End If;
399: Elsif p_upload_record.tolerance_percent is null Then
400: If p_upload_record.amount_diff >

Line 397: p_upload_record.exception_message := Fnd_Message.Get;

393: If p_upload_record.percentage_diff >
394: abs(p_upload_record.tolerance_percent) Then
395: p_upload_record.line_status_flag := 'L';
396: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PER_ERROR');
397: p_upload_record.exception_message := Fnd_Message.Get;
398: End If;
399: Elsif p_upload_record.tolerance_percent is null Then
400: If p_upload_record.amount_diff >
401: abs(p_upload_record.tolerance_amount) Then

Line 403: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_AMT_ERROR');

399: Elsif p_upload_record.tolerance_percent is null Then
400: If p_upload_record.amount_diff >
401: abs(p_upload_record.tolerance_amount) Then
402: p_upload_record.line_status_flag := 'L';
403: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_AMT_ERROR');
404: p_upload_record.exception_message := Fnd_Message.Get;
405: End If;
406: Else
407: If ((p_upload_record.percentage_diff >

Line 404: p_upload_record.exception_message := Fnd_Message.Get;

400: If p_upload_record.amount_diff >
401: abs(p_upload_record.tolerance_amount) Then
402: p_upload_record.line_status_flag := 'L';
403: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_AMT_ERROR');
404: p_upload_record.exception_message := Fnd_Message.Get;
405: End If;
406: Else
407: If ((p_upload_record.percentage_diff >
408: abs(p_upload_record.tolerance_percent)) OR

Line 416: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_AMT_PER_ERROR');

412: If ((p_upload_record.percentage_diff >
413: abs(p_upload_record.tolerance_percent)) AND
414: (p_upload_record.amount_diff >
415: abs(p_upload_record.tolerance_amount))) Then
416: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_AMT_PER_ERROR');
417: p_upload_record.exception_message := Fnd_Message.Get;
418: Elsif p_upload_record.percentage_diff >
419: abs(p_upload_record.tolerance_percent) Then
420: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PER_ERROR');

Line 417: p_upload_record.exception_message := Fnd_Message.Get;

413: abs(p_upload_record.tolerance_percent)) AND
414: (p_upload_record.amount_diff >
415: abs(p_upload_record.tolerance_amount))) Then
416: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_AMT_PER_ERROR');
417: p_upload_record.exception_message := Fnd_Message.Get;
418: Elsif p_upload_record.percentage_diff >
419: abs(p_upload_record.tolerance_percent) Then
420: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PER_ERROR');
421: p_upload_record.exception_message := Fnd_Message.Get;

Line 420: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PER_ERROR');

416: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_AMT_PER_ERROR');
417: p_upload_record.exception_message := Fnd_Message.Get;
418: Elsif p_upload_record.percentage_diff >
419: abs(p_upload_record.tolerance_percent) Then
420: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PER_ERROR');
421: p_upload_record.exception_message := Fnd_Message.Get;
422: Elsif p_upload_record.amount_diff >
423: abs(p_upload_record.tolerance_amount) Then
424: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_AMT_ERROR');

Line 421: p_upload_record.exception_message := Fnd_Message.Get;

417: p_upload_record.exception_message := Fnd_Message.Get;
418: Elsif p_upload_record.percentage_diff >
419: abs(p_upload_record.tolerance_percent) Then
420: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PER_ERROR');
421: p_upload_record.exception_message := Fnd_Message.Get;
422: Elsif p_upload_record.amount_diff >
423: abs(p_upload_record.tolerance_amount) Then
424: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_AMT_ERROR');
425: p_upload_record.exception_message := Fnd_Message.Get;

Line 424: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_AMT_ERROR');

420: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PER_ERROR');
421: p_upload_record.exception_message := Fnd_Message.Get;
422: Elsif p_upload_record.amount_diff >
423: abs(p_upload_record.tolerance_amount) Then
424: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_AMT_ERROR');
425: p_upload_record.exception_message := Fnd_Message.Get;
426: End If;
427: End If;
428: End If;

Line 425: p_upload_record.exception_message := Fnd_Message.Get;

421: p_upload_record.exception_message := Fnd_Message.Get;
422: Elsif p_upload_record.amount_diff >
423: abs(p_upload_record.tolerance_amount) Then
424: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_AMT_ERROR');
425: p_upload_record.exception_message := Fnd_Message.Get;
426: End If;
427: End If;
428: End If;
429: End Check_Tolerances;

Line 474: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_NON_IAC_CATEGORY');

470: p_upload_record.category_id);
471: Fetch C_Valid_Iac_Cat into l_allow_prof_reval_flag;
472: If C_Valid_Iac_Cat%notfound Then
473: p_upload_record.line_status_flag := 'E';
474: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_NON_IAC_CATEGORY');
475: p_upload_record.exception_message := ltrim(
476: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
477: Else
478: If l_allow_prof_reval_flag = 'Y' Then

Line 476: p_upload_record.exception_message || ' ' || Fnd_Message.Get);

472: If C_Valid_Iac_Cat%notfound Then
473: p_upload_record.line_status_flag := 'E';
474: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_NON_IAC_CATEGORY');
475: p_upload_record.exception_message := ltrim(
476: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
477: Else
478: If l_allow_prof_reval_flag = 'Y' Then
479: Null;
480: Else

Line 482: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_NON_PROF_CATEGORY');

478: If l_allow_prof_reval_flag = 'Y' Then
479: Null;
480: Else
481: p_upload_record.line_status_flag := 'E';
482: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_NON_PROF_CATEGORY');
483: p_upload_record.exception_message := ltrim(
484: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
485: End If;
486: End If;

Line 484: p_upload_record.exception_message || ' ' || Fnd_Message.Get);

480: Else
481: p_upload_record.line_status_flag := 'E';
482: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_NON_PROF_CATEGORY');
483: p_upload_record.exception_message := ltrim(
484: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
485: End If;
486: End If;
487: Close C_Valid_Iac_Cat;
488:

Line 492: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NEGATIVE_ASSETS');

488:
489: -- Bug 3391784 Start
490: If p_upload_record.original_cost < 0 Then
491: p_upload_record.line_status_flag := 'E';
492: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NEGATIVE_ASSETS');
493: p_upload_record.exception_message := ltrim(
494: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
495: End If;
496: -- Bug 3391784 End

Line 494: p_upload_record.exception_message || ' ' || Fnd_Message.Get);

490: If p_upload_record.original_cost < 0 Then
491: p_upload_record.line_status_flag := 'E';
492: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NEGATIVE_ASSETS');
493: p_upload_record.exception_message := ltrim(
494: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
495: End If;
496: -- Bug 3391784 End
497:
498: If igi_iac_common_utils.get_open_Period_Info(

Line 503: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_UNAVAILABLE_PERIOD');

499: p_upload_record.book_type_code, l_get_period_rec) Then
500: If p_upload_record.period_counter <> (l_get_period_rec.period_counter
501: - 1) Then
502: p_upload_record.line_status_flag := 'E';
503: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_UNAVAILABLE_PERIOD');
504: p_upload_record.exception_message := ltrim(
505: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
506: End If;
507: End If;

Line 505: p_upload_record.exception_message || ' ' || Fnd_Message.Get);

501: - 1) Then
502: p_upload_record.line_status_flag := 'E';
503: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_UNAVAILABLE_PERIOD');
504: p_upload_record.exception_message := ltrim(
505: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
506: End If;
507: End If;
508: Open C_max_period_counter(p_upload_record.book_type_code);
509: Fetch C_max_period_counter into l_max_period_counter;

Line 518: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_DEP_NOT_CLOSED');

514: Close C_Last_Closed_Period;
515:
516: If l_max_period_counter > l_last_closed_period Then
517: p_upload_record.line_status_flag := 'E';
518: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_DEP_NOT_CLOSED');
519: p_upload_record.exception_message := ltrim(
520: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
521: End If;
522:

Line 520: p_upload_record.exception_message || ' ' || Fnd_Message.Get);

516: If l_max_period_counter > l_last_closed_period Then
517: p_upload_record.line_status_flag := 'E';
518: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_DEP_NOT_CLOSED');
519: p_upload_record.exception_message := ltrim(
520: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
521: End If;
522:
523: If igi_iac_common_utils.Any_Txns_In_Open_Period(
524: p_upload_record.book_type_code, p_upload_record.asset_id) Then

Line 526: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PENDING_TRX');

522:
523: If igi_iac_common_utils.Any_Txns_In_Open_Period(
524: p_upload_record.book_type_code, p_upload_record.asset_id) Then
525: p_upload_record.line_status_flag := 'E';
526: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PENDING_TRX');
527: p_upload_record.exception_message := ltrim(
528: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
529: End If;
530: If p_upload_record.period_counter_fully_retired is not null Then

Line 528: p_upload_record.exception_message || ' ' || Fnd_Message.Get);

524: p_upload_record.book_type_code, p_upload_record.asset_id) Then
525: p_upload_record.line_status_flag := 'E';
526: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PENDING_TRX');
527: p_upload_record.exception_message := ltrim(
528: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
529: End If;
530: If p_upload_record.period_counter_fully_retired is not null Then
531: p_upload_record.line_status_flag := 'E';
532: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_FULLY_RET');

Line 532: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_FULLY_RET');

528: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
529: End If;
530: If p_upload_record.period_counter_fully_retired is not null Then
531: p_upload_record.line_status_flag := 'E';
532: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_FULLY_RET');
533: p_upload_record.exception_message := ltrim(
534: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
535: End If;
536: Open C_Dup_Assets(p_upload_record.File_Name, p_upload_record.Asset_Id);

Line 534: p_upload_record.exception_message || ' ' || Fnd_Message.Get);

530: If p_upload_record.period_counter_fully_retired is not null Then
531: p_upload_record.line_status_flag := 'E';
532: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_FULLY_RET');
533: p_upload_record.exception_message := ltrim(
534: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
535: End If;
536: Open C_Dup_Assets(p_upload_record.File_Name, p_upload_record.Asset_Id);
537: Fetch C_Dup_Assets into l_asset_cnt;
538: Close C_Dup_Assets;

Line 541: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_DUP_ASSET');

537: Fetch C_Dup_Assets into l_asset_cnt;
538: Close C_Dup_Assets;
539: If l_asset_cnt > 1 Then
540: p_upload_record.line_status_flag := 'E';
541: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_DUP_ASSET');
542: p_upload_record.exception_message := ltrim(
543: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
544: Update_Duplicate_Assets(p_upload_record.file_name,
545: p_upload_record.book_type_code,

Line 543: p_upload_record.exception_message || ' ' || Fnd_Message.Get);

539: If l_asset_cnt > 1 Then
540: p_upload_record.line_status_flag := 'E';
541: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_DUP_ASSET');
542: p_upload_record.exception_message := ltrim(
543: p_upload_record.exception_message || ' ' || Fnd_Message.Get);
544: Update_Duplicate_Assets(p_upload_record.file_name,
545: p_upload_record.book_type_code,
546: p_upload_record.period_counter,
547: p_upload_record.asset_id,

Line 848: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NOT_INSTALLED') ;

844: Update_Header_Status(l_upload_record.file_name);
845: Commit;
846: Exception
847: When E_Iac_Not_Enabled Then
848: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NOT_INSTALLED') ;
849: Fnd_Message.Raise_Error;
850: When E_Non_Iac_Book Then
851: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_INVALID_BOOK');
852: Fnd_Message.Raise_Error;

Line 849: Fnd_Message.Raise_Error;

845: Commit;
846: Exception
847: When E_Iac_Not_Enabled Then
848: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NOT_INSTALLED') ;
849: Fnd_Message.Raise_Error;
850: When E_Non_Iac_Book Then
851: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_INVALID_BOOK');
852: Fnd_Message.Raise_Error;
853: /*Added for bug 13250900 */

Line 851: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_INVALID_BOOK');

847: When E_Iac_Not_Enabled Then
848: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NOT_INSTALLED') ;
849: Fnd_Message.Raise_Error;
850: When E_Non_Iac_Book Then
851: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_INVALID_BOOK');
852: Fnd_Message.Raise_Error;
853: /*Added for bug 13250900 */
854: When E_Zero_New_Cost Then
855: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NEW_COST_ZERO') ;

Line 852: Fnd_Message.Raise_Error;

848: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NOT_INSTALLED') ;
849: Fnd_Message.Raise_Error;
850: When E_Non_Iac_Book Then
851: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_INVALID_BOOK');
852: Fnd_Message.Raise_Error;
853: /*Added for bug 13250900 */
854: When E_Zero_New_Cost Then
855: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NEW_COST_ZERO') ;
856: Fnd_Message.Raise_Error;

Line 855: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NEW_COST_ZERO') ;

851: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_INVALID_BOOK');
852: Fnd_Message.Raise_Error;
853: /*Added for bug 13250900 */
854: When E_Zero_New_Cost Then
855: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NEW_COST_ZERO') ;
856: Fnd_Message.Raise_Error;
857: When E_Igi_Tol_Yes Then
858: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_REQ');
859: Fnd_Message.Raise_Error;

Line 856: Fnd_Message.Raise_Error;

852: Fnd_Message.Raise_Error;
853: /*Added for bug 13250900 */
854: When E_Zero_New_Cost Then
855: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NEW_COST_ZERO') ;
856: Fnd_Message.Raise_Error;
857: When E_Igi_Tol_Yes Then
858: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_REQ');
859: Fnd_Message.Raise_Error;
860: When E_Igi_Tol_No Then

Line 858: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_REQ');

854: When E_Zero_New_Cost Then
855: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NEW_COST_ZERO') ;
856: Fnd_Message.Raise_Error;
857: When E_Igi_Tol_Yes Then
858: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_REQ');
859: Fnd_Message.Raise_Error;
860: When E_Igi_Tol_No Then
861: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_NOT_REQ');
862: Fnd_Message.Raise_Error;

Line 859: Fnd_Message.Raise_Error;

855: Fnd_Message.Set_Name('IGI', 'IGI_IAC_NEW_COST_ZERO') ;
856: Fnd_Message.Raise_Error;
857: When E_Igi_Tol_Yes Then
858: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_REQ');
859: Fnd_Message.Raise_Error;
860: When E_Igi_Tol_No Then
861: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_NOT_REQ');
862: Fnd_Message.Raise_Error;
863: When E_Invalid_Asset Then

Line 861: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_NOT_REQ');

857: When E_Igi_Tol_Yes Then
858: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_REQ');
859: Fnd_Message.Raise_Error;
860: When E_Igi_Tol_No Then
861: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_NOT_REQ');
862: Fnd_Message.Raise_Error;
863: When E_Invalid_Asset Then
864: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_INVALID_ASSET');
865: Fnd_Message.Raise_Error;

Line 862: Fnd_Message.Raise_Error;

858: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_REQ');
859: Fnd_Message.Raise_Error;
860: When E_Igi_Tol_No Then
861: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_NOT_REQ');
862: Fnd_Message.Raise_Error;
863: When E_Invalid_Asset Then
864: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_INVALID_ASSET');
865: Fnd_Message.Raise_Error;
866: When E_File_Trans Then

Line 864: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_INVALID_ASSET');

860: When E_Igi_Tol_No Then
861: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_NOT_REQ');
862: Fnd_Message.Raise_Error;
863: When E_Invalid_Asset Then
864: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_INVALID_ASSET');
865: Fnd_Message.Raise_Error;
866: When E_File_Trans Then
867: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
868: Fnd_Message.Raise_Error;

Line 865: Fnd_Message.Raise_Error;

861: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_NOT_REQ');
862: Fnd_Message.Raise_Error;
863: When E_Invalid_Asset Then
864: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_INVALID_ASSET');
865: Fnd_Message.Raise_Error;
866: When E_File_Trans Then
867: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
868: Fnd_Message.Raise_Error;
869: End New_File;

Line 867: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');

863: When E_Invalid_Asset Then
864: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_INVALID_ASSET');
865: Fnd_Message.Raise_Error;
866: When E_File_Trans Then
867: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
868: Fnd_Message.Raise_Error;
869: End New_File;
870:
871: Procedure Tol_Errors(

Line 868: Fnd_Message.Raise_Error;

864: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_INVALID_ASSET');
865: Fnd_Message.Raise_Error;
866: When E_File_Trans Then
867: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
868: Fnd_Message.Raise_Error;
869: End New_File;
870:
871: Procedure Tol_Errors(
872: P_File_Name IN igi_iac_upload_headers.file_name%type,

Line 924: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_ACCEPT');

920: l_upload_record.line_num);
921: l_upd_line_flag := 'N';
922: Elsif p_line_action = 'A' Then
923: If p_hdr_action = 'A' Then
924: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_ACCEPT');
925: l_upload_record.comments := Fnd_Message.Get;
926: End If;
927: l_upload_record.line_status_flag := 'A';
928: l_upload_record.exception_message := null;

Line 925: l_upload_record.comments := Fnd_Message.Get;

921: l_upd_line_flag := 'N';
922: Elsif p_line_action = 'A' Then
923: If p_hdr_action = 'A' Then
924: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_ACCEPT');
925: l_upload_record.comments := Fnd_Message.Get;
926: End If;
927: l_upload_record.line_status_flag := 'A';
928: l_upload_record.exception_message := null;
929: Else -- N

Line 936: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_ACCEPT');

932: l_upload_record.asset_Id,
933: l_upload_record.line_num);
934: l_upd_line_flag := 'N';
935: Elsif p_hdr_action = 'A' Then
936: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_ACCEPT');
937: l_upload_record.comments := Fnd_Message.Get;
938: l_upload_record.line_status_flag := 'A';
939: l_upload_record.exception_message := null;
940: Else -- N

Line 937: l_upload_record.comments := Fnd_Message.Get;

933: l_upload_record.line_num);
934: l_upd_line_flag := 'N';
935: Elsif p_hdr_action = 'A' Then
936: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TOL_ACCEPT');
937: l_upload_record.comments := Fnd_Message.Get;
938: l_upload_record.line_status_flag := 'A';
939: l_upload_record.exception_message := null;
940: Else -- N
941: l_upd_line_flag := 'N';

Line 965: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');

961: Update_Header_Status(l_upload_record.file_name);
962: Commit;
963: Exception
964: When E_Iac_Not_Enabled Then
965: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
966: Fnd_Message.Raise_Error;
967: When E_File_Trans Then
968: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
969: Fnd_Message.Raise_Error;

Line 966: Fnd_Message.Raise_Error;

962: Commit;
963: Exception
964: When E_Iac_Not_Enabled Then
965: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
966: Fnd_Message.Raise_Error;
967: When E_File_Trans Then
968: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
969: Fnd_Message.Raise_Error;
970: When E_Invalid_Asset Then

Line 968: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');

964: When E_Iac_Not_Enabled Then
965: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
966: Fnd_Message.Raise_Error;
967: When E_File_Trans Then
968: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
969: Fnd_Message.Raise_Error;
970: When E_Invalid_Asset Then
971: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');
972: Fnd_Message.Raise_Error;

Line 969: Fnd_Message.Raise_Error;

965: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
966: Fnd_Message.Raise_Error;
967: When E_File_Trans Then
968: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
969: Fnd_Message.Raise_Error;
970: When E_Invalid_Asset Then
971: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');
972: Fnd_Message.Raise_Error;
973: End Tol_Errors;

Line 971: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');

967: When E_File_Trans Then
968: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
969: Fnd_Message.Raise_Error;
970: When E_Invalid_Asset Then
971: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');
972: Fnd_Message.Raise_Error;
973: End Tol_Errors;
974:
975: Procedure Excpt_Errors(

Line 972: Fnd_Message.Raise_Error;

968: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
969: Fnd_Message.Raise_Error;
970: When E_Invalid_Asset Then
971: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');
972: Fnd_Message.Raise_Error;
973: End Tol_Errors;
974:
975: Procedure Excpt_Errors(
976: P_File_Name IN igi_iac_upload_headers.file_name%type,

Line 1054: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_EXC_ACCEPT');

1050: l_upload_record.line_num);
1051: l_upd_line_flag := 'N';
1052: Elsif p_line_action = 'A' Then
1053: If p_hdr_action = 'A' Then
1054: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_EXC_ACCEPT');
1055: l_upload_record.comments := Fnd_Message.Get;
1056: End If;
1057: Check_Exceptions(l_upload_record);
1058: Else -- N

Line 1055: l_upload_record.comments := Fnd_Message.Get;

1051: l_upd_line_flag := 'N';
1052: Elsif p_line_action = 'A' Then
1053: If p_hdr_action = 'A' Then
1054: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_EXC_ACCEPT');
1055: l_upload_record.comments := Fnd_Message.Get;
1056: End If;
1057: Check_Exceptions(l_upload_record);
1058: Else -- N
1059: If p_hdr_action = 'D' Then

Line 1065: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_EXC_ACCEPT');

1061: l_upload_record.asset_id,
1062: l_upload_record.line_num);
1063: l_upd_line_flag := 'N';
1064: Elsif p_hdr_action = 'A' Then
1065: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_EXC_ACCEPT');
1066: l_upload_record.comments := Fnd_Message.Get;
1067: Check_Exceptions(l_upload_record);
1068: Else -- N
1069: l_upd_line_flag := 'N';

Line 1066: l_upload_record.comments := Fnd_Message.Get;

1062: l_upload_record.line_num);
1063: l_upd_line_flag := 'N';
1064: Elsif p_hdr_action = 'A' Then
1065: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_EXC_ACCEPT');
1066: l_upload_record.comments := Fnd_Message.Get;
1067: Check_Exceptions(l_upload_record);
1068: Else -- N
1069: l_upd_line_flag := 'N';
1070: End If;

Line 1093: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');

1089: Update_Header_Status(l_upload_record.file_name);
1090: Commit;
1091: Exception
1092: When E_Iac_Not_Enabled Then
1093: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
1094: Fnd_Message.Raise_Error;
1095: When E_File_Trans Then
1096: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
1097: Fnd_Message.Raise_Error;

Line 1094: Fnd_Message.Raise_Error;

1090: Commit;
1091: Exception
1092: When E_Iac_Not_Enabled Then
1093: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
1094: Fnd_Message.Raise_Error;
1095: When E_File_Trans Then
1096: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
1097: Fnd_Message.Raise_Error;
1098: When E_Invalid_Asset Then

Line 1096: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');

1092: When E_Iac_Not_Enabled Then
1093: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
1094: Fnd_Message.Raise_Error;
1095: When E_File_Trans Then
1096: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
1097: Fnd_Message.Raise_Error;
1098: When E_Invalid_Asset Then
1099: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');
1100: Fnd_Message.Raise_Error;

Line 1097: Fnd_Message.Raise_Error;

1093: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
1094: Fnd_Message.Raise_Error;
1095: When E_File_Trans Then
1096: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
1097: Fnd_Message.Raise_Error;
1098: When E_Invalid_Asset Then
1099: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');
1100: Fnd_Message.Raise_Error;
1101: End Excpt_Errors;

Line 1099: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');

1095: When E_File_Trans Then
1096: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
1097: Fnd_Message.Raise_Error;
1098: When E_Invalid_Asset Then
1099: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');
1100: Fnd_Message.Raise_Error;
1101: End Excpt_Errors;
1102:
1103: Procedure Valid_Assets(

Line 1100: Fnd_Message.Raise_Error;

1096: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
1097: Fnd_Message.Raise_Error;
1098: When E_Invalid_Asset Then
1099: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');
1100: Fnd_Message.Raise_Error;
1101: End Excpt_Errors;
1102:
1103: Procedure Valid_Assets(
1104: P_File_Name IN igi_iac_upload_headers.file_name%type,

Line 1169: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');

1165: End If;
1166: Commit;
1167: Exception
1168: When E_Iac_Not_Enabled Then
1169: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
1170: Fnd_Message.Raise_Error;
1171: When E_File_Trans Then
1172: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
1173: Fnd_Message.Raise_Error;

Line 1170: Fnd_Message.Raise_Error;

1166: Commit;
1167: Exception
1168: When E_Iac_Not_Enabled Then
1169: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
1170: Fnd_Message.Raise_Error;
1171: When E_File_Trans Then
1172: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
1173: Fnd_Message.Raise_Error;
1174: When E_Invalid_Asset Then

Line 1172: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');

1168: When E_Iac_Not_Enabled Then
1169: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
1170: Fnd_Message.Raise_Error;
1171: When E_File_Trans Then
1172: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
1173: Fnd_Message.Raise_Error;
1174: When E_Invalid_Asset Then
1175: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');
1176: Fnd_Message.Raise_Error;

Line 1173: Fnd_Message.Raise_Error;

1169: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
1170: Fnd_Message.Raise_Error;
1171: When E_File_Trans Then
1172: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
1173: Fnd_Message.Raise_Error;
1174: When E_Invalid_Asset Then
1175: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');
1176: Fnd_Message.Raise_Error;
1177: End Valid_Assets;

Line 1175: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');

1171: When E_File_Trans Then
1172: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
1173: Fnd_Message.Raise_Error;
1174: When E_Invalid_Asset Then
1175: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');
1176: Fnd_Message.Raise_Error;
1177: End Valid_Assets;
1178:
1179: Procedure Transfer_Data(

Line 1176: Fnd_Message.Raise_Error;

1172: FND_MESSAGE.Set_Name('IGI','IGI_IAC_UPL_FILE_TRANS');
1173: Fnd_Message.Raise_Error;
1174: When E_Invalid_Asset Then
1175: Fnd_Message.Set_Name('IGI','IGI_IAC_UPL_NO_ASSET_IN_FILE');
1176: Fnd_Message.Raise_Error;
1177: End Valid_Assets;
1178:
1179: Procedure Transfer_Data(
1180: errbuf OUT NOCOPY varchar2,

Line 1481: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TRANS_FAILURE');

1477: Set status_flag = 'T', revaluation_id = l_reval_id
1478: Where file_name = p_file_name;
1479:
1480: If sql%notfound then
1481: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TRANS_FAILURE');
1482: l_message := Fnd_Message.Get;
1483: -- Debug(l_message);
1484: -- bug 3299718, start block
1485: IF (l_state_level >= l_debug_level) THEN

Line 1482: l_message := Fnd_Message.Get;

1478: Where file_name = p_file_name;
1479:
1480: If sql%notfound then
1481: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TRANS_FAILURE');
1482: l_message := Fnd_Message.Get;
1483: -- Debug(l_message);
1484: -- bug 3299718, start block
1485: IF (l_state_level >= l_debug_level) THEN
1486: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg1',

Line 1493: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TRANS_SUCCESS');

1489: -- bug 3299718, end block
1490:
1491:
1492: Elsif sql%found then
1493: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TRANS_SUCCESS');
1494: l_message := Fnd_Message.Get;
1495: -- Debug(l_message);
1496: -- bug 3299718, start block
1497: IF (l_state_level >= l_debug_level) THEN

Line 1494: l_message := Fnd_Message.Get;

1490:
1491:
1492: Elsif sql%found then
1493: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TRANS_SUCCESS');
1494: l_message := Fnd_Message.Get;
1495: -- Debug(l_message);
1496: -- bug 3299718, start block
1497: IF (l_state_level >= l_debug_level) THEN
1498: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg2',

Line 1503: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TRANS_COUNT');

1499: l_message);
1500: END IF;
1501: -- bug 3299718, end block
1502:
1503: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TRANS_COUNT');
1504: Fnd_Message.Set_Token('ASSET_COUNT',l_asset_count);
1505: l_message := Fnd_Message.Get;
1506: -- Debug(l_message);
1507: -- bug 3299718, start block

Line 1504: Fnd_Message.Set_Token('ASSET_COUNT',l_asset_count);

1500: END IF;
1501: -- bug 3299718, end block
1502:
1503: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TRANS_COUNT');
1504: Fnd_Message.Set_Token('ASSET_COUNT',l_asset_count);
1505: l_message := Fnd_Message.Get;
1506: -- Debug(l_message);
1507: -- bug 3299718, start block
1508: IF (l_state_level >= l_debug_level) THEN

Line 1505: l_message := Fnd_Message.Get;

1501: -- bug 3299718, end block
1502:
1503: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_TRANS_COUNT');
1504: Fnd_Message.Set_Token('ASSET_COUNT',l_asset_count);
1505: l_message := Fnd_Message.Get;
1506: -- Debug(l_message);
1507: -- bug 3299718, start block
1508: IF (l_state_level >= l_debug_level) THEN
1509: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg3',

Line 1513: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_REVAL_ID');

1509: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg3',
1510: l_message);
1511: END IF;
1512: -- bug 3299718, end block
1513: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_REVAL_ID');
1514: Fnd_Message.Set_Token('REVAL_ID',l_reval_id);
1515: l_message := Fnd_Message.Get;
1516: -- Debug(l_message);
1517: -- bug 3299718, start block

Line 1514: Fnd_Message.Set_Token('REVAL_ID',l_reval_id);

1510: l_message);
1511: END IF;
1512: -- bug 3299718, end block
1513: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_REVAL_ID');
1514: Fnd_Message.Set_Token('REVAL_ID',l_reval_id);
1515: l_message := Fnd_Message.Get;
1516: -- Debug(l_message);
1517: -- bug 3299718, start block
1518: IF (l_state_level >= l_debug_level) THEN

Line 1515: l_message := Fnd_Message.Get;

1511: END IF;
1512: -- bug 3299718, end block
1513: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_REVAL_ID');
1514: Fnd_Message.Set_Token('REVAL_ID',l_reval_id);
1515: l_message := Fnd_Message.Get;
1516: -- Debug(l_message);
1517: -- bug 3299718, start block
1518: IF (l_state_level >= l_debug_level) THEN
1519: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg4',

Line 1579: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_UNAVAILABLE_PERIOD');

1575: End Loop;
1576: retcode := 0;
1577: Exception
1578: When E_Unavailable_Period Then
1579: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_UNAVAILABLE_PERIOD');
1580: l_message := Fnd_Message.Get;
1581: -- Debug(l_message);
1582: -- bug 3299718, start block
1583: IF (l_state_level >= l_debug_level) THEN

Line 1580: l_message := Fnd_Message.Get;

1576: retcode := 0;
1577: Exception
1578: When E_Unavailable_Period Then
1579: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_UNAVAILABLE_PERIOD');
1580: l_message := Fnd_Message.Get;
1581: -- Debug(l_message);
1582: -- bug 3299718, start block
1583: IF (l_state_level >= l_debug_level) THEN
1584: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg5',

Line 1592: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_DEP_NOT_CLOSED');

1588:
1589: errbuf := l_message;
1590: retcode :=2;
1591: When E_Period_Not_Closed Then
1592: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_DEP_NOT_CLOSED');
1593: l_message := Fnd_Message.Get;
1594: -- Debug(l_message);
1595: -- bug 3299718, start block
1596: IF (l_state_level >= l_debug_level) THEN

Line 1593: l_message := Fnd_Message.Get;

1589: errbuf := l_message;
1590: retcode :=2;
1591: When E_Period_Not_Closed Then
1592: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_DEP_NOT_CLOSED');
1593: l_message := Fnd_Message.Get;
1594: -- Debug(l_message);
1595: -- bug 3299718, start block
1596: IF (l_state_level >= l_debug_level) THEN
1597: FND_LOG.STRING(l_state_level, 'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Msg6',

Line 1605: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PREVIEW_FAILED');

1601:
1602: errbuf := l_message;
1603: retcode :=2;
1604: When E_Request_Submit_Error THEN
1605: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PREVIEW_FAILED');
1606: l_message := Fnd_Message.Get;
1607: -- Debug(l_message);
1608:
1609: -- bug 3299718, start block

Line 1606: l_message := Fnd_Message.Get;

1602: errbuf := l_message;
1603: retcode :=2;
1604: When E_Request_Submit_Error THEN
1605: Fnd_Message.Set_Name('IGI', 'IGI_IAC_UPL_PREVIEW_FAILED');
1606: l_message := Fnd_Message.Get;
1607: -- Debug(l_message);
1608:
1609: -- bug 3299718, start block
1610: IF (l_state_level >= l_debug_level) THEN

Line 1621: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_EXISTS');

1617: WHEN e_preview_exists THEN
1618: /* bug 3495368, start 1
1619: -- commenting out as no longer required
1620: IF (l_error_level >= l_debug_level) THEN
1621: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_EXISTS');
1622: l_mesg1 := fnd_message.get;
1623: FND_LOG.MESSAGE(l_error_level,'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Preview Exists', TRUE);
1624: -- fnd_file.put_line required for display to user
1625: fnd_file.put_line(fnd_file.log, l_mesg1);

Line 1622: l_mesg1 := fnd_message.get;

1618: /* bug 3495368, start 1
1619: -- commenting out as no longer required
1620: IF (l_error_level >= l_debug_level) THEN
1621: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_EXISTS');
1622: l_mesg1 := fnd_message.get;
1623: FND_LOG.MESSAGE(l_error_level,'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Preview Exists', TRUE);
1624: -- fnd_file.put_line required for display to user
1625: fnd_file.put_line(fnd_file.log, l_mesg1);
1626:

Line 1630: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_ASSETS');

1626:
1627: -- list of assets
1628: l_preview_exists := NULL;
1629: FOR l_preview_exists IN c_preview_exists(l_book_type_code) LOOP
1630: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_ASSETS');
1631: fnd_message.set_token('ASSET_NUM', l_preview_exists.asset_number, FALSE);
1632: l_mesg1 := fnd_message.get;
1633: FND_LOG.MESSAGE(l_error_level,'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Preview Exists', TRUE);
1634: -- fnd_file.put_line required for display to user

Line 1631: fnd_message.set_token('ASSET_NUM', l_preview_exists.asset_number, FALSE);

1627: -- list of assets
1628: l_preview_exists := NULL;
1629: FOR l_preview_exists IN c_preview_exists(l_book_type_code) LOOP
1630: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_ASSETS');
1631: fnd_message.set_token('ASSET_NUM', l_preview_exists.asset_number, FALSE);
1632: l_mesg1 := fnd_message.get;
1633: FND_LOG.MESSAGE(l_error_level,'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Preview Exists', TRUE);
1634: -- fnd_file.put_line required for display to user
1635: fnd_file.put_line(fnd_file.log, l_mesg1);

Line 1632: l_mesg1 := fnd_message.get;

1628: l_preview_exists := NULL;
1629: FOR l_preview_exists IN c_preview_exists(l_book_type_code) LOOP
1630: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_ASSETS');
1631: fnd_message.set_token('ASSET_NUM', l_preview_exists.asset_number, FALSE);
1632: l_mesg1 := fnd_message.get;
1633: FND_LOG.MESSAGE(l_error_level,'igi.plsql.IGI_IAC_WEBADI_PKG.Transfer_Data.Preview Exists', TRUE);
1634: -- fnd_file.put_line required for display to user
1635: fnd_file.put_line(fnd_file.log, l_mesg1);
1636: END LOOP;

Line 1641: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_EXISTS');

1637: END IF;
1638: bug 3495368, end 1 */
1639:
1640: -- bug 3495368, start 2
1641: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_EXISTS');
1642: l_message := fnd_message.get;
1643: -- bug 3495368, end 2
1644:
1645: errbuf := SQLERRM||': '||l_message;

Line 1642: l_message := fnd_message.get;

1638: bug 3495368, end 1 */
1639:
1640: -- bug 3495368, start 2
1641: fnd_message.set_name('IGI', 'IGI_IAC_UPL_PREVIEW_EXISTS');
1642: l_message := fnd_message.get;
1643: -- bug 3495368, end 2
1644:
1645: errbuf := SQLERRM||': '||l_message;
1646: retcode :=2;