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_TXN_LINE_DTLS_PVT dependencies on CSI_T_VLDN_ROUTINES_PVT

Line 117: csi_t_vldn_routines_pvt.check_reqd_param(

113: -- Main API code
114:
115: -- check for required parameters
116:
117: csi_t_vldn_routines_pvt.check_reqd_param(
118: p_value => p_txn_line_dtl_rec.sub_type_id,
119: p_param_name => 'p_txn_line_dtl_rec.sub_type_id',
120: p_api_name => l_api_name);
121:

Line 125: csi_t_vldn_routines_pvt.check_reqd_param(

121:
122: /* Commenting/Removing this restriction and API will default value for this flag based on the value for instance id column - shegde*/
123: /*
124: IF p_txn_line_dtl_rec.instance_exists_flag = 'Y' THEN
125: csi_t_vldn_routines_pvt.check_reqd_param(
126: p_value => p_txn_line_dtl_rec.instance_exists_flag,
127: p_param_name => 'p_txn_line_dtl_rec.instance_exists_flag',
128: p_api_name => l_api_name);
129: END IF;

Line 132: csi_t_vldn_routines_pvt.check_reqd_param(

128: p_api_name => l_api_name);
129: END IF;
130: */
131:
132: csi_t_vldn_routines_pvt.check_reqd_param(
133: p_value => p_txn_line_dtl_rec.inventory_item_id,
134: p_param_name => 'p_txn_line_dtl_rec.inventory_item_id',
135: p_api_name => l_api_name);
136:

Line 137: csi_t_vldn_routines_pvt.check_reqd_param(

133: p_value => p_txn_line_dtl_rec.inventory_item_id,
134: p_param_name => 'p_txn_line_dtl_rec.inventory_item_id',
135: p_api_name => l_api_name);
136:
137: csi_t_vldn_routines_pvt.check_reqd_param(
138: p_value => p_txn_line_dtl_rec.inv_organization_id,
139: p_param_name => 'p_txn_line_dtl_rec.inv_organization_id',
140: p_api_name => l_api_name);
141:

Line 142: csi_t_vldn_routines_pvt.check_reqd_param(

138: p_value => p_txn_line_dtl_rec.inv_organization_id,
139: p_param_name => 'p_txn_line_dtl_rec.inv_organization_id',
140: p_api_name => l_api_name);
141:
142: csi_t_vldn_routines_pvt.check_reqd_param(
143: p_value => p_txn_line_dtl_rec.quantity,
144: p_param_name => 'p_txn_line_dtl_rec.quantity',
145: p_api_name => l_api_name);
146:

Line 147: csi_t_vldn_routines_pvt.check_reqd_param(

143: p_value => p_txn_line_dtl_rec.quantity,
144: p_param_name => 'p_txn_line_dtl_rec.quantity',
145: p_api_name => l_api_name);
146:
147: csi_t_vldn_routines_pvt.check_reqd_param(
148: p_value => p_txn_line_dtl_rec.unit_of_measure,
149: p_param_name => 'p_txn_line_dtl_rec.unit_of_measure',
150: p_api_name => l_api_name);
151:

Line 152: csi_t_vldn_routines_pvt.check_reqd_param(

148: p_value => p_txn_line_dtl_rec.unit_of_measure,
149: p_param_name => 'p_txn_line_dtl_rec.unit_of_measure',
150: p_api_name => l_api_name);
151:
152: csi_t_vldn_routines_pvt.check_reqd_param(
153: p_value => p_txn_line_dtl_rec.source_transaction_flag,
154: p_param_name => 'p_txn_line_dtl_rec.source_transaction_flag',
155: p_api_name => l_api_name);
156:

Line 161: csi_t_vldn_routines_pvt.check_reqd_param(

157: IF NVL(p_txn_line_dtl_rec.location_id, fnd_api.g_miss_num) <>
158: fnd_api.g_miss_num
159: THEN
160:
161: csi_t_vldn_routines_pvt.check_reqd_param(
162: p_value => p_txn_line_dtl_rec.location_type_code,
163: p_param_name => 'p_txn_line_dtl_rec.location_type_code',
164: p_api_name => l_api_name);
165:

Line 172: csi_t_vldn_routines_pvt.check_reqd_param(

168: IF NVL(p_txn_line_dtl_rec.serial_number, fnd_api.g_miss_char) <>
169: fnd_api.g_miss_char
170: THEN
171:
172: csi_t_vldn_routines_pvt.check_reqd_param(
173: p_value => p_txn_line_dtl_rec.mfg_serial_number_flag,
174: p_param_name => 'p_txn_line_dtl_rec.mfg_serial_number_flag',
175: p_api_name => l_api_name);
176:

Line 187: csi_t_vldn_routines_pvt.validate_sub_type_id(

183: IF nvl(p_txn_line_dtl_rec.sub_type_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
184:
185: --debug('Validate sub type id.');
186:
187: csi_t_vldn_routines_pvt.validate_sub_type_id(
188: p_transaction_line_id => p_txn_line_dtl_rec.transaction_line_id,
189: p_sub_type_id => p_txn_line_dtl_rec.sub_type_id,
190: x_return_status => l_return_status);
191:

Line 227: csi_t_vldn_routines_pvt.validate_instance_id(

223: IF nvl(p_txn_line_dtl_rec.instance_id, fnd_api.g_miss_num) <>
224: fnd_api.g_miss_num THEN
225:
226: --debug('Validate instance id .');
227: csi_t_vldn_routines_pvt.validate_instance_id(
228: p_instance_id => p_txn_line_dtl_rec.instance_id,
229: x_return_status => l_return_status);
230:
231: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 370: csi_t_vldn_routines_pvt.validate_serial_number(

366: THEN
367:
368: debug('Validating Serial Number.');
369:
370: csi_t_vldn_routines_pvt.validate_serial_number(
371: p_inventory_item_id => p_txn_line_dtl_rec.inventory_item_id,
372: p_organization_id => p_txn_line_dtl_rec.inv_organization_id,
373: p_serial_number => p_txn_line_dtl_rec.serial_number,
374: x_return_status => l_return_status);

Line 377: debug('csi_t_vldn_routines_pvt.validate_serial_number Failed.');

373: p_serial_number => p_txn_line_dtl_rec.serial_number,
374: x_return_status => l_return_status);
375:
376: IF l_return_status <> fnd_api.g_ret_sts_success THEN
377: debug('csi_t_vldn_routines_pvt.validate_serial_number Failed.');
378: RAISE fnd_api.g_exc_error;
379: END IF;
380:
381: /*

Line 404: csi_t_vldn_routines_pvt.validate_lot_number(

400: THEN
401:
402: debug('Validating line details lot number .');
403:
404: csi_t_vldn_routines_pvt.validate_lot_number(
405: p_inventory_item_id => p_txn_line_dtl_rec.inventory_item_id,
406: p_organization_id => p_txn_line_dtl_rec.inv_organization_id,
407: p_lot_number => p_txn_line_dtl_rec.lot_number,
408: x_return_status => l_return_status);

Line 411: debug('csi_t_vldn_routines_pvt.validate_lot_number Failed.');

407: p_lot_number => p_txn_line_dtl_rec.lot_number,
408: x_return_status => l_return_status);
409:
410: IF l_return_status <> fnd_api.g_ret_sts_success THEN
411: debug('csi_t_vldn_routines_pvt.validate_lot_number Failed.');
412: RAISE fnd_api.g_exc_error;
413: END IF;
414:
415: /*

Line 486: csi_t_vldn_routines_pvt.validate_txn_source_id(

482: IF NVL(p_txn_line_dtl_rec.reference_source_line_id, fnd_api.g_miss_num) <>
483: fnd_api.g_miss_num -- RMA fulfillment 11.5.9 ER
484: THEN
485:
486: csi_t_vldn_routines_pvt.validate_txn_source_id(
487: p_txn_source_name => 'ORDER_ENTRY',
488: p_txn_source_id => p_txn_line_dtl_rec.reference_source_line_id,
489: x_return_status => l_return_status);
490:

Line 492: debug('csi_t_vldn_routines_pvt.validate_txn_source_id.');

488: p_txn_source_id => p_txn_line_dtl_rec.reference_source_line_id,
489: x_return_status => l_return_status);
490:
491: IF l_return_status <> fnd_api.g_ret_sts_success THEN
492: debug('csi_t_vldn_routines_pvt.validate_txn_source_id.');
493: RAISE fnd_api.g_exc_error;
494: END IF;
495:
496: END IF;

Line 526: csi_t_vldn_routines_pvt.validate_instance_id(

522: l_cascade_owner_flag := p_txn_line_dtl_rec.cascade_owner_flag;
523: END IF;
524:
525: IF nvl(p_txn_line_dtl_rec.parent_instance_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
526: csi_t_vldn_routines_pvt.validate_instance_id(
527: p_instance_id => p_txn_line_dtl_rec.parent_instance_id,
528: x_return_status => l_return_status);
529:
530: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1094: csi_t_vldn_routines_pvt.check_reqd_param(

1090: l_td_rec.config_inst_hdr_id := p_txn_line_detail_tbl(l_ind).config_inst_hdr_id;
1091: l_td_rec.config_inst_rev_num := p_txn_line_detail_tbl(l_ind).config_inst_rev_num;
1092: l_td_rec.config_inst_item_id := p_txn_line_detail_tbl(l_ind).config_inst_item_id;
1093:
1094: csi_t_vldn_routines_pvt.check_reqd_param(
1095: p_value => l_td_rec.txn_line_detail_id,
1096: p_param_name => 'l_td_rec.txn_line_detail_id',
1097: p_api_name => l_api_name);
1098:

Line 1099: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(

1095: p_value => l_td_rec.txn_line_detail_id,
1096: p_param_name => 'l_td_rec.txn_line_detail_id',
1097: p_api_name => l_api_name);
1098:
1099: csi_t_vldn_routines_pvt.validate_txn_line_detail_id(
1100: p_txn_line_detail_id => l_td_rec.txn_line_detail_id,
1101: x_return_status => l_return_status);
1102:
1103: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1154: csi_t_vldn_routines_pvt.check_reqd_param(

1150: --validate sub_type_id
1151: IF l_td_rec.sub_type_id <> fnd_api.g_miss_num
1152: THEN
1153:
1154: csi_t_vldn_routines_pvt.check_reqd_param(
1155: p_value => l_td_rec.sub_type_id,
1156: p_param_name => 'l_td_rec.sub_type_id',
1157: p_api_name => l_api_name);
1158:

Line 1161: csi_t_vldn_routines_pvt.check_reqd_param(

1157: p_api_name => l_api_name);
1158:
1159: --debug('To Validate subtype ID, We require more parameters.');
1160:
1161: csi_t_vldn_routines_pvt.check_reqd_param(
1162: p_value => l_td_rec.transaction_line_id,
1163: p_param_name => 'l_td_rec.transaction_line_id',
1164: p_api_name => l_api_name);
1165: /* not sure why the following are required for an update OR validating sub type - commenting

Line 1167: csi_t_vldn_routines_pvt.check_reqd_param(

1163: p_param_name => 'l_td_rec.transaction_line_id',
1164: p_api_name => l_api_name);
1165: /* not sure why the following are required for an update OR validating sub type - commenting
1166:
1167: csi_t_vldn_routines_pvt.check_reqd_param(
1168: p_value => l_td_rec.inventory_item_id,
1169: p_param_name => 'l_td_rec.inventory_item_id',
1170: p_api_name => l_api_name);
1171:

Line 1172: csi_t_vldn_routines_pvt.check_reqd_param(

1168: p_value => l_td_rec.inventory_item_id,
1169: p_param_name => 'l_td_rec.inventory_item_id',
1170: p_api_name => l_api_name);
1171:
1172: csi_t_vldn_routines_pvt.check_reqd_param(
1173: p_value => l_td_rec.inv_organization_id,
1174: p_param_name => 'l_td_rec.inv_organization_id',
1175: p_api_name => l_api_name);
1176: */

Line 1178: csi_t_vldn_routines_pvt.validate_sub_type_id(

1174: p_param_name => 'l_td_rec.inv_organization_id',
1175: p_api_name => l_api_name);
1176: */
1177:
1178: csi_t_vldn_routines_pvt.validate_sub_type_id(
1179: p_transaction_line_id => l_td_rec.transaction_line_id,
1180: p_sub_type_id => l_td_rec.sub_type_id,
1181: x_return_status => l_return_status);
1182:

Line 1229: -- csi_t_vldn_routines_pvt.check_reqd_param(

1225: -- validate instance ID
1226: -- IF l_td_rec.instance_exists_flag = 'Y' THEN
1227: IF nvl(l_td_rec.instance_id, fnd_api.g_miss_num) <>
1228: fnd_api.g_miss_num THEN
1229: -- csi_t_vldn_routines_pvt.check_reqd_param(
1230: -- p_value => l_td_rec.instance_id,
1231: -- p_param_name => 'l_td_rec.instance_id',
1232: -- p_api_name => l_api_name);
1233:

Line 1234: csi_t_vldn_routines_pvt.validate_instance_id(

1230: -- p_value => l_td_rec.instance_id,
1231: -- p_param_name => 'l_td_rec.instance_id',
1232: -- p_api_name => l_api_name);
1233:
1234: csi_t_vldn_routines_pvt.validate_instance_id(
1235: p_instance_id => l_td_rec.instance_id,
1236: x_return_status => l_return_status);
1237:
1238: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1261: csi_t_vldn_routines_pvt.check_reqd_param(

1257: in any case, for validating serial, lot, revision etc WHEN CHANGED
1258: we are checking for the same again...
1259:
1260: -- mandate item , organization and quantity and uom
1261: csi_t_vldn_routines_pvt.check_reqd_param(
1262: p_value => l_td_rec.inv_organization_id,
1263: p_param_name => 'l_td_rec.inv_organization_id',
1264: p_api_name => l_api_name);
1265:

Line 1266: csi_t_vldn_routines_pvt.check_reqd_param(

1262: p_value => l_td_rec.inv_organization_id,
1263: p_param_name => 'l_td_rec.inv_organization_id',
1264: p_api_name => l_api_name);
1265:
1266: csi_t_vldn_routines_pvt.check_reqd_param(
1267: p_value => l_td_rec.inventory_item_id,
1268: p_param_name => 'l_td_rec.inventory_item_id',
1269: p_api_name => l_api_name);
1270:

Line 1271: csi_t_vldn_routines_pvt.check_reqd_param(

1267: p_value => l_td_rec.inventory_item_id,
1268: p_param_name => 'l_td_rec.inventory_item_id',
1269: p_api_name => l_api_name);
1270:
1271: csi_t_vldn_routines_pvt.check_reqd_param(
1272: p_value => l_td_rec.quantity,
1273: p_param_name => 'l_td_rec.quantity',
1274: p_api_name => l_api_name);
1275:

Line 1276: csi_t_vldn_routines_pvt.check_reqd_param(

1272: p_value => l_td_rec.quantity,
1273: p_param_name => 'l_td_rec.quantity',
1274: p_api_name => l_api_name);
1275:
1276: csi_t_vldn_routines_pvt.check_reqd_param(
1277: p_value => l_td_rec.unit_of_measure,
1278: p_param_name => 'l_td_rec.unit_of_measure',
1279: p_api_name => l_api_name);
1280: */

Line 1326: csi_t_vldn_routines_pvt.check_reqd_param(

1322:
1323: -- validate inventory_item_id
1324: IF l_td_rec.inventory_item_id <> fnd_api.g_miss_num THEN
1325:
1326: csi_t_vldn_routines_pvt.check_reqd_param(
1327: p_value => l_td_rec.inventory_item_id,
1328: p_param_name => 'l_td_rec.inventory_item_id',
1329: p_api_name => l_api_name);
1330:

Line 1408: csi_t_vldn_routines_pvt.check_reqd_param(

1404: AND
1405: l_td_rec.lot_number is not null
1406: THEN
1407:
1408: csi_t_vldn_routines_pvt.check_reqd_param(
1409: p_value => l_td_rec.inventory_item_id,
1410: p_param_name => 'l_td_rec.inventory_item_id',
1411: p_api_name => l_api_name);
1412:

Line 1413: csi_t_vldn_routines_pvt.check_reqd_param(

1409: p_value => l_td_rec.inventory_item_id,
1410: p_param_name => 'l_td_rec.inventory_item_id',
1411: p_api_name => l_api_name);
1412:
1413: csi_t_vldn_routines_pvt.check_reqd_param(
1414: p_value => l_td_rec.inv_organization_id,
1415: p_param_name => 'l_td_rec.inv_organization_id',
1416: p_api_name => l_api_name);
1417:

Line 1420: csi_t_vldn_routines_pvt.validate_lot_number(

1416: p_api_name => l_api_name);
1417:
1418: debug('Validating line details lot number .');
1419:
1420: csi_t_vldn_routines_pvt.validate_lot_number(
1421: p_inventory_item_id => l_td_rec.inventory_item_id,
1422: p_organization_id => l_td_rec.inv_organization_id,
1423: p_lot_number => l_td_rec.lot_number,
1424: x_return_status => l_return_status);

Line 1427: debug('csi_t_vldn_routines_pvt.validate_lot_number Failed.');

1423: p_lot_number => l_td_rec.lot_number,
1424: x_return_status => l_return_status);
1425:
1426: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1427: debug('csi_t_vldn_routines_pvt.validate_lot_number Failed.');
1428: RAISE fnd_api.g_exc_error;
1429: END IF;
1430:
1431: END IF;

Line 1440: csi_t_vldn_routines_pvt.check_reqd_param(

1436: -- IF l_td_rec.mfg_serial_number_flag = 'Y'
1437: -- AND bug 3593990
1438: IF nvl(l_td_rec.serial_number, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
1439:
1440: csi_t_vldn_routines_pvt.check_reqd_param(
1441: p_value => l_td_rec.inventory_item_id,
1442: p_param_name => 'l_td_rec.inventory_item_id',
1443: p_api_name => l_api_name);
1444:

Line 1445: csi_t_vldn_routines_pvt.check_reqd_param(

1441: p_value => l_td_rec.inventory_item_id,
1442: p_param_name => 'l_td_rec.inventory_item_id',
1443: p_api_name => l_api_name);
1444:
1445: csi_t_vldn_routines_pvt.check_reqd_param(
1446: p_value => l_td_rec.inv_organization_id,
1447: p_param_name => 'l_td_rec.inv_organization_id',
1448: p_api_name => l_api_name);
1449:

Line 1452: csi_t_vldn_routines_pvt.validate_serial_number(

1448: p_api_name => l_api_name);
1449:
1450: debug('Validating Serial Number.');
1451:
1452: csi_t_vldn_routines_pvt.validate_serial_number(
1453: p_inventory_item_id => l_td_rec.inventory_item_id,
1454: p_organization_id => l_td_rec.inv_organization_id,
1455: p_serial_number => l_td_rec.serial_number,
1456: x_return_status => l_return_status);

Line 1459: debug('csi_t_vldn_routines_pvt.validate_serial_number Failed.');

1455: p_serial_number => l_td_rec.serial_number,
1456: x_return_status => l_return_status);
1457:
1458: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1459: debug('csi_t_vldn_routines_pvt.validate_serial_number Failed.');
1460: RAISE fnd_api.g_exc_error;
1461: END IF;
1462:
1463: /*

Line 1560: csi_t_vldn_routines_pvt.validate_txn_source_id(

1556: IF NVL(l_td_rec.reference_source_line_id, fnd_api.g_miss_num)
1557: <> fnd_api.g_miss_num
1558: THEN
1559:
1560: csi_t_vldn_routines_pvt.validate_txn_source_id(
1561: p_txn_source_name => 'ORDER_ENTRY',
1562: p_txn_source_id => l_td_rec.reference_source_line_id,
1563: x_return_status => l_return_status);
1564:

Line 1566: debug('csi_t_vldn_routines_pvt.validate_txn_source_id.');

1562: p_txn_source_id => l_td_rec.reference_source_line_id,
1563: x_return_status => l_return_status);
1564:
1565: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1566: debug('csi_t_vldn_routines_pvt.validate_txn_source_id.');
1567: RAISE fnd_api.g_exc_error;
1568: END IF;
1569:
1570: END IF;

Line 3547: csi_t_vldn_routines_pvt.check_reqd_param(

3543: END IF;
3544:
3545: END IF;
3546:
3547: csi_t_vldn_routines_pvt.check_reqd_param(
3548: p_value => l_txn_line_rec.transaction_line_id,
3549: p_param_name => 'p_txn_line_rec.transaction_line_id',
3550: p_api_name => 'update_txn_line_dtls');
3551:

Line 3553: csi_t_vldn_routines_pvt.validate_transaction_line_id(

3549: p_param_name => 'p_txn_line_rec.transaction_line_id',
3550: p_api_name => 'update_txn_line_dtls');
3551:
3552: -- validate txn_line_id
3553: csi_t_vldn_routines_pvt.validate_transaction_line_id(
3554: p_transaction_line_id => l_txn_line_rec.transaction_line_id,
3555: x_transaction_line_rec => l_transaction_line_rec, -- changed for Mass Update R12
3556: x_return_status => l_return_status);
3557:

Line 3572: csi_t_vldn_routines_pvt.check_cz_session_keys

3568: THEN
3569:
3570: csi_t_gen_utility_pvt.add('Validating against CZ view ');
3571:
3572: csi_t_vldn_routines_pvt.check_cz_session_keys
3573: (p_config_session_hdr_id => p_txn_line_rec.config_session_hdr_id,
3574: p_config_session_rev_num => p_txn_line_rec.config_session_rev_num,
3575: p_config_session_item_id => p_txn_line_rec.config_session_item_id,
3576: x_return_status => l_return_status);