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_TPA_SV

Line 478: RLM_TPA_SV.ValidScheduleHeader(g_header_rec);

474: ApplyHeaderDefaults(g_header_rec);
475: --
476: v_progress := '020';
477: --
478: RLM_TPA_SV.ValidScheduleHeader(g_header_rec);
479: --
480: v_progress := '025';
481: --
482: CheckHeaderECETpLocCode(g_header_rec, x_ReturnStatus);

Line 549: RLM_TPA_SV.ValidateCustomerItem(g_header_rec, g_lines_tab(i));

545: --
546: DeriveCustomerID(g_header_rec,g_lines_tab(i)) ;
547: DeriveShipToID(g_header_rec, g_lines_tab(i));
548: DeriveShipFromOrg(g_header_rec, g_lines_tab(i));
549: RLM_TPA_SV.ValidateCustomerItem(g_header_rec, g_lines_tab(i));
550:
551: --
552: ELSE
553: --

Line 579: RLM_TPA_SV.ValidateCustomerItem(g_header_rec, g_lines_tab(i));

575: END IF;
576: --
577: DeriveCustomerID(g_header_rec,g_lines_tab(i)) ;
578: DeriveShipToID(g_header_rec, g_lines_tab(i));
579: RLM_TPA_SV.ValidateCustomerItem(g_header_rec, g_lines_tab(i));
580: --
581: END IF;
582:
583: g_lines_tab(i).ship_from_org_id := NVL(g_lines_tab(1).ship_from_org_id,

Line 591: RLM_TPA_SV.SetLineTPAttCategory( g_header_rec,

587:
588: --
589: DeriveIntrmdShipToID(g_header_rec, g_lines_tab(i));
590: --
591: RLM_TPA_SV.SetLineTPAttCategory( g_header_rec,
592: g_lines_tab(i),
593: v_Group_rec);
594: --
595: IF (l_debug <> -1) THEN

Line 651: RLM_TPA_SV.DeriveInventoryItemId(g_header_rec, g_lines_tab(i));

647: /** Bugfix 6185706 commented the performance changes
648: --perf changes
649: IF(i=1) THEN
650: --
651: RLM_TPA_SV.DeriveInventoryItemId(g_header_rec, g_lines_tab(i));
652: --
653: ELSE
654: --
655: IF(NVL(g_lines_tab(i).ship_to_address_id,1) <> NVL(g_lines_tab(1).ship_to_address_id,1)) THEN

Line 657: RLM_TPA_SV.DeriveInventoryItemId(g_header_rec, g_lines_tab(i));

653: ELSE
654: --
655: IF(NVL(g_lines_tab(i).ship_to_address_id,1) <> NVL(g_lines_tab(1).ship_to_address_id,1)) THEN
656: --
657: RLM_TPA_SV.DeriveInventoryItemId(g_header_rec, g_lines_tab(i));
658: --
659: ELSE
660: --
661: g_lines_tab(i).inventory_item_id := NVL(g_lines_tab(1).inventory_item_id,g_lines_tab(i).inventory_item_id);

Line 679: RLM_TPA_SV.CheckCUMKeyPO(v_group_rec,

675: --
676: -- All the lines within a group have the same PO and Cust_rec_year
677: -- This procedure needs to be called once per group.
678: --
679: RLM_TPA_SV.CheckCUMKeyPO(v_group_rec,
680: g_header_rec,
681: g_lines_tab(i));
682: --
683: v_first_time := FALSE;

Line 691: RLM_TPA_SV.ValidateLineDetails(v_Group_rec.setup_terms_rec,

687: IF (l_debug <> -1) THEN
688: rlm_core_sv.dlog (C_DEBUG,'process_status',g_lines_tab(i).process_status);
689: END IF;
690: --
691: RLM_TPA_SV.ValidateLineDetails(v_Group_rec.setup_terms_rec,
692: g_header_rec,
693: g_lines_tab(i),
694: k_ORIGINAL);
695: --

Line 739: RLM_TPA_SV.UpdateInterfaceLines(g_header_rec);

735: END IF;
736: --
737: END IF;
738: --
739: RLM_TPA_SV.UpdateInterfaceLines(g_header_rec);
740: --
741: --commit;
742: --
743: -- We need to reset_dependency so that the next group does not face the

Line 760: RLM_TPA_SV.UpdateInterfaceLines(g_header_rec);

756: IF (l_debug <> -1) THEN
757: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
758: END IF;
759: /* update error status for the entire group */
760: RLM_TPA_SV.UpdateInterfaceLines(g_header_rec);
761: --
762: WHEN e_InactiveBlanket THEN
763: --
764: IF (l_debug <> -1) THEN

Line 768: RLM_TPA_SV.UpdateInterfaceLines(g_header_rec);

764: IF (l_debug <> -1) THEN
765: rlm_core_sv.dlog(C_DEBUG,'progress',v_Progress);
766: END IF;
767: --
768: RLM_TPA_SV.UpdateInterfaceLines(g_header_rec);
769: --
770: WHEN OTHERS THEN
771: --
772: IF (l_debug <> -1) THEN

Line 787: RLM_TPA_SV.UpdateInterfaceLines(g_header_rec);

783: g_lines_tab(curr_rec).process_status);
784: END IF;
785: --
786: /* update error status for the entire group */
787: RLM_TPA_SV.UpdateInterfaceLines(g_header_rec);
788: --
789: END;
790: --
791: END LOOP; /* while loop */

Line 905: RLM_TPA_SV.ValidItemDetailType(x_header_rec, x_lines_rec);

901: END IF;
902: --
903: IF x_line_source = k_ORIGINAL THEN
904: --
905: RLM_TPA_SV.ValidItemDetailType(x_header_rec, x_lines_rec);
906: --
907: RLM_TPA_SV.ValidItemDetailSubtype(x_header_rec, x_lines_rec);
908: --
909: RLM_TPA_SV.ValidQtyTypeCode(x_setup_terms_rec, x_header_rec, x_lines_rec);

Line 907: RLM_TPA_SV.ValidItemDetailSubtype(x_header_rec, x_lines_rec);

903: IF x_line_source = k_ORIGINAL THEN
904: --
905: RLM_TPA_SV.ValidItemDetailType(x_header_rec, x_lines_rec);
906: --
907: RLM_TPA_SV.ValidItemDetailSubtype(x_header_rec, x_lines_rec);
908: --
909: RLM_TPA_SV.ValidQtyTypeCode(x_setup_terms_rec, x_header_rec, x_lines_rec);
910: --
911: RLM_TPA_SV.ValidItemDetailQty(x_header_rec, x_lines_rec);

Line 909: RLM_TPA_SV.ValidQtyTypeCode(x_setup_terms_rec, x_header_rec, x_lines_rec);

905: RLM_TPA_SV.ValidItemDetailType(x_header_rec, x_lines_rec);
906: --
907: RLM_TPA_SV.ValidItemDetailSubtype(x_header_rec, x_lines_rec);
908: --
909: RLM_TPA_SV.ValidQtyTypeCode(x_setup_terms_rec, x_header_rec, x_lines_rec);
910: --
911: RLM_TPA_SV.ValidItemDetailQty(x_header_rec, x_lines_rec);
912: --
913: RLM_TPA_SV.ValidDateTypeCode(x_header_rec, x_lines_rec);

Line 911: RLM_TPA_SV.ValidItemDetailQty(x_header_rec, x_lines_rec);

907: RLM_TPA_SV.ValidItemDetailSubtype(x_header_rec, x_lines_rec);
908: --
909: RLM_TPA_SV.ValidQtyTypeCode(x_setup_terms_rec, x_header_rec, x_lines_rec);
910: --
911: RLM_TPA_SV.ValidItemDetailQty(x_header_rec, x_lines_rec);
912: --
913: RLM_TPA_SV.ValidDateTypeCode(x_header_rec, x_lines_rec);
914: --
915: RLM_TPA_SV.ValidDateRange(x_header_rec, x_lines_rec);

Line 913: RLM_TPA_SV.ValidDateTypeCode(x_header_rec, x_lines_rec);

909: RLM_TPA_SV.ValidQtyTypeCode(x_setup_terms_rec, x_header_rec, x_lines_rec);
910: --
911: RLM_TPA_SV.ValidItemDetailQty(x_header_rec, x_lines_rec);
912: --
913: RLM_TPA_SV.ValidDateTypeCode(x_header_rec, x_lines_rec);
914: --
915: RLM_TPA_SV.ValidDateRange(x_header_rec, x_lines_rec);
916: --
917: RLM_TPA_SV.ValidateUOM(x_header_rec, x_lines_rec);

Line 915: RLM_TPA_SV.ValidDateRange(x_header_rec, x_lines_rec);

911: RLM_TPA_SV.ValidItemDetailQty(x_header_rec, x_lines_rec);
912: --
913: RLM_TPA_SV.ValidDateTypeCode(x_header_rec, x_lines_rec);
914: --
915: RLM_TPA_SV.ValidDateRange(x_header_rec, x_lines_rec);
916: --
917: RLM_TPA_SV.ValidateUOM(x_header_rec, x_lines_rec);
918: --
919: --bug 1811536

Line 917: RLM_TPA_SV.ValidateUOM(x_header_rec, x_lines_rec);

913: RLM_TPA_SV.ValidDateTypeCode(x_header_rec, x_lines_rec);
914: --
915: RLM_TPA_SV.ValidDateRange(x_header_rec, x_lines_rec);
916: --
917: RLM_TPA_SV.ValidateUOM(x_header_rec, x_lines_rec);
918: --
919: --bug 1811536
920: --RLM_TPA_SV.ValidPlanningProdSeqNum(x_setup_terms_rec,x_header_rec, x_lines_rec);
921: --

Line 920: --RLM_TPA_SV.ValidPlanningProdSeqNum(x_setup_terms_rec,x_header_rec, x_lines_rec);

916: --
917: RLM_TPA_SV.ValidateUOM(x_header_rec, x_lines_rec);
918: --
919: --bug 1811536
920: --RLM_TPA_SV.ValidPlanningProdSeqNum(x_setup_terms_rec,x_header_rec, x_lines_rec);
921: --
922: RLM_TPA_SV.ValidLineScheduleType(x_header_rec, x_lines_rec);
923: --
924: --performance changes

Line 922: RLM_TPA_SV.ValidLineScheduleType(x_header_rec, x_lines_rec);

918: --
919: --bug 1811536
920: --RLM_TPA_SV.ValidPlanningProdSeqNum(x_setup_terms_rec,x_header_rec, x_lines_rec);
921: --
922: RLM_TPA_SV.ValidLineScheduleType(x_header_rec, x_lines_rec);
923: --
924: --performance changes
925: --ValidForecastDesig(x_setup_terms_rec,x_header_rec, x_lines_rec,x_ForecastDesignator);
926: --

Line 933: RLM_TPA_SV.ValidOrderHeaderId(x_setup_terms_rec, x_header_rec, x_lines_rec);

929: -- Call to ValidOrderHeaderId should be made only if blankets are not setup.
930: --
931: IF x_setup_terms_rec.blanket_number IS NULL THEN
932: --
933: RLM_TPA_SV.ValidOrderHeaderId(x_setup_terms_rec, x_header_rec, x_lines_rec);
934: x_lines_rec.blanket_number := x_setup_terms_rec.blanket_number;
935: --
936: ELSE
937: --

Line 1644: IF NOT RLM_TPA_SV.ValidLookup('RLM_DATE_TYPE_CODE', x_lines_rec.date_type_code,

1640: END IF;
1641: --
1642: -- Allow custom date type values
1643: IF NOT x_lines_rec.item_detail_type in ('3','4','5') Then
1644: IF NOT RLM_TPA_SV.ValidLookup('RLM_DATE_TYPE_CODE', x_lines_rec.date_type_code,
1645: Sysdate) THEN
1646: --
1647: v_progress := '020';
1648: raise e_DateTypeInv;

Line 1806: IF NOT RLM_TPA_SV.ValidLookup( 'RLM_QTY_TYPE_CODE',

1802: --
1803:
1804: -- Allow custom qty type codes
1805: IF NOT x_lines_rec.item_detail_type in ('3','4','5') Then
1806: IF NOT RLM_TPA_SV.ValidLookup( 'RLM_QTY_TYPE_CODE',
1807: x_lines_rec.qty_type_code,
1808: Sysdate) THEN
1809: raise e_QtyTypeInv;
1810: END IF;

Line 1933: v_Status := RLM_TPA_SV.ValidLookup( 'RLM_DEMAND_SUBTYPE',

1929: rlm_core_sv.dpush(C_SDEBUG,'ValidItemDetailSubtype');
1930: END IF;
1931: --
1932: IF x_lines_rec.item_detail_type IN ('0','1','2','6') THEN
1933: v_Status := RLM_TPA_SV.ValidLookup( 'RLM_DEMAND_SUBTYPE',
1934: x_lines_rec.ITEM_DETAIL_SUBTYPE,
1935: Sysdate);
1936:
1937: /*

Line 1940: v_Status := RLM_TPA_SV.ValidLookup( 'RLM_AUTH_SUBTYPE',

1936:
1937: /*
1938: -- allow custom item detail subtypes
1939: ELSIF x_lines_rec.item_detail_type = '3' THEN
1940: v_Status := RLM_TPA_SV.ValidLookup( 'RLM_AUTH_SUBTYPE',
1941: x_lines_rec.ITEM_DETAIL_SUBTYPE,
1942: Sysdate);
1943: ELSIF x_lines_rec.item_detail_type = '4' THEN
1944: v_Status := RLM_TPA_SV.ValidLookup( 'RLM_SHP_RCV_SUBTYPE',

Line 1944: v_Status := RLM_TPA_SV.ValidLookup( 'RLM_SHP_RCV_SUBTYPE',

1940: v_Status := RLM_TPA_SV.ValidLookup( 'RLM_AUTH_SUBTYPE',
1941: x_lines_rec.ITEM_DETAIL_SUBTYPE,
1942: Sysdate);
1943: ELSIF x_lines_rec.item_detail_type = '4' THEN
1944: v_Status := RLM_TPA_SV.ValidLookup( 'RLM_SHP_RCV_SUBTYPE',
1945: x_lines_rec.ITEM_DETAIL_SUBTYPE,
1946: Sysdate);
1947: ELSE
1948: v_Status := RLM_TPA_SV.ValidLookup( 'RLM_INFO_SUBTYPE',

Line 1948: v_Status := RLM_TPA_SV.ValidLookup( 'RLM_INFO_SUBTYPE',

1944: v_Status := RLM_TPA_SV.ValidLookup( 'RLM_SHP_RCV_SUBTYPE',
1945: x_lines_rec.ITEM_DETAIL_SUBTYPE,
1946: Sysdate);
1947: ELSE
1948: v_Status := RLM_TPA_SV.ValidLookup( 'RLM_INFO_SUBTYPE',
1949: x_lines_rec.ITEM_DETAIL_SUBTYPE,
1950: Sysdate);
1951: */
1952:

Line 2023: IF NOT RLM_TPA_SV.ValidLookup( 'RLM_DETAIL_TYPE_CODE',

2019: IF (l_debug <> -1) THEN
2020: rlm_core_sv.dpush(C_SDEBUG,'ValidItemDetailType');
2021: END IF;
2022: --
2023: IF NOT RLM_TPA_SV.ValidLookup( 'RLM_DETAIL_TYPE_CODE',
2024: x_lines_rec.item_detail_type,
2025: Sysdate)
2026: THEN
2027: raise e_ItemDetailTypeInvalid;

Line 2807: RLM_TPA_SV.SetHdrTPAttCategory(x_header_rec);

2803: END IF;
2804: --
2805: v_progress := '050';
2806: --
2807: RLM_TPA_SV.SetHdrTPAttCategory(x_header_rec);
2808: --
2809: IF (l_debug <> -1) THEN
2810: rlm_core_sv.dpop(C_SDEBUG);
2811: END IF;

Line 3008: RLM_TPA_SV.ValidScheduleType(x_header_rec);

3004: IF (l_debug <> -1) THEN
3005: rlm_core_sv.dpush(C_SDEBUG,'ValidScheduleHeader');
3006: END IF;
3007: --
3008: RLM_TPA_SV.ValidScheduleType(x_header_rec);
3009: v_progress := '020';
3010: RLM_TPA_SV.ValidSchedulePurpose(x_header_rec);
3011: v_progress := '030';
3012: RLM_TPA_SV.ValidHorizonDates(x_header_rec);

Line 3010: RLM_TPA_SV.ValidSchedulePurpose(x_header_rec);

3006: END IF;
3007: --
3008: RLM_TPA_SV.ValidScheduleType(x_header_rec);
3009: v_progress := '020';
3010: RLM_TPA_SV.ValidSchedulePurpose(x_header_rec);
3011: v_progress := '030';
3012: RLM_TPA_SV.ValidHorizonDates(x_header_rec);
3013: v_progress := '040';
3014: RLM_TPA_SV.ValidScheduleReferenceNum(x_header_rec);

Line 3012: RLM_TPA_SV.ValidHorizonDates(x_header_rec);

3008: RLM_TPA_SV.ValidScheduleType(x_header_rec);
3009: v_progress := '020';
3010: RLM_TPA_SV.ValidSchedulePurpose(x_header_rec);
3011: v_progress := '030';
3012: RLM_TPA_SV.ValidHorizonDates(x_header_rec);
3013: v_progress := '040';
3014: RLM_TPA_SV.ValidScheduleReferenceNum(x_header_rec);
3015: v_progress := '060';
3016: RLM_TPA_SV.ValidScheduleSource(x_header_rec);

Line 3014: RLM_TPA_SV.ValidScheduleReferenceNum(x_header_rec);

3010: RLM_TPA_SV.ValidSchedulePurpose(x_header_rec);
3011: v_progress := '030';
3012: RLM_TPA_SV.ValidHorizonDates(x_header_rec);
3013: v_progress := '040';
3014: RLM_TPA_SV.ValidScheduleReferenceNum(x_header_rec);
3015: v_progress := '060';
3016: RLM_TPA_SV.ValidScheduleSource(x_header_rec);
3017: v_progress := '070';
3018: RLM_TPA_SV.ValidNumberLines(x_header_rec);

Line 3016: RLM_TPA_SV.ValidScheduleSource(x_header_rec);

3012: RLM_TPA_SV.ValidHorizonDates(x_header_rec);
3013: v_progress := '040';
3014: RLM_TPA_SV.ValidScheduleReferenceNum(x_header_rec);
3015: v_progress := '060';
3016: RLM_TPA_SV.ValidScheduleSource(x_header_rec);
3017: v_progress := '070';
3018: RLM_TPA_SV.ValidNumberLines(x_header_rec);
3019: --
3020: IF (l_debug <> -1) THEN

Line 3018: RLM_TPA_SV.ValidNumberLines(x_header_rec);

3014: RLM_TPA_SV.ValidScheduleReferenceNum(x_header_rec);
3015: v_progress := '060';
3016: RLM_TPA_SV.ValidScheduleSource(x_header_rec);
3017: v_progress := '070';
3018: RLM_TPA_SV.ValidNumberLines(x_header_rec);
3019: --
3020: IF (l_debug <> -1) THEN
3021: rlm_core_sv.dpop(C_SDEBUG);
3022: END IF;

Line 3665: IF NOT (RLM_TPA_SV.ValidLookup('RLM_SCHEDULE_TYPE',

3661: IF (l_debug <> -1) THEN
3662: rlm_core_sv.dlog(C_DEBUG,'ScheduleType',x_header_rec.schedule_type);
3663: END IF;
3664: --
3665: IF NOT (RLM_TPA_SV.ValidLookup('RLM_SCHEDULE_TYPE',
3666: x_header_rec.schedule_type,
3667: x_header_rec.sched_generation_date)) THEN
3668: --
3669: RAISE e_SchTypeInv;

Line 3863: IF NOT (RLM_TPA_SV.ValidLookup('RLM_SCHEDULE_PURPOSE',

3859: rlm_core_sv.dlog(C_DEBUG,'x_header_rec.schedule_purpose',
3860: x_header_rec.schedule_purpose );
3861: END IF;
3862: --
3863: IF NOT (RLM_TPA_SV.ValidLookup('RLM_SCHEDULE_PURPOSE',
3864: x_header_rec.schedule_purpose,
3865: x_header_rec.sched_generation_date)) THEN
3866: --
3867: RAISE e_SchPurposeInv;

Line 4257: RLM_TPA_SV.DeriveInventoryItemId(x_header_rec, x_lines_rec);

4253: rlm_core_sv.dpush(C_SDEBUG,'DeriveOrgDependentIDs');
4254: END IF;
4255: --
4256: --undo performance changes for bug 6185706
4257: RLM_TPA_SV.DeriveInventoryItemId(x_header_rec, x_lines_rec);
4258: DerivePurchaseOrder(x_setup_terms_rec, x_header_rec, x_lines_rec);
4259: --derive_price_list; -- TODO
4260: --
4261: IF (l_debug <> -1) THEN

Line 4310: RLM_TPA_SV.ValidateCustomerItem(x_header_rec, x_lines_rec);

4306:
4307: -- validate the relationship of customer id of bill_to and ship_to
4308: --
4309: DeriveIntrmdShipToID(x_header_rec, x_lines_rec);
4310: RLM_TPA_SV.ValidateCustomerItem(x_header_rec, x_lines_rec);
4311: DeriveShipFromOrg(x_header_rec, x_lines_rec);
4312: --
4313: IF (l_debug <> -1) THEN
4314: rlm_core_sv.dpop(C_SDEBUG);

Line 7335: RLM_TPA_SV.CalculateCUMKey(v_cum_key_record, v_cum_record);

7331: v_cum_key_record.ship_to_address_id);
7332: END IF;
7333: --
7334: v_cum_key_record.create_cum_key_flag := 'N';
7335: RLM_TPA_SV.CalculateCUMKey(v_cum_key_record, v_cum_record);
7336: --
7337: IF v_cum_record.cum_key_id IS NULL THEN
7338: --
7339: IF (l_debug <> -1) THEN

Line 9063: RLM_TPA_SV.get_setup_terms(x_lines_rec.ship_from_org_id,

9059: THEN
9060: RAISE e_skip_callsetup;
9061: END IF;*/ --Bugfix 8693697 End
9062:
9063: RLM_TPA_SV.get_setup_terms(x_lines_rec.ship_from_org_id,
9064: x_header_rec.customer_id,
9065: x_lines_rec.ship_to_address_id,
9066: x_lines_rec.customer_item_id,
9067: v_TermsLevel,

Line 9242: rlm_tpa_sv.GetDesignator(

9238: END IF;
9239: --
9240: IF IsMRPForecastFence THEN
9241: --
9242: rlm_tpa_sv.GetDesignator(
9243: NULL,
9244: NULL,
9245: x_header_rec.Customer_id,
9246: x_lines_rec.Ship_From_Org_Id,