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.RLM_MANAGE_DEMAND_SV dependencies on RLM_MANAGE_DEMAND_SV

Line 1: PACKAGE BODY RLM_MANAGE_DEMAND_SV as

1: PACKAGE BODY RLM_MANAGE_DEMAND_SV as
2: /* $Header: RLMDPMDB.pls 120.16.12020000.2 2012/07/05 10:08:45 brana ship $*/
3: /*========================== rlm_manage_demand_sv ===========================*/
4:
5: --

Line 3: /========================== rlm_manage_demand_sv ===========================/

1: PACKAGE BODY RLM_MANAGE_DEMAND_SV as
2: /* $Header: RLMDPMDB.pls 120.16.12020000.2 2012/07/05 10:08:45 brana ship $*/
3: /*========================== rlm_manage_demand_sv ===========================*/
4:
5: --
6: l_DEBUG NUMBER := NVL(fnd_profile.value('RLM_DEBUG_MODE'),-1);
7: g_count NUMBER :=0; --Bugfix 7007638

Line 227: rlm_message_sv.sql_error('rlm_manage_demand_sv.ManageDemand', v_Progress);

223: --
224: WHEN OTHERS THEN
225: --
226: x_ReturnStatus := rlm_core_sv.k_PROC_ERROR;
227: rlm_message_sv.sql_error('rlm_manage_demand_sv.ManageDemand', v_Progress);
228: --
229: IF (l_debug <> -1) THEN
230: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
231: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 385: rlm_message_sv.sql_error('rlm_manage_demand_sv.ManageDemand',

381: --
382: WHEN OTHERS THEN
383: --
384: x_ReturnStatus := rlm_core_sv.k_PROC_ERROR;
385: rlm_message_sv.sql_error('rlm_manage_demand_sv.ManageDemand',
386: v_Progress);
387: --
388: IF (l_debug <> -1) THEN
389: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

Line 471: rlm_message_sv.sql_error('rlm_manage_demand_sv.PopulateLastReceiptRec',

467: --
468: EXCEPTION
469: --
470: WHEN OTHERS THEN
471: rlm_message_sv.sql_error('rlm_manage_demand_sv.PopulateLastReceiptRec',
472: v_Progress);
473: --
474: IF (l_debug <> -1) THEN
475: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 773: rlm_message_sv.sql_error('rlm_manage_demand_sv.UOMConversion', v_Progress);

769:
770: EXCEPTION
771:
772: WHEN OTHERS THEN
773: rlm_message_sv.sql_error('rlm_manage_demand_sv.UOMConversion', v_Progress);
774: --
775: IF (l_debug <> -1) THEN
776: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
777: END IF;

Line 1283: rlm_message_sv.sql_error('rlm_manage_demand_sv.CUMDiscrepancyCheck',v_Progress);

1279: v_InterfaceLineId := NULL;
1280: --
1281: END;
1282: --
1283: rlm_message_sv.sql_error('rlm_manage_demand_sv.CUMDiscrepancyCheck',v_Progress);
1284: --
1285: rlm_message_sv.app_error(
1286: x_ExceptionLevel => rlm_message_sv.k_error_level,
1287: x_MessageName => 'RLM_CALC_CUM_KEY_FAILED',

Line 1315: rlm_message_sv.sql_error('rlm_manage_demand_sv.CUMDiscrepancyCheck', v_Progress);

1311: raise e_GroupError;
1312: --
1313: WHEN e_CalSupCumAPIFailed THEN /* This is never raised */
1314: --
1315: rlm_message_sv.sql_error('rlm_manage_demand_sv.CUMDiscrepancyCheck', v_Progress);
1316: --
1317: rlm_message_sv.app_error(
1318: x_ExceptionLevel => rlm_message_sv.k_error_level,
1319: x_MessageName => 'RLM_CALC_SUPCUM_KEY_FAILED',

Line 1340: rlm_message_sv.sql_error('rlm_manage_demand_sv.CUMDiscrepancyCheck',

1336: raise e_GroupError;
1337: --
1338: WHEN OTHERS THEN
1339: --
1340: rlm_message_sv.sql_error('rlm_manage_demand_sv.CUMDiscrepancyCheck',
1341: v_Progress);
1342: --
1343: IF (l_debug <> -1) THEN
1344: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

Line 1410: rlm_message_sv.sql_error('rlm_manage_demand_sv.SetOperation', v_Progress);

1406: EXCEPTION
1407: --
1408: WHEN OTHERS THEN
1409: --
1410: rlm_message_sv.sql_error('rlm_manage_demand_sv.SetOperation', v_Progress);
1411: --
1412: IF (l_debug <> -1) THEN
1413: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
1414: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 1524: v_cum_key_record.cum_start_date:= rlm_manage_demand_sv.K_DNULL;

1520: ELSE -- if g_CUM_tab
1521: --
1522: v_cum_record.record_return_status := TRUE;
1523: --
1524: v_cum_key_record.cum_start_date:= rlm_manage_demand_sv.K_DNULL;
1525: --
1526: v_cum_key_record.customer_item_id:= g_ManageDemand_tab(v_count).customer_item_id;
1527: --
1528: v_cum_key_record.inventory_item_id:= g_ManageDemand_tab(v_count).inventory_item_id;

Line 1694: v_cum_key_record.cum_start_date := rlm_manage_demand_sv.K_DNULL;

1690: IF v_cum_record.cum_key_id IS NULL THEN
1691: --Removed IF check for g_CUM_tab.found as no records exists in g_CUM_tab
1692: v_cum_record.record_return_status := TRUE;
1693: --
1694: v_cum_key_record.cum_start_date := rlm_manage_demand_sv.K_DNULL;
1695: --
1696: v_cum_key_record.customer_item_id:= g_ManageDemand_tab(v_count).customer_item_id;
1697: --
1698: v_cum_key_record.inventory_item_id:= g_ManageDemand_tab(v_count).inventory_item_id;

Line 1931: rlm_message_sv.sql_error('rlm_manage_demand_sv.CUMToDiscrete', v_Progress);

1927: --
1928:
1929: WHEN OTHERS THEN
1930: --
1931: rlm_message_sv.sql_error('rlm_manage_demand_sv.CUMToDiscrete', v_Progress);
1932: --
1933: IF (l_debug <> -1) THEN
1934: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
1935: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 1949: x_SourcedDemand_tab OUT NOCOPY rlm_manage_demand_sv.t_MD_Tab,

1945:
1946: ===========================================================================*/
1947: PROCEDURE ApplySourceRules(x_Sched_rec IN rlm_interface_headers%ROWTYPE,
1948: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1949: x_SourcedDemand_tab OUT NOCOPY rlm_manage_demand_sv.t_MD_Tab,
1950: x_Source_Tab OUT NOCOPY rlm_manage_demand_sv.t_Source_Tab)
1951: IS
1952: --
1953: v_progress VARCHAR2(3) := '010';

Line 1950: x_Source_Tab OUT NOCOPY rlm_manage_demand_sv.t_Source_Tab)

1946: ===========================================================================*/
1947: PROCEDURE ApplySourceRules(x_Sched_rec IN rlm_interface_headers%ROWTYPE,
1948: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1949: x_SourcedDemand_tab OUT NOCOPY rlm_manage_demand_sv.t_MD_Tab,
1950: x_Source_Tab OUT NOCOPY rlm_manage_demand_sv.t_Source_Tab)
1951: IS
1952: --
1953: v_progress VARCHAR2(3) := '010';
1954: k_PLANNING_ACTIVE NUMBER := 1;

Line 1956: v_Source_Tab rlm_manage_demand_sv.t_Source_Tab; --Bugfix 6051397

1952: --
1953: v_progress VARCHAR2(3) := '010';
1954: k_PLANNING_ACTIVE NUMBER := 1;
1955: sr_item_id NUMBER DEFAULT NULL;
1956: v_Source_Tab rlm_manage_demand_sv.t_Source_Tab; --Bugfix 6051397
1957: --
1958: -- Source type is used in the decode because the if the source type = 2 =
1959: -- Make At then the source_organization_id is null as the make at Item
1960: -- is the same item

Line 4072: rlm_core_sv.dlog('rlm_manage_demand_sv.ApplyFFFFences', v_Progress);

4068: WHEN NO_DATA_FOUND THEN
4069: --
4070: IF (l_debug <> -1) THEN
4071: rlm_core_sv.dlog(C_DEBUG,'EXCEPTION: NO_DATA_FOUND');
4072: rlm_core_sv.dlog('rlm_manage_demand_sv.ApplyFFFFences', v_Progress);
4073: rlm_core_sv.dpop(C_SDEBUG);
4074: END IF;
4075: --
4076: WHEN OTHERS THEN

Line 4078: rlm_message_sv.sql_error('rlm_manage_demand_sv.ApplyFFFFences', v_Progress);

4074: END IF;
4075: --
4076: WHEN OTHERS THEN
4077: --
4078: rlm_message_sv.sql_error('rlm_manage_demand_sv.ApplyFFFFences', v_Progress);
4079: --
4080: IF (l_debug <> -1) THEN
4081: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
4082: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 4141: rlm_message_sv.sql_error('rlm_manage_demand_sv.ProcessTable',

4137: --
4138: EXCEPTION
4139:
4140: WHEN OTHERS THEN
4141: rlm_message_sv.sql_error('rlm_manage_demand_sv.ProcessTable',
4142: v_Progress);
4143: --
4144: IF (l_debug <> -1) THEN
4145: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

Line 4191: rlm_message_sv.sql_error('rlm_manage_demand_sv.DeleteReq',

4187:
4188: EXCEPTION
4189:
4190: WHEN OTHERS THEN
4191: rlm_message_sv.sql_error('rlm_manage_demand_sv.DeleteReq',
4192: v_Progress);
4193: --
4194: IF (l_debug <> -1) THEN
4195: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

Line 4823: rlm_message_sv.sql_error('rlm_manage_demand_sv.InsertReq',

4819: --
4820: RAISE;
4821: --
4822: WHEN OTHERS THEN
4823: rlm_message_sv.sql_error('rlm_manage_demand_sv.InsertReq',
4824: v_Progress);
4825: --
4826: IF (l_debug <> -1) THEN
4827: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

Line 4889: rlm_message_sv.sql_error('rlm_manage_demand_sv.UpdateReq',

4885: --
4886: EXCEPTION
4887:
4888: WHEN OTHERS THEN
4889: rlm_message_sv.sql_error('rlm_manage_demand_sv.UpdateReq',
4890: v_Progress);
4891: --
4892: IF (l_debug <> -1) THEN
4893: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

Line 4941: rlm_message_sv.sql_error('rlm_manage_demand_sv.UpdateSchedule', v_Progress);

4937: --
4938: EXCEPTION
4939:
4940: WHEN OTHERS THEN
4941: rlm_message_sv.sql_error('rlm_manage_demand_sv.UpdateSchedule', v_Progress);
4942: --
4943: IF (l_debug <> -1) THEN
4944: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
4945: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 5479: rlm_message_sv.sql_error('rlm_manage_demand_sv.MatchDemand', v_Progress);

5475: EXCEPTION
5476: --
5477: WHEN OTHERS THEN
5478: --
5479: rlm_message_sv.sql_error('rlm_manage_demand_sv.MatchDemand', v_Progress);
5480: --
5481: IF (l_debug <> -1) THEN
5482: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
5483: END IF;

Line 5567: rlm_message_sv.sql_error('rlm_manage_demand_sv.AggregateDemand', v_Progress);

5563: --
5564: EXCEPTION
5565:
5566: WHEN OTHERS THEN
5567: rlm_message_sv.sql_error('rlm_manage_demand_sv.AggregateDemand', v_Progress);
5568: --
5569: IF (l_debug <> -1) THEN
5570: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
5571: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 5653: rlm_message_sv.sql_error('rlm_manage_demand_sv.SortDemand', v_Progress);

5649:
5650: EXCEPTION
5651:
5652: WHEN OTHERS THEN
5653: rlm_message_sv.sql_error('rlm_manage_demand_sv.SortDemand', v_Progress);
5654: --
5655: IF (l_debug <> -1) THEN
5656: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
5657: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 5722: rlm_message_sv.sql_error('rlm_manage_demand_sv.QuickSort', v_Progress);

5718:
5719: EXCEPTION
5720:
5721: WHEN OTHERS THEN
5722: rlm_message_sv.sql_error('rlm_manage_demand_sv.QuickSort', v_Progress);
5723: --
5724: IF (l_debug <> -1) THEN
5725: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
5726: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 5758: rlm_message_sv.sql_error('rlm_manage_demand_sv.Swap', v_Progress);

5754:
5755: EXCEPTION
5756:
5757: WHEN OTHERS THEN
5758: rlm_message_sv.sql_error('rlm_manage_demand_sv.Swap', v_Progress);
5759: --
5760: IF (l_debug <> -1) THEN
5761: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
5762: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 5808: rlm_message_sv.sql_error('rlm_manage_demand_sv.InsertionSort', v_Progress);

5804: --
5805: EXCEPTION
5806:
5807: WHEN OTHERS THEN
5808: rlm_message_sv.sql_error('rlm_manage_demand_sv.InsertionSort', v_Progress);
5809: --
5810: IF (l_debug <> -1) THEN
5811: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
5812: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 6071: rlm_message_sv.sql_error('rlm_manage_demand_sv.RoundStandardPack',

6067: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
6068: END IF;
6069:
6070: WHEN OTHERS THEN
6071: rlm_message_sv.sql_error('rlm_manage_demand_sv.RoundStandardPack',
6072: v_Progress);
6073: --
6074: IF (l_debug <> -1) THEN
6075: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

Line 6089: x_Group_ref IN OUT NOCOPY rlm_manage_demand_sv.t_Cursor_ref,

6085: PROCEDURE InitializeMdGroup
6086:
6087: ===========================================================================*/
6088: PROCEDURE InitializeMdGroup(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6089: x_Group_ref IN OUT NOCOPY rlm_manage_demand_sv.t_Cursor_ref,
6090: x_Group_rec IN rlm_dp_sv.t_Group_rec)
6091: IS
6092:
6093: BEGIN

Line 7037: AND NVL(il.item_detail_type, ' ') <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO

7033: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id
7034: AND il.inventory_item_id = x_Group_rec.inventory_item_id
7035: AND il.customer_item_id = x_Group_rec.customer_item_id
7036: AND il.schedule_line_id = sl.line_id
7037: AND NVL(il.item_detail_type, ' ') <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO
7038: AND sl.qty_type_code in (rlm_manage_demand_sv.k_ACTUAL, rlm_manage_demand_sv.k_CUMULATIVE); --Bugfix 13925958
7039:
7040:
7041: --

Line 7038: AND sl.qty_type_code in (rlm_manage_demand_sv.k_ACTUAL, rlm_manage_demand_sv.k_CUMULATIVE); --Bugfix 13925958

7034: AND il.inventory_item_id = x_Group_rec.inventory_item_id
7035: AND il.customer_item_id = x_Group_rec.customer_item_id
7036: AND il.schedule_line_id = sl.line_id
7037: AND NVL(il.item_detail_type, ' ') <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO
7038: AND sl.qty_type_code in (rlm_manage_demand_sv.k_ACTUAL, rlm_manage_demand_sv.k_CUMULATIVE); --Bugfix 13925958
7039:
7040:
7041: --
7042: IF (v_min_horizon_date IS NOT NULL ) THEN

Line 7096: x_Source_Tab IN RLM_MANAGE_DEMAND_SV.t_Source_Tab)

7092:
7093:
7094: FUNCTION GetAllIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7095: x_Group_rec IN rlm_dp_sv.t_Group_rec,
7096: x_Source_Tab IN RLM_MANAGE_DEMAND_SV.t_Source_Tab)
7097: RETURN NUMBER
7098: IS
7099:
7100: -- The shipper ID is stored in the item_detail_ref_value_1 field

Line 8461: AND NVL(il.item_detail_type, ' ') <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO

8457: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id
8458: AND il.inventory_item_id = x_Group_rec.inventory_item_id
8459: AND il.customer_item_id = x_Group_rec.customer_item_id
8460: AND il.schedule_line_id = sl.line_id
8461: AND NVL(il.item_detail_type, ' ') <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO
8462: AND sl.qty_type_code in (rlm_manage_demand_sv.k_ACTUAL, rlm_manage_demand_sv.k_CUMULATIVE); --Bugfix 13925958
8463:
8464:
8465: --

Line 8462: AND sl.qty_type_code in (rlm_manage_demand_sv.k_ACTUAL, rlm_manage_demand_sv.k_CUMULATIVE); --Bugfix 13925958

8458: AND il.inventory_item_id = x_Group_rec.inventory_item_id
8459: AND il.customer_item_id = x_Group_rec.customer_item_id
8460: AND il.schedule_line_id = sl.line_id
8461: AND NVL(il.item_detail_type, ' ') <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO
8462: AND sl.qty_type_code in (rlm_manage_demand_sv.k_ACTUAL, rlm_manage_demand_sv.k_CUMULATIVE); --Bugfix 13925958
8463:
8464:
8465: --
8466: IF (v_min_horizon_date IS NOT NULL ) THEN

Line 8543: return(RLM_MANAGE_DEMAND_SV.K_DNULL);

8539: RETURN DATE IS
8540:
8541: BEGIN
8542:
8543: return(RLM_MANAGE_DEMAND_SV.K_DNULL);
8544:
8545: END GetvarK_DNULL;
8546:
8547:

Line 8548: END RLM_MANAGE_DEMAND_SV;

8544:
8545: END GetvarK_DNULL;
8546:
8547:
8548: END RLM_MANAGE_DEMAND_SV;