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_ITEM_HELPER dependencies on FND_MSG_PUB

Line 276: FND_MSG_PUB.add;

272: l_pk_col_name_val_pairs.TRIM(1);
273: IF (x_item.main_obj_type.organization_id IS NULL) THEN
274: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
275: FND_MESSAGE.set_token('COL_VALUE', p_Item.main_obj_type.organization_code);
276: FND_MSG_PUB.add;
277: RAISE FND_API.g_exc_error;
278: END IF;
279: END IF;
280: IF ( (p_item.main_obj_type.inventory_item_id IS NULL OR p_item.main_obj_type.inventory_item_id= fnd_api.g_miss_num)

Line 318: FND_MSG_PUB.add;

314: l_pk_col_name_val_pairs.TRIM(1);
315: IF (x_item.org_id_obj_type(i).org_id IS NULL) THEN
316: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
317: FND_MESSAGE.set_token('COL_VALUE', p_item.org_id_obj_type(i).org_code);
318: FND_MSG_PUB.add;
319: RAISE FND_API.g_exc_error;
320: END IF;
321: END IF;
322: END LOOP;

Line 338: FND_MSG_PUB.add;

334: l_pk_col_name_val_pairs.TRIM(1);
335: IF (x_item.main_obj_type.item_catalog_group_id IS NULL ) THEN
336: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
337: FND_MESSAGE.set_token('COL_VALUE',p_item.main_obj_type.item_catalog_group_code);
338: FND_MSG_PUB.add;
339: RAISE FND_API.g_exc_error;
340: END IF;
341: END IF;
342: IF ( (p_item.main_obj_type.lifecycle_id IS NULL OR p_item.main_obj_type.lifecycle_id =fnd_api.g_miss_num)

Line 485: fnd_msg_pub.count_and_get(

481: EXCEPTION
482: WHEN FND_API.g_exc_error THEN
483: x_out.output_status.return_status := FND_API.g_ret_sts_error;
484: IF(x_out.output_status.msg_data IS NULL) THEN
485: fnd_msg_pub.count_and_get(
486: p_encoded => fnd_api.g_false
487: ,p_count => x_out.output_status.msg_count
488: ,p_data => x_out.output_status.msg_data
489: );

Line 1232: FND_MSG_PUB.add;

1228: );
1229: END IF;
1230: IF l_item_number IS NULL THEN
1231: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NUM_NULL');
1232: FND_MSG_PUB.add;
1233: RAISE FND_API.g_exc_error;
1234: END IF;
1235: IF p_operation = INV_EBI_ITEM_PUB.g_otype_sync THEN
1236: IF( is_item_exists (

Line 1293: FND_MSG_PUB.add;

1289: FND_MESSAGE.set_name('INV','INV_EBI_INVALD_REV_CODE');
1290: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1291: FND_MESSAGE.set_token('REVISION_CODE',l_item.main_obj_type.revision_code);
1292: FND_MESSAGE.set_token('ORG_CODE',l_item.main_obj_type.organization_code);
1293: FND_MSG_PUB.add;
1294: RAISE FND_API.g_exc_error;
1295: END IF;
1296: END IF;
1297: IF (l_item.main_obj_type.template_id IS NULL AND l_item.main_obj_type.template_name IS NULL AND

Line 1326: FND_MSG_PUB.add;

1322: FETCH c_item_description INTO l_description;
1323: IF(c_item_description%NOTFOUND) THEN
1324: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
1325: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1326: FND_MSG_PUB.add;
1327: RAISE FND_API.g_exc_error;
1328: END IF;
1329: l_item.main_obj_type.description := l_description;
1330: CLOSE c_item_description;

Line 1911: fnd_msg_pub.count_and_get(

1907: WHEN FND_API.g_exc_error THEN
1908: ROLLBACK TO inv_ebi_pvt_item_save_pnt;
1909: x_out.output_status.return_status := FND_API.g_ret_sts_error;
1910: IF(x_out.output_status.msg_data IS NULL) THEN
1911: fnd_msg_pub.count_and_get(
1912: p_encoded => fnd_api.g_false
1913: ,p_count => x_out.output_status.msg_count
1914: ,p_data => x_out.output_status.msg_data
1915: );

Line 1921: fnd_msg_pub.count_and_get(

1917: WHEN FND_API.g_exc_unexpected_error THEN
1918: ROLLBACK TO inv_ebi_pvt_item_save_pnt;
1919: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1920: IF(x_out.output_status.msg_data IS NULL) THEN
1921: fnd_msg_pub.count_and_get(
1922: p_encoded => fnd_api.g_false
1923: ,p_count => x_out.output_status.msg_count
1924: ,p_data => x_out.output_status.msg_data
1925: );

Line 1998: FND_MSG_PUB.add;

1994: AND organization_id = p_organization_id
1995: AND revision = p_revision_code;
1996: ELSE
1997: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_REVISION_CODE_NULL');
1998: FND_MSG_PUB.add;
1999: RAISE FND_API.g_exc_error;
2000: END IF;
2001: ELSE
2002: l_revision_id := l_attributes_row_obj.data_level_1;

Line 2059: FND_MSG_PUB.count_and_get(

2055: WHEN FND_API.g_exc_error THEN
2056: ROLLBACK TO inv_ebi_item_uda_save_pnt;
2057: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
2058: IF(x_uda_output_obj.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_uda_output_obj.output_status.msg_count
2062: ,p_data => x_uda_output_obj.output_status.msg_data
2063: );

Line 2069: FND_MSG_PUB.count_and_get(

2065: WHEN FND_API.g_exc_unexpected_error THEN
2066: ROLLBACK TO inv_ebi_item_uda_save_pnt;
2067: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2068: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
2069: FND_MSG_PUB.count_and_get(
2070: p_encoded => FND_API.g_false
2071: ,p_count => x_uda_output_obj.output_status.msg_count
2072: ,p_data => x_uda_output_obj.output_status.msg_data
2073: );

Line 2138: FND_MSG_PUB.count_and_get(

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

Line 2208: FND_MSG_PUB.count_and_get(

2204: WHEN FND_API.g_exc_unexpected_error THEN
2205: ROLLBACK TO inv_ebi_cat_id_save_pnt;
2206: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2207: IF(x_out.output_status.msg_data IS NULL) THEN
2208: FND_MSG_PUB.count_and_get(
2209: p_encoded => FND_API.g_false
2210: ,p_count => x_out.output_status.msg_count
2211: ,p_data => x_out.output_status.msg_data
2212: );

Line 2524: FND_MSG_PUB.add;

2520: CLOSE c_mfg_part_num;
2521: ELSE
2522: FND_MESSAGE.set_name('INV_EBI','INV_EBI_PART_NUM_NULL');
2523: FND_MESSAGE.set_token('PART_NUM', p_mfg_part_obj.mfg_part_num);
2524: FND_MSG_PUB.add;
2525: RAISE FND_API.g_exc_error;
2526: END IF;
2527: IF FND_API.to_boolean( p_commit ) THEN
2528: COMMIT;

Line 2536: FND_MSG_PUB.count_and_get(

2532: WHEN FND_API.g_exc_error THEN
2533: ROLLBACK TO inv_ebi_part_num_save_pnt;
2534: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2535: IF(x_out.output_status.msg_data IS NULL) THEN
2536: FND_MSG_PUB.count_and_get(
2537: p_encoded => FND_API.g_false
2538: ,p_count => x_out.output_status.msg_count
2539: ,p_data => x_out.output_status.msg_data
2540: );

Line 2546: FND_MSG_PUB.count_and_get(

2542: WHEN FND_API.g_exc_unexpected_error THEN
2543: ROLLBACK TO inv_ebi_part_num_save_pnt;
2544: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2545: IF(x_out.output_status.msg_data IS NULL) THEN
2546: FND_MSG_PUB.count_and_get(
2547: p_encoded => FND_API.g_false
2548: ,p_count => x_out.output_status.msg_count
2549: ,p_data => x_out.output_status.msg_data
2550: );

Line 2696: FND_MSG_PUB.add;

2692: );
2693: l_pk_col_name_val_pairs.TRIM(1);
2694: END IF;
2695: FND_MESSAGE.set_token('MFG_NAME', l_mfg_part_num_obj.manufacturer_name);
2696: FND_MSG_PUB.add;
2697: RAISE FND_API.g_exc_error;
2698: END IF;
2699: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2700: x_out.output_status.msg_data := l_out.output_status.msg_data ;

Line 2723: FND_MSG_PUB.count_and_get(

2719: WHEN FND_API.g_exc_error THEN
2720: ROLLBACK TO inv_ebi_sync_item_save_pnt;
2721: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2722: IF(x_out.output_status.msg_data IS NULL) THEN
2723: FND_MSG_PUB.count_and_get(
2724: p_encoded => FND_API.g_false
2725: ,p_count => x_out.output_status.msg_count
2726: ,p_data => x_out.output_status.msg_data
2727: );

Line 2733: FND_MSG_PUB.count_and_get(

2729: WHEN FND_API.g_exc_unexpected_error THEN
2730: ROLLBACK TO inv_ebi_sync_item_save_pnt;
2731: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2732: IF(x_out.output_status.msg_data IS NULL) THEN
2733: FND_MSG_PUB.count_and_get(
2734: p_encoded => FND_API.g_false
2735: ,p_count => x_out.output_status.msg_count
2736: ,p_data => x_out.output_status.msg_data
2737: );

Line 3012: FND_MSG_PUB.count_and_get(

3008: EXCEPTION
3009: WHEN FND_API.g_exc_unexpected_error THEN
3010: x_return_status := FND_API.g_ret_sts_error;
3011: IF l_msg_data IS NULL THEN
3012: FND_MSG_PUB.count_and_get(
3013: p_encoded => FND_API.g_false
3014: ,p_count => l_item_balance_output_tbl(i).item_balance_output.msg_count
3015: ,p_data => l_item_balance_output_tbl(i).item_balance_output.msg_data
3016: );

Line 3063: FND_MSG_PUB.initialize();

3059: x_msg_data OUT NOCOPY VARCHAR2
3060: )
3061: IS
3062: BEGIN
3063: FND_MSG_PUB.initialize();
3064: IF((p_get_opr_attrs_rec.item_id IS NULL) AND
3065: (p_get_opr_attrs_rec.item_name IS NULL)) THEN
3066: FND_MESSAGE.set_name('INV','INV_EBI_NO_ITEM_ID_NAME');
3067: FND_MSG_PUB.add;

Line 3067: FND_MSG_PUB.add;

3063: FND_MSG_PUB.initialize();
3064: IF((p_get_opr_attrs_rec.item_id IS NULL) AND
3065: (p_get_opr_attrs_rec.item_name IS NULL)) THEN
3066: FND_MESSAGE.set_name('INV','INV_EBI_NO_ITEM_ID_NAME');
3067: FND_MSG_PUB.add;
3068: RAISE FND_API.G_EXC_ERROR;
3069: ELSIF((p_get_opr_attrs_rec.organization_id IS NULL) AND
3070: (p_get_opr_attrs_rec.organization_code IS NULL))THEN
3071: FND_MESSAGE.set_name('INV','INV_EBI_NO_ORGID_ORGCODE');

Line 3072: FND_MSG_PUB.add;

3068: RAISE FND_API.G_EXC_ERROR;
3069: ELSIF((p_get_opr_attrs_rec.organization_id IS NULL) AND
3070: (p_get_opr_attrs_rec.organization_code IS NULL))THEN
3071: FND_MESSAGE.set_name('INV','INV_EBI_NO_ORGID_ORGCODE');
3072: FND_MSG_PUB.add;
3073: RAISE FND_API.G_EXC_ERROR;
3074: ELSE
3075: x_status := FND_API.G_RET_STS_SUCCESS;
3076: END IF;

Line 3080: FND_MSG_PUB.count_and_get(

3076: END IF;
3077: EXCEPTION
3078: WHEN FND_API.G_EXC_ERROR THEN
3079: x_status := FND_API.G_RET_STS_ERROR;
3080: FND_MSG_PUB.count_and_get(
3081: p_encoded => FND_API.g_false
3082: ,p_count => x_msg_count
3083: ,p_data => x_msg_data
3084: );

Line 3265: fnd_msg_pub.count_and_get(

3261:
3262: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3263:
3264: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
3265: fnd_msg_pub.count_and_get(
3266: p_encoded => FND_API.g_false
3267: ,p_count => x_uda_output_obj.output_status.msg_count
3268: ,p_data => x_uda_output_obj.output_status.msg_data
3269: );

Line 3367: FND_MSG_PUB.add;

3363: IF(l_application_id IS NULL ) THEN
3364:
3365: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
3366: FND_MESSAGE.set_token('COL_VALUE', 'EGO');
3367: FND_MSG_PUB.add;
3368: RAISE FND_API.g_exc_error;
3369: END IF;
3370:
3371: get_uda_attributes(

Line 3400: fnd_msg_pub.count_and_get(

3396: END IF;
3397:
3398: x_return_status := FND_API.g_ret_sts_unexp_error;
3399: IF(x_msg_data IS NULL) THEN
3400: fnd_msg_pub.count_and_get(
3401: p_encoded => FND_API.g_false
3402: ,p_count => x_msg_count
3403: ,p_data => x_msg_data
3404: );

Line 3656: FND_MSG_PUB.add;

3652: );
3653: IF (l_org_id IS NULL) THEN
3654: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
3655: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).organization_code);
3656: FND_MSG_PUB.add;
3657: RAISE FND_API.G_EXC_ERROR;
3658: END IF;
3659: END IF;
3660: IF( l_item_id IS NULL) THEN

Line 3674: FND_MSG_PUB.add;

3670: );
3671: IF (l_item_id IS NULL ) THEN
3672: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
3673: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).item_name);
3674: FND_MSG_PUB.add;
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677: END IF;
3678: SELECT inventory_item_id

Line 4530: FND_MSG_PUB.count_and_get(

4526: WHEN FND_API.G_EXC_ERROR THEN
4527: x_return_status := FND_API.G_RET_STS_ERROR;
4528: l_item_attr_tbl(i).return_status := FND_API.G_RET_STS_ERROR;
4529: IF l_item_attr_tbl(i).msg_data IS NOT NULL THEN
4530: FND_MSG_PUB.count_and_get(
4531: p_encoded => FND_API.g_false
4532: ,p_count => l_item_attr_tbl(i).msg_count
4533: ,p_data => l_item_attr_tbl(i).msg_data
4534: );

Line 4766: FND_MSG_PUB.initialize();

4762: l_valid_item_tbl := FND_TABLE_OF_VARCHAR2_255();
4763: l_entity_count :=0;
4764: FOR i in l_item_tbl.FIRST..l_item_tbl.LAST LOOP
4765: BEGIN
4766: FND_MSG_PUB.initialize();
4767: SELECT COUNT(1) into l_entity_exist
4768: FROM mtl_system_items_kfv
4769: WHERE concatenated_segments = l_item_tbl(i);
4770: IF l_entity_exist>0 THEN

Line 4777: FND_MSG_PUB.add;

4773: l_valid_item_tbl(l_entity_count) := l_item_tbl(i);
4774: ELSE
4775: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
4776: FND_MESSAGE.set_token('COL_VALUE', l_item_tbl(i));
4777: FND_MSG_PUB.add;
4778: RAISE FND_API.G_EXC_ERROR;
4779: END IF;
4780: EXCEPTION
4781: WHEN FND_API.G_EXC_ERROR THEN

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

4779: END IF;
4780: EXCEPTION
4781: WHEN FND_API.G_EXC_ERROR THEN
4782: x_return_status := FND_API.g_ret_sts_error;
4783: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4784: ,p_count => x_msg_count
4785: ,p_data => l_msg_data
4786: );
4787: x_msg_data := x_msg_data || l_msg_data ||' , ' ;

Line 4799: FND_MSG_PUB.initialize();

4795: l_valid_org_tbl := FND_TABLE_OF_VARCHAR2_255();
4796: l_entity_count :=0;
4797: FOR i in l_org_tbl.FIRST..l_org_tbl.LAST LOOP
4798: BEGIN
4799: FND_MSG_PUB.initialize();
4800: SELECT COUNT(1) into l_entity_exist
4801: FROM mtl_parameters
4802: WHERE organization_code = l_org_tbl(i);
4803: IF l_entity_exist>0 THEN

Line 4810: FND_MSG_PUB.add;

4806: l_valid_org_tbl(l_entity_count) := l_org_tbl(i);
4807: ELSE
4808: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
4809: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));
4810: FND_MSG_PUB.add;
4811: RAISE FND_API.G_EXC_ERROR;
4812: END IF;
4813: EXCEPTION
4814: WHEN FND_API.G_EXC_ERROR THEN

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

4812: END IF;
4813: EXCEPTION
4814: WHEN FND_API.G_EXC_ERROR THEN
4815: x_return_status := FND_API.g_ret_sts_error;
4816: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4817: ,p_count => x_msg_count
4818: ,p_data => l_msg_data
4819: );
4820: x_msg_data := x_msg_data || l_msg_data ||' , ' ;

Line 4830: FND_MSG_PUB.initialize();

4826: END IF;
4827: IF l_valid_item_tbl IS NOT NULL AND l_valid_item_tbl.COUNT > 0 THEN
4828: FOR i in l_valid_item_tbl.FIRST..l_valid_item_tbl.LAST LOOP
4829: BEGIN
4830: FND_MSG_PUB.initialize();
4831: l_count :=0;
4832: IF l_valid_org_tbl IS NOT NULL AND l_valid_org_tbl.COUNT > 0 THEN
4833: FOR j in l_valid_org_tbl.FIRST..l_valid_org_tbl.LAST LOOP
4834: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

Line 4874: FND_MSG_PUB.add;

4870:
4871: IF l_count = 0 THEN
4872: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');
4873: FND_MESSAGE.set_token('USER_INPUT', l_valid_item_tbl(i));
4874: FND_MSG_PUB.add;
4875: RAISE FND_API.G_EXC_ERROR;
4876: END IF;
4877: EXCEPTION
4878: WHEN FND_API.G_EXC_ERROR THEN

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

4876: END IF;
4877: EXCEPTION
4878: WHEN FND_API.G_EXC_ERROR THEN
4879: x_return_status := FND_API.g_ret_sts_error;
4880: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
4881: ,p_count => x_msg_count
4882: ,p_data => l_msg_data
4883: );
4884: x_msg_data := x_msg_data || l_msg_data ;

Line 5007: FND_MSG_PUB.initialize();

5003: FROM THE (SELECT CAST( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
5004: FROM dual ) b
5005: ) item_flst;
5006: BEGIN
5007: FND_MSG_PUB.initialize();
5008: x_return_status := FND_API.g_ret_sts_success;
5009:
5010: --Getting the values for the parameters passed from CP
5011: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN

Line 5191: FND_MSG_PUB.initialize();

5187: FROM THE (SELECT cast( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
5188: FROM dual ) b ) gibf;
5189:
5190: BEGIN
5191: FND_MSG_PUB.initialize();
5192: x_return_status := FND_API.g_ret_sts_success;
5193:
5194: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5195: l_item_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Item Name');