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.IEX_SCORE_PVT dependencies on IEX_SCORE_PVT

Line 1: PACKAGE BODY IEX_SCORE_PVT AS

1: PACKAGE BODY IEX_SCORE_PVT AS
2: /* $Header: iexvscrb.pls 120.9 2006/05/30 21:16:18 scherkas ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_SCORE_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvscrb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_SCORE_PVT';

1: PACKAGE BODY IEX_SCORE_PVT AS
2: /* $Header: iexvscrb.pls 120.9 2006/05/30 21:16:18 scherkas ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_SCORE_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvscrb.pls';
6:
7: --bug 2902302 clchang updated 04/14/2003
8: --G_MIN_SCORE CONSTANT NUMBER := 10;

Line 539: IEX_SCORE_PVT.WriteLog('iexvscrb:CreateScr: exc exp:'||SQLERRM);

535:
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO CREATE_SCORE_PVT;
539: IEX_SCORE_PVT.WriteLog('iexvscrb:CreateScr: exc exp:'||SQLERRM);
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: FND_MSG_PUB.Count_And_Get
542: ( p_count => x_msg_count,
543: p_data => x_msg_data);

Line 547: IEX_SCORE_PVT.WriteLog('iexvscrb:CreateScr: unexc exp:'||SQLERRM);

543: p_data => x_msg_data);
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO CREATE_SCORE_PVT;
547: IEX_SCORE_PVT.WriteLog('iexvscrb:CreateScr: unexc exp:'||SQLERRM);
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: FND_MSG_PUB.Count_And_Get
550: ( p_count => x_msg_count,
551: p_data => x_msg_data);

Line 555: IEX_SCORE_PVT.WriteLog('iexvscrb:CreateScr: other exp:'||SQLERRM);

551: p_data => x_msg_data);
552:
553: WHEN OTHERS THEN
554: ROLLBACK TO CREATE_SCORE_PVT;
555: IEX_SCORE_PVT.WriteLog('iexvscrb:CreateScr: other exp:'||SQLERRM);
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: FND_MSG_PUB.Count_And_Get
558: ( p_count => x_msg_count,
559: p_data => x_msg_data);

Line 834: IEX_SCORE_PVT.WriteLog('iexvscrb:UpdateScr: exc exp:'||SQLERRM);

830:
831: EXCEPTION
832: WHEN FND_API.G_EXC_ERROR THEN
833: ROLLBACK TO UPDATE_SCORE_PVT;
834: IEX_SCORE_PVT.WriteLog('iexvscrb:UpdateScr: exc exp:'||SQLERRM);
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: FND_MSG_PUB.Count_And_Get
837: ( p_count => x_msg_count,
838: p_data => x_msg_data);

Line 842: IEX_SCORE_PVT.WriteLog('iexvscrb:UpdateScr: unexc exp:'||SQLERRM);

838: p_data => x_msg_data);
839:
840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
841: ROLLBACK TO UPDATE_SCORE_PVT;
842: IEX_SCORE_PVT.WriteLog('iexvscrb:UpdateScr: unexc exp:'||SQLERRM);
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,
846: p_data => x_msg_data);

Line 850: IEX_SCORE_PVT.WriteLog('iexvscrb:UpdateScr: other exp:'||SQLERRM);

846: p_data => x_msg_data);
847:
848: WHEN OTHERS THEN
849: ROLLBACK TO UPDATE_SCORE_PVT;
850: IEX_SCORE_PVT.WriteLog('iexvscrb:UpdateScr: other exp:'||SQLERRM);
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: FND_MSG_PUB.Count_And_Get
853: ( p_count => x_msg_count,
854: p_data => x_msg_data);

Line 971: IEX_SCORE_PVT.Delete_Score_Comp(

967: LOOP
968: l_score_comp_id := s.score_component_id;
969:
970: WriteLog('iexvscrb:Delete_Score=>scrcompid='||l_score_comp_id);
971: IEX_SCORE_PVT.Delete_Score_Comp(
972: p_api_version => p_api_version
973: , p_init_msg_list => p_init_msg_list
974: , p_commit => p_commit
975: , p_score_id => p_score_id

Line 1577: IEX_SCORE_PVT.Delete_Score_Comp_Det(

1573: FOR s in C_GET_SCORE_COMP_DET (p_score_comp_id)
1574: LOOP
1575: l_score_comp_det_id := s.score_comp_det_id;
1576: WriteLog('iexvscrb:Delete_Score_Comp=>scrcompdetid='||l_score_comp_Det_id);
1577: IEX_SCORE_PVT.Delete_Score_Comp_Det(
1578: p_api_version => p_api_version
1579: , p_init_msg_list => p_init_msg_list
1580: , p_commit => p_commit
1581: , p_score_comp_id => p_score_comp_id

Line 2856: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Start');

2852:
2853: --dbms_output.put_line( FND_PROFILE.VALUE('IEX_DEBUG_LEVEL'));
2854: --dbms_output.put_line('debug=' || PG_DEBUG);
2855:
2856: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Start');
2857: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: score_id='||p_score_id);
2858:
2859: --
2860: -- Api body

Line 2857: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: score_id='||p_score_id);

2853: --dbms_output.put_line( FND_PROFILE.VALUE('IEX_DEBUG_LEVEL'));
2854: --dbms_output.put_line('debug=' || PG_DEBUG);
2855:
2856: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Start');
2857: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: score_id='||p_score_id);
2858:
2859: --
2860: -- Api body
2861: --

Line 2866: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create Score');

2862:
2863: --
2864: -- Create Scoring Engine
2865:
2866: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create Score');
2867: Open C_Get_SCORE(p_score_id);
2868: Fetch C_Get_Score into
2869: l_score_rec.SCORE_NAME,
2870: l_len,

Line 2886: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Score notfound');

2882: l_score_rec.OUT_OF_RANGE_RULE;
2883:
2884:
2885: IF ( C_Get_Score%NOTFOUND) THEN
2886: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Score notfound');
2887: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2888: FND_MESSAGE.Set_Token ('INFO', 'iex_Score', FALSE);
2889: FND_MSG_PUB.Add;
2890: RAISE FND_API.G_EXC_ERROR;

Line 2893: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: len(scrname)= '||l_len);

2889: FND_MSG_PUB.Add;
2890: RAISE FND_API.G_EXC_ERROR;
2891: END IF;
2892:
2893: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: len(scrname)= '||l_len);
2894: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: scrname= '||l_score_rec.score_name);
2895:
2896: -- Validate ScoreName
2897: -- 1.if the new scorename exists,

Line 2894: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: scrname= '||l_score_rec.score_name);

2890: RAISE FND_API.G_EXC_ERROR;
2891: END IF;
2892:
2893: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: len(scrname)= '||l_len);
2894: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: scrname= '||l_score_rec.score_name);
2895:
2896: -- Validate ScoreName
2897: -- 1.if the new scorename exists,
2898: -- then add extra 'Copy of ' to the score name;

Line 2909: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName Loop');

2905: WHILE x_dup_status = IEX_DUPLICATE_NAME
2906: LOOP
2907: EXIT when x_dup_status <> IEX_DUPLICATE_NAME ;
2908:
2909: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName Loop');
2910: if (l_len > 248) then
2911: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName > 256');
2912: l_tmp_score_name := 'Copy of ' || l_score_name;
2913: FND_MESSAGE.Set_Name('IEX', 'IEX_API_LEN_ERR');

Line 2911: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName > 256');

2907: EXIT when x_dup_status <> IEX_DUPLICATE_NAME ;
2908:
2909: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName Loop');
2910: if (l_len > 248) then
2911: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName > 256');
2912: l_tmp_score_name := 'Copy of ' || l_score_name;
2913: FND_MESSAGE.Set_Name('IEX', 'IEX_API_LEN_ERR');
2914: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);
2915: FND_MESSAGE.Set_Token('VALUE', l_tmp_score_Name, FALSE);

Line 2926: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Validate ScoreName');

2922: else
2923: l_score_name := 'Copy Of ' || l_score_name;
2924: l_add := l_add + 1;
2925: l_len := l_len + 8;
2926: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Validate ScoreName');
2927: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName= '||l_score_name);
2928: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: len(scrname)= '||l_len);
2929: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: l_add= '||l_add);
2930:

Line 2927: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName= '||l_score_name);

2923: l_score_name := 'Copy Of ' || l_score_name;
2924: l_add := l_add + 1;
2925: l_len := l_len + 8;
2926: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Validate ScoreName');
2927: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName= '||l_score_name);
2928: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: len(scrname)= '||l_len);
2929: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: l_add= '||l_add);
2930:
2931: Validate_Score_Name(P_Init_Msg_List => FND_API.G_FALSE,

Line 2928: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: len(scrname)= '||l_len);

2924: l_add := l_add + 1;
2925: l_len := l_len + 8;
2926: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Validate ScoreName');
2927: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName= '||l_score_name);
2928: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: len(scrname)= '||l_len);
2929: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: l_add= '||l_add);
2930:
2931: Validate_Score_Name(P_Init_Msg_List => FND_API.G_FALSE,
2932: P_SCORE_Name => l_score_name,

Line 2929: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: l_add= '||l_add);

2925: l_len := l_len + 8;
2926: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Validate ScoreName');
2927: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName= '||l_score_name);
2928: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: len(scrname)= '||l_len);
2929: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: l_add= '||l_add);
2930:
2931: Validate_Score_Name(P_Init_Msg_List => FND_API.G_FALSE,
2932: P_SCORE_Name => l_score_name,
2933: P_SCORE_ID => 0,

Line 2947: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName= '||l_score_name);

2943: END LOOP;
2944:
2945:
2946: l_score_rec.score_name := l_score_name;
2947: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName= '||l_score_name);
2948:
2949: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create Score ');
2950: Create_Score(
2951: p_api_version => p_api_version

Line 2949: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create Score ');

2945:
2946: l_score_rec.score_name := l_score_name;
2947: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName= '||l_score_name);
2948:
2949: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create Score ');
2950: Create_Score(
2951: p_api_version => p_api_version
2952: , p_init_msg_list => p_init_msg_list
2953: , p_commit => p_commit

Line 2961: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: CreateScore Status= '||x_return_status);

2957: , x_msg_count => x_msg_count
2958: , x_msg_data => x_msg_data
2959: , x_score_id => x_score_id);
2960:
2961: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: CreateScore Status= '||x_return_status);
2962:
2963:
2964: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2965: RAISE FND_API.G_EXC_ERROR;

Line 2971: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreId= '||l_score_id);

2967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2968: END IF;
2969:
2970: l_score_id := x_score_id;
2971: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreId= '||l_score_id);
2972:
2973: Close C_Get_Score;
2974:
2975: --

Line 2977: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create ScoreComp');

2973: Close C_Get_Score;
2974:
2975: --
2976: -- Create Score Components
2977: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create ScoreComp');
2978: idx := 0;
2979: newidx := 0;
2980: FOR s in C_GET_SCORE_COMPS (p_score_id)
2981: LOOP

Line 2984: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Existing ScoreCompId= '||s.score_component_id);

2980: FOR s in C_GET_SCORE_COMPS (p_score_id)
2981: LOOP
2982: idx := idx + 1;
2983: l_score_comp_id_tbl(idx) := s.score_component_id;
2984: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Existing ScoreCompId= '||s.score_component_id);
2985:
2986: Open C_Get_Score_Comp_Rec(s.score_component_id);
2987: Fetch C_Get_Score_Comp_Rec into
2988: l_score_comp_rec.SCORE_COMP_WEIGHT,

Line 2996: IEX_SCORE_PVT.Create_Score_Comp(

2992:
2993: WriteLog('iexvscrb:Copy_SE: TypeId= '||l_score_comp_rec.score_comp_type_id);
2994: l_score_comp_rec.score_id := l_score_id;
2995:
2996: IEX_SCORE_PVT.Create_Score_Comp(
2997: p_api_version => p_api_version
2998: , p_init_msg_list => p_init_msg_list
2999: , p_commit => p_commit
3000: , p_score_comp_rec => l_score_comp_rec

Line 3007: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: CreateScoreComp Status= '||x_return_status);

3003: , x_msg_count => x_msg_count
3004: , x_msg_data => x_msg_data
3005: );
3006:
3007: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: CreateScoreComp Status= '||x_return_status);
3008:
3009:
3010: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3011: RAISE FND_API.G_EXC_ERROR;

Line 3024: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: created ScoreCompId= '||l_score_comp_id);

3020: END IF;
3021:
3022: l_score_comp_id_new_tbl(newidx) := l_score_comp_id;
3023:
3024: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: created ScoreCompId= '||l_score_comp_id);
3025: Close C_Get_Score_Comp_Rec;
3026:
3027: END LOOP;
3028:

Line 3029: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: End Of ScoreComp');

3025: Close C_Get_Score_Comp_Rec;
3026:
3027: END LOOP;
3028:
3029: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: End Of ScoreComp');
3030: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreComp Count='||idx);
3031: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreComp NewRecCnt='||newidx);
3032:
3033:

Line 3030: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreComp Count='||idx);

3026:
3027: END LOOP;
3028:
3029: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: End Of ScoreComp');
3030: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreComp Count='||idx);
3031: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreComp NewRecCnt='||newidx);
3032:
3033:
3034: --

Line 3031: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreComp NewRecCnt='||newidx);

3027: END LOOP;
3028:
3029: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: End Of ScoreComp');
3030: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreComp Count='||idx);
3031: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreComp NewRecCnt='||newidx);
3032:
3033:
3034: --
3035: -- Create Score Component Details

Line 3037: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create ScoreCompDet');

3033:
3034: --
3035: -- Create Score Component Details
3036:
3037: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create ScoreCompDet');
3038: FOR i in 1..l_score_Comp_id_tbl.count
3039: LOOP
3040: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:i='|| i);
3041: l_score_comp_id := l_score_comp_id_tbl(i);

Line 3040: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:i='|| i);

3036:
3037: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create ScoreCompDet');
3038: FOR i in 1..l_score_Comp_id_tbl.count
3039: LOOP
3040: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:i='|| i);
3041: l_score_comp_id := l_score_comp_id_tbl(i);
3042: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:old_scrcompid='||l_score_comp_id);
3043: l_score_comp_id_new := l_score_comp_id_new_tbl(i);
3044: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:new_scrcompid='||l_score_comp_id_new);

Line 3042: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:old_scrcompid='||l_score_comp_id);

3038: FOR i in 1..l_score_Comp_id_tbl.count
3039: LOOP
3040: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:i='|| i);
3041: l_score_comp_id := l_score_comp_id_tbl(i);
3042: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:old_scrcompid='||l_score_comp_id);
3043: l_score_comp_id_new := l_score_comp_id_new_tbl(i);
3044: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:new_scrcompid='||l_score_comp_id_new);
3045:
3046: FOR s in C_GET_SCORE_COMP_DET (l_score_comp_id)

Line 3044: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:new_scrcompid='||l_score_comp_id_new);

3040: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:i='|| i);
3041: l_score_comp_id := l_score_comp_id_tbl(i);
3042: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:old_scrcompid='||l_score_comp_id);
3043: l_score_comp_id_new := l_score_comp_id_new_tbl(i);
3044: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:new_scrcompid='||l_score_comp_id_new);
3045:
3046: FOR s in C_GET_SCORE_COMP_DET (l_score_comp_id)
3047: LOOP
3048: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:scrcompdet loop');

Line 3048: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:scrcompdet loop');

3044: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:new_scrcompid='||l_score_comp_id_new);
3045:
3046: FOR s in C_GET_SCORE_COMP_DET (l_score_comp_id)
3047: LOOP
3048: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:scrcompdet loop');
3049: --l_score_comp_det_rec := IEX_SCORE_PUB.G_MISS_SCORE_COMP_DET_REC;
3050: l_score_comp_det_rec := null;
3051: l_score_comp_det_id := s.score_comp_det_id;
3052: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:scrcompdetid='||l_score_comp_det_id);

Line 3052: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:scrcompdetid='||l_score_comp_det_id);

3048: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:scrcompdet loop');
3049: --l_score_comp_det_rec := IEX_SCORE_PUB.G_MISS_SCORE_COMP_DET_REC;
3050: l_score_comp_det_rec := null;
3051: l_score_comp_det_id := s.score_comp_det_id;
3052: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:scrcompdetid='||l_score_comp_det_id);
3053: Open C_Get_Score_Comp_Det_Rec(l_score_comp_det_id);
3054: Fetch C_Get_Score_Comp_Det_Rec into
3055: l_score_comp_det_rec.RANGE_LOW,
3056: l_score_comp_det_rec.RANGE_HIGH,

Line 3066: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:scrcompid='||l_score_comp_id_new);

3062:
3063: Close C_Get_Score_Comp_Det_Rec;
3064:
3065: l_score_comp_det_rec.score_component_id := l_score_comp_id_new;
3066: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:scrcompid='||l_score_comp_id_new);
3067:
3068: IEX_SCORE_PVT.Create_Score_Comp_Det(
3069: p_api_version => p_api_version
3070: , p_init_msg_list => p_init_msg_list

Line 3068: IEX_SCORE_PVT.Create_Score_Comp_Det(

3064:
3065: l_score_comp_det_rec.score_component_id := l_score_comp_id_new;
3066: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE:scrcompid='||l_score_comp_id_new);
3067:
3068: IEX_SCORE_PVT.Create_Score_Comp_Det(
3069: p_api_version => p_api_version
3070: , p_init_msg_list => p_init_msg_list
3071: , p_commit => p_commit
3072: , p_score_comp_det_rec => l_score_comp_det_rec

Line 3079: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: CreateScoreCompDet Status= '||x_return_status);

3075: , x_msg_count => x_msg_count
3076: , x_msg_data => x_msg_data
3077: );
3078:
3079: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: CreateScoreCompDet Status= '||x_return_status);
3080:
3081:
3082: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3083: RAISE FND_API.G_EXC_ERROR;

Line 3089: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreCompDetId= '||l_score_comp_det_id);

3085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3086: END IF;
3087:
3088:
3089: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreCompDetId= '||l_score_comp_det_id);
3090:
3091: END LOOP;
3092:
3093: END LOOP;

Line 3095: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: End Of ScoreCompDet');

3091: END LOOP;
3092:
3093: END LOOP;
3094:
3095: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: End Of ScoreCompDet');
3096:
3097: --
3098: -- Create Scoring Filter
3099:

Line 3100: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create ScoreFilter');

3096:
3097: --
3098: -- Create Scoring Filter
3099:
3100: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create ScoreFilter');
3101:
3102: Open C_Get_SCORE_FILTER(p_score_id);
3103: Fetch C_Get_SCORE_FILTER into
3104: l_filter_rec.OBJECT_FILTER_ID,

Line 3114: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: SCORE_FILTER notfound');

3110: l_filter_rec.OBJECT_VERSION_NUMBER;
3111:
3112:
3113: IF ( C_Get_SCORE_FILTER%NOTFOUND) THEN
3114: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: SCORE_FILTER notfound');
3115: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
3116: --FND_MESSAGE.Set_Token ('INFO', 'iex_SCORE_FILTER', FALSE);
3117: --FND_MSG_PUB.Add;
3118: --RAISE FND_API.G_EXC_ERROR;

Line 3134: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Validate ScoreName');

3130: WHILE x_dup_status = IEX_DUPLICATE_NAME
3131: LOOP
3132: EXIT when x_dup_status <> IEX_DUPLICATE_NAME ;
3133:
3134: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Validate ScoreName');
3135: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: FilterName= '||l_filter_name);
3136:
3137: IEX_FILTER_PUB.Validate_FILTER(
3138: P_FILTER_rec => l_filter_rec,

Line 3135: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: FilterName= '||l_filter_name);

3131: LOOP
3132: EXIT when x_dup_status <> IEX_DUPLICATE_NAME ;
3133:
3134: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Validate ScoreName');
3135: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: FilterName= '||l_filter_name);
3136:
3137: IEX_FILTER_PUB.Validate_FILTER(
3138: P_FILTER_rec => l_filter_rec,
3139: X_Dup_Status => x_dup_status,

Line 3154: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: FilterName= '||l_filter_name);

3150: END IF;
3151:
3152: END LOOP;
3153:
3154: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: FilterName= '||l_filter_name);
3155:
3156:
3157: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create ScoreFilter ');
3158: IEX_FILTER_PUB.Create_OBJECT_FILTER(

Line 3157: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create ScoreFilter ');

3153:
3154: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: FilterName= '||l_filter_name);
3155:
3156:
3157: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create ScoreFilter ');
3158: IEX_FILTER_PUB.Create_OBJECT_FILTER(
3159: p_api_version => p_api_version
3160: , p_init_msg_list => p_init_msg_list
3161: , p_commit => p_commit

Line 3169: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: CreateFilter Status= '||x_return_status);

3165: , x_msg_count => x_msg_count
3166: , x_msg_data => x_msg_data
3167: , x_filter_id => l_filter_id);
3168:
3169: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: CreateFilter Status= '||x_return_status);
3170:
3171:
3172: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3173: RAISE FND_API.G_EXC_ERROR;

Line 3179: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: FilterId= '||l_filter_id);

3175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3176: END IF;
3177:
3178:
3179: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: FilterId= '||l_filter_id);
3180:
3181: END IF;
3182:
3183: Close C_Get_Score_Filter;

Line 3185: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: End of ScoreFilter');

3181: END IF;
3182:
3183: Close C_Get_Score_Filter;
3184:
3185: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: End of ScoreFilter');
3186:
3187: --
3188:
3189: --

Line 3192: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create DelStatus');

3188:
3189: --
3190: -- Create DEL STATUSES
3191:
3192: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create DelStatus');
3193:
3194: FOR d in C_GET_SCORE_STATUS (p_score_id)
3195: LOOP
3196:

Line 3198: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create SCORE_DEL_STATUSES ');

3194: FOR d in C_GET_SCORE_STATUS (p_score_id)
3195: LOOP
3196:
3197: BEGIN
3198: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create SCORE_DEL_STATUSES ');
3199: IEX_DEL_STATUSES_PKG.Insert_Row_With_Defaults(
3200: x_rowid => l_row_id
3201: , p_score_value_low => d.score_value_low
3202: , p_score_value_high => d.score_value_high

Line 3207: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create DelStatus: '||l_row_id);

3203: , p_del_status => d.del_status
3204: , p_score_id => l_score_id
3205: , commit_flag => p_commit);
3206:
3207: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create DelStatus: '||l_row_id);
3208: EXCEPTION
3209: WHEN OTHERS THEN
3210: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: exc exp:'||SQLERRM);
3211: RAISE FND_API.G_EXC_ERROR;

Line 3210: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: exc exp:'||SQLERRM);

3206:
3207: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Create DelStatus: '||l_row_id);
3208: EXCEPTION
3209: WHEN OTHERS THEN
3210: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: exc exp:'||SQLERRM);
3211: RAISE FND_API.G_EXC_ERROR;
3212: END ;
3213: END LOOP;
3214:

Line 3216: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: End of ScoreSTATUS');

3212: END ;
3213: END LOOP;
3214:
3215:
3216: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: End of ScoreSTATUS');
3217:
3218: --
3219: <>
3220:

Line 3221: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: END_COPY');

3217:
3218: --
3219: <>
3220:
3221: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: END_COPY');
3222: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: x_score_id='||x_score_id);
3223: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3224: RAISE FND_API.G_EXC_ERROR;
3225: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3222: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: x_score_id='||x_score_id);

3218: --
3219: <>
3220:
3221: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: END_COPY');
3222: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: x_score_id='||x_score_id);
3223: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3224: RAISE FND_API.G_EXC_ERROR;
3225: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3230: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: End');

3226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3227: END IF;
3228:
3229:
3230: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: End');
3231:
3232: --
3233: -- End of API body
3234: --

Line 3249: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: exc exp:'||SQLERRM);

3245: p_data => x_msg_data );
3246:
3247: EXCEPTION
3248: WHEN FND_API.G_EXC_ERROR THEN
3249: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: exc exp:'||SQLERRM);
3250: ROLLBACK To Copy_ScoringEngine_PVT;
3251: x_return_status := FND_API.G_RET_STS_ERROR;
3252: FND_MSG_PUB.Count_And_Get
3253: ( p_count => x_msg_count,

Line 3258: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: unexc exp:'||SQLERRM);

3254: p_data => x_msg_data );
3255:
3256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3257: ROLLBACK To Copy_ScoringEngine_PVT;
3258: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: unexc exp:'||SQLERRM);
3259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3260: FND_MSG_PUB.Count_And_Get
3261: ( p_count => x_msg_count,
3262: p_data => x_msg_data );

Line 3266: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: other exp:'||SQLERRM);

3262: p_data => x_msg_data );
3263:
3264: WHEN OTHERS THEN
3265: ROLLBACK To Copy_ScoringEngine_PVT;
3266: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: other exp:'||SQLERRM);
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268: FND_MSG_PUB.Count_And_Get
3269: ( p_count => x_msg_count,
3270: p_data => x_msg_data );

Line 3347: l_raw_score := IEX_SCORE_PVT.G_MIN_SCORE;

3343: nCount number;
3344:
3345: BEGIN
3346:
3347: l_raw_score := IEX_SCORE_PVT.G_MIN_SCORE;
3348:
3349: -- Standard Start of API savepoint
3350: SAVEPOINT Get_Score_PVT;
3351:

Line 3377: IEX_SCORE_PVT.GET_COMPONENTS(p_score_id => l_score_id,

3373: -- Api body
3374: --
3375:
3376: /* 1. enumerate all components */
3377: IEX_SCORE_PVT.GET_COMPONENTS(p_score_id => l_score_id,
3378: x_score_comp_tbl => l_score_comp_tbl);
3379:
3380: /* 2. get the parties to update */
3381: OPEN c_del_parties;

Line 3397: l_raw_score := IEX_SCORE_PVT.G_MIN_SCORE;

3393:
3394: --dbms_output.put_line ('before dynamic execute ' || l_score_comp_tbl(l_count).SCORE_COMPONENT_ID || ' ' || l_score_comp_tbl(l_count).SCORE_COMP_VALUE);
3395:
3396: -- initialize this to the minimum for any given component
3397: l_raw_score := IEX_SCORE_PVT.G_MIN_SCORE;
3398:
3399: /* executing dynamic sql for component */
3400: BEGIN
3401: --DBMS_OUTPUT.PUT_LINE('before execute immediate');

Line 3443: if l_running_score < IEX_SCORE_PVT.G_MIN_SCORE then

3439: END LOOP;
3440:
3441: -- if the score value falls above or below the hard coded floor / ceiling we will force the score
3442: -- to the floor or ceiling
3443: if l_running_score < IEX_SCORE_PVT.G_MIN_SCORE then
3444: l_running_score := IEX_SCORE_PVT.G_MIN_SCORE;
3445: elsif l_running_score > IEX_SCORE_PVT.G_MAX_SCORE then
3446: l_running_score := IEX_SCORE_PVT.G_MAX_SCORE;
3447: end if;

Line 3444: l_running_score := IEX_SCORE_PVT.G_MIN_SCORE;

3440:
3441: -- if the score value falls above or below the hard coded floor / ceiling we will force the score
3442: -- to the floor or ceiling
3443: if l_running_score < IEX_SCORE_PVT.G_MIN_SCORE then
3444: l_running_score := IEX_SCORE_PVT.G_MIN_SCORE;
3445: elsif l_running_score > IEX_SCORE_PVT.G_MAX_SCORE then
3446: l_running_score := IEX_SCORE_PVT.G_MAX_SCORE;
3447: end if;
3448:

Line 3445: elsif l_running_score > IEX_SCORE_PVT.G_MAX_SCORE then

3441: -- if the score value falls above or below the hard coded floor / ceiling we will force the score
3442: -- to the floor or ceiling
3443: if l_running_score < IEX_SCORE_PVT.G_MIN_SCORE then
3444: l_running_score := IEX_SCORE_PVT.G_MIN_SCORE;
3445: elsif l_running_score > IEX_SCORE_PVT.G_MAX_SCORE then
3446: l_running_score := IEX_SCORE_PVT.G_MAX_SCORE;
3447: end if;
3448:
3449: --dbms_output.put_line('party_id = ' || l_party_id || ' FINAL score = ' || l_running_score);

Line 3446: l_running_score := IEX_SCORE_PVT.G_MAX_SCORE;

3442: -- to the floor or ceiling
3443: if l_running_score < IEX_SCORE_PVT.G_MIN_SCORE then
3444: l_running_score := IEX_SCORE_PVT.G_MIN_SCORE;
3445: elsif l_running_score > IEX_SCORE_PVT.G_MAX_SCORE then
3446: l_running_score := IEX_SCORE_PVT.G_MAX_SCORE;
3447: end if;
3448:
3449: --dbms_output.put_line('party_id = ' || l_party_id || ' FINAL score = ' || l_running_score);
3450: /* UPDATE IEX_SCORE_HISTORIES with the collections score, score_id, and last_score_date */

Line 3657: IEX_SCORE_PVT.Get_Score(p_api_version => 1.0,

3653: l_msg_count NUMBER;
3654:
3655: BEGIN
3656:
3657: IEX_SCORE_PVT.Get_Score(p_api_version => 1.0,
3658: p_init_msg_list => FND_API.G_TRUE,
3659: p_commit => FND_API.G_TRUE,
3660: x_return_status => l_return_status,
3661: x_msg_count => l_msg_count,

Line 3673: END IEX_SCORE_PVT;

3669:
3670: BEGIN
3671: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3672:
3673: END IEX_SCORE_PVT;