DBA Data[Home] [Help]

APPS.OZF_FORECAST_UTIL_PVT dependencies on FND_MESSAGE

Line 826: FND_MESSAGE.set_name('OZF', 'OZF_FCST_PROD_MKT_REQD');

822: IF l_count = 0
823: THEN
824: if p_obj_type <> 'WKST'
825: then
826: FND_MESSAGE.set_name('OZF', 'OZF_FCST_PROD_MKT_REQD');
827: FND_MSG_PUB.add;
828: RAISE FND_API.G_EXC_ERROR;
829: end if;
830: END IF;

Line 5740: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_HEADER_QTY_REMAINING');

5736: -- forecast_remaining_quantity <> 0 for some record
5737: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5738:
5739: IF (l_flag_fcst = true) THEN
5740: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_HEADER_QTY_REMAINING');
5741: FND_MSG_PUB.Add;
5742: END IF;
5743:
5744: IF (l_flag_level_one = true) THEN

Line 5745: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_LEVEL_QTY_REMAINING');

5741: FND_MSG_PUB.Add;
5742: END IF;
5743:
5744: IF (l_flag_level_one = true) THEN
5745: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_LEVEL_QTY_REMAINING');
5746: FND_MESSAGE.Set_Token('DIMENTION', l_dimention1 );
5747: FND_MSG_PUB.Add;
5748: END IF;
5749:

Line 5746: FND_MESSAGE.Set_Token('DIMENTION', l_dimention1 );

5742: END IF;
5743:
5744: IF (l_flag_level_one = true) THEN
5745: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_LEVEL_QTY_REMAINING');
5746: FND_MESSAGE.Set_Token('DIMENTION', l_dimention1 );
5747: FND_MSG_PUB.Add;
5748: END IF;
5749:
5750: IF (l_flag_level_two = true) THEN

Line 5751: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_LEVEL_QTY_REMAINING');

5747: FND_MSG_PUB.Add;
5748: END IF;
5749:
5750: IF (l_flag_level_two = true) THEN
5751: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_LEVEL_QTY_REMAINING');
5752: FND_MESSAGE.Set_Token('DIMENTION', l_dimention2 );
5753: FND_MSG_PUB.Add;
5754: END IF;
5755:

Line 5752: FND_MESSAGE.Set_Token('DIMENTION', l_dimention2 );

5748: END IF;
5749:
5750: IF (l_flag_level_two = true) THEN
5751: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_LEVEL_QTY_REMAINING');
5752: FND_MESSAGE.Set_Token('DIMENTION', l_dimention2 );
5753: FND_MSG_PUB.Add;
5754: END IF;
5755:
5756: END IF;

Line 6912: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');

6908: EXCEPTION
6909: WHEN OTHERS THEN
6910: x_return_status := FND_API.g_ret_sts_unexp_error;
6911:
6912: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
6913: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
6914: FND_MSG_PUB.add;
6915:
6916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 6913: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

6909: WHEN OTHERS THEN
6910: x_return_status := FND_API.g_ret_sts_unexp_error;
6911:
6912: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
6913: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
6914: FND_MSG_PUB.add;
6915:
6916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
6917: THEN

Line 7194: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');

7190: EXCEPTION
7191: WHEN OTHERS THEN
7192: x_return_status := FND_API.g_ret_sts_unexp_error;
7193:
7194: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
7195: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
7196: FND_MSG_PUB.add;
7197:
7198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 7195: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

7191: WHEN OTHERS THEN
7192: x_return_status := FND_API.g_ret_sts_unexp_error;
7193:
7194: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
7195: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
7196: FND_MSG_PUB.add;
7197:
7198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
7199: THEN

Line 7743: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');

7739: EXCEPTION
7740: WHEN OTHERS THEN
7741: x_return_status := FND_API.g_ret_sts_unexp_error;
7742:
7743: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
7744: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
7745: FND_MSG_PUB.add;
7746:
7747: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 7744: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

7740: WHEN OTHERS THEN
7741: x_return_status := FND_API.g_ret_sts_unexp_error;
7742:
7743: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
7744: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
7745: FND_MSG_PUB.add;
7746:
7747: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
7748: THEN

Line 7958: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');

7954:
7955: IF x_return_stat = 'E'
7956: THEN
7957: x_return_status := FND_API.G_RET_STS_ERROR;
7958: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');
7959: FND_MESSAGE.set_token('ERR_MSG',x_return_status_text);
7960: FND_MSG_PUB.add;
7961: RAISE FND_API.G_EXC_ERROR;
7962: ELSE

Line 7959: FND_MESSAGE.set_token('ERR_MSG',x_return_status_text);

7955: IF x_return_stat = 'E'
7956: THEN
7957: x_return_status := FND_API.G_RET_STS_ERROR;
7958: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');
7959: FND_MESSAGE.set_token('ERR_MSG',x_return_status_text);
7960: FND_MSG_PUB.add;
7961: RAISE FND_API.G_EXC_ERROR;
7962: ELSE
7963:

Line 7975: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');

7971:
7972: IF l_status_code <> 'UPDATED'
7973: THEN
7974: x_return_status := FND_API.G_RET_STS_ERROR;
7975: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');
7976: FND_MESSAGE.set_token('ERR_MSG',l_status_text);
7977: FND_MSG_PUB.add;
7978: RAISE FND_API.G_EXC_ERROR;
7979:

Line 7976: FND_MESSAGE.set_token('ERR_MSG',l_status_text);

7972: IF l_status_code <> 'UPDATED'
7973: THEN
7974: x_return_status := FND_API.G_RET_STS_ERROR;
7975: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');
7976: FND_MESSAGE.set_token('ERR_MSG',l_status_text);
7977: FND_MSG_PUB.add;
7978: RAISE FND_API.G_EXC_ERROR;
7979:
7980: END IF;

Line 8003: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');

7999:
8000: WHEN OTHERS THEN
8001: x_return_status := FND_API.g_ret_sts_unexp_error;
8002:
8003: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');
8004: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
8005: FND_MSG_PUB.add;
8006:
8007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 8004: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

8000: WHEN OTHERS THEN
8001: x_return_status := FND_API.g_ret_sts_unexp_error;
8002:
8003: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');
8004: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
8005: FND_MSG_PUB.add;
8006:
8007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8008: THEN

Line 8260: FND_MESSAGE.set_name('OZF', 'OZF_FCST_CALC_COG_FAILED');

8256:
8257: WHEN OTHERS THEN
8258: x_return_status := FND_API.g_ret_sts_unexp_error;
8259:
8260: FND_MESSAGE.set_name('OZF', 'OZF_FCST_CALC_COG_FAILED');
8261: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
8262: FND_MSG_PUB.add;
8263:
8264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 8261: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

8257: WHEN OTHERS THEN
8258: x_return_status := FND_API.g_ret_sts_unexp_error;
8259:
8260: FND_MESSAGE.set_name('OZF', 'OZF_FCST_CALC_COG_FAILED');
8261: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
8262: FND_MSG_PUB.add;
8263:
8264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8265: THEN

Line 8725: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_DISC_FAILED');

8721: WHEN OTHERS THEN
8722: ROLLBACK TO get_discount_percent;
8723: x_return_status := FND_API.g_ret_sts_unexp_error;
8724:
8725: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_DISC_FAILED');
8726: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
8727: FND_MSG_PUB.add;
8728:
8729: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 8726: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

8722: ROLLBACK TO get_discount_percent;
8723: x_return_status := FND_API.g_ret_sts_unexp_error;
8724:
8725: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_DISC_FAILED');
8726: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
8727: FND_MSG_PUB.add;
8728:
8729: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8730: THEN

Line 9165: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_COG_MISSING');

9161: NULL;
9162: /*
9163: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
9164: THEN
9165: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_COG_MISSING');
9166: FND_MESSAGE.Set_Token('PRODUCT', p_product_attr_value );
9167: FND_MSG_PUB.Add;
9168: RAISE FND_API.g_exc_error;
9169: END IF;

Line 9166: FND_MESSAGE.Set_Token('PRODUCT', p_product_attr_value );

9162: /*
9163: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
9164: THEN
9165: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_COG_MISSING');
9166: FND_MESSAGE.Set_Token('PRODUCT', p_product_attr_value );
9167: FND_MSG_PUB.Add;
9168: RAISE FND_API.g_exc_error;
9169: END IF;
9170: */

Line 9201: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_DISC_FAILED');

9197: WHEN OTHERS THEN
9198: ROLLBACK TO get_discount_info;
9199: x_return_status := FND_API.g_ret_sts_unexp_error;
9200:
9201: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_DISC_FAILED');
9202: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
9203: FND_MSG_PUB.add;
9204:
9205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 9202: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

9198: ROLLBACK TO get_discount_info;
9199: x_return_status := FND_API.g_ret_sts_unexp_error;
9200:
9201: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_DISC_FAILED');
9202: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
9203: FND_MSG_PUB.add;
9204:
9205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
9206: THEN

Line 9853: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_UOM_CONVERSION_MISSING');

9849: l_flag_error := true;
9850:
9851: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
9852: THEN
9853: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_UOM_CONVERSION_MISSING');
9854: FND_MESSAGE.Set_Token('CURRENT_UOM', l_fcst_uom); -- replace with p_fcst_uom
9855: FND_MESSAGE.Set_Token('ORDER_UOM', i.uom_code);
9856: FND_MSG_PUB.Add;
9857: END IF;

Line 9854: FND_MESSAGE.Set_Token('CURRENT_UOM', l_fcst_uom); -- replace with p_fcst_uom

9850:
9851: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
9852: THEN
9853: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_UOM_CONVERSION_MISSING');
9854: FND_MESSAGE.Set_Token('CURRENT_UOM', l_fcst_uom); -- replace with p_fcst_uom
9855: FND_MESSAGE.Set_Token('ORDER_UOM', i.uom_code);
9856: FND_MSG_PUB.Add;
9857: END IF;
9858:

Line 9855: FND_MESSAGE.Set_Token('ORDER_UOM', i.uom_code);

9851: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
9852: THEN
9853: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_UOM_CONVERSION_MISSING');
9854: FND_MESSAGE.Set_Token('CURRENT_UOM', l_fcst_uom); -- replace with p_fcst_uom
9855: FND_MESSAGE.Set_Token('ORDER_UOM', i.uom_code);
9856: FND_MSG_PUB.Add;
9857: END IF;
9858:
9859: END IF;

Line 9925: FND_MESSAGE.set_name('OZF', 'OZF_GET_VOLUME_OFFER_DISCOUNT_FAILED');

9921:
9922: ROLLBACK TO get_volume_offer_discount;
9923: x_return_status := FND_API.g_ret_sts_unexp_error;
9924:
9925: FND_MESSAGE.set_name('OZF', 'OZF_GET_VOLUME_OFFER_DISCOUNT_FAILED');
9926: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
9927: FND_MSG_PUB.add;
9928:
9929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 9926: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

9922: ROLLBACK TO get_volume_offer_discount;
9923: x_return_status := FND_API.g_ret_sts_unexp_error;
9924:
9925: FND_MESSAGE.set_name('OZF', 'OZF_GET_VOLUME_OFFER_DISCOUNT_FAILED');
9926: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
9927: FND_MSG_PUB.add;
9928:
9929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
9930: THEN

Line 10084: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_UOM_CONVERSION_MISSING');

10080: l_flag_error := true;
10081:
10082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
10083: THEN
10084: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_UOM_CONVERSION_MISSING');
10085: FND_MESSAGE.Set_Token('CURRENT_UOM', i.forecast_uom_code);
10086: FND_MESSAGE.Set_Token('ORDER_UOM', i.offer_product_uom_code);
10087: FND_MSG_PUB.Add;
10088: END IF;

Line 10085: FND_MESSAGE.Set_Token('CURRENT_UOM', i.forecast_uom_code);

10081:
10082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
10083: THEN
10084: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_UOM_CONVERSION_MISSING');
10085: FND_MESSAGE.Set_Token('CURRENT_UOM', i.forecast_uom_code);
10086: FND_MESSAGE.Set_Token('ORDER_UOM', i.offer_product_uom_code);
10087: FND_MSG_PUB.Add;
10088: END IF;
10089: ELSE

Line 10086: FND_MESSAGE.Set_Token('ORDER_UOM', i.offer_product_uom_code);

10082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
10083: THEN
10084: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_UOM_CONVERSION_MISSING');
10085: FND_MESSAGE.Set_Token('CURRENT_UOM', i.forecast_uom_code);
10086: FND_MESSAGE.Set_Token('ORDER_UOM', i.offer_product_uom_code);
10087: FND_MSG_PUB.Add;
10088: END IF;
10089: ELSE
10090: l_ratio := i.converted_ratio ;

Line 10100: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRICE_LIST_NEEDED');

10096: l_flag_error := true;
10097:
10098: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
10099: THEN
10100: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRICE_LIST_NEEDED');
10101: FND_MSG_PUB.Add;
10102: END IF;
10103:
10104: ELSE

Line 10532: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');

10528: EXCEPTION
10529: WHEN OTHERS THEN
10530: x_return_status := FND_API.g_ret_sts_unexp_error;
10531:
10532: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
10533: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
10534: FND_MSG_PUB.add;
10535:
10536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 10533: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

10529: WHEN OTHERS THEN
10530: x_return_status := FND_API.g_ret_sts_unexp_error;
10531:
10532: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
10533: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
10534: FND_MSG_PUB.add;
10535:
10536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
10537: THEN

Line 10709: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');

10705: EXCEPTION
10706: WHEN OTHERS THEN
10707: x_return_status := FND_API.g_ret_sts_unexp_error;
10708:
10709: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
10710: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
10711: FND_MSG_PUB.add;
10712:
10713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 10710: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

10706: WHEN OTHERS THEN
10707: x_return_status := FND_API.g_ret_sts_unexp_error;
10708:
10709: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
10710: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
10711: FND_MSG_PUB.add;
10712:
10713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
10714: THEN