DBA Data[Home] [Help]

APPS.JTF_TERR_LOOKUP_PUB dependencies on FND_MSG_PUB

Line 102: FND_MSG_PUB.initialize;

98: --dbms_output.put_line('p_trans_rec.SQUAL_CHAR08 =' || llp_trans_rec.SQUAL_CHAR08(1));
99: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB.Get_Addn_Params: Begin ');
100:
101:
102: FND_MSG_PUB.initialize;
103:
104: -- Standard call to check for call compatibility.
105: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
106: p_api_version_number,

Line 115: FND_MSG_PUB.initialize;

111: END IF;
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: IF FND_API.to_Boolean( p_init_msg_list )
114: THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:
118: -- Debug Message
119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

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

115: FND_MSG_PUB.initialize;
116: END IF;
117:
118: -- Debug Message
119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
120: THEN
121: FND_MESSAGE.Set_Name('JTF', 'Get_Addn_Params_start');
122: FND_MSG_PUB.Add;
123: END IF;

Line 122: FND_MSG_PUB.Add;

118: -- Debug Message
119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
120: THEN
121: FND_MESSAGE.Set_Name('JTF', 'Get_Addn_Params_start');
122: FND_MSG_PUB.Add;
123: END IF;
124:
125: -- API body
126: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 412: FND_MSG_PUB.initialize;

408: -- to JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type
409:
410: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Convert to bulk ');
411:
412: FND_MSG_PUB.initialize;
413:
414: -- Standard call to check for call compatibility.
415: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
416: p_api_version_number,

Line 425: FND_MSG_PUB.initialize;

421: END IF;
422: -- Initialize message list if p_init_msg_list is set to TRUE.
423: IF FND_API.to_Boolean( p_init_msg_list )
424: THEN
425: FND_MSG_PUB.initialize;
426: END IF;
427:
428: -- Debug Message
429: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

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

425: FND_MSG_PUB.initialize;
426: END IF;
427:
428: -- Debug Message
429: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
430: THEN
431: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MEMBERS_ACCT_START');
432: FND_MSG_PUB.Add;
433: END IF;

Line 432: FND_MSG_PUB.Add;

428: -- Debug Message
429: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
430: THEN
431: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MEMBERS_ACCT_START');
432: FND_MSG_PUB.Add;
433: END IF;
434:
435: -- API body
436: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

927: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: API returned - number of winners: ' || x_winners_tbl.count );
928: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Convert from bulk ');
929: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Conversion complete ');
930: -- Debug Message
931: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
932: THEN
933: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MEMBERS_ACCT_END');
934: FND_MSG_PUB.Add;
935: END IF;

Line 934: FND_MSG_PUB.Add;

930: -- Debug Message
931: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
932: THEN
933: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MEMBERS_ACCT_END');
934: FND_MSG_PUB.Add;
935: END IF;
936:
937: -- Standard call to get message count and if count is 1, get message info.
938: FND_MSG_PUB.Count_And_Get

Line 938: FND_MSG_PUB.Count_And_Get

934: FND_MSG_PUB.Add;
935: END IF;
936:
937: -- Standard call to get message count and if count is 1, get message info.
938: FND_MSG_PUB.Count_And_Get
939: ( p_count => x_msg_count,
940: p_data => x_msg_data
941: );
942: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: End ');

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

942: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: End ');
943: EXCEPTION
944: WHEN OTHERS THEN
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
946: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
948: END IF;
949: FND_MSG_PUB.Count_And_Get
950: ( p_count => x_msg_count,

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

943: EXCEPTION
944: WHEN OTHERS THEN
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
946: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
948: END IF;
949: FND_MSG_PUB.Count_And_Get
950: ( p_count => x_msg_count,
951: p_data => x_msg_data

Line 949: FND_MSG_PUB.Count_And_Get

945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
946: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
948: END IF;
949: FND_MSG_PUB.Count_And_Get
950: ( p_count => x_msg_count,
951: p_data => x_msg_data
952: );
953: