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.POS_WC_CREATE_UPDATE_PVT dependencies on FND_API

Line 147: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN

143: x_return_status => l_api_return_status,
144: x_return_msg => l_api_return_msg
145: );
146:
147: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: END IF;

Line 148: RAISE FND_API.G_EXC_ERROR;

144: x_return_msg => l_api_return_msg
145: );
146:
147: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: END IF;
152:

Line 149: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

145: );
146:
147: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: END IF;
152:
153: l_progress := 1;

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

146:
147: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: END IF;
152:
153: l_progress := 1;
154:

Line 163: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN

159: x_return_status => l_api_return_status,
160: x_return_msg => l_api_return_msg
161: );
162:
163: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
164: RAISE FND_API.G_EXC_ERROR;
165: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;

Line 164: RAISE FND_API.G_EXC_ERROR;

160: x_return_msg => l_api_return_msg
161: );
162:
163: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
164: RAISE FND_API.G_EXC_ERROR;
165: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168:

Line 165: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

161: );
162:
163: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
164: RAISE FND_API.G_EXC_ERROR;
165: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168:
169: EXCEPTION

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

162:
163: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
164: RAISE FND_API.G_EXC_ERROR;
165: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168:
169: EXCEPTION
170:

Line 171: WHEN FND_API.G_EXC_ERROR THEN

167: END IF;
168:
169: EXCEPTION
170:
171: WHEN FND_API.G_EXC_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: x_return_msg := l_api_return_msg;
174: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_info',
175: 'Expected error at stage: '|| l_progress);

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168:
169: EXCEPTION
170:
171: WHEN FND_API.G_EXC_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: x_return_msg := l_api_return_msg;
174: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_info',
175: 'Expected error at stage: '|| l_progress);
176: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_ccinfo',

Line 179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

175: 'Expected error at stage: '|| l_progress);
176: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_ccinfo',
177: 'Error: '|| l_api_return_msg);
178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: x_return_msg := 'Unexpected error at stage: '|| l_progress;
182: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_info',
183: 'Unexpected error at stage: '|| l_progress);

Line 180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

176: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_ccinfo',
177: 'Error: '|| l_api_return_msg);
178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: x_return_msg := 'Unexpected error at stage: '|| l_progress;
182: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_info',
183: 'Unexpected error at stage: '|| l_progress);
184:

Line 186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

182: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_info',
183: 'Unexpected error at stage: '|| l_progress);
184:
185: WHEN OTHERS THEN
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
187: x_return_msg := 'Unexpected error at stage: '|| l_progress;
188: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_info',
189: 'Unexpected error at stage: '|| l_progress);
190:

Line 191: x_return_status := FND_API.G_RET_STS_SUCCESS;

187: x_return_msg := 'Unexpected error at stage: '|| l_progress;
188: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_info',
189: 'Unexpected error at stage: '|| l_progress);
190:
191: x_return_status := FND_API.G_RET_STS_SUCCESS;
192:
193: END;
194:
195: -----------------------------------------------------------------------------

Line 236: x_return_status := FND_API.G_RET_STS_SUCCESS;

232: AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
233: AND RSH.APPROVAL_STATUS = 'APPROVED'
234: AND RSL.APPROVAL_STATUS in ('APPROVED');
235:
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237:
238: EXCEPTION
239:
240: WHEN OTHERS THEN

Line 241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

237:
238: EXCEPTION
239:
240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_approved',
243: 'Unexpected error occurred');
244: END;
245:

Line 288: x_return_status := FND_API.G_RET_STS_SUCCESS;

284: FROM PO_LINE_LOCATIONS_ALL POLL
285: WHERE POLL.PO_HEADER_ID = p_po_header_id;
286:
287: x_po_ordered := l_po_ordered;
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289:
290: EXCEPTION
291:
292: WHEN OTHERS THEN

Line 293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

289:
290: EXCEPTION
291:
292: WHEN OTHERS THEN
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
294: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_ordered',
295: 'Unexpected error occurred');
296:
297: END GET_PO_ORDERED;

Line 426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

422: EXCEPTION
423: WHEN NO_DATA_FOUND THEN
424: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_pay_item_progress',
425: 'No such pay item found with pay_item_id: '||p_wc_pay_item_id);
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END;
428:
429: BEGIN
430: GET_PAY_ITEM_PREV_SUBMITTED(

Line 440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

436: EXCEPTION
437: WHEN others THEN
438: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_pay_item_progress',
439: 'API GET_PAY_ITEM_PREV_SUBMITTED returns error');
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441: END;
442:
443: if(l_matching_basis = 'QUANTITY') then
444: x_progress := (l_prev_submitted+l_quantity_shipped)/l_quantity_ordered*100;

Line 449: x_return_status := FND_API.G_RET_STS_SUCCESS;

445: elsif (l_matching_basis = 'AMOUNT') then
446: x_progress := (l_prev_submitted+l_amount_shipped)/l_amount_ordered*100;
447: end if;
448:
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:
451: EXCEPTION
452:
453: WHEN USE_CASE_NOT_SUPPORTED THEN

Line 454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

450:
451: EXCEPTION
452:
453: WHEN USE_CASE_NOT_SUPPORTED THEN
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
455: x_return_msg := 'Shipment Stage: '|| p_wc_stage || ' not supported.';
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

453: WHEN USE_CASE_NOT_SUPPORTED THEN
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
455: x_return_msg := 'Shipment Stage: '|| p_wc_stage || ' not supported.';
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459:
460: WHEN others THEN
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
455: x_return_msg := 'Shipment Stage: '|| p_wc_stage || ' not supported.';
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459:
460: WHEN others THEN
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462:

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459:
460: WHEN others THEN
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462:
463: END GET_PAY_ITEM_PROGRESS;
464:
465: PROCEDURE GET_PAY_ITEM_PREV_SUBMITTED(

Line 623: x_return_status := FND_API.G_RET_STS_SUCCESS;

619: l_wf_item_key,
620: 'NOTIFY_WC_APPROVER_BLOCK',
621: 'NULL');
622:
623: x_return_status := FND_API.G_RET_STS_SUCCESS;
624:
625: EXCEPTION
626:
627: WHEN OTHERS THEN

Line 628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

624:
625: EXCEPTION
626:
627: WHEN OTHERS THEN
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: LOG(FND_LOG.LEVEL_UNEXPECTED,'complete_wc_approval_wf_block',
630: 'Unexpected error occurred');
631:
632: END COMPLETE_WC_APPROVAL_WF_BLOCK;

Line 699: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

695: p_workflow_process => 'MAIN_WCAPPRV_PROCESS',
696: p_work_confirmation_id => p_wc_header_id,
697: x_return_status => l_return_status);
698:
699: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
700: RAISE WC_APPROVAL_WF_API_FAIL;
701: END IF;
702:
703: EXCEPTION

Line 706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

702:
703: EXCEPTION
704:
705: WHEN WC_APPROVAL_WF_API_FAIL THEN
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: LOG(FND_LOG.LEVEL_UNEXPECTED,'start_approval_workflow',
708: 'pos_wcapprove_pvt.start_wf_process'|| 'returns unexpected error');
709: LOG(FND_LOG.LEVEL_UNEXPECTED,'start_approval_workflow',
710: 'WC header Id:'||p_wc_header_id);

Line 713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

709: LOG(FND_LOG.LEVEL_UNEXPECTED,'start_approval_workflow',
710: 'WC header Id:'||p_wc_header_id);
711:
712: WHEN OTHERS THEN
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: LOG(FND_LOG.LEVEL_UNEXPECTED,'start_approval_workflow',
715: 'Unexpected error occurred');
716:
717: END START_APPROVAL_WORKFLOW;