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

Line 62: p_init_msg_list IN VARCHAR2 := FND_API.G_False,

58: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
59:
60: PROCEDURE Create_thldact
61: ( p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
63: p_commit IN VARCHAR2 := FND_API.G_False,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,

Line 63: p_commit IN VARCHAR2 := FND_API.G_False,

59:
60: PROCEDURE Create_thldact
61: ( p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
63: p_commit IN VARCHAR2 := FND_API.G_False,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,

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

60: PROCEDURE Create_thldact
61: ( p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
63: p_commit IN VARCHAR2 := FND_API.G_False,
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,
68: p_thldact_Rec IN thldact_rec_type,

Line 103: IF FND_API.to_Boolean( p_init_msg_list ) THEN

99:
100: --
101: -- Initialize message list IF p_init_msg_list is set to TRUE.
102: --
103: IF FND_API.to_Boolean( p_init_msg_list ) THEN
104: FND_MSG_PUB.initialize;
105: END IF;
106:
107: --

Line 110: IF NOT FND_API.Compatible_API_Call ( l_api_version,

106:
107: --
108: -- Standard call to check for call compatibility.
109: --
110: IF NOT FND_API.Compatible_API_Call ( l_api_version,
111: p_api_version,
112: l_api_name,
113: G_PKG_NAME)
114: THEN

Line 115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

111: p_api_version,
112: l_api_name,
113: G_PKG_NAME)
114: THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117:
118: --
119: -- Initialize API return status to success

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117:
118: --
119: -- Initialize API return status to success
120: --
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: --
124: -- API body
125: --

Line 152: ,p_init_msg_list => FND_API.G_FALSE

148: END LOOP;
149: END IF;
150:
151: Validate_Thldact ( p_api_version => 1.0
152: ,p_init_msg_list => FND_API.G_FALSE
153: ,p_validation_level => p_validation_level
154: ,x_return_status => l_return_status
155: ,x_msg_count => x_msg_count
156: ,x_msg_data => x_msg_data

Line 161: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

157: ,p_thldact_rec => l_thldact_rec
158: );
159:
160: -- If any errors happen abort API.
161: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: RAISE FND_API.G_EXC_ERROR;
163: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;

Line 162: RAISE FND_API.G_EXC_ERROR;

158: );
159:
160: -- If any errors happen abort API.
161: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: RAISE FND_API.G_EXC_ERROR;
163: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:

Line 163: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

159:
160: -- If any errors happen abort API.
161: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: RAISE FND_API.G_EXC_ERROR;
163: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167: --

Line 164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

160: -- If any errors happen abort API.
161: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: RAISE FND_API.G_EXC_ERROR;
163: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167: --
168: -- Insert the Record in Trigger Checks table

Line 186: IF (l_thldact_rec.process_id = FND_API.G_MISS_NUM) THEN

182: AMS_Utility_PVT.debug_message('CG: the value of activity_offer_id = ' || l_thldact_rec.activity_offer_id);
183: AMS_Utility_PVT.debug_message('CG: the value of cover_letter_id = ' || l_thldact_rec.cover_letter_id);
184: END IF;
185:
186: IF (l_thldact_rec.process_id = FND_API.G_MISS_NUM) THEN
187: l_thldact_rec.process_id := NULL;
188: END IF;
189: IF (l_thldact_rec.order_number = FND_API.G_MISS_NUM) THEN
190: l_thldact_rec.order_number := NULL;

Line 189: IF (l_thldact_rec.order_number = FND_API.G_MISS_NUM) THEN

185:
186: IF (l_thldact_rec.process_id = FND_API.G_MISS_NUM) THEN
187: l_thldact_rec.process_id := NULL;
188: END IF;
189: IF (l_thldact_rec.order_number = FND_API.G_MISS_NUM) THEN
190: l_thldact_rec.order_number := NULL;
191: END IF;
192: /*
193: IF (l_thldact_rec.action_notif_user_id = FND_API.G_MISS_NUM) THEN

Line 193: IF (l_thldact_rec.action_notif_user_id = FND_API.G_MISS_NUM) THEN

189: IF (l_thldact_rec.order_number = FND_API.G_MISS_NUM) THEN
190: l_thldact_rec.order_number := NULL;
191: END IF;
192: /*
193: IF (l_thldact_rec.action_notif_user_id = FND_API.G_MISS_NUM) THEN
194: l_thldact_rec.action_notif_user_id := NULL;
195: END IF;
196: */
197:

Line 198: IF (l_thldact_rec.action_approver_user_id = FND_API.G_MISS_NUM) THEN

194: l_thldact_rec.action_notif_user_id := NULL;
195: END IF;
196: */
197:
198: IF (l_thldact_rec.action_approver_user_id = FND_API.G_MISS_NUM) THEN
199: l_thldact_rec.action_approver_user_id := NULL;
200: END IF;
201: IF (l_thldact_rec.list_header_id = FND_API.G_MISS_NUM) THEN
202: l_thldact_rec.list_header_id := NULL;

Line 201: IF (l_thldact_rec.list_header_id = FND_API.G_MISS_NUM) THEN

197:
198: IF (l_thldact_rec.action_approver_user_id = FND_API.G_MISS_NUM) THEN
199: l_thldact_rec.action_approver_user_id := NULL;
200: END IF;
201: IF (l_thldact_rec.list_header_id = FND_API.G_MISS_NUM) THEN
202: l_thldact_rec.list_header_id := NULL;
203: END IF;
204: IF (l_thldact_rec.list_connected_to_id = FND_API.G_MISS_NUM) THEN
205: l_thldact_rec.list_connected_to_id := NULL;

Line 204: IF (l_thldact_rec.list_connected_to_id = FND_API.G_MISS_NUM) THEN

200: END IF;
201: IF (l_thldact_rec.list_header_id = FND_API.G_MISS_NUM) THEN
202: l_thldact_rec.list_header_id := NULL;
203: END IF;
204: IF (l_thldact_rec.list_connected_to_id = FND_API.G_MISS_NUM) THEN
205: l_thldact_rec.list_connected_to_id := NULL;
206: END IF;
207: IF (l_thldact_rec.deliverable_id = FND_API.G_MISS_NUM) THEN
208: l_thldact_rec.deliverable_id := NULL;

Line 207: IF (l_thldact_rec.deliverable_id = FND_API.G_MISS_NUM) THEN

203: END IF;
204: IF (l_thldact_rec.list_connected_to_id = FND_API.G_MISS_NUM) THEN
205: l_thldact_rec.list_connected_to_id := NULL;
206: END IF;
207: IF (l_thldact_rec.deliverable_id = FND_API.G_MISS_NUM) THEN
208: l_thldact_rec.deliverable_id := NULL;
209: END IF;
210: IF (l_thldact_rec.activity_offer_id = FND_API.G_MISS_NUM) THEN
211: l_thldact_rec.activity_offer_id := NULL;

Line 210: IF (l_thldact_rec.activity_offer_id = FND_API.G_MISS_NUM) THEN

206: END IF;
207: IF (l_thldact_rec.deliverable_id = FND_API.G_MISS_NUM) THEN
208: l_thldact_rec.deliverable_id := NULL;
209: END IF;
210: IF (l_thldact_rec.activity_offer_id = FND_API.G_MISS_NUM) THEN
211: l_thldact_rec.activity_offer_id := NULL;
212: END IF;
213: IF (l_thldact_rec.cover_letter_id = FND_API.G_MISS_NUM) THEN
214: l_thldact_rec.cover_letter_id := NULL;

Line 213: IF (l_thldact_rec.cover_letter_id = FND_API.G_MISS_NUM) THEN

209: END IF;
210: IF (l_thldact_rec.activity_offer_id = FND_API.G_MISS_NUM) THEN
211: l_thldact_rec.activity_offer_id := NULL;
212: END IF;
213: IF (l_thldact_rec.cover_letter_id = FND_API.G_MISS_NUM) THEN
214: l_thldact_rec.cover_letter_id := NULL;
215: END IF;
216: -- soagrawa 30-apr-2003
217: IF (l_thldact_rec.action_for_id = FND_API.G_MISS_NUM) THEN

Line 217: IF (l_thldact_rec.action_for_id = FND_API.G_MISS_NUM) THEN

213: IF (l_thldact_rec.cover_letter_id = FND_API.G_MISS_NUM) THEN
214: l_thldact_rec.cover_letter_id := NULL;
215: END IF;
216: -- soagrawa 30-apr-2003
217: IF (l_thldact_rec.action_for_id = FND_API.G_MISS_NUM) THEN
218: l_thldact_rec.action_for_id := NULL;
219: END IF;
220:
221: IF (l_thldact_rec.notify_flag = FND_API.G_MISS_CHAR) THEN

Line 221: IF (l_thldact_rec.notify_flag = FND_API.G_MISS_CHAR) THEN

217: IF (l_thldact_rec.action_for_id = FND_API.G_MISS_NUM) THEN
218: l_thldact_rec.action_for_id := NULL;
219: END IF;
220:
221: IF (l_thldact_rec.notify_flag = FND_API.G_MISS_CHAR) THEN
222: l_thldact_rec.notify_flag := NULL;
223: END IF;
224:
225: IF (l_thldact_rec.generate_list_flag = FND_API.G_MISS_CHAR) THEN

Line 225: IF (l_thldact_rec.generate_list_flag = FND_API.G_MISS_CHAR) THEN

221: IF (l_thldact_rec.notify_flag = FND_API.G_MISS_CHAR) THEN
222: l_thldact_rec.notify_flag := NULL;
223: END IF;
224:
225: IF (l_thldact_rec.generate_list_flag = FND_API.G_MISS_CHAR) THEN
226: l_thldact_rec.generate_list_flag := NULL;
227: END IF;
228:
229: IF (l_thldact_rec.action_need_approval_flag = FND_API.G_MISS_CHAR) THEN

Line 229: IF (l_thldact_rec.action_need_approval_flag = FND_API.G_MISS_CHAR) THEN

225: IF (l_thldact_rec.generate_list_flag = FND_API.G_MISS_CHAR) THEN
226: l_thldact_rec.generate_list_flag := NULL;
227: END IF;
228:
229: IF (l_thldact_rec.action_need_approval_flag = FND_API.G_MISS_CHAR) THEN
230: l_thldact_rec.action_need_approval_flag := NULL;
231: END IF;
232: --end soagrawa
233:

Line 306: IF FND_API.To_Boolean ( p_commit )

302: --
303: --
304: -- Standard check of p_commit.
305: --
306: IF FND_API.To_Boolean ( p_commit )
307: THEN
308: COMMIT WORK;
309: END IF;
310: --

Line 317: p_encoded => FND_API.G_FALSE

313: FND_MSG_PUB.Count_AND_Get
314: (
315: p_count => x_msg_count,
316: p_data => x_msg_data,
317: p_encoded => FND_API.G_FALSE
318: );
319:
320: IF (AMS_DEBUG_HIGH_ON) THEN
321: AMS_Utility_PVT.debug_message(l_full_name ||': end');

Line 325: WHEN FND_API.G_EXC_ERROR THEN

321: AMS_Utility_PVT.debug_message(l_full_name ||': end');
322: END IF;
323:
324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO Create_Thldact_PVT;
327: x_return_status := FND_API.G_RET_STS_ERROR ;
328:
329: FND_MSG_PUB.Count_AND_Get

Line 327: x_return_status := FND_API.G_RET_STS_ERROR ;

323:
324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO Create_Thldact_PVT;
327: x_return_status := FND_API.G_RET_STS_ERROR ;
328:
329: FND_MSG_PUB.Count_AND_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data,

Line 332: p_encoded => FND_API.G_FALSE

328:
329: FND_MSG_PUB.Count_AND_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => FND_API.G_FALSE
333: );
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: ROLLBACK TO Create_Thldact_PVT;
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

330: ( p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => FND_API.G_FALSE
333: );
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: ROLLBACK TO Create_Thldact_PVT;
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
337:
338: FND_MSG_PUB.Count_AND_Get

Line 336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

332: p_encoded => FND_API.G_FALSE
333: );
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: ROLLBACK TO Create_Thldact_PVT;
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
337:
338: FND_MSG_PUB.Count_AND_Get
339: ( p_count => x_msg_count,
340: p_data => x_msg_data,

Line 341: p_encoded => FND_API.G_FALSE

337:
338: FND_MSG_PUB.Count_AND_Get
339: ( p_count => x_msg_count,
340: p_data => x_msg_data,
341: p_encoded => FND_API.G_FALSE
342: );
343: WHEN OTHERS THEN
344: ROLLBACK TO Create_Thldact_PVT;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

341: p_encoded => FND_API.G_FALSE
342: );
343: WHEN OTHERS THEN
344: ROLLBACK TO Create_Thldact_PVT;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346:
347: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
348: THEN
349: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 355: p_encoded => FND_API.G_FALSE

351:
352: FND_MSG_PUB.Count_AND_Get
353: ( p_count => x_msg_count,
354: p_data => x_msg_data,
355: p_encoded => FND_API.G_FALSE
356: );
357: END Create_Thldact;
358:
359: -- Start of Comments

Line 377: p_init_msg_list IN VARCHAR2 := FND_API.G_False,

373: -- End of Comments
374:
375: PROCEDURE Delete_Thldact
376: ( p_api_version IN NUMBER,
377: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
378: p_commit IN VARCHAR2 := FND_API.G_False,
379:
380: x_return_status OUT NOCOPY VARCHAR2,
381: x_msg_count OUT NOCOPY NUMBER,

Line 378: p_commit IN VARCHAR2 := FND_API.G_False,

374:
375: PROCEDURE Delete_Thldact
376: ( p_api_version IN NUMBER,
377: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
378: p_commit IN VARCHAR2 := FND_API.G_False,
379:
380: x_return_status OUT NOCOPY VARCHAR2,
381: x_msg_count OUT NOCOPY NUMBER,
382: x_msg_data OUT NOCOPY VARCHAR2,

Line 409: IF FND_API.to_Boolean( p_init_msg_list ) THEN

405:
406: --
407: -- Initialize message list IF p_init_msg_list is set to TRUE.
408: --
409: IF FND_API.to_Boolean( p_init_msg_list ) THEN
410: FND_MSG_PUB.initialize;
411: END IF;
412:
413: --

Line 416: IF NOT FND_API.Compatible_API_Call ( l_api_version,

412:
413: --
414: -- Standard call to check for call compatibility.
415: --
416: IF NOT FND_API.Compatible_API_Call ( l_api_version,
417: p_api_version,
418: l_api_name,
419: G_PKG_NAME)
420: THEN

Line 421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

417: p_api_version,
418: l_api_name,
419: G_PKG_NAME)
420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
424: -- Initialize API return status to success
425: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 425: x_return_status := FND_API.G_RET_STS_SUCCESS;

421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
424: -- Initialize API return status to success
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426:
427: --
428: -- API body
429: --

Line 458: RAISE FND_API.G_EXC_ERROR;

454: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
455: FND_MSG_PUB.Add;
456: END IF;
457:
458: RAISE FND_API.G_EXC_ERROR;
459: END IF;
460:
461: --
462: -- END of API body.

Line 467: IF FND_API.To_Boolean ( p_commit )

463: --
464: --
465: -- Standard check of p_commit.
466: --
467: IF FND_API.To_Boolean ( p_commit )
468: THEN
469: COMMIT WORK;
470: END IF;
471:

Line 478: p_encoded => FND_API.G_FALSE

474: --
475: FND_MSG_PUB.Count_AND_Get
476: ( p_count => x_msg_count,
477: p_data => x_msg_data,
478: p_encoded => FND_API.G_FALSE
479: );
480:
481: EXCEPTION
482: WHEN FND_API.G_EXC_ERROR THEN

Line 482: WHEN FND_API.G_EXC_ERROR THEN

478: p_encoded => FND_API.G_FALSE
479: );
480:
481: EXCEPTION
482: WHEN FND_API.G_EXC_ERROR THEN
483:
484: ROLLBACK TO Delete_Thldact_PVT;
485: x_return_status := FND_API.G_RET_STS_ERROR ;
486:

Line 485: x_return_status := FND_API.G_RET_STS_ERROR ;

481: EXCEPTION
482: WHEN FND_API.G_EXC_ERROR THEN
483:
484: ROLLBACK TO Delete_Thldact_PVT;
485: x_return_status := FND_API.G_RET_STS_ERROR ;
486:
487: FND_MSG_PUB.Count_AND_Get
488: ( p_count => x_msg_count,
489: p_data => x_msg_data,

Line 490: p_encoded => FND_API.G_FALSE

486:
487: FND_MSG_PUB.Count_AND_Get
488: ( p_count => x_msg_count,
489: p_data => x_msg_data,
490: p_encoded => FND_API.G_FALSE
491: );
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493:
494: ROLLBACK TO Delete_Thldact_PVT;

Line 492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

488: ( p_count => x_msg_count,
489: p_data => x_msg_data,
490: p_encoded => FND_API.G_FALSE
491: );
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493:
494: ROLLBACK TO Delete_Thldact_PVT;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
496:

Line 495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

491: );
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493:
494: ROLLBACK TO Delete_Thldact_PVT;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
496:
497: FND_MSG_PUB.Count_AND_Get
498: ( p_count => x_msg_count,
499: p_data => x_msg_data,

Line 500: p_encoded => FND_API.G_FALSE

496:
497: FND_MSG_PUB.Count_AND_Get
498: ( p_count => x_msg_count,
499: p_data => x_msg_data,
500: p_encoded => FND_API.G_FALSE
501: );
502: WHEN OTHERS THEN
503:
504: ROLLBACK TO Delete_Thldact_PVT;

Line 505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

501: );
502: WHEN OTHERS THEN
503:
504: ROLLBACK TO Delete_Thldact_PVT;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
506:
507: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
508: THEN
509: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 515: p_encoded => FND_API.G_FALSE

511:
512: FND_MSG_PUB.Count_AND_Get
513: ( p_count => x_msg_count,
514: p_data => x_msg_data,
515: p_encoded => FND_API.G_FALSE
516: );
517: END Delete_Thldact;
518:
519: -- Start of Comments

Line 537: p_init_msg_list IN VARCHAR2 := FND_API.G_False,

533: -- End of Comments
534:
535: PROCEDURE Lock_Thldact
536: ( p_api_version IN NUMBER,
537: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
538:
539: x_return_status OUT NOCOPY VARCHAR2,
540: x_msg_count OUT NOCOPY NUMBER,
541: x_msg_data OUT NOCOPY VARCHAR2,

Line 574: IF FND_API.to_boolean(p_init_msg_list) THEN

570:
571: --
572: -- Initialize message list if p_init_msg_list is set to TRUE.
573: --
574: IF FND_API.to_boolean(p_init_msg_list) THEN
575: FND_MSG_PUB.initialize;
576: END IF;
577:
578: --

Line 581: IF NOT FND_API.Compatible_API_Call ( l_api_version,

577:
578: --
579: -- Standard call to check for call compatibility.
580: --
581: IF NOT FND_API.Compatible_API_Call ( l_api_version,
582: p_api_version,
583: l_api_name,
584: G_PKG_NAME)
585: THEN

Line 586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

582: p_api_version,
583: l_api_name,
584: G_PKG_NAME)
585: THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588:
589: -- Initialize API return status to success
590: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 590: x_return_status := FND_API.G_RET_STS_SUCCESS;

586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588:
589: -- Initialize API return status to success
590: x_return_status := FND_API.G_RET_STS_SUCCESS;
591:
592: --
593: -- API body
594: --

Line 617: RAISE FND_API.G_EXC_ERROR;

613: FND_MESSAGE.Set_Name('FND', 'AMS_API_RECORD_NOT_FOUND');
614: FND_MSG_PUB.Add;
615: END IF;
616:
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:
620: CLOSE C_ams_trigger_actions;
621:

Line 632: p_encoded => FND_API.G_FALSE

628: --
629: FND_MSG_PUB.Count_AND_Get
630: ( p_count => x_msg_count,
631: p_data => x_msg_data,
632: p_encoded => FND_API.G_FALSE
633: );
634: --
635: -- Debug Message
636: --

Line 643: WHEN FND_API.G_EXC_ERROR THEN

639: AMS_Utility_PVT.debug_message(l_full_name ||': end');
640: END IF;
641:
642: EXCEPTION
643: WHEN FND_API.G_EXC_ERROR THEN
644: x_return_status := FND_API.G_RET_STS_ERROR ;
645:
646: FND_MSG_PUB.Count_AND_Get
647: ( p_count => x_msg_count,

Line 644: x_return_status := FND_API.G_RET_STS_ERROR ;

640: END IF;
641:
642: EXCEPTION
643: WHEN FND_API.G_EXC_ERROR THEN
644: x_return_status := FND_API.G_RET_STS_ERROR ;
645:
646: FND_MSG_PUB.Count_AND_Get
647: ( p_count => x_msg_count,
648: p_data => x_msg_data,

Line 649: p_encoded => FND_API.G_FALSE

645:
646: FND_MSG_PUB.Count_AND_Get
647: ( p_count => x_msg_count,
648: p_data => x_msg_data,
649: p_encoded => FND_API.G_FALSE
650: );
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
653:

Line 651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

647: ( p_count => x_msg_count,
648: p_data => x_msg_data,
649: p_encoded => FND_API.G_FALSE
650: );
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
653:
654: FND_MSG_PUB.Count_AND_Get
655: ( p_count => x_msg_count,

Line 652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

648: p_data => x_msg_data,
649: p_encoded => FND_API.G_FALSE
650: );
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
653:
654: FND_MSG_PUB.Count_AND_Get
655: ( p_count => x_msg_count,
656: p_data => x_msg_data,

Line 657: p_encoded => FND_API.G_FALSE

653:
654: FND_MSG_PUB.Count_AND_Get
655: ( p_count => x_msg_count,
656: p_data => x_msg_data,
657: p_encoded => FND_API.G_FALSE
658: );
659: WHEN AMS_UTILITY_PVT.RESOURCE_LOCKED THEN
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:

Line 660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

656: p_data => x_msg_data,
657: p_encoded => FND_API.G_FALSE
658: );
659: WHEN AMS_UTILITY_PVT.RESOURCE_LOCKED THEN
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:
662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
663: THEN -- MMSG
664: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');

Line 671: p_encoded => FND_API.G_FALSE

667:
668: FND_MSG_PUB.Count_AND_Get
669: ( p_count => x_msg_count,
670: p_data => x_msg_data,
671: p_encoded => FND_API.G_FALSE
672: );
673:
674: WHEN OTHERS THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

671: p_encoded => FND_API.G_FALSE
672: );
673:
674: WHEN OTHERS THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
676:
677: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
678: THEN
679: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 685: p_encoded => FND_API.G_FALSE

681:
682: FND_MSG_PUB.Count_AND_Get
683: ( p_count => x_msg_count,
684: p_data => x_msg_data,
685: p_encoded => FND_API.G_FALSE
686: );
687:
688: END Lock_Thldact;
689:

Line 708: p_init_msg_list IN VARCHAR2 := FND_API.G_False,

704: -- End of Comments
705:
706: PROCEDURE Update_Thldact
707: ( p_api_version IN NUMBER,
708: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
709: p_commit IN VARCHAR2 := FND_API.G_False,
710: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711:
712: x_return_status OUT NOCOPY VARCHAR2,

Line 709: p_commit IN VARCHAR2 := FND_API.G_False,

705:
706: PROCEDURE Update_Thldact
707: ( p_api_version IN NUMBER,
708: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
709: p_commit IN VARCHAR2 := FND_API.G_False,
710: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711:
712: x_return_status OUT NOCOPY VARCHAR2,
713: x_msg_count OUT NOCOPY NUMBER,

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

706: PROCEDURE Update_Thldact
707: ( p_api_version IN NUMBER,
708: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
709: p_commit IN VARCHAR2 := FND_API.G_False,
710: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711:
712: x_return_status OUT NOCOPY VARCHAR2,
713: x_msg_count OUT NOCOPY NUMBER,
714: x_msg_data OUT NOCOPY VARCHAR2,

Line 745: IF FND_API.to_Boolean( p_init_msg_list ) THEN

741:
742: --
743: -- Initialize message list IF p_init_msg_list is set to TRUE.
744: --
745: IF FND_API.to_Boolean( p_init_msg_list ) THEN
746: FND_MSG_PUB.initialize;
747: END IF;
748:
749: --

Line 752: IF NOT FND_API.Compatible_API_Call ( l_api_version,

748:
749: --
750: -- Standard call to check for call compatibility.
751: --
752: IF NOT FND_API.Compatible_API_Call ( l_api_version,
753: p_api_version,
754: l_api_name,
755: G_PKG_NAME)
756: THEN

Line 757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

753: p_api_version,
754: l_api_name,
755: G_PKG_NAME)
756: THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759:
760: --
761: -- Initialize API return status to success

Line 763: x_return_status := FND_API.G_RET_STS_SUCCESS;

759:
760: --
761: -- Initialize API return status to success
762: --
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:
765: --
766: -- API body
767: --

Line 784: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

780: p_validation_mode => JTF_PLSQL_API.g_update,
781: x_return_status => l_return_status
782: );
783:
784: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
785: RAISE FND_API.g_exc_unexpected_error;
786: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
787: RAISE FND_API.g_exc_error;
788: END IF;

Line 785: RAISE FND_API.g_exc_unexpected_error;

781: x_return_status => l_return_status
782: );
783:
784: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
785: RAISE FND_API.g_exc_unexpected_error;
786: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
787: RAISE FND_API.g_exc_error;
788: END IF;
789: END IF;

Line 786: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

782: );
783:
784: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
785: RAISE FND_API.g_exc_unexpected_error;
786: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
787: RAISE FND_API.g_exc_error;
788: END IF;
789: END IF;
790:

Line 787: RAISE FND_API.g_exc_error;

783:
784: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
785: RAISE FND_API.g_exc_unexpected_error;
786: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
787: RAISE FND_API.g_exc_error;
788: END IF;
789: END IF;
790:
791: -- replace g_miss_char/num/date with current column values

Line 801: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

797: p_complete_rec => l_thldact_rec,
798: x_return_status => l_return_status
799: );
800:
801: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
802: RAISE FND_API.g_exc_unexpected_error;
803: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
804: RAISE FND_API.g_exc_error;
805: END IF;

Line 802: RAISE FND_API.g_exc_unexpected_error;

798: x_return_status => l_return_status
799: );
800:
801: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
802: RAISE FND_API.g_exc_unexpected_error;
803: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
804: RAISE FND_API.g_exc_error;
805: END IF;
806: END IF;

Line 803: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

799: );
800:
801: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
802: RAISE FND_API.g_exc_unexpected_error;
803: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
804: RAISE FND_API.g_exc_error;
805: END IF;
806: END IF;
807:

Line 804: RAISE FND_API.g_exc_error;

800:
801: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
802: RAISE FND_API.g_exc_unexpected_error;
803: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
804: RAISE FND_API.g_exc_error;
805: END IF;
806: END IF;
807:
808:

Line 848: RAISE FND_API.G_EXC_ERROR;

844: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
845: FND_MSG_PUB.Add;
846: END IF;
847:
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850:
851: --
852: -- END of API body.

Line 856: IF FND_API.To_Boolean ( p_commit )

852: -- END of API body.
853: --
854:
855: -- Standard check of p_commit.
856: IF FND_API.To_Boolean ( p_commit )
857: THEN
858: COMMIT WORK;
859: END IF;
860:

Line 867: p_encoded => FND_API.G_FALSE

863: --
864: FND_MSG_PUB.Count_AND_Get
865: ( p_count => x_msg_count,
866: p_data => x_msg_data,
867: p_encoded => FND_API.G_FALSE
868: );
869:
870: --
871: -- Debug Message

Line 879: WHEN FND_API.G_EXC_ERROR THEN

875: AMS_Utility_PVT.debug_message(l_full_name ||': end');
876: END IF;
877:
878: EXCEPTION
879: WHEN FND_API.G_EXC_ERROR THEN
880:
881: ROLLBACK TO Update_Thldact_PVT;
882: x_return_status := FND_API.G_RET_STS_ERROR ;
883:

Line 882: x_return_status := FND_API.G_RET_STS_ERROR ;

878: EXCEPTION
879: WHEN FND_API.G_EXC_ERROR THEN
880:
881: ROLLBACK TO Update_Thldact_PVT;
882: x_return_status := FND_API.G_RET_STS_ERROR ;
883:
884: FND_MSG_PUB.Count_AND_Get
885: ( p_count => x_msg_count,
886: p_data => x_msg_data,

Line 887: p_encoded => FND_API.G_FALSE

883:
884: FND_MSG_PUB.Count_AND_Get
885: ( p_count => x_msg_count,
886: p_data => x_msg_data,
887: p_encoded => FND_API.G_FALSE
888: );
889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
890:
891: ROLLBACK TO Update_Thldact_PVT;

Line 889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

885: ( p_count => x_msg_count,
886: p_data => x_msg_data,
887: p_encoded => FND_API.G_FALSE
888: );
889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
890:
891: ROLLBACK TO Update_Thldact_PVT;
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893:

Line 892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

888: );
889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
890:
891: ROLLBACK TO Update_Thldact_PVT;
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893:
894: FND_MSG_PUB.Count_AND_Get
895: ( p_count => x_msg_count,
896: p_data => x_msg_data,

Line 897: p_encoded => FND_API.G_FALSE

893:
894: FND_MSG_PUB.Count_AND_Get
895: ( p_count => x_msg_count,
896: p_data => x_msg_data,
897: p_encoded => FND_API.G_FALSE
898: );
899: WHEN OTHERS THEN
900:
901: ROLLBACK TO Update_Thldact_PVT;

Line 902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

898: );
899: WHEN OTHERS THEN
900:
901: ROLLBACK TO Update_Thldact_PVT;
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903:
904: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
905: THEN
906: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 912: p_encoded => FND_API.G_FALSE

908:
909: FND_MSG_PUB.Count_AND_Get
910: ( p_count => x_msg_count,
911: p_data => x_msg_data,
912: p_encoded => FND_API.G_FALSE
913: );
914: END Update_Thldact;
915:
916: -- Start of Comments

Line 934: p_init_msg_list IN VARCHAR2 := FND_API.G_False,

930: -- End of Comments
931:
932: PROCEDURE Validate_Thldact
933: ( p_api_version IN NUMBER,
934: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
935: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
936: x_return_status OUT NOCOPY VARCHAR2,
937: x_msg_count OUT NOCOPY NUMBER,
938: x_msg_data OUT NOCOPY VARCHAR2,

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

931:
932: PROCEDURE Validate_Thldact
933: ( p_api_version IN NUMBER,
934: p_init_msg_list IN VARCHAR2 := FND_API.G_False,
935: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
936: x_return_status OUT NOCOPY VARCHAR2,
937: x_msg_count OUT NOCOPY NUMBER,
938: x_msg_data OUT NOCOPY VARCHAR2,
939:

Line 963: IF FND_API.to_Boolean( p_init_msg_list ) THEN

959: AMS_Utility_PVT.debug_message(l_full_name||': start');
960: END IF;
961:
962: -- Initialize message list if p_init_msg_list is set to TRUE.
963: IF FND_API.to_Boolean( p_init_msg_list ) THEN
964: FND_MSG_PUB.initialize;
965: END IF;
966:
967: -- Standard call to check for call compatibility.

Line 968: IF NOT FND_API.Compatible_API_Call ( l_api_version,

964: FND_MSG_PUB.initialize;
965: END IF;
966:
967: -- Standard call to check for call compatibility.
968: IF NOT FND_API.Compatible_API_Call ( l_api_version,
969: p_api_version,
970: l_api_name,
971: G_PKG_NAME)
972: THEN

Line 973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

969: p_api_version,
970: l_api_name,
971: G_PKG_NAME)
972: THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975:
976: --
977: -- Initialize API return status to success

Line 979: x_return_status := FND_API.G_RET_STS_SUCCESS;

975:
976: --
977: -- Initialize API return status to success
978: --
979: x_return_status := FND_API.G_RET_STS_SUCCESS;
980:
981: --
982: -- API body
983: --

Line 991: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

987: p_validation_mode => JTF_PLSQL_API.g_create,
988: x_return_status => l_return_status
989: );
990:
991: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
992: RAISE FND_API.g_exc_unexpected_error;
993: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
994: RAISE FND_API.g_exc_error;
995: END IF;

Line 992: RAISE FND_API.g_exc_unexpected_error;

988: x_return_status => l_return_status
989: );
990:
991: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
992: RAISE FND_API.g_exc_unexpected_error;
993: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
994: RAISE FND_API.g_exc_error;
995: END IF;
996: END IF;

Line 993: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

989: );
990:
991: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
992: RAISE FND_API.g_exc_unexpected_error;
993: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
994: RAISE FND_API.g_exc_error;
995: END IF;
996: END IF;
997:

Line 994: RAISE FND_API.g_exc_error;

990:
991: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
992: RAISE FND_API.g_exc_unexpected_error;
993: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
994: RAISE FND_API.g_exc_error;
995: END IF;
996: END IF;
997:
998: --

Line 1014: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1010: x_return_status => l_return_status
1011: );
1012:
1013:
1014: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1015: RAISE FND_API.g_exc_unexpected_error;
1016: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1017: RAISE FND_API.g_exc_error;
1018: END IF;

Line 1015: RAISE FND_API.g_exc_unexpected_error;

1011: );
1012:
1013:
1014: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1015: RAISE FND_API.g_exc_unexpected_error;
1016: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1017: RAISE FND_API.g_exc_error;
1018: END IF;
1019: END IF;

Line 1016: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1012:
1013:
1014: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1015: RAISE FND_API.g_exc_unexpected_error;
1016: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1017: RAISE FND_API.g_exc_error;
1018: END IF;
1019: END IF;
1020:

Line 1017: RAISE FND_API.g_exc_error;

1013:
1014: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1015: RAISE FND_API.g_exc_unexpected_error;
1016: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1017: RAISE FND_API.g_exc_error;
1018: END IF;
1019: END IF;
1020:
1021: --

Line 1027: p_encoded => FND_API.G_FALSE

1023: --
1024: FND_MSG_PUB.Count_AND_Get
1025: ( p_count => x_msg_count,
1026: p_data => x_msg_data,
1027: p_encoded => FND_API.G_FALSE
1028: );
1029:
1030: --
1031: -- Debug Message

Line 1042: WHEN FND_API.G_EXC_ERROR THEN

1038:
1039:
1040: EXCEPTION
1041:
1042: WHEN FND_API.G_EXC_ERROR THEN
1043:
1044: x_return_status := FND_API.G_RET_STS_ERROR ;
1045:
1046: FND_MSG_PUB.Count_AND_Get

Line 1044: x_return_status := FND_API.G_RET_STS_ERROR ;

1040: EXCEPTION
1041:
1042: WHEN FND_API.G_EXC_ERROR THEN
1043:
1044: x_return_status := FND_API.G_RET_STS_ERROR ;
1045:
1046: FND_MSG_PUB.Count_AND_Get
1047: ( p_count => x_msg_count,
1048: p_data => x_msg_data,

Line 1049: p_encoded => FND_API.G_FALSE

1045:
1046: FND_MSG_PUB.Count_AND_Get
1047: ( p_count => x_msg_count,
1048: p_data => x_msg_data,
1049: p_encoded => FND_API.G_FALSE
1050: );
1051:
1052:
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1049: p_encoded => FND_API.G_FALSE
1050: );
1051:
1052:
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054:
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056:
1057: FND_MSG_PUB.Count_AND_Get

Line 1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1051:
1052:
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054:
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056:
1057: FND_MSG_PUB.Count_AND_Get
1058: ( p_count => x_msg_count,
1059: p_data => x_msg_data,

Line 1060: p_encoded => FND_API.G_FALSE

1056:
1057: FND_MSG_PUB.Count_AND_Get
1058: ( p_count => x_msg_count,
1059: p_data => x_msg_data,
1060: p_encoded => FND_API.G_FALSE
1061: );
1062:
1063:
1064: WHEN OTHERS THEN

Line 1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1062:
1063:
1064: WHEN OTHERS THEN
1065:
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1067:
1068: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1069: THEN
1070: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1076: p_encoded => FND_API.G_FALSE

1072:
1073: FND_MSG_PUB.Count_AND_Get
1074: ( p_count => x_msg_count,
1075: p_data => x_msg_data,
1076: p_encoded => FND_API.G_FALSE
1077: );
1078:
1079: END Validate_thldAct;
1080:

Line 1107: x_return_status := FND_API.G_Ret_Sts_Success;

1103: BEGIN
1104: --
1105: -- Initialize API/Procedure return status to success
1106: --
1107: x_return_status := FND_API.G_Ret_Sts_Success;
1108:
1109: --
1110: -- Check required parameters
1111: --

Line 1125: x_return_status := FND_API.G_RET_STS_ERROR;

1121: --dbms_output.put_line('trigger_id is missing');
1122: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_TRIG_ID');
1123: FND_MSG_PUB.Add;
1124: END IF;
1125: x_return_status := FND_API.G_RET_STS_ERROR;
1126: -- If any errors happen abort API/Procedure.
1127: return;
1128: END IF;
1129:

Line 1163: x_return_status := FND_API.g_ret_sts_success;

1159: l_valid_flag VARCHAR2(1);
1160: l_where_clause VARCHAR2(500);
1161: BEGIN
1162:
1163: x_return_status := FND_API.g_ret_sts_success;
1164:
1165: -- For create_thldact, when trigger_action_id is passed in, we need to
1166: -- check if this trigger_action_id is unique.
1167: IF p_validation_mode = JTF_PLSQL_API.g_create

Line 1173: ) = FND_API.g_false

1169: THEN
1170: IF AMS_Utility_PVT.check_uniqueness(
1171: 'ams_trigger_actions',
1172: 'trigger_action_id = ' || p_thldact_rec.trigger_action_id
1173: ) = FND_API.g_false
1174: THEN
1175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1176: THEN
1177: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_DUPLICATE_ACTION');

Line 1180: x_return_status := FND_API.g_ret_sts_error;

1176: THEN
1177: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_DUPLICATE_ACTION');
1178: FND_MSG_PUB.add;
1179: END IF;
1180: x_return_status := FND_API.g_ret_sts_error;
1181: RETURN;
1182: END IF;
1183: END IF;
1184:

Line 1203: ) = FND_API.g_false

1199:
1200: IF AMS_Utility_PVT.Check_Uniqueness(
1201: p_table_name => 'ams_trigger_actions',
1202: p_where_clause => l_where_clause
1203: ) = FND_API.g_false
1204: THEN
1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1206: THEN
1207: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_DUP_TRIG_ID');

Line 1210: x_return_status := FND_API.g_ret_sts_error;

1206: THEN
1207: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_DUP_TRIG_ID');
1208: FND_MSG_PUB.add;
1209: END IF;
1210: x_return_status := FND_API.g_ret_sts_error;
1211: RETURN;
1212: END IF;
1213: */
1214: -- check other unique items

Line 1250: x_return_status := FND_API.g_ret_sts_success;

1246: BEGIN
1247: --
1248: -- Initialize API/Procedure return status to success
1249: --
1250: x_return_status := FND_API.g_ret_sts_success;
1251:
1252: --
1253: -- Trigger ID
1254: --

Line 1255: IF p_thldact_rec.trigger_id <> FND_API.G_MISS_NUM

1251:
1252: --
1253: -- Trigger ID
1254: --
1255: IF p_thldact_rec.trigger_id <> FND_API.G_MISS_NUM
1256: THEN
1257: l_table_name := 'AMS_TRIGGERS' ;
1258: l_pk_name := 'trigger_id' ;
1259: l_pk_value := p_thldact_rec.trigger_id;

Line 1269: ) = FND_API.G_FALSE THEN

1265: ,p_PK_name => l_pk_name
1266: ,p_PK_value => l_pk_value
1267: ,p_pk_data_type => l_pk_data_type
1268: ,p_additional_where_clause => l_additional_where_clause
1269: ) = FND_API.G_FALSE THEN
1270: -- invalid item
1271: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1272: THEN -- MMSG
1273: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');

Line 1277: x_return_status := FND_API.G_RET_STS_ERROR;

1273: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1274: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_TRIGGER_ID');
1275: FND_MSG_PUB.Add;
1276: END IF;
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: -- If any errors happen abort API/Procedure.
1279: RETURN;
1280: END IF;
1281: END IF;

Line 1289: IF p_thldact_rec.list_header_id <> FND_API.G_MISS_NUM AND

1285: --
1286:
1287:
1288: /*
1289: IF p_thldact_rec.list_header_id <> FND_API.G_MISS_NUM AND
1290: p_thldact_rec.list_header_id IS NOT NULL THEN
1291: l_table_name := 'AMS_LIST_HEADERS_ALL' ;
1292: l_pk_name := 'LIST_HEADER_ID' ;
1293: l_pk_value := p_thldact_rec.list_header_id;

Line 1310: ) = FND_API.G_FALSE THEN

1306: ,p_PK_name => l_pk_name
1307: ,p_PK_value => l_pk_value
1308: ,p_pk_data_type => l_pk_data_type
1309: ,p_additional_where_clause => l_additional_where_clause
1310: ) = FND_API.G_FALSE THEN
1311: -- invalid item
1312: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1313: THEN -- MMSG
1314: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');

Line 1318: x_return_status := FND_API.G_RET_STS_ERROR;

1314: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1315: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_LIST');
1316: FND_MSG_PUB.Add;
1317: END IF;
1318: x_return_status := FND_API.G_RET_STS_ERROR;
1319: -- If any errors happen abort API/Procedure.
1320: RETURN;
1321: END IF;
1322: END IF;

Line 1334: IF p_thldact_rec.action_approver_user_id <> FND_API.G_MISS_NUM

1330: --
1331: -- Check action_approver_user_id
1332: --
1333: /*
1334: IF p_thldact_rec.action_approver_user_id <> FND_API.G_MISS_NUM
1335: AND p_thldact_rec.action_approver_user_id IS NOT NULL THEN
1336: l_table_name := 'jtf_rs_resource_extns' ;
1337: l_pk_name := 'resource_id' ;
1338: l_pk_value := p_thldact_rec.action_approver_user_id;

Line 1348: ) = FND_API.G_FALSE THEN

1344: ,p_PK_name => l_pk_name
1345: ,p_PK_value => l_pk_value
1346: ,p_pk_data_type => l_pk_data_type
1347: ,p_additional_where_clause => l_additional_where_clause
1348: ) = FND_API.G_FALSE THEN
1349:
1350: -- invalid item
1351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1352: THEN -- MMSG

Line 1357: x_return_status := FND_API.G_RET_STS_ERROR;

1353: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1354: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_APPROVER');
1355: FND_MSG_PUB.Add;
1356: END IF;
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: -- If any errors happen abort API/Procedure.
1359: RETURN;
1360: END IF;
1361: END IF;

Line 1367: IF p_thldact_rec.dscript_name <> FND_API.G_MISS_CHAR

1363: --
1364: -- Check dscript_name
1365: --
1366: /*
1367: IF p_thldact_rec.dscript_name <> FND_API.G_MISS_CHAR
1368: AND p_thldact_rec.dscript_name IS NOT NULL THEN
1369: l_table_name := 'ies_deployed_scripts' ;
1370: l_pk_name := 'dscript_name' ;
1371: l_pk_value := p_thldact_rec.dscript_name;

Line 1381: ) = FND_API.G_FALSE THEN

1377: ,p_PK_name => l_pk_name
1378: ,p_PK_value => l_pk_value
1379: ,p_pk_data_type => l_pk_data_type
1380: ,p_additional_where_clause => l_additional_where_clause
1381: ) = FND_API.G_FALSE THEN
1382:
1383: -- invalid item
1384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1385: THEN -- MMSG

Line 1390: x_return_status := FND_API.G_RET_STS_ERROR;

1386: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1387: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DSCRIPT');
1388: FND_MSG_PUB.Add;
1389: END IF;
1390: x_return_status := FND_API.G_RET_STS_ERROR;
1391: -- If any errors happen abort API/Procedure.
1392: RETURN;
1393: END IF;
1394: END IF;

Line 1400: IF p_thldact_rec.activity_offer_id <> FND_API.G_MISS_NUM

1396: --
1397: -- Check Offers
1398: --
1399: /*
1400: IF p_thldact_rec.activity_offer_id <> FND_API.G_MISS_NUM
1401: AND p_thldact_rec.activity_offer_id IS NOT NULL THEN
1402: l_table_name := 'ams_act_offers' ;
1403: l_pk_name := 'activity_offer_id' ;
1404: l_pk_value := p_thldact_rec.activity_offer_id;

Line 1414: ) = FND_API.G_FALSE THEN

1410: ,p_PK_name => l_pk_name
1411: ,p_PK_value => l_pk_value
1412: ,p_pk_data_type => l_pk_data_type
1413: ,p_additional_where_clause => l_additional_where_clause
1414: ) = FND_API.G_FALSE THEN
1415:
1416: -- invalid item
1417: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1418: THEN -- MMSG

Line 1423: x_return_status := FND_API.G_RET_STS_ERROR;

1419: -- DBMS_OUTPUT.Put_Line('Foreign Key Does not Exist');
1420: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_OFFER');
1421: FND_MSG_PUB.Add;
1422: END IF;
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: -- If any errors happen abort API/Procedure.
1425: RETURN;
1426: END IF;
1427: END IF;

Line 1437: p_thldact_rec.cover_letter_id <> FND_API.G_MISS_NUM

1433: --
1434: --============================================================================
1435: /*
1436: IF p_thldact_rec.cover_letter_id IS NOT NULL AND
1437: p_thldact_rec.cover_letter_id <> FND_API.G_MISS_NUM
1438: THEN
1439: l_table_name := 'jtf_amv_items_vl';
1440: l_pk_name := 'item_id' ;
1441: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;

Line 1453: ) = FND_API.G_FALSE

1449: ,p_pk_name => l_pk_name
1450: ,p_pk_value => l_pk_value
1451: ,p_pk_data_type => l_pk_data_type
1452: ,p_additional_where_clause => l_additional_where_clause
1453: ) = FND_API.G_FALSE
1454: THEN
1455: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1456: FND_MESSAGE.Set_Name ('AMS', 'AMS_TRIG_INVALID_COVER_LETTER');
1457: FND_MSG_PUB.Add;

Line 1459: x_return_status := FND_API.G_RET_STS_ERROR;

1455: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1456: FND_MESSAGE.Set_Name ('AMS', 'AMS_TRIG_INVALID_COVER_LETTER');
1457: FND_MSG_PUB.Add;
1458: END IF;
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460: RETURN;
1461: END IF;
1462: END IF ;
1463: */

Line 1495: x_return_status := FND_API.g_ret_sts_success;

1491: BEGIN
1492: --
1493: -- Initialize API/Procedure return status to success
1494: --
1495: x_return_status := FND_API.g_ret_sts_success;
1496:
1497: --
1498: -- Execute_action_type
1499: --

Line 1500: IF p_thldact_rec.execute_action_type <> FND_API.G_MISS_CHAR

1496:
1497: --
1498: -- Execute_action_type
1499: --
1500: IF p_thldact_rec.execute_action_type <> FND_API.G_MISS_CHAR
1501: AND p_thldact_rec.execute_action_type IS NOT NULL
1502: THEN
1503: IF AMS_Utility_PVT.Check_Lookup_Exists
1504: ( p_lookup_table_name => 'AMS_LOOKUPS'

Line 1507: ) = FND_API.G_FALSE then

1503: IF AMS_Utility_PVT.Check_Lookup_Exists
1504: ( p_lookup_table_name => 'AMS_LOOKUPS'
1505: ,p_lookup_type => 'AMS_TRIG_ACTION_TYPE'
1506: ,p_lookup_code => p_thldact_rec.execute_action_type
1507: ) = FND_API.G_FALSE then
1508: -- invalid item
1509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1510: THEN -- MMSG
1511: -- DBMS_OUTPUT.Put_Line('Check1 Type is invalid');

Line 1515: x_return_status := FND_API.G_RET_STS_ERROR;

1511: -- DBMS_OUTPUT.Put_Line('Check1 Type is invalid');
1512: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_ACTION_TYPE');
1513: FND_MSG_PUB.Add;
1514: END IF;
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: -- If any errors happen abort API/Procedure.
1517: RETURN;
1518: END IF;
1519: END IF;

Line 1546: x_return_status := FND_API.g_ret_sts_success;

1542: IS
1543: BEGIN
1544:
1545: --Initialize OUT NOCOPY Variable
1546: x_return_status := FND_API.g_ret_sts_success;
1547:
1548: --
1549: -- Notify Flag
1550: --

Line 1552: IF p_thldact_rec.notify_flag <> FND_API.g_miss_char

1548: --
1549: -- Notify Flag
1550: --
1551: /*
1552: IF p_thldact_rec.notify_flag <> FND_API.g_miss_char
1553: AND p_thldact_rec.notify_flag IS NOT NULL
1554: THEN
1555: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.notify_flag) = FND_API.g_false
1556: THEN

Line 1555: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.notify_flag) = FND_API.g_false

1551: /*
1552: IF p_thldact_rec.notify_flag <> FND_API.g_miss_char
1553: AND p_thldact_rec.notify_flag IS NOT NULL
1554: THEN
1555: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.notify_flag) = FND_API.g_false
1556: THEN
1557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1558: THEN
1559: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_NOTIFY_FLAG');

Line 1563: x_return_status := FND_API.g_ret_sts_error;

1559: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_NOTIFY_FLAG');
1560: FND_MSG_PUB.add;
1561: END IF;
1562:
1563: x_return_status := FND_API.g_ret_sts_error;
1564: RETURN;
1565: END IF;
1566: END IF;
1567: */

Line 1572: IF p_thldact_rec.generate_list_flag <> FND_API.g_miss_char

1568: --
1569: -- generate_list_flag
1570: --
1571: /*
1572: IF p_thldact_rec.generate_list_flag <> FND_API.g_miss_char
1573: AND p_thldact_rec.generate_list_flag IS NOT NULL
1574: THEN
1575: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.generate_list_flag) = FND_API.g_false
1576: THEN

Line 1575: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.generate_list_flag) = FND_API.g_false

1571: /*
1572: IF p_thldact_rec.generate_list_flag <> FND_API.g_miss_char
1573: AND p_thldact_rec.generate_list_flag IS NOT NULL
1574: THEN
1575: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.generate_list_flag) = FND_API.g_false
1576: THEN
1577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1578: THEN
1579: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_GEN_LIST_FLAG');

Line 1583: x_return_status := FND_API.g_ret_sts_error;

1579: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_GEN_LIST_FLAG');
1580: FND_MSG_PUB.add;
1581: END IF;
1582:
1583: x_return_status := FND_API.g_ret_sts_error;
1584: RETURN;
1585: END IF;
1586: END IF;
1587: */

Line 1592: IF p_thldact_rec.action_need_approval_flag <> FND_API.g_miss_char

1588: --
1589: -- Action_need_approval_flag
1590: --
1591: /*
1592: IF p_thldact_rec.action_need_approval_flag <> FND_API.g_miss_char
1593: AND p_thldact_rec.action_need_approval_flag IS NOT NULL
1594: THEN
1595: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.action_need_approval_flag) = FND_API.g_false
1596: THEN

Line 1595: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.action_need_approval_flag) = FND_API.g_false

1591: /*
1592: IF p_thldact_rec.action_need_approval_flag <> FND_API.g_miss_char
1593: AND p_thldact_rec.action_need_approval_flag IS NOT NULL
1594: THEN
1595: IF AMS_Utility_PVT.is_Y_or_N(p_thldact_rec.action_need_approval_flag) = FND_API.g_false
1596: THEN
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1598: THEN
1599: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_APPR_FLAG');

Line 1603: x_return_status := FND_API.g_ret_sts_error;

1599: FND_MESSAGE.set_name('AMS', 'AMS_TRIG_BAD_APPR_FLAG');
1600: FND_MSG_PUB.add;
1601: END IF;
1602:
1603: x_return_status := FND_API.g_ret_sts_error;
1604: RETURN;
1605: END IF;
1606: END IF;
1607: */

Line 1640: IF x_return_status <> FND_API.g_ret_sts_success THEN

1636: p_thldact_rec => p_thldact_rec,
1637: x_return_status => x_return_status
1638: );
1639:
1640: IF x_return_status <> FND_API.g_ret_sts_success THEN
1641: RETURN;
1642: END IF;
1643:
1644: Check_ThldAct_Uk_Items(

Line 1650: IF x_return_status <> FND_API.g_ret_sts_success THEN

1646: p_validation_mode => p_validation_mode,
1647: x_return_status => x_return_status
1648: );
1649: -- dbms_output.put_line('After UK : '||x_return_status);
1650: IF x_return_status <> FND_API.g_ret_sts_success THEN
1651: RETURN;
1652: END IF;
1653:
1654: Check_ThldAct_Fk_Items(

Line 1659: IF x_return_status <> FND_API.g_ret_sts_success THEN

1655: p_thldact_rec => p_thldact_rec,
1656: x_return_status => x_return_status
1657: );
1658: -- dbms_output.put_line('After fK : '||x_return_status);
1659: IF x_return_status <> FND_API.g_ret_sts_success THEN
1660: RETURN;
1661: END IF;
1662:
1663: Check_ThldAct_Lookup_Items(

Line 1668: IF x_return_status <> FND_API.g_ret_sts_success THEN

1664: p_thldact_rec => p_thldact_rec,
1665: x_return_status => x_return_status
1666: );
1667:
1668: IF x_return_status <> FND_API.g_ret_sts_success THEN
1669: RETURN;
1670: END IF;
1671:
1672: Check_Thldact_flag_items(

Line 1677: IF x_return_status <> FND_API.g_ret_sts_success THEN

1673: p_thldact_rec => p_thldact_rec,
1674: x_return_status => x_return_status
1675: );
1676:
1677: IF x_return_status <> FND_API.g_ret_sts_success THEN
1678: RETURN;
1679: END IF;
1680:
1681: END Check_Thldact_Items;

Line 1733: x_return_status := FND_API.g_ret_sts_success;

1729: BEGIN
1730: --
1731: -- Initialize the Out Variable
1732: --
1733: x_return_status := FND_API.g_ret_sts_success;
1734:
1735: --
1736: -- Generate List Flag
1737: --

Line 1739: IF p_thldact_rec.generate_list_flag <> FND_API.G_MISS_CHAR

1735: --
1736: -- Generate List Flag
1737: --
1738: /*
1739: IF p_thldact_rec.generate_list_flag <> FND_API.G_MISS_CHAR
1740: THEN
1741: IF p_thldact_rec.list_header_id = FND_API.G_MISS_NUM THEN
1742: l_list_header_id := p_complete_rec.list_header_id ;
1743: ELSE

Line 1741: IF p_thldact_rec.list_header_id = FND_API.G_MISS_NUM THEN

1737: --
1738: /*
1739: IF p_thldact_rec.generate_list_flag <> FND_API.G_MISS_CHAR
1740: THEN
1741: IF p_thldact_rec.list_header_id = FND_API.G_MISS_NUM THEN
1742: l_list_header_id := p_complete_rec.list_header_id ;
1743: ELSE
1744: l_list_header_id := p_thldact_rec.list_header_id ;
1745: END IF;

Line 1757: x_return_status := FND_API.G_RET_STS_ERROR;

1753: --dbms_output.put_line('list_use_this_source_code is missing');
1754: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_LIST');
1755: FND_MSG_PUB.Add;
1756: END IF;
1757: x_return_status := FND_API.G_RET_STS_ERROR;
1758: -- If any errors happen abort API/Procedure.
1759: RETURN;
1760: END IF;
1761: END IF;

Line 1767: IF p_thldact_rec.deliverable_id <> FND_API.G_MISS_NUM THEN

1763: --
1764: -- Validate Deliverable_id
1765: --
1766: /*
1767: IF p_thldact_rec.deliverable_id <> FND_API.G_MISS_NUM THEN
1768: IF p_thldact_rec.trigger_id = FND_API.G_MISS_NUM THEN
1769: l_trigger_id := p_complete_rec.trigger_id ;
1770: ELSE
1771: l_trigger_id := p_thldact_rec.trigger_id ;

Line 1768: IF p_thldact_rec.trigger_id = FND_API.G_MISS_NUM THEN

1764: -- Validate Deliverable_id
1765: --
1766: /*
1767: IF p_thldact_rec.deliverable_id <> FND_API.G_MISS_NUM THEN
1768: IF p_thldact_rec.trigger_id = FND_API.G_MISS_NUM THEN
1769: l_trigger_id := p_complete_rec.trigger_id ;
1770: ELSE
1771: l_trigger_id := p_thldact_rec.trigger_id ;
1772: END IF;

Line 1795: ) = FND_API.G_FALSE

1791: ,p_pk_name => l_pk_name
1792: ,p_pk_value => l_pk_value
1793: ,p_pk_data_type => l_pk_data_type
1794: ,p_additional_where_clause => l_additional_where_clause
1795: ) = FND_API.G_FALSE
1796: THEN
1797: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1798: FND_MESSAGE.Set_Name ('AMS', 'AMS_TRIG_INVALID_DELV_ID');
1799: FND_MSG_PUB.Add;

Line 1802: x_return_status := FND_API.G_RET_STS_ERROR;

1798: FND_MESSAGE.Set_Name ('AMS', 'AMS_TRIG_INVALID_DELV_ID');
1799: FND_MSG_PUB.Add;
1800: END IF;
1801:
1802: x_return_status := FND_API.G_RET_STS_ERROR;
1803: RETURN;
1804: END IF;
1805: END IF;
1806: */

Line 1812: IF p_thldact_rec.execute_action_type <> FND_API.G_MISS_CHAR

1808: -- Generate List Flag
1809: --
1810: -- soagrawa 30-apr-2003 removed this
1811: /*
1812: IF p_thldact_rec.execute_action_type <> FND_API.G_MISS_CHAR
1813: AND p_thldact_rec.execute_action_type IS NOT NULL
1814: AND p_thldact_rec.execute_action_type <> 'FULFILL_LIST'
1815: THEN
1816: IF p_thldact_rec.cover_letter_id = FND_API.G_MISS_NUM THEN

Line 1816: IF p_thldact_rec.cover_letter_id = FND_API.G_MISS_NUM THEN

1812: IF p_thldact_rec.execute_action_type <> FND_API.G_MISS_CHAR
1813: AND p_thldact_rec.execute_action_type IS NOT NULL
1814: AND p_thldact_rec.execute_action_type <> 'FULFILL_LIST'
1815: THEN
1816: IF p_thldact_rec.cover_letter_id = FND_API.G_MISS_NUM THEN
1817: l_cover_letter_id := p_complete_rec.cover_letter_id ;
1818: ELSE
1819: l_cover_letter_id := p_thldact_rec.cover_letter_id ;
1820: END IF;

Line 1831: x_return_status := FND_API.G_RET_STS_ERROR;

1827: --dbms_output.put_line('list_use_this_source_code is missing');
1828: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_COVER_LETTER');
1829: FND_MSG_PUB.Add;
1830: END IF;
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: -- If any errors happen abort API/Procedure.
1833: RETURN;
1834: END IF;
1835: END IF;

Line 1841: IF ((p_thldact_rec.ACTION_NOTIF_USER_ID IS NULL) OR (p_thldact_rec.ACTION_NOTIF_USER_ID = FND_API.G_MISS_NUM)) THEN

1837: -- CGOYAL added for 11.5.8 backport
1838: -- Validate Notify User if notify flag is checked.
1839: --
1840: /*
1841: IF ((p_thldact_rec.ACTION_NOTIF_USER_ID IS NULL) OR (p_thldact_rec.ACTION_NOTIF_USER_ID = FND_API.G_MISS_NUM)) THEN
1842: IF p_thldact_rec.notify_flag = 'Y' THEN
1843: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1844: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_NOTIFY_USER');
1845: FND_MSG_PUB.Add;

Line 1847: x_return_status := FND_API.G_RET_STS_ERROR;

1843: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1844: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_NOTIFY_USER');
1845: FND_MSG_PUB.Add;
1846: END IF;
1847: x_return_status := FND_API.G_RET_STS_ERROR;
1848: END IF;
1849: END IF;
1850: */
1851:

Line 1853: AND ((p_thldact_rec.action_for_id IS NULL) OR (p_thldact_rec.action_for_id = FND_API.G_MISS_NUM))

1849: END IF;
1850: */
1851:
1852: IF p_thldact_rec.execute_action_type = 'NOTIFY'
1853: AND ((p_thldact_rec.action_for_id IS NULL) OR (p_thldact_rec.action_for_id = FND_API.G_MISS_NUM))
1854: THEN
1855: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1856: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_NOTIFY_USER');
1857: FND_MSG_PUB.Add;

Line 1859: x_return_status := FND_API.G_RET_STS_ERROR;

1855: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1856: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_MISSING_NOTIFY_USER');
1857: FND_MSG_PUB.Add;
1858: END IF;
1859: x_return_status := FND_API.G_RET_STS_ERROR;
1860: END IF;
1861:
1862: END Check_thldact_record;
1863:

Line 1884: x_thldact_rec.trigger_action_id := FND_API.G_MISS_NUM ;

1880: x_thldact_rec OUT NOCOPY thldact_rec_type
1881: )
1882: IS
1883: BEGIN
1884: x_thldact_rec.trigger_action_id := FND_API.G_MISS_NUM ;
1885: x_thldact_rec.last_update_date := FND_API.G_MISS_DATE ;
1886: x_thldact_rec.last_updated_by := FND_API.G_MISS_NUM ;
1887: x_thldact_rec.creation_date := FND_API.G_MISS_DATE ;
1888: x_thldact_rec.created_by := FND_API.G_MISS_NUM ;

Line 1885: x_thldact_rec.last_update_date := FND_API.G_MISS_DATE ;

1881: )
1882: IS
1883: BEGIN
1884: x_thldact_rec.trigger_action_id := FND_API.G_MISS_NUM ;
1885: x_thldact_rec.last_update_date := FND_API.G_MISS_DATE ;
1886: x_thldact_rec.last_updated_by := FND_API.G_MISS_NUM ;
1887: x_thldact_rec.creation_date := FND_API.G_MISS_DATE ;
1888: x_thldact_rec.created_by := FND_API.G_MISS_NUM ;
1889: x_thldact_rec.last_update_login := FND_API.G_MISS_NUM ;

Line 1886: x_thldact_rec.last_updated_by := FND_API.G_MISS_NUM ;

1882: IS
1883: BEGIN
1884: x_thldact_rec.trigger_action_id := FND_API.G_MISS_NUM ;
1885: x_thldact_rec.last_update_date := FND_API.G_MISS_DATE ;
1886: x_thldact_rec.last_updated_by := FND_API.G_MISS_NUM ;
1887: x_thldact_rec.creation_date := FND_API.G_MISS_DATE ;
1888: x_thldact_rec.created_by := FND_API.G_MISS_NUM ;
1889: x_thldact_rec.last_update_login := FND_API.G_MISS_NUM ;
1890: x_thldact_rec.object_version_number := FND_API.G_MISS_NUM ;

Line 1887: x_thldact_rec.creation_date := FND_API.G_MISS_DATE ;

1883: BEGIN
1884: x_thldact_rec.trigger_action_id := FND_API.G_MISS_NUM ;
1885: x_thldact_rec.last_update_date := FND_API.G_MISS_DATE ;
1886: x_thldact_rec.last_updated_by := FND_API.G_MISS_NUM ;
1887: x_thldact_rec.creation_date := FND_API.G_MISS_DATE ;
1888: x_thldact_rec.created_by := FND_API.G_MISS_NUM ;
1889: x_thldact_rec.last_update_login := FND_API.G_MISS_NUM ;
1890: x_thldact_rec.object_version_number := FND_API.G_MISS_NUM ;
1891: x_thldact_rec.process_id := FND_API.G_MISS_NUM ;

Line 1888: x_thldact_rec.created_by := FND_API.G_MISS_NUM ;

1884: x_thldact_rec.trigger_action_id := FND_API.G_MISS_NUM ;
1885: x_thldact_rec.last_update_date := FND_API.G_MISS_DATE ;
1886: x_thldact_rec.last_updated_by := FND_API.G_MISS_NUM ;
1887: x_thldact_rec.creation_date := FND_API.G_MISS_DATE ;
1888: x_thldact_rec.created_by := FND_API.G_MISS_NUM ;
1889: x_thldact_rec.last_update_login := FND_API.G_MISS_NUM ;
1890: x_thldact_rec.object_version_number := FND_API.G_MISS_NUM ;
1891: x_thldact_rec.process_id := FND_API.G_MISS_NUM ;
1892: x_thldact_rec.trigger_id := FND_API.G_MISS_NUM ;

Line 1889: x_thldact_rec.last_update_login := FND_API.G_MISS_NUM ;

1885: x_thldact_rec.last_update_date := FND_API.G_MISS_DATE ;
1886: x_thldact_rec.last_updated_by := FND_API.G_MISS_NUM ;
1887: x_thldact_rec.creation_date := FND_API.G_MISS_DATE ;
1888: x_thldact_rec.created_by := FND_API.G_MISS_NUM ;
1889: x_thldact_rec.last_update_login := FND_API.G_MISS_NUM ;
1890: x_thldact_rec.object_version_number := FND_API.G_MISS_NUM ;
1891: x_thldact_rec.process_id := FND_API.G_MISS_NUM ;
1892: x_thldact_rec.trigger_id := FND_API.G_MISS_NUM ;
1893: x_thldact_rec.order_number := FND_API.G_MISS_NUM ;

Line 1890: x_thldact_rec.object_version_number := FND_API.G_MISS_NUM ;

1886: x_thldact_rec.last_updated_by := FND_API.G_MISS_NUM ;
1887: x_thldact_rec.creation_date := FND_API.G_MISS_DATE ;
1888: x_thldact_rec.created_by := FND_API.G_MISS_NUM ;
1889: x_thldact_rec.last_update_login := FND_API.G_MISS_NUM ;
1890: x_thldact_rec.object_version_number := FND_API.G_MISS_NUM ;
1891: x_thldact_rec.process_id := FND_API.G_MISS_NUM ;
1892: x_thldact_rec.trigger_id := FND_API.G_MISS_NUM ;
1893: x_thldact_rec.order_number := FND_API.G_MISS_NUM ;
1894: x_thldact_rec.notify_flag := FND_API.G_MISS_CHAR ;

Line 1891: x_thldact_rec.process_id := FND_API.G_MISS_NUM ;

1887: x_thldact_rec.creation_date := FND_API.G_MISS_DATE ;
1888: x_thldact_rec.created_by := FND_API.G_MISS_NUM ;
1889: x_thldact_rec.last_update_login := FND_API.G_MISS_NUM ;
1890: x_thldact_rec.object_version_number := FND_API.G_MISS_NUM ;
1891: x_thldact_rec.process_id := FND_API.G_MISS_NUM ;
1892: x_thldact_rec.trigger_id := FND_API.G_MISS_NUM ;
1893: x_thldact_rec.order_number := FND_API.G_MISS_NUM ;
1894: x_thldact_rec.notify_flag := FND_API.G_MISS_CHAR ;
1895:

Line 1892: x_thldact_rec.trigger_id := FND_API.G_MISS_NUM ;

1888: x_thldact_rec.created_by := FND_API.G_MISS_NUM ;
1889: x_thldact_rec.last_update_login := FND_API.G_MISS_NUM ;
1890: x_thldact_rec.object_version_number := FND_API.G_MISS_NUM ;
1891: x_thldact_rec.process_id := FND_API.G_MISS_NUM ;
1892: x_thldact_rec.trigger_id := FND_API.G_MISS_NUM ;
1893: x_thldact_rec.order_number := FND_API.G_MISS_NUM ;
1894: x_thldact_rec.notify_flag := FND_API.G_MISS_CHAR ;
1895:
1896: -- cgoyal added ACTION_NOTIF_USER_ID column initialise

Line 1893: x_thldact_rec.order_number := FND_API.G_MISS_NUM ;

1889: x_thldact_rec.last_update_login := FND_API.G_MISS_NUM ;
1890: x_thldact_rec.object_version_number := FND_API.G_MISS_NUM ;
1891: x_thldact_rec.process_id := FND_API.G_MISS_NUM ;
1892: x_thldact_rec.trigger_id := FND_API.G_MISS_NUM ;
1893: x_thldact_rec.order_number := FND_API.G_MISS_NUM ;
1894: x_thldact_rec.notify_flag := FND_API.G_MISS_CHAR ;
1895:
1896: -- cgoyal added ACTION_NOTIF_USER_ID column initialise
1897: --x_thldact_rec.ACTION_NOTIF_USER_ID := FND_API.G_MISS_NUM ;

Line 1894: x_thldact_rec.notify_flag := FND_API.G_MISS_CHAR ;

1890: x_thldact_rec.object_version_number := FND_API.G_MISS_NUM ;
1891: x_thldact_rec.process_id := FND_API.G_MISS_NUM ;
1892: x_thldact_rec.trigger_id := FND_API.G_MISS_NUM ;
1893: x_thldact_rec.order_number := FND_API.G_MISS_NUM ;
1894: x_thldact_rec.notify_flag := FND_API.G_MISS_CHAR ;
1895:
1896: -- cgoyal added ACTION_NOTIF_USER_ID column initialise
1897: --x_thldact_rec.ACTION_NOTIF_USER_ID := FND_API.G_MISS_NUM ;
1898: x_thldact_rec.action_for_id := FND_API.G_MISS_NUM ;

Line 1897: --x_thldact_rec.ACTION_NOTIF_USER_ID := FND_API.G_MISS_NUM ;

1893: x_thldact_rec.order_number := FND_API.G_MISS_NUM ;
1894: x_thldact_rec.notify_flag := FND_API.G_MISS_CHAR ;
1895:
1896: -- cgoyal added ACTION_NOTIF_USER_ID column initialise
1897: --x_thldact_rec.ACTION_NOTIF_USER_ID := FND_API.G_MISS_NUM ;
1898: x_thldact_rec.action_for_id := FND_API.G_MISS_NUM ;
1899:
1900: x_thldact_rec.generate_list_flag := FND_API.G_MISS_CHAR ;
1901: x_thldact_rec.action_need_approval_flag := FND_API.G_MISS_CHAR ;

Line 1898: x_thldact_rec.action_for_id := FND_API.G_MISS_NUM ;

1894: x_thldact_rec.notify_flag := FND_API.G_MISS_CHAR ;
1895:
1896: -- cgoyal added ACTION_NOTIF_USER_ID column initialise
1897: --x_thldact_rec.ACTION_NOTIF_USER_ID := FND_API.G_MISS_NUM ;
1898: x_thldact_rec.action_for_id := FND_API.G_MISS_NUM ;
1899:
1900: x_thldact_rec.generate_list_flag := FND_API.G_MISS_CHAR ;
1901: x_thldact_rec.action_need_approval_flag := FND_API.G_MISS_CHAR ;
1902: x_thldact_rec.action_approver_user_id := FND_API.G_MISS_NUM ;

Line 1900: x_thldact_rec.generate_list_flag := FND_API.G_MISS_CHAR ;

1896: -- cgoyal added ACTION_NOTIF_USER_ID column initialise
1897: --x_thldact_rec.ACTION_NOTIF_USER_ID := FND_API.G_MISS_NUM ;
1898: x_thldact_rec.action_for_id := FND_API.G_MISS_NUM ;
1899:
1900: x_thldact_rec.generate_list_flag := FND_API.G_MISS_CHAR ;
1901: x_thldact_rec.action_need_approval_flag := FND_API.G_MISS_CHAR ;
1902: x_thldact_rec.action_approver_user_id := FND_API.G_MISS_NUM ;
1903: x_thldact_rec.execute_action_type := FND_API.G_MISS_CHAR ;
1904: x_thldact_rec.list_header_id := FND_API.G_MISS_NUM ;

Line 1901: x_thldact_rec.action_need_approval_flag := FND_API.G_MISS_CHAR ;

1897: --x_thldact_rec.ACTION_NOTIF_USER_ID := FND_API.G_MISS_NUM ;
1898: x_thldact_rec.action_for_id := FND_API.G_MISS_NUM ;
1899:
1900: x_thldact_rec.generate_list_flag := FND_API.G_MISS_CHAR ;
1901: x_thldact_rec.action_need_approval_flag := FND_API.G_MISS_CHAR ;
1902: x_thldact_rec.action_approver_user_id := FND_API.G_MISS_NUM ;
1903: x_thldact_rec.execute_action_type := FND_API.G_MISS_CHAR ;
1904: x_thldact_rec.list_header_id := FND_API.G_MISS_NUM ;
1905: x_thldact_rec.list_connected_to_id := FND_API.G_MISS_NUM ;

Line 1902: x_thldact_rec.action_approver_user_id := FND_API.G_MISS_NUM ;

1898: x_thldact_rec.action_for_id := FND_API.G_MISS_NUM ;
1899:
1900: x_thldact_rec.generate_list_flag := FND_API.G_MISS_CHAR ;
1901: x_thldact_rec.action_need_approval_flag := FND_API.G_MISS_CHAR ;
1902: x_thldact_rec.action_approver_user_id := FND_API.G_MISS_NUM ;
1903: x_thldact_rec.execute_action_type := FND_API.G_MISS_CHAR ;
1904: x_thldact_rec.list_header_id := FND_API.G_MISS_NUM ;
1905: x_thldact_rec.list_connected_to_id := FND_API.G_MISS_NUM ;
1906: x_thldact_rec.arc_list_connected_to := FND_API.G_MISS_CHAR ;

Line 1903: x_thldact_rec.execute_action_type := FND_API.G_MISS_CHAR ;

1899:
1900: x_thldact_rec.generate_list_flag := FND_API.G_MISS_CHAR ;
1901: x_thldact_rec.action_need_approval_flag := FND_API.G_MISS_CHAR ;
1902: x_thldact_rec.action_approver_user_id := FND_API.G_MISS_NUM ;
1903: x_thldact_rec.execute_action_type := FND_API.G_MISS_CHAR ;
1904: x_thldact_rec.list_header_id := FND_API.G_MISS_NUM ;
1905: x_thldact_rec.list_connected_to_id := FND_API.G_MISS_NUM ;
1906: x_thldact_rec.arc_list_connected_to := FND_API.G_MISS_CHAR ;
1907: x_thldact_rec.deliverable_id := FND_API.G_MISS_NUM ;

Line 1904: x_thldact_rec.list_header_id := FND_API.G_MISS_NUM ;

1900: x_thldact_rec.generate_list_flag := FND_API.G_MISS_CHAR ;
1901: x_thldact_rec.action_need_approval_flag := FND_API.G_MISS_CHAR ;
1902: x_thldact_rec.action_approver_user_id := FND_API.G_MISS_NUM ;
1903: x_thldact_rec.execute_action_type := FND_API.G_MISS_CHAR ;
1904: x_thldact_rec.list_header_id := FND_API.G_MISS_NUM ;
1905: x_thldact_rec.list_connected_to_id := FND_API.G_MISS_NUM ;
1906: x_thldact_rec.arc_list_connected_to := FND_API.G_MISS_CHAR ;
1907: x_thldact_rec.deliverable_id := FND_API.G_MISS_NUM ;
1908: x_thldact_rec.activity_offer_id := FND_API.G_MISS_NUM ;

Line 1905: x_thldact_rec.list_connected_to_id := FND_API.G_MISS_NUM ;

1901: x_thldact_rec.action_need_approval_flag := FND_API.G_MISS_CHAR ;
1902: x_thldact_rec.action_approver_user_id := FND_API.G_MISS_NUM ;
1903: x_thldact_rec.execute_action_type := FND_API.G_MISS_CHAR ;
1904: x_thldact_rec.list_header_id := FND_API.G_MISS_NUM ;
1905: x_thldact_rec.list_connected_to_id := FND_API.G_MISS_NUM ;
1906: x_thldact_rec.arc_list_connected_to := FND_API.G_MISS_CHAR ;
1907: x_thldact_rec.deliverable_id := FND_API.G_MISS_NUM ;
1908: x_thldact_rec.activity_offer_id := FND_API.G_MISS_NUM ;
1909: x_thldact_rec.dscript_name := FND_API.G_MISS_CHAR ;

Line 1906: x_thldact_rec.arc_list_connected_to := FND_API.G_MISS_CHAR ;

1902: x_thldact_rec.action_approver_user_id := FND_API.G_MISS_NUM ;
1903: x_thldact_rec.execute_action_type := FND_API.G_MISS_CHAR ;
1904: x_thldact_rec.list_header_id := FND_API.G_MISS_NUM ;
1905: x_thldact_rec.list_connected_to_id := FND_API.G_MISS_NUM ;
1906: x_thldact_rec.arc_list_connected_to := FND_API.G_MISS_CHAR ;
1907: x_thldact_rec.deliverable_id := FND_API.G_MISS_NUM ;
1908: x_thldact_rec.activity_offer_id := FND_API.G_MISS_NUM ;
1909: x_thldact_rec.dscript_name := FND_API.G_MISS_CHAR ;
1910: x_thldact_rec.program_to_call := FND_API.G_MISS_CHAR ;

Line 1907: x_thldact_rec.deliverable_id := FND_API.G_MISS_NUM ;

1903: x_thldact_rec.execute_action_type := FND_API.G_MISS_CHAR ;
1904: x_thldact_rec.list_header_id := FND_API.G_MISS_NUM ;
1905: x_thldact_rec.list_connected_to_id := FND_API.G_MISS_NUM ;
1906: x_thldact_rec.arc_list_connected_to := FND_API.G_MISS_CHAR ;
1907: x_thldact_rec.deliverable_id := FND_API.G_MISS_NUM ;
1908: x_thldact_rec.activity_offer_id := FND_API.G_MISS_NUM ;
1909: x_thldact_rec.dscript_name := FND_API.G_MISS_CHAR ;
1910: x_thldact_rec.program_to_call := FND_API.G_MISS_CHAR ;
1911:

Line 1908: x_thldact_rec.activity_offer_id := FND_API.G_MISS_NUM ;

1904: x_thldact_rec.list_header_id := FND_API.G_MISS_NUM ;
1905: x_thldact_rec.list_connected_to_id := FND_API.G_MISS_NUM ;
1906: x_thldact_rec.arc_list_connected_to := FND_API.G_MISS_CHAR ;
1907: x_thldact_rec.deliverable_id := FND_API.G_MISS_NUM ;
1908: x_thldact_rec.activity_offer_id := FND_API.G_MISS_NUM ;
1909: x_thldact_rec.dscript_name := FND_API.G_MISS_CHAR ;
1910: x_thldact_rec.program_to_call := FND_API.G_MISS_CHAR ;
1911:
1912: x_thldact_rec.cover_letter_id := FND_API.G_MISS_NUM ;

Line 1909: x_thldact_rec.dscript_name := FND_API.G_MISS_CHAR ;

1905: x_thldact_rec.list_connected_to_id := FND_API.G_MISS_NUM ;
1906: x_thldact_rec.arc_list_connected_to := FND_API.G_MISS_CHAR ;
1907: x_thldact_rec.deliverable_id := FND_API.G_MISS_NUM ;
1908: x_thldact_rec.activity_offer_id := FND_API.G_MISS_NUM ;
1909: x_thldact_rec.dscript_name := FND_API.G_MISS_CHAR ;
1910: x_thldact_rec.program_to_call := FND_API.G_MISS_CHAR ;
1911:
1912: x_thldact_rec.cover_letter_id := FND_API.G_MISS_NUM ;
1913: x_thldact_rec.mail_subject := FND_API.G_MISS_CHAR ;

Line 1910: x_thldact_rec.program_to_call := FND_API.G_MISS_CHAR ;

1906: x_thldact_rec.arc_list_connected_to := FND_API.G_MISS_CHAR ;
1907: x_thldact_rec.deliverable_id := FND_API.G_MISS_NUM ;
1908: x_thldact_rec.activity_offer_id := FND_API.G_MISS_NUM ;
1909: x_thldact_rec.dscript_name := FND_API.G_MISS_CHAR ;
1910: x_thldact_rec.program_to_call := FND_API.G_MISS_CHAR ;
1911:
1912: x_thldact_rec.cover_letter_id := FND_API.G_MISS_NUM ;
1913: x_thldact_rec.mail_subject := FND_API.G_MISS_CHAR ;
1914: x_thldact_rec.mail_sender_name := FND_API.G_MISS_CHAR ;

Line 1912: x_thldact_rec.cover_letter_id := FND_API.G_MISS_NUM ;

1908: x_thldact_rec.activity_offer_id := FND_API.G_MISS_NUM ;
1909: x_thldact_rec.dscript_name := FND_API.G_MISS_CHAR ;
1910: x_thldact_rec.program_to_call := FND_API.G_MISS_CHAR ;
1911:
1912: x_thldact_rec.cover_letter_id := FND_API.G_MISS_NUM ;
1913: x_thldact_rec.mail_subject := FND_API.G_MISS_CHAR ;
1914: x_thldact_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
1915: x_thldact_rec.from_fax_no := FND_API.G_MISS_CHAR ;
1916:

Line 1913: x_thldact_rec.mail_subject := FND_API.G_MISS_CHAR ;

1909: x_thldact_rec.dscript_name := FND_API.G_MISS_CHAR ;
1910: x_thldact_rec.program_to_call := FND_API.G_MISS_CHAR ;
1911:
1912: x_thldact_rec.cover_letter_id := FND_API.G_MISS_NUM ;
1913: x_thldact_rec.mail_subject := FND_API.G_MISS_CHAR ;
1914: x_thldact_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
1915: x_thldact_rec.from_fax_no := FND_API.G_MISS_CHAR ;
1916:
1917: END Init_thldact_rec ;

Line 1914: x_thldact_rec.mail_sender_name := FND_API.G_MISS_CHAR ;

1910: x_thldact_rec.program_to_call := FND_API.G_MISS_CHAR ;
1911:
1912: x_thldact_rec.cover_letter_id := FND_API.G_MISS_NUM ;
1913: x_thldact_rec.mail_subject := FND_API.G_MISS_CHAR ;
1914: x_thldact_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
1915: x_thldact_rec.from_fax_no := FND_API.G_MISS_CHAR ;
1916:
1917: END Init_thldact_rec ;
1918:

Line 1915: x_thldact_rec.from_fax_no := FND_API.G_MISS_CHAR ;

1911:
1912: x_thldact_rec.cover_letter_id := FND_API.G_MISS_NUM ;
1913: x_thldact_rec.mail_subject := FND_API.G_MISS_CHAR ;
1914: x_thldact_rec.mail_sender_name := FND_API.G_MISS_CHAR ;
1915: x_thldact_rec.from_fax_no := FND_API.G_MISS_CHAR ;
1916:
1917: END Init_thldact_rec ;
1918:
1919: -- Start of Comments

Line 1960: RAISE FND_API.g_exc_error;

1956: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1957: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1958: FND_MSG_PUB.add;
1959: END IF;
1960: RAISE FND_API.g_exc_error;
1961: END IF;
1962: CLOSE c_thldact;
1963:
1964: IF p_thldact_rec.trigger_id = FND_API.g_miss_num THEN

Line 1964: IF p_thldact_rec.trigger_id = FND_API.g_miss_num THEN

1960: RAISE FND_API.g_exc_error;
1961: END IF;
1962: CLOSE c_thldact;
1963:
1964: IF p_thldact_rec.trigger_id = FND_API.g_miss_num THEN
1965: x_complete_rec.trigger_id := l_thldact_rec.trigger_id;
1966: END IF;
1967:
1968: IF p_thldact_rec.order_number = FND_API.g_miss_num THEN

Line 1968: IF p_thldact_rec.order_number = FND_API.g_miss_num THEN

1964: IF p_thldact_rec.trigger_id = FND_API.g_miss_num THEN
1965: x_complete_rec.trigger_id := l_thldact_rec.trigger_id;
1966: END IF;
1967:
1968: IF p_thldact_rec.order_number = FND_API.g_miss_num THEN
1969: x_complete_rec.order_number := l_thldact_rec.order_number;
1970: END IF;
1971:
1972: IF p_thldact_rec.process_id = FND_API.g_miss_num THEN

Line 1972: IF p_thldact_rec.process_id = FND_API.g_miss_num THEN

1968: IF p_thldact_rec.order_number = FND_API.g_miss_num THEN
1969: x_complete_rec.order_number := l_thldact_rec.order_number;
1970: END IF;
1971:
1972: IF p_thldact_rec.process_id = FND_API.g_miss_num THEN
1973: x_complete_rec.process_id := l_thldact_rec.process_id;
1974: END IF;
1975:
1976: IF p_thldact_rec.notify_flag = FND_API.g_miss_char THEN

Line 1976: IF p_thldact_rec.notify_flag = FND_API.g_miss_char THEN

1972: IF p_thldact_rec.process_id = FND_API.g_miss_num THEN
1973: x_complete_rec.process_id := l_thldact_rec.process_id;
1974: END IF;
1975:
1976: IF p_thldact_rec.notify_flag = FND_API.g_miss_char THEN
1977: x_complete_rec.notify_flag := l_thldact_rec.notify_flag;
1978: END IF;
1979: /*
1980: -- CGOYAL added for 11.5.8 backport

Line 1981: IF p_thldact_rec.ACTION_NOTIF_USER_ID = FND_API.g_miss_num THEN

1977: x_complete_rec.notify_flag := l_thldact_rec.notify_flag;
1978: END IF;
1979: /*
1980: -- CGOYAL added for 11.5.8 backport
1981: IF p_thldact_rec.ACTION_NOTIF_USER_ID = FND_API.g_miss_num THEN
1982: x_complete_rec.ACTION_NOTIF_USER_ID := l_thldact_rec.ACTION_NOTIF_USER_ID;
1983: END IF;
1984: -- End add.
1985: */

Line 1987: IF p_thldact_rec.action_for_id = FND_API.g_miss_num THEN

1983: END IF;
1984: -- End add.
1985: */
1986:
1987: IF p_thldact_rec.action_for_id = FND_API.g_miss_num THEN
1988: x_complete_rec.action_for_id := l_thldact_rec.action_for_id;
1989: END IF;
1990:
1991:

Line 1992: IF p_thldact_rec.generate_list_flag = FND_API.g_miss_char THEN

1988: x_complete_rec.action_for_id := l_thldact_rec.action_for_id;
1989: END IF;
1990:
1991:
1992: IF p_thldact_rec.generate_list_flag = FND_API.g_miss_char THEN
1993: x_complete_rec.generate_list_flag := l_thldact_rec.generate_list_flag;
1994: END IF;
1995:
1996: IF p_thldact_rec.action_need_approval_flag = FND_API.g_miss_char THEN

Line 1996: IF p_thldact_rec.action_need_approval_flag = FND_API.g_miss_char THEN

1992: IF p_thldact_rec.generate_list_flag = FND_API.g_miss_char THEN
1993: x_complete_rec.generate_list_flag := l_thldact_rec.generate_list_flag;
1994: END IF;
1995:
1996: IF p_thldact_rec.action_need_approval_flag = FND_API.g_miss_char THEN
1997: x_complete_rec.action_need_approval_flag := l_thldact_rec.action_need_approval_flag;
1998: END IF;
1999:
2000: IF p_thldact_rec.action_approver_user_id = FND_API.g_miss_num THEN

Line 2000: IF p_thldact_rec.action_approver_user_id = FND_API.g_miss_num THEN

1996: IF p_thldact_rec.action_need_approval_flag = FND_API.g_miss_char THEN
1997: x_complete_rec.action_need_approval_flag := l_thldact_rec.action_need_approval_flag;
1998: END IF;
1999:
2000: IF p_thldact_rec.action_approver_user_id = FND_API.g_miss_num THEN
2001: x_complete_rec.action_approver_user_id := l_thldact_rec.action_approver_user_id;
2002: END IF;
2003:
2004: IF p_thldact_rec.execute_action_type = FND_API.g_miss_char THEN

Line 2004: IF p_thldact_rec.execute_action_type = FND_API.g_miss_char THEN

2000: IF p_thldact_rec.action_approver_user_id = FND_API.g_miss_num THEN
2001: x_complete_rec.action_approver_user_id := l_thldact_rec.action_approver_user_id;
2002: END IF;
2003:
2004: IF p_thldact_rec.execute_action_type = FND_API.g_miss_char THEN
2005: x_complete_rec.execute_action_type := l_thldact_rec.execute_action_type;
2006: END IF;
2007:
2008: IF p_thldact_rec.list_header_id = FND_API.g_miss_num THEN

Line 2008: IF p_thldact_rec.list_header_id = FND_API.g_miss_num THEN

2004: IF p_thldact_rec.execute_action_type = FND_API.g_miss_char THEN
2005: x_complete_rec.execute_action_type := l_thldact_rec.execute_action_type;
2006: END IF;
2007:
2008: IF p_thldact_rec.list_header_id = FND_API.g_miss_num THEN
2009: x_complete_rec.list_header_id := l_thldact_rec.list_header_id;
2010: END IF;
2011:
2012: IF p_thldact_rec.list_connected_to_id = FND_API.g_miss_num THEN

Line 2012: IF p_thldact_rec.list_connected_to_id = FND_API.g_miss_num THEN

2008: IF p_thldact_rec.list_header_id = FND_API.g_miss_num THEN
2009: x_complete_rec.list_header_id := l_thldact_rec.list_header_id;
2010: END IF;
2011:
2012: IF p_thldact_rec.list_connected_to_id = FND_API.g_miss_num THEN
2013: x_complete_rec.list_connected_to_id := l_thldact_rec.list_connected_to_id;
2014: END IF;
2015:
2016: IF p_thldact_rec.arc_list_connected_to = FND_API.g_miss_char THEN

Line 2016: IF p_thldact_rec.arc_list_connected_to = FND_API.g_miss_char THEN

2012: IF p_thldact_rec.list_connected_to_id = FND_API.g_miss_num THEN
2013: x_complete_rec.list_connected_to_id := l_thldact_rec.list_connected_to_id;
2014: END IF;
2015:
2016: IF p_thldact_rec.arc_list_connected_to = FND_API.g_miss_char THEN
2017: x_complete_rec.arc_list_connected_to := l_thldact_rec.arc_list_connected_to;
2018: END IF;
2019:
2020: IF p_thldact_rec.deliverable_id = FND_API.g_miss_num THEN

Line 2020: IF p_thldact_rec.deliverable_id = FND_API.g_miss_num THEN

2016: IF p_thldact_rec.arc_list_connected_to = FND_API.g_miss_char THEN
2017: x_complete_rec.arc_list_connected_to := l_thldact_rec.arc_list_connected_to;
2018: END IF;
2019:
2020: IF p_thldact_rec.deliverable_id = FND_API.g_miss_num THEN
2021: x_complete_rec.deliverable_id := l_thldact_rec.deliverable_id;
2022: END IF;
2023:
2024: IF p_thldact_rec.activity_offer_id = FND_API.g_miss_num THEN

Line 2024: IF p_thldact_rec.activity_offer_id = FND_API.g_miss_num THEN

2020: IF p_thldact_rec.deliverable_id = FND_API.g_miss_num THEN
2021: x_complete_rec.deliverable_id := l_thldact_rec.deliverable_id;
2022: END IF;
2023:
2024: IF p_thldact_rec.activity_offer_id = FND_API.g_miss_num THEN
2025: x_complete_rec.activity_offer_id := l_thldact_rec.activity_offer_id;
2026: END IF;
2027:
2028: IF p_thldact_rec.dscript_name = FND_API.g_miss_char THEN

Line 2028: IF p_thldact_rec.dscript_name = FND_API.g_miss_char THEN

2024: IF p_thldact_rec.activity_offer_id = FND_API.g_miss_num THEN
2025: x_complete_rec.activity_offer_id := l_thldact_rec.activity_offer_id;
2026: END IF;
2027:
2028: IF p_thldact_rec.dscript_name = FND_API.g_miss_char THEN
2029: x_complete_rec.dscript_name := l_thldact_rec.dscript_name;
2030: END IF;
2031:
2032: IF p_thldact_rec.program_to_call = FND_API.g_miss_char THEN

Line 2032: IF p_thldact_rec.program_to_call = FND_API.g_miss_char THEN

2028: IF p_thldact_rec.dscript_name = FND_API.g_miss_char THEN
2029: x_complete_rec.dscript_name := l_thldact_rec.dscript_name;
2030: END IF;
2031:
2032: IF p_thldact_rec.program_to_call = FND_API.g_miss_char THEN
2033: x_complete_rec.program_to_call := l_thldact_rec.program_to_call;
2034: END IF;
2035:
2036: IF p_thldact_rec.cover_letter_id = FND_API.G_MISS_NUM THEN

Line 2036: IF p_thldact_rec.cover_letter_id = FND_API.G_MISS_NUM THEN

2032: IF p_thldact_rec.program_to_call = FND_API.g_miss_char THEN
2033: x_complete_rec.program_to_call := l_thldact_rec.program_to_call;
2034: END IF;
2035:
2036: IF p_thldact_rec.cover_letter_id = FND_API.G_MISS_NUM THEN
2037: x_complete_rec.cover_letter_id := l_thldact_rec.cover_letter_id ;
2038: END IF;
2039:
2040: IF p_thldact_rec.mail_subject = FND_API.G_MISS_CHAR THEN

Line 2040: IF p_thldact_rec.mail_subject = FND_API.G_MISS_CHAR THEN

2036: IF p_thldact_rec.cover_letter_id = FND_API.G_MISS_NUM THEN
2037: x_complete_rec.cover_letter_id := l_thldact_rec.cover_letter_id ;
2038: END IF;
2039:
2040: IF p_thldact_rec.mail_subject = FND_API.G_MISS_CHAR THEN
2041: x_complete_rec.mail_subject := l_thldact_rec.mail_subject ;
2042: END IF;
2043:
2044: IF p_thldact_rec.mail_sender_name = FND_API.G_MISS_CHAR THEN

Line 2044: IF p_thldact_rec.mail_sender_name = FND_API.G_MISS_CHAR THEN

2040: IF p_thldact_rec.mail_subject = FND_API.G_MISS_CHAR THEN
2041: x_complete_rec.mail_subject := l_thldact_rec.mail_subject ;
2042: END IF;
2043:
2044: IF p_thldact_rec.mail_sender_name = FND_API.G_MISS_CHAR THEN
2045: x_complete_rec.mail_sender_name := l_thldact_rec.mail_sender_name ;
2046: END IF;
2047:
2048: IF p_thldact_rec.from_fax_no = FND_API.G_MISS_CHAR THEN

Line 2048: IF p_thldact_rec.from_fax_no = FND_API.G_MISS_CHAR THEN

2044: IF p_thldact_rec.mail_sender_name = FND_API.G_MISS_CHAR THEN
2045: x_complete_rec.mail_sender_name := l_thldact_rec.mail_sender_name ;
2046: END IF;
2047:
2048: IF p_thldact_rec.from_fax_no = FND_API.G_MISS_CHAR THEN
2049: x_complete_rec.from_fax_no := l_thldact_rec.from_fax_no ;
2050: END IF;
2051:
2052: END Complete_thldact_rec ;