DBA Data[Home] [Help]

APPS.MSC_SCE_LOADS_PKG dependencies on FND_PROFILE

Line 9: G_OVERWRITE_OF varchar2(1) := nvl(fnd_profile.value('MSC_X_OVERWRITE_OF'),'N');

5: G_USER_IS_ADMIN number;
6: SYS_YES CONSTANT number := 1;
7: SYS_NO CONSTANT number := 2;
8:
9: G_OVERWRITE_OF varchar2(1) := nvl(fnd_profile.value('MSC_X_OVERWRITE_OF'),'N');
10: G_MSC_CP_DEBUG VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');
11: --Consigned CVMI Enh : Bug # 4562914
12: G_CVMI_PROFILE VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_X_CVMI_CA_MAND'), 'N') ;
13:

Line 10: G_MSC_CP_DEBUG VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');

6: SYS_YES CONSTANT number := 1;
7: SYS_NO CONSTANT number := 2;
8:
9: G_OVERWRITE_OF varchar2(1) := nvl(fnd_profile.value('MSC_X_OVERWRITE_OF'),'N');
10: G_MSC_CP_DEBUG VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');
11: --Consigned CVMI Enh : Bug # 4562914
12: G_CVMI_PROFILE VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_X_CVMI_CA_MAND'), 'N') ;
13:
14: PROCEDURE get_user_id (

Line 12: G_CVMI_PROFILE VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_X_CVMI_CA_MAND'), 'N') ;

8:
9: G_OVERWRITE_OF varchar2(1) := nvl(fnd_profile.value('MSC_X_OVERWRITE_OF'),'N');
10: G_MSC_CP_DEBUG VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');
11: --Consigned CVMI Enh : Bug # 4562914
12: G_CVMI_PROFILE VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_X_CVMI_CA_MAND'), 'N') ;
13:
14: PROCEDURE get_user_id (
15: p_int_control_number IN NUMBER,
16: p_user_id OUT NOCOPY NUMBER

Line 652: IF (Nvl(fnd_profile.value('MSC_X_CVMI_CA_MAND'),'N') = 'Y') THEN

648: /* ADD Validation: Check if Order Number is provided if profile option :
649: MSC: Order Number-CA Mandatory for CVMI is set to YES */
650: --================================================================================
651:
652: IF (Nvl(fnd_profile.value('MSC_X_CVMI_CA_MAND'),'N') = 'Y') THEN
653:
654: log_debug('Order number is Mandatory for Consumption Advice');
655: l_err_msg := get_message('MSC', 'MSC_X_INVALID_ORDER_NUMBER', p_language);
656:

Line 2859: log_debug('MSC_X_OVERWRITE_SC := ' || fnd_profile.value('MSC_X_OVERWRITE_SC'));

2855:
2856: END IF; /* if p_build_err <> 2 */
2857:
2858: --Added for bug 3103879
2859: log_debug('MSC_X_OVERWRITE_SC := ' || fnd_profile.value('MSC_X_OVERWRITE_SC'));
2860: IF (Nvl(fnd_profile.value('MSC_X_OVERWRITE_SC'),'N') = 'Y') THEN
2861: OPEN c_delete_supply_commit(p_header_id, p_language);
2862: FETCH c_delete_supply_commit
2863: bulk collect INTO t_del_pub_id,

Line 2860: IF (Nvl(fnd_profile.value('MSC_X_OVERWRITE_SC'),'N') = 'Y') THEN

2856: END IF; /* if p_build_err <> 2 */
2857:
2858: --Added for bug 3103879
2859: log_debug('MSC_X_OVERWRITE_SC := ' || fnd_profile.value('MSC_X_OVERWRITE_SC'));
2860: IF (Nvl(fnd_profile.value('MSC_X_OVERWRITE_SC'),'N') = 'Y') THEN
2861: OPEN c_delete_supply_commit(p_header_id, p_language);
2862: FETCH c_delete_supply_commit
2863: bulk collect INTO t_del_pub_id,
2864: t_del_pub_site_id,

Line 3058: full_language := fnd_profile.value('ICX_LANGUAGE');

3054:
3055: language := USERENV('LANG');
3056: IF(language is null) THEN
3057:
3058: full_language := fnd_profile.value('ICX_LANGUAGE');
3059:
3060: IF full_language IS NOT NULL THEN
3061: SELECT language_code
3062: INTO language

Line 3074: date_format := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY');

3070: if language is null then
3071: language := 'US';
3072: end if;
3073: */
3074: date_format := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY');
3075: mailDate := to_char(sysdate, date_format) ;
3076:
3077: IF p_status = G_SUCCESS THEN
3078: msg_txt := get_message('MSC', 'MSC_X_LOADS_SUCCESS', language);

Line 5095: to_char(sd.receipt_date,NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY')),

5091: p_header_id in number
5092: ) IS
5093: select sd.inventory_item_id,
5094: sd.primary_quantity,
5095: to_char(sd.receipt_date,NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY')),
5096: nvl(sd.customer_id, sd.publisher_id),
5097: nvl(sd.customer_site_id, sd.publisher_site_id),
5098: nvl(sd.supplier_id, sd.publisher_id),
5099: nvl(sd.supplier_site_id, sd.publisher_site_id),

Line 5328: l_language := fnd_profile.value('ICX_LANGUAGE');

5324: l_language_code := USERENV('LANG');
5325: G_USER_IS_ADMIN := is_user_admin(l_user_id);
5326:
5327: IF(l_language_code is null) THEN
5328: l_language := fnd_profile.value('ICX_LANGUAGE');
5329:
5330: IF l_language IS NOT NULL THEN
5331: SELECT language_code
5332: INTO l_language_code

Line 5354: l_date_format := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY HH24:MI:SS');

5350: into G_DAY_DESC
5351: USING l_language_code;
5352:
5353: IF p_build_err = 1 THEN
5354: l_date_format := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD/MM/YYYY HH24:MI:SS');
5355: ELSE
5356: l_date_format := 'DD/MM/YYYY HH24:MI:SS';
5357: END IF;
5358:

Line 7270: l_msc_x_auto_scem_mode := FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE');

7266: l_msc_x_auto_scem_mode NUMBER;
7267: l_msc_x_configuration NUMBER;
7268: BEGIN
7269: l_order_type_flag := 0;
7270: l_msc_x_auto_scem_mode := FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE');
7271: l_msc_x_configuration := FND_PROFILE.VALUE('MSC_X_CONFIGURATION');
7272: BEGIN
7273: select 1
7274: into l_order_type_flag

Line 7271: l_msc_x_configuration := FND_PROFILE.VALUE('MSC_X_CONFIGURATION');

7267: l_msc_x_configuration NUMBER;
7268: BEGIN
7269: l_order_type_flag := 0;
7270: l_msc_x_auto_scem_mode := FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE');
7271: l_msc_x_configuration := FND_PROFILE.VALUE('MSC_X_CONFIGURATION');
7272: BEGIN
7273: select 1
7274: into l_order_type_flag
7275: from dual

Line 10125: IF NVL(FND_PROFILE.VALUE('MSC_DEFAULT_SERIAL_CONTROL'),'Y') ='Y' THEN

10121:
10122: --=======================================================
10123: -- Validation 7: check for the serial_number_flag if the profile is
10124: --========================================================
10125: IF NVL(FND_PROFILE.VALUE('MSC_DEFAULT_SERIAL_CONTROL'),'Y') ='Y' THEN
10126: l_err_msg := get_message('MSC', 'MSC_X_INVALID_SERIAL_FLAG', p_language);
10127: FORALL j IN t_line_id.FIRST..t_line_id.LAST
10128: UPDATE /*+ parallel(mssn,5) */
10129: msc_st_serial_numbers mssn