eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_SD_BATCH_FEED_PVT dependencies on FND_API

Line 672: x_return_status := fnd_api.g_ret_sts_success;

668: BEGIN
669:
670: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'Procedure Starts');
671:
672: x_return_status := fnd_api.g_ret_sts_success;
673:
674: --Retreive batch id
675: BEGIN
676: SELECT batch_id, status_code

Line 689: x_return_status := fnd_api.g_ret_sts_error;

685: last_updated_by = fnd_global.user_id
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;

Line 693: x_return_status := fnd_api.g_ret_sts_error;

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');
695: RETURN;
696: END;
697:

Line 713: x_return_status := fnd_api.g_ret_sts_error;

709: last_updated_by = fnd_global.user_id
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:

Line 733: x_return_status := fnd_api.g_ret_sts_error;

729: last_updated_by = fnd_global.user_id
730: WHERE ship_frm_sd_claim_request_id = p_batch_number
731: AND processed_flag = 'N';
732: COMMIT;
733: x_return_status := fnd_api.g_ret_sts_error;
734: x_msg_data := 'There are no Lines for this Batch ID';
735: RETURN;
736: END IF;
737:

Line 787: x_return_status := fnd_api.g_ret_sts_error;

783: AND batch_line_number = v_batch_lines.batch_line_number
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:

Line 809: x_return_status := fnd_api.g_ret_sts_error;

805: last_updated_by = fnd_global.user_id
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',

Line 974: IF x_return_status = fnd_api.g_ret_sts_error THEN

970: COMMIT;
971: RETURN;
972: END IF;
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);

Line 979: RAISE fnd_api.g_exc_error;

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');
983: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');

Line 980: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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');
983: fnd_message.set_name('OZF', 'OZF_SD_FEED_DATA_ERROR');
984: fnd_message.set_token('MESSAGE', x_msg_data);

Line 985: RAISE fnd_api.g_exc_unexpected_error;

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');
989:

Line 991: WHEN fnd_api.g_exc_error THEN

987:
988: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data', 'Procedure Ends');
989:
990: EXCEPTION
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');

Line 994: x_return_status := fnd_api.g_ret_sts_error;

990: EXCEPTION
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 || '::::');

Line 1000: WHEN fnd_api.g_exc_unexpected_error THEN

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
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');

Line 1003: x_return_status := fnd_api.g_ret_sts_unexp_error;

999:
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 || '::::');

Line 1011: x_return_status := fnd_api.g_ret_sts_error;

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',
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 ||'::::');

Line 1262: fnd_api.g_false,

1258: 'Procedure Starts: Batch Id -> '||p_batch_id);
1259: --call claim API
1260: --update claim number and set batch /closed
1261: ozf_claim_accrual_pvt.initiate_sd_payment(1,
1262: fnd_api.g_false,
1263: fnd_api.g_true,
1264: fnd_api.g_valid_level_full,
1265: l_claim_ret_status,
1266: l_claim_msg_count,

Line 1263: fnd_api.g_true,

1259: --call claim API
1260: --update claim number and set batch /closed
1261: ozf_claim_accrual_pvt.initiate_sd_payment(1,
1262: fnd_api.g_false,
1263: fnd_api.g_true,
1264: fnd_api.g_valid_level_full,
1265: l_claim_ret_status,
1266: l_claim_msg_count,
1267: l_claim_msg_data,

Line 1264: fnd_api.g_valid_level_full,

1260: --update claim number and set batch /closed
1261: ozf_claim_accrual_pvt.initiate_sd_payment(1,
1262: fnd_api.g_false,
1263: fnd_api.g_true,
1264: fnd_api.g_valid_level_full,
1265: l_claim_ret_status,
1266: l_claim_msg_count,
1267: l_claim_msg_data,
1268: p_batch_id,

Line 1280: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN

1276: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'OZF_SD_BATCH_FEED_PVT::process_claim',
1277: 'Claim API Msg: '|| SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254) );
1278: END LOOP;
1279:
1280: IF l_claim_ret_status = FND_API.G_RET_STS_SUCCESS THEN
1281: UPDATE ozf_sd_batch_headers_all
1282: SET status_code = 'CLOSED',
1283: claim_id = l_claim_id,
1284: last_update_date = sysdate,

Line 1291: RAISE fnd_api.g_exc_error;

1287: WHERE batch_id = p_batch_id;
1288: ELSE
1289: x_return_status := l_claim_ret_status;
1290: x_msg_data := l_claim_msg_data;
1291: RAISE fnd_api.g_exc_error;
1292: END IF;
1293: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::process_claim',
1294: 'Procedure Ends');
1295: END process_claim;

Line 1336: x_return_status := fnd_api.g_ret_sts_error;

1332: last_updated_by = fnd_global.user_id
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:

Line 1357: x_return_status := fnd_api.g_ret_sts_error;

1353: last_updated_by = fnd_global.user_id
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:

Line 1371: x_return_status := fnd_api.g_ret_sts_error;

1367: last_updated_by = fnd_global.user_id
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: