DBA Data[Home] [Help]

APPS.PA_BC_COSTING dependencies on FND_API

Line 119: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

115: * Processing related variables.
116: */
117: l_calling_module VARCHAR2(20) ;
118: l_records_affected NUMBER := 0;
119: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
120: l_error_code VARCHAR2(1000);
121: l_error_stage VARCHAR2(1000);
122: l_debug_mode VARCHAR2(1);
123: l_stage NUMBER ;

Line 357: x_error_code := FND_API.G_RET_STS_SUCCESS;

353: IF P_DEBUG_MODE = 'Y' THEN
354: PA_DEBUG.write_file('costing_fc_proc: ' || PA_DEBUG.g_err_stage);
355: END IF;
356: x_return_status := 0;
357: x_error_code := FND_API.G_RET_STS_SUCCESS;
358: x_error_stage := l_stage;
359: EXIT;
360: END IF;
361: /*

Line 621: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

617:
618: /*
619: * Check l_return_status,l_error_code,l_error_stage and take appropriate action.
620: */
621: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
622: THEN
623: pa_debug.g_err_stage := 'Error occurred while call to populate_pa_bc_packets. x_return_status [' ||
624: l_return_status || ']';
625: IF P_DEBUG_MODE = 'Y' THEN

Line 628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

624: l_return_status || ']';
625: IF P_DEBUG_MODE = 'Y' THEN
626: pa_debug.write_file('costing_fc_proc: ' || pa_debug.g_err_stage);
627: END IF;
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630:
631: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':After Inserting Records into PA_BC_PACKETS.';
632: IF P_DEBUG_MODE = 'Y' THEN

Line 668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

664: IF P_DEBUG_MODE = 'Y' THEN
665: pa_debug.write_file('costing_fc_proc: ' || pa_debug.g_err_stage);
666: END IF;
667:
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:
671: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':After calling FC API l_return_status =[' || l_return_status ||
672: '] l_error_stage = [' || l_error_stage ||

Line 695: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

691: ,x_error_code => l_error_code
692: ,x_error_stage => l_error_stage
693: );
694:
695: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
696: THEN
697: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':Error occurred while call to process_rejected_exp_items. x_return_status [' || l_return_status || ']';
698: IF P_DEBUG_MODE = 'Y' THEN
699: pa_debug.write_file('costing_fc_proc: ' || pa_debug.g_err_stage);

Line 701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

697: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':Error occurred while call to process_rejected_exp_items. x_return_status [' || l_return_status || ']';
698: IF P_DEBUG_MODE = 'Y' THEN
699: pa_debug.write_file('costing_fc_proc: ' || pa_debug.g_err_stage);
700: END IF;
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703:
704: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':After calling process_rejected_exp_items l_return_status =[' ||
705: l_return_status ||

Line 807: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

803: ,x_error_code => l_error_code
804: ,x_error_stage => l_error_stage
805: );
806:
807: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
808: THEN
809: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':Error occurred while call to map_btc_items. x_return_status [' || l_return_status || ']';
810: IF P_DEBUG_MODE = 'Y' THEN
811: pa_debug.write_file('costing_fc_proc: ' || pa_debug.g_err_stage);

Line 813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

809: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':Error occurred while call to map_btc_items. x_return_status [' || l_return_status || ']';
810: IF P_DEBUG_MODE = 'Y' THEN
811: pa_debug.write_file('costing_fc_proc: ' || pa_debug.g_err_stage);
812: END IF;
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
814: END IF;
815:
816: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
817: ':After calling map_btc_items l_return_status =[' ||

Line 835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

831: x_return_status := 0;
832: pa_debug.reset_err_stack;
833:
834: EXCEPTION
835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
836: THEN
837: IF P_DEBUG_MODE = 'Y' THEN
838: pa_debug.write_file('costing_fc_proc: ' || pa_debug.g_err_stage);
839: END IF;

Line 1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1369: THEN
1370: IF P_DEBUG_MODE = 'Y' THEN
1371: pa_debug.write_file('ErrStage['||l_stage||']map_btc_items:'||l_debug_stage);
1372: END IF;
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1374: x_error_code := TO_CHAR(SQLCODE) || SQLERRM ;
1375: x_error_stage := l_stage ;
1376: RAISE;
1377: END map_btc_items;

Line 1575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1571: EXCEPTION
1572: WHEN OTHERS
1573: THEN
1574: pa_debug.write_file('EXCEPTION:' || pa_debug.g_err_stage);
1575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1576: x_error_code := TO_CHAR(SQLCODE) || SQLERRM ;
1577: x_error_stage := l_stage ;
1578: RAISE;
1579: END; -- process_rejected_exp_items

Line 1999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1995: EXCEPTION
1996: WHEN OTHERS
1997: THEN
1998: pa_debug.write_file(pa_debug.g_err_stage);
1999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2000: x_error_code := TO_CHAR(SQLCODE) || SQLERRM ;
2001: x_error_stage := l_stage ;
2002: RAISE;
2003: END; -- populate_pa_bc_packets

Line 2262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2258: THEN
2259: IF P_DEBUG_MODE = 'Y' THEN
2260: pa_debug.write_file('validate_debit_lines: ' || pa_debug.g_err_stage);
2261: END IF;
2262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2263: x_error_code := TO_CHAR(SQLCODE) || SQLERRM ;
2264: x_error_stage := l_stage ;
2265: RAISE;
2266:

Line 2285: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

2281: * Processing related variables.
2282: */
2283: l_calling_module VARCHAR2(20) ;
2284: l_debug_mode VARCHAR2(1);
2285: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2286: l_error_code VARCHAR2(30);
2287: l_error_stage VARCHAR2(30);
2288: l_proc_name VARCHAR2(50) := 'costing_fc_proc_cwk';
2289: l_records_affected NUMBER := 0;

Line 2498: x_error_code := FND_API.G_RET_STS_SUCCESS;

2494: IF P_DEBUG_MODE = 'Y' THEN
2495: PA_DEBUG.write_file(l_proc_name || ': ' || PA_DEBUG.g_err_stage);
2496: END IF;
2497: x_return_status := 0;
2498: x_error_code := FND_API.G_RET_STS_SUCCESS;
2499: x_error_stage := l_stage;
2500: EXIT;
2501: END IF;
2502: /*

Line 2750: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

2746:
2747: /*========================+
2748: | Exception Processing. |
2749: +========================*/
2750: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2751: THEN
2752: pa_debug.g_err_stage := 'Error occurred while call to populate_pa_bc_packets. x_return_status [' ||
2753: l_return_status || ']';
2754: IF P_DEBUG_MODE = 'Y' THEN

Line 2757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2753: l_return_status || ']';
2754: IF P_DEBUG_MODE = 'Y' THEN
2755: pa_debug.write_file(l_proc_name || ':' || pa_debug.g_err_stage);
2756: END IF;
2757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2758: END IF;
2759:
2760: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':After Inserting Records into PA_BC_PACKETS.';
2761: IF P_DEBUG_MODE = 'Y' THEN

Line 2817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2813: IF P_DEBUG_MODE = 'Y' THEN
2814: pa_debug.write_file('costing_fc_proc: ' || pa_debug.g_err_stage);
2815: END IF;
2816:
2817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2818: END IF;
2819:
2820: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':After calling FC API l_return_status =[' || l_return_status ||
2821: '] l_error_stage = [' || l_error_stage ||

Line 2838: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

2834: ,x_error_code => l_error_code
2835: ,x_error_stage => l_error_stage
2836: );
2837:
2838: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2839: THEN
2840: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':Error while call to process_rejected_exp_items. x_return_status ['
2841: || l_return_status || ']';
2842: IF P_DEBUG_MODE = 'Y' THEN

Line 2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2841: || l_return_status || ']';
2842: IF P_DEBUG_MODE = 'Y' THEN
2843: pa_debug.write_file(l_proc_name || ':' || pa_debug.g_err_stage);
2844: END IF;
2845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2846: END IF;
2847:
2848: pa_debug.g_err_stage := 'After calling process_rejected_exp_items l_return_status =[' ||
2849: l_return_status ||

Line 2950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

2946: x_return_status := 0;
2947: pa_debug.reset_err_stack;
2948:
2949: EXCEPTION
2950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2951: THEN
2952: IF P_DEBUG_MODE = 'Y' THEN
2953: pa_debug.write_file(l_proc_name || ': ' || TO_CHAR(l_stage) || ': ' || pa_debug.g_err_stage);
2954: END IF;

Line 4058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4054: EXCEPTION
4055: WHEN OTHERS
4056: THEN
4057: pa_debug.write_file(l_stage || pa_debug.g_err_stage);
4058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4059: x_error_code := TO_CHAR(SQLCODE) || SQLERRM ;
4060: x_error_stage := l_stage ;
4061: RAISE;
4062: END; -- populate_pa_bc_packets_cwk