DBA Data[Home] [Help]

APPS.INV_SHORTCHECKPROCESSTRX_PVT dependencies on FND_API

Line 98: p_init_msg_list => FND_API.G_TRUE,

94: FETCH L_LastTrx_csr INTO L_LastTrx_rec;
95: -- Call the shortage check procedure
96: INV_ShortCheckExec_PVT.ExecCheck (
97: p_api_version => 1.0,
98: p_init_msg_list => FND_API.G_TRUE,
99: p_commit => FND_API.G_TRUE,
100: x_return_status => L_return_status,
101: x_msg_count => L_msg_count,
102: x_msg_data => L_msg_data,

Line 99: p_commit => FND_API.G_TRUE,

95: -- Call the shortage check procedure
96: INV_ShortCheckExec_PVT.ExecCheck (
97: p_api_version => 1.0,
98: p_init_msg_list => FND_API.G_TRUE,
99: p_commit => FND_API.G_TRUE,
100: x_return_status => L_return_status,
101: x_msg_count => L_msg_count,
102: x_msg_data => L_msg_data,
103: p_sum_detail_flag => 1,

Line 114: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

110: );
111: --
112: -- If an error has occured set shortage process code to error,
113: -- write error msg data to ERRBUF and to log file and set RETCODE
114: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
115: UpdateTrx ( L_SelectTrx_rec.organization_id,
116: L_SelectTrx_rec.inventory_item_id,
117: 3 );
118: ERRBUF := L_msg_data;

Line 124: IF L_check_result = FND_API.G_TRUE THEN

120: RETCODE := 1;
121: --
122: -- Else call send notifications proc if shortage has been detected
123: ELSE
124: IF L_check_result = FND_API.G_TRUE THEN
125: INV_ShortCheckExec_PVT.SendNotifications (
126: p_api_version => 1.0,
127: p_init_msg_list => FND_API.G_TRUE,
128: p_commit => FND_API.G_TRUE,

Line 127: p_init_msg_list => FND_API.G_TRUE,

123: ELSE
124: IF L_check_result = FND_API.G_TRUE THEN
125: INV_ShortCheckExec_PVT.SendNotifications (
126: p_api_version => 1.0,
127: p_init_msg_list => FND_API.G_TRUE,
128: p_commit => FND_API.G_TRUE,
129: x_return_status => L_return_status,
130: x_msg_count => L_msg_count,
131: x_msg_data => L_msg_data,

Line 128: p_commit => FND_API.G_TRUE,

124: IF L_check_result = FND_API.G_TRUE THEN
125: INV_ShortCheckExec_PVT.SendNotifications (
126: p_api_version => 1.0,
127: p_init_msg_list => FND_API.G_TRUE,
128: p_commit => FND_API.G_TRUE,
129: x_return_status => L_return_status,
130: x_msg_count => L_msg_count,
131: x_msg_data => L_msg_data,
132: p_organization_id => L_SelectTrx_rec.organization_id,

Line 139: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

135: p_notification_type => 'R'
136: );
137: -- If an error has occured set shortage process code to error,
138: -- write error msg data to ERRBUF and to log file and set RETCODE
139: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
140: UpdateTrx ( L_SelectTrx_rec.organization_id,
141: L_SelectTrx_rec.inventory_item_id,
142: 3 );
143: ERRBUF := L_msg_data;

Line 164: p_init_msg_list => FND_API.G_TRUE,

160: --
161: -- Purge the rows from the temp table (if there are any)
162: INV_ShortCheckExec_PVT.PurgeTempTable (
163: p_api_version => 1.0,
164: p_init_msg_list => FND_API.G_TRUE,
165: p_commit => FND_API.G_TRUE,
166: x_return_status => L_return_status,
167: x_msg_count => L_msg_count,
168: x_msg_data => L_msg_data,

Line 165: p_commit => FND_API.G_TRUE,

161: -- Purge the rows from the temp table (if there are any)
162: INV_ShortCheckExec_PVT.PurgeTempTable (
163: p_api_version => 1.0,
164: p_init_msg_list => FND_API.G_TRUE,
165: p_commit => FND_API.G_TRUE,
166: x_return_status => L_return_status,
167: x_msg_count => L_msg_count,
168: x_msg_data => L_msg_data,
169: p_seq_num => L_seq_num

Line 189: p_init_msg_list => FND_API.G_TRUE,

185: --
186: -- and purge the rows from the temp table (if there are any)
187: INV_ShortCheckExec_PVT.PurgeTempTable (
188: p_api_version => 1.0,
189: p_init_msg_list => FND_API.G_TRUE,
190: p_commit => FND_API.G_TRUE,
191: x_return_status => L_return_status,
192: x_msg_count => L_msg_count,
193: x_msg_data => L_msg_data,

Line 190: p_commit => FND_API.G_TRUE,

186: -- and purge the rows from the temp table (if there are any)
187: INV_ShortCheckExec_PVT.PurgeTempTable (
188: p_api_version => 1.0,
189: p_init_msg_list => FND_API.G_TRUE,
190: p_commit => FND_API.G_TRUE,
191: x_return_status => L_return_status,
192: x_msg_count => L_msg_count,
193: x_msg_data => L_msg_data,
194: p_seq_num => L_seq_num