eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on FND_API

Line 17: IF (NVL(p_value,FND_API.g_miss_num) = FND_API.g_miss_num) THEN

13: p_api_name IN VARCHAR2)
14: IS
15: BEGIN
16:
17: IF (NVL(p_value,FND_API.g_miss_num) = FND_API.g_miss_num) THEN
18:
19: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
20: FND_MESSAGE.set_token('API_NAME',p_api_name);
21: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);

Line 23: RAISE FND_API.g_exc_error;

19: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
20: FND_MESSAGE.set_token('API_NAME',p_api_name);
21: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);
22: FND_MSG_PUB.add;
23: RAISE FND_API.g_exc_error;
24:
25: END IF;
26:
27: END Check_Reqd_Param;

Line 36: IF (NVL(p_value,FND_API.g_miss_char) = FND_API.g_miss_char) THEN

32: p_api_name IN VARCHAR2)
33: IS
34: BEGIN
35:
36: IF (NVL(p_value,FND_API.g_miss_char) = FND_API.g_miss_char) THEN
37:
38: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
39: FND_MESSAGE.set_token('API_NAME',p_api_name);
40: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);

Line 42: RAISE FND_API.g_exc_error;

38: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
39: FND_MESSAGE.set_token('API_NAME',p_api_name);
40: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);
41: FND_MSG_PUB.add;
42: RAISE FND_API.g_exc_error;
43:
44: END IF;
45:
46: END Check_Reqd_Param;

Line 55: IF (NVL(p_value,FND_API.g_miss_date) = FND_API.g_miss_date) THEN

51: p_api_name IN VARCHAR2)
52: IS
53: BEGIN
54:
55: IF (NVL(p_value,FND_API.g_miss_date) = FND_API.g_miss_date) THEN
56:
57: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
58: FND_MESSAGE.set_token('API_NAME',p_api_name);
59: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);

Line 61: RAISE FND_API.g_exc_error;

57: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
58: FND_MESSAGE.set_token('API_NAME',p_api_name);
59: FND_MESSAGE.set_token('MISSING_PARAM',p_param_name);
60: FND_MSG_PUB.add;
61: RAISE FND_API.g_exc_error;
62:
63: END IF;
64:
65: END Check_Reqd_Param;

Line 93: x_return_status := fnd_api.g_ret_sts_success;

89: where transaction_line_id = p_txn_line_id;
90:
91: l_txn_line_rec txn_line_cur%rowtype;
92: BEGIN
93: x_return_status := fnd_api.g_ret_sts_success;
94:
95: Open txn_line_cur(p_transaction_line_id) ;
96: Fetch txn_line_cur Into l_txn_line_rec;
97:

Line 99: x_return_status := fnd_api.g_ret_sts_error;

95: Open txn_line_cur(p_transaction_line_id) ;
96: Fetch txn_line_cur Into l_txn_line_rec;
97:
98: IF NOT txn_line_cur%FOUND THEN
99: x_return_status := fnd_api.g_ret_sts_error;
100: END IF;
101:
102: Close txn_line_cur;
103:

Line 119: x_return_status := fnd_api.g_ret_sts_error;

115: x_transaction_line_rec.config_valid_status := l_txn_line_rec.config_valid_status;
116:
117: EXCEPTION
118: WHEN others THEN
119: x_return_status := fnd_api.g_ret_sts_error;
120: END validate_transaction_line_id;
121:
122:
123: /* Validate txn_line_detail_id */

Line 136: x_return_status := fnd_api.g_ret_sts_success;

132: INTO l_found
133: FROM csi_t_txn_line_details
134: WHERE txn_line_detail_id = p_txn_line_detail_id;
135:
136: x_return_status := fnd_api.g_ret_sts_success;
137:
138: EXCEPTION
139: WHEN no_data_found THEN
140: x_return_status := fnd_api.g_ret_sts_error;

Line 140: x_return_status := fnd_api.g_ret_sts_error;

136: x_return_status := fnd_api.g_ret_sts_success;
137:
138: EXCEPTION
139: WHEN no_data_found THEN
140: x_return_status := fnd_api.g_ret_sts_error;
141: END validate_txn_line_detail_id;
142:
143: /* Validate txn_line_detail_id */ -- Added this overloaded routine for M-M
144: PROCEDURE validate_txn_line_detail_id(

Line 169: x_return_status := fnd_api.g_ret_sts_success;

165: WHERE txn_line_detail_id = p_txn_line_dtl_id;
166:
167: l_txn_line_detail_rec txn_line_dtl_cur%rowtype;
168: BEGIN
169: x_return_status := fnd_api.g_ret_sts_success;
170:
171: Open txn_line_dtl_cur (p_txn_line_detail_id);
172: Fetch txn_line_dtl_cur into l_txn_line_detail_rec;
173:

Line 175: x_return_status := fnd_api.g_ret_sts_error;

171: Open txn_line_dtl_cur (p_txn_line_detail_id);
172: Fetch txn_line_dtl_cur into l_txn_line_detail_rec;
173:
174: IF NOT txn_line_dtl_cur%FOUND THEN
175: x_return_status := fnd_api.g_ret_sts_error;
176: END IF;
177:
178: Close txn_line_dtl_cur;
179:

Line 197: x_return_status := fnd_api.g_ret_sts_error;

193: x_txn_line_detail_rec.config_inst_item_id := l_txn_line_detail_rec.config_inst_item_id;
194:
195: EXCEPTION
196: WHEN others THEN
197: x_return_status := fnd_api.g_ret_sts_error;
198: END validate_txn_line_detail_id;
199:
200: /* Validate txn_party_detail_id */
201: PROCEDURE validate_txn_party_detail_id(

Line 213: x_return_status := fnd_api.g_ret_sts_success;

209: INTO l_found
210: FROM csi_t_party_details
211: WHERE txn_party_detail_id = p_txn_party_detail_id;
212:
213: x_return_status := fnd_api.g_ret_sts_success;
214:
215: EXCEPTION
216: WHEN no_data_found THEN
217: x_return_status := fnd_api.g_ret_sts_error;

Line 217: x_return_status := fnd_api.g_ret_sts_error;

213: x_return_status := fnd_api.g_ret_sts_success;
214:
215: EXCEPTION
216: WHEN no_data_found THEN
217: x_return_status := fnd_api.g_ret_sts_error;
218: WHEN others then
219: x_return_status := fnd_api.g_ret_sts_error;
220: END validate_txn_party_detail_id;
221:

Line 219: x_return_status := fnd_api.g_ret_sts_error;

215: EXCEPTION
216: WHEN no_data_found THEN
217: x_return_status := fnd_api.g_ret_sts_error;
218: WHEN others then
219: x_return_status := fnd_api.g_ret_sts_error;
220: END validate_txn_party_detail_id;
221:
222:
223: /* validate transaction party account detail id */

Line 236: x_return_status := fnd_api.g_ret_sts_success;

232: INTO l_found
233: FROM csi_t_party_accounts
234: WHERE txn_account_detail_id = p_txn_acct_detail_id;
235:
236: x_return_status := fnd_api.g_ret_sts_success;
237:
238: EXCEPTION
239: WHEN no_data_found THEN
240: x_return_status := fnd_api.g_ret_sts_error;

Line 240: x_return_status := fnd_api.g_ret_sts_error;

236: x_return_status := fnd_api.g_ret_sts_success;
237:
238: EXCEPTION
239: WHEN no_data_found THEN
240: x_return_status := fnd_api.g_ret_sts_error;
241: WHEN others then
242: x_return_status := fnd_api.g_ret_sts_error;
243: END validate_txn_acct_detail_id;
244:

Line 242: x_return_status := fnd_api.g_ret_sts_error;

238: EXCEPTION
239: WHEN no_data_found THEN
240: x_return_status := fnd_api.g_ret_sts_error;
241: WHEN others then
242: x_return_status := fnd_api.g_ret_sts_error;
243: END validate_txn_acct_detail_id;
244:
245:
246: /* validate relationship id */

Line 259: x_return_status := fnd_api.g_ret_sts_success;

255: INTO l_found
256: FROM csi_t_ii_relationships
257: WHERE txn_relationship_id = p_txn_relationship_id;
258:
259: x_return_status := fnd_api.g_ret_sts_success;
260:
261: EXCEPTION
262: WHEN no_data_found THEN
263: x_return_status := fnd_api.g_ret_sts_error;

Line 263: x_return_status := fnd_api.g_ret_sts_error;

259: x_return_status := fnd_api.g_ret_sts_success;
260:
261: EXCEPTION
262: WHEN no_data_found THEN
263: x_return_status := fnd_api.g_ret_sts_error;
264:
265: END validate_txn_relationship_id;
266:
267: /* validate transaction operating unit_id */

Line 280: x_return_status := fnd_api.g_ret_sts_success;

276: INTO l_found
277: FROM csi_t_org_assignments
278: WHERE txn_operating_unit_id = p_txn_operating_unit_id;
279:
280: x_return_status := fnd_api.g_ret_sts_success;
281:
282: EXCEPTION
283: WHEN no_data_found THEN
284: x_return_status := fnd_api.g_ret_sts_error;

Line 284: x_return_status := fnd_api.g_ret_sts_error;

280: x_return_status := fnd_api.g_ret_sts_success;
281:
282: EXCEPTION
283: WHEN no_data_found THEN
284: x_return_status := fnd_api.g_ret_sts_error;
285:
286: END validate_txn_ou_id;
287:
288:

Line 302: x_return_status := fnd_api.g_ret_sts_success;

298: INTO l_found
299: FROM csi_t_extend_attribs
300: WHERE txn_attrib_detail_id = p_txn_attrib_detail_id;
301:
302: x_return_status := fnd_api.g_ret_sts_success;
303:
304: EXCEPTION
305: WHEN no_data_found THEN
306: x_return_status := fnd_api.g_ret_sts_error;

Line 306: x_return_status := fnd_api.g_ret_sts_error;

302: x_return_status := fnd_api.g_ret_sts_success;
303:
304: EXCEPTION
305: WHEN no_data_found THEN
306: x_return_status := fnd_api.g_ret_sts_error;
307:
308: END validate_txn_attrib_detail_id;
309:
310: /* Validate the txn_source_id */

Line 326: x_return_status := fnd_api.g_ret_sts_success;

322: INTO l_found
323: FROM oe_order_lines_all
324: WHERE line_id = p_txn_source_id;
325:
326: x_return_status := fnd_api.g_ret_sts_success;
327:
328: END IF;
329:
330: EXCEPTION

Line 332: x_return_status := fnd_api.g_ret_sts_error;

328: END IF;
329:
330: EXCEPTION
331: WHEN no_data_found THEN
332: x_return_status := fnd_api.g_ret_sts_error;
333: WHEN others THEN
334: x_return_status := fnd_api.g_ret_sts_error;
335:
336: END validate_txn_source_id;

Line 334: x_return_status := fnd_api.g_ret_sts_error;

330: EXCEPTION
331: WHEN no_data_found THEN
332: x_return_status := fnd_api.g_ret_sts_error;
333: WHEN others THEN
334: x_return_status := fnd_api.g_ret_sts_error;
335:
336: END validate_txn_source_id;
337:
338:

Line 369: x_return_status := fnd_api.g_true;

365: l_processed_found := TRUE;
366: END LOOP;
367:
368: IF (l_processing_status = 'PROCESSED') OR (l_processed_found = TRUE) THEN
369: x_return_status := fnd_api.g_true;
370: ELSE
371: x_return_status := fnd_api.g_false;
372: END IF;
373:

Line 371: x_return_status := fnd_api.g_false;

367:
368: IF (l_processing_status = 'PROCESSED') OR (l_processed_found = TRUE) THEN
369: x_return_status := fnd_api.g_true;
370: ELSE
371: x_return_status := fnd_api.g_false;
372: END IF;
373:
374: END check_ib_creation;
375:

Line 393: x_return_status := fnd_api.g_ret_sts_success;

389: l_subject_id NUMBER;
390:
391: BEGIN
392:
393: x_return_status := fnd_api.g_ret_sts_success;
394:
395: SELECT instance_exists_flag,
396: instance_id,
397: inventory_item_id,

Line 413: x_return_status := fnd_api.g_ret_sts_error;

409: l_subject_id := l_inventory_item_id;
410: END IF;
411:
412: IF p_subject_id <> l_subject_id THEN
413: x_return_status := fnd_api.g_ret_sts_error;
414: END IF;
415:
416: EXCEPTION
417: WHEN no_data_found THEN

Line 418: x_return_status := fnd_api.g_ret_sts_error;

414: END IF;
415:
416: EXCEPTION
417: WHEN no_data_found THEN
418: x_return_status := fnd_api.g_ret_sts_error;
419: END validate_subject_id;
420:
421:
422: PROCEDURE validate_object_id(

Line 434: x_return_status := fnd_api.g_ret_sts_success;

430: INTO l_found
431: FROM csi_item_instances
432: WHERE instance_id = p_object_id;
433:
434: x_return_status := fnd_api.g_ret_sts_success;
435:
436: EXCEPTION
437: WHEN no_data_found THEN
438: x_return_status := fnd_api.g_ret_sts_error;

Line 438: x_return_status := fnd_api.g_ret_sts_error;

434: x_return_status := fnd_api.g_ret_sts_success;
435:
436: EXCEPTION
437: WHEN no_data_found THEN
438: x_return_status := fnd_api.g_ret_sts_error;
439: END validate_object_id;
440:
441: /* validate relationship type code for item instances */
442: PROCEDURE validate_ii_rltns_type_code(

Line 454: x_return_status := fnd_api.g_ret_sts_success;

450: INTO v_found
451: FROM csi_ii_relation_types
452: WHERE relationship_type_code = p_rltns_type_code;
453:
454: x_return_status := fnd_api.g_ret_sts_success;
455:
456: EXCEPTION
457: WHEN no_data_found THEN
458: x_return_status := fnd_api.g_ret_sts_error;

Line 458: x_return_status := fnd_api.g_ret_sts_error;

454: x_return_status := fnd_api.g_ret_sts_success;
455:
456: EXCEPTION
457: WHEN no_data_found THEN
458: x_return_status := fnd_api.g_ret_sts_error;
459:
460: END validate_ii_rltns_type_code;
461:
462: /* validate instance party id from csi_i_parties */

Line 477: x_return_status := fnd_api.g_ret_sts_success;

473: FROM csi_i_parties
474: WHERE instance_id = p_instance_id
475: AND instance_party_id = p_instance_party_id;
476:
477: x_return_status := fnd_api.g_ret_sts_success;
478:
479: EXCEPTION
480: WHEN no_data_found THEN
481: x_return_status := fnd_api.g_ret_sts_error;

Line 481: x_return_status := fnd_api.g_ret_sts_error;

477: x_return_status := fnd_api.g_ret_sts_success;
478:
479: EXCEPTION
480: WHEN no_data_found THEN
481: x_return_status := fnd_api.g_ret_sts_error;
482:
483: END validate_instance_party_id;
484:
485: PROCEDURE validate_ip_account_id(

Line 497: x_return_status := fnd_api.g_ret_sts_success;

493: INTO l_found
494: FROM csi_ip_accounts
495: WHERE ip_account_id = p_ip_account_id;
496:
497: x_return_status := fnd_api.g_ret_sts_success;
498:
499: EXCEPTION
500: WHEN no_data_found THEN
501: x_return_status := fnd_api.g_ret_sts_error;

Line 501: x_return_status := fnd_api.g_ret_sts_error;

497: x_return_status := fnd_api.g_ret_sts_success;
498:
499: EXCEPTION
500: WHEN no_data_found THEN
501: x_return_status := fnd_api.g_ret_sts_error;
502: END validate_ip_account_id;
503:
504: PROCEDURE validate_instance_ou_id(
505: p_instance_id IN number,

Line 518: x_return_status := fnd_api.g_ret_sts_success;

514: FROM csi_i_org_assignments
515: WHERE instance_id = p_instance_id
516: AND instance_ou_id = p_instance_ou_id;
517:
518: x_return_status := fnd_api.g_ret_sts_success;
519:
520: EXCEPTION
521: WHEN no_data_found THEN
522: x_return_status := fnd_api.g_ret_sts_error;

Line 522: x_return_status := fnd_api.g_ret_sts_error;

518: x_return_status := fnd_api.g_ret_sts_success;
519:
520: EXCEPTION
521: WHEN no_data_found THEN
522: x_return_status := fnd_api.g_ret_sts_error;
523: END validate_instance_ou_id;
524:
525: PROCEDURE validate_instance_rltns_id(
526: p_csi_inst_rltns_id IN number,

Line 537: x_return_status := fnd_api.g_ret_sts_success;

533: INTO x_object_id
534: FROM csi_ii_relationships
535: WHERE relationship_id = p_csi_inst_rltns_id;
536:
537: x_return_status := fnd_api.g_ret_sts_success;
538:
539: EXCEPTION
540: WHEN no_data_found THEN
541: x_return_status := fnd_api.g_ret_sts_error;

Line 541: x_return_status := fnd_api.g_ret_sts_error;

537: x_return_status := fnd_api.g_ret_sts_success;
538:
539: EXCEPTION
540: WHEN no_data_found THEN
541: x_return_status := fnd_api.g_ret_sts_error;
542:
543: END validate_instance_rltns_id;
544:
545: /* integrity check for the source transaction */

Line 581: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

577: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
578: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
579: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
580: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
581: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
582:
583: BEGIN
584:
585: l_total_quantity := 0;

Line 603: IF l_return_status <> fnd_api.g_ret_sts_success THEN

599: x_txn_pty_acct_detail_tbl => l_pty_acct_tbl,
600: x_txn_org_assgn_tbl => l_org_assgn_tbl,
601: x_return_status => l_return_status);
602:
603: IF l_return_status <> fnd_api.g_ret_sts_success THEN
604: RAISE fnd_api.g_exc_error;
605: END IF;
606:
607: l_src_organization_id := l_src_rec.organization_id;

Line 604: RAISE fnd_api.g_exc_error;

600: x_txn_org_assgn_tbl => l_org_assgn_tbl,
601: x_return_status => l_return_status);
602:
603: IF l_return_status <> fnd_api.g_ret_sts_success THEN
604: RAISE fnd_api.g_exc_error;
605: END IF;
606:
607: l_src_organization_id := l_src_rec.organization_id;
608: l_src_item_id := l_src_rec.inventory_item_id;

Line 669: RAISE fnd_api.g_exc_error;

665: fnd_message.set_name('CSI', 'CSI_API_INVALID_INSTANCE_ID');
666: fnd_message.set_token('INSTANCE_ID',
667: p_txn_line_dtl_tbl(l_index).instance_id);
668: fnd_msg_pub.add;
669: RAISE fnd_api.g_exc_error;
670: END;
671:
672: END IF;
673:

Line 687: RAISE fnd_api.g_exc_error;

683: FND_MESSAGE.set_token('DTL_ITEM_ID',l_dtl_item_id);
684: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
685: FND_MESSAGE.set_token('SRC_LINE_ID',p_txn_line_rec.source_transaction_id);
686: FND_MSG_PUB.add;
687: RAISE fnd_api.g_exc_error;
688: END IF;
689: END IF ;
690: ---Added (End) for m-to-m enhancements
691:

Line 723: IF nvl(p_txn_line_dtl_tbl(l_index).location_id , fnd_api.g_miss_num) <>

719:
720: /* check the location_type_code for the source */
721: IF p_txn_line_rec.source_transaction_table = 'OE_ORDER_LINES_ALL' THEN
722:
723: IF nvl(p_txn_line_dtl_tbl(l_index).location_id , fnd_api.g_miss_num) <>
724: fnd_api.g_miss_num
725: THEN
726:
727: IF p_txn_line_dtl_tbl(l_index).location_type_code <> 'HZ_PARTY_SITES'

Line 724: fnd_api.g_miss_num

720: /* check the location_type_code for the source */
721: IF p_txn_line_rec.source_transaction_table = 'OE_ORDER_LINES_ALL' THEN
722:
723: IF nvl(p_txn_line_dtl_tbl(l_index).location_id , fnd_api.g_miss_num) <>
724: fnd_api.g_miss_num
725: THEN
726:
727: IF p_txn_line_dtl_tbl(l_index).location_type_code <> 'HZ_PARTY_SITES'
728: THEN

Line 736: RAISE fnd_api.g_exc_error;

732: FND_MESSAGE.set_token('LOC_code', p_txn_line_dtl_tbl(l_index).
733: location_type_code);
734:
735: FND_MSG_PUB.add;
736: RAISE fnd_api.g_exc_error;
737:
738: END IF;
739: END IF;
740: ELSE

Line 741: IF nvl(p_txn_line_dtl_tbl(l_index).location_id, fnd_api.g_miss_num)<>

737:
738: END IF;
739: END IF;
740: ELSE
741: IF nvl(p_txn_line_dtl_tbl(l_index).location_id, fnd_api.g_miss_num)<>
742: fnd_api.g_miss_num THEN
743: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
744: FND_MESSAGE.set_token('VALUE', p_txn_line_dtl_tbl(l_index).
745: location_id);

Line 742: fnd_api.g_miss_num THEN

738: END IF;
739: END IF;
740: ELSE
741: IF nvl(p_txn_line_dtl_tbl(l_index).location_id, fnd_api.g_miss_num)<>
742: fnd_api.g_miss_num THEN
743: FND_MESSAGE.set_name('CSI','CSI_TXN_PARAM_IGNORED_WARN');
744: FND_MESSAGE.set_token('VALUE', p_txn_line_dtl_tbl(l_index).
745: location_id);
746: FND_MESSAGE.set_token('PARAM','LOCATION_ID');

Line 763: IF p_validation_level = fnd_api.g_valid_level_full THEN

759: FND_MESSAGE.set_token('SRC_NAME',p_txn_line_rec.source_transaction_table);
760: FND_MESSAGE.set_token('SRC_QTY',l_src_quantity);
761: FND_MESSAGE.set_token('DTL_QTY',l_total_quantity);
762: FND_MSG_PUB.add;
763: IF p_validation_level = fnd_api.g_valid_level_full THEN
764: RAISE fnd_api.g_exc_error;
765: END IF;
766: END IF;
767:

Line 764: RAISE fnd_api.g_exc_error;

760: FND_MESSAGE.set_token('SRC_QTY',l_src_quantity);
761: FND_MESSAGE.set_token('DTL_QTY',l_total_quantity);
762: FND_MSG_PUB.add;
763: IF p_validation_level = fnd_api.g_valid_level_full THEN
764: RAISE fnd_api.g_exc_error;
765: END IF;
766: END IF;
767:
768: END IF;

Line 770: WHEN fnd_api.g_exc_error THEN

766: END IF;
767:
768: END IF;
769: EXCEPTION
770: WHEN fnd_api.g_exc_error THEN
771: x_return_status := fnd_api.g_ret_sts_error;
772: END check_source_integrity;
773:
774: /* This procedure checks for the validity of the party details supplied */

Line 771: x_return_status := fnd_api.g_ret_sts_error;

767:
768: END IF;
769: EXCEPTION
770: WHEN fnd_api.g_exc_error THEN
771: x_return_status := fnd_api.g_ret_sts_error;
772: END check_source_integrity;
773:
774: /* This procedure checks for the validity of the party details supplied */
775: /* Only one owner should be defined for a txn detail record (Instance) */

Line 784: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

780: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
781: p_party_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
782: x_return_status OUT NOCOPY VARCHAR2)
783: IS
784: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
785: l_owner_count number;
786: l_sub_type_rec csi_txn_sub_types%rowtype;
787: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE; -- Added for Bug 13896396
788: BEGIN

Line 790: x_return_status := fnd_api.g_ret_sts_success;

786: l_sub_type_rec csi_txn_sub_types%rowtype;
787: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE; -- Added for Bug 13896396
788: BEGIN
789:
790: x_return_status := fnd_api.g_ret_sts_success;
791:
792: --loop thru line detail table
793: IF p_txn_line_dtl_tbl.COUNT > 0 THEN
794: FOR l_td_ind IN p_txn_line_dtl_tbl.FIRST.. p_txn_line_dtl_tbl.LAST

Line 818: RAISE FND_API.g_exc_error;

814:
815: FND_MESSAGE.set_name('CSI','CSI_TXN_SUB_TYPE_ID_INVALID');
816: FND_MESSAGE.set_token('SUB_TYPE_ID',p_txn_line_dtl_tbl(l_td_ind).sub_type_id);
817: FND_MSG_PUB.add;
818: RAISE FND_API.g_exc_error;
819:
820: END;
821:
822: l_owner_count := 0;

Line 843: RAISE fnd_api.g_exc_error;

839: FND_MESSAGE.set_token('INDEX',l_td_ind);
840: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
841: inventory_item_id);
842: FND_MSG_PUB.add;
843: RAISE fnd_api.g_exc_error;
844: END IF;
845:
846: -- Added for Bug 13896396
847: BEGIN

Line 862: RAISE fnd_api.g_exc_error;

858: fnd_message.set_token('INVENTORY_ITEM_ID',p_txn_line_dtl_tbl(l_td_ind).inventory_item_id);
859: fnd_message.set_token('INV_ORGANIZATION_ID',p_txn_line_dtl_tbl(l_td_ind).INV_ORGANIZATION_ID);
860: fnd_msg_pub.add;
861:
862: RAISE fnd_api.g_exc_error;
863: END;
864:
865:
866: IF (p_txn_line_rec.source_transaction_type_id <> 53 OR (p_txn_line_rec.source_transaction_type_id = 53

Line 881: RAISE fnd_api.g_exc_error;

877: FND_MESSAGE.set_token('INDEX',l_td_ind);
878: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
879: inventory_item_id);
880: FND_MSG_PUB.add;
881: RAISE fnd_api.g_exc_error;
882: END IF;
883:
884: END IF;
885: ELSE

Line 894: RAISE fnd_api.g_exc_error;

890: FND_MESSAGE.set_token('INDEX',l_td_ind);
891: FND_MESSAGE.set_token('ITEM_ID', p_txn_line_dtl_tbl(l_td_ind).
892: inventory_item_id);
893: FND_MSG_PUB.add;
894: RAISE fnd_api.g_exc_error;
895: END IF;
896:
897: END IF;
898: END IF;

Line 904: WHEN fnd_api.g_exc_error THEN

900: END LOOP;
901: END IF;
902:
903: EXCEPTION
904: WHEN fnd_api.g_exc_error THEN
905: x_return_status := fnd_api.g_ret_sts_error;
906:
907: END check_party_integrity;
908:

Line 905: x_return_status := fnd_api.g_ret_sts_error;

901: END IF;
902:
903: EXCEPTION
904: WHEN fnd_api.g_exc_error THEN
905: x_return_status := fnd_api.g_ret_sts_error;
906:
907: END check_party_integrity;
908:
909: /* private routine used within check_rltns_integrity */ -- Modified this routine to address M-M changes

Line 925: x_return_status := fnd_api.g_ret_sts_success;

921: BEGIN
922: l_loc_ind := 0;
923: l_comp_of_count := 0;
924: x_src_dtl_count := 0;
925: x_return_status := fnd_api.g_ret_sts_success;
926:
927: IF p_iir_tbl.COUNT > 0 THEN
928: FOR l_ind IN p_iir_tbl.FIRST .. p_iir_tbl.LAST
929: LOOP

Line 939: x_return_status := fnd_api.g_ret_sts_error;

935:
936: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
937: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
938: FND_MSG_PUB.add;
939: x_return_status := fnd_api.g_ret_sts_error;
940: exit;
941: END IF;
942:
943: IF p_iir_tbl(l_ind).relationship_type_code = 'COMPONENT-OF' THEN

Line 977: x_return_status := fnd_api.g_ret_sts_error;

973: ( p_iir_tbl(l_ind).object_type not in ('T','I') ) ) THEN
974: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
975: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
976: FND_MSG_PUB.add;
977: x_return_status := fnd_api.g_ret_sts_error;
978: exit;
979: ELSIF ( ( p_iir_tbl(l_ind).subject_type = p_iir_tbl(l_ind).object_type) AND
980: (p_iir_tbl(l_ind).object_type = 'I' ) ) THEN --atleast one of them should be 'T'
981:

Line 985: x_return_status := fnd_api.g_ret_sts_error;

981:
982: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
983: FND_MESSAGE.set_token('TXN_DTL_ID',p_sub_obj_id);
984: FND_MSG_PUB.add;
985: x_return_status := fnd_api.g_ret_sts_error;
986: exit;
987: END IF;
988:
989: IF p_iir_tbl(l_ind).relationship_type_code = 'COMPONENT-OF' THEN

Line 1019: x_return_status := fnd_api.g_ret_sts_error; -- this status is then used to determine the multiple comp-of condition

1015: END IF; --object_yn = 'N'
1016: END LOOP;
1017:
1018: IF l_comp_of_count > 1 THEN
1019: x_return_status := fnd_api.g_ret_sts_error; -- this status is then used to determine the multiple comp-of condition
1020: END IF;
1021:
1022: END IF;
1023: END get_iir_details;

Line 1046: l_sub_obj_id NUMBER := fnd_api.g_miss_num;

1042: l_subject_id NUMBER ;
1043: l_object_id NUMBER ;
1044: l_object_type VARCHAR2(30);
1045: l_subject_type VARCHAR2(30);
1046: l_sub_obj_id NUMBER := fnd_api.g_miss_num;
1047: l_object_yn VARCHAR2(1);
1048: l_line_id1 NUMBER;
1049: l_line_id2 NUMBER;
1050: l_src_flag1 VARCHAR2(1);

Line 1070: IF ( l_sub_obj_id = fnd_api.g_miss_num OR l_sub_obj_id = NULL ) THEN

1066: LOOP
1067: l_object_yn := 'N';
1068: l_sub_obj_id := l_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1069:
1070: IF ( l_sub_obj_id = fnd_api.g_miss_num OR l_sub_obj_id = NULL ) THEN
1071: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_DTL_REF');
1072: FND_MESSAGE.set_token('SUBJECT_ID',l_sub_obj_id);
1073: FND_MESSAGE.set_token('OBJECT_ID', NULL);
1074: FND_MSG_PUB.add;

Line 1075: RAISE FND_API.g_exc_error;

1071: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_DTL_REF');
1072: FND_MESSAGE.set_token('SUBJECT_ID',l_sub_obj_id);
1073: FND_MESSAGE.set_token('OBJECT_ID', NULL);
1074: FND_MSG_PUB.add;
1075: RAISE FND_API.g_exc_error;
1076: END IF;
1077: -- get the corresponding ii_rltns (where subject_id = line detail index / id)
1078:
1079: get_iir_details(

Line 1107: RAISE FND_API.g_exc_error;

1103: FND_MESSAGE.set_token('INDEX',l_sub_obj_id);
1104: FND_MESSAGE.set_token('ITEM_ID',
1105: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1106: FND_MSG_PUB.add;
1107: RAISE FND_API.g_exc_error;
1108: END IF;
1109: END IF; -- source flag chk = 'N'
1110:
1111: IF l_iir_tbl.COUNT > 1 THEN

Line 1112: IF l_return_status <> fnd_api.g_ret_sts_success THEN -- status set to error in the get iir routine when Multiple comp - of relationships are found for a given TLD

1108: END IF;
1109: END IF; -- source flag chk = 'N'
1110:
1111: IF l_iir_tbl.COUNT > 1 THEN
1112: IF l_return_status <> fnd_api.g_ret_sts_success THEN -- status set to error in the get iir routine when Multiple comp - of relationships are found for a given TLD
1113: FND_MESSAGE.set_name('CSI','CSI_TXN_MULTIPLE_PARENT');
1114: FND_MESSAGE.set_token('INDEX',l_td_ind);
1115: FND_MESSAGE.set_token('ITEM_ID',
1116: l_line_dtl_tbl(l_td_ind).inventory_item_id);

Line 1118: RAISE FND_API.g_exc_error;

1114: FND_MESSAGE.set_token('INDEX',l_td_ind);
1115: FND_MESSAGE.set_token('ITEM_ID',
1116: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1117: FND_MSG_PUB.add;
1118: RAISE FND_API.g_exc_error;
1119: END IF;
1120: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN
1121: RAISE FND_API.g_exc_error;
1122: END IF;

Line 1120: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN

1116: l_line_dtl_tbl(l_td_ind).inventory_item_id);
1117: FND_MSG_PUB.add;
1118: RAISE FND_API.g_exc_error;
1119: END IF;
1120: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN
1121: RAISE FND_API.g_exc_error;
1122: END IF;
1123:
1124: END LOOP;

Line 1121: RAISE FND_API.g_exc_error;

1117: FND_MSG_PUB.add;
1118: RAISE FND_API.g_exc_error;
1119: END IF;
1120: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN
1121: RAISE FND_API.g_exc_error;
1122: END IF;
1123:
1124: END LOOP;
1125: END IF ; --- p_txn_ii_rltns_tbl.count > 0

Line 1129: WHEN fnd_api.g_exc_error THEN

1125: END IF ; --- p_txn_ii_rltns_tbl.count > 0
1126: END IF;
1127:
1128: EXCEPTION
1129: WHEN fnd_api.g_exc_error THEN
1130:
1131: x_return_status := fnd_api.g_ret_sts_error;
1132:
1133: END check_rltns_integrity;

Line 1131: x_return_status := fnd_api.g_ret_sts_error;

1127:
1128: EXCEPTION
1129: WHEN fnd_api.g_exc_error THEN
1130:
1131: x_return_status := fnd_api.g_ret_sts_error;
1132:
1133: END check_rltns_integrity;
1134:
1135:

Line 1143: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1139: x_return_status OUT NOCOPY varchar2)
1140: IS
1141: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
1142: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1143: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1144:
1145: BEGIN
1146: IF p_line_dtl_tbl.COUNT > 0 THEN
1147: FOR l_td_ind IN p_line_dtl_tbl.FIRST..p_line_dtl_tbl.LAST

Line 1154: IF nvl(px_ii_rltns_tbl(l_ii_ind).subject_index_flag,fnd_api.g_miss_char) = fnd_api.g_miss_char THEN

1150: FOR l_ii_ind IN px_ii_rltns_tbl.FIRST..px_ii_rltns_tbl.LAST
1151: LOOP
1152: /* Added the defaulting of values to the index flags for M-M */
1153:
1154: IF nvl(px_ii_rltns_tbl(l_ii_ind).subject_index_flag,fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1155: px_ii_rltns_tbl(l_ii_ind).subject_index_flag := 'Y';
1156: END IF;
1157:
1158: IF nvl(px_ii_rltns_tbl(l_ii_ind).object_index_flag,fnd_api.g_miss_char) = fnd_api.g_miss_char THEN

Line 1158: IF nvl(px_ii_rltns_tbl(l_ii_ind).object_index_flag,fnd_api.g_miss_char) = fnd_api.g_miss_char THEN

1154: IF nvl(px_ii_rltns_tbl(l_ii_ind).subject_index_flag,fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1155: px_ii_rltns_tbl(l_ii_ind).subject_index_flag := 'Y';
1156: END IF;
1157:
1158: IF nvl(px_ii_rltns_tbl(l_ii_ind).object_index_flag,fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1159: px_ii_rltns_tbl(l_ii_ind).object_index_flag := 'Y';
1160: END IF;
1161:
1162: IF px_ii_rltns_tbl(l_ii_ind).subject_type = 'T'

Line 1172: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1168: p_txn_line_detail_tbl => p_line_dtl_tbl,
1169: x_txn_line_detail_rec => l_line_dtl_rec,
1170: x_return_status => l_return_status);
1171:
1172: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1173: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_INDEX_INVALID');
1174: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).
1175: subject_id);
1176: FND_MSG_PUB.add;

Line 1177: RAISE FND_API.g_exc_error;

1173: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_INDEX_INVALID');
1174: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).
1175: subject_id);
1176: FND_MSG_PUB.add;
1177: RAISE FND_API.g_exc_error;
1178: END IF;
1179:
1180: l_ii_rltns_tbl(l_ii_ind).subject_id :=
1181: l_line_dtl_rec.txn_line_detail_id;

Line 1196: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1192: x_txn_line_detail_rec => l_line_dtl_rec,
1193: x_return_status => l_return_status);
1194:
1195:
1196: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1197: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_INDEX_INVALID');
1198: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).
1199: object_id);
1200: FND_MSG_PUB.add;

Line 1201: RAISE FND_API.g_exc_error;

1197: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_INDEX_INVALID');
1198: FND_MESSAGE.set_token('INDEX_ID',px_ii_rltns_tbl(l_ii_ind).
1199: object_id);
1200: FND_MSG_PUB.add;
1201: RAISE FND_API.g_exc_error;
1202: END IF;
1203:
1204: l_ii_rltns_tbl(l_ii_ind).object_id :=
1205: l_line_dtl_rec.txn_line_detail_id;

Line 1243: WHEN fnd_api.g_exc_error THEN

1239: END IF;
1240:
1241: END IF;
1242: EXCEPTION
1243: WHEN fnd_api.g_exc_error THEN
1244: x_return_status := fnd_api.g_ret_sts_error;
1245: END convert_rltns_index_to_ids;
1246:
1247:

Line 1244: x_return_status := fnd_api.g_ret_sts_error;

1240:
1241: END IF;
1242: EXCEPTION
1243: WHEN fnd_api.g_exc_error THEN
1244: x_return_status := fnd_api.g_ret_sts_error;
1245: END convert_rltns_index_to_ids;
1246:
1247:
1248: PROCEDURE is_valid_owner_for_create(

Line 1266: x_return_status := fnd_api.g_ret_sts_success;

1262: AND relationship_type_code = 'OWNER';
1263:
1264: BEGIN
1265:
1266: x_return_status := fnd_api.g_ret_sts_success;
1267:
1268: SELECT instance_exists_flag,
1269: instance_id
1270: INTO l_instance_exists_flag,

Line 1280: IF nvl(p_instance_party_id ,fnd_api.g_miss_num) = fnd_api.g_miss_num

1276: if the instance party is referred then skip the chk.
1277: */
1278: IF NVL(l_instance_exists_flag,'N') = 'Y' THEN
1279:
1280: IF nvl(p_instance_party_id ,fnd_api.g_miss_num) = fnd_api.g_miss_num
1281: THEN
1282:
1283: FOR csi_pty_rec in csi_pty_cur(l_csi_instance_id)
1284: LOOP

Line 1285: x_return_status := fnd_api.g_ret_sts_error;

1281: THEN
1282:
1283: FOR csi_pty_rec in csi_pty_cur(l_csi_instance_id)
1284: LOOP
1285: x_return_status := fnd_api.g_ret_sts_error;
1286: exit;
1287: END LOOP;
1288:
1289: /* we might have to put the logic if the caller is trying to change the

Line 1304: x_return_status := fnd_api.g_ret_sts_error;

1300: FROM csi_t_party_details
1301: WHERE txn_line_detail_id = p_txn_line_detail_id
1302: AND relationship_type_code = 'OWNER';
1303:
1304: x_return_status := fnd_api.g_ret_sts_error;
1305:
1306: EXCEPTION
1307: WHEN no_data_found THEN
1308: x_return_status := fnd_api.g_ret_sts_success;

Line 1308: x_return_status := fnd_api.g_ret_sts_success;

1304: x_return_status := fnd_api.g_ret_sts_error;
1305:
1306: EXCEPTION
1307: WHEN no_data_found THEN
1308: x_return_status := fnd_api.g_ret_sts_success;
1309:
1310: END;
1311:
1312: END IF;

Line 1341: x_return_status := fnd_api.g_ret_sts_success;

1337:
1338: END IF;
1339:
1340: IF l_found THEN
1341: x_return_status := fnd_api.g_ret_sts_success;
1342: ELSE
1343: x_return_status := fnd_api.g_ret_sts_error;
1344: END IF;
1345:

Line 1343: x_return_status := fnd_api.g_ret_sts_error;

1339:
1340: IF l_found THEN
1341: x_return_status := fnd_api.g_ret_sts_success;
1342: ELSE
1343: x_return_status := fnd_api.g_ret_sts_error;
1344: END IF;
1345:
1346: END get_txn_line_dtl_rec;
1347:

Line 1386: x_return_status := fnd_api.g_ret_sts_success;

1382: FROM csi_t_transaction_lines
1383: WHERE transaction_line_id = l_transaction_line_id;
1384:
1385: x_processing_status := l_processing_status;
1386: x_return_status := fnd_api.g_ret_sts_success;
1387:
1388: EXCEPTION
1389: WHEN no_data_found THEN
1390: x_return_status := fnd_api.g_ret_sts_error;

Line 1390: x_return_status := fnd_api.g_ret_sts_error;

1386: x_return_status := fnd_api.g_ret_sts_success;
1387:
1388: EXCEPTION
1389: WHEN no_data_found THEN
1390: x_return_status := fnd_api.g_ret_sts_error;
1391:
1392: END get_processing_status ;
1393:
1394: PROCEDURE validate_attrib_source_id(

Line 1422: RAISE FND_API.g_exc_error;

1418:
1419: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_TBL_INVALID');
1420: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);
1421: FND_MSG_PUB.add;
1422: RAISE FND_API.g_exc_error;
1423:
1424: END IF;
1425:
1426: x_return_status := fnd_api.g_ret_sts_success;

Line 1426: x_return_status := fnd_api.g_ret_sts_success;

1422: RAISE FND_API.g_exc_error;
1423:
1424: END IF;
1425:
1426: x_return_status := fnd_api.g_ret_sts_success;
1427:
1428: EXCEPTION
1429: WHEN no_data_found THEN
1430:

Line 1435: x_return_status := fnd_api.g_ret_sts_error;

1431: FND_MESSAGE.set_name('CSI','CSI_TXN_ATT_SRC_ID_INVALID');
1432: FND_MESSAGE.set_token('ATT_SRC_TBL',p_attrib_source_table);
1433: FND_MESSAGE.set_token('ATT_SRC_ID',p_attrib_source_id);
1434: FND_MSG_PUB.add;
1435: x_return_status := fnd_api.g_ret_sts_error;
1436:
1437: WHEN fnd_api.g_exc_error THEN
1438:
1439: x_return_status := fnd_api.g_ret_sts_error;

Line 1437: WHEN fnd_api.g_exc_error THEN

1433: FND_MESSAGE.set_token('ATT_SRC_ID',p_attrib_source_id);
1434: FND_MSG_PUB.add;
1435: x_return_status := fnd_api.g_ret_sts_error;
1436:
1437: WHEN fnd_api.g_exc_error THEN
1438:
1439: x_return_status := fnd_api.g_ret_sts_error;
1440:
1441: END validate_attrib_source_id;

Line 1439: x_return_status := fnd_api.g_ret_sts_error;

1435: x_return_status := fnd_api.g_ret_sts_error;
1436:
1437: WHEN fnd_api.g_exc_error THEN
1438:
1439: x_return_status := fnd_api.g_ret_sts_error;
1440:
1441: END validate_attrib_source_id;
1442:
1443: PROCEDURE validate_party_account_id(

Line 1451: x_return_status := fnd_api.g_ret_sts_success;

1447: IS
1448: l_found varchar2(1);
1449: BEGIN
1450:
1451: x_return_status := fnd_api.g_ret_sts_success;
1452:
1453: SELECT 'X'
1454: INTO l_found
1455: FROM hz_cust_accounts

Line 1462: x_return_status := fnd_api.g_ret_sts_error;

1458:
1459: EXCEPTION
1460: WHEN no_data_found THEN
1461:
1462: x_return_status := fnd_api.g_ret_sts_error;
1463:
1464: END validate_party_account_id;
1465:
1466: PROCEDURE get_instance_ref_info(

Line 1498: x_return_status := fnd_api.g_ret_sts_success;

1494: x_instance_exists_flag
1495: FROM csi_t_txn_line_details
1496: WHERE txn_line_detail_id = l_txn_line_dtl_id;
1497:
1498: x_return_status := fnd_api.g_ret_sts_success;
1499:
1500: EXCEPTION
1501: WHEN no_data_found THEN
1502: x_return_status := fnd_api.g_ret_sts_error;

Line 1502: x_return_status := fnd_api.g_ret_sts_error;

1498: x_return_status := fnd_api.g_ret_sts_success;
1499:
1500: EXCEPTION
1501: WHEN no_data_found THEN
1502: x_return_status := fnd_api.g_ret_sts_error;
1503:
1504: END get_instance_ref_info;
1505:
1506: PROCEDURE get_party_detail_rec(

Line 1518: x_return_status := fnd_api.g_ret_sts_success;

1514: INTO x_party_detail_rec
1515: FROM csi_t_party_details
1516: WHERE txn_party_detail_id = p_party_detail_id;
1517:
1518: x_return_status := fnd_api.g_ret_sts_success;
1519:
1520: EXCEPTION
1521: WHEN no_data_found THEN
1522: x_return_status := fnd_api.g_ret_sts_error;

Line 1522: x_return_status := fnd_api.g_ret_sts_error;

1518: x_return_status := fnd_api.g_ret_sts_success;
1519:
1520: EXCEPTION
1521: WHEN no_data_found THEN
1522: x_return_status := fnd_api.g_ret_sts_error;
1523: END get_party_detail_rec;
1524:
1525:
1526: PROCEDURE validate_instance_id(

Line 1539: x_return_status := fnd_api.g_ret_sts_success;

1535: FROM csi_item_instances
1536: WHERE instance_id = p_instance_id;
1537: -- AND unexpired condition
1538:
1539: x_return_status := fnd_api.g_ret_sts_success;
1540:
1541: EXCEPTION
1542: WHEN no_data_found THEN
1543: x_return_status := fnd_api.g_ret_sts_error;

Line 1543: x_return_status := fnd_api.g_ret_sts_error;

1539: x_return_status := fnd_api.g_ret_sts_success;
1540:
1541: EXCEPTION
1542: WHEN no_data_found THEN
1543: x_return_status := fnd_api.g_ret_sts_error;
1544:
1545: END validate_instance_id;
1546:
1547: procedure validate_instance_reference(

Line 1555: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1551: x_return_status OUT NOCOPY varchar2)
1552: IS
1553: l_instance_id csi_t_txn_line_details.instance_id%TYPE;
1554: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;
1555: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1556:
1557: l_td_object_id number;
1558: l_inst_object_id number;
1559: BEGIN

Line 1568: IF l_return_status = fnd_api.g_ret_sts_success THEN

1564: x_instance_id => l_instance_id,
1565: x_instance_exists_flag => l_instance_exists_flag,
1566: x_return_status => l_return_status);
1567:
1568: IF l_return_status = fnd_api.g_ret_sts_success THEN
1569:
1570: --IF nvl(l_instance_exists_flag,'N') <> 'Y' THEN
1571: IF l_instance_id is null THEN -- instance is not refernced
1572:

Line 1580: raise fnd_api.g_exc_error;

1576: fnd_message.set_token('LVL',p_level);
1577: fnd_message.set_token('LVL_DTL_ID',p_level_inst_ref_id);
1578: fnd_msg_pub.add;
1579:
1580: raise fnd_api.g_exc_error;
1581: END IF;
1582:
1583: END IF;
1584:

Line 1592: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1588: p_instance_id => l_instance_id,
1589: p_instance_party_id => p_level_inst_ref_id,
1590: x_return_status => l_return_status);
1591:
1592: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1593:
1594: fnd_message.set_name('CSI','CSI_TXN_INST_PARTY_REF_INVALID');
1595: fnd_message.set_token('INST_ID',l_instance_id);
1596: fnd_message.set_token('INST_PTY_ID',p_level_inst_ref_id);

Line 1599: RAISE fnd_api.g_exc_error;

1595: fnd_message.set_token('INST_ID',l_instance_id);
1596: fnd_message.set_token('INST_PTY_ID',p_level_inst_ref_id);
1597: fnd_msg_pub.add;
1598:
1599: RAISE fnd_api.g_exc_error;
1600: END IF;
1601:
1602: ELSIF p_level = 'ORG_ASSGN' THEN
1603:

Line 1609: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1605: p_instance_id => l_instance_id,
1606: p_instance_ou_id => p_level_inst_ref_id,
1607: x_return_status => l_return_status);
1608:
1609: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1610: fnd_message.set_name('CSI','CSI_TXN_INST_OU_REF_INVALID');
1611: fnd_message.set_token('INST_ID',l_instance_id);
1612: fnd_message.set_token('INST_OU_ID',p_level_inst_ref_id);
1613: fnd_msg_pub.add;

Line 1614: raise fnd_api.g_exc_error;

1610: fnd_message.set_name('CSI','CSI_TXN_INST_OU_REF_INVALID');
1611: fnd_message.set_token('INST_ID',l_instance_id);
1612: fnd_message.set_token('INST_OU_ID',p_level_inst_ref_id);
1613: fnd_msg_pub.add;
1614: raise fnd_api.g_exc_error;
1615: END IF;
1616:
1617: ELSIF p_level = 'ORG_ATTRIB' THEN
1618: null;

Line 1630: IF nvl(l_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

1626: -- compare both the instances
1627:
1628: -- if both are not same then raise exception
1629:
1630: IF nvl(l_instance_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1631:
1632: l_td_object_id := l_instance_id;
1633:
1634: validate_instance_rltns_id(

Line 1639: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1635: p_csi_inst_rltns_id => p_level_inst_ref_id,
1636: x_object_id => l_inst_object_id,
1637: x_return_status => l_return_status);
1638:
1639: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1640: null;
1641: -- invalid csi_inst_relation_id
1642: RAISE fnd_api.g_exc_error;
1643: END IF;

Line 1642: RAISE fnd_api.g_exc_error;

1638:
1639: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1640: null;
1641: -- invalid csi_inst_relation_id
1642: RAISE fnd_api.g_exc_error;
1643: END IF;
1644:
1645: IF l_td_object_id <> l_inst_object_id THEN
1646: null;

Line 1648: RAISE fnd_api.g_exc_error;

1644:
1645: IF l_td_object_id <> l_inst_object_id THEN
1646: null;
1647: -- cannot change the parent (object id) in IB
1648: RAISE fnd_api.g_exc_error;
1649:
1650: END IF;
1651:
1652: END IF;

Line 1659: WHEN fnd_api.g_exc_error THEN

1655:
1656: END IF;
1657:
1658: EXCEPTION
1659: WHEN fnd_api.g_exc_error THEN
1660: x_return_status := fnd_api.g_ret_sts_error;
1661: END validate_instance_reference;
1662:
1663: PROCEDURE validate_account_id(

Line 1660: x_return_status := fnd_api.g_ret_sts_error;

1656: END IF;
1657:
1658: EXCEPTION
1659: WHEN fnd_api.g_exc_error THEN
1660: x_return_status := fnd_api.g_ret_sts_error;
1661: END validate_instance_reference;
1662:
1663: PROCEDURE validate_account_id(
1664: p_account_id in number,

Line 1674: x_return_status := fnd_api.g_ret_sts_success;

1670: SELECT 'X' INTO l_found
1671: FROM hz_cust_accounts
1672: WHERE cust_account_id = p_account_id;
1673:
1674: x_return_status := fnd_api.g_ret_sts_success;
1675:
1676: EXCEPTION
1677: when no_data_found then
1678: x_return_status := fnd_api.g_ret_sts_error;

Line 1678: x_return_status := fnd_api.g_ret_sts_error;

1674: x_return_status := fnd_api.g_ret_sts_success;
1675:
1676: EXCEPTION
1677: when no_data_found then
1678: x_return_status := fnd_api.g_ret_sts_error;
1679:
1680: END validate_account_id;
1681:
1682: PROCEDURE validate_site_use_id(

Line 1718: x_return_status := fnd_api.g_ret_sts_success;

1714: exit;
1715: END LOOP;
1716:
1717: IF l_found THEN
1718: x_return_status := fnd_api.g_ret_sts_success;
1719: ELSE
1720: x_return_status := fnd_api.g_ret_sts_error;
1721: END IF;
1722:

Line 1720: x_return_status := fnd_api.g_ret_sts_error;

1716:
1717: IF l_found THEN
1718: x_return_status := fnd_api.g_ret_sts_success;
1719: ELSE
1720: x_return_status := fnd_api.g_ret_sts_error;
1721: END IF;
1722:
1723: END validate_site_use_id;
1724:

Line 1733: x_txn_system_id := fnd_api.g_miss_num;

1729: x_return_status OUT NOCOPY varchar2)
1730: IS
1731: BEGIN
1732:
1733: x_txn_system_id := fnd_api.g_miss_num;
1734:
1735: IF nvl(p_txn_systems_index,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1736: IF p_txn_systems_tbl.COUNT > 0 THEN
1737: FOR l_ind in p_txn_systems_tbl.FIRST .. p_txn_systems_tbl.LAST

Line 1735: IF nvl(p_txn_systems_index,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

1731: BEGIN
1732:
1733: x_txn_system_id := fnd_api.g_miss_num;
1734:
1735: IF nvl(p_txn_systems_index,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1736: IF p_txn_systems_tbl.COUNT > 0 THEN
1737: FOR l_ind in p_txn_systems_tbl.FIRST .. p_txn_systems_tbl.LAST
1738: LOOP
1739:

Line 1758: x_txn_systems_index := fnd_api.g_miss_num;

1754: x_return_status OUT NOCOPY varchar2)
1755: IS
1756: BEGIN
1757:
1758: x_txn_systems_index := fnd_api.g_miss_num;
1759:
1760: IF nvl(p_txn_system_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1761: IF p_txn_systems_tbl.COUNT > 0 THEN
1762: FOR l_ind in p_txn_systems_tbl.FIRST .. p_txn_systems_tbl.LAST

Line 1760: IF nvl(p_txn_system_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

1756: BEGIN
1757:
1758: x_txn_systems_index := fnd_api.g_miss_num;
1759:
1760: IF nvl(p_txn_system_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
1761: IF p_txn_systems_tbl.COUNT > 0 THEN
1762: FOR l_ind in p_txn_systems_tbl.FIRST .. p_txn_systems_tbl.LAST
1763: LOOP
1764:

Line 1781: x_return_status := fnd_api.g_ret_sts_success;

1777: p_contact_flag in varchar2,
1778: x_return_status OUT NOCOPY varchar2)
1779: IS
1780: BEGIN
1781: x_return_status := fnd_api.g_ret_sts_success;
1782: IF p_contact_flag not in ('Y','N') THEN
1783: x_return_status := fnd_api.g_ret_sts_error;
1784: END IF;
1785: END validate_contact_flag;

Line 1783: x_return_status := fnd_api.g_ret_sts_error;

1779: IS
1780: BEGIN
1781: x_return_status := fnd_api.g_ret_sts_success;
1782: IF p_contact_flag not in ('Y','N') THEN
1783: x_return_status := fnd_api.g_ret_sts_error;
1784: END IF;
1785: END validate_contact_flag;
1786:
1787: /* validtion routine for sub_type_id */

Line 1804: x_return_status := fnd_api.g_ret_sts_error;

1800: AND transaction_type_id = nvl(p_txn_type_id, transaction_type_id);
1801:
1802: BEGIN
1803:
1804: x_return_status := fnd_api.g_ret_sts_error;
1805:
1806: SELECT source_transaction_type_id
1807: INTO l_txn_type_id
1808: FROM csi_t_transaction_lines

Line 1813: x_return_status := fnd_api.g_ret_sts_success;

1809: WHERE transaction_line_id = p_transaction_line_id;
1810:
1811: FOR sub_type_rec in sub_type_cur(l_txn_type_id)
1812: LOOP
1813: x_return_status := fnd_api.g_ret_sts_success;
1814: exit;
1815: END LOOP;
1816:
1817:

Line 1820: x_return_status := fnd_api.g_ret_sts_error;

1816:
1817:
1818: EXCEPTION
1819: WHEN no_data_found THEN
1820: x_return_status := fnd_api.g_ret_sts_error;
1821: END validate_sub_type_id;
1822:
1823: PROCEDURE check_duplicate(
1824: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,

Line 1836: x_return_status := fnd_api.g_ret_sts_error;

1832: FROM csi_t_transaction_lines
1833: WHERE source_transaction_table = p_txn_line_rec.source_transaction_table
1834: AND source_transaction_id = p_txn_line_rec.source_transaction_id;
1835:
1836: x_return_status := fnd_api.g_ret_sts_error;
1837:
1838: EXCEPTION
1839: WHEN no_data_found THEN
1840: x_return_status := fnd_api.g_ret_sts_success;

Line 1840: x_return_status := fnd_api.g_ret_sts_success;

1836: x_return_status := fnd_api.g_ret_sts_error;
1837:
1838: EXCEPTION
1839: WHEN no_data_found THEN
1840: x_return_status := fnd_api.g_ret_sts_success;
1841: END check_duplicate;
1842:
1843: PROCEDURE validate_lot_number(
1844: p_inventory_item_id IN number,

Line 1854: x_return_status := fnd_api.g_ret_sts_success;

1850: l_item_name mtl_system_items.segment1%TYPE;
1851: l_found char;
1852: BEGIN
1853:
1854: x_return_status := fnd_api.g_ret_sts_success;
1855:
1856: -- check whether the item is under lot control or not...
1857:
1858: -- 1 - No Control

Line 1877: RAISE fnd_api.g_exc_error;

1873: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1874: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1875: fnd_msg_pub.add;
1876:
1877: RAISE fnd_api.g_exc_error;
1878: END;
1879:
1880: IF l_lot_control_code = 2 THEN
1881:

Line 1900: RAISE fnd_api.g_exc_error;

1896: WHEN no_data_found THEN
1897: fnd_message.set_name('CSI','CSI_API_INVALID_LOT_NUM');
1898: fnd_message.set_token('LOT_NUMBER',p_lot_number);
1899: fnd_msg_pub.add;
1900: RAISE fnd_api.g_exc_error;
1901:
1902: -- adding this because I took of the organization check
1903: WHEN too_many_rows THEN
1904: null;

Line 1914: WHEN fnd_api.g_exc_error THEN

1910: fnd_msg_pub.add;
1911: END IF;
1912:
1913: EXCEPTION
1914: WHEN fnd_api.g_exc_error THEN
1915: x_return_status := fnd_api.g_ret_sts_error;
1916: END validate_lot_number;
1917:
1918: PROCEDURE validate_serial_number(

Line 1915: x_return_status := fnd_api.g_ret_sts_error;

1911: END IF;
1912:
1913: EXCEPTION
1914: WHEN fnd_api.g_exc_error THEN
1915: x_return_status := fnd_api.g_ret_sts_error;
1916: END validate_lot_number;
1917:
1918: PROCEDURE validate_serial_number(
1919: p_inventory_item_id IN number,

Line 1929: x_return_status := fnd_api.g_ret_sts_success;

1925: l_item_name mtl_system_items.segment1%TYPE;
1926: l_found char;
1927: BEGIN
1928:
1929: x_return_status := fnd_api.g_ret_sts_success;
1930:
1931: -- check whether the item is serial controlled or not
1932:
1933: -- '1' No serial number control

Line 1955: RAISE fnd_api.g_exc_error;

1951: fnd_message.set_token('INVENTORY_ITEM_ID',p_inventory_item_id);
1952: fnd_message.set_token('INV_ORGANIZATION_ID',p_organization_id);
1953: fnd_msg_pub.add;
1954:
1955: RAISE fnd_api.g_exc_error;
1956: END;
1957:
1958: IF l_serial_control_code <> 1 THEN
1959:

Line 1978: RAISE fnd_api.g_exc_error;

1974:
1975: fnd_message.set_name('CSI','CSI_API_INVALID_SERIAL_NUM');
1976: fnd_message.set_token('SERIAL_NUMBER',p_serial_number);
1977: fnd_msg_pub.add;
1978: RAISE fnd_api.g_exc_error;
1979:
1980: -- adding this because I took of the organization check
1981: WHEN too_many_rows THEN
1982: null;

Line 1988: WHEN fnd_api.g_exc_error THEN

1984:
1985: END IF;
1986:
1987: EXCEPTION
1988: WHEN fnd_api.g_exc_error THEN
1989: x_return_status := fnd_api.g_ret_sts_error;
1990: END validate_serial_number;
1991:
1992: /* Added this new routine for M-M Changes */

Line 1989: x_return_status := fnd_api.g_ret_sts_error;

1985: END IF;
1986:
1987: EXCEPTION
1988: WHEN fnd_api.g_exc_error THEN
1989: x_return_status := fnd_api.g_ret_sts_error;
1990: END validate_serial_number;
1991:
1992: /* Added this new routine for M-M Changes */
1993:

Line 2013: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

2009: l_sub_obj_id NUMBER;
2010: l_object_yn VARCHAR2(1);
2011: l_csi_rel_id NUMBER;
2012: l_rel_type VARCHAR2(30);
2013: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2014:
2015:
2016: CURSOR txn_ii_rltns_cur (c_subject_id IN NUMBER,
2017: c_object_id IN NUMBER ,

Line 2049: x_return_status := fnd_api.g_ret_sts_success ;

2045: l_subject_type := l_ii_rltns_rec.subject_type;
2046: l_subject_id := l_ii_rltns_rec.subject_id;
2047: l_csi_rel_id := l_ii_rltns_rec.csi_inst_relationship_id;
2048: l_rel_type := l_ii_rltns_rec.relationship_type_code;
2049: x_return_status := fnd_api.g_ret_sts_success ;
2050:
2051: IF l_line_dtl_rec1.txn_line_detail_id = fnd_api.g_miss_num THEN
2052: -- call validate_inst_details to validate it in instance context
2053:

Line 2051: IF l_line_dtl_rec1.txn_line_detail_id = fnd_api.g_miss_num THEN

2047: l_csi_rel_id := l_ii_rltns_rec.csi_inst_relationship_id;
2048: l_rel_type := l_ii_rltns_rec.relationship_type_code;
2049: x_return_status := fnd_api.g_ret_sts_success ;
2050:
2051: IF l_line_dtl_rec1.txn_line_detail_id = fnd_api.g_miss_num THEN
2052: -- call validate_inst_details to validate it in instance context
2053:
2054: validate_inst_details (
2055: p_iir_rec => l_ii_rltns_rec,

Line 2059: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2055: p_iir_rec => l_ii_rltns_rec,
2056: p_txn_dtl_rec => l_line_dtl_rec2,
2057: x_return_status => l_return_status );
2058:
2059: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2060: RAISE fnd_api.g_exc_error;
2061: END IF;
2062:
2063: ELSIF l_line_dtl_rec2.txn_line_detail_id = fnd_api.g_miss_num THEN

Line 2060: RAISE fnd_api.g_exc_error;

2056: p_txn_dtl_rec => l_line_dtl_rec2,
2057: x_return_status => l_return_status );
2058:
2059: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2060: RAISE fnd_api.g_exc_error;
2061: END IF;
2062:
2063: ELSIF l_line_dtl_rec2.txn_line_detail_id = fnd_api.g_miss_num THEN
2064:

Line 2063: ELSIF l_line_dtl_rec2.txn_line_detail_id = fnd_api.g_miss_num THEN

2059: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2060: RAISE fnd_api.g_exc_error;
2061: END IF;
2062:
2063: ELSIF l_line_dtl_rec2.txn_line_detail_id = fnd_api.g_miss_num THEN
2064:
2065: validate_inst_details (
2066: p_iir_rec => l_ii_rltns_rec,
2067: p_txn_dtl_rec => l_line_dtl_rec1,

Line 2070: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2066: p_iir_rec => l_ii_rltns_rec,
2067: p_txn_dtl_rec => l_line_dtl_rec1,
2068: x_return_status => l_return_status );
2069:
2070: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2071: RAISE fnd_api.g_exc_error;
2072: END IF;
2073: ELSE
2074: /* validate the source txn hdr ID */

Line 2071: RAISE fnd_api.g_exc_error;

2067: p_txn_dtl_rec => l_line_dtl_rec1,
2068: x_return_status => l_return_status );
2069:
2070: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2071: RAISE fnd_api.g_exc_error;
2072: END IF;
2073: ELSE
2074: /* validate the source txn hdr ID */
2075: ---Bypass this check if the source is Configurator

Line 2077: IF (NVL(l_line_dtl_rec1.config_inst_hdr_id , fnd_api.g_miss_num)

2073: ELSE
2074: /* validate the source txn hdr ID */
2075: ---Bypass this check if the source is Configurator
2076: -- Added for CZ Integration
2077: IF (NVL(l_line_dtl_rec1.config_inst_hdr_id , fnd_api.g_miss_num)
2078: = fnd_api.g_miss_num AND
2079: NVL(l_line_dtl_rec2.config_inst_hdr_id , fnd_api.g_miss_num)
2080: = fnd_api.g_miss_num )
2081: THEN

Line 2078: = fnd_api.g_miss_num AND

2074: /* validate the source txn hdr ID */
2075: ---Bypass this check if the source is Configurator
2076: -- Added for CZ Integration
2077: IF (NVL(l_line_dtl_rec1.config_inst_hdr_id , fnd_api.g_miss_num)
2078: = fnd_api.g_miss_num AND
2079: NVL(l_line_dtl_rec2.config_inst_hdr_id , fnd_api.g_miss_num)
2080: = fnd_api.g_miss_num )
2081: THEN
2082: validate_src_header (

Line 2079: NVL(l_line_dtl_rec2.config_inst_hdr_id , fnd_api.g_miss_num)

2075: ---Bypass this check if the source is Configurator
2076: -- Added for CZ Integration
2077: IF (NVL(l_line_dtl_rec1.config_inst_hdr_id , fnd_api.g_miss_num)
2078: = fnd_api.g_miss_num AND
2079: NVL(l_line_dtl_rec2.config_inst_hdr_id , fnd_api.g_miss_num)
2080: = fnd_api.g_miss_num )
2081: THEN
2082: validate_src_header (
2083: p_txn_line_id1 => l_line_dtl_rec1.transaction_line_id,

Line 2080: = fnd_api.g_miss_num )

2076: -- Added for CZ Integration
2077: IF (NVL(l_line_dtl_rec1.config_inst_hdr_id , fnd_api.g_miss_num)
2078: = fnd_api.g_miss_num AND
2079: NVL(l_line_dtl_rec2.config_inst_hdr_id , fnd_api.g_miss_num)
2080: = fnd_api.g_miss_num )
2081: THEN
2082: validate_src_header (
2083: p_txn_line_id1 => l_line_dtl_rec1.transaction_line_id,
2084: p_txn_line_id2 => l_line_dtl_rec2.transaction_line_id,

Line 2087: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2083: p_txn_line_id1 => l_line_dtl_rec1.transaction_line_id,
2084: p_txn_line_id2 => l_line_dtl_rec2.transaction_line_id,
2085: p_rel_type_code => l_ii_rltns_rec.relationship_type_code,
2086: x_return_status => l_return_status);
2087: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2088: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2089: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2090: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2091: FND_MSG_PUB.add;

Line 2092: RAISE fnd_api.g_exc_error;

2088: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2089: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2090: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2091: FND_MSG_PUB.add;
2092: RAISE fnd_api.g_exc_error;
2093: END IF;
2094: END IF ;
2095:
2096: IF ( l_line_dtl_rec1.transaction_line_id = l_line_dtl_rec2.transaction_line_id )

Line 2103: RAISE fnd_api.g_exc_error;

2099: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_TXN_REL');
2100: FND_MESSAGE.set_token('TXN_DTL_ID1', l_line_dtl_rec1.txn_line_detail_id);
2101: FND_MESSAGE.set_token('TXN_DTL_ID2', l_line_dtl_rec2.txn_line_detail_id);
2102: FND_MSG_PUB.add;
2103: RAISE fnd_api.g_exc_error;
2104: END IF;
2105: END IF;
2106:
2107: END IF;

Line 2118: IF nvl(l_ii_rltns_rec.txn_relationship_id,fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

2114: FETCH txn_ii_rltns_cur INTO l_txn_relationship_id ,
2115: l_obj_type,
2116: l_sub_type;
2117: CLOSE txn_ii_rltns_cur ;
2118: IF nvl(l_ii_rltns_rec.txn_relationship_id,fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2119: IF ( l_ii_rltns_rec.object_type = l_obj_type
2120: AND l_ii_rltns_rec.subject_type = l_sub_type) THEN
2121: IF l_txn_relationship_id IS NOT NULL
2122: AND l_ii_rltns_rec.txn_relationship_id <> l_txn_relationship_id

Line 2126: RAISE fnd_api.g_exc_error;

2122: AND l_ii_rltns_rec.txn_relationship_id <> l_txn_relationship_id
2123: THEN
2124: FND_MESSAGE.set_name('CSI','CSI_TXN_DUP_RLTNS');
2125: FND_MSG_PUB.add;
2126: RAISE fnd_api.g_exc_error;
2127: END IF ;
2128: END IF;
2129: END IF;
2130:

Line 2132: WHEN fnd_api.g_exc_error THEN

2128: END IF;
2129: END IF;
2130:
2131: EXCEPTION
2132: WHEN fnd_api.g_exc_error THEN
2133: x_return_status := fnd_api.g_ret_sts_error;
2134: END validate_txn_rltnshp ;
2135:
2136: /* Added new routine for M-M Changes */

Line 2133: x_return_status := fnd_api.g_ret_sts_error;

2129: END IF;
2130:
2131: EXCEPTION
2132: WHEN fnd_api.g_exc_error THEN
2133: x_return_status := fnd_api.g_ret_sts_error;
2134: END validate_txn_rltnshp ;
2135:
2136: /* Added new routine for M-M Changes */
2137:

Line 2169: x_return_status := fnd_api.g_ret_sts_success ;

2165: l_subject_type := l_txn_rltns_rec.subject_type;
2166: l_subject_id := l_txn_rltns_rec.subject_id;
2167: l_csi_rel_id := l_txn_rltns_rec.csi_inst_relationship_id;
2168: l_rel_type := l_txn_rltns_rec.relationship_type_code;
2169: x_return_status := fnd_api.g_ret_sts_success ;
2170:
2171: IF l_txn_rltns_rec.subject_type = 'I' THEN
2172: l_instance_id := l_subject_id;
2173: ELSIF l_txn_rltns_rec.object_type = 'I' THEN

Line 2176: l_instance_id := fnd_api.g_miss_num;

2172: l_instance_id := l_subject_id;
2173: ELSIF l_txn_rltns_rec.object_type = 'I' THEN
2174: l_instance_id := l_object_id;
2175: ELSE
2176: l_instance_id := fnd_api.g_miss_num;
2177: END IF;
2178: IF l_txn_rltns_rec.csi_inst_relationship_id = NULL THEN
2179: l_csi_rel_id := fnd_api.g_miss_num;
2180: END IF;

Line 2179: l_csi_rel_id := fnd_api.g_miss_num;

2175: ELSE
2176: l_instance_id := fnd_api.g_miss_num;
2177: END IF;
2178: IF l_txn_rltns_rec.csi_inst_relationship_id = NULL THEN
2179: l_csi_rel_id := fnd_api.g_miss_num;
2180: END IF;
2181: IF l_txn_rltns_rec.active_end_date = NULL THEN
2182: l_active_end_date := fnd_api.g_miss_date;
2183: END IF;

Line 2182: l_active_end_date := fnd_api.g_miss_date;

2178: IF l_txn_rltns_rec.csi_inst_relationship_id = NULL THEN
2179: l_csi_rel_id := fnd_api.g_miss_num;
2180: END IF;
2181: IF l_txn_rltns_rec.active_end_date = NULL THEN
2182: l_active_end_date := fnd_api.g_miss_date;
2183: END IF;
2184:
2185: IF l_csi_rel_id <> fnd_api.g_miss_num THEN
2186:

Line 2185: IF l_csi_rel_id <> fnd_api.g_miss_num THEN

2181: IF l_txn_rltns_rec.active_end_date = NULL THEN
2182: l_active_end_date := fnd_api.g_miss_date;
2183: END IF;
2184:
2185: IF l_csi_rel_id <> fnd_api.g_miss_num THEN
2186:
2187: BEGIN
2188:
2189: SELECT subject_id,

Line 2200: x_return_status := fnd_api.g_ret_sts_error;

2196: WHERE relationship_id = l_csi_rel_id
2197: AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);
2198: EXCEPTION
2199: WHEN no_data_found THEN
2200: x_return_status := fnd_api.g_ret_sts_error;
2201: END ;
2202: IF l_iir_rec.relationship_type_code = 'COMPONENT-OF' THEN
2203: IF l_iir_rec.object_id <> l_object_id THEN
2204: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');

Line 2208: x_return_status := fnd_api.g_ret_sts_error; -- cannot swap parent in IB

2204: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2205: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2206: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2207: FND_MSG_PUB.add;
2208: x_return_status := fnd_api.g_ret_sts_error; -- cannot swap parent in IB
2209: ELSIF (( l_iir_rec.subject_id <> l_subject_id ) OR
2210: ( l_line_dtl_rec.instance_id <> l_subject_id) OR
2211: ( l_active_end_date <> fnd_api.g_miss_date) ) THEN
2212: BEGIN

Line 2211: ( l_active_end_date <> fnd_api.g_miss_date) ) THEN

2207: FND_MSG_PUB.add;
2208: x_return_status := fnd_api.g_ret_sts_error; -- cannot swap parent in IB
2209: ELSIF (( l_iir_rec.subject_id <> l_subject_id ) OR
2210: ( l_line_dtl_rec.instance_id <> l_subject_id) OR
2211: ( l_active_end_date <> fnd_api.g_miss_date) ) THEN
2212: BEGIN
2213:
2214: SELECT location_type_code
2215: INTO l_loc_type

Line 2221: x_return_status := fnd_api.g_ret_sts_error; -- unexpected error

2217: WHERE instance_id = l_iir_rec.subject_id -- either one should not be in Inventory
2218: AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);
2219: EXCEPTION
2220: WHEN OTHERS THEN
2221: x_return_status := fnd_api.g_ret_sts_error; -- unexpected error
2222: END;
2223: IF l_loc_type = 'INVENTORY' THEN
2224: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2225: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);

Line 2228: x_return_status := fnd_api.g_ret_sts_error; -- this txn is not allowed when in Inventory

2224: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_OPERATION');
2225: FND_MESSAGE.set_token('SUBJECT_ID', l_subject_id);
2226: FND_MESSAGE.set_token('OBJECT_ID' , l_object_id);
2227: FND_MSG_PUB.add;
2228: x_return_status := fnd_api.g_ret_sts_error; -- this txn is not allowed when in Inventory
2229: END IF;
2230: END IF;
2231: END IF;
2232: ELSIF l_instance_id <> fnd_api.g_miss_num THEN

Line 2232: ELSIF l_instance_id <> fnd_api.g_miss_num THEN

2228: x_return_status := fnd_api.g_ret_sts_error; -- this txn is not allowed when in Inventory
2229: END IF;
2230: END IF;
2231: END IF;
2232: ELSIF l_instance_id <> fnd_api.g_miss_num THEN
2233:
2234: BEGIN
2235:
2236: SELECT 'Y'

Line 2246: x_return_status := fnd_api.g_ret_sts_error;

2242: WHEN no_data_found THEN
2243: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_INST_REF');
2244: FND_MESSAGE.set_token('INSTANCE_ID', l_instance_id);
2245: FND_MSG_PUB.add;
2246: x_return_status := fnd_api.g_ret_sts_error;
2247: END;
2248:
2249: BEGIN
2250: SELECT 'Y'

Line 2262: x_return_status := fnd_api.g_ret_sts_error; -- Multiple parents not allowed for 'COMPONENT-OF'

2258: END;
2259:
2260: IF l_found = 'Y' THEN
2261: IF l_rel_type = 'COMPONENT-OF' THEN
2262: x_return_status := fnd_api.g_ret_sts_error; -- Multiple parents not allowed for 'COMPONENT-OF'
2263: END IF;
2264: END IF;
2265: END IF; -- l_csi_rel_id <> g_miss / null
2266: EXCEPTION

Line 2267: WHEN fnd_api.g_exc_error THEN

2263: END IF;
2264: END IF;
2265: END IF; -- l_csi_rel_id <> g_miss / null
2266: EXCEPTION
2267: WHEN fnd_api.g_exc_error THEN
2268: x_return_status := fnd_api.g_ret_sts_error;
2269: END validate_inst_details;
2270:
2271: /* Added new routine for M-M Changes */

Line 2268: x_return_status := fnd_api.g_ret_sts_error;

2264: END IF;
2265: END IF; -- l_csi_rel_id <> g_miss / null
2266: EXCEPTION
2267: WHEN fnd_api.g_exc_error THEN
2268: x_return_status := fnd_api.g_ret_sts_error;
2269: END validate_inst_details;
2270:
2271: /* Added new routine for M-M Changes */
2272:

Line 2292: x_return_status := fnd_api.g_ret_sts_success ;

2288:
2289: BEGIN
2290:
2291: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);
2292: x_return_status := fnd_api.g_ret_sts_success ;
2293: l_query := 'Select source_txn_header_id, source_transaction_type_id '||
2294: 'from csi_t_transaction_lines where transaction_line_id = :line_id';
2295: EXECUTE IMMEDIATE l_query
2296: INTO l_txn_hdr_id1 , l_txn_type_id1

Line 2306: l_txn_hdr_id1 := fnd_api.g_miss_num;

2302:
2303: csi_t_gen_utility_pvt.add('In Validate_src_header :'||'header id1'||l_txn_hdr_id1||'header id2'||l_txn_hdr_id2||'relationship type'||p_rel_type_code);
2304:
2305: IF l_txn_hdr_id1 is NULL THEN
2306: l_txn_hdr_id1 := fnd_api.g_miss_num;
2307: END IF;
2308: IF l_txn_hdr_id2 is NULL THEN
2309: l_txn_hdr_id2 := fnd_api.g_miss_num;
2310: END IF;

Line 2309: l_txn_hdr_id2 := fnd_api.g_miss_num;

2305: IF l_txn_hdr_id1 is NULL THEN
2306: l_txn_hdr_id1 := fnd_api.g_miss_num;
2307: END IF;
2308: IF l_txn_hdr_id2 is NULL THEN
2309: l_txn_hdr_id2 := fnd_api.g_miss_num;
2310: END IF;
2311: IF ( p_rel_type_code = 'CONNECTED-TO' AND
2312: (l_txn_hdr_id1 = fnd_api.g_miss_num OR l_txn_hdr_id2 = fnd_api.g_miss_num) ) THEN
2313: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_HDR_ID_REQD');

Line 2312: (l_txn_hdr_id1 = fnd_api.g_miss_num OR l_txn_hdr_id2 = fnd_api.g_miss_num) ) THEN

2308: IF l_txn_hdr_id2 is NULL THEN
2309: l_txn_hdr_id2 := fnd_api.g_miss_num;
2310: END IF;
2311: IF ( p_rel_type_code = 'CONNECTED-TO' AND
2312: (l_txn_hdr_id1 = fnd_api.g_miss_num OR l_txn_hdr_id2 = fnd_api.g_miss_num) ) THEN
2313: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_HDR_ID_REQD');
2314: FND_MESSAGE.set_token('TXN_LINE_ID1',p_txn_line_id1);
2315: FND_MESSAGE.set_token('TXN_LINE_ID2',p_txn_line_id2);
2316: FND_MSG_PUB.add;

Line 2317: Raise fnd_api.g_exc_error;

2313: FND_MESSAGE.set_name('CSI','CSI_TXN_SRC_HDR_ID_REQD');
2314: FND_MESSAGE.set_token('TXN_LINE_ID1',p_txn_line_id1);
2315: FND_MESSAGE.set_token('TXN_LINE_ID2',p_txn_line_id2);
2316: FND_MSG_PUB.add;
2317: Raise fnd_api.g_exc_error;
2318: END IF;
2319:
2320: IF ((l_txn_hdr_id1 <> l_txn_hdr_id2 ) AND (l_txn_type_id1 = l_txn_type_id2) ) THEN
2321: FND_MESSAGE.set_name('CSI','CSI_TXN_RLT_XSO_NOT_ALLOWED');

Line 2323: Raise fnd_api.g_exc_error;

2319:
2320: IF ((l_txn_hdr_id1 <> l_txn_hdr_id2 ) AND (l_txn_type_id1 = l_txn_type_id2) ) THEN
2321: FND_MESSAGE.set_name('CSI','CSI_TXN_RLT_XSO_NOT_ALLOWED');
2322: FND_MSG_PUB.add;
2323: Raise fnd_api.g_exc_error;
2324: END IF;
2325:
2326: EXCEPTION
2327: WHEN fnd_api.g_exc_error THEN

Line 2327: WHEN fnd_api.g_exc_error THEN

2323: Raise fnd_api.g_exc_error;
2324: END IF;
2325:
2326: EXCEPTION
2327: WHEN fnd_api.g_exc_error THEN
2328: x_return_status := fnd_api.g_ret_sts_error;
2329: END validate_src_header;
2330:
2331: -- Added for CZ Integration (Begin)

Line 2328: x_return_status := fnd_api.g_ret_sts_error;

2324: END IF;
2325:
2326: EXCEPTION
2327: WHEN fnd_api.g_exc_error THEN
2328: x_return_status := fnd_api.g_ret_sts_error;
2329: END validate_src_header;
2330:
2331: -- Added for CZ Integration (Begin)
2332: PROCEDURE check_exists_in_cz(

Line 2350: x_return_status := fnd_api.g_ret_sts_success;

2346: AND instance_rev_nbr = c_config_inst_rev_num
2347: AND config_item_id = c_config_inst_item_id ;
2348: BEGIN
2349:
2350: x_return_status := fnd_api.g_ret_sts_success;
2351:
2352: IF p_txn_line_dtl_tbl.COUNT > 0
2353: THEN
2354: FOR i IN p_txn_line_dtl_tbl.FIRST .. p_txn_line_dtl_tbl.LAST

Line 2372: RAISE fnd_api.g_exc_error;

2368: fnd_message.set_token('INST_HDR_ID',l_td_rec.config_inst_hdr_id);
2369: fnd_message.set_token('INST_REV_NBR',l_td_rec.config_inst_rev_num);
2370: fnd_message.set_token('CONFIG_ITEM_ID',l_td_rec.config_inst_item_id);
2371: fnd_msg_pub.add;
2372: RAISE fnd_api.g_exc_error;
2373: END IF ;
2374: END LOOP ;
2375: END IF ; ---p_txn_line_dtl_tbl.COUNT
2376: EXCEPTION

Line 2377: WHEN fnd_api.g_exc_error

2373: END IF ;
2374: END LOOP ;
2375: END IF ; ---p_txn_line_dtl_tbl.COUNT
2376: EXCEPTION
2377: WHEN fnd_api.g_exc_error
2378: THEN
2379: x_return_status := fnd_api.g_ret_sts_error;
2380: WHEN OTHERS
2381: THEN

Line 2379: x_return_status := fnd_api.g_ret_sts_error;

2375: END IF ; ---p_txn_line_dtl_tbl.COUNT
2376: EXCEPTION
2377: WHEN fnd_api.g_exc_error
2378: THEN
2379: x_return_status := fnd_api.g_ret_sts_error;
2380: WHEN OTHERS
2381: THEN
2382: x_return_status := fnd_api.g_ret_sts_error ;
2383: END check_exists_in_cz ;

Line 2382: x_return_status := fnd_api.g_ret_sts_error ;

2378: THEN
2379: x_return_status := fnd_api.g_ret_sts_error;
2380: WHEN OTHERS
2381: THEN
2382: x_return_status := fnd_api.g_ret_sts_error ;
2383: END check_exists_in_cz ;
2384:
2385:
2386: PROCEDURE get_cz_inst_or_tld_id (

Line 2420: x_return_status := fnd_api.g_ret_sts_success ;

2416: csi_t_gen_utility_pvt.add('p_config_inst_hdr_id :'||p_config_inst_hdr_id
2417: ||' p_config_inst_rev_num :'|| p_config_inst_rev_num ||
2418: ' p_config_inst_item_id :'|| p_config_inst_item_id);
2419:
2420: x_return_status := fnd_api.g_ret_sts_success ;
2421: x_instance_id := NULL ;
2422: x_txn_line_detail_id := NULL ;
2423:
2424: --SELECT TRUNC(sysdate) INTO l_sysdate from dual ;

Line 2444: RAISE fnd_api.g_exc_error;

2440: fnd_message.set_token('INST_HDR_ID',p_config_inst_hdr_id);
2441: fnd_message.set_token('INST_REV_NBR',p_config_inst_rev_num);
2442: fnd_message.set_token('CONFIG_ITEM_ID',p_config_inst_item_id);
2443: fnd_msg_pub.add;
2444: RAISE fnd_api.g_exc_error;
2445: END IF ;
2446:
2447: EXCEPTION
2448: WHEN fnd_api.g_exc_error

Line 2448: WHEN fnd_api.g_exc_error

2444: RAISE fnd_api.g_exc_error;
2445: END IF ;
2446:
2447: EXCEPTION
2448: WHEN fnd_api.g_exc_error
2449: THEN
2450: x_return_status := fnd_api.g_ret_sts_error ;
2451: WHEN OTHERS
2452: THEN

Line 2450: x_return_status := fnd_api.g_ret_sts_error ;

2446:
2447: EXCEPTION
2448: WHEN fnd_api.g_exc_error
2449: THEN
2450: x_return_status := fnd_api.g_ret_sts_error ;
2451: WHEN OTHERS
2452: THEN
2453: x_return_status := fnd_api.g_ret_sts_error ;
2454: END get_cz_inst_or_tld_id ;

Line 2453: x_return_status := fnd_api.g_ret_sts_error ;

2449: THEN
2450: x_return_status := fnd_api.g_ret_sts_error ;
2451: WHEN OTHERS
2452: THEN
2453: x_return_status := fnd_api.g_ret_sts_error ;
2454: END get_cz_inst_or_tld_id ;
2455:
2456:
2457: PROCEDURE get_cz_txn_line_id (

Line 2476: x_return_status := fnd_api.g_ret_sts_success ;

2472:
2473: BEGIN
2474: csi_t_gen_utility_pvt.add('Begin : in get_cz_txn_line_id ');
2475: x_txn_line_id := NULL ;
2476: x_return_status := fnd_api.g_ret_sts_success ;
2477:
2478: OPEN cz_txn_line_cur ;
2479: FETCH cz_txn_line_cur INTO x_txn_line_id ;
2480: CLOSE cz_txn_line_cur ;

Line 2486: x_return_status := fnd_api.g_ret_sts_error ;

2482:
2483: EXCEPTION
2484: WHEN OTHERS
2485: THEN
2486: x_return_status := fnd_api.g_ret_sts_error ;
2487: END get_cz_txn_line_id;
2488:
2489:
2490: PROCEDURE check_cz_session_keys (

Line 2506: x_return_status := fnd_api.g_ret_sts_success ;

2502: AND config_rev_nbr = p_config_session_rev_num
2503: AND config_item_id = p_config_session_item_id ;
2504: BEGIN
2505:
2506: x_return_status := fnd_api.g_ret_sts_success ;
2507: l_config_session_hdr_id := NULL ;
2508: OPEN cz_config_cur ;
2509: FETCH cz_config_cur INTO l_config_session_hdr_id;
2510: CLOSE cz_config_cur ;

Line 2519: RAISE fnd_api.g_exc_error;

2515: fnd_message.set_token('CONFIG_SESSION_HDR_ID',p_config_session_hdr_id);
2516: fnd_message.set_token('CONFIG_SESSION_REV_NUM',p_config_session_rev_num);
2517: fnd_message.set_token('CONFIG_SESSION_ITEM_ID',p_config_session_item_id);
2518: fnd_msg_pub.add;
2519: RAISE fnd_api.g_exc_error;
2520: END IF ;
2521: EXCEPTION
2522: WHEN fnd_api.g_exc_error
2523: THEN

Line 2522: WHEN fnd_api.g_exc_error

2518: fnd_msg_pub.add;
2519: RAISE fnd_api.g_exc_error;
2520: END IF ;
2521: EXCEPTION
2522: WHEN fnd_api.g_exc_error
2523: THEN
2524: x_return_status := fnd_api.g_ret_sts_error ;
2525: WHEN OTHERS
2526: THEN

Line 2524: x_return_status := fnd_api.g_ret_sts_error ;

2520: END IF ;
2521: EXCEPTION
2522: WHEN fnd_api.g_exc_error
2523: THEN
2524: x_return_status := fnd_api.g_ret_sts_error ;
2525: WHEN OTHERS
2526: THEN
2527: x_return_status := fnd_api.g_ret_sts_error ;
2528: END check_cz_session_keys ;

Line 2527: x_return_status := fnd_api.g_ret_sts_error ;

2523: THEN
2524: x_return_status := fnd_api.g_ret_sts_error ;
2525: WHEN OTHERS
2526: THEN
2527: x_return_status := fnd_api.g_ret_sts_error ;
2528: END check_cz_session_keys ;
2529:
2530:
2531: -- Added for CZ Integration (End)