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_TO_FORM_MOLINES dependencies on FND_API

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

17: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
18:
19: PROCEDURE Validate_and_Write(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_action_code IN NUMBER,
25: P_line_id IN NUMBER := FND_API.G_MISS_NUM,

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

18:
19: PROCEDURE Validate_and_Write(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_action_code IN NUMBER,
25: P_line_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,

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

19: PROCEDURE Validate_and_Write(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_action_code IN NUMBER,
25: P_line_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
27: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,

Line 25: P_line_id IN NUMBER := FND_API.G_MISS_NUM,

21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_action_code IN NUMBER,
25: P_line_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
27: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
28: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
29: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,

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

22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_action_code IN NUMBER,
25: P_line_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
27: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
28: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
29: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
30: p_LAST_UPDATED_LOGIN IN NUMBER := FND_API.G_MISS_NUM,

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

23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_action_code IN NUMBER,
25: P_line_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
27: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
28: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
29: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
30: p_LAST_UPDATED_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
31: p_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,

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

24: p_action_code IN NUMBER,
25: P_line_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
27: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
28: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
29: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
30: p_LAST_UPDATED_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
31: p_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
32: p_CUSTOMER_PO IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

25: P_line_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
27: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
28: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
29: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
30: p_LAST_UPDATED_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
31: p_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
32: p_CUSTOMER_PO IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_INCIDENT_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 30: p_LAST_UPDATED_LOGIN IN NUMBER := FND_API.G_MISS_NUM,

26: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
27: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
28: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
29: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
30: p_LAST_UPDATED_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
31: p_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
32: p_CUSTOMER_PO IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_INCIDENT_ID IN NUMBER := FND_API.G_MISS_NUM,
34: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,

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

27: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
28: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
29: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
30: p_LAST_UPDATED_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
31: p_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
32: p_CUSTOMER_PO IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_INCIDENT_ID IN NUMBER := FND_API.G_MISS_NUM,
34: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_TASK_ASSIGNMENT_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 32: p_CUSTOMER_PO IN VARCHAR2 := FND_API.G_MISS_CHAR,

28: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
29: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
30: p_LAST_UPDATED_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
31: p_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
32: p_CUSTOMER_PO IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_INCIDENT_ID IN NUMBER := FND_API.G_MISS_NUM,
34: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_TASK_ASSIGNMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
36: p_COMMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

29: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
30: p_LAST_UPDATED_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
31: p_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
32: p_CUSTOMER_PO IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_INCIDENT_ID IN NUMBER := FND_API.G_MISS_NUM,
34: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_TASK_ASSIGNMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
36: p_COMMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

30: p_LAST_UPDATED_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
31: p_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
32: p_CUSTOMER_PO IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_INCIDENT_ID IN NUMBER := FND_API.G_MISS_NUM,
34: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_TASK_ASSIGNMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
36: p_COMMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 35: p_TASK_ASSIGNMENT_ID IN NUMBER := FND_API.G_MISS_NUM,

31: p_HEADER_ID IN NUMBER := FND_API.G_MISS_NUM,
32: p_CUSTOMER_PO IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_INCIDENT_ID IN NUMBER := FND_API.G_MISS_NUM,
34: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_TASK_ASSIGNMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
36: p_COMMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

32: p_CUSTOMER_PO IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_INCIDENT_ID IN NUMBER := FND_API.G_MISS_NUM,
34: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_TASK_ASSIGNMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
36: p_COMMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

33: p_INCIDENT_ID IN NUMBER := FND_API.G_MISS_NUM,
34: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_TASK_ASSIGNMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
36: p_COMMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

34: p_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
35: p_TASK_ASSIGNMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
36: p_COMMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

35: p_TASK_ASSIGNMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
36: p_COMMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

36: p_COMMENTS IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

64: l_msg_data VARCHAR2(300);
65: l_check_existence NUMBER := 0;
66: l_return_status VARCHAR2(1);
67: l_msg_count NUMBER := 0;
68: l_commit VARCHAR2(1) := FND_API.G_FALSE;
69: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
70: l_task_id NUMBER := p_task_id;
71: l_task_assignment_id NUMBER := p_task_assignment_id;
72: EXCP_USER_DEFINED EXCEPTION;

Line 69: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;

65: l_check_existence NUMBER := 0;
66: l_return_status VARCHAR2(1);
67: l_msg_count NUMBER := 0;
68: l_commit VARCHAR2(1) := FND_API.G_FALSE;
69: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
70: l_task_id NUMBER := p_task_id;
71: l_task_assignment_id NUMBER := p_task_assignment_id;
72: EXCP_USER_DEFINED EXCEPTION;
73:

Line 91: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

87:
88: BEGIN
89: savepoint Validate_And_Write_PUB;
90:
91: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
92: -- initialize message list
93: FND_MSG_PUB.initialize;
94: END IF;
95:

Line 97: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Standard call to check for call compatibility.
97: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
98: p_api_version_number,
99: l_api_name,
100: G_PKG_NAME)
101: THEN

Line 102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

98: p_api_version_number,
99: l_api_name,
100: G_PKG_NAME)
101: THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105: --validating p_action_code
106: IF nvl(p_action_code, fnd_api.g_miss_num) NOT IN (0, 1, 2) THEN

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

102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105: --validating p_action_code
106: IF nvl(p_action_code, fnd_api.g_miss_num) NOT IN (0, 1, 2) THEN
107: fnd_message.set_name ('INV', 'INV-INVALID ACTION');
108: fnd_message.set_token ('ROUTINE', l_pkg_api_name, FALSE);
109: fnd_msg_pub.add;
110: RAISE EXCP_USER_DEFINED;

Line 115: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

111: END IF;
112:
113: IF p_action_code = 0 THEN
114: -- check p_header_id and p_line_id. if null return an error.
115: IF nvl(p_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
116: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
117: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
118: FND_MSG_PUB.ADD;
119: RAISE EXCP_USER_DEFINED;

Line 143: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

139: END;
140:
141: END IF;
142:
143: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
144: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
145: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);
146: FND_MSG_PUB.ADD;
147: RAISE EXCP_USER_DEFINED;

Line 180: IF nvl(p_task_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

176: END IF;
177: CLOSE l_Get_Line_ID_Csr;
178: END IF;
179:
180: IF nvl(p_task_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
181: -- Validate the task id
182: BEGIN
183: SELECT task_id INTO l_check_existence
184: FROM jtf_tasks_vl

Line 202: IF nvl(p_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

198: RAISE EXCP_USER_DEFINED;
199: END;
200: END IF;
201:
202: IF nvl(p_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
203: IF nvl(p_task_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
204: -- validate the task_assignment_id against the task_id.
205: BEGIN
206: SELECT task_assignment_id INTO l_check_existence

Line 203: IF nvl(p_task_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

199: END;
200: END IF;
201:
202: IF nvl(p_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
203: IF nvl(p_task_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
204: -- validate the task_assignment_id against the task_id.
205: BEGIN
206: SELECT task_assignment_id INTO l_check_existence
207: FROM jtf_task_assignments

Line 247: IF nvl(p_incident_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

243: END;
244: END IF;
245: END IF;
246:
247: IF nvl(p_incident_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
248: -- validate the incident id
249: BEGIN
250: SELECT incident_id INTO l_check_existence
251: FROM cs_incidents_all

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

266: END;
267: END IF;
268:
269: -- check creation_date and last_update_date
270: IF nvl(l_creation_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
271: l_creation_date := sysdate;
272: END IF;
273:
274: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN

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

270: IF nvl(l_creation_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
271: l_creation_date := sysdate;
272: END IF;
273:
274: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
275: l_last_update_date := sysdate;
276: END IF;
277:
278: IF nvl(l_created_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

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

274: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
275: l_last_update_date := sysdate;
276: END IF;
277:
278: IF nvl(l_created_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
279: l_created_by := g_user_id;
280: END IF;
281:
282: IF nvl(l_last_update_login, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

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

278: IF nvl(l_created_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
279: l_created_by := g_user_id;
280: END IF;
281:
282: IF nvl(l_last_update_login, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
283: l_last_update_login := g_login_id;
284: END IF;
285:
286: IF nvl(l_last_updated_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

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

282: IF nvl(l_last_update_login, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
283: l_last_update_login := g_login_id;
284: END IF;
285:
286: IF nvl(l_last_updated_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
287: l_last_updated_by := g_user_id;
288: END IF;
289:
290: ELSIF p_action_code = 1 THEN

Line 291: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

287: l_last_updated_by := g_user_id;
288: END IF;
289:
290: ELSIF p_action_code = 1 THEN
291: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
292: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
293: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);
294: FND_MSG_PUB.ADD;
295: RAISE EXCP_USER_DEFINED;

Line 318: IF nvl(p_header_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

314: END;
315: END IF;
316:
317: -- check p_header_id and p_line_id. if null return an error.
318: IF nvl(p_header_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
319: -- validate where the header_id already exists.
320: BEGIN
321: SELECT header_id INTO l_check_existence
322: FROM csp_moveorder_headers

Line 340: IF nvl(l_task_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

336: RAISE EXCP_USER_DEFINED;
337: END;
338: END IF;
339:
340: IF nvl(l_task_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
341: -- Validate the task id
342: BEGIN
343: SELECT task_id INTO l_check_existence
344: FROM jtf_tasks_vl

Line 361: IF nvl(p_task_assignment_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

357: FND_MSG_PUB.ADD;
358: RAISE EXCP_USER_DEFINED;
359: END;
360:
361: IF nvl(p_task_assignment_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
362: SELECT nvl(task_assignment_id, fnd_api.g_miss_num) INTO l_task_assignment_id
363: FROM csp_moveorder_lines
364: WHERE line_id = p_line_id;
365:

Line 362: SELECT nvl(task_assignment_id, fnd_api.g_miss_num) INTO l_task_assignment_id

358: RAISE EXCP_USER_DEFINED;
359: END;
360:
361: IF nvl(p_task_assignment_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
362: SELECT nvl(task_assignment_id, fnd_api.g_miss_num) INTO l_task_assignment_id
363: FROM csp_moveorder_lines
364: WHERE line_id = p_line_id;
365:
366: IF nvl(l_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

Line 366: IF nvl(l_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

362: SELECT nvl(task_assignment_id, fnd_api.g_miss_num) INTO l_task_assignment_id
363: FROM csp_moveorder_lines
364: WHERE line_id = p_line_id;
365:
366: IF nvl(l_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
367: BEGIN
368: SELECT task_assignment_id INTO l_check_existence
369: FROM jtf_task_assignments
370: WHERE task_assignment_id = l_task_assignment_id

Line 391: IF nvl(p_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

387: END IF;
388: END IF;
389: END IF;
390:
391: IF nvl(p_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
392: IF nvl(p_task_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
393: -- find out the task_id in the existing moveorder_line record.
394: SELECT nvl(task_id, fnd_api.g_miss_num) INTO l_task_id
395: FROM csp_moveorder_lines

Line 392: IF nvl(p_task_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

388: END IF;
389: END IF;
390:
391: IF nvl(p_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
392: IF nvl(p_task_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
393: -- find out the task_id in the existing moveorder_line record.
394: SELECT nvl(task_id, fnd_api.g_miss_num) INTO l_task_id
395: FROM csp_moveorder_lines
396: WHERE line_id = p_line_id;

Line 394: SELECT nvl(task_id, fnd_api.g_miss_num) INTO l_task_id

390:
391: IF nvl(p_task_assignment_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
392: IF nvl(p_task_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
393: -- find out the task_id in the existing moveorder_line record.
394: SELECT nvl(task_id, fnd_api.g_miss_num) INTO l_task_id
395: FROM csp_moveorder_lines
396: WHERE line_id = p_line_id;
397: END IF;
398:

Line 399: IF nvl(l_task_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

395: FROM csp_moveorder_lines
396: WHERE line_id = p_line_id;
397: END IF;
398:
399: IF nvl(l_task_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
400: -- validate the task_assignment_id against the task_id.
401: BEGIN
402: SELECT task_assignment_id INTO l_check_existence
403: FROM jtf_task_assignments

Line 443: IF nvl(p_incident_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

439: END;
440: END IF;
441: END IF;
442:
443: IF nvl(p_incident_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
444: -- validate the incident id
445: BEGIN
446: SELECT incident_id INTO l_check_existence
447: FROM cs_incidents_all

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

462: END;
463: END IF;
464:
465: -- validate the creation_date
466: IF nvl(l_creation_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
467: Open l_Get_Creation_Date_Csr;
468: Fetch l_Get_Creation_Date_Csr into l_creation_date;
469: If l_Get_Creation_Date_Csr%NOTFOUND Then
470: Close l_Get_Creation_Date_Csr;

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

477: End if;
478: Close l_Get_Creation_Date_Csr;
479: End if;
480:
481: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
482: l_last_update_date := sysdate;
483: END IF;
484: ELSE -- p_action_code = 2
485: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 485: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

481: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
482: l_last_update_date := sysdate;
483: END IF;
484: ELSE -- p_action_code = 2
485: IF nvl(p_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
486: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
487: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);
488: FND_MSG_PUB.ADD;
489: RAISE EXCP_USER_DEFINED;

Line 514: l_mol_rec.CREATED_BY := nvl(l_CREATED_BY, fnd_api.g_miss_num);

510: END IF;
511:
512: -- construct the l_mol_rec for calling the CSP_ORDRELINES_PVT.Create_orderlines
513: l_mol_rec.LINE_ID := P_line_id;
514: l_mol_rec.CREATED_BY := nvl(l_CREATED_BY, fnd_api.g_miss_num);
515: l_mol_rec.CREATION_DATE := l_CREATION_DATE;
516: l_mol_rec.LAST_UPDATED_BY := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);
517: l_mol_rec.LAST_UPDATE_DATE := l_LAST_UPDATE_DATE;
518: l_mol_rec.LAST_UPDATED_LOGIN := l_LAST_UPDATE_LOGIN;

Line 516: l_mol_rec.LAST_UPDATED_BY := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);

512: -- construct the l_mol_rec for calling the CSP_ORDRELINES_PVT.Create_orderlines
513: l_mol_rec.LINE_ID := P_line_id;
514: l_mol_rec.CREATED_BY := nvl(l_CREATED_BY, fnd_api.g_miss_num);
515: l_mol_rec.CREATION_DATE := l_CREATION_DATE;
516: l_mol_rec.LAST_UPDATED_BY := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);
517: l_mol_rec.LAST_UPDATE_DATE := l_LAST_UPDATE_DATE;
518: l_mol_rec.LAST_UPDATED_LOGIN := l_LAST_UPDATE_LOGIN;
519: l_mol_rec.HEADER_ID := nvl(p_HEADER_ID, fnd_api.g_miss_num);
520: l_mol_rec.CUSTOMER_PO := p_CUSTOMER_PO;

Line 519: l_mol_rec.HEADER_ID := nvl(p_HEADER_ID, fnd_api.g_miss_num);

515: l_mol_rec.CREATION_DATE := l_CREATION_DATE;
516: l_mol_rec.LAST_UPDATED_BY := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);
517: l_mol_rec.LAST_UPDATE_DATE := l_LAST_UPDATE_DATE;
518: l_mol_rec.LAST_UPDATED_LOGIN := l_LAST_UPDATE_LOGIN;
519: l_mol_rec.HEADER_ID := nvl(p_HEADER_ID, fnd_api.g_miss_num);
520: l_mol_rec.CUSTOMER_PO := p_CUSTOMER_PO;
521: l_mol_rec.INCIDENT_ID := p_INCIDENT_ID;
522: l_mol_rec.TASK_ID := p_TASK_ID;
523: l_mol_rec.TASK_ASSIGNMENT_ID := p_TASK_ASSIGNMENT_ID;

Line 581: IF l_return_status <> fnd_api.g_ret_sts_success THEN

577: X_Msg_Count => X_Msg_Count,
578: X_Msg_Data => X_Msg_Data);
579: end if;
580:
581: IF l_return_status <> fnd_api.g_ret_sts_success THEN
582: RAISE FND_API.G_EXC_ERROR;
583: END IF;
584:
585: IF fnd_api.to_boolean(p_commit) THEN

Line 582: RAISE FND_API.G_EXC_ERROR;

578: X_Msg_Data => X_Msg_Data);
579: end if;
580:
581: IF l_return_status <> fnd_api.g_ret_sts_success THEN
582: RAISE FND_API.G_EXC_ERROR;
583: END IF;
584:
585: IF fnd_api.to_boolean(p_commit) THEN
586: commit work;

Line 585: IF fnd_api.to_boolean(p_commit) THEN

581: IF l_return_status <> fnd_api.g_ret_sts_success THEN
582: RAISE FND_API.G_EXC_ERROR;
583: END IF;
584:
585: IF fnd_api.to_boolean(p_commit) THEN
586: commit work;
587: END IF;
588:
589: EXCEPTION

Line 592: x_return_status := FND_API.G_RET_STS_ERROR;

588:
589: EXCEPTION
590: WHEN EXCP_USER_DEFINED THEN
591: Rollback to Validate_And_Write_PUB;
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: fnd_msg_pub.count_and_get
594: ( p_count => x_msg_count
595: , p_data => x_msg_data);
596: --for debugging purpose

Line 598: WHEN FND_API.G_EXC_ERROR THEN

594: ( p_count => x_msg_count
595: , p_data => x_msg_data);
596: --for debugging purpose
597: --x_msg_data := l_msg_data;
598: WHEN FND_API.G_EXC_ERROR THEN
599: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
600: P_API_NAME => L_API_NAME
601: ,P_PKG_NAME => G_PKG_NAME
602: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

603: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
604: ,X_MSG_COUNT => X_MSG_COUNT
605: ,X_MSG_DATA => X_MSG_DATA
606: ,X_RETURN_STATUS => X_RETURN_STATUS);
607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
608: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
609: P_API_NAME => L_API_NAME
610: ,P_PKG_NAME => G_PKG_NAME
611: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 625: x_return_status := fnd_api.g_ret_sts_error;

621: fnd_msg_pub.add;
622: fnd_msg_pub.count_and_get
623: ( p_count => x_msg_count
624: , p_data => x_msg_data);
625: x_return_status := fnd_api.g_ret_sts_error;
626:
627: END Validate_and_Write;
628:
629: END CSP_TO_FORM_MOLINES;