eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_SALES_TEAM_PVT dependencies on FND_API

Line 18: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

14: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
15:
16:
17: PROCEDURE Assign_Sales_Team(
18: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,

Line 19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

15:
16:
17: PROCEDURE Assign_Sales_Team(
18: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
23: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 23: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,

19: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
20: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
22: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
23: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
25: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
26: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
27: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 187: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

183: -- Standard Start of API savepoint
184: SAVEPOINT ASSIGN_SALES_TEAM_PVT;
185:
186: -- Standard call to check for call compatibility.
187: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
188: 1.0,
189: l_api_name,
190: G_PKG_NAME)
191: THEN

Line 192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

188: 1.0,
189: l_api_name,
190: G_PKG_NAME)
191: THEN
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:
196: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

189: l_api_name,
190: G_PKG_NAME)
191: THEN
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:
196: -- Initialize message list if p_init_msg_list is set to TRUE.
197: IF FND_API.to_Boolean( p_init_msg_list )

Line 197: IF FND_API.to_Boolean( p_init_msg_list )

193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:
196: -- Initialize message list if p_init_msg_list is set to TRUE.
197: IF FND_API.to_Boolean( p_init_msg_list )
198: THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:

Line 203: x_return_status := FND_API.G_RET_STS_SUCCESS;

199: FND_MSG_PUB.initialize;
200: END IF;
201:
202: -- Initialize API return status to SUCCESS
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204:
205: --
206: -- API body
207: --

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: OPEN C_Quote_Exists(P_Qte_Header_Rec.Quote_Header_Id);
226: FETCH C_Quote_Exists INTO l_Exists_Flag;
227: IF (C_Quote_Exists%NOTFOUND) OR l_Exists_Flag <> 'Y' THEN
228: CLOSE C_Quote_Exists;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
231: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
232: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
233: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_rec.quote_header_id), FALSE);

Line 236: RAISE FND_API.G_EXC_ERROR;

232: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
233: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_rec.quote_header_id), FALSE);
234: FND_MSG_PUB.ADD;
235: END IF;
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: CLOSE C_Quote_Exists;
239: -- End: Check if quote header id exists
240:

Line 246: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN

242: OPEN C_Get_Update_Date(P_Qte_Header_Rec.Quote_Header_Id);
243: FETCH C_Get_Update_Date INTO l_last_upd_date;
244:
245: IF (C_Get_Update_Date%NOTFOUND) OR
246: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
249: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
250: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

243: FETCH C_Get_Update_Date INTO l_last_upd_date;
244:
245: IF (C_Get_Update_Date%NOTFOUND) OR
246: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
249: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
250: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
251: FND_MSG_PUB.ADD;

Line 254: RAISE FND_API.G_EXC_ERROR;

250: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
251: FND_MSG_PUB.ADD;
252: END IF;
253: CLOSE C_Get_Update_Date;
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256:
257: CLOSE C_Get_Update_Date;
258:

Line 260: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND

256:
257: CLOSE C_Get_Update_Date;
258:
259: IF (p_qte_header_rec.last_update_date IS NOT NULL AND
260: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND
261: (l_last_upd_date <> p_qte_header_rec.last_update_date) THEN
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
264: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');

Line 262: x_return_status := FND_API.G_RET_STS_ERROR;

258:
259: IF (p_qte_header_rec.last_update_date IS NOT NULL AND
260: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND
261: (l_last_upd_date <> p_qte_header_rec.last_update_date) THEN
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
264: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
265: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
266: FND_MSG_PUB.ADD;

Line 268: RAISE FND_API.G_EXC_ERROR;

264: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
265: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
266: FND_MSG_PUB.ADD;
267: END IF;
268: RAISE FND_API.G_EXC_ERROR;
269: END IF;
270: -- End: Check Whether record has been changed
271:
272: -- Check if a concurrent lock exists

Line 277: IF (lx_return_status = FND_API.G_TRUE) THEN

273: ASO_CONC_REQ_INT.Lock_Exists(
274: p_quote_header_id => p_qte_header_rec.quote_header_id,
275: x_status => lx_return_status);
276:
277: IF (lx_return_status = FND_API.G_TRUE) THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
280: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
281: FND_MSG_PUB.ADD;

Line 278: x_return_status := FND_API.G_RET_STS_ERROR;

274: p_quote_header_id => p_qte_header_rec.quote_header_id,
275: x_status => lx_return_status);
276:
277: IF (lx_return_status = FND_API.G_TRUE) THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
280: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
281: FND_MSG_PUB.ADD;
282: END IF;

Line 283: RAISE FND_API.G_EXC_ERROR;

279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
280: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
281: FND_MSG_PUB.ADD;
282: END IF;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285: -- End: Check if a concurrent lock exists
286: -- END BASIC VALIDATIONS
287:

Line 318: P_Init_Msg_List => FND_API.G_FALSE,

314: aso_debug_pub.add('Reassign_Flag: '||l_Reassign_Flag,1,'Y');
315: END IF;
316:
317: ASO_SALES_TEAM_PVT.Get_Sales_Team (
318: P_Init_Msg_List => FND_API.G_FALSE,
319: P_Qte_Header_Rec => l_Qte_Header_Rec,
320: X_Winners_Rec => lx_gen_return_rec,
321: x_return_status => x_return_status,
322: x_msg_count => x_msg_count,

Line 330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

326: IF aso_debug_pub.g_debug_flag = 'Y' THEN
327: aso_debug_pub.add('After ASO_SALES_TEAM_PVT.get_sales_team: '||x_return_status,1,'Y');
328: END IF;
329:
330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
331: RAISE FND_API.G_EXC_ERROR;
332: END IF;
333: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 331: RAISE FND_API.G_EXC_ERROR;

327: aso_debug_pub.add('After ASO_SALES_TEAM_PVT.get_sales_team: '||x_return_status,1,'Y');
328: END IF;
329:
330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
331: RAISE FND_API.G_EXC_ERROR;
332: END IF;
333: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;

Line 333: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

329:
330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
331: RAISE FND_API.G_EXC_ERROR;
332: END IF;
333: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:
337: IF nvl(lx_gen_return_Rec.resource_id.count,0) = 0 THEN

Line 334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
331: RAISE FND_API.G_EXC_ERROR;
332: END IF;
333: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:
337: IF nvl(lx_gen_return_Rec.resource_id.count,0) = 0 THEN
338: IF P_Operation <> 'CREATE' AND P_Operation <> 'UPDATE' AND P_Operation <> 'SUBMIT' THEN

Line 356: P_Init_Msg_List => FND_API.G_FALSE,

352: IF aso_debug_pub.g_debug_flag = 'Y' THEN
353: aso_debug_pub.add('Before Update_Primary_SalesAgent(oprn=update): ',1,'Y');
354: END IF;
355: ASO_SALES_TEAM_PVT.Update_Primary_SalesInfo (
356: P_Init_Msg_List => FND_API.G_FALSE,
357: P_Qte_Header_Rec => l_Qte_Header_Rec,
358: P_Primary_SalesAgent => NULL,
359: P_Primary_SalesGrp => NULL,
360: P_reassign_flag => l_reassign_flag,

Line 371: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

367: IF aso_debug_pub.g_debug_flag = 'Y' THEN
368: aso_debug_pub.add('After Update_Primary_SalesInfo(oprn=update): '||x_return_status,1,'Y');
369: END IF;
370:
371: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 372: RAISE FND_API.G_EXC_ERROR;

368: aso_debug_pub.add('After Update_Primary_SalesInfo(oprn=update): '||x_return_status,1,'Y');
369: END IF;
370:
371: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
376: END IF;

Line 374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

370:
371: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377:
378: RAISE Leave_Proc;

Line 375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

371: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377:
378: RAISE Leave_Proc;
379:

Line 513: p_REQUEST_ID => FND_API.G_MISS_NUM,

509: p_CREATION_DATE => SYSDATE,
510: p_LAST_UPDATED_BY => G_USER_ID,
511: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
512: p_LAST_UPDATE_DATE => SYSDATE,
513: p_REQUEST_ID => FND_API.G_MISS_NUM,
514: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
515: p_PROGRAM_ID => FND_API.G_MISS_NUM,
516: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
517: p_KEEP_FLAG => 'N',

Line 514: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

510: p_LAST_UPDATED_BY => G_USER_ID,
511: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
512: p_LAST_UPDATE_DATE => SYSDATE,
513: p_REQUEST_ID => FND_API.G_MISS_NUM,
514: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
515: p_PROGRAM_ID => FND_API.G_MISS_NUM,
516: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
517: p_KEEP_FLAG => 'N',
518: p_UPDATE_ACCESS_FLAG => 'Y',

Line 515: p_PROGRAM_ID => FND_API.G_MISS_NUM,

511: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
512: p_LAST_UPDATE_DATE => SYSDATE,
513: p_REQUEST_ID => FND_API.G_MISS_NUM,
514: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
515: p_PROGRAM_ID => FND_API.G_MISS_NUM,
516: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
517: p_KEEP_FLAG => 'N',
518: p_UPDATE_ACCESS_FLAG => 'Y',
519: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 516: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

512: p_LAST_UPDATE_DATE => SYSDATE,
513: p_REQUEST_ID => FND_API.G_MISS_NUM,
514: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
515: p_PROGRAM_ID => FND_API.G_MISS_NUM,
516: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
517: p_KEEP_FLAG => 'N',
518: p_UPDATE_ACCESS_FLAG => 'Y',
519: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
520: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 519: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

515: p_PROGRAM_ID => FND_API.G_MISS_NUM,
516: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
517: p_KEEP_FLAG => 'N',
518: p_UPDATE_ACCESS_FLAG => 'Y',
519: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
520: p_TERRITORY_ID => FND_API.G_MISS_NUM,
521: p_TERRITORY_SOURCE_FLAG => 'N',
522: p_ROLE_ID => l_creator_role,
523: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 520: p_TERRITORY_ID => FND_API.G_MISS_NUM,

516: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
517: p_KEEP_FLAG => 'N',
518: p_UPDATE_ACCESS_FLAG => 'Y',
519: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
520: p_TERRITORY_ID => FND_API.G_MISS_NUM,
521: p_TERRITORY_SOURCE_FLAG => 'N',
522: p_ROLE_ID => l_creator_role,
523: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
524: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 523: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

519: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
520: p_TERRITORY_ID => FND_API.G_MISS_NUM,
521: p_TERRITORY_SOURCE_FLAG => 'N',
522: p_ROLE_ID => l_creator_role,
523: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
524: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
525: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
526: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
527: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 524: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

520: p_TERRITORY_ID => FND_API.G_MISS_NUM,
521: p_TERRITORY_SOURCE_FLAG => 'N',
522: p_ROLE_ID => l_creator_role,
523: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
524: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
525: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
526: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
527: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
528: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 525: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

521: p_TERRITORY_SOURCE_FLAG => 'N',
522: p_ROLE_ID => l_creator_role,
523: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
524: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
525: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
526: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
527: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
528: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
529: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 526: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

522: p_ROLE_ID => l_creator_role,
523: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
524: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
525: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
526: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
527: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
528: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
529: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
530: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 527: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

523: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
524: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
525: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
526: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
527: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
528: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
529: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
530: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
531: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 528: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

524: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
525: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
526: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
527: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
528: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
529: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
530: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
531: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
532: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 529: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

525: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
526: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
527: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
528: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
529: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
530: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
531: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
532: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
533: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 530: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

526: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
527: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
528: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
529: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
530: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
531: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
532: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
533: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
534: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 531: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

527: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
528: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
529: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
530: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
531: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
532: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
533: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
534: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
535: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 532: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

528: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
529: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
530: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
531: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
532: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
533: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
534: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
535: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
536: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 533: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

529: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
530: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
531: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
532: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
533: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
534: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
535: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
536: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
537: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 534: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

530: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
531: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
532: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
533: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
534: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
535: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
536: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
537: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
538: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 535: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

531: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
532: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
533: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
534: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
535: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
536: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
537: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
538: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
539: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 536: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

532: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
533: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
534: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
535: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
536: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
537: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
538: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
539: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
540: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 537: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

533: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
534: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
535: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
536: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
537: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
538: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
539: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
540: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
541: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 538: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

534: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
535: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
536: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
537: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
538: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
539: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
540: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
541: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
542: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 539: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

535: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
536: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
537: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
538: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
539: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
540: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
541: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
542: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
543: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 540: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

536: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
537: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
538: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
539: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
540: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
541: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
542: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
543: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
544: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 541: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

537: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
538: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
539: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
540: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
541: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
542: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
543: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
544: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
545: );

Line 542: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

538: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
539: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
540: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
541: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
542: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
543: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
544: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
545: );
546:

Line 543: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

539: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
540: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
541: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
542: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
543: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
544: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
545: );
546:
547: OPEN C_Valid_SalesRep (l_creator_res);

Line 544: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

540: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
541: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
542: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
543: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
544: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
545: );
546:
547: OPEN C_Valid_SalesRep (l_creator_res);
548: FETCH C_Valid_SalesRep INTO l_valid;

Line 574: x_return_status := FND_API.G_RET_STS_ERROR;

570: aso_debug_pub.add('nores:create:Assign_Sales_Team: Default SalesRep: '||l_primary_salesagent,1,'N');
571: aso_debug_pub.add('nores:create:Assign_Sales_Team: Default SalesGrp: '||l_primary_res_grp,1,'N');
572: END IF;
573: ELSE
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
576:
577: -- Created new message to display the error message more appropriately - Girish Bug 4654938
578: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');

Line 585: RAISE FND_API.G_EXC_ERROR;

581: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
582:
583: FND_MSG_PUB.Add;
584: END IF;
585: RAISE FND_API.G_EXC_ERROR;
586: END IF; -- salesrep_prof
587:
588: l_primary_role := l_default_role_prof;
589:

Line 696: p_REQUEST_ID => FND_API.G_MISS_NUM,

692: p_CREATION_DATE => SYSDATE,
693: p_LAST_UPDATED_BY => G_USER_ID,
694: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
695: p_LAST_UPDATE_DATE => SYSDATE,
696: p_REQUEST_ID => FND_API.G_MISS_NUM,
697: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
698: p_PROGRAM_ID => FND_API.G_MISS_NUM,
699: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
700: p_KEEP_FLAG => FND_API.G_MISS_CHAR,

Line 697: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

693: p_LAST_UPDATED_BY => G_USER_ID,
694: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
695: p_LAST_UPDATE_DATE => SYSDATE,
696: p_REQUEST_ID => FND_API.G_MISS_NUM,
697: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
698: p_PROGRAM_ID => FND_API.G_MISS_NUM,
699: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
700: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
701: p_UPDATE_ACCESS_FLAG => 'Y',

Line 698: p_PROGRAM_ID => FND_API.G_MISS_NUM,

694: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
695: p_LAST_UPDATE_DATE => SYSDATE,
696: p_REQUEST_ID => FND_API.G_MISS_NUM,
697: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
698: p_PROGRAM_ID => FND_API.G_MISS_NUM,
699: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
700: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
701: p_UPDATE_ACCESS_FLAG => 'Y',
702: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 699: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

695: p_LAST_UPDATE_DATE => SYSDATE,
696: p_REQUEST_ID => FND_API.G_MISS_NUM,
697: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
698: p_PROGRAM_ID => FND_API.G_MISS_NUM,
699: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
700: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
701: p_UPDATE_ACCESS_FLAG => 'Y',
702: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
703: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 700: p_KEEP_FLAG => FND_API.G_MISS_CHAR,

696: p_REQUEST_ID => FND_API.G_MISS_NUM,
697: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
698: p_PROGRAM_ID => FND_API.G_MISS_NUM,
699: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
700: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
701: p_UPDATE_ACCESS_FLAG => 'Y',
702: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
703: p_TERRITORY_ID => FND_API.G_MISS_NUM,
704: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

Line 702: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

698: p_PROGRAM_ID => FND_API.G_MISS_NUM,
699: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
700: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
701: p_UPDATE_ACCESS_FLAG => 'Y',
702: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
703: p_TERRITORY_ID => FND_API.G_MISS_NUM,
704: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
705: p_ROLE_ID => l_primary_role,
706: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 703: p_TERRITORY_ID => FND_API.G_MISS_NUM,

699: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
700: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
701: p_UPDATE_ACCESS_FLAG => 'Y',
702: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
703: p_TERRITORY_ID => FND_API.G_MISS_NUM,
704: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
705: p_ROLE_ID => l_primary_role,
706: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 704: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

700: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
701: p_UPDATE_ACCESS_FLAG => 'Y',
702: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
703: p_TERRITORY_ID => FND_API.G_MISS_NUM,
704: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
705: p_ROLE_ID => l_primary_role,
706: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
708: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

Line 706: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

702: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
703: p_TERRITORY_ID => FND_API.G_MISS_NUM,
704: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
705: p_ROLE_ID => l_primary_role,
706: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
708: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 707: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

703: p_TERRITORY_ID => FND_API.G_MISS_NUM,
704: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
705: p_ROLE_ID => l_primary_role,
706: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
708: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 708: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

704: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
705: p_ROLE_ID => l_primary_role,
706: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
708: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 709: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

705: p_ROLE_ID => l_primary_role,
706: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
708: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 710: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

706: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
708: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 711: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

707: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
708: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 712: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

708: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 713: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

709: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 714: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

710: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 715: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

711: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 716: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

712: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 717: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

713: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 718: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

714: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 719: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

715: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 720: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

716: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 721: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

717: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
725: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 722: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

718: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
725: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
726: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 723: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

719: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
725: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
726: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
727: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 724: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

720: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
725: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
726: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
727: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
728: );

Line 725: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

721: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
725: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
726: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
727: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
728: );
729:

Line 726: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

722: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
725: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
726: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
727: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
728: );
729:
730: END IF;

Line 727: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

723: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
725: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
726: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
727: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
728: );
729:
730: END IF;
731:

Line 1064: p_REQUEST_ID => FND_API.G_MISS_NUM,

1060: p_CREATION_DATE => SYSDATE,
1061: p_LAST_UPDATED_BY => G_USER_ID,
1062: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1063: p_LAST_UPDATE_DATE => SYSDATE,
1064: p_REQUEST_ID => FND_API.G_MISS_NUM,
1065: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1066: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1067: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1068: p_KEEP_FLAG => 'N',

Line 1065: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

1061: p_LAST_UPDATED_BY => G_USER_ID,
1062: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1063: p_LAST_UPDATE_DATE => SYSDATE,
1064: p_REQUEST_ID => FND_API.G_MISS_NUM,
1065: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1066: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1067: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1068: p_KEEP_FLAG => 'N',
1069: p_UPDATE_ACCESS_FLAG => 'Y',

Line 1066: p_PROGRAM_ID => FND_API.G_MISS_NUM,

1062: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1063: p_LAST_UPDATE_DATE => SYSDATE,
1064: p_REQUEST_ID => FND_API.G_MISS_NUM,
1065: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1066: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1067: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1068: p_KEEP_FLAG => 'N',
1069: p_UPDATE_ACCESS_FLAG => 'Y',
1070: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 1067: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

1063: p_LAST_UPDATE_DATE => SYSDATE,
1064: p_REQUEST_ID => FND_API.G_MISS_NUM,
1065: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1066: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1067: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1068: p_KEEP_FLAG => 'N',
1069: p_UPDATE_ACCESS_FLAG => 'Y',
1070: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1071: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 1070: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

1066: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1067: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1068: p_KEEP_FLAG => 'N',
1069: p_UPDATE_ACCESS_FLAG => 'Y',
1070: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1071: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1072: p_TERRITORY_SOURCE_FLAG => 'N',
1073: p_ROLE_ID => l_creator_role,
1074: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 1071: p_TERRITORY_ID => FND_API.G_MISS_NUM,

1067: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1068: p_KEEP_FLAG => 'N',
1069: p_UPDATE_ACCESS_FLAG => 'Y',
1070: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1071: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1072: p_TERRITORY_SOURCE_FLAG => 'N',
1073: p_ROLE_ID => l_creator_role,
1074: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1075: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 1074: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

1070: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1071: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1072: p_TERRITORY_SOURCE_FLAG => 'N',
1073: p_ROLE_ID => l_creator_role,
1074: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1075: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1076: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1077: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1078: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 1075: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

1071: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1072: p_TERRITORY_SOURCE_FLAG => 'N',
1073: p_ROLE_ID => l_creator_role,
1074: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1075: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1076: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1077: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1078: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1079: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 1076: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

1072: p_TERRITORY_SOURCE_FLAG => 'N',
1073: p_ROLE_ID => l_creator_role,
1074: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1075: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1076: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1077: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1078: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1079: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1080: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 1077: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

1073: p_ROLE_ID => l_creator_role,
1074: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1075: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1076: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1077: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1078: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1079: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1080: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1081: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 1078: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

1074: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1075: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1076: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1077: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1078: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1079: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1080: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1081: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1082: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 1079: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

1075: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1076: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1077: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1078: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1079: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1080: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1081: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1082: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1083: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 1080: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

1076: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1077: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1078: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1079: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1080: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1081: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1082: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1083: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1084: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 1081: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

1077: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1078: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1079: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1080: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1081: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1082: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1083: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1084: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1085: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 1082: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

1078: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1079: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1080: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1081: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1082: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1083: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1084: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1085: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1086: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 1083: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

1079: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1080: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1081: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1082: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1083: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1084: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1085: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1086: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1087: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 1084: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

1080: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1081: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1082: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1083: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1084: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1085: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1086: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1087: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1088: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 1085: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

1081: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1082: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1083: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1084: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1085: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1086: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1087: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1088: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1089: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 1086: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

1082: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1083: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1084: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1085: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1086: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1087: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1088: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1089: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1090: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 1087: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

1083: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1084: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1085: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1086: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1087: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1088: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1089: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1090: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1091: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 1088: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

1084: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1085: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1086: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1087: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1088: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1089: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1090: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1091: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1092: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 1089: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

1085: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1086: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1087: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1088: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1089: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1090: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1091: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1092: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1093: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 1090: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

1086: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1087: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1088: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1089: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1090: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1091: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1092: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1093: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1094: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 1091: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

1087: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1088: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1089: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1090: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1091: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1092: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1093: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1094: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1095: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 1092: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

1088: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1089: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1090: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1091: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1092: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1093: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1094: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1095: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1096: );

Line 1093: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

1089: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1090: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1091: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1092: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1093: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1094: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1095: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1096: );
1097:

Line 1094: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

1090: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1091: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1092: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1093: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1094: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1095: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1096: );
1097:
1098: END IF;

Line 1095: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

1091: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1092: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1093: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1094: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1095: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1096: );
1097:
1098: END IF;
1099:

Line 1120: P_Init_Msg_List => FND_API.G_FALSE,

1116: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1117: aso_debug_pub.add('Before Update_Primary_SalesAgent: ',1,'Y');
1118: END IF;
1119: ASO_SALES_TEAM_PVT.Update_Primary_SalesInfo (
1120: P_Init_Msg_List => FND_API.G_FALSE,
1121: P_Qte_Header_Rec => l_Qte_Header_Rec,
1122: P_Primary_SalesAgent => l_primary_salesagent,
1123: P_Primary_SalesGrp => l_creator_grp,
1124: P_reassign_flag => l_reassign_flag,

Line 1135: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1131: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1132: aso_debug_pub.add('After Update_Primary_SalesInfo: '||x_return_status,1,'Y');
1133: END IF;
1134:
1135: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;
1138: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1136: RAISE FND_API.G_EXC_ERROR;

1132: aso_debug_pub.add('After Update_Primary_SalesInfo: '||x_return_status,1,'Y');
1133: END IF;
1134:
1135: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;
1138: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140: END IF;

Line 1138: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1134:
1135: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;
1138: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140: END IF;
1141:
1142: -- Change START

Line 1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1135: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;
1138: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140: END IF;
1141:
1142: -- Change START
1143: -- Release 12 TAP Changes

Line 1161: WHEN FND_API.G_EXC_ERROR THEN

1157: EXCEPTION
1158: WHEN Leave_Proc THEN
1159: NULL;
1160:
1161: WHEN FND_API.G_EXC_ERROR THEN
1162: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1163: P_API_NAME => L_API_NAME,
1164: P_PKG_NAME => G_PKG_NAME,
1165: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1170: X_MSG_DATA => X_MSG_DATA,
1171: X_RETURN_STATUS => X_RETURN_STATUS
1172: );
1173:
1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1175: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1176: P_API_NAME => L_API_NAME,
1177: P_PKG_NAME => G_PKG_NAME,
1178: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 1208: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1204: -- Changes Done By Girish
1205: -- Commenting the whole procedure as the realtime call has changed.
1206: /*
1207: PROCEDURE Get_Sales_Team(
1208: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1209: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1210: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1211: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1212: X_Winners_Rec OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type,

Line 1255: x_return_status := FND_API.G_RET_STS_SUCCESS;

1251:
1252: -- Standard Start of API savepoint
1253: SAVEPOINT GET_SALES_TEAM_PVT;
1254:
1255: x_return_status := FND_API.G_RET_STS_SUCCESS;
1256:
1257: -- Get input info to pass to TM
1258: OPEN C_Get_Party_Info (P_Qte_Header_Rec.cust_party_id);
1259: FETCH C_Get_Party_Info INTO C_Party_Rec;

Line 1352: p_init_msg_list => FND_API.G_FALSE,

1348:
1349: -- Call the JTF Terr Assignment API
1350: JTF_TERR_ASSIGN_PUB.get_winners
1351: ( p_api_version_number => 1.0,
1352: p_init_msg_list => FND_API.G_FALSE,
1353:
1354: p_use_type => 'RESOURCE',
1355: p_source_id => -1001, -- Oracle Sales and Telesales
1356: p_trans_id => -1105, -- Quoting

Line 1359: p_resource_type => FND_API.G_MISS_CHAR,

1355: p_source_id => -1001, -- Oracle Sales and Telesales
1356: p_trans_id => -1105, -- Quoting
1357: p_trans_rec => lp_gen_bulk_rec,
1358:
1359: p_resource_type => FND_API.G_MISS_CHAR,
1360: p_role => FND_API.G_MISS_CHAR,
1361: p_top_level_terr_id => FND_API.G_MISS_NUM,
1362: p_num_winners => FND_API.G_MISS_NUM,
1363:

Line 1360: p_role => FND_API.G_MISS_CHAR,

1356: p_trans_id => -1105, -- Quoting
1357: p_trans_rec => lp_gen_bulk_rec,
1358:
1359: p_resource_type => FND_API.G_MISS_CHAR,
1360: p_role => FND_API.G_MISS_CHAR,
1361: p_top_level_terr_id => FND_API.G_MISS_NUM,
1362: p_num_winners => FND_API.G_MISS_NUM,
1363:
1364: x_return_status => x_return_status,

Line 1361: p_top_level_terr_id => FND_API.G_MISS_NUM,

1357: p_trans_rec => lp_gen_bulk_rec,
1358:
1359: p_resource_type => FND_API.G_MISS_CHAR,
1360: p_role => FND_API.G_MISS_CHAR,
1361: p_top_level_terr_id => FND_API.G_MISS_NUM,
1362: p_num_winners => FND_API.G_MISS_NUM,
1363:
1364: x_return_status => x_return_status,
1365: x_msg_count => x_msg_count,

Line 1362: p_num_winners => FND_API.G_MISS_NUM,

1358:
1359: p_resource_type => FND_API.G_MISS_CHAR,
1360: p_role => FND_API.G_MISS_CHAR,
1361: p_top_level_terr_id => FND_API.G_MISS_NUM,
1362: p_num_winners => FND_API.G_MISS_NUM,
1363:
1364: x_return_status => x_return_status,
1365: x_msg_count => x_msg_count,
1366: x_msg_data => x_msg_data,

Line 1388: WHEN FND_API.G_EXC_ERROR THEN

1384: END IF;
1385:
1386: EXCEPTION
1387:
1388: WHEN FND_API.G_EXC_ERROR THEN
1389: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1390: P_API_NAME => L_API_NAME,
1391: P_PKG_NAME => G_PKG_NAME,
1392: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1397: X_MSG_DATA => X_MSG_DATA,
1398: X_RETURN_STATUS => X_RETURN_STATUS
1399: );
1400:
1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1402: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1403: P_API_NAME => L_API_NAME,
1404: P_PKG_NAME => G_PKG_NAME,
1405: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 1436: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1432: -- Girish Sachdeva
1433: -- This procedure is changed to call the new JTF Terr Assignment API.
1434:
1435: PROCEDURE Get_Sales_Team(
1436: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1437: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1438: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1439: X_Winners_Rec OUT NOCOPY /* file.sql.39 change */ JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
1440: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1454: x_return_status := FND_API.G_RET_STS_SUCCESS;

1450:
1451: -- Standard Start of API savepoint
1452: SAVEPOINT GET_SALES_TEAM_PVT;
1453:
1454: x_return_status := FND_API.G_RET_STS_SUCCESS;
1455:
1456: lp_bulk_trans_id.trans_object_id1 := jtf_terr_number_list(P_Qte_Header_Rec.quote_header_id);
1457: lp_bulk_trans_id.trans_object_id2 := jtf_terr_number_list(null);
1458: lp_bulk_trans_id.trans_object_id3 := jtf_terr_number_list(null);

Line 1475: P_init_msg_list => FND_API.G_FALSE,

1471:
1472: -- Call the new JTF Terr Assignment API
1473: JTY_ASSIGN_REALTIME_PUB.get_winners (
1474: P_api_version_number => 1.0,
1475: P_init_msg_list => FND_API.G_FALSE,
1476: P_source_id => -1001 , /* Oracle Sales and Telesales */
1477: P_trans_id => -1105 , /* Quoting */
1478: P_mode => 'REAL TIME:RESOURCE', /* It will return winning territories and resources in real time */
1479: P_param_passing_mechanism => 'PBR',

Line 1509: WHEN FND_API.G_EXC_ERROR THEN

1505: END IF;
1506:
1507: EXCEPTION
1508:
1509: WHEN FND_API.G_EXC_ERROR THEN
1510: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1511: P_API_NAME => L_API_NAME,
1512: P_PKG_NAME => G_PKG_NAME,
1513: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1518: X_MSG_DATA => X_MSG_DATA,
1519: X_RETURN_STATUS => X_RETURN_STATUS
1520: );
1521:
1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1523: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1524: P_API_NAME => L_API_NAME,
1525: P_PKG_NAME => G_PKG_NAME,
1526: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 1554: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1550: -- Change END
1551:
1552:
1553: PROCEDURE Update_Primary_SalesInfo(
1554: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1555: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1556: P_Primary_SalesAgent IN NUMBER,
1557: P_Primary_SalesGrp IN NUMBER,
1558: P_Reassign_Flag IN VARCHAR2,

Line 1656: x_return_status := FND_API.G_RET_STS_SUCCESS;

1652:
1653: -- Standard Start of API savepoint
1654: SAVEPOINT UPDATE_PRIMARY_SALESINFO_PVT;
1655:
1656: x_return_status := FND_API.G_RET_STS_SUCCESS;
1657: l_primary_salesagent := p_primary_salesagent;
1658: l_primary_res_grp := p_primary_salesgrp;
1659: x_qte_header_rec := p_qte_header_rec;
1660:

Line 1713: x_return_status := FND_API.G_RET_STS_ERROR;

1709: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1710: aso_debug_pub.add('Assign_Sales_Team: Default SalesRep: '||l_primary_salesagent,1,'N');
1711: END IF;
1712: ELSE
1713: x_return_status := FND_API.G_RET_STS_ERROR;
1714: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1715: -- Created new message to display the error message more appropriately - Girish Bug 4654938
1716: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
1717: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);

Line 1723: RAISE FND_API.G_EXC_ERROR;

1719: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
1720:
1721: FND_MSG_PUB.Add;
1722: END IF;
1723: RAISE FND_API.G_EXC_ERROR;
1724: END IF; -- salesrep_prof
1725:
1726: l_primary_role := l_default_role_prof;
1727:

Line 1840: p_REQUEST_ID => FND_API.G_MISS_NUM,

1836: p_CREATION_DATE => SYSDATE,
1837: p_LAST_UPDATED_BY => G_USER_ID,
1838: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1839: p_LAST_UPDATE_DATE => SYSDATE,
1840: p_REQUEST_ID => FND_API.G_MISS_NUM,
1841: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1842: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1843: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1844: p_KEEP_FLAG => FND_API.G_MISS_CHAR,

Line 1841: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

1837: p_LAST_UPDATED_BY => G_USER_ID,
1838: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1839: p_LAST_UPDATE_DATE => SYSDATE,
1840: p_REQUEST_ID => FND_API.G_MISS_NUM,
1841: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1842: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1843: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1844: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
1845: p_UPDATE_ACCESS_FLAG => 'Y',

Line 1842: p_PROGRAM_ID => FND_API.G_MISS_NUM,

1838: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1839: p_LAST_UPDATE_DATE => SYSDATE,
1840: p_REQUEST_ID => FND_API.G_MISS_NUM,
1841: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1842: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1843: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1844: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
1845: p_UPDATE_ACCESS_FLAG => 'Y',
1846: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 1843: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

1839: p_LAST_UPDATE_DATE => SYSDATE,
1840: p_REQUEST_ID => FND_API.G_MISS_NUM,
1841: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1842: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1843: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1844: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
1845: p_UPDATE_ACCESS_FLAG => 'Y',
1846: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1847: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 1844: p_KEEP_FLAG => FND_API.G_MISS_CHAR,

1840: p_REQUEST_ID => FND_API.G_MISS_NUM,
1841: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1842: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1843: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1844: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
1845: p_UPDATE_ACCESS_FLAG => 'Y',
1846: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1847: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1848: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

Line 1846: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

1842: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1843: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1844: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
1845: p_UPDATE_ACCESS_FLAG => 'Y',
1846: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1847: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1848: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1849: p_ROLE_ID => l_primary_role,
1850: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 1847: p_TERRITORY_ID => FND_API.G_MISS_NUM,

1843: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1844: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
1845: p_UPDATE_ACCESS_FLAG => 'Y',
1846: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1847: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1848: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1849: p_ROLE_ID => l_primary_role,
1850: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1851: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 1848: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

1844: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
1845: p_UPDATE_ACCESS_FLAG => 'Y',
1846: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1847: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1848: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1849: p_ROLE_ID => l_primary_role,
1850: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1851: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1852: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

Line 1850: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

1846: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1847: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1848: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1849: p_ROLE_ID => l_primary_role,
1850: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1851: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1852: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1853: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1854: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 1851: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

1847: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1848: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1849: p_ROLE_ID => l_primary_role,
1850: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1851: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1852: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1853: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1854: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1855: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 1852: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

1848: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
1849: p_ROLE_ID => l_primary_role,
1850: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1851: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1852: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1853: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1854: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1855: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1856: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 1853: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

1849: p_ROLE_ID => l_primary_role,
1850: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1851: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1852: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1853: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1854: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1855: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1856: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1857: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 1854: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

1850: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1851: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1852: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1853: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1854: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1855: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1856: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1857: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1858: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 1855: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

1851: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1852: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1853: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1854: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1855: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1856: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1857: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1858: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1859: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 1856: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

1852: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1853: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1854: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1855: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1856: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1857: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1858: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1859: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1860: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 1857: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

1853: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1854: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1855: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1856: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1857: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1858: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1859: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1860: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1861: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 1858: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

1854: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1855: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1856: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1857: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1858: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1859: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1860: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1861: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1862: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 1859: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

1855: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1856: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1857: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1858: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1859: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1860: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1861: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1862: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1863: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 1860: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

1856: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1857: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1858: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1859: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1860: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1861: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1862: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1863: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1864: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 1861: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

1857: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1858: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1859: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1860: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1861: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1862: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1863: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1864: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1865: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 1862: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

1858: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1859: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1860: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1861: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1862: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1863: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1864: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1865: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1866: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 1863: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

1859: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1860: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1861: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1862: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1863: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1864: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1865: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1866: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1867: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 1864: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

1860: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1861: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1862: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1863: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1864: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1865: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1866: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1867: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1868: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 1865: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

1861: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1862: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1863: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1864: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1865: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1866: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1867: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1868: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1869: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 1866: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

1862: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1863: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1864: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1865: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1866: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1867: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1868: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1869: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1870: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 1867: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

1863: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1864: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1865: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1866: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1867: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1868: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1869: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1870: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1871: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 1868: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

1864: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1865: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1866: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1867: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1868: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1869: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1870: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1871: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1872: );

Line 1869: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

1865: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1866: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1867: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1868: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1869: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1870: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1871: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1872: );
1873: END IF; -- primary_res_kept <> Y

Line 1870: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

1866: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1867: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1868: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1869: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1870: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1871: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1872: );
1873: END IF; -- primary_res_kept <> Y
1874: END IF; -- primary_res_kept <> Y

Line 1871: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

1867: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1868: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1869: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1870: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1871: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1872: );
1873: END IF; -- primary_res_kept <> Y
1874: END IF; -- primary_res_kept <> Y
1875: END IF;

Line 1900: WHEN FND_API.G_EXC_ERROR THEN

1896: );
1897:
1898: EXCEPTION
1899:
1900: WHEN FND_API.G_EXC_ERROR THEN
1901: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1902: P_API_NAME => L_API_NAME,
1903: P_PKG_NAME => G_PKG_NAME,
1904: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1909: X_MSG_DATA => X_MSG_DATA,
1910: X_RETURN_STATUS => X_RETURN_STATUS
1911: );
1912:
1913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1914: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1915: P_API_NAME => L_API_NAME,
1916: P_PKG_NAME => G_PKG_NAME,
1917: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 1943: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1939: END Update_Primary_SalesInfo;
1940:
1941:
1942: PROCEDURE Opp_Quote_Primary_SalesRep(
1943: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1944: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1945: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1946: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1947: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 2068: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2064: -- Standard Start of API savepoint
2065: SAVEPOINT OPP_QUOTE_PRIMARY_SALESREP_PVT;
2066:
2067: -- Standard call to check for call compatibility.
2068: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2069: 1.0,
2070: l_api_name,
2071: G_PKG_NAME)
2072: THEN

Line 2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2069: 1.0,
2070: l_api_name,
2071: G_PKG_NAME)
2072: THEN
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2075: END IF;
2076:
2077: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2070: l_api_name,
2071: G_PKG_NAME)
2072: THEN
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2075: END IF;
2076:
2077: -- Initialize message list if p_init_msg_list is set to TRUE.
2078: IF FND_API.to_Boolean( p_init_msg_list )

Line 2078: IF FND_API.to_Boolean( p_init_msg_list )

2074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2075: END IF;
2076:
2077: -- Initialize message list if p_init_msg_list is set to TRUE.
2078: IF FND_API.to_Boolean( p_init_msg_list )
2079: THEN
2080: FND_MSG_PUB.initialize;
2081: END IF;
2082:

Line 2084: x_return_status := FND_API.G_RET_STS_SUCCESS;

2080: FND_MSG_PUB.initialize;
2081: END IF;
2082:
2083: -- Initialize API return status to SUCCESS
2084: x_return_status := FND_API.G_RET_STS_SUCCESS;
2085:
2086: --
2087: -- API body
2088: --

Line 2239: p_REQUEST_ID => FND_API.G_MISS_NUM,

2235: p_CREATION_DATE => SYSDATE,
2236: p_LAST_UPDATED_BY => G_USER_ID,
2237: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2238: p_LAST_UPDATE_DATE => SYSDATE,
2239: p_REQUEST_ID => FND_API.G_MISS_NUM,
2240: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2241: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2242: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2243: p_KEEP_FLAG => 'N',

Line 2240: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

2236: p_LAST_UPDATED_BY => G_USER_ID,
2237: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2238: p_LAST_UPDATE_DATE => SYSDATE,
2239: p_REQUEST_ID => FND_API.G_MISS_NUM,
2240: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2241: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2242: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2243: p_KEEP_FLAG => 'N',
2244: p_UPDATE_ACCESS_FLAG => 'Y',

Line 2241: p_PROGRAM_ID => FND_API.G_MISS_NUM,

2237: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2238: p_LAST_UPDATE_DATE => SYSDATE,
2239: p_REQUEST_ID => FND_API.G_MISS_NUM,
2240: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2241: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2242: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2243: p_KEEP_FLAG => 'N',
2244: p_UPDATE_ACCESS_FLAG => 'Y',
2245: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 2242: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

2238: p_LAST_UPDATE_DATE => SYSDATE,
2239: p_REQUEST_ID => FND_API.G_MISS_NUM,
2240: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2241: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2242: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2243: p_KEEP_FLAG => 'N',
2244: p_UPDATE_ACCESS_FLAG => 'Y',
2245: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2246: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 2245: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

2241: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2242: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2243: p_KEEP_FLAG => 'N',
2244: p_UPDATE_ACCESS_FLAG => 'Y',
2245: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2246: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2247: p_TERRITORY_SOURCE_FLAG => 'N',
2248: p_ROLE_ID => l_primary_role,
2249: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 2246: p_TERRITORY_ID => FND_API.G_MISS_NUM,

2242: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2243: p_KEEP_FLAG => 'N',
2244: p_UPDATE_ACCESS_FLAG => 'Y',
2245: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2246: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2247: p_TERRITORY_SOURCE_FLAG => 'N',
2248: p_ROLE_ID => l_primary_role,
2249: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2250: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 2249: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

2245: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2246: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2247: p_TERRITORY_SOURCE_FLAG => 'N',
2248: p_ROLE_ID => l_primary_role,
2249: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2250: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2251: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2252: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2253: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 2250: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

2246: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2247: p_TERRITORY_SOURCE_FLAG => 'N',
2248: p_ROLE_ID => l_primary_role,
2249: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2250: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2251: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2252: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2253: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2254: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 2251: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

2247: p_TERRITORY_SOURCE_FLAG => 'N',
2248: p_ROLE_ID => l_primary_role,
2249: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2250: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2251: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2252: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2253: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2254: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2255: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 2252: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

2248: p_ROLE_ID => l_primary_role,
2249: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2250: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2251: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2252: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2253: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2254: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2255: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2256: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 2253: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

2249: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2250: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2251: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2252: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2253: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2254: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2255: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2256: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2257: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 2254: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

2250: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2251: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2252: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2253: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2254: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2255: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2256: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2257: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2258: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 2255: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

2251: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2252: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2253: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2254: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2255: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2256: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2257: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2258: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2259: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 2256: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

2252: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2253: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2254: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2255: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2256: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2257: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2258: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2259: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2260: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 2257: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

2253: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2254: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2255: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2256: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2257: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2258: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2259: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2260: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2261: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 2258: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

2254: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2255: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2256: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2257: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2258: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2259: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2260: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2261: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2262: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 2259: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

2255: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2256: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2257: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2258: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2259: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2260: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2261: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2262: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2263: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 2260: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

2256: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2257: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2258: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2259: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2260: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2261: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2262: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2263: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2264: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 2261: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

2257: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2258: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2259: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2260: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2261: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2262: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2263: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2264: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2265: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 2262: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

2258: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2259: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2260: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2261: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2262: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2263: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2264: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2265: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2266: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 2263: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

2259: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2260: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2261: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2262: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2263: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2264: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2265: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2266: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2267: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 2264: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

2260: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2261: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2262: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2263: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2264: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2265: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2266: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2267: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2268: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 2265: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

2261: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2262: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2263: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2264: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2265: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2266: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2267: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2268: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2269: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 2266: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

2262: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2263: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2264: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2265: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2266: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2267: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2268: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2269: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2270: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 2267: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

2263: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2264: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2265: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2266: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2267: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2268: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2269: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2270: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2271: );

Line 2268: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

2264: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2265: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2266: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2267: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2268: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2269: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2270: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2271: );
2272:

Line 2269: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

2265: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2266: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2267: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2268: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2269: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2270: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2271: );
2272:
2273: END IF; -- creator_found

Line 2270: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

2266: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2267: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2268: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2269: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2270: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2271: );
2272:
2273: END IF; -- creator_found
2274:

Line 2300: x_return_status := FND_API.G_RET_STS_ERROR;

2296: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2297: aso_debug_pub.add('Opp_Qte_PS: Default SalesRep: '||l_primary_salesagent,1,'N');
2298: END IF;
2299: ELSE
2300: x_return_status := FND_API.G_RET_STS_ERROR;
2301: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2302:
2303: -- Created new message to display the error message more appropriately - Girish Bug 4654938
2304: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');

Line 2311: RAISE FND_API.G_EXC_ERROR;

2307: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
2308:
2309: FND_MSG_PUB.Add;
2310: END IF;
2311: RAISE FND_API.G_EXC_ERROR;
2312: END IF; -- salesrep_prof
2313:
2314: l_primary_role := l_default_role_prof;
2315:

Line 2418: p_REQUEST_ID => FND_API.G_MISS_NUM,

2414: p_CREATION_DATE => SYSDATE,
2415: p_LAST_UPDATED_BY => G_USER_ID,
2416: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2417: p_LAST_UPDATE_DATE => SYSDATE,
2418: p_REQUEST_ID => FND_API.G_MISS_NUM,
2419: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2420: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2421: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2422: p_KEEP_FLAG => FND_API.G_MISS_CHAR,

Line 2419: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

2415: p_LAST_UPDATED_BY => G_USER_ID,
2416: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2417: p_LAST_UPDATE_DATE => SYSDATE,
2418: p_REQUEST_ID => FND_API.G_MISS_NUM,
2419: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2420: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2421: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2422: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2423: p_UPDATE_ACCESS_FLAG => 'Y',

Line 2420: p_PROGRAM_ID => FND_API.G_MISS_NUM,

2416: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2417: p_LAST_UPDATE_DATE => SYSDATE,
2418: p_REQUEST_ID => FND_API.G_MISS_NUM,
2419: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2420: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2421: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2422: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2423: p_UPDATE_ACCESS_FLAG => 'Y',
2424: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 2421: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

2417: p_LAST_UPDATE_DATE => SYSDATE,
2418: p_REQUEST_ID => FND_API.G_MISS_NUM,
2419: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2420: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2421: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2422: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2423: p_UPDATE_ACCESS_FLAG => 'Y',
2424: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2425: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 2422: p_KEEP_FLAG => FND_API.G_MISS_CHAR,

2418: p_REQUEST_ID => FND_API.G_MISS_NUM,
2419: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2420: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2421: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2422: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2423: p_UPDATE_ACCESS_FLAG => 'Y',
2424: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2425: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2426: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

Line 2424: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

2420: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2421: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2422: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2423: p_UPDATE_ACCESS_FLAG => 'Y',
2424: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2425: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2426: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2427: p_ROLE_ID => l_primary_role,
2428: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 2425: p_TERRITORY_ID => FND_API.G_MISS_NUM,

2421: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2422: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2423: p_UPDATE_ACCESS_FLAG => 'Y',
2424: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2425: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2426: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2427: p_ROLE_ID => l_primary_role,
2428: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2429: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 2426: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

2422: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2423: p_UPDATE_ACCESS_FLAG => 'Y',
2424: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2425: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2426: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2427: p_ROLE_ID => l_primary_role,
2428: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2429: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2430: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

Line 2428: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

2424: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2425: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2426: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2427: p_ROLE_ID => l_primary_role,
2428: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2429: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2430: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2431: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2432: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 2429: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

2425: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2426: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2427: p_ROLE_ID => l_primary_role,
2428: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2429: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2430: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2431: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2432: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2433: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 2430: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

2426: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2427: p_ROLE_ID => l_primary_role,
2428: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2429: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2430: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2431: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2432: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2433: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2434: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 2431: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

2427: p_ROLE_ID => l_primary_role,
2428: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2429: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2430: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2431: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2432: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2433: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2434: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2435: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 2432: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

2428: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2429: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2430: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2431: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2432: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2433: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2434: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2435: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2436: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 2433: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

2429: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2430: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2431: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2432: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2433: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2434: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2435: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2436: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2437: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 2434: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

2430: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2431: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2432: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2433: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2434: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2435: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2436: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2437: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2438: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 2435: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

2431: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2432: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2433: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2434: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2435: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2436: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2437: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2438: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2439: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 2436: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

2432: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2433: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2434: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2435: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2436: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2437: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2438: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2439: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2440: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 2437: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

2433: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2434: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2435: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2436: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2437: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2438: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2439: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2440: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2441: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 2438: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

2434: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2435: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2436: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2437: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2438: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2439: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2440: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2441: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2442: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 2439: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

2435: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2436: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2437: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2438: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2439: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2440: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2441: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2442: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2443: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 2440: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

2436: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2437: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2438: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2439: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2440: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2441: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2442: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2443: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2444: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 2441: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

2437: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2438: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2439: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2440: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2441: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2442: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2443: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2444: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2445: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 2442: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

2438: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2439: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2440: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2441: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2442: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2443: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2444: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2445: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2446: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 2443: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

2439: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2440: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2441: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2442: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2443: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2444: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2445: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2446: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2447: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 2444: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

2440: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2441: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2442: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2443: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2444: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2445: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2446: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2447: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2448: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 2445: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

2441: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2442: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2443: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2444: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2445: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2446: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2447: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2448: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2449: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 2446: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

2442: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2443: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2444: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2445: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2446: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2447: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2448: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2449: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2450: );

Line 2447: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

2443: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2444: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2445: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2446: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2447: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2448: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2449: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2450: );
2451:

Line 2448: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

2444: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2445: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2446: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2447: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2448: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2449: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2450: );
2451:
2452: END IF;

Line 2449: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

2445: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2446: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2447: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2448: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2449: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2450: );
2451:
2452: END IF;
2453:

Line 2478: WHEN FND_API.G_EXC_ERROR THEN

2474: );
2475:
2476: EXCEPTION
2477:
2478: WHEN FND_API.G_EXC_ERROR THEN
2479: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2480: P_API_NAME => L_API_NAME,
2481: P_PKG_NAME => G_PKG_NAME,
2482: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 2491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2487: X_MSG_DATA => X_MSG_DATA,
2488: X_RETURN_STATUS => X_RETURN_STATUS
2489: );
2490:
2491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2492: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2493: P_API_NAME => L_API_NAME,
2494: P_PKG_NAME => G_PKG_NAME,
2495: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,