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.ICX_POR_ITEM_UPLOAD_VALIDATE dependencies on ICX_POR_ITEM_UPLOAD_VALIDATE

Line 1: PACKAGE BODY ICX_POR_ITEM_UPLOAD_VALIDATE AS

1: PACKAGE BODY ICX_POR_ITEM_UPLOAD_VALIDATE AS
2: /* $Header: ICXIULVB.pls 115.33 2004/03/31 21:51:08 vkartik ship $*/
3:
4: --BUG#2228935
5: g_operating_unit_id NUMBER;

Line 417: 'Exception at ICX_POR_ITEM_UPLOAD_VALIDATE.validate_interface_data('

413: WHEN OTHERS THEN
414: ROLLBACK;
415:
416: RAISE_APPLICATION_ERROR(-20000,
417: 'Exception at ICX_POR_ITEM_UPLOAD_VALIDATE.validate_interface_data('
418: || xErrLoc || '): ' || SQLERRM);
419:
420: END validate_interface_data;
421:

Line 492: 'Exception at ICX_POR_ITEM_UPLOAD_VALIDATE.validate_duplicate_item2('

488: WHEN OTHERS THEN
489: ROLLBACK;
490:
491: RAISE_APPLICATION_ERROR(-20000,
492: 'Exception at ICX_POR_ITEM_UPLOAD_VALIDATE.validate_duplicate_item2('
493: || xErrLoc || '): ' || SQLERRM);
494: END validate_duplicate_item2;
495:
496: PROCEDURE check_pricelines(p_table_name IN VARCHAR2,

Line 537: 'Exception at ICX_POR_ITEM_UPLOAD_VALIDATE.check_pricelines('

533: WHEN OTHERS THEN
534: ROLLBACK;
535:
536: RAISE_APPLICATION_ERROR(-20000,
537: 'Exception at ICX_POR_ITEM_UPLOAD_VALIDATE.check_pricelines('
538: || xErrLoc || '): ' || SQLERRM);
539: END check_pricelines;
540:
541: /**

Line 564: IF ICX_POR_ITEM_UPLOAD_VALIDATE.g_debug_channel THEN

560: l_bus_group_id NUMBER := 0; --BUG#2228935
561: BEGIN
562: xErrLoc := 100;
563:
564: IF ICX_POR_ITEM_UPLOAD_VALIDATE.g_debug_channel THEN
565: ICX_POR_ITEM_UPLOAD_VALIDATE.g_job_number :=
566: substr(p_table_name,16,length(p_table_name)-instr(p_table_name,'_IT')+1);
567: ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name:=
568: 'ICX.PLSQL.LOADER.'|| ICX_POR_ITEM_UPLOAD_VALIDATE.g_job_number;

Line 565: ICX_POR_ITEM_UPLOAD_VALIDATE.g_job_number :=

561: BEGIN
562: xErrLoc := 100;
563:
564: IF ICX_POR_ITEM_UPLOAD_VALIDATE.g_debug_channel THEN
565: ICX_POR_ITEM_UPLOAD_VALIDATE.g_job_number :=
566: substr(p_table_name,16,length(p_table_name)-instr(p_table_name,'_IT')+1);
567: ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name:=
568: 'ICX.PLSQL.LOADER.'|| ICX_POR_ITEM_UPLOAD_VALIDATE.g_job_number;
569: fnd_global.apps_initialize(-1, -1, 178);

Line 567: ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name:=

563:
564: IF ICX_POR_ITEM_UPLOAD_VALIDATE.g_debug_channel THEN
565: ICX_POR_ITEM_UPLOAD_VALIDATE.g_job_number :=
566: substr(p_table_name,16,length(p_table_name)-instr(p_table_name,'_IT')+1);
567: ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name:=
568: 'ICX.PLSQL.LOADER.'|| ICX_POR_ITEM_UPLOAD_VALIDATE.g_job_number;
569: fnd_global.apps_initialize(-1, -1, 178);
570: fnd_profile.put('AFLOG_ENABLED', 'Y');
571: fnd_profile.put('AFLOG_MODULE', ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name);

Line 568: 'ICX.PLSQL.LOADER.'|| ICX_POR_ITEM_UPLOAD_VALIDATE.g_job_number;

564: IF ICX_POR_ITEM_UPLOAD_VALIDATE.g_debug_channel THEN
565: ICX_POR_ITEM_UPLOAD_VALIDATE.g_job_number :=
566: substr(p_table_name,16,length(p_table_name)-instr(p_table_name,'_IT')+1);
567: ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name:=
568: 'ICX.PLSQL.LOADER.'|| ICX_POR_ITEM_UPLOAD_VALIDATE.g_job_number;
569: fnd_global.apps_initialize(-1, -1, 178);
570: fnd_profile.put('AFLOG_ENABLED', 'Y');
571: fnd_profile.put('AFLOG_MODULE', ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name);
572: fnd_profile.put('AFLOG_LEVEL', '1');

Line 571: fnd_profile.put('AFLOG_MODULE', ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name);

567: ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name:=
568: 'ICX.PLSQL.LOADER.'|| ICX_POR_ITEM_UPLOAD_VALIDATE.g_job_number;
569: fnd_global.apps_initialize(-1, -1, 178);
570: fnd_profile.put('AFLOG_ENABLED', 'Y');
571: fnd_profile.put('AFLOG_MODULE', ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name);
572: fnd_profile.put('AFLOG_LEVEL', '1');
573: fnd_profile.put('AFLOG_FILENAME', '');
574: fnd_log_repository.init;
575: END IF;

Line 667: 'Exception at ICX_POR_ITEM_UPLOAD_VALIDATE.validate_interface_data('

663: WHEN OTHERS THEN
664: ROLLBACK;
665:
666: RAISE_APPLICATION_ERROR(-20000,
667: 'Exception at ICX_POR_ITEM_UPLOAD_VALIDATE.validate_interface_data('
668: || xErrLoc || '): ' || SQLERRM);
669: END validate_interface_data;
670:
671: /*

Line 691: ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name,

687: /*Insert the Debug SQL string */
688: WHILE l_start < l_sql_string_length LOOP
689: l_start := l_start + l_size;
690: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
691: ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name,
692: substrb(l_debug_sql_string,1,l_size));
693: l_debug_sql_string := substrb(l_debug_sql_string,l_size+1);
694: END LOOP;
695:

Line 701: ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name,

697: /*Insert the Debug Bind Variable string */
698: WHILE l_start < l_bind_string_length LOOP
699: l_start := l_start + l_size;
700: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
701: ICX_POR_ITEM_UPLOAD_VALIDATE.g_module_name,
702: substrb(l_debug_bind_variable,1,l_size));
703: l_debug_bind_variable := substrb(l_debug_bind_variable,l_size+1);
704: END LOOP;
705:

Line 713: ICX_POR_ITEM_UPLOAD_VALIDATE.g_debug_channel := true;

709: /* Procedure to set the debug channel*/
710: PROCEDURE set_debug_channel(p_debug_channel number) is
711: BEGIN
712: IF p_debug_channel=1 THEN
713: ICX_POR_ITEM_UPLOAD_VALIDATE.g_debug_channel := true;
714: ELSE
715: ICX_POR_ITEM_UPLOAD_VALIDATE.g_debug_channel :=false;
716: END IF;
717: END set_debug_channel;

Line 715: ICX_POR_ITEM_UPLOAD_VALIDATE.g_debug_channel :=false;

711: BEGIN
712: IF p_debug_channel=1 THEN
713: ICX_POR_ITEM_UPLOAD_VALIDATE.g_debug_channel := true;
714: ELSE
715: ICX_POR_ITEM_UPLOAD_VALIDATE.g_debug_channel :=false;
716: END IF;
717: END set_debug_channel;
718:
719:

Line 720: END ICX_POR_ITEM_UPLOAD_VALIDATE;

716: END IF;
717: END set_debug_channel;
718:
719:
720: END ICX_POR_ITEM_UPLOAD_VALIDATE;