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_VALIDATEDEMAND_SV dependencies on RLM_VALIDATEDEMAND_SV

Line 1: PACKAGE BODY RLM_VALIDATEDEMAND_SV as

1: PACKAGE BODY RLM_VALIDATEDEMAND_SV as
2: /* $Header: RLMDPVDB.pls 120.15.12010000.3 2009/08/07 09:27:30 sunilku ship $*/
3: /*=========================RLM_VALIDATEDEMAND_SV ===========================*/
4:
5: --

Line 3: /=========================RLM_VALIDATEDEMAND_SV ===========================/

1: PACKAGE BODY RLM_VALIDATEDEMAND_SV as
2: /* $Header: RLMDPVDB.pls 120.15.12010000.3 2009/08/07 09:27:30 sunilku ship $*/
3: /*=========================RLM_VALIDATEDEMAND_SV ===========================*/
4:
5: --
6: l_DEBUG NUMBER := NVL(fnd_profile.value('RLM_DEBUG_MODE'),-1);
7: --

Line 419: rlm_message_sv.sql_error('rlm_validatedemand_sv.CheckHeaderECETpLocCode', v_Progress);

415: WHEN OTHERS THEN
416: --
417: g_header_rec.process_status := rlm_core_sv.k_PS_ERROR;
418: x_returnStatus := rlm_core_sv.k_PROC_ERROR;
419: rlm_message_sv.sql_error('rlm_validatedemand_sv.CheckHeaderECETpLocCode', v_Progress);
420: --
421: IF (l_debug <> -1) THEN
422: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
423: END IF;

Line 866: rlm_message_sv.sql_error('rlm_validatedemand_sv.GroupValidateDemand', v_Progress);

862: --
863: WHEN OTHERS THEN
864: --
865: x_procedure_status := rlm_core_sv.k_PROC_ERROR;
866: rlm_message_sv.sql_error('rlm_validatedemand_sv.GroupValidateDemand', v_Progress);
867: --
868: IF (l_debug <> -1) THEN
869: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
870: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 960: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidateLineDetails',

956: EXCEPTION
957: WHEN OTHERS THEN
958: --
959: --x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
960: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidateLineDetails',
961: v_Progress);
962: --
963: IF (l_debug <> -1) THEN
964: rlm_core_sv.dlog(C_DEBUG,'process_status',x_lines_rec.process_status);

Line 1308: rlm_message_sv.sql_error('rlm_validateDemand_sv.ValidOrderHeaderId',

1304: WHEN OTHERS THEN
1305: --
1306: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
1307: --
1308: rlm_message_sv.sql_error('rlm_validateDemand_sv.ValidOrderHeaderId',
1309: v_Progress);
1310: --
1311: IF (l_debug <> -1) THEN
1312: rlm_core_sv.dlog(C_DEBUG,'process_status',x_lines_rec.process_status);

Line 1486: rlm_message_sv.sql_error('rlm_validateDemand_sv.ValidateUOM', v_Progress);

1482: WHEN OTHERS THEN
1483: --
1484: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
1485: --
1486: rlm_message_sv.sql_error('rlm_validateDemand_sv.ValidateUOM', v_Progress);
1487: --
1488: IF (l_debug <> -1) THEN
1489: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
1490: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 1612: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidDateRange',v_Progress);

1608: --
1609: WHEN OTHERS THEN
1610: --
1611: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
1612: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidDateRange',v_Progress);
1613: --
1614: IF (l_debug <> -1) THEN
1615: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
1616: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 1680: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidDateTypeCode: ',

1676: --
1677: WHEN OTHERS THEN
1678: --
1679: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
1680: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidDateTypeCode: ',
1681: v_Progress);
1682: --
1683: IF (l_debug <> -1) THEN
1684: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 1761: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidItemDetailQty: ',

1757: WHEN OTHERS THEN
1758: --
1759: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
1760: --
1761: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidItemDetailQty: ',
1762: v_Progress);
1763: --
1764: IF (l_debug <> -1) THEN
1765: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 1899: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidQtyTypeCode',

1895: WHEN OTHERS THEN
1896: --
1897: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
1898: --
1899: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidQtyTypeCode',
1900: v_Progress);
1901: --
1902: IF (l_debug <> -1) THEN
1903: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

Line 1992: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidItemDetailSubtype: ',

1988: --
1989: WHEN OTHERS THEN
1990: --
1991: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
1992: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidItemDetailSubtype: ',
1993: v_Progress);
1994: --
1995: IF (l_debug <> -1) THEN
1996: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 2061: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidItemDetailType: ',

2057: --
2058: WHEN OTHERS THEN
2059: --
2060: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
2061: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidItemDetailType: ',
2062: v_Progress);
2063: --
2064: IF (l_debug <> -1) THEN
2065: rlm_core_sv.dlog(C_DEBUG,'OTHERS',x_lines_rec.item_detail_type);

Line 2389: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidateCriticalKeys:',

2385: WHEN OTHERS THEN
2386: --
2387: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
2388: --
2389: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidateCriticalKeys:',
2390: v_Progress);
2391: --
2392: IF (l_debug <> -1) THEN
2393: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 2692: rlm_message_sv.sql_error('rlm_validatedemand_sv.PopulateLinesTab',

2688: --
2689: WHEN OTHERS THEN
2690: --
2691: g_header_rec.process_status := rlm_core_sv.k_PS_ERROR;
2692: rlm_message_sv.sql_error('rlm_validatedemand_sv.PopulateLinesTab',
2693: v_Progress);
2694: --
2695: IF (l_debug <> -1) THEN
2696: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 2747: rlm_message_sv.sql_error('rlm_validatedemand_sv.BuildHeaderRec',v_Progress);

2743: RETURN FALSE;
2744: --
2745: WHEN OTHERS THEN
2746: --
2747: rlm_message_sv.sql_error('rlm_validatedemand_sv.BuildHeaderRec',v_Progress);
2748: --
2749: IF (l_debug <> -1) THEN
2750: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2751: END IF;

Line 2818: rlm_message_sv.sql_error('rlm_validatedemand_sv.ApplyHeaderDefaults',

2814: --
2815: WHEN OTHERS THEN
2816: --
2817: x_header_rec.process_status := rlm_core_sv.k_PS_ERROR;
2818: rlm_message_sv.sql_error('rlm_validatedemand_sv.ApplyHeaderDefaults',
2819: v_Progress);
2820: --
2821: IF (l_debug <> -1) THEN
2822: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 2981: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetDateFromTable', v_Progress);

2977: --
2978: WHEN OTHERS THEN
2979: --
2980: g_header_rec.process_status := rlm_core_sv.k_PS_ERROR;
2981: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetDateFromTable', v_Progress);
2982: --
2983: IF (l_debug <> -1) THEN
2984: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
2985: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 3029: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidScheduleHeader', v_Progress);

3025: --
3026: WHEN OTHERS THEN
3027: --
3028: x_header_rec.process_status := rlm_core_sv.k_PS_ERROR;
3029: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidScheduleHeader', v_Progress);
3030: --
3031: IF (l_debug <> -1) THEN
3032: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
3033: END IF;

Line 3094: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidNumberLines',

3090: WHEN OTHERS THEN
3091: --
3092: x_header_rec.process_status := rlm_core_sv.k_PS_ERROR;
3093: --
3094: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidNumberLines',
3095: v_Progress);
3096: --
3097: IF (l_debug <> -1) THEN
3098: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 3490: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidScheduleSource',

3486: -- Bug 4995267: End
3487: WHEN OTHERS THEN
3488: --
3489: x_header_rec.process_status := rlm_core_sv.k_PS_ERROR;
3490: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidScheduleSource',
3491: v_Progress);
3492: --
3493: IF (l_debug <> -1) THEN
3494: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 3566: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidHorizonDates',

3562: --
3563: WHEN OTHERS THEN
3564: --
3565: x_header_rec.process_status := rlm_core_sv.k_PS_ERROR;
3566: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidHorizonDates',
3567: v_Progress);
3568: --
3569: IF (l_debug <> -1) THEN
3570: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 3631: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidScheduleReferenceNum',

3627: --
3628: WHEN OTHERS THEN
3629: --
3630: x_header_rec.process_status := rlm_core_sv.k_PS_ERROR;
3631: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidScheduleReferenceNum',
3632: v_Progress);
3633: --
3634: IF (l_debug <> -1) THEN
3635: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 3701: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidScheduleType: ',

3697: --
3698: WHEN OTHERS THEN
3699: --
3700: x_header_rec.process_status := rlm_core_sv.k_PS_ERROR;
3701: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidScheduleType: ',
3702: v_Progress);
3703: --
3704: IF (l_debug <> -1) THEN
3705: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 3777: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidLookup: ',v_Progress);

3773: EXCEPTION
3774: --
3775: WHEN OTHERS THEN
3776: --
3777: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidLookup: ',v_Progress);
3778: --
3779: IF (l_debug <> -1) THEN
3780: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
3781: END IF;

Line 4226: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidSchedulePurpose: ',

4222: -- Bug 4995267: End
4223: WHEN OTHERS THEN
4224: --
4225: x_header_rec.process_status := rlm_core_sv.k_PS_ERROR;
4226: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidSchedulePurpose: ',
4227: v_Progress);
4228: --
4229: IF (l_debug <> -1) THEN
4230: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 4270: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveOrgDependentIDs: ',

4266: --
4267: WHEN OTHERS THEN
4268: --
4269: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
4270: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveOrgDependentIDs: ',
4271: v_Progress);
4272: --
4273: IF (l_debug <> -1) THEN
4274: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 4322: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveIDs', v_Progress);

4318: --
4319: WHEN OTHERS THEN
4320: --
4321: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
4322: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveIDs', v_Progress);
4323: --
4324: IF (l_debug <> -1) THEN
4325: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4326: END IF;

Line 4839: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveInventoryItemId',

4835: --
4836: WHEN OTHERS THEN
4837: --
4838: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
4839: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveInventoryItemId',
4840: v_Progress);
4841: --
4842: IF (l_debug <> -1) THEN
4843: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 4983: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidateCustomerItem',

4979: --
4980: WHEN OTHERS THEN
4981: --
4982: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
4983: rlm_message_sv.sql_error('rlm_validatedemand_sv.ValidateCustomerItem',
4984: v_Progress);
4985: --
4986: IF (l_debug <> -1) THEN
4987: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 5291: 'rlm_validateDemand_sv.DerivePurchaseOrder',v_Progress);

5287: END IF;
5288: --
5289: WHEN OTHERS THEN
5290: rlm_message_sv.sql_error(
5291: 'rlm_validateDemand_sv.DerivePurchaseOrder',v_Progress);
5292: --
5293: IF (l_debug <> -1) THEN
5294: rlm_core_sv.dlog(C_DEBUG,'EXCEPTION:'||SUBSTR(SQLERRM,1,200));
5295: END IF;

Line 5483: rlm_message_sv.sql_error('rlm_validatedemand_sv.DerivePurchaseOrder',

5479: --
5480: WHEN OTHERS THEN
5481: --
5482: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
5483: rlm_message_sv.sql_error('rlm_validatedemand_sv.DerivePurchaseOrder',
5484: v_Progress);
5485: --
5486: IF (l_debug <> -1) THEN
5487: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 5805: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveCustomerID',

5801: WHEN OTHERS THEN
5802: --
5803: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
5804: g_Schedule_PS := rlm_core_sv.k_PS_ERROR;
5805: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveCustomerID',
5806: v_Progress);
5807: --
5808: IF (l_debug <> -1) THEN
5809: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 5924: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveShipFromOrg',

5920: raise e_ManyRows;
5921: --
5922: WHEN OTHERS THEN
5923: --
5924: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveShipFromOrg',
5925: v_Progress);
5926: --
5927: IF (l_debug <> -1) THEN
5928: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 6001: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveShipFromOrg', v_Progress);

5997: --
5998: WHEN OTHERS THEN
5999: --
6000: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
6001: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveShipFromOrg', v_Progress);
6002: --
6003: IF (l_debug <> -1) THEN
6004: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
6005: END IF;

Line 6313: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveIntrmdShipToID',

6309: --
6310: WHEN OTHERS THEN
6311: --
6312: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
6313: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveIntrmdShipToID',
6314: v_Progress);
6315: --
6316: IF (l_debug <> -1) THEN
6317: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 6785: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveBillToID',v_Progress);

6781: --
6782: WHEN OTHERS THEN
6783: --
6784: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
6785: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveBillToID',v_Progress);
6786: --
6787: IF (l_debug <> -1) THEN
6788: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
6789: END IF;

Line 7269: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveShipToID',

7265: --
7266: WHEN OTHERS THEN
7267: --
7268: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
7269: rlm_message_sv.sql_error('rlm_validatedemand_sv.DeriveShipToID',
7270: v_Progress);
7271: --
7272: IF (l_debug <> -1) THEN
7273: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 7541: x_group_rec IN RLM_VALIDATEDEMAND_SV.t_group_rec,

7537:
7538: ===========================================================================*/
7539:
7540: PROCEDURE CheckCUMKeyPO(
7541: x_group_rec IN RLM_VALIDATEDEMAND_SV.t_group_rec,
7542: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7543: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
7544: IS
7545: --

Line 7744: rlm_message_sv.sql_error('rlm_validateDemand_sv.CheckCUMKeyPO', v_Progress);

7740: CLOSE c_cum; --bug 4570658
7741: END IF;
7742:
7743: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
7744: rlm_message_sv.sql_error('rlm_validateDemand_sv.CheckCUMKeyPO', v_Progress);
7745: --
7746: IF (l_debug <> -1) THEN
7747: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
7748: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 7843: rlm_message_sv.sql_error('rlm_validateDemand_sv.ValidPlanningProdSeqNum',

7839: --
7840: WHEN OTHERS THEN
7841: --
7842: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
7843: rlm_message_sv.sql_error('rlm_validateDemand_sv.ValidPlanningProdSeqNum',
7844: v_Progress);
7845: --
7846: IF (l_debug <> -1) THEN
7847: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 7917: rlm_message_sv.sql_error('rlm_validateDemand_sv.ValidLineScheduleType: ',

7913: --
7914: WHEN OTHERS THEN
7915: --
7916: x_lines_rec.process_status := rlm_core_sv.k_PS_ERROR;
7917: rlm_message_sv.sql_error('rlm_validateDemand_sv.ValidLineScheduleType: ',
7918: v_Progress);
7919: --
7920: IF (l_debug <> -1) THEN
7921: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 8803: rlm_message_sv.sql_error('rlm_validateDemand_sv.UpdateInterfaceLines',

8799: EXCEPTION
8800: --
8801: WHEN OTHERS THEN
8802: --
8803: rlm_message_sv.sql_error('rlm_validateDemand_sv.UpdateInterfaceLines',
8804: v_Progress);
8805: --
8806: IF (l_debug <> -1) THEN
8807: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);

Line 8940: rlm_message_sv.sql_error('rlm_validateDemand_sv.UpdateInterfaceHeaders: ',

8936: EXCEPTION
8937: WHEN OTHERS THEN
8938: --
8939: rollback;
8940: rlm_message_sv.sql_error('rlm_validateDemand_sv.UpdateInterfaceHeaders: ',
8941: v_Progress);
8942: --
8943: IF (l_debug <> -1) THEN
8944: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 9001: rlm_message_sv.sql_error('rlm_validateDemand_sv.PostValidation: ',

8997: --
8998: WHEN OTHERS THEN
8999: --
9000: g_header_rec.process_status := rlm_core_sv.k_PS_ERROR;
9001: rlm_message_sv.sql_error('rlm_validateDemand_sv.PostValidation: ',
9002: v_Progress);
9003: --
9004: IF (l_debug <> -1) THEN
9005: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 9443: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetTPContext', v_Progress);

9439: rlm_core_sv.dpop(C_SDEBUG);
9440: END IF;
9441:
9442: WHEN OTHERS THEN
9443: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetTPContext', v_Progress);
9444: --
9445: IF (l_debug <> -1) THEN
9446: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
9447: END IF;

Line 9520: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetHdrTPContext', v_Progress);

9516: rlm_core_sv.dpop(C_SDEBUG);
9517: END IF;
9518:
9519: WHEN OTHERS THEN
9520: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetHdrTPContext', v_Progress);
9521: --
9522: IF (l_debug <> -1) THEN
9523: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
9524: END IF;

Line 9536: x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec) IS

9532: ==============================================================================*/
9533: PROCEDURE SetTPAttCategory (
9534: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
9535: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
9536: x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec) IS
9537: BEGIN
9538: --
9539: IF (l_debug <> -1) THEN
9540: rlm_core_sv.dpush(C_SDEBUG,'SetTPAttCategory');

Line 9591: x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec) IS

9587: ==============================================================================*/
9588: PROCEDURE SetLineTPAttCategory (
9589: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
9590: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
9591: x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec) IS
9592: BEGIN
9593: --
9594: IF (l_debug <> -1) THEN
9595: rlm_core_sv.dpush(C_SDEBUG,'SetLineTPAttCategory');

Line 9727: rlm_message_sv.sql_error('RLM_VALIDATEDEMAND_SV.CustomerRelationship',

9723: RETURN(FALSE);
9724: --
9725: WHEN OTHERS THEN
9726: --
9727: rlm_message_sv.sql_error('RLM_VALIDATEDEMAND_SV.CustomerRelationship',
9728: v_Progress);
9729: --
9730: IF (l_debug <> -1) THEN
9731: rlm_core_sv.dlog (C_DEBUG,'SQL Error: ',substr(sqlerrm,1,300));

Line 10148: END RLM_VALIDATEDEMAND_SV;

10144:
10145: END ValidateBlanket;
10146:
10147: -- End of package
10148: END RLM_VALIDATEDEMAND_SV;