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 3986: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');

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

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

4539: CLOSE c_action_dets;
4540: END IF;
4541: write_to_act_log('Error while executing process_list_actions '
4542: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4543: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4544: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4545: FND_MSG_PUB.Add;
4546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4547: FND_MSG_PUB.count_and_get(

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

4540: END IF;
4541: write_to_act_log('Error while executing process_list_actions '
4542: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4543: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4544: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4545: FND_MSG_PUB.Add;
4546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4547: FND_MSG_PUB.count_and_get(
4548: p_encoded => FND_API.g_false,

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

4565: CLOSE c_action_dets;
4566: END IF;
4567: write_to_act_log('Error while executing process_list_actions '
4568: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4569: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4570: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4571: FND_MSG_PUB.Add;
4572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4573: FND_MSG_PUB.count_and_get(

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

4566: END IF;
4567: write_to_act_log('Error while executing process_list_actions '
4568: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4569: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4570: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4571: FND_MSG_PUB.Add;
4572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4573: FND_MSG_PUB.count_and_get(
4574: p_encoded => FND_API.g_false,

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

4726:
4727: -- Start changes for migration
4728: /*
4729: if(l_entry_count < p_no_of_rows_min_requested)then
4730: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MINIMUM_NOT_REACHED');
4731: FND_MESSAGE.Set_Token('NO_AVAILABLE',TO_CHAR(l_entry_count));
4732: FND_MESSAGE.Set_Token('NO_REQUESTED',TO_CHAR(p_no_of_rows_min_requested));
4733: FND_MSG_PUB.Add;
4734: x_return_status := FND_API.G_RET_STS_ERROR;

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

4727: -- Start changes for migration
4728: /*
4729: if(l_entry_count < p_no_of_rows_min_requested)then
4730: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MINIMUM_NOT_REACHED');
4731: FND_MESSAGE.Set_Token('NO_AVAILABLE',TO_CHAR(l_entry_count));
4732: FND_MESSAGE.Set_Token('NO_REQUESTED',TO_CHAR(p_no_of_rows_min_requested));
4733: FND_MSG_PUB.Add;
4734: x_return_status := FND_API.G_RET_STS_ERROR;
4735: ELSE

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

4728: /*
4729: if(l_entry_count < p_no_of_rows_min_requested)then
4730: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MINIMUM_NOT_REACHED');
4731: FND_MESSAGE.Set_Token('NO_AVAILABLE',TO_CHAR(l_entry_count));
4732: FND_MESSAGE.Set_Token('NO_REQUESTED',TO_CHAR(p_no_of_rows_min_requested));
4733: FND_MSG_PUB.Add;
4734: x_return_status := FND_API.G_RET_STS_ERROR;
4735: ELSE
4736: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

7159: END IF;
7160:
7161: -- Checking if Debug is set. If debug is set then log debugging message
7162: IF (AMS_DEBUG_HIGH_ON) THEN
7163: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7164: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration : Start');
7165: FND_MSG_PUB.Add;
7166: END IF;
7167:

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

7160:
7161: -- Checking if Debug is set. If debug is set then log debugging message
7162: IF (AMS_DEBUG_HIGH_ON) THEN
7163: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7164: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration : Start');
7165: FND_MSG_PUB.Add;
7166: END IF;
7167:
7168: -- Initialize API return status to success

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

7710: -- Success Message
7711: -- MMSG
7712: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7713: --THEN
7714: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7715: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7716: FND_MSG_PUB.Add;
7717: --END IF;
7718:

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

7711: -- MMSG
7712: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7713: --THEN
7714: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7715: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7716: FND_MSG_PUB.Add;
7717: --END IF;
7718:
7719: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

7718:
7719: x_return_status := FND_API.G_RET_STS_SUCCESS;
7720: --IF (AMS_DEBUG_HIGH_ON) THEN
7721: --THEN
7722: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7723: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7724: FND_MSG_PUB.Add;
7725: --END IF;
7726: FND_MSG_PUB.count_and_get(

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

7719: x_return_status := FND_API.G_RET_STS_SUCCESS;
7720: --IF (AMS_DEBUG_HIGH_ON) THEN
7721: --THEN
7722: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7723: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7724: FND_MSG_PUB.Add;
7725: --END IF;
7726: FND_MSG_PUB.count_and_get(
7727: p_encoded => FND_API.g_false,

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

7763: status_date = sysdate,
7764: main_gen_end_time = sysdate
7765: WHERE list_header_id = p_list_header_id;
7766: logger;
7767: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7768: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7769: FND_MSG_PUB.Add;
7770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7771: FND_MSG_PUB.count_and_get(

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

7764: main_gen_end_time = sysdate
7765: WHERE list_header_id = p_list_header_id;
7766: logger;
7767: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7768: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7769: FND_MSG_PUB.Add;
7770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7771: FND_MSG_PUB.count_and_get(
7772: p_encoded => FND_API.g_false,

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

7786: main_gen_end_time = sysdate
7787: WHERE list_header_id = p_list_header_id;
7788: logger;
7789:
7790: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7791: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7792: FND_MSG_PUB.Add;
7793:
7794: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

7787: WHERE list_header_id = p_list_header_id;
7788: logger;
7789:
7790: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7791: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7792: FND_MSG_PUB.Add;
7793:
7794: x_return_status := FND_API.G_RET_STS_SUCCESS;
7795:

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

7792: FND_MSG_PUB.Add;
7793:
7794: x_return_status := FND_API.G_RET_STS_SUCCESS;
7795:
7796: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7797: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7798: FND_MSG_PUB.Add;
7799:
7800: FND_MSG_PUB.count_and_get(

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

7793:
7794: x_return_status := FND_API.G_RET_STS_SUCCESS;
7795:
7796: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7797: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7798: FND_MSG_PUB.Add;
7799:
7800: FND_MSG_PUB.count_and_get(
7801: p_encoded => FND_API.g_false,

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

7816: status_date = sysdate,
7817: main_gen_end_time = sysdate
7818: WHERE list_header_id = p_list_header_id;
7819: logger;
7820: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7821: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7822: FND_MSG_PUB.Add;
7823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7824: FND_MSG_PUB.count_and_get(

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

7817: main_gen_end_time = sysdate
7818: WHERE list_header_id = p_list_header_id;
7819: logger;
7820: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7821: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7822: FND_MSG_PUB.Add;
7823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7824: FND_MSG_PUB.count_and_get(
7825: p_encoded => FND_API.g_false,

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

7899: END IF;
7900:
7901: -- Debug Message
7902: IF (AMS_DEBUG_HIGH_ON) THEN
7903: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7904: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
7905: FND_MSG_PUB.Add;
7906: END IF;
7907:

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

7900:
7901: -- Debug Message
7902: IF (AMS_DEBUG_HIGH_ON) THEN
7903: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7904: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
7905: FND_MSG_PUB.Add;
7906: END IF;
7907:
7908: -- Initialize API return status to success

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

7932: if x_return_status <> FND_API.g_ret_sts_success THEN
7933: RAISE FND_API.G_EXC_ERROR;
7934: end if;
7935:
7936: FND_MESSAGE.set_name('AMS', 'bfore list query');
7937: FND_MSG_PUB.Add;
7938: l_list_query_rec.name := p_list_name || x_list_header_id;
7939: l_list_query_rec.sql_string := p_sql_string ;
7940: l_list_query_rec.primary_key := p_primary_key ;

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

8010: -- Success Message
8011: -- MMSG
8012: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8013: --THEN
8014: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8015: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8016: FND_MSG_PUB.Add;
8017: --END IF;
8018:

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

8011: -- MMSG
8012: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8013: --THEN
8014: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8015: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8016: FND_MSG_PUB.Add;
8017: --END IF;
8018:
8019: --IF (AMS_DEBUG_HIGH_ON) THEN

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

8017: --END IF;
8018:
8019: --IF (AMS_DEBUG_HIGH_ON) THEN
8020: --THEN
8021: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8022: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8023: FND_MSG_PUB.Add;
8024: --END IF;
8025: FND_MSG_PUB.count_and_get(

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

8018:
8019: --IF (AMS_DEBUG_HIGH_ON) THEN
8020: --THEN
8021: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8022: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8023: FND_MSG_PUB.Add;
8024: --END IF;
8025: FND_MSG_PUB.count_and_get(
8026: p_encoded => FND_API.g_false,

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

8119: END IF;
8120:
8121: -- Debug Message
8122: IF (AMS_DEBUG_HIGH_ON) THEN
8123: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8124: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8125: FND_MSG_PUB.Add;
8126: END IF;
8127: -- Initialize API return status to success

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

8120:
8121: -- Debug Message
8122: IF (AMS_DEBUG_HIGH_ON) THEN
8123: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8124: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8125: FND_MSG_PUB.Add;
8126: END IF;
8127: -- Initialize API return status to success
8128: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

8169: x_msg_data => x_msg_data,
8170: p_action_rec => l_action_rec,
8171: x_action_id => l_action_id
8172: ) ;
8173: FND_MESSAGE.set_name('AMS','after list action->'|| l_action_id|| '<-');
8174: FND_MSG_PUB.Add;
8175: if x_return_status <> FND_API.g_ret_sts_success THEN
8176: RAISE FND_API.G_EXC_ERROR;
8177: end if;

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

8201: -- Success Message
8202: -- MMSG
8203: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8204: --THEN
8205: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8206: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8207: FND_MSG_PUB.Add;
8208: --END IF;
8209:

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

8202: -- MMSG
8203: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8204: --THEN
8205: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8206: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8207: FND_MSG_PUB.Add;
8208: --END IF;
8209:
8210:

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

8209:
8210:
8211: --IF (AMS_DEBUG_HIGH_ON) THEN
8212: --THEN
8213: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8214: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8215: FND_MSG_PUB.Add;
8216: --END IF;
8217: FND_MSG_PUB.count_and_get(

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

8210:
8211: --IF (AMS_DEBUG_HIGH_ON) THEN
8212: --THEN
8213: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8214: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8215: FND_MSG_PUB.Add;
8216: --END IF;
8217: FND_MSG_PUB.count_and_get(
8218: p_encoded => FND_API.g_false,

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

8221: );
8222:
8223: EXCEPTION
8224: WHEN FND_API.G_EXC_ERROR THEN
8225: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8226: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8227: FND_MSG_PUB.Add;
8228: -- Check if reset of the status is required
8229: x_return_status := FND_API.G_RET_STS_ERROR ;

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

8222:
8223: EXCEPTION
8224: WHEN FND_API.G_EXC_ERROR THEN
8225: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8226: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8227: FND_MSG_PUB.Add;
8228: -- Check if reset of the status is required
8229: x_return_status := FND_API.G_RET_STS_ERROR ;
8230: FND_MSG_PUB.count_and_get(

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

8232: p_count => x_msg_count,
8233: p_data => x_msg_data);
8234:
8235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8236: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8237: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8238: FND_MSG_PUB.Add;
8239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8240: FND_MSG_PUB.count_and_get(

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

8233: p_data => x_msg_data);
8234:
8235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8236: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8237: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8238: FND_MSG_PUB.Add;
8239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8240: FND_MSG_PUB.count_and_get(
8241: p_encoded => FND_API.g_false,

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

8242: p_count => x_msg_count,
8243: p_data => x_msg_data);
8244:
8245: WHEN OTHERS THEN
8246: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8247: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8248: FND_MSG_PUB.Add;
8249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8250: FND_MSG_PUB.count_and_get(

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

8243: p_data => x_msg_data);
8244:
8245: WHEN OTHERS THEN
8246: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8247: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8248: FND_MSG_PUB.Add;
8249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8250: FND_MSG_PUB.count_and_get(
8251: p_encoded => FND_API.g_false,

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

8298: END IF;
8299:
8300: -- Debug Message
8301: IF (AMS_DEBUG_HIGH_ON) THEN
8302: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8303: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8304: FND_MSG_PUB.Add;
8305: END IF;
8306:

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

8299:
8300: -- Debug Message
8301: IF (AMS_DEBUG_HIGH_ON) THEN
8302: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8303: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8304: FND_MSG_PUB.Add;
8305: END IF;
8306:
8307: -- Initialize API return status to success

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

8379: -- Success Message
8380: -- MMSG
8381: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8382: --THEN
8383: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8384: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8385: FND_MSG_PUB.Add;
8386: --END IF;
8387:

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

8380: -- MMSG
8381: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8382: --THEN
8383: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8384: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8385: FND_MSG_PUB.Add;
8386: --END IF;
8387:
8388:

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

8387:
8388:
8389: --IF (AMS_DEBUG_HIGH_ON) THEN
8390: --THEN
8391: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8392: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8393: FND_MSG_PUB.Add;
8394: --END IF;
8395: FND_MSG_PUB.count_and_get(

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

8388:
8389: --IF (AMS_DEBUG_HIGH_ON) THEN
8390: --THEN
8391: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8392: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8393: FND_MSG_PUB.Add;
8394: --END IF;
8395: FND_MSG_PUB.count_and_get(
8396: p_encoded => FND_API.g_false,

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

8399: );
8400:
8401: EXCEPTION
8402: WHEN FND_API.G_EXC_ERROR THEN
8403: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8404: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8405: FND_MSG_PUB.Add;
8406: -- Check if reset of the status is required
8407: x_return_status := FND_API.G_RET_STS_ERROR ;

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

8400:
8401: EXCEPTION
8402: WHEN FND_API.G_EXC_ERROR THEN
8403: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8404: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8405: FND_MSG_PUB.Add;
8406: -- Check if reset of the status is required
8407: x_return_status := FND_API.G_RET_STS_ERROR ;
8408: FND_MSG_PUB.count_and_get(

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

8410: p_count => x_msg_count,
8411: p_data => x_msg_data);
8412:
8413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8414: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8415: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8416: FND_MSG_PUB.Add;
8417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8418: FND_MSG_PUB.count_and_get(

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

8411: p_data => x_msg_data);
8412:
8413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8414: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8415: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8416: FND_MSG_PUB.Add;
8417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8418: FND_MSG_PUB.count_and_get(
8419: p_encoded => FND_API.g_false,

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

8420: p_count => x_msg_count,
8421: p_data => x_msg_data);
8422:
8423: WHEN OTHERS THEN
8424: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8425: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8426: FND_MSG_PUB.Add;
8427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8428: FND_MSG_PUB.count_and_get(

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

8421: p_data => x_msg_data);
8422:
8423: WHEN OTHERS THEN
8424: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8425: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8426: FND_MSG_PUB.Add;
8427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8428: FND_MSG_PUB.count_and_get(
8429: p_encoded => FND_API.g_false,

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

8477: END IF;
8478:
8479: -- Debug Message
8480: IF (AMS_DEBUG_HIGH_ON) THEN
8481: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8482: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8483: FND_MSG_PUB.Add;
8484: END IF;
8485:

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

8478:
8479: -- Debug Message
8480: IF (AMS_DEBUG_HIGH_ON) THEN
8481: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8482: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8483: FND_MSG_PUB.Add;
8484: END IF;
8485:
8486: -- Initialize API return status to success

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

8560: -- Success Message
8561: -- MMSG
8562: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8563: --THEN
8564: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8565: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8566: FND_MSG_PUB.Add;
8567: --END IF;
8568:

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

8561: -- MMSG
8562: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8563: --THEN
8564: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8565: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8566: FND_MSG_PUB.Add;
8567: --END IF;
8568:
8569:

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

8568:
8569:
8570: --IF (AMS_DEBUG_HIGH_ON) THEN
8571: --THEN
8572: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8573: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8574: FND_MSG_PUB.Add;
8575: --END IF;
8576: FND_MSG_PUB.count_and_get(

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

8569:
8570: --IF (AMS_DEBUG_HIGH_ON) THEN
8571: --THEN
8572: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8573: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8574: FND_MSG_PUB.Add;
8575: --END IF;
8576: FND_MSG_PUB.count_and_get(
8577: p_encoded => FND_API.g_false,

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

8580: );
8581:
8582: EXCEPTION
8583: WHEN FND_API.G_EXC_ERROR THEN
8584: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8585: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8586: FND_MSG_PUB.Add;
8587: -- Check if reset of the status is required
8588: x_return_status := FND_API.G_RET_STS_ERROR ;

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

8581:
8582: EXCEPTION
8583: WHEN FND_API.G_EXC_ERROR THEN
8584: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8585: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8586: FND_MSG_PUB.Add;
8587: -- Check if reset of the status is required
8588: x_return_status := FND_API.G_RET_STS_ERROR ;
8589: FND_MSG_PUB.count_and_get(

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

8591: p_count => x_msg_count,
8592: p_data => x_msg_data);
8593:
8594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8595: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8596: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8597: FND_MSG_PUB.Add;
8598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8599: FND_MSG_PUB.count_and_get(

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

8592: p_data => x_msg_data);
8593:
8594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8595: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8596: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8597: FND_MSG_PUB.Add;
8598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8599: FND_MSG_PUB.count_and_get(
8600: p_encoded => FND_API.g_false,

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

8601: p_count => x_msg_count,
8602: p_data => x_msg_data);
8603:
8604: WHEN OTHERS THEN
8605: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8606: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8607: FND_MSG_PUB.Add;
8608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8609: FND_MSG_PUB.count_and_get(

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

8602: p_data => x_msg_data);
8603:
8604: WHEN OTHERS THEN
8605: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8606: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8607: FND_MSG_PUB.Add;
8608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8609: FND_MSG_PUB.count_and_get(
8610: p_encoded => FND_API.g_false,

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

8771: LOOP
8772: FETCH c_action_dets INTO l_action_dets_rec;
8773: EXIT WHEN c_action_dets%NOTFOUND;
8774:
8775: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8776: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : before IMMEDIATE');
8777: FND_MSG_PUB.Add;
8778: 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');
8779: 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 8776: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : before IMMEDIATE');

8772: FETCH c_action_dets INTO l_action_dets_rec;
8773: EXIT WHEN c_action_dets%NOTFOUND;
8774:
8775: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8776: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : before IMMEDIATE');
8777: FND_MSG_PUB.Add;
8778: 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');
8779: 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');
8780: if l_action_dets_rec.list_act_type = 'SQL' then

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

8904: else
8905: write_to_act_log('Process_'||l_action_dets_rec.list_act_type||' executed successfully.', 'LIST', g_list_header_id,'LOW');
8906: end if;
8907:
8908: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8909: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : AFTER IMMEDIATE');
8910: FND_MSG_PUB.Add;
8911:
8912: if l_action_dets_rec.list_action_type = 'INCLUDE' then

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

8905: write_to_act_log('Process_'||l_action_dets_rec.list_act_type||' executed successfully.', 'LIST', g_list_header_id,'LOW');
8906: end if;
8907:
8908: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8909: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : AFTER IMMEDIATE');
8910: FND_MSG_PUB.Add;
8911:
8912: if l_action_dets_rec.list_action_type = 'INCLUDE' then
8913: l_include_count := l_include_count +1 ;

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

9359: IF(c_action_dets%ISOPEN)THEN
9360: CLOSE c_action_dets;
9361: END IF;
9362: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9363: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9364: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9365: FND_MSG_PUB.Add;
9366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9367: FND_MSG_PUB.count_and_get(

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

9360: CLOSE c_action_dets;
9361: END IF;
9362: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9363: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9364: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9365: FND_MSG_PUB.Add;
9366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9367: FND_MSG_PUB.count_and_get(
9368: p_encoded => FND_API.g_false,

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

9373: IF(c_action_dets%ISOPEN)THEN
9374: CLOSE c_action_dets;
9375: END IF;
9376: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9377: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9378: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9379: FND_MSG_PUB.Add;
9380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9381: FND_MSG_PUB.count_and_get(

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

9374: CLOSE c_action_dets;
9375: END IF;
9376: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9377: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9378: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9379: FND_MSG_PUB.Add;
9380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9381: FND_MSG_PUB.count_and_get(
9382: p_encoded => FND_API.g_false,

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

9754:
9755: -- Checking if Debug is set. If debug is set then log debugging message
9756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
9757: THEN
9758: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9759: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : Start');
9760: FND_MSG_PUB.Add;
9761: END IF;
9762:

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

9755: -- Checking if Debug is set. If debug is set then log debugging message
9756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
9757: THEN
9758: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9759: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : Start');
9760: FND_MSG_PUB.Add;
9761: END IF;
9762:
9763: -- Initialize API return status to success

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

10261: -- Success Message
10262: -- MMSG
10263: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
10264: --THEN
10265: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
10266: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
10267: FND_MSG_PUB.Add;
10268: --END IF;
10269:

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

10262: -- MMSG
10263: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
10264: --THEN
10265: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
10266: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
10267: FND_MSG_PUB.Add;
10268: --END IF;
10269:
10270:

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

10270:
10271: x_return_status := FND_API.G_RET_STS_SUCCESS;
10272: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
10273: --THEN
10274: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10275: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List: END');
10276: FND_MSG_PUB.Add;
10277: --END IF;
10278: FND_MSG_PUB.count_and_get(

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

10271: x_return_status := FND_API.G_RET_STS_SUCCESS;
10272: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
10273: --THEN
10274: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10275: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List: END');
10276: FND_MSG_PUB.Add;
10277: --END IF;
10278: FND_MSG_PUB.count_and_get(
10279: p_encoded => FND_API.g_false,

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

10324: WHERE list_header_id = p_list_header_id;
10325: logger;
10326: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||
10327: --l_error_position||sqlerrm||sqlcode);
10328: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10329: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10330: FND_MSG_PUB.Add;
10331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10332: FND_MSG_PUB.count_and_get(

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

10325: logger;
10326: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||
10327: --l_error_position||sqlerrm||sqlcode);
10328: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10329: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10330: FND_MSG_PUB.Add;
10331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10332: FND_MSG_PUB.count_and_get(
10333: p_encoded => FND_API.g_false,

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

10352: logger;
10353:
10354: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||
10355: --l_error_position||sqlerrm||sqlcode);
10356: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10357: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10358: FND_MSG_PUB.Add;
10359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10360: FND_MSG_PUB.count_and_get(

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

10353:
10354: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||
10355: --l_error_position||sqlerrm||sqlcode);
10356: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10357: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10358: FND_MSG_PUB.Add;
10359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10360: FND_MSG_PUB.count_and_get(
10361: p_encoded => FND_API.g_false,

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

10516: END IF;
10517:
10518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
10519: THEN
10520: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LIST_RULE');
10521: FND_MSG_PUB.add;
10522: END IF;
10523:
10524: CLOSE c_list_rules;

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

10540: END IF;
10541: */
10542: Write_To_Act_Log ( 'More than one rule cannot be applied to the list','LIST',p_list_header_id ,'HIGH');
10543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
10544: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ONLY_ONE_LIST_RULE');
10545: FND_MSG_PUB.add;
10546: END IF;
10547:
10548: CLOSE c_list_rules;

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

11795: application => 'AMS',
11796: program => 'AMSLSRTC',
11797: argument1 => p_action_used_by_id);
11798: commit;
11799: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11800: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');
11801: FND_MSG_PUB.Add;
11802: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11803: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

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

11796: program => 'AMSLSRTC',
11797: argument1 => p_action_used_by_id);
11798: commit;
11799: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11800: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');
11801: FND_MSG_PUB.Add;
11802: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11803: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
11804: -- FND_MSG_PUB.Add;

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

11798: commit;
11799: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11800: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');
11801: FND_MSG_PUB.Add;
11802: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11803: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
11804: -- FND_MSG_PUB.Add;
11805: FND_MSG_PUB.count_and_get(
11806: p_encoded => FND_API.g_false,

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

11799: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11800: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');
11801: FND_MSG_PUB.Add;
11802: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11803: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
11804: -- FND_MSG_PUB.Add;
11805: FND_MSG_PUB.count_and_get(
11806: p_encoded => FND_API.g_false,
11807: p_count => x_msg_count,

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

11812: IF l_request_id = 0 THEN
11813: write_to_act_log('Unexpected Error for the program--concurrent program_id is '||to_char(l_request_id), 'LIST', g_list_header_id,'HIGH');
11814:
11815:
11816: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11817: FND_MESSAGE.Set_Token('TEXT', 'Error '|| sqlerrm||' '||sqlcode);
11818: FND_MSG_PUB.Add;
11819: FND_MSG_PUB.count_and_get(
11820: p_encoded => FND_API.g_false,

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

11813: write_to_act_log('Unexpected Error for the program--concurrent program_id is '||to_char(l_request_id), 'LIST', g_list_header_id,'HIGH');
11814:
11815:
11816: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11817: FND_MESSAGE.Set_Token('TEXT', 'Error '|| sqlerrm||' '||sqlcode);
11818: FND_MSG_PUB.Add;
11819: FND_MSG_PUB.count_and_get(
11820: p_encoded => FND_API.g_false,
11821: p_count => x_msg_count,

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

11939: IF (c_action_dets%ROWCOUNT = 1) THEN
11940: IF (p_action_rec.list_action_type <> 'INCLUDE')then
11941: write_to_act_log('Error. The action type of the first selection is NOT INCLUDE.', 'LIST', g_list_header_id,'HIGH');
11942: Ams_Utility_Pvt.Write_Conc_log('process list actions : first action INCLUDE check failed');
11943: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
11944: FND_MSG_PUB.Add;
11945: RAISE FND_API.G_EXC_ERROR;
11946: END IF; -- End of if for list_action_type check
11947: END IF; --End of Validation:- First Action Include Check

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

12132: END IF;
12133: Ams_Utility_Pvt.Write_Conc_log('Error: AMS_ListGeneration_PKG.Process_list_actions: '||sqlerrm||sqlcode);
12134: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'
12135: ||sqlerrm||sqlcode, 'LIST', g_list_header_id);
12136: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12137: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12138: FND_MSG_PUB.Add;
12139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12140: FND_MSG_PUB.count_and_get(

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

12133: Ams_Utility_Pvt.Write_Conc_log('Error: AMS_ListGeneration_PKG.Process_list_actions: '||sqlerrm||sqlcode);
12134: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'
12135: ||sqlerrm||sqlcode, 'LIST', g_list_header_id);
12136: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12137: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12138: FND_MSG_PUB.Add;
12139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12140: FND_MSG_PUB.count_and_get(
12141: p_encoded => FND_API.g_false,

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

12149: END IF;
12150: Ams_Utility_Pvt.Write_Conc_log('Error: AMS_ListGeneration_PKG.Process_list_actions: '||sqlerrm||sqlcode);
12151: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'
12152: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
12153: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12154: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12155: FND_MSG_PUB.Add;
12156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12157: FND_MSG_PUB.count_and_get(

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

12150: Ams_Utility_Pvt.Write_Conc_log('Error: AMS_ListGeneration_PKG.Process_list_actions: '||sqlerrm||sqlcode);
12151: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'
12152: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
12153: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12154: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12155: FND_MSG_PUB.Add;
12156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12157: FND_MSG_PUB.count_and_get(
12158: p_encoded => FND_API.g_false,

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

12514:
12515: -- write_to_act_log('Process_rt_all_sql l_found : '||l_found,'LIST', g_list_header_id);
12516: -- write_to_act_log('Process_rt_all_sql return status: After validate_sql_string call ','LIST', g_list_header_id);
12517: if l_found = 'N' then
12518: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');
12519: FND_MSG_PUB.Add;
12520: RAISE FND_API.G_EXC_ERROR;
12521: end if;
12522: /* write_to_act_log('Process_rt_all_sql: FROM Position ->'|| l_from_position ||

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

12534: x_source_object_name => l_source_object_name,
12535: x_source_object_pk_field => l_source_object_pk_field);
12536:
12537: if l_found = 'N' then
12538: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');
12539: FND_MSG_PUB.Add;
12540: RAISE FND_API.G_EXC_ERROR;
12541: end if;
12542: write_to_act_log('Master type is '|| l_master_type ||'<--' , 'LIST', g_list_header_id,'LOW');