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.

[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on FND_PROFILE

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

48: | Validate_Step_Completion_Date to compare the input dates |
49: | after converting them to the correct format |
50: +===========================================================================*/
51:
52: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
53: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_MOBILE_TXN';
54:
55: /*+========================================================================+
56: | PROCEDURE NAME

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

909:
910: x_return_status := FND_API.G_RET_STS_SUCCESS;
911: x_error_msg := ' ';
912:
913: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
914:
915: IF l_date_format IS NULL THEN
916: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
917: END IF;

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

912:
913: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
914:
915: IF l_date_format IS NULL THEN
916: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
917: END IF;
918:
919: OPEN x_txn_cursor FOR
920: SELECT

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

1849: gme_debug.put_line('Qty Type = '||p_qty_type);
1850: gme_debug.put_line('Org Code = '||p_org_code);
1851: END IF;
1852:
1853: fnd_profile.put('USER_ID',to_char(p_user_id));
1854: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
1855:
1856: x_return_status := FND_API.G_RET_STS_SUCCESS;
1857: x_error_msg := ' ';

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

1850: gme_debug.put_line('Org Code = '||p_org_code);
1851: END IF;
1852:
1853: fnd_profile.put('USER_ID',to_char(p_user_id));
1854: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
1855:
1856: x_return_status := FND_API.G_RET_STS_SUCCESS;
1857: x_error_msg := ' ';
1858:

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

1951: IF (g_debug IS NOT NULL) THEN
1952: gme_debug.log_initialize ('MobileSaveRsrcUsage');
1953: END IF;
1954:
1955: fnd_profile.put('USER_ID',to_char(p_uid));
1956: gme_common_pvt.g_user_ident := p_uid;
1957:
1958: l_input_rec.batchstep_resource_id := p_resource_id;
1959: l_input_rec.actual_rsrc_count := to_number(p_count);

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

2046:
2047: x_return_status := FND_API.G_RET_STS_SUCCESS;
2048: x_error_msg := ' ';
2049:
2050: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2051:
2052: IF l_date_format IS NULL THEN
2053: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
2054: END IF;

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

2049:
2050: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2051:
2052: IF l_date_format IS NULL THEN
2053: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
2054: END IF;
2055:
2056: OPEN x_lot_cursor FOR
2057: SELECT

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

2109:
2110: x_return_status := FND_API.G_RET_STS_SUCCESS;
2111: x_error_msg := ' ';
2112:
2113: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2114:
2115: IF l_date_format IS NULL THEN
2116: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
2117: END IF;

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

2112:
2113: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2114:
2115: IF l_date_format IS NULL THEN
2116: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
2117: END IF;
2118:
2119: OPEN x_lot_cursor FOR
2120: SELECT

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

2226:
2227: x_return_status := FND_API.G_RET_STS_SUCCESS;
2228: x_error_msg := ' ';
2229:
2230: fnd_profile.put('USER_ID',to_char(p_user_id));
2231: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
2232:
2233: -- nsinghi bug#5236702
2234: OPEN get_item_duom_ctl;

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

2227: x_return_status := FND_API.G_RET_STS_SUCCESS;
2228: x_error_msg := ' ';
2229:
2230: fnd_profile.put('USER_ID',to_char(p_user_id));
2231: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
2232:
2233: -- nsinghi bug#5236702
2234: OPEN get_item_duom_ctl;
2235: FETCH get_item_duom_ctl INTO l_duom_ctl;

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

2338:
2339: x_return_status := FND_API.G_RET_STS_SUCCESS;
2340: x_error_msg := ' ';
2341:
2342: fnd_profile.put('USER_ID',to_char(p_user_id));
2343: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
2344:
2345: IF p_sequence IS NULL THEN
2346: --- Set sequence to the last value

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

2339: x_return_status := FND_API.G_RET_STS_SUCCESS;
2340: x_error_msg := ' ';
2341:
2342: fnd_profile.put('USER_ID',to_char(p_user_id));
2343: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
2344:
2345: IF p_sequence IS NULL THEN
2346: --- Set sequence to the last value
2347: l_pending_product_lots_rec.sequence := FND_API.G_MISS_NUM;

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

3430:
3431: x_return_status := FND_API.G_RET_STS_SUCCESS;
3432: x_error_msg := ' ';
3433:
3434: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3435:
3436: IF l_date_format IS NULL THEN
3437: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3438: END IF;

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

3433:
3434: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3435:
3436: IF l_date_format IS NULL THEN
3437: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3438: END IF;
3439:
3440: OPEN x_txn_cursor FOR
3441: SELECT DISTINCT

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

3507:
3508: x_return_status := FND_API.G_RET_STS_SUCCESS;
3509: x_error_msg := ' ';
3510:
3511: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3512:
3513: IF l_date_format IS NULL THEN
3514: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3515: END IF;

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

3510:
3511: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3512:
3513: IF l_date_format IS NULL THEN
3514: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
3515: END IF;
3516:
3517: l_txn_type_id := Get_Txn_Type(p_txn_type_id);
3518:

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

3721:
3722: l_act_strt_dt := TO_DATE(p_act_strt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3723: l_act_complt_dt := TO_DATE(p_act_complt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3724:
3725: fnd_profile.put('USER_ID',to_char(p_uid));
3726: gme_common_pvt.g_user_name := p_uname;
3727: gme_common_pvt.g_user_ident := p_uid;
3728: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3729: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

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

3724:
3725: fnd_profile.put('USER_ID',to_char(p_uid));
3726: gme_common_pvt.g_user_name := p_uname;
3727: gme_common_pvt.g_user_ident := p_uid;
3728: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3729: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3730:
3731: l_batch_header.batch_id := p_batch_id;
3732: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header, l_batch_header)) THEN

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

3725: fnd_profile.put('USER_ID',to_char(p_uid));
3726: gme_common_pvt.g_user_name := p_uname;
3727: gme_common_pvt.g_user_ident := p_uid;
3728: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3729: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3730:
3731: l_batch_header.batch_id := p_batch_id;
3732: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header, l_batch_header)) THEN
3733: RAISE expected_error;

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

3840: l_api_name VARCHAR2(30) := 'End_Cmplt_Actual_Rsrc_Txn';
3841: BEGIN
3842: x_return_status := FND_API.G_RET_STS_SUCCESS;
3843: x_error_msg := '';
3844: FND_PROFILE.put('USER_ID',to_char(p_uid));
3845: gme_common_pvt.g_user_name := p_uname;
3846: gme_common_pvt.g_user_ident := p_uid;
3847: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3848: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

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

3843: x_error_msg := '';
3844: FND_PROFILE.put('USER_ID',to_char(p_uid));
3845: gme_common_pvt.g_user_name := p_uname;
3846: gme_common_pvt.g_user_ident := p_uid;
3847: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3848: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3849:
3850: l_in_rsrc_txn_rec.poc_trans_id := p_trans_id;
3851: l_in_rsrc_txn_rec.organization_id := p_organization_id;

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

3844: FND_PROFILE.put('USER_ID',to_char(p_uid));
3845: gme_common_pvt.g_user_name := p_uname;
3846: gme_common_pvt.g_user_ident := p_uid;
3847: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3848: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3849:
3850: l_in_rsrc_txn_rec.poc_trans_id := p_trans_id;
3851: l_in_rsrc_txn_rec.organization_id := p_organization_id;
3852: l_in_rsrc_txn_rec.trans_date := p_trans_date;

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

3931: x_return_status := FND_API.G_RET_STS_SUCCESS;
3932:
3933: l_act_strt_dt := TO_DATE(p_act_strt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3934:
3935: fnd_profile.put('USER_ID',to_char(p_uid));
3936: gme_common_pvt.g_user_name := p_uname;
3937: gme_common_pvt.g_user_ident := p_uid;
3938: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3939: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

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

3934:
3935: fnd_profile.put('USER_ID',to_char(p_uid));
3936: gme_common_pvt.g_user_name := p_uname;
3937: gme_common_pvt.g_user_ident := p_uid;
3938: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3939: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3940:
3941: l_batch_hdr_rec.batch_id := p_batch_id;
3942: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec)) THEN

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

3935: fnd_profile.put('USER_ID',to_char(p_uid));
3936: gme_common_pvt.g_user_name := p_uname;
3937: gme_common_pvt.g_user_ident := p_uid;
3938: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3939: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3940:
3941: l_batch_hdr_rec.batch_id := p_batch_id;
3942: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec)) THEN
3943: RAISE expected_error;

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

4037: l_api_name VARCHAR2(30) := 'Start_Cmplt_Actual_Rsrc_Txn';
4038: BEGIN
4039: x_return_status := FND_API.G_RET_STS_SUCCESS;
4040: x_error_msg := '';
4041: FND_PROFILE.put('USER_ID',to_char(p_uid));
4042: gme_common_pvt.g_user_name := p_uname;
4043: gme_common_pvt.g_user_ident := p_uid;
4044: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
4045: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

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

4040: x_error_msg := '';
4041: FND_PROFILE.put('USER_ID',to_char(p_uid));
4042: gme_common_pvt.g_user_name := p_uname;
4043: gme_common_pvt.g_user_ident := p_uid;
4044: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
4045: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
4046: l_in_rsrc_txn_rec.line_id := p_resource_id;
4047: l_in_rsrc_txn_rec.organization_id := p_organization_id;
4048: l_in_rsrc_txn_rec.start_date := p_start_date;

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

4041: FND_PROFILE.put('USER_ID',to_char(p_uid));
4042: gme_common_pvt.g_user_name := p_uname;
4043: gme_common_pvt.g_user_ident := p_uid;
4044: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
4045: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
4046: l_in_rsrc_txn_rec.line_id := p_resource_id;
4047: l_in_rsrc_txn_rec.organization_id := p_organization_id;
4048: l_in_rsrc_txn_rec.start_date := p_start_date;
4049: l_in_rsrc_txn_rec.end_date := p_start_date;

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

4286:
4287: END IF;
4288:
4289: --getting the date into either mwa date format mask or ICX date format mask
4290: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
4291:
4292: IF l_date_format IS NULL THEN
4293: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
4294: END IF;

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

4289: --getting the date into either mwa date format mask or ICX date format mask
4290: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
4291:
4292: IF l_date_format IS NULL THEN
4293: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_format);
4294: END IF;
4295:
4296: x_trans_date := TO_CHAR(l_trans_date,l_date_format||HOUR_MIN_SEC_FORMAT_STRING);
4297: