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.38.12020000.3 2012/09/28 06:14:23 sagpraka 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 4081: AMS_ListGeneration_PKG.process_'||p_action_rec.arc_incl_object_from ||

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

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

8967:
8968: write_to_act_log('Calling process_'||l_action_dets_rec.list_act_type,'LIST',g_list_header_id,'LOW');
8969: execute immediate
8970: 'BEGIN
8971: AMS_ListGeneration_PKG.process_'||l_action_dets_rec.list_act_type ||
8972: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12) ;
8973: END;'
8974: using p_action_used_by_id,
8975: l_action_dets_rec.list_header_id ,

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

10344: arc_list_used_by_source = p_list_used_by ,
10345: source_code_for_id = p_list_used_by_id
10346: where list_header_id = g_list_header_id ;
10347:
10348: AMS_LISTGENERATION_PKG.Update_List_Dets(g_list_header_id ,x_return_status ) ;
10349: */
10350: -- calling logging program
10351: write_to_act_log('Execution of procedure generate_target_group completed. Target group generated successfully ','LIST', g_list_header_id, 'HIGH');
10352: --logger; -- will be called from ams_act_list_pvt proc.

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

10399: WHERE list_header_id = p_list_header_id;
10400:
10401: logger;
10402:
10403: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List: '||
10404: --l_error_position||sqlerrm||sqlcode);
10405: -- Check if reset of the status is required
10406: x_return_status := FND_API.G_RET_STS_ERROR ;
10407: FND_MSG_PUB.count_and_get(

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

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

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

10451: WHERE list_header_id = p_list_header_id;
10452:
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;

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

12070: If the object type is of CELL the process will be procecss_cell
12071: Using the same logic the procedure could be extended for new
12072: action types
12073: *********************************************************************/
12074: write_to_act_log('Calling AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from, 'LIST', g_list_header_id,'LOW');
12075: execute immediate
12076: 'BEGIN
12077: AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from ||
12078: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12) ;

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

12073: *********************************************************************/
12074: write_to_act_log('Calling AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from, 'LIST', g_list_header_id,'LOW');
12075: execute immediate
12076: 'BEGIN
12077: AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from ||
12078: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12) ;
12079: END;'
12080: using p_action_used_by_id,
12081: p_action_rec.incl_object_id ,

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

12089: in OUT x_return_status ,
12090: OUT l_std_sql ,
12091: OUT l_include_sql;
12092: Ams_Utility_Pvt.Write_Conc_log('calc_selection_running_total : End Dynamic 001-> ');
12093: write_to_act_log('Executed AMS_ListGeneration_PKG.process_run_total_'||p_action_rec.arc_incl_object_from, 'LIST', g_list_header_id,'LOW');
12094: if p_action_rec.list_action_type = 'INCLUDE' then
12095: Ams_Utility_Pvt.Write_Conc_log('calc_selection_running_total include: '||to_char(l_include_count));
12096: l_include_count := l_include_count +1 ;
12097: l_include_sql_tbl(l_include_count) := l_include_sql ;

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

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

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

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

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

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

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

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

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

12922: p_cell_id => p_incl_object_id ,
12923: p_party_id_only => FND_API.g_false,
12924: x_sql_tbl => l_sql_2
12925: );
12926: write_to_act_log('AMS_ListGeneration_PKG.After Comp sql:', 'LIST', g_list_header_id,'LOW');
12927:
12928: l_sql_string_final := '';
12929: for i in 1 .. l_sql_2.last
12930: loop

Line 14175: END AMS_ListGeneration_PKG;

14171: x_msg_data := 'Error while executing upd_list_header_info. '||sqlcode||' '||sqlerrm;
14172: x_msg_count := 1;
14173: end upd_list_header_info;
14174:
14175: END AMS_ListGeneration_PKG;