APPS.JL_ZZ_AUTO_INVOICE dependencies on FND_FILE

Line 1251: fnd_file.put_line(fnd_file.log,'JL msg: RowID fetched');

1247: EXCEPTION
1248: WHEN OTHERS THEN
1249: l_rowid := '999';
1250: END;
1251: fnd_file.put_line(fnd_file.log,'JL msg: RowID fetched');
1252:
1253: /* Fetching Additional Towing Attributes from Shipping GDF using
1254: Unique delivery Name */
1255: BEGIN

Line 1306: fnd_file.put_line(fnd_file.log,'JL msg: Row ID '||l_rowid);

1302: -- BUG 11825724
1303: -- END
1304:
1305: IF l_rowid IS NOT NULL THEN
1306: fnd_file.put_line(fnd_file.log,'JL msg: Row ID '||l_rowid);
1307:
1308: -- Checking if Record already exists in JL Extension Table
1309: SELECT count(*) INTO l_count FROM JL_BR_INTERFACE_LINES_EXTS
1310: WHERE JL_BR_INTERFACE_LINK_ID = l_rowid;

Line 1311: fnd_file.put_line(fnd_file.log,'JL msg: Count '||l_count);

1307:
1308: -- Checking if Record already exists in JL Extension Table
1309: SELECT count(*) INTO l_count FROM JL_BR_INTERFACE_LINES_EXTS
1310: WHERE JL_BR_INTERFACE_LINK_ID = l_rowid;
1311: fnd_file.put_line(fnd_file.log,'JL msg: Count '||l_count);
1312: IF l_count = 0 THEN
1313: -- Inserting Data into JL Extension Table
1314: INSERT INTO JL_BR_INTERFACE_LINES_EXTS (JL_BR_INTERFACE_LINK_ID,
1315: HEADER_GDF_ATTRIBUTE31,

Line 1498: fnd_file.put_line(fnd_file.log,'IN jl_br_cm_upd_inv_status :'||SQLCODE||'-'||SQLERRM);

1494:
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: l_status_code := 0;
1498: fnd_file.put_line(fnd_file.log,'IN jl_br_cm_upd_inv_status :'||SQLCODE||'-'||SQLERRM);
1499: return l_status_code;
1500: END jl_br_cm_upd_inv_status;
1501:
1502: