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

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

36: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
37:
38: PROCEDURE Validate_And_Write (
39: P_Api_Version_Number IN NUMBER,
40: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
44: px_PICKLIST_LINE_ID IN OUT NOCOPY NUMBER,

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

37:
38: PROCEDURE Validate_And_Write (
39: P_Api_Version_Number IN NUMBER,
40: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
44: px_PICKLIST_LINE_ID IN OUT NOCOPY NUMBER,
45: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,

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

38: PROCEDURE Validate_And_Write (
39: P_Api_Version_Number IN NUMBER,
40: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
44: px_PICKLIST_LINE_ID IN OUT NOCOPY NUMBER,
45: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
46: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,

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

41: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
44: px_PICKLIST_LINE_ID IN OUT NOCOPY NUMBER,
45: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
46: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
47: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
48: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
49: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,

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

42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
44: px_PICKLIST_LINE_ID IN OUT NOCOPY NUMBER,
45: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
46: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
47: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
48: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
49: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
50: p_PICKLIST_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,

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

43: p_action_code IN NUMBER, /* 0 = insert, 1 = update, 2 = delete */
44: px_PICKLIST_LINE_ID IN OUT NOCOPY NUMBER,
45: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
46: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
47: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
48: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
49: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
50: p_PICKLIST_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
51: p_picklist_header_id IN NUMBER := FND_API.G_MISS_NUM,

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

44: px_PICKLIST_LINE_ID IN OUT NOCOPY NUMBER,
45: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
46: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
47: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
48: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
49: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
50: p_PICKLIST_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
51: p_picklist_header_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,

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

45: p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
46: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
47: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
48: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
49: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
50: p_PICKLIST_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
51: p_picklist_header_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 50: p_PICKLIST_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,

46: p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
47: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
48: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
49: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
50: p_PICKLIST_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
51: p_picklist_header_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 51: p_picklist_header_id IN NUMBER := FND_API.G_MISS_NUM,

47: p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
48: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
49: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
50: p_PICKLIST_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
51: p_picklist_header_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 52: p_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,

48: p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
49: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
50: p_PICKLIST_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
51: p_picklist_header_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_QUANTITY_PICKED IN NUMBER := FND_API.G_MISS_NUM,

Line 53: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,

49: p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
50: p_PICKLIST_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
51: p_picklist_header_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_QUANTITY_PICKED IN NUMBER := FND_API.G_MISS_NUM,
57: p_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,

Line 54: p_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,

50: p_PICKLIST_LINE_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
51: p_picklist_header_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_QUANTITY_PICKED IN NUMBER := FND_API.G_MISS_NUM,
57: p_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 55: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,

51: p_picklist_header_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_QUANTITY_PICKED IN NUMBER := FND_API.G_MISS_NUM,
57: p_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 56: p_QUANTITY_PICKED IN NUMBER := FND_API.G_MISS_NUM,

52: p_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
53: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_QUANTITY_PICKED IN NUMBER := FND_API.G_MISS_NUM,
57: p_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 57: p_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,

53: p_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
54: p_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_QUANTITY_PICKED IN NUMBER := FND_API.G_MISS_NUM,
57: p_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

54: p_UOM_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_QUANTITY_PICKED IN NUMBER := FND_API.G_MISS_NUM,
57: p_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

55: p_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_QUANTITY_PICKED IN NUMBER := FND_API.G_MISS_NUM,
57: p_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

56: p_QUANTITY_PICKED IN NUMBER := FND_API.G_MISS_NUM,
57: p_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

57: p_TRANSACTION_TEMP_ID IN NUMBER := FND_API.G_MISS_NUM,
58: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

58: p_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

59: p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

60: p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

61: p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

62: p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

63: p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

64: p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

65: p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

66: p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: x_return_status OUT NOCOPY VARCHAR2,

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

67: p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,

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

68: p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2)

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

69: p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2)
77: IS

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

83: l_check_var VARCHAR2(20);
84: l_return_status VARCHAR2(1);
85: l_msg_count NUMBER := 0;
86: l_picklist_header_id NUMBER := p_picklist_header_id;
87: l_commit VARCHAR2(1) := FND_API.G_FALSE;
88: l_organization_id NUMBER;
89: l_picklist_line_id NUMBER := 0;
90: l_creation_date DATE := p_creation_date;
91: l_last_update_date DATE := p_last_update_date;

Line 94: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;

90: l_creation_date DATE := p_creation_date;
91: l_last_update_date DATE := p_last_update_date;
92: -- for inserting data, the validation_level should be none
93: -- because we do not want to call the core apps standard validations.
94: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
95: EXCP_USER_DEFINED EXCEPTION;
96: l_created_by NUMBER := p_created_by;
97: l_last_update_login NUMBER := p_last_update_login;
98: l_last_updated_by NUMBER := p_last_updated_by;

Line 106: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

102: Where picklist_line_id = px_PICKLIST_LINE_ID;
103:
104: BEGIN
105: SAVEPOINT Validate_And_Write_PUB;
106: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
107: -- initialize message list
108: FND_MSG_PUB.initialize;
109: END IF;
110:

Line 112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

108: FND_MSG_PUB.initialize;
109: END IF;
110:
111: -- Standard call to check for call compatibility.
112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
113: p_api_version_number,
114: l_api_name,
115: G_PKG_NAME)
116: THEN

Line 117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

113: p_api_version_number,
114: l_api_name,
115: G_PKG_NAME)
116: THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: --validating p_action_code
121: IF p_action_code NOT IN (0, 1, 2) OR p_action_code IS NULL THEN

Line 147: IF nvl(p_quantity_picked, fnd_api.g_miss_num) = fnd_api.g_miss_num OR p_quantity_picked < 0 THEN

143: END;
144: End IF;
145:
146: --validating quantity_picked
147: IF nvl(p_quantity_picked, fnd_api.g_miss_num) = fnd_api.g_miss_num OR p_quantity_picked < 0 THEN
148: fnd_message.set_name ('CSP', 'CSP_INVALID_QTY_PICKED');
149: fnd_msg_pub.add;
150: RAISE EXCP_USER_DEFINED;
151: END IF;

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

150: RAISE EXCP_USER_DEFINED;
151: END IF;
152:
153: -- Validate the move order line id
154: IF nvl(p_line_id,fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
155: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
156: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_line_id', FALSE);
157: FND_MSG_PUB.ADD;
158: RAISE EXCP_USER_DEFINED;

Line 184: IF nvl(p_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

180: END;
181: END IF;
182:
183: --validate p_picklist_header_id
184: IF nvl(p_picklist_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
185: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
186: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_header_id', FALSE);
187: FND_MSG_PUB.ADD;
188: RAISE EXCP_USER_DEFINED;

Line 212: IF nvl(p_inventory_item_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

208: END;
209: END IF;
210:
211: --validating inventory_item_id
212: IF nvl(p_inventory_item_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
213: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
214: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id ', FALSE);
215: FND_MSG_PUB.ADD;
216: RAISE EXCP_USER_DEFINED;

Line 240: IF nvl(p_picklist_line_number, 0) < 1 OR p_picklist_line_number = fnd_api.g_miss_num THEN

236: END;
237: END IF;
238:
239: -- Validate the Picklist_Line_Number
240: IF nvl(p_picklist_line_number, 0) < 1 OR p_picklist_line_number = fnd_api.g_miss_num THEN
241: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
242: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_picklist_line_number', FALSE);
243: FND_MSG_PUB.ADD;
244: RAISE EXCP_USER_DEFINED;

Line 247: IF nvl(p_transaction_temp_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

243: FND_MSG_PUB.ADD;
244: RAISE EXCP_USER_DEFINED;
245: END IF;
246:
247: IF nvl(p_transaction_temp_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
248: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
249: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', FALSE);
250: FND_MSG_PUB.ADD;
251: RAISE EXCP_USER_DEFINED;

Line 276: IF nvl(p_uom_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN

272: RAISE EXCP_USER_DEFINED;
273: END;
274: END IF;
275:
276: IF nvl(p_uom_code, fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
277: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
278: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_uom_code', FALSE);
279: FND_MSG_PUB.ADD;
280: RAISE EXCP_USER_DEFINED;

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

300: END;
301: END IF;
302:
303: -- check creation_date and last_update_date
304: IF nvl(l_creation_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
305: l_creation_date := sysdate;
306: END IF;
307:
308: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN

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

304: IF nvl(l_creation_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
305: l_creation_date := sysdate;
306: END IF;
307:
308: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
309: l_last_update_date := sysdate;
310: END IF;
311:
312: IF nvl(l_created_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

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

308: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
309: l_last_update_date := sysdate;
310: END IF;
311:
312: IF nvl(l_created_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
313: l_created_by := g_user_id;
314: END IF;
315:
316: IF nvl(l_last_update_login, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

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

312: IF nvl(l_created_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
313: l_created_by := g_user_id;
314: END IF;
315:
316: IF nvl(l_last_update_login, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
317: l_last_update_login := g_login_id;
318: END IF;
319:
320: IF nvl(l_last_updated_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

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

316: IF nvl(l_last_update_login, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
317: l_last_update_login := g_login_id;
318: END IF;
319:
320: IF nvl(l_last_updated_by, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
321: l_last_updated_by := g_user_id;
322: END IF;
323:
324: ELSIF p_action_code = 1 THEN

Line 352: IF nvl(p_picklist_header_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

348: END;
349: END IF;
350:
351: -- validate the pick list header id associated with the pick list line id
352: IF nvl(p_picklist_header_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
353: --validate the pick list header id.
354: BEGIN
355: -- for bug 1238607.
356: -- Since we are updating the picklist_header_id, we do not need to check whether it exists in the

Line 393: IF nvl(p_inventory_item_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

389: where picklist_line_id = px_picklist_line_id);
390: END IF;
391:
392: --validating inventory_item_id
393: IF nvl(p_inventory_item_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
394: BEGIN
395: -- validate whether the inventory_item_is exists in the given oranization_id
396: select inventory_item_id into l_check_existence
397: from mtl_system_items_kfv

Line 416: IF nvl(p_line_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

412: END;
413: END IF;
414:
415: -- Validate the move order line id
416: IF nvl(p_line_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
417: BEGIN
418: select line_id into l_check_existence
419: from csp_moveorder_lines
420: where line_id = p_line_id;

Line 440: IF nvl(p_uom_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN

436: RAISE EXCP_USER_DEFINED;
437: END;
438: END IF;
439:
440: IF nvl(p_uom_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
441: -- validate the UOM code
442: BEGIN
443: select UOM_CODE into l_check_var
444: from mtl_units_of_measure

Line 462: IF nvl(p_transaction_temp_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

458: RAISE EXCP_USER_DEFINED;
459: END;
460: END IF;
461:
462: IF nvl(p_transaction_temp_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
463: BEGIN
464: -- validate whether the transaction temp id is valid
465: select transaction_temp_id into l_check_existence
466: from mtl_material_transactions_temp

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

481: END;
482: END IF;
483:
484: -- validate the creation_date
485: IF nvl(l_creation_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
486: Open l_Get_Creation_Date_Csr;
487: Fetch l_Get_Creation_Date_Csr into l_creation_date;
488: If l_Get_Creation_Date_Csr%NOTFOUND Then
489: Close l_Get_Creation_Date_Csr;

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

496: End if;
497: Close l_Get_Creation_Date_Csr;
498: End if;
499:
500: IF nvl(l_last_update_date, fnd_api.g_miss_date) = fnd_api.g_miss_date THEN
501: l_last_update_date := sysdate;
502: END IF;
503:
504: ELSE -- p_action_code = 2

Line 535: l_picklist_line_rec.created_by := nvl(l_CREATED_BY, fnd_api.g_miss_num);

531:
532:
533: -- create picklist line record type
534: l_picklist_line_rec.picklist_line_id := px_picklist_line_id;
535: l_picklist_line_rec.created_by := nvl(l_CREATED_BY, fnd_api.g_miss_num);
536: l_picklist_line_rec.creation_date := l_CREATION_DATE;
537: l_picklist_line_rec.last_updated_by := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);
538: l_picklist_line_rec.last_update_date := l_LAST_UPDATE_DATE;
539: l_picklist_line_rec.last_update_login := l_LAST_UPDATE_LOGIN;

Line 537: l_picklist_line_rec.last_updated_by := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);

533: -- create picklist line record type
534: l_picklist_line_rec.picklist_line_id := px_picklist_line_id;
535: l_picklist_line_rec.created_by := nvl(l_CREATED_BY, fnd_api.g_miss_num);
536: l_picklist_line_rec.creation_date := l_CREATION_DATE;
537: l_picklist_line_rec.last_updated_by := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);
538: l_picklist_line_rec.last_update_date := l_LAST_UPDATE_DATE;
539: l_picklist_line_rec.last_update_login := l_LAST_UPDATE_LOGIN;
540: l_picklist_line_rec.picklist_line_number:= nvl(p_PICKLIST_LINE_NUMBER, fnd_api.g_miss_num);
541: l_picklist_line_rec.picklist_header_id := nvl(p_picklist_header_id, fnd_api.g_miss_num);

Line 540: l_picklist_line_rec.picklist_line_number:= nvl(p_PICKLIST_LINE_NUMBER, fnd_api.g_miss_num);

536: l_picklist_line_rec.creation_date := l_CREATION_DATE;
537: l_picklist_line_rec.last_updated_by := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);
538: l_picklist_line_rec.last_update_date := l_LAST_UPDATE_DATE;
539: l_picklist_line_rec.last_update_login := l_LAST_UPDATE_LOGIN;
540: l_picklist_line_rec.picklist_line_number:= nvl(p_PICKLIST_LINE_NUMBER, fnd_api.g_miss_num);
541: l_picklist_line_rec.picklist_header_id := nvl(p_picklist_header_id, fnd_api.g_miss_num);
542: l_picklist_line_rec.LINE_ID := nvl(p_LINE_ID, fnd_api.g_miss_num);
543: l_picklist_line_rec.INVENTORY_ITEM_ID := nvl(p_INVENTORY_ITEM_ID, fnd_api.g_miss_num);
544: l_picklist_line_rec.UOM_CODE := nvl(p_UOM_CODE, fnd_api.g_miss_char);

Line 541: l_picklist_line_rec.picklist_header_id := nvl(p_picklist_header_id, fnd_api.g_miss_num);

537: l_picklist_line_rec.last_updated_by := nvl(l_LAST_UPDATED_BY, fnd_api.g_miss_num);
538: l_picklist_line_rec.last_update_date := l_LAST_UPDATE_DATE;
539: l_picklist_line_rec.last_update_login := l_LAST_UPDATE_LOGIN;
540: l_picklist_line_rec.picklist_line_number:= nvl(p_PICKLIST_LINE_NUMBER, fnd_api.g_miss_num);
541: l_picklist_line_rec.picklist_header_id := nvl(p_picklist_header_id, fnd_api.g_miss_num);
542: l_picklist_line_rec.LINE_ID := nvl(p_LINE_ID, fnd_api.g_miss_num);
543: l_picklist_line_rec.INVENTORY_ITEM_ID := nvl(p_INVENTORY_ITEM_ID, fnd_api.g_miss_num);
544: l_picklist_line_rec.UOM_CODE := nvl(p_UOM_CODE, fnd_api.g_miss_char);
545: l_picklist_line_rec.REVISION := p_REVISION;

Line 542: l_picklist_line_rec.LINE_ID := nvl(p_LINE_ID, fnd_api.g_miss_num);

538: l_picklist_line_rec.last_update_date := l_LAST_UPDATE_DATE;
539: l_picklist_line_rec.last_update_login := l_LAST_UPDATE_LOGIN;
540: l_picklist_line_rec.picklist_line_number:= nvl(p_PICKLIST_LINE_NUMBER, fnd_api.g_miss_num);
541: l_picklist_line_rec.picklist_header_id := nvl(p_picklist_header_id, fnd_api.g_miss_num);
542: l_picklist_line_rec.LINE_ID := nvl(p_LINE_ID, fnd_api.g_miss_num);
543: l_picklist_line_rec.INVENTORY_ITEM_ID := nvl(p_INVENTORY_ITEM_ID, fnd_api.g_miss_num);
544: l_picklist_line_rec.UOM_CODE := nvl(p_UOM_CODE, fnd_api.g_miss_char);
545: l_picklist_line_rec.REVISION := p_REVISION;
546: l_picklist_line_rec.QUANTITY_PICKED := nvl(p_QUANTITY_PICKED, fnd_api.g_miss_num);

Line 543: l_picklist_line_rec.INVENTORY_ITEM_ID := nvl(p_INVENTORY_ITEM_ID, fnd_api.g_miss_num);

539: l_picklist_line_rec.last_update_login := l_LAST_UPDATE_LOGIN;
540: l_picklist_line_rec.picklist_line_number:= nvl(p_PICKLIST_LINE_NUMBER, fnd_api.g_miss_num);
541: l_picklist_line_rec.picklist_header_id := nvl(p_picklist_header_id, fnd_api.g_miss_num);
542: l_picklist_line_rec.LINE_ID := nvl(p_LINE_ID, fnd_api.g_miss_num);
543: l_picklist_line_rec.INVENTORY_ITEM_ID := nvl(p_INVENTORY_ITEM_ID, fnd_api.g_miss_num);
544: l_picklist_line_rec.UOM_CODE := nvl(p_UOM_CODE, fnd_api.g_miss_char);
545: l_picklist_line_rec.REVISION := p_REVISION;
546: l_picklist_line_rec.QUANTITY_PICKED := nvl(p_QUANTITY_PICKED, fnd_api.g_miss_num);
547: l_picklist_line_rec.TRANSACTION_TEMP_ID := nvl(p_TRANSACTION_TEMP_ID, fnd_api.g_miss_num);

Line 544: l_picklist_line_rec.UOM_CODE := nvl(p_UOM_CODE, fnd_api.g_miss_char);

540: l_picklist_line_rec.picklist_line_number:= nvl(p_PICKLIST_LINE_NUMBER, fnd_api.g_miss_num);
541: l_picklist_line_rec.picklist_header_id := nvl(p_picklist_header_id, fnd_api.g_miss_num);
542: l_picklist_line_rec.LINE_ID := nvl(p_LINE_ID, fnd_api.g_miss_num);
543: l_picklist_line_rec.INVENTORY_ITEM_ID := nvl(p_INVENTORY_ITEM_ID, fnd_api.g_miss_num);
544: l_picklist_line_rec.UOM_CODE := nvl(p_UOM_CODE, fnd_api.g_miss_char);
545: l_picklist_line_rec.REVISION := p_REVISION;
546: l_picklist_line_rec.QUANTITY_PICKED := nvl(p_QUANTITY_PICKED, fnd_api.g_miss_num);
547: l_picklist_line_rec.TRANSACTION_TEMP_ID := nvl(p_TRANSACTION_TEMP_ID, fnd_api.g_miss_num);
548: l_picklist_line_rec.ATTRIBUTE_CATEGORY := p_ATTRIBUTE_CATEGORY;

Line 546: l_picklist_line_rec.QUANTITY_PICKED := nvl(p_QUANTITY_PICKED, fnd_api.g_miss_num);

542: l_picklist_line_rec.LINE_ID := nvl(p_LINE_ID, fnd_api.g_miss_num);
543: l_picklist_line_rec.INVENTORY_ITEM_ID := nvl(p_INVENTORY_ITEM_ID, fnd_api.g_miss_num);
544: l_picklist_line_rec.UOM_CODE := nvl(p_UOM_CODE, fnd_api.g_miss_char);
545: l_picklist_line_rec.REVISION := p_REVISION;
546: l_picklist_line_rec.QUANTITY_PICKED := nvl(p_QUANTITY_PICKED, fnd_api.g_miss_num);
547: l_picklist_line_rec.TRANSACTION_TEMP_ID := nvl(p_TRANSACTION_TEMP_ID, fnd_api.g_miss_num);
548: l_picklist_line_rec.ATTRIBUTE_CATEGORY := p_ATTRIBUTE_CATEGORY;
549: l_picklist_line_rec.ATTRIBUTE1 := p_ATTRIBUTE1;
550: l_picklist_line_rec.ATTRIBUTE2 := p_ATTRIBUTE2;

Line 547: l_picklist_line_rec.TRANSACTION_TEMP_ID := nvl(p_TRANSACTION_TEMP_ID, fnd_api.g_miss_num);

543: l_picklist_line_rec.INVENTORY_ITEM_ID := nvl(p_INVENTORY_ITEM_ID, fnd_api.g_miss_num);
544: l_picklist_line_rec.UOM_CODE := nvl(p_UOM_CODE, fnd_api.g_miss_char);
545: l_picklist_line_rec.REVISION := p_REVISION;
546: l_picklist_line_rec.QUANTITY_PICKED := nvl(p_QUANTITY_PICKED, fnd_api.g_miss_num);
547: l_picklist_line_rec.TRANSACTION_TEMP_ID := nvl(p_TRANSACTION_TEMP_ID, fnd_api.g_miss_num);
548: l_picklist_line_rec.ATTRIBUTE_CATEGORY := p_ATTRIBUTE_CATEGORY;
549: l_picklist_line_rec.ATTRIBUTE1 := p_ATTRIBUTE1;
550: l_picklist_line_rec.ATTRIBUTE2 := p_ATTRIBUTE2;
551: l_picklist_line_rec.ATTRIBUTE3 := p_ATTRIBUTE3;

Line 607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

603: );
604:
605: END IF;
606:
607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
608: RAISE FND_API.G_EXC_ERROR;
609: END IF;
610:
611: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 608: RAISE FND_API.G_EXC_ERROR;

604:
605: END IF;
606:
607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
608: RAISE FND_API.G_EXC_ERROR;
609: END IF;
610:
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612: px_picklist_line_id := l_picklist_line_id;

Line 611: x_return_status := FND_API.G_RET_STS_SUCCESS;

607: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
608: RAISE FND_API.G_EXC_ERROR;
609: END IF;
610:
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612: px_picklist_line_id := l_picklist_line_id;
613: IF fnd_api.to_boolean(p_commit) THEN
614: commit work;
615: END IF;

Line 613: IF fnd_api.to_boolean(p_commit) THEN

609: END IF;
610:
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612: px_picklist_line_id := l_picklist_line_id;
613: IF fnd_api.to_boolean(p_commit) THEN
614: commit work;
615: END IF;
616:
617:

Line 621: x_return_status := FND_API.G_RET_STS_ERROR;

617:
618: EXCEPTION
619: WHEN EXCP_USER_DEFINED THEN
620: Rollback to Validate_And_Write_PUB;
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: fnd_msg_pub.count_and_get
623: ( p_count => x_msg_count
624: , p_data => x_msg_data);
625: WHEN FND_API.G_EXC_ERROR THEN

Line 625: WHEN FND_API.G_EXC_ERROR THEN

621: x_return_status := FND_API.G_RET_STS_ERROR;
622: fnd_msg_pub.count_and_get
623: ( p_count => x_msg_count
624: , p_data => x_msg_data);
625: WHEN FND_API.G_EXC_ERROR THEN
626: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
627: P_API_NAME => L_API_NAME
628: ,P_PKG_NAME => G_PKG_NAME
629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

630: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
631: ,X_MSG_COUNT => X_MSG_COUNT
632: ,X_MSG_DATA => X_MSG_DATA
633: ,X_RETURN_STATUS => X_RETURN_STATUS);
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
636: P_API_NAME => L_API_NAME
637: ,P_PKG_NAME => G_PKG_NAME
638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 652: x_return_status := fnd_api.g_ret_sts_error;

648: fnd_msg_pub.add;
649: fnd_msg_pub.count_and_get
650: ( p_count => x_msg_count
651: , p_data => x_msg_data);
652: x_return_status := fnd_api.g_ret_sts_error;
653:
654: END Validate_And_Write;
655:
656: END CSP_PC_FORM_PICKLINES;