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.PV_ASSIGNMENT_PVT dependencies on FND_API

Line 53: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

49:
50: PROCEDURE Create_Oppty_Routing_Log_Row
51: (
52: P_Api_Version_Number IN NUMBER,
53: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
54: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: P_oppty_routing_log_rec IN oppty_routing_log_rec_type,
57: X_Return_Status OUT NOCOPY VARCHAR2,

Line 54: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

50: PROCEDURE Create_Oppty_Routing_Log_Row
51: (
52: P_Api_Version_Number IN NUMBER,
53: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
54: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: P_oppty_routing_log_rec IN oppty_routing_log_rec_type,
57: X_Return_Status OUT NOCOPY VARCHAR2,
58: X_Msg_Count OUT NOCOPY NUMBER,

Line 55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

51: (
52: P_Api_Version_Number IN NUMBER,
53: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
54: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: P_oppty_routing_log_rec IN oppty_routing_log_rec_type,
57: X_Return_Status OUT NOCOPY VARCHAR2,
58: X_Msg_Count OUT NOCOPY NUMBER,
59: X_Msg_Data OUT NOCOPY VARCHAR2

Line 82: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

78:
79:
80: BEGIN
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
83: p_api_version_number,
84: l_api_name,
85: G_PKG_NAME)
86: THEN

Line 87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

83: p_api_version_number,
84: l_api_name,
85: G_PKG_NAME)
86: THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89:
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list )

Line 91: IF FND_API.to_Boolean( p_init_msg_list )

87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89:
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list )
92: THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:

Line 104: x_return_status := FND_API.G_RET_STS_SUCCESS;

100: fnd_msg_pub.Add;
101: END IF;
102:
103: -- Initialize API return status to SUCCESS
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: OPEN C2;
107: FETCH C2 INTO l_routing_log_id;
108: CLOSE C2;

Line 158: IF FND_API.to_Boolean( p_commit )

154: -- End of API body
155: --
156:
157: -- Standard check for p_commit
158: IF FND_API.to_Boolean( p_commit )
159: THEN
160: COMMIT WORK;
161: END IF;
162:

Line 171: WHEN FND_API.G_EXC_ERROR THEN

167: );
168:
169: EXCEPTION
170:
171: WHEN FND_API.G_EXC_ERROR THEN
172:
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
175: p_count => x_msg_count,

Line 173: x_return_status := FND_API.G_RET_STS_ERROR ;

169: EXCEPTION
170:
171: WHEN FND_API.G_EXC_ERROR THEN
172:
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
175: p_count => x_msg_count,
176: p_data => x_msg_data);
177:

Line 174: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

170:
171: WHEN FND_API.G_EXC_ERROR THEN
172:
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
175: p_count => x_msg_count,
176: p_data => x_msg_data);
177:
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

174: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
175: p_count => x_msg_count,
176: p_data => x_msg_data);
177:
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179:
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
182: p_count => x_msg_count,

Line 180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

176: p_data => x_msg_data);
177:
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179:
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
182: p_count => x_msg_count,
183: p_data => x_msg_data);
184:

Line 181: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

177:
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179:
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
182: p_count => x_msg_count,
183: p_data => x_msg_data);
184:
185: WHEN OTHERS THEN

Line 187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

183: p_data => x_msg_data);
184:
185: WHEN OTHERS THEN
186:
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
189: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
190: p_count => x_msg_count,
191: p_data => x_msg_data);

Line 189: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

185: WHEN OTHERS THEN
186:
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
189: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
190: p_count => x_msg_count,
191: p_data => x_msg_data);
192:
193: END Create_Oppty_Routing_Log_Row;

Line 197: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

193: END Create_Oppty_Routing_Log_Row;
194:
195: PROCEDURE Create_assignment_log_row(
196: P_Api_Version_Number IN NUMBER,
197: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
198: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: P_assignment_log_rec IN assignment_log_rec_type,
201: X_assignment_id OUT NOCOPY NUMBER,

Line 198: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

194:
195: PROCEDURE Create_assignment_log_row(
196: P_Api_Version_Number IN NUMBER,
197: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
198: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: P_assignment_log_rec IN assignment_log_rec_type,
201: X_assignment_id OUT NOCOPY NUMBER,
202: X_Return_Status OUT NOCOPY VARCHAR2,

Line 199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

195: PROCEDURE Create_assignment_log_row(
196: P_Api_Version_Number IN NUMBER,
197: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
198: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: P_assignment_log_rec IN assignment_log_rec_type,
201: X_assignment_id OUT NOCOPY NUMBER,
202: X_Return_Status OUT NOCOPY VARCHAR2,
203: X_Msg_Count OUT NOCOPY NUMBER,

Line 216: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

212:
213: BEGIN
214:
215: -- Standard call to check for call compatibility.
216: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
217: p_api_version_number,
218: l_api_name,
219: G_PKG_NAME)
220: THEN

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

217: p_api_version_number,
218: l_api_name,
219: G_PKG_NAME)
220: THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223:
224: -- Initialize message list if p_init_msg_list is set to TRUE.
225: IF FND_API.to_Boolean( p_init_msg_list )

Line 225: IF FND_API.to_Boolean( p_init_msg_list )

221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223:
224: -- Initialize message list if p_init_msg_list is set to TRUE.
225: IF FND_API.to_Boolean( p_init_msg_list )
226: THEN
227: FND_MSG_PUB.initialize;
228: END IF;
229:

Line 238: x_return_status := FND_API.G_RET_STS_SUCCESS;

234: fnd_msg_pub.Add;
235: END IF;
236:
237: -- Initialize API return status to SUCCESS
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239:
240: --
241: -- API body
242: --

Line 309: IF FND_API.to_Boolean( p_commit )

305: -- End of API body
306: --
307:
308: -- Standard check for p_commit
309: IF FND_API.to_Boolean( p_commit )
310: THEN
311: COMMIT WORK;
312: END IF;
313:

Line 322: WHEN FND_API.G_EXC_ERROR THEN

318: );
319:
320: EXCEPTION
321:
322: WHEN FND_API.G_EXC_ERROR THEN
323:
324: x_return_status := FND_API.G_RET_STS_ERROR ;
325: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
326: p_count => x_msg_count,

Line 324: x_return_status := FND_API.G_RET_STS_ERROR ;

320: EXCEPTION
321:
322: WHEN FND_API.G_EXC_ERROR THEN
323:
324: x_return_status := FND_API.G_RET_STS_ERROR ;
325: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
326: p_count => x_msg_count,
327: p_data => x_msg_data);
328:

Line 325: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

321:
322: WHEN FND_API.G_EXC_ERROR THEN
323:
324: x_return_status := FND_API.G_RET_STS_ERROR ;
325: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
326: p_count => x_msg_count,
327: p_data => x_msg_data);
328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

325: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
326: p_count => x_msg_count,
327: p_data => x_msg_data);
328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330:
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
332: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
333: p_count => x_msg_count,

Line 331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

327: p_data => x_msg_data);
328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330:
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
332: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
333: p_count => x_msg_count,
334: p_data => x_msg_data);
335:

Line 332: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330:
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
332: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
333: p_count => x_msg_count,
334: p_data => x_msg_data);
335:
336: WHEN OTHERS THEN

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

334: p_data => x_msg_data);
335:
336: WHEN OTHERS THEN
337:
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
340: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
341: p_count => x_msg_count,
342: p_data => x_msg_data);

Line 340: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

336: WHEN OTHERS THEN
337:
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
340: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
341: p_count => x_msg_count,
342: p_data => x_msg_data);
343:
344: End Create_assignment_log_row;

Line 350: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

346:
347:
348: PROCEDURE update_party_response(
349: P_Api_Version_Number IN NUMBER,
350: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
351: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
353: P_rowid IN ROWID,
354: p_lead_assignment_id IN NUMBER,

Line 351: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

347:
348: PROCEDURE update_party_response(
349: P_Api_Version_Number IN NUMBER,
350: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
351: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
353: P_rowid IN ROWID,
354: p_lead_assignment_id IN NUMBER,
355: p_party_resource_id IN NUMBER,

Line 352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

348: PROCEDURE update_party_response(
349: P_Api_Version_Number IN NUMBER,
350: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
351: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
353: P_rowid IN ROWID,
354: p_lead_assignment_id IN NUMBER,
355: p_party_resource_id IN NUMBER,
356: p_response IN VARCHAR2,

Line 375: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

371:
372: begin
373: -- Standard call to check for call compatibility.
374:
375: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
376: p_api_version_number,
377: l_api_name,
378: G_PKG_NAME) THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

375: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
376: p_api_version_number,
377: l_api_name,
378: G_PKG_NAME) THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380:
381: END IF;
382:
383: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 384: IF FND_API.to_Boolean( p_init_msg_list )

380:
381: END IF;
382:
383: -- Initialize message list if p_init_msg_list is set to TRUE.
384: IF FND_API.to_Boolean( p_init_msg_list )
385: THEN
386: fnd_msg_pub.initialize;
387: END IF;
388:

Line 396: x_return_status := FND_API.G_RET_STS_SUCCESS ;

392: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
393: fnd_msg_pub.Add;
394: END IF;
395:
396: x_return_status := FND_API.G_RET_STS_SUCCESS ;
397:
398:
399: update pv_party_notifications
400: set resource_response = p_response,

Line 414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

410: IF (SQL%NOTFOUND) THEN
411: fnd_message.SET_NAME('PV', 'Cannot find row to update');
412: fnd_msg_pub.ADD;
413:
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: END IF;
416:
417: if (l_lead_assignment_id <> p_lead_assignment_id or
418: l_party_resource_id <> p_party_resource_id )

Line 423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

419: then
420: fnd_message.SET_NAME('PV', 'Updated wrong row');
421: fnd_msg_pub.ADD;
422:
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: end if;
425:
426: if p_response in (pv_assignment_pub.g_la_status_cm_added, pv_assignment_pub.g_la_status_cm_add_app_for_pt) then
427: l_response := pv_assignment_pub.g_la_status_cm_approved;

Line 434: ,p_init_msg_list => FND_API.G_FALSE

430: end if;
431:
432: UpdateAssignment (
433: p_api_version_number => 1.0
434: ,p_init_msg_list => FND_API.G_FALSE
435: ,p_commit => FND_API.G_FALSE
436: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
437: ,p_action => pv_assignment_pub.g_asgn_action_status_update
438: ,p_lead_assignment_id => p_lead_assignment_id

Line 435: ,p_commit => FND_API.G_FALSE

431:
432: UpdateAssignment (
433: p_api_version_number => 1.0
434: ,p_init_msg_list => FND_API.G_FALSE
435: ,p_commit => FND_API.G_FALSE
436: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
437: ,p_action => pv_assignment_pub.g_asgn_action_status_update
438: ,p_lead_assignment_id => p_lead_assignment_id
439: ,p_status_date => sysdate

Line 436: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

432: UpdateAssignment (
433: p_api_version_number => 1.0
434: ,p_init_msg_list => FND_API.G_FALSE
435: ,p_commit => FND_API.G_FALSE
436: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
437: ,p_action => pv_assignment_pub.g_asgn_action_status_update
438: ,p_lead_assignment_id => p_lead_assignment_id
439: ,p_status_date => sysdate
440: ,p_status => l_response

Line 447: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

443: ,x_msg_count => x_msg_count
444: ,x_msg_data => x_msg_data
445: ,x_return_status => x_return_status);
446:
447: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
448: raise FND_API.G_EXC_ERROR;
449: end if;
450:
451: IF FND_API.To_Boolean ( p_commit ) THEN

Line 448: raise FND_API.G_EXC_ERROR;

444: ,x_msg_data => x_msg_data
445: ,x_return_status => x_return_status);
446:
447: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
448: raise FND_API.G_EXC_ERROR;
449: end if;
450:
451: IF FND_API.To_Boolean ( p_commit ) THEN
452: COMMIT WORK;

Line 451: IF FND_API.To_Boolean ( p_commit ) THEN

447: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
448: raise FND_API.G_EXC_ERROR;
449: end if;
450:
451: IF FND_API.To_Boolean ( p_commit ) THEN
452: COMMIT WORK;
453: END IF;
454:
455: -- Standard call to get message count and if count is 1, get message info.

Line 456: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

452: COMMIT WORK;
453: END IF;
454:
455: -- Standard call to get message count and if count is 1, get message info.
456: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
457: p_count => x_msg_count,
458: p_data => x_msg_data);
459: EXCEPTION
460:

Line 461: WHEN FND_API.G_EXC_ERROR THEN

457: p_count => x_msg_count,
458: p_data => x_msg_data);
459: EXCEPTION
460:
461: WHEN FND_API.G_EXC_ERROR THEN
462:
463: x_return_status := FND_API.G_RET_STS_ERROR ;
464: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
465: p_count => x_msg_count,

Line 463: x_return_status := FND_API.G_RET_STS_ERROR ;

459: EXCEPTION
460:
461: WHEN FND_API.G_EXC_ERROR THEN
462:
463: x_return_status := FND_API.G_RET_STS_ERROR ;
464: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
465: p_count => x_msg_count,
466: p_data => x_msg_data);
467:

Line 464: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

460:
461: WHEN FND_API.G_EXC_ERROR THEN
462:
463: x_return_status := FND_API.G_RET_STS_ERROR ;
464: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
465: p_count => x_msg_count,
466: p_data => x_msg_data);
467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

464: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
465: p_count => x_msg_count,
466: p_data => x_msg_data);
467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469:
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
472: p_count => x_msg_count,

Line 470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

466: p_data => x_msg_data);
467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469:
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
472: p_count => x_msg_count,
473: p_data => x_msg_data);
474:

Line 471: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469:
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
472: p_count => x_msg_count,
473: p_data => x_msg_data);
474:
475: WHEN OTHERS THEN

Line 477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

473: p_data => x_msg_data);
474:
475: WHEN OTHERS THEN
476:
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
479: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
480: p_count => x_msg_count,
481: p_data => x_msg_data);

Line 479: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

475: WHEN OTHERS THEN
476:
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
479: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
480: p_count => x_msg_count,
481: p_data => x_msg_data);
482:
483: End update_party_response;

Line 488: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

484:
485:
486: PROCEDURE bulk_set_party_notify_id(
487: P_Api_Version_Number IN NUMBER,
488: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
489: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
490: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
491: p_itemtype IN VARCHAR2,
492: p_itemkey IN VARCHAR2,

Line 489: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

485:
486: PROCEDURE bulk_set_party_notify_id(
487: P_Api_Version_Number IN NUMBER,
488: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
489: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
490: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
491: p_itemtype IN VARCHAR2,
492: p_itemkey IN VARCHAR2,
493: p_notify_type IN VARCHAR2,

Line 490: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

486: PROCEDURE bulk_set_party_notify_id(
487: P_Api_Version_Number IN NUMBER,
488: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
489: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
490: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
491: p_itemtype IN VARCHAR2,
492: p_itemkey IN VARCHAR2,
493: p_notify_type IN VARCHAR2,
494: X_Return_Status OUT NOCOPY VARCHAR2,

Line 531: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

527:
528: begin
529: -- Standard call to check for call compatibility.
530:
531: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
532: p_api_version_number,
533: l_api_name,
534: G_PKG_NAME) THEN
535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

531: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
532: p_api_version_number,
533: l_api_name,
534: G_PKG_NAME) THEN
535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
536:
537: END IF;
538:
539: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 540: IF FND_API.to_Boolean( p_init_msg_list )

536:
537: END IF;
538:
539: -- Initialize message list if p_init_msg_list is set to TRUE.
540: IF FND_API.to_Boolean( p_init_msg_list )
541: THEN
542: fnd_msg_pub.initialize;
543: END IF;
544:

Line 552: x_return_status := FND_API.G_RET_STS_SUCCESS ;

548: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
549: fnd_msg_pub.Add;
550: END IF;
551:
552: x_return_status := FND_API.G_RET_STS_SUCCESS ;
553:
554: l_partner_id := nvl(wf_engine.GetItemAttrNumber(
555: itemtype => p_itemtype,
556: itemkey => p_itemkey,

Line 600: IF FND_API.To_Boolean ( p_commit ) THEN

596: where party_notification_id = l_party_notify_id_tbl(j);
597:
598: end if;
599:
600: IF FND_API.To_Boolean ( p_commit ) THEN
601: COMMIT WORK;
602: END IF;
603:
604: -- Standard call to get message count and if count is 1, get message info.

Line 605: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

601: COMMIT WORK;
602: END IF;
603:
604: -- Standard call to get message count and if count is 1, get message info.
605: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
606: p_count => x_msg_count,
607: p_data => x_msg_data);
608: EXCEPTION
609:

Line 610: WHEN FND_API.G_EXC_ERROR THEN

606: p_count => x_msg_count,
607: p_data => x_msg_data);
608: EXCEPTION
609:
610: WHEN FND_API.G_EXC_ERROR THEN
611:
612: x_return_status := FND_API.G_RET_STS_ERROR ;
613: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
614: p_count => x_msg_count,

Line 612: x_return_status := FND_API.G_RET_STS_ERROR ;

608: EXCEPTION
609:
610: WHEN FND_API.G_EXC_ERROR THEN
611:
612: x_return_status := FND_API.G_RET_STS_ERROR ;
613: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
614: p_count => x_msg_count,
615: p_data => x_msg_data);
616:

Line 613: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

609:
610: WHEN FND_API.G_EXC_ERROR THEN
611:
612: x_return_status := FND_API.G_RET_STS_ERROR ;
613: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
614: p_count => x_msg_count,
615: p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

613: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
614: p_count => x_msg_count,
615: p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618:
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
621: p_count => x_msg_count,

Line 619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

615: p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618:
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
621: p_count => x_msg_count,
622: p_data => x_msg_data);
623:

Line 620: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618:
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
621: p_count => x_msg_count,
622: p_data => x_msg_data);
623:
624: WHEN OTHERS THEN

Line 626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

622: p_data => x_msg_data);
623:
624: WHEN OTHERS THEN
625:
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
628: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
629: p_count => x_msg_count,
630: p_data => x_msg_data);

Line 628: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

624: WHEN OTHERS THEN
625:
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
628: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
629: p_count => x_msg_count,
630: p_data => x_msg_data);
631:
632: End bulk_set_party_notify_id;

Line 637: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

633:
634:
635: procedure UpdateAssignment (
636: p_api_version_number IN NUMBER
637: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
638: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
639: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
640: ,p_action IN VARCHAR2
641: ,p_lead_assignment_id IN number

Line 638: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

634:
635: procedure UpdateAssignment (
636: p_api_version_number IN NUMBER
637: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
638: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
639: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
640: ,p_action IN VARCHAR2
641: ,p_lead_assignment_id IN number
642: ,p_status_date IN DATE

Line 639: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

635: procedure UpdateAssignment (
636: p_api_version_number IN NUMBER
637: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
638: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
639: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
640: ,p_action IN VARCHAR2
641: ,p_lead_assignment_id IN number
642: ,p_status_date IN DATE
643: ,p_status IN VARCHAR2

Line 766: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

762:
763: begin
764: -- Standard call to check for call compatibility.
765:
766: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
767: p_api_version_number,
768: l_api_name,
769: G_PKG_NAME) THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

766: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
767: p_api_version_number,
768: l_api_name,
769: G_PKG_NAME) THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771:
772: END IF;
773:
774: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 775: IF FND_API.to_Boolean( p_init_msg_list )

771:
772: END IF;
773:
774: -- Initialize message list if p_init_msg_list is set to TRUE.
775: IF FND_API.to_Boolean( p_init_msg_list )
776: THEN
777: fnd_msg_pub.initialize;
778: END IF;
779:

Line 797: x_return_status := FND_API.G_RET_STS_SUCCESS ;

793: end if;
794:
795: END IF;
796:
797: x_return_status := FND_API.G_RET_STS_SUCCESS ;
798:
799: -- validate p_action modes
800:
801: if p_action is NULL or

Line 809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

805: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
806: fnd_message.SET_TOKEN('TEXT', 'Invalid action mode:' || nvl(p_action, 'NULL') );
807: fnd_msg_pub.ADD;
808:
809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
810:
811: end if;
812:
813: OPEN lc_get_assign_row(pc_lead_assignment_id => p_lead_assignment_id);

Line 840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

836: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
837: fnd_message.SET_TOKEN('TEXT', 'Cannot find row');
838: fnd_msg_pub.ADD;
839:
840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
841: END IF;
842:
843: if p_action = pv_assignment_pub.g_asgn_action_status_update then
844:

Line 898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

894: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
895: fnd_message.SET_TOKEN('TEXT', 'Cannot find row to update');
896: fnd_msg_pub.ADD;
897:
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: END IF;
900:
901: l_assignment_rec.lead_id := l_lead_id;
902: l_assignment_rec.partner_id := l_partner_id;

Line 907: p_init_msg_list => FND_API.G_FALSE,

903: l_assignment_rec.status := p_status;
904:
905: pv_assign_util_pvt.Log_assignment_status (
906: p_api_version_number => 1.0,
907: p_init_msg_list => FND_API.G_FALSE,
908: p_commit => FND_API.G_FALSE,
909: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
910: p_assignment_rec => l_assignment_rec,
911: x_return_status => x_return_status,

Line 908: p_commit => FND_API.G_FALSE,

904:
905: pv_assign_util_pvt.Log_assignment_status (
906: p_api_version_number => 1.0,
907: p_init_msg_list => FND_API.G_FALSE,
908: p_commit => FND_API.G_FALSE,
909: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
910: p_assignment_rec => l_assignment_rec,
911: x_return_status => x_return_status,
912: x_msg_count => x_msg_count,

Line 909: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

905: pv_assign_util_pvt.Log_assignment_status (
906: p_api_version_number => 1.0,
907: p_init_msg_list => FND_API.G_FALSE,
908: p_commit => FND_API.G_FALSE,
909: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
910: p_assignment_rec => l_assignment_rec,
911: x_return_status => x_return_status,
912: x_msg_count => x_msg_count,
913: x_msg_data => x_msg_data);

Line 915: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

911: x_return_status => x_return_status,
912: x_msg_count => x_msg_count,
913: x_msg_data => x_msg_data);
914:
915: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
916: raise FND_API.G_EXC_ERROR;
917: end if;
918: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
919: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 916: raise FND_API.G_EXC_ERROR;

912: x_msg_count => x_msg_count,
913: x_msg_data => x_msg_data);
914:
915: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
916: raise FND_API.G_EXC_ERROR;
917: end if;
918: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
919: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
920: fnd_message.Set_Token('TEXT', 'START:Logging in Opportunity Routing Log ');

Line 1038: p_init_msg_list => FND_API.G_FALSE,

1034:
1035:
1036: pv_assignment_pvt.Create_Oppty_Routing_Log_Row (
1037: p_api_version_number => 1.0,
1038: p_init_msg_list => FND_API.G_FALSE,
1039: p_commit => FND_API.G_FALSE,
1040: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1041: P_oppty_routing_log_rec => l_oppty_routing_log_rec,
1042: x_return_status => x_return_status,

Line 1039: p_commit => FND_API.G_FALSE,

1035:
1036: pv_assignment_pvt.Create_Oppty_Routing_Log_Row (
1037: p_api_version_number => 1.0,
1038: p_init_msg_list => FND_API.G_FALSE,
1039: p_commit => FND_API.G_FALSE,
1040: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1041: P_oppty_routing_log_rec => l_oppty_routing_log_rec,
1042: x_return_status => x_return_status,
1043: x_msg_count => x_msg_count,

Line 1040: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1036: pv_assignment_pvt.Create_Oppty_Routing_Log_Row (
1037: p_api_version_number => 1.0,
1038: p_init_msg_list => FND_API.G_FALSE,
1039: p_commit => FND_API.G_FALSE,
1040: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1041: P_oppty_routing_log_rec => l_oppty_routing_log_rec,
1042: x_return_status => x_return_status,
1043: x_msg_count => x_msg_count,
1044: x_msg_data => x_msg_data);

Line 1046: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1042: x_return_status => x_return_status,
1043: x_msg_count => x_msg_count,
1044: x_msg_data => x_msg_data);
1045:
1046: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1047: RAISE FND_API.G_EXC_ERROR;
1048: END IF;
1049: END IF;
1050:

Line 1047: RAISE FND_API.G_EXC_ERROR;

1043: x_msg_count => x_msg_count,
1044: x_msg_data => x_msg_data);
1045:
1046: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1047: RAISE FND_API.G_EXC_ERROR;
1048: END IF;
1049: END IF;
1050:
1051: -- vansub

Line 1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1059: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
1060: fnd_message.SET_TOKEN('TEXT', 'Cannot find row to delete');
1061: fnd_msg_pub.ADD;
1062:
1063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1064: END IF;
1065:
1066: end if;
1067:

Line 1094: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1090: p_wf_pt_user => NULL,
1091: p_wf_cm_user => NULL,
1092: x_return_status => x_return_status);
1093:
1094: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1095: raise FND_API.G_EXC_ERROR;
1096: end if;
1097:
1098:

Line 1095: raise FND_API.G_EXC_ERROR;

1091: p_wf_cm_user => NULL,
1092: x_return_status => x_return_status);
1093:
1094: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1095: raise FND_API.G_EXC_ERROR;
1096: end if;
1097:
1098:
1099: IF FND_API.To_Boolean ( p_commit ) THEN

Line 1099: IF FND_API.To_Boolean ( p_commit ) THEN

1095: raise FND_API.G_EXC_ERROR;
1096: end if;
1097:
1098:
1099: IF FND_API.To_Boolean ( p_commit ) THEN
1100: COMMIT WORK;
1101: END IF;
1102:
1103: -- Standard call to get message count and if count is 1, get message info.

Line 1104: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1100: COMMIT WORK;
1101: END IF;
1102:
1103: -- Standard call to get message count and if count is 1, get message info.
1104: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1105: p_count => x_msg_count,
1106: p_data => x_msg_data);
1107: EXCEPTION
1108: -- -------------------------------------------------------------------------------

Line 1115: x_return_status := FND_API.G_RET_STS_ERROR;

1111: -- so that no other user/session can update the row in pv_lead_assignments
1112: -- when the current session has not completed yet.
1113: -- -------------------------------------------------------------------------------
1114: WHEN g_e_resource_busy THEN
1115: x_return_status := FND_API.G_RET_STS_ERROR;
1116: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1117: p_count => x_msg_count,
1118: p_data => x_msg_data);
1119:

Line 1116: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1112: -- when the current session has not completed yet.
1113: -- -------------------------------------------------------------------------------
1114: WHEN g_e_resource_busy THEN
1115: x_return_status := FND_API.G_RET_STS_ERROR;
1116: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1117: p_count => x_msg_count,
1118: p_data => x_msg_data);
1119:
1120: RAISE;

Line 1123: WHEN FND_API.G_EXC_ERROR THEN

1119:
1120: RAISE;
1121:
1122:
1123: WHEN FND_API.G_EXC_ERROR THEN
1124:
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1127: p_count => x_msg_count,

Line 1125: x_return_status := FND_API.G_RET_STS_ERROR ;

1121:
1122:
1123: WHEN FND_API.G_EXC_ERROR THEN
1124:
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data);
1129:

Line 1126: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1122:
1123: WHEN FND_API.G_EXC_ERROR THEN
1124:
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data);
1129:
1130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1126: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data);
1129:
1130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1131:
1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1133: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1134: p_count => x_msg_count,

Line 1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1128: p_data => x_msg_data);
1129:
1130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1131:
1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1133: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1134: p_count => x_msg_count,
1135: p_data => x_msg_data);
1136:

Line 1133: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1129:
1130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1131:
1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1133: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1134: p_count => x_msg_count,
1135: p_data => x_msg_data);
1136:
1137: WHEN OTHERS THEN

Line 1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1135: p_data => x_msg_data);
1136:
1137: WHEN OTHERS THEN
1138:
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1140: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1141: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1142: p_count => x_msg_count,
1143: p_data => x_msg_data);

Line 1141: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1137: WHEN OTHERS THEN
1138:
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1140: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1141: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1142: p_count => x_msg_count,
1143: p_data => x_msg_data);
1144:
1145: end UpdateAssignment;

Line 1150: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1146:
1147:
1148: procedure removeRejectedFromAccess (
1149: p_api_version_number IN NUMBER
1150: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1151: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1152: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1153: ,p_itemtype IN VARCHAR2
1154: ,p_itemkey IN VARCHAR2

Line 1151: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1147:
1148: procedure removeRejectedFromAccess (
1149: p_api_version_number IN NUMBER
1150: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1151: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1152: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1153: ,p_itemtype IN VARCHAR2
1154: ,p_itemkey IN VARCHAR2
1155: ,p_partner_id IN VARCHAR2

Line 1152: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1148: procedure removeRejectedFromAccess (
1149: p_api_version_number IN NUMBER
1150: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1151: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1152: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1153: ,p_itemtype IN VARCHAR2
1154: ,p_itemkey IN VARCHAR2
1155: ,p_partner_id IN VARCHAR2
1156: ,x_msg_count OUT NOCOPY NUMBER

Line 1377: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1373: -- 3. When Partner Abandons the opportunity
1374: --
1375: -- Standard call to check for call compatibility.
1376:
1377: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1378: p_api_version_number,
1379: l_api_name,
1380: G_PKG_NAME) THEN
1381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1377: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1378: p_api_version_number,
1379: l_api_name,
1380: G_PKG_NAME) THEN
1381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1382:
1383: END IF;
1384:
1385: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1386: IF FND_API.to_Boolean( p_init_msg_list )

1382:
1383: END IF;
1384:
1385: -- Initialize message list if p_init_msg_list is set to TRUE.
1386: IF FND_API.to_Boolean( p_init_msg_list )
1387: THEN
1388: fnd_msg_pub.initialize;
1389: END IF;
1390:

Line 1398: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1394: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. itemkey = ' || p_itemkey);
1395: fnd_msg_pub.Add;
1396: END IF;
1397:
1398: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1399:
1400: OPEN lc_get_routing_status ( pc_itemtype => p_itemtype
1401: , pc_itemkey => p_itemkey );
1402: FETCH lc_get_routing_status INTO l_routing_status;

Line 1456: p_init_msg_list => FND_API.G_FALSE,

1452: end if;
1453:
1454: pv_assign_util_pvt.UpdateAccess(
1455: p_api_version_number => 1.0,
1456: p_init_msg_list => FND_API.G_FALSE,
1457: p_commit => FND_API.G_FALSE,
1458: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1459: p_itemtype => p_itemType,
1460: p_itemkey => p_itemKey,

Line 1457: p_commit => FND_API.G_FALSE,

1453:
1454: pv_assign_util_pvt.UpdateAccess(
1455: p_api_version_number => 1.0,
1456: p_init_msg_list => FND_API.G_FALSE,
1457: p_commit => FND_API.G_FALSE,
1458: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1459: p_itemtype => p_itemType,
1460: p_itemkey => p_itemKey,
1461: p_current_username => NULL, --- obsolete column

Line 1458: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1454: pv_assign_util_pvt.UpdateAccess(
1455: p_api_version_number => 1.0,
1456: p_init_msg_list => FND_API.G_FALSE,
1457: p_commit => FND_API.G_FALSE,
1458: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1459: p_itemtype => p_itemType,
1460: p_itemkey => p_itemKey,
1461: p_current_username => NULL, --- obsolete column
1462: p_lead_id => l_lead_id,

Line 1473: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1469: x_return_status => x_return_status,
1470: x_msg_count => x_msg_count,
1471: x_msg_data => x_msg_data);
1472:
1473: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1474: raise FND_API.G_EXC_ERROR;
1475: end if;
1476:
1477: end loop;

Line 1474: raise FND_API.G_EXC_ERROR;

1470: x_msg_count => x_msg_count,
1471: x_msg_data => x_msg_data);
1472:
1473: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1474: raise FND_API.G_EXC_ERROR;
1475: end if;
1476:
1477: end loop;
1478:

Line 1494: p_init_msg_list => FND_API.G_FALSE,

1490: END IF;
1491:
1492: pv_assign_util_pvt.UpdateAccess(
1493: p_api_version_number => 1.0,
1494: p_init_msg_list => FND_API.G_FALSE,
1495: p_commit => FND_API.G_FALSE,
1496: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1497: p_itemtype => p_itemType,
1498: p_itemkey => p_itemKey,

Line 1495: p_commit => FND_API.G_FALSE,

1491:
1492: pv_assign_util_pvt.UpdateAccess(
1493: p_api_version_number => 1.0,
1494: p_init_msg_list => FND_API.G_FALSE,
1495: p_commit => FND_API.G_FALSE,
1496: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1497: p_itemtype => p_itemType,
1498: p_itemkey => p_itemKey,
1499: p_current_username => NULL, --- obsolete column

Line 1496: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1492: pv_assign_util_pvt.UpdateAccess(
1493: p_api_version_number => 1.0,
1494: p_init_msg_list => FND_API.G_FALSE,
1495: p_commit => FND_API.G_FALSE,
1496: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1497: p_itemtype => p_itemType,
1498: p_itemkey => p_itemKey,
1499: p_current_username => NULL, --- obsolete column
1500: p_lead_id => l_lead_id,

Line 1511: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1507: x_return_status => x_return_status,
1508: x_msg_count => x_msg_count,
1509: x_msg_data => x_msg_data);
1510:
1511: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1512: raise FND_API.G_EXC_ERROR;
1513: end if;
1514:
1515: end loop;

Line 1512: raise FND_API.G_EXC_ERROR;

1508: x_msg_count => x_msg_count,
1509: x_msg_data => x_msg_data);
1510:
1511: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1512: raise FND_API.G_EXC_ERROR;
1513: end if;
1514:
1515: end loop;
1516: end if;

Line 1529: IF FND_API.To_Boolean ( p_commit ) THEN

1525: ELSE
1526: CLOSE lc_get_pt_cm_accesses;
1527: END IF;
1528:
1529: IF FND_API.To_Boolean ( p_commit ) THEN
1530: COMMIT WORK;
1531: END IF;
1532:
1533: -- Standard call to get message count and if count is 1, get message info.

Line 1534: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1530: COMMIT WORK;
1531: END IF;
1532:
1533: -- Standard call to get message count and if count is 1, get message info.
1534: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1535: p_count => x_msg_count,
1536: p_data => x_msg_data);
1537: EXCEPTION
1538:

Line 1539: WHEN FND_API.G_EXC_ERROR THEN

1535: p_count => x_msg_count,
1536: p_data => x_msg_data);
1537: EXCEPTION
1538:
1539: WHEN FND_API.G_EXC_ERROR THEN
1540:
1541: x_return_status := FND_API.G_RET_STS_ERROR ;
1542: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1543: p_count => x_msg_count,

Line 1541: x_return_status := FND_API.G_RET_STS_ERROR ;

1537: EXCEPTION
1538:
1539: WHEN FND_API.G_EXC_ERROR THEN
1540:
1541: x_return_status := FND_API.G_RET_STS_ERROR ;
1542: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1543: p_count => x_msg_count,
1544: p_data => x_msg_data);
1545:

Line 1542: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1538:
1539: WHEN FND_API.G_EXC_ERROR THEN
1540:
1541: x_return_status := FND_API.G_RET_STS_ERROR ;
1542: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1543: p_count => x_msg_count,
1544: p_data => x_msg_data);
1545:
1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1542: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1543: p_count => x_msg_count,
1544: p_data => x_msg_data);
1545:
1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1549: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1550: p_count => x_msg_count,

Line 1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1544: p_data => x_msg_data);
1545:
1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1549: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1550: p_count => x_msg_count,
1551: p_data => x_msg_data);
1552:

Line 1549: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1545:
1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1549: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1550: p_count => x_msg_count,
1551: p_data => x_msg_data);
1552:
1553: WHEN OTHERS THEN

Line 1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1551: p_data => x_msg_data);
1552:
1553: WHEN OTHERS THEN
1554:
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1557:
1558: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1559: p_count => x_msg_count,

Line 1558: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1554:
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1557:
1558: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1559: p_count => x_msg_count,
1560: p_data => x_msg_data);
1561:
1562: end removeRejectedFromAccess;

Line 1567: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1563:
1564:
1565: procedure setTimeout (
1566: p_api_version_number IN NUMBER
1567: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1568: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1569: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1570: ,p_itemtype IN varchar2
1571: ,p_itemkey IN varchar2

Line 1568: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1564:
1565: procedure setTimeout (
1566: p_api_version_number IN NUMBER
1567: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1568: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1569: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1570: ,p_itemtype IN varchar2
1571: ,p_itemkey IN varchar2
1572: ,p_partner_id in number

Line 1569: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1565: procedure setTimeout (
1566: p_api_version_number IN NUMBER
1567: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1568: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1569: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1570: ,p_itemtype IN varchar2
1571: ,p_itemkey IN varchar2
1572: ,p_partner_id in number
1573: ,p_timeoutType in varchar2

Line 1621: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1617:
1618: begin
1619: -- Standard call to check for call compatibility.
1620:
1621: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1622: p_api_version_number,
1623: l_api_name,
1624: G_PKG_NAME) THEN
1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1621: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1622: p_api_version_number,
1623: l_api_name,
1624: G_PKG_NAME) THEN
1625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1626:
1627: END IF;
1628:
1629: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1630: IF FND_API.to_Boolean( p_init_msg_list )

1626:
1627: END IF;
1628:
1629: -- Initialize message list if p_init_msg_list is set to TRUE.
1630: IF FND_API.to_Boolean( p_init_msg_list )
1631: THEN
1632: fnd_msg_pub.initialize;
1633: END IF;
1634:

Line 1642: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1638: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. itemkey: ' || p_itemkey || '. Type: ' || p_timeouttype);
1639: fnd_msg_pub.Add;
1640: END IF;
1641:
1642: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1643:
1644:
1645: if p_timeoutType = pv_assignment_pub.g_matched_timeout then
1646:

Line 1659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1655: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1656: fnd_message.set_token('TEXT', 'Invalid timeout type: ' || p_timeoutType);
1657: fnd_msg_pub.Add;
1658:
1659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1660:
1661: end if;
1662:
1663:

Line 1829: RAISE FND_API.G_EXC_ERROR;

1825: p_token1_value => null,
1826: p_token2 => null,
1827: p_token2_value => null);
1828:
1829: RAISE FND_API.G_EXC_ERROR;
1830:
1831: ELSIF (l_timeout IS NULL AND l_timeout_profile = 'PV_DEFAULT_PT_TIMEOUT') THEN
1832: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1833: p_msg_name => 'PV_NO_DEFAULT_PT_TIMEOUT',

Line 1839: RAISE FND_API.G_EXC_ERROR;

1835: p_token1_value => null,
1836: p_token2 => null,
1837: p_token2_value => null);
1838:
1839: RAISE FND_API.G_EXC_ERROR;
1840: END IF;
1841:
1842: -- wf will disable timeout if 0. Since what we want is to have wf
1843: -- follow the timeout path immediately, we set it to 1 minute

Line 1925: IF FND_API.To_Boolean ( p_commit ) THEN

1921: fnd_message.Set_token('TEXT', 'Timeout set to: ' || l_timeout);
1922: fnd_msg_pub.Add;
1923: END IF;
1924:
1925: IF FND_API.To_Boolean ( p_commit ) THEN
1926: COMMIT WORK;
1927: END IF;
1928:
1929: -- Standard call to get message count and if count is 1, get message info.

Line 1930: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1926: COMMIT WORK;
1927: END IF;
1928:
1929: -- Standard call to get message count and if count is 1, get message info.
1930: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1931: p_count => x_msg_count,
1932: p_data => x_msg_data);
1933: EXCEPTION
1934:

Line 1935: WHEN FND_API.G_EXC_ERROR THEN

1931: p_count => x_msg_count,
1932: p_data => x_msg_data);
1933: EXCEPTION
1934:
1935: WHEN FND_API.G_EXC_ERROR THEN
1936:
1937: x_return_status := FND_API.G_RET_STS_ERROR ;
1938: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1939: p_count => x_msg_count,

Line 1937: x_return_status := FND_API.G_RET_STS_ERROR ;

1933: EXCEPTION
1934:
1935: WHEN FND_API.G_EXC_ERROR THEN
1936:
1937: x_return_status := FND_API.G_RET_STS_ERROR ;
1938: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1939: p_count => x_msg_count,
1940: p_data => x_msg_data);
1941:

Line 1938: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1934:
1935: WHEN FND_API.G_EXC_ERROR THEN
1936:
1937: x_return_status := FND_API.G_RET_STS_ERROR ;
1938: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1939: p_count => x_msg_count,
1940: p_data => x_msg_data);
1941:
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1938: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1939: p_count => x_msg_count,
1940: p_data => x_msg_data);
1941:
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943:
1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1945: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1946: p_count => x_msg_count,

Line 1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1940: p_data => x_msg_data);
1941:
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943:
1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1945: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1946: p_count => x_msg_count,
1947: p_data => x_msg_data);
1948:

Line 1945: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1941:
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943:
1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1945: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1946: p_count => x_msg_count,
1947: p_data => x_msg_data);
1948:
1949: WHEN OTHERS THEN

Line 1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1947: p_data => x_msg_data);
1948:
1949: WHEN OTHERS THEN
1950:
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1953: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1954: p_count => x_msg_count,
1955: p_data => x_msg_data);

Line 1953: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

1949: WHEN OTHERS THEN
1950:
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1953: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
1954: p_count => x_msg_count,
1955: p_data => x_msg_data);
1956:
1957: end setTimeout;

Line 1962: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1958:
1959:
1960: procedure SetPartnerAttributes (
1961: p_api_version_number IN NUMBER
1962: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1963: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1964: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1965: ,p_itemType in varchar2
1966: ,p_itemKey in varchar2

Line 1963: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1959:
1960: procedure SetPartnerAttributes (
1961: p_api_version_number IN NUMBER
1962: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1963: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1964: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1965: ,p_itemType in varchar2
1966: ,p_itemKey in varchar2
1967: ,p_partner_id in NUMBER

Line 1964: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1960: procedure SetPartnerAttributes (
1961: p_api_version_number IN NUMBER
1962: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1963: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1964: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1965: ,p_itemType in varchar2
1966: ,p_itemKey in varchar2
1967: ,p_partner_id in NUMBER
1968: ,p_partner_org in varchar2

Line 1982: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1978:
1979: begin
1980: -- Standard call to check for call compatibility.
1981:
1982: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1983: p_api_version_number,
1984: l_api_name,
1985: G_PKG_NAME) THEN
1986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1982: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1983: p_api_version_number,
1984: l_api_name,
1985: G_PKG_NAME) THEN
1986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1987:
1988: END IF;
1989:
1990: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1991: IF FND_API.to_Boolean( p_init_msg_list )

1987:
1988: END IF;
1989:
1990: -- Initialize message list if p_init_msg_list is set to TRUE.
1991: IF FND_API.to_Boolean( p_init_msg_list )
1992: THEN
1993: fnd_msg_pub.initialize;
1994: END IF;
1995:

Line 2003: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1999: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Itemkey: ' || p_itemkey || '. Partner id: ' || p_partner_id);
2000: fnd_msg_pub.Add;
2001: END IF;
2002:
2003: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2004:
2005: l_assignment_type := wf_engine.GetItemAttrText( itemtype => p_itemtype,
2006: itemkey => p_itemkey,
2007: aname => pv_workflow_pub.g_wf_attr_assignment_type);

Line 2036: IF FND_API.To_Boolean ( p_commit ) THEN

2032: avalue => p_partner_id);
2033:
2034: end if;
2035:
2036: IF FND_API.To_Boolean ( p_commit ) THEN
2037: COMMIT WORK;
2038: END IF;
2039:
2040: -- Standard call to get message count and if count is 1, get message info.

Line 2041: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2037: COMMIT WORK;
2038: END IF;
2039:
2040: -- Standard call to get message count and if count is 1, get message info.
2041: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2042: p_count => x_msg_count,
2043: p_data => x_msg_data);
2044: EXCEPTION
2045:

Line 2046: WHEN FND_API.G_EXC_ERROR THEN

2042: p_count => x_msg_count,
2043: p_data => x_msg_data);
2044: EXCEPTION
2045:
2046: WHEN FND_API.G_EXC_ERROR THEN
2047:
2048: x_return_status := FND_API.G_RET_STS_ERROR ;
2049: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2050: p_count => x_msg_count,

Line 2048: x_return_status := FND_API.G_RET_STS_ERROR ;

2044: EXCEPTION
2045:
2046: WHEN FND_API.G_EXC_ERROR THEN
2047:
2048: x_return_status := FND_API.G_RET_STS_ERROR ;
2049: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2050: p_count => x_msg_count,
2051: p_data => x_msg_data);
2052:

Line 2049: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2045:
2046: WHEN FND_API.G_EXC_ERROR THEN
2047:
2048: x_return_status := FND_API.G_RET_STS_ERROR ;
2049: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2050: p_count => x_msg_count,
2051: p_data => x_msg_data);
2052:
2053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2049: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2050: p_count => x_msg_count,
2051: p_data => x_msg_data);
2052:
2053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2054:
2055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2056: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2057: p_count => x_msg_count,

Line 2055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2051: p_data => x_msg_data);
2052:
2053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2054:
2055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2056: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2057: p_count => x_msg_count,
2058: p_data => x_msg_data);
2059:

Line 2056: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2052:
2053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2054:
2055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2056: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2057: p_count => x_msg_count,
2058: p_data => x_msg_data);
2059:
2060: WHEN OTHERS THEN

Line 2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2058: p_data => x_msg_data);
2059:
2060: WHEN OTHERS THEN
2061:
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2063: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2064: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2065: p_count => x_msg_count,
2066: p_data => x_msg_data);

Line 2064: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2060: WHEN OTHERS THEN
2061:
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2063: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2064: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2065: p_count => x_msg_count,
2066: p_data => x_msg_data);
2067:
2068: end SetPartnerAttributes;

Line 2073: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2069:
2070:
2071: procedure set_offered_attributes (
2072: p_api_version_number IN NUMBER
2073: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2074: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2075: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2076: ,p_itemType in varchar2
2077: ,p_itemKey in varchar2

Line 2074: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2070:
2071: procedure set_offered_attributes (
2072: p_api_version_number IN NUMBER
2073: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2074: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2075: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2076: ,p_itemType in varchar2
2077: ,p_itemKey in varchar2
2078: ,p_partner_id IN number

Line 2075: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2071: procedure set_offered_attributes (
2072: p_api_version_number IN NUMBER
2073: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2074: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2075: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2076: ,p_itemType in varchar2
2077: ,p_itemKey in varchar2
2078: ,p_partner_id IN number
2079: ,x_msg_count OUT NOCOPY NUMBER

Line 2147: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

2143:
2144: begin
2145: -- Standard call to check for call compatibility.
2146:
2147: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2148: p_api_version_number,
2149: l_api_name,
2150: G_PKG_NAME) THEN
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2147: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2148: p_api_version_number,
2149: l_api_name,
2150: G_PKG_NAME) THEN
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152:
2153: END IF;
2154:
2155: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2156: IF FND_API.to_Boolean( p_init_msg_list )

2152:
2153: END IF;
2154:
2155: -- Initialize message list if p_init_msg_list is set to TRUE.
2156: IF FND_API.to_Boolean( p_init_msg_list )
2157: THEN
2158: fnd_msg_pub.initialize;
2159: END IF;
2160:

Line 2168: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2164: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
2165: fnd_msg_pub.Add;
2166: END IF;
2167:
2168: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2169:
2170: l_customer_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
2171: itemkey => p_itemkey,
2172: aname => pv_workflow_pub.g_wf_attr_customer_id);

Line 2192: raise FND_API.G_EXC_ERROR;

2188:
2189: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2190: fnd_message.Set_token('TEXT', 'Cannot find partner for itemkey: ' || p_itemkey || '. Partner id: ' || p_partner_id);
2191: fnd_msg_pub.Add;
2192: raise FND_API.G_EXC_ERROR;
2193:
2194: end if;
2195:
2196: close lc_get_pt_org_name;

Line 2202: ,p_init_msg_list => FND_API.G_FALSE

2198: end if;
2199:
2200: SetPartnerAttributes (
2201: p_api_version_number => 1.0
2202: ,p_init_msg_list => FND_API.G_FALSE
2203: ,p_commit => FND_API.G_FALSE
2204: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2205: ,p_itemType => p_itemtype
2206: ,p_itemKey => p_itemkey

Line 2203: ,p_commit => FND_API.G_FALSE

2199:
2200: SetPartnerAttributes (
2201: p_api_version_number => 1.0
2202: ,p_init_msg_list => FND_API.G_FALSE
2203: ,p_commit => FND_API.G_FALSE
2204: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2205: ,p_itemType => p_itemtype
2206: ,p_itemKey => p_itemkey
2207: ,p_partner_id => p_partner_id

Line 2204: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2200: SetPartnerAttributes (
2201: p_api_version_number => 1.0
2202: ,p_init_msg_list => FND_API.G_FALSE
2203: ,p_commit => FND_API.G_FALSE
2204: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2205: ,p_itemType => p_itemtype
2206: ,p_itemKey => p_itemkey
2207: ,p_partner_id => p_partner_id
2208: ,p_partner_org => l_partner_org

Line 2213: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2209: ,x_msg_count => x_msg_count
2210: ,x_msg_data => x_msg_data
2211: ,x_return_status => x_return_status);
2212:
2213: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2214: raise FND_API.G_EXC_ERROR;
2215: end if;
2216:
2217: if p_partner_id is null then

Line 2214: raise FND_API.G_EXC_ERROR;

2210: ,x_msg_data => x_msg_data
2211: ,x_return_status => x_return_status);
2212:
2213: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2214: raise FND_API.G_EXC_ERROR;
2215: end if;
2216:
2217: if p_partner_id is null then
2218:

Line 2263: p_init_msg_list => FND_API.G_FALSE,

2259: for i in 1 .. l_resource_id_tbl.count loop
2260:
2261: pv_assign_util_pvt.UpdateAccess(
2262: p_api_version_number => 1.0,
2263: p_init_msg_list => FND_API.G_FALSE,
2264: p_commit => FND_API.G_FALSE,
2265: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2266: p_itemtype => p_itemType,
2267: p_itemkey => p_itemKey,

Line 2264: p_commit => FND_API.G_FALSE,

2260:
2261: pv_assign_util_pvt.UpdateAccess(
2262: p_api_version_number => 1.0,
2263: p_init_msg_list => FND_API.G_FALSE,
2264: p_commit => FND_API.G_FALSE,
2265: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2266: p_itemtype => p_itemType,
2267: p_itemkey => p_itemKey,
2268: p_current_username => l_username_tbl(i),

Line 2265: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2261: pv_assign_util_pvt.UpdateAccess(
2262: p_api_version_number => 1.0,
2263: p_init_msg_list => FND_API.G_FALSE,
2264: p_commit => FND_API.G_FALSE,
2265: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2266: p_itemtype => p_itemType,
2267: p_itemkey => p_itemKey,
2268: p_current_username => l_username_tbl(i),
2269: p_lead_id => l_lead_id,

Line 2280: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2276: x_return_status => x_return_status,
2277: x_msg_count => x_msg_count,
2278: x_msg_data => x_msg_data);
2279:
2280: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2281: raise FND_API.G_EXC_ERROR;
2282: end if;
2283:
2284: end loop;

Line 2281: raise FND_API.G_EXC_ERROR;

2277: x_msg_count => x_msg_count,
2278: x_msg_data => x_msg_data);
2279:
2280: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2281: raise FND_API.G_EXC_ERROR;
2282: end if;
2283:
2284: end loop;
2285:

Line 2288: p_init_msg_list => FND_API.G_FALSE,

2284: end loop;
2285:
2286: pv_assignment_pvt.setTimeout (
2287: p_api_version_number => 1.0,
2288: p_init_msg_list => FND_API.G_FALSE,
2289: p_commit => FND_API.G_FALSE,
2290: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2291: p_itemtype => p_itemType,
2292: p_itemkey => p_itemKey,

Line 2289: p_commit => FND_API.G_FALSE,

2285:
2286: pv_assignment_pvt.setTimeout (
2287: p_api_version_number => 1.0,
2288: p_init_msg_list => FND_API.G_FALSE,
2289: p_commit => FND_API.G_FALSE,
2290: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2291: p_itemtype => p_itemType,
2292: p_itemkey => p_itemKey,
2293: p_partner_id => p_partner_id,

Line 2290: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2286: pv_assignment_pvt.setTimeout (
2287: p_api_version_number => 1.0,
2288: p_init_msg_list => FND_API.G_FALSE,
2289: p_commit => FND_API.G_FALSE,
2290: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2291: p_itemtype => p_itemType,
2292: p_itemkey => p_itemKey,
2293: p_partner_id => p_partner_id,
2294: p_timeoutType => pv_assignment_pub.g_offered_timeout,

Line 2299: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2295: x_return_status => x_return_status,
2296: x_msg_count => x_msg_count,
2297: x_msg_data => x_msg_data);
2298:
2299: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2300: raise FND_API.G_EXC_ERROR;
2301: end if;
2302:
2303: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 2300: raise FND_API.G_EXC_ERROR;

2296: x_msg_count => x_msg_count,
2297: x_msg_data => x_msg_data);
2298:
2299: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2300: raise FND_API.G_EXC_ERROR;
2301: end if;
2302:
2303: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2304: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 2385: IF FND_API.To_Boolean ( p_commit ) THEN

2381: pv_assignment_pub.g_la_status_cm_timeout
2382: ));
2383: end if;
2384:
2385: IF FND_API.To_Boolean ( p_commit ) THEN
2386: COMMIT WORK;
2387: END IF;
2388:
2389: -- Standard call to get message count and if count is 1, get message info.

Line 2390: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2386: COMMIT WORK;
2387: END IF;
2388:
2389: -- Standard call to get message count and if count is 1, get message info.
2390: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2391: p_count => x_msg_count,
2392: p_data => x_msg_data);
2393: EXCEPTION
2394:

Line 2395: WHEN FND_API.G_EXC_ERROR THEN

2391: p_count => x_msg_count,
2392: p_data => x_msg_data);
2393: EXCEPTION
2394:
2395: WHEN FND_API.G_EXC_ERROR THEN
2396:
2397: x_return_status := FND_API.G_RET_STS_ERROR ;
2398: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2399: p_count => x_msg_count,

Line 2397: x_return_status := FND_API.G_RET_STS_ERROR ;

2393: EXCEPTION
2394:
2395: WHEN FND_API.G_EXC_ERROR THEN
2396:
2397: x_return_status := FND_API.G_RET_STS_ERROR ;
2398: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2399: p_count => x_msg_count,
2400: p_data => x_msg_data);
2401:

Line 2398: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2394:
2395: WHEN FND_API.G_EXC_ERROR THEN
2396:
2397: x_return_status := FND_API.G_RET_STS_ERROR ;
2398: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2399: p_count => x_msg_count,
2400: p_data => x_msg_data);
2401:
2402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2398: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2399: p_count => x_msg_count,
2400: p_data => x_msg_data);
2401:
2402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2403:
2404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2405: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2406: p_count => x_msg_count,

Line 2404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2400: p_data => x_msg_data);
2401:
2402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2403:
2404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2405: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2406: p_count => x_msg_count,
2407: p_data => x_msg_data);
2408:

Line 2405: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2401:
2402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2403:
2404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2405: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2406: p_count => x_msg_count,
2407: p_data => x_msg_data);
2408:
2409: WHEN OTHERS THEN

Line 2411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2407: p_data => x_msg_data);
2408:
2409: WHEN OTHERS THEN
2410:
2411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2412: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2413: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2414: p_count => x_msg_count,
2415: p_data => x_msg_data);

Line 2413: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2409: WHEN OTHERS THEN
2410:
2411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2412: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2413: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2414: p_count => x_msg_count,
2415: p_data => x_msg_data);
2416:
2417: end set_offered_attributes;

Line 2425: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2421: -- Procedure Update_Routing_Stage
2422: -- -----------------------------------------------------------------------------------
2423: procedure update_routing_stage (
2424: p_api_version_number IN NUMBER
2425: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2426: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2427: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2428: ,p_itemtype IN varchar2
2429: ,p_itemkey IN varchar2

Line 2426: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2422: -- -----------------------------------------------------------------------------------
2423: procedure update_routing_stage (
2424: p_api_version_number IN NUMBER
2425: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2426: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2427: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2428: ,p_itemtype IN varchar2
2429: ,p_itemkey IN varchar2
2430: ,p_routing_stage IN VARCHAR2

Line 2427: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2423: procedure update_routing_stage (
2424: p_api_version_number IN NUMBER
2425: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2426: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2427: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2428: ,p_itemtype IN varchar2
2429: ,p_itemkey IN varchar2
2430: ,p_routing_stage IN VARCHAR2
2431: ,p_active_but_open_flag IN VARCHAR2

Line 2501: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

2497:
2498: begin
2499: -- Standard call to check for call compatibility.
2500:
2501: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2502: p_api_version_number,
2503: l_api_name,
2504: G_PKG_NAME) THEN
2505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2501: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2502: p_api_version_number,
2503: l_api_name,
2504: G_PKG_NAME) THEN
2505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2506:
2507: END IF;
2508:
2509: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2510: IF FND_API.to_Boolean( p_init_msg_list )

2506:
2507: END IF;
2508:
2509: -- Initialize message list if p_init_msg_list is set to TRUE.
2510: IF FND_API.to_Boolean( p_init_msg_list )
2511: THEN
2512: fnd_msg_pub.initialize;
2513: END IF;
2514:

Line 2522: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2518: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
2519: fnd_msg_pub.Add;
2520: END IF;
2521:
2522: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2523:
2524: if p_routing_stage not in ( pv_assignment_pub.g_r_status_active,
2525: pv_assignment_pub.g_r_status_matched,
2526: pv_assignment_pub.g_r_status_offered,

Line 2537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2533: fnd_message.SET_TOKEN('TEXT', 'Invalid workflow routing stage. Itemkey: ' || p_itemkey ||
2534: '. Stage: ' || p_routing_stage);
2535: fnd_msg_pub.ADD;
2536:
2537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2538:
2539: end if;
2540:
2541: open lc_get_workflow (pc_itemtype => p_itemtype,

Line 2552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2548: if l_rowid is null then
2549: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2550: fnd_message.SET_TOKEN('TEXT', 'Cannot find workflow row to update. Itemkey: ' || p_itemkey);
2551: fnd_msg_pub.ADD;
2552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2553: end if;
2554:
2555: if p_routing_stage = pv_assignment_pub.g_r_status_active and p_active_but_open_flag = 'Y' then
2556:

Line 2648: p_init_msg_list => FND_API.G_FALSE,

2644: l_assignment_log_rec.lead_assignment_id := lrec.lead_assignment_id;
2645:
2646: Create_assignment_log_row (
2647: p_api_version_number => 1.0,
2648: p_init_msg_list => FND_API.G_FALSE,
2649: p_commit => FND_API.G_FALSE,
2650: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2651: p_assignment_log_rec => l_assignment_log_rec,
2652: x_assignment_id => l_assignment_log_id,

Line 2649: p_commit => FND_API.G_FALSE,

2645:
2646: Create_assignment_log_row (
2647: p_api_version_number => 1.0,
2648: p_init_msg_list => FND_API.G_FALSE,
2649: p_commit => FND_API.G_FALSE,
2650: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2651: p_assignment_log_rec => l_assignment_log_rec,
2652: x_assignment_id => l_assignment_log_id,
2653: x_return_status => x_return_status,

Line 2650: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2646: Create_assignment_log_row (
2647: p_api_version_number => 1.0,
2648: p_init_msg_list => FND_API.G_FALSE,
2649: p_commit => FND_API.G_FALSE,
2650: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2651: p_assignment_log_rec => l_assignment_log_rec,
2652: x_assignment_id => l_assignment_log_id,
2653: x_return_status => x_return_status,
2654: x_msg_count => x_msg_count,

Line 2657: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2653: x_return_status => x_return_status,
2654: x_msg_count => x_msg_count,
2655: x_msg_data => x_msg_data);
2656:
2657: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2658: raise FND_API.G_EXC_ERROR;
2659: end if;
2660: end loop;
2661: end if;

Line 2658: raise FND_API.G_EXC_ERROR;

2654: x_msg_count => x_msg_count,
2655: x_msg_data => x_msg_data);
2656:
2657: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2658: raise FND_API.G_EXC_ERROR;
2659: end if;
2660: end loop;
2661: end if;
2662:

Line 2671: p_init_msg_list => FND_API.G_FALSE,

2667: l_assignment_log_rec.lead_assignment_id := lrec.lead_assignment_id;
2668:
2669: Create_assignment_log_row (
2670: p_api_version_number => 1.0,
2671: p_init_msg_list => FND_API.G_FALSE,
2672: p_commit => FND_API.G_FALSE,
2673: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2674: p_assignment_log_rec => l_assignment_log_rec,
2675: x_assignment_id => l_assignment_log_id,

Line 2672: p_commit => FND_API.G_FALSE,

2668:
2669: Create_assignment_log_row (
2670: p_api_version_number => 1.0,
2671: p_init_msg_list => FND_API.G_FALSE,
2672: p_commit => FND_API.G_FALSE,
2673: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2674: p_assignment_log_rec => l_assignment_log_rec,
2675: x_assignment_id => l_assignment_log_id,
2676: x_return_status => x_return_status,

Line 2673: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2669: Create_assignment_log_row (
2670: p_api_version_number => 1.0,
2671: p_init_msg_list => FND_API.G_FALSE,
2672: p_commit => FND_API.G_FALSE,
2673: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2674: p_assignment_log_rec => l_assignment_log_rec,
2675: x_assignment_id => l_assignment_log_id,
2676: x_return_status => x_return_status,
2677: x_msg_count => x_msg_count,

Line 2680: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2676: x_return_status => x_return_status,
2677: x_msg_count => x_msg_count,
2678: x_msg_data => x_msg_data);
2679:
2680: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2681: raise FND_API.G_EXC_ERROR;
2682: end if;
2683: end loop;
2684:

Line 2681: raise FND_API.G_EXC_ERROR;

2677: x_msg_count => x_msg_count,
2678: x_msg_data => x_msg_data);
2679:
2680: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2681: raise FND_API.G_EXC_ERROR;
2682: end if;
2683: end loop;
2684:
2685: elsif p_routing_stage = 'ABANDONED' then

Line 2693: p_init_msg_list => FND_API.G_FALSE,

2689: l_assignment_log_rec.lead_assignment_id := lrec.lead_assignment_id;
2690:
2691: Create_assignment_log_row (
2692: p_api_version_number => 1.0,
2693: p_init_msg_list => FND_API.G_FALSE,
2694: p_commit => FND_API.G_FALSE,
2695: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2696: p_assignment_log_rec => l_assignment_log_rec,
2697: x_assignment_id => l_assignment_log_id,

Line 2694: p_commit => FND_API.G_FALSE,

2690:
2691: Create_assignment_log_row (
2692: p_api_version_number => 1.0,
2693: p_init_msg_list => FND_API.G_FALSE,
2694: p_commit => FND_API.G_FALSE,
2695: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2696: p_assignment_log_rec => l_assignment_log_rec,
2697: x_assignment_id => l_assignment_log_id,
2698: x_return_status => x_return_status,

Line 2695: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2691: Create_assignment_log_row (
2692: p_api_version_number => 1.0,
2693: p_init_msg_list => FND_API.G_FALSE,
2694: p_commit => FND_API.G_FALSE,
2695: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2696: p_assignment_log_rec => l_assignment_log_rec,
2697: x_assignment_id => l_assignment_log_id,
2698: x_return_status => x_return_status,
2699: x_msg_count => x_msg_count,

Line 2702: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2698: x_return_status => x_return_status,
2699: x_msg_count => x_msg_count,
2700: x_msg_data => x_msg_data);
2701:
2702: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2703: raise FND_API.G_EXC_ERROR;
2704: end if;
2705: end loop;
2706: else

Line 2703: raise FND_API.G_EXC_ERROR;

2699: x_msg_count => x_msg_count,
2700: x_msg_data => x_msg_data);
2701:
2702: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2703: raise FND_API.G_EXC_ERROR;
2704: end if;
2705: end loop;
2706: else
2707: Create_assignment_log_row (

Line 2709: p_init_msg_list => FND_API.G_FALSE,

2705: end loop;
2706: else
2707: Create_assignment_log_row (
2708: p_api_version_number => 1.0,
2709: p_init_msg_list => FND_API.G_FALSE,
2710: p_commit => FND_API.G_FALSE,
2711: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2712: p_assignment_log_rec => l_assignment_log_rec,
2713: x_assignment_id => l_assignment_log_id,

Line 2710: p_commit => FND_API.G_FALSE,

2706: else
2707: Create_assignment_log_row (
2708: p_api_version_number => 1.0,
2709: p_init_msg_list => FND_API.G_FALSE,
2710: p_commit => FND_API.G_FALSE,
2711: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2712: p_assignment_log_rec => l_assignment_log_rec,
2713: x_assignment_id => l_assignment_log_id,
2714: x_return_status => x_return_status,

Line 2711: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2707: Create_assignment_log_row (
2708: p_api_version_number => 1.0,
2709: p_init_msg_list => FND_API.G_FALSE,
2710: p_commit => FND_API.G_FALSE,
2711: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2712: p_assignment_log_rec => l_assignment_log_rec,
2713: x_assignment_id => l_assignment_log_id,
2714: x_return_status => x_return_status,
2715: x_msg_count => x_msg_count,

Line 2718: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2714: x_return_status => x_return_status,
2715: x_msg_count => x_msg_count,
2716: x_msg_data => x_msg_data);
2717:
2718: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2719: raise FND_API.G_EXC_ERROR;
2720: end if;
2721: end if;
2722:

Line 2719: raise FND_API.G_EXC_ERROR;

2715: x_msg_count => x_msg_count,
2716: x_msg_data => x_msg_data);
2717:
2718: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2719: raise FND_API.G_EXC_ERROR;
2720: end if;
2721: end if;
2722:
2723: if l_wf_status = pv_assignment_pub.g_wf_status_closed then

Line 2752: IF FND_API.To_Boolean ( p_commit ) THEN

2748: end if;
2749:
2750: end if;
2751:
2752: IF FND_API.To_Boolean ( p_commit ) THEN
2753: COMMIT WORK;
2754: END IF;
2755:
2756: -- Standard call to get message count and if count is 1, get message info.

Line 2757: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2753: COMMIT WORK;
2754: END IF;
2755:
2756: -- Standard call to get message count and if count is 1, get message info.
2757: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2758: p_count => x_msg_count,
2759: p_data => x_msg_data);
2760: EXCEPTION
2761:

Line 2762: WHEN FND_API.G_EXC_ERROR THEN

2758: p_count => x_msg_count,
2759: p_data => x_msg_data);
2760: EXCEPTION
2761:
2762: WHEN FND_API.G_EXC_ERROR THEN
2763:
2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2766: p_count => x_msg_count,

Line 2764: x_return_status := FND_API.G_RET_STS_ERROR ;

2760: EXCEPTION
2761:
2762: WHEN FND_API.G_EXC_ERROR THEN
2763:
2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2766: p_count => x_msg_count,
2767: p_data => x_msg_data);
2768:

Line 2765: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2761:
2762: WHEN FND_API.G_EXC_ERROR THEN
2763:
2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2766: p_count => x_msg_count,
2767: p_data => x_msg_data);
2768:
2769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2765: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2766: p_count => x_msg_count,
2767: p_data => x_msg_data);
2768:
2769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2770:
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2772: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2773: p_count => x_msg_count,

Line 2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2767: p_data => x_msg_data);
2768:
2769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2770:
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2772: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2773: p_count => x_msg_count,
2774: p_data => x_msg_data);
2775:

Line 2772: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2768:
2769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2770:
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2772: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2773: p_count => x_msg_count,
2774: p_data => x_msg_data);
2775:
2776: WHEN OTHERS THEN

Line 2778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2774: p_data => x_msg_data);
2775:
2776: WHEN OTHERS THEN
2777:
2778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2779: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2780: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2781: p_count => x_msg_count,
2782: p_data => x_msg_data);

Line 2780: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2776: WHEN OTHERS THEN
2777:
2778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2779: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2780: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2781: p_count => x_msg_count,
2782: p_data => x_msg_data);
2783:
2784: end update_routing_stage;

Line 2789: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2785:
2786:
2787: procedure StartWorkflow (
2788: p_api_version_number IN NUMBER,
2789: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2790: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2791: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2792: p_itemKey IN VARCHAR2,
2793: p_itemType IN VARCHAR2,

Line 2790: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2786:
2787: procedure StartWorkflow (
2788: p_api_version_number IN NUMBER,
2789: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2790: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2791: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2792: p_itemKey IN VARCHAR2,
2793: p_itemType IN VARCHAR2,
2794: p_creating_username IN VARCHAR2,

Line 2791: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2787: procedure StartWorkflow (
2788: p_api_version_number IN NUMBER,
2789: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2790: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2791: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2792: p_itemKey IN VARCHAR2,
2793: p_itemType IN VARCHAR2,
2794: p_creating_username IN VARCHAR2,
2795: p_attrib_values_rec IN attrib_values_rec_type,

Line 2812: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

2808:
2809: begin
2810: -- Standard call to check for call compatibility.
2811:
2812: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2813: p_api_version_number,
2814: l_api_name,
2815: G_PKG_NAME) THEN
2816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2812: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2813: p_api_version_number,
2814: l_api_name,
2815: G_PKG_NAME) THEN
2816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2817:
2818: END IF;
2819:
2820: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2821: IF FND_API.to_Boolean( p_init_msg_list )

2817:
2818: END IF;
2819:
2820: -- Initialize message list if p_init_msg_list is set to TRUE.
2821: IF FND_API.to_Boolean( p_init_msg_list )
2822: THEN
2823: fnd_msg_pub.initialize;
2824: END IF;
2825:

Line 2834: x_return_status := FND_API.G_RET_STS_SUCCESS;

2830: fnd_msg_pub.Add;
2831: END IF;
2832:
2833: -- Initialize API return status to success
2834: x_return_status := FND_API.G_RET_STS_SUCCESS;
2835:
2836: -- Create Assignment Process
2837: IF p_attrib_values_rec.process_name = pv_workflow_pub.g_wf_pcs_initiate_assignment THEN
2838: wf_engine.CreateProcess ( ItemType => p_itemtype,

Line 2963: IF FND_API.To_Boolean ( p_commit ) THEN

2959: wf_engine.StartProcess( itemtype => p_itemtype,
2960: itemkey => p_itemkey);
2961:
2962:
2963: IF FND_API.To_Boolean ( p_commit ) THEN
2964: COMMIT WORK;
2965: END IF;
2966:
2967: -- Standard call to get message count and if count is 1, get message info.

Line 2968: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2964: COMMIT WORK;
2965: END IF;
2966:
2967: -- Standard call to get message count and if count is 1, get message info.
2968: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2969: p_count => x_msg_count,
2970: p_data => x_msg_data);
2971: EXCEPTION
2972:

Line 2973: WHEN FND_API.G_EXC_ERROR THEN

2969: p_count => x_msg_count,
2970: p_data => x_msg_data);
2971: EXCEPTION
2972:
2973: WHEN FND_API.G_EXC_ERROR THEN
2974:
2975: x_return_status := FND_API.G_RET_STS_ERROR ;
2976: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2977: p_count => x_msg_count,

Line 2975: x_return_status := FND_API.G_RET_STS_ERROR ;

2971: EXCEPTION
2972:
2973: WHEN FND_API.G_EXC_ERROR THEN
2974:
2975: x_return_status := FND_API.G_RET_STS_ERROR ;
2976: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2977: p_count => x_msg_count,
2978: p_data => x_msg_data);
2979:

Line 2976: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2972:
2973: WHEN FND_API.G_EXC_ERROR THEN
2974:
2975: x_return_status := FND_API.G_RET_STS_ERROR ;
2976: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2977: p_count => x_msg_count,
2978: p_data => x_msg_data);
2979:
2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2976: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2977: p_count => x_msg_count,
2978: p_data => x_msg_data);
2979:
2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2981:
2982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2983: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2984: p_count => x_msg_count,

Line 2982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2978: p_data => x_msg_data);
2979:
2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2981:
2982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2983: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2984: p_count => x_msg_count,
2985: p_data => x_msg_data);
2986:

Line 2983: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2979:
2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2981:
2982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2983: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2984: p_count => x_msg_count,
2985: p_data => x_msg_data);
2986:
2987: WHEN OTHERS THEN

Line 2989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2985: p_data => x_msg_data);
2986:
2987: WHEN OTHERS THEN
2988:
2989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2990: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2991: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2992: p_count => x_msg_count,
2993: p_data => x_msg_data);

Line 2991: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

2987: WHEN OTHERS THEN
2988:
2989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2990: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2991: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
2992: p_count => x_msg_count,
2993: p_data => x_msg_data);
2994: end StartWorkflow;
2995:

Line 2999: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2995:
2996:
2997: procedure validateResponse (
2998: p_api_version_number IN NUMBER
2999: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3000: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3001: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3002: ,p_response_code IN VARCHAR2
3003: ,p_routing_status IN VARCHAR2

Line 3000: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2996:
2997: procedure validateResponse (
2998: p_api_version_number IN NUMBER
2999: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3000: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3001: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3002: ,p_response_code IN VARCHAR2
3003: ,p_routing_status IN VARCHAR2
3004: ,p_decision_maker_flag IN VARCHAR2

Line 3001: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2997: procedure validateResponse (
2998: p_api_version_number IN NUMBER
2999: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3000: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3001: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3002: ,p_response_code IN VARCHAR2
3003: ,p_routing_status IN VARCHAR2
3004: ,p_decision_maker_flag IN VARCHAR2
3005: ,p_notify_type IN VARCHAR2

Line 3028: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

3024: begin
3025:
3026: -- Standard call to check for call compatibility.
3027:
3028: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3029: p_api_version_number,
3030: l_api_name,
3031: G_PKG_NAME) THEN
3032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3028: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3029: p_api_version_number,
3030: l_api_name,
3031: G_PKG_NAME) THEN
3032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3033:
3034: END IF;
3035:
3036: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3037: IF FND_API.to_Boolean( p_init_msg_list )

3033:
3034: END IF;
3035:
3036: -- Initialize message list if p_init_msg_list is set to TRUE.
3037: IF FND_API.to_Boolean( p_init_msg_list )
3038: THEN
3039: fnd_msg_pub.initialize;
3040: END IF;
3041:

Line 3049: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3045: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
3046: fnd_msg_pub.Add;
3047: END IF;
3048:
3049: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3050:
3051: if p_response_code is null then
3052:
3053: fnd_message.SET_NAME('PV', 'PV_INVALID_RESPONSE');

Line 3057: raise FND_API.G_EXC_ERROR;

3053: fnd_message.SET_NAME('PV', 'PV_INVALID_RESPONSE');
3054: fnd_message.SET_TOKEN('STATUS', p_response_code);
3055: fnd_msg_pub.ADD;
3056:
3057: raise FND_API.G_EXC_ERROR;
3058:
3059: end if;
3060:
3061: if p_decision_maker_flag <> 'Y' or p_decision_maker_flag is NULL then

Line 3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3062:
3063: fnd_message.set_name('PV', 'PV_NOT_DECISION_MAKER');
3064: fnd_msg_pub.ADD;
3065:
3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3067:
3068: end if;
3069:
3070: open lc_code_meaning ( pc_lookup_type => 'PV_ASSIGNMENT_STATUS',

Line 3082: raise FND_API.G_EXC_ERROR;

3078: fnd_message.SET_NAME('PV', 'PV_INVALID_RESPONSE');
3079: fnd_message.SET_TOKEN('STATUS', p_response_code);
3080: fnd_msg_pub.ADD;
3081:
3082: raise FND_API.G_EXC_ERROR;
3083: end if;
3084:
3085: if p_routing_status = pv_assignment_pub.g_r_status_matched and
3086: p_notify_type = pv_assignment_pub.g_notify_type_matched_to and

Line 3129: raise FND_API.G_EXC_ERROR;

3125: fnd_message.SET_TOKEN('P_RESPONSE', l_response_txt);
3126: fnd_message.SET_TOKEN('P_LEAD_STATUS', l_routing_status_txt);
3127: fnd_msg_pub.ADD;
3128:
3129: raise FND_API.G_EXC_ERROR;
3130: end if;
3131:
3132:
3133: IF FND_API.To_Boolean ( p_commit ) THEN

Line 3133: IF FND_API.To_Boolean ( p_commit ) THEN

3129: raise FND_API.G_EXC_ERROR;
3130: end if;
3131:
3132:
3133: IF FND_API.To_Boolean ( p_commit ) THEN
3134: COMMIT WORK;
3135: END IF;
3136:
3137: -- Standard call to get message count and if count is 1, get message info.

Line 3138: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

3134: COMMIT WORK;
3135: END IF;
3136:
3137: -- Standard call to get message count and if count is 1, get message info.
3138: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3139: p_count => x_msg_count,
3140: p_data => x_msg_data);
3141: EXCEPTION
3142:

Line 3143: WHEN FND_API.G_EXC_ERROR THEN

3139: p_count => x_msg_count,
3140: p_data => x_msg_data);
3141: EXCEPTION
3142:
3143: WHEN FND_API.G_EXC_ERROR THEN
3144:
3145: x_return_status := FND_API.G_RET_STS_ERROR ;
3146: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3147: p_count => x_msg_count,

Line 3145: x_return_status := FND_API.G_RET_STS_ERROR ;

3141: EXCEPTION
3142:
3143: WHEN FND_API.G_EXC_ERROR THEN
3144:
3145: x_return_status := FND_API.G_RET_STS_ERROR ;
3146: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3147: p_count => x_msg_count,
3148: p_data => x_msg_data);
3149:

Line 3146: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

3142:
3143: WHEN FND_API.G_EXC_ERROR THEN
3144:
3145: x_return_status := FND_API.G_RET_STS_ERROR ;
3146: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3147: p_count => x_msg_count,
3148: p_data => x_msg_data);
3149:
3150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3146: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3147: p_count => x_msg_count,
3148: p_data => x_msg_data);
3149:
3150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3151:
3152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3153: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3154: p_count => x_msg_count,

Line 3152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3148: p_data => x_msg_data);
3149:
3150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3151:
3152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3153: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3154: p_count => x_msg_count,
3155: p_data => x_msg_data);
3156:

Line 3153: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

3149:
3150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3151:
3152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3153: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3154: p_count => x_msg_count,
3155: p_data => x_msg_data);
3156:
3157: WHEN OTHERS THEN

Line 3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3155: p_data => x_msg_data);
3156:
3157: WHEN OTHERS THEN
3158:
3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3160: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3161: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3162: p_count => x_msg_count,
3163: p_data => x_msg_data);

Line 3161: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

3157: WHEN OTHERS THEN
3158:
3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3160: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3161: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3162: p_count => x_msg_count,
3163: p_data => x_msg_data);
3164: end validateResponse;
3165:

Line 3169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3165:
3166:
3167: procedure set_current_routing_flag (
3168: p_api_version_number IN NUMBER,
3169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3172: p_itemKey in varchar2,
3173: p_entity IN VARCHAR2,

Line 3170: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3166:
3167: procedure set_current_routing_flag (
3168: p_api_version_number IN NUMBER,
3169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3172: p_itemKey in varchar2,
3173: p_entity IN VARCHAR2,
3174: p_entity_id IN NUMBER,

Line 3171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3167: procedure set_current_routing_flag (
3168: p_api_version_number IN NUMBER,
3169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3172: p_itemKey in varchar2,
3173: p_entity IN VARCHAR2,
3174: p_entity_id IN NUMBER,
3175: x_return_status OUT NOCOPY VARCHAR2,

Line 3185: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

3181:
3182: begin
3183: -- Standard call to check for call compatibility.
3184:
3185: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3186: p_api_version_number,
3187: l_api_name,
3188: G_PKG_NAME) THEN
3189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3185: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3186: p_api_version_number,
3187: l_api_name,
3188: G_PKG_NAME) THEN
3189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3190:
3191: END IF;
3192:
3193: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3194: IF FND_API.to_Boolean( p_init_msg_list )

3190:
3191: END IF;
3192:
3193: -- Initialize message list if p_init_msg_list is set to TRUE.
3194: IF FND_API.to_Boolean( p_init_msg_list )
3195: THEN
3196: fnd_msg_pub.initialize;
3197: END IF;
3198:

Line 3206: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3202: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
3203: fnd_msg_pub.Add;
3204: END IF;
3205:
3206: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3207:
3208: update pv_lead_workflows
3209: set latest_routing_flag = decode(wf_item_key, p_itemkey, 'Y', 'N'),
3210: object_version_number = object_version_number + 1

Line 3215: IF FND_API.To_Boolean ( p_commit ) THEN

3211: where lead_id = p_entity_id
3212: and entity = p_entity
3213: and latest_routing_flag = 'Y';
3214:
3215: IF FND_API.To_Boolean ( p_commit ) THEN
3216: COMMIT WORK;
3217: END IF;
3218:
3219: -- Standard call to get message count and if count is 1, get message info.

Line 3220: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

3216: COMMIT WORK;
3217: END IF;
3218:
3219: -- Standard call to get message count and if count is 1, get message info.
3220: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3221: p_count => x_msg_count,
3222: p_data => x_msg_data);
3223: EXCEPTION
3224:

Line 3225: WHEN FND_API.G_EXC_ERROR THEN

3221: p_count => x_msg_count,
3222: p_data => x_msg_data);
3223: EXCEPTION
3224:
3225: WHEN FND_API.G_EXC_ERROR THEN
3226:
3227: x_return_status := FND_API.G_RET_STS_ERROR ;
3228: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3229: p_count => x_msg_count,

Line 3227: x_return_status := FND_API.G_RET_STS_ERROR ;

3223: EXCEPTION
3224:
3225: WHEN FND_API.G_EXC_ERROR THEN
3226:
3227: x_return_status := FND_API.G_RET_STS_ERROR ;
3228: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3229: p_count => x_msg_count,
3230: p_data => x_msg_data);
3231:

Line 3228: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

3224:
3225: WHEN FND_API.G_EXC_ERROR THEN
3226:
3227: x_return_status := FND_API.G_RET_STS_ERROR ;
3228: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3229: p_count => x_msg_count,
3230: p_data => x_msg_data);
3231:
3232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3228: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3229: p_count => x_msg_count,
3230: p_data => x_msg_data);
3231:
3232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3233:
3234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3235: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3236: p_count => x_msg_count,

Line 3234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3230: p_data => x_msg_data);
3231:
3232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3233:
3234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3235: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3236: p_count => x_msg_count,
3237: p_data => x_msg_data);
3238:

Line 3235: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

3231:
3232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3233:
3234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3235: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3236: p_count => x_msg_count,
3237: p_data => x_msg_data);
3238:
3239: WHEN OTHERS THEN

Line 3241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3237: p_data => x_msg_data);
3238:
3239: WHEN OTHERS THEN
3240:
3241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3242: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3243: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3244: p_count => x_msg_count,
3245: p_data => x_msg_data);

Line 3243: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

3239: WHEN OTHERS THEN
3240:
3241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3242: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3243: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3244: p_count => x_msg_count,
3245: p_data => x_msg_data);
3246:
3247: end set_current_routing_flag;

Line 3252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

3248:
3249:
3250: PROCEDURE Bulk_cr_party_notification(
3251: P_Api_Version_Number IN NUMBER,
3252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3253: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3255: P_party_notify_rec_tbl IN party_notify_rec_tbl_type,
3256: X_Return_Status OUT NOCOPY VARCHAR2,

Line 3253: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

3249:
3250: PROCEDURE Bulk_cr_party_notification(
3251: P_Api_Version_Number IN NUMBER,
3252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3253: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3255: P_party_notify_rec_tbl IN party_notify_rec_tbl_type,
3256: X_Return_Status OUT NOCOPY VARCHAR2,
3257: X_Msg_Count OUT NOCOPY NUMBER,

Line 3254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3250: PROCEDURE Bulk_cr_party_notification(
3251: P_Api_Version_Number IN NUMBER,
3252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3253: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3255: P_party_notify_rec_tbl IN party_notify_rec_tbl_type,
3256: X_Return_Status OUT NOCOPY VARCHAR2,
3257: X_Msg_Count OUT NOCOPY NUMBER,
3258: X_Msg_Data OUT NOCOPY VARCHAR2

Line 3274: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

3270:
3271: BEGIN
3272:
3273: -- Standard call to check for call compatibility.
3274: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3275: p_api_version_number,
3276: l_api_name,
3277: G_PKG_NAME)
3278: THEN

Line 3279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3275: p_api_version_number,
3276: l_api_name,
3277: G_PKG_NAME)
3278: THEN
3279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3280: END IF;
3281:
3282: -- Initialize message list if p_init_msg_list is set to TRUE.
3283: IF FND_API.to_Boolean( p_init_msg_list )

Line 3283: IF FND_API.to_Boolean( p_init_msg_list )

3279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3280: END IF;
3281:
3282: -- Initialize message list if p_init_msg_list is set to TRUE.
3283: IF FND_API.to_Boolean( p_init_msg_list )
3284: THEN
3285: FND_MSG_PUB.initialize;
3286: END IF;
3287:

Line 3296: x_return_status := FND_API.G_RET_STS_SUCCESS;

3292: fnd_msg_pub.Add;
3293: END IF;
3294:
3295: -- Initialize API return status to SUCCESS
3296: x_return_status := FND_API.G_RET_STS_SUCCESS;
3297:
3298: --
3299: -- API body
3300: --

Line 3366: IF FND_API.To_Boolean ( p_commit ) THEN

3362: --
3363: -- End of API body
3364: --
3365:
3366: IF FND_API.To_Boolean ( p_commit ) THEN
3367: COMMIT WORK;
3368: END IF;
3369:
3370: -- Standard call to get message count and if count is 1, get message info.

Line 3371: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

3367: COMMIT WORK;
3368: END IF;
3369:
3370: -- Standard call to get message count and if count is 1, get message info.
3371: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3372: p_count => x_msg_count,
3373: p_data => x_msg_data);
3374: EXCEPTION
3375:

Line 3376: WHEN FND_API.G_EXC_ERROR THEN

3372: p_count => x_msg_count,
3373: p_data => x_msg_data);
3374: EXCEPTION
3375:
3376: WHEN FND_API.G_EXC_ERROR THEN
3377:
3378: x_return_status := FND_API.G_RET_STS_ERROR ;
3379: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3380: p_count => x_msg_count,

Line 3378: x_return_status := FND_API.G_RET_STS_ERROR ;

3374: EXCEPTION
3375:
3376: WHEN FND_API.G_EXC_ERROR THEN
3377:
3378: x_return_status := FND_API.G_RET_STS_ERROR ;
3379: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3380: p_count => x_msg_count,
3381: p_data => x_msg_data);
3382:

Line 3379: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

3375:
3376: WHEN FND_API.G_EXC_ERROR THEN
3377:
3378: x_return_status := FND_API.G_RET_STS_ERROR ;
3379: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3380: p_count => x_msg_count,
3381: p_data => x_msg_data);
3382:
3383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3379: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3380: p_count => x_msg_count,
3381: p_data => x_msg_data);
3382:
3383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3384:
3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3386: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3387: p_count => x_msg_count,

Line 3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3381: p_data => x_msg_data);
3382:
3383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3384:
3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3386: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3387: p_count => x_msg_count,
3388: p_data => x_msg_data);
3389:

Line 3386: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

3382:
3383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3384:
3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3386: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
3387: p_count => x_msg_count,
3388: p_data => x_msg_data);
3389:
3390: WHEN OTHERS THEN

Line 3392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3388: p_data => x_msg_data);
3389:
3390: WHEN OTHERS THEN
3391:
3392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3393: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3394: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3395: p_count => x_msg_count,
3396: p_data => x_msg_data);

Line 3394: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

3390: WHEN OTHERS THEN
3391:
3392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3393: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3394: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3395: p_count => x_msg_count,
3396: p_data => x_msg_data);
3397:
3398: END Bulk_cr_party_notification;

Line 3403: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

3399:
3400:
3401: PROCEDURE send_notification(
3402: P_Api_Version_Number IN NUMBER,
3403: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3404: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3406: p_itemtype IN VARCHAR2,
3407: p_itemkey IN VARCHAR2,

Line 3404: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

3400:
3401: PROCEDURE send_notification(
3402: P_Api_Version_Number IN NUMBER,
3403: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3404: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3406: p_itemtype IN VARCHAR2,
3407: p_itemkey IN VARCHAR2,
3408: p_activity_id IN NUMBER,

Line 3405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3401: PROCEDURE send_notification(
3402: P_Api_Version_Number IN NUMBER,
3403: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3404: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3406: p_itemtype IN VARCHAR2,
3407: p_itemkey IN VARCHAR2,
3408: p_activity_id IN NUMBER,
3409: p_route_stage IN VARCHAR2,

Line 3573: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

3569: BEGIN
3570:
3571: -- Standard call to check for call compatibility.
3572:
3573: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3574: p_api_version_number,
3575: l_api_name,
3576: G_PKG_NAME) THEN
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3573: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3574: p_api_version_number,
3575: l_api_name,
3576: G_PKG_NAME) THEN
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578:
3579: END IF;
3580:
3581: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3582: IF FND_API.to_Boolean( p_init_msg_list )

3578:
3579: END IF;
3580:
3581: -- Initialize message list if p_init_msg_list is set to TRUE.
3582: IF FND_API.to_Boolean( p_init_msg_list )
3583: THEN
3584: fnd_msg_pub.initialize;
3585: END IF;
3586:

Line 3594: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3590: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. itemkey = ' || p_itemkey);
3591: fnd_msg_pub.Add;
3592: END IF;
3593:
3594: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3595:
3596: l_assignment_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,
3597: itemkey => p_itemkey,
3598: aname => pv_workflow_pub.g_wf_attr_assignment_type);

Line 3624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3620:
3621: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
3622: fnd_message.SET_TOKEN('TEXT', 'Cannot find routing stage: ' || p_route_stage || ' in pv_status_notifications');
3623: fnd_msg_pub.ADD;
3624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3625:
3626: end if;
3627:
3628: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 3973: raise FND_API.G_EXC_ERROR;

3969:
3970: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3971: fnd_message.Set_token('TEXT', 'Cannot find partner id: ' || l_partner_id);
3972: fnd_msg_pub.Add;
3973: raise FND_API.G_EXC_ERROR;
3974:
3975: end if;
3976:
3977: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 4084: IF FND_API.To_Boolean ( p_commit ) THEN

4080: end if;
4081:
4082: end if; --l_email_enabled_flag
4083:
4084: IF FND_API.To_Boolean ( p_commit ) THEN
4085: COMMIT WORK;
4086: END IF;
4087:
4088: -- Standard call to get message count and if count is 1, get message info.

Line 4089: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

4085: COMMIT WORK;
4086: END IF;
4087:
4088: -- Standard call to get message count and if count is 1, get message info.
4089: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4090: p_count => x_msg_count,
4091: p_data => x_msg_data);
4092: EXCEPTION
4093:

Line 4094: WHEN FND_API.G_EXC_ERROR THEN

4090: p_count => x_msg_count,
4091: p_data => x_msg_data);
4092: EXCEPTION
4093:
4094: WHEN FND_API.G_EXC_ERROR THEN
4095:
4096: x_return_status := FND_API.G_RET_STS_ERROR ;
4097: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4098: p_count => x_msg_count,

Line 4096: x_return_status := FND_API.G_RET_STS_ERROR ;

4092: EXCEPTION
4093:
4094: WHEN FND_API.G_EXC_ERROR THEN
4095:
4096: x_return_status := FND_API.G_RET_STS_ERROR ;
4097: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4098: p_count => x_msg_count,
4099: p_data => x_msg_data);
4100:

Line 4097: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

4093:
4094: WHEN FND_API.G_EXC_ERROR THEN
4095:
4096: x_return_status := FND_API.G_RET_STS_ERROR ;
4097: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4098: p_count => x_msg_count,
4099: p_data => x_msg_data);
4100:
4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4097: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4098: p_count => x_msg_count,
4099: p_data => x_msg_data);
4100:
4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4102:
4103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4104: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4105: p_count => x_msg_count,

Line 4103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4099: p_data => x_msg_data);
4100:
4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4102:
4103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4104: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4105: p_count => x_msg_count,
4106: p_data => x_msg_data);
4107:

Line 4104: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

4100:
4101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4102:
4103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4104: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4105: p_count => x_msg_count,
4106: p_data => x_msg_data);
4107:
4108: WHEN OTHERS THEN

Line 4120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4117:
4118: END IF;
4119:
4120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4121:
4122: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4123: p_count => x_msg_count,
4124: p_data => x_msg_data);

Line 4122: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

4118: END IF;
4119:
4120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4121:
4122: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4123: p_count => x_msg_count,
4124: p_data => x_msg_data);
4125:
4126: end send_notification;

Line 4130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4126: end send_notification;
4127:
4128: procedure AbandonWorkflow (
4129: p_api_version_number IN NUMBER,
4130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4133: p_creating_username IN VARCHAR2,
4134: p_attrib_values_rec IN attrib_values_rec_type,

Line 4131: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4127:
4128: procedure AbandonWorkflow (
4129: p_api_version_number IN NUMBER,
4130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4133: p_creating_username IN VARCHAR2,
4134: p_attrib_values_rec IN attrib_values_rec_type,
4135: p_partner_org_name IN VARCHAR2,

Line 4132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4128: procedure AbandonWorkflow (
4129: p_api_version_number IN NUMBER,
4130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4133: p_creating_username IN VARCHAR2,
4134: p_attrib_values_rec IN attrib_values_rec_type,
4135: p_partner_org_name IN VARCHAR2,
4136: p_action_reason IN VARCHAR2,

Line 4155: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

4151:
4152: begin
4153: -- Standard call to check for call compatibility.
4154:
4155: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4156: p_api_version_number,
4157: l_api_name,
4158: G_PKG_NAME) THEN
4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4155: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4156: p_api_version_number,
4157: l_api_name,
4158: G_PKG_NAME) THEN
4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4160:
4161: END IF;
4162:
4163: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4164: IF FND_API.to_Boolean( p_init_msg_list )

4160:
4161: END IF;
4162:
4163: -- Initialize message list if p_init_msg_list is set to TRUE.
4164: IF FND_API.to_Boolean( p_init_msg_list )
4165: THEN
4166: fnd_msg_pub.initialize;
4167: END IF;
4168:

Line 4177: x_return_status := FND_API.G_RET_STS_SUCCESS;

4173: fnd_msg_pub.Add;
4174: END IF;
4175:
4176: -- Initialize API return status to success
4177: x_return_status := FND_API.G_RET_STS_SUCCESS;
4178:
4179: select pv_lead_workflows_s.nextval into l_itemkey from dual;
4180:
4181:

Line 4256: ,p_init_msg_list => FND_API.G_FALSE

4252: itemkey => l_itemkey);
4253:
4254:
4255: PV_ASSIGN_UTIL_PVT.checkforErrors ( p_api_version_number => 1.0
4256: ,p_init_msg_list => FND_API.G_FALSE
4257: ,p_commit => FND_API.G_FALSE
4258: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
4259: ,p_itemtype => l_itemtype
4260: ,p_itemkey => l_itemkey

Line 4257: ,p_commit => FND_API.G_FALSE

4253:
4254:
4255: PV_ASSIGN_UTIL_PVT.checkforErrors ( p_api_version_number => 1.0
4256: ,p_init_msg_list => FND_API.G_FALSE
4257: ,p_commit => FND_API.G_FALSE
4258: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
4259: ,p_itemtype => l_itemtype
4260: ,p_itemkey => l_itemkey
4261: ,x_return_status => x_return_status

Line 4258: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

4254:
4255: PV_ASSIGN_UTIL_PVT.checkforErrors ( p_api_version_number => 1.0
4256: ,p_init_msg_list => FND_API.G_FALSE
4257: ,p_commit => FND_API.G_FALSE
4258: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
4259: ,p_itemtype => l_itemtype
4260: ,p_itemkey => l_itemkey
4261: ,x_return_status => x_return_status
4262: ,x_msg_count => x_msg_count

Line 4265: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

4261: ,x_return_status => x_return_status
4262: ,x_msg_count => x_msg_count
4263: ,x_msg_data => x_msg_data);
4264:
4265: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4266: raise FND_API.G_EXC_ERROR;
4267: end if;
4268:
4269: IF FND_API.To_Boolean ( p_commit ) THEN

Line 4266: raise FND_API.G_EXC_ERROR;

4262: ,x_msg_count => x_msg_count
4263: ,x_msg_data => x_msg_data);
4264:
4265: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4266: raise FND_API.G_EXC_ERROR;
4267: end if;
4268:
4269: IF FND_API.To_Boolean ( p_commit ) THEN
4270: COMMIT WORK;

Line 4269: IF FND_API.To_Boolean ( p_commit ) THEN

4265: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4266: raise FND_API.G_EXC_ERROR;
4267: end if;
4268:
4269: IF FND_API.To_Boolean ( p_commit ) THEN
4270: COMMIT WORK;
4271: END IF;
4272:
4273: -- Standard call to get message count and if count is 1, get message info.

Line 4274: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

4270: COMMIT WORK;
4271: END IF;
4272:
4273: -- Standard call to get message count and if count is 1, get message info.
4274: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4275: p_count => x_msg_count,
4276: p_data => x_msg_data);
4277: EXCEPTION
4278:

Line 4279: WHEN FND_API.G_EXC_ERROR THEN

4275: p_count => x_msg_count,
4276: p_data => x_msg_data);
4277: EXCEPTION
4278:
4279: WHEN FND_API.G_EXC_ERROR THEN
4280:
4281: x_return_status := FND_API.G_RET_STS_ERROR ;
4282: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4283: p_count => x_msg_count,

Line 4281: x_return_status := FND_API.G_RET_STS_ERROR ;

4277: EXCEPTION
4278:
4279: WHEN FND_API.G_EXC_ERROR THEN
4280:
4281: x_return_status := FND_API.G_RET_STS_ERROR ;
4282: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4283: p_count => x_msg_count,
4284: p_data => x_msg_data);
4285:

Line 4282: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

4278:
4279: WHEN FND_API.G_EXC_ERROR THEN
4280:
4281: x_return_status := FND_API.G_RET_STS_ERROR ;
4282: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4283: p_count => x_msg_count,
4284: p_data => x_msg_data);
4285:
4286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4282: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4283: p_count => x_msg_count,
4284: p_data => x_msg_data);
4285:
4286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4287:
4288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4289: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4290: p_count => x_msg_count,

Line 4288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4284: p_data => x_msg_data);
4285:
4286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4287:
4288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4289: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4290: p_count => x_msg_count,
4291: p_data => x_msg_data);
4292:

Line 4289: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

4285:
4286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4287:
4288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4289: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4290: p_count => x_msg_count,
4291: p_data => x_msg_data);
4292:
4293: WHEN OTHERS THEN

Line 4295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4291: p_data => x_msg_data);
4292:
4293: WHEN OTHERS THEN
4294:
4295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4296: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4297: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4298: p_count => x_msg_count,
4299: p_data => x_msg_data);

Line 4297: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

4293: WHEN OTHERS THEN
4294:
4295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4296: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4297: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
4298: p_count => x_msg_count,
4299: p_data => x_msg_data);
4300: end AbandonWorkflow;
4301: