DBA Data[Home] [Help]

APPS.JTF_TERR_LOOKUP_PUB dependencies on JTF_TERR_LOOKUP_PUB

Line 1: PACKAGE BODY JTF_TERR_LOOKUP_PUB AS

1: PACKAGE BODY JTF_TERR_LOOKUP_PUB AS
2: /* $Header: jtfplkub.pls 120.3 2008/08/07 09:34:29 gmarwah ship $ */
3: ---------------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTF_TERR_LOOKUP_PUB

2: /* $Header: jtfplkub.pls 120.3 2008/08/07 09:34:29 gmarwah ship $ */
3: ---------------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: JTF_TERR_LOOKUP_PUB
7: -- ---------------------------------------------------
8: -- PURPOSE
9: -- Joint task force territory lookup tool api's.
10: -- This package is a public API for getting winning territories

Line 42: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_LOOKUP_PUB';

38: --
39: -- ***************************************************
40: -- GLOBAL VARIABLES
41: -- ***************************************************
42: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_LOOKUP_PUB';
43: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfplkub.pls';
44:
45: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
46: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;

Line 99: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB.Get_Addn_Params: Begin ');

95: BEGIN
96:
97: --dbms_output.put_line('initial value - l_area_code = ' || l_area_code);
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:

Line 406: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: begin ');

402: l_program_name VARCHAR2(60);
403:
404: BEGIN
405:
406: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: begin ');
407: -- convert JTF_TERR_LOOKUP_PUB.JTF_Account_rec_type
408: -- to JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type
409:
410: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Convert to bulk ');

Line 407: -- convert JTF_TERR_LOOKUP_PUB.JTF_Account_rec_type

403:
404: BEGIN
405:
406: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: begin ');
407: -- convert JTF_TERR_LOOKUP_PUB.JTF_Account_rec_type
408: -- to JTF_TERRITORY_PUB.JTF_Account_bulk_rec_type
409:
410: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Convert to bulk ');
411:

Line 410: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Convert to bulk ');

406: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: begin ');
407: -- convert JTF_TERR_LOOKUP_PUB.JTF_Account_rec_type
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.

Line 688: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Call API ');

684: --Reset the global variables
685: l_RetCode := JTF_TERRITORY_GLOBAL_PUB.Reset;
686:
687:
688: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Call API ');
689: -- API Call for winning territory resources
690: /*
691: jtf_terr_1001_account_dyn.search_terr_rules_all(
692: p_Rec => lp_Rec,

Line 697: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Call assign API ');

693: x_rec => x_winners_tbl
694: );
695: */
696:
697: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Call assign API ');
698: --------arpatel 09/28 Now Calling Generic Assign package----------
699: /*
700: JTF_TERR_ASSIGN_PUB.get_winners
701: ( p_api_version_number => p_api_version_number,

Line 927: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: API returned - number of winners: ' || x_winners_tbl.count );

923:
924:
925: --x_winners_tbl := lx_rec;
926: --l_NumberOfWinners := JTF_TERRITORY_GLOBAL_PUB.get_RecordCount;
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)

Line 928: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Convert from bulk ');

924:
925: --x_winners_tbl := lx_rec;
926: --l_NumberOfWinners := JTF_TERRITORY_GLOBAL_PUB.get_RecordCount;
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

Line 929: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: Conversion complete ');

925: --x_winners_tbl := lx_rec;
926: --l_NumberOfWinners := JTF_TERRITORY_GLOBAL_PUB.get_RecordCount;
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');

Line 942: --dbms_output.put_line('JTF_TERR_LOOKUP_PUB: End ');

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 ');
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

Line 956: END JTF_TERR_LOOKUP_PUB;

952: );
953:
954: End Get_Winners;
955:
956: END JTF_TERR_LOOKUP_PUB;