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_MULTI_RATE_SCHEDULES_PVT dependencies on FND_MESSAGE

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

29: BEGIN
30: IF (p_name IS NULL) THEN
31: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
32: l_prompt := cn_api.get_lkup_meaning('RATE_TABLE_NAME', 'CN_PROMPTS');
33: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
34: fnd_message.set_token('OBJ_NAME', l_prompt);
35: fnd_msg_pub.ADD;
36: END IF;
37: RAISE fnd_api.g_exc_error;

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

30: IF (p_name IS NULL) THEN
31: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
32: l_prompt := cn_api.get_lkup_meaning('RATE_TABLE_NAME', 'CN_PROMPTS');
33: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
34: fnd_message.set_token('OBJ_NAME', l_prompt);
35: fnd_msg_pub.ADD;
36: END IF;
37: RAISE fnd_api.g_exc_error;
38: END IF;

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

42: CLOSE name_exists;
43:
44: IF (l_dummy = 1) THEN
45: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
46: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
47: fnd_msg_pub.ADD;
48: END IF;
49: RAISE fnd_api.g_exc_error;
50: END IF;

Line 55: fnd_message.set_name('CN', 'CN_INVALID_CUC');

51:
52: -- validate commission_unit_code
53: IF (p_commission_unit_code NOT IN ('AMOUNT', 'PERCENT')) THEN
54: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
55: fnd_message.set_name('CN', 'CN_INVALID_CUC');
56: fnd_msg_pub.ADD;
57: END IF;
58: RAISE fnd_api.g_exc_error;
59: END IF;

Line 65: fnd_message.set_name('CN', 'CN_X_NUMBER_DIM');

61: -- if p_dims_tbl is not empty, then p_number_dim should be equal to the number of
62: -- records in p_dims_tbl. also the sequence numbers should be unique
63: IF (p_number_dim <> p_dims_tbl.count) THEN
64: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
65: fnd_message.set_name('CN', 'CN_X_NUMBER_DIM');
66: fnd_msg_pub.ADD;
67: END IF;
68: RAISE fnd_api.g_exc_error;
69: END IF;

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

74: -- for i in 1..p_number_dim-1 loop
75: -- for j in i+1..p_number_dim loop
76: if p_dims_tbl(i).rate_dim_sequence = p_dims_tbl(j).rate_dim_sequence then
77: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
78: fnd_message.set_name('CN', 'CN_SEQUENCE_NOT_UNIQUE');
79: fnd_msg_pub.ADD;
80: END IF;
81: RAISE fnd_api.g_exc_error;
82: END IF;

Line 85: fnd_message.set_name('CN', 'CN_DUPLICATE_DIM_ASSIGN');

81: RAISE fnd_api.g_exc_error;
82: END IF;
83: if p_dims_tbl(i).rate_dimension_id = p_dims_tbl(j).rate_dimension_id then
84: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
85: fnd_message.set_name('CN', 'CN_DUPLICATE_DIM_ASSIGN');
86: fnd_msg_pub.ADD;
87: END IF;
88: RAISE fnd_api.g_exc_error;
89: END IF;

Line 211: fnd_message.set_name('CN', 'CN_SRP_RATE_ASSIGNS_NOTE');

207: l_tiers := d.name || ' (' || l_tier || ')' || l_tiers;
208: end loop;
209:
210: if p_rate_schedule_id = 0 then
211: fnd_message.set_name('CN', 'CN_SRP_RATE_ASSIGNS_NOTE');
212: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
213: fnd_message.set_token('START_DATE', l_info_rec.start_date);
214: fnd_message.set_token('END_DATE', l_info_rec.end_date);
215: fnd_message.set_token('DIMENSIONS', l_tiers);

Line 212: fnd_message.set_token('RATE_TABLE', l_info_rec.name);

208: end loop;
209:
210: if p_rate_schedule_id = 0 then
211: fnd_message.set_name('CN', 'CN_SRP_RATE_ASSIGNS_NOTE');
212: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
213: fnd_message.set_token('START_DATE', l_info_rec.start_date);
214: fnd_message.set_token('END_DATE', l_info_rec.end_date);
215: fnd_message.set_token('DIMENSIONS', l_tiers);
216: fnd_message.set_token('OLD', p_old_amt * l_pct);

Line 213: fnd_message.set_token('START_DATE', l_info_rec.start_date);

209:
210: if p_rate_schedule_id = 0 then
211: fnd_message.set_name('CN', 'CN_SRP_RATE_ASSIGNS_NOTE');
212: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
213: fnd_message.set_token('START_DATE', l_info_rec.start_date);
214: fnd_message.set_token('END_DATE', l_info_rec.end_date);
215: fnd_message.set_token('DIMENSIONS', l_tiers);
216: fnd_message.set_token('OLD', p_old_amt * l_pct);
217: fnd_message.set_token('NEW', p_new_amt * l_pct);

Line 214: fnd_message.set_token('END_DATE', l_info_rec.end_date);

210: if p_rate_schedule_id = 0 then
211: fnd_message.set_name('CN', 'CN_SRP_RATE_ASSIGNS_NOTE');
212: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
213: fnd_message.set_token('START_DATE', l_info_rec.start_date);
214: fnd_message.set_token('END_DATE', l_info_rec.end_date);
215: fnd_message.set_token('DIMENSIONS', l_tiers);
216: fnd_message.set_token('OLD', p_old_amt * l_pct);
217: fnd_message.set_token('NEW', p_new_amt * l_pct);
218:

Line 215: fnd_message.set_token('DIMENSIONS', l_tiers);

211: fnd_message.set_name('CN', 'CN_SRP_RATE_ASSIGNS_NOTE');
212: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
213: fnd_message.set_token('START_DATE', l_info_rec.start_date);
214: fnd_message.set_token('END_DATE', l_info_rec.end_date);
215: fnd_message.set_token('DIMENSIONS', l_tiers);
216: fnd_message.set_token('OLD', p_old_amt * l_pct);
217: fnd_message.set_token('NEW', p_new_amt * l_pct);
218:
219: l_note_msg := fnd_message.get();

Line 216: fnd_message.set_token('OLD', p_old_amt * l_pct);

212: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
213: fnd_message.set_token('START_DATE', l_info_rec.start_date);
214: fnd_message.set_token('END_DATE', l_info_rec.end_date);
215: fnd_message.set_token('DIMENSIONS', l_tiers);
216: fnd_message.set_token('OLD', p_old_amt * l_pct);
217: fnd_message.set_token('NEW', p_new_amt * l_pct);
218:
219: l_note_msg := fnd_message.get();
220: jtf_notes_pub.create_note

Line 217: fnd_message.set_token('NEW', p_new_amt * l_pct);

213: fnd_message.set_token('START_DATE', l_info_rec.start_date);
214: fnd_message.set_token('END_DATE', l_info_rec.end_date);
215: fnd_message.set_token('DIMENSIONS', l_tiers);
216: fnd_message.set_token('OLD', p_old_amt * l_pct);
217: fnd_message.set_token('NEW', p_new_amt * l_pct);
218:
219: l_note_msg := fnd_message.get();
220: jtf_notes_pub.create_note
221: ( p_api_version => 1.0,

Line 219: l_note_msg := fnd_message.get();

215: fnd_message.set_token('DIMENSIONS', l_tiers);
216: fnd_message.set_token('OLD', p_old_amt * l_pct);
217: fnd_message.set_token('NEW', p_new_amt * l_pct);
218:
219: l_note_msg := fnd_message.get();
220: jtf_notes_pub.create_note
221: ( p_api_version => 1.0,
222: x_return_status => x_return_status,
223: x_msg_count => x_msg_count,

Line 234: fnd_message.set_name('CN', 'CN_MULTI_RATE_ASSIGNS_NOTE');

230: x_jtf_note_id => x_note_id -- returned
231: );
232:
233: else
234: fnd_message.set_name('CN', 'CN_MULTI_RATE_ASSIGNS_NOTE');
235: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
236: fnd_message.set_token('DIMENSIONS', l_tiers);
237: fnd_message.set_token('OLD', p_old_amt * l_pct);
238: fnd_message.set_token('NEW', p_new_amt * l_pct);

Line 235: fnd_message.set_token('RATE_TABLE', l_info_rec.name);

231: );
232:
233: else
234: fnd_message.set_name('CN', 'CN_MULTI_RATE_ASSIGNS_NOTE');
235: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
236: fnd_message.set_token('DIMENSIONS', l_tiers);
237: fnd_message.set_token('OLD', p_old_amt * l_pct);
238: fnd_message.set_token('NEW', p_new_amt * l_pct);
239: l_note_msg := fnd_message.get();

Line 236: fnd_message.set_token('DIMENSIONS', l_tiers);

232:
233: else
234: fnd_message.set_name('CN', 'CN_MULTI_RATE_ASSIGNS_NOTE');
235: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
236: fnd_message.set_token('DIMENSIONS', l_tiers);
237: fnd_message.set_token('OLD', p_old_amt * l_pct);
238: fnd_message.set_token('NEW', p_new_amt * l_pct);
239: l_note_msg := fnd_message.get();
240: jtf_notes_pub.create_note

Line 237: fnd_message.set_token('OLD', p_old_amt * l_pct);

233: else
234: fnd_message.set_name('CN', 'CN_MULTI_RATE_ASSIGNS_NOTE');
235: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
236: fnd_message.set_token('DIMENSIONS', l_tiers);
237: fnd_message.set_token('OLD', p_old_amt * l_pct);
238: fnd_message.set_token('NEW', p_new_amt * l_pct);
239: l_note_msg := fnd_message.get();
240: jtf_notes_pub.create_note
241: ( p_api_version => 1.0,

Line 238: fnd_message.set_token('NEW', p_new_amt * l_pct);

234: fnd_message.set_name('CN', 'CN_MULTI_RATE_ASSIGNS_NOTE');
235: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
236: fnd_message.set_token('DIMENSIONS', l_tiers);
237: fnd_message.set_token('OLD', p_old_amt * l_pct);
238: fnd_message.set_token('NEW', p_new_amt * l_pct);
239: l_note_msg := fnd_message.get();
240: jtf_notes_pub.create_note
241: ( p_api_version => 1.0,
242: x_return_status => x_return_status,

Line 239: l_note_msg := fnd_message.get();

235: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
236: fnd_message.set_token('DIMENSIONS', l_tiers);
237: fnd_message.set_token('OLD', p_old_amt * l_pct);
238: fnd_message.set_token('NEW', p_new_amt * l_pct);
239: l_note_msg := fnd_message.get();
240: jtf_notes_pub.create_note
241: ( p_api_version => 1.0,
242: x_return_status => x_return_status,
243: x_msg_count => x_msg_count,

Line 384: fnd_message.set_name('CN', 'CNR12_NOTE_RT_CREATE');

380: select name into l_rate_sch_name
381: from cn_rate_schedules
382: where rate_schedule_id = x_rate_schedule_id;
383:
384: fnd_message.set_name('CN', 'CNR12_NOTE_RT_CREATE');
385: fnd_message.set_token('RT_NAME', l_rate_sch_name);
386: l_note_msg := fnd_message.get;
387:
388: jtf_notes_pub.create_note

Line 385: fnd_message.set_token('RT_NAME', l_rate_sch_name);

381: from cn_rate_schedules
382: where rate_schedule_id = x_rate_schedule_id;
383:
384: fnd_message.set_name('CN', 'CNR12_NOTE_RT_CREATE');
385: fnd_message.set_token('RT_NAME', l_rate_sch_name);
386: l_note_msg := fnd_message.get;
387:
388: jtf_notes_pub.create_note
389: (p_api_version => 1.0,

Line 386: l_note_msg := fnd_message.get;

382: where rate_schedule_id = x_rate_schedule_id;
383:
384: fnd_message.set_name('CN', 'CNR12_NOTE_RT_CREATE');
385: fnd_message.set_token('RT_NAME', l_rate_sch_name);
386: l_note_msg := fnd_message.get;
387:
388: jtf_notes_pub.create_note
389: (p_api_version => 1.0,
390: x_return_status => x_return_status,

Line 597: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');

593: IF (l_usage_code = 'USED' AND
594: (l_commission_unit_code_old <> p_commission_unit_code OR l_number_dim > 0))
595: THEN
596: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
597: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
598: fnd_msg_pub.ADD;
599: END IF;
600: RAISE fnd_api.g_exc_error;
601: END IF;

Line 668: fnd_message.set_name('CN', 'CNR12_NOTE_RT_NAME_UPDATE');

664:
665: l_consolidated_note := '';
666:
667: IF (p_name <> l_rate_sch_old) THEN
668: fnd_message.set_name('CN', 'CNR12_NOTE_RT_NAME_UPDATE');
669: fnd_message.set_token('OLD_RT', l_rate_sch_old);
670: fnd_message.set_token('NEW_RT', p_name);
671: l_note_msg := fnd_message.get;
672: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

Line 669: fnd_message.set_token('OLD_RT', l_rate_sch_old);

665: l_consolidated_note := '';
666:
667: IF (p_name <> l_rate_sch_old) THEN
668: fnd_message.set_name('CN', 'CNR12_NOTE_RT_NAME_UPDATE');
669: fnd_message.set_token('OLD_RT', l_rate_sch_old);
670: fnd_message.set_token('NEW_RT', p_name);
671: l_note_msg := fnd_message.get;
672: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
673:

Line 670: fnd_message.set_token('NEW_RT', p_name);

666:
667: IF (p_name <> l_rate_sch_old) THEN
668: fnd_message.set_name('CN', 'CNR12_NOTE_RT_NAME_UPDATE');
669: fnd_message.set_token('OLD_RT', l_rate_sch_old);
670: fnd_message.set_token('NEW_RT', p_name);
671: l_note_msg := fnd_message.get;
672: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
673:
674: /*

Line 671: l_note_msg := fnd_message.get;

667: IF (p_name <> l_rate_sch_old) THEN
668: fnd_message.set_name('CN', 'CNR12_NOTE_RT_NAME_UPDATE');
669: fnd_message.set_token('OLD_RT', l_rate_sch_old);
670: fnd_message.set_token('NEW_RT', p_name);
671: l_note_msg := fnd_message.get;
672: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
673:
674: /*
675: jtf_notes_pub.create_note

Line 691: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_TYPE_UPDATE');

687: */
688: END IF;
689:
690: IF (p_commission_unit_code <> l_type_old) THEN
691: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_TYPE_UPDATE');
692: fnd_message.set_token('OLD_RT_TYPE', l_type_old);
693: fnd_message.set_token('NEW_RT_TYPE', p_commission_unit_code);
694: l_note_msg := fnd_message.get;
695: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

Line 692: fnd_message.set_token('OLD_RT_TYPE', l_type_old);

688: END IF;
689:
690: IF (p_commission_unit_code <> l_type_old) THEN
691: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_TYPE_UPDATE');
692: fnd_message.set_token('OLD_RT_TYPE', l_type_old);
693: fnd_message.set_token('NEW_RT_TYPE', p_commission_unit_code);
694: l_note_msg := fnd_message.get;
695: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
696:

Line 693: fnd_message.set_token('NEW_RT_TYPE', p_commission_unit_code);

689:
690: IF (p_commission_unit_code <> l_type_old) THEN
691: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_TYPE_UPDATE');
692: fnd_message.set_token('OLD_RT_TYPE', l_type_old);
693: fnd_message.set_token('NEW_RT_TYPE', p_commission_unit_code);
694: l_note_msg := fnd_message.get;
695: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
696:
697: /*

Line 694: l_note_msg := fnd_message.get;

690: IF (p_commission_unit_code <> l_type_old) THEN
691: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_TYPE_UPDATE');
692: fnd_message.set_token('OLD_RT_TYPE', l_type_old);
693: fnd_message.set_token('NEW_RT_TYPE', p_commission_unit_code);
694: l_note_msg := fnd_message.get;
695: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
696:
697: /*
698: jtf_notes_pub.create_note

Line 850: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');

846: usage_check(p_rate_schedule_id => p_rate_schedule_id,
847: x_usage_code => l_usage_code);
848: IF (l_usage_code = 'USED') THEN
849: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
850: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
851: fnd_msg_pub.ADD;
852: END IF;
853: RAISE fnd_api.g_exc_error;
854: END IF;

Line 873: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DELETE');

869: -- *********************************************************************
870: -- ************ Start - R12 Notes History ******************************
871: -- *********************************************************************
872: IF (l_org_id <> -999) THEN
873: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DELETE');
874: fnd_message.set_token('RT_NAME', l_rate_sch_name);
875: l_note_msg := fnd_message.get;
876:
877: jtf_notes_pub.create_note

Line 874: fnd_message.set_token('RT_NAME', l_rate_sch_name);

870: -- ************ Start - R12 Notes History ******************************
871: -- *********************************************************************
872: IF (l_org_id <> -999) THEN
873: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DELETE');
874: fnd_message.set_token('RT_NAME', l_rate_sch_name);
875: l_note_msg := fnd_message.get;
876:
877: jtf_notes_pub.create_note
878: (p_api_version => 1.0,

Line 875: l_note_msg := fnd_message.get;

871: -- *********************************************************************
872: IF (l_org_id <> -999) THEN
873: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DELETE');
874: fnd_message.set_token('RT_NAME', l_rate_sch_name);
875: l_note_msg := fnd_message.get;
876:
877: jtf_notes_pub.create_note
878: (p_api_version => 1.0,
879: x_return_status => x_return_status,

Line 1020: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');

1016: usage_check(p_rate_schedule_id => p_rate_schedule_id,
1017: x_usage_code => l_usage_code);
1018: IF (l_usage_code = 'USED') THEN
1019: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1020: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
1021: fnd_msg_pub.ADD;
1022: END IF;
1023: RAISE fnd_api.g_exc_error;
1024: END IF;

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

1031: WHERE rate_schedule_id = p_rate_schedule_id
1032: AND rate_sch_dim_id = p_rate_sch_dim_id;
1033: EXCEPTION
1034: when no_data_found then
1035: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
1036: fnd_msg_pub.add;
1037: raise fnd_api.g_exc_unexpected_error;
1038: END;
1039:

Line 1066: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_DELETE');

1062: -- *********************************************************************
1063: -- ************ Start - R12 Notes History ******************************
1064: -- *********************************************************************
1065: IF (l_org_id <> -999) THEN
1066: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_DELETE');
1067: fnd_message.set_token('OLD_DIM', l_dimension_name_old);
1068: fnd_message.set_token('RT_NAME', l_rate_sch_name_old);
1069: l_note_msg := fnd_message.get;
1070:

Line 1067: fnd_message.set_token('OLD_DIM', l_dimension_name_old);

1063: -- ************ Start - R12 Notes History ******************************
1064: -- *********************************************************************
1065: IF (l_org_id <> -999) THEN
1066: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_DELETE');
1067: fnd_message.set_token('OLD_DIM', l_dimension_name_old);
1068: fnd_message.set_token('RT_NAME', l_rate_sch_name_old);
1069: l_note_msg := fnd_message.get;
1070:
1071: jtf_notes_pub.create_note

Line 1068: fnd_message.set_token('RT_NAME', l_rate_sch_name_old);

1064: -- *********************************************************************
1065: IF (l_org_id <> -999) THEN
1066: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_DELETE');
1067: fnd_message.set_token('OLD_DIM', l_dimension_name_old);
1068: fnd_message.set_token('RT_NAME', l_rate_sch_name_old);
1069: l_note_msg := fnd_message.get;
1070:
1071: jtf_notes_pub.create_note
1072: (p_api_version => 1.0,

Line 1069: l_note_msg := fnd_message.get;

1065: IF (l_org_id <> -999) THEN
1066: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_DELETE');
1067: fnd_message.set_token('OLD_DIM', l_dimension_name_old);
1068: fnd_message.set_token('RT_NAME', l_rate_sch_name_old);
1069: l_note_msg := fnd_message.get;
1070:
1071: jtf_notes_pub.create_note
1072: (p_api_version => 1.0,
1073: x_return_status => x_return_status,

Line 1244: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');

1240: usage_check(p_rate_schedule_id,
1241: x_usage_code => l_usage_code);
1242: IF (l_usage_code = 'USED') THEN
1243: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1244: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
1245: fnd_msg_pub.ADD;
1246: END IF;
1247: RAISE fnd_api.g_exc_error;
1248: END IF;

Line 1271: fnd_message.set_name('CN', 'CN_DUPLICATE_DIM_ASSIGN');

1267: where rate_schedule_id = p_rate_schedule_id
1268: and rate_dimension_id = p_rate_dimension_id;
1269: if l_count > 0 then
1270: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1271: fnd_message.set_name('CN', 'CN_DUPLICATE_DIM_ASSIGN');
1272: fnd_msg_pub.ADD;
1273: END IF;
1274: RAISE fnd_api.g_exc_error;
1275: END IF;

Line 1328: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_UPDATE');

1324: select name into l_dimension_name_new
1325: from cn_rate_dimensions
1326: where rate_dimension_id = p_rate_dimension_id;
1327:
1328: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_UPDATE');
1329: fnd_message.set_token('OLD_DIM', l_dimension_name_old);
1330: fnd_message.set_token('NEW_DIM', l_dimension_name_new);
1331: l_note_msg := fnd_message.get;
1332:

Line 1329: fnd_message.set_token('OLD_DIM', l_dimension_name_old);

1325: from cn_rate_dimensions
1326: where rate_dimension_id = p_rate_dimension_id;
1327:
1328: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_UPDATE');
1329: fnd_message.set_token('OLD_DIM', l_dimension_name_old);
1330: fnd_message.set_token('NEW_DIM', l_dimension_name_new);
1331: l_note_msg := fnd_message.get;
1332:
1333: jtf_notes_pub.create_note

Line 1330: fnd_message.set_token('NEW_DIM', l_dimension_name_new);

1326: where rate_dimension_id = p_rate_dimension_id;
1327:
1328: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_UPDATE');
1329: fnd_message.set_token('OLD_DIM', l_dimension_name_old);
1330: fnd_message.set_token('NEW_DIM', l_dimension_name_new);
1331: l_note_msg := fnd_message.get;
1332:
1333: jtf_notes_pub.create_note
1334: (p_api_version => 1.0,

Line 1331: l_note_msg := fnd_message.get;

1327:
1328: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_UPDATE');
1329: fnd_message.set_token('OLD_DIM', l_dimension_name_old);
1330: fnd_message.set_token('NEW_DIM', l_dimension_name_new);
1331: l_note_msg := fnd_message.get;
1332:
1333: jtf_notes_pub.create_note
1334: (p_api_version => 1.0,
1335: x_return_status => x_return_status,

Line 1482: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');

1478: usage_check(p_rate_schedule_id,
1479: x_usage_code => l_usage_code);
1480: IF (l_usage_code = 'USED') THEN
1481: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1482: fnd_message.set_name('CN', 'CN_SCHEDULE_IN_USE');
1483: fnd_msg_pub.ADD;
1484: END IF;
1485: RAISE fnd_api.g_exc_error;
1486: END IF;

Line 1494: fnd_message.set_name('CN', 'CN_DUPLICATE_DIM_ASSIGN');

1490: where rate_schedule_id = p_rate_schedule_id
1491: and rate_dimension_id = p_rate_dimension_id;
1492: if l_count > 0 then
1493: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1494: fnd_message.set_name('CN', 'CN_DUPLICATE_DIM_ASSIGN');
1495: fnd_msg_pub.ADD;
1496: END IF;
1497: RAISE fnd_api.g_exc_error;
1498: END IF;

Line 1535: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_CREATE');

1531: select name into l_rate_sch_name
1532: from cn_rate_schedules
1533: where rate_schedule_id = p_rate_schedule_id;
1534:
1535: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_CREATE');
1536: fnd_message.set_token('RT_DIM', l_dimension_name);
1537: fnd_message.set_token('RT_NAME', l_rate_sch_name);
1538: l_note_msg := fnd_message.get;
1539:

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

1532: from cn_rate_schedules
1533: where rate_schedule_id = p_rate_schedule_id;
1534:
1535: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_CREATE');
1536: fnd_message.set_token('RT_DIM', l_dimension_name);
1537: fnd_message.set_token('RT_NAME', l_rate_sch_name);
1538: l_note_msg := fnd_message.get;
1539:
1540: jtf_notes_pub.create_note

Line 1537: fnd_message.set_token('RT_NAME', l_rate_sch_name);

1533: where rate_schedule_id = p_rate_schedule_id;
1534:
1535: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_CREATE');
1536: fnd_message.set_token('RT_DIM', l_dimension_name);
1537: fnd_message.set_token('RT_NAME', l_rate_sch_name);
1538: l_note_msg := fnd_message.get;
1539:
1540: jtf_notes_pub.create_note
1541: (p_api_version => 1.0,

Line 1538: l_note_msg := fnd_message.get;

1534:
1535: fnd_message.set_name('CN', 'CNR12_NOTE_RT_ASGN_DIM_CREATE');
1536: fnd_message.set_token('RT_DIM', l_dimension_name);
1537: fnd_message.set_token('RT_NAME', l_rate_sch_name);
1538: l_note_msg := fnd_message.get;
1539:
1540: jtf_notes_pub.create_note
1541: (p_api_version => 1.0,
1542: x_return_status => x_return_status,

Line 1676: fnd_message.set_name('CN', 'CN_EMPTY_DIMENSION');

1672:
1673: -- each dimension must have at least one tier. otherwise, raise an exception
1674: FOR j IN 1..l_dim_count LOOP
1675: IF (dim_size_table(j) = 0) THEN
1676: fnd_message.set_name('CN', 'CN_EMPTY_DIMENSION');
1677: RAISE fnd_api.g_exc_error;
1678: END IF;
1679: END LOOP;
1680:

Line 1780: fnd_message.set_name('CN', 'CN_EMPTY_DIMENSION');

1776:
1777: -- each dimension must have at least one tier. otherwise, raise an exception
1778: FOR j IN 1..l_dim_count LOOP
1779: IF (dim_size_table(j) = 0) THEN
1780: fnd_message.set_name('CN', 'CN_EMPTY_DIMENSION');
1781: RAISE fnd_api.g_exc_error;
1782: END IF;
1783: END LOOP;
1784:

Line 2117: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');

2113: -- srp rate tier exists - update it
2114: close rate_tier_info;
2115:
2116: if (l_object_version_number <> p_object_version_number) then
2117: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
2118: fnd_msg_pub.add;
2119: x_loading_status := 'CN_RECORD_CHANGED';
2120: raise fnd_api.g_exc_error;
2121: end if;