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_RESALE_WF_PVT dependencies on OZF_RESALE_COMMON_PVT

Line 181: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN

177: OPEN batch_status_csr(l_batch_id);
178: FETCH batch_status_csr into l_batch_status;
179: CLOSE batch_status_csr;
180:
181: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN
182: l_batch_return_status := l_batch_status;
183: ELSE
184: OZF_RESALE_COMMON_PVT.Update_Duplicates (
185: p_api_version => 1.0,

Line 184: OZF_RESALE_COMMON_PVT.Update_Duplicates (

180:
181: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN
182: l_batch_return_status := l_batch_status;
183: ELSE
184: OZF_RESALE_COMMON_PVT.Update_Duplicates (
185: p_api_version => 1.0,
186: p_init_msg_list => FND_API.G_FALSE,
187: p_commit => FND_API.G_FALSE,
188: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 216: IF l_batch_return_status not in (OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED,

212: itemkey => itemkey ,
213: aname => G_WF_ATTR_BATCH_STATUS,
214: avalue => l_batch_return_status );
215:
216: IF l_batch_return_status not in (OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED,
217: OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED,
218: OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED) THEN
219: l_resultout := 'COMPLETE:OTHER';
220: ELSE

Line 217: OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED,

213: aname => G_WF_ATTR_BATCH_STATUS,
214: avalue => l_batch_return_status );
215:
216: IF l_batch_return_status not in (OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED,
217: OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED,
218: OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED) THEN
219: l_resultout := 'COMPLETE:OTHER';
220: ELSE
221: l_resultout := 'COMPLETE:' || l_batch_return_status;

Line 218: OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED) THEN

214: avalue => l_batch_return_status );
215:
216: IF l_batch_return_status not in (OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED,
217: OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED,
218: OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED) THEN
219: l_resultout := 'COMPLETE:OTHER';
220: ELSE
221: l_resultout := 'COMPLETE:' || l_batch_return_status;
222: END IF;

Line 638: IF l_status_code not in ( OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED,

634:
635: IF OZF_DEBUG_LOW_ON THEN
636: OZF_UTILITY_PVT.debug_message('Batch status '|| l_status_code );
637: END IF;
638: IF l_status_code not in ( OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED,
639: OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED,
640: OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED) THEN
641: l_resultout := 'COMPLETE:OTHER';
642: ELSE

Line 639: OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED,

635: IF OZF_DEBUG_LOW_ON THEN
636: OZF_UTILITY_PVT.debug_message('Batch status '|| l_status_code );
637: END IF;
638: IF l_status_code not in ( OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED,
639: OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED,
640: OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED) THEN
641: l_resultout := 'COMPLETE:OTHER';
642: ELSE
643: l_resultout := 'COMPLETE:' || l_status_code;

Line 640: OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED) THEN

636: OZF_UTILITY_PVT.debug_message('Batch status '|| l_status_code );
637: END IF;
638: IF l_status_code not in ( OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED,
639: OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED,
640: OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED) THEN
641: l_resultout := 'COMPLETE:OTHER';
642: ELSE
643: l_resultout := 'COMPLETE:' || l_status_code;
644: END IF;

Line 2097: OPEN OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr (l_resale_batch_id);

2093: RAISE FND_API.G_EXC_ERROR;
2094: END IF;
2095:
2096: -- reset the status based on # of disputed lines
2097: OPEN OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr (l_resale_batch_id);
2098: FETCH OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr into l_lines_disputed;
2099: CLOSE OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr;
2100:
2101: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING THEN

Line 2098: FETCH OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr into l_lines_disputed;

2094: END IF;
2095:
2096: -- reset the status based on # of disputed lines
2097: OPEN OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr (l_resale_batch_id);
2098: FETCH OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr into l_lines_disputed;
2099: CLOSE OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr;
2100:
2101: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING THEN
2102: IF l_lines_disputed = 0 THEN

Line 2099: CLOSE OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr;

2095:
2096: -- reset the status based on # of disputed lines
2097: OPEN OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr (l_resale_batch_id);
2098: FETCH OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr into l_lines_disputed;
2099: CLOSE OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr;
2100:
2101: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING THEN
2102: IF l_lines_disputed = 0 THEN
2103: -- update status to Processed

Line 2101: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING THEN

2097: OPEN OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr (l_resale_batch_id);
2098: FETCH OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr into l_lines_disputed;
2099: CLOSE OZF_RESALE_COMMON_PVT.g_disputed_line_count_csr;
2100:
2101: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING THEN
2102: IF l_lines_disputed = 0 THEN
2103: -- update status to Processed
2104: UPDATE ozf_resale_batches_all
2105: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_OPEN

Line 2105: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_OPEN

2101: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING THEN
2102: IF l_lines_disputed = 0 THEN
2103: -- update status to Processed
2104: UPDATE ozf_resale_batches_all
2105: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_OPEN
2106: WHERE resale_batch_id = l_resale_batch_id;
2107: ELSE
2108: -- update status to Disputed
2109: UPDATE ozf_resale_batches_all

Line 2110: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED

2106: WHERE resale_batch_id = l_resale_batch_id;
2107: ELSE
2108: -- update status to Disputed
2109: UPDATE ozf_resale_batches_all
2110: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
2111: WHERE resale_batch_id = l_resale_batch_id;
2112: END IF;
2113: ELSIF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN
2114:

Line 2113: ELSIF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN

2109: UPDATE ozf_resale_batches_all
2110: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
2111: WHERE resale_batch_id = l_resale_batch_id;
2112: END IF;
2113: ELSIF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN
2114:
2115: IF l_lines_disputed = 0 THEN
2116: -- update status to Processed
2117: UPDATE ozf_resale_batches_all

Line 2118: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED

2114:
2115: IF l_lines_disputed = 0 THEN
2116: -- update status to Processed
2117: UPDATE ozf_resale_batches_all
2118: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED
2119: WHERE resale_batch_id = l_resale_batch_id;
2120: ELSE
2121: -- update status to Disputed
2122: UPDATE ozf_resale_batches_all

Line 2123: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED

2119: WHERE resale_batch_id = l_resale_batch_id;
2120: ELSE
2121: -- update status to Disputed
2122: UPDATE ozf_resale_batches_all
2123: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
2124: WHERE resale_batch_id = l_resale_batch_id;
2125: END IF;
2126: END IF;
2127: l_resultout := 'COMPLETE';

Line 2319: IF l_batch_status in (OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING,

2315: RAISE FND_API.G_EXC_ERROR;
2316: END IF;
2317:
2318:
2319: IF l_batch_status in (OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING,
2320: OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT) THEN
2321: l_batch_next_status := l_batch_status;
2322: ELSE
2323: IF l_batch_status IN (OZF_RESALE_COMMON_PVT.G_BATCH_OPEN,

Line 2320: OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT) THEN

2316: END IF;
2317:
2318:
2319: IF l_batch_status in (OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING,
2320: OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT) THEN
2321: l_batch_next_status := l_batch_status;
2322: ELSE
2323: IF l_batch_status IN (OZF_RESALE_COMMON_PVT.G_BATCH_OPEN,
2324: OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED) THEN

Line 2323: IF l_batch_status IN (OZF_RESALE_COMMON_PVT.G_BATCH_OPEN,

2319: IF l_batch_status in (OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING,
2320: OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT) THEN
2321: l_batch_next_status := l_batch_status;
2322: ELSE
2323: IF l_batch_status IN (OZF_RESALE_COMMON_PVT.G_BATCH_OPEN,
2324: OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED) THEN
2325: l_batch_next_status := OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING;
2326:
2327: UPDATE ozf_resale_batches_all

Line 2324: OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED) THEN

2320: OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT) THEN
2321: l_batch_next_status := l_batch_status;
2322: ELSE
2323: IF l_batch_status IN (OZF_RESALE_COMMON_PVT.G_BATCH_OPEN,
2324: OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED) THEN
2325: l_batch_next_status := OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING;
2326:
2327: UPDATE ozf_resale_batches_all
2328: SET status_code = l_batch_next_status

Line 2325: l_batch_next_status := OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING;

2321: l_batch_next_status := l_batch_status;
2322: ELSE
2323: IF l_batch_status IN (OZF_RESALE_COMMON_PVT.G_BATCH_OPEN,
2324: OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED) THEN
2325: l_batch_next_status := OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSING;
2326:
2327: UPDATE ozf_resale_batches_all
2328: SET status_code = l_batch_next_status
2329: WHERE resale_batch_id = l_resale_batch_id;

Line 2465: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT

2461: itemkey => itemkey,
2462: aname => G_WF_ATTR_BATCH_ID);
2463:
2464: UPDATE ozf_resale_batches_all
2465: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT
2466: WHERE resale_batch_id = l_resale_batch_id;
2467:
2468: l_resultout := 'COMPLETE';
2469: --

Line 2841: OZF_RESALE_COMMON_PVT.Validate_Batch (

2837: IF OZF_DEBUG_LOW_ON THEN
2838: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
2839: END IF;
2840: IF l_batch_id IS NOT NULL THEN
2841: OZF_RESALE_COMMON_PVT.Validate_Batch (
2842: p_api_version => 1.0,
2843: p_init_msg_list => FND_API.G_FALSE,
2844: p_commit => FND_API.G_FALSE,
2845: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2988: OZF_RESALE_COMMON_PVT.Validate_Order_Record (

2984: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
2985: END IF;
2986: IF l_batch_id IS NOT NULL THEN
2987: -- Verify the line information for this batch
2988: OZF_RESALE_COMMON_PVT.Validate_Order_Record (
2989: p_api_version => 1.0
2990: ,p_init_msg_list => FND_API.G_FALSE
2991: ,p_commit => FND_API.G_FALSE
2992: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL