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.CSP_TRANSACTIONS_PUB dependencies on FND_LOG

Line 52: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

48: where line_id = p_line_id;
49:
50: begin
51:
52: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
53: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
54: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',
55: 'Begin');
56: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 53: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

49:
50: begin
51:
52: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
53: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
54: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',
55: 'Begin');
56: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
57: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',

Line 56: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

52: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
53: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
54: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',
55: 'Begin');
56: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
57: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',
58: 'p_line_id = ' || p_line_id);
59: end if;
60:

Line 67: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

63: close c_quantity_delivered;
64:
65: l_quantity_delivered := nvl(l_quantity_delivered,0);
66:
67: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
68: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
69: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',
70: 'l_quantity_delivered = ' || l_quantity_delivered);
71: end if;

Line 68: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

64:
65: l_quantity_delivered := nvl(l_quantity_delivered,0);
66:
67: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
68: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
69: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',
70: 'l_quantity_delivered = ' || l_quantity_delivered);
71: end if;
72:

Line 122: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

118: end if;
119: end if;
120: end if;
121:
122: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
123: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
124: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',
125: 'x_return_status = ' || x_return_status
126: || ', x_msg_count = ' || x_msg_count

Line 123: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

119: end if;
120: end if;
121:
122: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
123: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
124: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',
125: 'x_return_status = ' || x_return_status
126: || ', x_msg_count = ' || x_msg_count
127: || ', x_msg_data = ' || x_msg_data);

Line 2462: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2458: (Only if requirement is for a Task)
2459: -> Stamp this new reservation_id to requirement line detail record
2460: */
2461:
2462: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2463: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2464: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2465: 'Begin');
2466: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2463: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2459: -> Stamp this new reservation_id to requirement line detail record
2460: */
2461:
2462: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2463: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2464: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2465: 'Begin');
2466: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2467: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2466: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2462: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2463: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2464: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2465: 'Begin');
2466: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2467: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2468: 'p_trans_type=' || p_trans_type);
2469:
2470: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2470: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2466: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2467: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2468: 'p_trans_type=' || p_trans_type);
2469:
2470: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2471: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2472: 'p_trans_header_id=' || p_trans_header_id);
2473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2474: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2469:
2470: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2471: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2472: 'p_trans_header_id=' || p_trans_header_id);
2473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2474: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2475: 'p_trans_line_id=' || p_trans_line_id);
2476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2477: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2472: 'p_trans_header_id=' || p_trans_header_id);
2473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2474: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2475: 'p_trans_line_id=' || p_trans_line_id);
2476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2477: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2478: 'p_req_line_detail_id=' || p_req_line_detail_id);
2479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2480: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2475: 'p_trans_line_id=' || p_trans_line_id);
2476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2477: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2478: 'p_req_line_detail_id=' || p_req_line_detail_id);
2479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2480: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2481: 'p_close_short=' || p_close_short);
2482:
2483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2480: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2481: 'p_close_short=' || p_close_short);
2482:
2483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2484: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2485: 'p_trans_record.INVENTORY_ITEM_ID=' || p_trans_record.INVENTORY_ITEM_ID);
2486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2487: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2482:
2483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2484: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2485: 'p_trans_record.INVENTORY_ITEM_ID=' || p_trans_record.INVENTORY_ITEM_ID);
2486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2487: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2488: 'p_trans_record.REVISION=' || p_trans_record.REVISION);
2489: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2490: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2489: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2485: 'p_trans_record.INVENTORY_ITEM_ID=' || p_trans_record.INVENTORY_ITEM_ID);
2486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2487: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2488: 'p_trans_record.REVISION=' || p_trans_record.REVISION);
2489: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2490: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2491: 'p_trans_record.QUANTITY=' || p_trans_record.QUANTITY);
2492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2493: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2488: 'p_trans_record.REVISION=' || p_trans_record.REVISION);
2489: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2490: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2491: 'p_trans_record.QUANTITY=' || p_trans_record.QUANTITY);
2492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2493: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2494: 'p_trans_record.UOM_CODE=' || p_trans_record.UOM_CODE);
2495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2496: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2491: 'p_trans_record.QUANTITY=' || p_trans_record.QUANTITY);
2492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2493: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2494: 'p_trans_record.UOM_CODE=' || p_trans_record.UOM_CODE);
2495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2496: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2497: 'p_trans_record.LOT_NUMBER=' || p_trans_record.LOT_NUMBER);
2498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2499: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2494: 'p_trans_record.UOM_CODE=' || p_trans_record.UOM_CODE);
2495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2496: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2497: 'p_trans_record.LOT_NUMBER=' || p_trans_record.LOT_NUMBER);
2498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2499: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2500: 'p_trans_record.SERIAL_NUMBER=' || p_trans_record.SERIAL_NUMBER);
2501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2502: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2497: 'p_trans_record.LOT_NUMBER=' || p_trans_record.LOT_NUMBER);
2498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2499: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2500: 'p_trans_record.SERIAL_NUMBER=' || p_trans_record.SERIAL_NUMBER);
2501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2502: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2503: 'p_trans_record.FRM_ORGANIZATION_ID=' || p_trans_record.FRM_ORGANIZATION_ID);
2504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2505: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2500: 'p_trans_record.SERIAL_NUMBER=' || p_trans_record.SERIAL_NUMBER);
2501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2502: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2503: 'p_trans_record.FRM_ORGANIZATION_ID=' || p_trans_record.FRM_ORGANIZATION_ID);
2504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2505: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2506: 'p_trans_record.FRM_SUBINVENTORY_CODE=' || p_trans_record.FRM_SUBINVENTORY_CODE);
2507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2508: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2503: 'p_trans_record.FRM_ORGANIZATION_ID=' || p_trans_record.FRM_ORGANIZATION_ID);
2504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2505: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2506: 'p_trans_record.FRM_SUBINVENTORY_CODE=' || p_trans_record.FRM_SUBINVENTORY_CODE);
2507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2508: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2509: 'p_trans_record.FRM_LOCATOR_ID=' || p_trans_record.FRM_LOCATOR_ID);
2510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2511: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2506: 'p_trans_record.FRM_SUBINVENTORY_CODE=' || p_trans_record.FRM_SUBINVENTORY_CODE);
2507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2508: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2509: 'p_trans_record.FRM_LOCATOR_ID=' || p_trans_record.FRM_LOCATOR_ID);
2510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2511: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2512: 'p_trans_record.TO_ORGANIZATION_ID=' || p_trans_record.TO_ORGANIZATION_ID);
2513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2514: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2509: 'p_trans_record.FRM_LOCATOR_ID=' || p_trans_record.FRM_LOCATOR_ID);
2510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2511: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2512: 'p_trans_record.TO_ORGANIZATION_ID=' || p_trans_record.TO_ORGANIZATION_ID);
2513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2514: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2515: 'p_trans_record.TO_SUBINVENTORY_CODE=' || p_trans_record.TO_SUBINVENTORY_CODE);
2516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2517: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2512: 'p_trans_record.TO_ORGANIZATION_ID=' || p_trans_record.TO_ORGANIZATION_ID);
2513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2514: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2515: 'p_trans_record.TO_SUBINVENTORY_CODE=' || p_trans_record.TO_SUBINVENTORY_CODE);
2516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2517: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2518: 'p_trans_record.TO_LOCATOR_ID=' || p_trans_record.TO_LOCATOR_ID);
2519: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2520: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2519: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2515: 'p_trans_record.TO_SUBINVENTORY_CODE=' || p_trans_record.TO_SUBINVENTORY_CODE);
2516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2517: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2518: 'p_trans_record.TO_LOCATOR_ID=' || p_trans_record.TO_LOCATOR_ID);
2519: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2520: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2521: 'p_trans_record.TO_SERIAL_NUMBER=' || p_trans_record.TO_SERIAL_NUMBER);
2522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2523: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2518: 'p_trans_record.TO_LOCATOR_ID=' || p_trans_record.TO_LOCATOR_ID);
2519: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2520: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2521: 'p_trans_record.TO_SERIAL_NUMBER=' || p_trans_record.TO_SERIAL_NUMBER);
2522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2523: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2524: 'p_trans_record.WAYBILL_AIRBILL=' || p_trans_record.WAYBILL_AIRBILL);
2525: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2526: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2525: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2521: 'p_trans_record.TO_SERIAL_NUMBER=' || p_trans_record.TO_SERIAL_NUMBER);
2522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2523: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2524: 'p_trans_record.WAYBILL_AIRBILL=' || p_trans_record.WAYBILL_AIRBILL);
2525: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2526: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2527: 'p_trans_record.FREIGHT_CODE=' || p_trans_record.FREIGHT_CODE);
2528: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2529: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2528: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2524: 'p_trans_record.WAYBILL_AIRBILL=' || p_trans_record.WAYBILL_AIRBILL);
2525: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2526: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2527: 'p_trans_record.FREIGHT_CODE=' || p_trans_record.FREIGHT_CODE);
2528: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2529: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2530: 'p_trans_record.SHIPMENT_NUMBER=' || p_trans_record.SHIPMENT_NUMBER);
2531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2532: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2527: 'p_trans_record.FREIGHT_CODE=' || p_trans_record.FREIGHT_CODE);
2528: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2529: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2530: 'p_trans_record.SHIPMENT_NUMBER=' || p_trans_record.SHIPMENT_NUMBER);
2531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2532: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2533: 'p_trans_record.PACKLIST_LINE_ID=' || p_trans_record.PACKLIST_LINE_ID);
2534: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2535: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2534: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2530: 'p_trans_record.SHIPMENT_NUMBER=' || p_trans_record.SHIPMENT_NUMBER);
2531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2532: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2533: 'p_trans_record.PACKLIST_LINE_ID=' || p_trans_record.PACKLIST_LINE_ID);
2534: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2535: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2536: 'p_trans_record.TEMP_TRANSACTION_ID=' || p_trans_record.TEMP_TRANSACTION_ID);
2537: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2538: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2537: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2533: 'p_trans_record.PACKLIST_LINE_ID=' || p_trans_record.PACKLIST_LINE_ID);
2534: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2535: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2536: 'p_trans_record.TEMP_TRANSACTION_ID=' || p_trans_record.TEMP_TRANSACTION_ID);
2537: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2538: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2539: 'p_trans_record.ERROR_MSG=' || p_trans_record.ERROR_MSG);
2540: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2541: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2540: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2536: 'p_trans_record.TEMP_TRANSACTION_ID=' || p_trans_record.TEMP_TRANSACTION_ID);
2537: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2538: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2539: 'p_trans_record.ERROR_MSG=' || p_trans_record.ERROR_MSG);
2540: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2541: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2542: 'p_trans_record.SHIPMENT_LINE_ID=' || p_trans_record.SHIPMENT_LINE_ID);
2543:
2544: end if;

Line 2551: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2547:
2548:
2549: l_remaining_quantity := 0;
2550:
2551: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2553: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2554: 'p_close_short=' || p_close_short);
2555: end if;

Line 2552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2548:
2549: l_remaining_quantity := 0;
2550:
2551: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2553: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2554: 'p_close_short=' || p_close_short);
2555: end if;
2556:

Line 2565: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2561: x_msg_data => x_msg_count,
2562: x_msg_count => x_msg_data
2563: );
2564:
2565: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2567: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2568: 'After calling CSP_SCH_INT_PVT.CANCEL_RESERVATION...');
2569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2562: x_msg_count => x_msg_data
2563: );
2564:
2565: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2567: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2568: 'After calling CSP_SCH_INT_PVT.CANCEL_RESERVATION...');
2569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2570: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2565: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2567: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2568: 'After calling CSP_SCH_INT_PVT.CANCEL_RESERVATION...');
2569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2570: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2571: 'x_return_status=' || x_return_status ||
2572: ', x_msg_count=' || x_msg_count ||
2573: ', x_msg_data=' || x_msg_data);

Line 2579: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2575: else
2576: l_inv_reservation_rec.reservation_id := p_trans_header_id;
2577: l_relieved_quantity := p_trans_record.QUANTITY;
2578:
2579: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2580: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2581: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2582: 'Before calling inv_reservation_pub.relieve_reservation for reservation_id = '
2583: || l_inv_reservation_rec.reservation_id || ' and qty = ' || l_relieved_quantity);

Line 2580: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2576: l_inv_reservation_rec.reservation_id := p_trans_header_id;
2577: l_relieved_quantity := p_trans_record.QUANTITY;
2578:
2579: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2580: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2581: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2582: 'Before calling inv_reservation_pub.relieve_reservation for reservation_id = '
2583: || l_inv_reservation_rec.reservation_id || ' and qty = ' || l_relieved_quantity);
2584: end if;

Line 2605: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2601: fnd_msg_pub.count_and_get
2602: ( p_count => x_msg_count
2603: , p_data => x_msg_data);
2604:
2605: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2606: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2607: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2608: 'After calling inv_reservation_pub.relieve_reservation...');
2609: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2606: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2602: ( p_count => x_msg_count
2603: , p_data => x_msg_data);
2604:
2605: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2606: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2607: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2608: 'After calling inv_reservation_pub.relieve_reservation...');
2609: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2610: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2609: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2605: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2606: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2607: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2608: 'After calling inv_reservation_pub.relieve_reservation...');
2609: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2610: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2611: 'x_return_status=' || x_return_status ||
2612: ', x_msg_count=' || x_msg_count ||
2613: ', x_msg_data=' || x_msg_data ||

Line 2629: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2625: p_trans_record.FRM_SUBINVENTORY_CODE,
2626: p_trans_record.TO_ORGANIZATION_ID,
2627: p_trans_record.TO_SUBINVENTORY_CODE);
2628:
2629: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2630: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2631: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2632: 'l_actual_trans_type=' || l_actual_trans_type);
2633: end if;

Line 2630: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2626: p_trans_record.TO_ORGANIZATION_ID,
2627: p_trans_record.TO_SUBINVENTORY_CODE);
2628:
2629: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2630: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2631: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2632: 'l_actual_trans_type=' || l_actual_trans_type);
2633: end if;
2634:

Line 2639: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2635: l_Trans_Items(1) := p_trans_record;
2636:
2637: if l_actual_trans_type = 'SUBINVTRANS' then
2638:
2639: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2641: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2642: 'Before calling transact_subinv_transfer...');
2643: end if;

Line 2640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2636:
2637: if l_actual_trans_type = 'SUBINVTRANS' then
2638:
2639: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2641: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2642: 'Before calling transact_subinv_transfer...');
2643: end if;
2644:

Line 2655: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2651: X_Msg_Count => x_msg_count,
2652: X_Msg_Data => x_msg_data
2653: );
2654:
2655: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2656: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2657: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2658: 'After calling transact_subinv_transfer...');
2659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2656: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2652: X_Msg_Data => x_msg_data
2653: );
2654:
2655: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2656: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2657: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2658: 'After calling transact_subinv_transfer...');
2659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2660: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2655: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2656: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2657: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2658: 'After calling transact_subinv_transfer...');
2659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2660: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2661: 'x_return_status=' || x_return_status ||
2662: ', x_msg_count=' || x_msg_count ||
2663: ', x_msg_data=' || x_msg_data);

Line 2673: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2669: if l_actual_trans_type = 'INTORG_I' then
2670: l_if_intransit := true;
2671: end if;
2672:
2673: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2674: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2675: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2676: 'Before calling transact_intorg_transfer...');
2677: end if;

Line 2674: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2670: l_if_intransit := true;
2671: end if;
2672:
2673: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2674: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2675: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2676: 'Before calling transact_intorg_transfer...');
2677: end if;
2678:

Line 2690: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2686: X_Msg_Count => x_msg_count,
2687: X_Msg_Data => x_msg_data
2688: );
2689:
2690: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2691: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2692: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2693: 'After calling transact_intorg_transfer...');
2694: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2691: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2687: X_Msg_Data => x_msg_data
2688: );
2689:
2690: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2691: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2692: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2693: 'After calling transact_intorg_transfer...');
2694: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2695: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2694: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2690: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2691: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2692: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2693: 'After calling transact_intorg_transfer...');
2694: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2695: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2696: 'x_return_status=' || x_return_status ||
2697: ', x_msg_count=' || x_msg_count ||
2698: ', x_msg_data=' || x_msg_data);

Line 2719: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2715: --close check_task_req;
2716:
2717: -- remove this req_line_details link
2718: if l_remaining_quantity = 0 or p_close_short = 'Y' then
2719: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2720: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2721: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2722: 'Before calling csp_req_line_details_pkg.delete_row...');
2723: end if;

Line 2720: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2716:
2717: -- remove this req_line_details link
2718: if l_remaining_quantity = 0 or p_close_short = 'Y' then
2719: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2720: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2721: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2722: 'Before calling csp_req_line_details_pkg.delete_row...');
2723: end if;
2724: csp_req_line_details_pkg.delete_row(p_req_line_detail_id);

Line 2739: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2735: l_RESERVATION_REC.quantity_needed := p_trans_record.QUANTITY;
2736: l_RESERVATION_REC.revision := p_trans_record.REVISION;
2737: l_RESERVATION_REC.line_id := l_requirement_line_id;
2738:
2739: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2740: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2741: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2742: 'Before calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2743: end if;

Line 2740: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2736: l_RESERVATION_REC.revision := p_trans_record.REVISION;
2737: l_RESERVATION_REC.line_id := l_requirement_line_id;
2738:
2739: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2740: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2741: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2742: 'Before calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2743: end if;
2744:

Line 2750: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2746: p_reservation_parts => l_RESERVATION_REC,
2747: x_return_status => x_return_status,
2748: x_msg_data => x_msg_data);
2749:
2750: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2751: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2752: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2753: 'After calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2754: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2751: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2747: x_return_status => x_return_status,
2748: x_msg_data => x_msg_data);
2749:
2750: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2751: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2752: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2753: 'After calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2754: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2755: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2754: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2750: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2751: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2752: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2753: 'After calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2754: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2755: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2756: 'x_return_status=' || x_return_status ||
2757: ', x_msg_data=' || x_msg_data ||
2758: ', l_new_reservation_id=' || l_new_reservation_id);

Line 2766: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2762: l_req_line_detail_id := p_req_line_detail_id;
2763:
2764: if l_remaining_quantity = 0 or p_close_short = 'Y' then
2765:
2766: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2768: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2769: 'Before calling csp_req_line_details_pkg.Update_Row...');
2770: end if;

Line 2767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2763:
2764: if l_remaining_quantity = 0 or p_close_short = 'Y' then
2765:
2766: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2767: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2768: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2769: 'Before calling csp_req_line_details_pkg.Update_Row...');
2770: end if;
2771:

Line 2783: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2779: p_SOURCE_TYPE => 'RES',
2780: p_SOURCE_ID => l_new_reservation_id);
2781: else
2782:
2783: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2784: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2785: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2786: 'Before calling csp_req_line_details_pkg.Insert_Row...');
2787: end if;

Line 2784: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2780: p_SOURCE_ID => l_new_reservation_id);
2781: else
2782:
2783: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2784: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2785: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2786: 'Before calling csp_req_line_details_pkg.Insert_Row...');
2787: end if;
2788:

Line 2941: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2937: csp_requirement_lines l
2938: WHERE l.requirement_line_id = l_requirement_line_id
2939: AND l.requirement_header_id = h.requirement_header_id;
2940:
2941: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2942: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2943: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2944: 'l_hdr_need_by = ' || to_char(l_hdr_need_by, 'DD-MON-YYYY HH24:MI:SS'));
2945: end if;

Line 2942: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2938: WHERE l.requirement_line_id = l_requirement_line_id
2939: AND l.requirement_header_id = h.requirement_header_id;
2940:
2941: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2942: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2943: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2944: 'l_hdr_need_by = ' || to_char(l_hdr_need_by, 'DD-MON-YYYY HH24:MI:SS'));
2945: end if;
2946:

Line 2957: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2953: l_RESERVATION_REC.quantity_needed := p_trans_record.QUANTITY;
2954: l_RESERVATION_REC.revision := l_rcv_rec_type.item_revision;
2955: l_RESERVATION_REC.line_id := l_requirement_line_id;
2956:
2957: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2958: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2959: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2960: 'Before calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2961: end if;

Line 2958: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2954: l_RESERVATION_REC.revision := l_rcv_rec_type.item_revision;
2955: l_RESERVATION_REC.line_id := l_requirement_line_id;
2956:
2957: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2958: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2959: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2960: 'Before calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2961: end if;
2962:

Line 2968: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2964: p_reservation_parts => l_RESERVATION_REC,
2965: x_return_status => x_return_status,
2966: x_msg_data => x_msg_data);
2967:
2968: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2969: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2970: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2971: 'After calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2972: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2969: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2965: x_return_status => x_return_status,
2966: x_msg_data => x_msg_data);
2967:
2968: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2969: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2970: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2971: 'After calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2972: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2973: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2972: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2968: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2969: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2970: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2971: 'After calling CSP_SCH_INT_PVT.CREATE_RESERVATION...');
2972: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2973: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2974: 'x_return_status=' || x_return_status ||
2975: ', x_msg_data=' || x_msg_data ||
2976: ', l_new_reservation_id=' || l_new_reservation_id);

Line 2986: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2982: -- check how much reserved
2983: select reservation_quantity into l_total_reserved_qty
2984: from mtl_reservations where reservation_id = l_new_reservation_id;
2985:
2986: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2987: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2988: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2989: 'l_total_reserved_qty = ' || l_total_reserved_qty);
2990: end if;

Line 2987: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2983: select reservation_quantity into l_total_reserved_qty
2984: from mtl_reservations where reservation_id = l_new_reservation_id;
2985:
2986: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2987: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2988: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
2989: 'l_total_reserved_qty = ' || l_total_reserved_qty);
2990: end if;
2991:

Line 3001: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2997: AND cd.source_type = 'RES'
2998: AND cd.requirement_line_id = l_requirement_line_id
2999: AND cd.source_id <> l_new_reservation_id;
3000:
3001: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3002: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3003: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3004: 'l_already_res_qty = ' || l_already_res_qty);
3005: end if;

Line 3002: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2998: AND cd.requirement_line_id = l_requirement_line_id
2999: AND cd.source_id <> l_new_reservation_id;
3000:
3001: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3002: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3003: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3004: 'l_already_res_qty = ' || l_already_res_qty);
3005: end if;
3006:

Line 3018: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3014: AND ord.line_id = csp.source_id
3015: AND csp.source_type = 'IO'
3016: AND csp.req_line_detail_id = l_req_line_detail_id;
3017:
3018: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3019: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3020: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3021: 'l_total_req_qty = ' || l_total_req_qty);
3022: end if;

Line 3019: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3015: AND csp.source_type = 'IO'
3016: AND csp.req_line_detail_id = l_req_line_detail_id;
3017:
3018: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3019: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3020: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3021: 'l_total_req_qty = ' || l_total_req_qty);
3022: end if;
3023:

Line 3031: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3027: WHERE requirement_line_id = l_requirement_line_id
3028: AND source_type = 'RES'
3029: AND source_id = l_new_reservation_id;
3030:
3031: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3032: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3033: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3034: 'l_res_exists = ' || l_res_exists);
3035: end if;

Line 3032: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3028: AND source_type = 'RES'
3029: AND source_id = l_new_reservation_id;
3030:
3031: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3032: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3033: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3034: 'l_res_exists = ' || l_res_exists);
3035: end if;
3036:

Line 3040: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3036:
3037: if (l_total_reserved_qty + l_already_res_qty) >= l_total_req_qty then
3038:
3039: if l_res_exists = 0 then
3040: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3041: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3042: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3043: 'Before calling csp_req_line_details_pkg.Insert_Row...');
3044: end if;

Line 3041: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3037: if (l_total_reserved_qty + l_already_res_qty) >= l_total_req_qty then
3038:
3039: if l_res_exists = 0 then
3040: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3041: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3042: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3043: 'Before calling csp_req_line_details_pkg.Insert_Row...');
3044: end if;
3045:

Line 3057: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3053: p_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id,
3054: p_SOURCE_TYPE => 'RES',
3055: p_SOURCE_ID => l_new_reservation_id);
3056: else
3057: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3059: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3060: 'deleting.... l_req_line_detail_id = ' || l_req_line_detail_id);
3061: end if;

Line 3058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3054: p_SOURCE_TYPE => 'RES',
3055: p_SOURCE_ID => l_new_reservation_id);
3056: else
3057: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3059: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3060: 'deleting.... l_req_line_detail_id = ' || l_req_line_detail_id);
3061: end if;
3062: --csp_req_line_details_pkg.delete_row(l_req_line_detail_id);

Line 3067: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3063: end if;
3064: else
3065:
3066: if l_res_exists = 0 then
3067: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3068: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3069: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3070: 'Before calling csp_req_line_details_pkg.Insert_Row...');
3071: end if;

Line 3068: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3064: else
3065:
3066: if l_res_exists = 0 then
3067: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3068: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3069: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3070: 'Before calling csp_req_line_details_pkg.Insert_Row...');
3071: end if;
3072:

Line 3093: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3089: commit;
3090: end if; -- if x_return_status = 'S' then
3091: end if; -- if IO
3092:
3093: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3094: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3095: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3096: 'Leaving receive_requirement_trans...');
3097: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3094: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3090: end if; -- if x_return_status = 'S' then
3091: end if; -- if IO
3092:
3093: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3094: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3095: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3096: 'Leaving receive_requirement_trans...');
3097: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3098: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 3097: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3093: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3094: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3095: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3096: 'Leaving receive_requirement_trans...');
3097: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3098: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',
3099: 'x_return_status=' || x_return_status ||
3100: ', x_msg_count=' || x_msg_count ||
3101: ', x_msg_data=' || x_msg_data);

Line 3243: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3239: l_total_reserved_qty number;
3240:
3241: begin
3242:
3243: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3244: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3245: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3246: 'begin...');
3247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3244: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3240:
3241: begin
3242:
3243: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3244: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3245: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3246: 'begin...');
3247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3248: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

Line 3247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3243: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3244: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3245: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3246: 'begin...');
3247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3248: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3249: 'event name = ' || p_event.geteventname());
3250: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3251: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

Line 3250: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3246: 'begin...');
3247: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3248: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3249: 'event name = ' || p_event.geteventname());
3250: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3251: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3252: 'event key = ' || p_event.geteventkey());
3253: end if;
3254:

Line 3257: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3253: end if;
3254:
3255: l_shipment_header_id := p_event.GetValueForParameter('SHIPMENT_HEADER_ID');
3256:
3257: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3258: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3259: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3260: 'l_shipment_header_id = ' || l_shipment_header_id);
3261: end if;

Line 3258: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3254:
3255: l_shipment_header_id := p_event.GetValueForParameter('SHIPMENT_HEADER_ID');
3256:
3257: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3258: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3259: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3260: 'l_shipment_header_id = ' || l_shipment_header_id);
3261: end if;
3262:

Line 3274: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3270: l_reservation_parts.quantity_needed := grd.rcv_qty ;
3271: l_reservation_parts.sub_inventory_code := grd.subinv_code ;
3272: l_reservation_parts.revision := grd.revision;
3273:
3274: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3276: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3277: 'l_reservation_parts.need_by_date = '
3278: || to_char(l_reservation_parts.need_by_date, 'DD-MON-YYYY HH24:MI:SS'));

Line 3275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3271: l_reservation_parts.sub_inventory_code := grd.subinv_code ;
3272: l_reservation_parts.revision := grd.revision;
3273:
3274: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3276: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3277: 'l_reservation_parts.need_by_date = '
3278: || to_char(l_reservation_parts.need_by_date, 'DD-MON-YYYY HH24:MI:SS'));
3279: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3279: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3276: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3277: 'l_reservation_parts.need_by_date = '
3278: || to_char(l_reservation_parts.need_by_date, 'DD-MON-YYYY HH24:MI:SS'));
3279: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3280: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3281: 'l_reservation_parts.organization_id = ' || l_reservation_parts.organization_id);
3282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3283: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

Line 3282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3278: || to_char(l_reservation_parts.need_by_date, 'DD-MON-YYYY HH24:MI:SS'));
3279: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3280: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3281: 'l_reservation_parts.organization_id = ' || l_reservation_parts.organization_id);
3282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3283: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3284: 'l_reservation_parts.item_id = ' || l_reservation_parts.item_id);
3285: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3286: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

Line 3285: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3281: 'l_reservation_parts.organization_id = ' || l_reservation_parts.organization_id);
3282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3283: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3284: 'l_reservation_parts.item_id = ' || l_reservation_parts.item_id);
3285: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3286: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3287: 'l_reservation_parts.item_uom_code = ' || l_reservation_parts.item_uom_code);
3288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3289: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

Line 3288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3284: 'l_reservation_parts.item_id = ' || l_reservation_parts.item_id);
3285: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3286: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3287: 'l_reservation_parts.item_uom_code = ' || l_reservation_parts.item_uom_code);
3288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3289: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3290: 'l_reservation_parts.quantity_needed = ' || l_reservation_parts.quantity_needed);
3291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3292: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

Line 3291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3287: 'l_reservation_parts.item_uom_code = ' || l_reservation_parts.item_uom_code);
3288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3289: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3290: 'l_reservation_parts.quantity_needed = ' || l_reservation_parts.quantity_needed);
3291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3292: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3293: 'l_reservation_parts.sub_inventory_code = ' || l_reservation_parts.sub_inventory_code);
3294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3295: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

Line 3294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3290: 'l_reservation_parts.quantity_needed = ' || l_reservation_parts.quantity_needed);
3291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3292: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3293: 'l_reservation_parts.sub_inventory_code = ' || l_reservation_parts.sub_inventory_code);
3294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3295: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3296: 'l_reservation_parts.revision = ' || l_reservation_parts.revision);
3297: end if;
3298:

Line 3303: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3299: l_reservation_id := csp_sch_int_pvt.CREATE_RESERVATION(l_reservation_parts
3300: ,x_return_status
3301: ,x_msg_data );
3302:
3303: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3304: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3305: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3306: 'l_reservation_id = ' || l_reservation_id);
3307: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3304: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3300: ,x_return_status
3301: ,x_msg_data );
3302:
3303: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3304: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3305: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3306: 'l_reservation_id = ' || l_reservation_id);
3307: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3308: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

Line 3307: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3303: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3304: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3305: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3306: 'l_reservation_id = ' || l_reservation_id);
3307: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3308: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3309: 'x_return_status = ' || x_return_status);
3310: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3311: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

Line 3310: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3306: 'l_reservation_id = ' || l_reservation_id);
3307: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3308: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3309: 'x_return_status = ' || x_return_status);
3310: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3311: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3312: 'x_msg_data = ' || x_msg_data);
3313: end if;
3314:

Line 3323: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3319: WHERE requirement_line_id = grd.requirement_line_id
3320: AND source_type = 'RES'
3321: AND source_id = l_reservation_id;
3322:
3323: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3325: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3326: 'l_res_exists = ' || l_res_exists);
3327: end if;

Line 3324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3320: AND source_type = 'RES'
3321: AND source_id = l_reservation_id;
3322:
3323: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3325: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3326: 'l_res_exists = ' || l_res_exists);
3327: end if;
3328:

Line 3348: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3344:
3345: select reservation_quantity into l_total_reserved_qty
3346: from mtl_reservations where reservation_id = l_reservation_id;
3347:
3348: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3349: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3350: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3351: 'l_total_reserved_qty = ' || l_total_reserved_qty);
3352: end if;

Line 3349: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3345: select reservation_quantity into l_total_reserved_qty
3346: from mtl_reservations where reservation_id = l_reservation_id;
3347:
3348: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3349: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3350: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3351: 'l_total_reserved_qty = ' || l_total_reserved_qty);
3352: end if;
3353:

Line 3365: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3361: AND cl.requirement_line_id = grd.requirement_line_id
3362: AND cd.requirement_line_id = cl.requirement_line_id
3363: AND cd.source_id <> l_reservation_id;
3364:
3365: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3367: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3368: 'l_already_res_qty = ' || l_already_res_qty);
3369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3362: AND cd.requirement_line_id = cl.requirement_line_id
3363: AND cd.source_id <> l_reservation_id;
3364:
3365: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3367: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3368: 'l_already_res_qty = ' || l_already_res_qty);
3369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3370: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

Line 3369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3365: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3367: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3368: 'l_already_res_qty = ' || l_already_res_qty);
3369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3370: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3371: 'grd.ord_qty = ' || grd.ord_qty);
3372: end if;
3373:

Line 3382: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3378: END IF;
3379:
3380: end loop; -- for grd in c_ship_detail loop
3381:
3382: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3383: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3384: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3385: 'done...');
3386: end if;

Line 3383: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3379:
3380: end loop; -- for grd in c_ship_detail loop
3381:
3382: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3383: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3384: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',
3385: 'done...');
3386: end if;
3387: