DBA Data[Home] [Help]

APPS.OKL_CASH_RECEIPT dependencies on OKC_API

Line 9: ,p_init_msg_list IN VARCHAR2 := OKC_API.G_FALSE

5: -- PROCEDURE cash_receipt
6: ---------------------------------------------------------------------------
7:
8: PROCEDURE CASH_RECEIPT (p_api_version IN NUMBER := 1.0
9: ,p_init_msg_list IN VARCHAR2 := OKC_API.G_FALSE
10: ,x_return_status OUT NOCOPY VARCHAR2
11: ,x_msg_count OUT NOCOPY NUMBER
12: ,x_msg_data OUT NOCOPY VARCHAR2
13: ,p_over_pay IN VARCHAR2

Line 152: OKC_API.set_message( p_app_name => G_APP_NAME,

148:
149: IF c_get_gl_date%NOTFOUND THEN
150: CLOSE c_get_gl_date;
151:
152: OKC_API.set_message( p_app_name => G_APP_NAME,
153: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
154: p_token1 => 'TRX_DATE',
155: p_token1_value => TRUNC(SYSDATE));
156:

Line 157: l_return_status := OKC_API.G_RET_STS_ERROR;

153: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
154: p_token1 => 'TRX_DATE',
155: p_token1_value => TRUNC(SYSDATE));
156:
157: l_return_status := OKC_API.G_RET_STS_ERROR;
158: RAISE G_EXCEPTION_HALT_VALIDATION;
159: END IF;
160: CLOSE c_get_gl_date;
161:

Line 313: OKC_API.set_message( p_app_name => G_APP_NAME,

309: FETCH c_get_gl_date INTO l_inv_gl_date, l_counter;
310:
311: IF c_get_gl_date%NOTFOUND THEN
312: CLOSE c_get_gl_date;
313: OKC_API.set_message( p_app_name => G_APP_NAME,
314: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
315: p_token1 => 'TRX_DATE',
316: p_token1_value => TRUNC(l_xcav_tbl(i).trx_date));
317:

Line 318: l_return_status := OKC_API.G_RET_STS_ERROR;

314: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
315: p_token1 => 'TRX_DATE',
316: p_token1_value => TRUNC(l_xcav_tbl(i).trx_date));
317:
318: l_return_status := OKC_API.G_RET_STS_ERROR;
319: RAISE G_EXCEPTION_HALT_VALIDATION;
320: END IF;
321: CLOSE c_get_gl_date;
322:

Line 391: x_return_status := OKC_API.G_RET_STS_ERROR;

387:
388: EXCEPTION
389:
390: WHEN G_EXCEPTION_HALT_VALIDATION THEN
391: x_return_status := OKC_API.G_RET_STS_ERROR;
392:
393:
394: WHEN OKC_API.G_EXCEPTION_ERROR THEN
395: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 394: WHEN OKC_API.G_EXCEPTION_ERROR THEN

390: WHEN G_EXCEPTION_HALT_VALIDATION THEN
391: x_return_status := OKC_API.G_RET_STS_ERROR;
392:
393:
394: WHEN OKC_API.G_EXCEPTION_ERROR THEN
395: x_return_status := OKC_API.HANDLE_EXCEPTIONS
396: (
397: l_api_name,
398: G_PKG_NAME,

Line 395: x_return_status := OKC_API.HANDLE_EXCEPTIONS

391: x_return_status := OKC_API.G_RET_STS_ERROR;
392:
393:
394: WHEN OKC_API.G_EXCEPTION_ERROR THEN
395: x_return_status := OKC_API.HANDLE_EXCEPTIONS
396: (
397: l_api_name,
398: G_PKG_NAME,
399: 'OKC_API.G_RET_STS_ERROR',

Line 399: 'OKC_API.G_RET_STS_ERROR',

395: x_return_status := OKC_API.HANDLE_EXCEPTIONS
396: (
397: l_api_name,
398: G_PKG_NAME,
399: 'OKC_API.G_RET_STS_ERROR',
400: x_msg_count,
401: x_msg_data,
402: '_PVT'
403: );

Line 420: ,p_init_msg_list IN VARCHAR2 := OKC_API.G_FALSE

416: */
417: END CASH_RECEIPT;
418:
419: PROCEDURE CREATE_RECEIPT (p_api_version IN NUMBER := 1.0
420: ,p_init_msg_list IN VARCHAR2 := OKC_API.G_FALSE
421: ,x_return_status OUT NOCOPY VARCHAR2
422: ,x_msg_count OUT NOCOPY NUMBER
423: ,x_msg_data OUT NOCOPY VARCHAR2
424: ,p_rcpt_rec IN OKL_CASH_APPL_RULES.rcpt_rec_type

Line 539: WHEN OKC_API.G_EXCEPTION_ERROR THEN

535: WHEN G_EXCEPTION_HALT_VALIDATION THEN
536: ROLLBACK TO create_receipt;
537: x_return_status := OKL_API.G_RET_STS_ERROR;
538:
539: WHEN OKC_API.G_EXCEPTION_ERROR THEN
540: ROLLBACK TO create_receipt;
541: x_return_status := OKL_API.HANDLE_EXCEPTIONS
542: (
543: l_api_name,

Line 545: 'OKC_API.G_RET_STS_ERROR',

541: x_return_status := OKL_API.HANDLE_EXCEPTIONS
542: (
543: l_api_name,
544: G_PKG_NAME,
545: 'OKC_API.G_RET_STS_ERROR',
546: x_msg_count,
547: x_msg_data,
548: '_PVT'
549: );

Line 555: ,p_init_msg_list IN VARCHAR2 := OKC_API.G_FALSE

551: END CREATE_RECEIPT;
552:
553:
554: PROCEDURE PAYMENT_RECEIPT (p_api_version IN NUMBER := 1.0
555: ,p_init_msg_list IN VARCHAR2 := OKC_API.G_FALSE
556: ,x_return_status OUT NOCOPY VARCHAR2
557: ,x_msg_count OUT NOCOPY NUMBER
558: ,x_msg_data OUT NOCOPY VARCHAR2
559: ,p_over_pay IN VARCHAR2

Line 722: OKC_API.set_message( p_app_name => G_APP_NAME,

718:
719: IF c_get_gl_date%NOTFOUND THEN
720: CLOSE c_get_gl_date;
721:
722: OKC_API.set_message( p_app_name => G_APP_NAME,
723: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
724: p_token1 => 'TRX_DATE',
725: p_token1_value => TRUNC(SYSDATE));
726:

Line 727: l_return_status := OKC_API.G_RET_STS_ERROR;

723: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
724: p_token1 => 'TRX_DATE',
725: p_token1_value => TRUNC(SYSDATE));
726:
727: l_return_status := OKC_API.G_RET_STS_ERROR;
728: RAISE G_EXCEPTION_HALT_VALIDATION;
729: END IF;
730: CLOSE c_get_gl_date;
731:

Line 751: OKC_API.set_message( p_app_name => G_APP_NAME,

747:
748: IF c_get_gl_date_start%NOTFOUND THEN
749: CLOSE c_get_gl_date_start;
750:
751: OKC_API.set_message( p_app_name => G_APP_NAME,
752: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
753: p_token1 => 'TRX_DATE',
754: p_token1_value => TRUNC(SYSDATE));
755:

Line 756: l_return_status := OKC_API.G_RET_STS_ERROR;

752: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
753: p_token1 => 'TRX_DATE',
754: p_token1_value => TRUNC(SYSDATE));
755:
756: l_return_status := OKC_API.G_RET_STS_ERROR;
757: RAISE G_EXCEPTION_HALT_VALIDATION;
758: END IF;
759: CLOSE c_get_gl_date_start;
760: END IF;

Line 848: OKC_API.set_message( p_app_name => G_APP_NAME,

844:
845: IF c_get_gl_date%NOTFOUND THEN
846: CLOSE c_get_gl_date;
847:
848: OKC_API.set_message( p_app_name => G_APP_NAME,
849: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
850: p_token1 => 'TRX_DATE',
851: p_token1_value => TRUNC(l_xcav_tbl(i).trx_date));
852:

Line 853: l_return_status := OKC_API.G_RET_STS_ERROR;

849: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
850: p_token1 => 'TRX_DATE',
851: p_token1_value => TRUNC(l_xcav_tbl(i).trx_date));
852:
853: l_return_status := OKC_API.G_RET_STS_ERROR;
854: RAISE G_EXCEPTION_HALT_VALIDATION;
855: END IF;
856: CLOSE c_get_gl_date;
857: ELSE

Line 934: OKC_API.set_message( p_app_name => G_APP_NAME,

930: FETCH c_get_gl_date INTO l_gl_date, l_counter;
931:
932: IF c_get_gl_date%NOTFOUND THEN
933: CLOSE c_get_gl_date;
934: OKC_API.set_message( p_app_name => G_APP_NAME,
935: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
936: p_token1 => 'TRX_DATE',
937: p_token1_value => TRUNC(l_xcav_tbl(i).trx_date));
938:

Line 939: l_return_status := OKC_API.G_RET_STS_ERROR;

935: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
936: p_token1 => 'TRX_DATE',
937: p_token1_value => TRUNC(l_xcav_tbl(i).trx_date));
938:
939: l_return_status := OKC_API.G_RET_STS_ERROR;
940: RAISE G_EXCEPTION_HALT_VALIDATION;
941: END IF;
942: CLOSE c_get_gl_date;
943: ELSE

Line 1023: x_return_status := OKC_API.G_RET_STS_ERROR;

1019:
1020: EXCEPTION
1021:
1022: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1023: x_return_status := OKC_API.G_RET_STS_ERROR;
1024:
1025:
1026: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1027: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1026: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1022: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1023: x_return_status := OKC_API.G_RET_STS_ERROR;
1024:
1025:
1026: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1027: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1028: (
1029: l_api_name,
1030: G_PKG_NAME,

Line 1027: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1023: x_return_status := OKC_API.G_RET_STS_ERROR;
1024:
1025:
1026: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1027: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1028: (
1029: l_api_name,
1030: G_PKG_NAME,
1031: 'OKC_API.G_RET_STS_ERROR',

Line 1031: 'OKC_API.G_RET_STS_ERROR',

1027: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1028: (
1029: l_api_name,
1030: G_PKG_NAME,
1031: 'OKC_API.G_RET_STS_ERROR',
1032: x_msg_count,
1033: x_msg_data,
1034: '_PVT'
1035: );