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.

[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on FND_MSG_PUB

Line 88: FND_MSG_PUB.add;

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');
92: INV_EBI_ITEM_HELPER.get_uda_attributes(

Line 120: fnd_msg_pub.count_and_get(

116: END IF;
117:
118: x_return_status := FND_API.g_ret_sts_unexp_error;
119: IF(x_msg_data IS NULL) THEN
120: fnd_msg_pub.count_and_get(
121: p_encoded => FND_API.g_false
122: ,p_count => x_msg_count
123: ,p_data => x_msg_data
124: );

Line 230: FND_MSG_PUB.add;

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');
234: INV_EBI_ITEM_HELPER.get_uda_attributes(

Line 270: fnd_msg_pub.count_and_get(

266: END IF;
267:
268: x_return_status := FND_API.g_ret_sts_unexp_error;
269: IF(x_msg_data IS NULL) THEN
270: fnd_msg_pub.count_and_get(
271: p_encoded => FND_API.g_false
272: ,p_count => x_msg_count
273: ,p_data => x_msg_data
274: );

Line 413: FND_MSG_PUB.add;

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');
417: INV_EBI_ITEM_HELPER.get_uda_attributes(

Line 459: fnd_msg_pub.count_and_get(

455: END IF;
456:
457: x_return_status := FND_API.g_ret_sts_unexp_error;
458: IF(x_msg_data IS NULL) THEN
459: fnd_msg_pub.count_and_get(
460: p_encoded => FND_API.g_false
461: ,p_count => x_msg_count
462: ,p_data => x_msg_data
463: );

Line 1035: fnd_msg_pub.count_and_get(

1031: WHEN FND_API.g_exc_unexpected_error THEN
1032: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1033:
1034: IF(x_out.output_status.msg_data IS NULL) THEN
1035: fnd_msg_pub.count_and_get(
1036: p_encoded => FND_API.g_false
1037: ,p_count => x_out.output_status.msg_count
1038: ,p_data => x_out.output_status.msg_data
1039: );

Line 1308: fnd_msg_pub.count_and_get(

1304: CLOSE c_copied_substitute_comps;
1305: END IF;
1306: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1307: IF(x_out.output_status.msg_data IS NULL) THEN
1308: fnd_msg_pub.count_and_get(
1309: p_encoded => FND_API.g_false
1310: ,p_count => x_out.output_status.msg_count
1311: ,p_data => x_out.output_status.msg_data
1312: );

Line 1567: fnd_msg_pub.count_and_get(

1563: CLOSE c_copied_ref_designators;
1564: END IF;
1565: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1566: IF(x_out.output_status.msg_data IS NULL) THEN
1567: fnd_msg_pub.count_and_get(
1568: p_encoded => FND_API.g_false
1569: ,p_count => x_out.output_status.msg_count
1570: ,p_data => x_out.output_status.msg_data
1571: );

Line 2059: fnd_msg_pub.count_and_get(

2055: CLOSE c_merged_component;
2056: END IF;
2057: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2058: IF(x_out.output_status.msg_data IS NULL) THEN
2059: fnd_msg_pub.count_and_get(
2060: p_encoded => FND_API.g_false
2061: ,p_count => x_out.output_status.msg_count
2062: ,p_data => x_out.output_status.msg_data
2063: );

Line 2495: fnd_msg_pub.count_and_get(

2491: WHEN FND_API.g_exc_unexpected_error THEN
2492: ROLLBACK TO process_replicate_bom_save_pnt;
2493: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2494: IF(x_out.output_status.msg_data IS NULL) THEN
2495: fnd_msg_pub.count_and_get(
2496: p_encoded => FND_API.g_false
2497: ,p_count => x_out.output_status.msg_count
2498: ,p_data => x_out.output_status.msg_data
2499: );

Line 2621: fnd_msg_pub.count_and_get(

2617: ROLLBACK TO inv_ebi_process_uda_save_pnt;
2618: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
2619:
2620: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
2621: fnd_msg_pub.count_and_get(
2622: p_encoded => FND_API.g_false
2623: ,p_count => x_uda_output_obj.output_status.msg_count
2624: ,p_data => x_uda_output_obj.output_status.msg_data
2625: );

Line 2781: fnd_msg_pub.count_and_get(

2777: WHEN FND_API.g_exc_unexpected_error THEN
2778: ROLLBACK TO inv_ebi_chg_order_uda_save_pnt;
2779: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2780: IF(x_out.output_status.msg_data IS NULL) THEN
2781: fnd_msg_pub.count_and_get(
2782: p_encoded => FND_API.g_false
2783: ,p_count => x_out.output_status.msg_count
2784: ,p_data => x_out.output_status.msg_data
2785: );

Line 3353: FND_MSG_PUB.initialize();

3349: WHERE organization_id = l_master_org
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);

Line 3358: FND_MSG_PUB.add;

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;
3362: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING EGO_ITEM_PUB.assign_item_to_org');

Line 3461: FND_MSG_PUB.add;

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;
3465: INV_EBI_UTIL.debug_line('STEP 80: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ');

Line 3475: fnd_msg_pub.count_and_get(

3471: IF c_master_item_rev%ISOPEN THEN
3472: CLOSE c_master_item_rev;
3473: END IF;
3474: IF(x_msg_data IS NULL) THEN
3475: fnd_msg_pub.count_and_get(
3476: p_encoded => FND_API.g_false
3477: ,p_count => x_msg_count
3478: ,p_data => x_msg_data
3479: );

Line 3489: FND_MSG_PUB.count_and_get(

3485: IF c_master_item_rev%ISOPEN THEN
3486: CLOSE c_master_item_rev;
3487: END IF;
3488: IF(x_msg_data IS NULL) THEN
3489: FND_MSG_PUB.count_and_get(
3490: p_encoded => FND_API.g_false
3491: ,p_count => x_msg_count
3492: ,p_data => x_msg_data
3493: );

Line 3815: fnd_msg_pub.count_and_get(

3811: CLOSE c_common_sub_comps;
3812: END IF;
3813: x_return_status := FND_API.g_ret_sts_error;
3814: IF(x_msg_data IS NULL) THEN
3815: fnd_msg_pub.count_and_get(
3816: p_encoded => FND_API.g_false
3817: ,p_count => x_msg_count
3818: ,p_data => x_msg_data
3819: );

Line 3888: FND_MSG_PUB.add;

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:
3892: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(

Line 3921: fnd_msg_pub.count_and_get(

3917: WHEN FND_API.g_exc_unexpected_error THEN
3918: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3919: x_return_status := FND_API.g_ret_sts_unexp_error;
3920: IF(x_msg_data IS NULL) THEN
3921: fnd_msg_pub.count_and_get(
3922: p_encoded => FND_API.g_false
3923: ,p_count => x_msg_count
3924: ,p_data => x_msg_data
3925: );

Line 3931: FND_MSG_PUB.count_and_get(

3927: WHEN FND_API.g_exc_error THEN
3928: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3929: x_return_status := FND_API.g_ret_sts_error;
3930: IF(x_msg_data IS NULL) THEN
3931: FND_MSG_PUB.count_and_get(
3932: p_encoded => FND_API.g_false
3933: ,p_count => x_msg_count
3934: ,p_data => x_msg_data
3935: );

Line 4119: fnd_msg_pub.count_and_get(

4115: WHEN FND_API.g_exc_unexpected_error THEN
4116: ROLLBACK TO inv_ebi_common_orgs_save_pnt;
4117: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
4118: IF(x_out.output_status.msg_data IS NULL) THEN
4119: fnd_msg_pub.count_and_get(
4120: p_encoded => FND_API.g_false
4121: ,p_count => x_out.output_status.msg_count
4122: ,p_data => x_out.output_status.msg_data
4123: );

Line 4220: FND_MSG_PUB.add;

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:
4224: -- Code to incorporate the DVM changes

Line 4840: fnd_msg_pub.count_and_get(

4836: WHEN FND_API.g_exc_unexpected_error THEN
4837: ROLLBACK TO inv_ebi_proc_eco_save_pnt;
4838: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
4839: IF(x_out.output_status.msg_data IS NULL) THEN
4840: fnd_msg_pub.count_and_get(
4841: p_encoded => FND_API.g_false
4842: ,p_count => x_out.output_status.msg_count
4843: ,p_data => x_out.output_status.msg_data
4844: );

Line 5027: fnd_msg_pub.count_and_get(

5023: WHEN FND_API.g_exc_unexpected_error THEN
5024: ROLLBACK TO inv_ebi_proc_bom_save_pnt;
5025: x_out.output_status.return_status := FND_API.g_ret_sts_error;
5026: IF(x_out.output_status.msg_data IS NULL) THEN
5027: fnd_msg_pub.count_and_get(
5028: p_encoded => FND_API.g_false
5029: ,p_count => x_out.output_status.msg_count
5030: ,p_data => x_out.output_status.msg_data
5031: );

Line 5442: FND_MSG_PUB.initialize();

5438: x_return_status := fnd_api.g_ret_sts_success;
5439: l_change_id := p_change_id ;
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;

Line 5445: FND_MSG_PUB.add;

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

Line 5455: FND_MSG_PUB.add;

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;
5459: END IF;

Line 5491: FND_MSG_PUB.add;

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(
5495: c_eco_header.change_notice

Line 6004: FND_MSG_PUB.count_and_get(

6000: EXCEPTION
6001: WHEN FND_API.g_exc_error THEN
6002: x_return_status := FND_API.g_ret_sts_error;
6003: IF(x_msg_data IS NULL) THEN
6004: FND_MSG_PUB.count_and_get(
6005: p_encoded => FND_API.g_false
6006: ,p_count => x_msg_count
6007: ,p_data => x_msg_data
6008: );

Line 6134: FND_MSG_PUB.initialize();

6130: l_valid_eco_tbl := FND_TABLE_OF_VARCHAR2_255();
6131: l_entity_count :=0;
6132: FOR i in l_eco_tbl.FIRST..l_eco_tbl.LAST LOOP
6133: BEGIN
6134: FND_MSG_PUB.initialize();
6135: SELECT COUNT(1) into l_entity_exist
6136: FROM eng_engineering_changes
6137: WHERE change_notice = l_eco_tbl(i);
6138: IF l_entity_exist>0 THEN

Line 6145: FND_MSG_PUB.add;

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
6149: WHEN FND_API.G_EXC_ERROR THEN

Line 6151: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

6147: END IF;
6148: EXCEPTION
6149: WHEN FND_API.G_EXC_ERROR THEN
6150: x_return_status := FND_API.g_ret_sts_error;
6151: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6152: ,p_count => x_msg_count
6153: ,p_data => l_msg_data
6154: );
6155: x_msg_data := x_msg_data || l_msg_data ||' , ' ;

Line 6168: FND_MSG_PUB.initialize();

6164: l_valid_org_tbl := FND_TABLE_OF_VARCHAR2_255();
6165: l_entity_count :=0;
6166: FOR i in l_org_tbl.FIRST..l_org_tbl.LAST LOOP
6167: BEGIN
6168: FND_MSG_PUB.initialize();
6169: SELECT COUNT(1) into l_entity_exist
6170: FROM mtl_parameters
6171: WHERE organization_code = l_org_tbl(i);
6172: IF l_entity_exist>0 THEN

Line 6179: FND_MSG_PUB.add;

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
6183: WHEN FND_API.G_EXC_ERROR THEN

Line 6185: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

6181: END IF;
6182: EXCEPTION
6183: WHEN FND_API.G_EXC_ERROR THEN
6184: x_return_status := FND_API.g_ret_sts_error;
6185: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6186: ,p_count => x_msg_count
6187: ,p_data => l_msg_data
6188: );
6189: x_msg_data := x_msg_data || l_msg_data ||' , ' ;

Line 6200: FND_MSG_PUB.initialize();

6196:
6197: IF l_valid_eco_tbl IS NOT NULL AND l_valid_eco_tbl.COUNT > 0 THEN
6198: FOR i in l_valid_eco_tbl.FIRST..l_valid_eco_tbl.LAST LOOP
6199: BEGIN
6200: FND_MSG_PUB.initialize();
6201: l_count :=0;
6202: IF l_valid_org_tbl IS NOT NULL AND l_valid_org_tbl.COUNT > 0 THEN
6203: FOR j in l_valid_org_tbl.FIRST..l_valid_org_tbl.LAST LOOP
6204: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

Line 6247: FND_MSG_PUB.add;

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
6251: WHEN FND_API.G_EXC_ERROR THEN

Line 6253: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

6249: END IF;
6250: EXCEPTION
6251: WHEN FND_API.G_EXC_ERROR THEN
6252: x_return_status := FND_API.g_ret_sts_error;
6253: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6254: ,p_count => x_msg_count
6255: ,p_data => l_msg_data
6256: );
6257: x_msg_data := x_msg_data || l_msg_data ;

Line 6336: FND_MSG_PUB.initialize();

6332: FROM THE (SELECT CAST( l_eco_output_tbl as inv_ebi_change_id_obj_tbl)
6333: FROM dual ) c ) geco;
6334: l_ind_val NUMBER :=1;
6335: BEGIN
6336: FND_MSG_PUB.initialize();
6337: INV_EBI_UTIL.setup();
6338: INV_EBI_UTIL.debug_line('Step 10: START CALLING INV_EBI_CHANGE_ORDER_HELPER.GET_ECO_LIST');
6339: x_return_status := FND_API.G_RET_STS_SUCCESS;
6340: