25:
26: NULL;
27: END IF;
28: IF (P_BUCKET1 IS NOT NULL) THEN
29: FND_MESSAGE.SET_NAME('SQLAP'
30: ,'OIE_CC_BUCKET1_NAME');
31: FND_MESSAGE.SET_TOKEN('BUCKET1'
32: ,P_BUCKET1);
33: CP_BUCKET1_NAME := FND_MESSAGE.GET;
27: END IF;
28: IF (P_BUCKET1 IS NOT NULL) THEN
29: FND_MESSAGE.SET_NAME('SQLAP'
30: ,'OIE_CC_BUCKET1_NAME');
31: FND_MESSAGE.SET_TOKEN('BUCKET1'
32: ,P_BUCKET1);
33: CP_BUCKET1_NAME := FND_MESSAGE.GET;
34: NULL;
35: END IF;
29: FND_MESSAGE.SET_NAME('SQLAP'
30: ,'OIE_CC_BUCKET1_NAME');
31: FND_MESSAGE.SET_TOKEN('BUCKET1'
32: ,P_BUCKET1);
33: CP_BUCKET1_NAME := FND_MESSAGE.GET;
34: NULL;
35: END IF;
36: IF (P_BUCKET2 IS NOT NULL) THEN
37: FND_MESSAGE.SET_NAME('SQLAP'
33: CP_BUCKET1_NAME := FND_MESSAGE.GET;
34: NULL;
35: END IF;
36: IF (P_BUCKET2 IS NOT NULL) THEN
37: FND_MESSAGE.SET_NAME('SQLAP'
38: ,'OIE_CC_BUCKET2_NAME');
39: FND_MESSAGE.SET_TOKEN('BUCKET1'
40: ,P_BUCKET1 + 1);
41: FND_MESSAGE.SET_TOKEN('BUCKET2'
35: END IF;
36: IF (P_BUCKET2 IS NOT NULL) THEN
37: FND_MESSAGE.SET_NAME('SQLAP'
38: ,'OIE_CC_BUCKET2_NAME');
39: FND_MESSAGE.SET_TOKEN('BUCKET1'
40: ,P_BUCKET1 + 1);
41: FND_MESSAGE.SET_TOKEN('BUCKET2'
42: ,P_BUCKET2);
43: CP_BUCKET2_NAME := FND_MESSAGE.GET;
37: FND_MESSAGE.SET_NAME('SQLAP'
38: ,'OIE_CC_BUCKET2_NAME');
39: FND_MESSAGE.SET_TOKEN('BUCKET1'
40: ,P_BUCKET1 + 1);
41: FND_MESSAGE.SET_TOKEN('BUCKET2'
42: ,P_BUCKET2);
43: CP_BUCKET2_NAME := FND_MESSAGE.GET;
44: NULL;
45: END IF;
39: FND_MESSAGE.SET_TOKEN('BUCKET1'
40: ,P_BUCKET1 + 1);
41: FND_MESSAGE.SET_TOKEN('BUCKET2'
42: ,P_BUCKET2);
43: CP_BUCKET2_NAME := FND_MESSAGE.GET;
44: NULL;
45: END IF;
46: IF (P_BUCKET3 IS NOT NULL) THEN
47: FND_MESSAGE.SET_NAME('SQLAP'
43: CP_BUCKET2_NAME := FND_MESSAGE.GET;
44: NULL;
45: END IF;
46: IF (P_BUCKET3 IS NOT NULL) THEN
47: FND_MESSAGE.SET_NAME('SQLAP'
48: ,'OIE_CC_BUCKET3_NAME');
49: FND_MESSAGE.SET_TOKEN('BUCKET2'
50: ,P_BUCKET2 + 1);
51: FND_MESSAGE.SET_TOKEN('BUCKET3'
45: END IF;
46: IF (P_BUCKET3 IS NOT NULL) THEN
47: FND_MESSAGE.SET_NAME('SQLAP'
48: ,'OIE_CC_BUCKET3_NAME');
49: FND_MESSAGE.SET_TOKEN('BUCKET2'
50: ,P_BUCKET2 + 1);
51: FND_MESSAGE.SET_TOKEN('BUCKET3'
52: ,P_BUCKET3);
53: CP_BUCKET3_NAME := FND_MESSAGE.GET;
47: FND_MESSAGE.SET_NAME('SQLAP'
48: ,'OIE_CC_BUCKET3_NAME');
49: FND_MESSAGE.SET_TOKEN('BUCKET2'
50: ,P_BUCKET2 + 1);
51: FND_MESSAGE.SET_TOKEN('BUCKET3'
52: ,P_BUCKET3);
53: CP_BUCKET3_NAME := FND_MESSAGE.GET;
54: NULL;
55: FND_MESSAGE.SET_NAME('SQLAP'
49: FND_MESSAGE.SET_TOKEN('BUCKET2'
50: ,P_BUCKET2 + 1);
51: FND_MESSAGE.SET_TOKEN('BUCKET3'
52: ,P_BUCKET3);
53: CP_BUCKET3_NAME := FND_MESSAGE.GET;
54: NULL;
55: FND_MESSAGE.SET_NAME('SQLAP'
56: ,'OIE_CC_BUCKET4_NAME');
57: FND_MESSAGE.SET_TOKEN('BUCKET4'
51: FND_MESSAGE.SET_TOKEN('BUCKET3'
52: ,P_BUCKET3);
53: CP_BUCKET3_NAME := FND_MESSAGE.GET;
54: NULL;
55: FND_MESSAGE.SET_NAME('SQLAP'
56: ,'OIE_CC_BUCKET4_NAME');
57: FND_MESSAGE.SET_TOKEN('BUCKET4'
58: ,P_BUCKET3 + 1);
59: CP_BUCKET4_NAME := FND_MESSAGE.GET;
53: CP_BUCKET3_NAME := FND_MESSAGE.GET;
54: NULL;
55: FND_MESSAGE.SET_NAME('SQLAP'
56: ,'OIE_CC_BUCKET4_NAME');
57: FND_MESSAGE.SET_TOKEN('BUCKET4'
58: ,P_BUCKET3 + 1);
59: CP_BUCKET4_NAME := FND_MESSAGE.GET;
60: NULL;
61: END IF;
55: FND_MESSAGE.SET_NAME('SQLAP'
56: ,'OIE_CC_BUCKET4_NAME');
57: FND_MESSAGE.SET_TOKEN('BUCKET4'
58: ,P_BUCKET3 + 1);
59: CP_BUCKET4_NAME := FND_MESSAGE.GET;
60: NULL;
61: END IF;
62: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
63: