DBA Data[Home] [Help]

APPS.OZF_TP_ACCRUAL_PVT dependencies on FND_MESSAGE

Line 214: FND_MESSAGE.get_string('OZF','OZF_BATCH_STATUS_WNG'),

210: ozf_resale_logs_all_s.nextval,
211: p_resale_batch_id,
212: 'BATCH',
213: 'OZF_BATCH_STATUS_WNG',
214: FND_MESSAGE.get_string('OZF','OZF_BATCH_STATUS_WNG'),
215: 'STATUS_CODE',
216: l_status_code,
217: l_org_id
218: FROM dual

Line 229: FND_MESSAGE.set_name('OZF', 'OZF_INS_RESALE_LOG_WRG');

225: );
226: EXCEPTION
227: WHEN OTHERS THEN
228: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
229: FND_MESSAGE.set_name('OZF', 'OZF_INS_RESALE_LOG_WRG');
230: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
231: FND_MSG_PUB.add;
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;

Line 230: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');

226: EXCEPTION
227: WHEN OTHERS THEN
228: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
229: FND_MESSAGE.set_name('OZF', 'OZF_INS_RESALE_LOG_WRG');
230: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
231: FND_MSG_PUB.add;
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234: END;

Line 347: FND_MESSAGE.get_string('OZF','OZF_RESALE_SELL_PRICE_NULL'),

343: ozf_resale_logs_all_s.nextval,
344: resale_line_int_id,
345: 'IFACE',
346: 'OZF_RESALE_SELL_PRICE_NULL',
347: FND_MESSAGE.get_string('OZF','OZF_RESALE_SELL_PRICE_NULL'),
348: 'SELLING_PRICE',
349: NULL,
350: org_id
351: FROM ozf_resale_lines_int_all b

Line 399: FND_MESSAGE.get_string('OZF','OZF_RESALE_SELL_PRICE_NULL'),

395: ozf_resale_logs_all_s.nextval,
396: b.resale_line_id,
397: 'LINE',
398: 'OZF_RESALE_SELL_PRICE_NULL',
399: FND_MESSAGE.get_string('OZF','OZF_RESALE_SELL_PRICE_NULL'),
400: 'SELLING_PRICE',
401: NULL,
402: b.org_id
403: FROM ozf_resale_lines_all b

Line 1181: FND_MESSAGE.Set_Token('OZF', 'OZF_COST_PRICE_NOT_FOUND');

1177: CLOSE c_purchase_price;
1178:
1179: IF (l_cost_price = -1 AND (l_ldets_tbl(k).operand_calculation_code = '%' OR l_ldets_tbl(k).operand_calculation_code ='UNIT_PRICE')) THEN
1180: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1181: FND_MESSAGE.Set_Token('OZF', 'OZF_COST_PRICE_NOT_FOUND');
1182: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
1183: FND_MESSAGE.Set_Token('ORDER',l_act_util_rec.object_id);
1184: FND_MESSAGE.Set_Token('ITEM',l_act_util_rec.product_id);
1185: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 1182: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?

1178:
1179: IF (l_cost_price = -1 AND (l_ldets_tbl(k).operand_calculation_code = '%' OR l_ldets_tbl(k).operand_calculation_code ='UNIT_PRICE')) THEN
1180: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1181: FND_MESSAGE.Set_Token('OZF', 'OZF_COST_PRICE_NOT_FOUND');
1182: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
1183: FND_MESSAGE.Set_Token('ORDER',l_act_util_rec.object_id);
1184: FND_MESSAGE.Set_Token('ITEM',l_act_util_rec.product_id);
1185: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1186: fnd_msg_pub.add;

Line 1183: FND_MESSAGE.Set_Token('ORDER',l_act_util_rec.object_id);

1179: IF (l_cost_price = -1 AND (l_ldets_tbl(k).operand_calculation_code = '%' OR l_ldets_tbl(k).operand_calculation_code ='UNIT_PRICE')) THEN
1180: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1181: FND_MESSAGE.Set_Token('OZF', 'OZF_COST_PRICE_NOT_FOUND');
1182: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
1183: FND_MESSAGE.Set_Token('ORDER',l_act_util_rec.object_id);
1184: FND_MESSAGE.Set_Token('ITEM',l_act_util_rec.product_id);
1185: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1186: fnd_msg_pub.add;
1187: END IF;

Line 1184: FND_MESSAGE.Set_Token('ITEM',l_act_util_rec.product_id);

1180: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1181: FND_MESSAGE.Set_Token('OZF', 'OZF_COST_PRICE_NOT_FOUND');
1182: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
1183: FND_MESSAGE.Set_Token('ORDER',l_act_util_rec.object_id);
1184: FND_MESSAGE.Set_Token('ITEM',l_act_util_rec.product_id);
1185: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1186: fnd_msg_pub.add;
1187: END IF;
1188: RAISE fnd_api.g_exc_error;

Line 1185: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

1181: FND_MESSAGE.Set_Token('OZF', 'OZF_COST_PRICE_NOT_FOUND');
1182: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
1183: FND_MESSAGE.Set_Token('ORDER',l_act_util_rec.object_id);
1184: FND_MESSAGE.Set_Token('ITEM',l_act_util_rec.product_id);
1185: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1186: fnd_msg_pub.add;
1187: END IF;
1188: RAISE fnd_api.g_exc_error;
1189: END IF;

Line 2853: p_error_message => fnd_message.get_string('OZF','OZF_GET_ORDER_PRIC_ERR'),

2849: px_resale_log_id => l_log_id,
2850: p_resale_id => l_order_set_tbl(p).resale_line_id,
2851: p_resale_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE,
2852: p_error_code => 'OZF_GET_ORDER_PRIC_ERR',
2853: p_error_message => fnd_message.get_string('OZF','OZF_GET_ORDER_PRIC_ERR'),
2854: p_column_name => NULL,
2855: p_column_value => NULL,
2856: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
2857: px_org_id => l_org_id

Line 2920: p_error_message => fnd_message.get_string('OZF','OZF_PROC_PRIC_RESLT_ERR'),

2916: px_resale_log_id => l_log_id,
2917: p_resale_id => l_order_set_tbl(i).resale_line_id,
2918: p_resale_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE,
2919: p_error_code => 'OZF_PROC_PRIC_RESLT_ERR',
2920: p_error_message => fnd_message.get_string('OZF','OZF_PROC_PRIC_RESLT_ERR'),
2921: p_column_name => NULL,
2922: p_column_value => NULL,
2923: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
2924: px_org_id => l_org_id

Line 4196: p_error_message => FND_MESSAGE.get_string('OZF','OZF_GET_ORDER_PRIC_ERR'),

4192: px_resale_log_id => l_log_id,
4193: p_resale_id => l_order_set_tbl(p).resale_line_int_id,
4194: p_resale_id_type => 'IFACE',
4195: p_error_code => 'OZF_GET_ORDER_PRIC_ERR',
4196: p_error_message => FND_MESSAGE.get_string('OZF','OZF_GET_ORDER_PRIC_ERR'),
4197: p_column_name => NULL,
4198: p_column_value => NULL,
4199: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
4200: px_org_id => l_org_id

Line 4257: p_error_message => FND_MESSAGE.get_string('OZF','OZF_PRIC_RESULT_ERR'),

4253: px_resale_log_id => l_log_id,
4254: p_resale_id => l_order_set_tbl(p).resale_line_int_id,
4255: p_resale_id_type => 'IFACE',
4256: p_error_code => 'OZF_PRIC_RESULT_ERR',
4257: p_error_message => FND_MESSAGE.get_string('OZF','OZF_PRIC_RESULT_ERR'),
4258: p_column_name => NULL,
4259: p_column_value => NULL,
4260: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
4261: px_org_id => l_org_id