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;
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;
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:
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);
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;
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);
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,
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;
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:
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 (
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;
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 (
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,
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;
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 :=
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;
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;
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 :=
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;
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;
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 :=
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;