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.INV_EBI_CHANGE_ORDER_HELPER dependencies on FND_MSG_PUB

Line 86: FND_MSG_PUB.add;

82:
83: IF(l_application_id IS NULL ) THEN
84: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
85: FND_MESSAGE.set_token('COL_VALUE', 'ENG');
86: FND_MSG_PUB.add;
87: RAISE FND_API.g_exc_error;
88: END IF;
89:
90: INV_EBI_ITEM_HELPER.get_uda_attributes(

Line 117: fnd_msg_pub.count_and_get(

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

Line 225: FND_MSG_PUB.add;

221: IF(l_application_id IS NULL ) THEN
222:
223: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
224: FND_MESSAGE.set_token('COL_VALUE', 'BOM');
225: FND_MSG_PUB.add;
226: RAISE FND_API.g_exc_error;
227: END IF;
228:
229: INV_EBI_ITEM_HELPER.get_uda_attributes(

Line 265: fnd_msg_pub.count_and_get(

261: END IF;
262:
263: x_return_status := FND_API.g_ret_sts_unexp_error;
264: IF(x_msg_data IS NULL) THEN
265: fnd_msg_pub.count_and_get(
266: p_encoded => FND_API.g_false
267: ,p_count => x_msg_count
268: ,p_data => x_msg_data
269: );

Line 404: FND_MSG_PUB.add;

400:
401: IF(l_application_id IS NULL ) THEN
402: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
403: FND_MESSAGE.set_token('COL_VALUE', 'BOM');
404: FND_MSG_PUB.add;
405: RAISE FND_API.g_exc_error;
406: END IF;
407:
408: INV_EBI_ITEM_HELPER.get_uda_attributes(

Line 449: fnd_msg_pub.count_and_get(

445: END IF;
446:
447: x_return_status := FND_API.g_ret_sts_unexp_error;
448: IF(x_msg_data IS NULL) THEN
449: fnd_msg_pub.count_and_get(
450: p_encoded => FND_API.g_false
451: ,p_count => x_msg_count
452: ,p_data => x_msg_data
453: );

Line 733: fnd_msg_pub.count_and_get(

729: CLOSE c_copied_substitute_comps;
730: END IF;
731: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
732: IF(x_out.output_status.msg_data IS NULL) THEN
733: fnd_msg_pub.count_and_get(
734: p_encoded => FND_API.g_false
735: ,p_count => x_out.output_status.msg_count
736: ,p_data => x_out.output_status.msg_data
737: );

Line 992: fnd_msg_pub.count_and_get(

988: CLOSE c_copied_ref_designators;
989: END IF;
990: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
991: IF(x_out.output_status.msg_data IS NULL) THEN
992: fnd_msg_pub.count_and_get(
993: p_encoded => FND_API.g_false
994: ,p_count => x_out.output_status.msg_count
995: ,p_data => x_out.output_status.msg_data
996: );

Line 1483: fnd_msg_pub.count_and_get(

1479: CLOSE c_merged_component;
1480: END IF;
1481: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1482: IF(x_out.output_status.msg_data IS NULL) THEN
1483: fnd_msg_pub.count_and_get(
1484: p_encoded => FND_API.g_false
1485: ,p_count => x_out.output_status.msg_count
1486: ,p_data => x_out.output_status.msg_data
1487: );

Line 1855: fnd_msg_pub.count_and_get(

1851: WHEN FND_API.g_exc_unexpected_error THEN
1852: ROLLBACK TO process_replicate_bom_save_pnt;
1853: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1854: IF(x_out.output_status.msg_data IS NULL) THEN
1855: fnd_msg_pub.count_and_get(
1856: p_encoded => FND_API.g_false
1857: ,p_count => x_out.output_status.msg_count
1858: ,p_data => x_out.output_status.msg_data
1859: );

Line 1980: fnd_msg_pub.count_and_get(

1976: ROLLBACK TO inv_ebi_process_uda_save_pnt;
1977: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
1978:
1979: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
1980: fnd_msg_pub.count_and_get(
1981: p_encoded => FND_API.g_false
1982: ,p_count => x_uda_output_obj.output_status.msg_count
1983: ,p_data => x_uda_output_obj.output_status.msg_data
1984: );

Line 2137: fnd_msg_pub.count_and_get(

2133: WHEN FND_API.g_exc_unexpected_error THEN
2134: ROLLBACK TO inv_ebi_chg_order_uda_save_pnt;
2135: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2136: IF(x_out.output_status.msg_data IS NULL) THEN
2137: fnd_msg_pub.count_and_get(
2138: p_encoded => FND_API.g_false
2139: ,p_count => x_out.output_status.msg_count
2140: ,p_data => x_out.output_status.msg_data
2141: );

Line 2521: FND_MSG_PUB.initialize();

2517: WHERE organization_id = l_master_org
2518: AND concatenated_segments = p_item_name;
2519: IF (INV_EBI_ITEM_HELPER.is_new_item_request_reqd( l_item_catalog_group_id ) = FND_API.g_true) AND l_approval_status <> 'A'
2520: THEN
2521: FND_MSG_PUB.initialize();
2522: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_APROVAL_STS');
2523: FND_MESSAGE.set_token('ITEM_NUMBER',p_item_name);
2524: FND_MESSAGE.set_token('ORGANIZATION_ID',l_master_org);
2525: FND_MESSAGE.set_token('CHILD_ORGANIZATION_ID',p_organization_id);

Line 2526: FND_MSG_PUB.add;

2522: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_APROVAL_STS');
2523: FND_MESSAGE.set_token('ITEM_NUMBER',p_item_name);
2524: FND_MESSAGE.set_token('ORGANIZATION_ID',l_master_org);
2525: FND_MESSAGE.set_token('CHILD_ORGANIZATION_ID',p_organization_id);
2526: FND_MSG_PUB.add;
2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;
2529: END IF;
2530:

Line 2626: FND_MSG_PUB.add;

2622: END IF;
2623: ELSE
2624: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
2625: FND_MESSAGE.set_token('ITEM', p_item_name);
2626: FND_MSG_PUB.add;
2627: RAISE FND_API.g_exc_error;
2628: END IF;
2629: END IF;
2630: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items');

Line 2640: fnd_msg_pub.count_and_get(

2636: IF c_master_item_rev%ISOPEN THEN
2637: CLOSE c_master_item_rev;
2638: END IF;
2639: IF(x_msg_data IS NULL) THEN
2640: fnd_msg_pub.count_and_get(
2641: p_encoded => FND_API.g_false
2642: ,p_count => x_msg_count
2643: ,p_data => x_msg_data
2644: );

Line 2654: FND_MSG_PUB.count_and_get(

2650: IF c_master_item_rev%ISOPEN THEN
2651: CLOSE c_master_item_rev;
2652: END IF;
2653: IF(x_msg_data IS NULL) THEN
2654: FND_MSG_PUB.count_and_get(
2655: p_encoded => FND_API.g_false
2656: ,p_count => x_msg_count
2657: ,p_data => x_msg_data
2658: );

Line 2807: FND_MSG_PUB.add;

2803:
2804: IF (l_organization_id IS NULL) THEN
2805: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
2806: FND_MESSAGE.set_token('COL_VALUE', p_change_order.organization_code);
2807: FND_MSG_PUB.add;
2808: RAISE FND_API.g_exc_unexpected_error;
2809: END IF;
2810:
2811: -- Code to incorporate the DVM changes

Line 3363: fnd_msg_pub.count_and_get(

3359: WHEN FND_API.g_exc_unexpected_error THEN
3360: ROLLBACK TO inv_ebi_proc_eco_save_pnt;
3361: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3362: IF(x_out.output_status.msg_data IS NULL) THEN
3363: fnd_msg_pub.count_and_get(
3364: p_encoded => FND_API.g_false
3365: ,p_count => x_out.output_status.msg_count
3366: ,p_data => x_out.output_status.msg_data
3367: );

Line 3629: fnd_msg_pub.count_and_get(

3625: CLOSE c_common_sub_comps;
3626: END IF;
3627: x_return_status := FND_API.g_ret_sts_error;
3628: IF(x_msg_data IS NULL) THEN
3629: fnd_msg_pub.count_and_get(
3630: p_encoded => FND_API.g_false
3631: ,p_count => x_msg_count
3632: ,p_data => x_msg_data
3633: );

Line 3698: FND_MSG_PUB.add;

3694: );
3695: IF(l_src_bill_sequence_id IS NULL ) THEN
3696: FND_MESSAGE.set_name('INV','INV_EBI_COMMON_BILL_NOT_FOUND');
3697: FND_MESSAGE.set_token('ASSY_ITEM', p_common_assembly_item_name);
3698: FND_MSG_PUB.add;
3699: RAISE FND_API.g_exc_error;
3700: END IF;
3701:
3702: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(

Line 3730: fnd_msg_pub.count_and_get(

3726: WHEN FND_API.g_exc_unexpected_error THEN
3727: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3728: x_return_status := FND_API.g_ret_sts_unexp_error;
3729: IF(x_msg_data IS NULL) THEN
3730: fnd_msg_pub.count_and_get(
3731: p_encoded => FND_API.g_false
3732: ,p_count => x_msg_count
3733: ,p_data => x_msg_data
3734: );

Line 3740: FND_MSG_PUB.count_and_get(

3736: WHEN FND_API.g_exc_error THEN
3737: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3738: x_return_status := FND_API.g_ret_sts_error;
3739: IF(x_msg_data IS NULL) THEN
3740: FND_MSG_PUB.count_and_get(
3741: p_encoded => FND_API.g_false
3742: ,p_count => x_msg_count
3743: ,p_data => x_msg_data
3744: );

Line 3914: fnd_msg_pub.count_and_get(

3910: WHEN FND_API.g_exc_unexpected_error THEN
3911: ROLLBACK TO inv_ebi_common_orgs_save_pnt;
3912: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3913: IF(x_out.output_status.msg_data IS NULL) THEN
3914: fnd_msg_pub.count_and_get(
3915: p_encoded => FND_API.g_false
3916: ,p_count => x_out.output_status.msg_count
3917: ,p_data => x_out.output_status.msg_data
3918: );

Line 4084: fnd_msg_pub.count_and_get(

4080: WHEN FND_API.g_exc_unexpected_error THEN
4081: ROLLBACK TO inv_ebi_proc_bom_save_pnt;
4082: x_out.output_status.return_status := FND_API.g_ret_sts_error;
4083: IF(x_out.output_status.msg_data IS NULL) THEN
4084: fnd_msg_pub.count_and_get(
4085: p_encoded => FND_API.g_false
4086: ,p_count => x_out.output_status.msg_count
4087: ,p_data => x_out.output_status.msg_data
4088: );

Line 4498: FND_MSG_PUB.initialize();

4494: x_return_status := fnd_api.g_ret_sts_success;
4495: l_change_id := p_change_id ;
4496: l_revised_item_sequence_id := p_revised_item_sequence_id;
4497:
4498: FND_MSG_PUB.initialize();
4499: IF (l_change_id IS NULL AND l_revised_item_sequence_id IS NULL) THEN
4500: FND_MESSAGE.set_name('INV','INV_EBI_CHG_ID_REV_SEQ_NULL');
4501: FND_MSG_PUB.add;
4502: RAISE FND_API.g_exc_error;

Line 4501: FND_MSG_PUB.add;

4497:
4498: FND_MSG_PUB.initialize();
4499: IF (l_change_id IS NULL AND l_revised_item_sequence_id IS NULL) THEN
4500: FND_MESSAGE.set_name('INV','INV_EBI_CHG_ID_REV_SEQ_NULL');
4501: FND_MSG_PUB.add;
4502: RAISE FND_API.g_exc_error;
4503: END IF;
4504:
4505: IF (l_revised_item_sequence_id IS NOT NULL AND l_change_id IS NULL) THEN

Line 4511: FND_MSG_PUB.add;

4507: FETCH c_change_id INTO l_change_id;
4508: IF c_change_id%NOTFOUND THEN
4509: FND_MESSAGE.set_name('INV','INV_EBI_REV_SEQ_ID_INVALID');
4510: FND_MESSAGE.set_token('REV_SEQ_ID',l_revised_item_sequence_id);
4511: FND_MSG_PUB.add;
4512: RAISE FND_API.g_exc_error;
4513: END IF;
4514: CLOSE c_change_id;
4515: END IF;

Line 4547: FND_MSG_PUB.add;

4543: FETCH c_change_order_type INTO c_eco_header;
4544: IF c_change_order_type%NOTFOUND THEN
4545: FND_MESSAGE.set_name('INV','INV_EBI_CHG_ID_INVALID');
4546: FND_MESSAGE.set_token('CHG_ID',l_change_id);
4547: FND_MSG_PUB.add;
4548: RAISE FND_API.g_exc_error;
4549: END IF;
4550: l_eco_change_order_obj := inv_ebi_change_order_obj(
4551: c_eco_header.change_notice

Line 5055: FND_MSG_PUB.count_and_get(

5051: EXCEPTION
5052: WHEN FND_API.g_exc_error THEN
5053: x_return_status := FND_API.g_ret_sts_error;
5054: IF(x_msg_data IS NULL) THEN
5055: FND_MSG_PUB.count_and_get(
5056: p_encoded => FND_API.g_false
5057: ,p_count => x_msg_count
5058: ,p_data => x_msg_data
5059: );

Line 5173: FND_MSG_PUB.initialize();

5169: l_valid_eco_tbl := FND_TABLE_OF_VARCHAR2_255();
5170: l_entity_count :=0;
5171: FOR i in l_eco_tbl.FIRST..l_eco_tbl.LAST LOOP
5172: BEGIN
5173: FND_MSG_PUB.initialize();
5174: SELECT COUNT(1) into l_entity_exist
5175: FROM eng_engineering_changes
5176: WHERE change_notice = l_eco_tbl(i);
5177: IF l_entity_exist>0 THEN

Line 5184: FND_MSG_PUB.add;

5180: l_valid_eco_tbl(l_entity_count) := l_eco_tbl(i);
5181: ELSE
5182: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
5183: FND_MESSAGE.set_token('COL_VALUE', l_eco_tbl(i));
5184: FND_MSG_PUB.add;
5185: RAISE FND_API.G_EXC_ERROR;
5186: END IF;
5187: EXCEPTION
5188: WHEN FND_API.G_EXC_ERROR THEN

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

5186: END IF;
5187: EXCEPTION
5188: WHEN FND_API.G_EXC_ERROR THEN
5189: x_return_status := FND_API.g_ret_sts_error;
5190: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
5191: ,p_count => x_msg_count
5192: ,p_data => l_msg_data
5193: );
5194: x_msg_data := x_msg_data || l_msg_data ||' , ' ;

Line 5207: FND_MSG_PUB.initialize();

5203: l_valid_org_tbl := FND_TABLE_OF_VARCHAR2_255();
5204: l_entity_count :=0;
5205: FOR i in l_org_tbl.FIRST..l_org_tbl.LAST LOOP
5206: BEGIN
5207: FND_MSG_PUB.initialize();
5208: SELECT COUNT(1) into l_entity_exist
5209: FROM mtl_parameters
5210: WHERE organization_code = l_org_tbl(i);
5211: IF l_entity_exist>0 THEN

Line 5218: FND_MSG_PUB.add;

5214: l_valid_org_tbl(l_entity_count) := l_org_tbl(i);
5215: ELSE
5216: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
5217: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));
5218: FND_MSG_PUB.add;
5219: RAISE FND_API.G_EXC_ERROR;
5220: END IF;
5221: EXCEPTION
5222: WHEN FND_API.G_EXC_ERROR THEN

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

5220: END IF;
5221: EXCEPTION
5222: WHEN FND_API.G_EXC_ERROR THEN
5223: x_return_status := FND_API.g_ret_sts_error;
5224: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
5225: ,p_count => x_msg_count
5226: ,p_data => l_msg_data
5227: );
5228: x_msg_data := x_msg_data || l_msg_data ||' , ' ;

Line 5239: FND_MSG_PUB.initialize();

5235:
5236: IF l_valid_eco_tbl IS NOT NULL AND l_valid_eco_tbl.COUNT > 0 THEN
5237: FOR i in l_valid_eco_tbl.FIRST..l_valid_eco_tbl.LAST LOOP
5238: BEGIN
5239: FND_MSG_PUB.initialize();
5240: l_count :=0;
5241: IF l_valid_org_tbl IS NOT NULL AND l_valid_org_tbl.COUNT > 0 THEN
5242: FOR j in l_valid_org_tbl.FIRST..l_valid_org_tbl.LAST LOOP
5243: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

Line 5286: FND_MSG_PUB.add;

5282:
5283: IF l_count = 0 THEN
5284: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');
5285: FND_MESSAGE.set_token('USER_INPUT', l_valid_eco_tbl(i));
5286: FND_MSG_PUB.add;
5287: RAISE FND_API.G_EXC_ERROR;
5288: END IF;
5289: EXCEPTION
5290: WHEN FND_API.G_EXC_ERROR THEN

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

5288: END IF;
5289: EXCEPTION
5290: WHEN FND_API.G_EXC_ERROR THEN
5291: x_return_status := FND_API.g_ret_sts_error;
5292: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
5293: ,p_count => x_msg_count
5294: ,p_data => l_msg_data
5295: );
5296: x_msg_data := x_msg_data || l_msg_data ;

Line 5367: FND_MSG_PUB.initialize();

5363: FROM THE (SELECT CAST( l_eco_output_tbl as inv_ebi_change_id_obj_tbl)
5364: FROM dual ) c ) geco;
5365: l_ind_val NUMBER :=1;
5366: BEGIN
5367: FND_MSG_PUB.initialize();
5368: x_return_status := FND_API.G_RET_STS_SUCCESS;
5369:
5370: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5371: l_eco_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Change Order Name');