DBA Data[Home] [Help]

APPS.IEX_TRX_GRID_PUB dependencies on FND_API

Line 83: l_Init_Msg_List := FND_API.G_FALSE;

79: l_Init_Msg_List := P_Init_Msg_List;
80: l_Commit := P_Commit;
81: l_validation_level := p_validation_level;
82: if (l_Init_msg_List is null) then
83: l_Init_Msg_List := FND_API.G_FALSE;
84: end if;
85: if (l_Commit is null) then
86: l_Commit := FND_API.G_TRUE;
87: end if;

Line 86: l_Commit := FND_API.G_TRUE;

82: if (l_Init_msg_List is null) then
83: l_Init_Msg_List := FND_API.G_FALSE;
84: end if;
85: if (l_Commit is null) then
86: l_Commit := FND_API.G_TRUE;
87: end if;
88: if (l_validation_level is null) then
89: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
90: end if;

Line 89: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

85: if (l_Commit is null) then
86: l_Commit := FND_API.G_TRUE;
87: end if;
88: if (l_validation_level is null) then
89: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
90: end if;
91:
92: SAVEPOINT Set_Unpaid_Reason_PUB;
93:

Line 95: IF NOT FND_API.Compatible_API_Call (l_api_version,

91:
92: SAVEPOINT Set_Unpaid_Reason_PUB;
93:
94: -- Standard call to check for call compatibility.
95: IF NOT FND_API.Compatible_API_Call (l_api_version,
96: p_api_version,
97: l_api_name,
98: G_PKG_NAME) THEN
99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

95: IF NOT FND_API.Compatible_API_Call (l_api_version,
96: p_api_version,
97: l_api_name,
98: G_PKG_NAME) THEN
99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
100: END IF;
101:
102: -- Check p_init_msg_list
103: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 103: IF FND_API.to_Boolean( p_init_msg_list ) THEN

99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
100: END IF;
101:
102: -- Check p_init_msg_list
103: IF FND_API.to_Boolean( p_init_msg_list ) THEN
104: FND_MSG_PUB.initialize;
105: END IF;
106:
107: x_return_status := 'S';

Line 123: RAISE FND_API.G_EXC_ERROR;

119: fnd_message.set_token('PARAMETER', 'p_unpaid_reason');
120: FND_MSG_PUB.Add;
121:
122: close check_code;
123: RAISE FND_API.G_EXC_ERROR;
124: return;
125: end if;
126: close check_code;
127:

Line 136: RAISE FND_API.G_EXC_ERROR;

132: fnd_message.set_token('VALUE', p_unpaid_reason);
133: fnd_message.set_token('PARAMETER', 'p_unpaid_reason');
134: FND_MSG_PUB.Add;
135:
136: RAISE FND_API.G_EXC_ERROR;
137: return;
138: end;
139:
140:

Line 156: IF FND_API.To_Boolean(p_commit) THEN

152: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
153: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
154:
155: -- Standard check of p_commit
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

Line 165: WHEN FND_API.G_EXC_ERROR THEN

161: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
162:
163: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
164: EXCEPTION
165: WHEN FND_API.G_EXC_ERROR THEN
166: ROLLBACK TO Set_Unpaid_Reason_PUB;
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
169:

Line 167: x_return_status := FND_API.G_RET_STS_ERROR;

163: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':end');
164: EXCEPTION
165: WHEN FND_API.G_EXC_ERROR THEN
166: ROLLBACK TO Set_Unpaid_Reason_PUB;
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
169:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO Set_Unpaid_Reason_PUB;

Line 170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

166: ROLLBACK TO Set_Unpaid_Reason_PUB;
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
169:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO Set_Unpaid_Reason_PUB;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
174:

Line 172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

168: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
169:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO Set_Unpaid_Reason_PUB;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
174:
175: WHEN OTHERS THEN
176: ROLLBACK TO Set_Unpaid_Reason_PUB;

Line 177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
174:
175: WHEN OTHERS THEN
176: ROLLBACK TO Set_Unpaid_Reason_PUB;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
179: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
180: END IF;
181: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);