DBA Data[Home] [Help]

APPS.GR_EXPLOSIONS dependencies on FND_API

Line 234: IF FND_API.To_Boolean(p_init_msg_list) THEN

230: l_code_block := 'Initialize';
231: /*
232: ** Initialize the message list if true
233: */
234: IF FND_API.To_Boolean(p_init_msg_list) THEN
235: FND_MSG_PUB.Initialize;
236: END IF;
237: /* Check the API version passed in matches the
238: ** internal API version.

Line 240: IF NOT FND_API.Compatible_API_Call

236: END IF;
237: /* Check the API version passed in matches the
238: ** internal API version.
239: */
240: IF NOT FND_API.Compatible_API_Call
241: (l_api_version,
242: p_api_version,
243: l_api_name,
244: g_pkg_name) THEN

Line 250: x_return_status := FND_API.G_RET_STS_SUCCESS;

246: END IF;
247: /*
248: ** Set return status to successful
249: */
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251: /*
252: ** Check the item code has a value
253: */
254: IF (p_inventory_item_id IS NULL OR p_organization_id IS NULL) THEN

Line 322: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

318: GMD_API_GRP.FETCH_PARM_VALUES( p_organization_id,
319: 'FM_YIELD_TYPE',
320: l_system_uom_type,
321: l_return_status);
322: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
323: l_parameter_name := 'FM_YIELD_TYPE';
324: RAISE EX_GET_GMD_PARAM_EXCEPTION;
325: END IF;
326:

Line 359: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

355: GMD_API_GRP.FETCH_PARM_VALUES( p_organization_id,
356: 'GMD_MASS_UM_TYPE',
357: l_mass_uom_type,
358: l_return_status);
359: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: l_parameter_name := 'GMD_MASS_UM_TYPE';
361: RAISE EX_GET_GMD_PARAM_EXCEPTION;
362: END IF;
363:

Line 741: x_return_status := FND_API.G_RET_STS_ERROR;

737: END LOOP;
738: EXCEPTION
739:
740: WHEN Incompatible_API_Version_Error THEN
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_API_VERSION_ERROR');
744: FND_MESSAGE.SET_TOKEN('VERSION',
745: p_api_version,

Line 752: x_return_status := FND_API.G_RET_STS_ERROR;

748: FND_FILE.PUT(FND_FILE.LOG,'API version error');
749: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
750:
751: WHEN Item_To_Print_Error THEN
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: FND_MESSAGE.SET_NAME('GR',
754: 'GR_PRINT_ITEM_NULL');
755: X_msg_data := FND_MESSAGE.GET;
756: FND_FILE.PUT(FND_FILE.LOG,'Item code to explode is null');

Line 760: x_return_status := FND_API.G_RET_STS_ERROR;

756: FND_FILE.PUT(FND_FILE.LOG,'Item code to explode is null');
757: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
758:
759: WHEN Invalid_UOM_Error THEN
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: FND_MESSAGE.SET_NAME('GR',
762: 'GR_INVALID_UOM');
763: FND_MESSAGE.SET_TOKEN('UOM',
764: 'System UOM',

Line 771: x_return_status := FND_API.G_RET_STS_ERROR;

767: FND_FILE.PUT(FND_FILE.LOG,'Invalid system unit of measure');
768: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
769:
770: WHEN No_Effective_Formula_Error THEN
771: x_return_status := FND_API.G_RET_STS_ERROR;
772: FND_MESSAGE.SET_NAME('GR',
773: 'GR_NO_EFFECTIVE_FORMULA');
774: FND_MESSAGE.SET_TOKEN('ITEM',
775: l_item_code,

Line 782: x_return_status := FND_API.G_RET_STS_ERROR;

778: FND_FILE.PUT(FND_FILE.LOG,'No effective formula for ' || l_item_code);
779: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
780:
781: WHEN Item_Concentration_Error THEN
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: FND_MESSAGE.SET_NAME('GR',
784: 'GR_ITEM_CONCENTRATION');
785: FND_MESSAGE.SET_TOKEN('CODE',
786: l_item_code,

Line 793: x_return_status := FND_API.G_RET_STS_ERROR;

789: FND_FILE.PUT(FND_FILE.LOG,'Error finding concentration details for ' || l_item_code);
790: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
791:
792: WHEN Concentration_Delete_Error THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: FND_MESSAGE.SET_NAME('GR',
795: 'GR_UNEXPECTED_ERROR');
796: FND_MESSAGE.SET_TOKEN('TEXT',
797: l_msg_data||sqlerrm,

Line 804: x_return_status := FND_API.G_RET_STS_ERROR;

800: FND_FILE.PUT(FND_FILE.LOG,'Error clearing concentration detail tables');
801: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
802:
803: WHEN UOM_CONVERSION_ERROR THEN
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: FND_MESSAGE.SET_NAME('GMI',
806: 'IC_API_UOM_CONVERSION_ERROR');
807: FND_MESSAGE.SET_TOKEN('FROM_UOM',
808: FormulaDetailRecord.item_um,

Line 819: x_return_status := FND_API.G_RET_STS_ERROR;

815: FALSE);
816: X_msg_data := FND_MESSAGE.GET;
817: --
818: WHEN EX_GET_GMD_PARAM_EXCEPTION THEN
819: x_return_status := FND_API.G_RET_STS_ERROR;
820: fnd_message.set_name ('GMD', 'GMD_PARM_NOT_FOUND');
821: X_msg_data := FND_MESSAGE.GET;
822:
823: FND_FILE.PUT(FND_FILE.LOG,'Error finding gmd_parameter value for ' || l_parameter_name);

Line 1006: x_return_status := FND_API.G_RET_STS_ERROR;

1002: IS
1003:
1004: BEGIN
1005:
1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007: FND_MESSAGE.SET_NAME('GR',
1008: p_message_code);
1009: IF p_token_name IS NOT NULL THEN
1010: FND_MESSAGE.SET_TOKEN(p_token_name,

Line 1015: IF FND_API.To_Boolean(p_called_by_form) THEN

1011: p_token_value,
1012: FALSE);
1013: END IF;
1014:
1015: IF FND_API.To_Boolean(p_called_by_form) THEN
1016: APP_EXCEPTION.Raise_Exception;
1017: ELSE
1018: FND_MSG_PUB.Add;
1019: FND_MSG_PUB.Count_and_Get

Line 1196: IF FND_API.To_Boolean(l_key_exists) THEN

1192: p_source_item_id,
1193: 'F',
1194: l_rowid,
1195: l_key_exists);
1196: IF FND_API.To_Boolean(l_key_exists) THEN
1197: OPEN c_get_item_conc;
1198: FETCH c_get_item_conc INTO ConcRecord;
1199: CLOSE c_get_item_conc;
1200:

Line 1258: IF FND_API.To_Boolean(l_key_exists) THEN

1254: p_explosion_item_id,
1255: 'F',
1256: l_rowid,
1257: l_key_exists);
1258: IF FND_API.To_Boolean(l_key_exists) THEN
1259: OPEN c_get_item_conc_details;
1260: FETCH c_get_item_conc_details INTO ConcDetailRecord;
1261: l_item_percent := l_det_item_percent + ConcDetailRecord.work_concentration;
1262: CLOSE c_get_item_conc_details;

Line 1308: x_return_status := FND_API.G_RET_STS_ERROR;

1304: EXCEPTION
1305: WHEN Concentration_Insert_Error THEN
1306: ROLLBACK TO SAVEPOINT process_concentrations;
1307:
1308: x_return_status := FND_API.G_RET_STS_ERROR;
1309: FND_MESSAGE.SET_NAME('GR',
1310: 'GR_UNEXPECTED_ERROR');
1311: FND_MESSAGE.SET_TOKEN('TEXT',
1312: l_msg_data||sqlerrm,