DBA Data[Home] [Help]

APPS.OKC_RENEWAL_OUTCOME_PUB dependencies on OKC_API

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

30:
31: -- Variables
32: l_api_name CONSTANT VARCHAR2(30) := 'Renewal Outcome';
33: l_api_version CONSTANT NUMBER := 1.0;
34: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
35: l_msg_count NUMBER;
36: l_msg_data VARCHAR2(1000);
37: l_init_msg_list VARCHAR2(3) := 'F';
38: l_new_chr_id NUMBER;

Line 75: If p_contract_id = OKC_API.G_MISS_NUM Then

71:
72: BEGIN
73:
74:
75: If p_contract_id = OKC_API.G_MISS_NUM Then
76: l_contract_id := Null;
77: Else
78: l_contract_id := p_contract_id;
79: End If;

Line 80: If p_contract_number = OKC_API.G_MISS_CHAR Then

76: l_contract_id := Null;
77: Else
78: l_contract_id := p_contract_id;
79: End If;
80: If p_contract_number = OKC_API.G_MISS_CHAR Then
81: l_contract_number := Null;
82: Else
83: l_contract_number := p_contract_number;
84: End If;

Line 85: If p_contract_version = OKC_API.G_MISS_CHAR Then

81: l_contract_number := Null;
82: Else
83: l_contract_number := p_contract_number;
84: End If;
85: If p_contract_version = OKC_API.G_MISS_CHAR Then
86: l_contract_version := Null;
87: Else
88: l_contract_version := p_contract_version;
89: End If;

Line 90: If p_contract_modifier = OKC_API.G_MISS_CHAR Then

86: l_contract_version := Null;
87: Else
88: l_contract_version := p_contract_version;
89: End If;
90: If p_contract_modifier = OKC_API.G_MISS_CHAR Then
91: l_contract_modifier := Null;
92: Else
93: l_contract_modifier := p_contract_modifier;
94: End If;

Line 95: If p_object_version_number = OKC_API.G_MISS_NUM Then

91: l_contract_modifier := Null;
92: Else
93: l_contract_modifier := p_contract_modifier;
94: End If;
95: If p_object_version_number = OKC_API.G_MISS_NUM Then
96: l_object_version_number := Null;
97: Else
98: l_object_version_number := p_object_version_number;
99: End If;

Line 100: If p_new_contract_number = OKC_API.G_MISS_CHAR Then

96: l_object_version_number := Null;
97: Else
98: l_object_version_number := p_object_version_number;
99: End If;
100: If p_new_contract_number = OKC_API.G_MISS_CHAR Then
101: l_new_contract_number := Null;
102: Else
103: l_new_contract_number := p_new_contract_number;
104: End If;

Line 105: If p_new_contract_modifier = OKC_API.G_MISS_CHAR Then

101: l_new_contract_number := Null;
102: Else
103: l_new_contract_number := p_new_contract_number;
104: End If;
105: If p_new_contract_modifier = OKC_API.G_MISS_CHAR Then
106: l_new_contract_modifier := Null;
107: Else
108: l_new_contract_modifier := p_new_contract_modifier;
109: End If;

Line 110: If p_start_date = OKC_API.G_MISS_DATE Then

106: l_new_contract_modifier := Null;
107: Else
108: l_new_contract_modifier := p_new_contract_modifier;
109: End If;
110: If p_start_date = OKC_API.G_MISS_DATE Then
111: l_start_date := Null;
112: Else
113: l_start_date := p_start_date;
114: End If;

Line 115: If p_end_date = OKC_API.G_MISS_DATE Then

111: l_start_date := Null;
112: Else
113: l_start_date := p_start_date;
114: End If;
115: If p_end_date = OKC_API.G_MISS_DATE Then
116: l_end_date := Null;
117: Else
118: l_end_date := p_end_date;
119: End If;

Line 120: If p_orig_start_date = OKC_API.G_MISS_DATE Then

116: l_end_date := Null;
117: Else
118: l_end_date := p_end_date;
119: End If;
120: If p_orig_start_date = OKC_API.G_MISS_DATE Then
121: l_orig_start_date := Null;
122: Else
123: l_orig_start_date := p_orig_start_date;
124: End If;

Line 125: If p_orig_end_date = OKC_API.G_MISS_DATE Then

121: l_orig_start_date := Null;
122: Else
123: l_orig_start_date := p_orig_start_date;
124: End If;
125: If p_orig_end_date = OKC_API.G_MISS_DATE Then
126: l_orig_end_date := Null;
127: else
128: l_orig_end_date := p_orig_end_date;
129: End If;

Line 130: If p_uom_code = OKC_API.G_MISS_CHAR Then

126: l_orig_end_date := Null;
127: else
128: l_orig_end_date := p_orig_end_date;
129: End If;
130: If p_uom_code = OKC_API.G_MISS_CHAR Then
131: l_uom_code := Null;
132: else
133: l_uom_code := p_uom_code;
134: End If;

Line 135: If p_duration = OKC_API.G_MISS_NUM Then

131: l_uom_code := Null;
132: else
133: l_uom_code := p_uom_code;
134: End If;
135: If p_duration = OKC_API.G_MISS_NUM Then
136: l_duration := Null;
137: else
138: l_duration := p_duration;
139: End If;

Line 141: If p_context= OKC_API.G_MISS_CHAR Then

137: else
138: l_duration := p_duration;
139: End If;
140: --
141: If p_context= OKC_API.G_MISS_CHAR Then
142: l_context:= Null;
143: ELSE
144: l_context := p_context;
145: End If;

Line 146: If p_perpetual_flag= OKC_API.G_MISS_CHAR Then

142: l_context:= Null;
143: ELSE
144: l_context := p_context;
145: End If;
146: If p_perpetual_flag= OKC_API.G_MISS_CHAR Then
147: l_perpetual_flag:= Null;
148: ELSE
149: l_perpetual_flag:=p_perpetual_flag;
150: End If;

Line 200: ,p_init_msg_list => OKC_API.G_TRUE

196: l_renew_in_parameters_rec.p_perpetual_flag := l_perpetual_flag;
197:
198: -- call okc_renew_pub.pre_renew.
199: OKC_RENEW_PUB.PRE_RENEW( p_api_version => l_api_version
200: ,p_init_msg_list => OKC_API.G_TRUE
201: ,x_return_status => l_return_status
202: ,x_msg_count => l_msg_count
203: ,x_msg_data => l_msg_data
204: ,x_contract_id => l_new_chr_id

Line 207: ,p_do_commit => OKC_API.G_TRUE );

203: ,x_msg_data => l_msg_data
204: ,x_contract_id => l_new_chr_id
205: ,p_renew_in_parameters_rec => l_renew_in_parameters_rec
206: ,p_renewal_called_from_ui => 'N'
207: ,p_do_commit => OKC_API.G_TRUE );
208:
209: x_msg_count := l_msg_count;
210: x_return_status := l_return_status;
211: x_msg_data := l_msg_data;

Line 214: IF x_return_status = okc_api.g_ret_sts_success THEN

210: x_return_status := l_return_status;
211: x_msg_data := l_msg_data;
212: -- x_contract_id := l_new_chr_id;
213:
214: IF x_return_status = okc_api.g_ret_sts_success THEN
215: OKC_API.set_message(p_app_name => 'OKC',
216: p_msg_name => 'OKC_OC_SUCCESS',
217: p_token1 => 'PROCESS',
218: p_token1_value => 'Renewal');

Line 215: OKC_API.set_message(p_app_name => 'OKC',

211: x_msg_data := l_msg_data;
212: -- x_contract_id := l_new_chr_id;
213:
214: IF x_return_status = okc_api.g_ret_sts_success THEN
215: OKC_API.set_message(p_app_name => 'OKC',
216: p_msg_name => 'OKC_OC_SUCCESS',
217: p_token1 => 'PROCESS',
218: p_token1_value => 'Renewal');
219: ELSE

Line 220: OKC_API.SET_MESSAGE(p_app_name => 'OKC',

216: p_msg_name => 'OKC_OC_SUCCESS',
217: p_token1 => 'PROCESS',
218: p_token1_value => 'Renewal');
219: ELSE
220: OKC_API.SET_MESSAGE(p_app_name => 'OKC',
221: p_msg_name => 'OKC_OC_FAILED',
222: p_token1 => 'PROCESS',
223: p_token1_value => 'Renewal',
224: p_token2 => 'MESSAGE1',

Line 233: OKC_API.SET_MESSAGE(p_app_name => 'OKC',

229:
230:
231: EXCEPTION
232: when others then
233: OKC_API.SET_MESSAGE(p_app_name => 'OKC',
234: p_msg_name => 'OKC_OC_FAILED',
235: p_token1 => 'PROCESS',
236: p_token1_value => 'Renewal',
237: p_token2 => 'MESSAGE1',