14: --
15: -- Input Parameters:
16: -- p_api_version
17: -- API version number (current version is 1.0)
18: -- p_init_msg_list (optional, default FND_API.G_FALSE)
19: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
20: -- if set to FND_API.G_TRUE
21: -- initialize error message list
22: -- if set to FND_API.G_FALSE - not initialize error -- message list
15: -- Input Parameters:
16: -- p_api_version
17: -- API version number (current version is 1.0)
18: -- p_init_msg_list (optional, default FND_API.G_FALSE)
19: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
20: -- if set to FND_API.G_TRUE
21: -- initialize error message list
22: -- if set to FND_API.G_FALSE - not initialize error -- message list
23: -- p_commit (optional, default FND_API.G_FALSE)
16: -- p_api_version
17: -- API version number (current version is 1.0)
18: -- p_init_msg_list (optional, default FND_API.G_FALSE)
19: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
20: -- if set to FND_API.G_TRUE
21: -- initialize error message list
22: -- if set to FND_API.G_FALSE - not initialize error -- message list
23: -- p_commit (optional, default FND_API.G_FALSE)
24: -- whether or not to commit the changes to database
18: -- p_init_msg_list (optional, default FND_API.G_FALSE)
19: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
20: -- if set to FND_API.G_TRUE
21: -- initialize error message list
22: -- if set to FND_API.G_FALSE - not initialize error -- message list
23: -- p_commit (optional, default FND_API.G_FALSE)
24: -- whether or not to commit the changes to database
25: -- p_organization_id Organization Id - Required Value
26: -- p_mmtt_id Transaction Temp ID from MMTT - Required Value
19: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
20: -- if set to FND_API.G_TRUE
21: -- initialize error message list
22: -- if set to FND_API.G_FALSE - not initialize error -- message list
23: -- p_commit (optional, default FND_API.G_FALSE)
24: -- whether or not to commit the changes to database
25: -- p_organization_id Organization Id - Required Value
26: -- p_mmtt_id Transaction Temp ID from MMTT - Required Value
27: -- p_inventory_item_id Inventory Item ID - Required Value since
39: --
40: -- Output Parameters
41: -- x_return_status
42: -- if the Generate_LPN API succeeds, the value is
43: -- fnd_api.g_ret_sts_success;
44: -- if there is an expected error, the value is
45: -- fnd_api.g_ret_sts_error;
46: -- if there is an unexpected error, the value is
47: -- fnd_api.g_ret_sts_unexp_error;
41: -- x_return_status
42: -- if the Generate_LPN API succeeds, the value is
43: -- fnd_api.g_ret_sts_success;
44: -- if there is an expected error, the value is
45: -- fnd_api.g_ret_sts_error;
46: -- if there is an unexpected error, the value is
47: -- fnd_api.g_ret_sts_unexp_error;
48: -- x_msg_count
49: -- if there is one or more errors, the number of error messages
43: -- fnd_api.g_ret_sts_success;
44: -- if there is an expected error, the value is
45: -- fnd_api.g_ret_sts_error;
46: -- if there is an unexpected error, the value is
47: -- fnd_api.g_ret_sts_unexp_error;
48: -- x_msg_count
49: -- if there is one or more errors, the number of error messages
50: -- in the buffer
51: -- x_msg_data
49: -- if there is one or more errors, the number of error messages
50: -- in the buffer
51: -- x_msg_data
52: -- if there is one and only one error, the error message
53: -- (See fnd_api package for more details about the above output parameters)
54: PROCEDURE Inadequate_Qty
55: (
56: p_api_version_number IN NUMBER
57: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
53: -- (See fnd_api package for more details about the above output parameters)
54: PROCEDURE Inadequate_Qty
55: (
56: p_api_version_number IN NUMBER
57: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
58: , p_commit IN VARCHAR2 := FND_API.G_FALSE
59: , x_return_status OUT NOCOPY VARCHAR2
60: , x_msg_count OUT NOCOPY NUMBER
61: , x_msg_data OUT NOCOPY VARCHAR2
54: PROCEDURE Inadequate_Qty
55: (
56: p_api_version_number IN NUMBER
57: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
58: , p_commit IN VARCHAR2 := FND_API.G_FALSE
59: , x_return_status OUT NOCOPY VARCHAR2
60: , x_msg_count OUT NOCOPY NUMBER
61: , x_msg_data OUT NOCOPY VARCHAR2
62: , p_organization_id IN NUMBER
80: -- for the user id passed in
81: -- Input Parameters:
82: -- p_api_version
83: -- API version number (current version is 1.0)
84: -- p_init_msg_list (optional, default FND_API.G_FALSE)
85: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
86: -- if set to FND_API.G_TRUE
87: -- initialize error message list
88: -- if set to FND_API.G_FALSE - not initialize error -- message list
81: -- Input Parameters:
82: -- p_api_version
83: -- API version number (current version is 1.0)
84: -- p_init_msg_list (optional, default FND_API.G_FALSE)
85: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
86: -- if set to FND_API.G_TRUE
87: -- initialize error message list
88: -- if set to FND_API.G_FALSE - not initialize error -- message list
89: -- p_commit (optional, default FND_API.G_FALSE)
82: -- p_api_version
83: -- API version number (current version is 1.0)
84: -- p_init_msg_list (optional, default FND_API.G_FALSE)
85: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
86: -- if set to FND_API.G_TRUE
87: -- initialize error message list
88: -- if set to FND_API.G_FALSE - not initialize error -- message list
89: -- p_commit (optional, default FND_API.G_FALSE)
90: -- whether or not to commit the changes to database
84: -- p_init_msg_list (optional, default FND_API.G_FALSE)
85: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
86: -- if set to FND_API.G_TRUE
87: -- initialize error message list
88: -- if set to FND_API.G_FALSE - not initialize error -- message list
89: -- p_commit (optional, default FND_API.G_FALSE)
90: -- whether or not to commit the changes to database
91: -- p_organization_id Organization Id - Required Value
92: -- p_mmtt_id Transaction Temp ID from MMTT - Required Value
85: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
86: -- if set to FND_API.G_TRUE
87: -- initialize error message list
88: -- if set to FND_API.G_FALSE - not initialize error -- message list
89: -- p_commit (optional, default FND_API.G_FALSE)
90: -- whether or not to commit the changes to database
91: -- p_organization_id Organization Id - Required Value
92: -- p_mmtt_id Transaction Temp ID from MMTT - Required Value
93: -- p_subinventory_code Subinventory Code - Required Value
98: -- p_qty_picked Qty already picked - Required value
99: -- Output Parameters
100: -- x_return_status
101: -- if the Generate_LPN API succeeds, the value is
102: -- fnd_api.g_ret_sts_success;
103: -- if there is an expected error, the value is
104: -- fnd_api.g_ret_sts_error;
105: -- if there is an unexpected error, the value is
106: -- fnd_api.g_ret_sts_unexp_error;
100: -- x_return_status
101: -- if the Generate_LPN API succeeds, the value is
102: -- fnd_api.g_ret_sts_success;
103: -- if there is an expected error, the value is
104: -- fnd_api.g_ret_sts_error;
105: -- if there is an unexpected error, the value is
106: -- fnd_api.g_ret_sts_unexp_error;
107: -- x_msg_count
108: -- if there is one or more errors, the number of error messages
102: -- fnd_api.g_ret_sts_success;
103: -- if there is an expected error, the value is
104: -- fnd_api.g_ret_sts_error;
105: -- if there is an unexpected error, the value is
106: -- fnd_api.g_ret_sts_unexp_error;
107: -- x_msg_count
108: -- if there is one or more errors, the number of error messages
109: -- in the buffer
110: -- x_msg_data
108: -- if there is one or more errors, the number of error messages
109: -- in the buffer
110: -- x_msg_data
111: -- if there is one and only one error, the error message
112: -- (See fnd_api package for more details about the above output parameters)
113:
114: PROCEDURE Suggest_alternate_location
115: (
116: p_api_version_number IN NUMBER
113:
114: PROCEDURE Suggest_alternate_location
115: (
116: p_api_version_number IN NUMBER
117: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
118: , p_commit IN VARCHAR2 := FND_API.G_FALSE
119: , x_return_status OUT NOCOPY VARCHAR2
120: , x_msg_count OUT NOCOPY NUMBER
121: , x_msg_data OUT NOCOPY VARCHAR2
114: PROCEDURE Suggest_alternate_location
115: (
116: p_api_version_number IN NUMBER
117: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
118: , p_commit IN VARCHAR2 := FND_API.G_FALSE
119: , x_return_status OUT NOCOPY VARCHAR2
120: , x_msg_count OUT NOCOPY NUMBER
121: , x_msg_data OUT NOCOPY VARCHAR2
122: , p_organization_id IN NUMBER
138: -- being passed in
139: -- Input Parameters:
140: -- p_api_version
141: -- API version number (current version is 1.0)
142: -- p_init_msg_list (optional, default FND_API.G_FALSE)
143: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
144: -- if set to FND_API.G_TRUE
145: -- initialize error message list
146: -- if set to FND_API.G_FALSE - not initialize error -- message list
139: -- Input Parameters:
140: -- p_api_version
141: -- API version number (current version is 1.0)
142: -- p_init_msg_list (optional, default FND_API.G_FALSE)
143: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
144: -- if set to FND_API.G_TRUE
145: -- initialize error message list
146: -- if set to FND_API.G_FALSE - not initialize error -- message list
147: -- p_commit (optional, default FND_API.G_FALSE)
140: -- p_api_version
141: -- API version number (current version is 1.0)
142: -- p_init_msg_list (optional, default FND_API.G_FALSE)
143: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
144: -- if set to FND_API.G_TRUE
145: -- initialize error message list
146: -- if set to FND_API.G_FALSE - not initialize error -- message list
147: -- p_commit (optional, default FND_API.G_FALSE)
148: -- whether or not to commit the changes to database
142: -- p_init_msg_list (optional, default FND_API.G_FALSE)
143: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
144: -- if set to FND_API.G_TRUE
145: -- initialize error message list
146: -- if set to FND_API.G_FALSE - not initialize error -- message list
147: -- p_commit (optional, default FND_API.G_FALSE)
148: -- whether or not to commit the changes to database
149: -- p_organization_id Organization Id - Required Value
150: -- p_mmtt_id Transaction Temp ID from MMTT - Required Value
143: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
144: -- if set to FND_API.G_TRUE
145: -- initialize error message list
146: -- if set to FND_API.G_FALSE - not initialize error -- message list
147: -- p_commit (optional, default FND_API.G_FALSE)
148: -- whether or not to commit the changes to database
149: -- p_organization_id Organization Id - Required Value
150: -- p_mmtt_id Transaction Temp ID from MMTT - Required Value
151: -- p_reason_id - Required Value Reason_ID from MTL_Transaction_reasons
159: -- lookup WMS_Discrepancy_types
160: -- Output Parameters
161: -- x_return_status
162: -- if the Generate_LPN API succeeds, the value is
163: -- fnd_api.g_ret_sts_success;
164: -- if there is an expected error, the value is
165: -- fnd_api.g_ret_sts_error;
166: -- if there is an unexpected error, the value is
167: -- fnd_api.g_ret_sts_unexp_error;
161: -- x_return_status
162: -- if the Generate_LPN API succeeds, the value is
163: -- fnd_api.g_ret_sts_success;
164: -- if there is an expected error, the value is
165: -- fnd_api.g_ret_sts_error;
166: -- if there is an unexpected error, the value is
167: -- fnd_api.g_ret_sts_unexp_error;
168: -- x_msg_count
169: -- if there is one or more errors, the number of error messages
163: -- fnd_api.g_ret_sts_success;
164: -- if there is an expected error, the value is
165: -- fnd_api.g_ret_sts_error;
166: -- if there is an unexpected error, the value is
167: -- fnd_api.g_ret_sts_unexp_error;
168: -- x_msg_count
169: -- if there is one or more errors, the number of error messages
170: -- in the buffer
171: -- x_msg_data
169: -- if there is one or more errors, the number of error messages
170: -- in the buffer
171: -- x_msg_data
172: -- if there is one and only one error, the error message
173: -- (See fnd_api package for more details about the above output parameters)
174:
175:
176: PROCEDURE Log_exception
177: (
175:
176: PROCEDURE Log_exception
177: (
178: p_api_version_number IN NUMBER
179: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
180: , p_commit IN VARCHAR2 := FND_API.G_FALSE
181: , x_return_status OUT NOCOPY VARCHAR2
182: , x_msg_count OUT NOCOPY NUMBER
183: , x_msg_data OUT NOCOPY VARCHAR2
176: PROCEDURE Log_exception
177: (
178: p_api_version_number IN NUMBER
179: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
180: , p_commit IN VARCHAR2 := FND_API.G_FALSE
181: , x_return_status OUT NOCOPY VARCHAR2
182: , x_msg_count OUT NOCOPY NUMBER
183: , x_msg_data OUT NOCOPY VARCHAR2
184: , p_organization_id IN NUMBER