DBA Data[Home] [Help]

APPS.CSI_ML_UPDATE_PVT dependencies on FND_MESSAGE

Line 139: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

135: IF(l_debug_level>1) THEN
136: FND_File.Put_Line(Fnd_File.LOG,'Value of l_last_update_date='||to_char(l_last_update_date,'dd-mon-yy hh24:mi:ss'));
137: FND_File.Put_Line(Fnd_File.LOG,'Value of inst_intf_rec.source_transaction_date='||to_char(inst_intf_rec.source_transaction_date,'dd-mon-yy hh24:mi:ss'));
138: end if;
139: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
140: fnd_message.set_token('INSTANCE_NUMBER',inst_intf_rec.instance_id);
141: fnd_message.set_token('SOURCE_DATE',inst_intf_rec.source_transaction_date);
142: l_error_message :=substr(fnd_message.get,1,208);
143: RAISE e_restriction;

Line 140: fnd_message.set_token('INSTANCE_NUMBER',inst_intf_rec.instance_id);

136: FND_File.Put_Line(Fnd_File.LOG,'Value of l_last_update_date='||to_char(l_last_update_date,'dd-mon-yy hh24:mi:ss'));
137: FND_File.Put_Line(Fnd_File.LOG,'Value of inst_intf_rec.source_transaction_date='||to_char(inst_intf_rec.source_transaction_date,'dd-mon-yy hh24:mi:ss'));
138: end if;
139: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
140: fnd_message.set_token('INSTANCE_NUMBER',inst_intf_rec.instance_id);
141: fnd_message.set_token('SOURCE_DATE',inst_intf_rec.source_transaction_date);
142: l_error_message :=substr(fnd_message.get,1,208);
143: RAISE e_restriction;
144: END IF;

Line 141: fnd_message.set_token('SOURCE_DATE',inst_intf_rec.source_transaction_date);

137: FND_File.Put_Line(Fnd_File.LOG,'Value of inst_intf_rec.source_transaction_date='||to_char(inst_intf_rec.source_transaction_date,'dd-mon-yy hh24:mi:ss'));
138: end if;
139: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
140: fnd_message.set_token('INSTANCE_NUMBER',inst_intf_rec.instance_id);
141: fnd_message.set_token('SOURCE_DATE',inst_intf_rec.source_transaction_date);
142: l_error_message :=substr(fnd_message.get,1,208);
143: RAISE e_restriction;
144: END IF;
145:

Line 142: l_error_message :=substr(fnd_message.get,1,208);

138: end if;
139: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
140: fnd_message.set_token('INSTANCE_NUMBER',inst_intf_rec.instance_id);
141: fnd_message.set_token('SOURCE_DATE',inst_intf_rec.source_transaction_date);
142: l_error_message :=substr(fnd_message.get,1,208);
143: RAISE e_restriction;
144: END IF;
145:
146: OPEN ou_obj_ver_cur (inst_intf_rec.instance_id);

Line 152: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

148: l_last_update_date;
149: CLOSE ou_obj_ver_cur;
150: IF l_last_update_date > inst_intf_rec.source_transaction_date
151: THEN
152: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
153: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
154: l_error_message :=substr(fnd_message.get,1,208);
155: RAISE e_restriction;
156: END IF;

Line 153: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);

149: CLOSE ou_obj_ver_cur;
150: IF l_last_update_date > inst_intf_rec.source_transaction_date
151: THEN
152: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
153: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
154: l_error_message :=substr(fnd_message.get,1,208);
155: RAISE e_restriction;
156: END IF;
157: OPEN price_obj_ver_cur (inst_intf_rec.instance_id);

Line 154: l_error_message :=substr(fnd_message.get,1,208);

150: IF l_last_update_date > inst_intf_rec.source_transaction_date
151: THEN
152: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
153: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
154: l_error_message :=substr(fnd_message.get,1,208);
155: RAISE e_restriction;
156: END IF;
157: OPEN price_obj_ver_cur (inst_intf_rec.instance_id);
158: FETCH price_obj_ver_cur INTO l_price_object_version,

Line 163: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

159: l_last_update_date;
160: CLOSE price_obj_ver_cur;
161: IF l_last_update_date > inst_intf_rec.source_transaction_date
162: THEN
163: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
164: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
165: l_error_message :=substr(fnd_message.get,1,208);
166: RAISE e_restriction;
167: END IF;

Line 164: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);

160: CLOSE price_obj_ver_cur;
161: IF l_last_update_date > inst_intf_rec.source_transaction_date
162: THEN
163: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
164: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
165: l_error_message :=substr(fnd_message.get,1,208);
166: RAISE e_restriction;
167: END IF;
168:

Line 165: l_error_message :=substr(fnd_message.get,1,208);

161: IF l_last_update_date > inst_intf_rec.source_transaction_date
162: THEN
163: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
164: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
165: l_error_message :=substr(fnd_message.get,1,208);
166: RAISE e_restriction;
167: END IF;
168:
169: SELECT l_miss_num /* DECODE (

Line 1787: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

1783: l_last_update_date ;
1784: CLOSE ip_obj_ver_cur;
1785: IF l_last_update_date > inst_intf_rec.source_transaction_date
1786: THEN
1787: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
1788: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
1789: l_error_message := fnd_message.get;
1790: RAISE e_restriction;
1791: END IF;

Line 1788: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);

1784: CLOSE ip_obj_ver_cur;
1785: IF l_last_update_date > inst_intf_rec.source_transaction_date
1786: THEN
1787: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
1788: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
1789: l_error_message := fnd_message.get;
1790: RAISE e_restriction;
1791: END IF;
1792: SELECT DECODE (

Line 1789: l_error_message := fnd_message.get;

1785: IF l_last_update_date > inst_intf_rec.source_transaction_date
1786: THEN
1787: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
1788: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
1789: l_error_message := fnd_message.get;
1790: RAISE e_restriction;
1791: END IF;
1792: SELECT DECODE (
1793: party_intf_rec.party_source_table,

Line 1985: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

1981: l_last_update_date;
1982: CLOSE ipa_obj_ver_cur;
1983: IF l_last_update_date > inst_intf_rec.source_transaction_date
1984: THEN
1985: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
1986: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
1987: l_error_message := fnd_message.get;
1988: RAISE e_restriction;
1989: END IF;

Line 1986: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);

1982: CLOSE ipa_obj_ver_cur;
1983: IF l_last_update_date > inst_intf_rec.source_transaction_date
1984: THEN
1985: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
1986: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
1987: l_error_message := fnd_message.get;
1988: RAISE e_restriction;
1989: END IF;
1990: x_account_tbl (ptyacc_idx).object_version_number :=

Line 1987: l_error_message := fnd_message.get;

1983: IF l_last_update_date > inst_intf_rec.source_transaction_date
1984: THEN
1985: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
1986: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
1987: l_error_message := fnd_message.get;
1988: RAISE e_restriction;
1989: END IF;
1990: x_account_tbl (ptyacc_idx).object_version_number :=
1991: l_ipa1_object_version;

Line 2165: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

2161: l_last_update_date;
2162: CLOSE ipa_obj_ver_cur;
2163: IF l_last_update_date > inst_intf_rec.source_transaction_date
2164: THEN
2165: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
2166: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
2167: l_error_message := fnd_message.get;
2168: RAISE e_restriction;
2169: END IF;

Line 2166: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);

2162: CLOSE ipa_obj_ver_cur;
2163: IF l_last_update_date > inst_intf_rec.source_transaction_date
2164: THEN
2165: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
2166: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
2167: l_error_message := fnd_message.get;
2168: RAISE e_restriction;
2169: END IF;
2170: x_account_tbl (ptyacc_idx).object_version_number :=

Line 2167: l_error_message := fnd_message.get;

2163: IF l_last_update_date > inst_intf_rec.source_transaction_date
2164: THEN
2165: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
2166: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
2167: l_error_message := fnd_message.get;
2168: RAISE e_restriction;
2169: END IF;
2170: x_account_tbl (ptyacc_idx).object_version_number :=
2171: l_ipa2_object_version;

Line 2345: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

2341: l_last_update_date;
2342: CLOSE ipa_obj_ver_cur;
2343: IF l_last_update_date > inst_intf_rec.source_transaction_date
2344: THEN
2345: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
2346: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
2347: l_error_message := fnd_message.get;
2348: RAISE e_restriction;
2349: END IF;

Line 2346: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);

2342: CLOSE ipa_obj_ver_cur;
2343: IF l_last_update_date > inst_intf_rec.source_transaction_date
2344: THEN
2345: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
2346: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
2347: l_error_message := fnd_message.get;
2348: RAISE e_restriction;
2349: END IF;
2350: x_account_tbl (ptyacc_idx).object_version_number :=

Line 2347: l_error_message := fnd_message.get;

2343: IF l_last_update_date > inst_intf_rec.source_transaction_date
2344: THEN
2345: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
2346: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
2347: l_error_message := fnd_message.get;
2348: RAISE e_restriction;
2349: END IF;
2350: x_account_tbl (ptyacc_idx).object_version_number :=
2351: l_ipa3_object_version;