APPS.JTF_AMV_ITEM_PUB dependencies on FND_MSG_PUB

Line 138: FND_MSG_PUB.initialize;

134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136: --Initialize message list if p_init_msg_list is TRUE.
137: IF FND_API.To_Boolean (p_init_msg_list) THEN
138: FND_MSG_PUB.initialize;
139: END IF;
140: -- Initialize API return status to success
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142: -- Check if application id of the item record is valid

Line 144: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

140: -- Initialize API return status to success
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142: -- Check if application id of the item record is valid
143: IF (Is_ApplIdValid(l_item_rec.application_id) <> TRUE) THEN
144: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
145: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICATIONID_INVALID');
146: FND_MESSAGE.Set_Token('ID',
147: to_char( nvl(l_item_rec.application_id, -1) ) );
148: FND_MSG_PUB.Add;

Line 148: FND_MSG_PUB.Add;

144: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
145: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICATIONID_INVALID');
146: FND_MESSAGE.Set_Token('ID',
147: to_char( nvl(l_item_rec.application_id, -1) ) );
148: FND_MSG_PUB.Add;
149: END IF;
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152: -- Get the item id from sequence and date from current date.

Line 164: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

160: l_item_rec.external_access_flag := FND_API.G_FALSE;
161: END IF;
162: IF (l_item_rec.item_name is null OR
163: l_item_rec.item_name = FND_API.G_MISS_CHAR) THEN
164: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
165: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_NAME_NULL');
166: FND_MSG_PUB.Add;
167: END IF;
168: RAISE FND_API.G_EXC_ERROR;

Line 166: FND_MSG_PUB.Add;

162: IF (l_item_rec.item_name is null OR
163: l_item_rec.item_name = FND_API.G_MISS_CHAR) THEN
164: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
165: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_NAME_NULL');
166: FND_MSG_PUB.Add;
167: END IF;
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170: IF (l_item_rec.description = FND_API.G_MISS_CHAR) THEN

Line 227: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

223: -- If called from MES (MES has its own requirement)
224: IF (l_item_rec.application_id = G_MES_APPL_ID) THEN
225: -- Check if item type in the item record is null
226: IF (l_item_rec.item_type IS NULL ) THEN
227: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
228: FND_MESSAGE.Set_name('JTF','JTF_AMV_NULL_ITEM_TYPE');
229: FND_MSG_PUB.Add;
230: END IF;
231: RAISE FND_API.G_EXC_ERROR;

Line 229: FND_MSG_PUB.Add;

225: -- Check if item type in the item record is null
226: IF (l_item_rec.item_type IS NULL ) THEN
227: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
228: FND_MESSAGE.Set_name('JTF','JTF_AMV_NULL_ITEM_TYPE');
229: FND_MSG_PUB.Add;
230: END IF;
231: RAISE FND_API.G_EXC_ERROR;
232: END IF;
233:

Line 247: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

243: END IF;
244: /*
245: ELSIF (l_item_rec.application_id = G_ISTORE_APPL_ID ) THEN
246: IF (l_item_rec.access_name is null ) THEN
247: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
248: FND_MESSAGE.Set_name('JTF','JTF_AMV_ACCESS_NAME_MISSING');
249: FND_MSG_PUB.Add;
250: END IF;
251: RAISE FND_API.G_EXC_ERROR;

Line 249: FND_MSG_PUB.Add;

245: ELSIF (l_item_rec.application_id = G_ISTORE_APPL_ID ) THEN
246: IF (l_item_rec.access_name is null ) THEN
247: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
248: FND_MESSAGE.Set_name('JTF','JTF_AMV_ACCESS_NAME_MISSING');
249: FND_MSG_PUB.Add;
250: END IF;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: IF (l_item_rec.deliverable_type_code is null ) THEN

Line 254: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

250: END IF;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: IF (l_item_rec.deliverable_type_code is null ) THEN
254: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
255: FND_MESSAGE.Set_name('JTF','JTF_AMV_TYPE_CODE_NULL');
256: FND_MSG_PUB.Add;
257: END IF;
258: RAISE FND_API.G_EXC_ERROR;

Line 256: FND_MSG_PUB.Add;

252: END IF;
253: IF (l_item_rec.deliverable_type_code is null ) THEN
254: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
255: FND_MESSAGE.Set_name('JTF','JTF_AMV_TYPE_CODE_NULL');
256: FND_MSG_PUB.Add;
257: END IF;
258: RAISE FND_API.G_EXC_ERROR;
259: ELSE
260: IF check_lookup_exists

Line 265: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

261: (
262: p_lookup_type => 'JTF_AMV_DELV_TYPE_CODE',
263: p_lookup_code => l_item_rec.deliverable_type_code
264: ) = FND_API.G_FALSE THEN
265: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
266: FND_MESSAGE.Set_name('JTF','JTF_AMV_TYPE_CODE_WRONG');
267: FND_MSG_PUB.Add;
268: END IF;
269: RAISE FND_API.G_EXC_ERROR;

Line 267: FND_MSG_PUB.Add;

263: p_lookup_code => l_item_rec.deliverable_type_code
264: ) = FND_API.G_FALSE THEN
265: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
266: FND_MESSAGE.Set_name('JTF','JTF_AMV_TYPE_CODE_WRONG');
267: FND_MSG_PUB.Add;
268: END IF;
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271: END IF;

Line 273: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271: END IF;
272: IF (l_item_rec.applicable_to_code is null ) THEN
273: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
274: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICABLE_CODE_NULL');
275: FND_MSG_PUB.Add;
276: END IF;
277: RAISE FND_API.G_EXC_ERROR;

Line 275: FND_MSG_PUB.Add;

271: END IF;
272: IF (l_item_rec.applicable_to_code is null ) THEN
273: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
274: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICABLE_CODE_NULL');
275: FND_MSG_PUB.Add;
276: END IF;
277: RAISE FND_API.G_EXC_ERROR;
278: ELSE
279: IF check_lookup_exists

Line 284: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

280: (
281: p_lookup_type => 'JTF_AMV_APPLI_TO_CODE',
282: p_lookup_code => l_item_rec.applicable_to_code
283: ) = FND_API.G_FALSE THEN
284: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
285: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPL_TO_CODE_WRONG');
286: FND_MSG_PUB.Add;
287: END IF;
288: RAISE FND_API.G_EXC_ERROR;

Line 286: FND_MSG_PUB.Add;

282: p_lookup_code => l_item_rec.applicable_to_code
283: ) = FND_API.G_FALSE THEN
284: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
285: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPL_TO_CODE_WRONG');
286: FND_MSG_PUB.Add;
287: END IF;
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290: END IF;

Line 348: FND_MSG_PUB.Count_And_Get (

344: IF FND_API.To_Boolean ( p_commit ) THEN
345: COMMIT WORK;
346: END IF;
347: --Standard call to get message count and if count=1, get the message
348: FND_MSG_PUB.Count_And_Get (
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data
352: );

Line 358: FND_MSG_PUB.Count_And_Get (

354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO Create_Item_Pub;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: -- Standard call to get message count and if count=1, get the message
358: FND_MSG_PUB.Count_And_Get (
359: p_encoded => FND_API.G_FALSE,
360: p_count => x_msg_count,
361: p_data => x_msg_data
362: );

Line 367: FND_MSG_PUB.Count_And_Get (

363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO Create_Item_Pub;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: -- Standard call to get message count and if count=1, get the message
367: FND_MSG_PUB.Count_And_Get (
368: p_encoded => FND_API.G_FALSE,
369: p_count => x_msg_count,
370: p_data => x_msg_data
371: );

Line 375: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

371: );
372: WHEN OTHERS THEN
373: ROLLBACK TO Create_Item_Pub;
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
377: END IF;
378: -- Standard call to get message count and if count=1, get the message
379: FND_MSG_PUB.Count_And_Get (

Line 376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

372: WHEN OTHERS THEN
373: ROLLBACK TO Create_Item_Pub;
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
377: END IF;
378: -- Standard call to get message count and if count=1, get the message
379: FND_MSG_PUB.Count_And_Get (
380: p_encoded => FND_API.G_FALSE,

Line 379: FND_MSG_PUB.Count_And_Get (

375: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
377: END IF;
378: -- Standard call to get message count and if count=1, get the message
379: FND_MSG_PUB.Count_And_Get (
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_msg_count,
382: p_data => x_msg_data
383: );

Line 411: FND_MSG_PUB.initialize;

407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
408: END IF;
409: --Initialize message list if p_init_msg_list is TRUE.
410: IF FND_API.To_Boolean (p_init_msg_list) THEN
411: FND_MSG_PUB.initialize;
412: END IF;
413: -- Initialize API return status to success
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415: -- Check if item id is valid.

Line 417: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

413: -- Initialize API return status to success
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415: -- Check if item id is valid.
416: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
417: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
418: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
419: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
420: FND_MSG_PUB.Add;
421: END IF;

Line 420: FND_MSG_PUB.Add;

416: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
417: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
418: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
419: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
420: FND_MSG_PUB.Add;
421: END IF;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424: -- Delete the item's authors.

Line 441: FND_MSG_PUB.Count_And_Get (

437: IF FND_API.To_Boolean ( p_commit ) THEN
438: COMMIT WORK;
439: END IF;
440: --Standard call to get message count and if count=1, get the message
441: FND_MSG_PUB.Count_And_Get (
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data
445: );

Line 451: FND_MSG_PUB.Count_And_Get (

447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448: ROLLBACK TO Delete_Item_Pub;
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: -- Standard call to get message count and if count=1, get the message
451: FND_MSG_PUB.Count_And_Get (
452: p_encoded => FND_API.G_FALSE,
453: p_count => x_msg_count,
454: p_data => x_msg_data
455: );

Line 460: FND_MSG_PUB.Count_And_Get (

456: WHEN FND_API.G_EXC_ERROR THEN
457: ROLLBACK TO Delete_Item_Pub;
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (
461: p_encoded => FND_API.G_FALSE,
462: p_count => x_msg_count,
463: p_data => x_msg_data
464: );

Line 468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

464: );
465: WHEN OTHERS THEN
466: ROLLBACK TO Delete_Item_Pub;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
469: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
470: END IF;
471: -- Standard call to get message count and if count=1, get the message
472: FND_MSG_PUB.Count_And_Get (

Line 469: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

465: WHEN OTHERS THEN
466: ROLLBACK TO Delete_Item_Pub;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
469: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
470: END IF;
471: -- Standard call to get message count and if count=1, get the message
472: FND_MSG_PUB.Count_And_Get (
473: p_encoded => FND_API.G_FALSE,

Line 472: FND_MSG_PUB.Count_And_Get (

468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
469: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
470: END IF;
471: -- Standard call to get message count and if count=1, get the message
472: FND_MSG_PUB.Count_And_Get (
473: p_encoded => FND_API.G_FALSE,
474: p_count => x_msg_count,
475: p_data => x_msg_data
476: );

Line 510: FND_MSG_PUB.initialize;

506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508: --Initialize message list if p_init_msg_list is TRUE.
509: IF FND_API.To_Boolean (p_init_msg_list) THEN
510: FND_MSG_PUB.initialize;
511: END IF;
512: -- Initialize API return status to success
513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514: -- MAKE SURE THE PASSED ITEM RECORD HAS ALL THE RIGHT INFORMATION.

Line 536: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

532: l_new_item_rec.object_version_number) THEN
533: l_new_item_rec.object_version_number :=
534: l_new_item_rec.object_version_number +1;
535: ELSE
536: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
537: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_CHANGED');
538: FND_MESSAGE.Set_Token('ID',
539: to_char(nvl(l_new_item_rec.item_id,-1)) );
540: FND_MSG_PUB.Add;

Line 540: FND_MSG_PUB.Add;

536: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
537: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_CHANGED');
538: FND_MESSAGE.Set_Token('ID',
539: to_char(nvl(l_new_item_rec.item_id,-1)) );
540: FND_MSG_PUB.Add;
541: END IF;
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
544: --Checking application id.

Line 553: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

549: ELSE
550: -- Check if application in the item object is valid
551: l_record_change_flag := true;
552: IF (Is_ApplIdValid(l_new_item_rec.application_id) <> TRUE) THEN
553: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
554: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICATIONID_INVALID');
555: FND_MESSAGE.Set_Token('ID',
556: to_char( l_new_item_rec.application_id ) );
557: FND_MSG_PUB.Add;

Line 557: FND_MSG_PUB.Add;

553: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
554: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICATIONID_INVALID');
555: FND_MESSAGE.Set_Token('ID',
556: to_char( l_new_item_rec.application_id ) );
557: FND_MSG_PUB.Add;
558: END IF;
559: RAISE FND_API.G_EXC_ERROR;
560: END IF;
561: END IF;

Line 732: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

728: IF (l_new_item_rec.application_id = G_ISTORE_APPL_ID OR
729: l_new_item_rec.application_id = FND_API.G_MISS_CHAR and
730: l_old_item_rec.application_id = G_ISTORE_APPL_ID ) THEN
731: IF (l_new_item_rec.access_name IS NULL) THEN
732: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
733: FND_MESSAGE.Set_name('JTF','JTF_AMV_ACCESS_NAME_MISSING');
734: FND_MSG_PUB.Add;
735: END IF;
736: RAISE FND_API.G_EXC_ERROR;

Line 734: FND_MSG_PUB.Add;

730: l_old_item_rec.application_id = G_ISTORE_APPL_ID ) THEN
731: IF (l_new_item_rec.access_name IS NULL) THEN
732: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
733: FND_MESSAGE.Set_name('JTF','JTF_AMV_ACCESS_NAME_MISSING');
734: FND_MSG_PUB.Add;
735: END IF;
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738: END IF;

Line 759: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

755: (
756: p_lookup_type => 'JTF_AMV_DELV_TYPE_CODE',
757: p_lookup_code => l_new_item_rec.deliverable_type_code
758: ) = FND_API.G_FALSE THEN
759: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
760: FND_MESSAGE.Set_name('JTF','JTF_AMV_TYPE_CODE_WRONG');
761: FND_MSG_PUB.Add;
762: END IF;
763: RAISE FND_API.G_EXC_ERROR;

Line 761: FND_MSG_PUB.Add;

757: p_lookup_code => l_new_item_rec.deliverable_type_code
758: ) = FND_API.G_FALSE THEN
759: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
760: FND_MESSAGE.Set_name('JTF','JTF_AMV_TYPE_CODE_WRONG');
761: FND_MSG_PUB.Add;
762: END IF;
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765: END IF;

Line 786: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

782: (
783: p_lookup_type => 'JTF_AMV_APPLI_TO_CODE',
784: p_lookup_code => l_new_item_rec.applicable_to_code
785: ) = FND_API.G_FALSE THEN
786: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
787: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPL_TO_CODE_WRONG');
788: FND_MSG_PUB.Add;
789: END IF;
790: RAISE FND_API.G_EXC_ERROR;

Line 788: FND_MSG_PUB.Add;

784: p_lookup_code => l_new_item_rec.applicable_to_code
785: ) = FND_API.G_FALSE THEN
786: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
787: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPL_TO_CODE_WRONG');
788: FND_MSG_PUB.Add;
789: END IF;
790: RAISE FND_API.G_EXC_ERROR;
791: END IF;
792: END IF;

Line 848: FND_MSG_PUB.Count_And_Get (

844: IF FND_API.To_Boolean ( p_commit ) THEN
845: COMMIT WORK;
846: END IF;
847: --Standard call to get message count and if count=1, get the message
848: FND_MSG_PUB.Count_And_Get (
849: p_encoded => FND_API.G_FALSE,
850: p_count => x_msg_count,
851: p_data => x_msg_data
852: );

Line 858: FND_MSG_PUB.Count_And_Get (

854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: ROLLBACK TO Update_Item_Pub;
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
857: -- Standard call to get message count and if count=1, get the message
858: FND_MSG_PUB.Count_And_Get (
859: p_encoded => FND_API.G_FALSE,
860: p_count => x_msg_count,
861: p_data => x_msg_data
862: );

Line 867: FND_MSG_PUB.Count_And_Get (

863: WHEN FND_API.G_EXC_ERROR THEN
864: ROLLBACK TO Update_Item_Pub;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: -- Standard call to get message count and if count=1, get the message
867: FND_MSG_PUB.Count_And_Get (
868: p_encoded => FND_API.G_FALSE,
869: p_count => x_msg_count,
870: p_data => x_msg_data
871: );

Line 875: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

871: );
872: WHEN OTHERS THEN
873: ROLLBACK TO Update_Item_Pub;
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
877: END IF;
878: -- Standard call to get message count and if count=1, get the message
879: FND_MSG_PUB.Count_And_Get (

Line 876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

872: WHEN OTHERS THEN
873: ROLLBACK TO Update_Item_Pub;
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
877: END IF;
878: -- Standard call to get message count and if count=1, get the message
879: FND_MSG_PUB.Count_And_Get (
880: p_encoded => FND_API.G_FALSE,

Line 879: FND_MSG_PUB.Count_And_Get (

875: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
877: END IF;
878: -- Standard call to get message count and if count=1, get the message
879: FND_MSG_PUB.Count_And_Get (
880: p_encoded => FND_API.G_FALSE,
881: p_count => x_msg_count,
882: p_data => x_msg_data
883: );

Line 945: FND_MSG_PUB.initialize;

941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: END IF;
943: --Initialize message list if p_init_msg_list is TRUE.
944: IF FND_API.To_Boolean (p_init_msg_list) THEN
945: FND_MSG_PUB.initialize;
946: END IF;
947: -- Initialize API return status to success
948: x_return_status := FND_API.G_RET_STS_SUCCESS;
949: -- Now get the item data.

Line 954: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

950: OPEN Get_Item_csr;
951: FETCH Get_Item_csr INTO x_item_rec;
952: IF (Get_Item_csr%NOTFOUND) THEN
953: CLOSE Get_Item_csr;
954: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
955: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
956: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
957: FND_MSG_PUB.Add;
958: END IF;

Line 957: FND_MSG_PUB.Add;

953: CLOSE Get_Item_csr;
954: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
955: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
956: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
957: FND_MSG_PUB.Add;
958: END IF;
959: RAISE FND_API.G_EXC_ERROR;
960: END IF;
961: CLOSE Get_Item_csr;

Line 963: FND_MSG_PUB.Count_And_Get (

959: RAISE FND_API.G_EXC_ERROR;
960: END IF;
961: CLOSE Get_Item_csr;
962: --Standard call to get message count and if count=1, get the message
963: FND_MSG_PUB.Count_And_Get (
964: p_encoded => FND_API.G_FALSE,
965: p_count => x_msg_count,
966: p_data => x_msg_data
967: );

Line 972: FND_MSG_PUB.Count_And_Get (

968: EXCEPTION
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
971: -- Standard call to get message count and if count=1, get the message
972: FND_MSG_PUB.Count_And_Get (
973: p_encoded => FND_API.G_FALSE,
974: p_count => x_msg_count,
975: p_data => x_msg_data
976: );

Line 980: FND_MSG_PUB.Count_And_Get (

976: );
977: WHEN FND_API.G_EXC_ERROR THEN
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: -- Standard call to get message count and if count=1, get the message
980: FND_MSG_PUB.Count_And_Get (
981: p_encoded => FND_API.G_FALSE,
982: p_count => x_msg_count,
983: p_data => x_msg_data
984: );

Line 987: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

983: p_data => x_msg_data
984: );
985: WHEN OTHERS THEN
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
988: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
989: END IF;
990: -- Standard call to get message count and if count=1, get the message
991: FND_MSG_PUB.Count_And_Get (

Line 988: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

984: );
985: WHEN OTHERS THEN
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
988: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
989: END IF;
990: -- Standard call to get message count and if count=1, get the message
991: FND_MSG_PUB.Count_And_Get (
992: p_encoded => FND_API.G_FALSE,

Line 991: FND_MSG_PUB.Count_And_Get (

987: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
988: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
989: END IF;
990: -- Standard call to get message count and if count=1, get the message
991: FND_MSG_PUB.Count_And_Get (
992: p_encoded => FND_API.G_FALSE,
993: p_count => x_msg_count,
994: p_data => x_msg_data
995: );

Line 1042: FND_MSG_PUB.initialize;

1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040: --Initialize message list if p_init_msg_list is TRUE.
1041: IF FND_API.To_Boolean (p_init_msg_list) THEN
1042: FND_MSG_PUB.initialize;
1043: END IF;
1044: -- Initialize API return status to success
1045: x_return_status := FND_API.G_RET_STS_SUCCESS;
1046: -- Check if item id is valid.

Line 1048: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1044: -- Initialize API return status to success
1045: x_return_status := FND_API.G_RET_STS_SUCCESS;
1046: -- Check if item id is valid.
1047: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1048: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1049: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1050: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1051: FND_MSG_PUB.Add;
1052: END IF;

Line 1051: FND_MSG_PUB.Add;

1047: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1048: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1049: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1050: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1051: FND_MSG_PUB.Add;
1052: END IF;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055: IF (p_keyword_tab is null) THEN

Line 1066: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1062: FETCH Check_Itemkeyword_csr INTO l_temp_number;
1063: IF (Check_Itemkeyword_csr%FOUND) THEN
1064: CLOSE Check_Itemkeyword_csr;
1065: x_return_status := FND_API.G_RET_STS_ERROR;
1066: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1067: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HAS_KEYWORD');
1068: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1069: FND_MESSAGE.Set_Token('KEYWORD', p_keyword_tab(i));
1070: FND_MSG_PUB.Add;

Line 1070: FND_MSG_PUB.Add;

1066: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1067: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HAS_KEYWORD');
1068: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1069: FND_MESSAGE.Set_Token('KEYWORD', p_keyword_tab(i));
1070: FND_MSG_PUB.Add;
1071: END IF;
1072: ELSE
1073: CLOSE Check_Itemkeyword_csr;
1074: OPEN Get_IDandDate_csr;

Line 1107: FND_MSG_PUB.Count_And_Get (

1103: IF FND_API.To_Boolean ( p_commit ) THEN
1104: COMMIT WORK;
1105: END IF;
1106: --Standard call to get message count and if count=1, get the message
1107: FND_MSG_PUB.Count_And_Get (
1108: p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data
1111: );

Line 1117: FND_MSG_PUB.Count_And_Get (

1113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1114: ROLLBACK TO Add_ItemKeyword_Pub;
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1116: -- Standard call to get message count and if count=1, get the message
1117: FND_MSG_PUB.Count_And_Get (
1118: p_encoded => FND_API.G_FALSE,
1119: p_count => x_msg_count,
1120: p_data => x_msg_data
1121: );

Line 1126: FND_MSG_PUB.Count_And_Get (

1122: WHEN FND_API.G_EXC_ERROR THEN
1123: ROLLBACK TO Add_ItemKeyword_Pub;
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: -- Standard call to get message count and if count=1, get the message
1126: FND_MSG_PUB.Count_And_Get (
1127: p_encoded => FND_API.G_FALSE,
1128: p_count => x_msg_count,
1129: p_data => x_msg_data
1130: );

Line 1134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1130: );
1131: WHEN OTHERS THEN
1132: ROLLBACK TO Add_ItemKeyword_Pub;
1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1135: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1136: END IF;
1137: -- Standard call to get message count and if count=1, get the message
1138: FND_MSG_PUB.Count_And_Get (

Line 1135: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

1131: WHEN OTHERS THEN
1132: ROLLBACK TO Add_ItemKeyword_Pub;
1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1135: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1136: END IF;
1137: -- Standard call to get message count and if count=1, get the message
1138: FND_MSG_PUB.Count_And_Get (
1139: p_encoded => FND_API.G_FALSE,

Line 1138: FND_MSG_PUB.Count_And_Get (

1134: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1135: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1136: END IF;
1137: -- Standard call to get message count and if count=1, get the message
1138: FND_MSG_PUB.Count_And_Get (
1139: p_encoded => FND_API.G_FALSE,
1140: p_count => x_msg_count,
1141: p_data => x_msg_data
1142: );

Line 1211: FND_MSG_PUB.initialize;

1207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1208: END IF;
1209: --Initialize message list if p_init_msg_list is TRUE.
1210: IF FND_API.To_Boolean (p_init_msg_list) THEN
1211: FND_MSG_PUB.initialize;
1212: END IF;
1213: -- Initialize API return status to success
1214: x_return_status := FND_API.G_RET_STS_SUCCESS;
1215: --

Line 1218: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1214: x_return_status := FND_API.G_RET_STS_SUCCESS;
1215: --
1216: -- Check if item id is valid.
1217: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1218: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1219: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1220: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1221: FND_MSG_PUB.Add;
1222: END IF;

Line 1221: FND_MSG_PUB.Add;

1217: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1218: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1219: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1220: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1221: FND_MSG_PUB.Add;
1222: END IF;
1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1225: IF (p_keyword_tab IS NOT NULL) THEN

Line 1233: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1229: FETCH Check_Itemkeyword_csr INTO l_temp_number;
1230: IF (Check_Itemkeyword_csr%NOTFOUND) THEN
1231: CLOSE Check_Itemkeyword_csr;
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1234: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HASNOT_KEYWORD');
1235: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1236: FND_MESSAGE.Set_Token('KEYWORD', p_keyword_tab(i));
1237: FND_MSG_PUB.Add;

Line 1237: FND_MSG_PUB.Add;

1233: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1234: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HASNOT_KEYWORD');
1235: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1236: FND_MESSAGE.Set_Token('KEYWORD', p_keyword_tab(i));
1237: FND_MSG_PUB.Add;
1238: END IF;
1239: ELSE
1240: CLOSE Check_Itemkeyword_csr;
1241: Delete from jtf_amv_item_keywords

Line 1255: FND_MSG_PUB.Count_And_Get (

1251: IF FND_API.To_Boolean ( p_commit ) THEN
1252: COMMIT WORK;
1253: END IF;
1254: --Standard call to get message count and if count=1, get the message
1255: FND_MSG_PUB.Count_And_Get (
1256: p_encoded => FND_API.G_FALSE,
1257: p_count => x_msg_count,
1258: p_data => x_msg_data
1259: );

Line 1265: FND_MSG_PUB.Count_And_Get (

1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1262: ROLLBACK TO Delete_ItemKeyword_Pub;
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1264: -- Standard call to get message count and if count=1, get the message
1265: FND_MSG_PUB.Count_And_Get (
1266: p_encoded => FND_API.G_FALSE,
1267: p_count => x_msg_count,
1268: p_data => x_msg_data
1269: );

Line 1274: FND_MSG_PUB.Count_And_Get (

1270: WHEN FND_API.G_EXC_ERROR THEN
1271: ROLLBACK TO Delete_ItemKeyword_Pub;
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: -- Standard call to get message count and if count=1, get the message
1274: FND_MSG_PUB.Count_And_Get (
1275: p_encoded => FND_API.G_FALSE,
1276: p_count => x_msg_count,
1277: p_data => x_msg_data
1278: );

Line 1282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1278: );
1279: WHEN OTHERS THEN
1280: ROLLBACK TO Delete_ItemKeyword_Pub;
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1284: END IF;
1285: -- Standard call to get message count and if count=1, get the message
1286: FND_MSG_PUB.Count_And_Get (

Line 1283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1279: WHEN OTHERS THEN
1280: ROLLBACK TO Delete_ItemKeyword_Pub;
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1284: END IF;
1285: -- Standard call to get message count and if count=1, get the message
1286: FND_MSG_PUB.Count_And_Get (
1287: p_encoded => FND_API.G_FALSE,

Line 1286: FND_MSG_PUB.Count_And_Get (

1282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1284: END IF;
1285: -- Standard call to get message count and if count=1, get the message
1286: FND_MSG_PUB.Count_And_Get (
1287: p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => x_msg_data
1290: );

Line 1353: FND_MSG_PUB.initialize;

1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1350: END IF;
1351: --Initialize message list if p_init_msg_list is TRUE.
1352: IF FND_API.To_Boolean (p_init_msg_list) THEN
1353: FND_MSG_PUB.initialize;
1354: END IF;
1355: -- Initialize API return status to success
1356: x_return_status := FND_API.G_RET_STS_SUCCESS;
1357: -- Check if item id is valid.

Line 1359: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1355: -- Initialize API return status to success
1356: x_return_status := FND_API.G_RET_STS_SUCCESS;
1357: -- Check if item id is valid.
1358: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1359: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1360: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1361: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1362: FND_MSG_PUB.Add;
1363: END IF;

Line 1362: FND_MSG_PUB.Add;

1358: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1359: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1360: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1361: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1362: FND_MSG_PUB.Add;
1363: END IF;
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366: -- Delete all the item's original keyword

Line 1387: FND_MSG_PUB.Count_And_Get (

1383: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR) THEN
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386: --Standard call to get message count and if count=1, get the message
1387: FND_MSG_PUB.Count_And_Get (
1388: p_encoded => FND_API.G_FALSE,
1389: p_count => x_msg_count,
1390: p_data => x_msg_data
1391: );

Line 1397: FND_MSG_PUB.Count_And_Get (

1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1394: ROLLBACK TO Replace_ItemKeyword_Pub;
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396: -- Standard call to get message count and if count=1, get the message
1397: FND_MSG_PUB.Count_And_Get (
1398: p_encoded => FND_API.G_FALSE,
1399: p_count => x_msg_count,
1400: p_data => x_msg_data
1401: );

Line 1406: FND_MSG_PUB.Count_And_Get (

1402: WHEN FND_API.G_EXC_ERROR THEN
1403: ROLLBACK TO Replace_ItemKeyword_Pub;
1404: x_return_status := FND_API.G_RET_STS_ERROR;
1405: -- Standard call to get message count and if count=1, get the message
1406: FND_MSG_PUB.Count_And_Get (
1407: p_encoded => FND_API.G_FALSE,
1408: p_count => x_msg_count,
1409: p_data => x_msg_data
1410: );

Line 1414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1410: );
1411: WHEN OTHERS THEN
1412: ROLLBACK TO Replace_ItemKeyword_Pub;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1415: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1416: END IF;
1417: -- Standard call to get message count and if count=1, get the message
1418: FND_MSG_PUB.Count_And_Get (

Line 1415: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

1411: WHEN OTHERS THEN
1412: ROLLBACK TO Replace_ItemKeyword_Pub;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1415: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1416: END IF;
1417: -- Standard call to get message count and if count=1, get the message
1418: FND_MSG_PUB.Count_And_Get (
1419: p_encoded => FND_API.G_FALSE,

Line 1418: FND_MSG_PUB.Count_And_Get (

1414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1415: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1416: END IF;
1417: -- Standard call to get message count and if count=1, get the message
1418: FND_MSG_PUB.Count_And_Get (
1419: p_encoded => FND_API.G_FALSE,
1420: p_count => x_msg_count,
1421: p_data => x_msg_data
1422: );

Line 1456: FND_MSG_PUB.initialize;

1452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1453: END IF;
1454: --Initialize message list if p_init_msg_list is TRUE.
1455: IF FND_API.To_Boolean (p_init_msg_list) THEN
1456: FND_MSG_PUB.initialize;
1457: END IF;
1458: -- Initialize API return status to success
1459: x_return_status := FND_API.G_RET_STS_SUCCESS;
1460: -- Check if item id is valid.

Line 1462: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1458: -- Initialize API return status to success
1459: x_return_status := FND_API.G_RET_STS_SUCCESS;
1460: -- Check if item id is valid.
1461: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1462: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1463: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1464: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1465: FND_MSG_PUB.Add;
1466: END IF;

Line 1465: FND_MSG_PUB.Add;

1461: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1462: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1463: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1464: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1465: FND_MSG_PUB.Add;
1466: END IF;
1467: RAISE FND_API.G_EXC_ERROR;
1468: END IF;
1469: --Execute the SQL statements to get records

Line 1477: FND_MSG_PUB.Count_And_Get (

1473: x_keyword_tab.extend;
1474: x_keyword_tab(l_fetch_count) := kword.keyword;
1475: END LOOP;
1476: --Standard call to get message count and if count=1, get the message
1477: FND_MSG_PUB.Count_And_Get (
1478: p_encoded => FND_API.G_FALSE,
1479: p_count => x_msg_count,
1480: p_data => x_msg_data
1481: );

Line 1486: FND_MSG_PUB.Count_And_Get (

1482: EXCEPTION
1483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: -- Standard call to get message count and if count=1, get the message
1486: FND_MSG_PUB.Count_And_Get (
1487: p_encoded => FND_API.G_FALSE,
1488: p_count => x_msg_count,
1489: p_data => x_msg_data
1490: );

Line 1494: FND_MSG_PUB.Count_And_Get (

1490: );
1491: WHEN FND_API.G_EXC_ERROR THEN
1492: x_return_status := FND_API.G_RET_STS_ERROR;
1493: -- Standard call to get message count and if count=1, get the message
1494: FND_MSG_PUB.Count_And_Get (
1495: p_encoded => FND_API.G_FALSE,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data
1498: );

Line 1501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1497: p_data => x_msg_data
1498: );
1499: WHEN OTHERS THEN
1500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1503: END IF;
1504: -- Standard call to get message count and if count=1, get the message
1505: FND_MSG_PUB.Count_And_Get (

Line 1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1498: );
1499: WHEN OTHERS THEN
1500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1503: END IF;
1504: -- Standard call to get message count and if count=1, get the message
1505: FND_MSG_PUB.Count_And_Get (
1506: p_encoded => FND_API.G_FALSE,

Line 1505: FND_MSG_PUB.Count_And_Get (

1501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1503: END IF;
1504: -- Standard call to get message count and if count=1, get the message
1505: FND_MSG_PUB.Count_And_Get (
1506: p_encoded => FND_API.G_FALSE,
1507: p_count => x_msg_count,
1508: p_data => x_msg_data
1509: );

Line 1556: FND_MSG_PUB.initialize;

1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1553: END IF;
1554: --Initialize message list if p_init_msg_list is TRUE.
1555: IF FND_API.To_Boolean (p_init_msg_list) THEN
1556: FND_MSG_PUB.initialize;
1557: END IF;
1558: -- Initialize API return status to success
1559: x_return_status := FND_API.G_RET_STS_SUCCESS;
1560: -- Check if item id is valid.

Line 1562: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1558: -- Initialize API return status to success
1559: x_return_status := FND_API.G_RET_STS_SUCCESS;
1560: -- Check if item id is valid.
1561: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1562: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1563: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1564: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1565: FND_MSG_PUB.Add;
1566: END IF;

Line 1565: FND_MSG_PUB.Add;

1561: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1562: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1563: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1564: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1565: FND_MSG_PUB.Add;
1566: END IF;
1567: RAISE FND_API.G_EXC_ERROR;
1568: END IF;
1569: IF (p_author_tab is null) THEN

Line 1580: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1576: FETCH Check_Itemauthor_csr INTO l_temp_number;
1577: IF (Check_Itemauthor_csr%FOUND) THEN
1578: CLOSE Check_Itemauthor_csr;
1579: x_return_status := FND_API.G_RET_STS_ERROR;
1580: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1581: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HAS_AUTHOR');
1582: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1583: FND_MESSAGE.Set_Token('AUTHOR', p_author_tab(i));
1584: FND_MSG_PUB.Add;

Line 1584: FND_MSG_PUB.Add;

1580: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1581: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HAS_AUTHOR');
1582: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1583: FND_MESSAGE.Set_Token('AUTHOR', p_author_tab(i));
1584: FND_MSG_PUB.Add;
1585: END IF;
1586: ELSE
1587: CLOSE Check_Itemauthor_csr;
1588: OPEN Get_IDandDate_csr;

Line 1621: FND_MSG_PUB.Count_And_Get (

1617: IF FND_API.To_Boolean ( p_commit ) THEN
1618: COMMIT WORK;
1619: END IF;
1620: --Standard call to get message count and if count=1, get the message
1621: FND_MSG_PUB.Count_And_Get (
1622: p_encoded => FND_API.G_FALSE,
1623: p_count => x_msg_count,
1624: p_data => x_msg_data
1625: );

Line 1631: FND_MSG_PUB.Count_And_Get (

1627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1628: ROLLBACK TO Add_ItemAuthor_Pub;
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: -- Standard call to get message count and if count=1, get the message
1631: FND_MSG_PUB.Count_And_Get (
1632: p_encoded => FND_API.G_FALSE,
1633: p_count => x_msg_count,
1634: p_data => x_msg_data
1635: );

Line 1640: FND_MSG_PUB.Count_And_Get (

1636: WHEN FND_API.G_EXC_ERROR THEN
1637: ROLLBACK TO Add_ItemAuthor_Pub;
1638: x_return_status := FND_API.G_RET_STS_ERROR;
1639: -- Standard call to get message count and if count=1, get the message
1640: FND_MSG_PUB.Count_And_Get (
1641: p_encoded => FND_API.G_FALSE,
1642: p_count => x_msg_count,
1643: p_data => x_msg_data
1644: );

Line 1648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1644: );
1645: WHEN OTHERS THEN
1646: ROLLBACK TO Add_ItemAuthor_Pub;
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1649: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1650: END IF;
1651: -- Standard call to get message count and if count=1, get the message
1652: FND_MSG_PUB.Count_And_Get (

Line 1649: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

1645: WHEN OTHERS THEN
1646: ROLLBACK TO Add_ItemAuthor_Pub;
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1649: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1650: END IF;
1651: -- Standard call to get message count and if count=1, get the message
1652: FND_MSG_PUB.Count_And_Get (
1653: p_encoded => FND_API.G_FALSE,

Line 1652: FND_MSG_PUB.Count_And_Get (

1648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1649: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1650: END IF;
1651: -- Standard call to get message count and if count=1, get the message
1652: FND_MSG_PUB.Count_And_Get (
1653: p_encoded => FND_API.G_FALSE,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data
1656: );

Line 1723: FND_MSG_PUB.initialize;

1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1720: END IF;
1721: --Initialize message list if p_init_msg_list is TRUE.
1722: IF FND_API.To_Boolean (p_init_msg_list) THEN
1723: FND_MSG_PUB.initialize;
1724: END IF;
1725: -- Initialize API return status to success
1726: x_return_status := FND_API.G_RET_STS_SUCCESS;
1727: --

Line 1730: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1726: x_return_status := FND_API.G_RET_STS_SUCCESS;
1727: --
1728: -- Check if item id is valid.
1729: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1730: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1731: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1732: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1733: FND_MSG_PUB.Add;
1734: END IF;

Line 1733: FND_MSG_PUB.Add;

1729: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1730: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1731: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1732: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1733: FND_MSG_PUB.Add;
1734: END IF;
1735: RAISE FND_API.G_EXC_ERROR;
1736: END IF;
1737: IF (p_author_tab IS NOT NULL) THEN

Line 1745: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1741: FETCH Check_Itemauthor_csr INTO l_temp_number;
1742: IF (Check_Itemauthor_csr%NOTFOUND) THEN
1743: CLOSE Check_Itemauthor_csr;
1744: x_return_status := FND_API.G_RET_STS_ERROR;
1745: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1746: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HASNOT_AUTHOR');
1747: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1748: FND_MESSAGE.Set_Token('AUTHOR', p_author_tab(i));
1749: FND_MSG_PUB.Add;

Line 1749: FND_MSG_PUB.Add;

1745: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1746: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HASNOT_AUTHOR');
1747: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1748: FND_MESSAGE.Set_Token('AUTHOR', p_author_tab(i));
1749: FND_MSG_PUB.Add;
1750: END IF;
1751: ELSE
1752: CLOSE Check_Itemauthor_csr;
1753: Delete from jtf_amv_item_authors

Line 1767: FND_MSG_PUB.Count_And_Get (

1763: IF FND_API.To_Boolean ( p_commit ) THEN
1764: COMMIT WORK;
1765: END IF;
1766: --Standard call to get message count and if count=1, get the message
1767: FND_MSG_PUB.Count_And_Get (
1768: p_encoded => FND_API.G_FALSE,
1769: p_count => x_msg_count,
1770: p_data => x_msg_data
1771: );

Line 1777: FND_MSG_PUB.Count_And_Get (

1773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1774: ROLLBACK TO Delete_ItemAuthor_Pub;
1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1776: -- Standard call to get message count and if count=1, get the message
1777: FND_MSG_PUB.Count_And_Get (
1778: p_encoded => FND_API.G_FALSE,
1779: p_count => x_msg_count,
1780: p_data => x_msg_data
1781: );

Line 1786: FND_MSG_PUB.Count_And_Get (

1782: WHEN FND_API.G_EXC_ERROR THEN
1783: ROLLBACK TO Delete_ItemAuthor_Pub;
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: -- Standard call to get message count and if count=1, get the message
1786: FND_MSG_PUB.Count_And_Get (
1787: p_encoded => FND_API.G_FALSE,
1788: p_count => x_msg_count,
1789: p_data => x_msg_data
1790: );

Line 1794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1790: );
1791: WHEN OTHERS THEN
1792: ROLLBACK TO Delete_ItemAuthor_Pub;
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1795: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1796: END IF;
1797: -- Standard call to get message count and if count=1, get the message
1798: FND_MSG_PUB.Count_And_Get (

Line 1795: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1791: WHEN OTHERS THEN
1792: ROLLBACK TO Delete_ItemAuthor_Pub;
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1795: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1796: END IF;
1797: -- Standard call to get message count and if count=1, get the message
1798: FND_MSG_PUB.Count_And_Get (
1799: p_encoded => FND_API.G_FALSE,

Line 1798: FND_MSG_PUB.Count_And_Get (

1794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1795: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1796: END IF;
1797: -- Standard call to get message count and if count=1, get the message
1798: FND_MSG_PUB.Count_And_Get (
1799: p_encoded => FND_API.G_FALSE,
1800: p_count => x_msg_count,
1801: p_data => x_msg_data
1802: );

Line 1865: FND_MSG_PUB.initialize;

1861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1862: END IF;
1863: --Initialize message list if p_init_msg_list is TRUE.
1864: IF FND_API.To_Boolean (p_init_msg_list) THEN
1865: FND_MSG_PUB.initialize;
1866: END IF;
1867: -- Initialize API return status to success
1868: x_return_status := FND_API.G_RET_STS_SUCCESS;
1869: -- Check if item id is valid.

Line 1871: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1867: -- Initialize API return status to success
1868: x_return_status := FND_API.G_RET_STS_SUCCESS;
1869: -- Check if item id is valid.
1870: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1871: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1872: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1873: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1874: FND_MSG_PUB.Add;
1875: END IF;

Line 1874: FND_MSG_PUB.Add;

1870: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1871: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1872: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1873: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1874: FND_MSG_PUB.Add;
1875: END IF;
1876: RAISE FND_API.G_EXC_ERROR;
1877: END IF;
1878: -- Delete all the item's original author

Line 1894: FND_MSG_PUB.Count_And_Get (

1890: p_item_id => p_item_id,
1891: p_author_tab => p_author_tab
1892: );
1893: --Standard call to get message count and if count=1, get the message
1894: FND_MSG_PUB.Count_And_Get (
1895: p_encoded => FND_API.G_FALSE,
1896: p_count => x_msg_count,
1897: p_data => x_msg_data
1898: );

Line 1904: FND_MSG_PUB.Count_And_Get (

1900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1901: ROLLBACK TO Replace_ItemAuthor_Pub;
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1903: -- Standard call to get message count and if count=1, get the message
1904: FND_MSG_PUB.Count_And_Get (
1905: p_encoded => FND_API.G_FALSE,
1906: p_count => x_msg_count,
1907: p_data => x_msg_data
1908: );

Line 1913: FND_MSG_PUB.Count_And_Get (

1909: WHEN FND_API.G_EXC_ERROR THEN
1910: ROLLBACK TO Replace_ItemAuthor_Pub;
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: -- Standard call to get message count and if count=1, get the message
1913: FND_MSG_PUB.Count_And_Get (
1914: p_encoded => FND_API.G_FALSE,
1915: p_count => x_msg_count,
1916: p_data => x_msg_data
1917: );

Line 1921: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1917: );
1918: WHEN OTHERS THEN
1919: ROLLBACK TO Replace_ItemAuthor_Pub;
1920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1921: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1922: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1923: END IF;
1924: -- Standard call to get message count and if count=1, get the message
1925: FND_MSG_PUB.Count_And_Get (

Line 1922: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

1918: WHEN OTHERS THEN
1919: ROLLBACK TO Replace_ItemAuthor_Pub;
1920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1921: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1922: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1923: END IF;
1924: -- Standard call to get message count and if count=1, get the message
1925: FND_MSG_PUB.Count_And_Get (
1926: p_encoded => FND_API.G_FALSE,

Line 1925: FND_MSG_PUB.Count_And_Get (

1921: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1922: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1923: END IF;
1924: -- Standard call to get message count and if count=1, get the message
1925: FND_MSG_PUB.Count_And_Get (
1926: p_encoded => FND_API.G_FALSE,
1927: p_count => x_msg_count,
1928: p_data => x_msg_data
1929: );

Line 1963: FND_MSG_PUB.initialize;

1959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1960: END IF;
1961: --Initialize message list if p_init_msg_list is TRUE.
1962: IF FND_API.To_Boolean (p_init_msg_list) THEN
1963: FND_MSG_PUB.initialize;
1964: END IF;
1965: -- Initialize API return status to success
1966: x_return_status := FND_API.G_RET_STS_SUCCESS;
1967: -- Check if item id is valid.

Line 1969: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1965: -- Initialize API return status to success
1966: x_return_status := FND_API.G_RET_STS_SUCCESS;
1967: -- Check if item id is valid.
1968: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1969: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1970: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1971: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1972: FND_MSG_PUB.Add;
1973: END IF;

Line 1972: FND_MSG_PUB.Add;

1968: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1969: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1970: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1971: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1972: FND_MSG_PUB.Add;
1973: END IF;
1974: RAISE FND_API.G_EXC_ERROR;
1975: END IF;
1976: --Execute the SQL statements to get records

Line 1984: FND_MSG_PUB.Count_And_Get (

1980: x_author_tab.extend;
1981: x_author_tab(l_fetch_count) := rec.author;
1982: END LOOP;
1983: --Standard call to get message count and if count=1, get the message
1984: FND_MSG_PUB.Count_And_Get (
1985: p_encoded => FND_API.G_FALSE,
1986: p_count => x_msg_count,
1987: p_data => x_msg_data
1988: );

Line 1993: FND_MSG_PUB.Count_And_Get (

1989: EXCEPTION
1990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1992: -- Standard call to get message count and if count=1, get the message
1993: FND_MSG_PUB.Count_And_Get (
1994: p_encoded => FND_API.G_FALSE,
1995: p_count => x_msg_count,
1996: p_data => x_msg_data
1997: );

Line 2001: FND_MSG_PUB.Count_And_Get (

1997: );
1998: WHEN FND_API.G_EXC_ERROR THEN
1999: x_return_status := FND_API.G_RET_STS_ERROR;
2000: -- Standard call to get message count and if count=1, get the message
2001: FND_MSG_PUB.Count_And_Get (
2002: p_encoded => FND_API.G_FALSE,
2003: p_count => x_msg_count,
2004: p_data => x_msg_data
2005: );

Line 2008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2004: p_data => x_msg_data
2005: );
2006: WHEN OTHERS THEN
2007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2009: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2010: END IF;
2011: -- Standard call to get message count and if count=1, get the message
2012: FND_MSG_PUB.Count_And_Get (

Line 2009: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2005: );
2006: WHEN OTHERS THEN
2007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2009: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2010: END IF;
2011: -- Standard call to get message count and if count=1, get the message
2012: FND_MSG_PUB.Count_And_Get (
2013: p_encoded => FND_API.G_FALSE,

Line 2012: FND_MSG_PUB.Count_And_Get (

2008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2009: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2010: END IF;
2011: -- Standard call to get message count and if count=1, get the message
2012: FND_MSG_PUB.Count_And_Get (
2013: p_encoded => FND_API.G_FALSE,
2014: p_count => x_msg_count,
2015: p_data => x_msg_data
2016: );