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.JTF_TERR_CNR_GROUPS_PVT dependencies on FND_MSG_PUB

Line 95: FND_MSG_PUB.initialize;

91: END IF;
92:
93: -- Initialize message list if p_init_msg_list is set to TRUE.
94: IF FND_API.to_Boolean( p_init_msg_list ) THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97:
98: -- Debug Message
99: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 99: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

95: FND_MSG_PUB.initialize;
96: END IF;
97:
98: -- Debug Message
99: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
100: THEN
101: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
102: fnd_message.set_name ('PROC_NAME', l_api_name);
103: FND_MSG_PUB.Add;

Line 103: FND_MSG_PUB.Add;

99: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
100: THEN
101: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
102: fnd_message.set_name ('PROC_NAME', l_api_name);
103: FND_MSG_PUB.Add;
104: END IF;
105:
106: -- Initialize API return status to success
107: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

114:
115: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL)
116: THEN
117: -- Debug message
118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
119: THEN
120: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_GROUP_VALIDATE_MSG');
121: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');
122: FND_MSG_PUB.Add;

Line 122: FND_MSG_PUB.Add;

118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
119: THEN
120: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_GROUP_VALIDATE_MSG');
121: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');
122: FND_MSG_PUB.Add;
123: END IF;
124:
125: -- Invoke validation procedures
126: Validate_Cnr_Group_Value_Rec(p_init_msg_list => FND_API.G_FALSE,

Line 172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

168: x_Terr_cnr_group_out_rec.cnr_group_id := l_terr_cnr_group_Id;
169: --l_Terr_cnr_group_out_rec.cnr_group_id := l_terr_cnr_group_Id;
170:
171: -- Debug Message
172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
173: THEN
174: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
175: fnd_message.set_name ('PROC_NAME', l_api_name);
176: FND_MSG_PUB.Add;

Line 176: FND_MSG_PUB.Add;

172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
173: THEN
174: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
175: fnd_message.set_name ('PROC_NAME', l_api_name);
176: FND_MSG_PUB.Add;
177: END IF;
178:
179:
180: FND_MSG_PUB.Count_And_Get

Line 180: FND_MSG_PUB.Count_And_Get

176: FND_MSG_PUB.Add;
177: END IF;
178:
179:
180: FND_MSG_PUB.Count_And_Get
181: ( p_count => x_msg_count,
182: p_data => x_msg_data
183: );
184:

Line 198: FND_MSG_PUB.Count_And_Get

194: WHEN FND_API.G_EXC_ERROR THEN
195: --dbms_output.put_line('Create_Terr_Cnr_Group PVT: FND_API.G_EXC_ERROR');
196: ROLLBACK TO CREATE_CNR_GROUP_PVT;
197: x_return_status := FND_API.G_RET_STS_ERROR ;
198: FND_MSG_PUB.Count_And_Get
199: ( p_count => x_msg_count,
200: p_data => x_msg_data
201: );
202:

Line 207: FND_MSG_PUB.Count_And_Get

203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: --dbms_output.put_line('Create_Terr_Cnr_Group PVT: FND_API.G_EXC_UNEXPECTED_ERROR');
205: ROLLBACK TO CREATE_CNR_GROUP_PVT;
206: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: FND_MSG_PUB.Count_And_Get
208: ( p_count => x_msg_count,
209: p_data => x_msg_data
210: );
211:

Line 216: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

212: WHEN OTHERS THEN
213: --dbms_output.put_line('Create_Terr_Cnr_Group PVT: OTHERS - ' || SQLERRM);
214: ROLLBACK TO CREATE_CNR_GROUP_PVT;
215: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
217: THEN
218: fnd_msg_pub.add_exc_msg (
219: g_pkg_name,
220: 'Error inside Create_Terr_Cnr_Group ' || sqlerrm);

Line 218: fnd_msg_pub.add_exc_msg (

214: ROLLBACK TO CREATE_CNR_GROUP_PVT;
215: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
217: THEN
218: fnd_msg_pub.add_exc_msg (
219: g_pkg_name,
220: 'Error inside Create_Terr_Cnr_Group ' || sqlerrm);
221: END IF;
222: --

Line 278: FND_MSG_PUB.initialize;

274: END IF;
275:
276: -- Initialize message list if p_init_msg_list is set to TRUE.
277: IF FND_API.to_Boolean( p_init_msg_list ) THEN
278: FND_MSG_PUB.initialize;
279: END IF;
280:
281: -- Debug Message
282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

278: FND_MSG_PUB.initialize;
279: END IF;
280:
281: -- Debug Message
282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
283: THEN
284: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
285: fnd_message.set_name ('PROC_NAME', l_api_name);
286: FND_MSG_PUB.Add;

Line 286: FND_MSG_PUB.Add;

282: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
283: THEN
284: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
285: fnd_message.set_name ('PROC_NAME', l_api_name);
286: FND_MSG_PUB.Add;
287: END IF;
288:
289: -- Initialize API return status to success
290: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 301: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

297: -- ******************************************************************
298: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL)
299: THEN
300: -- Debug message
301: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
302: THEN
303: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_GROUP_VALIDATE_MSG');
304: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');
305: FND_MSG_PUB.Add;

Line 305: FND_MSG_PUB.Add;

301: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
302: THEN
303: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_GROUP_VALIDATE_MSG');
304: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');
305: FND_MSG_PUB.Add;
306: END IF;
307:
308: -- Invoke validation procedures
309: Validate_Cnr_Group_Value_Rec(p_init_msg_list => FND_API.G_FALSE,

Line 330: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

326: from JTF_TERR_CNR_GROUP_VALUES jt
327: where jt.cnr_group_id = p_Terr_cnr_group_rec.cnr_group_id;
328:
329: -- Debug Message
330: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
331: THEN
332: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
333: fnd_message.set_name ('PROC_NAME', l_api_name);
334: FND_MSG_PUB.Add;

Line 334: FND_MSG_PUB.Add;

330: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
331: THEN
332: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
333: fnd_message.set_name ('PROC_NAME', l_api_name);
334: FND_MSG_PUB.Add;
335: END IF;
336:
337:
338: FND_MSG_PUB.Count_And_Get

Line 338: FND_MSG_PUB.Count_And_Get

334: FND_MSG_PUB.Add;
335: END IF;
336:
337:
338: FND_MSG_PUB.Count_And_Get
339: ( p_count => x_msg_count,
340: p_data => x_msg_data
341: );
342:

Line 354: FND_MSG_PUB.Count_And_Get

350: --
351: WHEN FND_API.G_EXC_ERROR THEN
352: ROLLBACK TO DELETE_CNR_GROUP_PVT;
353: x_return_status := FND_API.G_RET_STS_ERROR ;
354: FND_MSG_PUB.Count_And_Get
355: ( p_count => x_msg_count,
356: p_data => x_msg_data
357: );
358:

Line 362: FND_MSG_PUB.Count_And_Get

358:
359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
360: ROLLBACK TO DELETE_CNR_GROUP_PVT;
361: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: FND_MSG_PUB.Count_And_Get
363: ( p_count => x_msg_count,
364: p_data => x_msg_data
365: );
366:

Line 370: FND_MSG_PUB.Count_And_Get

366:
367: WHEN OTHERS THEN
368: ROLLBACK TO DELETE_CNR_GROUP_PVT;
369: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: FND_MSG_PUB.Count_And_Get
371: ( p_count => x_msg_count,
372: p_data => x_msg_data
373: );
374: --

Line 429: FND_MSG_PUB.initialize;

425: END IF;
426:
427: -- Initialize message list if p_init_msg_list is set to TRUE.
428: IF FND_API.to_Boolean( p_init_msg_list ) THEN
429: FND_MSG_PUB.initialize;
430: END IF;
431:
432: -- Debug Message
433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

429: FND_MSG_PUB.initialize;
430: END IF;
431:
432: -- Debug Message
433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
434: THEN
435: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
436: fnd_message.set_name ('PROC_NAME', l_api_name);
437: FND_MSG_PUB.Add;

Line 437: FND_MSG_PUB.Add;

433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
434: THEN
435: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
436: fnd_message.set_name ('PROC_NAME', l_api_name);
437: FND_MSG_PUB.Add;
438: END IF;
439:
440:
441: -- Initialize API return status to success

Line 452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

448: -- ******************************************************************
449: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL)
450: THEN
451: -- Debug message
452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
453: THEN
454: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_GROUP_VALIDATE_MSG');
455: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');
456: FND_MSG_PUB.Add;

Line 456: FND_MSG_PUB.Add;

452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
453: THEN
454: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_GROUP_VALIDATE_MSG');
455: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');
456: FND_MSG_PUB.Add;
457: END IF;
458:
459: -- Invoke validation procedures
460: Validate_Cnr_Group_Value_Rec(p_init_msg_list => FND_API.G_FALSE,

Line 507: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

503: -- set cnr_group_id for later use
504: x_Terr_cnr_group_out_rec.cnr_group_id := l_terr_cnr_group_Id;
505:
506: -- Debug Message
507: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
508: THEN
509: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
510: fnd_message.set_name ('PROC_NAME', l_api_name);
511: FND_MSG_PUB.Add;

Line 511: FND_MSG_PUB.Add;

507: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
508: THEN
509: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
510: fnd_message.set_name ('PROC_NAME', l_api_name);
511: FND_MSG_PUB.Add;
512: END IF;
513:
514:
515: FND_MSG_PUB.Count_And_Get

Line 515: FND_MSG_PUB.Count_And_Get

511: FND_MSG_PUB.Add;
512: END IF;
513:
514:
515: FND_MSG_PUB.Count_And_Get
516: ( p_count => x_msg_count,
517: p_data => x_msg_data
518: );
519:

Line 531: FND_MSG_PUB.Count_And_Get

527: --
528: WHEN FND_API.G_EXC_ERROR THEN
529: ROLLBACK TO UPDATE_CNR_GROUP_PVT;
530: x_return_status := FND_API.G_RET_STS_ERROR ;
531: FND_MSG_PUB.Count_And_Get
532: ( p_count => x_msg_count,
533: p_data => x_msg_data
534: );
535:

Line 539: FND_MSG_PUB.Count_And_Get

535:
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: ROLLBACK TO UPDATE_CNR_GROUP_PVT;
538: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: FND_MSG_PUB.Count_And_Get
540: ( p_count => x_msg_count,
541: p_data => x_msg_data
542: );
543:

Line 547: FND_MSG_PUB.Count_And_Get

543:
544: WHEN OTHERS THEN
545: ROLLBACK TO UPDATE_CNR_GROUP_PVT;
546: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: FND_MSG_PUB.Count_And_Get
548: ( p_count => x_msg_count,
549: p_data => x_msg_data
550: );
551: --

Line 624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

620: FETCH c_cnrgroupid INTO l_cnr_child_num;
621:
622: IF (c_cnrgroupid%FOUND) OR (c_qualifier_defined%FOUND) THEN
623: --dbms_output.put_line('c_cnrgroupid%FOUND');
624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
625: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_CNR_HAS_FKREL');
626: FND_MESSAGE.Set_Token('COL_NAME', 'CNR_GROUP_ID' );
627: FND_MSG_PUB.ADD;
628: END IF;

Line 627: FND_MSG_PUB.ADD;

623: --dbms_output.put_line('c_cnrgroupid%FOUND');
624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
625: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_CNR_HAS_FKREL');
626: FND_MESSAGE.Set_Token('COL_NAME', 'CNR_GROUP_ID' );
627: FND_MSG_PUB.ADD;
628: END IF;
629: x_Return_Status := FND_API.G_RET_STS_ERROR ;
630: END IF;
631: CLOSE c_cnrgroupid;

Line 639: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

635: --dbms_output.put_line('INSERT,UPDATE');
636: --Check created by
637: IF ( p_Terr_cnr_group_rec.CREATED_BY is NULL OR
638: p_Terr_cnr_group_rec.CREATED_BY = FND_API.G_MISS_NUM ) THEN
639: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
640: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
641: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );
642: FND_MSG_PUB.ADD;
643: END IF;

Line 642: FND_MSG_PUB.ADD;

638: p_Terr_cnr_group_rec.CREATED_BY = FND_API.G_MISS_NUM ) THEN
639: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
640: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
641: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );
642: FND_MSG_PUB.ADD;
643: END IF;
644: x_Return_Status := FND_API.G_RET_STS_ERROR ;
645: End If;
646:

Line 650: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

646:
647: --Check creation date
648: If ( p_Terr_cnr_group_rec.CREATION_DATE is NULL OR
649: p_Terr_cnr_group_rec.CREATION_DATE = FND_API.G_MISS_DATE ) THEN
650: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
651: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
652: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );
653: FND_MSG_PUB.ADD;
654: END IF;

Line 653: FND_MSG_PUB.ADD;

649: p_Terr_cnr_group_rec.CREATION_DATE = FND_API.G_MISS_DATE ) THEN
650: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
651: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
652: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );
653: FND_MSG_PUB.ADD;
654: END IF;
655: x_Return_Status := FND_API.G_RET_STS_ERROR ;
656: End If;
657:

Line 661: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

657:
658: -- Validate last updated by
659: IF ( p_Terr_cnr_group_rec.LAST_UPDATED_BY is NULL OR
660: p_Terr_cnr_group_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) THEN
661: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
662: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
663: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
664: FND_MSG_PUB.ADD;
665: END IF;

Line 664: FND_MSG_PUB.ADD;

660: p_Terr_cnr_group_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) THEN
661: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
662: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
663: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
664: FND_MSG_PUB.ADD;
665: END IF;
666: x_Return_Status := FND_API.G_RET_STS_ERROR ;
667: End If;
668:

Line 672: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

668:
669: -- Check last update date
670: If ( p_Terr_cnr_group_rec.LAST_UPDATE_DATE IS NULL OR
671: p_Terr_cnr_group_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
672: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
673: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
674: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
675: FND_MSG_PUB.ADD;
676: END IF;

Line 675: FND_MSG_PUB.ADD;

671: p_Terr_cnr_group_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
672: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
673: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
674: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
675: FND_MSG_PUB.ADD;
676: END IF;
677: x_Return_Status := FND_API.G_RET_STS_ERROR ;
678: End If;
679:

Line 683: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

679:
680: --Check last update login
681: If ( p_Terr_cnr_group_rec.LAST_UPDATE_LOGIN is NULL OR
682: p_Terr_cnr_group_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
683: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
684: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
685: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
686: FND_MSG_PUB.ADD;
687: END IF;

Line 686: FND_MSG_PUB.ADD;

682: p_Terr_cnr_group_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
683: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
684: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
685: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
686: FND_MSG_PUB.ADD;
687: END IF;
688: x_Return_Status := FND_API.G_RET_STS_ERROR ;
689: End If;
690:

Line 694: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

690:
691: --Check CNR group name
692: If ( p_Terr_cnr_group_rec.NAME is NULL OR
693: p_Terr_cnr_group_rec.NAME = FND_API.G_MISS_CHAR ) THEN
694: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
695: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
696: FND_MESSAGE.Set_Token('COL_NAME', 'NAME' );
697: FND_MSG_PUB.ADD;
698: END IF;

Line 697: FND_MSG_PUB.ADD;

693: p_Terr_cnr_group_rec.NAME = FND_API.G_MISS_CHAR ) THEN
694: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
695: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
696: FND_MESSAGE.Set_Token('COL_NAME', 'NAME' );
697: FND_MSG_PUB.ADD;
698: END IF;
699: x_Return_Status := FND_API.G_RET_STS_ERROR ;
700: End If;
701:

Line 710: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

706: FETCH c_cnrgroupname INTO l_cnr_group_num;
707:
708: IF c_cnrgroupname%FOUND THEN
709: --dbms_output.put_line('c_cnrgroupname%FOUND');
710: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
711: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_CNR_DUPLICATE_NAME');
712: FND_MESSAGE.Set_Token('COL_NAME', 'NAME' );
713: FND_MSG_PUB.ADD;
714: END IF;

Line 713: FND_MSG_PUB.ADD;

709: --dbms_output.put_line('c_cnrgroupname%FOUND');
710: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
711: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_CNR_DUPLICATE_NAME');
712: FND_MESSAGE.Set_Token('COL_NAME', 'NAME' );
713: FND_MSG_PUB.ADD;
714: END IF;
715: x_Return_Status := FND_API.G_RET_STS_ERROR ;
716: END IF;
717: CLOSE c_cnrgroupname;

Line 727: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

723: --dbms_output.put_line('first update check');
724: --Check CNR group Id
725: If ( p_Terr_cnr_group_rec.CNR_GROUP_ID is NULL OR
726: p_Terr_cnr_group_rec.CNR_GROUP_ID = FND_API.G_MISS_NUM ) THEN
727: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
728: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
729: FND_MESSAGE.Set_Token('COL_NAME', 'CNR_GROUP_ID' );
730: FND_MSG_PUB.ADD;
731: END IF;

Line 730: FND_MSG_PUB.ADD;

726: p_Terr_cnr_group_rec.CNR_GROUP_ID = FND_API.G_MISS_NUM ) THEN
727: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
728: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
729: FND_MESSAGE.Set_Token('COL_NAME', 'CNR_GROUP_ID' );
730: FND_MSG_PUB.ADD;
731: END IF;
732: x_Return_Status := FND_API.G_RET_STS_ERROR ;
733: End If;
734: --dbms_output.put_line('UPDATE CHECK AT END');

Line 741: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

737: FETCH c_cnrgroupname_update INTO l_cnr_group_num;
738:
739: IF c_cnrgroupname_update%FOUND THEN
740: --dbms_output.put_line('c_cnrgroupname_update%FOUND');
741: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
742: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_CNR_DUPLICATE_NAME');
743: FND_MESSAGE.Set_Token('COL_NAME', 'NAME' );
744: FND_MSG_PUB.ADD;
745: END IF;

Line 744: FND_MSG_PUB.ADD;

740: --dbms_output.put_line('c_cnrgroupname_update%FOUND');
741: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
742: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_CNR_DUPLICATE_NAME');
743: FND_MESSAGE.Set_Token('COL_NAME', 'NAME' );
744: FND_MSG_PUB.ADD;
745: END IF;
746: x_Return_Status := FND_API.G_RET_STS_ERROR ;
747: END IF;
748: CLOSE c_cnrgroupname_update;

Line 755: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

751:
752: END IF;
753: --
754: --dbms_output.put_line('BEFORE COUNT and GET');
755: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
756: p_data => x_msg_data);
757: --dbms_output.put_line('AFTER COUNT and GET');
758:
759: EXCEPTION

Line 764: FND_MSG_PUB.Count_And_Get

760: --
761: WHEN FND_API.G_EXC_ERROR THEN
762: --dbms_output('Validate_Cnr_Group_Value_Rec: FND_API.G_EXC_ERROR');
763: x_return_status := FND_API.G_RET_STS_ERROR ;
764: FND_MSG_PUB.Count_And_Get
765: ( P_count => x_msg_count,
766: P_data => x_msg_data
767: );
768:

Line 772: FND_MSG_PUB.Count_And_Get

768:
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: --dbms_output('Validate_Cnr_Group_Value_Rec: FND_API.G_EXC_UNEXPECTED_ERROR');
771: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: FND_MSG_PUB.Count_And_Get
773: ( P_count => x_msg_count,
774: P_data => x_msg_data
775: );
776:

Line 784: FND_MSG_PUB.ADD;

780:
781: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_UNEXPECTED_ERROR');
782: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec' );
783: FND_MESSAGE.Set_Token('ERROR', sqlerrm );
784: FND_MSG_PUB.ADD;
785:
786: FND_MSG_PUB.Count_And_Get
787: ( P_count => x_msg_count,
788: P_data => x_msg_data

Line 786: FND_MSG_PUB.Count_And_Get

782: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec' );
783: FND_MESSAGE.Set_Token('ERROR', sqlerrm );
784: FND_MSG_PUB.ADD;
785:
786: FND_MSG_PUB.Count_And_Get
787: ( P_count => x_msg_count,
788: P_data => x_msg_data
789: );
790:

Line 832: FND_MSG_PUB.initialize;

828: END IF;
829:
830: -- Initialize message list if p_init_msg_list is set to TRUE.
831: IF FND_API.to_Boolean( p_init_msg_list ) THEN
832: FND_MSG_PUB.initialize;
833: END IF;
834:
835: -- Debug Message
836: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 836: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

832: FND_MSG_PUB.initialize;
833: END IF;
834:
835: -- Debug Message
836: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
837: THEN
838: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
839: fnd_message.set_name ('PROC_NAME', l_api_name);
840: FND_MSG_PUB.Add;

Line 840: FND_MSG_PUB.Add;

836: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
837: THEN
838: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
839: fnd_message.set_name ('PROC_NAME', l_api_name);
840: FND_MSG_PUB.Add;
841: END IF;
842:
843: -- Initialize API return status to success
844: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

845: --
846: -- API body
847:
848: -- Debug message
849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
850: THEN
851: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_VALUES_VALIDATE_MSG');
852: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');
853: FND_MSG_PUB.Add;

Line 853: FND_MSG_PUB.Add;

849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
850: THEN
851: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_VALUES_VALIDATE_MSG');
852: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');
853: FND_MSG_PUB.Add;
854: END IF;
855:
856: JTF_TERR_CNR_GROUP_VALUES_PKG.Insert_Row(
857: x_rowid => l_rowid,

Line 878: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

874: x_Terr_cnr_values_out_rec.cnr_group_value_id := l_terr_cnr_group_value_Id;
875:
876:
877: -- Debug Message
878: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
879: THEN
880: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
881: fnd_message.set_name ('PROC_NAME', l_api_name);
882: FND_MSG_PUB.Add;

Line 882: FND_MSG_PUB.Add;

878: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
879: THEN
880: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
881: fnd_message.set_name ('PROC_NAME', l_api_name);
882: FND_MSG_PUB.Add;
883: END IF;
884:
885:
886: FND_MSG_PUB.Count_And_Get

Line 886: FND_MSG_PUB.Count_And_Get

882: FND_MSG_PUB.Add;
883: END IF;
884:
885:
886: FND_MSG_PUB.Count_And_Get
887: ( p_count => x_msg_count,
888: p_data => x_msg_data
889: );
890:

Line 904: FND_MSG_PUB.Count_And_Get

900: WHEN FND_API.G_EXC_ERROR THEN
901: --dbms_output.put_line('Create_Terr_Cnr_Values PVT: FND_API.G_EXC_ERROR');
902: ROLLBACK TO CREATE_CNR_VALUES_PVT;
903: x_return_status := FND_API.G_RET_STS_ERROR ;
904: FND_MSG_PUB.Count_And_Get
905: ( p_count => x_msg_count,
906: p_data => x_msg_data
907: );
908:

Line 913: FND_MSG_PUB.Count_And_Get

909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
910: --dbms_output.put_line('Create_Terr_Cnr_Values PVT: FND_API.G_EXC_UNEXPECTED_ERROR');
911: ROLLBACK TO CREATE_CNR_VALUES_PVT;
912: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913: FND_MSG_PUB.Count_And_Get
914: ( p_count => x_msg_count,
915: p_data => x_msg_data
916: );
917:

Line 922: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

918: WHEN OTHERS THEN
919: --dbms_output.put_line('Create_Terr_Cnr_Values PVT: OTHERS - ' || SQLERRM);
920: ROLLBACK TO CREATE_CNR_VALUES_PVT;
921: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
922: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
923: THEN
924: fnd_msg_pub.add_exc_msg (
925: g_pkg_name,
926: 'Error inside Create_Terr_Cnr_Group ' || sqlerrm);

Line 924: fnd_msg_pub.add_exc_msg (

920: ROLLBACK TO CREATE_CNR_VALUES_PVT;
921: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
922: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
923: THEN
924: fnd_msg_pub.add_exc_msg (
925: g_pkg_name,
926: 'Error inside Create_Terr_Cnr_Group ' || sqlerrm);
927: END IF;
928: --

Line 965: FND_MSG_PUB.initialize;

961: END IF;
962:
963: -- Initialize message list if p_init_msg_list is set to TRUE.
964: IF FND_API.to_Boolean( p_init_msg_list ) THEN
965: FND_MSG_PUB.initialize;
966: END IF;
967:
968: -- Debug Message
969: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 969: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

965: FND_MSG_PUB.initialize;
966: END IF;
967:
968: -- Debug Message
969: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
970: THEN
971: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
972: fnd_message.set_name ('PROC_NAME', l_api_name);
973: FND_MSG_PUB.Add;

Line 973: FND_MSG_PUB.Add;

969: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
970: THEN
971: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
972: fnd_message.set_name ('PROC_NAME', l_api_name);
973: FND_MSG_PUB.Add;
974: END IF;
975:
976: -- Initialize API return status to success
977: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 986: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

982: x_CNR_GROUP_VALUE_ID => p_Terr_cnr_values_rec.cnr_group_value_id
983: );
984:
985: -- Debug Message
986: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
987: THEN
988: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
989: fnd_message.set_name ('PROC_NAME', l_api_name);
990: FND_MSG_PUB.Add;

Line 990: FND_MSG_PUB.Add;

986: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
987: THEN
988: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
989: fnd_message.set_name ('PROC_NAME', l_api_name);
990: FND_MSG_PUB.Add;
991: END IF;
992:
993:
994: FND_MSG_PUB.Count_And_Get

Line 994: FND_MSG_PUB.Count_And_Get

990: FND_MSG_PUB.Add;
991: END IF;
992:
993:
994: FND_MSG_PUB.Count_And_Get
995: ( p_count => x_msg_count,
996: p_data => x_msg_data
997: );
998:

Line 1010: FND_MSG_PUB.Count_And_Get

1006: --
1007: WHEN FND_API.G_EXC_ERROR THEN
1008: ROLLBACK TO DELETE_CNR_VALUE_PVT;
1009: x_return_status := FND_API.G_RET_STS_ERROR ;
1010: FND_MSG_PUB.Count_And_Get
1011: ( p_count => x_msg_count,
1012: p_data => x_msg_data
1013: );
1014:

Line 1018: FND_MSG_PUB.Count_And_Get

1014:
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016: ROLLBACK TO DELETE_CNR_VALUE_PVT;
1017: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MSG_PUB.Count_And_Get
1019: ( p_count => x_msg_count,
1020: p_data => x_msg_data
1021: );
1022:

Line 1026: FND_MSG_PUB.Count_And_Get

1022:
1023: WHEN OTHERS THEN
1024: ROLLBACK TO DELETE_CNR_VALUE_PVT;
1025: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1026: FND_MSG_PUB.Count_And_Get
1027: ( p_count => x_msg_count,
1028: p_data => x_msg_data
1029: );
1030: --

Line 1073: FND_MSG_PUB.initialize;

1069: END IF;
1070:
1071: -- Initialize message list if p_init_msg_list is set to TRUE.
1072: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1073: FND_MSG_PUB.initialize;
1074: END IF;
1075:
1076: -- Debug Message
1077: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 1077: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1073: FND_MSG_PUB.initialize;
1074: END IF;
1075:
1076: -- Debug Message
1077: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1078: THEN
1079: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1080: fnd_message.set_name ('PROC_NAME', l_api_name);
1081: FND_MSG_PUB.Add;

Line 1081: FND_MSG_PUB.Add;

1077: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1078: THEN
1079: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1080: fnd_message.set_name ('PROC_NAME', l_api_name);
1081: FND_MSG_PUB.Add;
1082: END IF;
1083:
1084: -- Initialize API return status to success
1085: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1090: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1086: --
1087: -- API body
1088:
1089: -- Debug message
1090: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1091: THEN
1092: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_VALUES_VALIDATE_MSG');
1093: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');
1094: FND_MSG_PUB.Add;

Line 1094: FND_MSG_PUB.Add;

1090: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1091: THEN
1092: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_VALUES_VALIDATE_MSG');
1093: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');
1094: FND_MSG_PUB.Add;
1095: END IF;
1096:
1097: JTF_TERR_CNR_GROUP_VALUES_PKG.Update_Row(
1098: x_rowid => l_rowid,

Line 1119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1115: x_Terr_cnr_values_out_rec.cnr_group_value_id := l_terr_cnr_group_value_Id;
1116:
1117:
1118: -- Debug Message
1119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1120: THEN
1121: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1122: fnd_message.set_name ('PROC_NAME', l_api_name);
1123: FND_MSG_PUB.Add;

Line 1123: FND_MSG_PUB.Add;

1119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1120: THEN
1121: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1122: fnd_message.set_name ('PROC_NAME', l_api_name);
1123: FND_MSG_PUB.Add;
1124: END IF;
1125:
1126:
1127: FND_MSG_PUB.Count_And_Get

Line 1127: FND_MSG_PUB.Count_And_Get

1123: FND_MSG_PUB.Add;
1124: END IF;
1125:
1126:
1127: FND_MSG_PUB.Count_And_Get
1128: ( p_count => x_msg_count,
1129: p_data => x_msg_data
1130: );
1131:

Line 1145: FND_MSG_PUB.Count_And_Get

1141: WHEN FND_API.G_EXC_ERROR THEN
1142: --dbms_output.put_line('Update_Terr_Cnr_Values PVT: FND_API.G_EXC_ERROR');
1143: ROLLBACK TO UPDATE_CNR_VALUES_PVT;
1144: x_return_status := FND_API.G_RET_STS_ERROR ;
1145: FND_MSG_PUB.Count_And_Get
1146: ( p_count => x_msg_count,
1147: p_data => x_msg_data
1148: );
1149:

Line 1154: FND_MSG_PUB.Count_And_Get

1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1151: --dbms_output.put_line('Update_Terr_Cnr_Values PVT: FND_API.G_EXC_UNEXPECTED_ERROR');
1152: ROLLBACK TO UPDATE_CNR_VALUES_PVT;
1153: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1154: FND_MSG_PUB.Count_And_Get
1155: ( p_count => x_msg_count,
1156: p_data => x_msg_data
1157: );
1158:

Line 1163: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1159: WHEN OTHERS THEN
1160: --dbms_output.put_line('Update_Terr_Cnr_Values PVT: OTHERS - ' || SQLERRM);
1161: ROLLBACK TO UPDATE_CNR_VALUES_PVT;
1162: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1164: THEN
1165: fnd_msg_pub.add_exc_msg (
1166: g_pkg_name,
1167: 'Error inside Update_Terr_Cnr_Group ' || sqlerrm);

Line 1165: fnd_msg_pub.add_exc_msg (

1161: ROLLBACK TO UPDATE_CNR_VALUES_PVT;
1162: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1164: THEN
1165: fnd_msg_pub.add_exc_msg (
1166: g_pkg_name,
1167: 'Error inside Update_Terr_Cnr_Group ' || sqlerrm);
1168: END IF;
1169: --