[Home] [Help]
46: --
47: --PARAMETERS: p_excp_list IN
48: -- p_mtl_movement_transaction IN
49: --
50: -- COMMENT : Procedure populates temp table INV_MVT_EXCEP_REP_TEMP with
51: -- data, that is printed in Exception Report
52: --=======================================================================
53: PROCEDURE Populate_temp_table
54: ( p_excp_list IN INV_MGD_MVT_DATA_STR.EXCP_LIST
118: ,'Insert record into temp table'
119: );
120: END IF;
121:
122: INSERT INTO inv_mvt_excep_rep_temp
123: ( error_type
124: , error_name
125: , inventory_item_id
126: , item_code
244: , 'Insert record into temp table'
245: );
246: END IF;
247:
248: INSERT INTO inv_mvt_excep_rep_temp
249: ( error_type
250: , error_name
251: , inventory_item_id
252: , item_code
284: ------already exists in temp table
285:
286: SELECT COUNT(*)
287: INTO l_count
288: FROM inv_mvt_excep_rep_temp
289: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
290: AND error_name=l_error_name
291: AND column_name='COMMODITY_CODE';
292:
308: );
309: END IF;
310:
311: ------update mode
312: UPDATE inv_mvt_excep_rep_temp
313: SET number_of_records=number_of_records+1
314: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
315: AND error_name=l_error_name
316: AND column_name='COMMODITY_CODE';
350: 'item_id='||p_mtl_movement_transaction.inventory_item_id
351: );
352: END IF;
353:
354: INSERT INTO inv_mvt_excep_rep_temp
355: ( error_type
356: , error_name
357: , inventory_item_id
358: , item_code
452: , 'Insert record into temp table:'
453: );
454: END IF;
455:
456: INSERT INTO inv_mvt_excep_rep_temp
457: ( error_type
458: , error_name
459: , inventory_item_id
460: , item_code
492: ------already exists in temp table
493:
494: SELECT COUNT(*)
495: INTO l_count
496: FROM inv_mvt_excep_rep_temp
497: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
498: AND error_name=l_error_name;
499:
500: IF l_count>0
507: );
508: END IF;
509:
510: ------update mode
511: UPDATE inv_mvt_excep_rep_temp
512: SET number_of_records=number_of_records+1
513: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
514: AND error_name=l_error_name;
515:
522: , 'Insert record into temp table:'
523: );
524: END IF;
525:
526: INSERT INTO inv_mvt_excep_rep_temp
527: ( error_type
528: , error_name
529: , inventory_item_id
530: , item_code
596: END IF;
597:
598: SELECT COUNT(*)
599: INTO l_count
600: FROM inv_mvt_excep_rep_temp
601: WHERE from_currency_code=p_mtl_movement_transaction.currency_code
602: AND error_name=l_error_name;
603:
604: IF l_count>0
611: );
612: END IF;
613:
614: ------update mode
615: UPDATE inv_mvt_excep_rep_temp
616: SET number_of_records=number_of_records+1
617: WHERE from_currency_code=p_mtl_movement_transaction.currency_code
618: AND error_name=l_error_name;
619:
626: , 'Insert record into temp table:'
627: );
628: END IF;
629:
630: INSERT INTO inv_mvt_excep_rep_temp
631: ( error_type
632: , error_name
633: , inventory_item_id
634: , item_code
727: ------already exists in temp table
728:
729: SELECT COUNT(*)
730: INTO l_count
731: FROM inv_mvt_excep_rep_temp
732: WHERE tp_name=l_tp_name
733: AND tp_type=l_tp_type
734: AND column_name='PARTNER_VAT_NUMBER'
735: AND error_name=l_error_name;
744: );
745: END IF;
746:
747: ------update mode
748: UPDATE inv_mvt_excep_rep_temp
749: SET number_of_records=number_of_records+1
750: WHERE tp_name=l_tp_name
751: AND tp_type=l_tp_type
752: AND column_name='PARTNER_VAT_NUMBER'
761: , 'Insert record into temp table, error_name='||l_error_name
762: );
763: END IF;
764:
765: INSERT INTO inv_mvt_excep_rep_temp
766: ( error_type
767: , error_name
768: , inventory_item_id
769: , item_code
920: , 'Insert record into temp table:'
921: );
922: END IF;
923:
924: INSERT INTO inv_mvt_excep_rep_temp
925: ( error_type
926: , error_name
927: , inventory_item_id
928: , item_code