DBA Data[Home] [Help]

APPS.INL_LANDEDCOST_PUB dependencies on STANDARD

Line 65: -- Standard Beginning of Procedure/Function Logging

61: l_debug_info VARCHAR2(200);
62: l_parent_ship_line_id NUMBER;
63: BEGIN
64:
65: -- Standard Beginning of Procedure/Function Logging
66: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
67: p_procedure_name => l_api_name);
68: -- Standard Start of API savepoint
69: SAVEPOINT Get_LandedCost_PVT;

Line 68: -- Standard Start of API savepoint

64:
65: -- Standard Beginning of Procedure/Function Logging
66: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
67: p_procedure_name => l_api_name);
68: -- Standard Start of API savepoint
69: SAVEPOINT Get_LandedCost_PVT;
70:
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 91: -- Standard Statement Level Procedure/Function Logging

87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: -- Api Body
90: BEGIN
91: -- Standard Statement Level Procedure/Function Logging
92: l_debug_info := 'Get estimated landed cost for the ship_line_id: ' || p_ship_line_id;
93: INL_LOGGING_PVT.Log_Statement (
94: p_module_name => g_module_name,
95: p_procedure_name => l_api_name,

Line 124: -- Standard Statement Level Procedure/Function Logging

120: FROM inl_shipln_landed_costs_v olcv
121: WHERE olcv.ship_line_id = l_parent_ship_line_id
122: AND olcv.adjustment_num = 0;
123:
124: -- Standard Statement Level Procedure/Function Logging
125: l_debug_info := 'Get actual landed cost for the ship_line_id: ' || p_ship_line_id;
126: INL_LOGGING_PVT.Log_Statement (
127: p_module_name => g_module_name,
128: p_procedure_name => l_api_name,

Line 155: -- Standard check of p_commit.

151:
152: END;
153: -- End of Api Body
154:
155: -- Standard check of p_commit.
156: IF FND_API.To_Boolean( p_commit ) THEN
157: COMMIT WORK;
158: END IF;
159:

Line 160: -- Standard call to get message count and if count is 1, get message info.

156: IF FND_API.To_Boolean( p_commit ) THEN
157: COMMIT WORK;
158: END IF;
159:
160: -- Standard call to get message count and if count is 1, get message info.
161: FND_MSG_PUB.Count_And_Get(
162: p_encoded => FND_API.g_false,
163: p_count => x_msg_count,
164: p_data => x_msg_data);

Line 166: -- Standard End of Procedure/Function Logging

162: p_encoded => FND_API.g_false,
163: p_count => x_msg_count,
164: p_data => x_msg_data);
165:
166: -- Standard End of Procedure/Function Logging
167: INL_LOGGING_PVT.Log_EndProc (
168: p_module_name => g_module_name,
169: p_procedure_name => l_api_name
170: );

Line 173: -- Standard Expected Error Logging

169: p_procedure_name => l_api_name
170: );
171: EXCEPTION
172: WHEN FND_API.G_EXC_ERROR THEN
173: -- Standard Expected Error Logging
174: INL_LOGGING_PVT.Log_ExpecError (
175: p_module_name => g_module_name,
176: p_procedure_name => l_api_name
177: );

Line 186: -- Standard Unexpected Error Logging

182: p_count => x_msg_count,
183: p_data => x_msg_data
184: );
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: -- Standard Unexpected Error Logging
187: INL_LOGGING_PVT.Log_UnexpecError (
188: p_module_name => g_module_name,
189: p_procedure_name => l_api_name);
190: ROLLBACK TO Get_LandedCost_PVT;

Line 198: -- Standard Unexpected Error Logging

194: p_count => x_msg_count,
195: p_data => x_msg_data
196: );
197: WHEN OTHERS THEN
198: -- Standard Unexpected Error Logging
199: INL_LOGGING_PVT.Log_UnexpecError (
200: p_module_name => g_module_name,
201: p_procedure_name => l_api_name
202: );