49:
50: -- Show the text Contract Details only once
51: IF (p_doc_index = 1) THEN
52:
53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
54: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
55: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
56: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
57: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
50: -- Show the text Contract Details only once
51: IF (p_doc_index = 1) THEN
52:
53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
54: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
55: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
56: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
57: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
58: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
51: IF (p_doc_index = 1) THEN
52:
53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
54: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
55: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
56: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
57: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
58: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
59:
52:
53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
54: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
55: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
56: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
57: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
58: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
59:
60: END IF;
53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
54: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
55: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
56: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
57: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
58: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
59:
60: END IF;
61:
54: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
55: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
56: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
57: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
58: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
59:
60: END IF;
61:
62: -- Document Type
59:
60: END IF;
61:
62: -- Document Type
63: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ' : ' || p_doc_type_name);
64: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ' : ' || p_doc_type_name);
65:
66: -- Operating Unit
67: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ' : ' || p_operating_unit);
60: END IF;
61:
62: -- Document Type
63: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ' : ' || p_doc_type_name);
64: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ' : ' || p_doc_type_name);
65:
66: -- Operating Unit
67: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ' : ' || p_operating_unit);
68: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ' : ' || p_operating_unit);
63: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ' : ' || p_doc_type_name);
64: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ' : ' || p_doc_type_name);
65:
66: -- Operating Unit
67: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ' : ' || p_operating_unit);
68: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ' : ' || p_operating_unit);
69:
70: -- Contract Number
71: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| p_con_number);
64: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ' : ' || p_doc_type_name);
65:
66: -- Operating Unit
67: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ' : ' || p_operating_unit);
68: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ' : ' || p_operating_unit);
69:
70: -- Contract Number
71: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| p_con_number);
72: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| p_con_number);
67: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ' : ' || p_operating_unit);
68: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ' : ' || p_operating_unit);
69:
70: -- Contract Number
71: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| p_con_number);
72: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| p_con_number);
73:
74: -- Customer
75: IF (p_cust_name IS NOT NULL) THEN
68: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ' : ' || p_operating_unit);
69:
70: -- Contract Number
71: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| p_con_number);
72: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| p_con_number);
73:
74: -- Customer
75: IF (p_cust_name IS NOT NULL) THEN
76: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || p_cust_name);
72: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| p_con_number);
73:
74: -- Customer
75: IF (p_cust_name IS NOT NULL) THEN
76: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || p_cust_name);
77: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || p_cust_name);
78: ELSE
79: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
80: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
73:
74: -- Customer
75: IF (p_cust_name IS NOT NULL) THEN
76: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || p_cust_name);
77: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || p_cust_name);
78: ELSE
79: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
80: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
81: END IF;
75: IF (p_cust_name IS NOT NULL) THEN
76: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || p_cust_name);
77: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || p_cust_name);
78: ELSE
79: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
80: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
81: END IF;
82:
83: -- Current Contract Administrator
76: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || p_cust_name);
77: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || p_cust_name);
78: ELSE
79: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
80: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
81: END IF;
82:
83: -- Current Contract Administrator
84: IF (p_current_con_admin IS NOT NULL) THEN
81: END IF;
82:
83: -- Current Contract Administrator
84: IF (p_current_con_admin IS NOT NULL) THEN
85: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || p_current_con_admin);
86: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || p_current_con_admin);
87: ELSE
88: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
89: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
82:
83: -- Current Contract Administrator
84: IF (p_current_con_admin IS NOT NULL) THEN
85: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || p_current_con_admin);
86: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || p_current_con_admin);
87: ELSE
88: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
89: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
90: END IF;
84: IF (p_current_con_admin IS NOT NULL) THEN
85: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || p_current_con_admin);
86: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || p_current_con_admin);
87: ELSE
88: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
89: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
90: END IF;
91:
92: -- New Contract Administrator
85: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || p_current_con_admin);
86: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || p_current_con_admin);
87: ELSE
88: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
89: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CURR_CON_ADMIN') || ': ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_NOT_AVAILABLE'));
90: END IF;
91:
92: -- New Contract Administrator
93: IF(p_new_con_admin IS NOT NULL) THEN
90: END IF;
91:
92: -- New Contract Administrator
93: IF(p_new_con_admin IS NOT NULL) THEN
94: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_NEW_CON_ADMIN') || ' : ' || p_new_con_admin);
95: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_NEW_CON_ADMIN') || ' : ' || p_new_con_admin);
96: END IF;
97:
98: -- Error Message
91:
92: -- New Contract Administrator
93: IF(p_new_con_admin IS NOT NULL) THEN
94: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_NEW_CON_ADMIN') || ' : ' || p_new_con_admin);
95: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_NEW_CON_ADMIN') || ' : ' || p_new_con_admin);
96: END IF;
97:
98: -- Error Message
99: IF( p_msg_type = G_ERROR_CODE) THEN
96: END IF;
97:
98: -- Error Message
99: IF( p_msg_type = G_ERROR_CODE) THEN
100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_ERR_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
101: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_ERR_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
102: ELSIF (p_msg_type = G_WARNING_CODE) THEN
103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_WARN_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
104: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_WARN_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
97:
98: -- Error Message
99: IF( p_msg_type = G_ERROR_CODE) THEN
100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_ERR_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
101: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_ERR_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
102: ELSIF (p_msg_type = G_WARNING_CODE) THEN
103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_WARN_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
104: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_WARN_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
105: END IF;
99: IF( p_msg_type = G_ERROR_CODE) THEN
100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_ERR_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
101: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_ERR_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
102: ELSIF (p_msg_type = G_WARNING_CODE) THEN
103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_WARN_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
104: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_WARN_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
105: END IF;
106:
107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '====================================');
100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_ERR_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
101: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_ERR_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
102: ELSIF (p_msg_type = G_WARNING_CODE) THEN
103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_WARN_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
104: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_WARN_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
105: END IF;
106:
107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '====================================');
108: FND_FILE.PUT_LINE(FND_FILE.LOG, '====================================');
103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_WARN_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
104: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_WARN_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
105: END IF;
106:
107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '====================================');
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,
104: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_ADMIN_WARN_MSG') || ' : ' || OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, p_msg_code));
105: END IF;
106:
107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '====================================');
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');
271: l_sales_grp_name := l_not_available_text;
272: END IF;
273:
274: -- Populate the title
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_NAME'));
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
277:
278: -- Populate log/output files with Report Parameters
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_REP_PARAMS'));
272: END IF;
273:
274: -- Populate the title
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_NAME'));
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
277:
278: -- Populate log/output files with Report Parameters
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_REP_PARAMS'));
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '=================');
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_NAME'));
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
277:
278: -- Populate log/output files with Report Parameters
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_REP_PARAMS'));
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '=================');
281:
282: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_REP_PARAMS'));
283: FND_FILE.PUT_LINE(FND_FILE.LOG, '=================');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
277:
278: -- Populate log/output files with Report Parameters
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_REP_PARAMS'));
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '=================');
281:
282: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_REP_PARAMS'));
283: FND_FILE.PUT_LINE(FND_FILE.LOG, '=================');
284:
278: -- Populate log/output files with Report Parameters
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_REP_PARAMS'));
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '=================');
281:
282: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_REP_PARAMS'));
283: FND_FILE.PUT_LINE(FND_FILE.LOG, '=================');
284:
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_REP_PARAMS'));
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '=================');
281:
282: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_REP_PARAMS'));
283: FND_FILE.PUT_LINE(FND_FILE.LOG, '=================');
284:
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
287: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
281:
282: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_REP_PARAMS'));
283: FND_FILE.PUT_LINE(FND_FILE.LOG, '=================');
284:
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
287: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
289: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
282: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_REP_PARAMS'));
283: FND_FILE.PUT_LINE(FND_FILE.LOG, '=================');
284:
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
287: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
289: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
283: FND_FILE.PUT_LINE(FND_FILE.LOG, '=================');
284:
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
287: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
289: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
284:
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
287: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
289: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
292: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
285: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
287: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
289: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
292: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_DOC_TYPE') || ': '|| l_doc_type_name);
287: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
289: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
292: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
294: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
287: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
289: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
292: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
294: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CUSTOMER') || ': '|| l_cust_name);
289: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
292: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
294: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
289: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
292: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
294: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALES_GROUP') || ': '|| l_sales_grp_name);
290: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_ADMIN') || ': '|| l_con_admin_name);
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
292: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
294: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALES_GROUP') || ': '|| l_sales_grp_name);
298: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALES_GROUP') || ': '|| l_sales_grp_name);
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
292: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
294: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALES_GROUP') || ': '|| l_sales_grp_name);
298: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALES_GROUP') || ': '|| l_sales_grp_name);
299:
292: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_OPERATING_UNIT') || ': '|| l_ou_name);
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
294: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALES_GROUP') || ': '|| l_sales_grp_name);
298: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALES_GROUP') || ': '|| l_sales_grp_name);
299:
300: -- Show the action parameter value
293: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
294: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALES_GROUP') || ': '|| l_sales_grp_name);
298: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALES_GROUP') || ': '|| l_sales_grp_name);
299:
300: -- Show the action parameter value
301: IF (p_mode = G_MODE_UPDATE) THEN
294: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALESPERSON') || ': '|| l_salesperson_name);
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_ORDER_TYPE') || ': '|| l_trans_type_name);
297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALES_GROUP') || ': '|| l_sales_grp_name);
298: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALES_GROUP') || ': '|| l_sales_grp_name);
299:
300: -- Show the action parameter value
301: IF (p_mode = G_MODE_UPDATE) THEN
302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_UPDATE'));
298: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_SALES_GROUP') || ': '|| l_sales_grp_name);
299:
300: -- Show the action parameter value
301: IF (p_mode = G_MODE_UPDATE) THEN
302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_UPDATE'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_UPDATE'));
304: ELSE
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_VIEW'));
306: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_VIEW'));
299:
300: -- Show the action parameter value
301: IF (p_mode = G_MODE_UPDATE) THEN
302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_UPDATE'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_UPDATE'));
304: ELSE
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_VIEW'));
306: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_VIEW'));
307: END IF;
301: IF (p_mode = G_MODE_UPDATE) THEN
302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_UPDATE'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_UPDATE'));
304: ELSE
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_VIEW'));
306: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_VIEW'));
307: END IF;
308:
309: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_UPDATE'));
303: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_UPDATE'));
304: ELSE
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_VIEW'));
306: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_VIEW'));
307: END IF;
308:
309: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
310:
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_VIEW'));
306: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_UPD_CON_ADMIN_ACT') || ': '|| OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ACT_VIEW'));
307: END IF;
308:
309: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
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,
321: g_module || l_api_name,
322: 'Leaving populate_report_parameters because of EXCEPTION: ' || sqlerrm);
323: END IF;
324:
325: FND_FILE.PUT_LINE(FND_FILE.LOG,
326: 'Leaving populate_report_parameters because of EXCEPTION: ' ||
327: sqlerrm);
328:
329: --close cursors
1108:
1109: END IF;
1110:
1111: -- Populate the log/output files with summary of the current job
1112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1113: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
1114:
1115: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_SUMMARY'));
1116: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '=======');
1109: END IF;
1110:
1111: -- Populate the log/output files with summary of the current job
1112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1113: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
1114:
1115: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_SUMMARY'));
1116: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '=======');
1117:
1111: -- Populate the log/output files with summary of the current job
1112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1113: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
1114:
1115: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_SUMMARY'));
1116: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '=======');
1117:
1118: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_SUMMARY'));
1119: FND_FILE.PUT_LINE(FND_FILE.LOG, '=======');
1112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1113: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
1114:
1115: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_SUMMARY'));
1116: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '=======');
1117:
1118: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_SUMMARY'));
1119: FND_FILE.PUT_LINE(FND_FILE.LOG, '=======');
1120:
1114:
1115: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_SUMMARY'));
1116: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '=======');
1117:
1118: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_SUMMARY'));
1119: FND_FILE.PUT_LINE(FND_FILE.LOG, '=======');
1120:
1121: -- If Contract Administrator is selected manually
1122: IF( p_con_admin_from <> G_CON_ADMIN_FROM_SALES_GROUP) THEN
1115: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_SUMMARY'));
1116: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '=======');
1117:
1118: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_SUMMARY'));
1119: FND_FILE.PUT_LINE(FND_FILE.LOG, '=======');
1120:
1121: -- If Contract Administrator is selected manually
1122: IF( p_con_admin_from <> G_CON_ADMIN_FROM_SALES_GROUP) THEN
1123: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_NEW_CON_ADMIN') || ': '|| p_new_con_admin_name);
1119: FND_FILE.PUT_LINE(FND_FILE.LOG, '=======');
1120:
1121: -- If Contract Administrator is selected manually
1122: IF( p_con_admin_from <> G_CON_ADMIN_FROM_SALES_GROUP) THEN
1123: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_NEW_CON_ADMIN') || ': '|| p_new_con_admin_name);
1124: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_NEW_CON_ADMIN') || ': '|| p_new_con_admin_name);
1125: END IF;
1126:
1127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_SUCC') || ': '|| l_succ_doc_count);
1120:
1121: -- If Contract Administrator is selected manually
1122: IF( p_con_admin_from <> G_CON_ADMIN_FROM_SALES_GROUP) THEN
1123: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_NEW_CON_ADMIN') || ': '|| p_new_con_admin_name);
1124: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_NEW_CON_ADMIN') || ': '|| p_new_con_admin_name);
1125: END IF;
1126:
1127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_SUCC') || ': '|| l_succ_doc_count);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_SUCC') || ': '|| l_succ_doc_count);
1123: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_NEW_CON_ADMIN') || ': '|| p_new_con_admin_name);
1124: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_NEW_CON_ADMIN') || ': '|| p_new_con_admin_name);
1125: END IF;
1126:
1127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_SUCC') || ': '|| l_succ_doc_count);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_SUCC') || ': '|| l_succ_doc_count);
1129:
1130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_ERR') || ': '|| l_err_doc_count);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_ERR') || ': '|| l_err_doc_count);
1124: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_NEW_CON_ADMIN') || ': '|| p_new_con_admin_name);
1125: END IF;
1126:
1127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_SUCC') || ': '|| l_succ_doc_count);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_SUCC') || ': '|| l_succ_doc_count);
1129:
1130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_ERR') || ': '|| l_err_doc_count);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_ERR') || ': '|| l_err_doc_count);
1132:
1126:
1127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_SUCC') || ': '|| l_succ_doc_count);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_SUCC') || ': '|| l_succ_doc_count);
1129:
1130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_ERR') || ': '|| l_err_doc_count);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_ERR') || ': '|| l_err_doc_count);
1132:
1133:
1134: IF(p_mode = 'UPDATE') THEN
1127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_SUCC') || ': '|| l_succ_doc_count);
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_SUCC') || ': '|| l_succ_doc_count);
1129:
1130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_ERR') || ': '|| l_err_doc_count);
1131: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_TOT_CON_ERR') || ': '|| l_err_doc_count);
1132:
1133:
1134: IF(p_mode = 'UPDATE') THEN
1135: COMMIT;
1149: g_module || l_api_name,
1150: 'Leaving update_con_admin_manager because of EXCEPTION: ' || sqlerrm);
1151: END IF;
1152:
1153: FND_FILE.PUT_LINE(FND_FILE.LOG,
1154: 'Leaving update_con_admin_manager because of EXCEPTION: ' ||
1155: sqlerrm);
1156:
1157: --close cursors