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_REQ_LINE_DETAILS_PKG

Line 2722: 'Before calling csp_req_line_details_pkg.delete_row...');

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

Line 2724: csp_req_line_details_pkg.delete_row(p_req_line_detail_id);

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;
2726: end if;
2727:
2728: else

Line 2769: 'Before calling csp_req_line_details_pkg.Update_Row...');

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,
2773: p_REQUIREMENT_LINE_ID => l_requirement_line_id,

Line 2772: csp_req_line_details_pkg.Update_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,

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,
2773: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
2774: p_CREATED_BY => FND_GLOBAL.user_id,
2775: p_CREATION_DATE => sysdate,
2776: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,

Line 2786: 'Before calling csp_req_line_details_pkg.Insert_Row...');

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(
2790: px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,

Line 2789: csp_req_line_details_pkg.Insert_Row(

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(
2790: px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
2791: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
2792: p_CREATED_BY => FND_GLOBAL.user_id,
2793: p_CREATION_DATE => sysdate,

Line 3043: 'Before calling csp_req_line_details_pkg.Insert_Row...');

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;
3047: csp_req_line_details_pkg.Insert_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,

Line 3047: csp_req_line_details_pkg.Insert_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,

3043: 'Before calling csp_req_line_details_pkg.Insert_Row...');
3044: end if;
3045:
3046: l_req_line_detail_id := null;
3047: csp_req_line_details_pkg.Insert_Row(px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
3048: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
3049: p_CREATED_BY => FND_GLOBAL.user_id,
3050: p_CREATION_DATE => sysdate,
3051: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,

Line 3062: --csp_req_line_details_pkg.delete_row(l_req_line_detail_id);

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;
3064: else
3065:
3066: if l_res_exists = 0 then

Line 3070: 'Before calling csp_req_line_details_pkg.Insert_Row...');

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

Line 3074: csp_req_line_details_pkg.Insert_Row(

3070: 'Before calling csp_req_line_details_pkg.Insert_Row...');
3071: end if;
3072:
3073: l_req_line_detail_id := null;
3074: csp_req_line_details_pkg.Insert_Row(
3075: px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
3076: p_REQUIREMENT_LINE_ID => l_requirement_line_id,
3077: p_CREATED_BY => FND_GLOBAL.user_id,
3078: p_CREATION_DATE => sysdate,

Line 3334: csp_req_line_details_pkg.insert_row(px_req_line_detail_id => l_req_line_detali_id

3330:
3331: IF l_reservation_id IS NOT NULL AND l_reservation_id > 0 THEN
3332:
3333: if l_res_exists = 0 then
3334: csp_req_line_details_pkg.insert_row(px_req_line_detail_id => l_req_line_detali_id
3335: ,p_requirement_line_id => grd.requirement_line_id
3336: ,p_created_by => FND_GLOBAL.user_id
3337: ,p_creation_date => sysdate
3338: ,p_last_updated_by => FND_GLOBAL.user_id

Line 3375: csp_req_line_details_pkg.delete_row(grd.req_line_detail_id);

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
3375: csp_req_line_details_pkg.delete_row(grd.req_line_detail_id);
3376: END IF;
3377:
3378: END IF;
3379: