[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
235: , 'Insert record into temp table'
236: );
237: END IF;
238:
239: INSERT INTO inv_mvt_excep_rep_temp
240: ( error_type
241: , error_name
242: , inventory_item_id
243: , item_code
275: ------already exists in temp table
276:
277: SELECT COUNT(*)
278: INTO l_count
279: FROM inv_mvt_excep_rep_temp
280: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
281: AND error_name=l_error_name
282: AND column_name='COMMODITY_CODE';
283:
299: );
300: END IF;
301:
302: ------update mode
303: UPDATE inv_mvt_excep_rep_temp
304: SET number_of_records=number_of_records+1
305: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
306: AND error_name=l_error_name
307: AND column_name='COMMODITY_CODE';
341: 'item_id='||p_mtl_movement_transaction.inventory_item_id
342: );
343: END IF;
344:
345: INSERT INTO inv_mvt_excep_rep_temp
346: ( error_type
347: , error_name
348: , inventory_item_id
349: , item_code
434: , 'Insert record into temp table:'
435: );
436: END IF;
437:
438: INSERT INTO inv_mvt_excep_rep_temp
439: ( error_type
440: , error_name
441: , inventory_item_id
442: , item_code
474: ------already exists in temp table
475:
476: SELECT COUNT(*)
477: INTO l_count
478: FROM inv_mvt_excep_rep_temp
479: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
480: AND error_name=l_error_name;
481:
482: IF l_count>0
489: );
490: END IF;
491:
492: ------update mode
493: UPDATE inv_mvt_excep_rep_temp
494: SET number_of_records=number_of_records+1
495: WHERE inventory_item_id=p_mtl_movement_transaction.inventory_item_id
496: AND error_name=l_error_name;
497:
504: , 'Insert record into temp table:'
505: );
506: END IF;
507:
508: INSERT INTO inv_mvt_excep_rep_temp
509: ( error_type
510: , error_name
511: , inventory_item_id
512: , item_code
578: END IF;
579:
580: SELECT COUNT(*)
581: INTO l_count
582: FROM inv_mvt_excep_rep_temp
583: WHERE from_currency_code=p_mtl_movement_transaction.currency_code
584: AND error_name=l_error_name;
585:
586: IF l_count>0
593: );
594: END IF;
595:
596: ------update mode
597: UPDATE inv_mvt_excep_rep_temp
598: SET number_of_records=number_of_records+1
599: WHERE from_currency_code=p_mtl_movement_transaction.currency_code
600: AND error_name=l_error_name;
601:
608: , 'Insert record into temp table:'
609: );
610: END IF;
611:
612: INSERT INTO inv_mvt_excep_rep_temp
613: ( error_type
614: , error_name
615: , inventory_item_id
616: , item_code
709: ------already exists in temp table
710:
711: SELECT COUNT(*)
712: INTO l_count
713: FROM inv_mvt_excep_rep_temp
714: WHERE tp_name=l_tp_name
715: AND tp_type=l_tp_type
716: AND column_name='PARTNER_VAT_NUMBER'
717: AND error_name=l_error_name;
726: );
727: END IF;
728:
729: ------update mode
730: UPDATE inv_mvt_excep_rep_temp
731: SET number_of_records=number_of_records+1
732: WHERE tp_name=l_tp_name
733: AND tp_type=l_tp_type
734: AND column_name='PARTNER_VAT_NUMBER'
743: , 'Insert record into temp table, error_name='||l_error_name
744: );
745: END IF;
746:
747: INSERT INTO inv_mvt_excep_rep_temp
748: ( error_type
749: , error_name
750: , inventory_item_id
751: , item_code
902: , 'Insert record into temp table:'
903: );
904: END IF;
905:
906: INSERT INTO inv_mvt_excep_rep_temp
907: ( error_type
908: , error_name
909: , inventory_item_id
910: , item_code