APPS.OKC_REP_UPD_CON_ADMIN_PVT dependencies on OKC_REP_UPD_CON_ADMIN_PVT

Line 1: PACKAGE BODY OKC_REP_UPD_CON_ADMIN_PVT AS

1: PACKAGE BODY OKC_REP_UPD_CON_ADMIN_PVT AS
2: /* $Header: OKCVREPUADB.pls 120.26 2006/08/18 02:05:23 vamuru noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS

Line 47: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.populate_output_and_log_file');

43: l_api_name := 'populate_output_and_log_file';
44:
45: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
46: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
47: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.populate_output_and_log_file');
48: END IF;
49:
50: -- Show the text Contract Details only once
51: IF (p_doc_index = 1) THEN

Line 112: 'Leaving OKC_REP_UPD_CON_ADMIN_PVT.populate_output_and_log_file');

108: FND_FILE.PUT_LINE(FND_FILE.LOG, '====================================');
109:
110: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
111: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
112: 'Leaving OKC_REP_UPD_CON_ADMIN_PVT.populate_output_and_log_file');
113: END IF;
114:
115: END populate_output_and_log_file;
116:

Line 195: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.populate_report_parameters');

191: l_api_name := 'populate_report_parameters';
192:
193: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
194: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
195: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.populate_report_parameters');
196: END IF;
197:
198: -- Get the translated string for the text "Not Available"
199: l_not_available_text := OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE');

Line 314: 'Leaving OKC_REP_UPD_CON_ADMIN_PVT.populate_report_parameters');

310:
311:
312: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
313: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
314: 'Leaving OKC_REP_UPD_CON_ADMIN_PVT.populate_report_parameters');
315: END IF;
316:
317: EXCEPTION
318: WHEN OTHERS THEN

Line 354: ROLLBACK TO OKC_REP_UPD_CON_ADMIN_PVT;

350: END IF;
351: IF (sales_grp_name_csr%ISOPEN) THEN
352: CLOSE sales_grp_name_csr ;
353: END IF;
354: ROLLBACK TO OKC_REP_UPD_CON_ADMIN_PVT;
355:
356: END populate_report_parameters;
357:
358:

Line 606: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.update_con_admin_manager');

602: l_api_name := 'update_con_admin_manager';
603:
604: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
606: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.update_con_admin_manager');
607: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
608: 'p_doc_type: ' || p_doc_type);
609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
610: 'p_cust_id: ' || p_cust_id);

Line 632: SAVEPOINT OKC_REP_UPD_CON_ADMIN_PVT;

628: 'p_mode: ' || p_mode);
629: END IF;
630:
631: -- Standard Start of API savepoint
632: SAVEPOINT OKC_REP_UPD_CON_ADMIN_PVT;
633:
634: -- Populate the log/output files with user entered report parameters
635: populate_report_parameters(p_doc_type => p_doc_type,
636: p_cust_id => p_cust_id,

Line 1142: 'Leaving OKC_REP_UPD_CON_ADMIN_PVT.update_con_admin_manager');

1138: retcode := G_RETURN_CODE_SUCCESS;
1139:
1140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1142: 'Leaving OKC_REP_UPD_CON_ADMIN_PVT.update_con_admin_manager');
1143: END IF;
1144:
1145: EXCEPTION
1146: WHEN OTHERS THEN

Line 1173: ROLLBACK TO OKC_REP_UPD_CON_ADMIN_PVT;

1169: END IF;
1170: IF (cust_names_csr%ISOPEN) THEN
1171: CLOSE cust_names_csr ;
1172: END IF;
1173: ROLLBACK TO OKC_REP_UPD_CON_ADMIN_PVT;
1174: errbuf := substr(SQLERRM, 1, 2000);
1175:
1176: END update_con_admin_manager;
1177:

Line 1179: END OKC_REP_UPD_CON_ADMIN_PVT;

1175:
1176: END update_con_admin_manager;
1177:
1178:
1179: END OKC_REP_UPD_CON_ADMIN_PVT;