DBA Data[Home] [Help]

APPS.GMF_ALLOC_PROC dependencies on FND_FLEX_EXT

Line 928: * string need to be formatted properly before passing it to API fnd_flex_ext.get_ccid()

924: * Sukarna Reddy Modified code for convergence. July 2005.
925: * Himadri Chakroborty Modified code for Bug 6133153.July 2007.
926: * 31-DEC-2009 Uday Phadtare Bug 9241807.
927: * When enabled segments in Accounting Flexfield are not in sequence, concatenated_segments
928: * string need to be formatted properly before passing it to API fnd_flex_ext.get_ccid()
929: * to avoid error 'Values have not been entered for one or more required segments'.
930: * Bug 14178149 Prasad marada. Added a ref cursor object to the argument of
931: * proc_gl_get_balances just to maintain the state and ref_cursor cannot be declared
932: * global

Line 990: l_seg_array fnd_flex_ext.SegmentArray;

986: x_to_account_id NUMBER(15);
987: l_to_segment_id NUMBER;
988: l_from_segment_id NUMBER;
989: l_n_segs NUMBER;
990: l_seg_array fnd_flex_ext.SegmentArray;
991: l_gl_fiscal_year NUMBER(15);
992: l_gl_period NUMBER(15);
993: l_return_status NUMBER(5);
994: /* B6133153 GL allocation of expenses are not showing after running the GL allocation process */

Line 1030: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Calling FND_FLEX_EXT.GET_SEGMENTS() API');

1026: fetch cur_bal_type INTO x_in_actual_flag;
1027: close cur_bal_type;
1028:
1029: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1030: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Calling FND_FLEX_EXT.GET_SEGMENTS() API');
1031: END IF;
1032:
1033: x_return_status := fnd_flex_ext.get_segments (
1034: application_short_name => 'SQLGL',

Line 1033: x_return_status := fnd_flex_ext.get_segments (

1029: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1030: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Calling FND_FLEX_EXT.GET_SEGMENTS() API');
1031: END IF;
1032:
1033: x_return_status := fnd_flex_ext.get_segments (
1034: application_short_name => 'SQLGL',
1035: key_flex_code => 'GL#',
1036: structure_number => g_structure_number,
1037: combination_id => v_from_segment,

Line 1058: x_return_status := fnd_flex_ext.get_segments(application_short_name => 'SQLGL',

1054: alloc_log_msg(C_LOG_FILE,FND_MESSAGE.GET);
1055: RETURN;
1056: END IF;
1057:
1058: x_return_status := fnd_flex_ext.get_segments(application_short_name => 'SQLGL',
1059: key_flex_code => 'GL#',
1060: structure_number => g_structure_number,
1061: combination_id => v_to_segment,
1062: n_segments => l_n_segs,

Line 1080: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Finished Calling FND_FLEX_EXT.GET_SEGMENTS() API');

1076: RETURN;
1077: END IF;
1078:
1079: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1080: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Finished Calling FND_FLEX_EXT.GET_SEGMENTS() API');
1081: END IF;
1082:
1083: x_in_ytd_ptd := v_ytd_ptd;
1084:

Line 1184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Calling FND_FLEX_EXT.GET_COMBINATION_ID() API');

1180: IF (x_error_status <> 100 AND x_error_status >= 0) THEN
1181: /* INVCONV sschinch */
1182: /**Bug#12600219 - Replaced this code with following, as now we are using X_to_segment_ccid to identify account
1183: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Calling FND_FLEX_EXT.GET_COMBINATION_ID() API');
1185: END IF;
1186: x_to_account_id := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
1187: key_flex_code => 'GL#',
1188: structure_number => g_structure_number,

Line 1186: x_to_account_id := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',

1182: /**Bug#12600219 - Replaced this code with following, as now we are using X_to_segment_ccid to identify account
1183: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Calling FND_FLEX_EXT.GET_COMBINATION_ID() API');
1185: END IF;
1186: x_to_account_id := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
1187: key_flex_code => 'GL#',
1188: structure_number => g_structure_number,
1189: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),
1190: concatenated_segments => l_new_x_to_segment

Line 1189: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),

1185: END IF;
1186: x_to_account_id := fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
1187: key_flex_code => 'GL#',
1188: structure_number => g_structure_number,
1189: validation_date => to_char(SYSDATE,FND_FLEX_EXT.DATE_FORMAT),
1190: concatenated_segments => l_new_x_to_segment
1191: );
1192: IF (x_to_account_id > 0) THEN
1193: insert_alloc_inp(v_alloc_id,

Line 1204: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,g_calling_module,'Error returned from FND_FLEX_EXT.GET_COMBINATION_ID() API '||l_mesg_text);

1200: ELSE
1201: l_mesg_text := FND_MESSAGE.GET;
1202: alloc_log_msg(C_LOG_FILE,l_mesg_text);
1203: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1204: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,g_calling_module,'Error returned from FND_FLEX_EXT.GET_COMBINATION_ID() API '||l_mesg_text);
1205: END IF;
1206: END IF;
1207: **/
1208:

Line 1221: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Calling FND_FLEX_EXT.GET_SEGMENTS() API');

1217: alloc_log_msg(C_LOG_FILE, ' AccountId: '||to_char(X_to_segment_ccid)|| ' Amount = '||to_char(x_amount));
1218:
1219: /* Now, fetching account using ccid just to display it in log (START)*/
1220: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1221: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Calling FND_FLEX_EXT.GET_SEGMENTS() API');
1222: END IF;
1223:
1224: x_return_status := fnd_flex_ext.get_segments(application_short_name => 'SQLGL',
1225: key_flex_code => 'GL#',

Line 1224: x_return_status := fnd_flex_ext.get_segments(application_short_name => 'SQLGL',

1220: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1221: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Calling FND_FLEX_EXT.GET_SEGMENTS() API');
1222: END IF;
1223:
1224: x_return_status := fnd_flex_ext.get_segments(application_short_name => 'SQLGL',
1225: key_flex_code => 'GL#',
1226: structure_number => g_structure_number,
1227: combination_id => X_to_segment_ccid,
1228: n_segments => l_n_segs,

Line 1247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Finished Calling FND_FLEX_EXT.GET_SEGMENTS() API');

1243: RETURN;
1244: END IF;
1245:
1246: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,g_calling_module,'Finished Calling FND_FLEX_EXT.GET_SEGMENTS() API');
1248: END IF;
1249: /* Now, fetching account using ccid just to display it in log (END)*/
1250: ELSE
1251: alloc_log_msg(C_LOG_FILE, ' WARNING: Incorrect X_to_segment_ccid, NOT inserting into gl_aloc_inp : '||to_char(X_to_segment_ccid));