1016:
1017: EXCEPTION
1018: WHEN STEP_QTY_ERROR THEN
1019: x_return_code := 'F';
1020: FND_MSG_PUB.GET(p_msg_index => 1,
1021: p_data => l_message,
1022: p_encoded => 'F',
1023: p_msg_index_out => l_temp);
1024: x_error_msg := l_message;
1429:
1430:
1431: WHEN STEP_QTY_ERROR THEN
1432: x_return_code := 'F';
1433: FND_MSG_PUB.GET(p_msg_index => 1,
1434: p_data => l_message,
1435: p_encoded => 'F',
1436: p_msg_index_out => l_temp);
1437: FND_MESSAGE.SET_NAME('GMD', l_message);
1973: END IF;
1974:
1975: EXCEPTION
1976: WHEN UPDATE_RECIPE_EXCEPTION THEN
1977: FND_MSG_PUB.GET( p_msg_index => 1,
1978: p_data => l_message,
1979: p_encoded => 'F',
1980: p_msg_index_out => l_dummy);
1981:
2190: X_FIXED_PROCESS_LOSS_UOM => NULL);
2191:
2192: EXCEPTION
2193: WHEN INSERT_RECIPE_EXCEPTION THEN
2194: FND_MSG_PUB.GET( p_msg_index => 1,
2195: p_data => l_message,
2196: p_encoded => 'F',
2197: p_msg_index_out => l_dummy);
2198:
2289: END IF;
2290:
2291: EXCEPTION
2292: WHEN CREATE_CUST_EXCEPTION THEN
2293: FND_MSG_PUB.GET( p_msg_index => 1,
2294: p_data => l_message,
2295: p_encoded => 'F',
2296: p_msg_index_out => l_dummy);
2297: x_return_code := 'F';
2463: END IF;
2464:
2465: EXCEPTION
2466: WHEN CREATE_LOSS_EXCEPTION THEN
2467: FND_MSG_PUB.GET( p_msg_index => 1,
2468: p_data => l_message,
2469: p_encoded => 'F',
2470: p_msg_index_out => l_dummy);
2471: x_return_code := 'F';
2690: END IF;
2691:
2692: EXCEPTION
2693: WHEN UPDATE_LOSS_EXCEPTION THEN
2694: FND_MSG_PUB.GET( p_msg_index => 1,
2695: p_data => l_message,
2696: p_encoded => 'F',
2697: p_msg_index_out => l_dummy);
2698: x_return_code := 'F';
2839: COMMIT;
2840:
2841: EXCEPTION
2842: WHEN DELETE_RECIPE_EXCEPTION THEN
2843: FND_MSG_PUB.GET( p_msg_index => 1,
2844: p_data => l_message,
2845: p_encoded => 'F',
2846: p_msg_index_out => l_dummy);
2847: x_return_code := 'F';
2987: COMMIT;
2988:
2989: EXCEPTION
2990: WHEN DELETE_RECIPE_EXCEPTION THEN
2991: FND_MSG_PUB.GET( p_msg_index => 1,
2992: p_data => l_message,
2993: p_encoded => 'F',
2994: p_msg_index_out => l_dummy);
2995: x_return_code := 'F';
3069: END IF;
3070:
3071: EXCEPTION
3072: WHEN PR_LOSS_EXCEPTION THEN
3073: FND_MSG_PUB.GET( p_msg_index => 1,
3074: p_data => l_message,
3075: p_encoded => 'F',
3076: p_msg_index_out => l_dummy);
3077: x_return_code := 'F';
3141: END IF;
3142:
3143: EXCEPTION
3144: WHEN CAL_QTY_EXCEPTION THEN
3145: FND_MSG_PUB.GET( p_msg_index => 1,
3146: p_data => x_error_msg,
3147: p_encoded => 'F',
3148: p_msg_index_out => l_dummy);
3149: x_return_code := 'F';
5355: x_return_code := 'F';
5356:
5357: WHEN COPY_RECIPE_EXCEPTION THEN
5358: ROLLBACK TO Copy_Recipe;
5359: FND_MSG_PUB.GET( p_msg_index => 1,
5360: p_data => x_error_msg,
5361: p_encoded => 'F',
5362: p_msg_index_out => l_dummy);
5363: x_return_code := 'F';
5363: x_return_code := 'F';
5364:
5365: WHEN COPY_ROUTING_EXCEPTION THEN
5366: ROLLBACK TO Copy_Recipe;
5367: FND_MSG_PUB.GET( p_msg_index => 1,
5368: p_data => x_error_msg,
5369: p_encoded => 'F',
5370: p_msg_index_out => l_dummy);
5371: x_return_code := 'F';
5371: x_return_code := 'F';
5372:
5373: WHEN COPY_FORMULA_EXCEPTION THEN
5374: ROLLBACK TO Copy_Recipe;
5375: FND_MSG_PUB.GET( p_msg_index => 1,
5376: p_data => x_error_msg,
5377: p_encoded => 'F',
5378: p_msg_index_out => l_dummy);
5379: x_return_code := 'F';
5379: x_return_code := 'F';
5380:
5381: WHEN COPY_FORM_DTL_EXCEPTION THEN
5382: ROLLBACK TO Copy_Recipe;
5383: FND_MSG_PUB.GET( p_msg_index => 1,
5384: p_data => x_error_msg,
5385: p_encoded => 'F',
5386: p_msg_index_out => l_dummy);
5387: x_return_code := 'F';
5580: IF (pEntity_name = 'FORMULA') THEN
5581: IF (l_entity_status.status_type = 700) THEN
5582: IF (gmdfmval_pub.check_expr_items(pEntity_id)) THEN
5583: FND_MESSAGE.SET_NAME('GMD','GMD_EXPR_ITEMS_FOUND');
5584: FND_MSG_PUB.ADD;
5585: RAISE FND_API.G_EXC_ERROR;
5586: END IF;
5587: END IF; -- IF (X_status_type = 700) THEN
5588:
5589: --Check any inactive items in formula before changing the status
5590: IF (l_entity_status.status_type IN (400,700)) THEN
5591: IF (gmdfmval_pub.inactive_items(pEntity_id)) THEN
5592: FND_MESSAGE.SET_NAME('GMI','IC_ITEM_INACTIVE');
5593: FND_MSG_PUB.ADD;
5594: RAISE FND_API.G_EXC_ERROR;
5595: END IF;
5596: END IF; --l_entity_status.status_type IN (400,700)
5597: END IF;
5616:
5617: EXCEPTION
5618: WHEN default_status_err THEN
5619: ROLLBACK TO default_status_sp;
5620: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
5621: p_count => x_msg_count,
5622: p_data => x_msg_data );
5623: WHEN OTHERS THEN
5624: ROLLBACK TO default_status_sp;
5622: p_data => x_msg_data );
5623: WHEN OTHERS THEN
5624: ROLLBACK TO default_status_sp;
5625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5626: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
5627: p_count => x_msg_count,
5628: p_data => x_msg_data );
5629: END set_default_status;
5630: