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 > SYSDATE);
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 > SYSDATE);
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 > SYSDATE);
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 > SYSDATE);
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 > SYSDATE);
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 > SYSDATE);
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 1436: rlm_core_sv.dlog(C_DEBUG, 'Picked up exceptional terms at address level');

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

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

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

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

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

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

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

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

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

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

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

Line 1487: rlm_core_sv.dpop(C_SDEBUG);

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

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

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

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

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

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

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

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

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

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

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

Line 1537: rlm_core_sv.dpop(C_SDEBUG);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1586: rlm_core_sv.dpop(C_SDEBUG);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1922: END IF;
1923: END IF;
1924: --
1925: IF x_terms_rec.match_within_key is NULL THEN
1926: x_terms_rec.match_within_key := rlm_core_sv.get_default_key;
1927: END IF;
1928: --
1929: IF x_terms_rec.match_across_key is NULL THEN
1930: x_terms_rec.match_across_key := rlm_core_sv.get_default_key;

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

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

Line 1937: rlm_core_sv.dpop(C_SDEBUG);

1933: x_terms_definition_level := 'CUSTOMER_ITEM';
1934: x_return_status := TRUE;
1935: --
1936: IF (l_debug <> -1) THEN
1937: rlm_core_sv.dpop(C_SDEBUG);
1938: END IF;
1939: --
1940: EXCEPTION
1941: --

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

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

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

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

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

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

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

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

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

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

Line 1990: rlm_core_sv.dpop(C_SDEBUG);

1986: x_return_message,
1987: x_return_status);
1988: --
1989: IF (l_debug <> -1) THEN
1990: rlm_core_sv.dpop(C_SDEBUG);
1991: END IF;
1992:
1993:
1994: WHEN e_inactive_record THEN

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

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

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

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

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

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

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

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

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

2022: x_return_message,
2023: x_return_status);
2024: --
2025: IF (l_debug <> -1) THEN
2026: rlm_core_sv.dpop(C_SDEBUG, 'No data found');
2027: END IF;
2028: --
2029: WHEN OTHERS THEN
2030: --

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

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

Line 2036: rlm_core_sv.dpop(C_SDEBUG);

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

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

2069:
2070: BEGIN
2071: --
2072: IF (l_debug <> -1) THEN
2073: rlm_core_sv.dpush(C_DEBUG, 'GetTPContext');
2074: END IF;
2075:
2076: IF x_customer_id IS NOT NULL THEN
2077:

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

2098:
2099: END IF;
2100:
2101: IF (l_debug <> -1) THEN
2102: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2103: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2104: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2105: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2106: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);

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

2099: END IF;
2100:
2101: IF (l_debug <> -1) THEN
2102: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2103: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2104: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2105: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2106: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2107: rlm_core_sv.dpop(C_DEBUG, 'Successful');

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

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

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

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

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

2102: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2103: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2104: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2105: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2106: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2107: rlm_core_sv.dpop(C_DEBUG, 'Successful');
2108: END IF;
2109:
2110: EXCEPTION

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

2103: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2104: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2105: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2106: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2107: rlm_core_sv.dpop(C_DEBUG, 'Successful');
2108: END IF;
2109:
2110: EXCEPTION
2111: WHEN NO_DATA_FOUND THEN

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

2116: x_inter_ship_to_ece_locn_code:=null;
2117: x_tp_group_code:=null;
2118: --
2119: IF (l_debug <> -1) THEN
2120: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2121: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2122: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2123: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2124: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);

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

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

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

2118: --
2119: IF (l_debug <> -1) THEN
2120: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2121: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2122: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2123: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2124: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2125: rlm_core_sv.dpop(C_DEBUG);
2126: END IF;

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

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

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

2120: rlm_core_sv.dlog(C_DEBUG, 'customer_number', x_customer_number);
2121: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2122: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2123: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2124: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2125: rlm_core_sv.dpop(C_DEBUG);
2126: END IF;
2127: --
2128: WHEN OTHERS THEN

Line 2125: rlm_core_sv.dpop(C_DEBUG);

2121: rlm_core_sv.dlog(C_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2122: rlm_core_sv.dlog(C_DEBUG, 'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2123: rlm_core_sv.dlog(C_DEBUG, 'x_inter_ship_to_ece_locn_code', x_inter_ship_to_ece_locn_code);
2124: rlm_core_sv.dlog(C_DEBUG, 'x_tp_group_code',x_tp_group_code);
2125: rlm_core_sv.dpop(C_DEBUG);
2126: END IF;
2127: --
2128: WHEN OTHERS THEN
2129: --

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

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

Line 2132: rlm_core_sv.dpop(C_DEBUG);

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