DBA Data[Home] [Help]

APPS.EGO_ITEM_OPEN_INTERFACE_PVT dependencies on FND_FILE

Line 477: FND_FILE.put_line(FND_FILE.LOG,'*Error Messages*'||FND_GLOBAL.Local_Chr(10)||l_temp_text);

473: EXIT WHEN c_error_result%NOTFOUND;
474: IF l_flash_heading THEN
475: l_flash_heading := FALSE;
476: l_temp_text := 'Entity Name: '||p_entity_name||' Table Name: '||p_table_name||FND_GLOBAL.Local_Chr(10);
477: FND_FILE.put_line(FND_FILE.LOG,'*Error Messages*'||FND_GLOBAL.Local_Chr(10)||l_temp_text);
478: l_temp_text:=' Item_Number '||' Org_Code '||' Message';
479: FND_FILE.put_line(FND_FILE.LOG,l_temp_text);
480: END IF;
481: FND_FILE.put_line(FND_FILE.LOG,l_item_number||' '||l_org_code||' '||l_error_msg);

Line 479: FND_FILE.put_line(FND_FILE.LOG,l_temp_text);

475: l_flash_heading := FALSE;
476: l_temp_text := 'Entity Name: '||p_entity_name||' Table Name: '||p_table_name||FND_GLOBAL.Local_Chr(10);
477: FND_FILE.put_line(FND_FILE.LOG,'*Error Messages*'||FND_GLOBAL.Local_Chr(10)||l_temp_text);
478: l_temp_text:=' Item_Number '||' Org_Code '||' Message';
479: FND_FILE.put_line(FND_FILE.LOG,l_temp_text);
480: END IF;
481: FND_FILE.put_line(FND_FILE.LOG,l_item_number||' '||l_org_code||' '||l_error_msg);
482: END LOOP;
483: IF c_error_result%ISOPEN THEN

Line 481: FND_FILE.put_line(FND_FILE.LOG,l_item_number||' '||l_org_code||' '||l_error_msg);

477: FND_FILE.put_line(FND_FILE.LOG,'*Error Messages*'||FND_GLOBAL.Local_Chr(10)||l_temp_text);
478: l_temp_text:=' Item_Number '||' Org_Code '||' Message';
479: FND_FILE.put_line(FND_FILE.LOG,l_temp_text);
480: END IF;
481: FND_FILE.put_line(FND_FILE.LOG,l_item_number||' '||l_org_code||' '||l_error_msg);
482: END LOOP;
483: IF c_error_result%ISOPEN THEN
484: CLOSE c_error_result;
485: END IF;

Line 789: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

785: --Bug# 4540712 (RSOUNDAR)
786: ---------------------------------------------
787: IF NVL(l_request_id, -1) <> -1 THEN
788: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
789: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
790: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
791: l_temp_message := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
792: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
793: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);

Line 795: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

791: l_temp_message := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
792: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
793: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
794: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
795: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
796:
797: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
798: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
799: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');

Line 797: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');

793: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
794: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
795: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
796:
797: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
798: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
799: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');
800: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
801:

Line 798: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');

794: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
795: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
796:
797: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
798: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
799: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');
800: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
801:
802:

Line 799: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');

795: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
796:
797: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
798: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
799: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');
800: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
801:
802:
803: --

Line 800: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');

796:
797: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
798: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
799: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');
800: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
801:
802:
803: --
804: -- Bug 11901255. Log not showing assigned items.

Line 819: FND_FILE.put_line(FND_FILE.LOG, RPAD(i.TRANSACTION_TYPE, 16, ' ') ||' '||RPAD(i.ORGANIZATION_CODE, 17, ' ') ||' '||i.ITEM_NUMBER);

815: AND msii.PROCESS_FLAG = 7
816: AND NVL(msii.CONFIRM_STATUS, 'X') NOT IN ('CFC', 'CFM', 'FMR', 'UFN', 'UFS', 'UFM', 'FK', 'FEX')
817: )
818: LOOP
819: FND_FILE.put_line(FND_FILE.LOG, RPAD(i.TRANSACTION_TYPE, 16, ' ') ||' '||RPAD(i.ORGANIZATION_CODE, 17, ' ') ||' '||i.ITEM_NUMBER);
820: END LOOP;
821: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
822: END IF;
823: EXCEPTION

Line 821: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');

817: )
818: LOOP
819: FND_FILE.put_line(FND_FILE.LOG, RPAD(i.TRANSACTION_TYPE, 16, ' ') ||' '||RPAD(i.ORGANIZATION_CODE, 17, ' ') ||' '||i.ITEM_NUMBER);
820: END LOOP;
821: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
822: END IF;
823: EXCEPTION
824: WHEN OTHERS THEN
825: IF l_inv_debug_level IN(101, 102) THEN