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.BOM_ALTERNATE_DESIGNATORS_PKG dependencies on FND_API

Line 386: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

382: -- Standard start of API savepoint
383: SAVEPOINT Delete_Alternate_PUB;
384:
385: -- Check for call compatibility
386: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
387: l_api_name, G_PKG_NAME)
388: THEN
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;

Line 389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

385: -- Check for call compatibility
386: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
387: l_api_name, G_PKG_NAME)
388: THEN
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391:
392: IF NOT Check_References(NULL, p_alt_desig_code) THEN
393: -- Added for Bug Fix : 3045566

Line 411: x_return_status := FND_API.G_RET_STS_SUCCESS;

407: END IF;
408:
409: -- End of bug fix
410:
411: x_return_status := FND_API.G_RET_STS_SUCCESS;
412: ELSE
413: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALT_IN_USE');
414: FND_MESSAGE.SET_TOKEN('ENTITY', p_alt_desig_code);
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

411: x_return_status := FND_API.G_RET_STS_SUCCESS;
412: ELSE
413: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALT_IN_USE');
414: FND_MESSAGE.SET_TOKEN('ENTITY', p_alt_desig_code);
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: x_msg_data := FND_MESSAGE.GET;
417: END IF;
418:
419: EXCEPTION

Line 422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

418:
419: EXCEPTION
420: WHEN OTHERS THEN
421: ROLLBACK TO Delete_Alternate_PUB;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: -- x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
424: x_msg_data := FND_MESSAGE.GET;
425:
426: END Delete_Row;

Line 447: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

443: -- Standard start of API savepoint
444: SAVEPOINT Delete_Alternate_PUB;
445:
446: -- Check for call compatibility
447: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
448: l_api_name, G_PKG_NAME) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445:
446: -- Check for call compatibility
447: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
448: l_api_name, G_PKG_NAME) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452: IF NOT Check_References(p_organization_id, p_alt_desig_code) THEN
453: DELETE FROM BOM_ALTERNATE_DESIGNATORS

Line 462: x_return_status := FND_API.G_RET_STS_SUCCESS;

458: WHERE ALTERNATE_DESIGNATOR_CODE = p_alt_desig_code
459: and ORGANIZATION_ID = p_organization_id;
460:
461: commit;
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463: ELSE
464: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALT_IN_USE');
465: FND_MESSAGE.SET_TOKEN('ENTITY', p_alt_desig_code);
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463: ELSE
464: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALT_IN_USE');
465: FND_MESSAGE.SET_TOKEN('ENTITY', p_alt_desig_code);
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: x_msg_data := FND_MESSAGE.GET;
468: END IF;
469:
470: EXCEPTION

Line 473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

469:
470: EXCEPTION
471: WHEN OTHERS THEN
472: ROLLBACK TO Delete_Alternate_PUB;
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474: -- x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
475: x_msg_data := FND_MESSAGE.GET;
476:
477: END Delete_Row;

Line 495: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

491: BEGIN
492: -- Standard start of API Savepoint
493: SAVEPOINT Create_Association;
494:
495: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
496: l_api_name, G_PKG_NAME) THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:

Line 497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

493: SAVEPOINT Create_Association;
494:
495: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
496: l_api_name, G_PKG_NAME) THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:
500: UPDATE BOM_ALTERNATE_DESIGNATORS
501: SET structure_type_id = p_structure_type_id

Line 504: x_return_status := FND_API.G_RET_STS_SUCCESS;

500: UPDATE BOM_ALTERNATE_DESIGNATORS
501: SET structure_type_id = p_structure_type_id
502: WHERE alternate_designator_code = p_alternate_designator_code;
503: -- AND organization_id = p_organization_id;
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:
506: EXCEPTION
507: WHEN OTHERS
508: THEN

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

506: EXCEPTION
507: WHEN OTHERS
508: THEN
509: ROLLBACK TO Create_Association;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: FND_MESSAGE.SET_NAME('BOM', 'BOM_UPDATE_FAILED');
512: x_msg_data := FND_MESSAGE.GET;
513: -- x_msg_data := 'Executing - '||G_PKG_NAME ||'.'||l_api_name||' '||SQLERRM;
514:

Line 695: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

691: x_errorcode => x_errorcode,
692: x_msg_count => x_msg_count,
693: x_msg_data => x_msg_data);
694:
695: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
696: -- Write exception handling specific to forms using the returned error messages
697: NULL;
698: END IF;
699: END Insert_Row;

Line 721: IF NOT FND_API.Compatible_API_Call (l_api_version, p_alt_desig_rec.api_version,

717:
718: -- Standard start of API savepoint
719: SAVEPOINT Create_Alternate_PUB;
720:
721: IF NOT FND_API.Compatible_API_Call (l_api_version, p_alt_desig_rec.api_version,
722: l_api_name, G_PKG_NAME)
723: THEN
724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
725: END IF;

Line 724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

720:
721: IF NOT FND_API.Compatible_API_Call (l_api_version, p_alt_desig_rec.api_version,
722: l_api_name, G_PKG_NAME)
723: THEN
724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
725: END IF;
726: IF p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE IS NULL THEN
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: END IF;

Line 727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

723: THEN
724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
725: END IF;
726: IF p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE IS NULL THEN
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: END IF;
729: IF p_alt_desig_rec.ORGANIZATION_ID IS NULL THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;

Line 730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

726: IF p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE IS NULL THEN
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: END IF;
729: IF p_alt_desig_rec.ORGANIZATION_ID IS NULL THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732: IF p_alt_desig_rec.STRUCTURE_TYPE_ID = -1 THEN
733: l_structure_type_id := NULL;
734: ELSE

Line 855: x_return_status := FND_API.G_RET_STS_SUCCESS;

851: from BOM_ALTERNATE_DESIGNATORS_TL T
852: where T.ALTERNATE_DESIGNATOR_CODE = p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE
853: and T.ORGANIZATION_ID = p_alt_desig_rec.ORGANIZATION_ID
854: and T.LANGUAGE = L.LANGUAGE_CODE);
855: x_return_status := FND_API.G_RET_STS_SUCCESS;
856: END IF;
857:
858: EXCEPTION
859: WHEN OTHERS THEN

Line 861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

857:
858: EXCEPTION
859: WHEN OTHERS THEN
860: ROLLBACK TO Create_Alternate_PUB;
861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
862: -- x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
863: x_msg_data := FND_MESSAGE.GET;
864: END Insert_row;
865:

Line 942: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

938: ,x_errorcode => x_errorcode
939: ,x_msg_count => x_msg_count
940: ,x_msg_data => x_msg_data);
941:
942: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
943: /* Write exception handling specific to forms using the returned error messages */
944: NULL;
945: END IF;
946: END;

Line 967: IF NOT FND_API.Compatible_API_Call (l_api_version, p_alt_desig_rec.api_version,

963: -- Standard start of API savepoint
964: SAVEPOINT Update_Alternate_PUB;
965:
966:
967: IF NOT FND_API.Compatible_API_Call (l_api_version, p_alt_desig_rec.api_version,
968: l_api_name, G_PKG_NAME)
969: THEN
970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
971: END IF;

Line 970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

966:
967: IF NOT FND_API.Compatible_API_Call (l_api_version, p_alt_desig_rec.api_version,
968: l_api_name, G_PKG_NAME)
969: THEN
970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
971: END IF;
972: IF p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE IS NULL THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;

Line 973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

969: THEN
970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
971: END IF;
972: IF p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE IS NULL THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975: IF p_alt_desig_rec.ORGANIZATION_ID IS NULL THEN
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
977: END IF;

Line 976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

972: IF p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE IS NULL THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975: IF p_alt_desig_rec.ORGANIZATION_ID IS NULL THEN
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
977: END IF;
978:
979: -- If the current structure is set as preferred structure name
980: -- and there exists another preferred structure name for this structure type then

Line 1039: x_return_status := FND_API.G_RET_STS_SUCCESS;

1035: ALTERNATE_DESIGNATOR_CODE = p_alt_desig_rec.alt_desig_code_old
1036: and ORGANIZATION_ID = p_alt_desig_rec.ORGANIZATION_ID
1037: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1038:
1039: x_return_status := FND_API.G_RET_STS_SUCCESS;
1040: ELSIF( p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE <> p_alt_desig_rec.alt_desig_code_old ) THEN
1041: IF NOT Check_Unique(p_alt_desig_rec.ORGANIZATION_ID, p_alt_desig_rec.ALTERNATE_DESIGNATOR_CODE) THEN
1042: UPDATE BOM_ALTERNATE_DESIGNATORS
1043: SET

Line 1086: x_return_status := FND_API.G_RET_STS_SUCCESS;

1082: ALTERNATE_DESIGNATOR_CODE = p_alt_desig_rec.alt_desig_code_old
1083: and ORGANIZATION_ID = p_alt_desig_rec.organization_id
1084: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1085:
1086: x_return_status := FND_API.G_RET_STS_SUCCESS;
1087: END IF;
1088: END IF;
1089:
1090: EXCEPTION

Line 1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1089:
1090: EXCEPTION
1091: WHEN OTHERS THEN
1092: ROLLBACK TO Update_Alternate_PUB;
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: -- x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
1095: x_msg_data := FND_MESSAGE.GET;
1096:
1097: END Update_Row;

Line 1118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1114: ,x_errorcode => x_errorcode
1115: ,x_msg_count => x_msg_count
1116: ,x_msg_data => x_msg_data);
1117:
1118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1119: /* Write exception handling specific to forms using the returned error messages */
1120: NULL;
1121: END IF;
1122: END DELETE_ROW;

Line 1315: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1311: ,x_errorcode => x_errorcode
1312: ,x_msg_count => x_msg_count
1313: ,x_msg_data => x_msg_data
1314: );
1315: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1316: app_exception.raise_exception;
1317: END IF;
1318: END copy_to_org;
1319: