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

Line 44: FND_FILE.PUT_LINE (FND_FILE.LOG, 'INSERT_WOO <<<');

40: l_num_rows NUMBER;
41: l_return BOOLEAN := TRUE;
42: BEGIN
43: IF (l_debug_flag = 'Y') THEN
44: FND_FILE.PUT_LINE (FND_FILE.LOG, 'INSERT_WOO <<<');
45: END IF;
46:
47: INSERT INTO WIP_OPERATION_OVERHEADS
48: (WIP_ENTITY_ID,

Line 169: FND_FILE.put_line(fnd_file.log, to_char(l_num_rows)||' rows inserted into WOO for Job: '||to_char(p_wip_entity_id));

165:
166: l_num_rows := SQL%ROWCOUNT;
167:
168: IF(l_debug_flag = 'Y') THEN
169: FND_FILE.put_line(fnd_file.log, to_char(l_num_rows)||' rows inserted into WOO for Job: '||to_char(p_wip_entity_id));
170: FND_FILE.PUT_LINE (FND_FILE.LOG, 'INSERT_WOO >>>');
171: END IF;
172: RETURN l_return;
173:

Line 170: FND_FILE.PUT_LINE (FND_FILE.LOG, 'INSERT_WOO >>>');

166: l_num_rows := SQL%ROWCOUNT;
167:
168: IF(l_debug_flag = 'Y') THEN
169: FND_FILE.put_line(fnd_file.log, to_char(l_num_rows)||' rows inserted into WOO for Job: '||to_char(p_wip_entity_id));
170: FND_FILE.PUT_LINE (FND_FILE.LOG, 'INSERT_WOO >>>');
171: END IF;
172: RETURN l_return;
173:
174: EXCEPTION

Line 177: FND_FILE.put_line(fnd_file.log, 'Failed to Insert into WOO: '||SQLERRM);

173:
174: EXCEPTION
175: WHEN OTHERS THEN
176: IF(l_debug_flag = 'Y') THEN
177: FND_FILE.put_line(fnd_file.log, 'Failed to Insert into WOO: '||SQLERRM);
178: END IF;
179: RETURN FALSE;
180:
181: END INSERT_WOO;

Line 346: FND_FILE.put_line(fnd_file.log, 'CSTPSMUT.COST_SPLIT_TXN <<<');

342: /* Check API Compatibility */
343: l_stmt_num := 10;
344:
345: IF(l_debug_flag = 'Y') THEN
346: FND_FILE.put_line(fnd_file.log, 'CSTPSMUT.COST_SPLIT_TXN <<<');
347: fnd_file.put_line(fnd_file.log, 'Costing Transaction: '||to_char(p_transaction_id));
348: END IF;
349:
350: IF NOT FND_API.COMPATIBLE_API_CALL (

Line 347: fnd_file.put_line(fnd_file.log, 'Costing Transaction: '||to_char(p_transaction_id));

343: l_stmt_num := 10;
344:
345: IF(l_debug_flag = 'Y') THEN
346: FND_FILE.put_line(fnd_file.log, 'CSTPSMUT.COST_SPLIT_TXN <<<');
347: fnd_file.put_line(fnd_file.log, 'Costing Transaction: '||to_char(p_transaction_id));
348: END IF;
349:
350: IF NOT FND_API.COMPATIBLE_API_CALL (
351: l_api_version,

Line 611: fnd_file.put_line(fnd_file.log, 'Net Cost to be Relieved from Rep. Lot: ');

607:
608: END LOOP; -- End Resulting Lots
609:
610: IF(l_debug_flag = 'Y') THEN
611: fnd_file.put_line(fnd_file.log, 'Net Cost to be Relieved from Rep. Lot: ');
612: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));
613: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
614: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
615: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));

Line 612: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));

608: END LOOP; -- End Resulting Lots
609:
610: IF(l_debug_flag = 'Y') THEN
611: fnd_file.put_line(fnd_file.log, 'Net Cost to be Relieved from Rep. Lot: ');
612: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));
613: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
614: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
615: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));
616: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));

Line 613: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));

609:
610: IF(l_debug_flag = 'Y') THEN
611: fnd_file.put_line(fnd_file.log, 'Net Cost to be Relieved from Rep. Lot: ');
612: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));
613: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
614: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
615: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));
616: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));
617: fnd_file.put_line(fnd_file.log, 'TL_OVH: '||to_char(l_total_tl_ovh));

Line 614: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));

610: IF(l_debug_flag = 'Y') THEN
611: fnd_file.put_line(fnd_file.log, 'Net Cost to be Relieved from Rep. Lot: ');
612: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));
613: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
614: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
615: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));
616: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));
617: fnd_file.put_line(fnd_file.log, 'TL_OVH: '||to_char(l_total_tl_ovh));
618: END IF;

Line 615: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));

611: fnd_file.put_line(fnd_file.log, 'Net Cost to be Relieved from Rep. Lot: ');
612: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));
613: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
614: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
615: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));
616: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));
617: fnd_file.put_line(fnd_file.log, 'TL_OVH: '||to_char(l_total_tl_ovh));
618: END IF;
619:

Line 616: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));

612: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));
613: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
614: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
615: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));
616: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));
617: fnd_file.put_line(fnd_file.log, 'TL_OVH: '||to_char(l_total_tl_ovh));
618: END IF;
619:
620: /* Only One Lot in Starting Jobs but cursor can be used since it is already there */

Line 617: fnd_file.put_line(fnd_file.log, 'TL_OVH: '||to_char(l_total_tl_ovh));

613: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
614: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
615: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));
616: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));
617: fnd_file.put_line(fnd_file.log, 'TL_OVH: '||to_char(l_total_tl_ovh));
618: END IF;
619:
620: /* Only One Lot in Starting Jobs but cursor can be used since it is already there */
621: FOR C_start in c_start_lot LOOP

Line 803: fnd_file.put_line(fnd_file.log, 'CSTPSMUT.COST_SPLIT_TXN >>>');

799: END IF;
800:
801: END IF;
802: IF(l_debug_flag = 'Y') THEN
803: fnd_file.put_line(fnd_file.log, 'CSTPSMUT.COST_SPLIT_TXN >>>');
804: END IF;
805:
806:
807: EXCEPTION

Line 812: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
809: x_err_num := -1;
810: x_err_code := 'Inconsistent API Version';--FND_API.G_RET_SYS_ERROR;
811: x_err_msg := 'Inconsistent API Version: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
812: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
813: WHEN GET_JOB_VALUE_FAILURE THEN
814: x_err_num := -1;
815: x_err_code := 'Error getting Job Charges/Scrap';
816: x_err_msg := 'Error getting Job Charges/Scrap: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 817: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

813: WHEN GET_JOB_VALUE_FAILURE THEN
814: x_err_num := -1;
815: x_err_code := 'Error getting Job Charges/Scrap';
816: x_err_msg := 'Error getting Job Charges/Scrap: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
817: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
818: WHEN FAILED_INSERTING_START_LOT THEN
819: x_err_num := -1;
820: x_err_code := 'Error Inserting WPB Information for Starting Lot';
821: x_err_msg := 'Error Inserting WPB Information for Starting Lot: CSTPSMUT.COST_SPLIT_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 1039: fnd_file.put_line(fnd_file.log, 'CSTPSMUT.COST_MERGE_TXN ... <<< ');

1035: /* Check API Compatibility */
1036: l_stmt_num := 10;
1037:
1038: IF(l_debug_flag = 'Y') THEN
1039: fnd_file.put_line(fnd_file.log, 'CSTPSMUT.COST_MERGE_TXN ... <<< ');
1040: fnd_file.put_line(fnd_file.log, 'Costing Transaction: '||to_char(p_transaction_id));
1041: END IF;
1042:
1043: IF NOT FND_API.COMPATIBLE_API_CALL (

Line 1040: fnd_file.put_line(fnd_file.log, 'Costing Transaction: '||to_char(p_transaction_id));

1036: l_stmt_num := 10;
1037:
1038: IF(l_debug_flag = 'Y') THEN
1039: fnd_file.put_line(fnd_file.log, 'CSTPSMUT.COST_MERGE_TXN ... <<< ');
1040: fnd_file.put_line(fnd_file.log, 'Costing Transaction: '||to_char(p_transaction_id));
1041: END IF;
1042:
1043: IF NOT FND_API.COMPATIBLE_API_CALL (
1044: l_api_version,

Line 1195: fnd_file.put_line(fnd_file.log, 'Processing Job: '||to_char(c_start.wip_entity_id));

1191: FOR c_start in c_start_lot LOOP
1192: IF (l_rep_wip_entity_id <> c_start.wip_entity_id) THEN
1193: l_stmt_num := 110;
1194: IF(l_debug_flag = 'Y') THEN
1195: fnd_file.put_line(fnd_file.log, 'Processing Job: '||to_char(c_start.wip_entity_id));
1196: END IF;
1197:
1198: CSTPSMUT.INSERT_MAT_TXN_ACCT(
1199: l_transaction_date,

Line 1467: fnd_file.put_line(fnd_file.log, 'Net Charges in Resulting Job: ');

1463: END IF;
1464:
1465: /* Only One Lot in Starting Jobs but cursor can be used since it is already there */
1466: IF(l_debug_flag = 'Y') THEN
1467: fnd_file.put_line(fnd_file.log, 'Net Charges in Resulting Job: ');
1468: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));
1469: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
1470: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
1471: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));

Line 1468: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));

1464:
1465: /* Only One Lot in Starting Jobs but cursor can be used since it is already there */
1466: IF(l_debug_flag = 'Y') THEN
1467: fnd_file.put_line(fnd_file.log, 'Net Charges in Resulting Job: ');
1468: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));
1469: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
1470: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
1471: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));
1472: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));

Line 1469: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));

1465: /* Only One Lot in Starting Jobs but cursor can be used since it is already there */
1466: IF(l_debug_flag = 'Y') THEN
1467: fnd_file.put_line(fnd_file.log, 'Net Charges in Resulting Job: ');
1468: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));
1469: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
1470: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
1471: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));
1472: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));
1473: fnd_file.put_line(fnd_file.log, 'TL_OVH: '||to_char(l_total_tl_ovh));

Line 1470: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));

1466: IF(l_debug_flag = 'Y') THEN
1467: fnd_file.put_line(fnd_file.log, 'Net Charges in Resulting Job: ');
1468: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));
1469: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
1470: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
1471: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));
1472: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));
1473: fnd_file.put_line(fnd_file.log, 'TL_OVH: '||to_char(l_total_tl_ovh));
1474: END IF;

Line 1471: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));

1467: fnd_file.put_line(fnd_file.log, 'Net Charges in Resulting Job: ');
1468: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));
1469: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
1470: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
1471: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));
1472: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));
1473: fnd_file.put_line(fnd_file.log, 'TL_OVH: '||to_char(l_total_tl_ovh));
1474: END IF;
1475:

Line 1472: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));

1468: fnd_file.put_line(fnd_file.log, 'PL_MTL: '||to_char(l_total_pl_mtl));
1469: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
1470: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
1471: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));
1472: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));
1473: fnd_file.put_line(fnd_file.log, 'TL_OVH: '||to_char(l_total_tl_ovh));
1474: END IF;
1475:
1476:

Line 1473: fnd_file.put_line(fnd_file.log, 'TL_OVH: '||to_char(l_total_tl_ovh));

1469: fnd_file.put_line(fnd_file.log, 'PL_MOH: '||to_char(l_total_pl_mto));
1470: fnd_file.put_line(fnd_file.log, 'PL_RES: '||to_char(l_total_pl_res));
1471: fnd_file.put_line(fnd_file.log, 'PL_OVH: '||to_char(l_total_pl_ovh));
1472: fnd_file.put_line(fnd_file.log, 'TL_RES: '||to_char(l_total_tl_res));
1473: fnd_file.put_line(fnd_file.log, 'TL_OVH: '||to_char(l_total_tl_ovh));
1474: END IF;
1475:
1476:
1477: l_stmt_num := 200;

Line 1479: fnd_file.put_line(fnd_file.log, 'Processing Result Lot: '||to_char(l_result_wip_entity_id));

1475:
1476:
1477: l_stmt_num := 200;
1478: IF(l_debug_flag = 'Y') THEN
1479: fnd_file.put_line(fnd_file.log, 'Processing Result Lot: '||to_char(l_result_wip_entity_id));
1480: END IF;
1481:
1482: /* Insert into MTA for Result Lot */
1483: CSTPSMUT.INSERT_MAT_TXN_ACCT(

Line 1661: fnd_file.put_line(fnd_file.log, 'CSTPSMUT.COST_MERGE_TXN ... >>> ');

1657: END IF;
1658:
1659:
1660: IF(l_debug_flag = 'Y') THEN
1661: fnd_file.put_line(fnd_file.log, 'CSTPSMUT.COST_MERGE_TXN ... >>> ');
1662: END IF;
1663:
1664: EXCEPTION
1665:

Line 1670: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1667: x_err_num := -1;
1668: x_err_code := 'Inconsistent API Version';--FND_API.G_RET_SYS_ERROR;
1669: x_err_msg := 'Inconsistent API Version: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
1670: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1671: WHEN GET_JOB_VALUE_FAILURE THEN
1672: x_err_num := -1;
1673: x_err_code := 'Error getting Job Charges/Scrap';
1674: x_err_msg := 'Error getting Job Charges/Scrap: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 1675: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

1671: WHEN GET_JOB_VALUE_FAILURE THEN
1672: x_err_num := -1;
1673: x_err_code := 'Error getting Job Charges/Scrap';
1674: x_err_msg := 'Error getting Job Charges/Scrap: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
1675: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1676: WHEN FAILED_INSERTING_START_LOT THEN
1677: x_err_num := -1;
1678: x_err_code := 'Error Inserting WPB Information for Starting Lot';
1679: x_err_msg := 'Error Inserting WPB Information for Starting Lot: CSTPSMUT.COST_MERGE_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 2230: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

2226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2227: x_err_num := -1;
2228: x_err_code := 'Inconsistent API Version';--FND_API.G_RET_SYS_ERROR;
2229: x_err_msg := 'Inconsistent API Version: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2230: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
2231: WHEN GET_JOB_VALUE_FAILURE THEN
2232: x_err_num := -1;
2233: x_err_code := 'Error getting Job Charges/Scrap';
2234: x_err_msg := 'Error getting Job Charges/Scrap: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 2235: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

2231: WHEN GET_JOB_VALUE_FAILURE THEN
2232: x_err_num := -1;
2233: x_err_code := 'Error getting Job Charges/Scrap';
2234: x_err_msg := 'Error getting Job Charges/Scrap: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2235: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
2236: WHEN FAILED_INSERTING_START_LOT THEN
2237: x_err_num := -1;
2238: x_err_code := 'Error Inserting WPB Information for Starting Lot';
2239: x_err_msg := 'Error Inserting WPB Information for Starting Lot: CSTPSMUT.COST_UPDATE_QTY_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 2381: fnd_file.put_line(fnd_file.log, 'CSTPSMUT.COST_BONUS_TXN <<<');

2377: BEGIN
2378: /* Check API Compatibility */
2379: l_stmt_num := 10;
2380: IF (l_debug_flag = 'Y') THEN
2381: fnd_file.put_line(fnd_file.log, 'CSTPSMUT.COST_BONUS_TXN <<<');
2382: END IF;
2383:
2384: IF NOT FND_API.COMPATIBLE_API_CALL (
2385: l_api_version,

Line 2479: fnd_file.put_line(fnd_file.log, 'WIP ENTITY : '||to_char(l_wip_entity_id));

2475: AND wo.organization_id = l_organization_id;
2476: END IF;
2477:
2478: IF ( l_debug_flag = 'Y' ) THEN
2479: fnd_file.put_line(fnd_file.log, 'WIP ENTITY : '||to_char(l_wip_entity_id));
2480: fnd_file.put_line(fnd_file.log, 'OPERATION_SEQ_NUM: '||to_char(l_operation_seq_num));
2481: END IF;
2482:
2483: /* Return success if Bonus occurs at the Queue Intraoperation step

Line 2480: fnd_file.put_line(fnd_file.log, 'OPERATION_SEQ_NUM: '||to_char(l_operation_seq_num));

2476: END IF;
2477:
2478: IF ( l_debug_flag = 'Y' ) THEN
2479: fnd_file.put_line(fnd_file.log, 'WIP ENTITY : '||to_char(l_wip_entity_id));
2480: fnd_file.put_line(fnd_file.log, 'OPERATION_SEQ_NUM: '||to_char(l_operation_seq_num));
2481: END IF;
2482:
2483: /* Return success if Bonus occurs at the Queue Intraoperation step
2484: of the first operation of the job.

Line 2787: fnd_file.put_line(fnd_file.log, 'CSTPSMUT.COST_BONUS_TXN >>>');

2783: END IF;
2784: END IF;
2785:
2786: IF (l_debug_flag = 'Y') THEN
2787: fnd_file.put_line(fnd_file.log, 'CSTPSMUT.COST_BONUS_TXN >>>');
2788: END IF;
2789:
2790: EXCEPTION
2791:

Line 2796: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

2792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2793: x_err_num := -1;
2794: x_err_code := 'Inconsistent API Version';--FND_API.G_RET_SYS_ERROR;
2795: x_err_msg := 'Inconsistent API Version: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2796: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
2797: WHEN GET_JOB_VALUE_FAILURE THEN
2798: x_err_num := -1;
2799: x_err_code := 'Error getting Job Charges/Scrap';
2800: x_err_msg := 'Error getting Job Charges/Scrap: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 2801: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

2797: WHEN GET_JOB_VALUE_FAILURE THEN
2798: x_err_num := -1;
2799: x_err_code := 'Error getting Job Charges/Scrap';
2800: x_err_msg := 'Error getting Job Charges/Scrap: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);
2801: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
2802: WHEN FAILED_INSERTING_START_LOT THEN
2803: x_err_num := -1;
2804: x_err_code := 'Error Inserting WPB Information for Starting Lot';
2805: x_err_msg := 'Error Inserting WPB Information for Starting Lot: CSTPSMUT.COST_BONUS_TXN('||to_char(l_stmt_num)||'):' || x_err_msg || substr(SQLERRM, 1, 200);

Line 3297: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.GET_JOB_VALUE <<<');

3293:
3294: END IF;
3295:
3296: IF(l_debug_flag = 'Y') THEN
3297: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.GET_JOB_VALUE <<<');
3298: FND_FILE.put_line(fnd_file.log,'Job: '||to_char(p_entity_id));
3299: FND_FILE.put_line(fnd_file.log,'Run Mode(1-Charge, 2-Scrap): ' ||to_char(p_run_mode));
3300: FND_FILE.put_line(fnd_file.log,'Transaction Type: ' ||to_char(p_txn_type));
3301: FND_FILE.put_line(fnd_file.log,'PL MTL COST: '||to_char(x_pl_mtl_cost));

Line 3298: FND_FILE.put_line(fnd_file.log,'Job: '||to_char(p_entity_id));

3294: END IF;
3295:
3296: IF(l_debug_flag = 'Y') THEN
3297: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.GET_JOB_VALUE <<<');
3298: FND_FILE.put_line(fnd_file.log,'Job: '||to_char(p_entity_id));
3299: FND_FILE.put_line(fnd_file.log,'Run Mode(1-Charge, 2-Scrap): ' ||to_char(p_run_mode));
3300: FND_FILE.put_line(fnd_file.log,'Transaction Type: ' ||to_char(p_txn_type));
3301: FND_FILE.put_line(fnd_file.log,'PL MTL COST: '||to_char(x_pl_mtl_cost));
3302: FND_FILE.put_line(fnd_file.log,'PL MOH COST: '||to_char(x_pl_mto_cost));

Line 3299: FND_FILE.put_line(fnd_file.log,'Run Mode(1-Charge, 2-Scrap): ' ||to_char(p_run_mode));

3295:
3296: IF(l_debug_flag = 'Y') THEN
3297: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.GET_JOB_VALUE <<<');
3298: FND_FILE.put_line(fnd_file.log,'Job: '||to_char(p_entity_id));
3299: FND_FILE.put_line(fnd_file.log,'Run Mode(1-Charge, 2-Scrap): ' ||to_char(p_run_mode));
3300: FND_FILE.put_line(fnd_file.log,'Transaction Type: ' ||to_char(p_txn_type));
3301: FND_FILE.put_line(fnd_file.log,'PL MTL COST: '||to_char(x_pl_mtl_cost));
3302: FND_FILE.put_line(fnd_file.log,'PL MOH COST: '||to_char(x_pl_mto_cost));
3303: FND_FILE.put_line(fnd_file.log,'PL RES COST: '||to_char(x_pl_res_cost));

Line 3300: FND_FILE.put_line(fnd_file.log,'Transaction Type: ' ||to_char(p_txn_type));

3296: IF(l_debug_flag = 'Y') THEN
3297: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.GET_JOB_VALUE <<<');
3298: FND_FILE.put_line(fnd_file.log,'Job: '||to_char(p_entity_id));
3299: FND_FILE.put_line(fnd_file.log,'Run Mode(1-Charge, 2-Scrap): ' ||to_char(p_run_mode));
3300: FND_FILE.put_line(fnd_file.log,'Transaction Type: ' ||to_char(p_txn_type));
3301: FND_FILE.put_line(fnd_file.log,'PL MTL COST: '||to_char(x_pl_mtl_cost));
3302: FND_FILE.put_line(fnd_file.log,'PL MOH COST: '||to_char(x_pl_mto_cost));
3303: FND_FILE.put_line(fnd_file.log,'PL RES COST: '||to_char(x_pl_res_cost));
3304: FND_FILE.put_line(fnd_file.log,'PL OSP COST: '||to_char(x_pl_osp_cost));

Line 3301: FND_FILE.put_line(fnd_file.log,'PL MTL COST: '||to_char(x_pl_mtl_cost));

3297: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.GET_JOB_VALUE <<<');
3298: FND_FILE.put_line(fnd_file.log,'Job: '||to_char(p_entity_id));
3299: FND_FILE.put_line(fnd_file.log,'Run Mode(1-Charge, 2-Scrap): ' ||to_char(p_run_mode));
3300: FND_FILE.put_line(fnd_file.log,'Transaction Type: ' ||to_char(p_txn_type));
3301: FND_FILE.put_line(fnd_file.log,'PL MTL COST: '||to_char(x_pl_mtl_cost));
3302: FND_FILE.put_line(fnd_file.log,'PL MOH COST: '||to_char(x_pl_mto_cost));
3303: FND_FILE.put_line(fnd_file.log,'PL RES COST: '||to_char(x_pl_res_cost));
3304: FND_FILE.put_line(fnd_file.log,'PL OSP COST: '||to_char(x_pl_osp_cost));
3305: FND_FILE.put_line(fnd_file.log,'PL OVH COST: '||to_char(x_pl_ovh_cost));

Line 3302: FND_FILE.put_line(fnd_file.log,'PL MOH COST: '||to_char(x_pl_mto_cost));

3298: FND_FILE.put_line(fnd_file.log,'Job: '||to_char(p_entity_id));
3299: FND_FILE.put_line(fnd_file.log,'Run Mode(1-Charge, 2-Scrap): ' ||to_char(p_run_mode));
3300: FND_FILE.put_line(fnd_file.log,'Transaction Type: ' ||to_char(p_txn_type));
3301: FND_FILE.put_line(fnd_file.log,'PL MTL COST: '||to_char(x_pl_mtl_cost));
3302: FND_FILE.put_line(fnd_file.log,'PL MOH COST: '||to_char(x_pl_mto_cost));
3303: FND_FILE.put_line(fnd_file.log,'PL RES COST: '||to_char(x_pl_res_cost));
3304: FND_FILE.put_line(fnd_file.log,'PL OSP COST: '||to_char(x_pl_osp_cost));
3305: FND_FILE.put_line(fnd_file.log,'PL OVH COST: '||to_char(x_pl_ovh_cost));
3306: FND_FILE.put_line(FND_FILE.log,'TL RES COST: '||to_char(x_tl_res_cost));

Line 3303: FND_FILE.put_line(fnd_file.log,'PL RES COST: '||to_char(x_pl_res_cost));

3299: FND_FILE.put_line(fnd_file.log,'Run Mode(1-Charge, 2-Scrap): ' ||to_char(p_run_mode));
3300: FND_FILE.put_line(fnd_file.log,'Transaction Type: ' ||to_char(p_txn_type));
3301: FND_FILE.put_line(fnd_file.log,'PL MTL COST: '||to_char(x_pl_mtl_cost));
3302: FND_FILE.put_line(fnd_file.log,'PL MOH COST: '||to_char(x_pl_mto_cost));
3303: FND_FILE.put_line(fnd_file.log,'PL RES COST: '||to_char(x_pl_res_cost));
3304: FND_FILE.put_line(fnd_file.log,'PL OSP COST: '||to_char(x_pl_osp_cost));
3305: FND_FILE.put_line(fnd_file.log,'PL OVH COST: '||to_char(x_pl_ovh_cost));
3306: FND_FILE.put_line(FND_FILE.log,'TL RES COST: '||to_char(x_tl_res_cost));
3307: FND_FILE.put_line(FND_FILE.log,'TL OSP COST: '||to_char(x_tl_osp_cost));

Line 3304: FND_FILE.put_line(fnd_file.log,'PL OSP COST: '||to_char(x_pl_osp_cost));

3300: FND_FILE.put_line(fnd_file.log,'Transaction Type: ' ||to_char(p_txn_type));
3301: FND_FILE.put_line(fnd_file.log,'PL MTL COST: '||to_char(x_pl_mtl_cost));
3302: FND_FILE.put_line(fnd_file.log,'PL MOH COST: '||to_char(x_pl_mto_cost));
3303: FND_FILE.put_line(fnd_file.log,'PL RES COST: '||to_char(x_pl_res_cost));
3304: FND_FILE.put_line(fnd_file.log,'PL OSP COST: '||to_char(x_pl_osp_cost));
3305: FND_FILE.put_line(fnd_file.log,'PL OVH COST: '||to_char(x_pl_ovh_cost));
3306: FND_FILE.put_line(FND_FILE.log,'TL RES COST: '||to_char(x_tl_res_cost));
3307: FND_FILE.put_line(FND_FILE.log,'TL OSP COST: '||to_char(x_tl_osp_cost));
3308: FND_FILE.put_line(FND_FILE.log,'TL OVH COST: '||to_char(x_tl_ovh_cost));

Line 3305: FND_FILE.put_line(fnd_file.log,'PL OVH COST: '||to_char(x_pl_ovh_cost));

3301: FND_FILE.put_line(fnd_file.log,'PL MTL COST: '||to_char(x_pl_mtl_cost));
3302: FND_FILE.put_line(fnd_file.log,'PL MOH COST: '||to_char(x_pl_mto_cost));
3303: FND_FILE.put_line(fnd_file.log,'PL RES COST: '||to_char(x_pl_res_cost));
3304: FND_FILE.put_line(fnd_file.log,'PL OSP COST: '||to_char(x_pl_osp_cost));
3305: FND_FILE.put_line(fnd_file.log,'PL OVH COST: '||to_char(x_pl_ovh_cost));
3306: FND_FILE.put_line(FND_FILE.log,'TL RES COST: '||to_char(x_tl_res_cost));
3307: FND_FILE.put_line(FND_FILE.log,'TL OSP COST: '||to_char(x_tl_osp_cost));
3308: FND_FILE.put_line(FND_FILE.log,'TL OVH COST: '||to_char(x_tl_ovh_cost));
3309: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.GET_JOB_VALUE >>>');

Line 3306: FND_FILE.put_line(FND_FILE.log,'TL RES COST: '||to_char(x_tl_res_cost));

3302: FND_FILE.put_line(fnd_file.log,'PL MOH COST: '||to_char(x_pl_mto_cost));
3303: FND_FILE.put_line(fnd_file.log,'PL RES COST: '||to_char(x_pl_res_cost));
3304: FND_FILE.put_line(fnd_file.log,'PL OSP COST: '||to_char(x_pl_osp_cost));
3305: FND_FILE.put_line(fnd_file.log,'PL OVH COST: '||to_char(x_pl_ovh_cost));
3306: FND_FILE.put_line(FND_FILE.log,'TL RES COST: '||to_char(x_tl_res_cost));
3307: FND_FILE.put_line(FND_FILE.log,'TL OSP COST: '||to_char(x_tl_osp_cost));
3308: FND_FILE.put_line(FND_FILE.log,'TL OVH COST: '||to_char(x_tl_ovh_cost));
3309: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.GET_JOB_VALUE >>>');
3310: END IF;

Line 3307: FND_FILE.put_line(FND_FILE.log,'TL OSP COST: '||to_char(x_tl_osp_cost));

3303: FND_FILE.put_line(fnd_file.log,'PL RES COST: '||to_char(x_pl_res_cost));
3304: FND_FILE.put_line(fnd_file.log,'PL OSP COST: '||to_char(x_pl_osp_cost));
3305: FND_FILE.put_line(fnd_file.log,'PL OVH COST: '||to_char(x_pl_ovh_cost));
3306: FND_FILE.put_line(FND_FILE.log,'TL RES COST: '||to_char(x_tl_res_cost));
3307: FND_FILE.put_line(FND_FILE.log,'TL OSP COST: '||to_char(x_tl_osp_cost));
3308: FND_FILE.put_line(FND_FILE.log,'TL OVH COST: '||to_char(x_tl_ovh_cost));
3309: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.GET_JOB_VALUE >>>');
3310: END IF;
3311:

Line 3308: FND_FILE.put_line(FND_FILE.log,'TL OVH COST: '||to_char(x_tl_ovh_cost));

3304: FND_FILE.put_line(fnd_file.log,'PL OSP COST: '||to_char(x_pl_osp_cost));
3305: FND_FILE.put_line(fnd_file.log,'PL OVH COST: '||to_char(x_pl_ovh_cost));
3306: FND_FILE.put_line(FND_FILE.log,'TL RES COST: '||to_char(x_tl_res_cost));
3307: FND_FILE.put_line(FND_FILE.log,'TL OSP COST: '||to_char(x_tl_osp_cost));
3308: FND_FILE.put_line(FND_FILE.log,'TL OVH COST: '||to_char(x_tl_ovh_cost));
3309: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.GET_JOB_VALUE >>>');
3310: END IF;
3311:
3312: EXCEPTION

Line 3309: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.GET_JOB_VALUE >>>');

3305: FND_FILE.put_line(fnd_file.log,'PL OVH COST: '||to_char(x_pl_ovh_cost));
3306: FND_FILE.put_line(FND_FILE.log,'TL RES COST: '||to_char(x_tl_res_cost));
3307: FND_FILE.put_line(FND_FILE.log,'TL OSP COST: '||to_char(x_tl_osp_cost));
3308: FND_FILE.put_line(FND_FILE.log,'TL OVH COST: '||to_char(x_tl_ovh_cost));
3309: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.GET_JOB_VALUE >>>');
3310: END IF;
3311:
3312: EXCEPTION
3313: when others then

Line 3387: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.UPDATE_JOB_QUANTITY <<<');

3383:
3384: BEGIN
3385: l_stmt_num := 10;
3386: IF(l_debug_flag = 'Y') THEN
3387: FND_FILE.put_line(fnd_file.log,'CSTPSMUT.UPDATE_JOB_QUANTITY <<<');
3388: END IF;
3389:
3390: IF NOT FND_API.COMPATIBLE_API_CALL (
3391: l_api_version,

Line 3718: FND_FILE.put_line(fnd_file.log, 'Job: '||to_char(C_rec1.wip_entity_id));

3714: FOR C_rec1 IN C_RJ LOOP
3715: l_scale_factor := C_rec1.start_quantity/l_available_quantity;
3716:
3717: IF(l_debug_flag = 'Y') THEN
3718: FND_FILE.put_line(fnd_file.log, 'Job: '||to_char(C_rec1.wip_entity_id));
3719: FND_FILE.put_line(fnd_file.log,'Updating the Non Representative Lots by the scale factor: '||to_char(l_scale_factor));
3720: END IF;
3721:
3722: IF C_rec1.wip_entity_id = l_rep_wip_entity_id THEN

Line 3719: FND_FILE.put_line(fnd_file.log,'Updating the Non Representative Lots by the scale factor: '||to_char(l_scale_factor));

3715: l_scale_factor := C_rec1.start_quantity/l_available_quantity;
3716:
3717: IF(l_debug_flag = 'Y') THEN
3718: FND_FILE.put_line(fnd_file.log, 'Job: '||to_char(C_rec1.wip_entity_id));
3719: FND_FILE.put_line(fnd_file.log,'Updating the Non Representative Lots by the scale factor: '||to_char(l_scale_factor));
3720: END IF;
3721:
3722: IF C_rec1.wip_entity_id = l_rep_wip_entity_id THEN
3723: l_resulting_job := 1;

Line 3813: FND_FILE.put_line(fnd_file.log,'Updating Resulting Job that is part of Start Job:(App-Rel)*F + Rel: '||to_char(l_resulting_scale_factor));

3809:
3810: IF (l_resulting_job = 1) THEN
3811:
3812: IF(l_debug_flag = 'Y') THEN
3813: FND_FILE.put_line(fnd_file.log,'Updating Resulting Job that is part of Start Job:(App-Rel)*F + Rel: '||to_char(l_resulting_scale_factor));
3814: END IF;
3815: l_stmt_num := 100;
3816:
3817: UPDATE wip_operation_resources wor

Line 3938: FND_FILE.put_line(fnd_file.log,'Updating Resulting Job that is not part of Start Job:App = Rel: '||to_char(S_rec.wip_entity_id));

3934: END;
3935: IF ( l_resulting_job = 0 ) THEN
3936:
3937: IF(l_debug_flag = 'Y') THEN
3938: FND_FILE.put_line(fnd_file.log,'Updating Resulting Job that is not part of Start Job:App = Rel: '||to_char(S_rec.wip_entity_id));
3939: END IF;
3940:
3941: l_stmt_num := 120;
3942:

Line 3996: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

3992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3993: x_err_num := -1;
3994: x_err_code := 'Inconsistent API Version';--FND_API.G_RET_SYS_ERROR;
3995: x_err_msg := 'CSTPSMUT.UPDATE_JOB_QUANTITY('||to_char(l_stmt_num)||'):'|| x_err_msg || substr(SQLERRM, 1, 200);
3996: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
3997: WHEN OTHERS THEN
3998: x_err_num := -1;
3999: x_err_code := 'Error Updating Quantity';
4000: x_err_msg := 'CSTPSMUT.UPDATE_JOB_QUANTITY('||to_char(l_stmt_num)||'): ' || substr(SQLERRM, 1, 200);

Line 4001: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

3997: WHEN OTHERS THEN
3998: x_err_num := -1;
3999: x_err_code := 'Error Updating Quantity';
4000: x_err_msg := 'CSTPSMUT.UPDATE_JOB_QUANTITY('||to_char(l_stmt_num)||'): ' || substr(SQLERRM, 1, 200);
4001: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
4002: END update_job_quantity;
4003:
4004: -------------------------------------------------------------------------
4005: ------------------- END CHANGES FOR OSFM_I ------------------------------

Line 4277: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)

4273:
4274: l_rows_inserted := SQL%ROWCOUNT;
4275:
4276: IF (l_rows_inserted > 0 ) and (p_debug = 'Y') THEN
4277: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)
4278: || ' row(s) inserted '
4279: || 'into mtl_material_transactions.'
4280: || ', mtl_txn_id: '
4281: || p_mtl_txn_id

Line 4364: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)

4360: WHERE transaction_id = p_wip_txn_id);
4361:
4362: l_rows_inserted := SQL%ROWCOUNT;
4363: IF (l_rows_inserted > 0 and p_debug = 'Y') THEN
4364: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)
4365: || ' row(s) inserted ' ||
4366: 'into wip_transactions.');
4367: END IF;
4368: l_rows_inserted := 0;

Line 4476: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(l_rows_inserted)

4472: SET INV_SUB_LEDGER_ID = CST_INV_SUB_LEDGER_ID_S.NEXTVAL
4473: WHERE TRANSACTION_ID = p_mtl_txn_id;
4474:
4475: IF (l_rows_inserted > 0) and (p_debug = 'Y')THEN
4476: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(l_rows_inserted)
4477: || ' row(s) inserted '
4478: || 'into mtl_transaction_accounts.'
4479: || ',mtl_txn_id: '
4480: || p_mtl_txn_id

Line 4605: FND_FILE.put_line(FND_FILE.LOG,'CSTPSMUT.INSERT_WIP_TXN_ACCT: wip_txn_id: '|| p_wip_txn_id);

4601: p_err_num := 0;
4602: l_stmt_num := 10;
4603:
4604: IF (p_debug = 'Y') THEN
4605: FND_FILE.put_line(FND_FILE.LOG,'CSTPSMUT.INSERT_WIP_TXN_ACCT: wip_txn_id: '|| p_wip_txn_id);
4606: END IF;
4607:
4608: FOR c1 IN c_elements LOOP
4609: INSERT INTO WIP_TRANSACTION_ACCOUNTS

Line 4656: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)

4652: l_rows_inserted := l_rows_inserted + SQL%ROWCOUNT;
4653: END LOOP;
4654:
4655: IF (l_rows_inserted > 0) and (p_debug = 'Y') THEN
4656: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)
4657: || 'row(s) inserted '
4658: || 'into wip_transaction_accounts.'
4659: || ', wip_entity_id: '
4660: || p_wip_id);

Line 4674: fnd_file.put_line(fnd_file.log, 'Insert into MTA Failed: '||p_err_msg || substr(SQLERRM, 1, 250));

4670: || '); ,'
4671: || to_char(p_err_num);
4672: p_err_code := null;
4673: IF ( p_debug = 'Y' ) THEN
4674: fnd_file.put_line(fnd_file.log, 'Insert into MTA Failed: '||p_err_msg || substr(SQLERRM, 1, 250));
4675: END IF;
4676: END INSERT_WIP_TXN_ACCT;
4677:
4678: PROCEDURE BONUS_MAT_TXN_ACCT(p_date IN DATE,

Line 4734: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)

4730: SET INV_SUB_LEDGER_ID = CST_INV_SUB_LEDGER_ID_S.NEXTVAL
4731: WHERE TRANSACTION_ID = p_mtl_txn_id;
4732:
4733: IF (l_rows_inserted > 0 and p_debug = 'Y') THEN
4734: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)
4735: || ' row(s) inserted '
4736: || 'into mtl_transaction_accounts '
4737: || ', mtl_txn_id: '
4738: || p_mtl_txn_id);

Line 4802: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted) || 'row(s) inserted ' ||

4798: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL
4799: WHERE TRANSACTION_ID = p_wip_txn_id;
4800: l_rows_inserted := SQL%ROWCOUNT;
4801: IF (l_rows_inserted > 0 and p_debug = 'Y') THEN
4802: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted) || 'row(s) inserted ' ||
4803: 'into wip_transaction_accounts.');
4804: END IF;
4805: END BONUS_WIP_TXN_ACCT;
4806:

Line 4988: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)

4984: WHERE transaction_id = p_rl_mtl_txn_id);
4985:
4986: l_rows_inserted := SQL%ROWCOUNT;
4987: IF (p_debug = 'Y') and (l_rows_inserted > 0) THEN
4988: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)
4989: || ' row(s) updated '
4990: || 'in wip_period_balances for mtl txn acct.');
4991: END IF;
4992: l_rows_inserted := 0;

Line 5027: FND_FILE.put_line(FND_FILE.log,to_char(l_rows_inserted)

5023:
5024: l_rows_inserted := SQL%ROWCOUNT;
5025:
5026: IF (p_debug = 'Y') and (l_rows_inserted > 0 ) THEN
5027: FND_FILE.put_line(FND_FILE.log,to_char(l_rows_inserted)
5028: || ' row(s) updated '
5029: || 'in wip_period_balances for wip txn acct.');
5030: END IF;
5031: l_rows_inserted := 0;