82: p_application_short_name => 'ENG'
83: );
84:
85: IF(l_application_id IS NULL ) THEN
86: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
87: FND_MESSAGE.set_token('COL_VALUE', 'ENG');
88: FND_MSG_PUB.add;
89: RAISE FND_API.g_exc_error;
90: END IF;
83: );
84:
85: IF(l_application_id IS NULL ) THEN
86: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
87: FND_MESSAGE.set_token('COL_VALUE', 'ENG');
88: FND_MSG_PUB.add;
89: RAISE FND_API.g_exc_error;
90: END IF;
91: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.get_uda_attributes');
224: p_application_short_name => 'BOM'
225: );
226: IF(l_application_id IS NULL ) THEN
227:
228: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
229: FND_MESSAGE.set_token('COL_VALUE', 'BOM');
230: FND_MSG_PUB.add;
231: RAISE FND_API.g_exc_error;
232: END IF;
225: );
226: IF(l_application_id IS NULL ) THEN
227:
228: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
229: FND_MESSAGE.set_token('COL_VALUE', 'BOM');
230: FND_MSG_PUB.add;
231: RAISE FND_API.g_exc_error;
232: END IF;
233: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.get_uda_attributes');
407: p_application_short_name => 'BOM'
408: );
409:
410: IF(l_application_id IS NULL ) THEN
411: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
412: FND_MESSAGE.set_token('COL_VALUE', 'BOM');
413: FND_MSG_PUB.add;
414: RAISE FND_API.g_exc_error;
415: END IF;
408: );
409:
410: IF(l_application_id IS NULL ) THEN
411: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
412: FND_MESSAGE.set_token('COL_VALUE', 'BOM');
413: FND_MSG_PUB.add;
414: RAISE FND_API.g_exc_error;
415: END IF;
416: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_ITEM_HELPER.get_uda_attributes');
3350: AND concatenated_segments = p_item_name;
3351: IF (INV_EBI_ITEM_HELPER.is_new_item_request_reqd( l_item_catalog_group_id ) = FND_API.g_true) AND l_approval_status <> 'A'
3352: THEN
3353: FND_MSG_PUB.initialize();
3354: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_APROVAL_STS');
3355: FND_MESSAGE.set_token('ITEM_NUMBER',p_item_name);
3356: FND_MESSAGE.set_token('ORGANIZATION_ID',l_master_org);
3357: FND_MESSAGE.set_token('CHILD_ORGANIZATION_ID',p_organization_id);
3358: FND_MSG_PUB.add;
3351: IF (INV_EBI_ITEM_HELPER.is_new_item_request_reqd( l_item_catalog_group_id ) = FND_API.g_true) AND l_approval_status <> 'A'
3352: THEN
3353: FND_MSG_PUB.initialize();
3354: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_APROVAL_STS');
3355: FND_MESSAGE.set_token('ITEM_NUMBER',p_item_name);
3356: FND_MESSAGE.set_token('ORGANIZATION_ID',l_master_org);
3357: FND_MESSAGE.set_token('CHILD_ORGANIZATION_ID',p_organization_id);
3358: FND_MSG_PUB.add;
3359: RAISE FND_API.g_exc_unexpected_error;
3352: THEN
3353: FND_MSG_PUB.initialize();
3354: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_APROVAL_STS');
3355: FND_MESSAGE.set_token('ITEM_NUMBER',p_item_name);
3356: FND_MESSAGE.set_token('ORGANIZATION_ID',l_master_org);
3357: FND_MESSAGE.set_token('CHILD_ORGANIZATION_ID',p_organization_id);
3358: FND_MSG_PUB.add;
3359: RAISE FND_API.g_exc_unexpected_error;
3360: END IF;
3353: FND_MSG_PUB.initialize();
3354: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_APROVAL_STS');
3355: FND_MESSAGE.set_token('ITEM_NUMBER',p_item_name);
3356: FND_MESSAGE.set_token('ORGANIZATION_ID',l_master_org);
3357: FND_MESSAGE.set_token('CHILD_ORGANIZATION_ID',p_organization_id);
3358: FND_MSG_PUB.add;
3359: RAISE FND_API.g_exc_unexpected_error;
3360: END IF;
3361: END IF;
3455: END IF;
3456: END IF;
3457: END IF;
3458: ELSE
3459: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
3460: FND_MESSAGE.set_token('ITEM', p_item_name);
3461: FND_MSG_PUB.add;
3462: RAISE FND_API.g_exc_error;
3463: END IF;
3456: END IF;
3457: END IF;
3458: ELSE
3459: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
3460: FND_MESSAGE.set_token('ITEM', p_item_name);
3461: FND_MSG_PUB.add;
3462: RAISE FND_API.g_exc_error;
3463: END IF;
3464: END IF;
3882: );
3883: INV_EBI_UTIL.debug_line('STEP 30: ORG ID '|| l_src_organization_id || ' ASSY ITEM ID: '|| l_src_assembly_item_id ||
3884: 'BILL SEQUENCE ID: '|| l_src_bill_sequence_id);
3885: IF(l_src_bill_sequence_id IS NULL ) THEN
3886: FND_MESSAGE.set_name('INV','INV_EBI_COMMON_BILL_NOT_FOUND');
3887: FND_MESSAGE.set_token('ASSY_ITEM', p_common_assembly_item_name);
3888: FND_MSG_PUB.add;
3889: RAISE FND_API.g_exc_error;
3890: END IF;
3883: INV_EBI_UTIL.debug_line('STEP 30: ORG ID '|| l_src_organization_id || ' ASSY ITEM ID: '|| l_src_assembly_item_id ||
3884: 'BILL SEQUENCE ID: '|| l_src_bill_sequence_id);
3885: IF(l_src_bill_sequence_id IS NULL ) THEN
3886: FND_MESSAGE.set_name('INV','INV_EBI_COMMON_BILL_NOT_FOUND');
3887: FND_MESSAGE.set_token('ASSY_ITEM', p_common_assembly_item_name);
3888: FND_MSG_PUB.add;
3889: RAISE FND_API.g_exc_error;
3890: END IF;
3891:
4214: );
4215: l_pk_col_name_val_pairs.TRIM(1);
4216:
4217: IF (l_organization_id IS NULL) THEN
4218: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
4219: FND_MESSAGE.set_token('COL_VALUE', p_change_order.organization_code);
4220: FND_MSG_PUB.add;
4221: RAISE FND_API.g_exc_unexpected_error;
4222: END IF;
4215: l_pk_col_name_val_pairs.TRIM(1);
4216:
4217: IF (l_organization_id IS NULL) THEN
4218: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
4219: FND_MESSAGE.set_token('COL_VALUE', p_change_order.organization_code);
4220: FND_MSG_PUB.add;
4221: RAISE FND_API.g_exc_unexpected_error;
4222: END IF;
4223:
5440: l_revised_item_sequence_id := p_revised_item_sequence_id;
5441:
5442: FND_MSG_PUB.initialize();
5443: IF (l_change_id IS NULL AND l_revised_item_sequence_id IS NULL) THEN
5444: FND_MESSAGE.set_name('INV','INV_EBI_CHG_ID_REV_SEQ_NULL');
5445: FND_MSG_PUB.add;
5446: RAISE FND_API.g_exc_error;
5447: END IF;
5448:
5449: IF (l_revised_item_sequence_id IS NOT NULL AND l_change_id IS NULL) THEN
5450: OPEN c_change_id(l_revised_item_sequence_id);
5451: FETCH c_change_id INTO l_change_id;
5452: IF c_change_id%NOTFOUND THEN
5453: FND_MESSAGE.set_name('INV','INV_EBI_REV_SEQ_ID_INVALID');
5454: FND_MESSAGE.set_token('REV_SEQ_ID',l_revised_item_sequence_id);
5455: FND_MSG_PUB.add;
5456: RAISE FND_API.g_exc_error;
5457: END IF;
5450: OPEN c_change_id(l_revised_item_sequence_id);
5451: FETCH c_change_id INTO l_change_id;
5452: IF c_change_id%NOTFOUND THEN
5453: FND_MESSAGE.set_name('INV','INV_EBI_REV_SEQ_ID_INVALID');
5454: FND_MESSAGE.set_token('REV_SEQ_ID',l_revised_item_sequence_id);
5455: FND_MSG_PUB.add;
5456: RAISE FND_API.g_exc_error;
5457: END IF;
5458: CLOSE c_change_id;
5485:
5486: OPEN c_change_order_type (l_change_id);
5487: FETCH c_change_order_type INTO c_eco_header;
5488: IF c_change_order_type%NOTFOUND THEN
5489: FND_MESSAGE.set_name('INV','INV_EBI_CHG_ID_INVALID');
5490: FND_MESSAGE.set_token('CHG_ID',l_change_id);
5491: FND_MSG_PUB.add;
5492: RAISE FND_API.g_exc_error;
5493: END IF;
5486: OPEN c_change_order_type (l_change_id);
5487: FETCH c_change_order_type INTO c_eco_header;
5488: IF c_change_order_type%NOTFOUND THEN
5489: FND_MESSAGE.set_name('INV','INV_EBI_CHG_ID_INVALID');
5490: FND_MESSAGE.set_token('CHG_ID',l_change_id);
5491: FND_MSG_PUB.add;
5492: RAISE FND_API.g_exc_error;
5493: END IF;
5494: l_eco_change_order_obj := inv_ebi_change_order_obj(
6139: l_entity_count := l_entity_count +1;
6140: l_valid_eco_tbl.EXTEND();
6141: l_valid_eco_tbl(l_entity_count) := l_eco_tbl(i);
6142: ELSE
6143: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
6144: FND_MESSAGE.set_token('COL_VALUE', l_eco_tbl(i));
6145: FND_MSG_PUB.add;
6146: RAISE FND_API.G_EXC_ERROR;
6147: END IF;
6140: l_valid_eco_tbl.EXTEND();
6141: l_valid_eco_tbl(l_entity_count) := l_eco_tbl(i);
6142: ELSE
6143: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
6144: FND_MESSAGE.set_token('COL_VALUE', l_eco_tbl(i));
6145: FND_MSG_PUB.add;
6146: RAISE FND_API.G_EXC_ERROR;
6147: END IF;
6148: EXCEPTION
6173: l_entity_count := l_entity_count +1;
6174: l_valid_org_tbl.EXTEND();
6175: l_valid_org_tbl(l_entity_count) := l_org_tbl(i);
6176: ELSE
6177: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
6178: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));
6179: FND_MSG_PUB.add;
6180: RAISE FND_API.G_EXC_ERROR;
6181: END IF;
6174: l_valid_org_tbl.EXTEND();
6175: l_valid_org_tbl(l_entity_count) := l_org_tbl(i);
6176: ELSE
6177: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
6178: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));
6179: FND_MSG_PUB.add;
6180: RAISE FND_API.G_EXC_ERROR;
6181: END IF;
6182: EXCEPTION
6241: END LOOP;
6242: END IF;
6243:
6244: IF l_count = 0 THEN
6245: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');
6246: FND_MESSAGE.set_token('USER_INPUT', l_valid_eco_tbl(i));
6247: FND_MSG_PUB.add;
6248: RAISE FND_API.G_EXC_ERROR;
6249: END IF;
6242: END IF;
6243:
6244: IF l_count = 0 THEN
6245: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');
6246: FND_MESSAGE.set_token('USER_INPUT', l_valid_eco_tbl(i));
6247: FND_MSG_PUB.add;
6248: RAISE FND_API.G_EXC_ERROR;
6249: END IF;
6250: EXCEPTION