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 AMS_LISTGENERATION_PKG

Line 1: PACKAGE BODY AMS_LISTGENERATION_PKG as

1: PACKAGE BODY AMS_LISTGENERATION_PKG as
2: /* $Header: amsvlgnb.pls 120.33.12010000.2 2008/08/04 09:50:08 rsatyava ship $ */
3: -- Start of Comments
4: -- NAME
5: -- AMS_LISTGENERATION

Line 32: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_LISTGENERATION_PKG';

28: -- list generation.
29: -- End of Comments
30:
31:
32: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_LISTGENERATION_PKG';
33: G_FILE_NAME CONSTANT VARCHAR2(12):='amslsgnb.pls';
34:
35: G_MAX_SQL_STR_LEN CONSTANT NUMBER := 2000;
36: G_MAX_STRING_LEN CONSTANT NUMBER := 32767;

Line 4080: AMS_ListGeneration_PKG.process_'||p_action_rec.arc_incl_object_from ||

4076: write_to_act_log('Calling process_'||p_action_rec.arc_incl_object_from,'LIST',g_list_header_id,'LOW');
4077: write_to_act_log('p_action_rec.list_select_action_id = '||p_action_rec.list_select_action_id, 'LIST', g_list_header_id,'LOW');
4078: execute immediate
4079: 'BEGIN
4080: AMS_ListGeneration_PKG.process_'||p_action_rec.arc_incl_object_from ||
4081: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12) ;
4082: END;'
4083: using p_action_used_by_id,
4084: p_action_rec.incl_object_id ,

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 8876: AMS_ListGeneration_PKG.process_'||l_action_dets_rec.list_act_type ||

8872:
8873: write_to_act_log('Calling process_'||l_action_dets_rec.list_act_type,'LIST',g_list_header_id,'LOW');
8874: execute immediate
8875: 'BEGIN
8876: AMS_ListGeneration_PKG.process_'||l_action_dets_rec.list_act_type ||
8877: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12) ;
8878: END;'
8879: using p_action_used_by_id,
8880: l_action_dets_rec.list_header_id ,

Line 10247: AMS_LISTGENERATION_PKG.Update_List_Dets(g_list_header_id ,x_return_status ) ;

10243: arc_list_used_by_source = p_list_used_by ,
10244: source_code_for_id = p_list_used_by_id
10245: where list_header_id = g_list_header_id ;
10246:
10247: AMS_LISTGENERATION_PKG.Update_List_Dets(g_list_header_id ,x_return_status ) ;
10248: */
10249: -- calling logging program
10250: write_to_act_log('Execution of procedure generate_target_group completed. Target group generated successfully ','LIST', g_list_header_id, 'HIGH');
10251: --logger; -- will be called from ams_act_list_pvt proc.

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 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 10302: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List: '||

10298: WHERE list_header_id = p_list_header_id;
10299:
10300: logger;
10301:
10302: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List: '||
10303: --l_error_position||sqlerrm||sqlcode);
10304: -- Check if reset of the status is required
10305: x_return_status := FND_API.G_RET_STS_ERROR ;
10306: FND_MSG_PUB.count_and_get(

Line 10326: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||

10322: ctrl_status_code = 'DRAFT',
10323: no_of_rows_in_ctrl_group = null
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;

Line 10354: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||

10350: WHERE list_header_id = p_list_header_id;
10351:
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;

Line 11973: write_to_act_log('Calling AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from, 'LIST', g_list_header_id,'LOW');

11969: If the object type is of CELL the process will be procecss_cell
11970: Using the same logic the procedure could be extended for new
11971: action types
11972: *********************************************************************/
11973: write_to_act_log('Calling AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from, 'LIST', g_list_header_id,'LOW');
11974: execute immediate
11975: 'BEGIN
11976: AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from ||
11977: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12) ;

Line 11976: AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from ||

11972: *********************************************************************/
11973: write_to_act_log('Calling AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from, 'LIST', g_list_header_id,'LOW');
11974: execute immediate
11975: 'BEGIN
11976: AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from ||
11977: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12) ;
11978: END;'
11979: using p_action_used_by_id,
11980: p_action_rec.incl_object_id ,

Line 11992: write_to_act_log('Executed AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from, 'LIST', g_list_header_id,'LOW');

11988: in OUT x_return_status ,
11989: OUT l_std_sql ,
11990: OUT l_include_sql;
11991: Ams_Utility_Pvt.Write_Conc_log('calc_selection_running_total : End Dynamic 001-> ');
11992: write_to_act_log('Executed AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from, 'LIST', g_list_header_id,'LOW');
11993: if p_action_rec.list_action_type = 'INCLUDE' then
11994: Ams_Utility_Pvt.Write_Conc_log('calc_selection_running_total include: '||to_char(l_include_count));
11995: l_include_count := l_include_count +1 ;
11996: l_include_sql_tbl(l_include_count) := l_include_sql ;

Line 12133: Ams_Utility_Pvt.Write_Conc_log('Error: AMS_ListGeneration_PKG.Process_list_actions: '||sqlerrm||sqlcode);

12129: write_to_act_log('Error while executing procedure calc_running_total '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12130: IF(c_action_dets%ISOPEN)THEN
12131: CLOSE c_action_dets;
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);

Line 12134: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'

12130: IF(c_action_dets%ISOPEN)THEN
12131: CLOSE c_action_dets;
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;

Line 12150: Ams_Utility_Pvt.Write_Conc_log('Error: AMS_ListGeneration_PKG.Process_list_actions: '||sqlerrm||sqlcode);

12146: write_to_act_log('Error while executing procedure calc_running_total '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12147: IF(c_action_dets%ISOPEN)THEN
12148: CLOSE c_action_dets;
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);

Line 12151: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'

12147: IF(c_action_dets%ISOPEN)THEN
12148: CLOSE c_action_dets;
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;

Line 12825: write_to_act_log('AMS_ListGeneration_PKG.After Comp sql:', 'LIST', g_list_header_id,'LOW');

12821: p_cell_id => p_incl_object_id ,
12822: p_party_id_only => FND_API.g_false,
12823: x_sql_tbl => l_sql_2
12824: );
12825: write_to_act_log('AMS_ListGeneration_PKG.After Comp sql:', 'LIST', g_list_header_id,'LOW');
12826:
12827: l_sql_string_final := '';
12828: for i in 1 .. l_sql_2.last
12829: loop

Line 14074: END AMS_ListGeneration_PKG;

14070: x_msg_data := 'Error while executing upd_list_header_info. '||sqlcode||' '||sqlerrm;
14071: x_msg_count := 1;
14072: end upd_list_header_info;
14073:
14074: END AMS_ListGeneration_PKG;