APPS.CSI_UTL_PKG dependencies on FND_MESSAGE

Line 77: fnd_message.set_name('CSI','CSI_INT_INV_INST_PARTY_ID');

73: RETURN l_inst_pty_id;
74:
75: EXCEPTION
76: WHEN no_data_found THEN
77: fnd_message.set_name('CSI','CSI_INT_INV_INST_PARTY_ID');
78: fnd_message.set_token('INSTANCE_ID',p_instance_id);
79: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code );
80: fnd_msg_pub.add;
81: l_inst_pty_id := -1;

Line 78: fnd_message.set_token('INSTANCE_ID',p_instance_id);

74:
75: EXCEPTION
76: WHEN no_data_found THEN
77: fnd_message.set_name('CSI','CSI_INT_INV_INST_PARTY_ID');
78: fnd_message.set_token('INSTANCE_ID',p_instance_id);
79: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code );
80: fnd_msg_pub.add;
81: l_inst_pty_id := -1;
82: RETURN l_inst_pty_id;

Line 79: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code );

75: EXCEPTION
76: WHEN no_data_found THEN
77: fnd_message.set_name('CSI','CSI_INT_INV_INST_PARTY_ID');
78: fnd_message.set_token('INSTANCE_ID',p_instance_id);
79: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code );
80: fnd_msg_pub.add;
81: l_inst_pty_id := -1;
82: RETURN l_inst_pty_id;
83: WHEN others THEN

Line 84: fnd_message.set_name('CSI','CSI_INT_INV_INST_PARTY_ID');

80: fnd_msg_pub.add;
81: l_inst_pty_id := -1;
82: RETURN l_inst_pty_id;
83: WHEN others THEN
84: fnd_message.set_name('CSI','CSI_INT_INV_INST_PARTY_ID');
85: fnd_message.set_token('INSTANCE_ID',p_instance_id);
86: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code );
87: fnd_msg_pub.add;
88: l_inst_pty_id := -1;

Line 85: fnd_message.set_token('INSTANCE_ID',p_instance_id);

81: l_inst_pty_id := -1;
82: RETURN l_inst_pty_id;
83: WHEN others THEN
84: fnd_message.set_name('CSI','CSI_INT_INV_INST_PARTY_ID');
85: fnd_message.set_token('INSTANCE_ID',p_instance_id);
86: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code );
87: fnd_msg_pub.add;
88: l_inst_pty_id := -1;
89: RETURN l_inst_pty_id;

Line 86: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code );

82: RETURN l_inst_pty_id;
83: WHEN others THEN
84: fnd_message.set_name('CSI','CSI_INT_INV_INST_PARTY_ID');
85: fnd_message.set_token('INSTANCE_ID',p_instance_id);
86: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code );
87: fnd_msg_pub.add;
88: l_inst_pty_id := -1;
89: RETURN l_inst_pty_id;
90: END get_curr_party;

Line 108: fnd_message.set_name('CSI','CSI_INT_INV_INST_OU_ID');

104: WHERE instance_ou_id = p_instance_ou_id;
105: RETURN l_obj_ver_num;
106: EXCEPTION
107: WHEN no_data_found THEN
108: fnd_message.set_name('CSI','CSI_INT_INV_INST_OU_ID');
109: fnd_message.set_token('INSTANCE_OU_ID',p_instance_ou_id);
110: fnd_msg_pub.add;
111: l_obj_ver_num := -1;
112: RETURN l_obj_ver_num;

Line 109: fnd_message.set_token('INSTANCE_OU_ID',p_instance_ou_id);

105: RETURN l_obj_ver_num;
106: EXCEPTION
107: WHEN no_data_found THEN
108: fnd_message.set_name('CSI','CSI_INT_INV_INST_OU_ID');
109: fnd_message.set_token('INSTANCE_OU_ID',p_instance_ou_id);
110: fnd_msg_pub.add;
111: l_obj_ver_num := -1;
112: RETURN l_obj_ver_num;
113: WHEN others THEN

Line 114: fnd_message.set_name('CSI','CSI_INT_INV_INST_OU_ID');

110: fnd_msg_pub.add;
111: l_obj_ver_num := -1;
112: RETURN l_obj_ver_num;
113: WHEN others THEN
114: fnd_message.set_name('CSI','CSI_INT_INV_INST_OU_ID');
115: fnd_message.set_token('INSTANCE_OU_ID',p_instance_ou_id);
116: fnd_msg_pub.add;
117: l_obj_ver_num := -1;
118: RETURN l_obj_ver_num;

Line 115: fnd_message.set_token('INSTANCE_OU_ID',p_instance_ou_id);

111: l_obj_ver_num := -1;
112: RETURN l_obj_ver_num;
113: WHEN others THEN
114: fnd_message.set_name('CSI','CSI_INT_INV_INST_OU_ID');
115: fnd_message.set_token('INSTANCE_OU_ID',p_instance_ou_id);
116: fnd_msg_pub.add;
117: l_obj_ver_num := -1;
118: RETURN l_obj_ver_num;
119: END get_org_obj_ver_num;

Line 141: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');

137: RETURN l_obj_ver_num;
138:
139: EXCEPTION
140: WHEN no_data_found THEN
141: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');
142: fnd_message.set_token('RELATIONSHIP_ID',p_relationship_id);
143: fnd_msg_pub.add;
144: l_obj_ver_num := -1;
145: RETURN l_obj_ver_num;

Line 142: fnd_message.set_token('RELATIONSHIP_ID',p_relationship_id);

138:
139: EXCEPTION
140: WHEN no_data_found THEN
141: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');
142: fnd_message.set_token('RELATIONSHIP_ID',p_relationship_id);
143: fnd_msg_pub.add;
144: l_obj_ver_num := -1;
145: RETURN l_obj_ver_num;
146: WHEN others THEN

Line 147: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');

143: fnd_msg_pub.add;
144: l_obj_ver_num := -1;
145: RETURN l_obj_ver_num;
146: WHEN others THEN
147: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');
148: fnd_message.set_token('RELATIONSHIP_ID',p_relationship_id);
149: fnd_msg_pub.add;
150: l_obj_ver_num := -1;
151: RETURN l_obj_ver_num;

Line 148: fnd_message.set_token('RELATIONSHIP_ID',p_relationship_id);

144: l_obj_ver_num := -1;
145: RETURN l_obj_ver_num;
146: WHEN others THEN
147: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');
148: fnd_message.set_token('RELATIONSHIP_ID',p_relationship_id);
149: fnd_msg_pub.add;
150: l_obj_ver_num := -1;
151: RETURN l_obj_ver_num;
152: END get_ii_obj_ver_num;

Line 178: fnd_message.set_name('CSI','CSI_INT_INV_EXT_ATTR_ID');

174: (active_end_date > sysdate));
175:
176: EXCEPTION
177: WHEN no_data_found THEN
178: fnd_message.set_name('CSI','CSI_INT_INV_EXT_ATTR_ID');
179: fnd_message.set_token('INSTANCE_ID',p_instance_id);
180: fnd_message.set_token('ATTRIBUTE_ID',p_attribute_id );
181: fnd_msg_pub.add;
182: x_return_status := fnd_api.g_ret_sts_error;

Line 179: fnd_message.set_token('INSTANCE_ID',p_instance_id);

175:
176: EXCEPTION
177: WHEN no_data_found THEN
178: fnd_message.set_name('CSI','CSI_INT_INV_EXT_ATTR_ID');
179: fnd_message.set_token('INSTANCE_ID',p_instance_id);
180: fnd_message.set_token('ATTRIBUTE_ID',p_attribute_id );
181: fnd_msg_pub.add;
182: x_return_status := fnd_api.g_ret_sts_error;
183: WHEN too_many_rows THEN

Line 180: fnd_message.set_token('ATTRIBUTE_ID',p_attribute_id );

176: EXCEPTION
177: WHEN no_data_found THEN
178: fnd_message.set_name('CSI','CSI_INT_INV_EXT_ATTR_ID');
179: fnd_message.set_token('INSTANCE_ID',p_instance_id);
180: fnd_message.set_token('ATTRIBUTE_ID',p_attribute_id );
181: fnd_msg_pub.add;
182: x_return_status := fnd_api.g_ret_sts_error;
183: WHEN too_many_rows THEN
184: fnd_message.set_name('CSI','CSI_INT_MANY_ATTR_FOUND');

Line 184: fnd_message.set_name('CSI','CSI_INT_MANY_ATTR_FOUND');

180: fnd_message.set_token('ATTRIBUTE_ID',p_attribute_id );
181: fnd_msg_pub.add;
182: x_return_status := fnd_api.g_ret_sts_error;
183: WHEN too_many_rows THEN
184: fnd_message.set_name('CSI','CSI_INT_MANY_ATTR_FOUND');
185: fnd_message.set_token('INSTANCE_ID',p_instance_id);
186: fnd_message.set_token('ATTRIBUTE_ID',p_attribute_id );
187: fnd_msg_pub.add;
188: x_return_status := fnd_api.g_ret_sts_error;

Line 185: fnd_message.set_token('INSTANCE_ID',p_instance_id);

181: fnd_msg_pub.add;
182: x_return_status := fnd_api.g_ret_sts_error;
183: WHEN too_many_rows THEN
184: fnd_message.set_name('CSI','CSI_INT_MANY_ATTR_FOUND');
185: fnd_message.set_token('INSTANCE_ID',p_instance_id);
186: fnd_message.set_token('ATTRIBUTE_ID',p_attribute_id );
187: fnd_msg_pub.add;
188: x_return_status := fnd_api.g_ret_sts_error;
189: END get_ext_attribs;

Line 186: fnd_message.set_token('ATTRIBUTE_ID',p_attribute_id );

182: x_return_status := fnd_api.g_ret_sts_error;
183: WHEN too_many_rows THEN
184: fnd_message.set_name('CSI','CSI_INT_MANY_ATTR_FOUND');
185: fnd_message.set_token('INSTANCE_ID',p_instance_id);
186: fnd_message.set_token('ATTRIBUTE_ID',p_attribute_id );
187: fnd_msg_pub.add;
188: x_return_status := fnd_api.g_ret_sts_error;
189: END get_ext_attribs;
190:

Line 215: fnd_message.set_name('CSI','CSI_INT_INV_OU_ID');

211: AND ((active_end_date is null ) OR
212: (active_end_date > sysdate));
213: EXCEPTION
214: WHEN no_data_found THEN
215: fnd_message.set_name('CSI','CSI_INT_INV_OU_ID');
216: fnd_message.set_token('INSTANCE_ID',p_instance_id);
217: fnd_message.set_token('OPERATING_UNIT_ID',p_operating_unit_id);
218: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
219: fnd_msg_pub.add;

Line 216: fnd_message.set_token('INSTANCE_ID',p_instance_id);

212: (active_end_date > sysdate));
213: EXCEPTION
214: WHEN no_data_found THEN
215: fnd_message.set_name('CSI','CSI_INT_INV_OU_ID');
216: fnd_message.set_token('INSTANCE_ID',p_instance_id);
217: fnd_message.set_token('OPERATING_UNIT_ID',p_operating_unit_id);
218: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
219: fnd_msg_pub.add;
220: x_return_status := fnd_api.g_ret_sts_error;

Line 217: fnd_message.set_token('OPERATING_UNIT_ID',p_operating_unit_id);

213: EXCEPTION
214: WHEN no_data_found THEN
215: fnd_message.set_name('CSI','CSI_INT_INV_OU_ID');
216: fnd_message.set_token('INSTANCE_ID',p_instance_id);
217: fnd_message.set_token('OPERATING_UNIT_ID',p_operating_unit_id);
218: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
219: fnd_msg_pub.add;
220: x_return_status := fnd_api.g_ret_sts_error;
221: WHEN too_many_rows THEN

Line 218: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);

214: WHEN no_data_found THEN
215: fnd_message.set_name('CSI','CSI_INT_INV_OU_ID');
216: fnd_message.set_token('INSTANCE_ID',p_instance_id);
217: fnd_message.set_token('OPERATING_UNIT_ID',p_operating_unit_id);
218: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
219: fnd_msg_pub.add;
220: x_return_status := fnd_api.g_ret_sts_error;
221: WHEN too_many_rows THEN
222: fnd_message.set_name('CSI','CSI_INT_MANY_OU_FOUND');

Line 222: fnd_message.set_name('CSI','CSI_INT_MANY_OU_FOUND');

218: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
219: fnd_msg_pub.add;
220: x_return_status := fnd_api.g_ret_sts_error;
221: WHEN too_many_rows THEN
222: fnd_message.set_name('CSI','CSI_INT_MANY_OU_FOUND');
223: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_id);
224: fnd_message.set_token('OPERATING_UNIT_ID',p_operating_unit_id);
225: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
226: fnd_msg_pub.add;

Line 223: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_id);

219: fnd_msg_pub.add;
220: x_return_status := fnd_api.g_ret_sts_error;
221: WHEN too_many_rows THEN
222: fnd_message.set_name('CSI','CSI_INT_MANY_OU_FOUND');
223: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_id);
224: fnd_message.set_token('OPERATING_UNIT_ID',p_operating_unit_id);
225: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
226: fnd_msg_pub.add;
227: x_return_status := fnd_api.g_ret_sts_error;

Line 224: fnd_message.set_token('OPERATING_UNIT_ID',p_operating_unit_id);

220: x_return_status := fnd_api.g_ret_sts_error;
221: WHEN too_many_rows THEN
222: fnd_message.set_name('CSI','CSI_INT_MANY_OU_FOUND');
223: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_id);
224: fnd_message.set_token('OPERATING_UNIT_ID',p_operating_unit_id);
225: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
226: fnd_msg_pub.add;
227: x_return_status := fnd_api.g_ret_sts_error;
228: END get_org_assign;

Line 225: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);

221: WHEN too_many_rows THEN
222: fnd_message.set_name('CSI','CSI_INT_MANY_OU_FOUND');
223: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_id);
224: fnd_message.set_token('OPERATING_UNIT_ID',p_operating_unit_id);
225: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
226: fnd_msg_pub.add;
227: x_return_status := fnd_api.g_ret_sts_error;
228: END get_org_assign;
229:

Line 254: fnd_message.set_name('CSI','CSI_INT_INV_ACCT_ID');

250: (active_end_date > sysdate));
251:
252: EXCEPTION
253: WHEN no_data_found THEN
254: fnd_message.set_name('CSI','CSI_INT_INV_ACCT_ID');
255: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_pty_id);
256: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
257: fnd_msg_pub.add;
258: x_return_status := fnd_api.g_ret_sts_error;

Line 255: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_pty_id);

251:
252: EXCEPTION
253: WHEN no_data_found THEN
254: fnd_message.set_name('CSI','CSI_INT_INV_ACCT_ID');
255: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_pty_id);
256: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
257: fnd_msg_pub.add;
258: x_return_status := fnd_api.g_ret_sts_error;
259: WHEN too_many_rows THEN

Line 256: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);

252: EXCEPTION
253: WHEN no_data_found THEN
254: fnd_message.set_name('CSI','CSI_INT_INV_ACCT_ID');
255: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_pty_id);
256: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
257: fnd_msg_pub.add;
258: x_return_status := fnd_api.g_ret_sts_error;
259: WHEN too_many_rows THEN
260: fnd_message.set_name('CSI','CSI_INT_MANY_ACCT_FOUND');

Line 260: fnd_message.set_name('CSI','CSI_INT_MANY_ACCT_FOUND');

256: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
257: fnd_msg_pub.add;
258: x_return_status := fnd_api.g_ret_sts_error;
259: WHEN too_many_rows THEN
260: fnd_message.set_name('CSI','CSI_INT_MANY_ACCT_FOUND');
261: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_pty_id);
262: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
263: fnd_msg_pub.add;
264: x_return_status := fnd_api.g_ret_sts_error;

Line 261: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_pty_id);

257: fnd_msg_pub.add;
258: x_return_status := fnd_api.g_ret_sts_error;
259: WHEN too_many_rows THEN
260: fnd_message.set_name('CSI','CSI_INT_MANY_ACCT_FOUND');
261: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_pty_id);
262: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
263: fnd_msg_pub.add;
264: x_return_status := fnd_api.g_ret_sts_error;
265: END get_party_account;

Line 262: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);

258: x_return_status := fnd_api.g_ret_sts_error;
259: WHEN too_many_rows THEN
260: fnd_message.set_name('CSI','CSI_INT_MANY_ACCT_FOUND');
261: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_pty_id);
262: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
263: fnd_msg_pub.add;
264: x_return_status := fnd_api.g_ret_sts_error;
265: END get_party_account;
266:

Line 293: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');

289:
290:
291: EXCEPTION
292: WHEN no_data_found THEN
293: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
294: fnd_message.set_token('INSTANCE_ID',p_instance_id);
295: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
296: fnd_msg_pub.add;
297: x_return_status := fnd_api.g_ret_sts_error;

Line 294: fnd_message.set_token('INSTANCE_ID',p_instance_id);

290:
291: EXCEPTION
292: WHEN no_data_found THEN
293: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
294: fnd_message.set_token('INSTANCE_ID',p_instance_id);
295: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
296: fnd_msg_pub.add;
297: x_return_status := fnd_api.g_ret_sts_error;
298: WHEN too_many_rows THEN

Line 295: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);

291: EXCEPTION
292: WHEN no_data_found THEN
293: fnd_message.set_name('CSI','CSI_INT_INV_INSTA_PTY_ID');
294: fnd_message.set_token('INSTANCE_ID',p_instance_id);
295: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
296: fnd_msg_pub.add;
297: x_return_status := fnd_api.g_ret_sts_error;
298: WHEN too_many_rows THEN
299: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');

Line 299: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');

295: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
296: fnd_msg_pub.add;
297: x_return_status := fnd_api.g_ret_sts_error;
298: WHEN too_many_rows THEN
299: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
300: fnd_message.set_token('INSTANCE_ID',p_instance_id);
301: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
302: fnd_msg_pub.add;
303: x_return_status := fnd_api.g_ret_sts_error;

Line 300: fnd_message.set_token('INSTANCE_ID',p_instance_id);

296: fnd_msg_pub.add;
297: x_return_status := fnd_api.g_ret_sts_error;
298: WHEN too_many_rows THEN
299: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
300: fnd_message.set_token('INSTANCE_ID',p_instance_id);
301: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
302: fnd_msg_pub.add;
303: x_return_status := fnd_api.g_ret_sts_error;
304:

Line 301: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);

297: x_return_status := fnd_api.g_ret_sts_error;
298: WHEN too_many_rows THEN
299: fnd_message.set_name('CSI','CSI_INT_MANY_INSTA_PTY_FOUND');
300: fnd_message.set_token('INSTANCE_ID',p_instance_id);
301: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',p_rel_type_code);
302: fnd_msg_pub.add;
303: x_return_status := fnd_api.g_ret_sts_error;
304:
305: END get_instance_party;

Line 332: fnd_message.set_name('CSI','CSI_INT_INV_INST_ID');

328: -- (active_end_date > sysdate));
329:
330: EXCEPTION
331: WHEN no_data_found THEN
332: fnd_message.set_name('CSI','CSI_INT_INV_INST_ID');
333: fnd_message.set_token('INSTANCE_ID',p_instance_id);
334: fnd_msg_pub.add;
335: x_return_status := fnd_api.g_ret_sts_error;
336: END get_instance;

Line 333: fnd_message.set_token('INSTANCE_ID',p_instance_id);

329:
330: EXCEPTION
331: WHEN no_data_found THEN
332: fnd_message.set_name('CSI','CSI_INT_INV_INST_ID');
333: fnd_message.set_token('INSTANCE_ID',p_instance_id);
334: fnd_msg_pub.add;
335: x_return_status := fnd_api.g_ret_sts_error;
336: END get_instance;
337:

Line 356: fnd_message.set_name('CSI','CSI_INT_INV_ATTR_VALUE_ID');

352: (active_end_date > sysdate));
353: RETURN l_obj_ver_num;
354: EXCEPTION
355: WHEN no_data_found THEN
356: fnd_message.set_name('CSI','CSI_INT_INV_ATTR_VALUE_ID');
357: fnd_message.set_token('ATTRIBUTE_VALUE_ID',p_attrib_value_id);
358: fnd_msg_pub.add;
359: l_obj_ver_num := -1;
360: RETURN l_obj_ver_num;

Line 357: fnd_message.set_token('ATTRIBUTE_VALUE_ID',p_attrib_value_id);

353: RETURN l_obj_ver_num;
354: EXCEPTION
355: WHEN no_data_found THEN
356: fnd_message.set_name('CSI','CSI_INT_INV_ATTR_VALUE_ID');
357: fnd_message.set_token('ATTRIBUTE_VALUE_ID',p_attrib_value_id);
358: fnd_msg_pub.add;
359: l_obj_ver_num := -1;
360: RETURN l_obj_ver_num;
361: END get_ext_obj_ver_num;

Line 381: fnd_message.set_name('CSI','CSI_INT_INST_PTY_MISSING');

377: (active_end_date > sysdate));
378: RETURN l_obj_ver_num;
379: EXCEPTION
380: WHEN no_data_found THEN
381: fnd_message.set_name('CSI','CSI_INT_INST_PTY_MISSING');
382: fnd_message.set_token('INSTANCE_PARTY_ID',p_inst_pty_id);
383: fnd_msg_pub.add;
384: l_obj_ver_num := -1;
385: RETURN l_obj_ver_num;

Line 382: fnd_message.set_token('INSTANCE_PARTY_ID',p_inst_pty_id);

378: RETURN l_obj_ver_num;
379: EXCEPTION
380: WHEN no_data_found THEN
381: fnd_message.set_name('CSI','CSI_INT_INST_PTY_MISSING');
382: fnd_message.set_token('INSTANCE_PARTY_ID',p_inst_pty_id);
383: fnd_msg_pub.add;
384: l_obj_ver_num := -1;
385: RETURN l_obj_ver_num;
386: END get_pty_obj_ver_num;

Line 405: fnd_message.set_name('CSI','CSI_INT_INV_IP_ACCT_ID');

401: (active_end_date > sysdate));
402: RETURN l_obj_ver_num;
403: EXCEPTION
404: WHEN no_data_found THEN
405: fnd_message.set_name('CSI','CSI_INT_INV_IP_ACCT_ID');
406: fnd_message.set_token('IP_ACCOUNT_ID',p_ip_acct_id);
407: fnd_msg_pub.add;
408: l_obj_ver_num := -1;
409: RETURN l_obj_ver_num;

Line 406: fnd_message.set_token('IP_ACCOUNT_ID',p_ip_acct_id);

402: RETURN l_obj_ver_num;
403: EXCEPTION
404: WHEN no_data_found THEN
405: fnd_message.set_name('CSI','CSI_INT_INV_IP_ACCT_ID');
406: fnd_message.set_token('IP_ACCOUNT_ID',p_ip_acct_id);
407: fnd_msg_pub.add;
408: l_obj_ver_num := -1;
409: RETURN l_obj_ver_num;
410: WHEN others THEN

Line 411: fnd_message.set_name('CSI','CSI_INT_INV_IP_ACCT_ID');

407: fnd_msg_pub.add;
408: l_obj_ver_num := -1;
409: RETURN l_obj_ver_num;
410: WHEN others THEN
411: fnd_message.set_name('CSI','CSI_INT_INV_IP_ACCT_ID');
412: fnd_message.set_token('IP_ACCOUNT_ID',p_ip_acct_id);
413: fnd_msg_pub.add;
414: l_obj_ver_num := -1;
415: RETURN l_obj_ver_num;

Line 412: fnd_message.set_token('IP_ACCOUNT_ID',p_ip_acct_id);

408: l_obj_ver_num := -1;
409: RETURN l_obj_ver_num;
410: WHEN others THEN
411: fnd_message.set_name('CSI','CSI_INT_INV_IP_ACCT_ID');
412: fnd_message.set_token('IP_ACCOUNT_ID',p_ip_acct_id);
413: fnd_msg_pub.add;
414: l_obj_ver_num := -1;
415: RETURN l_obj_ver_num;
416: END get_acct_obj_ver_num;

Line 440: fnd_message.set_name('CSI', 'CSI_DFLT_SUB_TYPE_MISSING');

436:
437: EXCEPTION
438:
439: WHEN no_data_found THEN
440: fnd_message.set_name('CSI', 'CSI_DFLT_SUB_TYPE_MISSING');
441: fnd_message.set_token('TXN_TYPE_ID', p_transaction_type_id);
442: fnd_msg_pub.add;
443: x_return_status := fnd_api.g_ret_sts_error;
444: WHEN too_many_rows THEN

Line 441: fnd_message.set_token('TXN_TYPE_ID', p_transaction_type_id);

437: EXCEPTION
438:
439: WHEN no_data_found THEN
440: fnd_message.set_name('CSI', 'CSI_DFLT_SUB_TYPE_MISSING');
441: fnd_message.set_token('TXN_TYPE_ID', p_transaction_type_id);
442: fnd_msg_pub.add;
443: x_return_status := fnd_api.g_ret_sts_error;
444: WHEN too_many_rows THEN
445: fnd_message.set_name('CSI', 'CSI_MANY_DFLT_SUB_TYPES');

Line 445: fnd_message.set_name('CSI', 'CSI_MANY_DFLT_SUB_TYPES');

441: fnd_message.set_token('TXN_TYPE_ID', p_transaction_type_id);
442: fnd_msg_pub.add;
443: x_return_status := fnd_api.g_ret_sts_error;
444: WHEN too_many_rows THEN
445: fnd_message.set_name('CSI', 'CSI_MANY_DFLT_SUB_TYPES');
446: fnd_message.set_token('TXN_TYPE_ID', p_transaction_type_id);
447: fnd_msg_pub.add;
448: x_return_status := fnd_api.g_ret_sts_error;
449: END get_dflt_sub_type_id;

Line 446: fnd_message.set_token('TXN_TYPE_ID', p_transaction_type_id);

442: fnd_msg_pub.add;
443: x_return_status := fnd_api.g_ret_sts_error;
444: WHEN too_many_rows THEN
445: fnd_message.set_name('CSI', 'CSI_MANY_DFLT_SUB_TYPES');
446: fnd_message.set_token('TXN_TYPE_ID', p_transaction_type_id);
447: fnd_msg_pub.add;
448: x_return_status := fnd_api.g_ret_sts_error;
449: END get_dflt_sub_type_id;
450:

Line 469: fnd_message.set_name('CSI','CSI_API_INVALID_STATUS_ID');

465: WHERE name = l_status_name;
466:
467: EXCEPTION
468: WHEN no_data_found THEN
469: fnd_message.set_name('CSI','CSI_API_INVALID_STATUS_ID');
470: fnd_message.set_token('INSTANCE_STATUS', l_status_name);
471: fnd_msg_pub.add;
472: x_return_status := fnd_api.g_ret_sts_error;
473: WHEN too_many_rows THEN

Line 470: fnd_message.set_token('INSTANCE_STATUS', l_status_name);

466:
467: EXCEPTION
468: WHEN no_data_found THEN
469: fnd_message.set_name('CSI','CSI_API_INVALID_STATUS_ID');
470: fnd_message.set_token('INSTANCE_STATUS', l_status_name);
471: fnd_msg_pub.add;
472: x_return_status := fnd_api.g_ret_sts_error;
473: WHEN too_many_rows THEN
474: fnd_message.set_name('CSI','CSI_API_INVALID_STATUS_ID');

Line 474: fnd_message.set_name('CSI','CSI_API_INVALID_STATUS_ID');

470: fnd_message.set_token('INSTANCE_STATUS', l_status_name);
471: fnd_msg_pub.add;
472: x_return_status := fnd_api.g_ret_sts_error;
473: WHEN too_many_rows THEN
474: fnd_message.set_name('CSI','CSI_API_INVALID_STATUS_ID');
475: fnd_message.set_token('INSTANCE_STATUS', l_status_name);
476: fnd_msg_pub.add;
477: x_return_status := fnd_api.g_ret_sts_error;
478: END get_dflt_inst_status_id;

Line 475: fnd_message.set_token('INSTANCE_STATUS', l_status_name);

471: fnd_msg_pub.add;
472: x_return_status := fnd_api.g_ret_sts_error;
473: WHEN too_many_rows THEN
474: fnd_message.set_name('CSI','CSI_API_INVALID_STATUS_ID');
475: fnd_message.set_token('INSTANCE_STATUS', l_status_name);
476: fnd_msg_pub.add;
477: x_return_status := fnd_api.g_ret_sts_error;
478: END get_dflt_inst_status_id;
479:

Line 500: fnd_message.set_name('CSI','CSI_INT_INV_ITEM_ID');

496: RETURN l_uom_code;
497:
498: EXCEPTION
499: WHEN no_data_found THEN
500: fnd_message.set_name('CSI','CSI_INT_INV_ITEM_ID');
501: fnd_message.set_token('INVENTORY_ITEM_ID',p_inv_item_id);
502: fnd_message.set_token('INV_ORGANIZATION_ID',p_inv_org_id);
503: fnd_msg_pub.add;
504: l_uom_code := '';

Line 501: fnd_message.set_token('INVENTORY_ITEM_ID',p_inv_item_id);

497:
498: EXCEPTION
499: WHEN no_data_found THEN
500: fnd_message.set_name('CSI','CSI_INT_INV_ITEM_ID');
501: fnd_message.set_token('INVENTORY_ITEM_ID',p_inv_item_id);
502: fnd_message.set_token('INV_ORGANIZATION_ID',p_inv_org_id);
503: fnd_msg_pub.add;
504: l_uom_code := '';
505: RETURN l_uom_code;

Line 502: fnd_message.set_token('INV_ORGANIZATION_ID',p_inv_org_id);

498: EXCEPTION
499: WHEN no_data_found THEN
500: fnd_message.set_name('CSI','CSI_INT_INV_ITEM_ID');
501: fnd_message.set_token('INVENTORY_ITEM_ID',p_inv_item_id);
502: fnd_message.set_token('INV_ORGANIZATION_ID',p_inv_org_id);
503: fnd_msg_pub.add;
504: l_uom_code := '';
505: RETURN l_uom_code;
506: END get_primay_uom;

Line 877: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');

873: WHERE c.cust_acct_site_id = u.cust_acct_site_id
874: AND u.site_use_id = p_order_shipment_rec.ib_current_loc_id; -- ship_to_org_id;
875: EXCEPTION
876: WHEN no_data_found THEN
877: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
878: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_current_loc_id); -- ship_to_org_id);
879: fnd_msg_pub.add;
880: RAISE fnd_api.g_exc_error;
881: WHEN too_many_rows THEN

Line 878: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_current_loc_id); -- ship_to_org_id);

874: AND u.site_use_id = p_order_shipment_rec.ib_current_loc_id; -- ship_to_org_id;
875: EXCEPTION
876: WHEN no_data_found THEN
877: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
878: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_current_loc_id); -- ship_to_org_id);
879: fnd_msg_pub.add;
880: RAISE fnd_api.g_exc_error;
881: WHEN too_many_rows THEN
882: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

Line 882: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

878: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_current_loc_id); -- ship_to_org_id);
879: fnd_msg_pub.add;
880: RAISE fnd_api.g_exc_error;
881: WHEN too_many_rows THEN
882: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
883: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_current_loc_id); -- ship_to_org_id);
884: fnd_msg_pub.add;
885: RAISE fnd_api.g_exc_error;
886: END ;

Line 883: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_current_loc_id); -- ship_to_org_id);

879: fnd_msg_pub.add;
880: RAISE fnd_api.g_exc_error;
881: WHEN too_many_rows THEN
882: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
883: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_current_loc_id); -- ship_to_org_id);
884: fnd_msg_pub.add;
885: RAISE fnd_api.g_exc_error;
886: END ;
887:

Line 903: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');

899: WHERE c.cust_acct_site_id = u.cust_acct_site_id
900: AND u.site_use_id = p_order_shipment_rec.ib_install_loc_id; -- ship_to_org_id;
901: Exception
902: When no_data_found then
903: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
904: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_install_loc_id); -- ship_to_org_id);
905: fnd_msg_pub.add;
906: debug('Party_site_id not found');
907: raise fnd_api.g_exc_error;

Line 904: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_install_loc_id); -- ship_to_org_id);

900: AND u.site_use_id = p_order_shipment_rec.ib_install_loc_id; -- ship_to_org_id;
901: Exception
902: When no_data_found then
903: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
904: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_install_loc_id); -- ship_to_org_id);
905: fnd_msg_pub.add;
906: debug('Party_site_id not found');
907: raise fnd_api.g_exc_error;
908: when too_many_rows then

Line 909: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

905: fnd_msg_pub.add;
906: debug('Party_site_id not found');
907: raise fnd_api.g_exc_error;
908: when too_many_rows then
909: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
910: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_install_loc_id); -- ship_to_org_id);
911: fnd_msg_pub.add;
912: debug('Party_site_id not found');
913: raise fnd_api.g_exc_error;

Line 910: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_install_loc_id); -- ship_to_org_id);

906: debug('Party_site_id not found');
907: raise fnd_api.g_exc_error;
908: when too_many_rows then
909: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
910: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ib_install_loc_id); -- ship_to_org_id);
911: fnd_msg_pub.add;
912: debug('Party_site_id not found');
913: raise fnd_api.g_exc_error;
914: end ;

Line 1076: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');

1072: WHERE c.cust_acct_site_id = u.cust_acct_site_id
1073: AND u.site_use_id = p_order_shipment_rec.ship_to_org_id;
1074: EXCEPTION
1075: WHEN no_data_found then
1076: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
1077: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ship_to_org_id);
1078: fnd_msg_pub.add;
1079: RAISE fnd_api.g_exc_error;
1080: WHEN too_many_rows then

Line 1077: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ship_to_org_id);

1073: AND u.site_use_id = p_order_shipment_rec.ship_to_org_id;
1074: EXCEPTION
1075: WHEN no_data_found then
1076: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
1077: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ship_to_org_id);
1078: fnd_msg_pub.add;
1079: RAISE fnd_api.g_exc_error;
1080: WHEN too_many_rows then
1081: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

Line 1081: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

1077: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ship_to_org_id);
1078: fnd_msg_pub.add;
1079: RAISE fnd_api.g_exc_error;
1080: WHEN too_many_rows then
1081: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
1082: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ship_to_org_id);
1083: fnd_msg_pub.add;
1084: RAISE fnd_api.g_exc_error;
1085: END;

Line 1082: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ship_to_org_id);

1078: fnd_msg_pub.add;
1079: RAISE fnd_api.g_exc_error;
1080: WHEN too_many_rows then
1081: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
1082: fnd_message.set_token('LOCATION_ID', p_order_shipment_rec.ship_to_org_id);
1083: fnd_msg_pub.add;
1084: RAISE fnd_api.g_exc_error;
1085: END;
1086:

Line 1227: fnd_message.set_name('CSI','CSI_INT_INV_CUST_ACCT_ID');

1223: END IF;
1224:
1225: EXCEPTION
1226: WHEN no_data_found THEN
1227: fnd_message.set_name('CSI','CSI_INT_INV_CUST_ACCT_ID');
1228: fnd_message.set_token('CUST_ACCOUNT_ID', p_cust_acct_id);
1229: fnd_msg_pub.add;
1230: RAISE fnd_api.g_exc_error;
1231: END;

Line 1228: fnd_message.set_token('CUST_ACCOUNT_ID', p_cust_acct_id);

1224:
1225: EXCEPTION
1226: WHEN no_data_found THEN
1227: fnd_message.set_name('CSI','CSI_INT_INV_CUST_ACCT_ID');
1228: fnd_message.set_token('CUST_ACCOUNT_ID', p_cust_acct_id);
1229: fnd_msg_pub.add;
1230: RAISE fnd_api.g_exc_error;
1231: END;
1232:

Line 1264: fnd_message.set_name('CSI','CSI_INT_INV_INST_PTY_ID');

1260: RETURN l_ret_status;
1261:
1262: EXCEPTION
1263: WHEN others THEN
1264: fnd_message.set_name('CSI','CSI_INT_INV_INST_PTY_ID');
1265: fnd_message.set_token('INSTANCE_ID', p_instance_id);
1266: fnd_message.set_token('INSTANCE_PARTY_ID', p_inst_party_id);
1267: fnd_message.set_token('RELATIONSHIP_TYPE_CODE', p_inst_party_id);
1268: fnd_msg_pub.add;

Line 1265: fnd_message.set_token('INSTANCE_ID', p_instance_id);

1261:
1262: EXCEPTION
1263: WHEN others THEN
1264: fnd_message.set_name('CSI','CSI_INT_INV_INST_PTY_ID');
1265: fnd_message.set_token('INSTANCE_ID', p_instance_id);
1266: fnd_message.set_token('INSTANCE_PARTY_ID', p_inst_party_id);
1267: fnd_message.set_token('RELATIONSHIP_TYPE_CODE', p_inst_party_id);
1268: fnd_msg_pub.add;
1269: RETURN l_ret_status;

Line 1266: fnd_message.set_token('INSTANCE_PARTY_ID', p_inst_party_id);

1262: EXCEPTION
1263: WHEN others THEN
1264: fnd_message.set_name('CSI','CSI_INT_INV_INST_PTY_ID');
1265: fnd_message.set_token('INSTANCE_ID', p_instance_id);
1266: fnd_message.set_token('INSTANCE_PARTY_ID', p_inst_party_id);
1267: fnd_message.set_token('RELATIONSHIP_TYPE_CODE', p_inst_party_id);
1268: fnd_msg_pub.add;
1269: RETURN l_ret_status;
1270: END validate_inst_party;

Line 1267: fnd_message.set_token('RELATIONSHIP_TYPE_CODE', p_inst_party_id);

1263: WHEN others THEN
1264: fnd_message.set_name('CSI','CSI_INT_INV_INST_PTY_ID');
1265: fnd_message.set_token('INSTANCE_ID', p_instance_id);
1266: fnd_message.set_token('INSTANCE_PARTY_ID', p_inst_party_id);
1267: fnd_message.set_token('RELATIONSHIP_TYPE_CODE', p_inst_party_id);
1268: fnd_msg_pub.add;
1269: RETURN l_ret_status;
1270: END validate_inst_party;
1271:

Line 1288: fnd_message.set_name('CSI','CSI_INT_INV_ORD_LINE_ID');

1284:
1285: RETURN l_inst_id;
1286: EXCEPTION
1287: WHEN no_data_found THEN
1288: fnd_message.set_name('CSI','CSI_INT_INV_ORD_LINE_ID');
1289: fnd_message.set_token('ORDER_LINE_ID', p_order_line_id);
1290: fnd_msg_pub.add;
1291: l_inst_id := -1;
1292: RETURN l_inst_id;

Line 1289: fnd_message.set_token('ORDER_LINE_ID', p_order_line_id);

1285: RETURN l_inst_id;
1286: EXCEPTION
1287: WHEN no_data_found THEN
1288: fnd_message.set_name('CSI','CSI_INT_INV_ORD_LINE_ID');
1289: fnd_message.set_token('ORDER_LINE_ID', p_order_line_id);
1290: fnd_msg_pub.add;
1291: l_inst_id := -1;
1292: RETURN l_inst_id;
1293: WHEN others THEN

Line 1294: fnd_message.set_name('CSI','CSI_INT_INV_ORD_LINE_ID');

1290: fnd_msg_pub.add;
1291: l_inst_id := -1;
1292: RETURN l_inst_id;
1293: WHEN others THEN
1294: fnd_message.set_name('CSI','CSI_INT_INV_ORD_LINE_ID');
1295: fnd_message.set_token('ORDER_LINE_ID', p_order_line_id);
1296: fnd_msg_pub.add;
1297: l_inst_id := -1;
1298: RETURN l_inst_id;

Line 1295: fnd_message.set_token('ORDER_LINE_ID', p_order_line_id);

1291: l_inst_id := -1;
1292: RETURN l_inst_id;
1293: WHEN others THEN
1294: fnd_message.set_name('CSI','CSI_INT_INV_ORD_LINE_ID');
1295: fnd_message.set_token('ORDER_LINE_ID', p_order_line_id);
1296: fnd_msg_pub.add;
1297: l_inst_id := -1;
1298: RETURN l_inst_id;
1299: END get_instance;

Line 1346: fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');

1342: RETURN l_inst_party_id;
1343:
1344: EXCEPTION
1345: WHEN no_data_found THEN
1346: fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
1347: fnd_message.set_token('INSTANCE_ID',p_instance_id);
1348: fnd_msg_pub.add;
1349: l_inst_party_id := -1;
1350: RETURN l_inst_party_id;

Line 1347: fnd_message.set_token('INSTANCE_ID',p_instance_id);

1343:
1344: EXCEPTION
1345: WHEN no_data_found THEN
1346: fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
1347: fnd_message.set_token('INSTANCE_ID',p_instance_id);
1348: fnd_msg_pub.add;
1349: l_inst_party_id := -1;
1350: RETURN l_inst_party_id;
1351: -- Added for 3185043

Line 1353: fnd_message.set_name('CSI','CSI_MANY_INST_OWNER_FOUND');

1349: l_inst_party_id := -1;
1350: RETURN l_inst_party_id;
1351: -- Added for 3185043
1352: WHEN too_many_rows THEN
1353: fnd_message.set_name('CSI','CSI_MANY_INST_OWNER_FOUND');
1354: fnd_message.set_token('INSTANCE_ID',p_instance_id);
1355: fnd_msg_pub.add;
1356: l_inst_party_id := -1;
1357: RETURN l_inst_party_id;

Line 1354: fnd_message.set_token('INSTANCE_ID',p_instance_id);

1350: RETURN l_inst_party_id;
1351: -- Added for 3185043
1352: WHEN too_many_rows THEN
1353: fnd_message.set_name('CSI','CSI_MANY_INST_OWNER_FOUND');
1354: fnd_message.set_token('INSTANCE_ID',p_instance_id);
1355: fnd_msg_pub.add;
1356: l_inst_party_id := -1;
1357: RETURN l_inst_party_id;
1358: WHEN others THEN

Line 1359: -- fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');

1355: fnd_msg_pub.add;
1356: l_inst_party_id := -1;
1357: RETURN l_inst_party_id;
1358: WHEN others THEN
1359: -- fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
1360: -- fnd_message.set_token('INSTANCE_ID',p_instance_id);
1361: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
1362: fnd_message.set_token('SQL_ERROR',SQLERRM);
1363: fnd_msg_pub.add;

Line 1360: -- fnd_message.set_token('INSTANCE_ID',p_instance_id);

1356: l_inst_party_id := -1;
1357: RETURN l_inst_party_id;
1358: WHEN others THEN
1359: -- fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
1360: -- fnd_message.set_token('INSTANCE_ID',p_instance_id);
1361: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
1362: fnd_message.set_token('SQL_ERROR',SQLERRM);
1363: fnd_msg_pub.add;
1364: l_inst_party_id := -1;

Line 1361: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');

1357: RETURN l_inst_party_id;
1358: WHEN others THEN
1359: -- fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
1360: -- fnd_message.set_token('INSTANCE_ID',p_instance_id);
1361: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
1362: fnd_message.set_token('SQL_ERROR',SQLERRM);
1363: fnd_msg_pub.add;
1364: l_inst_party_id := -1;
1365: RETURN l_inst_party_id;

Line 1362: fnd_message.set_token('SQL_ERROR',SQLERRM);

1358: WHEN others THEN
1359: -- fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
1360: -- fnd_message.set_token('INSTANCE_ID',p_instance_id);
1361: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
1362: fnd_message.set_token('SQL_ERROR',SQLERRM);
1363: fnd_msg_pub.add;
1364: l_inst_party_id := -1;
1365: RETURN l_inst_party_id;
1366: END get_instance_party_id;

Line 1386: fnd_message.set_name('CSI','CSI_INT_INV_TRX_LINE_ID');

1382: RETURN l_trx_type_id;
1383:
1384: exception
1385: when others then
1386: fnd_message.set_name('CSI','CSI_INT_INV_TRX_LINE_ID');
1387: fnd_message.set_token('TRX_LINE_ID',p_trx_line_id);
1388: fnd_msg_pub.add;
1389: l_trx_type_id := -1;
1390: RETURN l_trx_type_id;

Line 1387: fnd_message.set_token('TRX_LINE_ID',p_trx_line_id);

1383:
1384: exception
1385: when others then
1386: fnd_message.set_name('CSI','CSI_INT_INV_TRX_LINE_ID');
1387: fnd_message.set_token('TRX_LINE_ID',p_trx_line_id);
1388: fnd_msg_pub.add;
1389: l_trx_type_id := -1;
1390: RETURN l_trx_type_id;
1391:

Line 1413: fnd_message.set_name('CSI','CSI_INT_INV_SRC_TRX_ID');

1409: AND source_transaction_table = p_src_table_name;
1410: RETURN l_trx_line_id;
1411: exception
1412: when others then
1413: fnd_message.set_name('CSI','CSI_INT_INV_SRC_TRX_ID');
1414: fnd_message.set_token('SOURCE_TRANSACTION_ID',p_src_trx_id);
1415: fnd_message.set_token('SOURCE_TRANSACTION_TABLE',p_src_table_name);
1416: fnd_msg_pub.add;
1417: l_trx_line_id := -1;

Line 1414: fnd_message.set_token('SOURCE_TRANSACTION_ID',p_src_trx_id);

1410: RETURN l_trx_line_id;
1411: exception
1412: when others then
1413: fnd_message.set_name('CSI','CSI_INT_INV_SRC_TRX_ID');
1414: fnd_message.set_token('SOURCE_TRANSACTION_ID',p_src_trx_id);
1415: fnd_message.set_token('SOURCE_TRANSACTION_TABLE',p_src_table_name);
1416: fnd_msg_pub.add;
1417: l_trx_line_id := -1;
1418: RETURN l_trx_line_id;

Line 1415: fnd_message.set_token('SOURCE_TRANSACTION_TABLE',p_src_table_name);

1411: exception
1412: when others then
1413: fnd_message.set_name('CSI','CSI_INT_INV_SRC_TRX_ID');
1414: fnd_message.set_token('SOURCE_TRANSACTION_ID',p_src_trx_id);
1415: fnd_message.set_token('SOURCE_TRANSACTION_TABLE',p_src_table_name);
1416: fnd_msg_pub.add;
1417: l_trx_line_id := -1;
1418: RETURN l_trx_line_id;
1419: END Get_trx_line_id;

Line 1442: fnd_message.set_name('CSI','CSI_INT_OWNER_ACCT_MISSING');

1438: OR (active_end_date >= sysdate));
1439: RETURN l_ip_acct_id;
1440: exception
1441: when others then
1442: fnd_message.set_name('CSI','CSI_INT_OWNER_ACCT_MISSING');
1443: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_party_id);
1444: fnd_msg_pub.add;
1445: l_ip_acct_id := -1;
1446: RETURN l_ip_acct_id;

Line 1443: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_party_id);

1439: RETURN l_ip_acct_id;
1440: exception
1441: when others then
1442: fnd_message.set_name('CSI','CSI_INT_OWNER_ACCT_MISSING');
1443: fnd_message.set_token('INSTANCE_PARTY_ID',p_instance_party_id);
1444: fnd_msg_pub.add;
1445: l_ip_acct_id := -1;
1446: RETURN l_ip_acct_id;
1447: END get_ip_account_id;

Line 1473: fnd_message.set_name('CSI','CSI_INT_MSTR_ORG_MISSING');

1469: WHERE organization_id = p_organization_id;
1470:
1471: EXCEPTION
1472: WHEN no_data_found THEN
1473: fnd_message.set_name('CSI','CSI_INT_MSTR_ORG_MISSING');
1474: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);
1475: fnd_msg_pub.add;
1476: x_return_status := l_fnd_error;
1477: WHEN others THEN

Line 1474: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);

1470:
1471: EXCEPTION
1472: WHEN no_data_found THEN
1473: fnd_message.set_name('CSI','CSI_INT_MSTR_ORG_MISSING');
1474: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);
1475: fnd_msg_pub.add;
1476: x_return_status := l_fnd_error;
1477: WHEN others THEN
1478: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');

Line 1478: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');

1474: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);
1475: fnd_msg_pub.add;
1476: x_return_status := l_fnd_error;
1477: WHEN others THEN
1478: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
1479: fnd_message.set_token('SQL_ERROR',SQLERRM);
1480: fnd_msg_pub.add;
1481: x_return_status := l_fnd_unexpected;
1482: END get_master_organization;

Line 1479: fnd_message.set_token('SQL_ERROR',SQLERRM);

1475: fnd_msg_pub.add;
1476: x_return_status := l_fnd_error;
1477: WHEN others THEN
1478: fnd_message.set_name('CSI','CSI_INT_UNEXP_SQL_ERROR');
1479: fnd_message.set_token('SQL_ERROR',SQLERRM);
1480: fnd_msg_pub.add;
1481: x_return_status := l_fnd_unexpected;
1482: END get_master_organization;
1483:

Line 1503: fnd_message.set_name('CSI','CSI_INT_INT_PTY_ID_MISSING');

1499: */
1500: x_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
1501:
1502: IF x_int_party_id IS NULL THEN
1503: fnd_message.set_name('CSI','CSI_INT_INT_PTY_ID_MISSING');
1504: fnd_msg_pub.add;
1505: x_return_status := fnd_api.g_ret_sts_error;
1506: ELSE
1507: x_return_status := fnd_api.g_ret_sts_success;

Line 1512: fnd_message.set_name('CSI','CSI_INT_INT_PTY_ID_MISSING');

1508: END IF;
1509:
1510: exception
1511: when others then
1512: fnd_message.set_name('CSI','CSI_INT_INT_PTY_ID_MISSING');
1513: fnd_msg_pub.add;
1514: x_return_status := fnd_api.g_ret_sts_error;
1515: END get_int_party;
1516:

Line 1545: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');

1541:
1542: RETURN l_serial_code;
1543: exception
1544: when others then
1545: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1546: fnd_message.set_token('INVENTORY_ITEM_ID',p_inv_item_id);
1547: fnd_message.set_token('INV_ORGANIZATION_ID',p_inv_org_id);
1548: fnd_msg_pub.add;
1549: l_serial_code := -1;

Line 1546: fnd_message.set_token('INVENTORY_ITEM_ID',p_inv_item_id);

1542: RETURN l_serial_code;
1543: exception
1544: when others then
1545: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1546: fnd_message.set_token('INVENTORY_ITEM_ID',p_inv_item_id);
1547: fnd_message.set_token('INV_ORGANIZATION_ID',p_inv_org_id);
1548: fnd_msg_pub.add;
1549: l_serial_code := -1;
1550: RETURN l_serial_code;

Line 1547: fnd_message.set_token('INV_ORGANIZATION_ID',p_inv_org_id);

1543: exception
1544: when others then
1545: fnd_message.set_name('CSI','CSI_INT_ITEM_ID_MISSING');
1546: fnd_message.set_token('INVENTORY_ITEM_ID',p_inv_item_id);
1547: fnd_message.set_token('INV_ORGANIZATION_ID',p_inv_org_id);
1548: fnd_msg_pub.add;
1549: l_serial_code := -1;
1550: RETURN l_serial_code;
1551: END get_serial_contl_code;

Line 1665: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');

1661: WHERE hzcsu.site_use_id = l_order_line_rec.ship_to_org_id
1662: AND hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id;
1663: EXCEPTION
1664: WHEN no_data_found THEN
1665: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
1666: fnd_message.set_token('LOCATION_ID', l_order_line_rec.ship_to_org_id);
1667: fnd_msg_pub.add;
1668: RAISE fnd_api.g_exc_error;
1669: WHEN too_many_rows THEN

Line 1666: fnd_message.set_token('LOCATION_ID', l_order_line_rec.ship_to_org_id);

1662: AND hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id;
1663: EXCEPTION
1664: WHEN no_data_found THEN
1665: fnd_message.set_name('CSI','CSI_INT_PTY_SITE_MISSING');
1666: fnd_message.set_token('LOCATION_ID', l_order_line_rec.ship_to_org_id);
1667: fnd_msg_pub.add;
1668: RAISE fnd_api.g_exc_error;
1669: WHEN too_many_rows THEN
1670: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

Line 1670: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');

1666: fnd_message.set_token('LOCATION_ID', l_order_line_rec.ship_to_org_id);
1667: fnd_msg_pub.add;
1668: RAISE fnd_api.g_exc_error;
1669: WHEN too_many_rows THEN
1670: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
1671: fnd_message.set_token('LOCATION_ID', l_order_line_rec.ship_to_org_id);
1672: fnd_msg_pub.add;
1673: RAISE fnd_api.g_exc_error;
1674: END;

Line 1671: fnd_message.set_token('LOCATION_ID', l_order_line_rec.ship_to_org_id);

1667: fnd_msg_pub.add;
1668: RAISE fnd_api.g_exc_error;
1669: WHEN too_many_rows THEN
1670: fnd_message.set_name('CSI','CSI_INT_MANY_PTY_SITE_FOUND');
1671: fnd_message.set_token('LOCATION_ID', l_order_line_rec.ship_to_org_id);
1672: fnd_msg_pub.add;
1673: RAISE fnd_api.g_exc_error;
1674: END;
1675:

Line 1697: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1693: IF l_partner_rec.IB_OWNER = 'END_CUSTOMER'
1694: THEN
1695: l_order_line_rec.ib_owner := 'END_CUSTOMER';
1696: IF l_partner_rec.END_CUSTOMER_ID is null Then
1697: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1698: fnd_msg_pub.add;
1699: raise fnd_api.g_exc_error;
1700: ELSE
1701: l_order_line_rec.end_customer_id := l_partner_rec.end_customer_id;

Line 1718: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1714: IF l_order_line_rec.ib_install_loc = 'END_CUSTOMER'
1715: THEN
1716: IF l_partner_rec.end_customer_site_use_id is null
1717: THEN
1718: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1719: fnd_msg_pub.add;
1720: raise fnd_api.g_exc_error;
1721: ELSE
1722: l_order_line_rec.ib_install_loc_id := l_partner_rec.end_customer_site_use_id;

Line 1728: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1724: ELSIF l_order_line_rec.ib_install_loc = 'SHIP_TO'
1725: THEN
1726: IF l_order_line_rec.ship_to_org_id is null
1727: THEN
1728: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1729: fnd_msg_pub.add;
1730: raise fnd_api.g_exc_error;
1731: ELSE
1732: l_order_line_rec.ib_install_loc_id := l_order_line_rec.ship_to_org_id;

Line 1738: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1734: ELSIF l_order_line_rec.ib_install_loc = 'SOLD_TO'
1735: THEN
1736: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 l_order_line_rec.sold_to_org_id is null
1737: THEN
1738: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1739: fnd_msg_pub.add;
1740: raise fnd_api.g_exc_error;
1741: ELSE
1742: l_order_line_rec.ib_install_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 l_order_line_rec.sold_to_org_id;

Line 1748: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1744: ELSIF l_order_line_rec.ib_install_loc = 'DELIVER_TO'
1745: THEN
1746: IF l_order_line_rec.deliver_to_org_id is null
1747: THEN
1748: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1749: fnd_msg_pub.add;
1750: raise fnd_api.g_exc_error;
1751: ELSE
1752: l_order_line_rec.ib_install_loc_id := l_order_line_rec.deliver_to_org_id;

Line 1758: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1754: ELSIF l_order_line_rec.ib_install_loc = 'BILL_TO'
1755: THEN
1756: IF l_order_line_rec.invoice_to_org_id is null
1757: THEN
1758: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1759: fnd_msg_pub.add;
1760: raise fnd_api.g_exc_error;
1761: ELSE
1762: l_order_line_rec.ib_install_loc_id := l_order_line_rec.invoice_to_org_id;

Line 1779: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1775: IF l_order_line_rec.ib_current_loc = 'END_CUSTOMER'
1776: THEN
1777: IF l_partner_rec.end_customer_site_use_id is null
1778: THEN
1779: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1780: fnd_msg_pub.add;
1781: raise fnd_api.g_exc_error;
1782: ELSE
1783: l_order_line_rec.ib_current_loc_id := l_partner_rec.end_customer_site_use_id;

Line 1789: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1785: ELSIF l_order_line_rec.ib_current_loc = 'SHIP_TO'
1786: THEN
1787: IF l_order_line_rec.ship_to_org_id is null
1788: THEN
1789: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1790: fnd_msg_pub.add;
1791: raise fnd_api.g_exc_error;
1792: ELSE
1793: l_order_line_rec.ib_current_loc_id := l_order_line_rec.ship_to_org_id;

Line 1799: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1795: ELSIF l_order_line_rec.ib_current_loc = 'SOLD_TO'
1796: THEN
1797: IF l_partner_rec.SOLD_TO_SITE_USE_ID is null -- 3412544 l_order_line_rec.sold_to_org_id is null
1798: THEN
1799: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1800: fnd_msg_pub.add;
1801: raise fnd_api.g_exc_error;
1802: ELSE
1803: l_order_line_rec.ib_current_loc_id := l_partner_rec.SOLD_TO_SITE_USE_ID; -- 3412544 l_order_line_rec.sold_to_org_id;

Line 1809: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1805: ELSIF l_order_line_rec.ib_current_loc = 'DELIVER_TO'
1806: THEN
1807: IF l_order_line_rec.deliver_to_org_id is null
1808: THEN
1809: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1810: fnd_msg_pub.add;
1811: raise fnd_api.g_exc_error;
1812: ELSE
1813: l_order_line_rec.ib_current_loc_id := l_order_line_rec.deliver_to_org_id;

Line 1819: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');

1815: ELSIF l_order_line_rec.ib_current_loc = 'BILL_TO'
1816: THEN
1817: IF l_order_line_rec.invoice_to_org_id is null
1818: THEN
1819: fnd_message.set_name('CSI','CSI_PARTNER_VAL_MISSING');
1820: fnd_msg_pub.add;
1821: raise fnd_api.g_exc_error;
1822: ELSE
1823: l_order_line_rec.ib_current_loc_id := l_order_line_rec.invoice_to_org_id;

Line 1864: fnd_message.set_name('CSI','CSI_INT_ORD_LINE_MISSING');

1860: EXCEPTION
1861: WHEN fnd_api.g_exc_error THEN
1862: x_return_status := fnd_api.g_ret_sts_error;
1863: WHEN others THEN
1864: fnd_message.set_name('CSI','CSI_INT_ORD_LINE_MISSING');
1865: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_transaction_id);
1866: fnd_msg_pub.add;
1867: x_return_status := fnd_api.g_ret_sts_error;
1868:

Line 1865: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_transaction_id);

1861: WHEN fnd_api.g_exc_error THEN
1862: x_return_status := fnd_api.g_ret_sts_error;
1863: WHEN others THEN
1864: fnd_message.set_name('CSI','CSI_INT_ORD_LINE_MISSING');
1865: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_transaction_id);
1866: fnd_msg_pub.add;
1867: x_return_status := fnd_api.g_ret_sts_error;
1868:
1869: END get_order_line_dtls;

Line 1897: fnd_message.set_name('CSI','CSI_INT_SPL_ORD_LINE_MISSING');

1893: x_return_status := fnd_api.g_ret_sts_success;
1894: WHEN too_many_rows THEN
1895: x_return_status := fnd_api.g_ret_sts_success;
1896: WHEN others THEN
1897: fnd_message.set_name('CSI','CSI_INT_SPL_ORD_LINE_MISSING');
1898: fnd_message.set_token('ORDER_LINE_ID', p_order_line_id);
1899: fnd_msg_pub.add;
1900: x_return_status := fnd_api.g_ret_sts_error;
1901: END get_split_order_line;

Line 1898: fnd_message.set_token('ORDER_LINE_ID', p_order_line_id);

1894: WHEN too_many_rows THEN
1895: x_return_status := fnd_api.g_ret_sts_success;
1896: WHEN others THEN
1897: fnd_message.set_name('CSI','CSI_INT_SPL_ORD_LINE_MISSING');
1898: fnd_message.set_token('ORDER_LINE_ID', p_order_line_id);
1899: fnd_msg_pub.add;
1900: x_return_status := fnd_api.g_ret_sts_error;
1901: END get_split_order_line;
1902:

Line 1942: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');

1938: AND transaction_type_id = p_trx_type_id;
1939:
1940: EXCEPTION
1941: WHEN others THEN
1942: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
1943: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);
1944: fnd_message.set_token('TRANSACTION_TYPE_ID', p_trx_type_id);
1945: fnd_msg_pub.add;
1946: x_return_status := fnd_api.g_ret_sts_error;

Line 1943: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);

1939:
1940: EXCEPTION
1941: WHEN others THEN
1942: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
1943: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);
1944: fnd_message.set_token('TRANSACTION_TYPE_ID', p_trx_type_id);
1945: fnd_msg_pub.add;
1946: x_return_status := fnd_api.g_ret_sts_error;
1947: END get_sub_type_rec;

Line 1944: fnd_message.set_token('TRANSACTION_TYPE_ID', p_trx_type_id);

1940: EXCEPTION
1941: WHEN others THEN
1942: fnd_message.set_name('CSI','CSI_INT_SUB_TYPE_REC_MISSING');
1943: fnd_message.set_token('SUB_TYPE_ID', p_sub_type_id);
1944: fnd_message.set_token('TRANSACTION_TYPE_ID', p_trx_type_id);
1945: fnd_msg_pub.add;
1946: x_return_status := fnd_api.g_ret_sts_error;
1947: END get_sub_type_rec;
1948:

Line 1974: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');

1970: (active_end_date > sysdate));
1971:
1972: exception
1973: when others then
1974: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');
1975: fnd_message.set_token('RELATIONSHIP_ID', p_ii_relationship_id);
1976: fnd_msg_pub.add;
1977: x_return_status := fnd_api.g_ret_sts_error;
1978: END get_inst_relation;

Line 1975: fnd_message.set_token('RELATIONSHIP_ID', p_ii_relationship_id);

1971:
1972: exception
1973: when others then
1974: fnd_message.set_name('CSI','CSI_INT_INV_II_REL_ID');
1975: fnd_message.set_token('RELATIONSHIP_ID', p_ii_relationship_id);
1976: fnd_msg_pub.add;
1977: x_return_status := fnd_api.g_ret_sts_error;
1978: END get_inst_relation;
1979:

Line 2044: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');

2040: and inventory_item_id = p_order_item_id
2041: and model_remnant_flag = 'Y';
2042: EXCEPTION
2043: WHEN no_data_found THEN
2044: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2045: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2046: fnd_msg_pub.add;
2047: l_ordered_quantity := 0;
2048: WHEN others THEN

Line 2045: fnd_message.set_token('LINE_ID',p_link_to_line_id);

2041: and model_remnant_flag = 'Y';
2042: EXCEPTION
2043: WHEN no_data_found THEN
2044: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2045: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2046: fnd_msg_pub.add;
2047: l_ordered_quantity := 0;
2048: WHEN others THEN
2049: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');

Line 2049: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');

2045: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2046: fnd_msg_pub.add;
2047: l_ordered_quantity := 0;
2048: WHEN others THEN
2049: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2050: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2051: fnd_msg_pub.add;
2052: l_ordered_quantity := 0;
2053: END ;

Line 2050: fnd_message.set_token('LINE_ID',p_link_to_line_id);

2046: fnd_msg_pub.add;
2047: l_ordered_quantity := 0;
2048: WHEN others THEN
2049: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2050: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2051: fnd_msg_pub.add;
2052: l_ordered_quantity := 0;
2053: END ;
2054: ELSE

Line 2067: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');

2063: WHERE line_id = p_link_to_line_id;
2064:
2065: EXCEPTION
2066: WHEN no_data_found THEN
2067: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2068: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2069: fnd_msg_pub.add;
2070: l_ordered_quantity := 0;
2071: WHEN others THEN

Line 2068: fnd_message.set_token('LINE_ID',p_link_to_line_id);

2064:
2065: EXCEPTION
2066: WHEN no_data_found THEN
2067: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2068: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2069: fnd_msg_pub.add;
2070: l_ordered_quantity := 0;
2071: WHEN others THEN
2072: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');

Line 2072: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');

2068: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2069: fnd_msg_pub.add;
2070: l_ordered_quantity := 0;
2071: WHEN others THEN
2072: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2073: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2074: fnd_msg_pub.add;
2075: l_ordered_quantity := 0;
2076: END ;

Line 2073: fnd_message.set_token('LINE_ID',p_link_to_line_id);

2069: fnd_msg_pub.add;
2070: l_ordered_quantity := 0;
2071: WHEN others THEN
2072: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2073: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2074: fnd_msg_pub.add;
2075: l_ordered_quantity := 0;
2076: END ;
2077:

Line 2097: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');

2093: debug('IB Trackable '||l_ib_trackable_flag);
2094:
2095: Exception
2096: WHEN no_data_found THEN
2097: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2098: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2099: fnd_msg_pub.add;
2100: l_ordered_quantity := 0;
2101: End;

Line 2098: fnd_message.set_token('LINE_ID',p_link_to_line_id);

2094:
2095: Exception
2096: WHEN no_data_found THEN
2097: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2098: fnd_message.set_token('LINE_ID',p_link_to_line_id);
2099: fnd_msg_pub.add;
2100: l_ordered_quantity := 0;
2101: End;
2102:

Line 2169: fnd_message.set_name('CSI','CSI_OE_LINK_TO_LINE_ID_INVALID');

2165:
2166: exception
2167: when no_data_found then --fix for bug5045398--
2168: debug('Passed link_to_line_id '||x_link_to_line_id||' does not exists in oe order lines');
2169: fnd_message.set_name('CSI','CSI_OE_LINK_TO_LINE_ID_INVALID');
2170: fnd_message.set_token('OE_LINK_TO_LINE_ID', x_link_to_line_id);
2171: fnd_msg_pub.add;
2172: x_return_status := fnd_api.g_ret_sts_error;
2173: l_found := TRUE;

Line 2170: fnd_message.set_token('OE_LINK_TO_LINE_ID', x_link_to_line_id);

2166: exception
2167: when no_data_found then --fix for bug5045398--
2168: debug('Passed link_to_line_id '||x_link_to_line_id||' does not exists in oe order lines');
2169: fnd_message.set_name('CSI','CSI_OE_LINK_TO_LINE_ID_INVALID');
2170: fnd_message.set_token('OE_LINK_TO_LINE_ID', x_link_to_line_id);
2171: fnd_msg_pub.add;
2172: x_return_status := fnd_api.g_ret_sts_error;
2173: l_found := TRUE;
2174: --end of fix--

Line 2177: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');

2173: l_found := TRUE;
2174: --end of fix--
2175: end;
2176: WHEN others THEN
2177: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2178: fnd_message.set_token('LINE_ID',x_link_to_line_id);
2179: fnd_msg_pub.add;
2180: END ;
2181:

Line 2178: fnd_message.set_token('LINE_ID',x_link_to_line_id);

2174: --end of fix--
2175: end;
2176: WHEN others THEN
2177: fnd_message.set_name('CSI','CSI_INT_MOD_INST_MISSING');
2178: fnd_message.set_token('LINE_ID',x_link_to_line_id);
2179: fnd_msg_pub.add;
2180: END ;
2181:
2182: END LOOP; --end of while loop

Line 3558: fnd_message.set_name('CSI','CSI_INT_ORD_LINE_MISSING');

3554:
3555: EXCEPTION
3556: WHEN no_data_found THEN
3557: x_return_status := fnd_api.g_ret_sts_error;
3558: fnd_message.set_name('CSI','CSI_INT_ORD_LINE_MISSING');
3559: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_transaction_id);
3560: fnd_msg_pub.add;
3561: END get_source_trx_dtls;
3562:

Line 3559: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_transaction_id);

3555: EXCEPTION
3556: WHEN no_data_found THEN
3557: x_return_status := fnd_api.g_ret_sts_error;
3558: fnd_message.set_name('CSI','CSI_INT_ORD_LINE_MISSING');
3559: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_transaction_id);
3560: fnd_msg_pub.add;
3561: END get_source_trx_dtls;
3562:
3563: PROCEDURE split_txn_dtls_with_qty( --Included the API for bug 4354267

Line 4866: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

4862: WHERE subject_id = l_old_instance_id
4863: AND object_id = l_parent_instance_id;
4864: EXCEPTION
4865: WHEN NO_DATA_FOUND THEN
4866: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4867: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4868: fnd_msg_pub.add;
4869: debug('Item being replaced belongs to a different configuration.');
4870: RAISE fnd_api.g_exc_error;

Line 4867: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);

4863: AND object_id = l_parent_instance_id;
4864: EXCEPTION
4865: WHEN NO_DATA_FOUND THEN
4866: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4867: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4868: fnd_msg_pub.add;
4869: debug('Item being replaced belongs to a different configuration.');
4870: RAISE fnd_api.g_exc_error;
4871: WHEN OTHERS THEN

Line 4872: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

4868: fnd_msg_pub.add;
4869: debug('Item being replaced belongs to a different configuration.');
4870: RAISE fnd_api.g_exc_error;
4871: WHEN OTHERS THEN
4872: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4873: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4874: fnd_msg_pub.add;
4875: debug('Item being replaced belongs to a different configuration.');
4876: RAISE fnd_api.g_exc_error;

Line 4873: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);

4869: debug('Item being replaced belongs to a different configuration.');
4870: RAISE fnd_api.g_exc_error;
4871: WHEN OTHERS THEN
4872: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4873: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4874: fnd_msg_pub.add;
4875: debug('Item being replaced belongs to a different configuration.');
4876: RAISE fnd_api.g_exc_error;
4877: END;

Line 4887: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

4883: FROM csi_item_instances
4884: WHERE instance_id = l_old_instance_id;
4885: EXCEPTION
4886: WHEN OTHERS THEN
4887: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4888: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4889: fnd_msg_pub.add;
4890: debug('Item being replaced belongs to a different configuration.');
4891: RAISE fnd_api.g_exc_error;

Line 4888: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);

4884: WHERE instance_id = l_old_instance_id;
4885: EXCEPTION
4886: WHEN OTHERS THEN
4887: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4888: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4889: fnd_msg_pub.add;
4890: debug('Item being replaced belongs to a different configuration.');
4891: RAISE fnd_api.g_exc_error;
4892: END;

Line 4913: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

4909: END LOOP;
4910:
4911: debug('l_item_status = '||l_item_status);
4912: IF l_item_status is null THEN
4913: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4914: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4915: fnd_msg_pub.add;
4916: debug('Item is in INVENTORY and relationship is Active');
4917: RAISE fnd_api.g_exc_error;

Line 4914: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);

4910:
4911: debug('l_item_status = '||l_item_status);
4912: IF l_item_status is null THEN
4913: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
4914: fnd_message.set_token('INSTANCE_ID',l_subject_inst_id);
4915: fnd_msg_pub.add;
4916: debug('Item is in INVENTORY and relationship is Active');
4917: RAISE fnd_api.g_exc_error;
4918: ELSE

Line 5010: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

5006: FETCH check_instance_status into l_valid_instance_no;
5007:
5008: IF check_instance_status%notfound THEN
5009: close check_instance_status;
5010: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5011: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5012: fnd_msg_pub.add;
5013: debug('Check instance status - The item being replaced is no longer valid.');
5014: RAISE fnd_api.g_exc_error;

Line 5011: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);

5007:
5008: IF check_instance_status%notfound THEN
5009: close check_instance_status;
5010: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5011: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5012: fnd_msg_pub.add;
5013: debug('Check instance status - The item being replaced is no longer valid.');
5014: RAISE fnd_api.g_exc_error;
5015: ELSE

Line 5041: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

5037:
5038: l_upd_ii := l_upd_ii + 1;
5039: EXCEPTION
5040: WHEN NO_DATA_FOUND THEN
5041: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5042: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5043: fnd_msg_pub.add;
5044: debug('No data found - Item being replaced is no longer valid.');
5045: RAISE fnd_api.g_exc_error;

Line 5042: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);

5038: l_upd_ii := l_upd_ii + 1;
5039: EXCEPTION
5040: WHEN NO_DATA_FOUND THEN
5041: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5042: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5043: fnd_msg_pub.add;
5044: debug('No data found - Item being replaced is no longer valid.');
5045: RAISE fnd_api.g_exc_error;
5046: WHEN OTHERS THEN

Line 5047: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

5043: fnd_msg_pub.add;
5044: debug('No data found - Item being replaced is no longer valid.');
5045: RAISE fnd_api.g_exc_error;
5046: WHEN OTHERS THEN
5047: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5048: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5049: fnd_msg_pub.add;
5050: debug('Others - Item being replaced is no longer valid');
5051: RAISE fnd_api.g_exc_error;

Line 5048: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);

5044: debug('No data found - Item being replaced is no longer valid.');
5045: RAISE fnd_api.g_exc_error;
5046: WHEN OTHERS THEN
5047: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5048: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5049: fnd_msg_pub.add;
5050: debug('Others - Item being replaced is no longer valid');
5051: RAISE fnd_api.g_exc_error;
5052: END;

Line 5130: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

5126: END LOOP;
5127: END IF;
5128: EXCEPTION
5129: WHEN NO_DATA_FOUND THEN
5130: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5131: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5132: fnd_msg_pub.add;
5133: debug('No data found - Item being replaced is no longer valid.');
5134: RAISE fnd_api.g_exc_error;

Line 5131: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);

5127: END IF;
5128: EXCEPTION
5129: WHEN NO_DATA_FOUND THEN
5130: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5131: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5132: fnd_msg_pub.add;
5133: debug('No data found - Item being replaced is no longer valid.');
5134: RAISE fnd_api.g_exc_error;
5135: WHEN OTHERS THEN

Line 5136: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');

5132: fnd_msg_pub.add;
5133: debug('No data found - Item being replaced is no longer valid.');
5134: RAISE fnd_api.g_exc_error;
5135: WHEN OTHERS THEN
5136: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5137: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5138: fnd_msg_pub.add;
5139: debug('Others - Item being replaced is no longer valid');
5140: RAISE fnd_api.g_exc_error;

Line 5137: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);

5133: debug('No data found - Item being replaced is no longer valid.');
5134: RAISE fnd_api.g_exc_error;
5135: WHEN OTHERS THEN
5136: fnd_message.set_name('CSI','CSI_REPLACEMENT_TXN_INVALID');
5137: fnd_message.set_token('INSTANCE_ID',l_old_instance_id);
5138: fnd_msg_pub.add;
5139: debug('Others - Item being replaced is no longer valid');
5140: RAISE fnd_api.g_exc_error;
5141: END;

Line 5224: fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');

5220: OR
5221: sysdate < nvl(active_end_date, sysdate +1) );
5222: EXCEPTION
5223: WHEN no_data_found THEN
5224: fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
5225: fnd_message.set_token('INSTANCE_ID',l_instance_id);
5226: fnd_msg_pub.add;
5227: raise fnd_api.g_exc_error;
5228: END;

Line 5225: fnd_message.set_token('INSTANCE_ID',l_instance_id);

5221: sysdate < nvl(active_end_date, sysdate +1) );
5222: EXCEPTION
5223: WHEN no_data_found THEN
5224: fnd_message.set_name('CSI','CSI_INT_INST_OWNER_MISSING');
5225: fnd_message.set_token('INSTANCE_ID',l_instance_id);
5226: fnd_msg_pub.add;
5227: raise fnd_api.g_exc_error;
5228: END;
5229:

Line 5619: fnd_message.set_name('CSI','CSI_INT_CUST_ROLEID_MISSING');

5615: AND directional_flag = 'F';
5616:
5617: EXCEPTION
5618: WHEN no_data_found THEN
5619: fnd_message.set_name('CSI','CSI_INT_CUST_ROLEID_MISSING');
5620: fnd_message.set_token('CUST_ACCOUNT_ROLE_ID',p_cust_acct_role_id);
5621: fnd_msg_pub.add;
5622: x_return_status := fnd_api.g_ret_sts_error ;
5623: END derive_party_id;

Line 5620: fnd_message.set_token('CUST_ACCOUNT_ROLE_ID',p_cust_acct_role_id);

5616:
5617: EXCEPTION
5618: WHEN no_data_found THEN
5619: fnd_message.set_name('CSI','CSI_INT_CUST_ROLEID_MISSING');
5620: fnd_message.set_token('CUST_ACCOUNT_ROLE_ID',p_cust_acct_role_id);
5621: fnd_msg_pub.add;
5622: x_return_status := fnd_api.g_ret_sts_error ;
5623: END derive_party_id;
5624:

Line 6006: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');

6002: WHERE transaction_id = p_mtl_txn_id;
6003:
6004: EXCEPTION
6005: WHEN no_data_found THEN
6006: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
6007: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_txn_id);
6008: fnd_msg_pub.add;
6009: RAISE fnd_api.g_exc_error;
6010:

Line 6007: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_txn_id);

6003:
6004: EXCEPTION
6005: WHEN no_data_found THEN
6006: fnd_message.set_name('CSI','CSI_NO_INVENTORY_RECORDS');
6007: fnd_message.set_token('MTL_TRANSACTION_ID',p_mtl_txn_id);
6008: fnd_msg_pub.add;
6009: RAISE fnd_api.g_exc_error;
6010:
6011: END;

Line 6045: fnd_message.set_name('CSI', 'CSI_INT_ITEM_ID_MISSING');

6041: AND organization_id = l_item_control_rec.organization_id;
6042:
6043: EXCEPTION
6044: WHEN no_data_found THEN
6045: fnd_message.set_name('CSI', 'CSI_INT_ITEM_ID_MISSING');
6046: fnd_message.set_token('INVENTORY_ITEM_ID', l_item_control_rec.inventory_item_id);
6047: fnd_message.set_token('INV_ORGANZATION_ID', l_item_control_rec.organization_id);
6048: fnd_msg_pub.add;
6049: RAISE fnd_api.g_exc_error;

Line 6046: fnd_message.set_token('INVENTORY_ITEM_ID', l_item_control_rec.inventory_item_id);

6042:
6043: EXCEPTION
6044: WHEN no_data_found THEN
6045: fnd_message.set_name('CSI', 'CSI_INT_ITEM_ID_MISSING');
6046: fnd_message.set_token('INVENTORY_ITEM_ID', l_item_control_rec.inventory_item_id);
6047: fnd_message.set_token('INV_ORGANZATION_ID', l_item_control_rec.organization_id);
6048: fnd_msg_pub.add;
6049: RAISE fnd_api.g_exc_error;
6050: END;

Line 6047: fnd_message.set_token('INV_ORGANZATION_ID', l_item_control_rec.organization_id);

6043: EXCEPTION
6044: WHEN no_data_found THEN
6045: fnd_message.set_name('CSI', 'CSI_INT_ITEM_ID_MISSING');
6046: fnd_message.set_token('INVENTORY_ITEM_ID', l_item_control_rec.inventory_item_id);
6047: fnd_message.set_token('INV_ORGANZATION_ID', l_item_control_rec.organization_id);
6048: fnd_msg_pub.add;
6049: RAISE fnd_api.g_exc_error;
6050: END;
6051:

Line 6265: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

6261: From csi_t_transaction_lines tl, csi_t_txn_line_details tld
6262: Where tld.transaction_line_id = tl.transaction_line_id
6263: And tld.txn_line_detail_id = l_orig_oe_tld;
6264: Exception when others Then
6265: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
6266: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));
6267: fnd_msg_pub.add;
6268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6269: raise FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 6266: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));

6262: Where tld.transaction_line_id = tl.transaction_line_id
6263: And tld.txn_line_detail_id = l_orig_oe_tld;
6264: Exception when others Then
6265: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
6266: fnd_message.set_token('MESSAGE', substr(sqlerrm, 1, 240));
6267: fnd_msg_pub.add;
6268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6269: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
6270: End;

Line 6644: fnd_message.set_name('CSI','CSI_INT_CHILD_RATIO_INVALID');

6640: /* do a quick check to see if the shipping has not violated the
6641: quantity raito while splitting the instance */
6642: IF l_instance_tbl(l_ind).quantity > p_quantity_ratio THEN
6643: IF p_split_flag = 'Y' THEN -- Bug 14471544
6644: fnd_message.set_name('CSI','CSI_INT_CHILD_RATIO_INVALID');
6645: fnd_message.set_token('CHILD_QTY',l_instance_tbl(l_ind).quantity);
6646: fnd_message.set_token('RATIO', p_quantity_ratio);
6647: fnd_msg_pub.add;
6648: debug ('The instance qty generated by the shipment interface '||

Line 6645: fnd_message.set_token('CHILD_QTY',l_instance_tbl(l_ind).quantity);

6641: quantity raito while splitting the instance */
6642: IF l_instance_tbl(l_ind).quantity > p_quantity_ratio THEN
6643: IF p_split_flag = 'Y' THEN -- Bug 14471544
6644: fnd_message.set_name('CSI','CSI_INT_CHILD_RATIO_INVALID');
6645: fnd_message.set_token('CHILD_QTY',l_instance_tbl(l_ind).quantity);
6646: fnd_message.set_token('RATIO', p_quantity_ratio);
6647: fnd_msg_pub.add;
6648: debug ('The instance qty generated by the shipment interface '||
6649: l_instance_tbl(l_ind).quantity||' is greater than the MODEL/CHILD ratio '||

Line 6646: fnd_message.set_token('RATIO', p_quantity_ratio);

6642: IF l_instance_tbl(l_ind).quantity > p_quantity_ratio THEN
6643: IF p_split_flag = 'Y' THEN -- Bug 14471544
6644: fnd_message.set_name('CSI','CSI_INT_CHILD_RATIO_INVALID');
6645: fnd_message.set_token('CHILD_QTY',l_instance_tbl(l_ind).quantity);
6646: fnd_message.set_token('RATIO', p_quantity_ratio);
6647: fnd_msg_pub.add;
6648: debug ('The instance qty generated by the shipment interface '||
6649: l_instance_tbl(l_ind).quantity||' is greater than the MODEL/CHILD ratio '||
6650: p_quantity_ratio);