APPS.MSC_REL_PLAN_PUB dependencies on DBMS_OUTPUT

Line 139: dbms_output.put_line(p_debug_info);

135: p_debug_info IN VARCHAR2
136: )IS
137: BEGIN
138: -- FND_FILE.PUT_LINE(FND_FILE.LOG, p_debug_info);
139: dbms_output.put_line(p_debug_info);
140: EXCEPTION
141: WHEN OTHERS THEN
142: RAISE;
143: END print_debug_info;

Line 5926: --DBMS_OUTPUT.PUT_LINE('LOAD_JOB');

5922: -- -----------------------------------------------------------------------
5923: /* Due to we only give PLANNED components, BILL_RTG_EXPLOSION_FLAG
5924: is set to 'Y'. */
5925:
5926: --DBMS_OUTPUT.PUT_LINE('LOAD_JOB');
5927:
5928: FOR k in 1..lv_job_count
5929: Loop
5930: Begin

Line 6260: --DBMS_OUTPUT.PUT_LINE('OPERATION_RESOURCE');

6256: resreq.operation_sequence_id,
6257: s.sr_instance_id;
6258:
6259:
6260: --DBMS_OUTPUT.PUT_LINE('OPERATION_RESOURCE');
6261: /* for bug: 2479630, modified the expression that is passed in the column: usage_rate_or_amount,
6262: to divide the resource_hours by cum. qty (which is equal to new_order_qty/cum. yield) and if that is null
6263: than apply the CY on new_order_qty. This logic to use cummulative_qty is added to remove the calc. errors */
6264:

Line 6408: --DBMS_OUTPUT.PUT_LINE('LOAD COMPONENTS');

6404: AND resreq.resource_id = mdr.resource_id
6405: AND resreq.department_id=mdr.department_id;
6406:
6407:
6408: --DBMS_OUTPUT.PUT_LINE('LOAD COMPONENTS');
6409:
6410: /* for bug: 2378484, added code to consider the cum yield in the calc of qty_per_assembly */
6411: /* UPDATE EXISTING COMPONENTS *
6412: | We should set inventory_item_id_new to NULL |

Line 6639: --DBMS_OUTPUT.PUT_LINE('LOAD SUBSTITUTE COMPONENTS');

6635: AND lv_details_enabled(j) = 1
6636: AND lv_agg_details(j) = 1
6637: AND tp.organization_type = 2;
6638:
6639: --DBMS_OUTPUT.PUT_LINE('LOAD SUBSTITUTE COMPONENTS');
6640: /* SUBSTITUTE EXISTING COMPONENTS */
6641: FORALL j IN 1..lv_job_count
6642: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
6643: (last_update_date,

Line 6768: --DBMS_OUTPUT.PUT_LINE('RESOURCE_USAGE');

6764: AND s.plan_id= arg_plan_id
6765: AND lv_details_enabled(j)= 1
6766: AND lv_agg_details(j) = 1;
6767:
6768: --DBMS_OUTPUT.PUT_LINE('RESOURCE_USAGE');
6769:
6770:
6771: -- RESOURCE USAGE
6772: FORALL j IN 1..lv_job_count

Line 7369: --DBMS_OUTPUT.PUT_LINE('LOAD_JOB');

7365: -- -----------------------------------------------------------------------
7366: -- Due to we only give PLANNED components, BILL_RTG_EXPLOSION_FLAG
7367: -- is set to 'Y'.
7368:
7369: --DBMS_OUTPUT.PUT_LINE('LOAD_JOB');
7370:
7371: FOR k in 1..lv_job_count
7372: Loop
7373: Begin

Line 7664: --DBMS_OUTPUT.PUT_LINE('OPERATION_RESOURCE');

7660: resreq.operation_sequence_id,
7661: s.disposition_id;
7662:
7663:
7664: --DBMS_OUTPUT.PUT_LINE('OPERATION_RESOURCE');
7665:
7666: -- OPERATION RESOURCES
7667: FORALL j IN 1..lv_job_count
7668: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

Line 7792: --DBMS_OUTPUT.PUT_LINE('LOAD COMPONENTS');

7788: AND lv_details_enabled(j)= 1
7789: AND lv_agg_details(j) = 1 ;
7790:
7791:
7792: --DBMS_OUTPUT.PUT_LINE('LOAD COMPONENTS');
7793:
7794: /* UPDATE EXISTING COMPONENTS *
7795: | We should set inventory_item_id_new to NULL |
7796: * */

Line 8027: --DBMS_OUTPUT.PUT_LINE('RESOURCE_USAGE');

8023: AND lv_agg_details(j) = 1
8024: AND tp.organization_type = 2;
8025:
8026:
8027: --DBMS_OUTPUT.PUT_LINE('RESOURCE_USAGE');
8028:
8029: -- RESOURCE USAGE
8030: FORALL j IN 1..lv_job_count
8031: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE