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 302: FND_MSG_PUB.add;

298: l_pk_col_name_val_pairs.TRIM(1);
299: IF (x_item.main_obj_type.organization_id IS NULL) THEN
300: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
301: FND_MESSAGE.set_token('COL_VALUE', p_Item.main_obj_type.organization_code);
302: FND_MSG_PUB.add;
303: RAISE FND_API.g_exc_error;
304: END IF;
305: END IF;
306: 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 334: FND_MSG_PUB.add;

330: l_pk_col_name_val_pairs.TRIM(1);
331:
332: IF (x_item.main_obj_type.template_id IS NULL) THEN
333: FND_MESSAGE.set_name('INV','INV_TEMPLATE_ERROR');
334: FND_MSG_PUB.add;
335: RAISE FND_API.g_exc_error;
336: END IF;
337: END IF;
338: IF (p_item.org_id_obj_type IS NOT NULL AND p_item.org_id_obj_type.COUNT > 0 ) THEN

Line 353: FND_MSG_PUB.add;

349: l_pk_col_name_val_pairs.TRIM(1);
350: IF (x_item.org_id_obj_type(i).org_id IS NULL) THEN
351: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
352: FND_MESSAGE.set_token('COL_VALUE', p_item.org_id_obj_type(i).org_code);
353: FND_MSG_PUB.add;
354: RAISE FND_API.g_exc_error;
355: END IF;
356: END IF;
357: END LOOP;

Line 374: FND_MSG_PUB.add;

370: l_pk_col_name_val_pairs.TRIM(1);
371: IF (x_item.main_obj_type.item_catalog_group_id IS NULL ) THEN
372: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
373: FND_MESSAGE.set_token('COL_VALUE',p_item.main_obj_type.item_catalog_group_code);
374: FND_MSG_PUB.add;
375: RAISE FND_API.g_exc_error;
376: END IF;
377: END IF;
378: IF ( (p_item.main_obj_type.lifecycle_id IS NULL OR p_item.main_obj_type.lifecycle_id =fnd_api.g_miss_num)

Line 537: fnd_msg_pub.count_and_get(

533: EXCEPTION
534: WHEN FND_API.g_exc_error THEN
535: x_out.output_status.return_status := FND_API.g_ret_sts_error;
536: IF(x_out.output_status.msg_data IS NULL) THEN
537: fnd_msg_pub.count_and_get(
538: p_encoded => fnd_api.g_false
539: ,p_count => x_out.output_status.msg_count
540: ,p_data => x_out.output_status.msg_data
541: );

Line 685: FND_MSG_PUB.add;

681: IF(validate_uom(uom_conv_details(j).to_uom)=FND_API.G_FALSE) THEN
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_UOM');
684: FND_MESSAGE.set_token('UOM', uom_conv_details(j).to_uom);
685: FND_MSG_PUB.add;
686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;
688: IF(validate_uom(uom_conv_details(j).from_uom)=FND_API.G_FALSE) THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;

Line 692: FND_MSG_PUB.add;

688: IF(validate_uom(uom_conv_details(j).from_uom)=FND_API.G_FALSE) THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_UOM');
691: FND_MESSAGE.set_token('UOM', uom_conv_details(j).from_uom);
692: FND_MSG_PUB.add;
693: RAISE fnd_api.g_exc_unexpected_error;
694: END IF;
695: select UOM_CLASS into l_class1 from MTL_UNITS_OF_MEASURE where UOM_CODE=uom_conv_details(j).to_uom;
696: select UOM_CODE into l_baseunit1 from MTL_UNITS_OF_MEASURE where UOM_CLASS=l_class1 and BASE_UOM_FLAG='Y';

Line 767: FND_MSG_PUB.add;

763: x_return_status := FND_API.G_RET_STS_ERROR;
764: FND_MESSAGE.set_name('INV','INV_EBI_MISMATCH_CONV_RATE');
765: FND_MESSAGE.set_token('UOM1',uom_conv_details(j).from_uom);
766: FND_MESSAGE.set_token('UOM2',uom_conv_details(j).to_uom);
767: FND_MSG_PUB.add;
768: RAISE fnd_api.g_exc_unexpected_error;
769: end if;
770: else
771: inv_convert.inv_um_conversion(uom_conv_details(j).from_uom,l_baseunit2,p_item_id,l_conv_rate_from_unit1_to_bu1);

Line 784: FND_MSG_PUB.add;

780: check_conversion(l_conv_rate_from_unit1_to_bu1,uom_conv_details(j).conversion_rate,l_convrate_from_unit_to_bu,l_conv_rate_from_bu2_to_bu1,l_ret);
781: if( l_ret = 'E') THEN
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: FND_MESSAGE.set_name('INV','INV_EBI_MISMATCH_CONV_RATE');
784: FND_MSG_PUB.add;
785: RAISE fnd_api.g_exc_unexpected_error;
786: end if;
787: end if ;
788: end if;

Line 793: FND_MSG_PUB.count_and_get(

789: end loop;
790: Exception
791: WHEN fnd_api.g_exc_unexpected_error THEN
792: IF x_msg_data IS NULL THEN
793: FND_MSG_PUB.count_and_get(
794: p_encoded => FND_API.g_false
795: ,p_count => msg_count
796: ,p_data => x_msg_data
797: );

Line 1643: FND_MSG_PUB.add;

1639: );
1640: END IF;
1641: IF l_item_number IS NULL THEN
1642: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NUM_NULL');
1643: FND_MSG_PUB.add;
1644: RAISE FND_API.g_exc_error;
1645: END IF;
1646: IF p_operation = INV_EBI_ITEM_PUB.g_otype_sync THEN
1647: IF( is_item_exists (

Line 1704: FND_MSG_PUB.add;

1700: FND_MESSAGE.set_name('INV','INV_EBI_INVALD_REV_CODE');
1701: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1702: FND_MESSAGE.set_token('REVISION_CODE',l_item.main_obj_type.revision_code);
1703: FND_MESSAGE.set_token('ORG_CODE',l_item.main_obj_type.organization_code);
1704: FND_MSG_PUB.add;
1705: RAISE FND_API.g_exc_error;
1706: END IF;
1707: END IF;
1708:

Line 1765: FND_MSG_PUB.add;

1761:
1762: IF(c_item_description%NOTFOUND) THEN
1763: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
1764: FND_MESSAGE.set_token('ITEM_NUMBER', l_item_number);
1765: FND_MSG_PUB.add;
1766: RAISE FND_API.g_exc_error;
1767: END IF;
1768:
1769: l_item.main_obj_type.description := l_description;

Line 1792: FND_MSG_PUB.add;

1788:
1789: FND_MESSAGE.set_name('INV','INV_EBI_ICC_CONFG_FOR_NIR');
1790: FND_MESSAGE.set_token('ITEM',l_item.main_obj_type.item_number);
1791: FND_MESSAGE.set_token('ITEM_CATALOG', l_item.main_obj_type.item_catalog_group_code);
1792: FND_MSG_PUB.add;
1793: RAISE FND_API.g_exc_error;
1794:
1795: ELSIF(l_item.bom_obj_type.eng_item_flag = fnd_api.g_miss_char OR l_item.bom_obj_type.eng_item_flag IS NULL ) THEN
1796:

Line 2618: fnd_msg_pub.count_and_get(

2614: CLOSE c_get_item_curr_data;
2615: END IF;
2616:
2617: IF(x_out.output_status.msg_data IS NULL) THEN
2618: fnd_msg_pub.count_and_get(
2619: p_encoded => fnd_api.g_false
2620: ,p_count => x_out.output_status.msg_count
2621: ,p_data => x_out.output_status.msg_data
2622: );

Line 2632: fnd_msg_pub.count_and_get(

2628: END IF;
2629:
2630: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2631: IF(x_out.output_status.msg_data IS NULL) THEN
2632: fnd_msg_pub.count_and_get(
2633: p_encoded => fnd_api.g_false
2634: ,p_count => x_out.output_status.msg_count
2635: ,p_data => x_out.output_status.msg_data
2636: );

Line 2763: FND_MSG_PUB.add;

2759: AND organization_id = p_organization_id
2760: AND revision = p_revision_code;
2761: ELSE
2762: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_REVISION_CODE_NULL');
2763: FND_MSG_PUB.add;
2764: RAISE FND_API.g_exc_error;
2765: END IF;
2766: ELSE
2767: l_revision_id := l_attributes_row_obj.data_level_1;

Line 2838: FND_MSG_PUB.count_and_get(

2834: CLOSE c_data_level;
2835: END IF;
2836: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
2837: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
2838: FND_MSG_PUB.count_and_get(
2839: p_encoded => FND_API.g_false
2840: ,p_count => x_uda_output_obj.output_status.msg_count
2841: ,p_data => x_uda_output_obj.output_status.msg_data
2842: );

Line 2851: FND_MSG_PUB.count_and_get(

2847: CLOSE c_data_level;
2848: END IF;
2849: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2850: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
2851: FND_MSG_PUB.count_and_get(
2852: p_encoded => FND_API.g_false
2853: ,p_count => x_uda_output_obj.output_status.msg_count
2854: ,p_data => x_uda_output_obj.output_status.msg_data
2855: );

Line 2926: FND_MSG_PUB.count_and_get(

2922: WHEN FND_API.g_exc_unexpected_error THEN
2923: ROLLBACK TO inv_ebi_org_id_save_pnt;
2924: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2925: IF(x_out.output_status.msg_data IS NULL) THEN
2926: FND_MSG_PUB.count_and_get(
2927: p_encoded => FND_API.g_false
2928: ,p_count => x_out.output_status.msg_count
2929: ,p_data => x_out.output_status.msg_data
2930: );

Line 3043: FND_MSG_PUB.add;

3039: ,p_instance_pk2_value => p_organization_id
3040: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'
3041: THEN
3042: FND_MESSAGE.set_name('INV','INV_IOI_ITEM_UPDATE_PRIV');
3043: FND_MSG_PUB.add;
3044: RAISE FND_API.g_EXC_ERROR;
3045: ELSE
3046: INV_ITEM_CATEGORY_PUB.Update_Category_Assignment(
3047: p_api_version => p_api_version

Line 3070: FND_MSG_PUB.count_and_get(

3066: EXCEPTION
3067: WHEN FND_API.g_exc_error THEN
3068: x_return_status := FND_API.g_ret_sts_error;
3069: IF(x_msg_data IS NULL) THEN
3070: FND_MSG_PUB.count_and_get(
3071: p_encoded => FND_API.g_false
3072: ,p_count => x_msg_count
3073: ,p_data => x_msg_data
3074: );

Line 3079: FND_MSG_PUB.count_and_get(

3075: END IF;
3076: WHEN FND_API.g_exc_unexpected_error THEN
3077: x_return_status := FND_API.g_ret_sts_unexp_error;
3078: IF(x_msg_data IS NULL) THEN
3079: FND_MSG_PUB.count_and_get(
3080: p_encoded => FND_API.g_false
3081: ,p_count => x_msg_count
3082: ,p_data => x_msg_data
3083: );

Line 3212: FND_MSG_PUB.add;

3208: AND table_of_number_contains(l_no_multi_assign_cat_set_tbl, p_category_id_tbl(i).cat_set_id) THEN
3209: -- fail if multiple category assignments are coming in for the category set
3210: -- with multi assign disabled
3211: FND_MESSAGE.set_name('INV',' INV_ITEM_CAT_ASSIGN_NO_MULT');
3212: FND_MSG_PUB.add;
3213: RAISE FND_API.g_exc_unexpected_error;
3214: END IF;
3215: END IF;
3216: END IF;

Line 3227: FND_MSG_PUB.count_and_get(

3223: WHEN FND_API.g_exc_unexpected_error THEN
3224: ROLLBACK TO inv_ebi_cat_id_save_pnt;
3225: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3226: IF(x_out.output_status.msg_data IS NULL) THEN
3227: FND_MSG_PUB.count_and_get(
3228: p_encoded => FND_API.g_false
3229: ,p_count => x_out.output_status.msg_count
3230: ,p_data => x_out.output_status.msg_data
3231: );

Line 3545: FND_MSG_PUB.add;

3541: CLOSE c_mfg_part_num;
3542: ELSE
3543: FND_MESSAGE.set_name('INV_EBI','INV_EBI_PART_NUM_NULL');
3544: FND_MESSAGE.set_token('PART_NUM', p_mfg_part_obj.mfg_part_num);
3545: FND_MSG_PUB.add;
3546: RAISE FND_API.g_exc_error;
3547: END IF;
3548: IF FND_API.to_boolean( p_commit ) THEN
3549: COMMIT;

Line 3557: FND_MSG_PUB.count_and_get(

3553: WHEN FND_API.g_exc_error THEN
3554: ROLLBACK TO inv_ebi_part_num_save_pnt;
3555: x_out.output_status.return_status := FND_API.g_ret_sts_error;
3556: IF(x_out.output_status.msg_data IS NULL) THEN
3557: FND_MSG_PUB.count_and_get(
3558: p_encoded => FND_API.g_false
3559: ,p_count => x_out.output_status.msg_count
3560: ,p_data => x_out.output_status.msg_data
3561: );

Line 3568: FND_MSG_PUB.count_and_get(

3564: WHEN FND_API.g_exc_unexpected_error THEN
3565: ROLLBACK TO inv_ebi_part_num_save_pnt;
3566: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
3567: IF(x_out.output_status.msg_data IS NULL) THEN
3568: FND_MSG_PUB.count_and_get(
3569: p_encoded => FND_API.g_false
3570: ,p_count => x_out.output_status.msg_count
3571: ,p_data => x_out.output_status.msg_data
3572: );

Line 3949: fnd_msg_pub.count_and_get(

3945:
3946: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
3947: IF(x_out.output_status.msg_data IS NULL) THEN
3948:
3949: fnd_msg_pub.count_and_get(
3950: p_encoded => fnd_api.g_false
3951: ,p_count => x_out.output_status.msg_count
3952: ,p_data => x_out.output_status.msg_data
3953: );

Line 4120: FND_MSG_PUB.add;

4116: );
4117: l_pk_col_name_val_pairs.TRIM(1);
4118: END IF;
4119: FND_MESSAGE.set_token('MFG_NAME', l_mfg_part_num_obj.manufacturer_name);
4120: FND_MSG_PUB.add;
4121: RAISE FND_API.g_exc_error;
4122: END IF;
4123: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4124: x_out.output_status.msg_data := l_out.output_status.msg_data ;

Line 4153: FND_MSG_PUB.count_and_get(

4149: WHEN FND_API.g_exc_error THEN
4150: ROLLBACK TO inv_ebi_sync_item_save_pnt;
4151: x_out.output_status.return_status := FND_API.g_ret_sts_error;
4152: IF(x_out.output_status.msg_data IS NULL) THEN
4153: FND_MSG_PUB.count_and_get(
4154: p_encoded => FND_API.g_false
4155: ,p_count => x_out.output_status.msg_count
4156: ,p_data => x_out.output_status.msg_data
4157: );

Line 4163: FND_MSG_PUB.count_and_get(

4159: WHEN FND_API.g_exc_unexpected_error THEN
4160: ROLLBACK TO inv_ebi_sync_item_save_pnt;
4161: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
4162: IF(x_out.output_status.msg_data IS NULL) THEN
4163: FND_MSG_PUB.count_and_get(
4164: p_encoded => FND_API.g_false
4165: ,p_count => x_out.output_status.msg_count
4166: ,p_data => x_out.output_status.msg_data
4167: );

Line 4452: FND_MSG_PUB.count_and_get(

4448: EXCEPTION
4449: WHEN FND_API.g_exc_unexpected_error THEN
4450: x_return_status := FND_API.g_ret_sts_error;
4451: IF l_msg_data IS NULL THEN
4452: FND_MSG_PUB.count_and_get(
4453: p_encoded => FND_API.g_false
4454: ,p_count => l_item_balance_output_tbl(i).item_balance_output.msg_count
4455: ,p_data => l_item_balance_output_tbl(i).item_balance_output.msg_data
4456: );

Line 4504: FND_MSG_PUB.initialize();

4500: x_msg_data OUT NOCOPY VARCHAR2
4501: )
4502: IS
4503: BEGIN
4504: FND_MSG_PUB.initialize();
4505: IF((p_get_opr_attrs_rec.item_id IS NULL) AND
4506: (p_get_opr_attrs_rec.item_name IS NULL)) THEN
4507: FND_MESSAGE.set_name('INV','INV_EBI_NO_ITEM_ID_NAME');
4508: FND_MSG_PUB.add;

Line 4508: FND_MSG_PUB.add;

4504: FND_MSG_PUB.initialize();
4505: IF((p_get_opr_attrs_rec.item_id IS NULL) AND
4506: (p_get_opr_attrs_rec.item_name IS NULL)) THEN
4507: FND_MESSAGE.set_name('INV','INV_EBI_NO_ITEM_ID_NAME');
4508: FND_MSG_PUB.add;
4509: RAISE FND_API.G_EXC_ERROR;
4510: ELSIF((p_get_opr_attrs_rec.organization_id IS NULL) AND
4511: (p_get_opr_attrs_rec.organization_code IS NULL))THEN
4512: FND_MESSAGE.set_name('INV','INV_EBI_NO_ORGID_ORGCODE');

Line 4513: FND_MSG_PUB.add;

4509: RAISE FND_API.G_EXC_ERROR;
4510: ELSIF((p_get_opr_attrs_rec.organization_id IS NULL) AND
4511: (p_get_opr_attrs_rec.organization_code IS NULL))THEN
4512: FND_MESSAGE.set_name('INV','INV_EBI_NO_ORGID_ORGCODE');
4513: FND_MSG_PUB.add;
4514: RAISE FND_API.G_EXC_ERROR;
4515: ELSE
4516: x_status := FND_API.G_RET_STS_SUCCESS;
4517: END IF;

Line 4521: FND_MSG_PUB.count_and_get(

4517: END IF;
4518: EXCEPTION
4519: WHEN FND_API.G_EXC_ERROR THEN
4520: x_status := FND_API.G_RET_STS_ERROR;
4521: FND_MSG_PUB.count_and_get(
4522: p_encoded => FND_API.g_false
4523: ,p_count => x_msg_count
4524: ,p_data => x_msg_data
4525: );

Line 4770: fnd_msg_pub.count_and_get(

4766: IF(c_data_level % ISOPEN) THEN
4767: CLOSE c_data_level;
4768: END IF;
4769: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
4770: fnd_msg_pub.count_and_get(
4771: p_encoded => FND_API.g_false
4772: ,p_count => x_uda_output_obj.output_status.msg_count
4773: ,p_data => x_uda_output_obj.output_status.msg_data
4774: );

Line 4883: FND_MSG_PUB.add;

4879: IF(l_application_id IS NULL ) THEN
4880:
4881: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
4882: FND_MESSAGE.set_token('COL_VALUE', 'EGO');
4883: FND_MSG_PUB.add;
4884: RAISE FND_API.g_exc_error;
4885: END IF;
4886:
4887: get_uda_attributes(

Line 4916: fnd_msg_pub.count_and_get(

4912: END IF;
4913:
4914: x_return_status := FND_API.g_ret_sts_unexp_error;
4915: IF(x_msg_data IS NULL) THEN
4916: fnd_msg_pub.count_and_get(
4917: p_encoded => FND_API.g_false
4918: ,p_count => x_msg_count
4919: ,p_data => x_msg_data
4920: );

Line 5178: FND_MSG_PUB.add;

5174: );
5175: IF (l_org_id IS NULL) THEN
5176: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
5177: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).organization_code);
5178: FND_MSG_PUB.add;
5179: RAISE FND_API.G_EXC_ERROR;
5180: END IF;
5181: END IF;
5182: IF( l_item_id IS NULL) THEN

Line 5196: FND_MSG_PUB.add;

5192: );
5193: IF (l_item_id IS NULL ) THEN
5194: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
5195: FND_MESSAGE.set_token('COL_VALUE', p_get_item_inp_obj.p_get_opr_attrs_tbl_type(i).item_name);
5196: FND_MSG_PUB.add;
5197: RAISE FND_API.G_EXC_ERROR;
5198: END IF;
5199: END IF;
5200: SELECT inventory_item_id

Line 6063: FND_MSG_PUB.count_and_get(

6059: WHEN FND_API.G_EXC_ERROR THEN
6060: x_return_status := FND_API.G_RET_STS_ERROR;
6061: l_item_attr_tbl(i).return_status := FND_API.G_RET_STS_ERROR;
6062: IF l_item_attr_tbl(i).msg_data IS NOT NULL THEN
6063: FND_MSG_PUB.count_and_get(
6064: p_encoded => FND_API.g_false
6065: ,p_count => l_item_attr_tbl(i).msg_count
6066: ,p_data => l_item_attr_tbl(i).msg_data
6067: );

Line 6305: FND_MSG_PUB.initialize();

6301: l_valid_item_tbl := FND_TABLE_OF_VARCHAR2_255();
6302: l_entity_count :=0;
6303: FOR i in l_item_tbl.FIRST..l_item_tbl.LAST LOOP
6304: BEGIN
6305: FND_MSG_PUB.initialize();
6306: SELECT COUNT(1) into l_entity_exist
6307: FROM mtl_system_items_kfv
6308: WHERE concatenated_segments = l_item_tbl(i);
6309: IF l_entity_exist>0 THEN

Line 6316: FND_MSG_PUB.add;

6312: l_valid_item_tbl(l_entity_count) := l_item_tbl(i);
6313: ELSE
6314: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
6315: FND_MESSAGE.set_token('COL_VALUE', l_item_tbl(i));
6316: FND_MSG_PUB.add;
6317: RAISE FND_API.G_EXC_ERROR;
6318: END IF;
6319: EXCEPTION
6320: WHEN FND_API.G_EXC_ERROR THEN

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

6318: END IF;
6319: EXCEPTION
6320: WHEN FND_API.G_EXC_ERROR THEN
6321: x_return_status := FND_API.g_ret_sts_error;
6322: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6323: ,p_count => x_msg_count
6324: ,p_data => l_msg_data
6325: );
6326: x_msg_data := x_msg_data || l_msg_data ||' , ' ;

Line 6338: FND_MSG_PUB.initialize();

6334: l_valid_org_tbl := FND_TABLE_OF_VARCHAR2_255();
6335: l_entity_count :=0;
6336: FOR i in l_org_tbl.FIRST..l_org_tbl.LAST LOOP
6337: BEGIN
6338: FND_MSG_PUB.initialize();
6339: SELECT COUNT(1) into l_entity_exist
6340: FROM mtl_parameters
6341: WHERE organization_code = l_org_tbl(i);
6342: IF l_entity_exist>0 THEN

Line 6349: FND_MSG_PUB.add;

6345: l_valid_org_tbl(l_entity_count) := l_org_tbl(i);
6346: ELSE
6347: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
6348: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));
6349: FND_MSG_PUB.add;
6350: RAISE FND_API.G_EXC_ERROR;
6351: END IF;
6352: EXCEPTION
6353: WHEN FND_API.G_EXC_ERROR THEN

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

6351: END IF;
6352: EXCEPTION
6353: WHEN FND_API.G_EXC_ERROR THEN
6354: x_return_status := FND_API.g_ret_sts_error;
6355: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6356: ,p_count => x_msg_count
6357: ,p_data => l_msg_data
6358: );
6359: x_msg_data := x_msg_data || l_msg_data ||' , ' ;

Line 6369: FND_MSG_PUB.initialize();

6365: END IF;
6366: IF l_valid_item_tbl IS NOT NULL AND l_valid_item_tbl.COUNT > 0 THEN
6367: FOR i in l_valid_item_tbl.FIRST..l_valid_item_tbl.LAST LOOP
6368: BEGIN
6369: FND_MSG_PUB.initialize();
6370: l_count :=0;
6371: IF l_valid_org_tbl IS NOT NULL AND l_valid_org_tbl.COUNT > 0 THEN
6372: FOR j in l_valid_org_tbl.FIRST..l_valid_org_tbl.LAST LOOP
6373: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

Line 6413: FND_MSG_PUB.add;

6409:
6410: IF l_count = 0 THEN
6411: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');
6412: FND_MESSAGE.set_token('USER_INPUT', l_valid_item_tbl(i));
6413: FND_MSG_PUB.add;
6414: RAISE FND_API.G_EXC_ERROR;
6415: END IF;
6416: EXCEPTION
6417: WHEN FND_API.G_EXC_ERROR THEN

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

6415: END IF;
6416: EXCEPTION
6417: WHEN FND_API.G_EXC_ERROR THEN
6418: x_return_status := FND_API.g_ret_sts_error;
6419: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6420: ,p_count => x_msg_count
6421: ,p_data => l_msg_data
6422: );
6423: x_msg_data := x_msg_data || l_msg_data ;

Line 6588: FND_MSG_PUB.initialize();

6584: FROM THE (SELECT CAST( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
6585: FROM dual ) b
6586: ) item_flst;
6587: BEGIN
6588: FND_MSG_PUB.initialize();
6589: INV_EBI_UTIL.setup();
6590: INV_EBI_UTIL.debug_line('STEP 10: START CALLING INV_EBI_ITEM_HELPER.GET_ITEM_ATTRIBUTES_LIST');
6591: x_return_status := FND_API.g_ret_sts_success;
6592:

Line 6830: FND_MSG_PUB.initialize();

6826: FROM THE (SELECT cast( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
6827: FROM dual ) b ) gibf;
6828:
6829: BEGIN
6830: FND_MSG_PUB.initialize();
6831: INV_EBI_UTIL.setup();
6832: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_ITEM_HELPER.get_item_balance_list');
6833: x_return_status := FND_API.g_ret_sts_success;
6834: