DBA Data[Home] [Help]

APPS.OZF_SD_BATCH_FEED_PVT dependencies on FND_MESSAGE

Line 690: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');

686: WHERE ship_frm_sd_claim_request_id = p_batch_number
687: AND processed_flag = 'N';
688: COMMIT;
689: x_return_status := fnd_api.g_ret_sts_error;
690: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');
691: RETURN;
692: WHEN OTHERS THEN
693: x_return_status := fnd_api.g_ret_sts_error;
694: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');

Line 694: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');

690: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');
691: RETURN;
692: WHEN OTHERS THEN
693: x_return_status := fnd_api.g_ret_sts_error;
694: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_INVALID');
695: RETURN;
696: END;
697:
698: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

Line 714: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_STATUS_INVALID');

710: WHERE ship_frm_sd_claim_request_id = p_batch_number
711: AND processed_flag = 'N';
712: COMMIT;
713: x_return_status := fnd_api.g_ret_sts_error;
714: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_BATCH_STATUS_INVALID');
715: RETURN;
716: END IF;
717:
718: --check whether lines exist for given batch id

Line 788: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR');

784: AND processed_flag = 'N';
785:
786:
787: x_return_status := fnd_api.g_ret_sts_error;
788: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR');
789: END IF;
790: END LOOP;
791:
792: FOR v_missing_invalid_sts_lines IN (SELECT batch_line_number,

Line 810: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR');

806: WHERE ship_frm_sd_claim_request_id = p_batch_number
807: AND batch_line_number = v_missing_invalid_sts_lines.batch_line_number;
808:
809: x_return_status := fnd_api.g_ret_sts_error;
810: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR');
811:
812: UPDATE ozf_sd_batch_lines_all
813: SET status_code = 'REJECTED',
814: approved_amount = v_missing_invalid_sts_lines.vendor_auth_cost_monetary_amt,

Line 977: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');

973:
974: IF x_return_status = fnd_api.g_ret_sts_error THEN
975: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
976: 'Entered throwing exception' || x_msg_data);
977: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
978: fnd_message.set_token('MESSAGE', x_msg_data);
979: RAISE fnd_api.g_exc_error;
980: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
981: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

Line 978: fnd_message.set_token('MESSAGE', x_msg_data);

974: IF x_return_status = fnd_api.g_ret_sts_error THEN
975: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
976: 'Entered throwing exception' || x_msg_data);
977: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
978: fnd_message.set_token('MESSAGE', x_msg_data);
979: RAISE fnd_api.g_exc_error;
980: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
981: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
982: 'Entered throwing unexpected exception');

Line 983: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');

979: RAISE fnd_api.g_exc_error;
980: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
981: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
982: 'Entered throwing unexpected exception');
983: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
984: fnd_message.set_token('MESSAGE', x_msg_data);
985: RAISE fnd_api.g_exc_unexpected_error;
986: END IF;
987:

Line 984: fnd_message.set_token('MESSAGE', x_msg_data);

980: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
981: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
982: 'Entered throwing unexpected exception');
983: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
984: fnd_message.set_token('MESSAGE', x_msg_data);
985: RAISE fnd_api.g_exc_unexpected_error;
986: END IF;
987:
988: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'Procedure Ends');

Line 995: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');

991: WHEN fnd_api.g_exc_error THEN
992: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
993: 'OZF EXCEPTION G_EXC_ERROR: '||x_msg_data);
994: x_return_status := fnd_api.g_ret_sts_error;
995: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
996: fnd_message.set_token('MESSAGE', x_msg_data);
997: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
998: 'OZF done:' || x_msg_data || '::::');
999:

Line 996: fnd_message.set_token('MESSAGE', x_msg_data);

992: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
993: 'OZF EXCEPTION G_EXC_ERROR: '||x_msg_data);
994: x_return_status := fnd_api.g_ret_sts_error;
995: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
996: fnd_message.set_token('MESSAGE', x_msg_data);
997: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
998: 'OZF done:' || x_msg_data || '::::');
999:
1000: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1004: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');

1000: WHEN fnd_api.g_exc_unexpected_error THEN
1001: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1002: 'OZF EXCEPTION G_EXC_UNEXPECTED_ERROR');
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
1005: fnd_message.set_token('MESSAGE', x_msg_data);
1006: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1007: 'OZF done G_EXC_UNEXPECTED_ERROR:' || x_msg_data || '::::');
1008: WHEN others THEN

Line 1005: fnd_message.set_token('MESSAGE', x_msg_data);

1001: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1002: 'OZF EXCEPTION G_EXC_UNEXPECTED_ERROR');
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
1005: fnd_message.set_token('MESSAGE', x_msg_data);
1006: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1007: 'OZF done G_EXC_UNEXPECTED_ERROR:' || x_msg_data || '::::');
1008: WHEN others THEN
1009: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',

Line 1012: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');

1008: WHEN others THEN
1009: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1010: 'OZF EXCEPTION OTHERS' || sqlerrm);
1011: x_return_status := fnd_api.g_ret_sts_error;
1012: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
1013: fnd_message.set_token('MESSAGE', x_msg_data);
1014: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1015: 'OZF done OTHERS:' || x_msg_data ||'::::');
1016: END update_data;

Line 1013: fnd_message.set_token('MESSAGE', x_msg_data);

1009: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1010: 'OZF EXCEPTION OTHERS' || sqlerrm);
1011: x_return_status := fnd_api.g_ret_sts_error;
1012: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
1013: fnd_message.set_token('MESSAGE', x_msg_data);
1014: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1015: 'OZF done OTHERS:' || x_msg_data ||'::::');
1016: END update_data;
1017:

Line 1337: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR');

1333: WHERE batch_line_number = v_rejected_lines.batch_line_number
1334: AND ship_frm_sd_claim_request_id = p_batch_number;
1335:
1336: x_return_status := fnd_api.g_ret_sts_error;
1337: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR');
1338:
1339: END IF;
1340:
1341: SELECT claim_amount_currency_code

Line 1358: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR');

1354: WHERE batch_line_number = v_rejected_lines.batch_line_number AND
1355: ship_frm_sd_claim_request_id = p_batch_number;
1356:
1357: x_return_status := fnd_api.g_ret_sts_error;
1358: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR');
1359:
1360: END IF;
1361:
1362: IF v_rejected_lines.vendor_auth_cost_monetary_amt < 0 THEN

Line 1372: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR');

1368: WHERE batch_line_number = v_rejected_lines.batch_line_number AND
1369: ship_frm_sd_claim_request_id = p_batch_number;
1370:
1371: x_return_status := fnd_api.g_ret_sts_error;
1372: x_msg_data := FND_MESSAGE.GET_STRING('OZF','OZF_SD_FEED_DATA_ERROR');
1373:
1374: END IF;
1375:
1376: UPDATE ozf_sd_batch_lines_all