DBA Data[Home] [Help]

APPS.PV_PARTNER_CONTRACTS_PVT dependencies on PVX_UTILITY_PVT

Line 170: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

166: END IF;
167:
168: -- Debug Message
169: IF (PV_DEBUG_HIGH_ON) THEN
170: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
171: END IF;
172:
173: -- Initialize API return status to SUCCESS
174: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 177: PVX_UTILITY_PVT.debug_message('p_program_id = ' || p_program_id);

173: -- Initialize API return status to SUCCESS
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: IF (PV_DEBUG_HIGH_ON) THEN
177: PVX_UTILITY_PVT.debug_message('p_program_id = ' || p_program_id);
178: END IF;
179:
180: l_geo_cnt := 1;
181: FOR x IN c_get_geo_hierarchy_id (p_partner_id, p_program_id) LOOP

Line 183: PVX_UTILITY_PVT.debug_message('x.GEO_HIERARCHY_ID:' || x.GEO_HIERARCHY_ID);

179:
180: l_geo_cnt := 1;
181: FOR x IN c_get_geo_hierarchy_id (p_partner_id, p_program_id) LOOP
182: IF (PV_DEBUG_HIGH_ON) THEN
183: PVX_UTILITY_PVT.debug_message('x.GEO_HIERARCHY_ID:' || x.GEO_HIERARCHY_ID);
184: END IF;
185:
186: l_geo_hierarchy_id_tbl.extend;
187: l_geo_hierarchy_id_tbl(l_geo_cnt) := x.GEO_HIERARCHY_ID;

Line 193: PVX_UTILITY_PVT.debug_message('x.partner_party_id:' || x.partner_party_id);

189: END LOOP;
190:
191: FOR x IN c_get_partner_party_id LOOP
192: IF (PV_DEBUG_HIGH_ON) THEN
193: PVX_UTILITY_PVT.debug_message('x.partner_party_id:' || x.partner_party_id);
194: END IF;
195:
196: l_partner_party_id := x.partner_party_id;
197: END LOOP;

Line 221: PVX_UTILITY_PVT.debug_message('l_geo_hierarchy_id is not null');

217: END IF;
218:
219: IF l_geo_hierarchy_id is not null THEN
220: IF (PV_DEBUG_HIGH_ON) THEN
221: PVX_UTILITY_PVT.debug_message('l_geo_hierarchy_id is not null');
222: PVX_UTILITY_PVT.debug_message('l_geo_hierarchy_id = ' || l_geo_hierarchy_id);
223: END IF;
224:
225: FOR y IN c_get_contract_id (p_partner_id, p_program_id, l_geo_hierarchy_id)

Line 222: PVX_UTILITY_PVT.debug_message('l_geo_hierarchy_id = ' || l_geo_hierarchy_id);

218:
219: IF l_geo_hierarchy_id is not null THEN
220: IF (PV_DEBUG_HIGH_ON) THEN
221: PVX_UTILITY_PVT.debug_message('l_geo_hierarchy_id is not null');
222: PVX_UTILITY_PVT.debug_message('l_geo_hierarchy_id = ' || l_geo_hierarchy_id);
223: END IF;
224:
225: FOR y IN c_get_contract_id (p_partner_id, p_program_id, l_geo_hierarchy_id)
226: LOOP

Line 228: PVX_UTILITY_PVT.debug_message('y.contract_id = ' || y.contract_id);

224:
225: FOR y IN c_get_contract_id (p_partner_id, p_program_id, l_geo_hierarchy_id)
226: LOOP
227: IF (PV_DEBUG_HIGH_ON) THEN
228: PVX_UTILITY_PVT.debug_message('y.contract_id = ' || y.contract_id);
229: END IF;
230:
231: OKC_TERMS_UTIL_GRP.get_translated_template(
232: p_api_version => 1.0

Line 255: PVX_UTILITY_PVT.debug_message('l_template_id = ' || l_template_id);

251: END IF;
252: END IF;
253:
254: IF (PV_DEBUG_HIGH_ON) THEN
255: PVX_UTILITY_PVT.debug_message('l_template_id = ' || l_template_id);
256: END IF;
257:
258: -- If there is an appropriate contract, instantiate the T's and C's here
259: OKC_TERMS_COPY_GRP.COPY_TERMS(

Line 284: PVX_UTILITY_PVT.debug_message('x_return_status: ' || x_return_status);

280: ,x_msg_count => x_msg_count
281: );
282:
283: IF (PV_DEBUG_HIGH_ON) THEN
284: PVX_UTILITY_PVT.debug_message('x_return_status: ' || x_return_status);
285: END IF;
286:
287: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
288: FND_MESSAGE.SET_NAME('PV','PV_COPY_TERMS_ERROR_OUT');

Line 300: PVX_UTILITY_PVT.debug_message('l_geo_hierarchy_id is not null');

296: END LOOP;
297: x_exist := 'Y';
298: ELSE
299: IF (PV_DEBUG_HIGH_ON) THEN
300: PVX_UTILITY_PVT.debug_message('l_geo_hierarchy_id is not null');
301: PVX_UTILITY_PVT.debug_message('x_exist is N');
302: END IF;
303: x_exist := 'N';
304: END IF;

Line 301: PVX_UTILITY_PVT.debug_message('x_exist is N');

297: x_exist := 'Y';
298: ELSE
299: IF (PV_DEBUG_HIGH_ON) THEN
300: PVX_UTILITY_PVT.debug_message('l_geo_hierarchy_id is not null');
301: PVX_UTILITY_PVT.debug_message('x_exist is N');
302: END IF;
303: x_exist := 'N';
304: END IF;
305:

Line 308: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');

304: END IF;
305:
306: -- Debug Message
307: IF (PV_DEBUG_HIGH_ON) THEN
308: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
309: END IF;
310:
311: -- Standard call to get message count and if count is 1, get message info.
312: FND_MSG_PUB.Count_And_Get