DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on FND_PROFILE

Line 34: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');

30: | status. |
31: | |
32: +===========================================================================*/
33:
34: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
35: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_MOBILE_TXN';
36:
37: /*+========================================================================+
38: | PROCEDURE NAME

Line 822: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

818:
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820: x_error_msg := ' ';
821:
822: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
823:
824: IF l_date_format IS NULL THEN
825: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
826: END IF;

Line 825: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

821:
822: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
823:
824: IF l_date_format IS NULL THEN
825: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
826: END IF;
827:
828: OPEN x_txn_cursor FOR
829: SELECT

Line 1757: fnd_profile.put('USER_ID',to_char(p_user_id));

1753: gme_debug.put_line('Qty Type = '||p_qty_type);
1754: gme_debug.put_line('Org Code = '||p_org_code);
1755: END IF;
1756:
1757: fnd_profile.put('USER_ID',to_char(p_user_id));
1758: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
1759:
1760: x_return_status := FND_API.G_RET_STS_SUCCESS;
1761: x_error_msg := ' ';

Line 1758: fnd_profile.put('LOGIN_ID',to_char(p_login_id));

1754: gme_debug.put_line('Org Code = '||p_org_code);
1755: END IF;
1756:
1757: fnd_profile.put('USER_ID',to_char(p_user_id));
1758: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
1759:
1760: x_return_status := FND_API.G_RET_STS_SUCCESS;
1761: x_error_msg := ' ';
1762:

Line 1859: fnd_profile.put('USER_ID',to_char(p_uid));

1855: IF (g_debug IS NOT NULL) THEN
1856: gme_debug.log_initialize ('MobileSaveRsrcUsage');
1857: END IF;
1858:
1859: fnd_profile.put('USER_ID',to_char(p_uid));
1860: gme_common_pvt.g_user_ident := p_uid;
1861:
1862: l_input_rec.batchstep_resource_id := p_resource_id;
1863: l_input_rec.actual_rsrc_count := to_number(p_count);

Line 1954: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

1950:
1951: x_return_status := FND_API.G_RET_STS_SUCCESS;
1952: x_error_msg := ' ';
1953:
1954: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
1955:
1956: IF l_date_format IS NULL THEN
1957: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
1958: END IF;

Line 1957: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

1953:
1954: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
1955:
1956: IF l_date_format IS NULL THEN
1957: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
1958: END IF;
1959:
1960: OPEN x_lot_cursor FOR
1961: SELECT

Line 2017: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

2013:
2014: x_return_status := FND_API.G_RET_STS_SUCCESS;
2015: x_error_msg := ' ';
2016:
2017: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2018:
2019: IF l_date_format IS NULL THEN
2020: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
2021: END IF;

Line 2020: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

2016:
2017: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2018:
2019: IF l_date_format IS NULL THEN
2020: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
2021: END IF;
2022:
2023: OPEN x_lot_cursor FOR
2024: SELECT

Line 2134: fnd_profile.put('USER_ID',to_char(p_user_id));

2130:
2131: x_return_status := FND_API.G_RET_STS_SUCCESS;
2132: x_error_msg := ' ';
2133:
2134: fnd_profile.put('USER_ID',to_char(p_user_id));
2135: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
2136:
2137: -- nsinghi bug#5236702
2138: OPEN get_item_duom_ctl;

Line 2135: fnd_profile.put('LOGIN_ID',to_char(p_login_id));

2131: x_return_status := FND_API.G_RET_STS_SUCCESS;
2132: x_error_msg := ' ';
2133:
2134: fnd_profile.put('USER_ID',to_char(p_user_id));
2135: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
2136:
2137: -- nsinghi bug#5236702
2138: OPEN get_item_duom_ctl;
2139: FETCH get_item_duom_ctl INTO l_duom_ctl;

Line 2246: fnd_profile.put('USER_ID',to_char(p_user_id));

2242:
2243: x_return_status := FND_API.G_RET_STS_SUCCESS;
2244: x_error_msg := ' ';
2245:
2246: fnd_profile.put('USER_ID',to_char(p_user_id));
2247: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
2248:
2249: IF p_sequence IS NULL THEN
2250: --- Set sequence to the last value

Line 2247: fnd_profile.put('LOGIN_ID',to_char(p_login_id));

2243: x_return_status := FND_API.G_RET_STS_SUCCESS;
2244: x_error_msg := ' ';
2245:
2246: fnd_profile.put('USER_ID',to_char(p_user_id));
2247: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
2248:
2249: IF p_sequence IS NULL THEN
2250: --- Set sequence to the last value
2251: l_pending_product_lots_rec.sequence := FND_API.G_MISS_NUM;

Line 3338: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

3334:
3335: x_return_status := FND_API.G_RET_STS_SUCCESS;
3336: x_error_msg := ' ';
3337:
3338: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3339:
3340: IF l_date_format IS NULL THEN
3341: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3342: END IF;

Line 3341: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

3337:
3338: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3339:
3340: IF l_date_format IS NULL THEN
3341: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3342: END IF;
3343:
3344: OPEN x_txn_cursor FOR
3345: SELECT DISTINCT

Line 3415: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

3411:
3412: x_return_status := FND_API.G_RET_STS_SUCCESS;
3413: x_error_msg := ' ';
3414:
3415: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3416:
3417: IF l_date_format IS NULL THEN
3418: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3419: END IF;

Line 3418: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

3414:
3415: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3416:
3417: IF l_date_format IS NULL THEN
3418: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3419: END IF;
3420:
3421: l_txn_type_id := Get_Txn_Type(p_txn_type_id);
3422:

Line 3629: fnd_profile.put('USER_ID',to_char(p_uid));

3625:
3626: l_act_strt_dt := TO_DATE(p_act_strt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3627: l_act_complt_dt := TO_DATE(p_act_complt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3628:
3629: fnd_profile.put('USER_ID',to_char(p_uid));
3630: gme_common_pvt.g_user_name := p_uname;
3631: gme_common_pvt.g_user_ident := p_uid;
3632: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3633: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

Line 3632: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));

3628:
3629: fnd_profile.put('USER_ID',to_char(p_uid));
3630: gme_common_pvt.g_user_name := p_uname;
3631: gme_common_pvt.g_user_ident := p_uid;
3632: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3633: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3634:
3635: l_batch_header.batch_id := p_batch_id;
3636: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header, l_batch_header)) THEN

Line 3633: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

3629: fnd_profile.put('USER_ID',to_char(p_uid));
3630: gme_common_pvt.g_user_name := p_uname;
3631: gme_common_pvt.g_user_ident := p_uid;
3632: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3633: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3634:
3635: l_batch_header.batch_id := p_batch_id;
3636: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header, l_batch_header)) THEN
3637: RAISE expected_error;

Line 3740: FND_PROFILE.put('USER_ID',to_char(p_uid));

3736: l_api_name VARCHAR2(30) := 'End_Cmplt_Actual_Rsrc_Txn';
3737: BEGIN
3738: x_return_status := FND_API.G_RET_STS_SUCCESS;
3739: x_error_msg := '';
3740: FND_PROFILE.put('USER_ID',to_char(p_uid));
3741: gme_common_pvt.g_user_name := p_uname;
3742: gme_common_pvt.g_user_ident := p_uid;
3743: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3744: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

Line 3743: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));

3739: x_error_msg := '';
3740: FND_PROFILE.put('USER_ID',to_char(p_uid));
3741: gme_common_pvt.g_user_name := p_uname;
3742: gme_common_pvt.g_user_ident := p_uid;
3743: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3744: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3745:
3746: l_in_rsrc_txn_rec.poc_trans_id := p_trans_id;
3747: l_in_rsrc_txn_rec.organization_id := p_organization_id;

Line 3744: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

3740: FND_PROFILE.put('USER_ID',to_char(p_uid));
3741: gme_common_pvt.g_user_name := p_uname;
3742: gme_common_pvt.g_user_ident := p_uid;
3743: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3744: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3745:
3746: l_in_rsrc_txn_rec.poc_trans_id := p_trans_id;
3747: l_in_rsrc_txn_rec.organization_id := p_organization_id;
3748: l_in_rsrc_txn_rec.trans_date := p_trans_date;

Line 3831: fnd_profile.put('USER_ID',to_char(p_uid));

3827: x_return_status := FND_API.G_RET_STS_SUCCESS;
3828:
3829: l_act_strt_dt := TO_DATE(p_act_strt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3830:
3831: fnd_profile.put('USER_ID',to_char(p_uid));
3832: gme_common_pvt.g_user_name := p_uname;
3833: gme_common_pvt.g_user_ident := p_uid;
3834: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3835: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

Line 3834: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));

3830:
3831: fnd_profile.put('USER_ID',to_char(p_uid));
3832: gme_common_pvt.g_user_name := p_uname;
3833: gme_common_pvt.g_user_ident := p_uid;
3834: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3835: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3836:
3837: l_batch_hdr_rec.batch_id := p_batch_id;
3838: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec)) THEN

Line 3835: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

3831: fnd_profile.put('USER_ID',to_char(p_uid));
3832: gme_common_pvt.g_user_name := p_uname;
3833: gme_common_pvt.g_user_ident := p_uid;
3834: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3835: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3836:
3837: l_batch_hdr_rec.batch_id := p_batch_id;
3838: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec)) THEN
3839: RAISE expected_error;

Line 3927: FND_PROFILE.put('USER_ID',to_char(p_uid));

3923: l_api_name VARCHAR2(30) := 'Start_Cmplt_Actual_Rsrc_Txn';
3924: BEGIN
3925: x_return_status := FND_API.G_RET_STS_SUCCESS;
3926: x_error_msg := '';
3927: FND_PROFILE.put('USER_ID',to_char(p_uid));
3928: gme_common_pvt.g_user_name := p_uname;
3929: gme_common_pvt.g_user_ident := p_uid;
3930: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3931: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

Line 3930: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));

3926: x_error_msg := '';
3927: FND_PROFILE.put('USER_ID',to_char(p_uid));
3928: gme_common_pvt.g_user_name := p_uname;
3929: gme_common_pvt.g_user_ident := p_uid;
3930: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3931: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3932: l_in_rsrc_txn_rec.line_id := p_resource_id;
3933: l_in_rsrc_txn_rec.organization_id := p_organization_id;
3934: l_in_rsrc_txn_rec.start_date := p_start_date;

Line 3931: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

3927: FND_PROFILE.put('USER_ID',to_char(p_uid));
3928: gme_common_pvt.g_user_name := p_uname;
3929: gme_common_pvt.g_user_ident := p_uid;
3930: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3931: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3932: l_in_rsrc_txn_rec.line_id := p_resource_id;
3933: l_in_rsrc_txn_rec.organization_id := p_organization_id;
3934: l_in_rsrc_txn_rec.start_date := p_start_date;
3935: l_in_rsrc_txn_rec.end_date := p_start_date;

Line 4160: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);

4156:
4157: END IF;
4158:
4159: --getting the date into either mwa date format mask or ICX date format mask
4160: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
4161:
4162: IF l_date_format IS NULL THEN
4163: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
4164: END IF;

Line 4163: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);

4159: --getting the date into either mwa date format mask or ICX date format mask
4160: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
4161:
4162: IF l_date_format IS NULL THEN
4163: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
4164: END IF;
4165:
4166: x_trans_date := TO_CHAR(l_trans_date,l_date_format||HOUR_MIN_SEC_FORMAT_STRING);
4167: