APPS.AS_AUTOCREATE_OPP dependencies on FND_API

Line 94: RAISE FND_API.G_EXC_ERROR;

90: FETCH C_GetIdentity_FndUser INTO l_salesforce_id;
91: IF ( C_GetIdentity_FndUser%NOTFOUND) THEN
92: Close C_GetIdentity_FndUser;
93: write_log(1,'Error in Login user');
94: RAISE FND_API.G_EXC_ERROR;
95:
96: END IF;
97: Close C_GetIdentity_FndUser;
98: write_log(1,'Login Resource id : ' || l_salesforce_id);

Line 105: RAISE FND_API.G_EXC_ERROR;

101: FETCH C_GetIdentity_SGID INTO l_salesgroup_id;
102: IF ( C_GetIdentity_SGID%NOTFOUND) THEN
103: Close C_GetIdentity_SGID;
104: write_log(1,'Error in Login Group id');
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107: Close C_GetIdentity_SGID;
108: write_log(1,'Login Group id : ' || l_salesgroup_id);
109:

Line 123: p_init_msg_list => FND_API.G_TRUE,

119: l_total_process := l_total_process + 1;
120:
121: AS_SALES_LEADS_PUB.Create_Opportunity_For_Lead
122: ( p_api_version_number => 2.0,
123: p_init_msg_list => FND_API.G_TRUE,
124: p_commit => FND_API.G_FALSE,
125: p_validation_level => 90,
126: P_Check_Access_Flag => 'Y',
127: P_Admin_Flag => 'N',

Line 124: p_commit => FND_API.G_FALSE,

120:
121: AS_SALES_LEADS_PUB.Create_Opportunity_For_Lead
122: ( p_api_version_number => 2.0,
123: p_init_msg_list => FND_API.G_TRUE,
124: p_commit => FND_API.G_FALSE,
125: p_validation_level => 90,
126: P_Check_Access_Flag => 'Y',
127: P_Admin_Flag => 'N',
128: P_Admin_Group_Id => NULL,

Line 132: --P_Partner_Cont_Party_id => FND_API.G_MISS_NUM,

128: P_Admin_Group_Id => NULL,
129: P_Identity_Salesforce_Id => l_salesforce_id,
130: P_identity_salesgroup_id =>l_salesgroup_id,
131: P_sales_lead_profile_tbl => AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
132: --P_Partner_Cont_Party_id => FND_API.G_MISS_NUM,
133: P_sales_lead_id => l_sales_lead_id,
134: x_return_status => l_return_status,
135: x_msg_count => l_msg_count,
136: x_msg_data => l_msg_data,

Line 139: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

135: x_msg_count => l_msg_count,
136: x_msg_data => l_msg_data,
137: X_opportunity_ID => l_opportunity_id);
138:
139: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
140: IF p_debug_mode = 'Y' and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
141: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxldopb', 'Successfully create opportunity '||
142: to_char(l_opportunity_id) || 'for sales lead' ||
143: to_char(l_sales_lead_id));

Line 160: IF l_return_status <> FND_API.G_RET_STS_ERROR THEN

156: IF p_debug_mode = 'Y' and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxldopb', 'Fail to create opportunity for sales lead' ||
158: to_char(l_sales_lead_id));
159: END IF;
160: IF l_return_status <> FND_API.G_RET_STS_ERROR THEN
161: raise FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163: END IF;
164:

Line 161: raise FND_API.G_EXC_UNEXPECTED_ERROR;

157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxldopb', 'Fail to create opportunity for sales lead' ||
158: to_char(l_sales_lead_id));
159: END IF;
160: IF l_return_status <> FND_API.G_RET_STS_ERROR THEN
161: raise FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163: END IF;
164:
165: IF l_counter = commit_counter THEN

Line 181: WHEN FND_API.G_EXC_ERROR THEN

177: to_char(l_total_success));
178: Write_log (1, '*** End of Auto-create opportunities ***');
179:
180: EXCEPTION
181: WHEN FND_API.G_EXC_ERROR THEN
182: ERRBUF := ERRBUF || sqlerrm;
183: RETCODE := FND_API.G_RET_STS_ERROR;
184: ROLLBACK;
185: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

Line 183: RETCODE := FND_API.G_RET_STS_ERROR;

179:
180: EXCEPTION
181: WHEN FND_API.G_EXC_ERROR THEN
182: ERRBUF := ERRBUF || sqlerrm;
183: RETCODE := FND_API.G_RET_STS_ERROR;
184: ROLLBACK;
185: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
186: Write_log (1, 'Error in Create_Opp_from_Sales_lead');
187: Write_log (1, 'SQLCODE ' || to_char(SQLCODE) ||

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

186: Write_log (1, 'Error in Create_Opp_from_Sales_lead');
187: Write_log (1, 'SQLCODE ' || to_char(SQLCODE) ||
188: ' SQLERRM ' || substr(SQLERRM, 1, 100));
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ERRBUF := ERRBUF||sqlerrm;
192: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
193: ROLLBACK;
194: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

Line 192: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

188: ' SQLERRM ' || substr(SQLERRM, 1, 100));
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ERRBUF := ERRBUF||sqlerrm;
192: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
193: ROLLBACK;
194: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
195: Write_log (1, 'Unexpected error in Create_Opp_from_Sales_lead');
196: Write_log (1, 'SQLCODE ' || to_char(SQLCODE) ||