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

Line 128: l_column VARCHAR2(30) :=fnd_api.g_miss_char;

124: )
125: IS
126: l_order_by_cl VARCHAR2(1000) := NULL;
127: l_util_order_by_tbl util_order_by_tbl_type;
128: l_column VARCHAR2(30) :=fnd_api.g_miss_char;
129: BEGIN
130:
131: IF p_order_by_rec.transaction_date = 'Y' THEN
132: l_column:=' transaction_date';

Line 137: IF l_column <> fnd_api.g_miss_char THEN

133: ELSIF p_order_by_rec.transaction_type_id = 'Y' THEN
134: l_column:=' transaction_type_id';
135: END IF;
136:
137: IF l_column <> fnd_api.g_miss_char THEN
138: x_order_by_cl := ' order by' || l_column;
139: ELSE
140: x_order_by_cl :=l_order_by_cl;
141: END IF;

Line 152: IF( (p_txnfind_rec.transaction_id IS NOT NULL) AND (p_txnfind_rec.transaction_id <> fnd_api.g_miss_num) )

148: p_cur_get_transactions IN NUMBER
149: )
150: IS
151: BEGIN
152: IF( (p_txnfind_rec.transaction_id IS NOT NULL) AND (p_txnfind_rec.transaction_id <> fnd_api.g_miss_num) )
153: THEN
154: dbms_sql.bind_variable(p_cur_get_transactions, 'transaction_id', p_txnfind_rec.transaction_id);
155: END IF;
156:

Line 157: IF( (p_txnfind_rec.transaction_type_id IS NOT NULL) AND (p_txnfind_rec.transaction_type_id <> fnd_api.g_miss_num) )

153: THEN
154: dbms_sql.bind_variable(p_cur_get_transactions, 'transaction_id', p_txnfind_rec.transaction_id);
155: END IF;
156:
157: IF( (p_txnfind_rec.transaction_type_id IS NOT NULL) AND (p_txnfind_rec.transaction_type_id <> fnd_api.g_miss_num) )
158: THEN
159: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_type_id', p_txnfind_rec.transaction_type_id);
160: END IF;
161:

Line 162: IF( (p_txnfind_rec.txn_sub_type_id IS NOT NULL) AND (p_txnfind_rec.txn_sub_type_id <> fnd_api.g_miss_num) )

158: THEN
159: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_type_id', p_txnfind_rec.transaction_type_id);
160: END IF;
161:
162: IF( (p_txnfind_rec.txn_sub_type_id IS NOT NULL) AND (p_txnfind_rec.txn_sub_type_id <> fnd_api.g_miss_num) )
163: THEN
164: dbms_sql.bind_variable(p_cur_get_transactions, ':txn_sub_type_id', p_txnfind_rec.txn_sub_type_id);
165: END IF;
166:

Line 167: IF( (p_txnfind_rec.source_group_ref_id IS NOT NULL) AND (p_txnfind_rec.source_group_ref_id<> fnd_api.g_miss_num) )

163: THEN
164: dbms_sql.bind_variable(p_cur_get_transactions, ':txn_sub_type_id', p_txnfind_rec.txn_sub_type_id);
165: END IF;
166:
167: IF( (p_txnfind_rec.source_group_ref_id IS NOT NULL) AND (p_txnfind_rec.source_group_ref_id<> fnd_api.g_miss_num) )
168: THEN
169: dbms_sql.bind_variable(p_cur_get_transactions, ':source_group_ref_id', p_txnfind_rec.source_group_ref_id);
170: END IF;
171:

Line 172: IF( (p_txnfind_rec.source_group_ref IS NOT NULL) AND (p_txnfind_rec.source_group_ref <> fnd_api.g_miss_char) )

168: THEN
169: dbms_sql.bind_variable(p_cur_get_transactions, ':source_group_ref_id', p_txnfind_rec.source_group_ref_id);
170: END IF;
171:
172: IF( (p_txnfind_rec.source_group_ref IS NOT NULL) AND (p_txnfind_rec.source_group_ref <> fnd_api.g_miss_char) )
173: THEN
174: dbms_sql.bind_variable(p_cur_get_transactions, ':source_group_ref', p_txnfind_rec.source_group_ref);
175: END IF;
176:

Line 177: IF( (p_txnfind_rec.source_header_ref_id IS NOT NULL) AND (p_txnfind_rec.source_header_ref_id <> fnd_api.g_miss_num) )

173: THEN
174: dbms_sql.bind_variable(p_cur_get_transactions, ':source_group_ref', p_txnfind_rec.source_group_ref);
175: END IF;
176:
177: IF( (p_txnfind_rec.source_header_ref_id IS NOT NULL) AND (p_txnfind_rec.source_header_ref_id <> fnd_api.g_miss_num) )
178: THEN
179: dbms_sql.bind_variable(p_cur_get_transactions, ':source_header_ref_id', p_txnfind_rec.source_header_ref_id);
180: END IF;
181:

Line 182: IF( (p_txnfind_rec.source_header_ref IS NOT NULL) AND (p_txnfind_rec.source_header_ref <> fnd_api.g_miss_char) )

178: THEN
179: dbms_sql.bind_variable(p_cur_get_transactions, ':source_header_ref_id', p_txnfind_rec.source_header_ref_id);
180: END IF;
181:
182: IF( (p_txnfind_rec.source_header_ref IS NOT NULL) AND (p_txnfind_rec.source_header_ref <> fnd_api.g_miss_char) )
183: THEN
184: dbms_sql.bind_variable(p_cur_get_transactions, ':source_header_ref', p_txnfind_rec.source_header_ref);
185: END IF;
186:

Line 187: IF( (p_txnfind_rec.source_line_ref_id IS NOT NULL) AND (p_txnfind_rec.source_line_ref_id <> fnd_api.g_miss_num) )

183: THEN
184: dbms_sql.bind_variable(p_cur_get_transactions, ':source_header_ref', p_txnfind_rec.source_header_ref);
185: END IF;
186:
187: IF( (p_txnfind_rec.source_line_ref_id IS NOT NULL) AND (p_txnfind_rec.source_line_ref_id <> fnd_api.g_miss_num) )
188: THEN
189: dbms_sql.bind_variable(p_cur_get_transactions, ':source_line_ref_id', p_txnfind_rec.source_line_ref_id);
190: END IF;
191:

Line 192: IF( (p_txnfind_rec.source_line_ref IS NOT NULL) AND (p_txnfind_rec.source_line_ref <> fnd_api.g_miss_char) )

188: THEN
189: dbms_sql.bind_variable(p_cur_get_transactions, ':source_line_ref_id', p_txnfind_rec.source_line_ref_id);
190: END IF;
191:
192: IF( (p_txnfind_rec.source_line_ref IS NOT NULL) AND (p_txnfind_rec.source_line_ref <> fnd_api.g_miss_char) )
193: THEN
194: dbms_sql.bind_variable(p_cur_get_transactions, ':source_line_ref', rtrim(ltrim(p_txnfind_rec.source_line_ref)));
195: END IF;
196:

Line 197: IF( (p_txnfind_rec.source_transaction_date IS NOT NULL) AND (p_txnfind_rec.source_transaction_date <> fnd_api.g_miss_date) )

193: THEN
194: dbms_sql.bind_variable(p_cur_get_transactions, ':source_line_ref', rtrim(ltrim(p_txnfind_rec.source_line_ref)));
195: END IF;
196:
197: IF( (p_txnfind_rec.source_transaction_date IS NOT NULL) AND (p_txnfind_rec.source_transaction_date <> fnd_api.g_miss_date) )
198: THEN
199: dbms_sql.bind_variable(p_cur_get_transactions, ':source_txn_date', p_txnfind_rec.source_transaction_date);
200: END IF;
201:

Line 202: IF( (p_txnfind_rec.inv_material_transaction_id IS NOT NULL) AND (p_txnfind_rec.inv_material_transaction_id <> fnd_api.g_miss_num) )

198: THEN
199: dbms_sql.bind_variable(p_cur_get_transactions, ':source_txn_date', p_txnfind_rec.source_transaction_date);
200: END IF;
201:
202: IF( (p_txnfind_rec.inv_material_transaction_id IS NOT NULL) AND (p_txnfind_rec.inv_material_transaction_id <> fnd_api.g_miss_num) )
203: THEN
204: dbms_sql.bind_variable(p_cur_get_transactions, ':inv_material_transaction_id', p_txnfind_rec.inv_material_transaction_id);
205: END IF;
206:

Line 207: IF( (p_txnfind_rec.message_id IS NOT NULL) AND (p_txnfind_rec.message_id <> fnd_api.g_miss_num) )

203: THEN
204: dbms_sql.bind_variable(p_cur_get_transactions, ':inv_material_transaction_id', p_txnfind_rec.inv_material_transaction_id);
205: END IF;
206:
207: IF( (p_txnfind_rec.message_id IS NOT NULL) AND (p_txnfind_rec.message_id <> fnd_api.g_miss_num) )
208: THEN
209: dbms_sql.bind_variable(p_cur_get_transactions, ':message_id', p_txnfind_rec.message_id);
210: END IF;
211:

Line 212: IF( (p_txnfind_rec.instance_id IS NOT NULL) AND (p_txnfind_rec.instance_id <> fnd_api.g_miss_num) )

208: THEN
209: dbms_sql.bind_variable(p_cur_get_transactions, ':message_id', p_txnfind_rec.message_id);
210: END IF;
211:
212: IF( (p_txnfind_rec.instance_id IS NOT NULL) AND (p_txnfind_rec.instance_id <> fnd_api.g_miss_num) )
213: THEN
214: dbms_sql.bind_variable(p_cur_get_transactions, ':instance_id', p_txnfind_rec.instance_id);
215: END IF;
216:

Line 218: IF( (p_txnfind_rec.transaction_start_date IS NOT NULL) AND (p_txnfind_rec.transaction_start_date <> fnd_api.g_miss_date) )

214: dbms_sql.bind_variable(p_cur_get_transactions, ':instance_id', p_txnfind_rec.instance_id);
215: END IF;
216:
217:
218: IF( (p_txnfind_rec.transaction_start_date IS NOT NULL) AND (p_txnfind_rec.transaction_start_date <> fnd_api.g_miss_date) )
219: THEN
220: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_start_date', p_txnfind_rec.transaction_start_date);
221: END IF;
222:

Line 224: IF( (p_txnfind_rec.transaction_end_date IS NOT NULL) AND (p_txnfind_rec.transaction_end_date <> fnd_api.g_miss_date) )

220: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_start_date', p_txnfind_rec.transaction_start_date);
221: END IF;
222:
223:
224: IF( (p_txnfind_rec.transaction_end_date IS NOT NULL) AND (p_txnfind_rec.transaction_end_date <> fnd_api.g_miss_date) )
225: THEN
226: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_end_date', p_txnfind_rec.transaction_end_date);
227: END IF;
228:

Line 229: IF( (p_txnfind_rec.transaction_status_code IS NOT NULL) AND (p_txnfind_rec.transaction_status_code <> fnd_api.g_miss_char) )

225: THEN
226: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_end_date', p_txnfind_rec.transaction_end_date);
227: END IF;
228:
229: IF( (p_txnfind_rec.transaction_status_code IS NOT NULL) AND (p_txnfind_rec.transaction_status_code <> fnd_api.g_miss_char) )
230: THEN
231: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_status_code', p_txnfind_rec.transaction_status_code);
232: END IF;
233:

Line 248: IF ( (p_txnfind_rec.instance_id IS NOT NULL) AND (p_txnfind_rec.instance_id <> fnd_api.g_miss_num) ) THEN

244: )
245: IS
246: l_table_name VARCHAR2(30);
247: BEGIN
248: IF ( (p_txnfind_rec.instance_id IS NOT NULL) AND (p_txnfind_rec.instance_id <> fnd_api.g_miss_num) ) THEN
249: l_table_name:='csi_inst_trx_details_v';
250: ELSE
251: l_table_name:='csi_transactions';
252: END IF;

Line 291: IF( (p_txnfind_rec.transaction_id IS NOT NULL) AND (p_txnfind_rec.transaction_id <> fnd_api.g_miss_num) )

287:
288: BEGIN
289:
290:
291: IF( (p_txnfind_rec.transaction_id IS NOT NULL) AND (p_txnfind_rec.transaction_id <> fnd_api.g_miss_num) )
292: THEN
293:
294: IF(x_transactions_where IS NULL) THEN
295: x_transactions_where := ' WHERE ';

Line 302: IF( (p_txnfind_rec.transaction_type_id IS NOT NULL) AND (p_txnfind_rec.transaction_type_id <> fnd_api.g_miss_num) )

298: END IF;
299: x_transactions_where := x_transactions_where || 'transaction_id = :transaction_id';
300: END IF;
301:
302: IF( (p_txnfind_rec.transaction_type_id IS NOT NULL) AND (p_txnfind_rec.transaction_type_id <> fnd_api.g_miss_num) )
303: THEN
304:
305: IF(x_transactions_where IS NULL) THEN
306: x_transactions_where := ' WHERE ';

Line 313: IF( (p_txnfind_rec.txn_sub_type_id IS NOT NULL) AND (p_txnfind_rec.txn_sub_type_id <> fnd_api.g_miss_num) )

309: END IF;
310: x_transactions_where := x_transactions_where || 'transaction_type_id = :transaction_type_id';
311: END IF;
312:
313: IF( (p_txnfind_rec.txn_sub_type_id IS NOT NULL) AND (p_txnfind_rec.txn_sub_type_id <> fnd_api.g_miss_num) )
314: THEN
315:
316: IF(x_transactions_where IS NULL) THEN
317: x_transactions_where := ' WHERE ';

Line 324: IF( (p_txnfind_rec.source_group_ref_id IS NOT NULL) AND (p_txnfind_rec.source_group_ref_id <> fnd_api.g_miss_num) )

320: END IF;
321: x_transactions_where := x_transactions_where || 'txn_sub_type_id = :txn_sub_type_id';
322: END IF;
323:
324: IF( (p_txnfind_rec.source_group_ref_id IS NOT NULL) AND (p_txnfind_rec.source_group_ref_id <> fnd_api.g_miss_num) )
325: THEN
326:
327:
328: IF(x_transactions_where IS NULL) THEN

Line 336: IF( (p_txnfind_rec.source_group_ref IS NOT NULL) AND (p_txnfind_rec.source_group_ref <> fnd_api.g_miss_char) )

332: END IF;
333: x_transactions_where := x_transactions_where || 'source_group_ref_id = :source_group_ref_id';
334: END IF;
335:
336: IF( (p_txnfind_rec.source_group_ref IS NOT NULL) AND (p_txnfind_rec.source_group_ref <> fnd_api.g_miss_char) )
337: THEN
338:
339: i:=0;
340: -- check if item value contains '%' wildcard

Line 376: IF( (p_txnfind_rec.source_header_ref_id IS NOT NULL) AND (p_txnfind_rec.source_header_ref_id <> fnd_api.g_miss_num) )

372: x_transactions_where := x_transactions_where || 'source_group_ref ' || l_operator || ' :source_group_ref';
373: END IF;
374:
375:
376: IF( (p_txnfind_rec.source_header_ref_id IS NOT NULL) AND (p_txnfind_rec.source_header_ref_id <> fnd_api.g_miss_num) )
377: THEN
378:
379:
380: IF(x_transactions_where IS NULL) THEN

Line 388: IF( (p_txnfind_rec.source_header_ref IS NOT NULL) AND (p_txnfind_rec.source_header_ref <> fnd_api.g_miss_char) )

384: END IF;
385: x_transactions_where := x_transactions_where || 'source_header_ref_id = :source_header_ref_id';
386: END IF;
387:
388: IF( (p_txnfind_rec.source_header_ref IS NOT NULL) AND (p_txnfind_rec.source_header_ref <> fnd_api.g_miss_char) )
389: THEN
390: i:=0;
391: -- check if item value contains '%' wildcard
392: OPEN c_chk_str1(p_txnfind_rec.source_header_ref);

Line 424: IF( (p_txnfind_rec.source_line_ref_id IS NOT NULL) AND (p_txnfind_rec.source_line_ref_id <> fnd_api.g_miss_num) )

420: END IF;
421:
422:
423:
424: IF( (p_txnfind_rec.source_line_ref_id IS NOT NULL) AND (p_txnfind_rec.source_line_ref_id <> fnd_api.g_miss_num) )
425: THEN
426:
427: IF(x_transactions_where IS NULL) THEN
428: x_transactions_where := ' WHERE ';

Line 435: IF( (p_txnfind_rec.source_line_ref IS NOT NULL) AND (p_txnfind_rec.source_line_ref <> fnd_api.g_miss_char) )

431: END IF;
432: x_transactions_where := x_transactions_where || 'source_line_ref_id = :source_line_ref_id';
433: END IF;
434:
435: IF( (p_txnfind_rec.source_line_ref IS NOT NULL) AND (p_txnfind_rec.source_line_ref <> fnd_api.g_miss_char) )
436: THEN
437: i:=0;
438: -- check if item value contains '%' wildcard
439: OPEN c_chk_str1(p_txnfind_rec.source_line_ref);

Line 469: IF( (p_txnfind_rec.source_transaction_date IS NOT NULL) AND (p_txnfind_rec.source_transaction_date <> fnd_api.g_miss_date) )

465: END IF;
466: x_transactions_where := x_transactions_where || 'source_line_ref ' || l_operator || ' :source_line_ref';
467: END IF;
468:
469: IF( (p_txnfind_rec.source_transaction_date IS NOT NULL) AND (p_txnfind_rec.source_transaction_date <> fnd_api.g_miss_date) )
470: THEN
471: i:=0;
472: -- check if item value contains '%' wildcard
473: OPEN c_chk_str1(p_txnfind_rec.source_transaction_date);

Line 509: IF( (p_txnfind_rec.inv_material_transaction_id IS NOT NULL) AND (p_txnfind_rec.inv_material_transaction_id <> fnd_api.g_miss_num) )

505: END IF;
506: END IF;
507:
508:
509: IF( (p_txnfind_rec.inv_material_transaction_id IS NOT NULL) AND (p_txnfind_rec.inv_material_transaction_id <> fnd_api.g_miss_num) )
510: THEN
511:
512: IF(x_transactions_where IS NULL) THEN
513: x_transactions_where := ' WHERE ';

Line 520: IF( (p_txnfind_rec.message_id IS NOT NULL) AND (p_txnfind_rec.message_id <> fnd_api.g_miss_num) )

516: END IF;
517: x_transactions_where := x_transactions_where || 'inv_material_transaction_id = :inv_material_transaction_id';
518: END IF;
519:
520: IF( (p_txnfind_rec.message_id IS NOT NULL) AND (p_txnfind_rec.message_id <> fnd_api.g_miss_num) )
521: THEN
522:
523: IF(x_transactions_where IS NULL) THEN
524: x_transactions_where := ' WHERE ';

Line 532: IF( (p_txnfind_rec.transaction_start_date IS NOT NULL) AND (p_txnfind_rec.transaction_start_date <> fnd_api.g_miss_date) )

528: x_transactions_where := x_transactions_where || 'message_id = :message_id';
529: END IF;
530:
531:
532: IF( (p_txnfind_rec.transaction_start_date IS NOT NULL) AND (p_txnfind_rec.transaction_start_date <> fnd_api.g_miss_date) )
533: THEN
534: IF ( (p_txnfind_rec.transaction_end_date IS NOT NULL) AND (p_txnfind_rec.transaction_end_date <> fnd_api.g_miss_date) )
535: THEN
536: i:=0;

Line 534: IF ( (p_txnfind_rec.transaction_end_date IS NOT NULL) AND (p_txnfind_rec.transaction_end_date <> fnd_api.g_miss_date) )

530:
531:
532: IF( (p_txnfind_rec.transaction_start_date IS NOT NULL) AND (p_txnfind_rec.transaction_start_date <> fnd_api.g_miss_date) )
533: THEN
534: IF ( (p_txnfind_rec.transaction_end_date IS NOT NULL) AND (p_txnfind_rec.transaction_end_date <> fnd_api.g_miss_date) )
535: THEN
536: i:=0;
537: IF(x_transactions_where IS NULL) THEN
538: x_transactions_where := ' WHERE ';

Line 554: IF( (p_txnfind_rec.instance_id IS NOT NULL) AND (p_txnfind_rec.instance_id <> fnd_api.g_miss_num) )

550: x_transactions_where := x_transactions_where || 'transaction_date between :transaction_start_date and :transaction_start_date+1 ';
551: END IF;
552: END IF;
553:
554: IF( (p_txnfind_rec.instance_id IS NOT NULL) AND (p_txnfind_rec.instance_id <> fnd_api.g_miss_num) )
555: THEN
556:
557: IF(x_transactions_where IS NULL) THEN
558: x_transactions_where := ' WHERE ';

Line 565: IF( (p_txnfind_rec.transaction_status_code IS NOT NULL) AND (p_txnfind_rec.transaction_status_code <> fnd_api.g_miss_char) )

561: END IF;
562: x_transactions_where := x_transactions_where || 'instance_id = :instance_id';
563: END IF;
564:
565: IF( (p_txnfind_rec.transaction_status_code IS NOT NULL) AND (p_txnfind_rec.transaction_status_code <> fnd_api.g_miss_char) )
566: THEN
567: i:=0;
568: -- check if item value contains '%' wildcard
569: OPEN c_chk_str1(p_txnfind_rec.transaction_status_code);

Line 602: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

598: END gen_transactions_where;
599:
600: PROCEDURE get_transactions(
601: p_api_version_number IN NUMBER,
602: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
603: p_commit IN VARCHAR2 := fnd_api.g_false,
604: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
605: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec ,
606: p_rec_requested IN NUMBER := g_default_num_rec_fetch,

Line 603: p_commit IN VARCHAR2 := fnd_api.g_false,

599:
600: PROCEDURE get_transactions(
601: p_api_version_number IN NUMBER,
602: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
603: p_commit IN VARCHAR2 := fnd_api.g_false,
604: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
605: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec ,
606: p_rec_requested IN NUMBER := g_default_num_rec_fetch,
607: p_start_rec_prt IN NUMBER := 1,

Line 604: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

600: PROCEDURE get_transactions(
601: p_api_version_number IN NUMBER,
602: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
603: p_commit IN VARCHAR2 := fnd_api.g_false,
604: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
605: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec ,
606: p_rec_requested IN NUMBER := g_default_num_rec_fetch,
607: p_start_rec_prt IN NUMBER := 1,
608: p_return_tot_count IN VARCHAR2 := fnd_api.g_false,

Line 608: p_return_tot_count IN VARCHAR2 := fnd_api.g_false,

604: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
605: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec ,
606: p_rec_requested IN NUMBER := g_default_num_rec_fetch,
607: p_start_rec_prt IN NUMBER := 1,
608: p_return_tot_count IN VARCHAR2 := fnd_api.g_false,
609: p_order_by_rec IN csi_datastructures_pub.transaction_sort_rec,
610: x_return_status OUT NOCOPY VARCHAR2,
611: x_msg_count OUT NOCOPY NUMBER,
612: x_msg_data OUT NOCOPY VARCHAR2,

Line 648: IF fnd_api.to_boolean(p_commit)

644:
645: BEGIN
646:
647: -- standard start of api savepoint
648: IF fnd_api.to_boolean(p_commit)
649: THEN
650: SAVEPOINT get_transactions_pvt;
651: END IF;
652:

Line 654: IF NOT fnd_api.compatible_api_call ( l_api_version_number,

650: SAVEPOINT get_transactions_pvt;
651: END IF;
652:
653: -- standard call to check for call compatibility.
654: IF NOT fnd_api.compatible_api_call ( l_api_version_number,
655: p_api_version_number,
656: l_api_name,
657: g_pkg_name)
658: THEN

Line 659: RAISE fnd_api.g_exc_unexpected_error;

655: p_api_version_number,
656: l_api_name,
657: g_pkg_name)
658: THEN
659: RAISE fnd_api.g_exc_unexpected_error;
660: END IF;
661:
662:
663: -- initialize message list if p_init_msg_list is set to true.

Line 664: IF fnd_api.to_boolean( p_init_msg_list )

660: END IF;
661:
662:
663: -- initialize message list if p_init_msg_list is set to true.
664: IF fnd_api.to_boolean( p_init_msg_list )
665: THEN
666: fnd_msg_pub.initialize;
667: END IF;
668:

Line 671: x_return_status := fnd_api.g_ret_sts_success;

667: END IF;
668:
669:
670: -- initialize api return status to success
671: x_return_status := fnd_api.g_ret_sts_success;
672:
673: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
674: IF (l_debug_level > 0) THEN
675: CSI_gen_utility_pvt.put_line( 'get_transactions');

Line 704: IF( ((p_txnfind_rec.transaction_id IS NULL) OR (p_txnfind_rec.transaction_id = fnd_api.g_miss_num))

700: --
701: -- *************************************************
702: -- generate dynamic sql based on criteria passed in.
703:
704: IF( ((p_txnfind_rec.transaction_id IS NULL) OR (p_txnfind_rec.transaction_id = fnd_api.g_miss_num))
705: AND ((p_txnfind_rec.transaction_type_id IS NULL) OR (p_txnfind_rec.transaction_type_id = fnd_api.g_miss_num))
706: AND ((p_txnfind_rec.txn_sub_type_id IS NULL) OR (p_txnfind_rec.txn_sub_type_id = fnd_api.g_miss_num))
707: AND ((p_txnfind_rec.source_group_ref_id IS NULL) OR (p_txnfind_rec.source_group_ref_id = fnd_api.g_miss_num))
708: AND ((p_txnfind_rec.source_group_ref IS NULL) OR (p_txnfind_rec.source_group_ref = fnd_api.g_miss_char))

Line 705: AND ((p_txnfind_rec.transaction_type_id IS NULL) OR (p_txnfind_rec.transaction_type_id = fnd_api.g_miss_num))

701: -- *************************************************
702: -- generate dynamic sql based on criteria passed in.
703:
704: IF( ((p_txnfind_rec.transaction_id IS NULL) OR (p_txnfind_rec.transaction_id = fnd_api.g_miss_num))
705: AND ((p_txnfind_rec.transaction_type_id IS NULL) OR (p_txnfind_rec.transaction_type_id = fnd_api.g_miss_num))
706: AND ((p_txnfind_rec.txn_sub_type_id IS NULL) OR (p_txnfind_rec.txn_sub_type_id = fnd_api.g_miss_num))
707: AND ((p_txnfind_rec.source_group_ref_id IS NULL) OR (p_txnfind_rec.source_group_ref_id = fnd_api.g_miss_num))
708: AND ((p_txnfind_rec.source_group_ref IS NULL) OR (p_txnfind_rec.source_group_ref = fnd_api.g_miss_char))
709: AND ((p_txnfind_rec.source_header_ref_id IS NULL) OR (p_txnfind_rec.source_header_ref_id = fnd_api.g_miss_num))

Line 706: AND ((p_txnfind_rec.txn_sub_type_id IS NULL) OR (p_txnfind_rec.txn_sub_type_id = fnd_api.g_miss_num))

702: -- generate dynamic sql based on criteria passed in.
703:
704: IF( ((p_txnfind_rec.transaction_id IS NULL) OR (p_txnfind_rec.transaction_id = fnd_api.g_miss_num))
705: AND ((p_txnfind_rec.transaction_type_id IS NULL) OR (p_txnfind_rec.transaction_type_id = fnd_api.g_miss_num))
706: AND ((p_txnfind_rec.txn_sub_type_id IS NULL) OR (p_txnfind_rec.txn_sub_type_id = fnd_api.g_miss_num))
707: AND ((p_txnfind_rec.source_group_ref_id IS NULL) OR (p_txnfind_rec.source_group_ref_id = fnd_api.g_miss_num))
708: AND ((p_txnfind_rec.source_group_ref IS NULL) OR (p_txnfind_rec.source_group_ref = fnd_api.g_miss_char))
709: AND ((p_txnfind_rec.source_header_ref_id IS NULL) OR (p_txnfind_rec.source_header_ref_id = fnd_api.g_miss_num))
710: AND ((p_txnfind_rec.source_header_ref IS NULL) OR (p_txnfind_rec.source_header_ref = fnd_api.g_miss_char))

Line 707: AND ((p_txnfind_rec.source_group_ref_id IS NULL) OR (p_txnfind_rec.source_group_ref_id = fnd_api.g_miss_num))

703:
704: IF( ((p_txnfind_rec.transaction_id IS NULL) OR (p_txnfind_rec.transaction_id = fnd_api.g_miss_num))
705: AND ((p_txnfind_rec.transaction_type_id IS NULL) OR (p_txnfind_rec.transaction_type_id = fnd_api.g_miss_num))
706: AND ((p_txnfind_rec.txn_sub_type_id IS NULL) OR (p_txnfind_rec.txn_sub_type_id = fnd_api.g_miss_num))
707: AND ((p_txnfind_rec.source_group_ref_id IS NULL) OR (p_txnfind_rec.source_group_ref_id = fnd_api.g_miss_num))
708: AND ((p_txnfind_rec.source_group_ref IS NULL) OR (p_txnfind_rec.source_group_ref = fnd_api.g_miss_char))
709: AND ((p_txnfind_rec.source_header_ref_id IS NULL) OR (p_txnfind_rec.source_header_ref_id = fnd_api.g_miss_num))
710: AND ((p_txnfind_rec.source_header_ref IS NULL) OR (p_txnfind_rec.source_header_ref = fnd_api.g_miss_char))
711: AND ((p_txnfind_rec.source_line_ref_id IS NULL) OR (p_txnfind_rec.source_line_ref_id = fnd_api.g_miss_num))

Line 708: AND ((p_txnfind_rec.source_group_ref IS NULL) OR (p_txnfind_rec.source_group_ref = fnd_api.g_miss_char))

704: IF( ((p_txnfind_rec.transaction_id IS NULL) OR (p_txnfind_rec.transaction_id = fnd_api.g_miss_num))
705: AND ((p_txnfind_rec.transaction_type_id IS NULL) OR (p_txnfind_rec.transaction_type_id = fnd_api.g_miss_num))
706: AND ((p_txnfind_rec.txn_sub_type_id IS NULL) OR (p_txnfind_rec.txn_sub_type_id = fnd_api.g_miss_num))
707: AND ((p_txnfind_rec.source_group_ref_id IS NULL) OR (p_txnfind_rec.source_group_ref_id = fnd_api.g_miss_num))
708: AND ((p_txnfind_rec.source_group_ref IS NULL) OR (p_txnfind_rec.source_group_ref = fnd_api.g_miss_char))
709: AND ((p_txnfind_rec.source_header_ref_id IS NULL) OR (p_txnfind_rec.source_header_ref_id = fnd_api.g_miss_num))
710: AND ((p_txnfind_rec.source_header_ref IS NULL) OR (p_txnfind_rec.source_header_ref = fnd_api.g_miss_char))
711: AND ((p_txnfind_rec.source_line_ref_id IS NULL) OR (p_txnfind_rec.source_line_ref_id = fnd_api.g_miss_num))
712: AND ((p_txnfind_rec.source_line_ref IS NULL) OR (p_txnfind_rec.source_line_ref = fnd_api.g_miss_char))

Line 709: AND ((p_txnfind_rec.source_header_ref_id IS NULL) OR (p_txnfind_rec.source_header_ref_id = fnd_api.g_miss_num))

705: AND ((p_txnfind_rec.transaction_type_id IS NULL) OR (p_txnfind_rec.transaction_type_id = fnd_api.g_miss_num))
706: AND ((p_txnfind_rec.txn_sub_type_id IS NULL) OR (p_txnfind_rec.txn_sub_type_id = fnd_api.g_miss_num))
707: AND ((p_txnfind_rec.source_group_ref_id IS NULL) OR (p_txnfind_rec.source_group_ref_id = fnd_api.g_miss_num))
708: AND ((p_txnfind_rec.source_group_ref IS NULL) OR (p_txnfind_rec.source_group_ref = fnd_api.g_miss_char))
709: AND ((p_txnfind_rec.source_header_ref_id IS NULL) OR (p_txnfind_rec.source_header_ref_id = fnd_api.g_miss_num))
710: AND ((p_txnfind_rec.source_header_ref IS NULL) OR (p_txnfind_rec.source_header_ref = fnd_api.g_miss_char))
711: AND ((p_txnfind_rec.source_line_ref_id IS NULL) OR (p_txnfind_rec.source_line_ref_id = fnd_api.g_miss_num))
712: AND ((p_txnfind_rec.source_line_ref IS NULL) OR (p_txnfind_rec.source_line_ref = fnd_api.g_miss_char))
713: AND ((p_txnfind_rec.source_transaction_date IS NULL) OR (p_txnfind_rec.source_transaction_date = fnd_api.g_miss_date))

Line 710: AND ((p_txnfind_rec.source_header_ref IS NULL) OR (p_txnfind_rec.source_header_ref = fnd_api.g_miss_char))

706: AND ((p_txnfind_rec.txn_sub_type_id IS NULL) OR (p_txnfind_rec.txn_sub_type_id = fnd_api.g_miss_num))
707: AND ((p_txnfind_rec.source_group_ref_id IS NULL) OR (p_txnfind_rec.source_group_ref_id = fnd_api.g_miss_num))
708: AND ((p_txnfind_rec.source_group_ref IS NULL) OR (p_txnfind_rec.source_group_ref = fnd_api.g_miss_char))
709: AND ((p_txnfind_rec.source_header_ref_id IS NULL) OR (p_txnfind_rec.source_header_ref_id = fnd_api.g_miss_num))
710: AND ((p_txnfind_rec.source_header_ref IS NULL) OR (p_txnfind_rec.source_header_ref = fnd_api.g_miss_char))
711: AND ((p_txnfind_rec.source_line_ref_id IS NULL) OR (p_txnfind_rec.source_line_ref_id = fnd_api.g_miss_num))
712: AND ((p_txnfind_rec.source_line_ref IS NULL) OR (p_txnfind_rec.source_line_ref = fnd_api.g_miss_char))
713: AND ((p_txnfind_rec.source_transaction_date IS NULL) OR (p_txnfind_rec.source_transaction_date = fnd_api.g_miss_date))
714: AND ((p_txnfind_rec.inv_material_transaction_id IS NULL) OR (p_txnfind_rec.inv_material_transaction_id = fnd_api.g_miss_num))

Line 711: AND ((p_txnfind_rec.source_line_ref_id IS NULL) OR (p_txnfind_rec.source_line_ref_id = fnd_api.g_miss_num))

707: AND ((p_txnfind_rec.source_group_ref_id IS NULL) OR (p_txnfind_rec.source_group_ref_id = fnd_api.g_miss_num))
708: AND ((p_txnfind_rec.source_group_ref IS NULL) OR (p_txnfind_rec.source_group_ref = fnd_api.g_miss_char))
709: AND ((p_txnfind_rec.source_header_ref_id IS NULL) OR (p_txnfind_rec.source_header_ref_id = fnd_api.g_miss_num))
710: AND ((p_txnfind_rec.source_header_ref IS NULL) OR (p_txnfind_rec.source_header_ref = fnd_api.g_miss_char))
711: AND ((p_txnfind_rec.source_line_ref_id IS NULL) OR (p_txnfind_rec.source_line_ref_id = fnd_api.g_miss_num))
712: AND ((p_txnfind_rec.source_line_ref IS NULL) OR (p_txnfind_rec.source_line_ref = fnd_api.g_miss_char))
713: AND ((p_txnfind_rec.source_transaction_date IS NULL) OR (p_txnfind_rec.source_transaction_date = fnd_api.g_miss_date))
714: AND ((p_txnfind_rec.inv_material_transaction_id IS NULL) OR (p_txnfind_rec.inv_material_transaction_id = fnd_api.g_miss_num))
715: AND ((p_txnfind_rec.message_id IS NULL) OR (p_txnfind_rec.message_id = fnd_api.g_miss_num))

Line 712: AND ((p_txnfind_rec.source_line_ref IS NULL) OR (p_txnfind_rec.source_line_ref = fnd_api.g_miss_char))

708: AND ((p_txnfind_rec.source_group_ref IS NULL) OR (p_txnfind_rec.source_group_ref = fnd_api.g_miss_char))
709: AND ((p_txnfind_rec.source_header_ref_id IS NULL) OR (p_txnfind_rec.source_header_ref_id = fnd_api.g_miss_num))
710: AND ((p_txnfind_rec.source_header_ref IS NULL) OR (p_txnfind_rec.source_header_ref = fnd_api.g_miss_char))
711: AND ((p_txnfind_rec.source_line_ref_id IS NULL) OR (p_txnfind_rec.source_line_ref_id = fnd_api.g_miss_num))
712: AND ((p_txnfind_rec.source_line_ref IS NULL) OR (p_txnfind_rec.source_line_ref = fnd_api.g_miss_char))
713: AND ((p_txnfind_rec.source_transaction_date IS NULL) OR (p_txnfind_rec.source_transaction_date = fnd_api.g_miss_date))
714: AND ((p_txnfind_rec.inv_material_transaction_id IS NULL) OR (p_txnfind_rec.inv_material_transaction_id = fnd_api.g_miss_num))
715: AND ((p_txnfind_rec.message_id IS NULL) OR (p_txnfind_rec.message_id = fnd_api.g_miss_num))
716: AND ((p_txnfind_rec.instance_id IS NULL) OR (p_txnfind_rec.instance_id = fnd_api.g_miss_num))

Line 713: AND ((p_txnfind_rec.source_transaction_date IS NULL) OR (p_txnfind_rec.source_transaction_date = fnd_api.g_miss_date))

709: AND ((p_txnfind_rec.source_header_ref_id IS NULL) OR (p_txnfind_rec.source_header_ref_id = fnd_api.g_miss_num))
710: AND ((p_txnfind_rec.source_header_ref IS NULL) OR (p_txnfind_rec.source_header_ref = fnd_api.g_miss_char))
711: AND ((p_txnfind_rec.source_line_ref_id IS NULL) OR (p_txnfind_rec.source_line_ref_id = fnd_api.g_miss_num))
712: AND ((p_txnfind_rec.source_line_ref IS NULL) OR (p_txnfind_rec.source_line_ref = fnd_api.g_miss_char))
713: AND ((p_txnfind_rec.source_transaction_date IS NULL) OR (p_txnfind_rec.source_transaction_date = fnd_api.g_miss_date))
714: AND ((p_txnfind_rec.inv_material_transaction_id IS NULL) OR (p_txnfind_rec.inv_material_transaction_id = fnd_api.g_miss_num))
715: AND ((p_txnfind_rec.message_id IS NULL) OR (p_txnfind_rec.message_id = fnd_api.g_miss_num))
716: AND ((p_txnfind_rec.instance_id IS NULL) OR (p_txnfind_rec.instance_id = fnd_api.g_miss_num))
717: AND ((p_txnfind_rec.transaction_start_date IS NULL) OR (p_txnfind_rec.transaction_start_date = fnd_api.g_miss_date))

Line 714: AND ((p_txnfind_rec.inv_material_transaction_id IS NULL) OR (p_txnfind_rec.inv_material_transaction_id = fnd_api.g_miss_num))

710: AND ((p_txnfind_rec.source_header_ref IS NULL) OR (p_txnfind_rec.source_header_ref = fnd_api.g_miss_char))
711: AND ((p_txnfind_rec.source_line_ref_id IS NULL) OR (p_txnfind_rec.source_line_ref_id = fnd_api.g_miss_num))
712: AND ((p_txnfind_rec.source_line_ref IS NULL) OR (p_txnfind_rec.source_line_ref = fnd_api.g_miss_char))
713: AND ((p_txnfind_rec.source_transaction_date IS NULL) OR (p_txnfind_rec.source_transaction_date = fnd_api.g_miss_date))
714: AND ((p_txnfind_rec.inv_material_transaction_id IS NULL) OR (p_txnfind_rec.inv_material_transaction_id = fnd_api.g_miss_num))
715: AND ((p_txnfind_rec.message_id IS NULL) OR (p_txnfind_rec.message_id = fnd_api.g_miss_num))
716: AND ((p_txnfind_rec.instance_id IS NULL) OR (p_txnfind_rec.instance_id = fnd_api.g_miss_num))
717: AND ((p_txnfind_rec.transaction_start_date IS NULL) OR (p_txnfind_rec.transaction_start_date = fnd_api.g_miss_date))
718: AND ((p_txnfind_rec.transaction_end_date IS NULL) OR (p_txnfind_rec.transaction_end_date = fnd_api.g_miss_date))

Line 715: AND ((p_txnfind_rec.message_id IS NULL) OR (p_txnfind_rec.message_id = fnd_api.g_miss_num))

711: AND ((p_txnfind_rec.source_line_ref_id IS NULL) OR (p_txnfind_rec.source_line_ref_id = fnd_api.g_miss_num))
712: AND ((p_txnfind_rec.source_line_ref IS NULL) OR (p_txnfind_rec.source_line_ref = fnd_api.g_miss_char))
713: AND ((p_txnfind_rec.source_transaction_date IS NULL) OR (p_txnfind_rec.source_transaction_date = fnd_api.g_miss_date))
714: AND ((p_txnfind_rec.inv_material_transaction_id IS NULL) OR (p_txnfind_rec.inv_material_transaction_id = fnd_api.g_miss_num))
715: AND ((p_txnfind_rec.message_id IS NULL) OR (p_txnfind_rec.message_id = fnd_api.g_miss_num))
716: AND ((p_txnfind_rec.instance_id IS NULL) OR (p_txnfind_rec.instance_id = fnd_api.g_miss_num))
717: AND ((p_txnfind_rec.transaction_start_date IS NULL) OR (p_txnfind_rec.transaction_start_date = fnd_api.g_miss_date))
718: AND ((p_txnfind_rec.transaction_end_date IS NULL) OR (p_txnfind_rec.transaction_end_date = fnd_api.g_miss_date))
719: AND ((p_txnfind_rec.transaction_status_code IS NULL) OR (p_txnfind_rec.transaction_status_code = fnd_api.g_miss_char))

Line 716: AND ((p_txnfind_rec.instance_id IS NULL) OR (p_txnfind_rec.instance_id = fnd_api.g_miss_num))

712: AND ((p_txnfind_rec.source_line_ref IS NULL) OR (p_txnfind_rec.source_line_ref = fnd_api.g_miss_char))
713: AND ((p_txnfind_rec.source_transaction_date IS NULL) OR (p_txnfind_rec.source_transaction_date = fnd_api.g_miss_date))
714: AND ((p_txnfind_rec.inv_material_transaction_id IS NULL) OR (p_txnfind_rec.inv_material_transaction_id = fnd_api.g_miss_num))
715: AND ((p_txnfind_rec.message_id IS NULL) OR (p_txnfind_rec.message_id = fnd_api.g_miss_num))
716: AND ((p_txnfind_rec.instance_id IS NULL) OR (p_txnfind_rec.instance_id = fnd_api.g_miss_num))
717: AND ((p_txnfind_rec.transaction_start_date IS NULL) OR (p_txnfind_rec.transaction_start_date = fnd_api.g_miss_date))
718: AND ((p_txnfind_rec.transaction_end_date IS NULL) OR (p_txnfind_rec.transaction_end_date = fnd_api.g_miss_date))
719: AND ((p_txnfind_rec.transaction_status_code IS NULL) OR (p_txnfind_rec.transaction_status_code = fnd_api.g_miss_char))
720:

Line 717: AND ((p_txnfind_rec.transaction_start_date IS NULL) OR (p_txnfind_rec.transaction_start_date = fnd_api.g_miss_date))

713: AND ((p_txnfind_rec.source_transaction_date IS NULL) OR (p_txnfind_rec.source_transaction_date = fnd_api.g_miss_date))
714: AND ((p_txnfind_rec.inv_material_transaction_id IS NULL) OR (p_txnfind_rec.inv_material_transaction_id = fnd_api.g_miss_num))
715: AND ((p_txnfind_rec.message_id IS NULL) OR (p_txnfind_rec.message_id = fnd_api.g_miss_num))
716: AND ((p_txnfind_rec.instance_id IS NULL) OR (p_txnfind_rec.instance_id = fnd_api.g_miss_num))
717: AND ((p_txnfind_rec.transaction_start_date IS NULL) OR (p_txnfind_rec.transaction_start_date = fnd_api.g_miss_date))
718: AND ((p_txnfind_rec.transaction_end_date IS NULL) OR (p_txnfind_rec.transaction_end_date = fnd_api.g_miss_date))
719: AND ((p_txnfind_rec.transaction_status_code IS NULL) OR (p_txnfind_rec.transaction_status_code = fnd_api.g_miss_char))
720:
721: ) THEN

Line 718: AND ((p_txnfind_rec.transaction_end_date IS NULL) OR (p_txnfind_rec.transaction_end_date = fnd_api.g_miss_date))

714: AND ((p_txnfind_rec.inv_material_transaction_id IS NULL) OR (p_txnfind_rec.inv_material_transaction_id = fnd_api.g_miss_num))
715: AND ((p_txnfind_rec.message_id IS NULL) OR (p_txnfind_rec.message_id = fnd_api.g_miss_num))
716: AND ((p_txnfind_rec.instance_id IS NULL) OR (p_txnfind_rec.instance_id = fnd_api.g_miss_num))
717: AND ((p_txnfind_rec.transaction_start_date IS NULL) OR (p_txnfind_rec.transaction_start_date = fnd_api.g_miss_date))
718: AND ((p_txnfind_rec.transaction_end_date IS NULL) OR (p_txnfind_rec.transaction_end_date = fnd_api.g_miss_date))
719: AND ((p_txnfind_rec.transaction_status_code IS NULL) OR (p_txnfind_rec.transaction_status_code = fnd_api.g_miss_char))
720:
721: ) THEN
722: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');

Line 719: AND ((p_txnfind_rec.transaction_status_code IS NULL) OR (p_txnfind_rec.transaction_status_code = fnd_api.g_miss_char))

715: AND ((p_txnfind_rec.message_id IS NULL) OR (p_txnfind_rec.message_id = fnd_api.g_miss_num))
716: AND ((p_txnfind_rec.instance_id IS NULL) OR (p_txnfind_rec.instance_id = fnd_api.g_miss_num))
717: AND ((p_txnfind_rec.transaction_start_date IS NULL) OR (p_txnfind_rec.transaction_start_date = fnd_api.g_miss_date))
718: AND ((p_txnfind_rec.transaction_end_date IS NULL) OR (p_txnfind_rec.transaction_end_date = fnd_api.g_miss_date))
719: AND ((p_txnfind_rec.transaction_status_code IS NULL) OR (p_txnfind_rec.transaction_status_code = fnd_api.g_miss_char))
720:
721: ) THEN
722: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
723: fnd_msg_pub.add;

Line 724: x_return_status := fnd_api.g_ret_sts_error;

720:
721: ) THEN
722: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
723: fnd_msg_pub.add;
724: x_return_status := fnd_api.g_ret_sts_error;
725: RAISE fnd_api.g_exc_error;
726: END IF;
727: x_tot_rec_count:=l_tot_rec_count;
728: x_returned_rec_count:=l_returned_rec_count;

Line 725: RAISE fnd_api.g_exc_error;

721: ) THEN
722: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
723: fnd_msg_pub.add;
724: x_return_status := fnd_api.g_ret_sts_error;
725: RAISE fnd_api.g_exc_error;
726: END IF;
727: x_tot_rec_count:=l_tot_rec_count;
728: x_returned_rec_count:=l_returned_rec_count;
729: gen_select(l_crit_transaction_rec,l_select_cl);

Line 745: IF((dbms_sql.fetch_rows(l_cur_get_transactions)>0) AND ((p_return_tot_count = fnd_api.g_true)

741: l_ignore := dbms_sql.execute(l_cur_get_transactions);
742:
743: LOOP
744:
745: IF((dbms_sql.fetch_rows(l_cur_get_transactions)>0) AND ((p_return_tot_count = fnd_api.g_true)
746: OR (l_returned_rec_count 747: THEN
748: get_column_values(l_cur_get_transactions, l_txn_rec);
749: l_tot_rec_count := l_tot_rec_count + 1;

Line 746: OR (l_returned_rec_count

742:
743: LOOP
744:
745: IF((dbms_sql.fetch_rows(l_cur_get_transactions)>0) AND ((p_return_tot_count = fnd_api.g_true)
746: OR (l_returned_rec_count 747: THEN
748: get_column_values(l_cur_get_transactions, l_txn_rec);
749: l_tot_rec_count := l_tot_rec_count + 1;
750: x_tot_rec_count := l_tot_rec_count;

Line 836: WHEN fnd_api.g_exc_error THEN

832: ( p_count => x_msg_count,
833: p_data => x_msg_data
834: );
835: EXCEPTION
836: WHEN fnd_api.g_exc_error THEN
837: IF fnd_api.to_boolean(p_commit)
838: THEN
839: ROLLBACK TO get_transactions_pvt;
840: END IF;

Line 837: IF fnd_api.to_boolean(p_commit)

833: p_data => x_msg_data
834: );
835: EXCEPTION
836: WHEN fnd_api.g_exc_error THEN
837: IF fnd_api.to_boolean(p_commit)
838: THEN
839: ROLLBACK TO get_transactions_pvt;
840: END IF;
841: x_return_status := fnd_api.g_ret_sts_error ;

Line 841: x_return_status := fnd_api.g_ret_sts_error ;

837: IF fnd_api.to_boolean(p_commit)
838: THEN
839: ROLLBACK TO get_transactions_pvt;
840: END IF;
841: x_return_status := fnd_api.g_ret_sts_error ;
842: fnd_msg_pub.count_and_get
843: (p_count => x_msg_count ,
844: p_data => x_msg_data
845: );

Line 847: WHEN fnd_api.g_exc_unexpected_error THEN

843: (p_count => x_msg_count ,
844: p_data => x_msg_data
845: );
846:
847: WHEN fnd_api.g_exc_unexpected_error THEN
848: IF fnd_api.to_boolean(p_commit)
849: THEN
850: ROLLBACK TO get_transactions_pvt;
851: END IF;

Line 848: IF fnd_api.to_boolean(p_commit)

844: p_data => x_msg_data
845: );
846:
847: WHEN fnd_api.g_exc_unexpected_error THEN
848: IF fnd_api.to_boolean(p_commit)
849: THEN
850: ROLLBACK TO get_transactions_pvt;
851: END IF;
852: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 852: x_return_status := fnd_api.g_ret_sts_unexp_error ;

848: IF fnd_api.to_boolean(p_commit)
849: THEN
850: ROLLBACK TO get_transactions_pvt;
851: END IF;
852: x_return_status := fnd_api.g_ret_sts_unexp_error ;
853: fnd_msg_pub.count_and_get
854: (p_count => x_msg_count ,
855: p_data => x_msg_data
856: );

Line 859: IF fnd_api.to_boolean(p_commit)

855: p_data => x_msg_data
856: );
857:
858: WHEN OTHERS THEN
859: IF fnd_api.to_boolean(p_commit)
860: THEN
861: ROLLBACK TO get_transactions_pvt;
862: END IF;
863: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 863: x_return_status := fnd_api.g_ret_sts_unexp_error ;

859: IF fnd_api.to_boolean(p_commit)
860: THEN
861: ROLLBACK TO get_transactions_pvt;
862: END IF;
863: x_return_status := fnd_api.g_ret_sts_unexp_error ;
864: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
865: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
866: END IF;
867: fnd_msg_pub.count_and_get

Line 879: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

875: /* --- the transaction_id passed --- */
876: /* ---------------------------------------------------------------------------------- */
877:
878: PROCEDURE validate_transaction_id (
879: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
880: p_validation_mode IN VARCHAR2,
881: p_transaction_id IN NUMBER,
882: x_return_status OUT NOCOPY VARCHAR2,
883: x_msg_count OUT NOCOPY NUMBER,

Line 895: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

891:
892:
893:
894: PROCEDURE validate_s_transaction_date (
895: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
896: p_source_transaction_date IN DATE,
897: x_return_status OUT NOCOPY VARCHAR2,
898: x_msg_count OUT NOCOPY NUMBER,
899: x_msg_data OUT NOCOPY VARCHAR2

Line 908: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

904: /* --- the transaction_type_id passed --- */
905: /* ---------------------------------------------------------------------------------- */
906:
907: PROCEDURE validate_transaction_type_id (
908: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
909: p_transaction_type_id IN NUMBER,
910: x_return_status OUT NOCOPY VARCHAR2,
911: x_msg_count OUT NOCOPY NUMBER,
912: x_msg_data OUT NOCOPY VARCHAR2

Line 921: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

917: /* --- the object_version_number passed --- */
918: /* --------------------------------------------------------------------------------- */
919:
920: PROCEDURE validate_object_version_num (
921: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
922: p_validation_mode IN VARCHAR2,
923: p_object_version_number IN NUMBER,
924: x_return_status OUT NOCOPY VARCHAR2,
925: x_msg_count OUT NOCOPY NUMBER,

Line 935: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

931: /* --- the transaction_type_id passed --- */
932: /* ---------------------------------------------------------------------------------- */
933:
934: PROCEDURE validate_source_object (
935: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
936: p_transaction_type_id IN NUMBER,
937: p_source_line_ref_id IN NUMBER,
938: x_return_status OUT NOCOPY VARCHAR2,
939: x_msg_count OUT NOCOPY NUMBER,

Line 950: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

946: /* ---------------------------------------------------------------------------------- */
947:
948:
949: PROCEDURE validate_split_code (
950: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
951: p_split_reason_code IN VARCHAR2,
952: x_return_status OUT NOCOPY VARCHAR2,
953: x_msg_count OUT NOCOPY NUMBER ,
954: x_msg_data OUT NOCOPY VARCHAR2

Line 965: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

961: /* ---------------------------------------------------------------------------------- */
962:
963:
964: PROCEDURE validate_transactions(
965: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
966: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
967: p_validation_mode IN VARCHAR2,
968: p_transaction_rec IN csi_datastructures_pub.transaction_rec,
969: x_return_status OUT NOCOPY VARCHAR2,

Line 966: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

962:
963:
964: PROCEDURE validate_transactions(
965: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
966: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
967: p_validation_mode IN VARCHAR2,
968: p_transaction_rec IN csi_datastructures_pub.transaction_rec,
969: x_return_status OUT NOCOPY VARCHAR2,
970: x_msg_count OUT NOCOPY NUMBER,

Line 982: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

978:
979:
980: PROCEDURE create_transaction(
981: p_api_version IN NUMBER,
982: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
983: p_commit IN VARCHAR2 := fnd_api.g_false,
984: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
985: p_success_if_exists_flag IN VARCHAR2 := 'N',
986: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec ,

Line 983: p_commit IN VARCHAR2 := fnd_api.g_false,

979:
980: PROCEDURE create_transaction(
981: p_api_version IN NUMBER,
982: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
983: p_commit IN VARCHAR2 := fnd_api.g_false,
984: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
985: p_success_if_exists_flag IN VARCHAR2 := 'N',
986: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec ,
987: x_return_status OUT NOCOPY VARCHAR2,

Line 984: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

980: PROCEDURE create_transaction(
981: p_api_version IN NUMBER,
982: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
983: p_commit IN VARCHAR2 := fnd_api.g_false,
984: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
985: p_success_if_exists_flag IN VARCHAR2 := 'N',
986: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec ,
987: x_return_status OUT NOCOPY VARCHAR2,
988: x_msg_count OUT NOCOPY NUMBER,

Line 1005: IF fnd_api.to_boolean(p_commit)

1001:
1002: BEGIN
1003:
1004: -- standard start of api savepoint
1005: IF fnd_api.to_boolean(p_commit)
1006: THEN
1007: SAVEPOINT create_transactions_pvt;
1008: END IF;
1009:

Line 1011: IF NOT fnd_api.compatible_api_call ( l_api_version,

1007: SAVEPOINT create_transactions_pvt;
1008: END IF;
1009:
1010: -- standard call to check for call compatibility.
1011: IF NOT fnd_api.compatible_api_call ( l_api_version,
1012: p_api_version,
1013: l_api_name,
1014: g_pkg_name)
1015: THEN

Line 1016: RAISE fnd_api.g_exc_unexpected_error;

1012: p_api_version,
1013: l_api_name,
1014: g_pkg_name)
1015: THEN
1016: RAISE fnd_api.g_exc_unexpected_error;
1017: END IF;
1018:
1019:
1020: -- initialize message list if p_init_msg_list is set to true.

Line 1021: IF fnd_api.to_boolean( p_init_msg_list )

1017: END IF;
1018:
1019:
1020: -- initialize message list if p_init_msg_list is set to true.
1021: IF fnd_api.to_boolean( p_init_msg_list )
1022: THEN
1023: fnd_msg_pub.initialize;
1024: END IF;
1025:

Line 1028: x_return_status := fnd_api.g_ret_sts_success;

1024: END IF;
1025:
1026:
1027: -- initialize api return status to success
1028: x_return_status := fnd_api.g_ret_sts_success;
1029:
1030: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1031: IF (l_debug_level > 0) THEN
1032: CSI_gen_utility_pvt.put_line( 'create_transaction');

Line 1054: (p_transaction_rec.transaction_id <> fnd_api.g_miss_num)) THEN

1050:
1051: IF p_success_if_exists_flag ='Y' THEN
1052: /* If success flag is Y then */
1053: IF ((p_transaction_rec.transaction_id IS NOT NULL) AND
1054: (p_transaction_rec.transaction_id <> fnd_api.g_miss_num)) THEN
1055: /* If success flag is Y then check for id if present return success */
1056:
1057: BEGIN
1058: SELECT 'x'

Line 1064: x_return_status := fnd_api.g_ret_sts_success;

1060: FROM csi_transactions
1061: WHERE transaction_id=p_transaction_rec.transaction_id
1062: AND rownum=1;
1063: IF SQL%FOUND THEN
1064: x_return_status := fnd_api.g_ret_sts_success;
1065: l_create_flag :='N';
1066: END IF;
1067:
1068: EXCEPTION WHEN no_data_found THEN

Line 1071: p_init_msg_list => fnd_api.g_false,

1067:
1068: EXCEPTION WHEN no_data_found THEN
1069: /* If success flag is Y then if passed id not found then proceed with validations */
1070: validate_transactions(
1071: p_init_msg_list => fnd_api.g_false,
1072: p_validation_level => p_validation_level,
1073: p_validation_mode => 'CREATE',
1074: p_transaction_rec => p_transaction_rec,
1075: x_return_status => x_return_status,

Line 1082: p_init_msg_list => fnd_api.g_false,

1078: END;
1079: ELSE
1080: /* If success flag is Y then if id not passed proceed with validations */
1081: validate_transactions(
1082: p_init_msg_list => fnd_api.g_false,
1083: p_validation_level => p_validation_level,
1084: p_validation_mode => 'CREATE',
1085: p_transaction_rec => p_transaction_rec,
1086: x_return_status => x_return_status,

Line 1095: (p_transaction_rec.transaction_id <> fnd_api.g_miss_num)) THEN

1091:
1092: /* If success flag is 'N' then if id passed already exists then return error mesg */
1093:
1094: IF ((p_transaction_rec.transaction_id IS NOT NULL) AND
1095: (p_transaction_rec.transaction_id <> fnd_api.g_miss_num)) THEN
1096: BEGIN
1097: SELECT 'x'
1098: INTO l_dummy
1099: FROM csi_transactions

Line 1107: x_return_status := fnd_api.g_ret_sts_error;

1103: IF SQL%FOUND THEN
1104: fnd_message.set_name('CSI', 'CSI_TXN_ID_ALREADY_EXISTS');
1105: fnd_message.set_token('transaction_id',p_transaction_rec.transaction_id);
1106: fnd_msg_pub.add;
1107: x_return_status := fnd_api.g_ret_sts_error;
1108: END IF;
1109:
1110: EXCEPTION WHEN no_data_found THEN
1111: /* If success flag is 'N' then if id passed not exists then proceed with validations */

Line 1113: p_init_msg_list => fnd_api.g_false,

1109:
1110: EXCEPTION WHEN no_data_found THEN
1111: /* If success flag is 'N' then if id passed not exists then proceed with validations */
1112: validate_transactions(
1113: p_init_msg_list => fnd_api.g_false,
1114: p_validation_level => p_validation_level,
1115: p_validation_mode => 'CREATE',
1116: p_transaction_rec => p_transaction_rec,
1117: x_return_status => x_return_status,

Line 1125: p_init_msg_list => fnd_api.g_false,

1121: -- added code for flag ='n and id passed
1122: ELSE
1123: /* If success flag is 'N' then if id not passed then proceed with validations */
1124: validate_transactions(
1125: p_init_msg_list => fnd_api.g_false,
1126: p_validation_level => p_validation_level,
1127: p_validation_mode => 'CREATE',
1128: p_transaction_rec => p_transaction_rec,
1129: x_return_status => x_return_status,

Line 1137: IF x_return_status<>fnd_api.g_ret_sts_success THEN

1133: END IF;
1134:
1135:
1136:
1137: IF x_return_status<>fnd_api.g_ret_sts_success THEN
1138:
1139: RAISE fnd_api.g_exc_error;
1140: END IF;
1141:

Line 1139: RAISE fnd_api.g_exc_error;

1135:
1136:
1137: IF x_return_status<>fnd_api.g_ret_sts_success THEN
1138:
1139: RAISE fnd_api.g_exc_error;
1140: END IF;
1141:
1142:
1143:

Line 1148: IF p_transaction_rec.transaction_date=fnd_api.g_miss_date THEN

1144: SELECT SYSDATE
1145: INTO l_transaction_date
1146: FROM dual;
1147:
1148: IF p_transaction_rec.transaction_date=fnd_api.g_miss_date THEN
1149: l_transaction_date:=l_transaction_date;
1150: END IF;
1151:
1152: IF p_transaction_rec.gl_interface_status_code IS NULL OR

Line 1153: p_transaction_rec.gl_interface_status_code = FND_API.G_MISS_NUM

1149: l_transaction_date:=l_transaction_date;
1150: END IF;
1151:
1152: IF p_transaction_rec.gl_interface_status_code IS NULL OR
1153: p_transaction_rec.gl_interface_status_code = FND_API.G_MISS_NUM
1154: THEN
1155: p_transaction_rec.gl_interface_status_code :=1;
1156: ELSE
1157: IF p_transaction_rec.gl_interface_status_code NOT IN (1,2,3)

Line 1162: RAISE fnd_api.g_exc_error;

1158: THEN
1159: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_GL_STATUS');
1160: FND_MESSAGE.SET_TOKEN('STATUS_CODE',p_transaction_rec.gl_interface_status_code);
1161: FND_MSG_PUB.Add;
1162: RAISE fnd_api.g_exc_error;
1163: END IF;
1164: END IF;
1165:
1166: --x_transaction_id:=p_transaction_rec.transaction_id;

Line 1222: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1218: -- hint: primary key should be returned.
1219: -- x_transaction_id := px_transaction_id;
1220: --p_transaction_rec.transaction_id := px_transaction_id;
1221:
1222: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1223: RAISE fnd_api.g_exc_error;
1224: END IF;
1225:
1226: --

Line 1223: RAISE fnd_api.g_exc_error;

1219: -- x_transaction_id := px_transaction_id;
1220: --p_transaction_rec.transaction_id := px_transaction_id;
1221:
1222: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1223: RAISE fnd_api.g_exc_error;
1224: END IF;
1225:
1226: --
1227: -- end of api body

Line 1231: IF fnd_api.to_boolean( p_commit )

1227: -- end of api body
1228: --
1229:
1230: -- standard check for p_commit
1231: IF fnd_api.to_boolean( p_commit )
1232: THEN
1233: COMMIT WORK;
1234: END IF;
1235:

Line 1244: WHEN fnd_api.g_exc_error THEN

1240: p_data => x_msg_data
1241: );
1242:
1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN
1245: IF fnd_api.to_boolean(p_commit)
1246: THEN
1247: ROLLBACK TO create_transactions_pvt;
1248: END IF;

Line 1245: IF fnd_api.to_boolean(p_commit)

1241: );
1242:
1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN
1245: IF fnd_api.to_boolean(p_commit)
1246: THEN
1247: ROLLBACK TO create_transactions_pvt;
1248: END IF;
1249: x_return_status := fnd_api.g_ret_sts_error ;

Line 1249: x_return_status := fnd_api.g_ret_sts_error ;

1245: IF fnd_api.to_boolean(p_commit)
1246: THEN
1247: ROLLBACK TO create_transactions_pvt;
1248: END IF;
1249: x_return_status := fnd_api.g_ret_sts_error ;
1250: fnd_msg_pub.count_and_get
1251: (p_count => x_msg_count ,
1252: p_data => x_msg_data
1253: );

Line 1255: WHEN fnd_api.g_exc_unexpected_error THEN

1251: (p_count => x_msg_count ,
1252: p_data => x_msg_data
1253: );
1254:
1255: WHEN fnd_api.g_exc_unexpected_error THEN
1256: IF fnd_api.to_boolean(p_commit)
1257: THEN
1258: ROLLBACK TO create_transactions_pvt;
1259: END IF;

Line 1256: IF fnd_api.to_boolean(p_commit)

1252: p_data => x_msg_data
1253: );
1254:
1255: WHEN fnd_api.g_exc_unexpected_error THEN
1256: IF fnd_api.to_boolean(p_commit)
1257: THEN
1258: ROLLBACK TO create_transactions_pvt;
1259: END IF;
1260: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1260: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1256: IF fnd_api.to_boolean(p_commit)
1257: THEN
1258: ROLLBACK TO create_transactions_pvt;
1259: END IF;
1260: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1261: fnd_msg_pub.count_and_get
1262: (p_count => x_msg_count ,
1263: p_data => x_msg_data
1264: );

Line 1267: IF fnd_api.to_boolean(p_commit)

1263: p_data => x_msg_data
1264: );
1265:
1266: WHEN OTHERS THEN
1267: IF fnd_api.to_boolean(p_commit)
1268: THEN
1269: ROLLBACK TO create_transactions_pvt;
1270: END IF;
1271: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1271: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1267: IF fnd_api.to_boolean(p_commit)
1268: THEN
1269: ROLLBACK TO create_transactions_pvt;
1270: END IF;
1271: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1272: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1273: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
1274: END IF;
1275: fnd_msg_pub.count_and_get

Line 1292: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1288:
1289:
1290: PROCEDURE update_transactions(
1291: p_api_version IN NUMBER,
1292: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1293: p_commit IN VARCHAR2 := fnd_api.g_false,
1294: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1295: p_transaction_rec IN csi_datastructures_pub.transaction_rec,
1296: x_return_status OUT NOCOPY VARCHAR2,

Line 1293: p_commit IN VARCHAR2 := fnd_api.g_false,

1289:
1290: PROCEDURE update_transactions(
1291: p_api_version IN NUMBER,
1292: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1293: p_commit IN VARCHAR2 := fnd_api.g_false,
1294: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1295: p_transaction_rec IN csi_datastructures_pub.transaction_rec,
1296: x_return_status OUT NOCOPY VARCHAR2,
1297: x_msg_count OUT NOCOPY NUMBER,

Line 1294: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

1290: PROCEDURE update_transactions(
1291: p_api_version IN NUMBER,
1292: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1293: p_commit IN VARCHAR2 := fnd_api.g_false,
1294: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1295: p_transaction_rec IN csi_datastructures_pub.transaction_rec,
1296: x_return_status OUT NOCOPY VARCHAR2,
1297: x_msg_count OUT NOCOPY NUMBER,
1298: x_msg_data OUT NOCOPY VARCHAR2

Line 1321: IF fnd_api.to_boolean(p_commit)

1317: l_debug_level NUMBER;
1318:
1319: BEGIN
1320: -- standard start of api savepoint
1321: IF fnd_api.to_boolean(p_commit)
1322: THEN
1323: SAVEPOINT update_transactions_pvt;
1324: END IF;
1325:

Line 1327: IF NOT fnd_api.compatible_api_call ( l_api_version,

1323: SAVEPOINT update_transactions_pvt;
1324: END IF;
1325:
1326: -- standard call to check for call compatibility.
1327: IF NOT fnd_api.compatible_api_call ( l_api_version,
1328: p_api_version,
1329: l_api_name,
1330: g_pkg_name)
1331: THEN

Line 1332: RAISE fnd_api.g_exc_unexpected_error;

1328: p_api_version,
1329: l_api_name,
1330: g_pkg_name)
1331: THEN
1332: RAISE fnd_api.g_exc_unexpected_error;
1333: END IF;
1334:
1335:
1336: -- initialize message list if p_init_msg_list is set to true.

Line 1337: IF fnd_api.to_boolean( p_init_msg_list )

1333: END IF;
1334:
1335:
1336: -- initialize message list if p_init_msg_list is set to true.
1337: IF fnd_api.to_boolean( p_init_msg_list )
1338: THEN
1339: fnd_msg_pub.initialize;
1340: END IF;
1341: -- initialize api return status to success

Line 1342: x_return_status := fnd_api.g_ret_sts_success;

1338: THEN
1339: fnd_msg_pub.initialize;
1340: END IF;
1341: -- initialize api return status to success
1342: x_return_status := fnd_api.g_ret_sts_success;
1343:
1344: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1345: IF (l_debug_level > 0) THEN
1346: CSI_gen_utility_pvt.put_line( 'update_transactions');

Line 1366: AND (p_transaction_rec.object_version_number <> fnd_api.g_miss_num) ) THEN

1362:
1363: OPEN lock_csr (p_transaction_rec);
1364: FETCH lock_csr INTO l_object_version_number;
1365: IF ( (l_object_version_number<>p_transaction_rec.object_version_number)
1366: AND (p_transaction_rec.object_version_number <> fnd_api.g_miss_num) ) THEN
1367: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');
1368: fnd_msg_pub.add;
1369: RAISE fnd_api.g_exc_error;
1370: END IF;

Line 1369: RAISE fnd_api.g_exc_error;

1365: IF ( (l_object_version_number<>p_transaction_rec.object_version_number)
1366: AND (p_transaction_rec.object_version_number <> fnd_api.g_miss_num) ) THEN
1367: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');
1368: fnd_msg_pub.add;
1369: RAISE fnd_api.g_exc_error;
1370: END IF;
1371:
1372: IF lock_csr%NOTFOUND THEN
1373: fnd_message.set_name('CSI', 'CSI_RECORD_LOCKED');

Line 1375: RAISE fnd_api.g_exc_error;

1371:
1372: IF lock_csr%NOTFOUND THEN
1373: fnd_message.set_name('CSI', 'CSI_RECORD_LOCKED');
1374: fnd_msg_pub.add;
1375: RAISE fnd_api.g_exc_error;
1376: END IF;
1377:
1378: CLOSE lock_csr;
1379:

Line 1383: p_init_msg_list => fnd_api.g_false,

1379:
1380: -- invoke validation procedures
1381:
1382: validate_transaction_id (
1383: p_init_msg_list => fnd_api.g_false,
1384: p_validation_mode => 'UPDATE',
1385: p_transaction_id => p_transaction_rec.transaction_id,
1386: x_return_status => x_return_status,
1387: x_msg_count => x_msg_count,

Line 1390: IF x_return_status=fnd_api.g_ret_sts_success THEN

1386: x_return_status => x_return_status,
1387: x_msg_count => x_msg_count,
1388: x_msg_data => x_msg_data);
1389:
1390: IF x_return_status=fnd_api.g_ret_sts_success THEN
1391: validate_object_version_num (
1392: p_init_msg_list => fnd_api.g_false,
1393: p_validation_mode => 'UPDATE',
1394: p_object_version_number => p_transaction_rec.object_version_number,

Line 1392: p_init_msg_list => fnd_api.g_false,

1388: x_msg_data => x_msg_data);
1389:
1390: IF x_return_status=fnd_api.g_ret_sts_success THEN
1391: validate_object_version_num (
1392: p_init_msg_list => fnd_api.g_false,
1393: p_validation_mode => 'UPDATE',
1394: p_object_version_number => p_transaction_rec.object_version_number,
1395: x_return_status => x_return_status,
1396: x_msg_count => x_msg_count,

Line 1400: IF x_return_status<>fnd_api.g_ret_sts_success THEN

1396: x_msg_count => x_msg_count,
1397: x_msg_data => x_msg_data);
1398: END IF;
1399:
1400: IF x_return_status<>fnd_api.g_ret_sts_success THEN
1401: RAISE fnd_api.g_exc_error;
1402: END IF;
1403:
1404: IF p_transaction_rec.gl_interface_status_code IS NOT NULL AND

Line 1401: RAISE fnd_api.g_exc_error;

1397: x_msg_data => x_msg_data);
1398: END IF;
1399:
1400: IF x_return_status<>fnd_api.g_ret_sts_success THEN
1401: RAISE fnd_api.g_exc_error;
1402: END IF;
1403:
1404: IF p_transaction_rec.gl_interface_status_code IS NOT NULL AND
1405: p_transaction_rec.gl_interface_status_code <> FND_API.G_MISS_NUM AND

Line 1405: p_transaction_rec.gl_interface_status_code <> FND_API.G_MISS_NUM AND

1401: RAISE fnd_api.g_exc_error;
1402: END IF;
1403:
1404: IF p_transaction_rec.gl_interface_status_code IS NOT NULL AND
1405: p_transaction_rec.gl_interface_status_code <> FND_API.G_MISS_NUM AND
1406: p_transaction_rec.gl_interface_status_code NOT IN (1,2,3)
1407: THEN
1408: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_GL_STATUS');
1409: FND_MESSAGE.SET_TOKEN('STATUS_CODE',p_transaction_rec.gl_interface_status_code);

Line 1411: RAISE fnd_api.g_exc_error;

1407: THEN
1408: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_GL_STATUS');
1409: FND_MESSAGE.SET_TOKEN('STATUS_CODE',p_transaction_rec.gl_interface_status_code);
1410: FND_MSG_PUB.Add;
1411: RAISE fnd_api.g_exc_error;
1412: END IF;
1413:
1414: -- invoke table handler(csi_transactions_pkg.update_row)
1415: csi_transactions_pkg.update_row(

Line 1436: IF fnd_api.to_boolean( p_commit )

1432: -- end of api body.
1433: --
1434:
1435: -- standard check for p_commit
1436: IF fnd_api.to_boolean( p_commit )
1437: THEN
1438: COMMIT WORK;
1439: END IF;
1440:

Line 1451: WHEN fnd_api.g_exc_error THEN

1447: p_data => x_msg_data
1448: );
1449:
1450: EXCEPTION
1451: WHEN fnd_api.g_exc_error THEN
1452: IF fnd_api.to_boolean(p_commit)
1453: THEN
1454: ROLLBACK TO update_transactions_pvt;
1455: END IF;

Line 1452: IF fnd_api.to_boolean(p_commit)

1448: );
1449:
1450: EXCEPTION
1451: WHEN fnd_api.g_exc_error THEN
1452: IF fnd_api.to_boolean(p_commit)
1453: THEN
1454: ROLLBACK TO update_transactions_pvt;
1455: END IF;
1456: x_return_status := fnd_api.g_ret_sts_error ;

Line 1456: x_return_status := fnd_api.g_ret_sts_error ;

1452: IF fnd_api.to_boolean(p_commit)
1453: THEN
1454: ROLLBACK TO update_transactions_pvt;
1455: END IF;
1456: x_return_status := fnd_api.g_ret_sts_error ;
1457: fnd_msg_pub.count_and_get
1458: (p_count => x_msg_count ,
1459: p_data => x_msg_data
1460: );

Line 1462: WHEN fnd_api.g_exc_unexpected_error THEN

1458: (p_count => x_msg_count ,
1459: p_data => x_msg_data
1460: );
1461:
1462: WHEN fnd_api.g_exc_unexpected_error THEN
1463: IF fnd_api.to_boolean(p_commit)
1464: THEN
1465: ROLLBACK TO update_transactions_pvt;
1466: END IF;

Line 1463: IF fnd_api.to_boolean(p_commit)

1459: p_data => x_msg_data
1460: );
1461:
1462: WHEN fnd_api.g_exc_unexpected_error THEN
1463: IF fnd_api.to_boolean(p_commit)
1464: THEN
1465: ROLLBACK TO update_transactions_pvt;
1466: END IF;
1467: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1467: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1463: IF fnd_api.to_boolean(p_commit)
1464: THEN
1465: ROLLBACK TO update_transactions_pvt;
1466: END IF;
1467: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1468: fnd_msg_pub.count_and_get
1469: (p_count => x_msg_count ,
1470: p_data => x_msg_data
1471: );

Line 1474: IF fnd_api.to_boolean(p_commit)

1470: p_data => x_msg_data
1471: );
1472:
1473: WHEN OTHERS THEN
1474: IF fnd_api.to_boolean(p_commit)
1475: THEN
1476: ROLLBACK TO update_transactions_pvt;
1477: END IF;
1478: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1478: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1474: IF fnd_api.to_boolean(p_commit)
1475: THEN
1476: ROLLBACK TO update_transactions_pvt;
1477: END IF;
1478: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1480: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
1481: END IF;
1482: fnd_msg_pub.count_and_get

Line 1496: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1492:
1493: PROCEDURE create_txn_error
1494: (
1495: p_api_version IN NUMBER,
1496: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1497: p_commit IN VARCHAR2 := fnd_api.g_false,
1498: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1499: p_txn_error_rec IN csi_datastructures_pub.transaction_error_rec,
1500: x_return_status OUT NOCOPY VARCHAR2,

Line 1497: p_commit IN VARCHAR2 := fnd_api.g_false,

1493: PROCEDURE create_txn_error
1494: (
1495: p_api_version IN NUMBER,
1496: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1497: p_commit IN VARCHAR2 := fnd_api.g_false,
1498: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1499: p_txn_error_rec IN csi_datastructures_pub.transaction_error_rec,
1500: x_return_status OUT NOCOPY VARCHAR2,
1501: x_msg_count OUT NOCOPY NUMBER,

Line 1498: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

1494: (
1495: p_api_version IN NUMBER,
1496: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1497: p_commit IN VARCHAR2 := fnd_api.g_false,
1498: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1499: p_txn_error_rec IN csi_datastructures_pub.transaction_error_rec,
1500: x_return_status OUT NOCOPY VARCHAR2,
1501: x_msg_count OUT NOCOPY NUMBER,
1502: x_msg_data OUT NOCOPY VARCHAR2,

Line 1513: IF fnd_api.to_boolean(p_commit)

1509: l_debug_level NUMBER;
1510:
1511: BEGIN
1512: -- standard start of api savepoint
1513: IF fnd_api.to_boolean(p_commit)
1514: THEN
1515: SAVEPOINT create_txn_error_pvt;
1516: END IF;
1517: -- standard call to check for call compatibility.

Line 1518: IF NOT fnd_api.compatible_api_call ( l_api_version,

1514: THEN
1515: SAVEPOINT create_txn_error_pvt;
1516: END IF;
1517: -- standard call to check for call compatibility.
1518: IF NOT fnd_api.compatible_api_call ( l_api_version,
1519: p_api_version,
1520: l_api_name,
1521: g_pkg_name)
1522: THEN

Line 1523: RAISE fnd_api.g_exc_unexpected_error;

1519: p_api_version,
1520: l_api_name,
1521: g_pkg_name)
1522: THEN
1523: RAISE fnd_api.g_exc_unexpected_error;
1524: END IF;
1525:
1526:
1527: -- initialize message list if p_init_msg_list is set to true.

Line 1528: IF fnd_api.to_boolean( p_init_msg_list )

1524: END IF;
1525:
1526:
1527: -- initialize message list if p_init_msg_list is set to true.
1528: IF fnd_api.to_boolean( p_init_msg_list )
1529: THEN
1530: fnd_msg_pub.initialize;
1531: END IF;
1532:

Line 1534: x_return_status := fnd_api.g_ret_sts_success;

1530: fnd_msg_pub.initialize;
1531: END IF;
1532:
1533: -- initialize api return status TO success
1534: x_return_status := fnd_api.g_ret_sts_success;
1535:
1536: /***** COMMENTED l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1537: IF (l_debug_level > 0) THEN
1538: CSI_gen_utility_pvt.put_line( 'create_txn_error');

Line 1553: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1549:
1550:
1551: END IF; **** END OF COMMENT *****/
1552:
1553: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1554: RAISE fnd_api.g_exc_error;
1555: END IF;
1556:
1557: /* End of addition for 11.5.10 */

Line 1554: RAISE fnd_api.g_exc_error;

1550:
1551: END IF; **** END OF COMMENT *****/
1552:
1553: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1554: RAISE fnd_api.g_exc_error;
1555: END IF;
1556:
1557: /* End of addition for 11.5.10 */
1558:

Line 1603: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1599: p_comms_nl_trackable_flag => p_txn_error_rec.comms_nl_trackable_flag);
1600: -- hint: primary key should be returned.
1601: -- x_transaction_error_id := px_transaction_error_id;
1602:
1603: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1604: RAISE fnd_api.g_exc_error;
1605: END IF;
1606:
1607: --

Line 1604: RAISE fnd_api.g_exc_error;

1600: -- hint: primary key should be returned.
1601: -- x_transaction_error_id := px_transaction_error_id;
1602:
1603: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1604: RAISE fnd_api.g_exc_error;
1605: END IF;
1606:
1607: --
1608: -- end of api body

Line 1612: IF fnd_api.to_boolean( p_commit )

1608: -- end of api body
1609: --
1610:
1611: -- standard check for p_commit
1612: IF fnd_api.to_boolean( p_commit )
1613: THEN
1614: COMMIT WORK;
1615: END IF;
1616:

Line 1624: WHEN fnd_api.g_exc_error THEN

1620: p_data => x_msg_data
1621: );
1622:
1623: EXCEPTION
1624: WHEN fnd_api.g_exc_error THEN
1625: IF fnd_api.to_boolean(p_commit)
1626: THEN
1627: ROLLBACK TO create_txn_error_pvt;
1628: END IF;

Line 1625: IF fnd_api.to_boolean(p_commit)

1621: );
1622:
1623: EXCEPTION
1624: WHEN fnd_api.g_exc_error THEN
1625: IF fnd_api.to_boolean(p_commit)
1626: THEN
1627: ROLLBACK TO create_txn_error_pvt;
1628: END IF;
1629: x_return_status := fnd_api.g_ret_sts_error ;

Line 1629: x_return_status := fnd_api.g_ret_sts_error ;

1625: IF fnd_api.to_boolean(p_commit)
1626: THEN
1627: ROLLBACK TO create_txn_error_pvt;
1628: END IF;
1629: x_return_status := fnd_api.g_ret_sts_error ;
1630: fnd_msg_pub.count_and_get
1631: (p_count => x_msg_count ,
1632: p_data => x_msg_data
1633: );

Line 1635: WHEN fnd_api.g_exc_unexpected_error THEN

1631: (p_count => x_msg_count ,
1632: p_data => x_msg_data
1633: );
1634:
1635: WHEN fnd_api.g_exc_unexpected_error THEN
1636: IF fnd_api.to_boolean(p_commit)
1637: THEN
1638: ROLLBACK TO create_txn_error_pvt;
1639: END IF;

Line 1636: IF fnd_api.to_boolean(p_commit)

1632: p_data => x_msg_data
1633: );
1634:
1635: WHEN fnd_api.g_exc_unexpected_error THEN
1636: IF fnd_api.to_boolean(p_commit)
1637: THEN
1638: ROLLBACK TO create_txn_error_pvt;
1639: END IF;
1640: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1640: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1636: IF fnd_api.to_boolean(p_commit)
1637: THEN
1638: ROLLBACK TO create_txn_error_pvt;
1639: END IF;
1640: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1641: fnd_msg_pub.count_and_get
1642: (p_count => x_msg_count ,
1643: p_data => x_msg_data
1644: );

Line 1647: IF fnd_api.to_boolean(p_commit)

1643: p_data => x_msg_data
1644: );
1645:
1646: WHEN OTHERS THEN
1647: IF fnd_api.to_boolean(p_commit)
1648: THEN
1649: ROLLBACK TO create_txn_error_pvt;
1650: END IF;
1651: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1651: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1647: IF fnd_api.to_boolean(p_commit)
1648: THEN
1649: ROLLBACK TO create_txn_error_pvt;
1650: END IF;
1651: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1652: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1653: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
1654: END IF;
1655: fnd_msg_pub.count_and_get

Line 1672: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1668: /* ---------------------------------------------------------------------------------- */
1669:
1670:
1671: PROCEDURE validate_transaction_id (
1672: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1673: p_validation_mode IN VARCHAR2,
1674: p_transaction_id IN NUMBER,
1675: x_return_status OUT NOCOPY VARCHAR2,
1676: x_msg_count OUT NOCOPY NUMBER,

Line 1683: IF fnd_api.to_boolean( p_init_msg_list )

1679: IS
1680: l_dummy VARCHAR2(1);
1681: BEGIN
1682: -- initialize message list if p_init_msg_list is set to true.
1683: IF fnd_api.to_boolean( p_init_msg_list )
1684: THEN
1685: fnd_msg_pub.initialize;
1686: END IF;
1687:

Line 1690: x_return_status := fnd_api.g_ret_sts_success;

1686: END IF;
1687:
1688:
1689: -- initialize api return status TO success
1690: x_return_status := fnd_api.g_ret_sts_success;
1691:
1692: -- validate not null column
1693:
1694: IF(p_validation_mode ='CREATE') THEN

Line 1695: x_return_status := fnd_api.g_ret_sts_success;

1691:
1692: -- validate not null column
1693:
1694: IF(p_validation_mode ='CREATE') THEN
1695: x_return_status := fnd_api.g_ret_sts_success;
1696: ELSIF(p_validation_mode = 'UPDATE') THEN
1697: IF ( (p_transaction_id IS NULL) OR (p_transaction_id = fnd_api.g_miss_num) ) THEN
1698: fnd_message.set_name('CSI', 'CSI_TXN_ID_NOT_PASSED');
1699: fnd_msg_pub.add;

Line 1697: IF ( (p_transaction_id IS NULL) OR (p_transaction_id = fnd_api.g_miss_num) ) THEN

1693:
1694: IF(p_validation_mode ='CREATE') THEN
1695: x_return_status := fnd_api.g_ret_sts_success;
1696: ELSIF(p_validation_mode = 'UPDATE') THEN
1697: IF ( (p_transaction_id IS NULL) OR (p_transaction_id = fnd_api.g_miss_num) ) THEN
1698: fnd_message.set_name('CSI', 'CSI_TXN_ID_NOT_PASSED');
1699: fnd_msg_pub.add;
1700: x_return_status := fnd_api.g_ret_sts_error;
1701: ELSE

Line 1700: x_return_status := fnd_api.g_ret_sts_error;

1696: ELSIF(p_validation_mode = 'UPDATE') THEN
1697: IF ( (p_transaction_id IS NULL) OR (p_transaction_id = fnd_api.g_miss_num) ) THEN
1698: fnd_message.set_name('CSI', 'CSI_TXN_ID_NOT_PASSED');
1699: fnd_msg_pub.add;
1700: x_return_status := fnd_api.g_ret_sts_error;
1701: ELSE
1702: BEGIN
1703: SELECT 'x'
1704: INTO l_dummy

Line 1712: x_return_status := fnd_api.g_ret_sts_error;

1708: WHEN no_data_found THEN
1709: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_ID');
1710: fnd_message.set_token('transaction_id',p_transaction_id);
1711: fnd_msg_pub.add;
1712: x_return_status := fnd_api.g_ret_sts_error;
1713: END;
1714: END IF;
1715: END IF;
1716:

Line 1732: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1728: /* ---------------------------------------------------------------------------------- */
1729:
1730:
1731: PROCEDURE validate_s_transaction_date (
1732: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1733: p_source_transaction_date IN DATE,
1734: x_return_status OUT NOCOPY VARCHAR2,
1735: x_msg_count OUT NOCOPY NUMBER,
1736: x_msg_data OUT NOCOPY VARCHAR2

Line 1741: IF fnd_api.to_boolean( p_init_msg_list )

1737: )
1738: IS
1739: BEGIN
1740: -- initialize message list if p_init_msg_list is set to true.
1741: IF fnd_api.to_boolean( p_init_msg_list )
1742: THEN
1743: fnd_msg_pub.initialize;
1744: END IF;
1745:

Line 1748: x_return_status := fnd_api.g_ret_sts_success;

1744: END IF;
1745:
1746:
1747: -- initialize api return status to success
1748: x_return_status := fnd_api.g_ret_sts_success;
1749:
1750: -- validate not null column
1751: IF ( (p_source_transaction_date IS NULL) OR (p_source_transaction_date = fnd_api.g_miss_date) ) THEN
1752: fnd_message.set_name('CSI', 'CSI_NO_TXN_DATE');

Line 1751: IF ( (p_source_transaction_date IS NULL) OR (p_source_transaction_date = fnd_api.g_miss_date) ) THEN

1747: -- initialize api return status to success
1748: x_return_status := fnd_api.g_ret_sts_success;
1749:
1750: -- validate not null column
1751: IF ( (p_source_transaction_date IS NULL) OR (p_source_transaction_date = fnd_api.g_miss_date) ) THEN
1752: fnd_message.set_name('CSI', 'CSI_NO_TXN_DATE');
1753: fnd_msg_pub.add;
1754: x_return_status := fnd_api.g_ret_sts_error;
1755: END IF;

Line 1754: x_return_status := fnd_api.g_ret_sts_error;

1750: -- validate not null column
1751: IF ( (p_source_transaction_date IS NULL) OR (p_source_transaction_date = fnd_api.g_miss_date) ) THEN
1752: fnd_message.set_name('CSI', 'CSI_NO_TXN_DATE');
1753: fnd_msg_pub.add;
1754: x_return_status := fnd_api.g_ret_sts_error;
1755: END IF;
1756:
1757: -- standard call to get message count and if count is 1, get message info.
1758: fnd_msg_pub.count_and_get

Line 1773: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1769: /* --- 2. for not null check for the exsistence in the csi_txn_types table --- */
1770: /* ---------------------------------------------------------------------------------- */
1771:
1772: PROCEDURE validate_transaction_type_id (
1773: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1774: p_transaction_type_id IN NUMBER,
1775: x_return_status OUT NOCOPY VARCHAR2,
1776: x_msg_count OUT NOCOPY NUMBER,
1777: x_msg_data OUT NOCOPY VARCHAR2

Line 1783: IF fnd_api.to_boolean( p_init_msg_list )

1779: IS
1780: l_dummy VARCHAR2(1);
1781: BEGIN
1782: -- initialize message list if p_init_msg_list is set to true.
1783: IF fnd_api.to_boolean( p_init_msg_list )
1784: THEN
1785: fnd_msg_pub.initialize;
1786: END IF;
1787:

Line 1790: x_return_status := fnd_api.g_ret_sts_success;

1786: END IF;
1787:
1788:
1789: -- initialize api return status to success
1790: x_return_status := fnd_api.g_ret_sts_success;
1791:
1792: -- validate not null column
1793:
1794: IF ( (p_transaction_type_id IS NULL) OR (p_transaction_type_id = fnd_api.g_miss_num) ) THEN

Line 1794: IF ( (p_transaction_type_id IS NULL) OR (p_transaction_type_id = fnd_api.g_miss_num) ) THEN

1790: x_return_status := fnd_api.g_ret_sts_success;
1791:
1792: -- validate not null column
1793:
1794: IF ( (p_transaction_type_id IS NULL) OR (p_transaction_type_id = fnd_api.g_miss_num) ) THEN
1795: fnd_message.set_name('CSI', 'CSI_NO_TXN_TYPE_ID');
1796: fnd_msg_pub.add;
1797: x_return_status := fnd_api.g_ret_sts_error;
1798: ELSE

Line 1797: x_return_status := fnd_api.g_ret_sts_error;

1793:
1794: IF ( (p_transaction_type_id IS NULL) OR (p_transaction_type_id = fnd_api.g_miss_num) ) THEN
1795: fnd_message.set_name('CSI', 'CSI_NO_TXN_TYPE_ID');
1796: fnd_msg_pub.add;
1797: x_return_status := fnd_api.g_ret_sts_error;
1798: ELSE
1799: BEGIN
1800: SELECT 'x'
1801: INTO l_dummy

Line 1809: x_return_status := fnd_api.g_ret_sts_error;

1805: EXCEPTION
1806: WHEN no_data_found THEN
1807: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_TYPE_ID');
1808: fnd_msg_pub.add;
1809: x_return_status := fnd_api.g_ret_sts_error;
1810: END;
1811: END IF;
1812: -- standard call to get message count and if count is 1, get message info.
1813: fnd_msg_pub.count_and_get

Line 1827: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1823: /* --- 2. check for existence of a record if not exsist then return error --- */
1824: /* ---------------------------------------------------------------------------------- */
1825:
1826: PROCEDURE validate_source_object (
1827: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1828: p_transaction_type_id IN NUMBER,
1829: p_source_line_ref_id IN NUMBER,
1830: x_return_status OUT NOCOPY VARCHAR2,
1831: x_msg_count OUT NOCOPY NUMBER,

Line 1857: IF fnd_api.to_boolean( p_init_msg_list )

1853: l_object_name VARCHAR2(80);
1854: l_object_id NUMBER;
1855: BEGIN
1856: -- initialize message list if p_init_msg_list is set to true.
1857: IF fnd_api.to_boolean( p_init_msg_list )
1858: THEN
1859: fnd_msg_pub.initialize;
1860: END IF;
1861:

Line 1864: x_return_status := fnd_api.g_ret_sts_success;

1860: END IF;
1861:
1862:
1863: -- initialize api return status to success
1864: x_return_status := fnd_api.g_ret_sts_success;
1865: BEGIN
1866: BEGIN
1867: IF ( (p_source_line_ref_id IS NOT NULL) AND (p_source_line_ref_id <> fnd_api.g_miss_num) ) THEN
1868: l_flag:='t';

Line 1867: IF ( (p_source_line_ref_id IS NOT NULL) AND (p_source_line_ref_id <> fnd_api.g_miss_num) ) THEN

1863: -- initialize api return status to success
1864: x_return_status := fnd_api.g_ret_sts_success;
1865: BEGIN
1866: BEGIN
1867: IF ( (p_source_line_ref_id IS NOT NULL) AND (p_source_line_ref_id <> fnd_api.g_miss_num) ) THEN
1868: l_flag:='t';
1869: END IF;
1870: SELECT source_object_code
1871: INTO l_source_code

Line 1891: x_return_status := fnd_api.g_ret_sts_error;

1887: IF c_ref_csr%notfound
1888: THEN
1889: fnd_message.set_name ('CSI', 'CSI_INVALID_OBJECT_CODE');
1890: fnd_msg_pub.add;
1891: x_return_status := fnd_api.g_ret_sts_error;
1892: END IF;
1893:
1894: IF x_return_status <> fnd_api.g_ret_sts_error THEN
1895: IF(l_where_clause IS NULL) THEN

Line 1894: IF x_return_status <> fnd_api.g_ret_sts_error THEN

1890: fnd_msg_pub.add;
1891: x_return_status := fnd_api.g_ret_sts_error;
1892: END IF;
1893:
1894: IF x_return_status <> fnd_api.g_ret_sts_error THEN
1895: IF(l_where_clause IS NULL) THEN
1896: l_where_clause := ' WHERE ';
1897: ELSE
1898: l_where_clause := l_where_clause || ' AND ';

Line 1923: x_return_status := fnd_api.g_ret_sts_error;

1919: EXCEPTION
1920: WHEN no_data_found THEN
1921: fnd_message.set_name('CSI', 'CSI_REF_NOT_FOUND');
1922: fnd_msg_pub.add;
1923: x_return_status := fnd_api.g_ret_sts_error;
1924:
1925: END;
1926: END;
1927:

Line 1945: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1941: /* ---------------------------------------------------------------------------------- */
1942:
1943:
1944: PROCEDURE validate_object_version_num (
1945: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1946: p_validation_mode IN VARCHAR2,
1947: p_object_version_number IN NUMBER,
1948: x_return_status OUT NOCOPY VARCHAR2,
1949: x_msg_count OUT NOCOPY NUMBER,

Line 1956: IF fnd_api.to_boolean( p_init_msg_list )

1952: IS
1953: l_dummy VARCHAR2(1);
1954: BEGIN
1955: -- initialize message list if p_init_msg_list is set to true.
1956: IF fnd_api.to_boolean( p_init_msg_list )
1957: THEN
1958: fnd_msg_pub.initialize;
1959: END IF;
1960:

Line 1963: x_return_status := fnd_api.g_ret_sts_success;

1959: END IF;
1960:
1961:
1962: -- initialize api return status to success
1963: x_return_status := fnd_api.g_ret_sts_success;
1964:
1965: IF(p_validation_mode = 'UPDATE') THEN
1966: IF ( (p_object_version_number IS NULL) OR (p_object_version_number = fnd_api.g_miss_num) ) THEN
1967: fnd_message.set_name('CSI', 'CSI_MISSING_OBJ_VER_NUM');

Line 1966: IF ( (p_object_version_number IS NULL) OR (p_object_version_number = fnd_api.g_miss_num) ) THEN

1962: -- initialize api return status to success
1963: x_return_status := fnd_api.g_ret_sts_success;
1964:
1965: IF(p_validation_mode = 'UPDATE') THEN
1966: IF ( (p_object_version_number IS NULL) OR (p_object_version_number = fnd_api.g_miss_num) ) THEN
1967: fnd_message.set_name('CSI', 'CSI_MISSING_OBJ_VER_NUM');
1968: fnd_msg_pub.add;
1969: x_return_status := fnd_api.g_ret_sts_error;
1970: END IF;

Line 1969: x_return_status := fnd_api.g_ret_sts_error;

1965: IF(p_validation_mode = 'UPDATE') THEN
1966: IF ( (p_object_version_number IS NULL) OR (p_object_version_number = fnd_api.g_miss_num) ) THEN
1967: fnd_message.set_name('CSI', 'CSI_MISSING_OBJ_VER_NUM');
1968: fnd_msg_pub.add;
1969: x_return_status := fnd_api.g_ret_sts_error;
1970: END IF;
1971: END IF;
1972:
1973: -- standard call to get message count and if count is 1, get message info.

Line 1987: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1983: /* --- the split_reason_code passed --- */
1984: /* ---------------------------------------------------------------------------------- */
1985:
1986: PROCEDURE validate_split_code (
1987: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1988: p_split_reason_code IN VARCHAR2,
1989: x_return_status OUT NOCOPY VARCHAR2,
1990: x_msg_count OUT NOCOPY NUMBER ,
1991: x_msg_data OUT NOCOPY VARCHAR2

Line 1997: IF fnd_api.to_boolean( p_init_msg_list )

1993: IS
1994: l_dummy VARCHAR2(1);
1995: BEGIN
1996: -- initialize message list if p_init_msg_list is set to true.
1997: IF fnd_api.to_boolean( p_init_msg_list )
1998: THEN
1999: fnd_msg_pub.initialize;
2000: END IF;
2001:

Line 2004: x_return_status := fnd_api.g_ret_sts_success;

2000: END IF;
2001:
2002:
2003: -- initialize api return status to success
2004: x_return_status := fnd_api.g_ret_sts_success;
2005:
2006: -- validate not null column
2007:
2008: IF ( (p_split_reason_code IS NOT NULL) AND (p_split_reason_code <> fnd_api.g_miss_char) ) THEN

Line 2008: IF ( (p_split_reason_code IS NOT NULL) AND (p_split_reason_code <> fnd_api.g_miss_char) ) THEN

2004: x_return_status := fnd_api.g_ret_sts_success;
2005:
2006: -- validate not null column
2007:
2008: IF ( (p_split_reason_code IS NOT NULL) AND (p_split_reason_code <> fnd_api.g_miss_char) ) THEN
2009: BEGIN
2010: SELECT 'x'
2011: INTO l_dummy
2012: FROM csi_lookups

Line 2019: x_return_status := fnd_api.g_ret_sts_error;

2015: EXCEPTION
2016: WHEN no_data_found THEN
2017: fnd_message.set_name('CSI', 'CSI_INVALID_REASON_CODE');
2018: fnd_msg_pub.add;
2019: x_return_status := fnd_api.g_ret_sts_error;
2020: END;
2021: END IF;
2022: -- standard call to get message count and if count is 1, get message info.
2023: fnd_msg_pub.count_and_get

Line 2040: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2036:
2037:
2038:
2039: PROCEDURE validate_transactions(
2040: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2041: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2042: p_validation_mode IN VARCHAR2,
2043: p_transaction_rec IN csi_datastructures_pub.transaction_rec,
2044: x_return_status OUT NOCOPY VARCHAR2,

Line 2041: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

2037:
2038:
2039: PROCEDURE validate_transactions(
2040: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2041: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2042: p_validation_mode IN VARCHAR2,
2043: p_transaction_rec IN csi_datastructures_pub.transaction_rec,
2044: x_return_status OUT NOCOPY VARCHAR2,
2045: x_msg_count OUT NOCOPY NUMBER,

Line 2052: x_return_status := fnd_api.g_ret_sts_success;

2048: IS
2049: l_api_name CONSTANT VARCHAR2(30) := 'validate_transactions';
2050: BEGIN
2051: -- initialize api return status to success
2052: x_return_status := fnd_api.g_ret_sts_success;
2053: IF (p_validation_level >= fnd_api.g_valid_level_full) THEN
2054: validate_transaction_id(
2055: p_init_msg_list => fnd_api.g_false,
2056: p_validation_mode => p_validation_mode,

Line 2053: IF (p_validation_level >= fnd_api.g_valid_level_full) THEN

2049: l_api_name CONSTANT VARCHAR2(30) := 'validate_transactions';
2050: BEGIN
2051: -- initialize api return status to success
2052: x_return_status := fnd_api.g_ret_sts_success;
2053: IF (p_validation_level >= fnd_api.g_valid_level_full) THEN
2054: validate_transaction_id(
2055: p_init_msg_list => fnd_api.g_false,
2056: p_validation_mode => p_validation_mode,
2057: p_transaction_id => p_transaction_rec.transaction_id,

Line 2055: p_init_msg_list => fnd_api.g_false,

2051: -- initialize api return status to success
2052: x_return_status := fnd_api.g_ret_sts_success;
2053: IF (p_validation_level >= fnd_api.g_valid_level_full) THEN
2054: validate_transaction_id(
2055: p_init_msg_list => fnd_api.g_false,
2056: p_validation_mode => p_validation_mode,
2057: p_transaction_id => p_transaction_rec.transaction_id,
2058: x_return_status => x_return_status,
2059: x_msg_count => x_msg_count,

Line 2061: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2057: p_transaction_id => p_transaction_rec.transaction_id,
2058: x_return_status => x_return_status,
2059: x_msg_count => x_msg_count,
2060: x_msg_data => x_msg_data);
2061: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2062: RAISE fnd_api.g_exc_error;
2063: END IF;
2064:
2065:

Line 2062: RAISE fnd_api.g_exc_error;

2058: x_return_status => x_return_status,
2059: x_msg_count => x_msg_count,
2060: x_msg_data => x_msg_data);
2061: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2062: RAISE fnd_api.g_exc_error;
2063: END IF;
2064:
2065:
2066: validate_s_transaction_date(

Line 2067: p_init_msg_list => fnd_api.g_false,

2063: END IF;
2064:
2065:
2066: validate_s_transaction_date(
2067: p_init_msg_list => fnd_api.g_false,
2068: p_source_transaction_date => p_transaction_rec.source_transaction_date,
2069: x_return_status => x_return_status,
2070: x_msg_count => x_msg_count,
2071: x_msg_data => x_msg_data);

Line 2072: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2068: p_source_transaction_date => p_transaction_rec.source_transaction_date,
2069: x_return_status => x_return_status,
2070: x_msg_count => x_msg_count,
2071: x_msg_data => x_msg_data);
2072: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2073: RAISE fnd_api.g_exc_error;
2074: END IF;
2075:
2076: validate_transaction_type_id(

Line 2073: RAISE fnd_api.g_exc_error;

2069: x_return_status => x_return_status,
2070: x_msg_count => x_msg_count,
2071: x_msg_data => x_msg_data);
2072: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2073: RAISE fnd_api.g_exc_error;
2074: END IF;
2075:
2076: validate_transaction_type_id(
2077: p_init_msg_list => fnd_api.g_false,

Line 2077: p_init_msg_list => fnd_api.g_false,

2073: RAISE fnd_api.g_exc_error;
2074: END IF;
2075:
2076: validate_transaction_type_id(
2077: p_init_msg_list => fnd_api.g_false,
2078: p_transaction_type_id => p_transaction_rec.transaction_type_id,
2079: x_return_status => x_return_status,
2080: x_msg_count => x_msg_count,
2081: x_msg_data => x_msg_data);

Line 2082: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2078: p_transaction_type_id => p_transaction_rec.transaction_type_id,
2079: x_return_status => x_return_status,
2080: x_msg_count => x_msg_count,
2081: x_msg_data => x_msg_data);
2082: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2083: RAISE fnd_api.g_exc_error;
2084: END IF;
2085:
2086: validate_source_object(

Line 2083: RAISE fnd_api.g_exc_error;

2079: x_return_status => x_return_status,
2080: x_msg_count => x_msg_count,
2081: x_msg_data => x_msg_data);
2082: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2083: RAISE fnd_api.g_exc_error;
2084: END IF;
2085:
2086: validate_source_object(
2087: p_init_msg_list => fnd_api.g_false,

Line 2087: p_init_msg_list => fnd_api.g_false,

2083: RAISE fnd_api.g_exc_error;
2084: END IF;
2085:
2086: validate_source_object(
2087: p_init_msg_list => fnd_api.g_false,
2088: p_transaction_type_id => p_transaction_rec.transaction_type_id,
2089: p_source_line_ref_id => p_transaction_rec.source_line_ref_id,
2090: x_return_status => x_return_status,
2091: x_msg_count => x_msg_count,

Line 2093: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2089: p_source_line_ref_id => p_transaction_rec.source_line_ref_id,
2090: x_return_status => x_return_status,
2091: x_msg_count => x_msg_count,
2092: x_msg_data => x_msg_data);
2093: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2094: RAISE fnd_api.g_exc_error;
2095: END IF;
2096:
2097:

Line 2094: RAISE fnd_api.g_exc_error;

2090: x_return_status => x_return_status,
2091: x_msg_count => x_msg_count,
2092: x_msg_data => x_msg_data);
2093: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2094: RAISE fnd_api.g_exc_error;
2095: END IF;
2096:
2097:
2098: validate_split_code(

Line 2099: p_init_msg_list => fnd_api.g_false,

2095: END IF;
2096:
2097:
2098: validate_split_code(
2099: p_init_msg_list => fnd_api.g_false,
2100: p_split_reason_code => p_transaction_rec.split_reason_code,
2101: x_return_status => x_return_status,
2102: x_msg_count => x_msg_count,
2103: x_msg_data => x_msg_data);

Line 2104: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2100: p_split_reason_code => p_transaction_rec.split_reason_code,
2101: x_return_status => x_return_status,
2102: x_msg_count => x_msg_count,
2103: x_msg_data => x_msg_data);
2104: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2105: RAISE fnd_api.g_exc_error;
2106: END IF;
2107:
2108:

Line 2105: RAISE fnd_api.g_exc_error;

2101: x_return_status => x_return_status,
2102: x_msg_count => x_msg_count,
2103: x_msg_data => x_msg_data);
2104: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2105: RAISE fnd_api.g_exc_error;
2106: END IF;
2107:
2108:
2109: END IF;