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 CSP_TRANSACTIONS_PUB

Line 1: PACKAGE BODY CSP_TRANSACTIONS_PUB AS

1: PACKAGE BODY CSP_TRANSACTIONS_PUB AS
2: /*$Header: csppttnb.pls 120.30.12020000.4 2013/02/11 08:52:32 htank ship $*/
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_TRANSACTIONS_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_TRANSACTIONS_PUB';

1: PACKAGE BODY CSP_TRANSACTIONS_PUB AS
2: /*$Header: csppttnb.pls 120.30.12020000.4 2013/02/11 08:52:32 htank ship $*/
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_TRANSACTIONS_PUB';
6: G_FILE_NAME CONSTANT VARCHAR2(30) := 'csppttnb.pls';
7:
8: -- Start of comments
9: --

Line 54: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',

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',
58: 'p_line_id = ' || p_line_id);

Line 57: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',

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:
61: open c_quantity_delivered;

Line 69: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',

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:
73: if l_quantity_delivered = 0 then

Line 124: 'csp.plsql.CSP_TRANSACTIONS_PUB.cancel_move_order_line',

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);
128: end if;

Line 2092: CSP_TRANSACTIONS_PUB.TRANSACT_MATERIAL(

2088: PX_TRANSACTION_ID := NULL;
2089: PX_TRANSACTION_HEADER_ID := NULL;
2090:
2091: FOR inx1 IN 1..p_Trans_Items.COUNT LOOP
2092: CSP_TRANSACTIONS_PUB.TRANSACT_MATERIAL(
2093: P_API_VERSION => P_Api_Version_Number,
2094: P_INIT_MSG_LIST => FND_API.G_TRUE,
2095: P_COMMIT => FND_API.G_TRUE,
2096: PX_TRANSACTION_ID => PX_TRANSACTION_ID,

Line 2223: CSP_TRANSACTIONS_PUB.CREATE_MOVE_ORDER_HEADER(

2219: l_line_id := NULL;
2220:
2221: -- INSERT HEADER FIRST
2222:
2223: CSP_TRANSACTIONS_PUB.CREATE_MOVE_ORDER_HEADER(
2224: px_header_id => l_move_order_id
2225: ,p_request_number => null
2226: ,p_api_version => 1.0
2227: ,p_Init_Msg_List => FND_API.G_TRUE

Line 2260: CSP_TRANSACTIONS_PUB.CREATE_MOVE_ORDER_LINE

2256: );
2257: RAISE FND_API.G_EXC_ERROR;
2258: ELSE
2259: FOR inx1 IN 1..p_Trans_Items.COUNT LOOP
2260: CSP_TRANSACTIONS_PUB.CREATE_MOVE_ORDER_LINE
2261: (p_api_version => 1.0
2262: ,p_Init_Msg_List => FND_API.G_TRUE
2263: ,p_commit => FND_API.G_TRUE
2264: ,px_line_id => l_line_id

Line 2464: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2468: 'p_trans_type=' || p_trans_type);

Line 2467: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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,
2471: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2471: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2475: 'p_trans_line_id=' || p_trans_line_id);

Line 2474: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2478: 'p_req_line_detail_id=' || p_req_line_detail_id);

Line 2477: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2481: 'p_close_short=' || p_close_short);

Line 2480: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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,
2484: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

Line 2484: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2488: 'p_trans_record.REVISION=' || p_trans_record.REVISION);

Line 2487: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2491: 'p_trans_record.QUANTITY=' || p_trans_record.QUANTITY);

Line 2490: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2494: 'p_trans_record.UOM_CODE=' || p_trans_record.UOM_CODE);

Line 2493: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2497: 'p_trans_record.LOT_NUMBER=' || p_trans_record.LOT_NUMBER);

Line 2496: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2500: 'p_trans_record.SERIAL_NUMBER=' || p_trans_record.SERIAL_NUMBER);

Line 2499: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2503: 'p_trans_record.FRM_ORGANIZATION_ID=' || p_trans_record.FRM_ORGANIZATION_ID);

Line 2502: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2506: 'p_trans_record.FRM_SUBINVENTORY_CODE=' || p_trans_record.FRM_SUBINVENTORY_CODE);

Line 2505: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2509: 'p_trans_record.FRM_LOCATOR_ID=' || p_trans_record.FRM_LOCATOR_ID);

Line 2508: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2512: 'p_trans_record.TO_ORGANIZATION_ID=' || p_trans_record.TO_ORGANIZATION_ID);

Line 2511: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2515: 'p_trans_record.TO_SUBINVENTORY_CODE=' || p_trans_record.TO_SUBINVENTORY_CODE);

Line 2514: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2518: 'p_trans_record.TO_LOCATOR_ID=' || p_trans_record.TO_LOCATOR_ID);

Line 2517: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2521: 'p_trans_record.TO_SERIAL_NUMBER=' || p_trans_record.TO_SERIAL_NUMBER);

Line 2520: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2524: 'p_trans_record.WAYBILL_AIRBILL=' || p_trans_record.WAYBILL_AIRBILL);

Line 2523: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2527: 'p_trans_record.FREIGHT_CODE=' || p_trans_record.FREIGHT_CODE);

Line 2526: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2530: 'p_trans_record.SHIPMENT_NUMBER=' || p_trans_record.SHIPMENT_NUMBER);

Line 2529: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2533: 'p_trans_record.PACKLIST_LINE_ID=' || p_trans_record.PACKLIST_LINE_ID);

Line 2532: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2536: 'p_trans_record.TEMP_TRANSACTION_ID=' || p_trans_record.TEMP_TRANSACTION_ID);

Line 2535: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2539: 'p_trans_record.ERROR_MSG=' || p_trans_record.ERROR_MSG);

Line 2538: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2542: 'p_trans_record.SHIPMENT_LINE_ID=' || p_trans_record.SHIPMENT_LINE_ID);

Line 2541: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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;
2545:

Line 2553: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
2557: if p_close_short = 'Y' then

Line 2567: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2571: 'x_return_status=' || x_return_status ||

Line 2570: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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);
2574: end if;

Line 2581: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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;
2585:

Line 2607: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2611: 'x_return_status=' || x_return_status ||

Line 2610: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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 ||
2614: ', l_remaining_quantity=' || l_remaining_quantity);

Line 2631: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
2635: l_Trans_Items(1) := p_trans_record;

Line 2641: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
2645: transact_subinv_transfer(

Line 2657: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2661: 'x_return_status=' || x_return_status ||

Line 2660: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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);
2664: end if;

Line 2675: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
2679: transact_intorg_transfer(

Line 2692: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2696: 'x_return_status=' || x_return_status ||

Line 2695: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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);
2699: end if;

Line 2721: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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);
2725: commit;

Line 2741: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
2745: l_new_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(

Line 2752: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2756: 'x_return_status=' || x_return_status ||

Line 2755: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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);
2759: end if;

Line 2768: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
2772: csp_req_line_details_pkg.Update_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,

Line 2785: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
2789: csp_req_line_details_pkg.Insert_Row(

Line 2943: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
2947: -- create new reservation

Line 2959: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
2963: l_new_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(

Line 2970: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
2974: 'x_return_status=' || x_return_status ||

Line 2973: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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);
2977: end if;

Line 2988: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
2992: SELECT nvl(SUM(mr.reservation_quantity), 0)

Line 3003: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
3007: -- check how much required

Line 3020: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
3024: SELECT COUNT(*)

Line 3033: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
3037: if (l_total_reserved_qty + l_already_res_qty) >= l_total_req_qty then

Line 3042: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
3046: l_req_line_detail_id := null;

Line 3059: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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);
3063: end if;

Line 3069: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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:
3073: l_req_line_detail_id := null;

Line 3095: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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',
3099: 'x_return_status=' || x_return_status ||

Line 3098: 'csp.plsql.CSP_TRANSACTIONS_PUB.receive_requirement_trans',

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);
3102: end if;

Line 3245: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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',
3249: 'event name = ' || p_event.geteventname());

Line 3248: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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',
3252: 'event key = ' || p_event.geteventkey());

Line 3251: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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:
3255: l_shipment_header_id := p_event.GetValueForParameter('SHIPMENT_HEADER_ID');

Line 3259: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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:
3263: for grd in c_ship_detail loop

Line 3276: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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,
3280: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

Line 3280: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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',
3284: 'l_reservation_parts.item_id = ' || l_reservation_parts.item_id);

Line 3283: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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',
3287: 'l_reservation_parts.item_uom_code = ' || l_reservation_parts.item_uom_code);

Line 3286: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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',
3290: 'l_reservation_parts.quantity_needed = ' || l_reservation_parts.quantity_needed);

Line 3289: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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',
3293: 'l_reservation_parts.sub_inventory_code = ' || l_reservation_parts.sub_inventory_code);

Line 3292: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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',
3296: 'l_reservation_parts.revision = ' || l_reservation_parts.revision);

Line 3295: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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:
3299: l_reservation_id := csp_sch_int_pvt.CREATE_RESERVATION(l_reservation_parts

Line 3305: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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',
3309: 'x_return_status = ' || x_return_status);

Line 3308: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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',
3312: 'x_msg_data = ' || x_msg_data);

Line 3311: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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:
3315:

Line 3325: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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:
3329: l_req_line_detali_id := NULL;

Line 3350: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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:
3354: SELECT nvl(SUM(mr.reservation_quantity), 0)

Line 3367: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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',
3371: 'grd.ord_qty = ' || grd.ord_qty);

Line 3370: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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:
3374: IF (l_total_reserved_qty + l_already_res_qty) >= grd.ord_qty THEN

Line 3384: 'csp.plsql.CSP_TRANSACTIONS_PUB.res_for_rcv_trans',

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:
3388: return 'SUCCESS';

Line 3402: END csp_transactions_pub;

3398: end loop;
3399: return;
3400: end gen_numbers;
3401:
3402: END csp_transactions_pub;