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.BOM_BULKLOAD_PVT_PKG dependencies on FND_FILE

Line 103: FND_FILE.PUT_LINE( FND_FILE.LOG, '['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);

99:
100: -- NOTE: No need to check for profile now, as Error_Handler checks
101: -- for Error_Handler.Get_Debug = 'Y' before writing to Debug Log.
102: IF l_debug = 'Y' THEN
103: FND_FILE.PUT_LINE( FND_FILE.LOG, '['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
104: END IF;
105: END;
106:
107: PROCEDURE open_debug_session IS

Line 152: FND_FILE.put_line(FND_FILE.LOG, ' Log file location --> '||l_log_output_dir||'/'||G_ERROR_FILE_NAME ||' created with status '|| l_log_return_status);

148: ,x_return_status => l_log_return_status
149: ,x_error_mesg => l_errbuff
150: );
151:
152: FND_FILE.put_line(FND_FILE.LOG, ' Log file location --> '||l_log_output_dir||'/'||G_ERROR_FILE_NAME ||' created with status '|| l_log_return_status);
153:
154: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
155: FND_FILE.put_line(FND_FILE.LOG, 'Unable to open error log file. Error => '||l_errbuff);
156: END IF;

Line 155: FND_FILE.put_line(FND_FILE.LOG, 'Unable to open error log file. Error => '||l_errbuff);

151:
152: FND_FILE.put_line(FND_FILE.LOG, ' Log file location --> '||l_log_output_dir||'/'||G_ERROR_FILE_NAME ||' created with status '|| l_log_return_status);
153:
154: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
155: FND_FILE.put_line(FND_FILE.LOG, 'Unable to open error log file. Error => '||l_errbuff);
156: END IF;
157:
158: END IF;--IF c_get_utl_file_dir%FOUND THEN
159:

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

749: END IF;
750: G_CONCREQ_VALID_FLAG := TRUE;
751:
752: IF (G_CONCREQ_VALID_FLAG ) THEN
753: FND_FILE.put_line(FND_FILE.LOG, ' ******** New Log ******** ');
754: END IF;
755:
756: -- the values are chosen from the FND_GLOBALS
757: G_USER_ID := FND_GLOBAL.user_id ;

Line 784: FND_FILE.PUT_LINE( FND_FILE.LOG,'No Rows to Process for Data Separation' );

780: /* Return if no rows to process
781: * Should we be updating the requestIds?? Test
782: */
783: if (NOT Interface_Rows_Exist(p_resultfmt_usage_id)) then
784: FND_FILE.PUT_LINE( FND_FILE.LOG,'No Rows to Process for Data Separation' );
785: return;
786: end if;
787:
788: -- Getting the Intf_column names from the ego_results_fmt_usages for the attributes

Line 791: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE before :--->' || G_INTF_ORG_CODE);

787:
788: -- Getting the Intf_column names from the ego_results_fmt_usages for the attributes
789: -- of OrgCode and CompSeqId. Previously we hard-coding them
790: IF l_debug = 'Y' THEN
791: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE before :--->' || G_INTF_ORG_CODE);
792: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID before :--->' || G_INTF_COMP_SEQ_ID);
793: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ASSEMBLY_TYPE before :--->' || G_INTF_ASSEMBLY_TYPE);
794: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION before :--->' || G_INTF_PARENT_REVISION);
795: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION before :--->' || G_INTF_REVISION);

Line 792: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID before :--->' || G_INTF_COMP_SEQ_ID);

788: -- Getting the Intf_column names from the ego_results_fmt_usages for the attributes
789: -- of OrgCode and CompSeqId. Previously we hard-coding them
790: IF l_debug = 'Y' THEN
791: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE before :--->' || G_INTF_ORG_CODE);
792: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID before :--->' || G_INTF_COMP_SEQ_ID);
793: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ASSEMBLY_TYPE before :--->' || G_INTF_ASSEMBLY_TYPE);
794: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION before :--->' || G_INTF_PARENT_REVISION);
795: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION before :--->' || G_INTF_REVISION);
796: END IF;

Line 793: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ASSEMBLY_TYPE before :--->' || G_INTF_ASSEMBLY_TYPE);

789: -- of OrgCode and CompSeqId. Previously we hard-coding them
790: IF l_debug = 'Y' THEN
791: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE before :--->' || G_INTF_ORG_CODE);
792: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID before :--->' || G_INTF_COMP_SEQ_ID);
793: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ASSEMBLY_TYPE before :--->' || G_INTF_ASSEMBLY_TYPE);
794: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION before :--->' || G_INTF_PARENT_REVISION);
795: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION before :--->' || G_INTF_REVISION);
796: END IF;
797:

Line 794: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION before :--->' || G_INTF_PARENT_REVISION);

790: IF l_debug = 'Y' THEN
791: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE before :--->' || G_INTF_ORG_CODE);
792: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID before :--->' || G_INTF_COMP_SEQ_ID);
793: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ASSEMBLY_TYPE before :--->' || G_INTF_ASSEMBLY_TYPE);
794: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION before :--->' || G_INTF_PARENT_REVISION);
795: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION before :--->' || G_INTF_REVISION);
796: END IF;
797:
798: Select INTF_COLUMN_NAME into G_INTF_ORG_CODE FROM Ego_Results_Fmt_Usages erf

Line 795: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION before :--->' || G_INTF_REVISION);

791: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE before :--->' || G_INTF_ORG_CODE);
792: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID before :--->' || G_INTF_COMP_SEQ_ID);
793: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ASSEMBLY_TYPE before :--->' || G_INTF_ASSEMBLY_TYPE);
794: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION before :--->' || G_INTF_PARENT_REVISION);
795: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION before :--->' || G_INTF_REVISION);
796: END IF;
797:
798: Select INTF_COLUMN_NAME into G_INTF_ORG_CODE FROM Ego_Results_Fmt_Usages erf
799: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'ORGANIZATION_CODE';

Line 834: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE after :--->' || G_INTF_ORG_CODE);

830: G_INTF_REVISION := 'NULL';
831: END;
832:
833: IF l_debug = 'Y' THEN
834: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE after :--->' || G_INTF_ORG_CODE);
835: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID after :--->' || G_INTF_COMP_SEQ_ID);
836: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ASSEMBLY_TYPE after :--->' || G_INTF_ASSEMBLY_TYPE);
837: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION after :--->' || G_INTF_PARENT_REVISION);
838: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION after :--->' || G_INTF_REVISION);

Line 835: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID after :--->' || G_INTF_COMP_SEQ_ID);

831: END;
832:
833: IF l_debug = 'Y' THEN
834: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE after :--->' || G_INTF_ORG_CODE);
835: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID after :--->' || G_INTF_COMP_SEQ_ID);
836: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ASSEMBLY_TYPE after :--->' || G_INTF_ASSEMBLY_TYPE);
837: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION after :--->' || G_INTF_PARENT_REVISION);
838: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION after :--->' || G_INTF_REVISION);
839: END IF;

Line 836: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ASSEMBLY_TYPE after :--->' || G_INTF_ASSEMBLY_TYPE);

832:
833: IF l_debug = 'Y' THEN
834: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE after :--->' || G_INTF_ORG_CODE);
835: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID after :--->' || G_INTF_COMP_SEQ_ID);
836: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ASSEMBLY_TYPE after :--->' || G_INTF_ASSEMBLY_TYPE);
837: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION after :--->' || G_INTF_PARENT_REVISION);
838: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION after :--->' || G_INTF_REVISION);
839: END IF;
840:

Line 837: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION after :--->' || G_INTF_PARENT_REVISION);

833: IF l_debug = 'Y' THEN
834: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE after :--->' || G_INTF_ORG_CODE);
835: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID after :--->' || G_INTF_COMP_SEQ_ID);
836: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ASSEMBLY_TYPE after :--->' || G_INTF_ASSEMBLY_TYPE);
837: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION after :--->' || G_INTF_PARENT_REVISION);
838: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION after :--->' || G_INTF_REVISION);
839: END IF;
840:
841: --bug 13829520 begin

Line 838: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION after :--->' || G_INTF_REVISION);

834: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE after :--->' || G_INTF_ORG_CODE);
835: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID after :--->' || G_INTF_COMP_SEQ_ID);
836: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ASSEMBLY_TYPE after :--->' || G_INTF_ASSEMBLY_TYPE);
837: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION after :--->' || G_INTF_PARENT_REVISION);
838: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION after :--->' || G_INTF_REVISION);
839: END IF;
840:
841: --bug 13829520 begin
842: IF (G_INTF_COMP_SEQ_ID IS NOT NULL AND G_INTF_COMP_SEQ_ID <> 'NULL') THEN

Line 869: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering First Loop ');

865: SET Transaction_Id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
866: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND PROCESS_STATUS = 1 ;
867:
868: IF l_debug = 'Y' THEN
869: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering First Loop ');
870: END IF;
871:
872: --Sreejith
873:

Line 916: FND_FILE.PUT_LINE( FND_FILE.LOG,'Exiting First Loop ');

912: i := i+1;
913: END LOOP;
914:
915: IF l_debug = 'Y' THEN
916: FND_FILE.PUT_LINE( FND_FILE.LOG,'Exiting First Loop ');
917: END IF;
918:
919: -- Added by hgelli for supporting import formats
920: -----------------------------------------------------

Line 1034: FND_FILE.PUT_LINE( FND_FILE.LOG,' TIMEZONE conversion stuff ' || l_dyn_sql);

1030: l_dyn_sql := l_dyn_sql || ' AND PROCESS_STATUS = 1 ';
1031: Write_Debug(' TIMEZONE conversion stuff ' || l_dyn_sql);
1032:
1033: IF l_debug = 'Y' THEN
1034: FND_FILE.PUT_LINE( FND_FILE.LOG,' TIMEZONE conversion stuff ' || l_dyn_sql);
1035: END IF;
1036:
1037: EXECUTE IMMEDIATE l_dyn_sql USING p_Resultfmt_Usage_Id;
1038: END IF;

Line 1102: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering First SQL 1-->' || l_dyn_sql);

1098:
1099: l_dyn_sql := l_dyn_sql_insert || ' ' || l_dyn_sql_select;
1100:
1101: IF l_debug = 'Y' THEN
1102: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering First SQL 1-->' || l_dyn_sql);
1103: END IF;
1104:
1105: EXECUTE IMMEDIATE l_dyn_sql USING p_batch_id,p_batch_id,p_batch_id,p_resultfmt_usage_id;
1106:

Line 1145: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 2.1-->' || l_dyn_sql_cursor);

1141: l_dyn_sql_cursor := l_dyn_sql_cursor || ' ORDER BY ' || G_INTF_ASSEMBLY_TYPE || ' ';
1142: END IF;
1143:
1144: IF l_debug = 'Y' THEN
1145: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 2.1-->' || l_dyn_sql_cursor);
1146: END IF;
1147:
1148:
1149: l_cursor_select := Dbms_Sql.Open_Cursor;

Line 1168: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 2.2-->' || p_resultfmt_usage_id);

1164: Dbms_Sql.Bind_Variable(l_cursor_select,':3', p_batch_id);
1165: Dbms_Sql.Bind_Variable(l_cursor_select,':4', p_resultfmt_usage_id);
1166:
1167: IF l_debug = 'Y' THEN
1168: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 2.2-->' || p_resultfmt_usage_id);
1169: END IF;
1170:
1171: l_cursor_execute := Dbms_Sql.EXECUTE(l_cursor_select);
1172:

Line 1174: FND_FILE.PUT_LINE( FND_FILE.LOG,'SUCCESS');

1170:
1171: l_cursor_execute := Dbms_Sql.EXECUTE(l_cursor_select);
1172:
1173: IF l_debug = 'Y' THEN
1174: FND_FILE.PUT_LINE( FND_FILE.LOG,'SUCCESS');
1175: END IF;
1176: i := 1;
1177: LOOP
1178: IF (Dbms_Sql.Fetch_Rows(l_cursor_select) > 0) THEN

Line 1417: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 2 -->' || l_dyn_sql);

1413:
1414: l_dyn_sql := l_dyn_sql_insert || ' ' || l_dyn_sql_select;
1415:
1416: IF l_debug = 'Y' THEN
1417: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 2 -->' || l_dyn_sql);
1418: END IF;
1419:
1420:
1421: EXECUTE IMMEDIATE l_dyn_sql USING p_batch_id,p_batch_id,p_resultfmt_usage_id;

Line 1424: FND_FILE.PUT_LINE( FND_FILE.LOG,'Executed Succesfully 2');

1420:
1421: EXECUTE IMMEDIATE l_dyn_sql USING p_batch_id,p_batch_id,p_resultfmt_usage_id;
1422: -- End of Process Components for UPDATE
1423: IF l_debug = 'Y' THEN
1424: FND_FILE.PUT_LINE( FND_FILE.LOG,'Executed Succesfully 2');
1425: END IF;
1426:
1427: IF l_debug = 'Y' THEN
1428: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 3-->' || l_dyn_sql);

Line 1428: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 3-->' || l_dyn_sql);

1424: FND_FILE.PUT_LINE( FND_FILE.LOG,'Executed Succesfully 2');
1425: END IF;
1426:
1427: IF l_debug = 'Y' THEN
1428: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 3-->' || l_dyn_sql);
1429: END IF;
1430:
1431:
1432: Dbms_Sql.Close_Cursor(l_cursor_select);

Line 1501: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 4-->' || l_dyn_sql);

1497:
1498: l_dyn_sql := l_dyn_sql_insert || ' ' || l_dyn_sql_select;
1499:
1500: IF l_debug = 'Y' THEN
1501: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 4-->' || l_dyn_sql);
1502: END IF;
1503:
1504: EXECUTE IMMEDIATE l_dyn_sql USING p_batch_id,p_batch_id,p_resultfmt_usage_id;
1505: -- End of Process Components for CREATE/ADD

Line 1508: FND_FILE.PUT_LINE( FND_FILE.LOG,'Executed Succesfully 4');

1504: EXECUTE IMMEDIATE l_dyn_sql USING p_batch_id,p_batch_id,p_resultfmt_usage_id;
1505: -- End of Process Components for CREATE/ADD
1506:
1507: IF l_debug = 'Y' THEN
1508: FND_FILE.PUT_LINE( FND_FILE.LOG,'Executed Succesfully 4');
1509: END IF;
1510:
1511: -- Start of process components for Delete
1512: l_dyn_sql_insert := '';

Line 1568: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 5-->' || l_dyn_sql);

1564:
1565: l_dyn_sql := l_dyn_sql_insert || ' ' || l_dyn_sql_select;
1566:
1567: IF l_debug = 'Y' THEN
1568: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering SQL 5-->' || l_dyn_sql);
1569: END IF;
1570:
1571: EXECUTE IMMEDIATE l_dyn_sql USING p_batch_id,p_batch_id,p_resultfmt_usage_id;
1572: -- End of process components for Delete

Line 1575: FND_FILE.PUT_LINE( FND_FILE.LOG,'Before UPdate of AssemblyType');

1571: EXECUTE IMMEDIATE l_dyn_sql USING p_batch_id,p_batch_id,p_resultfmt_usage_id;
1572: -- End of process components for Delete
1573:
1574: IF l_debug = 'Y' THEN
1575: FND_FILE.PUT_LINE( FND_FILE.LOG,'Before UPdate of AssemblyType');
1576: END IF;
1577:
1578: -- Updateing the assembly_type to 2 for BOM_header
1579: UPDATE BOM_BILL_OF_MTLS_INTERFACE SET assembly_type = 2

Line 1584: FND_FILE.PUT_LINE( FND_FILE.LOG,'After UPdate of AssemblyType');

1580: WHERE assembly_type IS NULL
1581: AND batch_id = p_batch_id;
1582:
1583: IF l_debug = 'Y' THEN
1584: FND_FILE.PUT_LINE( FND_FILE.LOG,'After UPdate of AssemblyType');
1585: END IF;
1586:
1587: /* Commenting the primary creation, as now we can create eng alternates with out primary.
1588: -- iNSERT ROWS FOR PRIMARY ALTERNATE FOR creating primary bom if it doesn't exist

Line 1691: FND_FILE.PUT_LINE( FND_FILE.LOG,'item_cole_name--' || l_item_col_name);

1687: END IF;
1688:
1689:
1690: IF l_debug = 'Y' THEN
1691: FND_FILE.PUT_LINE( FND_FILE.LOG,'item_cole_name--' || l_item_col_name);
1692: FND_FILE.PUT_LINE( FND_FILE.LOG,'Update Sql for ego bulkload for Multi Row-->' || l_upd_sql);
1693: END IF;
1694:
1695: EXECUTE IMMEDIATE l_upd_sql USING p_resultfmt_usage_id;

Line 1692: FND_FILE.PUT_LINE( FND_FILE.LOG,'Update Sql for ego bulkload for Multi Row-->' || l_upd_sql);

1688:
1689:
1690: IF l_debug = 'Y' THEN
1691: FND_FILE.PUT_LINE( FND_FILE.LOG,'item_cole_name--' || l_item_col_name);
1692: FND_FILE.PUT_LINE( FND_FILE.LOG,'Update Sql for ego bulkload for Multi Row-->' || l_upd_sql);
1693: END IF;
1694:
1695: EXECUTE IMMEDIATE l_upd_sql USING p_resultfmt_usage_id;
1696:

Line 1846: FND_FILE.PUT_LINE( FND_FILE.LOG,'Done Processing');

1842: COMMIT; */
1843: x_retcode := G_STATUS_SUCCESS;
1844:
1845: IF l_debug = 'Y' THEN
1846: FND_FILE.PUT_LINE( FND_FILE.LOG,'Done Processing');
1847: END IF;
1848:
1849: --Error_Handler.Write_Debug('Structure Import : UPDATE : l_err_text = ' || l_err_text);
1850:

Line 1860: FND_FILE.PUT_LINE( FND_FILE.LOG,'Completed Processing');

1856: ,x_retcode => l_retcode
1857: );
1858: */
1859: IF l_debug = 'Y' THEN
1860: FND_FILE.PUT_LINE( FND_FILE.LOG,'Completed Processing');
1861: END IF;
1862:
1863: --Error_Handler.Write_Debug('Updated the Process Status to Indicate Successful/Unsucessful component/structure Import Completion');
1864:

Line 1871: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Message ' || x_errbuff);

1867: l_err_text := SQLERRM;
1868: x_errbuff := 'Error : '||TO_CHAR(SQLCODE)||'---'||SQLERRM;
1869: x_retcode := Error_Handler.G_STATUS_ERROR;
1870: IF l_debug = 'Y' THEN
1871: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Message ' || x_errbuff);
1872: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Code' || x_retcode);
1873: END IF;
1874: Error_Handler.Close_Debug_Session;
1875:

Line 1872: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Code' || x_retcode);

1868: x_errbuff := 'Error : '||TO_CHAR(SQLCODE)||'---'||SQLERRM;
1869: x_retcode := Error_Handler.G_STATUS_ERROR;
1870: IF l_debug = 'Y' THEN
1871: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Message ' || x_errbuff);
1872: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Code' || x_retcode);
1873: END IF;
1874: Error_Handler.Close_Debug_Session;
1875:
1876: END PROCESS_BOM_INTERFACE_LINES;