APPS.PSB_PSBRPPOS_XMLP_PKG dependencies on FND_MESSAGE

Line 15: FND_MESSAGE.SET_NAME('PSB'

11: INTO CP_POSITION_SETS
12: FROM
13: PSB_ACCOUNT_POSITION_SETS
14: WHERE ACCOUNT_POSITION_SET_ID = P_ACCOUNT_POSITION_SET_ID;
15: FND_MESSAGE.SET_NAME('PSB'
16: ,'PSB_ALL');
17: CP_DATA_EXTRACT_NAME := FND_MESSAGE.GET;
18: END;
19: ELSIF (P_DATA_EXTRACT_ID IS NOT NULL AND P_ACCOUNT_POSITION_SET_ID IS NULL) THEN

Line 17: CP_DATA_EXTRACT_NAME := FND_MESSAGE.GET;

13: PSB_ACCOUNT_POSITION_SETS
14: WHERE ACCOUNT_POSITION_SET_ID = P_ACCOUNT_POSITION_SET_ID;
15: FND_MESSAGE.SET_NAME('PSB'
16: ,'PSB_ALL');
17: CP_DATA_EXTRACT_NAME := FND_MESSAGE.GET;
18: END;
19: ELSIF (P_DATA_EXTRACT_ID IS NOT NULL AND P_ACCOUNT_POSITION_SET_ID IS NULL) THEN
20: BEGIN
21: SELECT

Line 27: FND_MESSAGE.SET_NAME('PSB'

23: INTO CP_DATA_EXTRACT_NAME
24: FROM
25: PSB_DATA_EXTRACTS
26: WHERE DATA_EXTRACT_ID = P_DATA_EXTRACT_ID;
27: FND_MESSAGE.SET_NAME('PSB'
28: ,'PSB_ALL');
29: CP_POSITION_SETS := FND_MESSAGE.GET;
30: END;
31: ELSIF (P_DATA_EXTRACT_ID IS NOT NULL AND P_ACCOUNT_POSITION_SET_ID IS NOT NULL) THEN

Line 29: CP_POSITION_SETS := FND_MESSAGE.GET;

25: PSB_DATA_EXTRACTS
26: WHERE DATA_EXTRACT_ID = P_DATA_EXTRACT_ID;
27: FND_MESSAGE.SET_NAME('PSB'
28: ,'PSB_ALL');
29: CP_POSITION_SETS := FND_MESSAGE.GET;
30: END;
31: ELSIF (P_DATA_EXTRACT_ID IS NOT NULL AND P_ACCOUNT_POSITION_SET_ID IS NOT NULL) THEN
32: BEGIN
33: SELECT

Line 48: FND_MESSAGE.SET_NAME('PSB'

44: WHERE ACCOUNT_POSITION_SET_ID = P_ACCOUNT_POSITION_SET_ID;
45: END;
46: ELSIF (P_DATA_EXTRACT_ID IS NULL AND P_ACCOUNT_POSITION_SET_ID IS NULL) THEN
47: BEGIN
48: FND_MESSAGE.SET_NAME('PSB'
49: ,'PSB_ALL');
50: CP_POSITION_SETS := FND_MESSAGE.GET;
51: FND_MESSAGE.SET_NAME('PSB'
52: ,'PSB_ALL');

Line 50: CP_POSITION_SETS := FND_MESSAGE.GET;

46: ELSIF (P_DATA_EXTRACT_ID IS NULL AND P_ACCOUNT_POSITION_SET_ID IS NULL) THEN
47: BEGIN
48: FND_MESSAGE.SET_NAME('PSB'
49: ,'PSB_ALL');
50: CP_POSITION_SETS := FND_MESSAGE.GET;
51: FND_MESSAGE.SET_NAME('PSB'
52: ,'PSB_ALL');
53: CP_DATA_EXTRACT_NAME := FND_MESSAGE.GET;
54: END;

Line 51: FND_MESSAGE.SET_NAME('PSB'

47: BEGIN
48: FND_MESSAGE.SET_NAME('PSB'
49: ,'PSB_ALL');
50: CP_POSITION_SETS := FND_MESSAGE.GET;
51: FND_MESSAGE.SET_NAME('PSB'
52: ,'PSB_ALL');
53: CP_DATA_EXTRACT_NAME := FND_MESSAGE.GET;
54: END;
55: ELSE

Line 53: CP_DATA_EXTRACT_NAME := FND_MESSAGE.GET;

49: ,'PSB_ALL');
50: CP_POSITION_SETS := FND_MESSAGE.GET;
51: FND_MESSAGE.SET_NAME('PSB'
52: ,'PSB_ALL');
53: CP_DATA_EXTRACT_NAME := FND_MESSAGE.GET;
54: END;
55: ELSE
56: NULL;
57: END IF;

Line 58: FND_MESSAGE.SET_NAME('PSB'

54: END;
55: ELSE
56: NULL;
57: END IF;
58: FND_MESSAGE.SET_NAME('PSB'
59: ,'PSB_NO_DATA_FOUND');
60: C_NLS_NO_DATA_EXISTS := SUBSTR(FND_MESSAGE.GET,7,13);
61: FND_MESSAGE.SET_NAME('PSB'
62: ,'PSB_END_OF_REPORT');

Line 60: C_NLS_NO_DATA_EXISTS := SUBSTR(FND_MESSAGE.GET,7,13);

56: NULL;
57: END IF;
58: FND_MESSAGE.SET_NAME('PSB'
59: ,'PSB_NO_DATA_FOUND');
60: C_NLS_NO_DATA_EXISTS := SUBSTR(FND_MESSAGE.GET,7,13);
61: FND_MESSAGE.SET_NAME('PSB'
62: ,'PSB_END_OF_REPORT');
63: C_NLS_END_OF_REPORT := SUBSTR(FND_MESSAGE.GET,7,13);
64: RETURN (TRUE);

Line 61: FND_MESSAGE.SET_NAME('PSB'

57: END IF;
58: FND_MESSAGE.SET_NAME('PSB'
59: ,'PSB_NO_DATA_FOUND');
60: C_NLS_NO_DATA_EXISTS := SUBSTR(FND_MESSAGE.GET,7,13);
61: FND_MESSAGE.SET_NAME('PSB'
62: ,'PSB_END_OF_REPORT');
63: C_NLS_END_OF_REPORT := SUBSTR(FND_MESSAGE.GET,7,13);
64: RETURN (TRUE);
65: EXCEPTION

Line 63: C_NLS_END_OF_REPORT := SUBSTR(FND_MESSAGE.GET,7,13);

59: ,'PSB_NO_DATA_FOUND');
60: C_NLS_NO_DATA_EXISTS := SUBSTR(FND_MESSAGE.GET,7,13);
61: FND_MESSAGE.SET_NAME('PSB'
62: ,'PSB_END_OF_REPORT');
63: C_NLS_END_OF_REPORT := SUBSTR(FND_MESSAGE.GET,7,13);
64: RETURN (TRUE);
65: EXCEPTION
66: WHEN NO_DATA_FOUND THEN
67: RETURN NULL;