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 25: x_return_status := FND_API.G_RET_STS_SUCCESS;

21: x_return_status OUT NOCOPY VARCHAR2) IS
22: BEGIN
23:
24: aso_debug_pub.add('Begin INSERT_ACCESSES_ACCOUNTS',1,'Y');
25: x_return_status := FND_API.G_RET_STS_SUCCESS;
26: IF p_WinningTerrMember_tbl.resource_id.COUNT > 0 THEN
27:
28: FOR l_index IN p_WinningTerrMember_tbl.resource_id.FIRST..p_WinningTerrMember_tbl.resource_id.LAST LOOP
29:

Line 76: x_return_status := FND_API.G_RET_STS_ERROR;

72: aso_debug_pub.add('Proc INSERT_ACCESSES_ACCOUNTS exception part',1,'Y');
73:
74: x_errbuf := SQLERRM;
75: x_retcode := SQLCODE;
76: x_return_status := FND_API.G_RET_STS_ERROR;
77: END INSERT_ACCESSES_ACCOUNTS;
78:
79: /************************** Start Explode Teams ******************/
80: PROCEDURE EXPLODE_TEAMS(

Line 113: x_return_status := FND_API.G_RET_STS_SUCCESS;

109: BEGIN
110:
111: aso_debug_pub.add('Explode Team',1,'Y');
112:
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114: -- l_resource_type := 'RS_TEAM';
115: /* Get resources within a resource team */
116: /** Note
117: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL

Line 288: x_return_status := FND_API.G_RET_STS_ERROR;

284: WHEN others THEN
285: -- AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
286: x_errbuf := SQLERRM;
287: x_retcode := SQLCODE;
288: x_return_status := FND_API.G_RET_STS_ERROR;
289: END EXPLODE_TEAMS;
290: /************************** End Explode Teams ******************/
291:
292:

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

290: /************************** End Explode Teams ******************/
291:
292:
293: PROCEDURE Assign_Sales_Team(
294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
296: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
297: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
298: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,

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

291:
292:
293: PROCEDURE Assign_Sales_Team(
294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
296: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
297: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
298: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
299: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

295: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
296: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
297: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
298: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
299: P_Operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
301: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
302: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
303: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 464: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

460: -- Standard Start of API savepoint
461: SAVEPOINT ASSIGN_SALES_TEAM_PVT;
462:
463: -- Standard call to check for call compatibility.
464: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
465: 1.0,
466: l_api_name,
467: G_PKG_NAME)
468: THEN

Line 469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

465: 1.0,
466: l_api_name,
467: G_PKG_NAME)
468: THEN
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;
472:
473: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

466: l_api_name,
467: G_PKG_NAME)
468: THEN
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;
472:
473: -- Initialize message list if p_init_msg_list is set to TRUE.
474: IF FND_API.to_Boolean( p_init_msg_list )

Line 474: IF FND_API.to_Boolean( p_init_msg_list )

470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;
472:
473: -- Initialize message list if p_init_msg_list is set to TRUE.
474: IF FND_API.to_Boolean( p_init_msg_list )
475: THEN
476: FND_MSG_PUB.initialize;
477: END IF;
478:

Line 480: x_return_status := FND_API.G_RET_STS_SUCCESS;

476: FND_MSG_PUB.initialize;
477: END IF;
478:
479: -- Initialize API return status to SUCCESS
480: x_return_status := FND_API.G_RET_STS_SUCCESS;
481:
482: --
483: -- API body
484: --

Line 506: x_return_status := FND_API.G_RET_STS_ERROR;

502: OPEN C_Quote_Exists(P_Qte_Header_Rec.Quote_Header_Id);
503: FETCH C_Quote_Exists INTO l_Exists_Flag;
504: IF (C_Quote_Exists%NOTFOUND) OR l_Exists_Flag <> 'Y' THEN
505: CLOSE C_Quote_Exists;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
508: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
509: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
510: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_rec.quote_header_id), FALSE);

Line 513: RAISE FND_API.G_EXC_ERROR;

509: FND_MESSAGE.Set_Token('COLUMN', 'ORIGINAL_QUOTE_ID', FALSE);
510: FND_MESSAGE.Set_Token('VALUE', TO_CHAR(p_qte_header_rec.quote_header_id), FALSE);
511: FND_MSG_PUB.ADD;
512: END IF;
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515: CLOSE C_Quote_Exists;
516: -- End: Check if quote header id exists
517:

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

519: OPEN C_Get_Update_Date(P_Qte_Header_Rec.Quote_Header_Id);
520: FETCH C_Get_Update_Date INTO l_last_upd_date;
521:
522: IF (C_Get_Update_Date%NOTFOUND) OR
523: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
526: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
527: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line 524: x_return_status := FND_API.G_RET_STS_ERROR;

520: FETCH C_Get_Update_Date INTO l_last_upd_date;
521:
522: IF (C_Get_Update_Date%NOTFOUND) OR
523: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
526: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
527: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
528: FND_MSG_PUB.ADD;

Line 531: RAISE FND_API.G_EXC_ERROR;

527: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
528: FND_MSG_PUB.ADD;
529: END IF;
530: CLOSE C_Get_Update_Date;
531: RAISE FND_API.G_EXC_ERROR;
532: END IF;
533:
534: CLOSE C_Get_Update_Date;
535:

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

533:
534: CLOSE C_Get_Update_Date;
535:
536: IF (p_qte_header_rec.last_update_date IS NOT NULL AND
537: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND
538: (l_last_upd_date <> p_qte_header_rec.last_update_date) THEN
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
541: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

535:
536: IF (p_qte_header_rec.last_update_date IS NOT NULL AND
537: p_qte_header_rec.last_update_date <> FND_API.G_MISS_DATE) AND
538: (l_last_upd_date <> p_qte_header_rec.last_update_date) THEN
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
541: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
542: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
543: FND_MSG_PUB.ADD;

Line 545: RAISE FND_API.G_EXC_ERROR;

541: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
542: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
543: FND_MSG_PUB.ADD;
544: END IF;
545: RAISE FND_API.G_EXC_ERROR;
546: END IF;
547: -- End: Check Whether record has been changed
548:
549: -- Check if a concurrent lock exists

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

550: ASO_CONC_REQ_INT.Lock_Exists(
551: p_quote_header_id => p_qte_header_rec.quote_header_id,
552: x_status => lx_return_status);
553:
554: IF (lx_return_status = FND_API.G_TRUE) THEN
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
557: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
558: FND_MSG_PUB.ADD;

Line 555: x_return_status := FND_API.G_RET_STS_ERROR;

551: p_quote_header_id => p_qte_header_rec.quote_header_id,
552: x_status => lx_return_status);
553:
554: IF (lx_return_status = FND_API.G_TRUE) THEN
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
557: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
558: FND_MSG_PUB.ADD;
559: END IF;

Line 560: RAISE FND_API.G_EXC_ERROR;

556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
557: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
558: FND_MSG_PUB.ADD;
559: END IF;
560: RAISE FND_API.G_EXC_ERROR;
561: END IF;
562: -- End: Check if a concurrent lock exists
563: -- END BASIC VALIDATIONS
564:

Line 585: p_qte_header_rec.cust_account_id <> FND_API.G_MISS_NUM) Then

581: /*** Start : Code change done for Bug 11076978 ***/
582: If (NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'Y') Then
583: If (l_sales_team_prof = 'FULL' OR l_sales_team_prof = 'PARTIAL') Then
584: If (p_qte_header_rec.cust_account_id IS NOT NULL AND
585: p_qte_header_rec.cust_account_id <> FND_API.G_MISS_NUM) Then
586: If (l_qte_header_rec.cust_account_id <> P_Qte_Header_Rec.cust_account_id) Then
587: l_qte_header_rec := P_Qte_Header_Rec;
588: End If;
589: End If;

Line 609: P_Init_Msg_List => FND_API.G_FALSE,

605: aso_debug_pub.add('Reassign_Flag: '||l_Reassign_Flag,1,'Y');
606: END IF;
607:
608: ASO_SALES_TEAM_PVT.Get_Sales_Team (
609: P_Init_Msg_List => FND_API.G_FALSE,
610: P_Qte_Header_Rec => l_Qte_Header_Rec,
611: X_Winners_Rec => lx_gen_return_rec,
612: x_return_status => x_return_status,
613: x_msg_count => x_msg_count,

Line 621: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

617: IF aso_debug_pub.g_debug_flag = 'Y' THEN
618: aso_debug_pub.add('After ASO_SALES_TEAM_PVT.get_sales_team: '||x_return_status,1,'Y');
619: END IF;
620:
621: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 622: RAISE FND_API.G_EXC_ERROR;

618: aso_debug_pub.add('After ASO_SALES_TEAM_PVT.get_sales_team: '||x_return_status,1,'Y');
619: END IF;
620:
621: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626: END IF;

Line 624: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

620:
621: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626: END IF;
627:
628: IF nvl(lx_gen_return_Rec.resource_id.count,0) = 0 THEN

Line 625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

621: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626: END IF;
627:
628: IF nvl(lx_gen_return_Rec.resource_id.count,0) = 0 THEN
629: IF P_Operation <> 'CREATE' AND P_Operation <> 'UPDATE' AND P_Operation <> 'SUBMIT' THEN

Line 647: P_Init_Msg_List => FND_API.G_FALSE,

643: IF aso_debug_pub.g_debug_flag = 'Y' THEN
644: aso_debug_pub.add('Before Update_Primary_SalesAgent(oprn=update): ',1,'Y');
645: END IF;
646: ASO_SALES_TEAM_PVT.Update_Primary_SalesInfo (
647: P_Init_Msg_List => FND_API.G_FALSE,
648: P_Qte_Header_Rec => l_Qte_Header_Rec,
649: P_Primary_SalesAgent => NULL,
650: P_Primary_SalesGrp => NULL,
651: P_reassign_flag => l_reassign_flag,

Line 662: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

658: IF aso_debug_pub.g_debug_flag = 'Y' THEN
659: aso_debug_pub.add('After Update_Primary_SalesInfo(oprn=update): '||x_return_status,1,'Y');
660: END IF;
661:
662: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 663: RAISE FND_API.G_EXC_ERROR;

659: aso_debug_pub.add('After Update_Primary_SalesInfo(oprn=update): '||x_return_status,1,'Y');
660: END IF;
661:
662: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END IF;

Line 665: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

661:
662: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END IF;
668:
669: RAISE Leave_Proc;

Line 666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

662: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END IF;
668:
669: RAISE Leave_Proc;
670:

Line 804: p_REQUEST_ID => FND_API.G_MISS_NUM,

800: p_CREATION_DATE => SYSDATE,
801: p_LAST_UPDATED_BY => G_USER_ID,
802: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
803: p_LAST_UPDATE_DATE => SYSDATE,
804: p_REQUEST_ID => FND_API.G_MISS_NUM,
805: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
806: p_PROGRAM_ID => FND_API.G_MISS_NUM,
807: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
808: p_KEEP_FLAG => 'N',

Line 805: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

801: p_LAST_UPDATED_BY => G_USER_ID,
802: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
803: p_LAST_UPDATE_DATE => SYSDATE,
804: p_REQUEST_ID => FND_API.G_MISS_NUM,
805: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
806: p_PROGRAM_ID => FND_API.G_MISS_NUM,
807: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
808: p_KEEP_FLAG => 'N',
809: p_UPDATE_ACCESS_FLAG => 'Y',

Line 806: p_PROGRAM_ID => FND_API.G_MISS_NUM,

802: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
803: p_LAST_UPDATE_DATE => SYSDATE,
804: p_REQUEST_ID => FND_API.G_MISS_NUM,
805: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
806: p_PROGRAM_ID => FND_API.G_MISS_NUM,
807: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
808: p_KEEP_FLAG => 'N',
809: p_UPDATE_ACCESS_FLAG => 'Y',
810: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 807: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

803: p_LAST_UPDATE_DATE => SYSDATE,
804: p_REQUEST_ID => FND_API.G_MISS_NUM,
805: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
806: p_PROGRAM_ID => FND_API.G_MISS_NUM,
807: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
808: p_KEEP_FLAG => 'N',
809: p_UPDATE_ACCESS_FLAG => 'Y',
810: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
811: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 810: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

806: p_PROGRAM_ID => FND_API.G_MISS_NUM,
807: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
808: p_KEEP_FLAG => 'N',
809: p_UPDATE_ACCESS_FLAG => 'Y',
810: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
811: p_TERRITORY_ID => FND_API.G_MISS_NUM,
812: p_TERRITORY_SOURCE_FLAG => 'N',
813: p_ROLE_ID => l_creator_role,
814: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 811: p_TERRITORY_ID => FND_API.G_MISS_NUM,

807: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
808: p_KEEP_FLAG => 'N',
809: p_UPDATE_ACCESS_FLAG => 'Y',
810: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
811: p_TERRITORY_ID => FND_API.G_MISS_NUM,
812: p_TERRITORY_SOURCE_FLAG => 'N',
813: p_ROLE_ID => l_creator_role,
814: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
815: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 814: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

810: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
811: p_TERRITORY_ID => FND_API.G_MISS_NUM,
812: p_TERRITORY_SOURCE_FLAG => 'N',
813: p_ROLE_ID => l_creator_role,
814: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
815: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
816: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
817: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
818: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 815: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

811: p_TERRITORY_ID => FND_API.G_MISS_NUM,
812: p_TERRITORY_SOURCE_FLAG => 'N',
813: p_ROLE_ID => l_creator_role,
814: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
815: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
816: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
817: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
818: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
819: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 816: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

812: p_TERRITORY_SOURCE_FLAG => 'N',
813: p_ROLE_ID => l_creator_role,
814: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
815: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
816: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
817: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
818: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
819: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
820: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 817: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

813: p_ROLE_ID => l_creator_role,
814: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
815: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
816: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
817: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
818: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
819: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
820: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
821: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 818: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

814: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
815: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
816: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
817: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
818: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
819: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
820: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
821: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
822: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 819: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

815: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
816: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
817: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
818: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
819: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
820: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
821: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
822: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
823: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 820: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

816: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
817: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
818: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
819: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
820: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
821: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
822: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
823: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
824: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 821: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

817: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
818: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
819: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
820: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
821: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
822: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
823: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
824: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
825: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 822: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

818: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
819: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
820: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
821: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
822: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
823: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
824: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
825: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
826: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 823: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

819: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
820: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
821: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
822: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
823: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
824: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
825: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
826: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
827: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 824: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

820: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
821: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
822: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
823: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
824: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
825: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
826: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
827: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
828: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 825: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

821: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
822: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
823: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
824: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
825: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
826: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
827: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
828: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
829: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 826: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

822: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
823: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
824: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
825: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
826: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
827: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
828: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
829: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
830: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 827: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

823: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
824: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
825: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
826: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
827: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
828: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
829: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
830: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
831: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 828: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

824: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
825: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
826: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
827: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
828: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
829: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
830: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
831: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
832: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 829: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

825: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
826: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
827: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
828: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
829: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
830: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
831: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
832: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
833: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 830: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

826: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
827: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
828: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
829: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
830: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
831: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
832: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
833: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
834: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 831: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

827: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
828: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
829: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
830: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
831: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
832: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
833: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
834: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
835: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 832: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

828: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
829: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
830: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
831: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
832: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
833: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
834: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
835: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
836: );

Line 833: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

829: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
830: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
831: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
832: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
833: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
834: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
835: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
836: );
837:

Line 834: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

830: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
831: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
832: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
833: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
834: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
835: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
836: );
837:
838: OPEN C_Valid_SalesRep (l_creator_res);

Line 835: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

831: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
832: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
833: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
834: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
835: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
836: );
837:
838: OPEN C_Valid_SalesRep (l_creator_res);
839: FETCH C_Valid_SalesRep INTO l_valid;

Line 865: x_return_status := FND_API.G_RET_STS_ERROR;

861: aso_debug_pub.add('nores:create:Assign_Sales_Team: Default SalesRep: '||l_primary_salesagent,1,'N');
862: aso_debug_pub.add('nores:create:Assign_Sales_Team: Default SalesGrp: '||l_primary_res_grp,1,'N');
863: END IF;
864: ELSE
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
867:
868: -- Created new message to display the error message more appropriately - Girish Bug 4654938
869: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');

Line 876: RAISE FND_API.G_EXC_ERROR;

872: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
873:
874: FND_MSG_PUB.Add;
875: END IF;
876: RAISE FND_API.G_EXC_ERROR;
877: END IF; -- salesrep_prof
878:
879: l_primary_role := l_default_role_prof;
880:

Line 987: p_REQUEST_ID => FND_API.G_MISS_NUM,

983: p_CREATION_DATE => SYSDATE,
984: p_LAST_UPDATED_BY => G_USER_ID,
985: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
986: p_LAST_UPDATE_DATE => SYSDATE,
987: p_REQUEST_ID => FND_API.G_MISS_NUM,
988: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
989: p_PROGRAM_ID => FND_API.G_MISS_NUM,
990: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
991: p_KEEP_FLAG => FND_API.G_MISS_CHAR,

Line 988: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

984: p_LAST_UPDATED_BY => G_USER_ID,
985: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
986: p_LAST_UPDATE_DATE => SYSDATE,
987: p_REQUEST_ID => FND_API.G_MISS_NUM,
988: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
989: p_PROGRAM_ID => FND_API.G_MISS_NUM,
990: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
991: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
992: p_UPDATE_ACCESS_FLAG => 'Y',

Line 989: p_PROGRAM_ID => FND_API.G_MISS_NUM,

985: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
986: p_LAST_UPDATE_DATE => SYSDATE,
987: p_REQUEST_ID => FND_API.G_MISS_NUM,
988: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
989: p_PROGRAM_ID => FND_API.G_MISS_NUM,
990: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
991: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
992: p_UPDATE_ACCESS_FLAG => 'Y',
993: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 990: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

986: p_LAST_UPDATE_DATE => SYSDATE,
987: p_REQUEST_ID => FND_API.G_MISS_NUM,
988: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
989: p_PROGRAM_ID => FND_API.G_MISS_NUM,
990: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
991: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
992: p_UPDATE_ACCESS_FLAG => 'Y',
993: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
994: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 991: p_KEEP_FLAG => FND_API.G_MISS_CHAR,

987: p_REQUEST_ID => FND_API.G_MISS_NUM,
988: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
989: p_PROGRAM_ID => FND_API.G_MISS_NUM,
990: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
991: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
992: p_UPDATE_ACCESS_FLAG => 'Y',
993: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
994: p_TERRITORY_ID => FND_API.G_MISS_NUM,
995: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

Line 993: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

989: p_PROGRAM_ID => FND_API.G_MISS_NUM,
990: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
991: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
992: p_UPDATE_ACCESS_FLAG => 'Y',
993: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
994: p_TERRITORY_ID => FND_API.G_MISS_NUM,
995: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
996: p_ROLE_ID => l_primary_role,
997: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 994: p_TERRITORY_ID => FND_API.G_MISS_NUM,

990: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
991: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
992: p_UPDATE_ACCESS_FLAG => 'Y',
993: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
994: p_TERRITORY_ID => FND_API.G_MISS_NUM,
995: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
996: p_ROLE_ID => l_primary_role,
997: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
998: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 995: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

991: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
992: p_UPDATE_ACCESS_FLAG => 'Y',
993: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
994: p_TERRITORY_ID => FND_API.G_MISS_NUM,
995: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
996: p_ROLE_ID => l_primary_role,
997: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
998: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
999: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

Line 997: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

993: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
994: p_TERRITORY_ID => FND_API.G_MISS_NUM,
995: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
996: p_ROLE_ID => l_primary_role,
997: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
998: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
999: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1000: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1001: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 998: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

994: p_TERRITORY_ID => FND_API.G_MISS_NUM,
995: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
996: p_ROLE_ID => l_primary_role,
997: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
998: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
999: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1000: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1001: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1002: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 999: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

995: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
996: p_ROLE_ID => l_primary_role,
997: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
998: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
999: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1000: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1001: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1002: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1003: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 1000: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

996: p_ROLE_ID => l_primary_role,
997: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
998: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
999: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1000: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1001: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1002: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1003: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1004: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 1001: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

997: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
998: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
999: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1000: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1001: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1002: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1003: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1004: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1005: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 1002: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

998: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
999: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1000: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1001: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1002: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1003: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1004: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1005: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1006: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 1003: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

999: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1000: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1001: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1002: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1003: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1004: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1005: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1006: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1007: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 1004: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

1000: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1001: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1002: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1003: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1004: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1005: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1006: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1007: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1008: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 1005: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

1001: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1002: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1003: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1004: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1005: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1006: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1007: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1008: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1009: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 1006: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

1002: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1003: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1004: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1005: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1006: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1007: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1008: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1009: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1010: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 1007: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

1003: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1004: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1005: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1006: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1007: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1008: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1009: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1010: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1011: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 1008: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

1004: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1005: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1006: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1007: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1008: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1009: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1010: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1011: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1012: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 1009: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

1005: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1006: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1007: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1008: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1009: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1010: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1011: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1012: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1013: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 1010: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

1006: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1007: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1008: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1009: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1010: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1011: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1012: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1013: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1014: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 1011: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

1007: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1008: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1009: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1010: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1011: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1012: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1013: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1014: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1015: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 1012: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

1008: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1009: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1010: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1011: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1012: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1013: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1014: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1015: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1016: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 1013: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

1009: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1010: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1011: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1012: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1013: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1014: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1015: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1016: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1017: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 1014: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

1010: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1011: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1012: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1013: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1014: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1015: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1016: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1017: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1018: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 1015: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

1011: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1012: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1013: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1014: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1015: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1016: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1017: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1018: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1019: );

Line 1016: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

1012: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1013: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1014: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1015: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1016: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1017: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1018: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1019: );
1020:

Line 1017: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

1013: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1014: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1015: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1016: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1017: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1018: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1019: );
1020:
1021: END IF;

Line 1018: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

1014: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1015: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1016: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1017: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1018: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1019: );
1020:
1021: END IF;
1022:

Line 1358: p_REQUEST_ID => FND_API.G_MISS_NUM,

1354: p_CREATION_DATE => SYSDATE,
1355: p_LAST_UPDATED_BY => G_USER_ID,
1356: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1357: p_LAST_UPDATE_DATE => SYSDATE,
1358: p_REQUEST_ID => FND_API.G_MISS_NUM,
1359: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1360: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1361: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1362: p_KEEP_FLAG => 'N',

Line 1359: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

1355: p_LAST_UPDATED_BY => G_USER_ID,
1356: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1357: p_LAST_UPDATE_DATE => SYSDATE,
1358: p_REQUEST_ID => FND_API.G_MISS_NUM,
1359: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1360: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1361: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1362: p_KEEP_FLAG => 'N',
1363: p_UPDATE_ACCESS_FLAG => 'Y',

Line 1360: p_PROGRAM_ID => FND_API.G_MISS_NUM,

1356: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
1357: p_LAST_UPDATE_DATE => SYSDATE,
1358: p_REQUEST_ID => FND_API.G_MISS_NUM,
1359: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1360: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1361: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1362: p_KEEP_FLAG => 'N',
1363: p_UPDATE_ACCESS_FLAG => 'Y',
1364: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 1361: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

1357: p_LAST_UPDATE_DATE => SYSDATE,
1358: p_REQUEST_ID => FND_API.G_MISS_NUM,
1359: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
1360: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1361: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1362: p_KEEP_FLAG => 'N',
1363: p_UPDATE_ACCESS_FLAG => 'Y',
1364: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1365: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 1364: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

1360: p_PROGRAM_ID => FND_API.G_MISS_NUM,
1361: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1362: p_KEEP_FLAG => 'N',
1363: p_UPDATE_ACCESS_FLAG => 'Y',
1364: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1365: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1366: p_TERRITORY_SOURCE_FLAG => 'N',
1367: p_ROLE_ID => l_creator_role,
1368: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 1365: p_TERRITORY_ID => FND_API.G_MISS_NUM,

1361: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
1362: p_KEEP_FLAG => 'N',
1363: p_UPDATE_ACCESS_FLAG => 'Y',
1364: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1365: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1366: p_TERRITORY_SOURCE_FLAG => 'N',
1367: p_ROLE_ID => l_creator_role,
1368: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1369: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 1368: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

1364: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
1365: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1366: p_TERRITORY_SOURCE_FLAG => 'N',
1367: p_ROLE_ID => l_creator_role,
1368: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1369: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1370: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1371: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1372: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 1369: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

1365: p_TERRITORY_ID => FND_API.G_MISS_NUM,
1366: p_TERRITORY_SOURCE_FLAG => 'N',
1367: p_ROLE_ID => l_creator_role,
1368: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1369: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1370: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1371: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1372: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1373: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 1370: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

1366: p_TERRITORY_SOURCE_FLAG => 'N',
1367: p_ROLE_ID => l_creator_role,
1368: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1369: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1370: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1371: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1372: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1373: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1374: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 1371: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

1367: p_ROLE_ID => l_creator_role,
1368: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1369: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1370: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1371: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1372: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1373: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1374: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1375: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 1372: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

1368: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
1369: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1370: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1371: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1372: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1373: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1374: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1375: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1376: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 1373: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

1369: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1370: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1371: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1372: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1373: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1374: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1375: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1376: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1377: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 1374: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

1370: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1371: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1372: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1373: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1374: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1375: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1376: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1377: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1378: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 1375: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

1371: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1372: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1373: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1374: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1375: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1376: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1377: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1378: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1379: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 1376: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

1372: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1373: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1374: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1375: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1376: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1377: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1378: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1379: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1380: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 1377: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

1373: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1374: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1375: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1376: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1377: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1378: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1379: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1380: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1381: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 1378: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

1374: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1375: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1376: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1377: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1378: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1379: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1380: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1381: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1382: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 1379: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

1375: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1376: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1377: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1378: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1379: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1380: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1381: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1382: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1383: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 1380: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

1376: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1377: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1378: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1379: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1380: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1381: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1382: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1383: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1384: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 1381: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

1377: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1378: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1379: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1380: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1381: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1382: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1383: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1384: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1385: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 1382: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

1378: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1379: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1380: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1381: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1382: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1383: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1384: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1385: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1386: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 1383: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

1379: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1380: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1381: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1382: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1383: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1384: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1385: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1386: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1387: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 1384: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

1380: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1381: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1382: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1383: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1384: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1385: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1386: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1387: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1388: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 1385: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

1381: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1382: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1383: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1384: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1385: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1386: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1387: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1388: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1389: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 1386: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

1382: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1383: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1384: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1385: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1386: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1387: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1388: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1389: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1390: );

Line 1387: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

1383: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1384: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1385: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1386: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1387: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1388: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1389: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1390: );
1391:

Line 1388: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

1384: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
1385: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1386: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1387: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1388: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1389: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1390: );
1391:
1392: END IF;

Line 1389: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

1385: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
1386: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
1387: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
1388: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
1389: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
1390: );
1391:
1392: END IF;
1393:

Line 1414: P_Init_Msg_List => FND_API.G_FALSE,

1410: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1411: aso_debug_pub.add('Before Update_Primary_SalesAgent: ',1,'Y');
1412: END IF;
1413: ASO_SALES_TEAM_PVT.Update_Primary_SalesInfo (
1414: P_Init_Msg_List => FND_API.G_FALSE,
1415: P_Qte_Header_Rec => l_Qte_Header_Rec,
1416: P_Primary_SalesAgent => l_primary_salesagent,
1417: P_Primary_SalesGrp => l_creator_grp,
1418: P_reassign_flag => l_reassign_flag,

Line 1429: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1425: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1426: aso_debug_pub.add('After Update_Primary_SalesInfo: '||x_return_status,1,'Y');
1427: END IF;
1428:
1429: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1430: RAISE FND_API.G_EXC_ERROR;

1426: aso_debug_pub.add('After Update_Primary_SalesInfo: '||x_return_status,1,'Y');
1427: END IF;
1428:
1429: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1434: END IF;

Line 1432: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1428:
1429: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1434: END IF;
1435:
1436: -- Change START

Line 1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1429: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1434: END IF;
1435:
1436: -- Change START
1437: -- Release 12 TAP Changes

Line 1455: WHEN FND_API.G_EXC_ERROR THEN

1451: EXCEPTION
1452: WHEN Leave_Proc THEN
1453: NULL;
1454:
1455: WHEN FND_API.G_EXC_ERROR THEN
1456: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1457: P_API_NAME => L_API_NAME,
1458: P_PKG_NAME => G_PKG_NAME,
1459: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1464: X_MSG_DATA => X_MSG_DATA,
1465: X_RETURN_STATUS => X_RETURN_STATUS
1466: );
1467:
1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1470: P_API_NAME => L_API_NAME,
1471: P_PKG_NAME => G_PKG_NAME,
1472: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

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

1498: -- Changes Done By Girish
1499: -- Commenting the whole procedure as the realtime call has changed.
1500: /*
1501: PROCEDURE Get_Sales_Team(
1502: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1503: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1504: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
1505: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1506: X_Winners_Rec OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type,

Line 1549: x_return_status := FND_API.G_RET_STS_SUCCESS;

1545:
1546: -- Standard Start of API savepoint
1547: SAVEPOINT GET_SALES_TEAM_PVT;
1548:
1549: x_return_status := FND_API.G_RET_STS_SUCCESS;
1550:
1551: -- Get input info to pass to TM
1552: OPEN C_Get_Party_Info (P_Qte_Header_Rec.cust_party_id);
1553: FETCH C_Get_Party_Info INTO C_Party_Rec;

Line 1646: p_init_msg_list => FND_API.G_FALSE,

1642:
1643: -- Call the JTF Terr Assignment API
1644: JTF_TERR_ASSIGN_PUB.get_winners
1645: ( p_api_version_number => 1.0,
1646: p_init_msg_list => FND_API.G_FALSE,
1647:
1648: p_use_type => 'RESOURCE',
1649: p_source_id => -1001, -- Oracle Sales and Telesales
1650: p_trans_id => -1105, -- Quoting

Line 1653: p_resource_type => FND_API.G_MISS_CHAR,

1649: p_source_id => -1001, -- Oracle Sales and Telesales
1650: p_trans_id => -1105, -- Quoting
1651: p_trans_rec => lp_gen_bulk_rec,
1652:
1653: p_resource_type => FND_API.G_MISS_CHAR,
1654: p_role => FND_API.G_MISS_CHAR,
1655: p_top_level_terr_id => FND_API.G_MISS_NUM,
1656: p_num_winners => FND_API.G_MISS_NUM,
1657:

Line 1654: p_role => FND_API.G_MISS_CHAR,

1650: p_trans_id => -1105, -- Quoting
1651: p_trans_rec => lp_gen_bulk_rec,
1652:
1653: p_resource_type => FND_API.G_MISS_CHAR,
1654: p_role => FND_API.G_MISS_CHAR,
1655: p_top_level_terr_id => FND_API.G_MISS_NUM,
1656: p_num_winners => FND_API.G_MISS_NUM,
1657:
1658: x_return_status => x_return_status,

Line 1655: p_top_level_terr_id => FND_API.G_MISS_NUM,

1651: p_trans_rec => lp_gen_bulk_rec,
1652:
1653: p_resource_type => FND_API.G_MISS_CHAR,
1654: p_role => FND_API.G_MISS_CHAR,
1655: p_top_level_terr_id => FND_API.G_MISS_NUM,
1656: p_num_winners => FND_API.G_MISS_NUM,
1657:
1658: x_return_status => x_return_status,
1659: x_msg_count => x_msg_count,

Line 1656: p_num_winners => FND_API.G_MISS_NUM,

1652:
1653: p_resource_type => FND_API.G_MISS_CHAR,
1654: p_role => FND_API.G_MISS_CHAR,
1655: p_top_level_terr_id => FND_API.G_MISS_NUM,
1656: p_num_winners => FND_API.G_MISS_NUM,
1657:
1658: x_return_status => x_return_status,
1659: x_msg_count => x_msg_count,
1660: x_msg_data => x_msg_data,

Line 1682: WHEN FND_API.G_EXC_ERROR THEN

1678: END IF;
1679:
1680: EXCEPTION
1681:
1682: WHEN FND_API.G_EXC_ERROR THEN
1683: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1684: P_API_NAME => L_API_NAME,
1685: P_PKG_NAME => G_PKG_NAME,
1686: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1691: X_MSG_DATA => X_MSG_DATA,
1692: X_RETURN_STATUS => X_RETURN_STATUS
1693: );
1694:
1695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1696: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1697: P_API_NAME => L_API_NAME,
1698: P_PKG_NAME => G_PKG_NAME,
1699: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 1754: x_return_status := FND_API.G_RET_STS_SUCCESS;

1750:
1751: BEGIN
1752: aso_debug_pub.add('Proc EXPLODE_GROUPS_ACCOUNTS',1,'Y');
1753:
1754: x_return_status := FND_API.G_RET_STS_SUCCESS;
1755: -- l_resource_type := 'RS_TEAM';
1756: /* Get resources within a resource team */
1757: /** Note
1758: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL

Line 1839: x_return_status := FND_API.G_RET_STS_ERROR;

1835: aso_debug_pub.add('exception in EXPLODE_GROUPS_ACCOUNTS ',1,'Y');
1836:
1837: x_errbuf := SQLERRM;
1838: x_retcode := SQLCODE;
1839: x_return_status := FND_API.G_RET_STS_ERROR;
1840: aso_debug_pub.add('exception in EXPLODE_GROUPS_ACCOUNTS '||x_errbuf,1,'Y');
1841: aso_debug_pub.add('exception in EXPLODE_GROUPS_ACCOUNTS '||x_retcode,1,'Y');
1842: aso_debug_pub.add('exception in EXPLODE_GROUPS_ACCOUNTS '||x_return_status,1,'Y');
1843: END EXPLODE_GROUPS_ACCOUNTS;

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

1842: aso_debug_pub.add('exception in EXPLODE_GROUPS_ACCOUNTS '||x_return_status,1,'Y');
1843: END EXPLODE_GROUPS_ACCOUNTS;
1844:
1845: PROCEDURE Get_Sales_Team(
1846: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1847: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1848: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
1849: X_Winners_Rec OUT NOCOPY /* file.sql.39 change */ JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
1850: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1866: x_return_status := FND_API.G_RET_STS_SUCCESS;

1862:
1863: -- Standard Start of API savepoint
1864: SAVEPOINT GET_SALES_TEAM_PVT;
1865:
1866: x_return_status := FND_API.G_RET_STS_SUCCESS;
1867:
1868: lp_bulk_trans_id.trans_object_id1 := jtf_terr_number_list(P_Qte_Header_Rec.quote_header_id);
1869: lp_bulk_trans_id.trans_object_id2 := jtf_terr_number_list(null);
1870: lp_bulk_trans_id.trans_object_id3 := jtf_terr_number_list(null);

Line 1887: P_init_msg_list => FND_API.G_FALSE,

1883:
1884: -- Call the new JTF Terr Assignment API
1885: JTY_ASSIGN_REALTIME_PUB.get_winners (
1886: P_api_version_number => 1.0,
1887: P_init_msg_list => FND_API.G_FALSE,
1888: P_source_id => -1001 , /* Oracle Sales and Telesales */
1889: P_trans_id => -1105 , /* Quoting */
1890: P_mode => 'REAL TIME:RESOURCE', /* It will return winning territories and resources in real time */
1891: P_param_passing_mechanism => 'PBR',

Line 1937: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

1933: x_return_status => l_return_status);
1934:
1935:
1936:
1937: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
1938:
1939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1940: End If;
1941:

Line 1939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1935:
1936:
1937: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
1938:
1939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1940: End If;
1941:
1942:
1943: END IF;

Line 1948: WHEN FND_API.G_EXC_ERROR THEN

1944: END IF;
1945:
1946: EXCEPTION
1947:
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1950: P_API_NAME => L_API_NAME,
1951: P_PKG_NAME => G_PKG_NAME,
1952: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1957: X_MSG_DATA => X_MSG_DATA,
1958: X_RETURN_STATUS => X_RETURN_STATUS
1959: );
1960:
1961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1962: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1963: P_API_NAME => L_API_NAME,
1964: P_PKG_NAME => G_PKG_NAME,
1965: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

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

1989: -- Change END
1990:
1991:
1992: PROCEDURE Update_Primary_SalesInfo(
1993: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1994: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1995: P_Primary_SalesAgent IN NUMBER,
1996: P_Primary_SalesGrp IN NUMBER,
1997: P_Reassign_Flag IN VARCHAR2,

Line 2095: x_return_status := FND_API.G_RET_STS_SUCCESS;

2091:
2092: -- Standard Start of API savepoint
2093: SAVEPOINT UPDATE_PRIMARY_SALESINFO_PVT;
2094:
2095: x_return_status := FND_API.G_RET_STS_SUCCESS;
2096: l_primary_salesagent := p_primary_salesagent;
2097: l_primary_res_grp := p_primary_salesgrp;
2098: x_qte_header_rec := p_qte_header_rec;
2099:

Line 2152: x_return_status := FND_API.G_RET_STS_ERROR;

2148: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2149: aso_debug_pub.add('Assign_Sales_Team: Default SalesRep: '||l_primary_salesagent,1,'N');
2150: END IF;
2151: ELSE
2152: x_return_status := FND_API.G_RET_STS_ERROR;
2153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2154: -- Created new message to display the error message more appropriately - Girish Bug 4654938
2155: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
2156: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);

Line 2162: RAISE FND_API.G_EXC_ERROR;

2158: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
2159:
2160: FND_MSG_PUB.Add;
2161: END IF;
2162: RAISE FND_API.G_EXC_ERROR;
2163: END IF; -- salesrep_prof
2164:
2165: l_primary_role := l_default_role_prof;
2166:

Line 2279: p_REQUEST_ID => FND_API.G_MISS_NUM,

2275: p_CREATION_DATE => SYSDATE,
2276: p_LAST_UPDATED_BY => G_USER_ID,
2277: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2278: p_LAST_UPDATE_DATE => SYSDATE,
2279: p_REQUEST_ID => FND_API.G_MISS_NUM,
2280: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2281: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2282: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2283: p_KEEP_FLAG => FND_API.G_MISS_CHAR,

Line 2280: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

2276: p_LAST_UPDATED_BY => G_USER_ID,
2277: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2278: p_LAST_UPDATE_DATE => SYSDATE,
2279: p_REQUEST_ID => FND_API.G_MISS_NUM,
2280: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2281: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2282: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2283: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2284: p_UPDATE_ACCESS_FLAG => 'Y',

Line 2281: p_PROGRAM_ID => FND_API.G_MISS_NUM,

2277: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2278: p_LAST_UPDATE_DATE => SYSDATE,
2279: p_REQUEST_ID => FND_API.G_MISS_NUM,
2280: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2281: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2282: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2283: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2284: p_UPDATE_ACCESS_FLAG => 'Y',
2285: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 2282: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

2278: p_LAST_UPDATE_DATE => SYSDATE,
2279: p_REQUEST_ID => FND_API.G_MISS_NUM,
2280: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2281: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2282: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2283: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2284: p_UPDATE_ACCESS_FLAG => 'Y',
2285: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2286: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 2283: p_KEEP_FLAG => FND_API.G_MISS_CHAR,

2279: p_REQUEST_ID => FND_API.G_MISS_NUM,
2280: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2281: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2282: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2283: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2284: p_UPDATE_ACCESS_FLAG => 'Y',
2285: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2286: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2287: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

Line 2285: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

2281: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2282: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2283: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2284: p_UPDATE_ACCESS_FLAG => 'Y',
2285: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2286: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2287: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2288: p_ROLE_ID => l_primary_role,
2289: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 2286: p_TERRITORY_ID => FND_API.G_MISS_NUM,

2282: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2283: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2284: p_UPDATE_ACCESS_FLAG => 'Y',
2285: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2286: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2287: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2288: p_ROLE_ID => l_primary_role,
2289: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2290: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 2287: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

2283: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2284: p_UPDATE_ACCESS_FLAG => 'Y',
2285: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2286: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2287: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2288: p_ROLE_ID => l_primary_role,
2289: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2290: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2291: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

Line 2289: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

2285: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2286: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2287: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2288: p_ROLE_ID => l_primary_role,
2289: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2290: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2291: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2292: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2293: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 2290: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

2286: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2287: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2288: p_ROLE_ID => l_primary_role,
2289: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2290: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2291: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2292: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2293: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2294: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 2291: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

2287: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2288: p_ROLE_ID => l_primary_role,
2289: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2290: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2291: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2292: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2293: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2294: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2295: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 2292: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

2288: p_ROLE_ID => l_primary_role,
2289: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2290: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2291: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2292: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2293: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2294: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2295: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2296: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 2293: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

2289: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2290: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2291: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2292: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2293: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2294: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2295: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2296: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2297: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 2294: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

2290: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2291: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2292: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2293: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2294: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2295: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2296: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2297: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2298: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 2295: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

2291: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2292: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2293: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2294: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2295: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2296: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2297: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2298: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2299: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 2296: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

2292: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2293: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2294: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2295: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2296: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2297: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2298: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2299: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2300: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 2297: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

2293: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2294: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2295: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2296: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2297: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2298: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2299: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2300: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2301: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 2298: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

2294: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2295: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2296: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2297: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2298: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2299: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2300: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2301: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2302: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 2299: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

2295: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2296: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2297: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2298: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2299: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2300: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2301: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2302: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2303: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 2300: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

2296: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2297: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2298: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2299: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2300: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2301: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2302: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2303: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2304: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 2301: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

2297: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2298: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2299: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2300: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2301: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2302: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2303: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2304: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2305: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 2302: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

2298: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2299: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2300: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2301: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2302: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2303: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2304: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2305: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2306: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 2303: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

2299: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2300: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2301: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2302: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2303: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2304: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2305: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2306: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2307: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 2304: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

2300: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2301: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2302: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2303: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2304: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2305: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2306: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2307: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2308: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 2305: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

2301: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2302: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2303: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2304: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2305: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2306: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2307: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2308: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2309: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 2306: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

2302: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2303: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2304: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2305: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2306: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2307: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2308: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2309: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2310: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 2307: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

2303: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2304: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2305: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2306: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2307: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2308: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2309: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2310: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2311: );

Line 2308: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

2304: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2305: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2306: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2307: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2308: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2309: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2310: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2311: );
2312: END IF; -- primary_res_kept <> Y

Line 2309: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

2305: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2306: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2307: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2308: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2309: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2310: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2311: );
2312: END IF; -- primary_res_kept <> Y
2313: END IF; -- primary_res_kept <> Y

Line 2310: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

2306: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2307: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2308: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2309: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2310: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2311: );
2312: END IF; -- primary_res_kept <> Y
2313: END IF; -- primary_res_kept <> Y
2314: END IF;

Line 2339: WHEN FND_API.G_EXC_ERROR THEN

2335: );
2336:
2337: EXCEPTION
2338:
2339: WHEN FND_API.G_EXC_ERROR THEN
2340: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2341: P_API_NAME => L_API_NAME,
2342: P_PKG_NAME => G_PKG_NAME,
2343: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2348: X_MSG_DATA => X_MSG_DATA,
2349: X_RETURN_STATUS => X_RETURN_STATUS
2350: );
2351:
2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2354: P_API_NAME => L_API_NAME,
2355: P_PKG_NAME => G_PKG_NAME,
2356: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

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

2378: END Update_Primary_SalesInfo;
2379:
2380:
2381: PROCEDURE Opp_Quote_Primary_SalesRep(
2382: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2383: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2384: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2385: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2386: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 2507: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2503: -- Standard Start of API savepoint
2504: SAVEPOINT OPP_QUOTE_PRIMARY_SALESREP_PVT;
2505:
2506: -- Standard call to check for call compatibility.
2507: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2508: 1.0,
2509: l_api_name,
2510: G_PKG_NAME)
2511: THEN

Line 2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2508: 1.0,
2509: l_api_name,
2510: G_PKG_NAME)
2511: THEN
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2514: END IF;
2515:
2516: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2509: l_api_name,
2510: G_PKG_NAME)
2511: THEN
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2514: END IF;
2515:
2516: -- Initialize message list if p_init_msg_list is set to TRUE.
2517: IF FND_API.to_Boolean( p_init_msg_list )

Line 2517: IF FND_API.to_Boolean( p_init_msg_list )

2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2514: END IF;
2515:
2516: -- Initialize message list if p_init_msg_list is set to TRUE.
2517: IF FND_API.to_Boolean( p_init_msg_list )
2518: THEN
2519: FND_MSG_PUB.initialize;
2520: END IF;
2521:

Line 2523: x_return_status := FND_API.G_RET_STS_SUCCESS;

2519: FND_MSG_PUB.initialize;
2520: END IF;
2521:
2522: -- Initialize API return status to SUCCESS
2523: x_return_status := FND_API.G_RET_STS_SUCCESS;
2524:
2525: --
2526: -- API body
2527: --

Line 2678: p_REQUEST_ID => FND_API.G_MISS_NUM,

2674: p_CREATION_DATE => SYSDATE,
2675: p_LAST_UPDATED_BY => G_USER_ID,
2676: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2677: p_LAST_UPDATE_DATE => SYSDATE,
2678: p_REQUEST_ID => FND_API.G_MISS_NUM,
2679: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2680: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2681: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2682: p_KEEP_FLAG => 'N',

Line 2679: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

2675: p_LAST_UPDATED_BY => G_USER_ID,
2676: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2677: p_LAST_UPDATE_DATE => SYSDATE,
2678: p_REQUEST_ID => FND_API.G_MISS_NUM,
2679: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2680: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2681: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2682: p_KEEP_FLAG => 'N',
2683: p_UPDATE_ACCESS_FLAG => 'Y',

Line 2680: p_PROGRAM_ID => FND_API.G_MISS_NUM,

2676: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2677: p_LAST_UPDATE_DATE => SYSDATE,
2678: p_REQUEST_ID => FND_API.G_MISS_NUM,
2679: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2680: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2681: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2682: p_KEEP_FLAG => 'N',
2683: p_UPDATE_ACCESS_FLAG => 'Y',
2684: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 2681: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

2677: p_LAST_UPDATE_DATE => SYSDATE,
2678: p_REQUEST_ID => FND_API.G_MISS_NUM,
2679: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2680: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2681: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2682: p_KEEP_FLAG => 'N',
2683: p_UPDATE_ACCESS_FLAG => 'Y',
2684: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2685: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 2684: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

2680: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2681: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2682: p_KEEP_FLAG => 'N',
2683: p_UPDATE_ACCESS_FLAG => 'Y',
2684: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2685: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2686: p_TERRITORY_SOURCE_FLAG => 'N',
2687: p_ROLE_ID => l_primary_role,
2688: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 2685: p_TERRITORY_ID => FND_API.G_MISS_NUM,

2681: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2682: p_KEEP_FLAG => 'N',
2683: p_UPDATE_ACCESS_FLAG => 'Y',
2684: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2685: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2686: p_TERRITORY_SOURCE_FLAG => 'N',
2687: p_ROLE_ID => l_primary_role,
2688: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2689: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 2688: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

2684: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2685: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2686: p_TERRITORY_SOURCE_FLAG => 'N',
2687: p_ROLE_ID => l_primary_role,
2688: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2689: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2690: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2691: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2692: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 2689: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

2685: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2686: p_TERRITORY_SOURCE_FLAG => 'N',
2687: p_ROLE_ID => l_primary_role,
2688: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2689: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2690: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2691: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2692: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2693: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 2690: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

2686: p_TERRITORY_SOURCE_FLAG => 'N',
2687: p_ROLE_ID => l_primary_role,
2688: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2689: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2690: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2691: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2692: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2693: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2694: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 2691: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

2687: p_ROLE_ID => l_primary_role,
2688: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2689: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2690: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2691: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2692: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2693: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2694: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2695: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 2692: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

2688: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2689: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2690: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2691: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2692: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2693: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2694: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2695: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2696: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 2693: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

2689: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2690: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2691: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2692: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2693: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2694: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2695: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2696: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2697: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 2694: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

2690: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2691: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2692: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2693: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2694: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2695: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2696: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2697: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2698: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 2695: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

2691: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2692: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2693: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2694: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2695: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2696: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2697: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2698: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2699: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 2696: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

2692: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2693: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2694: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2695: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2696: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2697: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2698: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2699: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2700: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 2697: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

2693: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2694: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2695: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2696: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2697: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2698: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2699: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2700: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2701: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 2698: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

2694: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2695: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2696: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2697: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2698: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2699: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2700: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2701: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2702: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 2699: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

2695: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2696: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2697: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2698: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2699: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2700: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2701: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2702: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2703: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 2700: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

2696: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2697: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2698: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2699: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2700: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2701: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2702: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2703: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2704: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 2701: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

2697: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2698: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2699: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2700: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2701: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2702: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2703: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2704: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2705: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 2702: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

2698: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2699: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2700: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2701: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2702: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2703: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2704: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2705: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2706: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 2703: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

2699: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2700: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2701: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2702: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2703: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2704: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2705: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2706: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2707: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 2704: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

2700: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2701: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2702: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2703: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2704: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2705: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2706: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2707: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2708: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 2705: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

2701: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2702: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2703: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2704: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2705: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2706: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2707: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2708: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2709: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 2706: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

2702: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2703: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2704: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2705: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2706: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2707: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2708: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2709: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2710: );

Line 2707: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

2703: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2704: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2705: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2706: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2707: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2708: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2709: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2710: );
2711:

Line 2708: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

2704: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2705: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2706: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2707: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2708: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2709: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2710: );
2711:
2712: END IF; -- creator_found

Line 2709: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

2705: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2706: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2707: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2708: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2709: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2710: );
2711:
2712: END IF; -- creator_found
2713:

Line 2739: x_return_status := FND_API.G_RET_STS_ERROR;

2735: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2736: aso_debug_pub.add('Opp_Qte_PS: Default SalesRep: '||l_primary_salesagent,1,'N');
2737: END IF;
2738: ELSE
2739: x_return_status := FND_API.G_RET_STS_ERROR;
2740: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2741:
2742: -- Created new message to display the error message more appropriately - Girish Bug 4654938
2743: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');

Line 2750: RAISE FND_API.G_EXC_ERROR;

2746: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
2747:
2748: FND_MSG_PUB.Add;
2749: END IF;
2750: RAISE FND_API.G_EXC_ERROR;
2751: END IF; -- salesrep_prof
2752:
2753: l_primary_role := l_default_role_prof;
2754:

Line 2857: p_REQUEST_ID => FND_API.G_MISS_NUM,

2853: p_CREATION_DATE => SYSDATE,
2854: p_LAST_UPDATED_BY => G_USER_ID,
2855: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2856: p_LAST_UPDATE_DATE => SYSDATE,
2857: p_REQUEST_ID => FND_API.G_MISS_NUM,
2858: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2859: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2860: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2861: p_KEEP_FLAG => FND_API.G_MISS_CHAR,

Line 2858: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

2854: p_LAST_UPDATED_BY => G_USER_ID,
2855: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2856: p_LAST_UPDATE_DATE => SYSDATE,
2857: p_REQUEST_ID => FND_API.G_MISS_NUM,
2858: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2859: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2860: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2861: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2862: p_UPDATE_ACCESS_FLAG => 'Y',

Line 2859: p_PROGRAM_ID => FND_API.G_MISS_NUM,

2855: p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
2856: p_LAST_UPDATE_DATE => SYSDATE,
2857: p_REQUEST_ID => FND_API.G_MISS_NUM,
2858: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2859: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2860: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2861: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2862: p_UPDATE_ACCESS_FLAG => 'Y',
2863: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

Line 2860: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,

2856: p_LAST_UPDATE_DATE => SYSDATE,
2857: p_REQUEST_ID => FND_API.G_MISS_NUM,
2858: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2859: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2860: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2861: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2862: p_UPDATE_ACCESS_FLAG => 'Y',
2863: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2864: p_TERRITORY_ID => FND_API.G_MISS_NUM,

Line 2861: p_KEEP_FLAG => FND_API.G_MISS_CHAR,

2857: p_REQUEST_ID => FND_API.G_MISS_NUM,
2858: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
2859: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2860: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2861: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2862: p_UPDATE_ACCESS_FLAG => 'Y',
2863: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2864: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2865: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

Line 2863: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,

2859: p_PROGRAM_ID => FND_API.G_MISS_NUM,
2860: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2861: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2862: p_UPDATE_ACCESS_FLAG => 'Y',
2863: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2864: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2865: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2866: p_ROLE_ID => l_primary_role,
2867: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 2864: p_TERRITORY_ID => FND_API.G_MISS_NUM,

2860: p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
2861: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2862: p_UPDATE_ACCESS_FLAG => 'Y',
2863: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2864: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2865: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2866: p_ROLE_ID => l_primary_role,
2867: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2868: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

Line 2865: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,

2861: p_KEEP_FLAG => FND_API.G_MISS_CHAR,
2862: p_UPDATE_ACCESS_FLAG => 'Y',
2863: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2864: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2865: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2866: p_ROLE_ID => l_primary_role,
2867: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2868: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2869: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

Line 2867: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

2863: p_CREATED_BY_TAP_FLAG => FND_API.G_MISS_CHAR,
2864: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2865: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2866: p_ROLE_ID => l_primary_role,
2867: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2868: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2869: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2870: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2871: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 2868: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

2864: p_TERRITORY_ID => FND_API.G_MISS_NUM,
2865: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2866: p_ROLE_ID => l_primary_role,
2867: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2868: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2869: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2870: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2871: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2872: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 2869: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

2865: p_TERRITORY_SOURCE_FLAG => FND_API.G_MISS_CHAR,
2866: p_ROLE_ID => l_primary_role,
2867: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2868: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2869: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2870: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2871: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2872: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2873: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 2870: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

2866: p_ROLE_ID => l_primary_role,
2867: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2868: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2869: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2870: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2871: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2872: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2873: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2874: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 2871: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

2867: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
2868: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2869: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2870: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2871: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2872: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2873: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2874: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2875: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 2872: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

2868: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2869: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2870: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2871: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2872: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2873: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2874: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2875: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2876: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 2873: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

2869: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2870: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2871: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2872: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2873: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2874: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2875: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2876: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2877: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 2874: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

2870: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2871: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2872: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2873: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2874: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2875: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2876: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2877: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2878: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 2875: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

2871: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2872: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2873: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2874: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2875: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2876: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2877: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2878: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2879: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 2876: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

2872: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2873: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2874: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2875: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2876: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2877: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2878: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2879: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2880: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 2877: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

2873: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2874: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2875: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2876: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2877: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2878: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2879: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2880: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2881: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 2878: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

2874: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2875: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2876: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2877: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2878: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2879: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2880: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2881: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2882: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 2879: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

2875: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2876: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2877: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2878: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2879: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2880: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2881: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2882: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2883: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

Line 2880: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

2876: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2877: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2878: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2879: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2880: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2881: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2882: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2883: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2884: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

Line 2881: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

2877: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2878: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2879: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2880: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2881: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2882: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2883: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2884: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2885: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

Line 2882: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

2878: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2879: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2880: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2881: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2882: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2883: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2884: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2885: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2886: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

Line 2883: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,

2879: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2880: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2881: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2882: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2883: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2884: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2885: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2886: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2887: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

Line 2884: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,

2880: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2881: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2882: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2883: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2884: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2885: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2886: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2887: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2888: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 2885: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,

2881: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2882: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2883: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2884: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2885: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2886: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2887: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2888: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2889: );

Line 2886: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,

2882: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2883: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2884: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2885: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2886: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2887: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2888: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2889: );
2890:

Line 2887: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,

2883: p_ATTRIBUTE16 => FND_API.G_MISS_CHAR,
2884: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2885: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2886: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2887: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2888: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2889: );
2890:
2891: END IF;

Line 2888: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

2884: p_ATTRIBUTE17 => FND_API.G_MISS_CHAR,
2885: p_ATTRIBUTE18 => FND_API.G_MISS_CHAR,
2886: p_ATTRIBUTE19 => FND_API.G_MISS_CHAR,
2887: p_ATTRIBUTE20 => FND_API.G_MISS_CHAR,
2888: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
2889: );
2890:
2891: END IF;
2892:

Line 2917: WHEN FND_API.G_EXC_ERROR THEN

2913: );
2914:
2915: EXCEPTION
2916:
2917: WHEN FND_API.G_EXC_ERROR THEN
2918: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2919: P_API_NAME => L_API_NAME,
2920: P_PKG_NAME => G_PKG_NAME,
2921: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 2930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2926: X_MSG_DATA => X_MSG_DATA,
2927: X_RETURN_STATUS => X_RETURN_STATUS
2928: );
2929:
2930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2931: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2932: P_API_NAME => L_API_NAME,
2933: P_PKG_NAME => G_PKG_NAME,
2934: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,