25: begin
26: if (p_sales_team_rec.freeze_flag is NOT NULL
27: and p_sales_team_rec.freeze_flag <> FND_API.G_MISS_CHAR)
28: then
29: if (AS_FOUNDATION_PVT.get_lookupMeaning('YES/NO',
30: p_sales_team_rec.freeze_flag, AS_FOUNDATION_PVT.G_AR_LOOKUPS )
31: is NULL)
32: then
33: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
26: if (p_sales_team_rec.freeze_flag is NOT NULL
27: and p_sales_team_rec.freeze_flag <> FND_API.G_MISS_CHAR)
28: then
29: if (AS_FOUNDATION_PVT.get_lookupMeaning('YES/NO',
30: p_sales_team_rec.freeze_flag, AS_FOUNDATION_PVT.G_AR_LOOKUPS )
31: is NULL)
32: then
33: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
34: THEN
43:
44: if (p_sales_team_rec.reassign_flag is NOT NULL
45: and p_sales_team_rec.reassign_flag <> FND_API.G_MISS_CHAR)
46: then
47: if (AS_FOUNDATION_PVT.get_lookupMeaning('YES/NO',
48: p_sales_team_rec.reassign_flag, AS_FOUNDATION_PVT.G_AR_LOOKUPS )
49: is NULL)
50: then
51: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
44: if (p_sales_team_rec.reassign_flag is NOT NULL
45: and p_sales_team_rec.reassign_flag <> FND_API.G_MISS_CHAR)
46: then
47: if (AS_FOUNDATION_PVT.get_lookupMeaning('YES/NO',
48: p_sales_team_rec.reassign_flag, AS_FOUNDATION_PVT.G_AR_LOOKUPS )
49: is NULL)
50: then
51: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
52: THEN
61:
62: if (p_sales_team_rec.team_leader_flag is NOT NULL
63: and p_sales_team_rec.team_leader_flag <> FND_API.G_MISS_CHAR)
64: then
65: if (AS_FOUNDATION_PVT.get_lookupMeaning('YES/NO',
66: p_sales_team_rec.team_leader_flag, AS_FOUNDATION_PVT.G_AR_LOOKUPS )
67: is NULL)
68: then
69: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
62: if (p_sales_team_rec.team_leader_flag is NOT NULL
63: and p_sales_team_rec.team_leader_flag <> FND_API.G_MISS_CHAR)
64: then
65: if (AS_FOUNDATION_PVT.get_lookupMeaning('YES/NO',
66: p_sales_team_rec.team_leader_flag, AS_FOUNDATION_PVT.G_AR_LOOKUPS )
67: is NULL)
68: then
69: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
70: THEN