DBA Data[Home] [Help]

APPS.OKL_XMLP_PARAMS_PVT dependencies on OKL_XMP_PVT

Line 55: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

51: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
52: END IF;
53: IF(IS_DEBUG_PROCEDURE_ON) THEN
54: BEGIN
55: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');
56: END;
57: END IF;
58:
59: l_xmp_rec := p_xmp_rec;

Line 80: okl_xmp_pvt.insert_row( l_api_version,

76: RAISE OKL_API.G_EXCEPTION_ERROR;
77: END IF;
78:
79: -- TAPI call to create a record for xmlp params in table OKL_XMLP_PARAMS.
80: okl_xmp_pvt.insert_row( l_api_version,
81: l_init_msg_list,
82: l_return_status,
83: l_msg_count,
84: l_msg_data,

Line 101: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

97: x_msg_count := l_msg_count;
98:
99: IF(IS_DEBUG_PROCEDURE_ON) THEN
100: BEGIN
101: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');
102: END;
103: END IF;
104:
105: EXCEPTION

Line 193: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

189: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
190: END IF;
191: IF(IS_DEBUG_PROCEDURE_ON) THEN
192: BEGIN
193: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');
194: END;
195: END IF;
196:
197: l_xmp_tbl := p_xmp_tbl;

Line 218: okl_xmp_pvt.insert_row( l_api_version,

214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216:
217: -- TAPI call to create a record for xmlp params in table OKL_XMLP_PARAMS.
218: okl_xmp_pvt.insert_row( l_api_version,
219: l_init_msg_list,
220: l_return_status,
221: l_msg_count,
222: l_msg_data,

Line 239: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

235: x_msg_count := l_msg_count;
236:
237: IF(IS_DEBUG_PROCEDURE_ON) THEN
238: BEGIN
239: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');
240: END;
241: END IF;
242:
243: EXCEPTION

Line 328: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

324: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
325: END IF;
326: IF(IS_DEBUG_PROCEDURE_ON) THEN
327: BEGIN
328: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');
329: END;
330: END IF;
331: l_xmp_rec := p_xmp_rec;
332: l_api_version := 1.0;

Line 352: okl_xmp_pvt.update_row(l_api_version,

348: RAISE OKL_API.G_EXCEPTION_ERROR;
349: END IF;
350:
351: -- TAPI call to update xmlp params in table OKL_XMLP_PARAMS.
352: okl_xmp_pvt.update_row(l_api_version,
353: l_init_msg_list,
354: l_return_status,
355: l_msg_count,
356: l_msg_data,

Line 373: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

369: x_msg_count := l_msg_count;
370:
371: IF(IS_DEBUG_PROCEDURE_ON) THEN
372: BEGIN
373: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');
374: END;
375: END IF;
376:
377: EXCEPTION

Line 461: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

457: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
458: END IF;
459: IF(IS_DEBUG_PROCEDURE_ON) THEN
460: BEGIN
461: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');
462: END;
463: END IF;
464: l_xmp_tbl := p_xmp_tbl;
465: l_api_version := 1.0;

Line 485: okl_xmp_pvt.update_row(l_api_version,

481: RAISE OKL_API.G_EXCEPTION_ERROR;
482: END IF;
483:
484: -- TAPI call to update xmlp params in table OKL_XMLP_PARAMS.
485: okl_xmp_pvt.update_row(l_api_version,
486: l_init_msg_list,
487: l_return_status,
488: l_msg_count,
489: l_msg_data,

Line 506: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

502: x_msg_count := l_msg_count;
503:
504: IF(IS_DEBUG_PROCEDURE_ON) THEN
505: BEGIN
506: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');
507: END;
508: END IF;
509:
510: EXCEPTION

Line 602: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.delete_row ');

598: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
599: END IF;
600: IF(IS_DEBUG_PROCEDURE_ON) THEN
601: BEGIN
602: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.delete_row ');
603: END;
604: END IF;
605: l_batch_id := p_batch_id;
606: l_api_version := 1.0;

Line 629: okl_xmp_pvt.delete_row(l_api_version,

625: -- Call TAPI to delete the xmlp params in table OKL_XMLP_PARAMS based on the batch id.
626: FOR each_row IN c_get_param_ids(l_batch_id) LOOP
627: l_xmp_rec.id := each_row.id;
628: l_xmp_rec.batch_id := each_row.batch_id;
629: okl_xmp_pvt.delete_row(l_api_version,
630: l_init_msg_list,
631: l_return_status,
632: l_msg_count,
633: l_msg_data,

Line 650: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.delete_row ');

646: x_msg_count := l_msg_count;
647:
648: IF(IS_DEBUG_PROCEDURE_ON) THEN
649: BEGIN
650: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.delete_row ');
651: END;
652: END IF;
653:
654: EXCEPTION

Line 737: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');

733: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
734: END IF;
735: IF(IS_DEBUG_PROCEDURE_ON) THEN
736: BEGIN
737: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');
738: END;
739: END IF;
740: l_api_version := 1.0;
741: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 763: okl_xmp_pvt.validate_row(

759: raise OKL_API.G_EXCEPTION_ERROR;
760: End If;
761:
762: -- TAPI call to validate the records.
763: okl_xmp_pvt.validate_row(
764: p_api_version => p_api_version,
765: p_init_msg_list => p_init_msg_list,
766: x_return_status => x_return_status,
767: x_msg_count => x_msg_count,

Line 783: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');

779: x_msg_data => x_msg_data);
780:
781: IF(IS_DEBUG_PROCEDURE_ON) THEN
782: BEGIN
783: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');
784: END;
785: END IF;
786:
787: EXCEPTION

Line 862: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');

858: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
859: END IF;
860: IF(IS_DEBUG_PROCEDURE_ON) THEN
861: BEGIN
862: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');
863: END;
864: END IF;
865: l_api_version := 1.0;
866: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 889: okl_xmp_pvt.validate_row(

885: End If;
886:
887:
888: -- TAPI call to validate the records.
889: okl_xmp_pvt.validate_row(
890: p_api_version => p_api_version,
891: p_init_msg_list => p_init_msg_list,
892: x_return_status => x_return_status,
893: x_msg_count => x_msg_count,

Line 909: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');

905: x_msg_data => x_msg_data);
906:
907: IF(IS_DEBUG_PROCEDURE_ON) THEN
908: BEGIN
909: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');
910: END;
911: END IF;
912:
913: EXCEPTION