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_INV_TRXS_PKG dependencies on CSI_ITEM_INSTANCE_PUB

Line 372: csi_item_instance_pub.get_item_instances(l_api_version,

368: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec => l_instance_query_rec);
369:
370: debug('Calling get_item_instance');
371:
372: csi_item_instance_pub.get_item_instances(l_api_version,
373: l_commit,
374: l_init_msg_list,
375: l_validation_level,
376: l_instance_query_rec,

Line 397: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

393:
394: -- Check for any errors and add them to the message stack to pass out to be put into the
395: -- error log table.
396: IF NOT l_return_status = l_fnd_success then
397: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
398: l_msg_index := 1;
399: WHILE l_msg_count > 0 loop
400: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
401: l_msg_index := l_msg_index + 1;

Line 445: csi_item_instance_pub.create_item_instance(l_api_version,

441: debug('Instance_status_id Value: '||nvl(l_new_instance_rec.instance_status_id,-1));
442: debug('You will now Create a new Item Instance Record');
443: debug('Serial Number: '||l_new_instance_rec.serial_number);
444:
445: csi_item_instance_pub.create_item_instance(l_api_version,
446: l_commit,
447: l_init_msg_list,
448: l_validation_level,
449: l_new_instance_rec,

Line 464: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

460:
461: -- Check for any errors and add them to the message stack to pass out to be put into the
462: -- error log table.
463: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
464: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
465: l_msg_index := 1;
466: WHILE l_msg_count > 0 loop
467: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
468: l_msg_index := l_msg_index + 1;

Line 527: csi_item_instance_pub.update_item_instance(l_api_version,

523: END IF;
524:
525: debug('Before Update Item Instance');
526:
527: csi_item_instance_pub.update_item_instance(l_api_version,
528: l_commit,
529: l_init_msg_list,
530: l_validation_level,
531: l_update_instance_rec,

Line 554: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

550:
551: -- Check for any errors and add them to the message stack to pass out to be put into the
552: -- error log table.
553: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
554: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
555: l_msg_index := 1;
556: WHILE l_msg_count > 0 loop
557: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
558: l_msg_index := l_msg_index + 1;

Line 655: csi_item_instance_pub.get_item_instance_details

651: -- Instance.
652:
653: l_instance_header_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
654: -- Call details to get Party Information
655: csi_item_instance_pub.get_item_instance_details
656: (l_api_version,
657: l_commit,
658: l_init_msg_list,
659: l_validation_level,

Line 765: csi_item_instance_pub.update_item_instance(l_api_version,

761: END IF;
762:
763: debug('Before Update Item Instance');
764:
765: csi_item_instance_pub.update_item_instance(l_api_version,
766: l_commit,
767: l_init_msg_list,
768: l_validation_level,
769: l_update_instance_rec,

Line 791: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

787: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
788:
789: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
790: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
791: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
792: l_msg_index := 1;
793: WHILE l_msg_count > 0 loop
794: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
795: l_msg_index := l_msg_index + 1;

Line 854: csi_item_instance_pub.create_item_instance(l_api_version,

850: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
851:
852: debug('You will now Create a new Item Instance Record');
853:
854: csi_item_instance_pub.create_item_instance(l_api_version,
855: l_commit,
856: l_init_msg_list,
857: l_validation_level,
858: l_new_instance_rec,

Line 873: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

869:
870: -- Check for any errors and add them to the message stack to pass out to be put into the
871: -- error log table.
872: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
873: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
874: l_msg_index := 1;
875: WHILE l_msg_count > 0 loop
876: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
877: l_msg_index := l_msg_index + 1;

Line 905: csi_item_instance_pub.get_item_instances(l_api_version,

901:
902:
903: debug('Calling get_item_instance');
904:
905: csi_item_instance_pub.get_item_instances(l_api_version,
906: l_commit,
907: l_init_msg_list,
908: l_validation_level,
909: l_instance_query_rec,

Line 930: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

926:
927: -- Check for any errors and add them to the message stack to pass out to be put into the
928: -- error log table.
929: IF NOT l_return_status = l_fnd_success then
930: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
931: l_msg_index := 1;
932: WHILE l_msg_count > 0 loop
933: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
934: l_msg_index := l_msg_index + 1;

Line 975: csi_item_instance_pub.create_item_instance(l_api_version,

971: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
972:
973: debug('You will now Create a new Item Instance Record');
974:
975: csi_item_instance_pub.create_item_instance(l_api_version,
976: l_commit,
977: l_init_msg_list,
978: l_validation_level,
979: l_new_instance_rec,

Line 994: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

990:
991: -- Check for any errors and add them to the message stack to pass out to be put into the
992: -- error log table.
993: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
994: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
995: l_msg_index := 1;
996: WHILE l_msg_count > 0 loop
997: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
998: l_msg_index := l_msg_index + 1;

Line 1040: csi_item_instance_pub.update_item_instance(l_api_version,

1036: END IF;
1037:
1038: debug('Before Update Item Instance');
1039:
1040: csi_item_instance_pub.update_item_instance(l_api_version,
1041: l_commit,
1042: l_init_msg_list,
1043: l_validation_level,
1044: l_update_instance_rec,

Line 1066: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

1062:
1063: -- Check for any errors and add them to the message stack to pass out to be put into the
1064: -- error log table.
1065: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1066: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1067: l_msg_index := 1;
1068: WHILE l_msg_count > 0 loop
1069: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1070: l_msg_index := l_msg_index + 1;

Line 1454: csi_item_instance_pub.get_item_instances(l_api_version,

1450: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec => l_instance_query_rec);
1451:
1452: debug('Before Get Item Instance');
1453:
1454: csi_item_instance_pub.get_item_instances(l_api_version,
1455: l_commit,
1456: l_init_msg_list,
1457: l_validation_level,
1458: l_instance_query_rec,

Line 1479: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

1475:
1476: -- Check for any errors and add them to the message stack to pass out to be put into the
1477: -- error log table.
1478: IF NOT l_return_status = l_fnd_success then
1479: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1480: l_msg_index := 1;
1481: WHILE l_msg_count > 0 loop
1482: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1483: l_msg_index := l_msg_index + 1;

Line 1529: csi_item_instance_pub.create_item_instance(l_api_version,

1525: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1526:
1527: debug('Before Create of new source Item Instance');
1528:
1529: csi_item_instance_pub.create_item_instance(l_api_version,
1530: l_commit,
1531: l_init_msg_list,
1532: l_validation_level,
1533: l_new_instance_rec,

Line 1552: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

1548:
1549: -- Check for any errors and add them to the message stack to pass out to be put into the
1550: -- error log table.
1551: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1552: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
1553: l_msg_index := 1;
1554: WHILE l_msg_count > 0 loop
1555: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1556: l_msg_index := l_msg_index + 1;

Line 1611: csi_item_instance_pub.update_item_instance(l_api_version,

1607:
1608: debug('Right after setting instance status');
1609: debug('Before Update item instance');
1610:
1611: csi_item_instance_pub.update_item_instance(l_api_version,
1612: l_commit,
1613: l_init_msg_list,
1614: l_validation_level,
1615: l_update_instance_rec,

Line 1636: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

1632:
1633: -- Check for any errors and add them to the message stack to pass out to be put into the
1634: -- error log table.
1635: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1636: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1637: debug('Message Count: '||l_msg_count);
1638: debug('Return Status: '||l_return_status);
1639: l_msg_index := 1;
1640: WHILE l_msg_count > 0 loop

Line 1735: csi_item_instance_pub.get_item_instance_details

1731: -- Instance.
1732:
1733: l_instance_header_rec.instance_id := l_src_instance_header_tbl(i).instance_id;
1734: -- Call details to get Party Information
1735: csi_item_instance_pub.get_item_instance_details
1736: (l_api_version,
1737: l_commit,
1738: l_init_msg_list,
1739: l_validation_level,

Line 1840: csi_item_instance_pub.update_item_instance(l_api_version,

1836:
1837: debug('Right after setting instance status');
1838: debug('Before Update item instance');
1839:
1840: csi_item_instance_pub.update_item_instance(l_api_version,
1841: l_commit,
1842: l_init_msg_list,
1843: l_validation_level,
1844: l_update_instance_rec,

Line 1866: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

1862: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
1863:
1864: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
1865: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
1866: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
1867: debug('Message Count: '||l_msg_count);
1868: debug('Return Status: '||l_return_status);
1869: l_msg_index := 1;
1870: WHILE l_msg_count > 0 loop

Line 1918: csi_item_instance_pub.get_item_instances(l_api_version,

1914:
1915:
1916: debug('Before Get Item Instance');
1917:
1918: csi_item_instance_pub.get_item_instances(l_api_version,
1919: l_commit,
1920: l_init_msg_list,
1921: l_validation_level,
1922: l_instance_query_rec,

Line 1943: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);

1939:
1940: -- Check for any errors and add them to the message stack to pass out to be put into the
1941: -- error log table.
1942: IF NOT l_return_status = l_fnd_success then
1943: debug('You encountered an error in the csi_item_instance_pub.get_item_instance API '||l_msg_data);
1944: l_msg_index := 1;
1945: WHILE l_msg_count > 0 loop
1946: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
1947: l_msg_index := l_msg_index + 1;

Line 1990: csi_item_instance_pub.create_item_instance(l_api_version,

1986: l_new_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
1987:
1988: debug('Before Create of new source Item Instance');
1989:
1990: csi_item_instance_pub.create_item_instance(l_api_version,
1991: l_commit,
1992: l_init_msg_list,
1993: l_validation_level,
1994: l_new_instance_rec,

Line 2013: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

2009:
2010: -- Check for any errors and add them to the message stack to pass out to be put into the
2011: -- error log table.
2012: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2013: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2014: l_msg_index := 1;
2015: WHILE l_msg_count > 0 loop
2016: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2017: l_msg_index := l_msg_index + 1;

Line 2048: csi_item_instance_pub.update_item_instance(l_api_version,

2044:
2045: debug('Right after setting instance status');
2046: debug('Before Update item instance');
2047:
2048: csi_item_instance_pub.update_item_instance(l_api_version,
2049: l_commit,
2050: l_init_msg_list,
2051: l_validation_level,
2052: l_update_instance_rec,

Line 2073: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

2069:
2070: -- Check for any errors and add them to the message stack to pass out to be put into the
2071: -- error log table.
2072: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2073: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2074: debug('Message Count: '||l_msg_count);
2075: debug('Return Status: '||l_return_status);
2076: l_msg_index := 1;
2077: WHILE l_msg_count > 0 loop

Line 2548: csi_item_instance_pub.get_item_instances(l_api_version,

2544: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec => l_instance_query_rec);
2545:
2546: debug('Before Get Item Instance');
2547:
2548: csi_item_instance_pub.get_item_instances(l_api_version,
2549: l_commit,
2550: l_init_msg_list,
2551: l_validation_level,
2552: l_instance_query_rec,

Line 2619: csi_item_instance_pub.create_item_instance(l_api_version,

2615: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2616:
2617: debug('Before Create of source Instance - Neg Qty');
2618:
2619: csi_item_instance_pub.create_item_instance(l_api_version,
2620: l_commit,
2621: l_init_msg_list,
2622: l_validation_level,
2623: l_new_src_instance_rec,

Line 2641: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

2637:
2638: -- Check for any errors and add them to the message stack to pass out to be put into the
2639: -- error log table.
2640: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2641: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2642: l_msg_index := 1;
2643: WHILE l_msg_count > 0 loop
2644: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2645: l_msg_index := l_msg_index + 1;

Line 2682: csi_item_instance_pub.update_item_instance(l_api_version,

2678: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
2679:
2680: debug('Instance Status Id: '||l_update_instance_rec.instance_status_id);
2681:
2682: csi_item_instance_pub.update_item_instance(l_api_version,
2683: l_commit,
2684: l_init_msg_list,
2685: l_validation_level,
2686: l_update_instance_rec,

Line 2707: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

2703: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
2704:
2705: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
2706: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2707: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2708: l_msg_index := 1;
2709: WHILE l_msg_count > 0 loop
2710: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2711: l_msg_index := l_msg_index + 1;

Line 2761: csi_item_instance_pub.update_item_instance(l_api_version,

2757: l_asset_assignment_tbl.delete;
2758:
2759: debug('Before Update of Serialized Item Instance');
2760:
2761: csi_item_instance_pub.update_item_instance(l_api_version,
2762: l_commit,
2763: l_init_msg_list,
2764: l_validation_level,
2765: l_update_instance_rec,

Line 2787: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

2783: debug('l_upd_error_instance_id is: '||l_upd_error_instance_id);
2784:
2785: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
2786: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2787: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
2788: l_msg_index := 1;
2789: WHILE l_msg_count > 0 loop
2790: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2791: l_msg_index := l_msg_index + 1;

Line 2856: csi_item_instance_pub.create_item_instance(l_api_version,

2852: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
2853:
2854: debug('Before Create of source Instance - Neg Qty');
2855:
2856: csi_item_instance_pub.create_item_instance(l_api_version,
2857: l_commit,
2858: l_init_msg_list,
2859: l_validation_level,
2860: l_new_src_instance_rec,

Line 2878: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);

2874:
2875: -- Check for any errors and add them to the message stack to pass out to be put into the
2876: -- error log table.
2877: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
2878: debug('You encountered an error in the csi_item_instance_pub.create_item_instance API '||l_msg_data);
2879: l_msg_index := 1;
2880: WHILE l_msg_count > 0 loop
2881: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
2882: l_msg_index := l_msg_index + 1;

Line 2919: csi_item_instance_pub.update_item_instance(l_api_version,

2915: l_update_instance_rec.instance_status_id := nvl(csi_inv_trxs_pkg.get_default_status_id(l_txn_rec.transaction_type_id),r_id.instance_status_id);
2916:
2917: debug('Instance Status Id: '||l_update_instance_rec.instance_status_id);
2918:
2919: csi_item_instance_pub.update_item_instance(l_api_version,
2920: l_commit,
2921: l_init_msg_list,
2922: l_validation_level,
2923: l_update_instance_rec,

Line 2961: csi_item_instance_pub.get_item_instances(l_api_version,

2957: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec => l_instance_query_rec);
2958:
2959: debug('Before Get Item Instance');
2960:
2961: csi_item_instance_pub.get_item_instances(l_api_version,
2962: l_commit,
2963: l_init_msg_list,
2964: l_validation_level,
2965: l_instance_query_rec,

Line 2976: /*csi_item_instance_pub.get_item_instances(l_api_version,

2972: l_return_status,
2973: l_msg_count,
2974: l_msg_data);
2975:
2976: /*csi_item_instance_pub.get_item_instances(l_api_version,
2977: l_commit,
2978: l_init_msg_list,
2979: l_validation_level,
2980: l_instance_query_rec,

Line 3032: csi_item_instance_pub.create_item_instance(l_api_version,

3028: l_asset_assignment_tbl := csi_inv_trxs_pkg.init_asset_assignment_tbl;
3029:
3030: debug('Before Create of Destination Instance');
3031:
3032: csi_item_instance_pub.create_item_instance(l_api_version,
3033: l_commit,
3034: l_init_msg_list,
3035: l_validation_level,
3036: l_new_dest_instance_rec,

Line 3052: debug('You encountered an error in the destination csi_item_instance_pub.create_item_instance API '||l_msg_data);

3048: debug('After Create of Destination Item Instance');
3049: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
3050: -- Bug 13371469
3051: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3052: debug('You encountered an error in the destination csi_item_instance_pub.create_item_instance API '||l_msg_data);
3053: l_msg_index := 1;
3054: WHILE l_msg_count > 0 loop
3055: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3056: l_msg_index := l_msg_index + 1;

Line 3089: csi_item_instance_pub.update_item_instance(l_api_version,

3085: l_asset_assignment_tbl.delete;
3086:
3087: debug('Before Update of Serial Tagged Item Instance');
3088:
3089: csi_item_instance_pub.update_item_instance(l_api_version,
3090: l_commit,
3091: l_init_msg_list,
3092: l_validation_level,
3093: l_new_dest_instance_rec,

Line 3117: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);

3113:
3114:
3115: -- Check for any errors and add them to the message stack to pass out to be put into the error log table.
3116: IF NOT l_return_status in (l_fnd_success,l_fnd_warning) then
3117: debug('You encountered an error in the csi_item_instance_pub.update_item_instance API '||l_msg_data);
3118: l_msg_index := 1;
3119: WHILE l_msg_count > 0 loop
3120: l_error_message := l_error_message || fnd_msg_pub.get(l_msg_index,FND_API.G_FALSE);
3121: l_msg_index := l_msg_index + 1;