DBA Data[Home] [Help]

APPS.EGO_ITEM_OPEN_INTERFACE_PVT dependencies on FND_FILE

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

413: EXIT WHEN c_error_result%NOTFOUND;
414: IF l_flash_heading THEN
415: l_flash_heading := FALSE;
416: l_temp_text := 'Entity Name: '||p_entity_name||' Table Name: '||p_table_name||FND_GLOBAL.Local_Chr(10);
417: FND_FILE.put_line(FND_FILE.LOG,'*Error Messages*'||FND_GLOBAL.Local_Chr(10)||l_temp_text);
418: l_temp_text:=' Item_Number '||' Org_Code '||' Message';
419: FND_FILE.put_line(FND_FILE.LOG,l_temp_text);
420: END IF;
421: FND_FILE.put_line(FND_FILE.LOG,l_item_number||' '||l_org_code||' '||l_error_msg);

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

415: l_flash_heading := FALSE;
416: l_temp_text := 'Entity Name: '||p_entity_name||' Table Name: '||p_table_name||FND_GLOBAL.Local_Chr(10);
417: FND_FILE.put_line(FND_FILE.LOG,'*Error Messages*'||FND_GLOBAL.Local_Chr(10)||l_temp_text);
418: l_temp_text:=' Item_Number '||' Org_Code '||' Message';
419: FND_FILE.put_line(FND_FILE.LOG,l_temp_text);
420: END IF;
421: FND_FILE.put_line(FND_FILE.LOG,l_item_number||' '||l_org_code||' '||l_error_msg);
422: END LOOP;
423: IF c_error_result%ISOPEN THEN

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

417: FND_FILE.put_line(FND_FILE.LOG,'*Error Messages*'||FND_GLOBAL.Local_Chr(10)||l_temp_text);
418: l_temp_text:=' Item_Number '||' Org_Code '||' Message';
419: FND_FILE.put_line(FND_FILE.LOG,l_temp_text);
420: END IF;
421: FND_FILE.put_line(FND_FILE.LOG,l_item_number||' '||l_org_code||' '||l_error_msg);
422: END LOOP;
423: IF c_error_result%ISOPEN THEN
424: CLOSE c_error_result;
425: END IF;

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

725: --Bug# 4540712 (RSOUNDAR)
726: ---------------------------------------------
727: IF NVL(l_request_id, -1) <> -1 THEN
728: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
729: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
730: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
731: l_temp_message := FND_MESSAGE.GET;
732: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
733: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);

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

731: l_temp_message := FND_MESSAGE.GET;
732: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
733: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
734: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
735: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
736:
737: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
738: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
739: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');

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

733: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_message);
734: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
735: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
736:
737: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
738: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
739: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');
740: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
741: FOR i IN (SELECT msii.TRANSACTION_TYPE, msii.ITEM_NUMBER, NVL(msii.ORGANIZATION_CODE, mp.ORGANIZATION_CODE) AS ORGANIZATION_CODE

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

734: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', l_request_id);
735: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
736:
737: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
738: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
739: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');
740: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
741: FOR i IN (SELECT msii.TRANSACTION_TYPE, msii.ITEM_NUMBER, NVL(msii.ORGANIZATION_CODE, mp.ORGANIZATION_CODE) AS ORGANIZATION_CODE
742: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

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

735: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
736:
737: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
738: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
739: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');
740: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
741: FOR i IN (SELECT msii.TRANSACTION_TYPE, msii.ITEM_NUMBER, NVL(msii.ORGANIZATION_CODE, mp.ORGANIZATION_CODE) AS ORGANIZATION_CODE
742: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
743: WHERE msii.SET_PROCESS_ID = p_batch_id

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

736:
737: FND_FILE.put_line(FND_FILE.LOG, 'Following items got processed in this batch');
738: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
739: FND_FILE.put_line(FND_FILE.LOG, 'TRANSACTION TYPE ORGANIZATION CODE ITEM NUMBER');
740: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
741: FOR i IN (SELECT msii.TRANSACTION_TYPE, msii.ITEM_NUMBER, NVL(msii.ORGANIZATION_CODE, mp.ORGANIZATION_CODE) AS ORGANIZATION_CODE
742: FROM MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
743: WHERE msii.SET_PROCESS_ID = p_batch_id
744: AND msii.REQUEST_ID = l_request_id

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

747: AND msii.PROCESS_FLAG = 7
748: AND NVL(msii.CONFIRM_STATUS, 'X') NOT IN ('CFC', 'CFM', 'FMR', 'UFN', 'UFS', 'UFM', 'FK', 'FEX')
749: )
750: LOOP
751: FND_FILE.put_line(FND_FILE.LOG, RPAD(i.TRANSACTION_TYPE, 16, ' ') ||' '||RPAD(i.ORGANIZATION_CODE, 17, ' ') ||' '||i.ITEM_NUMBER);
752: END LOOP;
753: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
754: END IF;
755: EXCEPTION

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

749: )
750: LOOP
751: FND_FILE.put_line(FND_FILE.LOG, RPAD(i.TRANSACTION_TYPE, 16, ' ') ||' '||RPAD(i.ORGANIZATION_CODE, 17, ' ') ||' '||i.ITEM_NUMBER);
752: END LOOP;
753: FND_FILE.put_line(FND_FILE.LOG, '----------------------------------------------------');
754: END IF;
755: EXCEPTION
756: WHEN OTHERS THEN
757: IF l_inv_debug_level IN(101, 102) THEN