DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on FND_MESSAGE

Line 84: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');

80: p_application_short_name => 'ENG'
81: );
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;

Line 85: FND_MESSAGE.set_token('COL_VALUE', 'ENG');

81: );
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:

Line 223: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');

219: p_application_short_name => 'BOM'
220: );
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;

Line 224: FND_MESSAGE.set_token('COL_VALUE', 'BOM');

220: );
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:

Line 402: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');

398: p_application_short_name => 'BOM'
399: );
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;

Line 403: FND_MESSAGE.set_token('COL_VALUE', 'BOM');

399: );
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:

Line 2522: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_APROVAL_STS');

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

Line 2523: FND_MESSAGE.set_token('ITEM_NUMBER',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);
2526: FND_MSG_PUB.add;
2527: RAISE FND_API.g_exc_unexpected_error;

Line 2524: FND_MESSAGE.set_token('ORGANIZATION_ID',l_master_org);

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);
2526: FND_MSG_PUB.add;
2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;

Line 2525: FND_MESSAGE.set_token('CHILD_ORGANIZATION_ID',p_organization_id);

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);
2526: FND_MSG_PUB.add;
2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;
2529: END IF;

Line 2624: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');

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

Line 2625: FND_MESSAGE.set_token('ITEM', p_item_name);

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

Line 2805: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');

2801: );
2802: l_pk_col_name_val_pairs.TRIM(1);
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;

Line 2806: FND_MESSAGE.set_token('COL_VALUE', p_change_order.organization_code);

2802: l_pk_col_name_val_pairs.TRIM(1);
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:

Line 3696: FND_MESSAGE.set_name('INV','INV_EBI_COMMON_BILL_NOT_FOUND');

3692: p_organization_id => l_src_organization_id,
3693: p_alternate_bom_code => p_alternate_bom_code
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;

Line 3697: FND_MESSAGE.set_token('ASSY_ITEM', p_common_assembly_item_name);

3693: p_alternate_bom_code => p_alternate_bom_code
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:

Line 4500: FND_MESSAGE.set_name('INV','INV_EBI_CHG_ID_REV_SEQ_NULL');

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

Line 4509: FND_MESSAGE.set_name('INV','INV_EBI_REV_SEQ_ID_INVALID');

4505: IF (l_revised_item_sequence_id IS NOT NULL AND l_change_id IS NULL) THEN
4506: OPEN c_change_id(l_revised_item_sequence_id);
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;

Line 4510: FND_MESSAGE.set_token('REV_SEQ_ID',l_revised_item_sequence_id);

4506: OPEN c_change_id(l_revised_item_sequence_id);
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;

Line 4545: FND_MESSAGE.set_name('INV','INV_EBI_CHG_ID_INVALID');

4541:
4542: OPEN c_change_order_type (l_change_id);
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;

Line 4546: FND_MESSAGE.set_token('CHG_ID',l_change_id);

4542: OPEN c_change_order_type (l_change_id);
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(

Line 5182: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');

5178: l_entity_count := l_entity_count +1;
5179: l_valid_eco_tbl.EXTEND();
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;

Line 5183: FND_MESSAGE.set_token('COL_VALUE', l_eco_tbl(i));

5179: l_valid_eco_tbl.EXTEND();
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

Line 5216: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');

5212: l_entity_count := l_entity_count +1;
5213: l_valid_org_tbl.EXTEND();
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;

Line 5217: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));

5213: l_valid_org_tbl.EXTEND();
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

Line 5284: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');

5280: END LOOP;
5281: END IF;
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;

Line 5285: FND_MESSAGE.set_token('USER_INPUT', l_valid_eco_tbl(i));

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