DBA Data[Home] [Help]

APPS.ASO_CORE_CONTRACTS_INT dependencies on FND_API

Line 21: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

17:
18:
19: PROCEDURE quote_is_renewal (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
22: p_commit IN VARCHAR2 := fnd_api.g_false,
23: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
24: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
25: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 22: p_commit IN VARCHAR2 := fnd_api.g_false,

18:
19: PROCEDURE quote_is_renewal (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
22: p_commit IN VARCHAR2 := fnd_api.g_false,
23: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
24: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
25: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
26: p_quote_id IN NUMBER,

Line 41: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

37: END quote_is_renewal;
38:
39: PROCEDURE quote_contract_renewal (
40: p_api_version IN NUMBER,
41: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
42: p_commit IN VARCHAR2 := fnd_api.g_false,
43: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
44: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
45: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 42: p_commit IN VARCHAR2 := fnd_api.g_false,

38:
39: PROCEDURE quote_contract_renewal (
40: p_api_version IN NUMBER,
41: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
42: p_commit IN VARCHAR2 := fnd_api.g_false,
43: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
44: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
45: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
46: p_quote_id IN NUMBER,

Line 61: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

57: END quote_contract_renewal;
58:
59: PROCEDURE contract_renewal (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
62: p_commit IN VARCHAR2 := fnd_api.g_false,
63: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
64: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
65: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 62: p_commit IN VARCHAR2 := fnd_api.g_false,

58:
59: PROCEDURE contract_renewal (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
62: p_commit IN VARCHAR2 := fnd_api.g_false,
63: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
64: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
65: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
66: p_contract_id IN NUMBER,

Line 83: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

79: END contract_renewal;
80:
81: PROCEDURE quote_contract_is_ordered (
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
84: p_commit IN VARCHAR2 := fnd_api.g_false,
85: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
86: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
87: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 84: p_commit IN VARCHAR2 := fnd_api.g_false,

80:
81: PROCEDURE quote_contract_is_ordered (
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
84: p_commit IN VARCHAR2 := fnd_api.g_false,
85: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
86: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
87: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
88: p_quote_id IN NUMBER,

Line 103: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

99: END quote_contract_is_ordered;
100:
101: PROCEDURE create_contract (
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
104: p_commit IN VARCHAR2 := fnd_api.g_false,
105: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
106: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
107: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 104: p_commit IN VARCHAR2 := fnd_api.g_false,

100:
101: PROCEDURE create_contract (
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
104: p_commit IN VARCHAR2 := fnd_api.g_false,
105: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
106: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
107: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
108: p_quote_id IN NUMBER,

Line 126: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

122:
123:
124: PROCEDURE create_contract (
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
127: p_commit IN VARCHAR2 := fnd_api.g_false,
128: p_quote_id IN NUMBER,
129: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
130: p_rel_type IN VARCHAR2,

Line 127: p_commit IN VARCHAR2 := fnd_api.g_false,

123:
124: PROCEDURE create_contract (
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
127: p_commit IN VARCHAR2 := fnd_api.g_false,
128: p_quote_id IN NUMBER,
129: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
130: p_rel_type IN VARCHAR2,
131: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,

Line 129: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,

125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
127: p_commit IN VARCHAR2 := fnd_api.g_false,
128: p_quote_id IN NUMBER,
129: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
130: p_rel_type IN VARCHAR2,
131: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
132: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
133: p_party_id IN NUMBER := fnd_api.g_miss_num,

Line 131: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,

127: p_commit IN VARCHAR2 := fnd_api.g_false,
128: p_quote_id IN NUMBER,
129: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
130: p_rel_type IN VARCHAR2,
131: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
132: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
133: p_party_id IN NUMBER := fnd_api.g_miss_num,
134: p_resource_id IN NUMBER := fnd_api.g_miss_num,
135: p_template_id IN NUMBER := fnd_api.g_miss_num,

Line 132: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,

128: p_quote_id IN NUMBER,
129: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
130: p_rel_type IN VARCHAR2,
131: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
132: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
133: p_party_id IN NUMBER := fnd_api.g_miss_num,
134: p_resource_id IN NUMBER := fnd_api.g_miss_num,
135: p_template_id IN NUMBER := fnd_api.g_miss_num,
136: p_template_major_version IN NUMBER := fnd_api.g_miss_num,

Line 133: p_party_id IN NUMBER := fnd_api.g_miss_num,

129: p_terms_agreed_flag IN VARCHAR2 := fnd_api.g_false,
130: p_rel_type IN VARCHAR2,
131: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
132: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
133: p_party_id IN NUMBER := fnd_api.g_miss_num,
134: p_resource_id IN NUMBER := fnd_api.g_miss_num,
135: p_template_id IN NUMBER := fnd_api.g_miss_num,
136: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
137: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 134: p_resource_id IN NUMBER := fnd_api.g_miss_num,

130: p_rel_type IN VARCHAR2,
131: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
132: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
133: p_party_id IN NUMBER := fnd_api.g_miss_num,
134: p_resource_id IN NUMBER := fnd_api.g_miss_num,
135: p_template_id IN NUMBER := fnd_api.g_miss_num,
136: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
137: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
138: x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 135: p_template_id IN NUMBER := fnd_api.g_miss_num,

131: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
132: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
133: p_party_id IN NUMBER := fnd_api.g_miss_num,
134: p_resource_id IN NUMBER := fnd_api.g_miss_num,
135: p_template_id IN NUMBER := fnd_api.g_miss_num,
136: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
137: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
138: x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
139: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 136: p_template_major_version IN NUMBER := fnd_api.g_miss_num,

132: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
133: p_party_id IN NUMBER := fnd_api.g_miss_num,
134: p_resource_id IN NUMBER := fnd_api.g_miss_num,
135: p_template_id IN NUMBER := fnd_api.g_miss_num,
136: p_template_major_version IN NUMBER := fnd_api.g_miss_num,
137: x_contract_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
138: x_contract_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
139: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
140: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 158: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

154: -- this procedure is used to update a contract from a quote.
155:
156: PROCEDURE update_contract (
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
159: p_commit IN VARCHAR2 := fnd_api.g_false,
160: p_quote_id IN NUMBER,
161: p_contract_id IN NUMBER := fnd_api.g_miss_num,
162: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,

Line 159: p_commit IN VARCHAR2 := fnd_api.g_false,

155:
156: PROCEDURE update_contract (
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
159: p_commit IN VARCHAR2 := fnd_api.g_false,
160: p_quote_id IN NUMBER,
161: p_contract_id IN NUMBER := fnd_api.g_miss_num,
162: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
163: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,

Line 161: p_contract_id IN NUMBER := fnd_api.g_miss_num,

157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
159: p_commit IN VARCHAR2 := fnd_api.g_false,
160: p_quote_id IN NUMBER,
161: p_contract_id IN NUMBER := fnd_api.g_miss_num,
162: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
163: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
164: p_party_id IN NUMBER := fnd_api.g_miss_num,
165: p_resource_id IN NUMBER := fnd_api.g_miss_num,

Line 162: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,

158: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
159: p_commit IN VARCHAR2 := fnd_api.g_false,
160: p_quote_id IN NUMBER,
161: p_contract_id IN NUMBER := fnd_api.g_miss_num,
162: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
163: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
164: p_party_id IN NUMBER := fnd_api.g_miss_num,
165: p_resource_id IN NUMBER := fnd_api.g_miss_num,
166: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 163: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,

159: p_commit IN VARCHAR2 := fnd_api.g_false,
160: p_quote_id IN NUMBER,
161: p_contract_id IN NUMBER := fnd_api.g_miss_num,
162: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
163: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
164: p_party_id IN NUMBER := fnd_api.g_miss_num,
165: p_resource_id IN NUMBER := fnd_api.g_miss_num,
166: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
167: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 164: p_party_id IN NUMBER := fnd_api.g_miss_num,

160: p_quote_id IN NUMBER,
161: p_contract_id IN NUMBER := fnd_api.g_miss_num,
162: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
163: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
164: p_party_id IN NUMBER := fnd_api.g_miss_num,
165: p_resource_id IN NUMBER := fnd_api.g_miss_num,
166: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
167: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
168: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 165: p_resource_id IN NUMBER := fnd_api.g_miss_num,

161: p_contract_id IN NUMBER := fnd_api.g_miss_num,
162: p_interaction_subject IN VARCHAR2 := fnd_api.g_miss_char,
163: p_interaction_body IN VARCHAR2 := fnd_api.g_miss_char,
164: p_party_id IN NUMBER := fnd_api.g_miss_num,
165: p_resource_id IN NUMBER := fnd_api.g_miss_num,
166: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
167: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
168: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
169: ) IS

Line 183: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

179:
180:
181: PROCEDURE notify_contract_change (
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
184: p_commit IN VARCHAR2 := fnd_api.g_false,
185: p_quote_id IN NUMBER,
186: p_notification_type IN VARCHAR2,
187: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,

Line 184: p_commit IN VARCHAR2 := fnd_api.g_false,

180:
181: PROCEDURE notify_contract_change (
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
184: p_commit IN VARCHAR2 := fnd_api.g_false,
185: p_quote_id IN NUMBER,
186: p_notification_type IN VARCHAR2,
187: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
188: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,

Line 187: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,

183: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
184: p_commit IN VARCHAR2 := fnd_api.g_false,
185: p_quote_id IN NUMBER,
186: p_notification_type IN VARCHAR2,
187: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
188: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,
189: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
190: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
191: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 188: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,

184: p_commit IN VARCHAR2 := fnd_api.g_false,
185: p_quote_id IN NUMBER,
186: p_notification_type IN VARCHAR2,
187: p_customer_comments IN VARCHAR2 := fnd_api.g_miss_char,
188: p_salesrep_email_id IN VARCHAR2 := fnd_api.g_miss_char,
189: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
190: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
191: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
192: ) IS

Line 206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

202:
203:
204: -- vtariker
205: PROCEDURE Check_Customer_Accounts(
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_qte_header_id IN NUMBER,
208: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
209: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
210: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 224: IF FND_API.to_Boolean( p_init_msg_list ) THEN

220: -- Standard Start of API savepoint
221: SAVEPOINT Check_Customer_Accounts_INT;
222:
223: -- Initialize message list if p_init_msg_list is set to TRUE.
224: IF FND_API.to_Boolean( p_init_msg_list ) THEN
225: FND_MSG_PUB.initialize;
226: END IF;
227:
228: -- Initialize API return status to success

Line 229: x_return_status := FND_API.G_RET_STS_SUCCESS;

225: FND_MSG_PUB.initialize;
226: END IF;
227:
228: -- Initialize API return status to success
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230:
231: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
232: aso_debug_pub.add('ASO_CORE_CONTRACTS_INT.Check_Customer_Accounts - Begin', 1, 'Y');
233: END IF;

Line 238: p_init_msg_list => fnd_api.g_false,

234:
235: /************** Replacing with call to moved api ********************/
236:
237: ASO_CHECK_TCA_PVT.Check_Customer_Accounts (
238: p_init_msg_list => fnd_api.g_false,
239: p_qte_header_id => p_qte_header_id,
240: x_return_status => x_return_status,
241: x_msg_count => x_msg_count,
242: x_msg_data => x_msg_data

Line 256: WHEN FND_API.G_EXC_ERROR THEN

252: p_data => x_msg_data
253: );
254:
255: EXCEPTION
256: WHEN FND_API.G_EXC_ERROR THEN
257: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
258: P_API_NAME => L_API_NAME
259: ,P_PKG_NAME => G_PKG_NAME
260: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

264: ,X_MSG_COUNT => X_MSG_COUNT
265: ,X_MSG_DATA => X_MSG_DATA
266: ,X_RETURN_STATUS => X_RETURN_STATUS);
267:
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
270: P_API_NAME => L_API_NAME
271: ,P_PKG_NAME => G_PKG_NAME
272: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR