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_MESSAGE

Line 101: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

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;
104: END IF;
105:

Line 102: fnd_message.set_name ('PROC_NAME', l_api_name);

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;
104: END IF;
105:
106: -- Initialize API return status to success

Line 120: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_GROUP_VALIDATE_MSG');

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;
123: END IF;
124:

Line 121: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');

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;
123: END IF;
124:
125: -- Invoke validation procedures

Line 174: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

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;
177: END IF;
178:

Line 175: fnd_message.set_name ('PROC_NAME', l_api_name);

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;
177: END IF;
178:
179:

Line 284: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

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;
287: END IF;
288:

Line 285: fnd_message.set_name ('PROC_NAME', l_api_name);

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;
287: END IF;
288:
289: -- Initialize API return status to success

Line 303: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_GROUP_VALIDATE_MSG');

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;
306: END IF;
307:

Line 304: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');

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;
306: END IF;
307:
308: -- Invoke validation procedures

Line 332: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

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;
335: END IF;
336:

Line 333: fnd_message.set_name ('PROC_NAME', l_api_name);

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;
335: END IF;
336:
337:

Line 435: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

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;
438: END IF;
439:

Line 436: fnd_message.set_name ('PROC_NAME', l_api_name);

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;
438: END IF;
439:
440:

Line 454: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_GROUP_VALIDATE_MSG');

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;
457: END IF;
458:

Line 455: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');

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;
457: END IF;
458:
459: -- Invoke validation procedures

Line 509: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

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;
512: END IF;
513:

Line 510: fnd_message.set_name ('PROC_NAME', l_api_name);

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;
512: END IF;
513:
514:

Line 625: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_CNR_HAS_FKREL');

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;
629: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 626: FND_MESSAGE.Set_Token('COL_NAME', 'CNR_GROUP_ID' );

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;
629: x_Return_Status := FND_API.G_RET_STS_ERROR ;
630: END IF;

Line 640: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

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;
644: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 641: FND_MESSAGE.Set_Token('COL_NAME', '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;
644: x_Return_Status := FND_API.G_RET_STS_ERROR ;
645: End If;

Line 651: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

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;
655: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 652: FND_MESSAGE.Set_Token('COL_NAME', '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;
655: x_Return_Status := FND_API.G_RET_STS_ERROR ;
656: End If;

Line 662: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

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;
666: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 663: FND_MESSAGE.Set_Token('COL_NAME', '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;
666: x_Return_Status := FND_API.G_RET_STS_ERROR ;
667: End If;

Line 673: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

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;
677: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 674: FND_MESSAGE.Set_Token('COL_NAME', '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;
677: x_Return_Status := FND_API.G_RET_STS_ERROR ;
678: End If;

Line 684: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

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;
688: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 685: FND_MESSAGE.Set_Token('COL_NAME', '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;
688: x_Return_Status := FND_API.G_RET_STS_ERROR ;
689: End If;

Line 695: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

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;
699: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 696: FND_MESSAGE.Set_Token('COL_NAME', '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;
699: x_Return_Status := FND_API.G_RET_STS_ERROR ;
700: End If;

Line 711: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_CNR_DUPLICATE_NAME');

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;
715: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 712: FND_MESSAGE.Set_Token('COL_NAME', 'NAME' );

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;
715: x_Return_Status := FND_API.G_RET_STS_ERROR ;
716: END IF;

Line 728: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

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;
732: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 729: FND_MESSAGE.Set_Token('COL_NAME', '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;
732: x_Return_Status := FND_API.G_RET_STS_ERROR ;
733: End If;

Line 742: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_CNR_DUPLICATE_NAME');

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;
746: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 743: FND_MESSAGE.Set_Token('COL_NAME', 'NAME' );

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;
746: x_Return_Status := FND_API.G_RET_STS_ERROR ;
747: END IF;

Line 781: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_UNEXPECTED_ERROR');

777: WHEN OTHERS THEN
778: --dbms_output('Validate_Cnr_Group_Value_Rec: OTHERS - ' || SQLERRM);
779: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:

Line 782: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec' );

778: --dbms_output('Validate_Cnr_Group_Value_Rec: OTHERS - ' || SQLERRM);
779: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 783: FND_MESSAGE.Set_Token('ERROR', sqlerrm );

779: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 838: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

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;
841: END IF;
842:

Line 839: fnd_message.set_name ('PROC_NAME', l_api_name);

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;
841: END IF;
842:
843: -- Initialize API return status to success

Line 851: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_VALUES_VALIDATE_MSG');

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;
854: END IF;
855:

Line 852: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');

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;
854: END IF;
855:
856: JTF_TERR_CNR_GROUP_VALUES_PKG.Insert_Row(

Line 880: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

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;
883: END IF;
884:

Line 881: fnd_message.set_name ('PROC_NAME', l_api_name);

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;
883: END IF;
884:
885:

Line 971: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

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;
974: END IF;
975:

Line 972: fnd_message.set_name ('PROC_NAME', l_api_name);

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;
974: END IF;
975:
976: -- Initialize API return status to success

Line 988: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

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;
991: END IF;
992:

Line 989: fnd_message.set_name ('PROC_NAME', l_api_name);

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;
991: END IF;
992:
993:

Line 1079: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

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;
1082: END IF;
1083:

Line 1080: fnd_message.set_name ('PROC_NAME', l_api_name);

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;
1082: END IF;
1083:
1084: -- Initialize API return status to success

Line 1092: FND_MESSAGE.Set_Name('JTF', 'JTF_CNR_VALUES_VALIDATE_MSG');

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;
1095: END IF;
1096:

Line 1093: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Cnr_Group_Value_Rec');

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;
1095: END IF;
1096:
1097: JTF_TERR_CNR_GROUP_VALUES_PKG.Update_Row(

Line 1121: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

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;
1124: END IF;
1125:

Line 1122: fnd_message.set_name ('PROC_NAME', l_api_name);

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;
1124: END IF;
1125:
1126: