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.CN_RATE_DIMENSIONS_PVT dependencies on FND_MESSAGE

Line 47: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

43: BEGIN
44: IF (p_name IS NULL) THEN
45: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
46: l_prompt := cn_api.get_lkup_meaning('DIMENSION_NAME', 'CN_PROMPTS');
47: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
48: fnd_message.set_token('OBJ_NAME', l_prompt);
49: fnd_msg_pub.ADD;
50: END IF;
51: RAISE fnd_api.g_exc_error;

Line 48: fnd_message.set_token('OBJ_NAME', l_prompt);

44: IF (p_name IS NULL) THEN
45: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
46: l_prompt := cn_api.get_lkup_meaning('DIMENSION_NAME', 'CN_PROMPTS');
47: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
48: fnd_message.set_token('OBJ_NAME', l_prompt);
49: fnd_msg_pub.ADD;
50: END IF;
51: RAISE fnd_api.g_exc_error;
52: END IF;

Line 60: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');

56: CLOSE name_exists;
57:
58: IF (l_dummy = 1) THEN
59: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
60: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
61: fnd_msg_pub.ADD;
62: END IF;
63: RAISE fnd_api.g_exc_error;
64: END IF;

Line 69: fnd_message.set_name('CN', 'CN_INVALID_DIM_UOM');

65:
66: -- validate dim_unit_code
67: IF (p_dim_unit_code NOT IN ('AMOUNT', 'PERCENT', 'STRING', 'EXPRESSION')) THEN
68: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
69: fnd_message.set_name('CN', 'CN_INVALID_DIM_UOM');
70: fnd_msg_pub.ADD;
71: END IF;
72: RAISE fnd_api.g_exc_error;
73: END IF;

Line 78: fnd_message.set_name('CN', 'CN_X_NUMBER_TIER');

74:
75: -- if p_tiers_tbl is not empty, then p_number_tier should be equal to the number of records in p_tiers_tbl
76: IF (p_tiers_tbl.COUNT > 0 AND p_number_tier <> p_tiers_tbl.count) THEN
77: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
78: fnd_message.set_name('CN', 'CN_X_NUMBER_TIER');
79: fnd_msg_pub.ADD;
80: END IF;
81: RAISE fnd_api.g_exc_error;
82: END IF;

Line 90: fnd_message.set_name('CN', 'CN_MIN_G_MAX');

86: FOR i IN p_tiers_tbl.first..p_tiers_tbl.last LOOP
87: -- if minimum_amount is greater than maximum_amount, then error
88: IF (p_tiers_tbl(i).minimum_amount >= p_tiers_tbl(i).maximum_amount) THEN
89: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
90: fnd_message.set_name('CN', 'CN_MIN_G_MAX');
91: fnd_msg_pub.ADD;
92: END IF;
93: RAISE fnd_api.g_exc_error;
94: END IF;

Line 99: fnd_message.set_name('CN', 'CN_MIN_NE_MAX');

95:
96: -- if minimum_amount is not equal to previous tier's maximum_amount, then error
97: IF (i > 1 AND p_tiers_tbl(i).minimum_amount <> p_tiers_tbl(i-1).maximum_amount) THEN
98: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
99: fnd_message.set_name('CN', 'CN_MIN_NE_MAX');
100: fnd_msg_pub.ADD;
101: END IF;
102: RAISE fnd_api.g_exc_error;
103: END IF;

Line 118: fnd_message.set_name('CN', 'CN_EXP_NOT_EXIST');

114: CLOSE exp_info;
115:
116: IF (l_dummy = 0) THEN
117: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
118: fnd_message.set_name('CN', 'CN_EXP_NOT_EXIST');
119: fnd_msg_pub.ADD;
120: END IF;
121: RAISE fnd_api.g_exc_error;
122: ELSIF (l_dummy = 2) THEN

Line 124: fnd_message.set_name('CN', 'CN_EXP_NOT_MATCH');

120: END IF;
121: RAISE fnd_api.g_exc_error;
122: ELSIF (l_dummy = 2) THEN
123: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
124: fnd_message.set_name('CN', 'CN_EXP_NOT_MATCH');
125: fnd_msg_pub.ADD;
126: END IF;
127: RAISE fnd_api.g_exc_error;
128: END IF;

Line 136: fnd_message.set_name('CN', 'CN_EXP_NOT_EXIST');

132: CLOSE exp_info;
133:
134: IF (l_dummy = 0) THEN
135: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
136: fnd_message.set_name('CN', 'CN_EXP_NOT_EXIST');
137: fnd_msg_pub.ADD;
138: END IF;
139: RAISE fnd_api.g_exc_error;
140: ELSIF (l_dummy = 2) THEN

Line 142: fnd_message.set_name('CN', 'CN_EXP_NOT_MATCH');

138: END IF;
139: RAISE fnd_api.g_exc_error;
140: ELSIF (l_dummy = 2) THEN
141: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
142: fnd_message.set_name('CN', 'CN_EXP_NOT_MATCH');
143: fnd_msg_pub.ADD;
144: END IF;
145: RAISE fnd_api.g_exc_error;
146: END IF;

Line 241: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_CREATE');

237: select name into l_dimension_name
238: from cn_rate_dimensions
239: where rate_dimension_id = x_rate_dimension_id;
240:
241: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_CREATE');
242: fnd_message.set_token('RT_DIM', l_dimension_name);
243: l_note_msg := fnd_message.get;
244:
245: jtf_notes_pub.create_note

Line 242: fnd_message.set_token('RT_DIM', l_dimension_name);

238: from cn_rate_dimensions
239: where rate_dimension_id = x_rate_dimension_id;
240:
241: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_CREATE');
242: fnd_message.set_token('RT_DIM', l_dimension_name);
243: l_note_msg := fnd_message.get;
244:
245: jtf_notes_pub.create_note
246: (p_api_version => 1.0,

Line 243: l_note_msg := fnd_message.get;

239: where rate_dimension_id = x_rate_dimension_id;
240:
241: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_CREATE');
242: fnd_message.set_token('RT_DIM', l_dimension_name);
243: l_note_msg := fnd_message.get;
244:
245: jtf_notes_pub.create_note
246: (p_api_version => 1.0,
247: x_return_status => x_return_status,

Line 444: fnd_message.set_name('CN', 'CN_X_UPDATE_DUC1');

440:
441: -- if it is used in a formula, then can not update dim_unit_code
442: IF (l_dummy = 1) THEN
443: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
444: fnd_message.set_name('CN', 'CN_X_UPDATE_DUC1');
445: fnd_msg_pub.ADD;
446: END IF;
447: RAISE fnd_api.g_exc_error;
448: END IF;

Line 454: fnd_message.set_name('CN', 'CN_X_UPDATE_DUC2');

450: -- dim_unit_code can be changed only between AMOUNT and PERCENT
451: IF (p_dim_unit_code NOT IN ('AMOUNT', 'PERCENT') OR
452: l_dim_unit_code NOT IN ('AMOUNT', 'PERCENT')) THEN
453: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
454: fnd_message.set_name('CN', 'CN_X_UPDATE_DUC2');
455: fnd_msg_pub.ADD;
456: END IF;
457: RAISE fnd_api.g_exc_error;
458: END IF;

Line 572: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_UPDATE');

568: -- ************ Start - R12 Notes History ************** ***************
569: -- *********************************************************************
570: l_consolidated_note := '';
571: IF (p_name <> l_dimension_name_old) THEN
572: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_UPDATE');
573: fnd_message.set_token('OLD_RT_DIM', l_dimension_name_old);
574: fnd_message.set_token('NEW_RT_DIM', p_name);
575: l_note_msg := fnd_message.get;
576: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);

Line 573: fnd_message.set_token('OLD_RT_DIM', l_dimension_name_old);

569: -- *********************************************************************
570: l_consolidated_note := '';
571: IF (p_name <> l_dimension_name_old) THEN
572: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_UPDATE');
573: fnd_message.set_token('OLD_RT_DIM', l_dimension_name_old);
574: fnd_message.set_token('NEW_RT_DIM', p_name);
575: l_note_msg := fnd_message.get;
576: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
577: /*jtf_notes_pub.create_note

Line 574: fnd_message.set_token('NEW_RT_DIM', p_name);

570: l_consolidated_note := '';
571: IF (p_name <> l_dimension_name_old) THEN
572: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_UPDATE');
573: fnd_message.set_token('OLD_RT_DIM', l_dimension_name_old);
574: fnd_message.set_token('NEW_RT_DIM', p_name);
575: l_note_msg := fnd_message.get;
576: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
577: /*jtf_notes_pub.create_note
578: (p_api_version => 1.0,

Line 575: l_note_msg := fnd_message.get;

571: IF (p_name <> l_dimension_name_old) THEN
572: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_UPDATE');
573: fnd_message.set_token('OLD_RT_DIM', l_dimension_name_old);
574: fnd_message.set_token('NEW_RT_DIM', p_name);
575: l_note_msg := fnd_message.get;
576: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
577: /*jtf_notes_pub.create_note
578: (p_api_version => 1.0,
579: x_return_status => x_return_status,

Line 592: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TYPE_UPDATE');

588: );*/
589: END IF;
590:
591: IF (p_dim_unit_code <> l_type_old) THEN
592: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TYPE_UPDATE');
593: fnd_message.set_token('OLD_DIM_TYPE', cn_api.get_lkup_meaning(l_type_old, 'UNIT_OF_MEASURE'));
594: fnd_message.set_token('NEW_DIM_TYPE', cn_api.get_lkup_meaning(p_dim_unit_code, 'UNIT_OF_MEASURE'));
595: l_note_msg := fnd_message.get;
596: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

Line 593: fnd_message.set_token('OLD_DIM_TYPE', cn_api.get_lkup_meaning(l_type_old, 'UNIT_OF_MEASURE'));

589: END IF;
590:
591: IF (p_dim_unit_code <> l_type_old) THEN
592: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TYPE_UPDATE');
593: fnd_message.set_token('OLD_DIM_TYPE', cn_api.get_lkup_meaning(l_type_old, 'UNIT_OF_MEASURE'));
594: fnd_message.set_token('NEW_DIM_TYPE', cn_api.get_lkup_meaning(p_dim_unit_code, 'UNIT_OF_MEASURE'));
595: l_note_msg := fnd_message.get;
596: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
597: /* jtf_notes_pub.create_note

Line 594: fnd_message.set_token('NEW_DIM_TYPE', cn_api.get_lkup_meaning(p_dim_unit_code, 'UNIT_OF_MEASURE'));

590:
591: IF (p_dim_unit_code <> l_type_old) THEN
592: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TYPE_UPDATE');
593: fnd_message.set_token('OLD_DIM_TYPE', cn_api.get_lkup_meaning(l_type_old, 'UNIT_OF_MEASURE'));
594: fnd_message.set_token('NEW_DIM_TYPE', cn_api.get_lkup_meaning(p_dim_unit_code, 'UNIT_OF_MEASURE'));
595: l_note_msg := fnd_message.get;
596: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
597: /* jtf_notes_pub.create_note
598: (p_api_version => 1.0,

Line 595: l_note_msg := fnd_message.get;

591: IF (p_dim_unit_code <> l_type_old) THEN
592: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TYPE_UPDATE');
593: fnd_message.set_token('OLD_DIM_TYPE', cn_api.get_lkup_meaning(l_type_old, 'UNIT_OF_MEASURE'));
594: fnd_message.set_token('NEW_DIM_TYPE', cn_api.get_lkup_meaning(p_dim_unit_code, 'UNIT_OF_MEASURE'));
595: l_note_msg := fnd_message.get;
596: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
597: /* jtf_notes_pub.create_note
598: (p_api_version => 1.0,
599: x_return_status => x_return_status,

Line 730: fnd_message.set_name('CN', 'CN_DIMENSION_IN_USE');

726: CLOSE parent_table_exist;
727:
728: IF (l_dummy = 1) THEN
729: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
730: fnd_message.set_name('CN', 'CN_DIMENSION_IN_USE');
731: fnd_msg_pub.ADD;
732: END IF;
733: RAISE fnd_api.g_exc_error;
734: END IF;

Line 754: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_DELETE');

750: -- *********************************************************************
751: -- ************ Start - R12 Notes History ******************************
752: -- *********************************************************************
753: IF (l_org_id <> -999) THEN
754: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_DELETE');
755: fnd_message.set_token('RT_DIM', l_dimension_name);
756: l_note_msg := fnd_message.get;
757:
758: jtf_notes_pub.create_note

Line 755: fnd_message.set_token('RT_DIM', l_dimension_name);

751: -- ************ Start - R12 Notes History ******************************
752: -- *********************************************************************
753: IF (l_org_id <> -999) THEN
754: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_DELETE');
755: fnd_message.set_token('RT_DIM', l_dimension_name);
756: l_note_msg := fnd_message.get;
757:
758: jtf_notes_pub.create_note
759: (p_api_version => 1.0,

Line 756: l_note_msg := fnd_message.get;

752: -- *********************************************************************
753: IF (l_org_id <> -999) THEN
754: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_DELETE');
755: fnd_message.set_token('RT_DIM', l_dimension_name);
756: l_note_msg := fnd_message.get;
757:
758: jtf_notes_pub.create_note
759: (p_api_version => 1.0,
760: x_return_status => x_return_status,

Line 904: fnd_message.set_name('CN', 'CN_RECORD_DELETED');

900: FROM cn_rate_dim_tiers
901: WHERE rate_dim_tier_id = p_rate_dim_tier_id;
902: exception
903: when no_data_found then
904: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
905: fnd_msg_pub.add;
906: raise fnd_api.g_exc_unexpected_error;
907: end;
908:

Line 916: fnd_message.set_name('CN', 'CN_DIM_LAST_TIER');

912: CLOSE last_tier;
913:
914: IF (l_dummy = 1) THEN
915: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
916: fnd_message.set_name('CN', 'CN_DIM_LAST_TIER');
917: fnd_msg_pub.ADD;
918: END IF;
919: RAISE fnd_api.g_exc_error;
920: END IF;

Line 953: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_DELETE');

949: if (l_old_rec.minimum_amount is NOT NULL AND l_old_rec.maximum_amount is NOT NULL)
950: then
951: l_from := l_old_rec.minimum_amount;
952: l_to := l_old_rec.maximum_amount;
953: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_DELETE');
954: fnd_message.set_token('FROM', l_from);
955: fnd_message.set_token('TO', l_to);
956: end if;
957: if (l_old_rec.min_exp_id is NOT NULL AND l_old_rec.max_exp_id is NOT NULL)

Line 954: fnd_message.set_token('FROM', l_from);

950: then
951: l_from := l_old_rec.minimum_amount;
952: l_to := l_old_rec.maximum_amount;
953: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_DELETE');
954: fnd_message.set_token('FROM', l_from);
955: fnd_message.set_token('TO', l_to);
956: end if;
957: if (l_old_rec.min_exp_id is NOT NULL AND l_old_rec.max_exp_id is NOT NULL)
958: then

Line 955: fnd_message.set_token('TO', l_to);

951: l_from := l_old_rec.minimum_amount;
952: l_to := l_old_rec.maximum_amount;
953: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_DELETE');
954: fnd_message.set_token('FROM', l_from);
955: fnd_message.set_token('TO', l_to);
956: end if;
957: if (l_old_rec.min_exp_id is NOT NULL AND l_old_rec.max_exp_id is NOT NULL)
958: then
959: select name into l_from from cn_calc_sql_exps

Line 963: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_DELETE');

959: select name into l_from from cn_calc_sql_exps
960: where calc_sql_exp_id = l_old_rec.min_exp_id;
961: select name into l_to from cn_calc_sql_exps
962: where calc_sql_exp_id = l_old_rec.max_exp_id;
963: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_DELETE');
964: fnd_message.set_token('FROM', l_from);
965: fnd_message.set_token('TO', l_to);
966: end if;
967: if (l_old_rec.string_value is NOT NULL)

Line 964: fnd_message.set_token('FROM', l_from);

960: where calc_sql_exp_id = l_old_rec.min_exp_id;
961: select name into l_to from cn_calc_sql_exps
962: where calc_sql_exp_id = l_old_rec.max_exp_id;
963: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_DELETE');
964: fnd_message.set_token('FROM', l_from);
965: fnd_message.set_token('TO', l_to);
966: end if;
967: if (l_old_rec.string_value is NOT NULL)
968: then

Line 965: fnd_message.set_token('TO', l_to);

961: select name into l_to from cn_calc_sql_exps
962: where calc_sql_exp_id = l_old_rec.max_exp_id;
963: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_DELETE');
964: fnd_message.set_token('FROM', l_from);
965: fnd_message.set_token('TO', l_to);
966: end if;
967: if (l_old_rec.string_value is NOT NULL)
968: then
969: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_DELETE');

Line 969: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_DELETE');

965: fnd_message.set_token('TO', l_to);
966: end if;
967: if (l_old_rec.string_value is NOT NULL)
968: then
969: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_DELETE');
970: fnd_message.set_token('STR_VAL', l_old_rec.string_value);
971: end if;
972:
973: l_note_msg := fnd_message.get;

Line 970: fnd_message.set_token('STR_VAL', l_old_rec.string_value);

966: end if;
967: if (l_old_rec.string_value is NOT NULL)
968: then
969: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_DELETE');
970: fnd_message.set_token('STR_VAL', l_old_rec.string_value);
971: end if;
972:
973: l_note_msg := fnd_message.get;
974:

Line 973: l_note_msg := fnd_message.get;

969: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_DELETE');
970: fnd_message.set_token('STR_VAL', l_old_rec.string_value);
971: end if;
972:
973: l_note_msg := fnd_message.get;
974:
975: jtf_notes_pub.create_note
976: (p_api_version => 1.0,
977: x_return_status => x_return_status,

Line 1118: fnd_message.set_name('CN', 'CN_TIER_NULL_MISS');

1114: p_minimum_amount IS NULL OR
1115: p_maximum_amount IS NULL)
1116: THEN
1117: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1118: fnd_message.set_name('CN', 'CN_TIER_NULL_MISS');
1119: fnd_msg_pub.ADD;
1120: END IF;
1121: RAISE fnd_api.g_exc_error;
1122: END IF;

Line 1126: fnd_message.set_name('CN', 'CN_MIN_G_MAX');

1122: END IF;
1123:
1124: IF (p_minimum_amount >= p_maximum_amount) THEN
1125: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1126: fnd_message.set_name('CN', 'CN_MIN_G_MAX');
1127: fnd_msg_pub.ADD;
1128: END IF;
1129: RAISE fnd_api.g_exc_error;
1130: END IF;

Line 1171: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');

1167: l_from_old := l_old_rec.minimum_amount;
1168: l_to_old := l_old_rec.maximum_amount;
1169: l_from_new := p_minimum_amount;
1170: l_to_new := p_maximum_amount;
1171: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');
1172: fnd_message.set_token('OLD_FROM', l_from_old);
1173: fnd_message.set_token('OLD_TO', l_to_old);
1174: fnd_message.set_token('NEW_FROM', l_from_new);
1175: fnd_message.set_token('NEW_TO', l_to_new);

Line 1172: fnd_message.set_token('OLD_FROM', l_from_old);

1168: l_to_old := l_old_rec.maximum_amount;
1169: l_from_new := p_minimum_amount;
1170: l_to_new := p_maximum_amount;
1171: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');
1172: fnd_message.set_token('OLD_FROM', l_from_old);
1173: fnd_message.set_token('OLD_TO', l_to_old);
1174: fnd_message.set_token('NEW_FROM', l_from_new);
1175: fnd_message.set_token('NEW_TO', l_to_new);
1176: end if;

Line 1173: fnd_message.set_token('OLD_TO', l_to_old);

1169: l_from_new := p_minimum_amount;
1170: l_to_new := p_maximum_amount;
1171: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');
1172: fnd_message.set_token('OLD_FROM', l_from_old);
1173: fnd_message.set_token('OLD_TO', l_to_old);
1174: fnd_message.set_token('NEW_FROM', l_from_new);
1175: fnd_message.set_token('NEW_TO', l_to_new);
1176: end if;
1177: if (p_min_exp_id is NOT NULL AND p_max_exp_id is NOT NULL)

Line 1174: fnd_message.set_token('NEW_FROM', l_from_new);

1170: l_to_new := p_maximum_amount;
1171: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');
1172: fnd_message.set_token('OLD_FROM', l_from_old);
1173: fnd_message.set_token('OLD_TO', l_to_old);
1174: fnd_message.set_token('NEW_FROM', l_from_new);
1175: fnd_message.set_token('NEW_TO', l_to_new);
1176: end if;
1177: if (p_min_exp_id is NOT NULL AND p_max_exp_id is NOT NULL)
1178: then

Line 1175: fnd_message.set_token('NEW_TO', l_to_new);

1171: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');
1172: fnd_message.set_token('OLD_FROM', l_from_old);
1173: fnd_message.set_token('OLD_TO', l_to_old);
1174: fnd_message.set_token('NEW_FROM', l_from_new);
1175: fnd_message.set_token('NEW_TO', l_to_new);
1176: end if;
1177: if (p_min_exp_id is NOT NULL AND p_max_exp_id is NOT NULL)
1178: then
1179: select name into l_from_old from cn_calc_sql_exps

Line 1187: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');

1183: select name into l_from_new from cn_calc_sql_exps
1184: where calc_sql_exp_id = p_min_exp_id;
1185: select name into l_to_new from cn_calc_sql_exps
1186: where calc_sql_exp_id = p_max_exp_id;
1187: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');
1188: fnd_message.set_token('OLD_FROM', l_from_old);
1189: fnd_message.set_token('OLD_TO', l_to_old);
1190: fnd_message.set_token('NEW_FROM', l_from_new);
1191: fnd_message.set_token('NEW_TO', l_to_new);

Line 1188: fnd_message.set_token('OLD_FROM', l_from_old);

1184: where calc_sql_exp_id = p_min_exp_id;
1185: select name into l_to_new from cn_calc_sql_exps
1186: where calc_sql_exp_id = p_max_exp_id;
1187: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');
1188: fnd_message.set_token('OLD_FROM', l_from_old);
1189: fnd_message.set_token('OLD_TO', l_to_old);
1190: fnd_message.set_token('NEW_FROM', l_from_new);
1191: fnd_message.set_token('NEW_TO', l_to_new);
1192: end if;

Line 1189: fnd_message.set_token('OLD_TO', l_to_old);

1185: select name into l_to_new from cn_calc_sql_exps
1186: where calc_sql_exp_id = p_max_exp_id;
1187: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');
1188: fnd_message.set_token('OLD_FROM', l_from_old);
1189: fnd_message.set_token('OLD_TO', l_to_old);
1190: fnd_message.set_token('NEW_FROM', l_from_new);
1191: fnd_message.set_token('NEW_TO', l_to_new);
1192: end if;
1193: if (p_string_value is not null) then

Line 1190: fnd_message.set_token('NEW_FROM', l_from_new);

1186: where calc_sql_exp_id = p_max_exp_id;
1187: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');
1188: fnd_message.set_token('OLD_FROM', l_from_old);
1189: fnd_message.set_token('OLD_TO', l_to_old);
1190: fnd_message.set_token('NEW_FROM', l_from_new);
1191: fnd_message.set_token('NEW_TO', l_to_new);
1192: end if;
1193: if (p_string_value is not null) then
1194: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_UPDATE');

Line 1191: fnd_message.set_token('NEW_TO', l_to_new);

1187: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');
1188: fnd_message.set_token('OLD_FROM', l_from_old);
1189: fnd_message.set_token('OLD_TO', l_to_old);
1190: fnd_message.set_token('NEW_FROM', l_from_new);
1191: fnd_message.set_token('NEW_TO', l_to_new);
1192: end if;
1193: if (p_string_value is not null) then
1194: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_UPDATE');
1195: fnd_message.set_token('OLD_STR_VAL', l_old_rec.string_value);

Line 1194: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_UPDATE');

1190: fnd_message.set_token('NEW_FROM', l_from_new);
1191: fnd_message.set_token('NEW_TO', l_to_new);
1192: end if;
1193: if (p_string_value is not null) then
1194: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_UPDATE');
1195: fnd_message.set_token('OLD_STR_VAL', l_old_rec.string_value);
1196: fnd_message.set_token('NEW_STR_VAL', p_string_value);
1197: end if;
1198:

Line 1195: fnd_message.set_token('OLD_STR_VAL', l_old_rec.string_value);

1191: fnd_message.set_token('NEW_TO', l_to_new);
1192: end if;
1193: if (p_string_value is not null) then
1194: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_UPDATE');
1195: fnd_message.set_token('OLD_STR_VAL', l_old_rec.string_value);
1196: fnd_message.set_token('NEW_STR_VAL', p_string_value);
1197: end if;
1198:
1199: l_note_msg := fnd_message.get;

Line 1196: fnd_message.set_token('NEW_STR_VAL', p_string_value);

1192: end if;
1193: if (p_string_value is not null) then
1194: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_UPDATE');
1195: fnd_message.set_token('OLD_STR_VAL', l_old_rec.string_value);
1196: fnd_message.set_token('NEW_STR_VAL', p_string_value);
1197: end if;
1198:
1199: l_note_msg := fnd_message.get;
1200:

Line 1199: l_note_msg := fnd_message.get;

1195: fnd_message.set_token('OLD_STR_VAL', l_old_rec.string_value);
1196: fnd_message.set_token('NEW_STR_VAL', p_string_value);
1197: end if;
1198:
1199: l_note_msg := fnd_message.get;
1200:
1201: jtf_notes_pub.create_note
1202: (p_api_version => 1.0,
1203: x_return_status => x_return_status,

Line 1336: fnd_message.set_name('CN', 'CN_TIER_NULL_MISS');

1332: p_minimum_amount IS NULL OR
1333: p_maximum_amount IS NULL)
1334: THEN
1335: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1336: fnd_message.set_name('CN', 'CN_TIER_NULL_MISS');
1337: fnd_msg_pub.ADD;
1338: END IF;
1339: RAISE fnd_api.g_exc_error;
1340: END IF;

Line 1344: fnd_message.set_name('CN', 'CN_MIN_G_MAX');

1340: END IF;
1341:
1342: IF (p_minimum_amount >= p_maximum_amount) THEN
1343: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1344: fnd_message.set_name('CN', 'CN_MIN_G_MAX');
1345: fnd_msg_pub.ADD;
1346: END IF;
1347: RAISE fnd_api.g_exc_error;
1348: END IF;

Line 1395: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_CREATE');

1391: if (p_minimum_amount is NOT NULL AND p_maximum_amount is NOT NULL)
1392: then
1393: l_from := p_minimum_amount;
1394: l_to := p_maximum_amount;
1395: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_CREATE');
1396: fnd_message.set_token('FROM', l_from);
1397: fnd_message.set_token('TO', l_to);
1398: end if;
1399: if (p_min_exp_id is NOT NULL AND p_max_exp_id is NOT NULL)

Line 1396: fnd_message.set_token('FROM', l_from);

1392: then
1393: l_from := p_minimum_amount;
1394: l_to := p_maximum_amount;
1395: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_CREATE');
1396: fnd_message.set_token('FROM', l_from);
1397: fnd_message.set_token('TO', l_to);
1398: end if;
1399: if (p_min_exp_id is NOT NULL AND p_max_exp_id is NOT NULL)
1400: then

Line 1397: fnd_message.set_token('TO', l_to);

1393: l_from := p_minimum_amount;
1394: l_to := p_maximum_amount;
1395: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_CREATE');
1396: fnd_message.set_token('FROM', l_from);
1397: fnd_message.set_token('TO', l_to);
1398: end if;
1399: if (p_min_exp_id is NOT NULL AND p_max_exp_id is NOT NULL)
1400: then
1401: select name into l_from from cn_calc_sql_exps

Line 1405: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_CREATE');

1401: select name into l_from from cn_calc_sql_exps
1402: where calc_sql_exp_id = p_min_exp_id;
1403: select name into l_to from cn_calc_sql_exps
1404: where calc_sql_exp_id = p_max_exp_id;
1405: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_CREATE');
1406: fnd_message.set_token('FROM', l_from);
1407: fnd_message.set_token('TO', l_to);
1408: end if;
1409: if (p_string_value is NOT NULL) then

Line 1406: fnd_message.set_token('FROM', l_from);

1402: where calc_sql_exp_id = p_min_exp_id;
1403: select name into l_to from cn_calc_sql_exps
1404: where calc_sql_exp_id = p_max_exp_id;
1405: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_CREATE');
1406: fnd_message.set_token('FROM', l_from);
1407: fnd_message.set_token('TO', l_to);
1408: end if;
1409: if (p_string_value is NOT NULL) then
1410: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_CREATE');

Line 1407: fnd_message.set_token('TO', l_to);

1403: select name into l_to from cn_calc_sql_exps
1404: where calc_sql_exp_id = p_max_exp_id;
1405: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_CREATE');
1406: fnd_message.set_token('FROM', l_from);
1407: fnd_message.set_token('TO', l_to);
1408: end if;
1409: if (p_string_value is NOT NULL) then
1410: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_CREATE');
1411: fnd_message.set_token('STR_VAL', p_string_value);

Line 1410: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_CREATE');

1406: fnd_message.set_token('FROM', l_from);
1407: fnd_message.set_token('TO', l_to);
1408: end if;
1409: if (p_string_value is NOT NULL) then
1410: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_CREATE');
1411: fnd_message.set_token('STR_VAL', p_string_value);
1412: end if;
1413:
1414: l_note_msg := fnd_message.get;

Line 1411: fnd_message.set_token('STR_VAL', p_string_value);

1407: fnd_message.set_token('TO', l_to);
1408: end if;
1409: if (p_string_value is NOT NULL) then
1410: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_CREATE');
1411: fnd_message.set_token('STR_VAL', p_string_value);
1412: end if;
1413:
1414: l_note_msg := fnd_message.get;
1415:

Line 1414: l_note_msg := fnd_message.get;

1410: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_ST_CREATE');
1411: fnd_message.set_token('STR_VAL', p_string_value);
1412: end if;
1413:
1414: l_note_msg := fnd_message.get;
1415:
1416: jtf_notes_pub.create_note
1417: (p_api_version => 1.0,
1418: x_return_status => x_return_status,