APPS.OKL_PROCESS_TRX_TYPES_PVT dependencies on OKC_API

Line 25: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

21:
22: IS
23:
24: l_api_version NUMBER := 1.0;
25: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
26: l_api_name VARCHAR2(30) := 'INSERT_TRX_TYPES';
27:
28: BEGIN
29:

Line 51: (p_tryv_rec.name = OKC_API.G_MISS_CHAR) THEN

47:
48: -- 08/30/2002 Added by Santonyr if check to see if the name is not null
49:
50: IF (p_tryv_rec.name IS NULL) OR
51: (p_tryv_rec.name = OKC_API.G_MISS_CHAR) THEN
52: OKC_API.SET_MESSAGE(p_app_name => 'OKL',
53: p_msg_name => 'OKL_NAME_REQUIRED' );
54:
55: RAISE G_EXCEPTION_ERROR;

Line 52: OKC_API.SET_MESSAGE(p_app_name => 'OKL',

48: -- 08/30/2002 Added by Santonyr if check to see if the name is not null
49:
50: IF (p_tryv_rec.name IS NULL) OR
51: (p_tryv_rec.name = OKC_API.G_MISS_CHAR) THEN
52: OKC_API.SET_MESSAGE(p_app_name => 'OKL',
53: p_msg_name => 'OKL_NAME_REQUIRED' );
54:
55: RAISE G_EXCEPTION_ERROR;
56: END IF;

Line 115: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

111: IS
112:
113: l_api_version NUMBER := 1.0;
114: l_api_name VARCHAR2(30) := 'INSERT_TRX_TYPES';
115: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
116: i NUMBER;
117:
118: BEGIN
119:

Line 142: (p_tryv_tbl(i).name = OKC_API.G_MISS_CHAR) THEN

138: IF (p_tryv_tbl.COUNT > 0) THEN
139: i := p_tryv_tbl.FIRST;
140: LOOP
141: IF (p_tryv_tbl(i).name IS NULL) OR
142: (p_tryv_tbl(i).name = OKC_API.G_MISS_CHAR) THEN
143: OKC_API.SET_MESSAGE(p_app_name => 'OKL',
144: p_msg_name => 'OKL_NAME_REQUIRED' );
145:
146: RAISE G_EXCEPTION_ERROR;

Line 143: OKC_API.SET_MESSAGE(p_app_name => 'OKL',

139: i := p_tryv_tbl.FIRST;
140: LOOP
141: IF (p_tryv_tbl(i).name IS NULL) OR
142: (p_tryv_tbl(i).name = OKC_API.G_MISS_CHAR) THEN
143: OKC_API.SET_MESSAGE(p_app_name => 'OKL',
144: p_msg_name => 'OKL_NAME_REQUIRED' );
145:
146: RAISE G_EXCEPTION_ERROR;
147: END IF;

Line 245: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

241:
242: IS
243:
244: l_api_version NUMBER := 1.0;
245: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
246: l_update_allowed VARCHAR2(1) := 'Y';
247: l_api_name VARCHAR2(30) := 'UPDATE_TRX_TYPES';
248:
249:

Line 272: (p_tryv_rec.name = OKC_API.G_MISS_CHAR) THEN

268:
269: -- 08/30/2002 Added by Santonyr Mandatory Check for Name
270:
271: IF (p_tryv_rec.name IS NULL) OR
272: (p_tryv_rec.name = OKC_API.G_MISS_CHAR) THEN
273: OKC_API.SET_MESSAGE(p_app_name => 'OKL',
274: p_msg_name => 'OKL_NAME_REQUIRED' );
275:
276: RAISE G_EXCEPTION_ERROR;

Line 273: OKC_API.SET_MESSAGE(p_app_name => 'OKL',

269: -- 08/30/2002 Added by Santonyr Mandatory Check for Name
270:
271: IF (p_tryv_rec.name IS NULL) OR
272: (p_tryv_rec.name = OKC_API.G_MISS_CHAR) THEN
273: OKC_API.SET_MESSAGE(p_app_name => 'OKL',
274: p_msg_name => 'OKL_NAME_REQUIRED' );
275:
276: RAISE G_EXCEPTION_ERROR;
277: END IF;

Line 285: OKC_API.SET_MESSAGE(p_app_name => 'OKL',

281:
282: l_update_allowed := Check_Update_Allowed(p_tryv_rec);
283:
284: IF l_update_allowed = 'N' THEN
285: OKC_API.SET_MESSAGE(p_app_name => 'OKL',
286: p_msg_name => 'OKL_NO_UPD_TRX_TYPE' );
287: RAISE G_EXCEPTION_ERROR;
288: END IF;
289:

Line 350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

346: IS
347:
348: l_api_version NUMBER := 1.0;
349: l_update_allowed VARCHAR2(1) := 'Y';
350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
351: l_api_name VARCHAR2(30) := 'UPDATE_TRX_TYPES';
352: i NUMBER;
353:
354: BEGIN

Line 379: (p_tryv_tbl(i).name = OKC_API.G_MISS_CHAR) THEN

375: i := p_tryv_tbl.FIRST;
376:
377: LOOP
378: IF (p_tryv_tbl(i).name IS NULL) OR
379: (p_tryv_tbl(i).name = OKC_API.G_MISS_CHAR) THEN
380: OKC_API.SET_MESSAGE(p_app_name => 'OKL',
381: p_msg_name => 'OKL_NAME_REQUIRED' );
382:
383: RAISE G_EXCEPTION_ERROR;

Line 380: OKC_API.SET_MESSAGE(p_app_name => 'OKL',

376:
377: LOOP
378: IF (p_tryv_tbl(i).name IS NULL) OR
379: (p_tryv_tbl(i).name = OKC_API.G_MISS_CHAR) THEN
380: OKC_API.SET_MESSAGE(p_app_name => 'OKL',
381: p_msg_name => 'OKL_NAME_REQUIRED' );
382:
383: RAISE G_EXCEPTION_ERROR;
384: END IF;

Line 391: OKC_API.SET_MESSAGE(p_app_name => 'OKL',

387:
388: l_update_allowed := Check_Update_Allowed(p_tryv_tbl(i));
389:
390: IF l_update_allowed = 'N' THEN
391: OKC_API.SET_MESSAGE(p_app_name => 'OKL',
392: p_msg_name => 'OKL_NO_UPD_TRX_TYPE' );
393: RAISE G_EXCEPTION_ERROR;
394: END IF;
395:

Line 459: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

455: IS
456:
457: l_api_version NUMBER := 1.0;
458: l_api_name VARCHAR2(30) := 'DELETE_TRX_TYPES';
459: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
460:
461: BEGIN
462:
463: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 537: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

533: IS
534:
535: l_api_version NUMBER := 1.0;
536: l_api_name VARCHAR2(30) := 'DELETE_TRX_TYPES';
537: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
538:
539: BEGIN
540:
541: x_return_status := OKL_API.G_RET_STS_SUCCESS;