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_SETUP_TERMS_SV dependencies on RLM_CORE_SV

Line 44: rlm_core_sv.dpush(C_SDEBUG, 'get_setup_terms');

40:
41: BEGIN
42: --
43: IF (l_debug <> -1) THEN
44: rlm_core_sv.dpush(C_SDEBUG, 'get_setup_terms');
45: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id);
46: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id);
47: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id);
48: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id);

Line 45: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id);

41: BEGIN
42: --
43: IF (l_debug <> -1) THEN
44: rlm_core_sv.dpush(C_SDEBUG, 'get_setup_terms');
45: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id);
46: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id);
47: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id);
48: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id);
49: END IF;

Line 46: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id);

42: --
43: IF (l_debug <> -1) THEN
44: rlm_core_sv.dpush(C_SDEBUG, 'get_setup_terms');
45: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id);
46: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id);
47: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id);
48: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id);
49: END IF;
50: --

Line 47: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id);

43: IF (l_debug <> -1) THEN
44: rlm_core_sv.dpush(C_SDEBUG, 'get_setup_terms');
45: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id);
46: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id);
47: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id);
48: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id);
49: END IF;
50: --
51: -- Mandatory parameters can not be null

Line 48: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id);

44: rlm_core_sv.dpush(C_SDEBUG, 'get_setup_terms');
45: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id);
46: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id);
47: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id);
48: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id);
49: END IF;
50: --
51: -- Mandatory parameters can not be null
52: -- global_atp: ship_from_org_id can be null

Line 169: rlm_core_sv.dpop(C_SDEBUG);

165: --
166: END IF;
167: --
168: IF (l_debug <> -1) THEN
169: rlm_core_sv.dpop(C_SDEBUG);
170: END IF;
171: --
172: EXCEPTION
173: WHEN e_null_mandatory THEN

Line 182: rlm_core_sv.dpop(C_SDEBUG, 'Mandatory parameters can not be blank');

178: --
179: x_return_status := FALSE;
180: --
181: IF (l_debug <> -1) THEN
182: rlm_core_sv.dpop(C_SDEBUG, 'Mandatory parameters can not be blank');
183: END IF;
184: --
185: WHEN e_null_address THEN
186: --

Line 198: rlm_core_sv.dpop(C_SDEBUG, 'Ship_to_address_id is required when terms definition level is ADDRESS');

194: --
195: x_return_status := FALSE;
196: --
197: IF (l_debug <> -1) THEN
198: rlm_core_sv.dpop(C_SDEBUG, 'Ship_to_address_id is required when terms definition level is ADDRESS');
199: END IF;
200: --
201: WHEN e_null_customer_item THEN
202: --

Line 211: rlm_core_sv.dpop(C_SDEBUG, 'Customer_item_id is required when terms definition level is CUSTOMER_ITEM');

207: --
208: x_return_status := FALSE;
209: --
210: IF (l_debug <> -1) THEN
211: rlm_core_sv.dpop(C_SDEBUG, 'Customer_item_id is required when terms definition level is CUSTOMER_ITEM');
212: END IF;
213: --
214: WHEN e_invalid_terms_level THEN
215: --

Line 226: rlm_core_sv.dpop(C_SDEBUG, 'The terms_definition_level has to be one of the following: CUSTOMER, ADDRESS, CUSTOMER_ITEM');

222: --
223: x_return_status := FALSE;
224: --
225: IF (l_debug <> -1) THEN
226: rlm_core_sv.dpop(C_SDEBUG, 'The terms_definition_level has to be one of the following: CUSTOMER, ADDRESS, CUSTOMER_ITEM');
227: END IF;
228: --
229: WHEN OTHERS THEN
230: --

Line 234: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);

230: --
231: x_return_status := FALSE;
232: --
233: IF (l_debug <> -1) THEN
234: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);
235: rlm_core_sv.dpop(C_SDEBUG);
236: END IF;
237: --
238: raise;

Line 235: rlm_core_sv.dpop(C_SDEBUG);

231: x_return_status := FALSE;
232: --
233: IF (l_debug <> -1) THEN
234: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);
235: rlm_core_sv.dpop(C_SDEBUG);
236: END IF;
237: --
238: raise;
239: --

Line 262: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_cust');

258: e_no_default EXCEPTION;
259: BEGIN
260: --
261: IF (l_debug <> -1) THEN
262: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_cust');
263: END IF;
264: --
265: v_ship_from_org_id := x_ship_from_org_id;
266: --

Line 282: rlm_core_sv.dlog(C_DEBUG, 'v_ship_from_org_id', v_ship_from_org_id );

278: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
279:
280: -- Proceed
281: IF (l_debug <> -1) THEN
282: rlm_core_sv.dlog(C_DEBUG, 'v_ship_from_org_id', v_ship_from_org_id );
283: END IF;
284:
285: EXCEPTION
286: WHEN TOO_MANY_ROWS THEN

Line 299: rlm_core_sv.dlog(C_DEBUG, 'Default v_ship_from_org_id', v_ship_from_org_id );

295: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
296:
297: -- Proceed
298: IF (l_debug <> -1) THEN
299: rlm_core_sv.dlog(C_DEBUG, 'Default v_ship_from_org_id', v_ship_from_org_id );
300: END IF;
301:
302: EXCEPTION
303: WHEN NO_DATA_FOUND THEN

Line 547: x_terms_rec.match_within_key := rlm_core_sv.get_default_key;

543: /* By default, match_within_key is ABCDEFG */
544: --
545: IF x_terms_rec.match_within_key is NULL THEN
546: --
547: x_terms_rec.match_within_key := rlm_core_sv.get_default_key;
548: --
549: END IF;
550: --
551: /* By default, match_across_key is ABCDEFG */

Line 555: x_terms_rec.match_across_key := rlm_core_sv.get_default_key;

551: /* By default, match_across_key is ABCDEFG */
552: --
553: IF x_terms_rec.match_across_key is NULL THEN
554: --
555: x_terms_rec.match_across_key := rlm_core_sv.get_default_key;
556: --
557: END IF;
558: --
559: x_terms_rec.calc_cum_flag := 'Y';

Line 564: rlm_core_sv.dpop(C_SDEBUG);

560: x_terms_definition_level := 'CUSTOMER';
561: x_return_status := TRUE;
562: --
563: IF (l_debug <> -1) THEN
564: rlm_core_sv.dpop(C_SDEBUG);
565: END IF;
566: --
567: EXCEPTION
568: --

Line 576: x_value1 => rlm_core_sv.get_customer_name(x_Customer_id));

572: rlm_message_sv.get_msg_text(
573: x_message_name => x_terms_rec.msg_name,
574: x_text => x_return_message,
575: x_token1 => 'CUSTOMER',
576: x_value1 => rlm_core_sv.get_customer_name(x_Customer_id));
577: --
578: x_terms_definition_level := NULL;
579: --
580: x_return_status := FALSE;

Line 583: rlm_core_sv.dlog(C_DEBUG, 'Too Many Rows ');

579: --
580: x_return_status := FALSE;
581: --
582: IF (l_debug <> -1) THEN
583: rlm_core_sv.dlog(C_DEBUG, 'Too Many Rows ');
584: rlm_core_sv.dpop(C_SDEBUG, 'There are more than one record of RLM Setup Terms at the CUSTOMER level');
585: END IF;
586: --
587: WHEN e_no_default THEN

Line 584: rlm_core_sv.dpop(C_SDEBUG, 'There are more than one record of RLM Setup Terms at the CUSTOMER level');

580: x_return_status := FALSE;
581: --
582: IF (l_debug <> -1) THEN
583: rlm_core_sv.dlog(C_DEBUG, 'Too Many Rows ');
584: rlm_core_sv.dpop(C_SDEBUG, 'There are more than one record of RLM Setup Terms at the CUSTOMER level');
585: END IF;
586: --
587: WHEN e_no_default THEN
588: --

Line 594: x_value1 => RLM_CORE_SV.get_customer_name(x_customer_id));

590: rlm_message_sv.get_msg_text(
591: x_message_name => x_terms_rec.msg_name,
592: x_text => x_return_message,
593: x_token1 => 'CUST',
594: x_value1 => RLM_CORE_SV.get_customer_name(x_customer_id));
595:
596: --
597: x_terms_definition_level := NULL;
598: --

Line 602: rlm_core_sv.dlog(C_DEBUG, 'No Default');

598: --
599: x_return_status := FALSE;
600: --
601: IF (l_debug <> -1) THEN
602: rlm_core_sv.dlog(C_DEBUG, 'No Default');
603: rlm_core_sv.dpop(C_SDEBUG);
604: END IF;
605:
606: WHEN e_inactive_record THEN

Line 603: rlm_core_sv.dpop(C_SDEBUG);

599: x_return_status := FALSE;
600: --
601: IF (l_debug <> -1) THEN
602: rlm_core_sv.dlog(C_DEBUG, 'No Default');
603: rlm_core_sv.dpop(C_SDEBUG);
604: END IF;
605:
606: WHEN e_inactive_record THEN
607: --

Line 615: rlm_core_sv.dpop(C_SDEBUG, 'The RLM Setup Terms record at the CUSTOMER level has been inactivated');

611: --
612: x_return_status := FALSE;
613: --
614: IF (l_debug <> -1) THEN
615: rlm_core_sv.dpop(C_SDEBUG, 'The RLM Setup Terms record at the CUSTOMER level has been inactivated');
616: END IF;
617: --
618: WHEN NO_DATA_FOUND THEN
619: --

Line 625: x_value1 => rlm_core_sv.get_ship_from(x_Ship_from_org_id),

621: rlm_message_sv.get_msg_text(
622: x_message_name => x_terms_rec.msg_name,
623: x_text => x_return_message,
624: x_token1 => 'SHIPFROM',
625: x_value1 => rlm_core_sv.get_ship_from(x_Ship_from_org_id),
626: x_token2 => 'CUSTOMER',
627: x_value2 => rlm_core_sv.get_customer_name(x_Customer_id));
628: --
629: x_terms_definition_level := NULL;

Line 627: x_value2 => rlm_core_sv.get_customer_name(x_Customer_id));

623: x_text => x_return_message,
624: x_token1 => 'SHIPFROM',
625: x_value1 => rlm_core_sv.get_ship_from(x_Ship_from_org_id),
626: x_token2 => 'CUSTOMER',
627: x_value2 => rlm_core_sv.get_customer_name(x_Customer_id));
628: --
629: x_terms_definition_level := NULL;
630: --
631: x_return_status := FALSE;

Line 634: rlm_core_sv.dlog(C_DEBUG, 'No data found');

630: --
631: x_return_status := FALSE;
632: --
633: IF (l_debug <> -1) THEN
634: rlm_core_sv.dlog(C_DEBUG, 'No data found');
635: rlm_core_sv.dpop(C_SDEBUG, 'No data found');
636: END IF;
637: --
638: WHEN OTHERS THEN

Line 635: rlm_core_sv.dpop(C_SDEBUG, 'No data found');

631: x_return_status := FALSE;
632: --
633: IF (l_debug <> -1) THEN
634: rlm_core_sv.dlog(C_DEBUG, 'No data found');
635: rlm_core_sv.dpop(C_SDEBUG, 'No data found');
636: END IF;
637: --
638: WHEN OTHERS THEN
639: --

Line 643: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);

639: --
640: x_return_status := FALSE;
641: --
642: IF (l_debug <> -1) THEN
643: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);
644: rlm_core_sv.dpop(C_SDEBUG);
645: END IF;
646: --
647: raise;

Line 644: rlm_core_sv.dpop(C_SDEBUG);

640: x_return_status := FALSE;
641: --
642: IF (l_debug <> -1) THEN
643: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);
644: rlm_core_sv.dpop(C_SDEBUG);
645: END IF;
646: --
647: raise;
648: --

Line 690: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_add');

686: --
687: BEGIN
688: --
689: IF (l_debug <> -1) THEN
690: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_add');
691: END IF;
692:
693: v_ship_from_org_id := x_ship_from_org_id;
694:

Line 710: rlm_core_sv.dlog(C_DEBUG, 'v_ship_from_org_id', v_ship_from_org_id);

706: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
707:
708: -- Proceed
709: IF (l_debug <> -1) THEN
710: rlm_core_sv.dlog(C_DEBUG, 'v_ship_from_org_id', v_ship_from_org_id);
711: END IF;
712:
713: EXCEPTION
714: WHEN TOO_MANY_ROWS THEN

Line 727: rlm_core_sv.dlog(C_DEBUG, 'Default v_ship_from_org_id', v_ship_from_org_id);

723: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
724:
725: -- Proceed
726: IF (l_debug <> -1) THEN
727: rlm_core_sv.dlog(C_DEBUG, 'Default v_ship_from_org_id', v_ship_from_org_id);
728: END IF;
729:
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN

Line 980: rlm_core_sv.dlog(C_DEBUG, 'Cust. Level Match Within', v_match_within_key);

976: FETCH c_optional_match_cust INTO v_match_within_key, v_match_across_key;
977: CLOSE c_optional_match_cust;
978: --
979: IF (l_debug <> -1) THEN
980: rlm_core_sv.dlog(C_DEBUG, 'Cust. Level Match Within', v_match_within_key);
981: rlm_core_sv.dlog(C_DEBUG, 'Cust. Level Match Across', v_match_across_key);
982: END IF;
983: --
984: IF (x_terms_rec.match_within_key IS NULL) THEN

Line 981: rlm_core_sv.dlog(C_DEBUG, 'Cust. Level Match Across', v_match_across_key);

977: CLOSE c_optional_match_cust;
978: --
979: IF (l_debug <> -1) THEN
980: rlm_core_sv.dlog(C_DEBUG, 'Cust. Level Match Within', v_match_within_key);
981: rlm_core_sv.dlog(C_DEBUG, 'Cust. Level Match Across', v_match_across_key);
982: END IF;
983: --
984: IF (x_terms_rec.match_within_key IS NULL) THEN
985: IF v_match_within_key IS NOT NULL THEN

Line 989: x_terms_rec.match_within_key := RLM_CORE_SV.get_default_key;

985: IF v_match_within_key IS NOT NULL THEN
986: x_terms_rec.match_within_key := v_match_within_key;
987: ELSE
988: /* By default, match_within_key is ABCDEFG */
989: x_terms_rec.match_within_key := RLM_CORE_SV.get_default_key;
990: END IF;
991: END IF;
992: --
993: IF (x_terms_rec.match_across_key IS NULL) THEN

Line 998: x_terms_rec.match_across_key := RLM_CORE_SV.get_default_key;

994: IF v_match_across_key IS NOT NULL THEN
995: x_terms_rec.match_across_key := v_match_across_key;
996: ELSE
997: /* By default, match_across_key is ABCDEFG */
998: x_terms_rec.match_across_key := RLM_CORE_SV.get_default_key;
999: END IF;
1000: END IF;
1001: --}
1002: END IF;

Line 1009: rlm_core_sv.dpop(C_SDEBUG);

1005: x_terms_definition_level := 'ADDRESS';
1006: x_return_status := TRUE;
1007: --
1008: IF (l_debug <> -1) THEN
1009: rlm_core_sv.dpop(C_SDEBUG);
1010: END IF;
1011:
1012: EXCEPTION
1013:

Line 1024: rlm_core_sv.dlog(C_DEBUG, 'There are more than one record of RLM Setup Terms at the ADDRESS level');

1020: x_terms_definition_level := NULL;
1021: x_return_status := FALSE;
1022: --
1023: IF (l_debug <> -1) THEN
1024: rlm_core_sv.dlog(C_DEBUG, 'There are more than one record of RLM Setup Terms at the ADDRESS level');
1025: rlm_core_sv.dpop(C_SDEBUG);
1026: END IF;
1027: --
1028: WHEN e_no_default THEN

Line 1025: rlm_core_sv.dpop(C_SDEBUG);

1021: x_return_status := FALSE;
1022: --
1023: IF (l_debug <> -1) THEN
1024: rlm_core_sv.dlog(C_DEBUG, 'There are more than one record of RLM Setup Terms at the ADDRESS level');
1025: rlm_core_sv.dpop(C_SDEBUG);
1026: END IF;
1027: --
1028: WHEN e_no_default THEN
1029: --

Line 1035: x_value1 => RLM_CORE_SV.get_customer_name(x_customer_id),

1031: rlm_message_sv.get_msg_text(
1032: x_message_name => x_terms_rec.msg_name,
1033: x_text => x_return_message,
1034: x_token1 => 'CUST',
1035: x_value1 => RLM_CORE_SV.get_customer_name(x_customer_id),
1036: x_token2 => 'ST',
1037: x_value2 => RLM_CORE_SV.get_ship_to(x_ship_to_address_id));
1038: --
1039: --x_terms_definition_level := NULL;

Line 1037: x_value2 => RLM_CORE_SV.get_ship_to(x_ship_to_address_id));

1033: x_text => x_return_message,
1034: x_token1 => 'CUST',
1035: x_value1 => RLM_CORE_SV.get_customer_name(x_customer_id),
1036: x_token2 => 'ST',
1037: x_value2 => RLM_CORE_SV.get_ship_to(x_ship_to_address_id));
1038: --
1039: --x_terms_definition_level := NULL;
1040: --x_return_status := FALSE;
1041: --

Line 1054: rlm_core_sv.dpop(C_SDEBUG);

1050: x_return_message,
1051: x_return_status);
1052: --
1053: IF (l_debug <> -1) THEN
1054: rlm_core_sv.dpop(C_SDEBUG);
1055: END IF;
1056: --
1057: WHEN e_inactive_record THEN
1058: --

Line 1069: rlm_core_sv.dlog(C_DEBUG, 'The RLM Setup Terms record at the ADDRESS level has been inactivated');

1065: x_return_message,
1066: x_return_status);
1067: --
1068: IF (l_debug <> -1) THEN
1069: rlm_core_sv.dlog(C_DEBUG, 'The RLM Setup Terms record at the ADDRESS level has been inactivated');
1070: rlm_core_sv.dpop(C_SDEBUG);
1071: END IF;
1072: --
1073: WHEN NO_DATA_FOUND THEN

Line 1070: rlm_core_sv.dpop(C_SDEBUG);

1066: x_return_status);
1067: --
1068: IF (l_debug <> -1) THEN
1069: rlm_core_sv.dlog(C_DEBUG, 'The RLM Setup Terms record at the ADDRESS level has been inactivated');
1070: rlm_core_sv.dpop(C_SDEBUG);
1071: END IF;
1072: --
1073: WHEN NO_DATA_FOUND THEN
1074: --

Line 1085: rlm_core_sv.dlog(C_DEBUG, 'No data found at ADDRESS level');

1081: x_return_message,
1082: x_return_status);
1083: --
1084: IF (l_debug <> -1) THEN
1085: rlm_core_sv.dlog(C_DEBUG, 'No data found at ADDRESS level');
1086: rlm_core_sv.dpop(C_SDEBUG);
1087: END IF;
1088: --
1089: WHEN OTHERS THEN

Line 1086: rlm_core_sv.dpop(C_SDEBUG);

1082: x_return_status);
1083: --
1084: IF (l_debug <> -1) THEN
1085: rlm_core_sv.dlog(C_DEBUG, 'No data found at ADDRESS level');
1086: rlm_core_sv.dpop(C_SDEBUG);
1087: END IF;
1088: --
1089: WHEN OTHERS THEN
1090: --

Line 1095: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);

1091: x_terms_definition_level := NULL;
1092: x_return_status := FALSE;
1093: --
1094: IF (l_debug <> -1) THEN
1095: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);
1096: rlm_core_sv.dpop(C_SDEBUG);
1097: END IF;
1098: --
1099: RAISE;

Line 1096: rlm_core_sv.dpop(C_SDEBUG);

1092: x_return_status := FALSE;
1093: --
1094: IF (l_debug <> -1) THEN
1095: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);
1096: rlm_core_sv.dpop(C_SDEBUG);
1097: END IF;
1098: --
1099: RAISE;
1100:

Line 1143: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_item');

1139: --
1140: BEGIN
1141: --
1142: IF (l_debug <> -1) THEN
1143: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_item');
1144: --global_atp
1145: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );
1146: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );
1147: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );

Line 1145: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );

1141: --
1142: IF (l_debug <> -1) THEN
1143: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_item');
1144: --global_atp
1145: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );
1146: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );
1147: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );
1148: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id );
1149: rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');

Line 1146: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );

1142: IF (l_debug <> -1) THEN
1143: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_item');
1144: --global_atp
1145: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );
1146: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );
1147: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );
1148: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id );
1149: rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');
1150: END IF;

Line 1147: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );

1143: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_item');
1144: --global_atp
1145: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );
1146: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );
1147: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );
1148: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id );
1149: rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');
1150: END IF;
1151:

Line 1148: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id );

1144: --global_atp
1145: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );
1146: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );
1147: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );
1148: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id );
1149: rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');
1150: END IF;
1151:
1152: v_ship_from_org_id := x_ship_from_org_id;

Line 1149: rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');

1145: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );
1146: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );
1147: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );
1148: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id );
1149: rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');
1150: END IF;
1151:
1152: v_ship_from_org_id := x_ship_from_org_id;
1153:

Line 1170: rlm_core_sv.dlog(C_DEBUG, 'v_ship_from_org_id', v_ship_from_org_id );

1166: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
1167:
1168: -- Proceed
1169: IF (l_debug <> -1) THEN
1170: rlm_core_sv.dlog(C_DEBUG, 'v_ship_from_org_id', v_ship_from_org_id );
1171: END IF;
1172:
1173: EXCEPTION
1174: WHEN TOO_MANY_ROWS THEN

Line 1188: rlm_core_sv.dlog(C_DEBUG, 'Default v_ship_from_org_id', v_ship_from_org_id );

1184: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
1185:
1186: -- Proceed
1187: IF (l_debug <> -1) THEN
1188: rlm_core_sv.dlog(C_DEBUG, 'Default v_ship_from_org_id', v_ship_from_org_id );
1189: END IF;
1190:
1191: EXCEPTION
1192: WHEN NO_DATA_FOUND THEN

Line 1404: NVL(match_within_key, rlm_core_sv.get_default_key),

1400: -- Select exceptional terms
1401: --
1402: SELECT cum_control_code,
1403: critical_attribute_key,
1404: NVL(match_within_key, rlm_core_sv.get_default_key),
1405: NVL(match_across_key, rlm_core_sv.get_default_key),
1406: schedule_hierarchy_code,
1407: unshipped_firm_disp_cd,
1408: unship_firm_cutoff_days,

Line 1405: NVL(match_across_key, rlm_core_sv.get_default_key),

1401: --
1402: SELECT cum_control_code,
1403: critical_attribute_key,
1404: NVL(match_within_key, rlm_core_sv.get_default_key),
1405: NVL(match_across_key, rlm_core_sv.get_default_key),
1406: schedule_hierarchy_code,
1407: unshipped_firm_disp_cd,
1408: unship_firm_cutoff_days,
1409: cum_shipment_rule_code,

Line 1438: rlm_core_sv.dlog(C_DEBUG, 'Picked up exceptional terms at address level');

1434: AND CUSTOMER_ID = x_customer_id
1435: AND ADDRESS_ID = x_ship_to_address_id;
1436: --
1437: IF (l_debug <> -1) THEN
1438: rlm_core_sv.dlog(C_DEBUG, 'Picked up exceptional terms at address level');
1439: rlm_core_sv.dlog(C_DEBUG, 'After Item Level Select ');
1440: END IF;
1441: --
1442: /* By default, inactive_date is NULL */

Line 1439: rlm_core_sv.dlog(C_DEBUG, 'After Item Level Select ');

1435: AND ADDRESS_ID = x_ship_to_address_id;
1436: --
1437: IF (l_debug <> -1) THEN
1438: rlm_core_sv.dlog(C_DEBUG, 'Picked up exceptional terms at address level');
1439: rlm_core_sv.dlog(C_DEBUG, 'After Item Level Select ');
1440: END IF;
1441: --
1442: /* By default, inactive_date is NULL */
1443: IF x_terms_rec.inactive_date is NOT NULL THEN

Line 1459: rlm_core_sv.dlog(C_DEBUG, 'Cust. Level Match Within', v_match_within_key);

1455: FETCH c_optional_match_cust INTO v_match_within_key, v_match_across_key;
1456: CLOSE c_optional_match_cust;
1457: --
1458: IF (l_debug <> -1) THEN
1459: rlm_core_sv.dlog(C_DEBUG, 'Cust. Level Match Within', v_match_within_key);
1460: rlm_core_sv.dlog(C_DEBUG, 'Cust. Level Match Across', v_match_across_key);
1461: END IF;
1462: --
1463: IF (x_terms_rec.match_within_key IS NULL) THEN

Line 1460: rlm_core_sv.dlog(C_DEBUG, 'Cust. Level Match Across', v_match_across_key);

1456: CLOSE c_optional_match_cust;
1457: --
1458: IF (l_debug <> -1) THEN
1459: rlm_core_sv.dlog(C_DEBUG, 'Cust. Level Match Within', v_match_within_key);
1460: rlm_core_sv.dlog(C_DEBUG, 'Cust. Level Match Across', v_match_across_key);
1461: END IF;
1462: --
1463: IF (x_terms_rec.match_within_key IS NULL) THEN
1464: --

Line 1468: x_terms_rec.match_within_key := RLM_CORE_SV.get_default_key;

1464: --
1465: IF v_match_within_key IS NOT NULL THEN
1466: x_terms_rec.match_within_key := v_match_within_key;
1467: ELSE
1468: x_terms_rec.match_within_key := RLM_CORE_SV.get_default_key;
1469: END IF;
1470: --
1471: END IF;
1472: --

Line 1478: x_terms_rec.match_across_key := RLM_CORE_SV.get_default_key;

1474: --
1475: IF v_match_across_key IS NOT NULL THEN
1476: x_terms_rec.match_across_key := v_match_across_key;
1477: ELSE
1478: x_terms_rec.match_across_key := RLM_CORE_SV.get_default_key;
1479: END IF;
1480: --
1481: END IF;
1482: --}

Line 1489: rlm_core_sv.dpop(C_SDEBUG);

1485: x_terms_definition_level := 'ADDRESS_ITEM';
1486: x_return_status := TRUE;
1487: --
1488: IF (l_debug <> -1) THEN
1489: rlm_core_sv.dpop(C_SDEBUG);
1490: END IF;
1491: --
1492: EXCEPTION
1493: --

Line 1506: rlm_core_sv.dlog(C_DEBUG, 'Too Many Rows ');

1502: --
1503: x_return_status := FALSE;
1504: --
1505: IF (l_debug <> -1) THEN
1506: rlm_core_sv.dlog(C_DEBUG, 'Too Many Rows ');
1507: rlm_core_sv.dpop(C_SDEBUG, 'There are more than one record of RLM Setup Terms at the CUSTOMER_ITEM level');
1508: END IF;
1509:
1510:

Line 1507: rlm_core_sv.dpop(C_SDEBUG, 'There are more than one record of RLM Setup Terms at the CUSTOMER_ITEM level');

1503: x_return_status := FALSE;
1504: --
1505: IF (l_debug <> -1) THEN
1506: rlm_core_sv.dlog(C_DEBUG, 'Too Many Rows ');
1507: rlm_core_sv.dpop(C_SDEBUG, 'There are more than one record of RLM Setup Terms at the CUSTOMER_ITEM level');
1508: END IF;
1509:
1510:
1511: WHEN e_no_default THEN

Line 1518: x_value1 => RLM_CORE_SV.get_customer_name(x_customer_id),

1514: rlm_message_sv.get_msg_text(
1515: x_message_name => x_terms_rec.msg_name,
1516: x_text => x_return_message,
1517: x_token1 => 'CUST',
1518: x_value1 => RLM_CORE_SV.get_customer_name(x_customer_id),
1519: x_token2 => 'ST',
1520: x_value2 => RLM_CORE_SV.get_ship_to(x_ship_to_address_id),
1521: x_token3 => 'CI',
1522: x_value3 => RLM_CORE_SV.get_item_number(x_customer_item_id));

Line 1520: x_value2 => RLM_CORE_SV.get_ship_to(x_ship_to_address_id),

1516: x_text => x_return_message,
1517: x_token1 => 'CUST',
1518: x_value1 => RLM_CORE_SV.get_customer_name(x_customer_id),
1519: x_token2 => 'ST',
1520: x_value2 => RLM_CORE_SV.get_ship_to(x_ship_to_address_id),
1521: x_token3 => 'CI',
1522: x_value3 => RLM_CORE_SV.get_item_number(x_customer_item_id));
1523: --
1524: --x_terms_definition_level := NULL;

Line 1522: x_value3 => RLM_CORE_SV.get_item_number(x_customer_item_id));

1518: x_value1 => RLM_CORE_SV.get_customer_name(x_customer_id),
1519: x_token2 => 'ST',
1520: x_value2 => RLM_CORE_SV.get_ship_to(x_ship_to_address_id),
1521: x_token3 => 'CI',
1522: x_value3 => RLM_CORE_SV.get_item_number(x_customer_item_id));
1523: --
1524: --x_terms_definition_level := NULL;
1525: --x_return_status := FALSE;
1526: --

Line 1539: rlm_core_sv.dpop(C_SDEBUG);

1535: x_return_message,
1536: x_return_status);
1537: --
1538: IF (l_debug <> -1) THEN
1539: rlm_core_sv.dpop(C_SDEBUG);
1540: END IF;
1541: --
1542: WHEN e_inactive_record THEN
1543: --

Line 1545: rlm_core_sv.dlog(C_DEBUG, 'Inactive Record ');

1541: --
1542: WHEN e_inactive_record THEN
1543: --
1544: IF (l_debug <> -1) THEN
1545: rlm_core_sv.dlog(C_DEBUG, 'Inactive Record ');
1546: rlm_core_sv.dlog(C_DEBUG, 'Populating Rec Addres ');
1547: END IF;
1548: --
1549: RLM_TPA_SV.populate_record_add(x_ship_from_org_id,

Line 1546: rlm_core_sv.dlog(C_DEBUG, 'Populating Rec Addres ');

1542: WHEN e_inactive_record THEN
1543: --
1544: IF (l_debug <> -1) THEN
1545: rlm_core_sv.dlog(C_DEBUG, 'Inactive Record ');
1546: rlm_core_sv.dlog(C_DEBUG, 'Populating Rec Addres ');
1547: END IF;
1548: --
1549: RLM_TPA_SV.populate_record_add(x_ship_from_org_id,
1550: x_customer_id,

Line 1559: rlm_core_sv.dpop(C_SDEBUG, 'The RLM Setup Terms record at the CUSTOMER_ITEM level has been inactivated');

1555: x_return_message,
1556: x_return_status);
1557: --
1558: IF (l_debug <> -1) THEN
1559: rlm_core_sv.dpop(C_SDEBUG, 'The RLM Setup Terms record at the CUSTOMER_ITEM level has been inactivated');
1560: END IF;
1561: --
1562: WHEN NO_DATA_FOUND THEN
1563: --

Line 1565: rlm_core_sv.dlog(C_DEBUG, 'No data found');

1561: --
1562: WHEN NO_DATA_FOUND THEN
1563: --
1564: IF (l_debug <> -1) THEN
1565: rlm_core_sv.dlog(C_DEBUG, 'No data found');
1566: END IF;
1567: --
1568: RLM_TPA_SV.populate_record_add(x_ship_from_org_id,
1569: x_customer_id,

Line 1578: rlm_core_sv.dpop(C_SDEBUG, 'No data found');

1574: x_return_message,
1575: x_return_status);
1576: --
1577: IF (l_debug <> -1) THEN
1578: rlm_core_sv.dpop(C_SDEBUG, 'No data found');
1579: END IF;
1580: --
1581: WHEN OTHERS THEN
1582: --

Line 1587: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);

1583: x_terms_definition_level := NULL;
1584: x_return_status := FALSE;
1585: --
1586: IF (l_debug <> -1) THEN
1587: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);
1588: rlm_core_sv.dpop(C_SDEBUG);
1589: END IF;
1590: --
1591: RAISE;

Line 1588: rlm_core_sv.dpop(C_SDEBUG);

1584: x_return_status := FALSE;
1585: --
1586: IF (l_debug <> -1) THEN
1587: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);
1588: rlm_core_sv.dpop(C_SDEBUG);
1589: END IF;
1590: --
1591: RAISE;
1592:

Line 1622: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_cust_item');

1618: --
1619: BEGIN
1620: --
1621: IF (l_debug <> -1) THEN
1622: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_cust_item');
1623: --global_atp
1624: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );
1625: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );
1626: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );

Line 1624: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );

1620: --
1621: IF (l_debug <> -1) THEN
1622: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_cust_item');
1623: --global_atp
1624: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );
1625: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );
1626: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );
1627: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id );
1628: rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');

Line 1625: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );

1621: IF (l_debug <> -1) THEN
1622: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_cust_item');
1623: --global_atp
1624: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );
1625: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );
1626: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );
1627: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id );
1628: rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');
1629: END IF;

Line 1626: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );

1622: rlm_core_sv.dpush(C_SDEBUG, 'populate_record_cust_item');
1623: --global_atp
1624: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );
1625: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );
1626: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );
1627: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id );
1628: rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');
1629: END IF;
1630: --

Line 1627: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id );

1623: --global_atp
1624: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );
1625: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );
1626: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );
1627: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id );
1628: rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');
1629: END IF;
1630: --
1631: v_ship_from_org_id := x_ship_from_org_id;

Line 1628: rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');

1624: rlm_core_sv.dlog(C_DEBUG, 'x_ship_from_org_id', x_ship_from_org_id );
1625: rlm_core_sv.dlog(C_DEBUG, 'x_customer_id', x_customer_id );
1626: rlm_core_sv.dlog(C_DEBUG, 'x_ship_to_address_id', x_ship_to_address_id );
1627: rlm_core_sv.dlog(C_DEBUG, 'x_customer_item_id', x_customer_item_id );
1628: rlm_core_sv.dlog(C_DEBUG, 'Before Item Level Select ');
1629: END IF;
1630: --
1631: v_ship_from_org_id := x_ship_from_org_id;
1632:

Line 1649: rlm_core_sv.dlog(C_DEBUG, 'v_ship_from_org_id', v_ship_from_org_id );

1645: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
1646:
1647: -- Proceed
1648: IF (l_debug <> -1) THEN
1649: rlm_core_sv.dlog(C_DEBUG, 'v_ship_from_org_id', v_ship_from_org_id );
1650: END IF;
1651:
1652: EXCEPTION
1653: WHEN TOO_MANY_ROWS THEN

Line 1667: rlm_core_sv.dlog(C_DEBUG, 'Default v_ship_from_org_id', v_ship_from_org_id );

1663: AND (inactive_date IS NULL OR inactive_date > nvl(rlm_dp_sv.g_dsp_start_time,SYSDATE)); --Bugfix 10053830
1664:
1665: -- Proceed
1666: IF (l_debug <> -1) THEN
1667: rlm_core_sv.dlog(C_DEBUG, 'Default v_ship_from_org_id', v_ship_from_org_id );
1668: END IF;
1669:
1670: EXCEPTION
1671: WHEN NO_DATA_FOUND THEN

Line 1883: NVL(match_within_key, rlm_core_sv.get_default_key),

1879: -- Select exceptional terms
1880: --
1881: SELECT cum_control_code,
1882: critical_attribute_key,
1883: NVL(match_within_key, rlm_core_sv.get_default_key),
1884: NVL(match_across_key, rlm_core_sv.get_default_key),
1885: schedule_hierarchy_code,
1886: unshipped_firm_disp_cd,
1887: unship_firm_cutoff_days,

Line 1884: NVL(match_across_key, rlm_core_sv.get_default_key),

1880: --
1881: SELECT cum_control_code,
1882: critical_attribute_key,
1883: NVL(match_within_key, rlm_core_sv.get_default_key),
1884: NVL(match_across_key, rlm_core_sv.get_default_key),
1885: schedule_hierarchy_code,
1886: unshipped_firm_disp_cd,
1887: unship_firm_cutoff_days,
1888: cum_shipment_rule_code,

Line 1918: rlm_core_sv.dlog(C_DEBUG, 'Picked up exceptional terms at Customer level');

1914: AND CUSTOMER_ID = x_customer_id
1915: AND ADDRESS_ID IS NULL;
1916: --
1917: IF (l_debug <> -1) THEN
1918: rlm_core_sv.dlog(C_DEBUG, 'Picked up exceptional terms at Customer level');
1919: rlm_core_sv.dlog(C_DEBUG, 'After Item Level Select ');
1920: END IF;
1921: --
1922: /* By default, inactive_date is NULL */

Line 1919: rlm_core_sv.dlog(C_DEBUG, 'After Item Level Select ');

1915: AND ADDRESS_ID IS NULL;
1916: --
1917: IF (l_debug <> -1) THEN
1918: rlm_core_sv.dlog(C_DEBUG, 'Picked up exceptional terms at Customer level');
1919: rlm_core_sv.dlog(C_DEBUG, 'After Item Level Select ');
1920: END IF;
1921: --
1922: /* By default, inactive_date is NULL */
1923: IF x_terms_rec.inactive_date is NOT NULL THEN

Line 1930: x_terms_rec.match_within_key := rlm_core_sv.get_default_key;

1926: END IF;
1927: END IF;
1928: --
1929: IF x_terms_rec.match_within_key is NULL THEN
1930: x_terms_rec.match_within_key := rlm_core_sv.get_default_key;
1931: END IF;
1932: --
1933: IF x_terms_rec.match_across_key is NULL THEN
1934: x_terms_rec.match_across_key := rlm_core_sv.get_default_key;

Line 1934: x_terms_rec.match_across_key := rlm_core_sv.get_default_key;

1930: x_terms_rec.match_within_key := rlm_core_sv.get_default_key;
1931: END IF;
1932: --
1933: IF x_terms_rec.match_across_key is NULL THEN
1934: x_terms_rec.match_across_key := rlm_core_sv.get_default_key;
1935: END IF;
1936: --
1937: x_terms_definition_level := 'CUSTOMER_ITEM';
1938: x_return_status := TRUE;

Line 1941: rlm_core_sv.dpop(C_SDEBUG);

1937: x_terms_definition_level := 'CUSTOMER_ITEM';
1938: x_return_status := TRUE;
1939: --
1940: IF (l_debug <> -1) THEN
1941: rlm_core_sv.dpop(C_SDEBUG);
1942: END IF;
1943: --
1944: EXCEPTION
1945: --

Line 1949: rlm_core_sv.dlog(C_DEBUG, 'Too Many Rows ');

1945: --
1946: WHEN TOO_MANY_ROWS THEN
1947: --
1948: IF (l_debug <> -1) THEN
1949: rlm_core_sv.dlog(C_DEBUG, 'Too Many Rows ');
1950: END IF;
1951: --
1952: x_terms_rec.msg_name := 'RLM_SETUP_ITEM_MULTIPLE_ROWS';
1953: rlm_message_sv.get_msg_text(

Line 1962: rlm_core_sv.dpop(C_SDEBUG, 'There are more than one record of RLM Setup Terms at the CUSTOMER_ITEM level');

1958: --
1959: x_return_status := FALSE;
1960: --
1961: IF (l_debug <> -1) THEN
1962: rlm_core_sv.dpop(C_SDEBUG, 'There are more than one record of RLM Setup Terms at the CUSTOMER_ITEM level');
1963: END IF;
1964: --
1965:
1966: WHEN e_no_default THEN

Line 1969: rlm_core_sv.dlog(C_DEBUG, 'No Default');

1965:
1966: WHEN e_no_default THEN
1967: --
1968: IF (l_debug <> -1) THEN
1969: rlm_core_sv.dlog(C_DEBUG, 'No Default');
1970: END IF;
1971: --
1972: x_terms_rec.msg_name := 'RLM_SETUP_CITEM_NO_DEFAULT';
1973: rlm_message_sv.get_msg_text(

Line 1977: x_value1 => RLM_CORE_SV.get_customer_name(x_customer_id),

1973: rlm_message_sv.get_msg_text(
1974: x_message_name => x_terms_rec.msg_name,
1975: x_text => x_return_message,
1976: x_token1 => 'CUST',
1977: x_value1 => RLM_CORE_SV.get_customer_name(x_customer_id),
1978: x_token2 => 'CI',
1979: x_value2 => RLM_CORE_SV.get_item_number(x_customer_item_id));
1980: --
1981: --x_terms_definition_level := NULL;

Line 1979: x_value2 => RLM_CORE_SV.get_item_number(x_customer_item_id));

1975: x_text => x_return_message,
1976: x_token1 => 'CUST',
1977: x_value1 => RLM_CORE_SV.get_customer_name(x_customer_id),
1978: x_token2 => 'CI',
1979: x_value2 => RLM_CORE_SV.get_item_number(x_customer_item_id));
1980: --
1981: --x_terms_definition_level := NULL;
1982: --x_return_status := FALSE;
1983: --

Line 1994: rlm_core_sv.dpop(C_SDEBUG);

1990: x_return_message,
1991: x_return_status);
1992: --
1993: IF (l_debug <> -1) THEN
1994: rlm_core_sv.dpop(C_SDEBUG);
1995: END IF;
1996:
1997:
1998: WHEN e_inactive_record THEN

Line 2001: rlm_core_sv.dlog(C_DEBUG, 'Inactive Record ');

1997:
1998: WHEN e_inactive_record THEN
1999: --
2000: IF (l_debug <> -1) THEN
2001: rlm_core_sv.dlog(C_DEBUG, 'Inactive Record ');
2002: rlm_core_sv.dlog(C_DEBUG, 'Populating Rec Customer ');
2003: END IF;
2004: --
2005: RLM_TPA_SV.populate_record_cust(x_ship_from_org_id,

Line 2002: rlm_core_sv.dlog(C_DEBUG, 'Populating Rec Customer ');

1998: WHEN e_inactive_record THEN
1999: --
2000: IF (l_debug <> -1) THEN
2001: rlm_core_sv.dlog(C_DEBUG, 'Inactive Record ');
2002: rlm_core_sv.dlog(C_DEBUG, 'Populating Rec Customer ');
2003: END IF;
2004: --
2005: RLM_TPA_SV.populate_record_cust(x_ship_from_org_id,
2006: x_customer_id,

Line 2013: rlm_core_sv.dpop(C_SDEBUG, 'The RLM Setup Terms record at the CUSTOMER_ITEM level has been inactivated');

2009: x_return_message,
2010: x_return_status);
2011: --
2012: IF (l_debug <> -1) THEN
2013: rlm_core_sv.dpop(C_SDEBUG, 'The RLM Setup Terms record at the CUSTOMER_ITEM level has been inactivated');
2014: END IF;
2015: --
2016: WHEN NO_DATA_FOUND THEN
2017: --

Line 2019: rlm_core_sv.dlog(C_DEBUG, 'No data found');

2015: --
2016: WHEN NO_DATA_FOUND THEN
2017: --
2018: IF (l_debug <> -1) THEN
2019: rlm_core_sv.dlog(C_DEBUG, 'No data found');
2020: END IF;
2021: --
2022: RLM_TPA_SV.populate_record_cust(x_ship_from_org_id,
2023: x_customer_id,

Line 2030: rlm_core_sv.dpop(C_SDEBUG, 'No data found');

2026: x_return_message,
2027: x_return_status);
2028: --
2029: IF (l_debug <> -1) THEN
2030: rlm_core_sv.dpop(C_SDEBUG, 'No data found');
2031: END IF;
2032: --
2033: WHEN OTHERS THEN
2034: --

Line 2039: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);

2035: x_terms_definition_level := NULL;
2036: x_return_status := FALSE;
2037: --
2038: IF (l_debug <> -1) THEN
2039: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);
2040: rlm_core_sv.dpop(C_SDEBUG);
2041: END IF;
2042: --
2043: RAISE;

Line 2040: rlm_core_sv.dpop(C_SDEBUG);

2036: x_return_status := FALSE;
2037: --
2038: IF (l_debug <> -1) THEN
2039: rlm_core_sv.dlog(C_DEBUG, 'SQL Error', SQLERRM);
2040: rlm_core_sv.dpop(C_SDEBUG);
2041: END IF;
2042: --
2043: RAISE;
2044:

Line 2077: rlm_core_sv.dpush(C_DEBUG, 'GetTPContext');

2073:
2074: BEGIN
2075: --
2076: IF (l_debug <> -1) THEN
2077: rlm_core_sv.dpush(C_DEBUG, 'GetTPContext');
2078: END IF;
2079:
2080: IF x_customer_id IS NOT NULL THEN
2081:

Line 2106: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);

2102:
2103: END IF;
2104:
2105: IF (l_debug <> -1) THEN
2106: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2107: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2108: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2109: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2110: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);

Line 2107: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);

2103: END IF;
2104:
2105: IF (l_debug <> -1) THEN
2106: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2107: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2108: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2109: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2110: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2111: rlm_core_sv.dpop(C_DEBUG, 'Successful');

Line 2108: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);

2104:
2105: IF (l_debug <> -1) THEN
2106: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2107: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2108: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2109: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2110: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2111: rlm_core_sv.dpop(C_DEBUG, 'Successful');
2112: END IF;

Line 2109: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);

2105: IF (l_debug <> -1) THEN
2106: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2107: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2108: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2109: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2110: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2111: rlm_core_sv.dpop(C_DEBUG, 'Successful');
2112: END IF;
2113:

Line 2110: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);

2106: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2107: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2108: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2109: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2110: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2111: rlm_core_sv.dpop(C_DEBUG, 'Successful');
2112: END IF;
2113:
2114: EXCEPTION

Line 2111: rlm_core_sv.dpop(C_DEBUG, 'Successful');

2107: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2108: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2109: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2110: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2111: rlm_core_sv.dpop(C_DEBUG, 'Successful');
2112: END IF;
2113:
2114: EXCEPTION
2115: WHEN NO_DATA_FOUND THEN

Line 2124: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);

2120: x_inter_ship_to_ece_locn_code:=null;
2121: x_tp_group_code:=null;
2122: --
2123: IF (l_debug <> -1) THEN
2124: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2125: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2126: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2127: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2128: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);

Line 2125: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);

2121: x_tp_group_code:=null;
2122: --
2123: IF (l_debug <> -1) THEN
2124: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2125: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2126: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2127: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2128: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2129: rlm_core_sv.dpop(C_DEBUG);

Line 2126: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);

2122: --
2123: IF (l_debug <> -1) THEN
2124: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2125: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2126: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2127: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2128: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2129: rlm_core_sv.dpop(C_DEBUG);
2130: END IF;

Line 2127: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);

2123: IF (l_debug <> -1) THEN
2124: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2125: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2126: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2127: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2128: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2129: rlm_core_sv.dpop(C_DEBUG);
2130: END IF;
2131: --

Line 2128: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);

2124: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2125: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2126: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2127: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2128: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2129: rlm_core_sv.dpop(C_DEBUG);
2130: END IF;
2131: --
2132: WHEN OTHERS THEN

Line 2129: rlm_core_sv.dpop(C_DEBUG);

2125: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2126: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2127: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2128: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2129: rlm_core_sv.dpop(C_DEBUG);
2130: END IF;
2131: --
2132: WHEN OTHERS THEN
2133: --

Line 2135: rlm_core_sv.dlog(C_SDEBUG, 'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

2131: --
2132: WHEN OTHERS THEN
2133: --
2134: IF (l_debug <> -1) THEN
2135: rlm_core_sv.dlog(C_SDEBUG, 'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2136: rlm_core_sv.dpop(C_DEBUG);
2137: END IF;
2138: --
2139: RAISE;

Line 2136: rlm_core_sv.dpop(C_DEBUG);

2132: WHEN OTHERS THEN
2133: --
2134: IF (l_debug <> -1) THEN
2135: rlm_core_sv.dlog(C_SDEBUG, 'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2136: rlm_core_sv.dpop(C_DEBUG);
2137: END IF;
2138: --
2139: RAISE;
2140: