APPS.DPP_TRANSACTION_PVT dependencies on FND_MESSAGE

Line 69: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

65: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
66: WHEN OTHERS THEN
67: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
68: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
69: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
70: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
71: fnd_message.set_token('ERRNO', SQLCODE);
72: fnd_message.set_token('REASON', sqlerrm);
73: END IF;

Line 70: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

66: WHEN OTHERS THEN
67: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
68: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
69: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
70: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
71: fnd_message.set_token('ERRNO', SQLCODE);
72: fnd_message.set_token('REASON', sqlerrm);
73: END IF;
74: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||sqlerrm);

Line 71: fnd_message.set_token('ERRNO', SQLCODE);

67: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
68: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
69: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
70: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
71: fnd_message.set_token('ERRNO', SQLCODE);
72: fnd_message.set_token('REASON', sqlerrm);
73: END IF;
74: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||sqlerrm);
75: END Update_InterfaceErrSts;

Line 72: fnd_message.set_token('REASON', sqlerrm);

68: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
69: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
70: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
71: fnd_message.set_token('ERRNO', SQLCODE);
72: fnd_message.set_token('REASON', sqlerrm);
73: END IF;
74: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||sqlerrm);
75: END Update_InterfaceErrSts;
76:

Line 98: fnd_message.set_name( 'DPP', 'DPP_TXN_OPERATING_UNIT_NULL');

94: --BUG 6806974
95: IF p_txn_header_rec_type.operating_unit_name IS NULL
96: AND p_txn_header_rec_type.org_id IS NULL THEN
97: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
98: fnd_message.set_name( 'DPP', 'DPP_TXN_OPERATING_UNIT_NULL');
99: x_msg_data := fnd_message.get();
100: END IF;
101: x_return_status := fnd_api.g_ret_sts_error;
102: p_txn_header_rec_type.error_code := 'DPP_TXN_OPERATING_UNIT_NULL';

Line 99: x_msg_data := fnd_message.get();

95: IF p_txn_header_rec_type.operating_unit_name IS NULL
96: AND p_txn_header_rec_type.org_id IS NULL THEN
97: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
98: fnd_message.set_name( 'DPP', 'DPP_TXN_OPERATING_UNIT_NULL');
99: x_msg_data := fnd_message.get();
100: END IF;
101: x_return_status := fnd_api.g_ret_sts_error;
102: p_txn_header_rec_type.error_code := 'DPP_TXN_OPERATING_UNIT_NULL';
103: RAISE Fnd_Api.G_EXC_ERROR;

Line 129: fnd_message.set_name( 'DPP', 'DPP_TXN_OPERATING_UNIT_ERR');

125: EXCEPTION
126: WHEN NO_DATA_FOUND THEN
127: x_return_status := fnd_api.g_ret_sts_error;
128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
129: fnd_message.set_name( 'DPP', 'DPP_TXN_OPERATING_UNIT_ERR');
130: fnd_message.set_token('OPERATING_UNIT', p_txn_header_rec_type.operating_unit_name);
131: fnd_message.set_token('ORG_ID', p_txn_header_rec_type.org_id);
132: x_msg_data := fnd_message.get();
133: END IF;

Line 130: fnd_message.set_token('OPERATING_UNIT', p_txn_header_rec_type.operating_unit_name);

126: WHEN NO_DATA_FOUND THEN
127: x_return_status := fnd_api.g_ret_sts_error;
128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
129: fnd_message.set_name( 'DPP', 'DPP_TXN_OPERATING_UNIT_ERR');
130: fnd_message.set_token('OPERATING_UNIT', p_txn_header_rec_type.operating_unit_name);
131: fnd_message.set_token('ORG_ID', p_txn_header_rec_type.org_id);
132: x_msg_data := fnd_message.get();
133: END IF;
134: p_txn_header_rec_type.error_code := 'DPP_TXN_OPERATING_UNIT_ERR';

Line 131: fnd_message.set_token('ORG_ID', p_txn_header_rec_type.org_id);

127: x_return_status := fnd_api.g_ret_sts_error;
128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
129: fnd_message.set_name( 'DPP', 'DPP_TXN_OPERATING_UNIT_ERR');
130: fnd_message.set_token('OPERATING_UNIT', p_txn_header_rec_type.operating_unit_name);
131: fnd_message.set_token('ORG_ID', p_txn_header_rec_type.org_id);
132: x_msg_data := fnd_message.get();
133: END IF;
134: p_txn_header_rec_type.error_code := 'DPP_TXN_OPERATING_UNIT_ERR';
135: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 132: x_msg_data := fnd_message.get();

128: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
129: fnd_message.set_name( 'DPP', 'DPP_TXN_OPERATING_UNIT_ERR');
130: fnd_message.set_token('OPERATING_UNIT', p_txn_header_rec_type.operating_unit_name);
131: fnd_message.set_token('ORG_ID', p_txn_header_rec_type.org_id);
132: x_msg_data := fnd_message.get();
133: END IF;
134: p_txn_header_rec_type.error_code := 'DPP_TXN_OPERATING_UNIT_ERR';
135: WHEN Fnd_Api.G_EXC_ERROR THEN
136: x_return_status := Fnd_Api.g_ret_sts_error ;

Line 140: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

136: x_return_status := Fnd_Api.g_ret_sts_error ;
137: WHEN OTHERS THEN
138: x_return_status := fnd_api.g_ret_sts_unexp_error;
139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
140: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
141: fnd_message.set_token('ROUTINE', l_full_name);
142: fnd_message.set_token('ERRNO', SQLCODE);
143: fnd_message.set_token('REASON', sqlerrm);
144: END IF;

Line 141: fnd_message.set_token('ROUTINE', l_full_name);

137: WHEN OTHERS THEN
138: x_return_status := fnd_api.g_ret_sts_unexp_error;
139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
140: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
141: fnd_message.set_token('ROUTINE', l_full_name);
142: fnd_message.set_token('ERRNO', SQLCODE);
143: fnd_message.set_token('REASON', sqlerrm);
144: END IF;
145: x_msg_data := fnd_message.get();

Line 142: fnd_message.set_token('ERRNO', SQLCODE);

138: x_return_status := fnd_api.g_ret_sts_unexp_error;
139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
140: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
141: fnd_message.set_token('ROUTINE', l_full_name);
142: fnd_message.set_token('ERRNO', SQLCODE);
143: fnd_message.set_token('REASON', sqlerrm);
144: END IF;
145: x_msg_data := fnd_message.get();
146: END Validate_OperatingUnit;

Line 143: fnd_message.set_token('REASON', sqlerrm);

139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
140: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
141: fnd_message.set_token('ROUTINE', l_full_name);
142: fnd_message.set_token('ERRNO', SQLCODE);
143: fnd_message.set_token('REASON', sqlerrm);
144: END IF;
145: x_msg_data := fnd_message.get();
146: END Validate_OperatingUnit;
147:

Line 145: x_msg_data := fnd_message.get();

141: fnd_message.set_token('ROUTINE', l_full_name);
142: fnd_message.set_token('ERRNO', SQLCODE);
143: fnd_message.set_token('REASON', sqlerrm);
144: END IF;
145: x_msg_data := fnd_message.get();
146: END Validate_OperatingUnit;
147:
148:
149: FUNCTION has_docnum_chars (

Line 185: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_NULL');

181: -- Initialize API return status to sucess
182: x_return_status := fnd_api.g_ret_sts_success;
183: IF p_txn_header_rec_type.ref_document_number IS NULL THEN
184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
185: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_NULL');
186: END IF;
187: x_msg_data := fnd_message.get();
188: p_txn_header_rec_type.error_code := 'DPP_DOC_REF_NUM_NULL';
189: RAISE Fnd_Api.G_EXC_ERROR;

Line 187: x_msg_data := fnd_message.get();

183: IF p_txn_header_rec_type.ref_document_number IS NULL THEN
184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
185: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_NULL');
186: END IF;
187: x_msg_data := fnd_message.get();
188: p_txn_header_rec_type.error_code := 'DPP_DOC_REF_NUM_NULL';
189: RAISE Fnd_Api.G_EXC_ERROR;
190: END IF;
191: --Call function to validate the document ref number for special characters other than _ and -.

Line 199: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_ERR');

195:
196: IF l_valid_doc = 'N' OR length(p_txn_header_rec_type.ref_document_number) > 40 THEN
197: x_return_status := fnd_api.g_ret_sts_error;
198: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
199: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_ERR');
200: fnd_message.set_token('DOC_REF_NO', p_txn_header_rec_type.ref_document_number);
201: END IF;
202: x_msg_data := fnd_message.get();
203: p_txn_header_rec_type.error_code := 'DPP_DOC_REF_NUM_ERR';

Line 200: fnd_message.set_token('DOC_REF_NO', p_txn_header_rec_type.ref_document_number);

196: IF l_valid_doc = 'N' OR length(p_txn_header_rec_type.ref_document_number) > 40 THEN
197: x_return_status := fnd_api.g_ret_sts_error;
198: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
199: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_ERR');
200: fnd_message.set_token('DOC_REF_NO', p_txn_header_rec_type.ref_document_number);
201: END IF;
202: x_msg_data := fnd_message.get();
203: p_txn_header_rec_type.error_code := 'DPP_DOC_REF_NUM_ERR';
204: END IF;

Line 202: x_msg_data := fnd_message.get();

198: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
199: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_ERR');
200: fnd_message.set_token('DOC_REF_NO', p_txn_header_rec_type.ref_document_number);
201: END IF;
202: x_msg_data := fnd_message.get();
203: p_txn_header_rec_type.error_code := 'DPP_DOC_REF_NUM_ERR';
204: END IF;
205: IF DPP_DEBUG_HIGH_ON THEN
206: FND_FILE.PUT_LINE(FND_FILE.LOG,' End Validate Document Reference Number');

Line 214: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

210: x_return_status := Fnd_Api.g_ret_sts_error ;
211: WHEN OTHERS THEN
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
214: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
215: fnd_message.set_token('ROUTINE', l_full_name);
216: fnd_message.set_token('ERRNO', SQLCODE);
217: fnd_message.set_token('REASON', sqlerrm);
218: x_msg_data := fnd_message.get();

Line 215: fnd_message.set_token('ROUTINE', l_full_name);

211: WHEN OTHERS THEN
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
214: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
215: fnd_message.set_token('ROUTINE', l_full_name);
216: fnd_message.set_token('ERRNO', SQLCODE);
217: fnd_message.set_token('REASON', sqlerrm);
218: x_msg_data := fnd_message.get();
219: END IF;

Line 216: fnd_message.set_token('ERRNO', SQLCODE);

212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
214: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
215: fnd_message.set_token('ROUTINE', l_full_name);
216: fnd_message.set_token('ERRNO', SQLCODE);
217: fnd_message.set_token('REASON', sqlerrm);
218: x_msg_data := fnd_message.get();
219: END IF;
220: END Validate_RefDocNumber;

Line 217: fnd_message.set_token('REASON', sqlerrm);

213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
214: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
215: fnd_message.set_token('ROUTINE', l_full_name);
216: fnd_message.set_token('ERRNO', SQLCODE);
217: fnd_message.set_token('REASON', sqlerrm);
218: x_msg_data := fnd_message.get();
219: END IF;
220: END Validate_RefDocNumber;
221:

Line 218: x_msg_data := fnd_message.get();

214: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
215: fnd_message.set_token('ROUTINE', l_full_name);
216: fnd_message.set_token('ERRNO', SQLCODE);
217: fnd_message.set_token('REASON', sqlerrm);
218: x_msg_data := fnd_message.get();
219: END IF;
220: END Validate_RefDocNumber;
221:
222: PROCEDURE Validate_SupplierDetails(

Line 242: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_INFO_NULL');

238: --BUG 6806974
239: IF (p_txn_header_rec_type.vendor_name IS NULL
240: AND p_txn_header_rec_type.vendor_id IS NULL) THEN
241: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
242: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_INFO_NULL');
243: x_msg_data :=fnd_message.get();
244: END IF;
245: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_INFO_NULL';
246: RAISE Fnd_Api.G_EXC_ERROR;

Line 243: x_msg_data :=fnd_message.get();

239: IF (p_txn_header_rec_type.vendor_name IS NULL
240: AND p_txn_header_rec_type.vendor_id IS NULL) THEN
241: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
242: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_INFO_NULL');
243: x_msg_data :=fnd_message.get();
244: END IF;
245: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_INFO_NULL';
246: RAISE Fnd_Api.G_EXC_ERROR;
247: END IF;

Line 265: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_INFO_ERR');

261: EXCEPTION
262: WHEN NO_DATA_FOUND THEN
263: x_return_status := fnd_api.g_ret_sts_error;
264: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
265: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_INFO_ERR');
266: fnd_message.set_token('SUPPLIER_NAME', p_txn_header_rec_type.vendor_name);
267: fnd_message.set_token('SUPPLIER_ID', p_txn_header_rec_type.vendor_id);
268: x_msg_data :=fnd_message.get();
269: END IF;

Line 266: fnd_message.set_token('SUPPLIER_NAME', p_txn_header_rec_type.vendor_name);

262: WHEN NO_DATA_FOUND THEN
263: x_return_status := fnd_api.g_ret_sts_error;
264: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
265: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_INFO_ERR');
266: fnd_message.set_token('SUPPLIER_NAME', p_txn_header_rec_type.vendor_name);
267: fnd_message.set_token('SUPPLIER_ID', p_txn_header_rec_type.vendor_id);
268: x_msg_data :=fnd_message.get();
269: END IF;
270: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_INFO_ERR';

Line 267: fnd_message.set_token('SUPPLIER_ID', p_txn_header_rec_type.vendor_id);

263: x_return_status := fnd_api.g_ret_sts_error;
264: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
265: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_INFO_ERR');
266: fnd_message.set_token('SUPPLIER_NAME', p_txn_header_rec_type.vendor_name);
267: fnd_message.set_token('SUPPLIER_ID', p_txn_header_rec_type.vendor_id);
268: x_msg_data :=fnd_message.get();
269: END IF;
270: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_INFO_ERR';
271: RAISE Fnd_Api.G_EXC_ERROR;

Line 268: x_msg_data :=fnd_message.get();

264: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
265: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_INFO_ERR');
266: fnd_message.set_token('SUPPLIER_NAME', p_txn_header_rec_type.vendor_name);
267: fnd_message.set_token('SUPPLIER_ID', p_txn_header_rec_type.vendor_id);
268: x_msg_data :=fnd_message.get();
269: END IF;
270: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_INFO_ERR';
271: RAISE Fnd_Api.G_EXC_ERROR;
272: END;

Line 277: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_SITE_NULL');

273: --Validate Supplier Site
274: IF (p_txn_header_rec_type.vendor_site_code IS NULL
275: AND p_txn_header_rec_type.vendor_site_id IS NULL) THEN
276: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
277: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_SITE_NULL');
278: x_msg_data :=fnd_message.get();
279: END IF;
280: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_SITE_NULL';
281: RAISE Fnd_Api.G_EXC_ERROR;

Line 278: x_msg_data :=fnd_message.get();

274: IF (p_txn_header_rec_type.vendor_site_code IS NULL
275: AND p_txn_header_rec_type.vendor_site_id IS NULL) THEN
276: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
277: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_SITE_NULL');
278: x_msg_data :=fnd_message.get();
279: END IF;
280: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_SITE_NULL';
281: RAISE Fnd_Api.G_EXC_ERROR;
282: END IF;

Line 303: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_SITE_ERR');

299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: x_return_status := fnd_api.g_ret_sts_error;
302: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
303: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_SITE_ERR');
304: fnd_message.set_token('SUPPLIER_SITE', p_txn_header_rec_type.vendor_site_code);
305: fnd_message.set_token('SITE_ID', p_txn_header_rec_type.vendor_site_id);
306: x_msg_data :=fnd_message.get();
307: END IF;

Line 304: fnd_message.set_token('SUPPLIER_SITE', p_txn_header_rec_type.vendor_site_code);

300: WHEN NO_DATA_FOUND THEN
301: x_return_status := fnd_api.g_ret_sts_error;
302: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
303: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_SITE_ERR');
304: fnd_message.set_token('SUPPLIER_SITE', p_txn_header_rec_type.vendor_site_code);
305: fnd_message.set_token('SITE_ID', p_txn_header_rec_type.vendor_site_id);
306: x_msg_data :=fnd_message.get();
307: END IF;
308: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_SITE_ERR';

Line 305: fnd_message.set_token('SITE_ID', p_txn_header_rec_type.vendor_site_id);

301: x_return_status := fnd_api.g_ret_sts_error;
302: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
303: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_SITE_ERR');
304: fnd_message.set_token('SUPPLIER_SITE', p_txn_header_rec_type.vendor_site_code);
305: fnd_message.set_token('SITE_ID', p_txn_header_rec_type.vendor_site_id);
306: x_msg_data :=fnd_message.get();
307: END IF;
308: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_SITE_ERR';
309: RAISE Fnd_Api.G_EXC_ERROR;

Line 306: x_msg_data :=fnd_message.get();

302: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
303: fnd_message.set_name('DPP', 'DPP_TXN_SUPP_SITE_ERR');
304: fnd_message.set_token('SUPPLIER_SITE', p_txn_header_rec_type.vendor_site_code);
305: fnd_message.set_token('SITE_ID', p_txn_header_rec_type.vendor_site_id);
306: x_msg_data :=fnd_message.get();
307: END IF;
308: p_txn_header_rec_type.error_code := 'DPP_TXN_SUPP_SITE_ERR';
309: RAISE Fnd_Api.G_EXC_ERROR;
310: END;

Line 320: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

316: x_return_status := Fnd_Api.g_ret_sts_error ;
317: WHEN others THEN
318: x_return_status := fnd_api.g_ret_sts_unexp_error;
319: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
320: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
321: fnd_message.set_token('ROUTINE', l_full_name);
322: fnd_message.set_token('ERRNO', SQLCODE);
323: fnd_message.set_token('REASON', sqlerrm);
324: x_msg_data :=fnd_message.get();

Line 321: fnd_message.set_token('ROUTINE', l_full_name);

317: WHEN others THEN
318: x_return_status := fnd_api.g_ret_sts_unexp_error;
319: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
320: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
321: fnd_message.set_token('ROUTINE', l_full_name);
322: fnd_message.set_token('ERRNO', SQLCODE);
323: fnd_message.set_token('REASON', sqlerrm);
324: x_msg_data :=fnd_message.get();
325: END IF;

Line 322: fnd_message.set_token('ERRNO', SQLCODE);

318: x_return_status := fnd_api.g_ret_sts_unexp_error;
319: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
320: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
321: fnd_message.set_token('ROUTINE', l_full_name);
322: fnd_message.set_token('ERRNO', SQLCODE);
323: fnd_message.set_token('REASON', sqlerrm);
324: x_msg_data :=fnd_message.get();
325: END IF;
326: END Validate_SupplierDetails;

Line 323: fnd_message.set_token('REASON', sqlerrm);

319: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
320: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
321: fnd_message.set_token('ROUTINE', l_full_name);
322: fnd_message.set_token('ERRNO', SQLCODE);
323: fnd_message.set_token('REASON', sqlerrm);
324: x_msg_data :=fnd_message.get();
325: END IF;
326: END Validate_SupplierDetails;
327:

Line 324: x_msg_data :=fnd_message.get();

320: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
321: fnd_message.set_token('ROUTINE', l_full_name);
322: fnd_message.set_token('ERRNO', SQLCODE);
323: fnd_message.set_token('REASON', sqlerrm);
324: x_msg_data :=fnd_message.get();
325: END IF;
326: END Validate_SupplierDetails;
327:
328: PROCEDURE Validate_lines(

Line 405: fnd_message.set_name('DPP', 'DPP_DUPLICATE_TXN_LINES');

401: NULL;
402: END;
403: END IF;
404: IF l_duplicate_lines > 1 THEN
405: fnd_message.set_name('DPP', 'DPP_DUPLICATE_TXN_LINES');
406: x_msg_data := fnd_message.get();
407: p_txn_header_rec_type.error_code := 'DPP_DUPLICATE_TXN_LINES';
408: x_return_status := Fnd_Api.g_ret_sts_error ;
409: --RAISE Fnd_Api.G_EXC_ERROR;

Line 406: x_msg_data := fnd_message.get();

402: END;
403: END IF;
404: IF l_duplicate_lines > 1 THEN
405: fnd_message.set_name('DPP', 'DPP_DUPLICATE_TXN_LINES');
406: x_msg_data := fnd_message.get();
407: p_txn_header_rec_type.error_code := 'DPP_DUPLICATE_TXN_LINES';
408: x_return_status := Fnd_Api.g_ret_sts_error ;
409: --RAISE Fnd_Api.G_EXC_ERROR;
410: l_error_message := l_error_message ||x_msg_data;

Line 428: fnd_message.set_name('DPP', 'DPP_TXN_FUNC_CURR_ERR');

424: , hr_operating_units hr
425: WHERE hr.set_of_books_id = gs.set_of_books_id
426: AND hr.organization_id = p_txn_header_rec_type.org_id;
427: EXCEPTION WHEN OTHERS THEN
428: fnd_message.set_name('DPP', 'DPP_TXN_FUNC_CURR_ERR');
429: x_msg_data := fnd_message.get();
430: p_txn_header_rec_type.error_code := 'DPP_TXN_FUNC_CURR_ERR';
431: x_return_status := Fnd_Api.g_ret_sts_error ;
432: --RAISE Fnd_Api.G_EXC_ERROR;

Line 429: x_msg_data := fnd_message.get();

425: WHERE hr.set_of_books_id = gs.set_of_books_id
426: AND hr.organization_id = p_txn_header_rec_type.org_id;
427: EXCEPTION WHEN OTHERS THEN
428: fnd_message.set_name('DPP', 'DPP_TXN_FUNC_CURR_ERR');
429: x_msg_data := fnd_message.get();
430: p_txn_header_rec_type.error_code := 'DPP_TXN_FUNC_CURR_ERR';
431: x_return_status := Fnd_Api.g_ret_sts_error ;
432: --RAISE Fnd_Api.G_EXC_ERROR;
433: l_error_message := l_error_message ||x_msg_data;

Line 445: fnd_message.set_name('DPP', 'DPP_TXN_NO_LINES');

441: dpp_txn_lines_int_all dtla WHERE
442: dtla.transaction_int_header_id = p_txn_header_rec_type.transaction_int_header_id;
443: EXCEPTION
444: WHEN NO_DATA_FOUND THEN
445: fnd_message.set_name('DPP', 'DPP_TXN_NO_LINES');
446: x_msg_data :=fnd_message.get();
447: p_txn_header_rec_type.error_code := 'DPP_TXN_NO_LINES';
448: l_error_message := l_error_message ||x_msg_data;
449: x_return_status := Fnd_Api.g_ret_sts_error ;

Line 446: x_msg_data :=fnd_message.get();

442: dtla.transaction_int_header_id = p_txn_header_rec_type.transaction_int_header_id;
443: EXCEPTION
444: WHEN NO_DATA_FOUND THEN
445: fnd_message.set_name('DPP', 'DPP_TXN_NO_LINES');
446: x_msg_data :=fnd_message.get();
447: p_txn_header_rec_type.error_code := 'DPP_TXN_NO_LINES';
448: l_error_message := l_error_message ||x_msg_data;
449: x_return_status := Fnd_Api.g_ret_sts_error ;
450: WHEN TOO_MANY_ROWS THEN

Line 459: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

455: x_return_status := Fnd_Api.g_ret_sts_error ;
456: WHEN others THEN
457: x_return_status := fnd_api.g_ret_sts_unexp_error;
458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
459: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
460: fnd_message.set_token('ROUTINE', l_full_name);
461: fnd_message.set_token('ERRNO', SQLCODE);
462: fnd_message.set_token('REASON', sqlerrm);
463: x_msg_data :=fnd_message.get();

Line 460: fnd_message.set_token('ROUTINE', l_full_name);

456: WHEN others THEN
457: x_return_status := fnd_api.g_ret_sts_unexp_error;
458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
459: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
460: fnd_message.set_token('ROUTINE', l_full_name);
461: fnd_message.set_token('ERRNO', SQLCODE);
462: fnd_message.set_token('REASON', sqlerrm);
463: x_msg_data :=fnd_message.get();
464: END IF;

Line 461: fnd_message.set_token('ERRNO', SQLCODE);

457: x_return_status := fnd_api.g_ret_sts_unexp_error;
458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
459: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
460: fnd_message.set_token('ROUTINE', l_full_name);
461: fnd_message.set_token('ERRNO', SQLCODE);
462: fnd_message.set_token('REASON', sqlerrm);
463: x_msg_data :=fnd_message.get();
464: END IF;
465: END Validate_lines;

Line 462: fnd_message.set_token('REASON', sqlerrm);

458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
459: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
460: fnd_message.set_token('ROUTINE', l_full_name);
461: fnd_message.set_token('ERRNO', SQLCODE);
462: fnd_message.set_token('REASON', sqlerrm);
463: x_msg_data :=fnd_message.get();
464: END IF;
465: END Validate_lines;
466:

Line 463: x_msg_data :=fnd_message.get();

459: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
460: fnd_message.set_token('ROUTINE', l_full_name);
461: fnd_message.set_token('ERRNO', SQLCODE);
462: fnd_message.set_token('REASON', sqlerrm);
463: x_msg_data :=fnd_message.get();
464: END IF;
465: END Validate_lines;
466:
467: PROCEDURE Get_DaysCovered(

Line 493: fnd_message.set_name('DPP', 'DPP_DAYS_COVRD_ERR');

489: EXCEPTION
490: WHEN NO_DATA_FOUND THEN
491: x_return_status := fnd_api.g_ret_sts_error;
492: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
493: fnd_message.set_name('DPP', 'DPP_DAYS_COVRD_ERR');
494: fnd_message.set_token('SUPPLIER_NAME', p_txn_header_rec_type.vendor_name);
495: x_msg_data :=fnd_message.get();
496: END IF;
497: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 494: fnd_message.set_token('SUPPLIER_NAME', p_txn_header_rec_type.vendor_name);

490: WHEN NO_DATA_FOUND THEN
491: x_return_status := fnd_api.g_ret_sts_error;
492: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
493: fnd_message.set_name('DPP', 'DPP_DAYS_COVRD_ERR');
494: fnd_message.set_token('SUPPLIER_NAME', p_txn_header_rec_type.vendor_name);
495: x_msg_data :=fnd_message.get();
496: END IF;
497: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
498: p_txn_header_rec_type.error_code := 'DPP_DAYS_COVRD_ERR';

Line 495: x_msg_data :=fnd_message.get();

491: x_return_status := fnd_api.g_ret_sts_error;
492: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
493: fnd_message.set_name('DPP', 'DPP_DAYS_COVRD_ERR');
494: fnd_message.set_token('SUPPLIER_NAME', p_txn_header_rec_type.vendor_name);
495: x_msg_data :=fnd_message.get();
496: END IF;
497: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
498: p_txn_header_rec_type.error_code := 'DPP_DAYS_COVRD_ERR';
499: WHEN others THEN

Line 502: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

498: p_txn_header_rec_type.error_code := 'DPP_DAYS_COVRD_ERR';
499: WHEN others THEN
500: x_return_status := fnd_api.g_ret_sts_unexp_error;
501: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
502: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
503: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
504: fnd_message.set_token('ERRNO', SQLCODE);
505: fnd_message.set_token('REASON', sqlerrm);
506: END IF;

Line 503: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

499: WHEN others THEN
500: x_return_status := fnd_api.g_ret_sts_unexp_error;
501: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
502: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
503: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
504: fnd_message.set_token('ERRNO', SQLCODE);
505: fnd_message.set_token('REASON', sqlerrm);
506: END IF;
507: END Get_DaysCovered;

Line 504: fnd_message.set_token('ERRNO', SQLCODE);

500: x_return_status := fnd_api.g_ret_sts_unexp_error;
501: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
502: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
503: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
504: fnd_message.set_token('ERRNO', SQLCODE);
505: fnd_message.set_token('REASON', sqlerrm);
506: END IF;
507: END Get_DaysCovered;
508:

Line 505: fnd_message.set_token('REASON', sqlerrm);

501: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
502: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
503: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
504: fnd_message.set_token('ERRNO', SQLCODE);
505: fnd_message.set_token('REASON', sqlerrm);
506: END IF;
507: END Get_DaysCovered;
508:
509: PROCEDURE Validate_Currency(

Line 528: fnd_message.set_name('DPP', 'DPP_TXN_CURR_NULL');

524: IF DPP_DEBUG_HIGH_ON THEN
525: FND_FILE.PUT_LINE(FND_FILE.LOG,' Begin Validate Currency');
526: END IF;
527: IF p_txn_header_rec_type.trx_currency IS NULL THEN
528: fnd_message.set_name('DPP', 'DPP_TXN_CURR_NULL');
529: x_msg_data :=fnd_message.get();
530: p_txn_header_rec_type.error_code := 'DPP_TXN_CURR_NULL';
531: l_error_message := l_error_message || x_msg_data;
532: --RAISE Fnd_Api.G_EXC_ERROR ;

Line 529: x_msg_data :=fnd_message.get();

525: FND_FILE.PUT_LINE(FND_FILE.LOG,' Begin Validate Currency');
526: END IF;
527: IF p_txn_header_rec_type.trx_currency IS NULL THEN
528: fnd_message.set_name('DPP', 'DPP_TXN_CURR_NULL');
529: x_msg_data :=fnd_message.get();
530: p_txn_header_rec_type.error_code := 'DPP_TXN_CURR_NULL';
531: l_error_message := l_error_message || x_msg_data;
532: --RAISE Fnd_Api.G_EXC_ERROR ;
533: END IF;

Line 546: fnd_message.set_name('DPP', 'DPP_TXN_CURR_ERR');

542: FND_FILE.PUT_LINE(FND_FILE.LOG,' End Validate Currency');
543: END IF;
544: EXCEPTION WHEN no_data_found THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546: fnd_message.set_name('DPP', 'DPP_TXN_CURR_ERR');
547: fnd_message.set_token('CURRENCY_CODE', p_txn_header_rec_type.trx_currency);
548: x_msg_data :=fnd_message.get();
549: l_error_message := l_error_message || x_msg_data;
550: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 547: fnd_message.set_token('CURRENCY_CODE', p_txn_header_rec_type.trx_currency);

543: END IF;
544: EXCEPTION WHEN no_data_found THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546: fnd_message.set_name('DPP', 'DPP_TXN_CURR_ERR');
547: fnd_message.set_token('CURRENCY_CODE', p_txn_header_rec_type.trx_currency);
548: x_msg_data :=fnd_message.get();
549: l_error_message := l_error_message || x_msg_data;
550: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
551: p_txn_header_rec_type.error_code := 'DPP_TXN_CURR_ERR';

Line 548: x_msg_data :=fnd_message.get();

544: EXCEPTION WHEN no_data_found THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546: fnd_message.set_name('DPP', 'DPP_TXN_CURR_ERR');
547: fnd_message.set_token('CURRENCY_CODE', p_txn_header_rec_type.trx_currency);
548: x_msg_data :=fnd_message.get();
549: l_error_message := l_error_message || x_msg_data;
550: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
551: p_txn_header_rec_type.error_code := 'DPP_TXN_CURR_ERR';
552: END;

Line 563: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');

559: FROM dual;
560: EXCEPTION
561: WHEN no_data_found THEN
562: x_return_status := fnd_api.g_ret_sts_error;
563: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
564: fnd_message.set_token('SEQ_NUM', 'Transaction Header Id');
565: x_msg_data := fnd_message.get();
566: l_error_message := l_error_message || x_msg_data;
567: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 564: fnd_message.set_token('SEQ_NUM', 'Transaction Header Id');

560: EXCEPTION
561: WHEN no_data_found THEN
562: x_return_status := fnd_api.g_ret_sts_error;
563: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
564: fnd_message.set_token('SEQ_NUM', 'Transaction Header Id');
565: x_msg_data := fnd_message.get();
566: l_error_message := l_error_message || x_msg_data;
567: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
568: l_error_message :=l_error_message|| x_msg_data;

Line 565: x_msg_data := fnd_message.get();

561: WHEN no_data_found THEN
562: x_return_status := fnd_api.g_ret_sts_error;
563: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
564: fnd_message.set_token('SEQ_NUM', 'Transaction Header Id');
565: x_msg_data := fnd_message.get();
566: l_error_message := l_error_message || x_msg_data;
567: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
568: l_error_message :=l_error_message|| x_msg_data;
569: p_txn_header_rec_type.error_code := 'DPP_TXN_SEQ_NO_ERR';

Line 584: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');

580: EXCEPTION
581: WHEN no_data_found THEN
582: x_return_status := fnd_api.g_ret_sts_error;
583: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
584: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
585: fnd_message.set_token('SEQ_NUM', 'Transaction Number');
586: END IF;
587: x_msg_data := fnd_message.get();
588: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 585: fnd_message.set_token('SEQ_NUM', 'Transaction Number');

581: WHEN no_data_found THEN
582: x_return_status := fnd_api.g_ret_sts_error;
583: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
584: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
585: fnd_message.set_token('SEQ_NUM', 'Transaction Number');
586: END IF;
587: x_msg_data := fnd_message.get();
588: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
589: p_txn_header_rec_type.error_code := 'DPP_TXN_SEQ_NO_ERR';

Line 587: x_msg_data := fnd_message.get();

583: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
584: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
585: fnd_message.set_token('SEQ_NUM', 'Transaction Number');
586: END IF;
587: x_msg_data := fnd_message.get();
588: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
589: p_txn_header_rec_type.error_code := 'DPP_TXN_SEQ_NO_ERR';
590: l_error_message :=l_error_message|| x_msg_data;
591: --RAISE Fnd_Api.G_EXC_ERROR;

Line 619: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');

615: EXCEPTION
616: WHEN no_data_found THEN
617: x_return_status := fnd_api.g_ret_sts_error;
618: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
619: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
620: END IF;
621: x_msg_data := fnd_message.get();
622: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
623: p_txn_header_rec_type.error_code := 'DPP_TXN_STS_ERR';

Line 621: x_msg_data := fnd_message.get();

617: x_return_status := fnd_api.g_ret_sts_error;
618: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
619: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
620: END IF;
621: x_msg_data := fnd_message.get();
622: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
623: p_txn_header_rec_type.error_code := 'DPP_TXN_STS_ERR';
624: l_error_message :=l_error_message|| x_msg_data;
625: --RAISE Fnd_Api.G_EXC_ERROR;

Line 650: fnd_message.set_name('DPP', 'DPP_TXN_DAYS_COV_ERR');

646: OR p_txn_header_rec_type.days_covered <> ROUND(p_txn_header_rec_type.days_covered)
647: THEN
648: x_return_status := fnd_api.g_ret_sts_error;
649: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
650: fnd_message.set_name('DPP', 'DPP_TXN_DAYS_COV_ERR');
651: END IF;
652: x_msg_data := fnd_message.get();
653: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
654: p_txn_header_rec_type.error_code := 'DPP_TXN_DAYS_COV_ERR';

Line 652: x_msg_data := fnd_message.get();

648: x_return_status := fnd_api.g_ret_sts_error;
649: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
650: fnd_message.set_name('DPP', 'DPP_TXN_DAYS_COV_ERR');
651: END IF;
652: x_msg_data := fnd_message.get();
653: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
654: p_txn_header_rec_type.error_code := 'DPP_TXN_DAYS_COV_ERR';
655: l_error_message :=l_error_message|| x_msg_data;
656: --RAISE Fnd_Api.g_exc_error;

Line 661: fnd_message.set_name('DPP', 'DPP_EFF_START_DATE_ERR');

657: END IF;
658: IF p_txn_header_rec_type.effective_start_date IS NULL THEN
659: x_return_status := fnd_api.g_ret_sts_error;
660: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
661: fnd_message.set_name('DPP', 'DPP_EFF_START_DATE_ERR');
662: END IF;
663: x_msg_data := fnd_message.get();
664: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
665: p_txn_header_rec_type.error_code := 'DPP_EFF_START_DATE_ERR';

Line 663: x_msg_data := fnd_message.get();

659: x_return_status := fnd_api.g_ret_sts_error;
660: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
661: fnd_message.set_name('DPP', 'DPP_EFF_START_DATE_ERR');
662: END IF;
663: x_msg_data := fnd_message.get();
664: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
665: p_txn_header_rec_type.error_code := 'DPP_EFF_START_DATE_ERR';
666: l_error_message :=l_error_message|| x_msg_data;
667: --RAISE Fnd_Api.g_exc_error;

Line 681: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

677: x_return_status := Fnd_Api.g_ret_sts_error ;
678: WHEN others THEN
679: x_return_status := fnd_api.g_ret_sts_unexp_error;
680: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
681: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
682: fnd_message.set_token('ROUTINE', l_full_name);
683: fnd_message.set_token('ERRNO', SQLCODE);
684: fnd_message.set_token('REASON', sqlerrm);
685: END IF;

Line 682: fnd_message.set_token('ROUTINE', l_full_name);

678: WHEN others THEN
679: x_return_status := fnd_api.g_ret_sts_unexp_error;
680: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
681: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
682: fnd_message.set_token('ROUTINE', l_full_name);
683: fnd_message.set_token('ERRNO', SQLCODE);
684: fnd_message.set_token('REASON', sqlerrm);
685: END IF;
686: x_msg_data :=fnd_message.get();

Line 683: fnd_message.set_token('ERRNO', SQLCODE);

679: x_return_status := fnd_api.g_ret_sts_unexp_error;
680: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
681: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
682: fnd_message.set_token('ROUTINE', l_full_name);
683: fnd_message.set_token('ERRNO', SQLCODE);
684: fnd_message.set_token('REASON', sqlerrm);
685: END IF;
686: x_msg_data :=fnd_message.get();
687: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 684: fnd_message.set_token('REASON', sqlerrm);

680: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
681: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
682: fnd_message.set_token('ROUTINE', l_full_name);
683: fnd_message.set_token('ERRNO', SQLCODE);
684: fnd_message.set_token('REASON', sqlerrm);
685: END IF;
686: x_msg_data :=fnd_message.get();
687: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
688: END Validate_Currency;

Line 686: x_msg_data :=fnd_message.get();

682: fnd_message.set_token('ROUTINE', l_full_name);
683: fnd_message.set_token('ERRNO', SQLCODE);
684: fnd_message.set_token('REASON', sqlerrm);
685: END IF;
686: x_msg_data :=fnd_message.get();
687: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
688: END Validate_Currency;
689:
690:

Line 852: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

848: dpp_utility_pvt.debug_message('Create Header OTHERS'||sqlerrm);
849: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
850: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
851: THEN
852: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
853: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
854: fnd_message.set_token('ERRNO', SQLCODE);
855: fnd_message.set_token('REASON', sqlerrm);
856: END IF;

Line 853: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

849: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
850: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
851: THEN
852: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
853: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
854: fnd_message.set_token('ERRNO', SQLCODE);
855: fnd_message.set_token('REASON', sqlerrm);
856: END IF;
857: x_msg_data := fnd_message.get;

Line 854: fnd_message.set_token('ERRNO', SQLCODE);

850: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
851: THEN
852: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
853: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
854: fnd_message.set_token('ERRNO', SQLCODE);
855: fnd_message.set_token('REASON', sqlerrm);
856: END IF;
857: x_msg_data := fnd_message.get;
858: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 855: fnd_message.set_token('REASON', sqlerrm);

851: THEN
852: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
853: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
854: fnd_message.set_token('ERRNO', SQLCODE);
855: fnd_message.set_token('REASON', sqlerrm);
856: END IF;
857: x_msg_data := fnd_message.get;
858: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
859: END Create_Header;

Line 857: x_msg_data := fnd_message.get;

853: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
854: fnd_message.set_token('ERRNO', SQLCODE);
855: fnd_message.set_token('REASON', sqlerrm);
856: END IF;
857: x_msg_data := fnd_message.get;
858: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
859: END Create_Header;
860: PROCEDURE Validate_SupplierPartNum(
861: p_txn_header_rec_type IN OUT nocopy txn_header_rec

Line 895: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');

891: EXCEPTION
892: WHEN no_data_found THEN
893: x_return_status := fnd_api.g_ret_sts_error;
894: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
895: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
896: fnd_message.set_token('SEQ_NUM', 'Transaction Line Id');
897: END IF;
898: x_msg_data := fnd_message.get();
899: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 896: fnd_message.set_token('SEQ_NUM', 'Transaction Line Id');

892: WHEN no_data_found THEN
893: x_return_status := fnd_api.g_ret_sts_error;
894: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
895: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
896: fnd_message.set_token('SEQ_NUM', 'Transaction Line Id');
897: END IF;
898: x_msg_data := fnd_message.get();
899: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
900: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SEQ_NO_ERR';

Line 898: x_msg_data := fnd_message.get();

894: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
895: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');
896: fnd_message.set_token('SEQ_NUM', 'Transaction Line Id');
897: END IF;
898: x_msg_data := fnd_message.get();
899: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
900: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SEQ_NO_ERR';
901: IF p_txn_header_rec_type.error_code IS NULL THEN
902: p_txn_header_rec_type.error_code := 'DPP_TXN_SEQ_NO_ERR';

Line 920: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');

916: EXCEPTION
917: WHEN no_data_found THEN
918: x_return_status := fnd_api.g_ret_sts_error;
919: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
920: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
921: END IF;
922: x_msg_data := fnd_message.get();
923: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
924: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_STS_ERR';

Line 922: x_msg_data := fnd_message.get();

918: x_return_status := fnd_api.g_ret_sts_error;
919: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
920: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
921: END IF;
922: x_msg_data := fnd_message.get();
923: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
924: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_STS_ERR';
925: IF p_txn_header_rec_type.error_code IS NULL THEN
926: p_txn_header_rec_type.error_code := 'DPP_TXN_STS_ERR';

Line 937: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_NULL');

933: --BUG 6806974
934: IF (p_txn_lines_tbl_type(i).supplier_part_num IS NULL AND p_txn_lines_tbl_type(i).item_number IS NULL
935: AND p_txn_lines_tbl_type(i).inventory_item_id IS NULL) THEN
936: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
937: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_NULL');
938: END IF;
939: x_msg_data := fnd_message.get();
940: l_error_message :=l_error_message|| x_msg_data;
941: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 939: x_msg_data := fnd_message.get();

935: AND p_txn_lines_tbl_type(i).inventory_item_id IS NULL) THEN
936: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
937: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_NULL');
938: END IF;
939: x_msg_data := fnd_message.get();
940: l_error_message :=l_error_message|| x_msg_data;
941: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
942: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_NULL';
943:

Line 1010: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');

1006: END IF;
1007: EXCEPTION
1008: WHEN no_data_found THEN
1009: x_return_status := fnd_api.g_ret_sts_error;
1010: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1011: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1012: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1013: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1014: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);

Line 1011: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);

1007: EXCEPTION
1008: WHEN no_data_found THEN
1009: x_return_status := fnd_api.g_ret_sts_error;
1010: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1011: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1012: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1013: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1014: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1015: x_msg_data := fnd_message.get();

Line 1012: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);

1008: WHEN no_data_found THEN
1009: x_return_status := fnd_api.g_ret_sts_error;
1010: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1011: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1012: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1013: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1014: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1015: x_msg_data := fnd_message.get();
1016: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_ERR';

Line 1013: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);

1009: x_return_status := fnd_api.g_ret_sts_error;
1010: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1011: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1012: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1013: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1014: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1015: x_msg_data := fnd_message.get();
1016: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_ERR';
1017: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1014: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);

1010: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1011: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1012: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1013: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1014: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1015: x_msg_data := fnd_message.get();
1016: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_ERR';
1017: IF p_txn_header_rec_type.error_code IS NULL THEN
1018: p_txn_header_rec_type.error_code := 'DPP_TXN_SUP_PART_NO_ERR';

Line 1015: x_msg_data := fnd_message.get();

1011: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1012: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1013: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1014: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1015: x_msg_data := fnd_message.get();
1016: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_ERR';
1017: IF p_txn_header_rec_type.error_code IS NULL THEN
1018: p_txn_header_rec_type.error_code := 'DPP_TXN_SUP_PART_NO_ERR';
1019: ELSE

Line 1026: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1022: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1023: l_error_message :=l_error_message|| x_msg_data;
1024: ELSE
1025: l_msg_exceeded := 'Y';
1026: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1027: x_msg_data := fnd_message.get();
1028: l_error_message := x_msg_data;
1029: END IF;
1030: END;

Line 1027: x_msg_data := fnd_message.get();

1023: l_error_message :=l_error_message|| x_msg_data;
1024: ELSE
1025: l_msg_exceeded := 'Y';
1026: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1027: x_msg_data := fnd_message.get();
1028: l_error_message := x_msg_data;
1029: END IF;
1030: END;
1031:

Line 1051: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');

1047: AND occ.external_code =p_txn_lines_tbl_type(i).supplier_part_num;
1048: EXCEPTION
1049: WHEN no_data_found THEN
1050: x_return_status := fnd_api.g_ret_sts_error;
1051: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1052: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1053: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1054: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1055: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);

Line 1052: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);

1048: EXCEPTION
1049: WHEN no_data_found THEN
1050: x_return_status := fnd_api.g_ret_sts_error;
1051: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1052: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1053: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1054: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1055: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1056: x_msg_data := fnd_message.get();

Line 1053: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);

1049: WHEN no_data_found THEN
1050: x_return_status := fnd_api.g_ret_sts_error;
1051: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1052: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1053: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1054: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1055: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1056: x_msg_data := fnd_message.get();
1057: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_ERR';

Line 1054: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);

1050: x_return_status := fnd_api.g_ret_sts_error;
1051: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1052: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1053: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1054: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1055: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1056: x_msg_data := fnd_message.get();
1057: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_ERR';
1058: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1055: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);

1051: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1052: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1053: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1054: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1055: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1056: x_msg_data := fnd_message.get();
1057: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_ERR';
1058: IF p_txn_header_rec_type.error_code IS NULL THEN
1059: p_txn_header_rec_type.error_code := 'DPP_TXN_SUP_PART_NO_ERR';

Line 1056: x_msg_data := fnd_message.get();

1052: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1053: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1054: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1055: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1056: x_msg_data := fnd_message.get();
1057: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_ERR';
1058: IF p_txn_header_rec_type.error_code IS NULL THEN
1059: p_txn_header_rec_type.error_code := 'DPP_TXN_SUP_PART_NO_ERR';
1060: ELSE

Line 1068: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1064: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1065: l_error_message :=l_error_message|| x_msg_data;
1066: ELSE
1067: l_msg_exceeded := 'Y';
1068: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1069: x_msg_data := fnd_message.get();
1070: l_error_message := x_msg_data;
1071: END IF;
1072:

Line 1069: x_msg_data := fnd_message.get();

1065: l_error_message :=l_error_message|| x_msg_data;
1066: ELSE
1067: l_msg_exceeded := 'Y';
1068: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1069: x_msg_data := fnd_message.get();
1070: l_error_message := x_msg_data;
1071: END IF;
1072:
1073: WHEN TOO_MANY_ROWS THEN

Line 1074: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');

1070: l_error_message := x_msg_data;
1071: END IF;
1072:
1073: WHEN TOO_MANY_ROWS THEN
1074: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');
1075: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1076: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1077: x_msg_data := fnd_message.get();
1078: p_txn_header_rec_type.error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';

Line 1075: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);

1071: END IF;
1072:
1073: WHEN TOO_MANY_ROWS THEN
1074: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');
1075: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1076: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1077: x_msg_data := fnd_message.get();
1078: p_txn_header_rec_type.error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';
1079: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 1076: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);

1072:
1073: WHEN TOO_MANY_ROWS THEN
1074: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');
1075: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1076: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1077: x_msg_data := fnd_message.get();
1078: p_txn_header_rec_type.error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';
1079: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1080: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN

Line 1077: x_msg_data := fnd_message.get();

1073: WHEN TOO_MANY_ROWS THEN
1074: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');
1075: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1076: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1077: x_msg_data := fnd_message.get();
1078: p_txn_header_rec_type.error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';
1079: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1080: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1081: l_error_message :=l_error_message|| x_msg_data;

Line 1084: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1080: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1081: l_error_message :=l_error_message|| x_msg_data;
1082: ELSE
1083: l_msg_exceeded := 'Y';
1084: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1085: x_msg_data := fnd_message.get();
1086: l_error_message := x_msg_data;
1087: END IF;
1088:

Line 1085: x_msg_data := fnd_message.get();

1081: l_error_message :=l_error_message|| x_msg_data;
1082: ELSE
1083: l_msg_exceeded := 'Y';
1084: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1085: x_msg_data := fnd_message.get();
1086: l_error_message := x_msg_data;
1087: END IF;
1088:
1089: END;

Line 1110: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');

1106: FND_FILE.PUT_LINE(FND_FILE.LOG,' Supplier Part Number does not exist for Item Number '|| p_txn_lines_tbl_type(i).item_number ||
1107: '( Inventory Item ID '|| p_txn_lines_tbl_type(i).inventory_item_id );
1108: END IF;
1109: WHEN TOO_MANY_ROWS THEN
1110: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');
1111: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1112: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1113: x_msg_data := fnd_message.get();
1114: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';

Line 1111: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);

1107: '( Inventory Item ID '|| p_txn_lines_tbl_type(i).inventory_item_id );
1108: END IF;
1109: WHEN TOO_MANY_ROWS THEN
1110: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');
1111: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1112: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1113: x_msg_data := fnd_message.get();
1114: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';
1115: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1112: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);

1108: END IF;
1109: WHEN TOO_MANY_ROWS THEN
1110: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');
1111: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1112: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1113: x_msg_data := fnd_message.get();
1114: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';
1115: IF p_txn_header_rec_type.error_code IS NULL THEN
1116: p_txn_header_rec_type.error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';

Line 1113: x_msg_data := fnd_message.get();

1109: WHEN TOO_MANY_ROWS THEN
1110: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');
1111: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1112: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1113: x_msg_data := fnd_message.get();
1114: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';
1115: IF p_txn_header_rec_type.error_code IS NULL THEN
1116: p_txn_header_rec_type.error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';
1117: ELSE

Line 1125: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1121: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1122: l_error_message :=l_error_message|| x_msg_data;
1123: ELSE
1124: l_msg_exceeded := 'Y';
1125: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1126: x_msg_data := fnd_message.get();
1127: l_error_message := x_msg_data;
1128: END IF;
1129:

Line 1126: x_msg_data := fnd_message.get();

1122: l_error_message :=l_error_message|| x_msg_data;
1123: ELSE
1124: l_msg_exceeded := 'Y';
1125: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1126: x_msg_data := fnd_message.get();
1127: l_error_message := x_msg_data;
1128: END IF;
1129:
1130: END;

Line 1150: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');

1146: AND (trunc(sysdate) between occ.start_date_active and occ.end_date_active OR occ.end_date_active is null)
1147: AND occ.external_code =p_txn_lines_tbl_type(i).supplier_part_num;
1148: EXCEPTION WHEN NO_DATA_FOUND THEN
1149: x_return_status := fnd_api.g_ret_sts_error;
1150: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1151: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1152: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1153: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1154: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);

Line 1151: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);

1147: AND occ.external_code =p_txn_lines_tbl_type(i).supplier_part_num;
1148: EXCEPTION WHEN NO_DATA_FOUND THEN
1149: x_return_status := fnd_api.g_ret_sts_error;
1150: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1151: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1152: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1153: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1154: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1155: x_msg_data := fnd_message.get();

Line 1152: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);

1148: EXCEPTION WHEN NO_DATA_FOUND THEN
1149: x_return_status := fnd_api.g_ret_sts_error;
1150: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1151: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1152: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1153: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1154: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1155: x_msg_data := fnd_message.get();
1156: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_ERR';

Line 1153: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);

1149: x_return_status := fnd_api.g_ret_sts_error;
1150: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1151: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1152: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1153: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1154: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1155: x_msg_data := fnd_message.get();
1156: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_ERR';
1157: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1154: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);

1150: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_NO_ERR');
1151: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1152: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1153: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1154: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1155: x_msg_data := fnd_message.get();
1156: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_ERR';
1157: IF p_txn_header_rec_type.error_code IS NULL THEN
1158: p_txn_header_rec_type.error_code := 'DPP_TXN_SUP_PART_NO_ERR';

Line 1155: x_msg_data := fnd_message.get();

1151: fnd_message.set_token('SUPPLIER_PART_NUM', p_txn_lines_tbl_type(i).supplier_part_num);
1152: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1153: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1154: fnd_message.set_token('UOM_CODE', p_txn_lines_tbl_type(i).uom);
1155: x_msg_data := fnd_message.get();
1156: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_NO_ERR';
1157: IF p_txn_header_rec_type.error_code IS NULL THEN
1158: p_txn_header_rec_type.error_code := 'DPP_TXN_SUP_PART_NO_ERR';
1159: ELSE

Line 1166: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1162: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1163: l_error_message :=l_error_message|| x_msg_data;
1164: ELSE
1165: l_msg_exceeded := 'Y';
1166: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1167: x_msg_data := fnd_message.get();
1168:
1169: l_error_message := x_msg_data;
1170: END IF;

Line 1167: x_msg_data := fnd_message.get();

1163: l_error_message :=l_error_message|| x_msg_data;
1164: ELSE
1165: l_msg_exceeded := 'Y';
1166: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1167: x_msg_data := fnd_message.get();
1168:
1169: l_error_message := x_msg_data;
1170: END IF;
1171:

Line 1173: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');

1169: l_error_message := x_msg_data;
1170: END IF;
1171:
1172: WHEN TOO_MANY_ROWS THEN
1173: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');
1174: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1175: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1176: x_msg_data := fnd_message.get();
1177: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 1174: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);

1170: END IF;
1171:
1172: WHEN TOO_MANY_ROWS THEN
1173: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');
1174: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1175: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1176: x_msg_data := fnd_message.get();
1177: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1178: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';

Line 1175: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);

1171:
1172: WHEN TOO_MANY_ROWS THEN
1173: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');
1174: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1175: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1176: x_msg_data := fnd_message.get();
1177: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1178: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';
1179: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1176: x_msg_data := fnd_message.get();

1172: WHEN TOO_MANY_ROWS THEN
1173: fnd_message.set_name('DPP', 'DPP_TXN_DUP_SUP_PART_NUM_ERR');
1174: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1175: fnd_message.set_token('INVENTORY_ITEM_ID', p_txn_lines_tbl_type(i).inventory_item_id);
1176: x_msg_data := fnd_message.get();
1177: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1178: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';
1179: IF p_txn_header_rec_type.error_code IS NULL THEN
1180: p_txn_header_rec_type.error_code := 'DPP_TXN_DUP_SUP_PART_NUM_ERR';

Line 1188: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1184: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1185: l_error_message :=l_error_message|| x_msg_data;
1186: ELSE
1187: l_msg_exceeded := 'Y';
1188: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1189: x_msg_data := fnd_message.get();
1190: l_error_message := x_msg_data;
1191: END IF;
1192:

Line 1189: x_msg_data := fnd_message.get();

1185: l_error_message :=l_error_message|| x_msg_data;
1186: ELSE
1187: l_msg_exceeded := 'Y';
1188: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1189: x_msg_data := fnd_message.get();
1190: l_error_message := x_msg_data;
1191: END IF;
1192:
1193:

Line 1229: fnd_message.set_name('DPP', 'DPP_TXN_CONV_PRICE_ER');

1225: ,x_to_amount => p_txn_lines_tbl_type(i).prior_price
1226: ,x_rate => l_exchange_rate);
1227:
1228: IF x_return_status <>fnd_api.g_ret_sts_success THEN
1229: fnd_message.set_name('DPP', 'DPP_TXN_CONV_PRICE_ER');
1230: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1231: x_msg_data := fnd_message.get();
1232: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CONV_PRICE_ER';
1233: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1230: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);

1226: ,x_rate => l_exchange_rate);
1227:
1228: IF x_return_status <>fnd_api.g_ret_sts_success THEN
1229: fnd_message.set_name('DPP', 'DPP_TXN_CONV_PRICE_ER');
1230: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1231: x_msg_data := fnd_message.get();
1232: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CONV_PRICE_ER';
1233: IF p_txn_header_rec_type.error_code IS NULL THEN
1234: p_txn_header_rec_type.error_code := 'DPP_TXN_CONV_PRICE_ER';

Line 1231: x_msg_data := fnd_message.get();

1227:
1228: IF x_return_status <>fnd_api.g_ret_sts_success THEN
1229: fnd_message.set_name('DPP', 'DPP_TXN_CONV_PRICE_ER');
1230: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1231: x_msg_data := fnd_message.get();
1232: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CONV_PRICE_ER';
1233: IF p_txn_header_rec_type.error_code IS NULL THEN
1234: p_txn_header_rec_type.error_code := 'DPP_TXN_CONV_PRICE_ER';
1235: ELSE

Line 1245: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_LIST_PRICE_ER');

1241: END IF;
1242: END IF;
1243: dpp_utility_pvt.debug_message('Prior Price:'||p_txn_lines_tbl_type(i).prior_price);
1244: IF p_txn_lines_tbl_type(i).prior_price IS NULL THEN
1245: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_LIST_PRICE_ER');
1246: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1247: x_msg_data := fnd_message.get();
1248: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_LIST_PRICE_ER';
1249: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1246: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);

1242: END IF;
1243: dpp_utility_pvt.debug_message('Prior Price:'||p_txn_lines_tbl_type(i).prior_price);
1244: IF p_txn_lines_tbl_type(i).prior_price IS NULL THEN
1245: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_LIST_PRICE_ER');
1246: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1247: x_msg_data := fnd_message.get();
1248: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_LIST_PRICE_ER';
1249: IF p_txn_header_rec_type.error_code IS NULL THEN
1250: p_txn_header_rec_type.error_code := 'DPP_TXN_SUP_PART_LIST_PRICE_ER';

Line 1247: x_msg_data := fnd_message.get();

1243: dpp_utility_pvt.debug_message('Prior Price:'||p_txn_lines_tbl_type(i).prior_price);
1244: IF p_txn_lines_tbl_type(i).prior_price IS NULL THEN
1245: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_LIST_PRICE_ER');
1246: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1247: x_msg_data := fnd_message.get();
1248: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_LIST_PRICE_ER';
1249: IF p_txn_header_rec_type.error_code IS NULL THEN
1250: p_txn_header_rec_type.error_code := 'DPP_TXN_SUP_PART_LIST_PRICE_ER';
1251: ELSE

Line 1260: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1256: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1257: l_error_message :=l_error_message|| x_msg_data;
1258: ELSE
1259: l_msg_exceeded := 'Y';
1260: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1261: x_msg_data := fnd_message.get();
1262: l_error_message := x_msg_data;
1263: END IF;
1264: END IF;

Line 1261: x_msg_data := fnd_message.get();

1257: l_error_message :=l_error_message|| x_msg_data;
1258: ELSE
1259: l_msg_exceeded := 'Y';
1260: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1261: x_msg_data := fnd_message.get();
1262: l_error_message := x_msg_data;
1263: END IF;
1264: END IF;
1265: END IF;

Line 1269: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_LIST_PRICE_ER');

1265: END IF;
1266: END IF;
1267: EXCEPTION
1268: WHEN no_data_found THEN
1269: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_LIST_PRICE_ER');
1270: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1271: x_msg_data := fnd_message.get();
1272: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_LIST_PRICE_ER';
1273: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1270: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);

1266: END IF;
1267: EXCEPTION
1268: WHEN no_data_found THEN
1269: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_LIST_PRICE_ER');
1270: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1271: x_msg_data := fnd_message.get();
1272: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_LIST_PRICE_ER';
1273: IF p_txn_header_rec_type.error_code IS NULL THEN
1274: p_txn_header_rec_type.error_code := 'DPP_TXN_SUP_PART_LIST_PRICE_ER';

Line 1271: x_msg_data := fnd_message.get();

1267: EXCEPTION
1268: WHEN no_data_found THEN
1269: fnd_message.set_name('DPP', 'DPP_TXN_SUP_PART_LIST_PRICE_ER');
1270: fnd_message.set_token('ITEM_NUMBER', p_txn_lines_tbl_type(i).item_number);
1271: x_msg_data := fnd_message.get();
1272: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_SUP_PART_LIST_PRICE_ER';
1273: IF p_txn_header_rec_type.error_code IS NULL THEN
1274: p_txn_header_rec_type.error_code := 'DPP_TXN_SUP_PART_LIST_PRICE_ER';
1275: ELSE

Line 1284: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1280: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1281: l_error_message :=l_error_message|| x_msg_data;
1282: ELSE
1283: l_msg_exceeded := 'Y';
1284: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1285: x_msg_data := fnd_message.get();
1286: l_error_message := x_msg_data;
1287: END IF;
1288: END;

Line 1285: x_msg_data := fnd_message.get();

1281: l_error_message :=l_error_message|| x_msg_data;
1282: ELSE
1283: l_msg_exceeded := 'Y';
1284: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1285: x_msg_data := fnd_message.get();
1286: l_error_message := x_msg_data;
1287: END IF;
1288: END;
1289:

Line 1293: fnd_message.set_name('DPP', 'DPP_CHANGE_VALUE_NULL');

1289:
1290: --Validation for Change Value
1291: IF p_txn_lines_tbl_type(i).change_value IS NULL THEN
1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' Change Value is null');
1293: fnd_message.set_name('DPP', 'DPP_CHANGE_VALUE_NULL');
1294: x_msg_data := fnd_message.get();
1295: p_txn_lines_tbl_type(i).error_code := 'DPP_CHANGE_VALUE_NULL';
1296: IF p_txn_header_rec_type.error_code IS NULL THEN
1297: p_txn_header_rec_type.error_code := 'DPP_CHANGE_VALUE_NULL';

Line 1294: x_msg_data := fnd_message.get();

1290: --Validation for Change Value
1291: IF p_txn_lines_tbl_type(i).change_value IS NULL THEN
1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' Change Value is null');
1293: fnd_message.set_name('DPP', 'DPP_CHANGE_VALUE_NULL');
1294: x_msg_data := fnd_message.get();
1295: p_txn_lines_tbl_type(i).error_code := 'DPP_CHANGE_VALUE_NULL';
1296: IF p_txn_header_rec_type.error_code IS NULL THEN
1297: p_txn_header_rec_type.error_code := 'DPP_CHANGE_VALUE_NULL';
1298: ELSE

Line 1305: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1301: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1302: l_error_message :=l_error_message|| x_msg_data;
1303: ELSE
1304: l_msg_exceeded := 'Y';
1305: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1306: x_msg_data := fnd_message.get();
1307: l_error_message := x_msg_data;
1308: END IF;
1309: END IF;

Line 1306: x_msg_data := fnd_message.get();

1302: l_error_message :=l_error_message|| x_msg_data;
1303: ELSE
1304: l_msg_exceeded := 'Y';
1305: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1306: x_msg_data := fnd_message.get();
1307: l_error_message := x_msg_data;
1308: END IF;
1309: END IF;
1310:

Line 1313: fnd_message.set_name('DPP', 'DPP_CHANGE_TYPE_NULL');

1309: END IF;
1310:
1311: IF p_txn_lines_tbl_type(i).change_type IS NULL THEN
1312: FND_FILE.PUT_LINE(FND_FILE.LOG,' Change type is null');
1313: fnd_message.set_name('DPP', 'DPP_CHANGE_TYPE_NULL');
1314: x_msg_data := fnd_message.get();
1315: p_txn_lines_tbl_type(i).error_code := 'DPP_CHANGE_TYPE_NULL';
1316: IF p_txn_header_rec_type.error_code IS NULL THEN
1317: p_txn_header_rec_type.error_code := 'DPP_CHANGE_TYPE_NULL';

Line 1314: x_msg_data := fnd_message.get();

1310:
1311: IF p_txn_lines_tbl_type(i).change_type IS NULL THEN
1312: FND_FILE.PUT_LINE(FND_FILE.LOG,' Change type is null');
1313: fnd_message.set_name('DPP', 'DPP_CHANGE_TYPE_NULL');
1314: x_msg_data := fnd_message.get();
1315: p_txn_lines_tbl_type(i).error_code := 'DPP_CHANGE_TYPE_NULL';
1316: IF p_txn_header_rec_type.error_code IS NULL THEN
1317: p_txn_header_rec_type.error_code := 'DPP_CHANGE_TYPE_NULL';
1318: ELSE

Line 1325: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1321: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1322: l_error_message :=l_error_message|| x_msg_data;
1323: ELSE
1324: l_msg_exceeded := 'Y';
1325: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1326: x_msg_data := fnd_message.get();
1327: l_error_message := x_msg_data;
1328: END IF;
1329: END IF;

Line 1326: x_msg_data := fnd_message.get();

1322: l_error_message :=l_error_message|| x_msg_data;
1323: ELSE
1324: l_msg_exceeded := 'Y';
1325: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1326: x_msg_data := fnd_message.get();
1327: l_error_message := x_msg_data;
1328: END IF;
1329: END IF;
1330:

Line 1338: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');

1334:
1335: IF p_txn_lines_tbl_type(i).change_type = 'NEW_PRICE' THEN
1336: IF p_txn_lines_tbl_type(i).change_value <= 0 THEN
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,' Negative Price Change Value:' || p_txn_lines_tbl_type(i).change_value ||'. Please enter a valid Change value.');
1338: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1339: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1340: x_msg_data := fnd_message.get();
1341: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1342: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1339: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );

1335: IF p_txn_lines_tbl_type(i).change_type = 'NEW_PRICE' THEN
1336: IF p_txn_lines_tbl_type(i).change_value <= 0 THEN
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,' Negative Price Change Value:' || p_txn_lines_tbl_type(i).change_value ||'. Please enter a valid Change value.');
1338: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1339: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1340: x_msg_data := fnd_message.get();
1341: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1342: IF p_txn_header_rec_type.error_code IS NULL THEN
1343: p_txn_header_rec_type.error_code := 'DPP_TXN_CHANGE_VALUE_ERR';

Line 1340: x_msg_data := fnd_message.get();

1336: IF p_txn_lines_tbl_type(i).change_value <= 0 THEN
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,' Negative Price Change Value:' || p_txn_lines_tbl_type(i).change_value ||'. Please enter a valid Change value.');
1338: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1339: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1340: x_msg_data := fnd_message.get();
1341: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1342: IF p_txn_header_rec_type.error_code IS NULL THEN
1343: p_txn_header_rec_type.error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1344: ELSE

Line 1351: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1347: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1348: l_error_message :=l_error_message|| x_msg_data;
1349: ELSE
1350: l_msg_exceeded := 'Y';
1351: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1352: x_msg_data := fnd_message.get();
1353: l_error_message := x_msg_data;
1354: END IF;
1355: ELSE

Line 1352: x_msg_data := fnd_message.get();

1348: l_error_message :=l_error_message|| x_msg_data;
1349: ELSE
1350: l_msg_exceeded := 'Y';
1351: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1352: x_msg_data := fnd_message.get();
1353: l_error_message := x_msg_data;
1354: END IF;
1355: ELSE
1356: p_txn_lines_tbl_type(i).supplier_new_price := p_txn_lines_tbl_type(i).change_value;

Line 1361: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');

1357: END IF;
1358: ELSIF p_txn_lines_tbl_type(i).change_type = 'PERCENT_DECREASE' THEN
1359: IF p_txn_lines_tbl_type(i).change_value <= 0 OR p_txn_lines_tbl_type(i).change_value >= 100 THEN
1360: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change Value:' || p_txn_lines_tbl_type(i).change_value || 'for the change type Percent Decrease. Please enter a valid Change value.');
1361: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1362: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1363: x_msg_data := fnd_message.get();
1364: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1365: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1362: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );

1358: ELSIF p_txn_lines_tbl_type(i).change_type = 'PERCENT_DECREASE' THEN
1359: IF p_txn_lines_tbl_type(i).change_value <= 0 OR p_txn_lines_tbl_type(i).change_value >= 100 THEN
1360: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change Value:' || p_txn_lines_tbl_type(i).change_value || 'for the change type Percent Decrease. Please enter a valid Change value.');
1361: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1362: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1363: x_msg_data := fnd_message.get();
1364: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1365: IF p_txn_header_rec_type.error_code IS NULL THEN
1366: p_txn_header_rec_type.error_code := 'DPP_TXN_CHANGE_VALUE_ERR';

Line 1363: x_msg_data := fnd_message.get();

1359: IF p_txn_lines_tbl_type(i).change_value <= 0 OR p_txn_lines_tbl_type(i).change_value >= 100 THEN
1360: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change Value:' || p_txn_lines_tbl_type(i).change_value || 'for the change type Percent Decrease. Please enter a valid Change value.');
1361: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1362: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1363: x_msg_data := fnd_message.get();
1364: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1365: IF p_txn_header_rec_type.error_code IS NULL THEN
1366: p_txn_header_rec_type.error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1367: ELSE

Line 1374: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1370: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1371: l_error_message :=l_error_message|| x_msg_data;
1372: ELSE
1373: l_msg_exceeded := 'Y';
1374: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1375: x_msg_data := fnd_message.get();
1376: l_error_message := x_msg_data;
1377: END IF;
1378: ELSE

Line 1375: x_msg_data := fnd_message.get();

1371: l_error_message :=l_error_message|| x_msg_data;
1372: ELSE
1373: l_msg_exceeded := 'Y';
1374: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1375: x_msg_data := fnd_message.get();
1376: l_error_message := x_msg_data;
1377: END IF;
1378: ELSE
1379: p_txn_lines_tbl_type(i).supplier_new_price := (p_txn_lines_tbl_type(i).prior_price-(p_txn_lines_tbl_type(i).prior_price*( p_txn_lines_tbl_type(i).change_value) / 100));

Line 1385: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');

1381:
1382: ELSIF p_txn_lines_tbl_type(i).change_type = 'PERCENT_INCREASE' THEN
1383: IF p_txn_lines_tbl_type(i).change_value <= 0 THEN
1384: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change Value:' || p_txn_lines_tbl_type(i).change_value || 'for the change type Percent Increase. Please enter a valid Change value.');
1385: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1386: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1387: x_msg_data := fnd_message.get();
1388: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1389: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1386: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );

1382: ELSIF p_txn_lines_tbl_type(i).change_type = 'PERCENT_INCREASE' THEN
1383: IF p_txn_lines_tbl_type(i).change_value <= 0 THEN
1384: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change Value:' || p_txn_lines_tbl_type(i).change_value || 'for the change type Percent Increase. Please enter a valid Change value.');
1385: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1386: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1387: x_msg_data := fnd_message.get();
1388: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1389: IF p_txn_header_rec_type.error_code IS NULL THEN
1390: p_txn_header_rec_type.error_code := 'DPP_TXN_CHANGE_VALUE_ERR';

Line 1387: x_msg_data := fnd_message.get();

1383: IF p_txn_lines_tbl_type(i).change_value <= 0 THEN
1384: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change Value:' || p_txn_lines_tbl_type(i).change_value || 'for the change type Percent Increase. Please enter a valid Change value.');
1385: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1386: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1387: x_msg_data := fnd_message.get();
1388: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1389: IF p_txn_header_rec_type.error_code IS NULL THEN
1390: p_txn_header_rec_type.error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1391: ELSE

Line 1398: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1394: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1395: l_error_message :=l_error_message|| x_msg_data;
1396: ELSE
1397: l_msg_exceeded := 'Y';
1398: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1399: x_msg_data := fnd_message.get();
1400: l_error_message := x_msg_data;
1401: END IF;
1402: ELSE

Line 1399: x_msg_data := fnd_message.get();

1395: l_error_message :=l_error_message|| x_msg_data;
1396: ELSE
1397: l_msg_exceeded := 'Y';
1398: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1399: x_msg_data := fnd_message.get();
1400: l_error_message := x_msg_data;
1401: END IF;
1402: ELSE
1403: p_txn_lines_tbl_type(i).supplier_new_price := (p_txn_lines_tbl_type(i).prior_price+(p_txn_lines_tbl_type(i).prior_price*( p_txn_lines_tbl_type(i).change_value) / 100));

Line 1408: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');

1404: END IF;
1405: ELSIF p_txn_lines_tbl_type(i).change_type = 'AMOUNT_INCREASE' THEN
1406: IF p_txn_lines_tbl_type(i).change_value <= 0 THEN
1407: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change Value:' || p_txn_lines_tbl_type(i).change_value || 'for the change type Amount Increase. Please enter a valid Change value.');
1408: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1409: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1410: x_msg_data := fnd_message.get();
1411: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1412: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1409: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );

1405: ELSIF p_txn_lines_tbl_type(i).change_type = 'AMOUNT_INCREASE' THEN
1406: IF p_txn_lines_tbl_type(i).change_value <= 0 THEN
1407: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change Value:' || p_txn_lines_tbl_type(i).change_value || 'for the change type Amount Increase. Please enter a valid Change value.');
1408: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1409: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1410: x_msg_data := fnd_message.get();
1411: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1412: IF p_txn_header_rec_type.error_code IS NULL THEN
1413: p_txn_header_rec_type.error_code := 'DPP_TXN_CHANGE_VALUE_ERR';

Line 1410: x_msg_data := fnd_message.get();

1406: IF p_txn_lines_tbl_type(i).change_value <= 0 THEN
1407: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change Value:' || p_txn_lines_tbl_type(i).change_value || 'for the change type Amount Increase. Please enter a valid Change value.');
1408: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1409: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1410: x_msg_data := fnd_message.get();
1411: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1412: IF p_txn_header_rec_type.error_code IS NULL THEN
1413: p_txn_header_rec_type.error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1414: ELSE

Line 1421: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1417: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1418: l_error_message :=l_error_message|| x_msg_data;
1419: ELSE
1420: l_msg_exceeded := 'Y';
1421: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1422: x_msg_data := fnd_message.get();
1423: l_error_message := x_msg_data;
1424: END IF;
1425: ELSE

Line 1422: x_msg_data := fnd_message.get();

1418: l_error_message :=l_error_message|| x_msg_data;
1419: ELSE
1420: l_msg_exceeded := 'Y';
1421: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1422: x_msg_data := fnd_message.get();
1423: l_error_message := x_msg_data;
1424: END IF;
1425: ELSE
1426: p_txn_lines_tbl_type(i).supplier_new_price := p_txn_lines_tbl_type(i).prior_price + p_txn_lines_tbl_type(i).change_value;

Line 1431: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');

1427: END IF;
1428: ELSIF p_txn_lines_tbl_type(i).change_type = 'AMOUNT_DECREASE' THEN
1429: IF p_txn_lines_tbl_type(i).change_value <= 0 AND p_txn_lines_tbl_type(i).change_value >= p_txn_lines_tbl_type(i).prior_price THEN
1430: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change Value:' || p_txn_lines_tbl_type(i).change_value || 'for the change type Amount Decrease. Please enter a valid Change value.');
1431: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1432: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1433: x_msg_data := fnd_message.get();
1434: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1435: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1432: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );

1428: ELSIF p_txn_lines_tbl_type(i).change_type = 'AMOUNT_DECREASE' THEN
1429: IF p_txn_lines_tbl_type(i).change_value <= 0 AND p_txn_lines_tbl_type(i).change_value >= p_txn_lines_tbl_type(i).prior_price THEN
1430: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change Value:' || p_txn_lines_tbl_type(i).change_value || 'for the change type Amount Decrease. Please enter a valid Change value.');
1431: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1432: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1433: x_msg_data := fnd_message.get();
1434: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1435: IF p_txn_header_rec_type.error_code IS NULL THEN
1436: p_txn_header_rec_type.error_code := 'DPP_TXN_CHANGE_VALUE_ERR';

Line 1433: x_msg_data := fnd_message.get();

1429: IF p_txn_lines_tbl_type(i).change_value <= 0 AND p_txn_lines_tbl_type(i).change_value >= p_txn_lines_tbl_type(i).prior_price THEN
1430: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change Value:' || p_txn_lines_tbl_type(i).change_value || 'for the change type Amount Decrease. Please enter a valid Change value.');
1431: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_VALUE_ERR');
1432: fnd_message.set_token('CHANGE_VALUE', p_txn_lines_tbl_type(i).change_value );
1433: x_msg_data := fnd_message.get();
1434: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1435: IF p_txn_header_rec_type.error_code IS NULL THEN
1436: p_txn_header_rec_type.error_code := 'DPP_TXN_CHANGE_VALUE_ERR';
1437: ELSE

Line 1444: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1440: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1441: l_error_message :=l_error_message|| x_msg_data;
1442: ELSE
1443: l_msg_exceeded := 'Y';
1444: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1445: x_msg_data := fnd_message.get();
1446: l_error_message := x_msg_data;
1447: END IF;
1448: ELSE

Line 1445: x_msg_data := fnd_message.get();

1441: l_error_message :=l_error_message|| x_msg_data;
1442: ELSE
1443: l_msg_exceeded := 'Y';
1444: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1445: x_msg_data := fnd_message.get();
1446: l_error_message := x_msg_data;
1447: END IF;
1448: ELSE
1449: p_txn_lines_tbl_type(i).supplier_new_price := p_txn_lines_tbl_type(i).prior_price - p_txn_lines_tbl_type(i).change_value;

Line 1454: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_TYPE_ERR');

1450: END IF;
1451:
1452: ELSE
1453: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change type:' || p_txn_lines_tbl_type(i).change_type ||'. Please enter a valid Change type.');
1454: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_TYPE_ERR');
1455: fnd_message.set_token('CHANGE_TYPE', p_txn_lines_tbl_type(i).change_type );
1456: x_msg_data := fnd_message.get();
1457: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_TYPE_ERR';
1458: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1455: fnd_message.set_token('CHANGE_TYPE', p_txn_lines_tbl_type(i).change_type );

1451:
1452: ELSE
1453: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change type:' || p_txn_lines_tbl_type(i).change_type ||'. Please enter a valid Change type.');
1454: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_TYPE_ERR');
1455: fnd_message.set_token('CHANGE_TYPE', p_txn_lines_tbl_type(i).change_type );
1456: x_msg_data := fnd_message.get();
1457: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_TYPE_ERR';
1458: IF p_txn_header_rec_type.error_code IS NULL THEN
1459: p_txn_header_rec_type.error_code := 'DPP_TXN_CHANGE_TYPE_ERR';

Line 1456: x_msg_data := fnd_message.get();

1452: ELSE
1453: FND_FILE.PUT_LINE(FND_FILE.LOG,' Invalid Price Change type:' || p_txn_lines_tbl_type(i).change_type ||'. Please enter a valid Change type.');
1454: fnd_message.set_name('DPP', 'DPP_TXN_CHANGE_TYPE_ERR');
1455: fnd_message.set_token('CHANGE_TYPE', p_txn_lines_tbl_type(i).change_type );
1456: x_msg_data := fnd_message.get();
1457: p_txn_lines_tbl_type(i).error_code := 'DPP_TXN_CHANGE_TYPE_ERR';
1458: IF p_txn_header_rec_type.error_code IS NULL THEN
1459: p_txn_header_rec_type.error_code := 'DPP_TXN_CHANGE_TYPE_ERR';
1460: ELSE

Line 1467: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');

1463: IF (l_error_message is null or length(l_error_message) < 2000) and l_msg_exceeded = 'N' THEN
1464: l_error_message :=l_error_message|| x_msg_data;
1465: ELSE
1466: l_msg_exceeded := 'Y';
1467: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1468: x_msg_data := fnd_message.get();
1469: l_error_message := x_msg_data;
1470: END IF;
1471: --RAISE Fnd_Api.G_EXC_ERROR;

Line 1468: x_msg_data := fnd_message.get();

1464: l_error_message :=l_error_message|| x_msg_data;
1465: ELSE
1466: l_msg_exceeded := 'Y';
1467: fnd_message.set_name('DPP', 'DPP_ERROR_MSG_STD');
1468: x_msg_data := fnd_message.get();
1469: l_error_message := x_msg_data;
1470: END IF;
1471: --RAISE Fnd_Api.G_EXC_ERROR;
1472: END IF;

Line 1500: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1496: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1497: WHEN OTHERS THEN
1498: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1499: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1500: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1501: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT VALIDATE SUPPLIER PART NUMBER');
1502: fnd_message.set_token('ERRNO', SQLCODE);
1503: fnd_message.set_token('REASON', sqlerrm);
1504: END IF;

Line 1501: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT VALIDATE SUPPLIER PART NUMBER');

1497: WHEN OTHERS THEN
1498: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1499: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1500: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1501: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT VALIDATE SUPPLIER PART NUMBER');
1502: fnd_message.set_token('ERRNO', SQLCODE);
1503: fnd_message.set_token('REASON', sqlerrm);
1504: END IF;
1505: x_msg_data := fnd_message.get();

Line 1502: fnd_message.set_token('ERRNO', SQLCODE);

1498: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1499: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1500: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1501: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT VALIDATE SUPPLIER PART NUMBER');
1502: fnd_message.set_token('ERRNO', SQLCODE);
1503: fnd_message.set_token('REASON', sqlerrm);
1504: END IF;
1505: x_msg_data := fnd_message.get();
1506: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 1503: fnd_message.set_token('REASON', sqlerrm);

1499: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1500: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1501: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT VALIDATE SUPPLIER PART NUMBER');
1502: fnd_message.set_token('ERRNO', SQLCODE);
1503: fnd_message.set_token('REASON', sqlerrm);
1504: END IF;
1505: x_msg_data := fnd_message.get();
1506: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1507: END Validate_SupplierPartNum;

Line 1505: x_msg_data := fnd_message.get();

1501: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT VALIDATE SUPPLIER PART NUMBER');
1502: fnd_message.set_token('ERRNO', SQLCODE);
1503: fnd_message.set_token('REASON', sqlerrm);
1504: END IF;
1505: x_msg_data := fnd_message.get();
1506: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1507: END Validate_SupplierPartNum;
1508:
1509:

Line 1707: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1703: WHEN OTHERS THEN
1704: dpp_utility_pvt.debug_message('Exception Create Lines'||sqlerrm);
1705: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1706: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1707: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1708: fnd_message.set_token('ROUTINE', l_full_name);
1709: fnd_message.set_token('ERRNO', SQLCODE);
1710: fnd_message.set_token('REASON', sqlerrm);
1711: END IF;

Line 1708: fnd_message.set_token('ROUTINE', l_full_name);

1704: dpp_utility_pvt.debug_message('Exception Create Lines'||sqlerrm);
1705: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1706: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1707: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1708: fnd_message.set_token('ROUTINE', l_full_name);
1709: fnd_message.set_token('ERRNO', SQLCODE);
1710: fnd_message.set_token('REASON', sqlerrm);
1711: END IF;
1712: x_msg_data := fnd_message.get();

Line 1709: fnd_message.set_token('ERRNO', SQLCODE);

1705: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1706: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1707: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1708: fnd_message.set_token('ROUTINE', l_full_name);
1709: fnd_message.set_token('ERRNO', SQLCODE);
1710: fnd_message.set_token('REASON', sqlerrm);
1711: END IF;
1712: x_msg_data := fnd_message.get();
1713: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 1710: fnd_message.set_token('REASON', sqlerrm);

1706: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1707: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1708: fnd_message.set_token('ROUTINE', l_full_name);
1709: fnd_message.set_token('ERRNO', SQLCODE);
1710: fnd_message.set_token('REASON', sqlerrm);
1711: END IF;
1712: x_msg_data := fnd_message.get();
1713: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1714: END Create_lines;

Line 1712: x_msg_data := fnd_message.get();

1708: fnd_message.set_token('ROUTINE', l_full_name);
1709: fnd_message.set_token('ERRNO', SQLCODE);
1710: fnd_message.set_token('REASON', sqlerrm);
1711: END IF;
1712: x_msg_data := fnd_message.get();
1713: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1714: END Create_lines;
1715:
1716:

Line 1854: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1850: AND ostp.org_id = to_number(dtha.org_id)
1851: AND dtha.transaction_header_id = p_txn_header_rec_type.transaction_header_id;
1852: EXCEPTION
1853: WHEN NO_DATA_FOUND THEN
1854: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1855: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1856: fnd_message.set_token('ERRNO', sqlcode);
1857: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
1858: FND_MSG_PUB.add;

Line 1855: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1851: AND dtha.transaction_header_id = p_txn_header_rec_type.transaction_header_id;
1852: EXCEPTION
1853: WHEN NO_DATA_FOUND THEN
1854: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1855: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1856: fnd_message.set_token('ERRNO', sqlcode);
1857: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
1858: FND_MSG_PUB.add;
1859: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1856: fnd_message.set_token('ERRNO', sqlcode);

1852: EXCEPTION
1853: WHEN NO_DATA_FOUND THEN
1854: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1855: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1856: fnd_message.set_token('ERRNO', sqlcode);
1857: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
1858: FND_MSG_PUB.add;
1859: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1860: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1857: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified

1853: WHEN NO_DATA_FOUND THEN
1854: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1855: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1856: fnd_message.set_token('ERRNO', sqlcode);
1857: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
1858: FND_MSG_PUB.add;
1859: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1860: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1861: END IF;

Line 1864: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1860: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1861: END IF;
1862: RAISE FND_API.g_exc_error;
1863: WHEN OTHERS THEN
1864: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1865: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1866: fnd_message.set_token('ERRNO', sqlcode);
1867: fnd_message.set_token('REASON', sqlerrm);
1868: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1865: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1861: END IF;
1862: RAISE FND_API.g_exc_error;
1863: WHEN OTHERS THEN
1864: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1865: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1866: fnd_message.set_token('ERRNO', sqlcode);
1867: fnd_message.set_token('REASON', sqlerrm);
1868: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1869: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified

Line 1866: fnd_message.set_token('ERRNO', sqlcode);

1862: RAISE FND_API.g_exc_error;
1863: WHEN OTHERS THEN
1864: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1865: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1866: fnd_message.set_token('ERRNO', sqlcode);
1867: fnd_message.set_token('REASON', sqlerrm);
1868: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1869: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
1870: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified

Line 1867: fnd_message.set_token('REASON', sqlerrm);

1863: WHEN OTHERS THEN
1864: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1865: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1866: fnd_message.set_token('ERRNO', sqlcode);
1867: fnd_message.set_token('REASON', sqlerrm);
1868: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1869: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
1870: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
1871: FND_MSG_PUB.add;

Line 1869: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified

1865: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1866: fnd_message.set_token('ERRNO', sqlcode);
1867: fnd_message.set_token('REASON', sqlerrm);
1868: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1869: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
1870: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
1871: FND_MSG_PUB.add;
1872: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1873: END IF;

Line 1870: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified

1866: fnd_message.set_token('ERRNO', sqlcode);
1867: fnd_message.set_token('REASON', sqlerrm);
1868: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1869: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
1870: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
1871: FND_MSG_PUB.add;
1872: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1873: END IF;
1874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1917: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1913: ROLLBACK TO DPP_Update_CoveredInv;
1914: WHEN OTHERS THEN
1915: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1916: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1917: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1918: fnd_message.set_token('ROUTINE', l_full_name);
1919: fnd_message.set_token('ERRNO', SQLCODE);
1920: fnd_message.set_token('REASON', sqlerrm);
1921: END IF;

Line 1918: fnd_message.set_token('ROUTINE', l_full_name);

1914: WHEN OTHERS THEN
1915: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1916: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1917: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1918: fnd_message.set_token('ROUTINE', l_full_name);
1919: fnd_message.set_token('ERRNO', SQLCODE);
1920: fnd_message.set_token('REASON', sqlerrm);
1921: END IF;
1922: x_msg_data := fnd_message.get();

Line 1919: fnd_message.set_token('ERRNO', SQLCODE);

1915: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1916: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1917: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1918: fnd_message.set_token('ROUTINE', l_full_name);
1919: fnd_message.set_token('ERRNO', SQLCODE);
1920: fnd_message.set_token('REASON', sqlerrm);
1921: END IF;
1922: x_msg_data := fnd_message.get();
1923: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 1920: fnd_message.set_token('REASON', sqlerrm);

1916: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1917: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1918: fnd_message.set_token('ROUTINE', l_full_name);
1919: fnd_message.set_token('ERRNO', SQLCODE);
1920: fnd_message.set_token('REASON', sqlerrm);
1921: END IF;
1922: x_msg_data := fnd_message.get();
1923: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1924: ROLLBACK TO DPP_Update_CoveredInv;

Line 1922: x_msg_data := fnd_message.get();

1918: fnd_message.set_token('ROUTINE', l_full_name);
1919: fnd_message.set_token('ERRNO', SQLCODE);
1920: fnd_message.set_token('REASON', sqlerrm);
1921: END IF;
1922: x_msg_data := fnd_message.get();
1923: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
1924: ROLLBACK TO DPP_Update_CoveredInv;
1925: END Update_CoveredInv;
1926:

Line 1955: fnd_message.set_name('DPP', 'DPP_CLAIM_NUMBER_NULL');

1951: IF (p_txn_header_rec_type.supp_dist_claim_number IS NULL AND
1952: p_txn_header_rec_type.supp_dist_claim_id IS NULL ) THEN
1953: x_return_status := fnd_api.g_ret_sts_error;
1954: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1955: fnd_message.set_name('DPP', 'DPP_CLAIM_NUMBER_NULL');
1956: x_msg_data := fnd_message.get();
1957: p_txn_header_rec_type.error_code := 'DPP_CLAIM_NUMBER_NULL';
1958: l_error_message := l_error_message || x_msg_data;
1959: IF DPP_DEBUG_HIGH_ON THEN

Line 1956: x_msg_data := fnd_message.get();

1952: p_txn_header_rec_type.supp_dist_claim_id IS NULL ) THEN
1953: x_return_status := fnd_api.g_ret_sts_error;
1954: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1955: fnd_message.set_name('DPP', 'DPP_CLAIM_NUMBER_NULL');
1956: x_msg_data := fnd_message.get();
1957: p_txn_header_rec_type.error_code := 'DPP_CLAIM_NUMBER_NULL';
1958: l_error_message := l_error_message || x_msg_data;
1959: IF DPP_DEBUG_HIGH_ON THEN
1960: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 1986: fnd_message.set_name('DPP', 'DPP_APPROVED_CLAIM_LINES_ERR');

1982: END IF;
1983: EXCEPTION
1984: WHEN no_data_found THEN
1985: x_return_status := fnd_api.g_ret_sts_error;
1986: fnd_message.set_name('DPP', 'DPP_APPROVED_CLAIM_LINES_ERR');
1987: fnd_message.set_token('CLAIM_NUMBER', p_txn_header_rec_type.supp_dist_claim_number);
1988: fnd_message.set_token('CLAIM_ID', p_txn_header_rec_type.supp_dist_claim_id);
1989: x_msg_data := fnd_message.get();
1990: p_txn_lines_tbl_type(i).error_code := 'DPP_APPROVED_CLAIM_LINES_ERR';

Line 1987: fnd_message.set_token('CLAIM_NUMBER', p_txn_header_rec_type.supp_dist_claim_number);

1983: EXCEPTION
1984: WHEN no_data_found THEN
1985: x_return_status := fnd_api.g_ret_sts_error;
1986: fnd_message.set_name('DPP', 'DPP_APPROVED_CLAIM_LINES_ERR');
1987: fnd_message.set_token('CLAIM_NUMBER', p_txn_header_rec_type.supp_dist_claim_number);
1988: fnd_message.set_token('CLAIM_ID', p_txn_header_rec_type.supp_dist_claim_id);
1989: x_msg_data := fnd_message.get();
1990: p_txn_lines_tbl_type(i).error_code := 'DPP_APPROVED_CLAIM_LINES_ERR';
1991: IF p_txn_header_rec_type.error_code IS NULL THEN

Line 1988: fnd_message.set_token('CLAIM_ID', p_txn_header_rec_type.supp_dist_claim_id);

1984: WHEN no_data_found THEN
1985: x_return_status := fnd_api.g_ret_sts_error;
1986: fnd_message.set_name('DPP', 'DPP_APPROVED_CLAIM_LINES_ERR');
1987: fnd_message.set_token('CLAIM_NUMBER', p_txn_header_rec_type.supp_dist_claim_number);
1988: fnd_message.set_token('CLAIM_ID', p_txn_header_rec_type.supp_dist_claim_id);
1989: x_msg_data := fnd_message.get();
1990: p_txn_lines_tbl_type(i).error_code := 'DPP_APPROVED_CLAIM_LINES_ERR';
1991: IF p_txn_header_rec_type.error_code IS NULL THEN
1992: p_txn_header_rec_type.error_code := 'DPP_APPROVED_CLAIM_LINES_ERR';

Line 1989: x_msg_data := fnd_message.get();

1985: x_return_status := fnd_api.g_ret_sts_error;
1986: fnd_message.set_name('DPP', 'DPP_APPROVED_CLAIM_LINES_ERR');
1987: fnd_message.set_token('CLAIM_NUMBER', p_txn_header_rec_type.supp_dist_claim_number);
1988: fnd_message.set_token('CLAIM_ID', p_txn_header_rec_type.supp_dist_claim_id);
1989: x_msg_data := fnd_message.get();
1990: p_txn_lines_tbl_type(i).error_code := 'DPP_APPROVED_CLAIM_LINES_ERR';
1991: IF p_txn_header_rec_type.error_code IS NULL THEN
1992: p_txn_header_rec_type.error_code := 'DPP_APPROVED_CLAIM_LINES_ERR';
1993: ELSE

Line 2051: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2047: x_return_status := Fnd_Api.g_ret_sts_error ;
2048: WHEN others THEN
2049: x_return_status := fnd_api.g_ret_sts_unexp_error;
2050: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2051: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2052: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2053: fnd_message.set_token('ERRNO', SQLCODE);
2054: fnd_message.set_token('REASON', sqlerrm);
2055: END IF;

Line 2052: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

2048: WHEN others THEN
2049: x_return_status := fnd_api.g_ret_sts_unexp_error;
2050: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2051: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2052: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2053: fnd_message.set_token('ERRNO', SQLCODE);
2054: fnd_message.set_token('REASON', sqlerrm);
2055: END IF;
2056: x_msg_data := fnd_message.get();

Line 2053: fnd_message.set_token('ERRNO', SQLCODE);

2049: x_return_status := fnd_api.g_ret_sts_unexp_error;
2050: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2051: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2052: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2053: fnd_message.set_token('ERRNO', SQLCODE);
2054: fnd_message.set_token('REASON', sqlerrm);
2055: END IF;
2056: x_msg_data := fnd_message.get();
2057: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 2054: fnd_message.set_token('REASON', sqlerrm);

2050: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2051: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2052: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2053: fnd_message.set_token('ERRNO', SQLCODE);
2054: fnd_message.set_token('REASON', sqlerrm);
2055: END IF;
2056: x_msg_data := fnd_message.get();
2057: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
2058: END Update_Approval;

Line 2056: x_msg_data := fnd_message.get();

2052: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2053: fnd_message.set_token('ERRNO', SQLCODE);
2054: fnd_message.set_token('REASON', sqlerrm);
2055: END IF;
2056: x_msg_data := fnd_message.get();
2057: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
2058: END Update_Approval;
2059:
2060: PROCEDURE Update_ClaimsApproval(

Line 2097: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2093: EXCEPTION
2094: WHEN no_data_found THEN
2095: x_return_status := fnd_api.g_ret_sts_error;
2096: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2097: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2098: fnd_message.set_token('ROUTINE', l_full_name);
2099: fnd_message.set_token('ERRNO', SQLCODE);
2100: fnd_message.set_token('REASON', sqlerrm);
2101: END IF;

Line 2098: fnd_message.set_token('ROUTINE', l_full_name);

2094: WHEN no_data_found THEN
2095: x_return_status := fnd_api.g_ret_sts_error;
2096: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2097: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2098: fnd_message.set_token('ROUTINE', l_full_name);
2099: fnd_message.set_token('ERRNO', SQLCODE);
2100: fnd_message.set_token('REASON', sqlerrm);
2101: END IF;
2102: x_msg_data := fnd_message.get();

Line 2099: fnd_message.set_token('ERRNO', SQLCODE);

2095: x_return_status := fnd_api.g_ret_sts_error;
2096: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2097: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2098: fnd_message.set_token('ROUTINE', l_full_name);
2099: fnd_message.set_token('ERRNO', SQLCODE);
2100: fnd_message.set_token('REASON', sqlerrm);
2101: END IF;
2102: x_msg_data := fnd_message.get();
2103: END;

Line 2100: fnd_message.set_token('REASON', sqlerrm);

2096: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2097: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2098: fnd_message.set_token('ROUTINE', l_full_name);
2099: fnd_message.set_token('ERRNO', SQLCODE);
2100: fnd_message.set_token('REASON', sqlerrm);
2101: END IF;
2102: x_msg_data := fnd_message.get();
2103: END;
2104:

Line 2102: x_msg_data := fnd_message.get();

2098: fnd_message.set_token('ROUTINE', l_full_name);
2099: fnd_message.set_token('ERRNO', SQLCODE);
2100: fnd_message.set_token('REASON', sqlerrm);
2101: END IF;
2102: x_msg_data := fnd_message.get();
2103: END;
2104:
2105: FOR i in p_txn_lines_tbl_type.FIRST..p_txn_lines_tbl_type.LAST
2106: LOOP

Line 2184: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2180: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2181: WHEN OTHERS THEN
2182: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2184: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2185: fnd_message.set_token('ROUTINE', l_full_name);
2186: fnd_message.set_token('ERRNO', SQLCODE);
2187: fnd_message.set_token('REASON', sqlerrm);
2188: END IF;

Line 2185: fnd_message.set_token('ROUTINE', l_full_name);

2181: WHEN OTHERS THEN
2182: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2184: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2185: fnd_message.set_token('ROUTINE', l_full_name);
2186: fnd_message.set_token('ERRNO', SQLCODE);
2187: fnd_message.set_token('REASON', sqlerrm);
2188: END IF;
2189: x_msg_data := fnd_message.get();

Line 2186: fnd_message.set_token('ERRNO', SQLCODE);

2182: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2184: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2185: fnd_message.set_token('ROUTINE', l_full_name);
2186: fnd_message.set_token('ERRNO', SQLCODE);
2187: fnd_message.set_token('REASON', sqlerrm);
2188: END IF;
2189: x_msg_data := fnd_message.get();
2190: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 2187: fnd_message.set_token('REASON', sqlerrm);

2183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2184: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2185: fnd_message.set_token('ROUTINE', l_full_name);
2186: fnd_message.set_token('ERRNO', SQLCODE);
2187: fnd_message.set_token('REASON', sqlerrm);
2188: END IF;
2189: x_msg_data := fnd_message.get();
2190: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
2191: END Update_ClaimsApproval;

Line 2189: x_msg_data := fnd_message.get();

2185: fnd_message.set_token('ROUTINE', l_full_name);
2186: fnd_message.set_token('ERRNO', SQLCODE);
2187: fnd_message.set_token('REASON', sqlerrm);
2188: END IF;
2189: x_msg_data := fnd_message.get();
2190: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
2191: END Update_ClaimsApproval;
2192:
2193: PROCEDURE form_line_tbl(

Line 2232: fnd_message.set_name('DPP', 'DPP_TXN_ORG_MISMATCH');

2228: FOR fetch_lines_rec IN fetch_lines_cur(p_txn_header_rec_type.transaction_int_header_id)
2229: LOOP
2230: IF p_txn_header_rec_type.org_id <> nvl(fetch_lines_rec.org_id,p_txn_header_rec_type.org_id) THEN
2231: x_return_status := fnd_api.g_ret_sts_error;
2232: fnd_message.set_name('DPP', 'DPP_TXN_ORG_MISMATCH');
2233: fnd_message.set_token('HEADER_ORG_ID', p_txn_header_rec_type.org_id);
2234: fnd_message.set_token('LINE_ORG_ID', fetch_lines_rec.org_id);
2235: x_msg_data :=fnd_message.get();
2236: --RAISE Fnd_Api.G_EXC_ERROR;

Line 2233: fnd_message.set_token('HEADER_ORG_ID', p_txn_header_rec_type.org_id);

2229: LOOP
2230: IF p_txn_header_rec_type.org_id <> nvl(fetch_lines_rec.org_id,p_txn_header_rec_type.org_id) THEN
2231: x_return_status := fnd_api.g_ret_sts_error;
2232: fnd_message.set_name('DPP', 'DPP_TXN_ORG_MISMATCH');
2233: fnd_message.set_token('HEADER_ORG_ID', p_txn_header_rec_type.org_id);
2234: fnd_message.set_token('LINE_ORG_ID', fetch_lines_rec.org_id);
2235: x_msg_data :=fnd_message.get();
2236: --RAISE Fnd_Api.G_EXC_ERROR;
2237: l_txn_lines_rec_type.error_code := 'DPP_TXN_ORG_MISMATCH';

Line 2234: fnd_message.set_token('LINE_ORG_ID', fetch_lines_rec.org_id);

2230: IF p_txn_header_rec_type.org_id <> nvl(fetch_lines_rec.org_id,p_txn_header_rec_type.org_id) THEN
2231: x_return_status := fnd_api.g_ret_sts_error;
2232: fnd_message.set_name('DPP', 'DPP_TXN_ORG_MISMATCH');
2233: fnd_message.set_token('HEADER_ORG_ID', p_txn_header_rec_type.org_id);
2234: fnd_message.set_token('LINE_ORG_ID', fetch_lines_rec.org_id);
2235: x_msg_data :=fnd_message.get();
2236: --RAISE Fnd_Api.G_EXC_ERROR;
2237: l_txn_lines_rec_type.error_code := 'DPP_TXN_ORG_MISMATCH';
2238: x_return_status := Fnd_Api.g_ret_sts_error ;

Line 2235: x_msg_data :=fnd_message.get();

2231: x_return_status := fnd_api.g_ret_sts_error;
2232: fnd_message.set_name('DPP', 'DPP_TXN_ORG_MISMATCH');
2233: fnd_message.set_token('HEADER_ORG_ID', p_txn_header_rec_type.org_id);
2234: fnd_message.set_token('LINE_ORG_ID', fetch_lines_rec.org_id);
2235: x_msg_data :=fnd_message.get();
2236: --RAISE Fnd_Api.G_EXC_ERROR;
2237: l_txn_lines_rec_type.error_code := 'DPP_TXN_ORG_MISMATCH';
2238: x_return_status := Fnd_Api.g_ret_sts_error ;
2239: l_error_message := l_error_message || x_msg_data;

Line 2319: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2315: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2316: WHEN OTHERS THEN
2317: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2318: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2319: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2320: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2321: fnd_message.set_token('ERRNO', SQLCODE);
2322: fnd_message.set_token('REASON', sqlerrm);
2323: END IF;

Line 2320: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

2316: WHEN OTHERS THEN
2317: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2318: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2319: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2320: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2321: fnd_message.set_token('ERRNO', SQLCODE);
2322: fnd_message.set_token('REASON', sqlerrm);
2323: END IF;
2324: x_msg_data := fnd_message.get();

Line 2321: fnd_message.set_token('ERRNO', SQLCODE);

2317: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2318: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2319: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2320: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2321: fnd_message.set_token('ERRNO', SQLCODE);
2322: fnd_message.set_token('REASON', sqlerrm);
2323: END IF;
2324: x_msg_data := fnd_message.get();
2325: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 2322: fnd_message.set_token('REASON', sqlerrm);

2318: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2319: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2320: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2321: fnd_message.set_token('ERRNO', SQLCODE);
2322: fnd_message.set_token('REASON', sqlerrm);
2323: END IF;
2324: x_msg_data := fnd_message.get();
2325: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
2326: END form_line_tbl;

Line 2324: x_msg_data := fnd_message.get();

2320: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2321: fnd_message.set_token('ERRNO', SQLCODE);
2322: fnd_message.set_token('REASON', sqlerrm);
2323: END IF;
2324: x_msg_data := fnd_message.get();
2325: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
2326: END form_line_tbl;
2327:
2328: PROCEDURE Update_HeaderLog(

Line 2434: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2430: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2431: WHEN OTHERS THEN
2432: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2433: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2434: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2435: fnd_message.set_token('ROUTINE', l_full_name);
2436: fnd_message.set_token('ERRNO', SQLCODE);
2437: fnd_message.set_token('REASON', sqlerrm);
2438: END IF;

Line 2435: fnd_message.set_token('ROUTINE', l_full_name);

2431: WHEN OTHERS THEN
2432: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2433: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2434: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2435: fnd_message.set_token('ROUTINE', l_full_name);
2436: fnd_message.set_token('ERRNO', SQLCODE);
2437: fnd_message.set_token('REASON', sqlerrm);
2438: END IF;
2439: x_msg_data := fnd_message.get();

Line 2436: fnd_message.set_token('ERRNO', SQLCODE);

2432: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2433: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2434: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2435: fnd_message.set_token('ROUTINE', l_full_name);
2436: fnd_message.set_token('ERRNO', SQLCODE);
2437: fnd_message.set_token('REASON', sqlerrm);
2438: END IF;
2439: x_msg_data := fnd_message.get();
2440: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 2437: fnd_message.set_token('REASON', sqlerrm);

2433: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2434: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2435: fnd_message.set_token('ROUTINE', l_full_name);
2436: fnd_message.set_token('ERRNO', SQLCODE);
2437: fnd_message.set_token('REASON', sqlerrm);
2438: END IF;
2439: x_msg_data := fnd_message.get();
2440: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
2441: END Update_HeaderLog;

Line 2439: x_msg_data := fnd_message.get();

2435: fnd_message.set_token('ROUTINE', l_full_name);
2436: fnd_message.set_token('ERRNO', SQLCODE);
2437: fnd_message.set_token('REASON', sqlerrm);
2438: END IF;
2439: x_msg_data := fnd_message.get();
2440: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
2441: END Update_HeaderLog;
2442:
2443: PROCEDURE Update_LinesLog(

Line 2569: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2565: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2566: WHEN OTHERS THEN
2567: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2569: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2570: fnd_message.set_token('ROUTINE', l_full_name);
2571: fnd_message.set_token('ERRNO', SQLCODE);
2572: fnd_message.set_token('REASON', sqlerrm);
2573: END IF;

Line 2570: fnd_message.set_token('ROUTINE', l_full_name);

2566: WHEN OTHERS THEN
2567: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2569: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2570: fnd_message.set_token('ROUTINE', l_full_name);
2571: fnd_message.set_token('ERRNO', SQLCODE);
2572: fnd_message.set_token('REASON', sqlerrm);
2573: END IF;
2574: x_msg_data := fnd_message.get();

Line 2571: fnd_message.set_token('ERRNO', SQLCODE);

2567: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2569: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2570: fnd_message.set_token('ROUTINE', l_full_name);
2571: fnd_message.set_token('ERRNO', SQLCODE);
2572: fnd_message.set_token('REASON', sqlerrm);
2573: END IF;
2574: x_msg_data := fnd_message.get();
2575: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 2572: fnd_message.set_token('REASON', sqlerrm);

2568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2569: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2570: fnd_message.set_token('ROUTINE', l_full_name);
2571: fnd_message.set_token('ERRNO', SQLCODE);
2572: fnd_message.set_token('REASON', sqlerrm);
2573: END IF;
2574: x_msg_data := fnd_message.get();
2575: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
2576: END Update_LinesLog;

Line 2574: x_msg_data := fnd_message.get();

2570: fnd_message.set_token('ROUTINE', l_full_name);
2571: fnd_message.set_token('ERRNO', SQLCODE);
2572: fnd_message.set_token('REASON', sqlerrm);
2573: END IF;
2574: x_msg_data := fnd_message.get();
2575: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
2576: END Update_LinesLog;
2577:
2578: PROCEDURE Update_InterfaceTbl(

Line 2635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2631:
2632: WHEN OTHERS THEN
2633: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2634: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2636: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2637: fnd_message.set_token('ERRNO', SQLCODE);
2638: fnd_message.set_token('REASON', sqlerrm);
2639: END IF;

Line 2636: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

2632: WHEN OTHERS THEN
2633: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2634: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2636: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2637: fnd_message.set_token('ERRNO', SQLCODE);
2638: fnd_message.set_token('REASON', sqlerrm);
2639: END IF;
2640: x_msg_data := fnd_message.get();

Line 2637: fnd_message.set_token('ERRNO', SQLCODE);

2633: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2634: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2636: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2637: fnd_message.set_token('ERRNO', SQLCODE);
2638: fnd_message.set_token('REASON', sqlerrm);
2639: END IF;
2640: x_msg_data := fnd_message.get();
2641: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);

Line 2638: fnd_message.set_token('REASON', sqlerrm);

2634: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2636: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2637: fnd_message.set_token('ERRNO', SQLCODE);
2638: fnd_message.set_token('REASON', sqlerrm);
2639: END IF;
2640: x_msg_data := fnd_message.get();
2641: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
2642: END Update_InterfaceTbl;

Line 2640: x_msg_data := fnd_message.get();

2636: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2637: fnd_message.set_token('ERRNO', SQLCODE);
2638: fnd_message.set_token('REASON', sqlerrm);
2639: END IF;
2640: x_msg_data := fnd_message.get();
2641: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||x_msg_data);
2642: END Update_InterfaceTbl;
2643:
2644:

Line 2698: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2694: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2695: WHEN OTHERS THEN
2696: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2697: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2698: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2699: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2700: fnd_message.set_token('ERRNO', SQLCODE);
2701: fnd_message.set_token('REASON', sqlerrm);
2702: END IF;

Line 2699: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

2695: WHEN OTHERS THEN
2696: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2697: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2698: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2699: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2700: fnd_message.set_token('ERRNO', SQLCODE);
2701: fnd_message.set_token('REASON', sqlerrm);
2702: END IF;
2703: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||sqlerrm);

Line 2700: fnd_message.set_token('ERRNO', SQLCODE);

2696: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2697: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2698: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2699: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2700: fnd_message.set_token('ERRNO', SQLCODE);
2701: fnd_message.set_token('REASON', sqlerrm);
2702: END IF;
2703: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||sqlerrm);
2704: END Update_InterfaceLineErrSts;

Line 2701: fnd_message.set_token('REASON', sqlerrm);

2697: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2698: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2699: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2700: fnd_message.set_token('ERRNO', SQLCODE);
2701: fnd_message.set_token('REASON', sqlerrm);
2702: END IF;
2703: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||sqlerrm);
2704: END Update_InterfaceLineErrSts;
2705:

Line 2986: fnd_message.set_name('DPP', 'DPP_TRANSACTION_EXIST');

2982: EXCEPTION
2983: WHEN NO_DATA_FOUND THEN
2984: l_transaction_status := NULL;
2985: WHEN TOO_MANY_ROWS THEN
2986: fnd_message.set_name('DPP', 'DPP_TRANSACTION_EXIST');
2987: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
2988: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
2989: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
2990: x_msg_data := fnd_message.get();

Line 2987: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);

2983: WHEN NO_DATA_FOUND THEN
2984: l_transaction_status := NULL;
2985: WHEN TOO_MANY_ROWS THEN
2986: fnd_message.set_name('DPP', 'DPP_TRANSACTION_EXIST');
2987: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
2988: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
2989: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
2990: x_msg_data := fnd_message.get();
2991: l_txn_header_rec_type.error_code := 'DPP_TRANSACTION_EXIST';

Line 2988: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);

2984: l_transaction_status := NULL;
2985: WHEN TOO_MANY_ROWS THEN
2986: fnd_message.set_name('DPP', 'DPP_TRANSACTION_EXIST');
2987: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
2988: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
2989: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
2990: x_msg_data := fnd_message.get();
2991: l_txn_header_rec_type.error_code := 'DPP_TRANSACTION_EXIST';
2992: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;

Line 2989: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);

2985: WHEN TOO_MANY_ROWS THEN
2986: fnd_message.set_name('DPP', 'DPP_TRANSACTION_EXIST');
2987: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
2988: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
2989: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
2990: x_msg_data := fnd_message.get();
2991: l_txn_header_rec_type.error_code := 'DPP_TRANSACTION_EXIST';
2992: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;
2993: Update_InterfaceErrSts(

Line 2990: x_msg_data := fnd_message.get();

2986: fnd_message.set_name('DPP', 'DPP_TRANSACTION_EXIST');
2987: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
2988: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
2989: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
2990: x_msg_data := fnd_message.get();
2991: l_txn_header_rec_type.error_code := 'DPP_TRANSACTION_EXIST';
2992: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;
2993: Update_InterfaceErrSts(
2994: p_txn_header_rec_type => l_txn_header_rec_type

Line 3011: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');

3007: EXCEPTION
3008: WHEN no_data_found THEN
3009: x_return_status := fnd_api.g_ret_sts_error;
3010: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3011: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
3012: END IF;
3013: x_msg_data := fnd_message.get();
3014: --RAISE Fnd_Api.G_EXC_ERROR;
3015: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;

Line 3013: x_msg_data := fnd_message.get();

3009: x_return_status := fnd_api.g_ret_sts_error;
3010: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3011: fnd_message.set_name('DPP', 'DPP_TXN_STS_ERR');
3012: END IF;
3013: x_msg_data := fnd_message.get();
3014: --RAISE Fnd_Api.G_EXC_ERROR;
3015: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;
3016: Update_InterfaceErrSts(
3017: p_txn_header_rec_type => l_txn_header_rec_type

Line 3186: fnd_message.set_name('DPP', 'DPP_TRANSACTION_EXIST');

3182: RAISE Fnd_Api.g_exc_error;
3183: END IF;
3184: ELSE
3185: --The transaction is in Active/.... Status
3186: fnd_message.set_name('DPP', 'DPP_TRANSACTION_EXIST');
3187: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3188: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3189: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3190: x_msg_data := fnd_message.get();

Line 3187: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);

3183: END IF;
3184: ELSE
3185: --The transaction is in Active/.... Status
3186: fnd_message.set_name('DPP', 'DPP_TRANSACTION_EXIST');
3187: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3188: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3189: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3190: x_msg_data := fnd_message.get();
3191: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;

Line 3188: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);

3184: ELSE
3185: --The transaction is in Active/.... Status
3186: fnd_message.set_name('DPP', 'DPP_TRANSACTION_EXIST');
3187: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3188: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3189: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3190: x_msg_data := fnd_message.get();
3191: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;
3192: l_txn_header_rec_type.error_code := 'DPP_TRANSACTION_EXIST';

Line 3189: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);

3185: --The transaction is in Active/.... Status
3186: fnd_message.set_name('DPP', 'DPP_TRANSACTION_EXIST');
3187: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3188: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3189: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3190: x_msg_data := fnd_message.get();
3191: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;
3192: l_txn_header_rec_type.error_code := 'DPP_TRANSACTION_EXIST';
3193: IF DPP_DEBUG_HIGH_ON THEN

Line 3190: x_msg_data := fnd_message.get();

3186: fnd_message.set_name('DPP', 'DPP_TRANSACTION_EXIST');
3187: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3188: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3189: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3190: x_msg_data := fnd_message.get();
3191: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;
3192: l_txn_header_rec_type.error_code := 'DPP_TRANSACTION_EXIST';
3193: IF DPP_DEBUG_HIGH_ON THEN
3194: fnd_file.put_line(fnd_file.log, 'Error:' || x_msg_data);

Line 3204: fnd_message.set_name('DPP', 'DPP_TRANSACTION_CREATED');

3200: );
3201: RAISE Fnd_Api.g_exc_error;
3202: END IF; --l_transaction_status is null
3203:
3204: fnd_message.set_name('DPP', 'DPP_TRANSACTION_CREATED');
3205: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3206: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3207: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3208: fnd_message.set_token('TRANSACTION_NUMBER', l_txn_header_rec_type.transaction_number);

Line 3205: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);

3201: RAISE Fnd_Api.g_exc_error;
3202: END IF; --l_transaction_status is null
3203:
3204: fnd_message.set_name('DPP', 'DPP_TRANSACTION_CREATED');
3205: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3206: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3207: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3208: fnd_message.set_token('TRANSACTION_NUMBER', l_txn_header_rec_type.transaction_number);
3209: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);

Line 3206: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);

3202: END IF; --l_transaction_status is null
3203:
3204: fnd_message.set_name('DPP', 'DPP_TRANSACTION_CREATED');
3205: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3206: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3207: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3208: fnd_message.set_token('TRANSACTION_NUMBER', l_txn_header_rec_type.transaction_number);
3209: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);
3210: x_msg_data := fnd_message.get();

Line 3207: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);

3203:
3204: fnd_message.set_name('DPP', 'DPP_TRANSACTION_CREATED');
3205: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3206: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3207: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3208: fnd_message.set_token('TRANSACTION_NUMBER', l_txn_header_rec_type.transaction_number);
3209: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);
3210: x_msg_data := fnd_message.get();
3211: fnd_file.put_line(fnd_file.log, x_msg_data);

Line 3208: fnd_message.set_token('TRANSACTION_NUMBER', l_txn_header_rec_type.transaction_number);

3204: fnd_message.set_name('DPP', 'DPP_TRANSACTION_CREATED');
3205: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3206: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3207: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3208: fnd_message.set_token('TRANSACTION_NUMBER', l_txn_header_rec_type.transaction_number);
3209: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);
3210: x_msg_data := fnd_message.get();
3211: fnd_file.put_line(fnd_file.log, x_msg_data);
3212:

Line 3209: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);

3205: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3206: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3207: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3208: fnd_message.set_token('TRANSACTION_NUMBER', l_txn_header_rec_type.transaction_number);
3209: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);
3210: x_msg_data := fnd_message.get();
3211: fnd_file.put_line(fnd_file.log, x_msg_data);
3212:
3213: IF l_concatenated_error_message IS NOT NULL THEN

Line 3210: x_msg_data := fnd_message.get();

3206: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3207: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3208: fnd_message.set_token('TRANSACTION_NUMBER', l_txn_header_rec_type.transaction_number);
3209: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);
3210: x_msg_data := fnd_message.get();
3211: fnd_file.put_line(fnd_file.log, x_msg_data);
3212:
3213: IF l_concatenated_error_message IS NOT NULL THEN
3214: x_msg_data := 'The Transaction for the supplier name '||l_txn_header_rec_type.vendor_name ||

Line 3221: fnd_message.set_name('DPP', 'DPP_TXN_NOT_EXISTS');

3217: END IF;
3218: --The Transaction is an Approval response
3219: ELSE
3220: IF l_transaction_status IS NULL OR l_transaction_status <> 'ACTIVE' THEN
3221: fnd_message.set_name('DPP', 'DPP_TXN_NOT_EXISTS');
3222: x_msg_data := fnd_message.get();
3223: l_txn_header_rec_type.error_code := 'DPP_TXN_NOT_EXISTS';
3224: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;
3225: Update_InterfaceErrSts(

Line 3222: x_msg_data := fnd_message.get();

3218: --The Transaction is an Approval response
3219: ELSE
3220: IF l_transaction_status IS NULL OR l_transaction_status <> 'ACTIVE' THEN
3221: fnd_message.set_name('DPP', 'DPP_TXN_NOT_EXISTS');
3222: x_msg_data := fnd_message.get();
3223: l_txn_header_rec_type.error_code := 'DPP_TXN_NOT_EXISTS';
3224: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;
3225: Update_InterfaceErrSts(
3226: p_txn_header_rec_type => l_txn_header_rec_type

Line 3234: fnd_message.set_name('DPP', 'DPP_APP_DETAILS_NOT_EXISTS');

3230: END IF;
3231: --Validate Supplier approved date,claim Number
3232: IF l_txn_header_rec_type.supplier_approval_date IS NULL
3233: THEN
3234: fnd_message.set_name('DPP', 'DPP_APP_DETAILS_NOT_EXISTS');
3235: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3236: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3237: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3238: x_msg_data := fnd_message.get();

Line 3235: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);

3231: --Validate Supplier approved date,claim Number
3232: IF l_txn_header_rec_type.supplier_approval_date IS NULL
3233: THEN
3234: fnd_message.set_name('DPP', 'DPP_APP_DETAILS_NOT_EXISTS');
3235: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3236: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3237: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3238: x_msg_data := fnd_message.get();
3239: l_txn_header_rec_type.error_code := 'DPP_APP_DETAILS_NOT_EXISTS';

Line 3236: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);

3232: IF l_txn_header_rec_type.supplier_approval_date IS NULL
3233: THEN
3234: fnd_message.set_name('DPP', 'DPP_APP_DETAILS_NOT_EXISTS');
3235: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3236: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3237: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3238: x_msg_data := fnd_message.get();
3239: l_txn_header_rec_type.error_code := 'DPP_APP_DETAILS_NOT_EXISTS';
3240: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;

Line 3237: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);

3233: THEN
3234: fnd_message.set_name('DPP', 'DPP_APP_DETAILS_NOT_EXISTS');
3235: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3236: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3237: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3238: x_msg_data := fnd_message.get();
3239: l_txn_header_rec_type.error_code := 'DPP_APP_DETAILS_NOT_EXISTS';
3240: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;
3241: Update_InterfaceErrSts(

Line 3238: x_msg_data := fnd_message.get();

3234: fnd_message.set_name('DPP', 'DPP_APP_DETAILS_NOT_EXISTS');
3235: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3236: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3237: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3238: x_msg_data := fnd_message.get();
3239: l_txn_header_rec_type.error_code := 'DPP_APP_DETAILS_NOT_EXISTS';
3240: l_concatenated_error_message :=l_concatenated_error_message|| x_msg_data;
3241: Update_InterfaceErrSts(
3242: p_txn_header_rec_type => l_txn_header_rec_type

Line 3387: fnd_message.set_name('DPP', 'DPP_TRANSACTION_APPROVED');

3383: ,x_return_status =>l_return_status
3384: );
3385: --RAISE Fnd_Api.g_exc_error;
3386: END IF;
3387: fnd_message.set_name('DPP', 'DPP_TRANSACTION_APPROVED');
3388: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3389: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3390: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);
3391: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);

Line 3388: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);

3384: );
3385: --RAISE Fnd_Api.g_exc_error;
3386: END IF;
3387: fnd_message.set_name('DPP', 'DPP_TRANSACTION_APPROVED');
3388: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3389: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3390: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);
3391: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3392: x_msg_data := fnd_message.get();

Line 3389: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);

3385: --RAISE Fnd_Api.g_exc_error;
3386: END IF;
3387: fnd_message.set_name('DPP', 'DPP_TRANSACTION_APPROVED');
3388: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3389: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3390: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);
3391: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3392: x_msg_data := fnd_message.get();
3393: fnd_file.put_line(fnd_file.log, x_msg_data);

Line 3390: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);

3386: END IF;
3387: fnd_message.set_name('DPP', 'DPP_TRANSACTION_APPROVED');
3388: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3389: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3390: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);
3391: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3392: x_msg_data := fnd_message.get();
3393: fnd_file.put_line(fnd_file.log, x_msg_data);
3394: END IF; --l_transaction_type = 'INB'

Line 3391: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);

3387: fnd_message.set_name('DPP', 'DPP_TRANSACTION_APPROVED');
3388: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3389: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3390: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);
3391: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3392: x_msg_data := fnd_message.get();
3393: fnd_file.put_line(fnd_file.log, x_msg_data);
3394: END IF; --l_transaction_type = 'INB'
3395: --Call procedure to update interface tables (header )

Line 3392: x_msg_data := fnd_message.get();

3388: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3389: fnd_message.set_token('SUPPLIER_SITE', l_txn_header_rec_type.vendor_site_code);
3390: fnd_message.set_token('OPERATING_UNIT', l_txn_header_rec_type.operating_unit_name);
3391: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3392: x_msg_data := fnd_message.get();
3393: fnd_file.put_line(fnd_file.log, x_msg_data);
3394: END IF; --l_transaction_type = 'INB'
3395: --Call procedure to update interface tables (header )
3396: Update_InterfaceTbl (

Line 3426: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');

3422: END LOOP; --End of loop FOR fetch_header_rec IN fetch_header_cur
3423: EXCEPTION
3424: WHEN Fnd_Api.G_EXC_ERROR THEN
3425: x_return_status := Fnd_Api.g_ret_sts_error ;
3426: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3427: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3428: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3429: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3430: l_msg_data := fnd_message.get();

Line 3427: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);

3423: EXCEPTION
3424: WHEN Fnd_Api.G_EXC_ERROR THEN
3425: x_return_status := Fnd_Api.g_ret_sts_error ;
3426: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3427: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3428: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3429: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3430: l_msg_data := fnd_message.get();
3431: x_msg_data := l_msg_data || l_concatenated_error_message;

Line 3428: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);

3424: WHEN Fnd_Api.G_EXC_ERROR THEN
3425: x_return_status := Fnd_Api.g_ret_sts_error ;
3426: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3427: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3428: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3429: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3430: l_msg_data := fnd_message.get();
3431: x_msg_data := l_msg_data || l_concatenated_error_message;
3432: dpp_utility_pvt.debug_message('DPP G_EXC_ERROR x_msg_data');

Line 3429: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);

3425: x_return_status := Fnd_Api.g_ret_sts_error ;
3426: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3427: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3428: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3429: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3430: l_msg_data := fnd_message.get();
3431: x_msg_data := l_msg_data || l_concatenated_error_message;
3432: dpp_utility_pvt.debug_message('DPP G_EXC_ERROR x_msg_data');
3433: dpp_utility_pvt.debug_message('Status '||x_return_status|| ' Message '||x_msg_data);

Line 3430: l_msg_data := fnd_message.get();

3426: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3427: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3428: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3429: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3430: l_msg_data := fnd_message.get();
3431: x_msg_data := l_msg_data || l_concatenated_error_message;
3432: dpp_utility_pvt.debug_message('DPP G_EXC_ERROR x_msg_data');
3433: dpp_utility_pvt.debug_message('Status '||x_return_status|| ' Message '||x_msg_data);
3434:

Line 3437: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');

3433: dpp_utility_pvt.debug_message('Status '||x_return_status|| ' Message '||x_msg_data);
3434:
3435:
3436: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3437: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3438: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3439: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3440: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3441: x_msg_data := fnd_message.get();

Line 3438: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);

3434:
3435:
3436: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3437: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3438: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3439: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3440: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3441: x_msg_data := fnd_message.get();
3442: x_msg_data:= x_msg_data ||l_concatenated_error_message;

Line 3439: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);

3435:
3436: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3437: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3438: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3439: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3440: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3441: x_msg_data := fnd_message.get();
3442: x_msg_data:= x_msg_data ||l_concatenated_error_message;
3443: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

Line 3440: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);

3436: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3437: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3438: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3439: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3440: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3441: x_msg_data := fnd_message.get();
3442: x_msg_data:= x_msg_data ||l_concatenated_error_message;
3443: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3444: dpp_utility_pvt.debug_message('DPP G_EXC_UNEXPECTED_ERROR Transaction Int header id '||l_txn_header_rec_type.transaction_int_header_id);

Line 3441: x_msg_data := fnd_message.get();

3437: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3438: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3439: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3440: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3441: x_msg_data := fnd_message.get();
3442: x_msg_data:= x_msg_data ||l_concatenated_error_message;
3443: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3444: dpp_utility_pvt.debug_message('DPP G_EXC_UNEXPECTED_ERROR Transaction Int header id '||l_txn_header_rec_type.transaction_int_header_id);
3445:

Line 3447: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');

3443: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3444: dpp_utility_pvt.debug_message('DPP G_EXC_UNEXPECTED_ERROR Transaction Int header id '||l_txn_header_rec_type.transaction_int_header_id);
3445:
3446: WHEN OTHERS THEN
3447: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3448: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3449: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3450: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3451: x_msg_data := fnd_message.get();

Line 3448: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);

3444: dpp_utility_pvt.debug_message('DPP G_EXC_UNEXPECTED_ERROR Transaction Int header id '||l_txn_header_rec_type.transaction_int_header_id);
3445:
3446: WHEN OTHERS THEN
3447: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3448: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3449: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3450: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3451: x_msg_data := fnd_message.get();
3452: dpp_utility_pvt.debug_message('Error:' ||x_msg_data);

Line 3449: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);

3445:
3446: WHEN OTHERS THEN
3447: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3448: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3449: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3450: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3451: x_msg_data := fnd_message.get();
3452: dpp_utility_pvt.debug_message('Error:' ||x_msg_data);
3453: x_msg_data := x_msg_data || l_concatenated_error_message;

Line 3450: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);

3446: WHEN OTHERS THEN
3447: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3448: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3449: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3450: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3451: x_msg_data := fnd_message.get();
3452: dpp_utility_pvt.debug_message('Error:' ||x_msg_data);
3453: x_msg_data := x_msg_data || l_concatenated_error_message;
3454: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

Line 3451: x_msg_data := fnd_message.get();

3447: fnd_message.set_name('DPP', 'DPP_TRANSACTION_ERROR');
3448: fnd_message.set_token('SUPPLIER_NAME', l_txn_header_rec_type.vendor_name);
3449: fnd_message.set_token('SUPPLIER_ID', l_txn_header_rec_type.vendor_id);
3450: fnd_message.set_token('DOC_REF_NO', l_txn_header_rec_type.ref_document_number);
3451: x_msg_data := fnd_message.get();
3452: dpp_utility_pvt.debug_message('Error:' ||x_msg_data);
3453: x_msg_data := x_msg_data || l_concatenated_error_message;
3454: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
3455: dpp_utility_pvt.debug_message('Error after assignment:' ||x_msg_data);

Line 3682: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

3678: EXCEPTION
3679: WHEN others THEN
3680: x_return_status := fnd_api.g_ret_sts_unexp_error;
3681: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3682: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3683: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3684: fnd_message.set_token('ERRNO', SQLCODE);
3685: fnd_message.set_token('REASON', sqlerrm);
3686: END IF;

Line 3683: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

3679: WHEN others THEN
3680: x_return_status := fnd_api.g_ret_sts_unexp_error;
3681: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3682: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3683: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3684: fnd_message.set_token('ERRNO', SQLCODE);
3685: fnd_message.set_token('REASON', sqlerrm);
3686: END IF;
3687:

Line 3684: fnd_message.set_token('ERRNO', SQLCODE);

3680: x_return_status := fnd_api.g_ret_sts_unexp_error;
3681: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3682: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3683: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3684: fnd_message.set_token('ERRNO', SQLCODE);
3685: fnd_message.set_token('REASON', sqlerrm);
3686: END IF;
3687:
3688: END Create_IntHeader;

Line 3685: fnd_message.set_token('REASON', sqlerrm);

3681: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3682: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3683: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3684: fnd_message.set_token('ERRNO', SQLCODE);
3685: fnd_message.set_token('REASON', sqlerrm);
3686: END IF;
3687:
3688: END Create_IntHeader;
3689:

Line 3826: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

3822: WHEN others THEN
3823: dpp_utility_pvt.debug_message('Create IntLines : SQLERRM:'||SQLERRM);
3824: x_return_status := fnd_api.g_ret_sts_unexp_error;
3825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3826: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3827: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3828: fnd_message.set_token('ERRNO', SQLCODE);
3829: fnd_message.set_token('REASON', sqlerrm);
3830: END IF;

Line 3827: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

3823: dpp_utility_pvt.debug_message('Create IntLines : SQLERRM:'||SQLERRM);
3824: x_return_status := fnd_api.g_ret_sts_unexp_error;
3825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3826: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3827: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3828: fnd_message.set_token('ERRNO', SQLCODE);
3829: fnd_message.set_token('REASON', sqlerrm);
3830: END IF;
3831: x_msg_data := fnd_message.get();

Line 3828: fnd_message.set_token('ERRNO', SQLCODE);

3824: x_return_status := fnd_api.g_ret_sts_unexp_error;
3825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3826: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3827: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3828: fnd_message.set_token('ERRNO', SQLCODE);
3829: fnd_message.set_token('REASON', sqlerrm);
3830: END IF;
3831: x_msg_data := fnd_message.get();
3832: END Create_IntLines;

Line 3829: fnd_message.set_token('REASON', sqlerrm);

3825: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3826: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3827: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3828: fnd_message.set_token('ERRNO', SQLCODE);
3829: fnd_message.set_token('REASON', sqlerrm);
3830: END IF;
3831: x_msg_data := fnd_message.get();
3832: END Create_IntLines;
3833:

Line 3831: x_msg_data := fnd_message.get();

3827: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3828: fnd_message.set_token('ERRNO', SQLCODE);
3829: fnd_message.set_token('REASON', sqlerrm);
3830: END IF;
3831: x_msg_data := fnd_message.get();
3832: END Create_IntLines;
3833:
3834:
3835: PROCEDURE inbound_transaction(

Line 3947: fnd_message.set_name('DPP', 'DPP_OPERATING_UNIT_NULL');

3943:
3944:
3945: IF p_distributor_operating_unit IS NULL THEN
3946: dpp_utility_pvt.debug_message('DPP Entered OU in webadi api');
3947: fnd_message.set_name('DPP', 'DPP_OPERATING_UNIT_NULL');
3948: l_error_message := fnd_message.get();
3949: l_message := l_message || l_error_message;
3950: --RAISE DPP_WEBADI_ERROR;
3951: --raise_application_error( -20000, l_error_message);

Line 3948: l_error_message := fnd_message.get();

3944:
3945: IF p_distributor_operating_unit IS NULL THEN
3946: dpp_utility_pvt.debug_message('DPP Entered OU in webadi api');
3947: fnd_message.set_name('DPP', 'DPP_OPERATING_UNIT_NULL');
3948: l_error_message := fnd_message.get();
3949: l_message := l_message || l_error_message;
3950: --RAISE DPP_WEBADI_ERROR;
3951: --raise_application_error( -20000, l_error_message);
3952: END IF;

Line 3955: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_NULL');

3951: --raise_application_error( -20000, l_error_message);
3952: END IF;
3953:
3954: IF p_document_reference IS NULL THEN
3955: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_NULL');
3956: l_error_message := fnd_message.get();
3957: l_message := l_message || l_error_message;
3958: --raise_application_error( -20000, l_error_message);
3959: --RAISE DPP_WEBADI_ERROR;

Line 3956: l_error_message := fnd_message.get();

3952: END IF;
3953:
3954: IF p_document_reference IS NULL THEN
3955: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_NULL');
3956: l_error_message := fnd_message.get();
3957: l_message := l_message || l_error_message;
3958: --raise_application_error( -20000, l_error_message);
3959: --RAISE DPP_WEBADI_ERROR;
3960: END IF;

Line 3963: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM');

3959: --RAISE DPP_WEBADI_ERROR;
3960: END IF;
3961:
3962: IF LENGTH(p_document_reference) > 40 THEN
3963: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM');
3964: l_error_message := fnd_message.get();
3965: l_message := l_message || l_error_message;
3966: --raise_application_error( -20000, l_error_message);
3967: --RAISE DPP_WEBADI_ERROR;

Line 3964: l_error_message := fnd_message.get();

3960: END IF;
3961:
3962: IF LENGTH(p_document_reference) > 40 THEN
3963: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM');
3964: l_error_message := fnd_message.get();
3965: l_message := l_message || l_error_message;
3966: --raise_application_error( -20000, l_error_message);
3967: --RAISE DPP_WEBADI_ERROR;
3968: END IF;

Line 3972: fnd_message.set_name ('DPP', 'DPP_SUPPLIER_NAME_NULL');

3968: END IF;
3969:
3970:
3971: IF p_supplier_name IS NULL THEN
3972: fnd_message.set_name ('DPP', 'DPP_SUPPLIER_NAME_NULL');
3973: l_error_message := fnd_message.get();
3974: l_message := l_message || l_error_message;
3975: --raise_application_error( -20000, l_error_message);
3976: -- RAISE DPP_WEBADI_ERROR;

Line 3973: l_error_message := fnd_message.get();

3969:
3970:
3971: IF p_supplier_name IS NULL THEN
3972: fnd_message.set_name ('DPP', 'DPP_SUPPLIER_NAME_NULL');
3973: l_error_message := fnd_message.get();
3974: l_message := l_message || l_error_message;
3975: --raise_application_error( -20000, l_error_message);
3976: -- RAISE DPP_WEBADI_ERROR;
3977: END IF;

Line 3980: fnd_message.set_name('DPP', 'DPP_SUPPLIER_SITE_NULL');

3976: -- RAISE DPP_WEBADI_ERROR;
3977: END IF;
3978:
3979: IF p_supplier_site IS NULL THEN
3980: fnd_message.set_name('DPP', 'DPP_SUPPLIER_SITE_NULL');
3981: l_error_message := fnd_message.get();
3982: l_message := l_message || l_error_message;
3983: --raise_application_error( -20000, l_error_message);
3984: --RAISE DPP_WEBADI_ERROR;

Line 3981: l_error_message := fnd_message.get();

3977: END IF;
3978:
3979: IF p_supplier_site IS NULL THEN
3980: fnd_message.set_name('DPP', 'DPP_SUPPLIER_SITE_NULL');
3981: l_error_message := fnd_message.get();
3982: l_message := l_message || l_error_message;
3983: --raise_application_error( -20000, l_error_message);
3984: --RAISE DPP_WEBADI_ERROR;
3985: END IF;

Line 3988: fnd_message.set_name('DPP', 'DPP_EFFECTIVE_DATE_NULL');

3984: --RAISE DPP_WEBADI_ERROR;
3985: END IF;
3986:
3987: IF p_effective_date IS NULL THEN
3988: fnd_message.set_name('DPP', 'DPP_EFFECTIVE_DATE_NULL');
3989: l_error_message := fnd_message.get();
3990: l_message := l_message || l_error_message;
3991: --raise_application_error( -20000, l_error_message);
3992: --RAISE DPP_WEBADI_ERROR;

Line 3989: l_error_message := fnd_message.get();

3985: END IF;
3986:
3987: IF p_effective_date IS NULL THEN
3988: fnd_message.set_name('DPP', 'DPP_EFFECTIVE_DATE_NULL');
3989: l_error_message := fnd_message.get();
3990: l_message := l_message || l_error_message;
3991: --raise_application_error( -20000, l_error_message);
3992: --RAISE DPP_WEBADI_ERROR;
3993: END IF;

Line 3996: fnd_message.set_name('DPP', 'DPP_CURRENCY_NULL');

3992: --RAISE DPP_WEBADI_ERROR;
3993: END IF;
3994:
3995: IF p_currency IS NULL THEN
3996: fnd_message.set_name('DPP', 'DPP_CURRENCY_NULL');
3997: l_error_message := fnd_message.get();
3998: l_message := l_message || l_error_message;
3999: --raise_application_error( -20000, l_error_message);
4000: --RAISE DPP_WEBADI_ERROR;

Line 3997: l_error_message := fnd_message.get();

3993: END IF;
3994:
3995: IF p_currency IS NULL THEN
3996: fnd_message.set_name('DPP', 'DPP_CURRENCY_NULL');
3997: l_error_message := fnd_message.get();
3998: l_message := l_message || l_error_message;
3999: --raise_application_error( -20000, l_error_message);
4000: --RAISE DPP_WEBADI_ERROR;
4001: END IF;

Line 4012: fnd_message.set_name('DPP', 'DPP_SUPPLIER_PART_NUM_NULL');

4008: -- Line Level Mandatory Field Validation
4009:
4010: IF (p_supplier_part_num IS NULL and p_item_number IS NULL) THEN
4011: -- TBD: change the DPP_VENDOR_PART_NUM_NULL attribute text to reflect the either or validation
4012: fnd_message.set_name('DPP', 'DPP_SUPPLIER_PART_NUM_NULL');
4013: l_error_message := fnd_message.get();
4014: l_message := l_message || l_error_message;
4015: --raise_application_error( -20000, l_error_message);
4016: --RAISE DPP_WEBADI_ERROR;

Line 4013: l_error_message := fnd_message.get();

4009:
4010: IF (p_supplier_part_num IS NULL and p_item_number IS NULL) THEN
4011: -- TBD: change the DPP_VENDOR_PART_NUM_NULL attribute text to reflect the either or validation
4012: fnd_message.set_name('DPP', 'DPP_SUPPLIER_PART_NUM_NULL');
4013: l_error_message := fnd_message.get();
4014: l_message := l_message || l_error_message;
4015: --raise_application_error( -20000, l_error_message);
4016: --RAISE DPP_WEBADI_ERROR;
4017: END IF;

Line 4020: fnd_message.set_name('DPP', 'DPP_CHANGE_TYPE_NULL');

4016: --RAISE DPP_WEBADI_ERROR;
4017: END IF;
4018:
4019: IF p_change_type IS NULL THEN
4020: fnd_message.set_name('DPP', 'DPP_CHANGE_TYPE_NULL');
4021: l_error_message := fnd_message.get();
4022: l_message := l_message || l_error_message;
4023: --raise_application_error( -20000, l_error_message);
4024: --RAISE DPP_WEBADI_ERROR;

Line 4021: l_error_message := fnd_message.get();

4017: END IF;
4018:
4019: IF p_change_type IS NULL THEN
4020: fnd_message.set_name('DPP', 'DPP_CHANGE_TYPE_NULL');
4021: l_error_message := fnd_message.get();
4022: l_message := l_message || l_error_message;
4023: --raise_application_error( -20000, l_error_message);
4024: --RAISE DPP_WEBADI_ERROR;
4025: END IF;

Line 4029: fnd_message.set_name('DPP', 'DPP_CHANGE_VALUE_NULL');

4025: END IF;
4026:
4027: IF p_change_value IS NULL OR p_change_value <= 0 THEN
4028: dpp_utility_pvt.debug_message('DPP Entered VALUE');
4029: fnd_message.set_name('DPP', 'DPP_CHANGE_VALUE_NULL');
4030: l_error_message := fnd_message.get();
4031: l_message := l_message || l_error_message;
4032: --raise_application_error( -20000, l_error_message);
4033: --RAISE DPP_WEBADI_ERROR;

Line 4030: l_error_message := fnd_message.get();

4026:
4027: IF p_change_value IS NULL OR p_change_value <= 0 THEN
4028: dpp_utility_pvt.debug_message('DPP Entered VALUE');
4029: fnd_message.set_name('DPP', 'DPP_CHANGE_VALUE_NULL');
4030: l_error_message := fnd_message.get();
4031: l_message := l_message || l_error_message;
4032: --raise_application_error( -20000, l_error_message);
4033: --RAISE DPP_WEBADI_ERROR;
4034: END IF;

Line 4146: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');

4142:
4143:
4144: IF l_return_status = fnd_api.g_ret_sts_error THEN
4145: dpp_utility_pvt.debug_message('DPP SYSTEM ERROR');
4146: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');
4147: l_error_message := fnd_message.get();
4148: RAISE dpp_webadi_error;
4149: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4150: dpp_utility_pvt.debug_message('DPP UNEXPECTED ERROR');

Line 4147: l_error_message := fnd_message.get();

4143:
4144: IF l_return_status = fnd_api.g_ret_sts_error THEN
4145: dpp_utility_pvt.debug_message('DPP SYSTEM ERROR');
4146: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');
4147: l_error_message := fnd_message.get();
4148: RAISE dpp_webadi_error;
4149: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4150: dpp_utility_pvt.debug_message('DPP UNEXPECTED ERROR');
4151: RAISE fnd_api.g_exc_unexpected_error;

Line 4158: l_message := fnd_message.get();

4154: EXCEPTION
4155: WHEN dpp_webadi_error THEN
4156: ROLLBACK TO inbound_transaction;
4157: if l_message is NULL then
4158: l_message := fnd_message.get();
4159: end if;
4160: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error:'||l_error_message);
4161: raise_application_error( -20000, l_message);
4162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4167: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));

4163: dpp_utility_pvt.debug_message('DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4164: ROLLBACK TO inbound_transaction;
4165: IF length( SQLERRM) > 30 THEN
4166: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4167: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4168: ELSE
4169: fnd_message.set_name ('DPP', SQLERRM);
4170: END IF;
4171: l_error_message := fnd_message.get();

Line 4169: fnd_message.set_name ('DPP', SQLERRM);

4165: IF length( SQLERRM) > 30 THEN
4166: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4167: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4168: ELSE
4169: fnd_message.set_name ('DPP', SQLERRM);
4170: END IF;
4171: l_error_message := fnd_message.get();
4172: raise_application_error( -20000, l_error_message);
4173: WHEN OTHERS THEN

Line 4171: l_error_message := fnd_message.get();

4167: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4168: ELSE
4169: fnd_message.set_name ('DPP', SQLERRM);
4170: END IF;
4171: l_error_message := fnd_message.get();
4172: raise_application_error( -20000, l_error_message);
4173: WHEN OTHERS THEN
4174: dpp_utility_pvt.debug_message('DPP IN OTHERS BLOCK');
4175: ROLLBACK TO inbound_transaction;

Line 4178: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));

4174: dpp_utility_pvt.debug_message('DPP IN OTHERS BLOCK');
4175: ROLLBACK TO inbound_transaction;
4176: IF length( SQLERRM) > 30 THEN
4177: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4178: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4179: ELSE
4180: fnd_message.set_name ('DPP', SQLERRM);
4181: END IF;
4182: l_error_message := fnd_message.get();

Line 4180: fnd_message.set_name ('DPP', SQLERRM);

4176: IF length( SQLERRM) > 30 THEN
4177: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4178: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4179: ELSE
4180: fnd_message.set_name ('DPP', SQLERRM);
4181: END IF;
4182: l_error_message := fnd_message.get();
4183: dpp_utility_pvt.debug_message('DPP l_error_message:'||l_error_message);
4184: raise_application_error( -20000, l_error_message);

Line 4182: l_error_message := fnd_message.get();

4178: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4179: ELSE
4180: fnd_message.set_name ('DPP', SQLERRM);
4181: END IF;
4182: l_error_message := fnd_message.get();
4183: dpp_utility_pvt.debug_message('DPP l_error_message:'||l_error_message);
4184: raise_application_error( -20000, l_error_message);
4185: END inbound_transaction;
4186:

Line 4256: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');

4252:
4253:
4254: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
4255: dpp_utility_pvt.debug_message('Create WebADI Transaction Fnd_Api.g_ret_sts_error');
4256: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');
4257: fnd_message.set_token('MESSAGE', x_msg_data);
4258: RAISE FND_API.G_EXC_ERROR;
4259: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
4260: dpp_utility_pvt.debug_message('Create WebADI Transaction Fnd_Api.g_ret_sts_unexp_error');

Line 4257: fnd_message.set_token('MESSAGE', x_msg_data);

4253:
4254: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
4255: dpp_utility_pvt.debug_message('Create WebADI Transaction Fnd_Api.g_ret_sts_error');
4256: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');
4257: fnd_message.set_token('MESSAGE', x_msg_data);
4258: RAISE FND_API.G_EXC_ERROR;
4259: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
4260: dpp_utility_pvt.debug_message('Create WebADI Transaction Fnd_Api.g_ret_sts_unexp_error');
4261: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');

Line 4261: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');

4257: fnd_message.set_token('MESSAGE', x_msg_data);
4258: RAISE FND_API.G_EXC_ERROR;
4259: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
4260: dpp_utility_pvt.debug_message('Create WebADI Transaction Fnd_Api.g_ret_sts_unexp_error');
4261: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');
4262: fnd_message.set_token('MESSAGE', x_msg_data);
4263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4264: END IF;
4265: EXCEPTION

Line 4262: fnd_message.set_token('MESSAGE', x_msg_data);

4258: RAISE FND_API.G_EXC_ERROR;
4259: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
4260: dpp_utility_pvt.debug_message('Create WebADI Transaction Fnd_Api.g_ret_sts_unexp_error');
4261: fnd_message.set_name('DPP', 'DPP_WEBADI_IMPORT_ERROR');
4262: fnd_message.set_token('MESSAGE', x_msg_data);
4263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4264: END IF;
4265: EXCEPTION
4266: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 4325: fnd_message.set_name('DPP', 'DPP_EVENT_SUBS_ERR');

4321: dpp_utility_pvt.debug_message('Event Key = ' || evtkey);
4322: END IF;
4323: l_event_test := wf_event.test(l_event_name);
4324: IF l_event_test = 'NONE' THEN
4325: fnd_message.set_name('DPP', 'DPP_EVENT_SUBS_ERR');
4326: fnd_message.set_token('CLAIM_NUMBER', p_claim_id);
4327: x_msg_data := fnd_message.get();
4328: DPP_UTILITY_PVT.debug_message('No enabled local subscriptions reference the event, or the event does not exist.');
4329: RAISE FND_API.g_exc_error;

Line 4326: fnd_message.set_token('CLAIM_NUMBER', p_claim_id);

4322: END IF;
4323: l_event_test := wf_event.test(l_event_name);
4324: IF l_event_test = 'NONE' THEN
4325: fnd_message.set_name('DPP', 'DPP_EVENT_SUBS_ERR');
4326: fnd_message.set_token('CLAIM_NUMBER', p_claim_id);
4327: x_msg_data := fnd_message.get();
4328: DPP_UTILITY_PVT.debug_message('No enabled local subscriptions reference the event, or the event does not exist.');
4329: RAISE FND_API.g_exc_error;
4330: END IF;

Line 4327: x_msg_data := fnd_message.get();

4323: l_event_test := wf_event.test(l_event_name);
4324: IF l_event_test = 'NONE' THEN
4325: fnd_message.set_name('DPP', 'DPP_EVENT_SUBS_ERR');
4326: fnd_message.set_token('CLAIM_NUMBER', p_claim_id);
4327: x_msg_data := fnd_message.get();
4328: DPP_UTILITY_PVT.debug_message('No enabled local subscriptions reference the event, or the event does not exist.');
4329: RAISE FND_API.g_exc_error;
4330: END IF;
4331: -- DEFINE IN WF ATTRIBUTES

Line 4358: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

4354: );
4355: WHEN OTHERS THEN
4356: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4358: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4359: fnd_message.set_token('ROUTINE', l_full_name);
4360: fnd_message.set_token('ERRNO', SQLCODE);
4361: fnd_message.set_token('REASON', sqlerrm);
4362: END IF;

Line 4359: fnd_message.set_token('ROUTINE', l_full_name);

4355: WHEN OTHERS THEN
4356: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4358: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4359: fnd_message.set_token('ROUTINE', l_full_name);
4360: fnd_message.set_token('ERRNO', SQLCODE);
4361: fnd_message.set_token('REASON', sqlerrm);
4362: END IF;
4363: ROLLBACK TO DPP_Raise_OutBoundEvent;

Line 4360: fnd_message.set_token('ERRNO', SQLCODE);

4356: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4358: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4359: fnd_message.set_token('ROUTINE', l_full_name);
4360: fnd_message.set_token('ERRNO', SQLCODE);
4361: fnd_message.set_token('REASON', sqlerrm);
4362: END IF;
4363: ROLLBACK TO DPP_Raise_OutBoundEvent;
4364: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

Line 4361: fnd_message.set_token('REASON', sqlerrm);

4357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4358: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4359: fnd_message.set_token('ROUTINE', l_full_name);
4360: fnd_message.set_token('ERRNO', SQLCODE);
4361: fnd_message.set_token('REASON', sqlerrm);
4362: END IF;
4363: ROLLBACK TO DPP_Raise_OutBoundEvent;
4364: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
4365: THEN

Line 4480: fnd_message.set_name('DPP', 'DPP_OPERATING_UNIT_NULL');

4476: SAVEPOINT inbound_approval;
4477: x_return_status := fnd_api.g_ret_sts_success;
4478:
4479: IF p_distributor_operating_unit IS NULL THEN
4480: fnd_message.set_name('DPP', 'DPP_OPERATING_UNIT_NULL');
4481: l_error_message := fnd_message.get();
4482: l_message := l_message || l_error_message;
4483:
4484: END IF;

Line 4481: l_error_message := fnd_message.get();

4477: x_return_status := fnd_api.g_ret_sts_success;
4478:
4479: IF p_distributor_operating_unit IS NULL THEN
4480: fnd_message.set_name('DPP', 'DPP_OPERATING_UNIT_NULL');
4481: l_error_message := fnd_message.get();
4482: l_message := l_message || l_error_message;
4483:
4484: END IF;
4485: IF p_document_reference IS NULL THEN

Line 4486: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_NULL');

4482: l_message := l_message || l_error_message;
4483:
4484: END IF;
4485: IF p_document_reference IS NULL THEN
4486: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_NULL');
4487: l_error_message := fnd_message.get();
4488: l_message := l_message || l_error_message;
4489: --raise_application_error( -20000, l_error_message);
4490: --RAISE DPP_WEBADI_ERROR;

Line 4487: l_error_message := fnd_message.get();

4483:
4484: END IF;
4485: IF p_document_reference IS NULL THEN
4486: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM_NULL');
4487: l_error_message := fnd_message.get();
4488: l_message := l_message || l_error_message;
4489: --raise_application_error( -20000, l_error_message);
4490: --RAISE DPP_WEBADI_ERROR;
4491: END IF;

Line 4494: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM');

4490: --RAISE DPP_WEBADI_ERROR;
4491: END IF;
4492:
4493: IF LENGTH(p_document_reference) > 40 THEN
4494: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM');
4495: l_error_message := fnd_message.get();
4496: l_message := l_message || l_error_message;
4497: --raise_application_error( -20000, l_error_message);
4498: --RAISE DPP_WEBADI_ERROR;

Line 4495: l_error_message := fnd_message.get();

4491: END IF;
4492:
4493: IF LENGTH(p_document_reference) > 40 THEN
4494: fnd_message.set_name('DPP', 'DPP_DOC_REF_NUM');
4495: l_error_message := fnd_message.get();
4496: l_message := l_message || l_error_message;
4497: --raise_application_error( -20000, l_error_message);
4498: --RAISE DPP_WEBADI_ERROR;
4499: END IF;

Line 4502: fnd_message.set_name('DPP', 'DPP_CLAIM_NUM_NULL');

4498: --RAISE DPP_WEBADI_ERROR;
4499: END IF;
4500:
4501: IF p_supp_dist_claim_number IS NULL THEN
4502: fnd_message.set_name('DPP', 'DPP_CLAIM_NUM_NULL');
4503: l_error_message := fnd_message.get();
4504: l_message := l_message || l_error_message;
4505: --RAISE DPP_WEBADI_ERROR;
4506: END IF;

Line 4503: l_error_message := fnd_message.get();

4499: END IF;
4500:
4501: IF p_supp_dist_claim_number IS NULL THEN
4502: fnd_message.set_name('DPP', 'DPP_CLAIM_NUM_NULL');
4503: l_error_message := fnd_message.get();
4504: l_message := l_message || l_error_message;
4505: --RAISE DPP_WEBADI_ERROR;
4506: END IF;
4507:

Line 4509: fnd_message.set_name('DPP', 'DPP_APPROVEDBY_NULL');

4505: --RAISE DPP_WEBADI_ERROR;
4506: END IF;
4507:
4508: IF p_supplier_approved_by IS NULL THEN
4509: fnd_message.set_name('DPP', 'DPP_APPROVEDBY_NULL');
4510: l_error_message := fnd_message.get();
4511: l_message := l_message || l_error_message;
4512: --RAISE DPP_WEBADI_ERROR;
4513: END IF;

Line 4510: l_error_message := fnd_message.get();

4506: END IF;
4507:
4508: IF p_supplier_approved_by IS NULL THEN
4509: fnd_message.set_name('DPP', 'DPP_APPROVEDBY_NULL');
4510: l_error_message := fnd_message.get();
4511: l_message := l_message || l_error_message;
4512: --RAISE DPP_WEBADI_ERROR;
4513: END IF;
4514:

Line 4516: fnd_message.set_name('DPP', 'DPP_APPROVED_DATE_NULL');

4512: --RAISE DPP_WEBADI_ERROR;
4513: END IF;
4514:
4515: IF p_supplier_approval_date IS NULL THEN
4516: fnd_message.set_name('DPP', 'DPP_APPROVED_DATE_NULL');
4517: l_error_message := fnd_message.get();
4518: l_message := l_message || l_error_message;
4519: --RAISE DPP_WEBADI_ERROR;
4520: END IF;

Line 4517: l_error_message := fnd_message.get();

4513: END IF;
4514:
4515: IF p_supplier_approval_date IS NULL THEN
4516: fnd_message.set_name('DPP', 'DPP_APPROVED_DATE_NULL');
4517: l_error_message := fnd_message.get();
4518: l_message := l_message || l_error_message;
4519: --RAISE DPP_WEBADI_ERROR;
4520: END IF;
4521:

Line 4523: fnd_message.set_name ('DPP', 'DPP_SUPPLIER_NAME_NULL');

4519: --RAISE DPP_WEBADI_ERROR;
4520: END IF;
4521:
4522: IF p_supplier_name IS NULL THEN
4523: fnd_message.set_name ('DPP', 'DPP_SUPPLIER_NAME_NULL');
4524: l_error_message := fnd_message.get();
4525: --raise_application_error( -20000, l_error_message);
4526: l_message := l_message || l_error_message;
4527: --RAISE DPP_WEBADI_ERROR;

Line 4524: l_error_message := fnd_message.get();

4520: END IF;
4521:
4522: IF p_supplier_name IS NULL THEN
4523: fnd_message.set_name ('DPP', 'DPP_SUPPLIER_NAME_NULL');
4524: l_error_message := fnd_message.get();
4525: --raise_application_error( -20000, l_error_message);
4526: l_message := l_message || l_error_message;
4527: --RAISE DPP_WEBADI_ERROR;
4528: END IF;

Line 4532: fnd_message.set_name('DPP', 'DPP_SUPPLIER_SITE_NULL');

4528: END IF;
4529:
4530:
4531: IF p_supplier_site IS NULL THEN
4532: fnd_message.set_name('DPP', 'DPP_SUPPLIER_SITE_NULL');
4533: l_error_message := fnd_message.get();
4534: --raise_application_error( -20000, l_error_message);
4535: l_message := l_message || l_error_message;
4536: --RAISE DPP_WEBADI_ERROR;;

Line 4533: l_error_message := fnd_message.get();

4529:
4530:
4531: IF p_supplier_site IS NULL THEN
4532: fnd_message.set_name('DPP', 'DPP_SUPPLIER_SITE_NULL');
4533: l_error_message := fnd_message.get();
4534: --raise_application_error( -20000, l_error_message);
4535: l_message := l_message || l_error_message;
4536: --RAISE DPP_WEBADI_ERROR;;
4537: END IF;

Line 4542: fnd_message.set_name('DPP', 'DPP_SUPPLIER_PART_NUM_NULL');

4538:
4539: -- Line Level Mandatory Field Validation
4540:
4541: IF (p_supplier_part_num IS NULL and p_item_number IS NULL) THEN
4542: fnd_message.set_name('DPP', 'DPP_SUPPLIER_PART_NUM_NULL');
4543: l_error_message := fnd_message.get();
4544: l_message := l_message || l_error_message;
4545: --RAISE DPP_WEBADI_ERROR;
4546: END IF;

Line 4543: l_error_message := fnd_message.get();

4539: -- Line Level Mandatory Field Validation
4540:
4541: IF (p_supplier_part_num IS NULL and p_item_number IS NULL) THEN
4542: fnd_message.set_name('DPP', 'DPP_SUPPLIER_PART_NUM_NULL');
4543: l_error_message := fnd_message.get();
4544: l_message := l_message || l_error_message;
4545: --RAISE DPP_WEBADI_ERROR;
4546: END IF;
4547:

Line 4549: fnd_message.set_name('DPP', 'DPP_APPROVED_QTY_NULL');

4545: --RAISE DPP_WEBADI_ERROR;
4546: END IF;
4547:
4548: IF p_approved_inventory IS NULL OR p_approved_inventory < 0 THEN
4549: fnd_message.set_name('DPP', 'DPP_APPROVED_QTY_NULL');
4550: l_error_message := fnd_message.get();
4551: l_message := l_message || l_error_message;
4552: --RAISE DPP_WEBADI_ERROR;
4553: END IF;

Line 4550: l_error_message := fnd_message.get();

4546: END IF;
4547:
4548: IF p_approved_inventory IS NULL OR p_approved_inventory < 0 THEN
4549: fnd_message.set_name('DPP', 'DPP_APPROVED_QTY_NULL');
4550: l_error_message := fnd_message.get();
4551: l_message := l_message || l_error_message;
4552: --RAISE DPP_WEBADI_ERROR;
4553: END IF;
4554: IF l_message IS NOT NULL THEN

Line 4666: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');

4662:
4663:
4664: IF l_return_status = fnd_api.g_ret_sts_error THEN
4665: dpp_utility_pvt.debug_message('Create_Intlines fnd_api.g_ret_sts_error'||sqlerrm);
4666: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');
4667: l_error_message := fnd_message.get();
4668: RAISE dpp_webadi_error;
4669: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4670: dpp_utility_pvt.debug_message('Create_Intlines fnd_api.g_ret_sts_error');

Line 4667: l_error_message := fnd_message.get();

4663:
4664: IF l_return_status = fnd_api.g_ret_sts_error THEN
4665: dpp_utility_pvt.debug_message('Create_Intlines fnd_api.g_ret_sts_error'||sqlerrm);
4666: fnd_message.set_name('DPP', 'DPP_DUPLICATE_RECORDS');
4667: l_error_message := fnd_message.get();
4668: RAISE dpp_webadi_error;
4669: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4670: dpp_utility_pvt.debug_message('Create_Intlines fnd_api.g_ret_sts_error');
4671: RAISE fnd_api.g_exc_unexpected_error;

Line 4681: l_error_message := fnd_message.get();

4677: --x_return_status := FND_API.G_RET_STS_ERROR;
4678: ROLLBACK TO inbound_approval;
4679: if l_error_message is NULL then
4680: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error l_error_message is null');
4681: l_error_message := fnd_message.get();
4682: end if;
4683: dpp_utility_pvt.debug_message('DPP in DPP_webadi_error:'||l_error_message);
4684: raise_application_error( -20000, l_error_message);
4685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4690: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));

4686: dpp_utility_pvt.debug_message('DPP IN FND_API.G_EXC_UNEXPECTED_ERROR BLOCK');
4687: ROLLBACK TO inbound_approval;
4688: IF length( SQLERRM) > 30 THEN
4689: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4690: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4691: ELSE
4692: fnd_message.set_name ('DPP', SQLERRM);
4693: END IF;
4694: l_error_message := fnd_message.get();

Line 4692: fnd_message.set_name ('DPP', SQLERRM);

4688: IF length( SQLERRM) > 30 THEN
4689: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4690: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4691: ELSE
4692: fnd_message.set_name ('DPP', SQLERRM);
4693: END IF;
4694: l_error_message := fnd_message.get();
4695: raise_application_error( -20000, l_error_message);
4696: WHEN OTHERS THEN

Line 4694: l_error_message := fnd_message.get();

4690: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4691: ELSE
4692: fnd_message.set_name ('DPP', SQLERRM);
4693: END IF;
4694: l_error_message := fnd_message.get();
4695: raise_application_error( -20000, l_error_message);
4696: WHEN OTHERS THEN
4697: dpp_utility_pvt.debug_message('DPP IN OTHERS BLOCK');
4698: ROLLBACK TO inbound_approval;

Line 4701: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));

4697: dpp_utility_pvt.debug_message('DPP IN OTHERS BLOCK');
4698: ROLLBACK TO inbound_approval;
4699: IF length( SQLERRM) > 30 THEN
4700: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4701: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4702: ELSE
4703: fnd_message.set_name ('DPP', SQLERRM);
4704: END IF;
4705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4703: fnd_message.set_name ('DPP', SQLERRM);

4699: IF length( SQLERRM) > 30 THEN
4700: dpp_utility_pvt.debug_message(substr(SQLERRM,12,30));
4701: fnd_message.set_name ('DPP', substr(SQLERRM,12,30));
4702: ELSE
4703: fnd_message.set_name ('DPP', SQLERRM);
4704: END IF;
4705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4706: l_error_message := fnd_message.get();
4707: dpp_utility_pvt.debug_message('DPP l_error_message:'||l_error_message);

Line 4706: l_error_message := fnd_message.get();

4702: ELSE
4703: fnd_message.set_name ('DPP', SQLERRM);
4704: END IF;
4705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4706: l_error_message := fnd_message.get();
4707: dpp_utility_pvt.debug_message('DPP l_error_message:'||l_error_message);
4708: raise_application_error( -20000, l_error_message);
4709: END inbound_approval;
4710: