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.CSP_PC_FORM_PICKHEADERS dependencies on FND_API

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

20: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
21:
22: PROCEDURE Validate_And_Write (
23: P_Api_Version_Number IN NUMBER,
24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_action_code IN NUMBER,
28: px_picklist_header_id IN OUT NOCOPY NUMBER,

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

21:
22: PROCEDURE Validate_And_Write (
23: P_Api_Version_Number IN NUMBER,
24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_action_code IN NUMBER,
28: px_picklist_header_id IN OUT NOCOPY NUMBER,
29: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,

Line 26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

22: PROCEDURE Validate_And_Write (
23: P_Api_Version_Number IN NUMBER,
24: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_action_code IN NUMBER,
28: px_picklist_header_id IN OUT NOCOPY NUMBER,
29: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,

Line 29: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,

25: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_action_code IN NUMBER,
28: px_picklist_header_id IN OUT NOCOPY NUMBER,
29: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,

Line 30: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,

26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_action_code IN NUMBER,
28: px_picklist_header_id IN OUT NOCOPY NUMBER,
29: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
34: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 31: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,

27: p_action_code IN NUMBER,
28: px_picklist_header_id IN OUT NOCOPY NUMBER,
29: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
34: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_PICKLIST_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,

28: px_picklist_header_id IN OUT NOCOPY NUMBER,
29: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
34: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_PICKLIST_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_PICKLIST_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 33: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,

29: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
30: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
34: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_PICKLIST_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_PICKLIST_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_DATE_CREATED IN DATE := FND_API.G_MISS_DATE,

Line 34: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,

30: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
31: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
34: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_PICKLIST_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_PICKLIST_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_DATE_CREATED IN DATE := FND_API.G_MISS_DATE,
38: p_DATE_CONFIRMED IN DATE := FND_API.G_MISS_DATE,

Line 35: p_PICKLIST_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,

31: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
34: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_PICKLIST_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_PICKLIST_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_DATE_CREATED IN DATE := FND_API.G_MISS_DATE,
38: p_DATE_CONFIRMED IN DATE := FND_API.G_MISS_DATE,
39: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 36: p_PICKLIST_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,

32: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
33: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
34: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_PICKLIST_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_PICKLIST_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_DATE_CREATED IN DATE := FND_API.G_MISS_DATE,
38: p_DATE_CONFIRMED IN DATE := FND_API.G_MISS_DATE,
39: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 37: p_DATE_CREATED IN DATE := FND_API.G_MISS_DATE,

33: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
34: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_PICKLIST_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_PICKLIST_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_DATE_CREATED IN DATE := FND_API.G_MISS_DATE,
38: p_DATE_CONFIRMED IN DATE := FND_API.G_MISS_DATE,
39: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 38: p_DATE_CONFIRMED IN DATE := FND_API.G_MISS_DATE,

34: p_ORGANIZATION_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_PICKLIST_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_PICKLIST_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_DATE_CREATED IN DATE := FND_API.G_MISS_DATE,
38: p_DATE_CONFIRMED IN DATE := FND_API.G_MISS_DATE,
39: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 39: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

35: p_PICKLIST_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_PICKLIST_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_DATE_CREATED IN DATE := FND_API.G_MISS_DATE,
38: p_DATE_CONFIRMED IN DATE := FND_API.G_MISS_DATE,
39: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 40: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

36: p_PICKLIST_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_DATE_CREATED IN DATE := FND_API.G_MISS_DATE,
38: p_DATE_CONFIRMED IN DATE := FND_API.G_MISS_DATE,
39: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 41: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

37: p_DATE_CREATED IN DATE := FND_API.G_MISS_DATE,
38: p_DATE_CONFIRMED IN DATE := FND_API.G_MISS_DATE,
39: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 42: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

38: p_DATE_CONFIRMED IN DATE := FND_API.G_MISS_DATE,
39: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 43: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

39: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 44: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

40: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 45: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

41: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 46: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

42: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 47: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

43: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 48: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

44: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 49: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

45: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 50: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

46: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_ATTRIBUTE15 IN VARCHAR2,

Line 51: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

47: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_ATTRIBUTE15 IN VARCHAR2,
55: X_Return_Status OUT NOCOPY VARCHAR2,

Line 52: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

48: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_ATTRIBUTE15 IN VARCHAR2,
55: X_Return_Status OUT NOCOPY VARCHAR2,
56: X_Msg_Count OUT NOCOPY NUMBER,

Line 53: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

49: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_ATTRIBUTE15 IN VARCHAR2,
55: X_Return_Status OUT NOCOPY VARCHAR2,
56: X_Msg_Count OUT NOCOPY NUMBER,
57: X_Msg_Data OUT NOCOPY VARCHAR2

Line 68: l_commit VARCHAR2(1) := FND_API.G_FALSE;

64: l_check_var VARCHAR2(30);
65: l_return_status VARCHAR2(1);
66: l_msg_count NUMBER := 0;
67: l_picklist_header_id NUMBER;
68: l_commit VARCHAR2(1) := FND_API.G_FALSE;
69: -- for inserting data, the validation_level should be none
70: -- because we do not want to call the core apps standard validations.
71: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
72: l_creation_date DATE := p_creation_date;

Line 71: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;

67: l_picklist_header_id NUMBER;
68: l_commit VARCHAR2(1) := FND_API.G_FALSE;
69: -- for inserting data, the validation_level should be none
70: -- because we do not want to call the core apps standard validations.
71: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
72: l_creation_date DATE := p_creation_date;
73: l_last_update_date DATE := p_last_update_date;
74: l_PICK_HEADER_Rec CSP_PICKLIST_HEADER_PVT.PICK_HEADER_Rec_Type;
75: EXCP_USER_DEFINED EXCEPTION;

Line 86: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

82: Where picklist_header_id = px_PICKLIST_HEADER_ID;
83:
84: BEGIN
85: SAVEPOINT Validate_And_Write_PUB;
86: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
87: -- initialize message list
88: FND_MSG_PUB.initialize;
89: END IF;
90:

Line 92: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

88: FND_MSG_PUB.initialize;
89: END IF;
90:
91: -- Standard call to check for call compatibility.
92: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
93: p_api_version_number,
94: l_api_name,
95: G_PKG_NAME)
96: THEN

Line 97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

93: p_api_version_number,
94: l_api_name,
95: G_PKG_NAME)
96: THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:
100:
101: IF nvl(p_action_code, fnd_api.g_miss_num) NOT IN (0, 1, 2) THEN

Line 101: IF nvl(p_action_code, fnd_api.g_miss_num) NOT IN (0, 1, 2) THEN

97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:
100:
101: IF nvl(p_action_code, fnd_api.g_miss_num) NOT IN (0, 1, 2) THEN
102: fnd_message.set_name ('INV', 'INV-INVALID ACTION');
103: fnd_message.set_token ('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
104: fnd_msg_pub.add;
105: RAISE EXCP_USER_DEFINED;

Line 109: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

105: RAISE EXCP_USER_DEFINED;
106: END IF;
107:
108: IF p_action_code = 0 THEN
109: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
110: -- check whethter the px_picklist_header_id already exists.
111: BEGIN
112: SELECT picklist_header_id INTO l_check_existence
113: FROM CSP_PICKLIST_HEADERS

Line 135: IF nvl(p_PICKLIST_STATUS, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN

131: END;
132: END IF;
133:
134: -- Validate the status against the lookup codes.
135: IF nvl(p_PICKLIST_STATUS, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
136: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
137: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_status', FALSE);
138: FND_MSG_PUB.ADD;
139: RAISE EXCP_USER_DEFINED;

Line 163: IF nvl(p_organization_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

159: END;
160: END IF;
161:
162: --validation of organization_id
163: IF nvl(p_organization_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
164: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
165: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', FALSE);
166: FND_MSG_PUB.ADD;
167: RAISE EXCP_USER_DEFINED;

Line 189: IF nvl(l_creation_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN

185: END;
186: END IF;
187:
188: -- check creation_date and last_update_date
189: IF nvl(l_creation_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
190: l_creation_date := sysdate;
191: END IF;
192:
193: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN

Line 193: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN

189: IF nvl(l_creation_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
190: l_creation_date := sysdate;
191: END IF;
192:
193: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
194: l_last_update_date := sysdate;
195: END IF;
196:
197: IF nvl(l_created_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 197: IF nvl(l_created_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

193: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
194: l_last_update_date := sysdate;
195: END IF;
196:
197: IF nvl(l_created_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
198: l_created_by := g_user_id;
199: END IF;
200:
201: IF nvl(l_last_update_login, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 201: IF nvl(l_last_update_login, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

197: IF nvl(l_created_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
198: l_created_by := g_user_id;
199: END IF;
200:
201: IF nvl(l_last_update_login, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
202: l_last_update_login := g_login_id;
203: END IF;
204:
205: IF nvl(l_last_updated_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 205: IF nvl(l_last_updated_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

201: IF nvl(l_last_update_login, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
202: l_last_update_login := g_login_id;
203: END IF;
204:
205: IF nvl(l_last_updated_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
206: l_last_updated_by := g_user_id;
207: END IF;
208:
209:

Line 214: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

210: ELSIF p_action_code = 1 THEN
211: -- Picklist header id is required for update.
212: -- We do need to take care the case which the user updates the picklist_header_id to a record
213: -- which already exists because the picklist_header_id is a primary key.
214: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
215: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
216: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_header_id', FALSE);
217: FND_MSG_PUB.ADD;
218: RAISE EXCP_USER_DEFINED;

Line 241: IF nvl(p_PICKLIST_STATUS, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN

237: END;
238: END IF;
239:
240: -- Validate the status against the lookup codes.
241: IF nvl(p_PICKLIST_STATUS, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
242: BEGIN
243: select distinct lookup_code into l_check_var
244: from fnd_lookups
245: where lookup_type = 'CSP_PICKLIST_STATUS'

Line 264: IF nvl(p_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

260: END;
261: END IF;
262:
263: --validation of organization_id
264: IF nvl(p_organization_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
265: BEGIN
266: select organization_id into l_check_existence
267: from mtl_parameters
268: where organization_id = p_organization_id;

Line 285: IF nvl(l_creation_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN

281: END;
282: END IF;
283:
284: -- validate the creation_date
285: IF nvl(l_creation_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
286: Open l_Get_Creation_Date_Csr;
287: Fetch l_Get_Creation_Date_Csr into l_creation_date;
288: If l_Get_Creation_Date_Csr%NOTFOUND Then
289: Close l_Get_Creation_Date_Csr;

Line 300: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN

296: End if;
297: Close l_Get_Creation_Date_Csr;
298: End if;
299:
300: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
301: l_last_update_date := sysdate;
302: END IF;
303:
304: ELSE -- p_action_code = 2

Line 305: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

301: l_last_update_date := sysdate;
302: END IF;
303:
304: ELSE -- p_action_code = 2
305: IF nvl(px_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
306: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
307: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_picklist_header_id', FALSE);
308: FND_MSG_PUB.ADD;
309: RAISE EXCP_USER_DEFINED;

Line 335: l_pick_header_rec.CREATED_BY := nvl(l_CREATED_BY, fnd_api.g_miss_num);

331: END IF;
332:
333: -- Construct the record to call the CSP_picklist_header_PVT insert, update and delete operation
334: l_pick_header_rec.picklist_header_id := px_picklist_header_id;
335: l_pick_header_rec.CREATED_BY := nvl(l_CREATED_BY, fnd_api.g_miss_num);
336: l_pick_header_rec.CREATION_DATE := l_CREATION_DATE;
337: l_pick_header_rec.LAST_UPDATED_BY := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);
338: l_pick_header_rec.LAST_UPDATE_DATE := l_LAST_UPDATE_DATE;
339: l_pick_header_rec.LAST_UPDATE_LOGIN := l_LAST_UPDATE_LOGIN;

Line 337: l_pick_header_rec.LAST_UPDATED_BY := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);

333: -- Construct the record to call the CSP_picklist_header_PVT insert, update and delete operation
334: l_pick_header_rec.picklist_header_id := px_picklist_header_id;
335: l_pick_header_rec.CREATED_BY := nvl(l_CREATED_BY, fnd_api.g_miss_num);
336: l_pick_header_rec.CREATION_DATE := l_CREATION_DATE;
337: l_pick_header_rec.LAST_UPDATED_BY := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);
338: l_pick_header_rec.LAST_UPDATE_DATE := l_LAST_UPDATE_DATE;
339: l_pick_header_rec.LAST_UPDATE_LOGIN := l_LAST_UPDATE_LOGIN;
340: l_pick_header_rec.ORGANIZATION_ID := nvl(p_ORGANIZATION_ID, fnd_api.g_miss_num);
341: l_pick_header_rec.PICKLIST_NUMBER := p_PICKLIST_NUMBER;

Line 340: l_pick_header_rec.ORGANIZATION_ID := nvl(p_ORGANIZATION_ID, fnd_api.g_miss_num);

336: l_pick_header_rec.CREATION_DATE := l_CREATION_DATE;
337: l_pick_header_rec.LAST_UPDATED_BY := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);
338: l_pick_header_rec.LAST_UPDATE_DATE := l_LAST_UPDATE_DATE;
339: l_pick_header_rec.LAST_UPDATE_LOGIN := l_LAST_UPDATE_LOGIN;
340: l_pick_header_rec.ORGANIZATION_ID := nvl(p_ORGANIZATION_ID, fnd_api.g_miss_num);
341: l_pick_header_rec.PICKLIST_NUMBER := p_PICKLIST_NUMBER;
342: l_pick_header_rec.PICKLIST_STATUS := nvl(p_PICKLIST_STATUS, fnd_api.g_miss_char);
343: l_pick_header_rec.DATE_CREATED := p_DATE_CREATED;
344: l_pick_header_rec.DATE_CONFIRMED := p_DATE_CONFIRMED;

Line 342: l_pick_header_rec.PICKLIST_STATUS := nvl(p_PICKLIST_STATUS, fnd_api.g_miss_char);

338: l_pick_header_rec.LAST_UPDATE_DATE := l_LAST_UPDATE_DATE;
339: l_pick_header_rec.LAST_UPDATE_LOGIN := l_LAST_UPDATE_LOGIN;
340: l_pick_header_rec.ORGANIZATION_ID := nvl(p_ORGANIZATION_ID, fnd_api.g_miss_num);
341: l_pick_header_rec.PICKLIST_NUMBER := p_PICKLIST_NUMBER;
342: l_pick_header_rec.PICKLIST_STATUS := nvl(p_PICKLIST_STATUS, fnd_api.g_miss_char);
343: l_pick_header_rec.DATE_CREATED := p_DATE_CREATED;
344: l_pick_header_rec.DATE_CONFIRMED := p_DATE_CONFIRMED;
345: l_pick_header_rec.ATTRIBUTE_CATEGORY := p_ATTRIBUTE_CATEGORY;
346: l_pick_header_rec.ATTRIBUTE1 := p_ATTRIBUTE1;

Line 404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

400: X_Msg_Data => l_Msg_Data
401: );
402: END IF;
403:
404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 405: RAISE FND_API.G_EXC_ERROR;

401: );
402: END IF;
403:
404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: px_picklist_header_id := l_picklist_header_id;

Line 408: x_return_status := FND_API.G_RET_STS_SUCCESS;

404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: px_picklist_header_id := l_picklist_header_id;
410: IF fnd_api.to_boolean(p_commit) THEN
411: commit work;
412: END IF;

Line 410: IF fnd_api.to_boolean(p_commit) THEN

406: END IF;
407:
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: px_picklist_header_id := l_picklist_header_id;
410: IF fnd_api.to_boolean(p_commit) THEN
411: commit work;
412: END IF;
413:
414: EXCEPTION

Line 417: x_return_status := FND_API.G_RET_STS_ERROR;

413:
414: EXCEPTION
415: WHEN EXCP_USER_DEFINED THEN
416: Rollback to Validate_And_Write_PUB;
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: fnd_msg_pub.count_and_get
419: ( p_count => x_msg_count
420: , p_data => x_msg_data);
421:

Line 425: WHEN FND_API.G_EXC_ERROR THEN

421:
422: --for debugging purpose
423: --x_msg_data := l_msg_data;
424:
425: WHEN FND_API.G_EXC_ERROR THEN
426: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
427: P_API_NAME => L_API_NAME
428: ,P_PKG_NAME => G_PKG_NAME
429: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

431: ,X_MSG_COUNT => X_MSG_COUNT
432: ,X_MSG_DATA => X_MSG_DATA
433: ,X_RETURN_STATUS => X_RETURN_STATUS);
434:
435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
436: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
437: P_API_NAME => L_API_NAME
438: ,P_PKG_NAME => G_PKG_NAME
439: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 453: x_return_status := fnd_api.g_ret_sts_error;

449: fnd_msg_pub.add;
450: fnd_msg_pub.count_and_get
451: ( p_count => x_msg_count
452: , p_data => x_msg_data);
453: x_return_status := fnd_api.g_ret_sts_error;
454:
455: END Validate_And_Write;
456:
457: END CSP_PC_FORM_PICKHEADERS;