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.PA_CI_DIR_COST_PUB dependencies on PA_API

Line 40: l_return_status VARCHAR2(1) := PA_API.G_RET_STS_SUCCESS;

36: p_change_description IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_2000_TBL_TYPE()) IS
37:
38: l_api_version number := 1;
39: l_api_name CONSTANT VARCHAR2(30) := 'PUB.insert_row';
40: l_return_status VARCHAR2(1) := PA_API.G_RET_STS_SUCCESS;
41: l_msg_count number;
42: l_msg_data varchar2(2000);
43:
44: l_dc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 147: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN

143: x_msg_data => l_msg_data,
144: PPaCiDirectCostDetailsTbl => l_PaCiDirCostDetTbl,
145: XPaCiDirectCostDetailsTbl => x_PaCiDirCostDetTbl);
146:
147: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
150: RAISE PA_API.G_EXCEPTION_ERROR;
151: END IF;

Line 148: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;

144: PPaCiDirectCostDetailsTbl => l_PaCiDirCostDetTbl,
145: XPaCiDirectCostDetailsTbl => x_PaCiDirCostDetTbl);
146:
147: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
150: RAISE PA_API.G_EXCEPTION_ERROR;
151: END IF;
152:

Line 149: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN

145: XPaCiDirectCostDetailsTbl => x_PaCiDirCostDetTbl);
146:
147: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
150: RAISE PA_API.G_EXCEPTION_ERROR;
151: END IF;
152:
153: pa_process_ci_lines_pkg.process_planning_lines(

Line 150: RAISE PA_API.G_EXCEPTION_ERROR;

146:
147: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
150: RAISE PA_API.G_EXCEPTION_ERROR;
151: END IF;
152:
153: pa_process_ci_lines_pkg.process_planning_lines(
154: p_api_version => l_api_version,

Line 173: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN

169: p_quantity_tbl => p_quantity_tbl,
170: p_raw_cost_tbl => p_raw_cost_tbl
171: );
172:
173: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
176: RAISE PA_API.G_EXCEPTION_ERROR;
177: END IF;

Line 174: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;

170: p_raw_cost_tbl => p_raw_cost_tbl
171: );
172:
173: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
176: RAISE PA_API.G_EXCEPTION_ERROR;
177: END IF;
178:

Line 175: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN

171: );
172:
173: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
176: RAISE PA_API.G_EXCEPTION_ERROR;
177: END IF;
178:
179: forall i in l_dc_line_id_tbl.first..l_dc_line_id_tbl.last

Line 176: RAISE PA_API.G_EXCEPTION_ERROR;

172:
173: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
176: RAISE PA_API.G_EXCEPTION_ERROR;
177: END IF;
178:
179: forall i in l_dc_line_id_tbl.first..l_dc_line_id_tbl.last
180: update pa_ci_direct_cost_details pcdc

Line 207: PA_API.END_ACTIVITY(l_msg_count, l_msg_data);

203: and dc_line_id = l_dc_line_id_tbl(i);
204:
205: end if;
206:
207: PA_API.END_ACTIVITY(l_msg_count, l_msg_data);
208: x_return_status := PA_API.G_RET_STS_SUCCESS;
209:
210: EXCEPTION
211:

Line 208: x_return_status := PA_API.G_RET_STS_SUCCESS;

204:
205: end if;
206:
207: PA_API.END_ACTIVITY(l_msg_count, l_msg_data);
208: x_return_status := PA_API.G_RET_STS_SUCCESS;
209:
210: EXCEPTION
211:
212: WHEN PA_API.G_EXCEPTION_ERROR THEN

Line 212: WHEN PA_API.G_EXCEPTION_ERROR THEN

208: x_return_status := PA_API.G_RET_STS_SUCCESS;
209:
210: EXCEPTION
211:
212: WHEN PA_API.G_EXCEPTION_ERROR THEN
213: ROLLBACK TO SAVEPOINT PUB_INSERT_ROW;
214:
215: FND_MSG_PUB.Count_And_Get
216: (p_count => x_msg_count,

Line 220: WHEN PA_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

216: (p_count => x_msg_count,
217: p_data => x_msg_data);
218: x_return_status := l_return_status;
219:
220: WHEN PA_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
221:
222: ROLLBACK TO SAVEPOINT PUB_INSERT_ROW;
223:
224: FND_MSG_PUB.Count_And_Get

Line 282: l_return_status VARCHAR2(1) := PA_API.G_RET_STS_SUCCESS;

278: p_change_description IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE) IS
279:
280: l_api_version number := 1;
281: l_api_name CONSTANT VARCHAR2(30) := 'Pub.update_row';
282: l_return_status VARCHAR2(1) := PA_API.G_RET_STS_SUCCESS;
283: l_msg_count number;
284: l_msg_data varchar2(2000);
285: l_PaCiDirCostDetTbl PaCiDirCostTblType;
286: x_PaCiDirCostDetTbl PaCiDirCostTblType;

Line 362: l_PaCiDirCostDetTbl(i).quantity := PA_API.G_MISS_NUM;

358:
359: if p_quantity_tbl.exists(i) then
360: l_PaCiDirCostDetTbl(i).quantity := p_quantity_tbl(i);
361: else
362: l_PaCiDirCostDetTbl(i).quantity := PA_API.G_MISS_NUM;
363: end if;
364:
365: if p_planning_resource_rate_tbl.exists(i) then
366: l_PaCiDirCostDetTbl(i).planning_resource_rate := p_planning_resource_rate_tbl(i);

Line 368: l_PaCiDirCostDetTbl(i).planning_resource_rate := PA_API.G_MISS_NUM;

364:
365: if p_planning_resource_rate_tbl.exists(i) then
366: l_PaCiDirCostDetTbl(i).planning_resource_rate := p_planning_resource_rate_tbl(i);
367: else
368: l_PaCiDirCostDetTbl(i).planning_resource_rate := PA_API.G_MISS_NUM;
369: end if;
370:
371: if p_raw_cost_tbl.exists(i) then
372: l_PaCiDirCostDetTbl(i).raw_cost := p_raw_cost_tbl(i);

Line 374: l_PaCiDirCostDetTbl(i).raw_cost := PA_API.G_MISS_NUM;

370:
371: if p_raw_cost_tbl.exists(i) then
372: l_PaCiDirCostDetTbl(i).raw_cost := p_raw_cost_tbl(i);
373: else
374: l_PaCiDirCostDetTbl(i).raw_cost := PA_API.G_MISS_NUM;
375: end if;
376:
377: l_PaCiDirCostDetTbl(i).burdened_cost := PA_API.G_MISS_NUM;
378: l_PaCiDirCostDetTbl(i).raw_cost_rate := PA_API.G_MISS_NUM;

Line 377: l_PaCiDirCostDetTbl(i).burdened_cost := PA_API.G_MISS_NUM;

373: else
374: l_PaCiDirCostDetTbl(i).raw_cost := PA_API.G_MISS_NUM;
375: end if;
376:
377: l_PaCiDirCostDetTbl(i).burdened_cost := PA_API.G_MISS_NUM;
378: l_PaCiDirCostDetTbl(i).raw_cost_rate := PA_API.G_MISS_NUM;
379: l_PaCiDirCostDetTbl(i).burden_cost_rate := PA_API.G_MISS_NUM;
380: l_PaCiDirCostDetTbl(i).resource_assignment_id := PA_API.G_MISS_NUM;
381: l_PaCiDirCostDetTbl(i).effective_from := p_effective_from_tbl(i);

Line 378: l_PaCiDirCostDetTbl(i).raw_cost_rate := PA_API.G_MISS_NUM;

374: l_PaCiDirCostDetTbl(i).raw_cost := PA_API.G_MISS_NUM;
375: end if;
376:
377: l_PaCiDirCostDetTbl(i).burdened_cost := PA_API.G_MISS_NUM;
378: l_PaCiDirCostDetTbl(i).raw_cost_rate := PA_API.G_MISS_NUM;
379: l_PaCiDirCostDetTbl(i).burden_cost_rate := PA_API.G_MISS_NUM;
380: l_PaCiDirCostDetTbl(i).resource_assignment_id := PA_API.G_MISS_NUM;
381: l_PaCiDirCostDetTbl(i).effective_from := p_effective_from_tbl(i);
382: l_PaCiDirCostDetTbl(i).effective_to := p_effective_to_tbl(i);

Line 379: l_PaCiDirCostDetTbl(i).burden_cost_rate := PA_API.G_MISS_NUM;

375: end if;
376:
377: l_PaCiDirCostDetTbl(i).burdened_cost := PA_API.G_MISS_NUM;
378: l_PaCiDirCostDetTbl(i).raw_cost_rate := PA_API.G_MISS_NUM;
379: l_PaCiDirCostDetTbl(i).burden_cost_rate := PA_API.G_MISS_NUM;
380: l_PaCiDirCostDetTbl(i).resource_assignment_id := PA_API.G_MISS_NUM;
381: l_PaCiDirCostDetTbl(i).effective_from := p_effective_from_tbl(i);
382: l_PaCiDirCostDetTbl(i).effective_to := p_effective_to_tbl(i);
383:

Line 380: l_PaCiDirCostDetTbl(i).resource_assignment_id := PA_API.G_MISS_NUM;

376:
377: l_PaCiDirCostDetTbl(i).burdened_cost := PA_API.G_MISS_NUM;
378: l_PaCiDirCostDetTbl(i).raw_cost_rate := PA_API.G_MISS_NUM;
379: l_PaCiDirCostDetTbl(i).burden_cost_rate := PA_API.G_MISS_NUM;
380: l_PaCiDirCostDetTbl(i).resource_assignment_id := PA_API.G_MISS_NUM;
381: l_PaCiDirCostDetTbl(i).effective_from := p_effective_from_tbl(i);
382: l_PaCiDirCostDetTbl(i).effective_to := p_effective_to_tbl(i);
383:
384: if p_change_reason_code.exists(i) then

Line 407: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN

403: x_msg_data => l_msg_data,
404: PPaCiDirectCostDetailsTbl => l_PaCiDirCostDetTbl,
405: XPaCiDirectCostDetailsTbl => x_PaCiDirCostDetTbl);
406:
407: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
408: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
409: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
410: RAISE PA_API.G_EXCEPTION_ERROR;
411: END IF;

Line 408: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;

404: PPaCiDirectCostDetailsTbl => l_PaCiDirCostDetTbl,
405: XPaCiDirectCostDetailsTbl => x_PaCiDirCostDetTbl);
406:
407: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
408: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
409: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
410: RAISE PA_API.G_EXCEPTION_ERROR;
411: END IF;
412:

Line 409: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN

405: XPaCiDirectCostDetailsTbl => x_PaCiDirCostDetTbl);
406:
407: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
408: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
409: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
410: RAISE PA_API.G_EXCEPTION_ERROR;
411: END IF;
412:
413: k := 0;

Line 410: RAISE PA_API.G_EXCEPTION_ERROR;

406:
407: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
408: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
409: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
410: RAISE PA_API.G_EXCEPTION_ERROR;
411: END IF;
412:
413: k := 0;
414: for i in budget_impact_tbl.first..budget_impact_tbl.last loop

Line 465: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN

461: p_quantity_tbl => b_quantity_tbl,
462: p_raw_cost_tbl => b_raw_cost_tbl
463: );
464:
465: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
468: RAISE PA_API.G_EXCEPTION_ERROR;
469: END IF;

Line 466: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;

462: p_raw_cost_tbl => b_raw_cost_tbl
463: );
464:
465: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
468: RAISE PA_API.G_EXCEPTION_ERROR;
469: END IF;
470: /*

Line 467: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN

463: );
464:
465: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
468: RAISE PA_API.G_EXCEPTION_ERROR;
469: END IF;
470: /*
471: forall i in b_task_id_tbl.first..b_task_id_tbl.last

Line 468: RAISE PA_API.G_EXCEPTION_ERROR;

464:
465: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
468: RAISE PA_API.G_EXCEPTION_ERROR;
469: END IF;
470: /*
471: forall i in b_task_id_tbl.first..b_task_id_tbl.last
472: update pa_ci_direct_cost_details pcdc

Line 501: PA_API.END_ACTIVITY(l_msg_count, l_msg_data);

497: end if;
498:
499: end if;
500:
501: PA_API.END_ACTIVITY(l_msg_count, l_msg_data);
502: x_return_status := PA_API.G_RET_STS_SUCCESS;
503:
504: EXCEPTION
505:

Line 502: x_return_status := PA_API.G_RET_STS_SUCCESS;

498:
499: end if;
500:
501: PA_API.END_ACTIVITY(l_msg_count, l_msg_data);
502: x_return_status := PA_API.G_RET_STS_SUCCESS;
503:
504: EXCEPTION
505:
506: WHEN PA_API.G_EXCEPTION_ERROR THEN

Line 506: WHEN PA_API.G_EXCEPTION_ERROR THEN

502: x_return_status := PA_API.G_RET_STS_SUCCESS;
503:
504: EXCEPTION
505:
506: WHEN PA_API.G_EXCEPTION_ERROR THEN
507:
508: ROLLBACK TO SAVEPOINT PUB_UPDATE_ROW;
509:
510: FND_MSG_PUB.Count_And_Get

Line 515: WHEN PA_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

511: (p_count => x_msg_count,
512: p_data => x_msg_data);
513: x_return_status := l_return_status;
514:
515: WHEN PA_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
516:
517: ROLLBACK TO SAVEPOINT PUB_UPDATE_ROW;
518:
519: FND_MSG_PUB.Count_And_Get

Line 565: l_return_status VARCHAR2(1) := PA_API.G_RET_STS_SUCCESS;

561: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE) IS
562:
563: l_api_version number := 1;
564: l_api_name CONSTANT VARCHAR2(30) := 'Pub.delete_row';
565: l_return_status VARCHAR2(1) := PA_API.G_RET_STS_SUCCESS;
566: l_msg_count number;
567: l_msg_data varchar2(2000);
568: l_PaCiDirCostDetTbl PaCiDirCostTblType;
569:

Line 597: l_PaCiDirCostDetTbl(i).quantity := PA_API.G_MISS_NUM;

593: l_PaCiDirCostDetTbl(i).task_id := p_task_id_tbl(i);
594: l_PaCiDirCostDetTbl(i).expenditure_type := p_expenditure_type_tbl(i);
595: l_PaCiDirCostDetTbl(i).resource_list_member_id := p_rlmi_id_tbl(i);
596: l_PaCiDirCostDetTbl(i).currency_code := p_currency_code_tbl(i);
597: l_PaCiDirCostDetTbl(i).quantity := PA_API.G_MISS_NUM;
598: l_PaCiDirCostDetTbl(i).raw_cost := PA_API.G_MISS_NUM;
599: l_resource_assignment_id_tbl.extend(1);
600: l_resource_assignment_id_tbl(i) := null;
601: end loop;

Line 598: l_PaCiDirCostDetTbl(i).raw_cost := PA_API.G_MISS_NUM;

594: l_PaCiDirCostDetTbl(i).expenditure_type := p_expenditure_type_tbl(i);
595: l_PaCiDirCostDetTbl(i).resource_list_member_id := p_rlmi_id_tbl(i);
596: l_PaCiDirCostDetTbl(i).currency_code := p_currency_code_tbl(i);
597: l_PaCiDirCostDetTbl(i).quantity := PA_API.G_MISS_NUM;
598: l_PaCiDirCostDetTbl(i).raw_cost := PA_API.G_MISS_NUM;
599: l_resource_assignment_id_tbl.extend(1);
600: l_resource_assignment_id_tbl(i) := null;
601: end loop;
602:

Line 611: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN

607: x_msg_count => l_msg_count,
608: x_msg_data => l_msg_data,
609: PPaCiDirectCostDetailsTbl => l_PaCiDirCostDetTbl);
610:
611: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
614: RAISE PA_API.G_EXCEPTION_ERROR;
615: END IF;

Line 612: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;

608: x_msg_data => l_msg_data,
609: PPaCiDirectCostDetailsTbl => l_PaCiDirCostDetTbl);
610:
611: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
614: RAISE PA_API.G_EXCEPTION_ERROR;
615: END IF;
616:

Line 613: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN

609: PPaCiDirectCostDetailsTbl => l_PaCiDirCostDetTbl);
610:
611: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
614: RAISE PA_API.G_EXCEPTION_ERROR;
615: END IF;
616:
617: pa_process_ci_lines_pkg.process_planning_lines(

Line 614: RAISE PA_API.G_EXCEPTION_ERROR;

610:
611: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
614: RAISE PA_API.G_EXCEPTION_ERROR;
615: END IF;
616:
617: pa_process_ci_lines_pkg.process_planning_lines(
618: p_api_version => l_api_version,

Line 635: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN

631: p_rlmi_id_tbl => p_rlmi_id_tbl,
632: p_res_assgn_id_tbl => l_resource_assignment_id_tbl
633: );
634:
635: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
636: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
637: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
638: RAISE PA_API.G_EXCEPTION_ERROR;
639: END IF;

Line 636: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;

632: p_res_assgn_id_tbl => l_resource_assignment_id_tbl
633: );
634:
635: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
636: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
637: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
638: RAISE PA_API.G_EXCEPTION_ERROR;
639: END IF;
640:

Line 637: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN

633: );
634:
635: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
636: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
637: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
638: RAISE PA_API.G_EXCEPTION_ERROR;
639: END IF;
640:
641: end if;

Line 638: RAISE PA_API.G_EXCEPTION_ERROR;

634:
635: IF (l_return_status = PA_API.G_RET_STS_UNEXP_ERROR) THEN
636: RAISE PA_API.G_EXCEPTION_UNEXPECTED_ERROR;
637: ELSIF (l_return_status = PA_API.G_RET_STS_ERROR) THEN
638: RAISE PA_API.G_EXCEPTION_ERROR;
639: END IF;
640:
641: end if;
642:

Line 643: PA_API.END_ACTIVITY(l_msg_count, l_msg_data);

639: END IF;
640:
641: end if;
642:
643: PA_API.END_ACTIVITY(l_msg_count, l_msg_data);
644: x_return_status := PA_API.G_RET_STS_SUCCESS;
645:
646: EXCEPTION
647: WHEN PA_API.G_EXCEPTION_ERROR THEN

Line 644: x_return_status := PA_API.G_RET_STS_SUCCESS;

640:
641: end if;
642:
643: PA_API.END_ACTIVITY(l_msg_count, l_msg_data);
644: x_return_status := PA_API.G_RET_STS_SUCCESS;
645:
646: EXCEPTION
647: WHEN PA_API.G_EXCEPTION_ERROR THEN
648:

Line 647: WHEN PA_API.G_EXCEPTION_ERROR THEN

643: PA_API.END_ACTIVITY(l_msg_count, l_msg_data);
644: x_return_status := PA_API.G_RET_STS_SUCCESS;
645:
646: EXCEPTION
647: WHEN PA_API.G_EXCEPTION_ERROR THEN
648:
649: ROLLBACK TO SAVEPOINT PUB_DELETE_ROW;
650:
651: FND_MSG_PUB.Count_And_Get

Line 656: WHEN PA_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

652: (p_count => x_msg_count,
653: p_data => x_msg_data);
654: x_return_status := l_return_status;
655:
656: WHEN PA_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
657:
658: ROLLBACK TO SAVEPOINT PUB_DELETE_ROW;
659:
660: FND_MSG_PUB.Count_And_Get