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.12.12010000.2 2008/07/30 12:46:40 sunilku 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.12.12010000.2 2008/07/30 12:46:40 sunilku 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 379: rlm_message_sv.sql_error('rlm_manage_demand_sv.ManageDemand',

375: --
376: WHEN OTHERS THEN
377: --
378: x_ReturnStatus := rlm_core_sv.k_PROC_ERROR;
379: rlm_message_sv.sql_error('rlm_manage_demand_sv.ManageDemand',
380: v_Progress);
381: --
382: IF (l_debug <> -1) THEN
383: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

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

461: --
462: EXCEPTION
463: --
464: WHEN OTHERS THEN
465: rlm_message_sv.sql_error('rlm_manage_demand_sv.PopulateLastReceiptRec',
466: v_Progress);
467: --
468: IF (l_debug <> -1) THEN
469: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

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

763:
764: EXCEPTION
765:
766: WHEN OTHERS THEN
767: rlm_message_sv.sql_error('rlm_manage_demand_sv.UOMConversion', v_Progress);
768: --
769: IF (l_debug <> -1) THEN
770: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
771: END IF;

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

1273: v_InterfaceLineId := NULL;
1274: --
1275: END;
1276: --
1277: rlm_message_sv.sql_error('rlm_manage_demand_sv.CUMDiscrepancyCheck',v_Progress);
1278: --
1279: rlm_message_sv.app_error(
1280: x_ExceptionLevel => rlm_message_sv.k_error_level,
1281: x_MessageName => 'RLM_CALC_CUM_KEY_FAILED',

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

1305: raise e_GroupError;
1306: --
1307: WHEN e_CalSupCumAPIFailed THEN /* This is never raised */
1308: --
1309: rlm_message_sv.sql_error('rlm_manage_demand_sv.CUMDiscrepancyCheck', v_Progress);
1310: --
1311: rlm_message_sv.app_error(
1312: x_ExceptionLevel => rlm_message_sv.k_error_level,
1313: x_MessageName => 'RLM_CALC_SUPCUM_KEY_FAILED',

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

1330: raise e_GroupError;
1331: --
1332: WHEN OTHERS THEN
1333: --
1334: rlm_message_sv.sql_error('rlm_manage_demand_sv.CUMDiscrepancyCheck',
1335: v_Progress);
1336: --
1337: IF (l_debug <> -1) THEN
1338: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

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

1400: EXCEPTION
1401: --
1402: WHEN OTHERS THEN
1403: --
1404: rlm_message_sv.sql_error('rlm_manage_demand_sv.SetOperation', v_Progress);
1405: --
1406: IF (l_debug <> -1) THEN
1407: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
1408: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

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

1514: ELSE -- if g_CUM_tab
1515: --
1516: v_cum_record.record_return_status := TRUE;
1517: --
1518: v_cum_key_record.cum_start_date:= rlm_manage_demand_sv.K_DNULL;
1519: --
1520: v_cum_key_record.customer_item_id:= g_ManageDemand_tab(v_count).customer_item_id;
1521: --
1522: v_cum_key_record.inventory_item_id:= g_ManageDemand_tab(v_count).inventory_item_id;

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

1684: IF v_cum_record.cum_key_id IS NULL THEN
1685: --Removed IF check for g_CUM_tab.found as no records exists in g_CUM_tab
1686: v_cum_record.record_return_status := TRUE;
1687: --
1688: v_cum_key_record.cum_start_date := rlm_manage_demand_sv.K_DNULL;
1689: --
1690: v_cum_key_record.customer_item_id:= g_ManageDemand_tab(v_count).customer_item_id;
1691: --
1692: v_cum_key_record.inventory_item_id:= g_ManageDemand_tab(v_count).inventory_item_id;

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

1921: --
1922:
1923: WHEN OTHERS THEN
1924: --
1925: rlm_message_sv.sql_error('rlm_manage_demand_sv.CUMToDiscrete', v_Progress);
1926: --
1927: IF (l_debug <> -1) THEN
1928: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
1929: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 1943: x_SourcedDemand_tab OUT NOCOPY rlm_manage_demand_sv.t_MD_Tab,

1939:
1940: ===========================================================================*/
1941: PROCEDURE ApplySourceRules(x_Sched_rec IN rlm_interface_headers%ROWTYPE,
1942: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1943: x_SourcedDemand_tab OUT NOCOPY rlm_manage_demand_sv.t_MD_Tab,
1944: x_Source_Tab OUT NOCOPY rlm_manage_demand_sv.t_Source_Tab)
1945: IS
1946: --
1947: v_progress VARCHAR2(3) := '010';

Line 1944: x_Source_Tab OUT NOCOPY rlm_manage_demand_sv.t_Source_Tab)

1940: ===========================================================================*/
1941: PROCEDURE ApplySourceRules(x_Sched_rec IN rlm_interface_headers%ROWTYPE,
1942: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1943: x_SourcedDemand_tab OUT NOCOPY rlm_manage_demand_sv.t_MD_Tab,
1944: x_Source_Tab OUT NOCOPY rlm_manage_demand_sv.t_Source_Tab)
1945: IS
1946: --
1947: v_progress VARCHAR2(3) := '010';
1948: k_PLANNING_ACTIVE NUMBER := 1;

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

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

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

3977: WHEN NO_DATA_FOUND THEN
3978: --
3979: IF (l_debug <> -1) THEN
3980: rlm_core_sv.dlog(C_DEBUG,'EXCEPTION: NO_DATA_FOUND');
3981: rlm_core_sv.dlog('rlm_manage_demand_sv.ApplyFFFFences', v_Progress);
3982: rlm_core_sv.dpop(C_SDEBUG);
3983: END IF;
3984: --
3985: WHEN OTHERS THEN

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

3983: END IF;
3984: --
3985: WHEN OTHERS THEN
3986: --
3987: rlm_message_sv.sql_error('rlm_manage_demand_sv.ApplyFFFFences', v_Progress);
3988: --
3989: IF (l_debug <> -1) THEN
3990: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
3991: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

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

4046: --
4047: EXCEPTION
4048:
4049: WHEN OTHERS THEN
4050: rlm_message_sv.sql_error('rlm_manage_demand_sv.ProcessTable',
4051: v_Progress);
4052: --
4053: IF (l_debug <> -1) THEN
4054: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

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

4096:
4097: EXCEPTION
4098:
4099: WHEN OTHERS THEN
4100: rlm_message_sv.sql_error('rlm_manage_demand_sv.DeleteReq',
4101: v_Progress);
4102: --
4103: IF (l_debug <> -1) THEN
4104: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

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

4728: --
4729: RAISE;
4730: --
4731: WHEN OTHERS THEN
4732: rlm_message_sv.sql_error('rlm_manage_demand_sv.InsertReq',
4733: v_Progress);
4734: --
4735: IF (l_debug <> -1) THEN
4736: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

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

4794: --
4795: EXCEPTION
4796:
4797: WHEN OTHERS THEN
4798: rlm_message_sv.sql_error('rlm_manage_demand_sv.UpdateReq',
4799: v_Progress);
4800: --
4801: IF (l_debug <> -1) THEN
4802: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

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

4846: --
4847: EXCEPTION
4848:
4849: WHEN OTHERS THEN
4850: rlm_message_sv.sql_error('rlm_manage_demand_sv.UpdateSchedule', v_Progress);
4851: --
4852: IF (l_debug <> -1) THEN
4853: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
4854: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

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

5384: EXCEPTION
5385: --
5386: WHEN OTHERS THEN
5387: --
5388: rlm_message_sv.sql_error('rlm_manage_demand_sv.MatchDemand', v_Progress);
5389: --
5390: IF (l_debug <> -1) THEN
5391: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
5392: END IF;

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

5472: --
5473: EXCEPTION
5474:
5475: WHEN OTHERS THEN
5476: rlm_message_sv.sql_error('rlm_manage_demand_sv.AggregateDemand', v_Progress);
5477: --
5478: IF (l_debug <> -1) THEN
5479: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
5480: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

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

5558:
5559: EXCEPTION
5560:
5561: WHEN OTHERS THEN
5562: rlm_message_sv.sql_error('rlm_manage_demand_sv.SortDemand', v_Progress);
5563: --
5564: IF (l_debug <> -1) THEN
5565: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
5566: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

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

5627:
5628: EXCEPTION
5629:
5630: WHEN OTHERS THEN
5631: rlm_message_sv.sql_error('rlm_manage_demand_sv.QuickSort', v_Progress);
5632: --
5633: IF (l_debug <> -1) THEN
5634: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
5635: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

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

5663:
5664: EXCEPTION
5665:
5666: WHEN OTHERS THEN
5667: rlm_message_sv.sql_error('rlm_manage_demand_sv.Swap', v_Progress);
5668: --
5669: IF (l_debug <> -1) THEN
5670: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
5671: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

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

5713: --
5714: EXCEPTION
5715:
5716: WHEN OTHERS THEN
5717: rlm_message_sv.sql_error('rlm_manage_demand_sv.InsertionSort', v_Progress);
5718: --
5719: IF (l_debug <> -1) THEN
5720: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
5721: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

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

5976: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
5977: END IF;
5978:
5979: WHEN OTHERS THEN
5980: rlm_message_sv.sql_error('rlm_manage_demand_sv.RoundStandardPack',
5981: v_Progress);
5982: --
5983: IF (l_debug <> -1) THEN
5984: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

Line 5998: x_Group_ref IN OUT NOCOPY rlm_manage_demand_sv.t_Cursor_ref,

5994: PROCEDURE InitializeMdGroup
5995:
5996: ===========================================================================*/
5997: PROCEDURE InitializeMdGroup(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
5998: x_Group_ref IN OUT NOCOPY rlm_manage_demand_sv.t_Cursor_ref,
5999: x_Group_rec IN rlm_dp_sv.t_Group_rec)
6000: IS
6001:
6002: BEGIN

Line 6947: <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO

6943: AND il.inventory_item_id = x_Group_rec.inventory_item_id
6944: AND il.customer_item_id = x_Group_rec.customer_item_id
6945: AND il.schedule_line_id = sl.line_id
6946: AND NVL(il.item_detail_type, ' ')
6947: <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO
6948: AND sl.qty_type_code = rlm_manage_demand_sv.k_ACTUAL;
6949:
6950:
6951: --

Line 6948: AND sl.qty_type_code = rlm_manage_demand_sv.k_ACTUAL;

6944: AND il.customer_item_id = x_Group_rec.customer_item_id
6945: AND il.schedule_line_id = sl.line_id
6946: AND NVL(il.item_detail_type, ' ')
6947: <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO
6948: AND sl.qty_type_code = rlm_manage_demand_sv.k_ACTUAL;
6949:
6950:
6951: --
6952: IF (v_min_horizon_date IS NOT NULL ) THEN

Line 7006: x_Source_Tab IN RLM_MANAGE_DEMAND_SV.t_Source_Tab)

7002:
7003:
7004: FUNCTION GetAllIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7005: x_Group_rec IN rlm_dp_sv.t_Group_rec,
7006: x_Source_Tab IN RLM_MANAGE_DEMAND_SV.t_Source_Tab)
7007: RETURN NUMBER
7008: IS
7009:
7010: -- The shipper ID is stored in the item_detail_ref_value_1 field

Line 8372: <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO

8368: AND il.inventory_item_id = x_Group_rec.inventory_item_id
8369: AND il.customer_item_id = x_Group_rec.customer_item_id
8370: AND il.schedule_line_id = sl.line_id
8371: AND NVL(il.item_detail_type, ' ')
8372: <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO
8373: AND sl.qty_type_code = rlm_manage_demand_sv.k_ACTUAL;
8374:
8375:
8376: --

Line 8373: AND sl.qty_type_code = rlm_manage_demand_sv.k_ACTUAL;

8369: AND il.customer_item_id = x_Group_rec.customer_item_id
8370: AND il.schedule_line_id = sl.line_id
8371: AND NVL(il.item_detail_type, ' ')
8372: <> rlm_manage_demand_sv.k_SHIP_RECEIPT_INFO
8373: AND sl.qty_type_code = rlm_manage_demand_sv.k_ACTUAL;
8374:
8375:
8376: --
8377: IF (v_min_horizon_date IS NOT NULL ) THEN

Line 8454: return(RLM_MANAGE_DEMAND_SV.K_DNULL);

8450: RETURN DATE IS
8451:
8452: BEGIN
8453:
8454: return(RLM_MANAGE_DEMAND_SV.K_DNULL);
8455:
8456: END GetvarK_DNULL;
8457:
8458:

Line 8459: END RLM_MANAGE_DEMAND_SV;

8455:
8456: END GetvarK_DNULL;
8457:
8458:
8459: END RLM_MANAGE_DEMAND_SV;