DBA Data[Home] [Help]

APPS.BOM_ALTERNATE_DESIGNATORS_PKG dependencies on FND_MESSAGE

Line 135: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALREADY_EXISTS');

131: );
132:
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN
135: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALREADY_EXISTS');
136: FND_MESSAGE.SET_TOKEN('ENTITY1', 'THIS_CAP', TRUE);
137: FND_MESSAGE.SET_TOKEN('ENTITY2', 'ALTERNATE_CAP', TRUE);
138: APP_EXCEPTION.RAISE_EXCEPTION;
139: END Check_Unique;

Line 136: FND_MESSAGE.SET_TOKEN('ENTITY1', 'THIS_CAP', TRUE);

132:
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN
135: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALREADY_EXISTS');
136: FND_MESSAGE.SET_TOKEN('ENTITY1', 'THIS_CAP', TRUE);
137: FND_MESSAGE.SET_TOKEN('ENTITY2', 'ALTERNATE_CAP', TRUE);
138: APP_EXCEPTION.RAISE_EXCEPTION;
139: END Check_Unique;
140:

Line 137: FND_MESSAGE.SET_TOKEN('ENTITY2', 'ALTERNATE_CAP', TRUE);

133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN
135: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALREADY_EXISTS');
136: FND_MESSAGE.SET_TOKEN('ENTITY1', 'THIS_CAP', TRUE);
137: FND_MESSAGE.SET_TOKEN('ENTITY2', 'ALTERNATE_CAP', TRUE);
138: APP_EXCEPTION.RAISE_EXCEPTION;
139: END Check_Unique;
140:
141:

Line 170: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALT_IN_USE');

166: );
167:
168: EXCEPTION
169: WHEN NO_DATA_FOUND THEN
170: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALT_IN_USE');
171: FND_MESSAGE.SET_TOKEN('ENTITY', X_Alternate_Designator_Code);
172: APP_EXCEPTION.RAISE_EXCEPTION;
173: END Check_References;
174:

Line 171: FND_MESSAGE.SET_TOKEN('ENTITY', X_Alternate_Designator_Code);

167:
168: EXCEPTION
169: WHEN NO_DATA_FOUND THEN
170: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALT_IN_USE');
171: FND_MESSAGE.SET_TOKEN('ENTITY', X_Alternate_Designator_Code);
172: APP_EXCEPTION.RAISE_EXCEPTION;
173: END Check_References;
174:
175: PROCEDURE Insert_Row ( --- not used, retaining for the moment

Line 413: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALT_IN_USE');

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;
416: x_msg_data := FND_MESSAGE.GET;
417: END IF;

Line 414: FND_MESSAGE.SET_TOKEN('ENTITY', p_alt_desig_code);

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;
416: x_msg_data := FND_MESSAGE.GET;
417: END IF;
418:

Line 416: x_msg_data := FND_MESSAGE.GET;

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
420: WHEN OTHERS THEN

Line 424: x_msg_data := FND_MESSAGE.GET;

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;
427:
428: ----------------------------------------------------------------------

Line 464: FND_MESSAGE.SET_NAME('BOM', 'BOM_ALT_IN_USE');

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;
467: x_msg_data := FND_MESSAGE.GET;
468: END IF;

Line 465: FND_MESSAGE.SET_TOKEN('ENTITY', p_alt_desig_code);

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;
467: x_msg_data := FND_MESSAGE.GET;
468: END IF;
469:

Line 467: x_msg_data := FND_MESSAGE.GET;

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
471: WHEN OTHERS THEN

Line 475: x_msg_data := FND_MESSAGE.GET;

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;
478:
479: PROCEDURE Create_Association(

Line 511: FND_MESSAGE.SET_NAME('BOM', 'BOM_UPDATE_FAILED');

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:
515: END Create_Association;

Line 512: x_msg_data := FND_MESSAGE.GET;

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:
515: END Create_Association;
516: -- -------------------------------

Line 863: x_msg_data := FND_MESSAGE.GET;

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:
866: procedure UPDATE_ROW ( --- Called from the form BOMFDBAD.fmb
867: P_ALTERNATE_DESIGNATOR_CODE in VARCHAR2,

Line 1095: x_msg_data := FND_MESSAGE.GET;

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;
1098:
1099: procedure DELETE_ROW ( ---- Called from form BOMFDBAD.fmb

Line 1189: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

1185: open c;
1186: fetch c into recinfo;
1187: if (c%notfound) then
1188: close c;
1189: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1190: app_exception.raise_exception;
1191: end if;
1192: close c;
1193: if ( ((recinfo.STRUCTURE_TYPE_ID = P_STRUCTURE_TYPE_ID)

Line 1234: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

1230: OR ((recinfo.REQUEST_ID is null) AND (P_REQUEST_ID is null)))
1231: ) then
1232: null;
1233: else
1234: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1235: app_exception.raise_exception;
1236: end if;
1237:
1238: for tlinfo in c1 loop

Line 1246: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

1242: OR ((tlinfo.DESCRIPTION is null) AND (P_DESCRIPTION is null)))
1243: ) then
1244: null;
1245: else
1246: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1247: app_exception.raise_exception;
1248: end if;
1249: end if;
1250: end loop;

Line 1296: fnd_message.set_name('BOM', 'BOM_NO_SOURCE_ALT_DESIG_EXISTS');

1292: OPEN c_from_structure_name_csr(p_alt_desig_code, p_from_org_id);
1293: FETCH c_from_structure_name_csr INTO l_display_name, l_description, l_disable_date, l_structure_type_id, l_is_preferred;
1294: IF (c_from_structure_name_csr%NOTFOUND) THEN
1295: CLOSE c_from_structure_name_csr;
1296: fnd_message.set_name('BOM', 'BOM_NO_SOURCE_ALT_DESIG_EXISTS');
1297: fnd_message.set_token('ALT_DESIG', p_alt_desig_code, FALSE);
1298: app_exception.raise_exception;
1299: end if;
1300: close c_from_structure_name_csr;

Line 1297: fnd_message.set_token('ALT_DESIG', p_alt_desig_code, FALSE);

1293: FETCH c_from_structure_name_csr INTO l_display_name, l_description, l_disable_date, l_structure_type_id, l_is_preferred;
1294: IF (c_from_structure_name_csr%NOTFOUND) THEN
1295: CLOSE c_from_structure_name_csr;
1296: fnd_message.set_name('BOM', 'BOM_NO_SOURCE_ALT_DESIG_EXISTS');
1297: fnd_message.set_token('ALT_DESIG', p_alt_desig_code, FALSE);
1298: app_exception.raise_exception;
1299: end if;
1300: close c_from_structure_name_csr;
1301: insert_row (