17: rp_ind_org_cnt Number;
18:
19: -- Fix for NLS Bug 2552772: Numeric or Value error
20: -- Changes: varchar2(30) to varchar2(80), substrb introduced while retrieving
21: -- messages using fnd_message.get_string
22:
23: rp_msg_dupl varchar2(80) :=
24: substrb(fnd_message.get_string('IMC','IMC_REPORTS_DUPL'),1,80);
25: rp_msg_dupls varchar2(80) :=
20: -- Changes: varchar2(30) to varchar2(80), substrb introduced while retrieving
21: -- messages using fnd_message.get_string
22:
23: rp_msg_dupl varchar2(80) :=
24: substrb(fnd_message.get_string('IMC','IMC_REPORTS_DUPL'),1,80);
25: rp_msg_dupls varchar2(80) :=
26: substrb(fnd_message.get_string('IMC','IMC_REPORTS_DUPLS'),1,80);
27: rp_msg_no_dupl varchar2(80) :=
28: substrb(fnd_message.get_string('IMC','IMC_REPORTS_NO_DUPL'),1,80);
22:
23: rp_msg_dupl varchar2(80) :=
24: substrb(fnd_message.get_string('IMC','IMC_REPORTS_DUPL'),1,80);
25: rp_msg_dupls varchar2(80) :=
26: substrb(fnd_message.get_string('IMC','IMC_REPORTS_DUPLS'),1,80);
27: rp_msg_no_dupl varchar2(80) :=
28: substrb(fnd_message.get_string('IMC','IMC_REPORTS_NO_DUPL'),1,80);
29: rp_msg_all_others varchar2(80) :=
30: substrb(fnd_message.get_string('IMC','IMC_REPORTS_ALL_OTHERS'),1,80);
24: substrb(fnd_message.get_string('IMC','IMC_REPORTS_DUPL'),1,80);
25: rp_msg_dupls varchar2(80) :=
26: substrb(fnd_message.get_string('IMC','IMC_REPORTS_DUPLS'),1,80);
27: rp_msg_no_dupl varchar2(80) :=
28: substrb(fnd_message.get_string('IMC','IMC_REPORTS_NO_DUPL'),1,80);
29: rp_msg_all_others varchar2(80) :=
30: substrb(fnd_message.get_string('IMC','IMC_REPORTS_ALL_OTHERS'),1,80);
31: rp_msg_total varchar2(80) :=
32: substrb(fnd_message.get_string('IMC','IMC_REPORTS_TOTAL'),1,80);
26: substrb(fnd_message.get_string('IMC','IMC_REPORTS_DUPLS'),1,80);
27: rp_msg_no_dupl varchar2(80) :=
28: substrb(fnd_message.get_string('IMC','IMC_REPORTS_NO_DUPL'),1,80);
29: rp_msg_all_others varchar2(80) :=
30: substrb(fnd_message.get_string('IMC','IMC_REPORTS_ALL_OTHERS'),1,80);
31: rp_msg_total varchar2(80) :=
32: substrb(fnd_message.get_string('IMC','IMC_REPORTS_TOTAL'),1,80);
33: rp_msg_undefined varchar2(80):=
34: substrb(fnd_message.get_string('IMC','IMC_REPORTS_UNDEFINED'),1,80);
28: substrb(fnd_message.get_string('IMC','IMC_REPORTS_NO_DUPL'),1,80);
29: rp_msg_all_others varchar2(80) :=
30: substrb(fnd_message.get_string('IMC','IMC_REPORTS_ALL_OTHERS'),1,80);
31: rp_msg_total varchar2(80) :=
32: substrb(fnd_message.get_string('IMC','IMC_REPORTS_TOTAL'),1,80);
33: rp_msg_undefined varchar2(80):=
34: substrb(fnd_message.get_string('IMC','IMC_REPORTS_UNDEFINED'),1,80);
35:
36: -- This variable g_log_flag is used as a flag whether to use fnd_file.put_line
30: substrb(fnd_message.get_string('IMC','IMC_REPORTS_ALL_OTHERS'),1,80);
31: rp_msg_total varchar2(80) :=
32: substrb(fnd_message.get_string('IMC','IMC_REPORTS_TOTAL'),1,80);
33: rp_msg_undefined varchar2(80):=
34: substrb(fnd_message.get_string('IMC','IMC_REPORTS_UNDEFINED'),1,80);
35:
36: -- This variable g_log_flag is used as a flag whether to use fnd_file.put_line
37: -- or not. If it is set to null, error messages are logged to fnd_file.If it
38: -- set to some value,the message can be printed dbms_output instead of