eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_LEAD_OWNER dependencies on FND_API

Line 21: x_return_status := FND_API.g_ret_sts_success;

17: IS
18: l_valid_flag VARCHAR2(1);
19: BEGIN
20:
21: x_return_status := FND_API.g_ret_sts_success;
22:
23:
24: END Check_Uk_Items;
25:

Line 48: x_return_status := FND_API.g_ret_sts_success;

44: WHERE resource_id = cv_cm_resource_id;
45:
46: BEGIN
47:
48: x_return_status := FND_API.g_ret_sts_success;
49:
50:
51: ----------------------- attribute_id ------------------------
52: IF p_Lead_Owner_rec.CM_resource_id <> FND_API.g_miss_num THEN

Line 52: IF p_Lead_Owner_rec.CM_resource_id <> FND_API.g_miss_num THEN

48: x_return_status := FND_API.g_ret_sts_success;
49:
50:
51: ----------------------- attribute_id ------------------------
52: IF p_Lead_Owner_rec.CM_resource_id <> FND_API.g_miss_num THEN
53:
54: -- Check the uniqueness of the identifier
55: OPEN c_cm_exsist(p_Lead_Owner_rec.CM_RESOURCE_ID);
56: FETCH c_cm_exsist INTO l_cm_exsits;

Line 72: ) = FND_API.g_false

68: 'jtf_rs_resource_extns', -- Parent schema object having the primary key
69: 'resource_id', -- Column name in the parent object that maps to the fk value
70: p_Lead_Owner_rec.CM_resource_id, -- Value of fk to be validated against the parent object's pk column
71: AS_Utility_PVT.g_number -- datatype of fk
72: ) = FND_API.g_false
73: THEN
74: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
75: THEN
76: FND_MESSAGE.set_name('PV', 'PV_BAD_CMM_RESOURCE_ID');

Line 81: x_return_status := FND_API.g_ret_sts_error;

77: FND_MESSAGE.SET_TOKEN('ID', to_char(p_Lead_Owner_rec.CM_resource_id) );
78: FND_MSG_PUB.add;
79: END IF;
80: */
81: x_return_status := FND_API.g_ret_sts_error;
82: RETURN;
83: END IF;
84: END IF;
85:

Line 103: x_return_status := FND_API.g_ret_sts_success;

99: )
100: IS
101: BEGIN
102:
103: x_return_status := FND_API.g_ret_sts_success;
104:
105: /*
106: ------------------------ entity --------------------------
107: IF p_Lead_Owner_rec.entity IS NULL THEN

Line 114: x_return_status := FND_API.g_ret_sts_error;

110: FND_MESSAGE.set_name('PV', 'PV_NO_ENTITY');
111: FND_MSG_PUB.add;
112: END IF;
113:
114: x_return_status := FND_API.g_ret_sts_error;
115: RETURN;
116: ------------------------ attribute id -------------------------------
117: ELSIF p_Lead_Owner_rec.attribute_id IS NULL THEN
118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 125: x_return_status := FND_API.g_ret_sts_error;

121: FND_MESSAGE.SET_TOKEN('ID',to_char(p_Lead_Owner_rec.attribute_id) );
122: FND_MSG_PUB.add;
123: END IF;
124:
125: x_return_status := FND_API.g_ret_sts_error;
126: RETURN;
127: END IF;*/
128:
129: END Check_Req_Items;

Line 143: x_return_status := FND_API.g_ret_sts_success;

139: )
140: IS
141: BEGIN
142:
143: x_return_status := FND_API.g_ret_sts_success;
144:
145:
146: -- check other lookup codes
147:

Line 163: x_return_status := FND_API.g_ret_sts_success;

159: )
160: IS
161: BEGIN
162:
163: x_return_status := FND_API.g_ret_sts_success;
164:
165:
166: END Check_Flag_Items;
167:

Line 187: IF x_return_status <> FND_API.g_ret_sts_success THEN

183: p_Lead_Owner_rec => p_Lead_Owner_rec
184: ,x_return_status => x_return_status
185: );
186:
187: IF x_return_status <> FND_API.g_ret_sts_success THEN
188: RETURN;
189: END IF;
190:
191: --DBMS_output.put_line(': start uk record validate');

Line 198: IF x_return_status <> FND_API.g_ret_sts_success THEN

194: ,p_validation_mode => p_validation_mode
195: ,x_return_status => x_return_status
196: );
197:
198: IF x_return_status <> FND_API.g_ret_sts_success THEN
199: RETURN;
200: END IF;
201:
202: --DBMS_output.put_line(': start fk record validate');

Line 208: IF x_return_status <> FND_API.g_ret_sts_success THEN

204: p_Lead_Owner_rec => p_Lead_Owner_rec
205: ,x_return_status => x_return_status
206: );
207:
208: IF x_return_status <> FND_API.g_ret_sts_success THEN
209: RETURN;
210: END IF;
211:
212: --DBMS_output.put_line(': start lookup record validate');

Line 218: IF x_return_status <> FND_API.g_ret_sts_success THEN

214: p_Lead_Owner_rec => p_Lead_Owner_rec
215: ,x_return_status => x_return_status
216: );
217:
218: IF x_return_status <> FND_API.g_ret_sts_success THEN
219: RETURN;
220: END IF;
221:
222: --DBMS_output.put_line(': start flag record validate');

Line 228: IF x_return_status <> FND_API.g_ret_sts_success THEN

224: p_Lead_Owner_rec => p_Lead_Owner_rec
225: ,x_return_status => x_return_status
226: );
227:
228: IF x_return_status <> FND_API.g_ret_sts_success THEN
229: RETURN;
230: END IF;
231:
232: END Check_Lead_Owner_Items;

Line 251: x_return_status := FND_API.g_ret_sts_success;

247:
248:
249: BEGIN
250:
251: x_return_status := FND_API.g_ret_sts_success;
252:
253:
254:
255: -- do other record level checkings

Line 271: x_Lead_Owner_rec.Lead_Owner_id := FND_API.G_MISS_NUM;

267: )
268: IS
269: BEGIN
270:
271: x_Lead_Owner_rec.Lead_Owner_id := FND_API.G_MISS_NUM;
272: x_Lead_Owner_rec.country := FND_API.G_MISS_CHAR;
273: x_Lead_Owner_rec.from_postal_code := FND_API.G_MISS_CHAR;
274: x_Lead_Owner_rec.to_postal_code := FND_API.G_MISS_CHAR;
275: x_Lead_Owner_rec.CM_resource_id := FND_API.G_MISS_NUM;

Line 272: x_Lead_Owner_rec.country := FND_API.G_MISS_CHAR;

268: IS
269: BEGIN
270:
271: x_Lead_Owner_rec.Lead_Owner_id := FND_API.G_MISS_NUM;
272: x_Lead_Owner_rec.country := FND_API.G_MISS_CHAR;
273: x_Lead_Owner_rec.from_postal_code := FND_API.G_MISS_CHAR;
274: x_Lead_Owner_rec.to_postal_code := FND_API.G_MISS_CHAR;
275: x_Lead_Owner_rec.CM_resource_id := FND_API.G_MISS_NUM;
276: x_Lead_Owner_rec.last_update_date := FND_API.G_MISS_DATE;

Line 273: x_Lead_Owner_rec.from_postal_code := FND_API.G_MISS_CHAR;

269: BEGIN
270:
271: x_Lead_Owner_rec.Lead_Owner_id := FND_API.G_MISS_NUM;
272: x_Lead_Owner_rec.country := FND_API.G_MISS_CHAR;
273: x_Lead_Owner_rec.from_postal_code := FND_API.G_MISS_CHAR;
274: x_Lead_Owner_rec.to_postal_code := FND_API.G_MISS_CHAR;
275: x_Lead_Owner_rec.CM_resource_id := FND_API.G_MISS_NUM;
276: x_Lead_Owner_rec.last_update_date := FND_API.G_MISS_DATE;
277: x_Lead_Owner_rec.last_updated_by := FND_API.G_MISS_NUM;

Line 274: x_Lead_Owner_rec.to_postal_code := FND_API.G_MISS_CHAR;

270:
271: x_Lead_Owner_rec.Lead_Owner_id := FND_API.G_MISS_NUM;
272: x_Lead_Owner_rec.country := FND_API.G_MISS_CHAR;
273: x_Lead_Owner_rec.from_postal_code := FND_API.G_MISS_CHAR;
274: x_Lead_Owner_rec.to_postal_code := FND_API.G_MISS_CHAR;
275: x_Lead_Owner_rec.CM_resource_id := FND_API.G_MISS_NUM;
276: x_Lead_Owner_rec.last_update_date := FND_API.G_MISS_DATE;
277: x_Lead_Owner_rec.last_updated_by := FND_API.G_MISS_NUM;
278: x_Lead_Owner_rec.creation_date := FND_API.G_MISS_DATE;

Line 275: x_Lead_Owner_rec.CM_resource_id := FND_API.G_MISS_NUM;

271: x_Lead_Owner_rec.Lead_Owner_id := FND_API.G_MISS_NUM;
272: x_Lead_Owner_rec.country := FND_API.G_MISS_CHAR;
273: x_Lead_Owner_rec.from_postal_code := FND_API.G_MISS_CHAR;
274: x_Lead_Owner_rec.to_postal_code := FND_API.G_MISS_CHAR;
275: x_Lead_Owner_rec.CM_resource_id := FND_API.G_MISS_NUM;
276: x_Lead_Owner_rec.last_update_date := FND_API.G_MISS_DATE;
277: x_Lead_Owner_rec.last_updated_by := FND_API.G_MISS_NUM;
278: x_Lead_Owner_rec.creation_date := FND_API.G_MISS_DATE;
279: x_Lead_Owner_rec.created_by := FND_API.G_MISS_NUM;

Line 276: x_Lead_Owner_rec.last_update_date := FND_API.G_MISS_DATE;

272: x_Lead_Owner_rec.country := FND_API.G_MISS_CHAR;
273: x_Lead_Owner_rec.from_postal_code := FND_API.G_MISS_CHAR;
274: x_Lead_Owner_rec.to_postal_code := FND_API.G_MISS_CHAR;
275: x_Lead_Owner_rec.CM_resource_id := FND_API.G_MISS_NUM;
276: x_Lead_Owner_rec.last_update_date := FND_API.G_MISS_DATE;
277: x_Lead_Owner_rec.last_updated_by := FND_API.G_MISS_NUM;
278: x_Lead_Owner_rec.creation_date := FND_API.G_MISS_DATE;
279: x_Lead_Owner_rec.created_by := FND_API.G_MISS_NUM;
280: x_Lead_Owner_rec.last_update_login := FND_API.G_MISS_NUM;

Line 277: x_Lead_Owner_rec.last_updated_by := FND_API.G_MISS_NUM;

273: x_Lead_Owner_rec.from_postal_code := FND_API.G_MISS_CHAR;
274: x_Lead_Owner_rec.to_postal_code := FND_API.G_MISS_CHAR;
275: x_Lead_Owner_rec.CM_resource_id := FND_API.G_MISS_NUM;
276: x_Lead_Owner_rec.last_update_date := FND_API.G_MISS_DATE;
277: x_Lead_Owner_rec.last_updated_by := FND_API.G_MISS_NUM;
278: x_Lead_Owner_rec.creation_date := FND_API.G_MISS_DATE;
279: x_Lead_Owner_rec.created_by := FND_API.G_MISS_NUM;
280: x_Lead_Owner_rec.last_update_login := FND_API.G_MISS_NUM;
281: x_Lead_Owner_rec.object_version_number := FND_API.G_MISS_NUM;

Line 278: x_Lead_Owner_rec.creation_date := FND_API.G_MISS_DATE;

274: x_Lead_Owner_rec.to_postal_code := FND_API.G_MISS_CHAR;
275: x_Lead_Owner_rec.CM_resource_id := FND_API.G_MISS_NUM;
276: x_Lead_Owner_rec.last_update_date := FND_API.G_MISS_DATE;
277: x_Lead_Owner_rec.last_updated_by := FND_API.G_MISS_NUM;
278: x_Lead_Owner_rec.creation_date := FND_API.G_MISS_DATE;
279: x_Lead_Owner_rec.created_by := FND_API.G_MISS_NUM;
280: x_Lead_Owner_rec.last_update_login := FND_API.G_MISS_NUM;
281: x_Lead_Owner_rec.object_version_number := FND_API.G_MISS_NUM;
282: x_Lead_Owner_rec.request_id := FND_API.G_MISS_NUM;

Line 279: x_Lead_Owner_rec.created_by := FND_API.G_MISS_NUM;

275: x_Lead_Owner_rec.CM_resource_id := FND_API.G_MISS_NUM;
276: x_Lead_Owner_rec.last_update_date := FND_API.G_MISS_DATE;
277: x_Lead_Owner_rec.last_updated_by := FND_API.G_MISS_NUM;
278: x_Lead_Owner_rec.creation_date := FND_API.G_MISS_DATE;
279: x_Lead_Owner_rec.created_by := FND_API.G_MISS_NUM;
280: x_Lead_Owner_rec.last_update_login := FND_API.G_MISS_NUM;
281: x_Lead_Owner_rec.object_version_number := FND_API.G_MISS_NUM;
282: x_Lead_Owner_rec.request_id := FND_API.G_MISS_NUM;
283: x_Lead_Owner_rec.program_application_id := FND_API.G_MISS_NUM;

Line 280: x_Lead_Owner_rec.last_update_login := FND_API.G_MISS_NUM;

276: x_Lead_Owner_rec.last_update_date := FND_API.G_MISS_DATE;
277: x_Lead_Owner_rec.last_updated_by := FND_API.G_MISS_NUM;
278: x_Lead_Owner_rec.creation_date := FND_API.G_MISS_DATE;
279: x_Lead_Owner_rec.created_by := FND_API.G_MISS_NUM;
280: x_Lead_Owner_rec.last_update_login := FND_API.G_MISS_NUM;
281: x_Lead_Owner_rec.object_version_number := FND_API.G_MISS_NUM;
282: x_Lead_Owner_rec.request_id := FND_API.G_MISS_NUM;
283: x_Lead_Owner_rec.program_application_id := FND_API.G_MISS_NUM;
284: x_Lead_Owner_rec.program_id := FND_API.G_MISS_NUM;

Line 281: x_Lead_Owner_rec.object_version_number := FND_API.G_MISS_NUM;

277: x_Lead_Owner_rec.last_updated_by := FND_API.G_MISS_NUM;
278: x_Lead_Owner_rec.creation_date := FND_API.G_MISS_DATE;
279: x_Lead_Owner_rec.created_by := FND_API.G_MISS_NUM;
280: x_Lead_Owner_rec.last_update_login := FND_API.G_MISS_NUM;
281: x_Lead_Owner_rec.object_version_number := FND_API.G_MISS_NUM;
282: x_Lead_Owner_rec.request_id := FND_API.G_MISS_NUM;
283: x_Lead_Owner_rec.program_application_id := FND_API.G_MISS_NUM;
284: x_Lead_Owner_rec.program_id := FND_API.G_MISS_NUM;
285: x_Lead_Owner_rec.program_update_date := FND_API.G_MISS_DATE;

Line 282: x_Lead_Owner_rec.request_id := FND_API.G_MISS_NUM;

278: x_Lead_Owner_rec.creation_date := FND_API.G_MISS_DATE;
279: x_Lead_Owner_rec.created_by := FND_API.G_MISS_NUM;
280: x_Lead_Owner_rec.last_update_login := FND_API.G_MISS_NUM;
281: x_Lead_Owner_rec.object_version_number := FND_API.G_MISS_NUM;
282: x_Lead_Owner_rec.request_id := FND_API.G_MISS_NUM;
283: x_Lead_Owner_rec.program_application_id := FND_API.G_MISS_NUM;
284: x_Lead_Owner_rec.program_id := FND_API.G_MISS_NUM;
285: x_Lead_Owner_rec.program_update_date := FND_API.G_MISS_DATE;
286:

Line 283: x_Lead_Owner_rec.program_application_id := FND_API.G_MISS_NUM;

279: x_Lead_Owner_rec.created_by := FND_API.G_MISS_NUM;
280: x_Lead_Owner_rec.last_update_login := FND_API.G_MISS_NUM;
281: x_Lead_Owner_rec.object_version_number := FND_API.G_MISS_NUM;
282: x_Lead_Owner_rec.request_id := FND_API.G_MISS_NUM;
283: x_Lead_Owner_rec.program_application_id := FND_API.G_MISS_NUM;
284: x_Lead_Owner_rec.program_id := FND_API.G_MISS_NUM;
285: x_Lead_Owner_rec.program_update_date := FND_API.G_MISS_DATE;
286:
287: END Init_Lead_Owner_Rec;

Line 284: x_Lead_Owner_rec.program_id := FND_API.G_MISS_NUM;

280: x_Lead_Owner_rec.last_update_login := FND_API.G_MISS_NUM;
281: x_Lead_Owner_rec.object_version_number := FND_API.G_MISS_NUM;
282: x_Lead_Owner_rec.request_id := FND_API.G_MISS_NUM;
283: x_Lead_Owner_rec.program_application_id := FND_API.G_MISS_NUM;
284: x_Lead_Owner_rec.program_id := FND_API.G_MISS_NUM;
285: x_Lead_Owner_rec.program_update_date := FND_API.G_MISS_DATE;
286:
287: END Init_Lead_Owner_Rec;
288:

Line 285: x_Lead_Owner_rec.program_update_date := FND_API.G_MISS_DATE;

281: x_Lead_Owner_rec.object_version_number := FND_API.G_MISS_NUM;
282: x_Lead_Owner_rec.request_id := FND_API.G_MISS_NUM;
283: x_Lead_Owner_rec.program_application_id := FND_API.G_MISS_NUM;
284: x_Lead_Owner_rec.program_id := FND_API.G_MISS_NUM;
285: x_Lead_Owner_rec.program_update_date := FND_API.G_MISS_DATE;
286:
287: END Init_Lead_Owner_Rec;
288:
289:

Line 320: RAISE FND_API.g_exc_error;

316: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
317: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
318: FND_MSG_PUB.add;
319: END IF;
320: RAISE FND_API.g_exc_error;
321: END IF;
322: CLOSE c_Lead_Owner;
323:
324: IF p_Lead_Owner_rec.request_id = FND_API.G_MISS_NUM THEN

Line 324: IF p_Lead_Owner_rec.request_id = FND_API.G_MISS_NUM THEN

320: RAISE FND_API.g_exc_error;
321: END IF;
322: CLOSE c_Lead_Owner;
323:
324: IF p_Lead_Owner_rec.request_id = FND_API.G_MISS_NUM THEN
325: x_complete_rec.request_id := l_Lead_Owner_rec.request_id;
326: END IF;
327:
328: IF p_Lead_Owner_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 328: IF p_Lead_Owner_rec.program_application_id = FND_API.G_MISS_NUM THEN

324: IF p_Lead_Owner_rec.request_id = FND_API.G_MISS_NUM THEN
325: x_complete_rec.request_id := l_Lead_Owner_rec.request_id;
326: END IF;
327:
328: IF p_Lead_Owner_rec.program_application_id = FND_API.G_MISS_NUM THEN
329: x_complete_rec.program_application_id := l_Lead_Owner_rec.program_application_id;
330: END IF;
331:
332: IF p_Lead_Owner_rec.program_id = FND_API.G_MISS_NUM THEN

Line 332: IF p_Lead_Owner_rec.program_id = FND_API.G_MISS_NUM THEN

328: IF p_Lead_Owner_rec.program_application_id = FND_API.G_MISS_NUM THEN
329: x_complete_rec.program_application_id := l_Lead_Owner_rec.program_application_id;
330: END IF;
331:
332: IF p_Lead_Owner_rec.program_id = FND_API.G_MISS_NUM THEN
333: x_complete_rec.program_id := l_Lead_Owner_rec.program_id;
334: END IF;
335:
336: IF p_Lead_Owner_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 336: IF p_Lead_Owner_rec.program_update_date = FND_API.G_MISS_DATE THEN

332: IF p_Lead_Owner_rec.program_id = FND_API.G_MISS_NUM THEN
333: x_complete_rec.program_id := l_Lead_Owner_rec.program_id;
334: END IF;
335:
336: IF p_Lead_Owner_rec.program_update_date = FND_API.G_MISS_DATE THEN
337: x_complete_rec.program_update_date := l_Lead_Owner_rec.program_update_date;
338: END IF;
339:
340: IF p_Lead_Owner_rec.country = FND_API.G_MISS_CHAR THEN

Line 340: IF p_Lead_Owner_rec.country = FND_API.G_MISS_CHAR THEN

336: IF p_Lead_Owner_rec.program_update_date = FND_API.G_MISS_DATE THEN
337: x_complete_rec.program_update_date := l_Lead_Owner_rec.program_update_date;
338: END IF;
339:
340: IF p_Lead_Owner_rec.country = FND_API.G_MISS_CHAR THEN
341: x_complete_rec.country := l_Lead_Owner_rec.country;
342: END IF;
343:
344: IF p_Lead_Owner_rec.from_postal_code = FND_API.G_MISS_CHAR THEN

Line 344: IF p_Lead_Owner_rec.from_postal_code = FND_API.G_MISS_CHAR THEN

340: IF p_Lead_Owner_rec.country = FND_API.G_MISS_CHAR THEN
341: x_complete_rec.country := l_Lead_Owner_rec.country;
342: END IF;
343:
344: IF p_Lead_Owner_rec.from_postal_code = FND_API.G_MISS_CHAR THEN
345: x_complete_rec.from_postal_code := l_Lead_Owner_rec.from_postal_code;
346: END IF;
347:
348: IF p_Lead_Owner_rec.referral_type = FND_API.G_MISS_CHAR THEN

Line 348: IF p_Lead_Owner_rec.referral_type = FND_API.G_MISS_CHAR THEN

344: IF p_Lead_Owner_rec.from_postal_code = FND_API.G_MISS_CHAR THEN
345: x_complete_rec.from_postal_code := l_Lead_Owner_rec.from_postal_code;
346: END IF;
347:
348: IF p_Lead_Owner_rec.referral_type = FND_API.G_MISS_CHAR THEN
349: x_complete_rec.referral_type := l_Lead_Owner_rec.referral_type;
350: END IF;
351:
352: IF p_Lead_Owner_rec.owner_flag = FND_API.G_MISS_CHAR THEN

Line 352: IF p_Lead_Owner_rec.owner_flag = FND_API.G_MISS_CHAR THEN

348: IF p_Lead_Owner_rec.referral_type = FND_API.G_MISS_CHAR THEN
349: x_complete_rec.referral_type := l_Lead_Owner_rec.referral_type;
350: END IF;
351:
352: IF p_Lead_Owner_rec.owner_flag = FND_API.G_MISS_CHAR THEN
353: x_complete_rec.owner_flag := l_Lead_Owner_rec.owner_flag;
354: END IF;
355:
356: IF p_Lead_Owner_rec.to_postal_code = FND_API.G_MISS_CHAR THEN

Line 356: IF p_Lead_Owner_rec.to_postal_code = FND_API.G_MISS_CHAR THEN

352: IF p_Lead_Owner_rec.owner_flag = FND_API.G_MISS_CHAR THEN
353: x_complete_rec.owner_flag := l_Lead_Owner_rec.owner_flag;
354: END IF;
355:
356: IF p_Lead_Owner_rec.to_postal_code = FND_API.G_MISS_CHAR THEN
357: x_complete_rec.to_postal_code := l_Lead_Owner_rec.to_postal_code;
358: END IF;
359:
360: IF p_Lead_Owner_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 360: IF p_Lead_Owner_rec.object_version_number = FND_API.G_MISS_NUM THEN

356: IF p_Lead_Owner_rec.to_postal_code = FND_API.G_MISS_CHAR THEN
357: x_complete_rec.to_postal_code := l_Lead_Owner_rec.to_postal_code;
358: END IF;
359:
360: IF p_Lead_Owner_rec.object_version_number = FND_API.G_MISS_NUM THEN
361: x_complete_rec.object_version_number := l_Lead_Owner_rec.object_version_number;
362: END IF;
363:
364:

Line 374: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

370: --
371: --------------------------------------------------------------------
372: PROCEDURE Validate_Lead_Owner(
373: p_api_version IN NUMBER
374: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
375: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
376:
377: ,x_return_status OUT NOCOPY VARCHAR2
378: ,x_msg_count OUT NOCOPY NUMBER

Line 375: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

371: --------------------------------------------------------------------
372: PROCEDURE Validate_Lead_Owner(
373: p_api_version IN NUMBER
374: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
375: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
376:
377: ,x_return_status OUT NOCOPY VARCHAR2
378: ,x_msg_count OUT NOCOPY NUMBER
379: ,x_msg_data OUT NOCOPY VARCHAR2

Line 395: IF FND_API.to_boolean(p_init_msg_list) THEN

391:
392: ----------------------- initialize --------------------
393: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
394:
395: IF FND_API.to_boolean(p_init_msg_list) THEN
396: FND_MSG_PUB.initialize;
397: END IF;
398:
399: IF NOT FND_API.compatible_api_call(

Line 399: IF NOT FND_API.compatible_api_call(

395: IF FND_API.to_boolean(p_init_msg_list) THEN
396: FND_MSG_PUB.initialize;
397: END IF;
398:
399: IF NOT FND_API.compatible_api_call(
400: l_api_version,
401: p_api_version,
402: l_api_name,
403: g_pkg_name

Line 405: RAISE FND_API.g_exc_unexpected_error;

401: p_api_version,
402: l_api_name,
403: g_pkg_name
404: ) THEN
405: RAISE FND_API.g_exc_unexpected_error;
406: END IF;
407:
408: x_return_status := FND_API.g_ret_sts_success;
409:

Line 408: x_return_status := FND_API.g_ret_sts_success;

404: ) THEN
405: RAISE FND_API.g_exc_unexpected_error;
406: END IF;
407:
408: x_return_status := FND_API.g_ret_sts_success;
409:
410: ---------------------- validate ------------------------
411: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': check items');
412: --DBMS_output.put_line(l_full_name||': start item validate');

Line 421: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

417: p_validation_mode => JTF_PLSQL_API.g_create,
418: x_return_status => l_return_status
419: );
420:
421: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
422: RAISE FND_API.g_exc_unexpected_error;
423: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
424: RAISE FND_API.g_exc_error;
425: END IF;

Line 422: RAISE FND_API.g_exc_unexpected_error;

418: x_return_status => l_return_status
419: );
420:
421: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
422: RAISE FND_API.g_exc_unexpected_error;
423: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
424: RAISE FND_API.g_exc_error;
425: END IF;
426: END IF;

Line 423: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

419: );
420:
421: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
422: RAISE FND_API.g_exc_unexpected_error;
423: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
424: RAISE FND_API.g_exc_error;
425: END IF;
426: END IF;
427:

Line 424: RAISE FND_API.g_exc_error;

420:
421: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
422: RAISE FND_API.g_exc_unexpected_error;
423: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
424: RAISE FND_API.g_exc_error;
425: END IF;
426: END IF;
427:
428: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': check record');

Line 438: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

434: p_complete_rec => NULL,
435: x_return_status => l_return_status
436: );
437:
438: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
439: RAISE FND_API.g_exc_unexpected_error;
440: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
441: RAISE FND_API.g_exc_error;
442: END IF;

Line 439: RAISE FND_API.g_exc_unexpected_error;

435: x_return_status => l_return_status
436: );
437:
438: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
439: RAISE FND_API.g_exc_unexpected_error;
440: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
441: RAISE FND_API.g_exc_error;
442: END IF;
443: END IF;

Line 440: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

436: );
437:
438: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
439: RAISE FND_API.g_exc_unexpected_error;
440: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
441: RAISE FND_API.g_exc_error;
442: END IF;
443: END IF;
444:

Line 441: RAISE FND_API.g_exc_error;

437:
438: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
439: RAISE FND_API.g_exc_unexpected_error;
440: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
441: RAISE FND_API.g_exc_error;
442: END IF;
443: END IF;
444:
445: -------------------- finish --------------------------

Line 447: p_encoded => FND_API.g_false,

443: END IF;
444:
445: -------------------- finish --------------------------
446: FND_MSG_PUB.count_and_get(
447: p_encoded => FND_API.g_false,
448: p_count => x_msg_count,
449: p_data => x_msg_data
450: );
451:

Line 456: WHEN FND_API.g_exc_error THEN

452: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
453:
454: EXCEPTION
455:
456: WHEN FND_API.g_exc_error THEN
457: x_return_status := FND_API.g_ret_sts_error;
458: FND_MSG_PUB.count_and_get(
459: p_encoded => FND_API.g_false,
460: p_count => x_msg_count,

Line 457: x_return_status := FND_API.g_ret_sts_error;

453:
454: EXCEPTION
455:
456: WHEN FND_API.g_exc_error THEN
457: x_return_status := FND_API.g_ret_sts_error;
458: FND_MSG_PUB.count_and_get(
459: p_encoded => FND_API.g_false,
460: p_count => x_msg_count,
461: p_data => x_msg_data

Line 459: p_encoded => FND_API.g_false,

455:
456: WHEN FND_API.g_exc_error THEN
457: x_return_status := FND_API.g_ret_sts_error;
458: FND_MSG_PUB.count_and_get(
459: p_encoded => FND_API.g_false,
460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );
463:

Line 464: WHEN FND_API.g_exc_unexpected_error THEN

460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );
463:
464: WHEN FND_API.g_exc_unexpected_error THEN
465: x_return_status := FND_API.g_ret_sts_unexp_error ;
466: FND_MSG_PUB.count_and_get(
467: p_encoded => FND_API.g_false,
468: p_count => x_msg_count,

Line 465: x_return_status := FND_API.g_ret_sts_unexp_error ;

461: p_data => x_msg_data
462: );
463:
464: WHEN FND_API.g_exc_unexpected_error THEN
465: x_return_status := FND_API.g_ret_sts_unexp_error ;
466: FND_MSG_PUB.count_and_get(
467: p_encoded => FND_API.g_false,
468: p_count => x_msg_count,
469: p_data => x_msg_data

Line 467: p_encoded => FND_API.g_false,

463:
464: WHEN FND_API.g_exc_unexpected_error THEN
465: x_return_status := FND_API.g_ret_sts_unexp_error ;
466: FND_MSG_PUB.count_and_get(
467: p_encoded => FND_API.g_false,
468: p_count => x_msg_count,
469: p_data => x_msg_data
470: );
471:

Line 473: x_return_status := FND_API.g_ret_sts_unexp_error;

469: p_data => x_msg_data
470: );
471:
472: WHEN OTHERS THEN
473: x_return_status := FND_API.g_ret_sts_unexp_error;
474: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
475: THEN
476: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
477: END IF;

Line 480: p_encoded => FND_API.g_false,

476: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
477: END IF;
478:
479: FND_MSG_PUB.count_and_get(
480: p_encoded => FND_API.g_false,
481: p_count => x_msg_count,
482: p_data => x_msg_data
483: );
484:

Line 511: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.

507: -- the sequence.
508: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
509: -- Raise exception for invalid flag.
510: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
511: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
512: ---------------------------------------------------------------------
513: PROCEDURE Create_Lead_Owner(
514: p_api_version IN NUMBER
515: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

Line 515: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

511: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
512: ---------------------------------------------------------------------
513: PROCEDURE Create_Lead_Owner(
514: p_api_version IN NUMBER
515: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
516: ,p_commit IN VARCHAR2 := FND_API.g_false
517: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
518:
519: ,x_return_status OUT NOCOPY VARCHAR2

Line 516: ,p_commit IN VARCHAR2 := FND_API.g_false

512: ---------------------------------------------------------------------
513: PROCEDURE Create_Lead_Owner(
514: p_api_version IN NUMBER
515: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
516: ,p_commit IN VARCHAR2 := FND_API.g_false
517: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
518:
519: ,x_return_status OUT NOCOPY VARCHAR2
520: ,x_msg_count OUT NOCOPY NUMBER

Line 517: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

513: PROCEDURE Create_Lead_Owner(
514: p_api_version IN NUMBER
515: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
516: ,p_commit IN VARCHAR2 := FND_API.g_false
517: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
518:
519: ,x_return_status OUT NOCOPY VARCHAR2
520: ,x_msg_count OUT NOCOPY NUMBER
521: ,x_msg_data OUT NOCOPY VARCHAR2

Line 559: IF FND_API.to_boolean(p_init_msg_list) THEN

555:
556: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
557:
558:
559: IF FND_API.to_boolean(p_init_msg_list) THEN
560: FND_MSG_PUB.initialize;
561: END IF;
562:
563: IF NOT FND_API.compatible_api_call(

Line 563: IF NOT FND_API.compatible_api_call(

559: IF FND_API.to_boolean(p_init_msg_list) THEN
560: FND_MSG_PUB.initialize;
561: END IF;
562:
563: IF NOT FND_API.compatible_api_call(
564: l_api_version,
565: p_api_version,
566: l_api_name,
567: g_pkg_name

Line 569: RAISE FND_API.g_exc_unexpected_error;

565: p_api_version,
566: l_api_name,
567: g_pkg_name
568: ) THEN
569: RAISE FND_API.g_exc_unexpected_error;
570: END IF;
571:
572: x_return_status := FND_API.g_ret_sts_success;
573:

Line 572: x_return_status := FND_API.g_ret_sts_success;

568: ) THEN
569: RAISE FND_API.g_exc_unexpected_error;
570: END IF;
571:
572: x_return_status := FND_API.g_ret_sts_success;
573:
574: ----------------------- validate -----------------------
575: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');
576:

Line 589: IF l_return_status = FND_API.g_ret_sts_error THEN

585: p_Lead_Owner_rec => l_Lead_Owner_rec
586: );
587:
588:
589: IF l_return_status = FND_API.g_ret_sts_error THEN
590: RAISE FND_API.g_exc_error;
591: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
592: RAISE FND_API.g_exc_unexpected_error;
593: END IF;

Line 590: RAISE FND_API.g_exc_error;

586: );
587:
588:
589: IF l_return_status = FND_API.g_ret_sts_error THEN
590: RAISE FND_API.g_exc_error;
591: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
592: RAISE FND_API.g_exc_unexpected_error;
593: END IF;
594:

Line 591: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

587:
588:
589: IF l_return_status = FND_API.g_ret_sts_error THEN
590: RAISE FND_API.g_exc_error;
591: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
592: RAISE FND_API.g_exc_unexpected_error;
593: END IF;
594:
595:

Line 592: RAISE FND_API.g_exc_unexpected_error;

588:
589: IF l_return_status = FND_API.g_ret_sts_error THEN
590: RAISE FND_API.g_exc_error;
591: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
592: RAISE FND_API.g_exc_unexpected_error;
593: END IF;
594:
595:
596: --DBMS_output.put_line(l_full_name||': back validate');

Line 622: RAISE FND_API.g_exc_error;

618: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
619: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');
620: FND_MSG_PUB.add;
621: END IF;
622: RAISE FND_API.g_exc_error;
623: END IF;
624:
625: --DBMS_output.put_line(l_full_name||': start insert');
626: INSERT INTO AS_SALES_LEAD_OWNERS (

Line 670: IF l_return_status = FND_API.g_ret_sts_error THEN

666:
667: ------------------------- finish -------------------------------
668: x_Lead_Owner_id := l_Lead_Owner_rec.Lead_Owner_id;
669:
670: IF l_return_status = FND_API.g_ret_sts_error THEN
671: RAISE FND_API.g_exc_error;
672: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
673: RAISE FND_API.g_exc_unexpected_error;
674: END IF;

Line 671: RAISE FND_API.g_exc_error;

667: ------------------------- finish -------------------------------
668: x_Lead_Owner_id := l_Lead_Owner_rec.Lead_Owner_id;
669:
670: IF l_return_status = FND_API.g_ret_sts_error THEN
671: RAISE FND_API.g_exc_error;
672: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
673: RAISE FND_API.g_exc_unexpected_error;
674: END IF;
675:

Line 672: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

668: x_Lead_Owner_id := l_Lead_Owner_rec.Lead_Owner_id;
669:
670: IF l_return_status = FND_API.g_ret_sts_error THEN
671: RAISE FND_API.g_exc_error;
672: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
673: RAISE FND_API.g_exc_unexpected_error;
674: END IF;
675:
676:

Line 673: RAISE FND_API.g_exc_unexpected_error;

669:
670: IF l_return_status = FND_API.g_ret_sts_error THEN
671: RAISE FND_API.g_exc_error;
672: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
673: RAISE FND_API.g_exc_unexpected_error;
674: END IF;
675:
676:
677: -- Check for commit

Line 678: IF FND_API.to_boolean(p_commit) THEN

674: END IF;
675:
676:
677: -- Check for commit
678: IF FND_API.to_boolean(p_commit) THEN
679: COMMIT;
680: END IF;
681:
682: FND_MSG_PUB.count_and_get(

Line 683: p_encoded => FND_API.g_false,

679: COMMIT;
680: END IF;
681:
682: FND_MSG_PUB.count_and_get(
683: p_encoded => FND_API.g_false,
684: p_count => x_msg_count,
685: p_data => x_msg_data
686: );
687:

Line 692: WHEN FND_API.g_exc_error THEN

688: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
689:
690: EXCEPTION
691:
692: WHEN FND_API.g_exc_error THEN
693: ROLLBACK TO Create_Lead_Owner;
694: x_return_status := FND_API.g_ret_sts_error;
695: FND_MSG_PUB.count_and_get (
696: p_encoded => FND_API.g_false

Line 694: x_return_status := FND_API.g_ret_sts_error;

690: EXCEPTION
691:
692: WHEN FND_API.g_exc_error THEN
693: ROLLBACK TO Create_Lead_Owner;
694: x_return_status := FND_API.g_ret_sts_error;
695: FND_MSG_PUB.count_and_get (
696: p_encoded => FND_API.g_false
697: ,p_count => x_msg_count
698: ,p_data => x_msg_data

Line 696: p_encoded => FND_API.g_false

692: WHEN FND_API.g_exc_error THEN
693: ROLLBACK TO Create_Lead_Owner;
694: x_return_status := FND_API.g_ret_sts_error;
695: FND_MSG_PUB.count_and_get (
696: p_encoded => FND_API.g_false
697: ,p_count => x_msg_count
698: ,p_data => x_msg_data
699: );
700:

Line 701: WHEN FND_API.g_exc_unexpected_error THEN

697: ,p_count => x_msg_count
698: ,p_data => x_msg_data
699: );
700:
701: WHEN FND_API.g_exc_unexpected_error THEN
702: ROLLBACK TO Create_Lead_Owner;
703: x_return_status := FND_API.g_ret_sts_unexp_error ;
704: FND_MSG_PUB.count_and_get (
705: p_encoded => FND_API.g_false

Line 703: x_return_status := FND_API.g_ret_sts_unexp_error ;

699: );
700:
701: WHEN FND_API.g_exc_unexpected_error THEN
702: ROLLBACK TO Create_Lead_Owner;
703: x_return_status := FND_API.g_ret_sts_unexp_error ;
704: FND_MSG_PUB.count_and_get (
705: p_encoded => FND_API.g_false
706: ,p_count => x_msg_count
707: ,p_data => x_msg_data

Line 705: p_encoded => FND_API.g_false

701: WHEN FND_API.g_exc_unexpected_error THEN
702: ROLLBACK TO Create_Lead_Owner;
703: x_return_status := FND_API.g_ret_sts_unexp_error ;
704: FND_MSG_PUB.count_and_get (
705: p_encoded => FND_API.g_false
706: ,p_count => x_msg_count
707: ,p_data => x_msg_data
708: );
709:

Line 713: x_return_status := FND_API.g_ret_sts_unexp_error ;

709:
710:
711: WHEN OTHERS THEN
712: ROLLBACK TO Create_Lead_Owner;
713: x_return_status := FND_API.g_ret_sts_unexp_error ;
714:
715: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
716: THEN
717: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 721: p_encoded => FND_API.g_false

717: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
718: END IF;
719:
720: FND_MSG_PUB.count_and_get(
721: p_encoded => FND_API.g_false
722: ,p_count => x_msg_count
723: ,p_data => x_msg_data
724: );
725:

Line 736: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

732: --
733: ---------------------------------------------------------------
734: PROCEDURE Delete_Lead_Owner(
735: p_api_version IN NUMBER
736: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
737: ,p_commit IN VARCHAR2 := FND_API.g_false
738:
739: ,x_return_status OUT NOCOPY VARCHAR2
740: ,x_msg_count OUT NOCOPY NUMBER

Line 737: ,p_commit IN VARCHAR2 := FND_API.g_false

733: ---------------------------------------------------------------
734: PROCEDURE Delete_Lead_Owner(
735: p_api_version IN NUMBER
736: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
737: ,p_commit IN VARCHAR2 := FND_API.g_false
738:
739: ,x_return_status OUT NOCOPY VARCHAR2
740: ,x_msg_count OUT NOCOPY NUMBER
741: ,x_msg_data OUT NOCOPY VARCHAR2

Line 760: IF FND_API.to_boolean(p_init_msg_list) THEN

756: SAVEPOINT Delete_Lead_Owner;
757:
758: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
759:
760: IF FND_API.to_boolean(p_init_msg_list) THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763:
764: IF NOT FND_API.compatible_api_call(

Line 764: IF NOT FND_API.compatible_api_call(

760: IF FND_API.to_boolean(p_init_msg_list) THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763:
764: IF NOT FND_API.compatible_api_call(
765: l_api_version,
766: p_api_version,
767: l_api_name,
768: g_pkg_name

Line 770: RAISE FND_API.g_exc_unexpected_error;

766: p_api_version,
767: l_api_name,
768: g_pkg_name
769: ) THEN
770: RAISE FND_API.g_exc_unexpected_error;
771: END IF;
772:
773: x_return_status := FND_API.G_RET_STS_SUCCESS;
774:

Line 773: x_return_status := FND_API.G_RET_STS_SUCCESS;

769: ) THEN
770: RAISE FND_API.g_exc_unexpected_error;
771: END IF;
772:
773: x_return_status := FND_API.G_RET_STS_SUCCESS;
774:
775: ------------------------ delete ------------------------
776: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': delete');
777:

Line 788: RAISE FND_API.g_exc_error;

784: THEN
785: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
786: FND_MSG_PUB.add;
787: END IF;
788: RAISE FND_API.g_exc_error;
789: END IF;
790:
791: -------------------- finish --------------------------
792: IF FND_API.to_boolean(p_commit) THEN

Line 792: IF FND_API.to_boolean(p_commit) THEN

788: RAISE FND_API.g_exc_error;
789: END IF;
790:
791: -------------------- finish --------------------------
792: IF FND_API.to_boolean(p_commit) THEN
793: COMMIT;
794: END IF;
795:
796: FND_MSG_PUB.count_and_get(

Line 797: p_encoded => FND_API.g_false,

793: COMMIT;
794: END IF;
795:
796: FND_MSG_PUB.count_and_get(
797: p_encoded => FND_API.g_false,
798: p_count => x_msg_count,
799: p_data => x_msg_data
800: );
801:

Line 806: WHEN FND_API.g_exc_error THEN

802: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
803:
804: EXCEPTION
805:
806: WHEN FND_API.g_exc_error THEN
807: ROLLBACK TO Delete_Lead_Owner;
808: x_return_status := FND_API.g_ret_sts_error;
809: FND_MSG_PUB.count_and_get(
810: p_encoded => FND_API.g_false,

Line 808: x_return_status := FND_API.g_ret_sts_error;

804: EXCEPTION
805:
806: WHEN FND_API.g_exc_error THEN
807: ROLLBACK TO Delete_Lead_Owner;
808: x_return_status := FND_API.g_ret_sts_error;
809: FND_MSG_PUB.count_and_get(
810: p_encoded => FND_API.g_false,
811: p_count => x_msg_count,
812: p_data => x_msg_data

Line 810: p_encoded => FND_API.g_false,

806: WHEN FND_API.g_exc_error THEN
807: ROLLBACK TO Delete_Lead_Owner;
808: x_return_status := FND_API.g_ret_sts_error;
809: FND_MSG_PUB.count_and_get(
810: p_encoded => FND_API.g_false,
811: p_count => x_msg_count,
812: p_data => x_msg_data
813: );
814:

Line 815: WHEN FND_API.g_exc_unexpected_error THEN

811: p_count => x_msg_count,
812: p_data => x_msg_data
813: );
814:
815: WHEN FND_API.g_exc_unexpected_error THEN
816: ROLLBACK TO Delete_Lead_Owner;
817: x_return_status := FND_API.g_ret_sts_unexp_error ;
818: FND_MSG_PUB.count_and_get(
819: p_encoded => FND_API.g_false,

Line 817: x_return_status := FND_API.g_ret_sts_unexp_error ;

813: );
814:
815: WHEN FND_API.g_exc_unexpected_error THEN
816: ROLLBACK TO Delete_Lead_Owner;
817: x_return_status := FND_API.g_ret_sts_unexp_error ;
818: FND_MSG_PUB.count_and_get(
819: p_encoded => FND_API.g_false,
820: p_count => x_msg_count,
821: p_data => x_msg_data

Line 819: p_encoded => FND_API.g_false,

815: WHEN FND_API.g_exc_unexpected_error THEN
816: ROLLBACK TO Delete_Lead_Owner;
817: x_return_status := FND_API.g_ret_sts_unexp_error ;
818: FND_MSG_PUB.count_and_get(
819: p_encoded => FND_API.g_false,
820: p_count => x_msg_count,
821: p_data => x_msg_data
822: );
823:

Line 826: x_return_status := FND_API.g_ret_sts_unexp_error ;

822: );
823:
824: WHEN OTHERS THEN
825: ROLLBACK TO Delete_Lead_Owner;
826: x_return_status := FND_API.g_ret_sts_unexp_error ;
827:
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
829: THEN
830: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 834: p_encoded => FND_API.g_false,

830: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
831: END IF;
832:
833: FND_MSG_PUB.count_and_get(
834: p_encoded => FND_API.g_false,
835: p_count => x_msg_count,
836: p_data => x_msg_data
837: );
838:

Line 850: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

846: --------------------------------------------------------------------
847: /*
848: PROCEDURE Lock_Lead_Owner(
849: p_api_version IN NUMBER
850: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
851:
852: ,x_return_status OUT NOCOPY VARCHAR2
853: ,x_msg_count OUT NOCOPY NUMBER
854: ,x_msg_data OUT NOCOPY VARCHAR2

Line 879: IF FND_API.to_boolean(p_init_msg_list) THEN

875:
876: -------------------- initialize ------------------------
877: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
878:
879: IF FND_API.to_boolean(p_init_msg_list) THEN
880: FND_MSG_PUB.initialize;
881: END IF;
882:
883: IF NOT FND_API.compatible_api_call(

Line 883: IF NOT FND_API.compatible_api_call(

879: IF FND_API.to_boolean(p_init_msg_list) THEN
880: FND_MSG_PUB.initialize;
881: END IF;
882:
883: IF NOT FND_API.compatible_api_call(
884: l_api_version,
885: p_api_version,
886: l_api_name,
887: g_pkg_name

Line 889: RAISE FND_API.g_exc_unexpected_error;

885: p_api_version,
886: l_api_name,
887: g_pkg_name
888: ) THEN
889: RAISE FND_API.g_exc_unexpected_error;
890: END IF;
891:
892: x_return_status := FND_API.G_RET_STS_SUCCESS;
893:

Line 892: x_return_status := FND_API.G_RET_STS_SUCCESS;

888: ) THEN
889: RAISE FND_API.g_exc_unexpected_error;
890: END IF;
891:
892: x_return_status := FND_API.G_RET_STS_SUCCESS;
893:
894: ------------------------ lock -------------------------
895: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': lock');
896:

Line 905: RAISE FND_API.g_exc_error;

901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
902: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
903: FND_MSG_PUB.add;
904: END IF;
905: RAISE FND_API.g_exc_error;
906: END IF;
907: CLOSE c_Lead_Owner;
908:
909:

Line 912: p_encoded => FND_API.g_false,

908:
909:
910: -------------------- finish --------------------------
911: FND_MSG_PUB.count_and_get(
912: p_encoded => FND_API.g_false,
913: p_count => x_msg_count,
914: p_data => x_msg_data
915: );
916:

Line 922: x_return_status := FND_API.g_ret_sts_error;

918:
919: EXCEPTION
920:
921: WHEN AS_Utility_PVT.resource_locked THEN
922: x_return_status := FND_API.g_ret_sts_error;
923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
924: FND_MESSAGE.set_name('PV', 'PV_RESOURCE_LOCKED');
925: FND_MSG_PUB.add;
926: END IF;

Line 929: p_encoded => FND_API.g_false,

925: FND_MSG_PUB.add;
926: END IF;
927:
928: FND_MSG_PUB.count_and_get(
929: p_encoded => FND_API.g_false,
930: p_count => x_msg_count,
931: p_data => x_msg_data
932: );
933:

Line 934: WHEN FND_API.g_exc_error THEN

930: p_count => x_msg_count,
931: p_data => x_msg_data
932: );
933:
934: WHEN FND_API.g_exc_error THEN
935: x_return_status := FND_API.g_ret_sts_error;
936: FND_MSG_PUB.count_and_get(
937: p_encoded => FND_API.g_false,
938: p_count => x_msg_count,

Line 935: x_return_status := FND_API.g_ret_sts_error;

931: p_data => x_msg_data
932: );
933:
934: WHEN FND_API.g_exc_error THEN
935: x_return_status := FND_API.g_ret_sts_error;
936: FND_MSG_PUB.count_and_get(
937: p_encoded => FND_API.g_false,
938: p_count => x_msg_count,
939: p_data => x_msg_data

Line 937: p_encoded => FND_API.g_false,

933:
934: WHEN FND_API.g_exc_error THEN
935: x_return_status := FND_API.g_ret_sts_error;
936: FND_MSG_PUB.count_and_get(
937: p_encoded => FND_API.g_false,
938: p_count => x_msg_count,
939: p_data => x_msg_data
940: );
941:

Line 942: WHEN FND_API.g_exc_unexpected_error THEN

938: p_count => x_msg_count,
939: p_data => x_msg_data
940: );
941:
942: WHEN FND_API.g_exc_unexpected_error THEN
943: x_return_status := FND_API.g_ret_sts_unexp_error ;
944: FND_MSG_PUB.count_and_get(
945: p_encoded => FND_API.g_false,
946: p_count => x_msg_count,

Line 943: x_return_status := FND_API.g_ret_sts_unexp_error ;

939: p_data => x_msg_data
940: );
941:
942: WHEN FND_API.g_exc_unexpected_error THEN
943: x_return_status := FND_API.g_ret_sts_unexp_error ;
944: FND_MSG_PUB.count_and_get(
945: p_encoded => FND_API.g_false,
946: p_count => x_msg_count,
947: p_data => x_msg_data

Line 945: p_encoded => FND_API.g_false,

941:
942: WHEN FND_API.g_exc_unexpected_error THEN
943: x_return_status := FND_API.g_ret_sts_unexp_error ;
944: FND_MSG_PUB.count_and_get(
945: p_encoded => FND_API.g_false,
946: p_count => x_msg_count,
947: p_data => x_msg_data
948: );
949:

Line 951: x_return_status := FND_API.g_ret_sts_unexp_error ;

947: p_data => x_msg_data
948: );
949:
950: WHEN OTHERS THEN
951: x_return_status := FND_API.g_ret_sts_unexp_error ;
952: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
953: THEN
954: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
955: END IF;

Line 958: p_encoded => FND_API.g_false,

954: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
955: END IF;
956:
957: FND_MSG_PUB.count_and_get(
958: p_encoded => FND_API.g_false,
959: p_count => x_msg_count,
960: p_data => x_msg_data
961: );
962:

Line 972: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

968: -- Update_Lead_Owner
969: ----------------------------------------------------------------------
970: PROCEDURE Update_Lead_Owner(
971: p_api_version IN NUMBER
972: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
973: ,p_commit IN VARCHAR2 := FND_API.g_false
974: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
975:
976: ,x_return_status OUT NOCOPY VARCHAR2

Line 973: ,p_commit IN VARCHAR2 := FND_API.g_false

969: ----------------------------------------------------------------------
970: PROCEDURE Update_Lead_Owner(
971: p_api_version IN NUMBER
972: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
973: ,p_commit IN VARCHAR2 := FND_API.g_false
974: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
975:
976: ,x_return_status OUT NOCOPY VARCHAR2
977: ,x_msg_count OUT NOCOPY NUMBER

Line 974: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

970: PROCEDURE Update_Lead_Owner(
971: p_api_version IN NUMBER
972: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
973: ,p_commit IN VARCHAR2 := FND_API.g_false
974: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
975:
976: ,x_return_status OUT NOCOPY VARCHAR2
977: ,x_msg_count OUT NOCOPY NUMBER
978: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1000: IF FND_API.to_boolean(p_init_msg_list) THEN

996: SAVEPOINT Update_Lead_Owner;
997:
998: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
999:
1000: IF FND_API.to_boolean(p_init_msg_list) THEN
1001: FND_MSG_PUB.initialize;
1002: END IF;
1003:
1004: IF NOT FND_API.compatible_api_call(

Line 1004: IF NOT FND_API.compatible_api_call(

1000: IF FND_API.to_boolean(p_init_msg_list) THEN
1001: FND_MSG_PUB.initialize;
1002: END IF;
1003:
1004: IF NOT FND_API.compatible_api_call(
1005: l_api_version,
1006: p_api_version,
1007: l_api_name,
1008: g_pkg_name

Line 1010: RAISE FND_API.g_exc_unexpected_error;

1006: p_api_version,
1007: l_api_name,
1008: g_pkg_name
1009: ) THEN
1010: RAISE FND_API.g_exc_unexpected_error;
1011: END IF;
1012:
1013: x_return_status := FND_API.G_RET_STS_SUCCESS;
1014:

Line 1013: x_return_status := FND_API.G_RET_STS_SUCCESS;

1009: ) THEN
1010: RAISE FND_API.g_exc_unexpected_error;
1011: END IF;
1012:
1013: x_return_status := FND_API.G_RET_STS_SUCCESS;
1014:
1015:
1016: ----------------------- validate ----------------------
1017: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');

Line 1024: RAISE FND_API.g_exc_error;

1020: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1021: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');
1022: FND_MSG_PUB.add;
1023: END IF;
1024: RAISE FND_API.g_exc_error;
1025: END IF;
1026:
1027: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1028: Check_Lead_Owner_Items(

Line 1034: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1030: p_validation_mode => JTF_PLSQL_API.g_update,
1031: x_return_status => l_return_status
1032: );
1033:
1034: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1035: RAISE FND_API.g_exc_unexpected_error;
1036: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1037: RAISE FND_API.g_exc_error;
1038: END IF;

Line 1035: RAISE FND_API.g_exc_unexpected_error;

1031: x_return_status => l_return_status
1032: );
1033:
1034: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1035: RAISE FND_API.g_exc_unexpected_error;
1036: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1037: RAISE FND_API.g_exc_error;
1038: END IF;
1039: END IF;

Line 1036: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1032: );
1033:
1034: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1035: RAISE FND_API.g_exc_unexpected_error;
1036: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1037: RAISE FND_API.g_exc_error;
1038: END IF;
1039: END IF;
1040:

Line 1037: RAISE FND_API.g_exc_error;

1033:
1034: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1035: RAISE FND_API.g_exc_unexpected_error;
1036: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1037: RAISE FND_API.g_exc_error;
1038: END IF;
1039: END IF;
1040:
1041: -- replace g_miss_char/num/date with current column values

Line 1052: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1048: p_mode => l_mode,
1049: x_return_status => l_return_status
1050: );
1051:
1052: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1053: RAISE FND_API.g_exc_unexpected_error;
1054: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1055: RAISE FND_API.g_exc_error;
1056: END IF;

Line 1053: RAISE FND_API.g_exc_unexpected_error;

1049: x_return_status => l_return_status
1050: );
1051:
1052: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1053: RAISE FND_API.g_exc_unexpected_error;
1054: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1055: RAISE FND_API.g_exc_error;
1056: END IF;
1057: END IF;

Line 1054: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1050: );
1051:
1052: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1053: RAISE FND_API.g_exc_unexpected_error;
1054: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1055: RAISE FND_API.g_exc_error;
1056: END IF;
1057: END IF;
1058:

Line 1055: RAISE FND_API.g_exc_error;

1051:
1052: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1053: RAISE FND_API.g_exc_unexpected_error;
1054: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1055: RAISE FND_API.g_exc_error;
1056: END IF;
1057: END IF;
1058:
1059:

Line 1087: RAISE FND_API.g_exc_error;

1083: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1084: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
1085: FND_MSG_PUB.add;
1086: END IF;
1087: RAISE FND_API.g_exc_error;
1088: END IF;
1089:
1090: -------------------- finish --------------------------
1091:

Line 1093: IF FND_API.to_boolean(p_commit) THEN

1089:
1090: -------------------- finish --------------------------
1091:
1092: -- Check for commit
1093: IF FND_API.to_boolean(p_commit) THEN
1094: COMMIT;
1095: END IF;
1096:
1097: FND_MSG_PUB.count_and_get(

Line 1098: p_encoded => FND_API.g_false,

1094: COMMIT;
1095: END IF;
1096:
1097: FND_MSG_PUB.count_and_get(
1098: p_encoded => FND_API.g_false,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data
1101: );
1102:

Line 1107: WHEN FND_API.g_exc_error THEN

1103: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
1104:
1105: EXCEPTION
1106:
1107: WHEN FND_API.g_exc_error THEN
1108: ROLLBACK TO Update_Lead_Owner;
1109: x_return_status := FND_API.g_ret_sts_error;
1110: FND_MSG_PUB.count_and_get(
1111: p_encoded => FND_API.g_false,

Line 1109: x_return_status := FND_API.g_ret_sts_error;

1105: EXCEPTION
1106:
1107: WHEN FND_API.g_exc_error THEN
1108: ROLLBACK TO Update_Lead_Owner;
1109: x_return_status := FND_API.g_ret_sts_error;
1110: FND_MSG_PUB.count_and_get(
1111: p_encoded => FND_API.g_false,
1112: p_count => x_msg_count,
1113: p_data => x_msg_data

Line 1111: p_encoded => FND_API.g_false,

1107: WHEN FND_API.g_exc_error THEN
1108: ROLLBACK TO Update_Lead_Owner;
1109: x_return_status := FND_API.g_ret_sts_error;
1110: FND_MSG_PUB.count_and_get(
1111: p_encoded => FND_API.g_false,
1112: p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );
1115:

Line 1116: WHEN FND_API.g_exc_unexpected_error THEN

1112: p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );
1115:
1116: WHEN FND_API.g_exc_unexpected_error THEN
1117: ROLLBACK TO Update_Lead_Owner;
1118: x_return_status := FND_API.g_ret_sts_unexp_error ;
1119: FND_MSG_PUB.count_and_get(
1120: p_encoded => FND_API.g_false,

Line 1118: x_return_status := FND_API.g_ret_sts_unexp_error ;

1114: );
1115:
1116: WHEN FND_API.g_exc_unexpected_error THEN
1117: ROLLBACK TO Update_Lead_Owner;
1118: x_return_status := FND_API.g_ret_sts_unexp_error ;
1119: FND_MSG_PUB.count_and_get(
1120: p_encoded => FND_API.g_false,
1121: p_count => x_msg_count,
1122: p_data => x_msg_data

Line 1120: p_encoded => FND_API.g_false,

1116: WHEN FND_API.g_exc_unexpected_error THEN
1117: ROLLBACK TO Update_Lead_Owner;
1118: x_return_status := FND_API.g_ret_sts_unexp_error ;
1119: FND_MSG_PUB.count_and_get(
1120: p_encoded => FND_API.g_false,
1121: p_count => x_msg_count,
1122: p_data => x_msg_data
1123: );
1124:

Line 1127: x_return_status := FND_API.g_ret_sts_unexp_error ;

1123: );
1124:
1125: WHEN OTHERS THEN
1126: ROLLBACK TO Update_Lead_Owner;
1127: x_return_status := FND_API.g_ret_sts_unexp_error ;
1128:
1129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1130: THEN
1131: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1135: p_encoded => FND_API.g_false,

1131: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1132: END IF;
1133:
1134: FND_MSG_PUB.count_and_get(
1135: p_encoded => FND_API.g_false,
1136: p_count => x_msg_count,
1137: p_data => x_msg_data
1138: );
1139:

Line 1149: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

1145: -- Get_Salesreps
1146: ----------------------------------------------------------------------
1147: PROCEDURE Get_Salesreps(
1148: p_api_version IN NUMBER
1149: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1150: ,p_commit IN VARCHAR2 := FND_API.g_false
1151: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1152:
1153: ,p_sales_lead_id IN NUMBER

Line 1150: ,p_commit IN VARCHAR2 := FND_API.g_false

1146: ----------------------------------------------------------------------
1147: PROCEDURE Get_Salesreps(
1148: p_api_version IN NUMBER
1149: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1150: ,p_commit IN VARCHAR2 := FND_API.g_false
1151: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1152:
1153: ,p_sales_lead_id IN NUMBER
1154: ,x_salesreps_tbl OUT NOCOPY lead_owner_rec_tbl_type

Line 1151: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

1147: PROCEDURE Get_Salesreps(
1148: p_api_version IN NUMBER
1149: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1150: ,p_commit IN VARCHAR2 := FND_API.g_false
1151: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1152:
1153: ,p_sales_lead_id IN NUMBER
1154: ,x_salesreps_tbl OUT NOCOPY lead_owner_rec_tbl_type
1155:

Line 1203: IF FND_API.to_boolean(p_init_msg_list) THEN

1199: SAVEPOINT Get_Salesreps;
1200:
1201: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
1202:
1203: IF FND_API.to_boolean(p_init_msg_list) THEN
1204: FND_MSG_PUB.initialize;
1205: END IF;
1206:
1207: IF NOT FND_API.compatible_api_call(

Line 1207: IF NOT FND_API.compatible_api_call(

1203: IF FND_API.to_boolean(p_init_msg_list) THEN
1204: FND_MSG_PUB.initialize;
1205: END IF;
1206:
1207: IF NOT FND_API.compatible_api_call(
1208: l_api_version,
1209: p_api_version,
1210: l_api_name,
1211: g_pkg_name

Line 1213: RAISE FND_API.g_exc_unexpected_error;

1209: p_api_version,
1210: l_api_name,
1211: g_pkg_name
1212: ) THEN
1213: RAISE FND_API.g_exc_unexpected_error;
1214: END IF;
1215:
1216: x_return_status := FND_API.G_RET_STS_SUCCESS;
1217:

Line 1216: x_return_status := FND_API.G_RET_STS_SUCCESS;

1212: ) THEN
1213: RAISE FND_API.g_exc_unexpected_error;
1214: END IF;
1215:
1216: x_return_status := FND_API.G_RET_STS_SUCCESS;
1217:
1218: ----------------------- validate ----------------------
1219: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');
1220:

Line 1226: RAISE FND_API.g_exc_error;

1222: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1223: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');
1224: FND_MSG_PUB.add;
1225: END IF;
1226: RAISE FND_API.g_exc_error;
1227: ELSE
1228: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1229: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1230: fnd_message.Set_Token('TEXT', 'Sales lead id : ' || p_sales_lead_id);

Line 1274: IF FND_API.to_boolean(p_commit) THEN

1270: end loop;
1271: close lc_lead_owners_country;
1272: end if;
1273: -- Check for commit
1274: IF FND_API.to_boolean(p_commit) THEN
1275: COMMIT;
1276: END IF;
1277:
1278: FND_MSG_PUB.count_and_get(

Line 1279: p_encoded => FND_API.g_false,

1275: COMMIT;
1276: END IF;
1277:
1278: FND_MSG_PUB.count_and_get(
1279: p_encoded => FND_API.g_false,
1280: p_count => x_msg_count,
1281: p_data => x_msg_data
1282: );
1283:

Line 1288: WHEN FND_API.g_exc_error THEN

1284: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
1285:
1286: EXCEPTION
1287:
1288: WHEN FND_API.g_exc_error THEN
1289: ROLLBACK TO Get_Salesreps;
1290: x_return_status := FND_API.g_ret_sts_error;
1291: FND_MSG_PUB.count_and_get(
1292: p_encoded => FND_API.g_false,

Line 1290: x_return_status := FND_API.g_ret_sts_error;

1286: EXCEPTION
1287:
1288: WHEN FND_API.g_exc_error THEN
1289: ROLLBACK TO Get_Salesreps;
1290: x_return_status := FND_API.g_ret_sts_error;
1291: FND_MSG_PUB.count_and_get(
1292: p_encoded => FND_API.g_false,
1293: p_count => x_msg_count,
1294: p_data => x_msg_data

Line 1292: p_encoded => FND_API.g_false,

1288: WHEN FND_API.g_exc_error THEN
1289: ROLLBACK TO Get_Salesreps;
1290: x_return_status := FND_API.g_ret_sts_error;
1291: FND_MSG_PUB.count_and_get(
1292: p_encoded => FND_API.g_false,
1293: p_count => x_msg_count,
1294: p_data => x_msg_data
1295: );
1296:

Line 1297: WHEN FND_API.g_exc_unexpected_error THEN

1293: p_count => x_msg_count,
1294: p_data => x_msg_data
1295: );
1296:
1297: WHEN FND_API.g_exc_unexpected_error THEN
1298: ROLLBACK TO Get_Salesreps;
1299: x_return_status := FND_API.g_ret_sts_unexp_error ;
1300: FND_MSG_PUB.count_and_get(
1301: p_encoded => FND_API.g_false,

Line 1299: x_return_status := FND_API.g_ret_sts_unexp_error ;

1295: );
1296:
1297: WHEN FND_API.g_exc_unexpected_error THEN
1298: ROLLBACK TO Get_Salesreps;
1299: x_return_status := FND_API.g_ret_sts_unexp_error ;
1300: FND_MSG_PUB.count_and_get(
1301: p_encoded => FND_API.g_false,
1302: p_count => x_msg_count,
1303: p_data => x_msg_data

Line 1301: p_encoded => FND_API.g_false,

1297: WHEN FND_API.g_exc_unexpected_error THEN
1298: ROLLBACK TO Get_Salesreps;
1299: x_return_status := FND_API.g_ret_sts_unexp_error ;
1300: FND_MSG_PUB.count_and_get(
1301: p_encoded => FND_API.g_false,
1302: p_count => x_msg_count,
1303: p_data => x_msg_data
1304: );
1305:

Line 1308: x_return_status := FND_API.g_ret_sts_unexp_error ;

1304: );
1305:
1306: WHEN OTHERS THEN
1307: ROLLBACK TO Get_Salesreps;
1308: x_return_status := FND_API.g_ret_sts_unexp_error ;
1309:
1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1311: THEN
1312: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1316: p_encoded => FND_API.g_false,

1312: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1313: END IF;
1314:
1315: FND_MSG_PUB.count_and_get(
1316: p_encoded => FND_API.g_false,
1317: p_count => x_msg_count,
1318: p_data => x_msg_data
1319: );
1320:

Line 1334: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

1330: -- CATEGORY = 'IMMATURED'
1331: ----------------------------------------------------------------------
1332: PROCEDURE Get_Immatured_Lead_Owner(
1333: p_api_version IN NUMBER
1334: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1335: ,p_commit IN VARCHAR2 := FND_API.g_false
1336: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1337:
1338: ,p_sales_lead_id IN NUMBER

Line 1335: ,p_commit IN VARCHAR2 := FND_API.g_false

1331: ----------------------------------------------------------------------
1332: PROCEDURE Get_Immatured_Lead_Owner(
1333: p_api_version IN NUMBER
1334: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1335: ,p_commit IN VARCHAR2 := FND_API.g_false
1336: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1337:
1338: ,p_sales_lead_id IN NUMBER
1339: ,x_salesforce_id OUT NOCOPY NUMBER

Line 1336: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

1332: PROCEDURE Get_Immatured_Lead_Owner(
1333: p_api_version IN NUMBER
1334: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1335: ,p_commit IN VARCHAR2 := FND_API.g_false
1336: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1337:
1338: ,p_sales_lead_id IN NUMBER
1339: ,x_salesforce_id OUT NOCOPY NUMBER
1340:

Line 1389: IF FND_API.to_boolean(p_init_msg_list) THEN

1385: SAVEPOINT Get_Salesreps;
1386:
1387: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
1388:
1389: IF FND_API.to_boolean(p_init_msg_list) THEN
1390: FND_MSG_PUB.initialize;
1391: END IF;
1392:
1393: IF NOT FND_API.compatible_api_call(

Line 1393: IF NOT FND_API.compatible_api_call(

1389: IF FND_API.to_boolean(p_init_msg_list) THEN
1390: FND_MSG_PUB.initialize;
1391: END IF;
1392:
1393: IF NOT FND_API.compatible_api_call(
1394: l_api_version,
1395: p_api_version,
1396: l_api_name,
1397: g_pkg_name

Line 1399: RAISE FND_API.g_exc_unexpected_error;

1395: p_api_version,
1396: l_api_name,
1397: g_pkg_name
1398: ) THEN
1399: RAISE FND_API.g_exc_unexpected_error;
1400: END IF;
1401:
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403:

Line 1402: x_return_status := FND_API.G_RET_STS_SUCCESS;

1398: ) THEN
1399: RAISE FND_API.g_exc_unexpected_error;
1400: END IF;
1401:
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403:
1404: ----------------------- validate ----------------------
1405: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');
1406:

Line 1412: RAISE FND_API.g_exc_error;

1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1409: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');
1410: FND_MSG_PUB.add;
1411: END IF;
1412: RAISE FND_API.g_exc_error;
1413: ELSE
1414: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1415: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1416: fnd_message.Set_Token('TEXT', 'Sales lead id : ' || p_sales_lead_id);

Line 1468: IF FND_API.to_boolean(p_commit) THEN

1464: x_salesforce_id := fnd_profile.value('AS_DEFAULT_LEAD_MKTG_OWNER');
1465: END IF;
1466:
1467: -- Check for commit
1468: IF FND_API.to_boolean(p_commit) THEN
1469: COMMIT;
1470: END IF;
1471:
1472: FND_MSG_PUB.count_and_get(

Line 1473: p_encoded => FND_API.g_false,

1469: COMMIT;
1470: END IF;
1471:
1472: FND_MSG_PUB.count_and_get(
1473: p_encoded => FND_API.g_false,
1474: p_count => x_msg_count,
1475: p_data => x_msg_data
1476: );
1477:

Line 1482: WHEN FND_API.g_exc_error THEN

1478: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': end');
1479:
1480: EXCEPTION
1481:
1482: WHEN FND_API.g_exc_error THEN
1483: ROLLBACK TO Get_Salesreps;
1484: x_return_status := FND_API.g_ret_sts_error;
1485: FND_MSG_PUB.count_and_get(
1486: p_encoded => FND_API.g_false,

Line 1484: x_return_status := FND_API.g_ret_sts_error;

1480: EXCEPTION
1481:
1482: WHEN FND_API.g_exc_error THEN
1483: ROLLBACK TO Get_Salesreps;
1484: x_return_status := FND_API.g_ret_sts_error;
1485: FND_MSG_PUB.count_and_get(
1486: p_encoded => FND_API.g_false,
1487: p_count => x_msg_count,
1488: p_data => x_msg_data

Line 1486: p_encoded => FND_API.g_false,

1482: WHEN FND_API.g_exc_error THEN
1483: ROLLBACK TO Get_Salesreps;
1484: x_return_status := FND_API.g_ret_sts_error;
1485: FND_MSG_PUB.count_and_get(
1486: p_encoded => FND_API.g_false,
1487: p_count => x_msg_count,
1488: p_data => x_msg_data
1489: );
1490:

Line 1491: WHEN FND_API.g_exc_unexpected_error THEN

1487: p_count => x_msg_count,
1488: p_data => x_msg_data
1489: );
1490:
1491: WHEN FND_API.g_exc_unexpected_error THEN
1492: ROLLBACK TO Get_Salesreps;
1493: x_return_status := FND_API.g_ret_sts_unexp_error ;
1494: FND_MSG_PUB.count_and_get(
1495: p_encoded => FND_API.g_false,

Line 1493: x_return_status := FND_API.g_ret_sts_unexp_error ;

1489: );
1490:
1491: WHEN FND_API.g_exc_unexpected_error THEN
1492: ROLLBACK TO Get_Salesreps;
1493: x_return_status := FND_API.g_ret_sts_unexp_error ;
1494: FND_MSG_PUB.count_and_get(
1495: p_encoded => FND_API.g_false,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data

Line 1495: p_encoded => FND_API.g_false,

1491: WHEN FND_API.g_exc_unexpected_error THEN
1492: ROLLBACK TO Get_Salesreps;
1493: x_return_status := FND_API.g_ret_sts_unexp_error ;
1494: FND_MSG_PUB.count_and_get(
1495: p_encoded => FND_API.g_false,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data
1498: );
1499:

Line 1502: x_return_status := FND_API.g_ret_sts_unexp_error ;

1498: );
1499:
1500: WHEN OTHERS THEN
1501: ROLLBACK TO Get_Salesreps;
1502: x_return_status := FND_API.g_ret_sts_unexp_error ;
1503:
1504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1505: THEN
1506: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1510: p_encoded => FND_API.g_false,

1506: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1507: END IF;
1508:
1509: FND_MSG_PUB.count_and_get(
1510: p_encoded => FND_API.g_false,
1511: p_count => x_msg_count,
1512: p_data => x_msg_data
1513: );
1514: