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.AMS_LISTGENERATION_PKG dependencies on FND_MESSAGE

Line 964: -- Added FND Message procedures

960: -- List_src_type_usages store the source type code against each type
961: -- of list
962: -- 10/29/1999 TDONOHOE Created
963: -- 01/24/2001 GJOBY Changed from function to Procedure
964: -- Added FND Message procedures
965: ------------------------------------------------------------------------------
966:
967: PROCEDURE delete_list_entries(p_list_header_id number ,
968: x_msg_count OUT NOCOPY number,

Line 1031: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

1027: write_to_act_log('Procedure delete_list_entries executed successfully.', 'LIST', g_list_header_id,'LOW');
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: write_to_act_log('Error while executing delete_list_entries '||sqlcode || ' '||sqlerrm, 'LIST',g_list_header_id,'HIGH');
1031: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
1032: FND_MESSAGE.Set_Token('TEXT', 'Delete List Entries ' ||
1033: l_delete_action || ' '|| SQLERRM||' '||SQLCODE);
1034: FND_MSG_PUB.Add;
1035: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1032: FND_MESSAGE.Set_Token('TEXT', 'Delete List Entries ' ||

1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: write_to_act_log('Error while executing delete_list_entries '||sqlcode || ' '||sqlerrm, 'LIST',g_list_header_id,'HIGH');
1031: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
1032: FND_MESSAGE.Set_Token('TEXT', 'Delete List Entries ' ||
1033: l_delete_action || ' '|| SQLERRM||' '||SQLCODE);
1034: FND_MSG_PUB.Add;
1035: x_return_status := FND_API.G_RET_STS_ERROR ;
1036:

Line 1075: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

1071:
1072: EXCEPTION
1073: WHEN OTHERS THEN
1074: write_to_act_log('Error while executing initialize_list_header procedure', 'LIST', g_list_header_id,'HIGH');
1075: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
1076: FND_MESSAGE.Set_Token('TEXT', 'Initialize List Header ' ||
1077: SQLERRM||' '||SQLCODE);
1078: FND_MSG_PUB.Add;
1079: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1076: FND_MESSAGE.Set_Token('TEXT', 'Initialize List Header ' ||

1072: EXCEPTION
1073: WHEN OTHERS THEN
1074: write_to_act_log('Error while executing initialize_list_header procedure', 'LIST', g_list_header_id,'HIGH');
1075: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
1076: FND_MESSAGE.Set_Token('TEXT', 'Initialize List Header ' ||
1077: SQLERRM||' '||SQLCODE);
1078: FND_MSG_PUB.Add;
1079: x_return_status := FND_API.G_RET_STS_ERROR ;
1080: END initialize_list_header;

Line 3294: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');

3290: x_counter => l_from_counter) ;
3291:
3292: if l_found = 'N' then
3293: write_to_act_log('Validation failed for this SQL string in validate_sql_string procedure'||l_found,'LIST', g_list_header_id,'HIGH');
3294: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');
3295: FND_MSG_PUB.Add;
3296: RAISE FND_API.G_EXC_ERROR;
3297: end if;
3298: write_to_act_log('SQL string validated successfully in validate_sql_string','LIST', g_list_header_id,'LOW');

Line 3315: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');

3311: x_source_object_pk_field => l_source_object_pk_field);
3312:
3313: if l_found = 'N' then
3314: write_to_act_log('No master type found','LIST', g_list_header_id,'LOW');
3315: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');
3316: FND_MSG_PUB.Add;
3317: RAISE FND_API.G_EXC_ERROR;
3318: end if;
3319:

Line 3987: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');

3983: ----------------------------------------------------------------------
3984: IF (c_action_dets%ROWCOUNT = 1) THEN
3985: IF (p_action_rec.list_action_type <> 'INCLUDE')then
3986: write_to_act_log('Action type of the first selection should always be INCLUDE. Aborting list generation.', 'LIST', g_list_header_id,'HIGH');
3987: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
3988: FND_MSG_PUB.Add;
3989: RAISE FND_API.G_EXC_ERROR;
3990: END IF; -- End of if for list_action_type check
3991: END IF; --End of Validation:- First Action Include Check

Line 4550: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

4546: CLOSE c_action_dets;
4547: END IF;
4548: write_to_act_log('Error while executing process_list_actions '
4549: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4550: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4551: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4552: FND_MSG_PUB.Add;
4553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4554: FND_MSG_PUB.count_and_get(

Line 4551: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

4547: END IF;
4548: write_to_act_log('Error while executing process_list_actions '
4549: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4550: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4551: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4552: FND_MSG_PUB.Add;
4553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4554: FND_MSG_PUB.count_and_get(
4555: p_encoded => FND_API.g_false,

Line 4576: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

4572: CLOSE c_action_dets;
4573: END IF;
4574: write_to_act_log('Error while executing process_list_actions '
4575: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4576: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4577: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4578: FND_MSG_PUB.Add;
4579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4580: FND_MSG_PUB.count_and_get(

Line 4577: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

4573: END IF;
4574: write_to_act_log('Error while executing process_list_actions '
4575: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4576: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4577: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4578: FND_MSG_PUB.Add;
4579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4580: FND_MSG_PUB.count_and_get(
4581: p_encoded => FND_API.g_false,

Line 4737: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MINIMUM_NOT_REACHED');

4733:
4734: -- Start changes for migration
4735: /*
4736: if(l_entry_count < p_no_of_rows_min_requested)then
4737: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MINIMUM_NOT_REACHED');
4738: FND_MESSAGE.Set_Token('NO_AVAILABLE',TO_CHAR(l_entry_count));
4739: FND_MESSAGE.Set_Token('NO_REQUESTED',TO_CHAR(p_no_of_rows_min_requested));
4740: FND_MSG_PUB.Add;
4741: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4738: FND_MESSAGE.Set_Token('NO_AVAILABLE',TO_CHAR(l_entry_count));

4734: -- Start changes for migration
4735: /*
4736: if(l_entry_count < p_no_of_rows_min_requested)then
4737: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MINIMUM_NOT_REACHED');
4738: FND_MESSAGE.Set_Token('NO_AVAILABLE',TO_CHAR(l_entry_count));
4739: FND_MESSAGE.Set_Token('NO_REQUESTED',TO_CHAR(p_no_of_rows_min_requested));
4740: FND_MSG_PUB.Add;
4741: x_return_status := FND_API.G_RET_STS_ERROR;
4742: ELSE

Line 4739: FND_MESSAGE.Set_Token('NO_REQUESTED',TO_CHAR(p_no_of_rows_min_requested));

4735: /*
4736: if(l_entry_count < p_no_of_rows_min_requested)then
4737: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MINIMUM_NOT_REACHED');
4738: FND_MESSAGE.Set_Token('NO_AVAILABLE',TO_CHAR(l_entry_count));
4739: FND_MESSAGE.Set_Token('NO_REQUESTED',TO_CHAR(p_no_of_rows_min_requested));
4740: FND_MSG_PUB.Add;
4741: x_return_status := FND_API.G_RET_STS_ERROR;
4742: ELSE
4743: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7248: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

7244: END IF;
7245:
7246: -- Checking if Debug is set. If debug is set then log debugging message
7247: IF (AMS_DEBUG_HIGH_ON) THEN
7248: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7249: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration : Start');
7250: FND_MSG_PUB.Add;
7251: END IF;
7252:

Line 7249: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration : Start');

7245:
7246: -- Checking if Debug is set. If debug is set then log debugging message
7247: IF (AMS_DEBUG_HIGH_ON) THEN
7248: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7249: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration : Start');
7250: FND_MSG_PUB.Add;
7251: END IF;
7252:
7253: -- Initialize API return status to success

Line 7802: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');

7798: -- Success Message
7799: -- MMSG
7800: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7801: --THEN
7802: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7803: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7804: FND_MSG_PUB.Add;
7805: --END IF;
7806:

Line 7803: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');

7799: -- MMSG
7800: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7801: --THEN
7802: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7803: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7804: FND_MSG_PUB.Add;
7805: --END IF;
7806:
7807: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7810: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

7806:
7807: x_return_status := FND_API.G_RET_STS_SUCCESS;
7808: --IF (AMS_DEBUG_HIGH_ON) THEN
7809: --THEN
7810: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7811: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7812: FND_MSG_PUB.Add;
7813: --END IF;
7814: FND_MSG_PUB.count_and_get(

Line 7811: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');

7807: x_return_status := FND_API.G_RET_STS_SUCCESS;
7808: --IF (AMS_DEBUG_HIGH_ON) THEN
7809: --THEN
7810: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7811: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7812: FND_MSG_PUB.Add;
7813: --END IF;
7814: FND_MSG_PUB.count_and_get(
7815: p_encoded => FND_API.g_false,

Line 7855: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

7851: status_date = sysdate,
7852: main_gen_end_time = sysdate
7853: WHERE list_header_id = p_list_header_id;
7854: logger;
7855: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7856: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7857: FND_MSG_PUB.Add;
7858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7859: FND_MSG_PUB.count_and_get(

Line 7856: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

7852: main_gen_end_time = sysdate
7853: WHERE list_header_id = p_list_header_id;
7854: logger;
7855: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7856: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7857: FND_MSG_PUB.Add;
7858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7859: FND_MSG_PUB.count_and_get(
7860: p_encoded => FND_API.g_false,

Line 7878: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');

7874: main_gen_end_time = sysdate
7875: WHERE list_header_id = p_list_header_id;
7876: logger;
7877:
7878: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7879: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7880: FND_MSG_PUB.Add;
7881:
7882: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7879: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');

7875: WHERE list_header_id = p_list_header_id;
7876: logger;
7877:
7878: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7879: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7880: FND_MSG_PUB.Add;
7881:
7882: x_return_status := FND_API.G_RET_STS_SUCCESS;
7883:

Line 7884: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

7880: FND_MSG_PUB.Add;
7881:
7882: x_return_status := FND_API.G_RET_STS_SUCCESS;
7883:
7884: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7885: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7886: FND_MSG_PUB.Add;
7887:
7888: FND_MSG_PUB.count_and_get(

Line 7885: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');

7881:
7882: x_return_status := FND_API.G_RET_STS_SUCCESS;
7883:
7884: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7885: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7886: FND_MSG_PUB.Add;
7887:
7888: FND_MSG_PUB.count_and_get(
7889: p_encoded => FND_API.g_false,

Line 7908: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

7904: status_date = sysdate,
7905: main_gen_end_time = sysdate
7906: WHERE list_header_id = p_list_header_id;
7907: logger;
7908: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7909: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7910: FND_MSG_PUB.Add;
7911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7912: FND_MSG_PUB.count_and_get(

Line 7909: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

7905: main_gen_end_time = sysdate
7906: WHERE list_header_id = p_list_header_id;
7907: logger;
7908: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7909: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7910: FND_MSG_PUB.Add;
7911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7912: FND_MSG_PUB.count_and_get(
7913: p_encoded => FND_API.g_false,

Line 7991: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

7987: END IF;
7988:
7989: -- Debug Message
7990: IF (AMS_DEBUG_HIGH_ON) THEN
7991: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7992: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
7993: FND_MSG_PUB.Add;
7994: END IF;
7995:

Line 7992: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);

7988:
7989: -- Debug Message
7990: IF (AMS_DEBUG_HIGH_ON) THEN
7991: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7992: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
7993: FND_MSG_PUB.Add;
7994: END IF;
7995:
7996: -- Initialize API return status to success

Line 8024: FND_MESSAGE.set_name('AMS', 'bfore list query');

8020: if x_return_status <> FND_API.g_ret_sts_success THEN
8021: RAISE FND_API.G_EXC_ERROR;
8022: end if;
8023:
8024: FND_MESSAGE.set_name('AMS', 'bfore list query');
8025: FND_MSG_PUB.Add;
8026: l_list_query_rec.name := p_list_name || x_list_header_id;
8027: l_list_query_rec.sql_string := p_sql_string ;
8028: l_list_query_rec.primary_key := p_primary_key ;

Line 8102: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');

8098: -- Success Message
8099: -- MMSG
8100: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8101: --THEN
8102: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8103: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8104: FND_MSG_PUB.Add;
8105: --END IF;
8106:

Line 8103: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');

8099: -- MMSG
8100: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8101: --THEN
8102: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8103: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8104: FND_MSG_PUB.Add;
8105: --END IF;
8106:
8107: --IF (AMS_DEBUG_HIGH_ON) THEN

Line 8109: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8105: --END IF;
8106:
8107: --IF (AMS_DEBUG_HIGH_ON) THEN
8108: --THEN
8109: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8110: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8111: FND_MSG_PUB.Add;
8112: --END IF;
8113: FND_MSG_PUB.count_and_get(

Line 8110: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');

8106:
8107: --IF (AMS_DEBUG_HIGH_ON) THEN
8108: --THEN
8109: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8110: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8111: FND_MSG_PUB.Add;
8112: --END IF;
8113: FND_MSG_PUB.count_and_get(
8114: p_encoded => FND_API.g_false,

Line 8211: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8207: END IF;
8208:
8209: -- Debug Message
8210: IF (AMS_DEBUG_HIGH_ON) THEN
8211: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8212: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8213: FND_MSG_PUB.Add;
8214: END IF;
8215: -- Initialize API return status to success

Line 8212: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);

8208:
8209: -- Debug Message
8210: IF (AMS_DEBUG_HIGH_ON) THEN
8211: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8212: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8213: FND_MSG_PUB.Add;
8214: END IF;
8215: -- Initialize API return status to success
8216: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8261: FND_MESSAGE.set_name('AMS','after list action->'|| l_action_id|| '<-');

8257: x_msg_data => x_msg_data,
8258: p_action_rec => l_action_rec,
8259: x_action_id => l_action_id
8260: ) ;
8261: FND_MESSAGE.set_name('AMS','after list action->'|| l_action_id|| '<-');
8262: FND_MSG_PUB.Add;
8263: if x_return_status <> FND_API.g_ret_sts_success THEN
8264: RAISE FND_API.G_EXC_ERROR;
8265: end if;

Line 8293: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');

8289: -- Success Message
8290: -- MMSG
8291: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8292: --THEN
8293: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8294: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8295: FND_MSG_PUB.Add;
8296: --END IF;
8297:

Line 8294: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');

8290: -- MMSG
8291: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8292: --THEN
8293: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8294: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8295: FND_MSG_PUB.Add;
8296: --END IF;
8297:
8298:

Line 8301: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8297:
8298:
8299: --IF (AMS_DEBUG_HIGH_ON) THEN
8300: --THEN
8301: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8302: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8303: FND_MSG_PUB.Add;
8304: --END IF;
8305: FND_MSG_PUB.count_and_get(

Line 8302: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');

8298:
8299: --IF (AMS_DEBUG_HIGH_ON) THEN
8300: --THEN
8301: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8302: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8303: FND_MSG_PUB.Add;
8304: --END IF;
8305: FND_MSG_PUB.count_and_get(
8306: p_encoded => FND_API.g_false,

Line 8313: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8309: );
8310:
8311: EXCEPTION
8312: WHEN FND_API.G_EXC_ERROR THEN
8313: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8314: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8315: FND_MSG_PUB.Add;
8316: -- Check if reset of the status is required
8317: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 8314: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

8310:
8311: EXCEPTION
8312: WHEN FND_API.G_EXC_ERROR THEN
8313: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8314: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8315: FND_MSG_PUB.Add;
8316: -- Check if reset of the status is required
8317: x_return_status := FND_API.G_RET_STS_ERROR ;
8318: FND_MSG_PUB.count_and_get(

Line 8324: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8320: p_count => x_msg_count,
8321: p_data => x_msg_data);
8322:
8323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8324: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8325: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8326: FND_MSG_PUB.Add;
8327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8328: FND_MSG_PUB.count_and_get(

Line 8325: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

8321: p_data => x_msg_data);
8322:
8323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8324: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8325: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8326: FND_MSG_PUB.Add;
8327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8328: FND_MSG_PUB.count_and_get(
8329: p_encoded => FND_API.g_false,

Line 8334: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8330: p_count => x_msg_count,
8331: p_data => x_msg_data);
8332:
8333: WHEN OTHERS THEN
8334: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8335: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8336: FND_MSG_PUB.Add;
8337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8338: FND_MSG_PUB.count_and_get(

Line 8335: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

8331: p_data => x_msg_data);
8332:
8333: WHEN OTHERS THEN
8334: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8335: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8336: FND_MSG_PUB.Add;
8337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8338: FND_MSG_PUB.count_and_get(
8339: p_encoded => FND_API.g_false,

Line 8390: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8386: END IF;
8387:
8388: -- Debug Message
8389: IF (AMS_DEBUG_HIGH_ON) THEN
8390: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8391: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8392: FND_MSG_PUB.Add;
8393: END IF;
8394:

Line 8391: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);

8387:
8388: -- Debug Message
8389: IF (AMS_DEBUG_HIGH_ON) THEN
8390: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8391: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8392: FND_MSG_PUB.Add;
8393: END IF;
8394:
8395: -- Initialize API return status to success

Line 8471: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');

8467: -- Success Message
8468: -- MMSG
8469: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8470: --THEN
8471: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8472: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8473: FND_MSG_PUB.Add;
8474: --END IF;
8475:

Line 8472: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');

8468: -- MMSG
8469: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8470: --THEN
8471: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8472: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8473: FND_MSG_PUB.Add;
8474: --END IF;
8475:
8476:

Line 8479: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8475:
8476:
8477: --IF (AMS_DEBUG_HIGH_ON) THEN
8478: --THEN
8479: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8480: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8481: FND_MSG_PUB.Add;
8482: --END IF;
8483: FND_MSG_PUB.count_and_get(

Line 8480: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');

8476:
8477: --IF (AMS_DEBUG_HIGH_ON) THEN
8478: --THEN
8479: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8480: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8481: FND_MSG_PUB.Add;
8482: --END IF;
8483: FND_MSG_PUB.count_and_get(
8484: p_encoded => FND_API.g_false,

Line 8491: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8487: );
8488:
8489: EXCEPTION
8490: WHEN FND_API.G_EXC_ERROR THEN
8491: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8492: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8493: FND_MSG_PUB.Add;
8494: -- Check if reset of the status is required
8495: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 8492: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

8488:
8489: EXCEPTION
8490: WHEN FND_API.G_EXC_ERROR THEN
8491: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8492: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8493: FND_MSG_PUB.Add;
8494: -- Check if reset of the status is required
8495: x_return_status := FND_API.G_RET_STS_ERROR ;
8496: FND_MSG_PUB.count_and_get(

Line 8502: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8498: p_count => x_msg_count,
8499: p_data => x_msg_data);
8500:
8501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8502: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8503: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8504: FND_MSG_PUB.Add;
8505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8506: FND_MSG_PUB.count_and_get(

Line 8503: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

8499: p_data => x_msg_data);
8500:
8501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8502: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8503: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8504: FND_MSG_PUB.Add;
8505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8506: FND_MSG_PUB.count_and_get(
8507: p_encoded => FND_API.g_false,

Line 8512: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8508: p_count => x_msg_count,
8509: p_data => x_msg_data);
8510:
8511: WHEN OTHERS THEN
8512: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8513: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8514: FND_MSG_PUB.Add;
8515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8516: FND_MSG_PUB.count_and_get(

Line 8513: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

8509: p_data => x_msg_data);
8510:
8511: WHEN OTHERS THEN
8512: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8513: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8514: FND_MSG_PUB.Add;
8515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8516: FND_MSG_PUB.count_and_get(
8517: p_encoded => FND_API.g_false,

Line 8569: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8565: END IF;
8566:
8567: -- Debug Message
8568: IF (AMS_DEBUG_HIGH_ON) THEN
8569: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8570: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8571: FND_MSG_PUB.Add;
8572: END IF;
8573:

Line 8570: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);

8566:
8567: -- Debug Message
8568: IF (AMS_DEBUG_HIGH_ON) THEN
8569: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8570: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8571: FND_MSG_PUB.Add;
8572: END IF;
8573:
8574: -- Initialize API return status to success

Line 8652: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');

8648: -- Success Message
8649: -- MMSG
8650: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8651: --THEN
8652: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8653: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8654: FND_MSG_PUB.Add;
8655: --END IF;
8656:

Line 8653: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');

8649: -- MMSG
8650: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8651: --THEN
8652: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8653: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8654: FND_MSG_PUB.Add;
8655: --END IF;
8656:
8657:

Line 8660: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8656:
8657:
8658: --IF (AMS_DEBUG_HIGH_ON) THEN
8659: --THEN
8660: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8661: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8662: FND_MSG_PUB.Add;
8663: --END IF;
8664: FND_MSG_PUB.count_and_get(

Line 8661: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');

8657:
8658: --IF (AMS_DEBUG_HIGH_ON) THEN
8659: --THEN
8660: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8661: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8662: FND_MSG_PUB.Add;
8663: --END IF;
8664: FND_MSG_PUB.count_and_get(
8665: p_encoded => FND_API.g_false,

Line 8672: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8668: );
8669:
8670: EXCEPTION
8671: WHEN FND_API.G_EXC_ERROR THEN
8672: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8673: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8674: FND_MSG_PUB.Add;
8675: -- Check if reset of the status is required
8676: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 8673: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

8669:
8670: EXCEPTION
8671: WHEN FND_API.G_EXC_ERROR THEN
8672: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8673: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8674: FND_MSG_PUB.Add;
8675: -- Check if reset of the status is required
8676: x_return_status := FND_API.G_RET_STS_ERROR ;
8677: FND_MSG_PUB.count_and_get(

Line 8683: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8679: p_count => x_msg_count,
8680: p_data => x_msg_data);
8681:
8682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8683: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8684: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8685: FND_MSG_PUB.Add;
8686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8687: FND_MSG_PUB.count_and_get(

Line 8684: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

8680: p_data => x_msg_data);
8681:
8682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8683: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8684: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8685: FND_MSG_PUB.Add;
8686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8687: FND_MSG_PUB.count_and_get(
8688: p_encoded => FND_API.g_false,

Line 8693: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

8689: p_count => x_msg_count,
8690: p_data => x_msg_data);
8691:
8692: WHEN OTHERS THEN
8693: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8694: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8695: FND_MSG_PUB.Add;
8696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8697: FND_MSG_PUB.count_and_get(

Line 8694: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

8690: p_data => x_msg_data);
8691:
8692: WHEN OTHERS THEN
8693: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8694: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8695: FND_MSG_PUB.Add;
8696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8697: FND_MSG_PUB.count_and_get(
8698: p_encoded => FND_API.g_false,

Line 8870: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

8866: LOOP
8867: FETCH c_action_dets INTO l_action_dets_rec;
8868: EXIT WHEN c_action_dets%NOTFOUND;
8869:
8870: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8871: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : before IMMEDIATE');
8872: FND_MSG_PUB.Add;
8873: write_to_act_log('Selection included in target group is of type '||l_action_dets_rec.list_act_type||' , action type is '||l_action_dets_rec.list_action_type, 'LIST', g_list_header_id,'HIGH');
8874: write_to_act_log('List header id is '||l_action_dets_rec.list_header_id||' act list header id is '||l_action_dets_rec.act_list_header_id||' and order no is '||l_action_dets_rec.order_number, 'LIST', g_list_header_id,'HIGH');

Line 8871: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : before IMMEDIATE');

8867: FETCH c_action_dets INTO l_action_dets_rec;
8868: EXIT WHEN c_action_dets%NOTFOUND;
8869:
8870: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8871: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : before IMMEDIATE');
8872: FND_MSG_PUB.Add;
8873: write_to_act_log('Selection included in target group is of type '||l_action_dets_rec.list_act_type||' , action type is '||l_action_dets_rec.list_action_type, 'LIST', g_list_header_id,'HIGH');
8874: write_to_act_log('List header id is '||l_action_dets_rec.list_header_id||' act list header id is '||l_action_dets_rec.act_list_header_id||' and order no is '||l_action_dets_rec.order_number, 'LIST', g_list_header_id,'HIGH');
8875: if l_action_dets_rec.list_act_type = 'SQL' then

Line 9003: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

8999: else
9000: write_to_act_log('Process_'||l_action_dets_rec.list_act_type||' executed successfully.', 'LIST', g_list_header_id,'LOW');
9001: end if;
9002:
9003: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9004: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : AFTER IMMEDIATE');
9005: FND_MSG_PUB.Add;
9006:
9007: if l_action_dets_rec.list_action_type = 'INCLUDE' then

Line 9004: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : AFTER IMMEDIATE');

9000: write_to_act_log('Process_'||l_action_dets_rec.list_act_type||' executed successfully.', 'LIST', g_list_header_id,'LOW');
9001: end if;
9002:
9003: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9004: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : AFTER IMMEDIATE');
9005: FND_MSG_PUB.Add;
9006:
9007: if l_action_dets_rec.list_action_type = 'INCLUDE' then
9008: l_include_count := l_include_count +1 ;

Line 9464: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

9460: IF(c_action_dets%ISOPEN)THEN
9461: CLOSE c_action_dets;
9462: END IF;
9463: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9464: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9465: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9466: FND_MSG_PUB.Add;
9467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9468: FND_MSG_PUB.count_and_get(

Line 9465: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);

9461: CLOSE c_action_dets;
9462: END IF;
9463: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9464: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9465: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9466: FND_MSG_PUB.Add;
9467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9468: FND_MSG_PUB.count_and_get(
9469: p_encoded => FND_API.g_false,

Line 9478: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

9474: IF(c_action_dets%ISOPEN)THEN
9475: CLOSE c_action_dets;
9476: END IF;
9477: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9478: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9479: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9480: FND_MSG_PUB.Add;
9481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9482: FND_MSG_PUB.count_and_get(

Line 9479: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);

9475: CLOSE c_action_dets;
9476: END IF;
9477: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9478: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9479: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9480: FND_MSG_PUB.Add;
9481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9482: FND_MSG_PUB.count_and_get(
9483: p_encoded => FND_API.g_false,

Line 9859: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

9855:
9856: -- Checking if Debug is set. If debug is set then log debugging message
9857: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
9858: THEN
9859: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9860: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : Start');
9861: FND_MSG_PUB.Add;
9862: END IF;
9863:

Line 9860: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : Start');

9856: -- Checking if Debug is set. If debug is set then log debugging message
9857: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
9858: THEN
9859: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9860: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : Start');
9861: FND_MSG_PUB.Add;
9862: END IF;
9863:
9864: -- Initialize API return status to success

Line 10366: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');

10362: -- Success Message
10363: -- MMSG
10364: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
10365: --THEN
10366: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
10367: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
10368: FND_MSG_PUB.Add;
10369: --END IF;
10370:

Line 10367: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');

10363: -- MMSG
10364: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
10365: --THEN
10366: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
10367: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
10368: FND_MSG_PUB.Add;
10369: --END IF;
10370:
10371:

Line 10375: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

10371:
10372: x_return_status := FND_API.G_RET_STS_SUCCESS;
10373: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
10374: --THEN
10375: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10376: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List: END');
10377: FND_MSG_PUB.Add;
10378: --END IF;
10379: FND_MSG_PUB.count_and_get(

Line 10376: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List: END');

10372: x_return_status := FND_API.G_RET_STS_SUCCESS;
10373: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
10374: --THEN
10375: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10376: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List: END');
10377: FND_MSG_PUB.Add;
10378: --END IF;
10379: FND_MSG_PUB.count_and_get(
10380: p_encoded => FND_API.g_false,

Line 10429: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

10425: WHERE list_header_id = p_list_header_id;
10426: logger;
10427: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||
10428: --l_error_position||sqlerrm||sqlcode);
10429: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10430: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10431: FND_MSG_PUB.Add;
10432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10433: FND_MSG_PUB.count_and_get(

Line 10430: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);

10426: logger;
10427: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||
10428: --l_error_position||sqlerrm||sqlcode);
10429: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10430: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10431: FND_MSG_PUB.Add;
10432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10433: FND_MSG_PUB.count_and_get(
10434: p_encoded => FND_API.g_false,

Line 10457: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

10453: logger;
10454:
10455: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||
10456: --l_error_position||sqlerrm||sqlcode);
10457: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10458: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10459: FND_MSG_PUB.Add;
10460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10461: FND_MSG_PUB.count_and_get(

Line 10458: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);

10454:
10455: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||
10456: --l_error_position||sqlerrm||sqlcode);
10457: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10458: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10459: FND_MSG_PUB.Add;
10460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10461: FND_MSG_PUB.count_and_get(
10462: p_encoded => FND_API.g_false,

Line 10621: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LIST_RULE');

10617: END IF;
10618:
10619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
10620: THEN
10621: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LIST_RULE');
10622: FND_MSG_PUB.add;
10623: END IF;
10624:
10625: CLOSE c_list_rules;

Line 10645: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ONLY_ONE_LIST_RULE');

10641: END IF;
10642: */
10643: Write_To_Act_Log ( 'More than one rule cannot be applied to the list','LIST',p_list_header_id ,'HIGH');
10644: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
10645: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ONLY_ONE_LIST_RULE');
10646: FND_MSG_PUB.add;
10647: END IF;
10648:
10649: CLOSE c_list_rules;

Line 11900: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

11896: application => 'AMS',
11897: program => 'AMSLSRTC',
11898: argument1 => p_action_used_by_id);
11899: commit;
11900: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11901: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');
11902: FND_MSG_PUB.Add;
11903: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11904: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

Line 11901: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');

11897: program => 'AMSLSRTC',
11898: argument1 => p_action_used_by_id);
11899: commit;
11900: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11901: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');
11902: FND_MSG_PUB.Add;
11903: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11904: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
11905: -- FND_MSG_PUB.Add;

Line 11903: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

11899: commit;
11900: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11901: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');
11902: FND_MSG_PUB.Add;
11903: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11904: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
11905: -- FND_MSG_PUB.Add;
11906: FND_MSG_PUB.count_and_get(
11907: p_encoded => FND_API.g_false,

Line 11904: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

11900: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11901: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');
11902: FND_MSG_PUB.Add;
11903: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11904: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
11905: -- FND_MSG_PUB.Add;
11906: FND_MSG_PUB.count_and_get(
11907: p_encoded => FND_API.g_false,
11908: p_count => x_msg_count,

Line 11917: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

11913: IF l_request_id = 0 THEN
11914: write_to_act_log('Unexpected Error for the program--concurrent program_id is '||to_char(l_request_id), 'LIST', g_list_header_id,'HIGH');
11915:
11916:
11917: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11918: FND_MESSAGE.Set_Token('TEXT', 'Error '|| sqlerrm||' '||sqlcode);
11919: FND_MSG_PUB.Add;
11920: FND_MSG_PUB.count_and_get(
11921: p_encoded => FND_API.g_false,

Line 11918: FND_MESSAGE.Set_Token('TEXT', 'Error '|| sqlerrm||' '||sqlcode);

11914: write_to_act_log('Unexpected Error for the program--concurrent program_id is '||to_char(l_request_id), 'LIST', g_list_header_id,'HIGH');
11915:
11916:
11917: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11918: FND_MESSAGE.Set_Token('TEXT', 'Error '|| sqlerrm||' '||sqlcode);
11919: FND_MSG_PUB.Add;
11920: FND_MSG_PUB.count_and_get(
11921: p_encoded => FND_API.g_false,
11922: p_count => x_msg_count,

Line 12044: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');

12040: IF (c_action_dets%ROWCOUNT = 1) THEN
12041: IF (p_action_rec.list_action_type <> 'INCLUDE')then
12042: write_to_act_log('Error. The action type of the first selection is NOT INCLUDE.', 'LIST', g_list_header_id,'HIGH');
12043: Ams_Utility_Pvt.Write_Conc_log('process list actions : first action INCLUDE check failed');
12044: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
12045: FND_MSG_PUB.Add;
12046: RAISE FND_API.G_EXC_ERROR;
12047: END IF; -- End of if for list_action_type check
12048: END IF; --End of Validation:- First Action Include Check

Line 12237: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

12233: END IF;
12234: Ams_Utility_Pvt.Write_Conc_log('Error: AMS_ListGeneration_PKG.Process_list_actions: '||sqlerrm||sqlcode);
12235: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'
12236: ||sqlerrm||sqlcode, 'LIST', g_list_header_id);
12237: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12238: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12239: FND_MSG_PUB.Add;
12240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12241: FND_MSG_PUB.count_and_get(

Line 12238: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

12234: Ams_Utility_Pvt.Write_Conc_log('Error: AMS_ListGeneration_PKG.Process_list_actions: '||sqlerrm||sqlcode);
12235: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'
12236: ||sqlerrm||sqlcode, 'LIST', g_list_header_id);
12237: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12238: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12239: FND_MSG_PUB.Add;
12240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12241: FND_MSG_PUB.count_and_get(
12242: p_encoded => FND_API.g_false,

Line 12254: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

12250: END IF;
12251: Ams_Utility_Pvt.Write_Conc_log('Error: AMS_ListGeneration_PKG.Process_list_actions: '||sqlerrm||sqlcode);
12252: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'
12253: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
12254: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12255: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12256: FND_MSG_PUB.Add;
12257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12258: FND_MSG_PUB.count_and_get(

Line 12255: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

12251: Ams_Utility_Pvt.Write_Conc_log('Error: AMS_ListGeneration_PKG.Process_list_actions: '||sqlerrm||sqlcode);
12252: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'
12253: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
12254: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12255: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12256: FND_MSG_PUB.Add;
12257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12258: FND_MSG_PUB.count_and_get(
12259: p_encoded => FND_API.g_false,

Line 12619: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');

12615:
12616: -- write_to_act_log('Process_rt_all_sql l_found : '||l_found,'LIST', g_list_header_id);
12617: -- write_to_act_log('Process_rt_all_sql return status: After validate_sql_string call ','LIST', g_list_header_id);
12618: if l_found = 'N' then
12619: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');
12620: FND_MSG_PUB.Add;
12621: RAISE FND_API.G_EXC_ERROR;
12622: end if;
12623: /* write_to_act_log('Process_rt_all_sql: FROM Position ->'|| l_from_position ||

Line 12639: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');

12635: x_source_object_name => l_source_object_name,
12636: x_source_object_pk_field => l_source_object_pk_field);
12637:
12638: if l_found = 'N' then
12639: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');
12640: FND_MSG_PUB.Add;
12641: RAISE FND_API.G_EXC_ERROR;
12642: end if;
12643: write_to_act_log('Master type is '|| l_master_type ||'<--' , 'LIST', g_list_header_id,'LOW');