DBA Data[Home] [Help]

APPS.OKL_QUICK_QUOTES_PVT dependencies on FND_LOG_MESSAGES

Line 65: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QQH';

61: ,x_qqhv_rec_type OUT NOCOPY qqhv_rec_type ) IS
62:
63: lp_qqhv_rec_type qqhv_rec_type;
64: lx_qqhv_rec_type qqhv_rec_type;
65: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QQH';
66: l_debug_enabled VARCHAR2(10);
67: is_debug_procedure_on BOOLEAN;
68: is_debug_statement_on BOOLEAN;
69: l_api_name CONSTANT VARCHAR2(30) := 'create_qqh';

Line 190: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QQL';

186: ,x_qqlv_tbl_type OUT NOCOPY qqlv_tbl_type) IS
187:
188: lp_qqlv_tbl_type qqlv_tbl_type;
189: lx_qqlv_tbl_type qqlv_tbl_type;
190: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QQL';
191: l_debug_enabled VARCHAR2(10);
192: is_debug_procedure_on BOOLEAN;
193: is_debug_statement_on BOOLEAN;
194: l_api_name CONSTANT VARCHAR2(30) := 'create_qql';

Line 300: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QUICK_QTE';

296: lp_qqhv_rec_type qqhv_rec_type;
297: lx_qqhv_rec_type qqhv_rec_type;
298: lp_qqlv_tbl_type qqlv_tbl_type;
299: lx_qqlv_tbl_type qqlv_tbl_type;
300: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CREATE_QUICK_QTE';
301: l_debug_enabled VARCHAR2(10);
302: is_debug_procedure_on BOOLEAN;
303: is_debug_statement_on BOOLEAN;
304: l_api_name CONSTANT VARCHAR2(30) := 'create_quick_qte';

Line 435: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QQH';

431: ,p_qqhv_rec_type IN qqhv_rec_type
432: ,x_qqhv_rec_type OUT NOCOPY qqhv_rec_type) IS
433: lp_qqhv_rec_type qqhv_rec_type;
434: lx_qqhv_rec_type qqhv_rec_type;
435: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QQH';
436: l_debug_enabled VARCHAR2(10);
437: is_debug_procedure_on BOOLEAN;
438: is_debug_statement_on BOOLEAN;
439: l_api_name CONSTANT VARCHAR2(30) := 'update_qqh';

Line 569: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CANCEL_QUICK_QUOTE';

565: ,p_qqhv_rec_type IN qqhv_rec_type
566: ,x_qqhv_rec_type OUT NOCOPY qqhv_rec_type) IS
567: lp_qqhv_rec_type qqhv_rec_type;
568: lx_qqhv_rec_type qqhv_rec_type;
569: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.CANCEL_QUICK_QUOTE';
570: QQ_CANCELLED CONSTANT okl_quick_quotes_b.sts_code%TYPE := 'CANCELLED';
571: l_debug_enabled VARCHAR2(10);
572: is_debug_procedure_on BOOLEAN;
573: is_debug_statement_on BOOLEAN;

Line 678: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QQL';

674: ,x_qqlv_tbl_type OUT NOCOPY qqlv_tbl_type) IS
675:
676: lp_qqlv_tbl_type qqlv_tbl_type := p_qqlv_tbl_type; --dkagrawa assigned the in value
677: lx_qqlv_tbl_type qqlv_tbl_type;
678: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QQL';
679: l_debug_enabled VARCHAR2(10);
680: is_debug_procedure_on BOOLEAN;
681: is_debug_statement_on BOOLEAN;
682: l_api_name CONSTANT VARCHAR2(30) := 'update_qql';

Line 786: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QUICK_QTE';

782: lp_qqhv_rec_type qqhv_rec_type;
783: lx_qqhv_rec_type qqhv_rec_type;
784: lp_qqlv_tbl_type qqlv_tbl_type;
785: lx_qqlv_tbl_type qqlv_tbl_type;
786: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.UPDATE_QUICK_QTE';
787: l_debug_enabled VARCHAR2(10);
788: is_debug_procedure_on BOOLEAN;
789: is_debug_statement_on BOOLEAN;
790: l_api_name CONSTANT VARCHAR2(30) := 'update_quick_qte';

Line 918: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';

914: l_api_name CONSTANT VARCHAR2(30) := 'delete_qql';
915: l_api_version CONSTANT NUMBER := 1.0;
916: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
917: l_qqlv_rec qqlv_rec_type := p_qqlv_rec_type;
918: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';
919: l_debug_enabled VARCHAR2(10);
920: is_debug_procedure_on BOOLEAN;
921: is_debug_statement_on BOOLEAN;
922:

Line 1015: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';

1011: l_api_name CONSTANT VARCHAR2(30) := 'delete_qql';
1012: l_api_version CONSTANT NUMBER := 1.0;
1013: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1014: l_qqlv_tbl qqlv_tbl_type := p_qqlv_tbl_type;
1015: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DELETE_QQL';
1016: l_debug_enabled VARCHAR2(10);
1017: is_debug_procedure_on BOOLEAN;
1018: is_debug_statement_on BOOLEAN;
1019:

Line 1138: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.handle_quick_quote';

1134: lxx_qqlv_tbl_type qqlv_tbl_type;
1135: lp_qqlv_rec qqlv_rec_type;
1136: lx_qqlv_rec qqlv_rec_type;
1137:
1138: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.handle_quick_quote';
1139: l_debug_enabled VARCHAR2(10);
1140: is_debug_procedure_on BOOLEAN;
1141: is_debug_statement_on BOOLEAN;
1142: l_item_name VARCHAR2(240);

Line 2392: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DUPLICATE_QUICK_QTE';

2388: l_quote_lines_tbl qqlv_tbl_type;
2389: x_quick_qte_rec qqhv_rec_type;
2390: x_quick_qte_lines_tbl qqlv_tbl_type;
2391:
2392: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_QUICK_QUOTES_PVT.DUPLICATE_QUICK_QTE';
2393: l_debug_enabled VARCHAR2(10);
2394: is_debug_procedure_on BOOLEAN;
2395: is_debug_statement_on BOOLEAN;
2396: l_api_name CONSTANT VARCHAR2(30) := 'duplicate_quick_qte';