DBA Data[Home] [Help]

APPS.OKL_AM_BTCH_EXP_LEASE_LOAN_PVT dependencies on FND_MSG_PUB

Line 20: g_first CONSTANT NUMBER := fnd_msg_pub.g_first;

16: l_success_exp_tbl_index NUMBER := 0;
17: l_error_exp_tbl_index NUMBER := 0;
18: l_success_recy_tbl_index NUMBER := 0;
19: l_error_recy_tbl_index NUMBER := 0;
20: g_first CONSTANT NUMBER := fnd_msg_pub.g_first;
21: g_next CONSTANT NUMBER := fnd_msg_pub.g_next;
22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
23: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
24: g_prin_bal_zero VARCHAR2 (3);

Line 21: g_next CONSTANT NUMBER := fnd_msg_pub.g_next;

17: l_error_exp_tbl_index NUMBER := 0;
18: l_success_recy_tbl_index NUMBER := 0;
19: l_error_recy_tbl_index NUMBER := 0;
20: g_first CONSTANT NUMBER := fnd_msg_pub.g_first;
21: g_next CONSTANT NUMBER := fnd_msg_pub.g_next;
22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
23: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
24: g_prin_bal_zero VARCHAR2 (3);
25: --akrangan added for debug logging begin

Line 67: fnd_msg_pub.get (p_msg_index => l_msg_idx,

63: l_msg_tbl msg_tbl_type;
64: BEGIN
65: -- Get the messages in the log
66: LOOP
67: fnd_msg_pub.get (p_msg_index => l_msg_idx,
68: p_encoded => g_false,
69: p_data => lx_error_rec.msg_data,
70: p_msg_index_out => lx_error_rec.msg_count
71: );

Line 78: EXIT WHEN ( (lx_error_rec.msg_count = fnd_msg_pub.count_msg)

74: asset_msg_tbl (g_msg_tbl_counter).msg := lx_error_rec.msg_data;
75: g_msg_tbl_counter := g_msg_tbl_counter + 1;
76: END IF;
77:
78: EXIT WHEN ( (lx_error_rec.msg_count = fnd_msg_pub.count_msg)
79: OR (lx_error_rec.msg_count IS NULL)
80: );
81: l_msg_idx := g_next;
82: END LOOP;

Line 124: FND_MSG_PUB.get(

120: /*
121: -- Get the messages in the log
122: LOOP
123:
124: FND_MSG_PUB.get(
125: p_msg_index => l_msg_idx,
126: p_encoded => G_FALSE,
127: p_data => lx_error_rec.msg_data,
128: p_msg_index_out => lx_error_rec.msg_count);

Line 136: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)

132: l_msg_tbl(lx_error_rec.msg_count).msg := lx_error_rec.msg_data;
133: END IF;
134:
135:
136: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
137: OR (lx_error_rec.msg_count IS NULL));
138:
139: l_msg_idx := G_NEXT;
140:

Line 1589: l_msg_idx INTEGER := fnd_msg_pub.g_first;

1585: l_quotes_found VARCHAR2 (1) := 'N';
1586: l_return_status VARCHAR2 (1) := okl_api.g_ret_sts_success;
1587: l_trn_exists VARCHAR2 (1);
1588: lx_error_rec okl_api.error_rec_type;
1589: l_msg_idx INTEGER := fnd_msg_pub.g_first;
1590: l_quote_type VARCHAR2 (200);
1591: l_quote_reason VARCHAR2 (200);
1592: -- akrangan added for debug feature start
1593: l_module_name VARCHAR2 (500)

Line 1808: fnd_msg_pub.get(

1804:
1805: -- Get the messages in the log
1806: LOOP
1807:
1808: fnd_msg_pub.get(
1809: p_msg_index => l_msg_idx,
1810: p_encoded => FND_API.G_FALSE,
1811: p_data => lx_error_rec.msg_data,
1812: p_msg_index_out => lx_error_rec.msg_count);

Line 1821: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)

1817: fnd_file.put_line(fnd_file.output, lx_error_rec.msg_data);
1818:
1819: END IF;
1820:
1821: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
1822: OR (lx_error_rec.msg_count IS NULL));
1823:
1824: l_msg_idx := FND_MSG_PUB.G_NEXT;
1825: END LOOP;

Line 1824: l_msg_idx := FND_MSG_PUB.G_NEXT;

1820:
1821: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
1822: OR (lx_error_rec.msg_count IS NULL));
1823:
1824: l_msg_idx := FND_MSG_PUB.G_NEXT;
1825: END LOOP;
1826: */
1827:
1828: -- If error then abort this contract

Line 3089: l_msg_idx INTEGER := fnd_msg_pub.g_first;

3085: l_mesg_len NUMBER;
3086: l_term_tbl term_tbl_type;
3087: lx_contract_status VARCHAR2 (200);
3088: lx_error_rec okl_api.error_rec_type;
3089: l_msg_idx INTEGER := fnd_msg_pub.g_first;
3090: -- akrangan added for debug feature start
3091: l_module_name VARCHAR2 (500)
3092: := g_module_name || 'concurrent_expire_lease_loan';
3093: is_debug_exception_on BOOLEAN

Line 3142: fnd_msg_pub.get(

3138: fnd_file.put_line(fnd_file.output, '');
3139:
3140: LOOP
3141:
3142: fnd_msg_pub.get(
3143: p_msg_index => l_msg_idx,
3144: p_encoded => FND_API.G_FALSE,
3145: p_data => lx_error_rec.msg_data,
3146: p_msg_index_out => lx_error_rec.msg_count);

Line 3155: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)

3151: fnd_file.put_line(fnd_file.output, lx_error_rec.msg_data);
3152:
3153: END IF;
3154:
3155: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
3156: OR (lx_error_rec.msg_count IS NULL));
3157:
3158: l_msg_idx := FND_MSG_PUB.G_NEXT;
3159: END LOOP;

Line 3158: l_msg_idx := FND_MSG_PUB.G_NEXT;

3154:
3155: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
3156: OR (lx_error_rec.msg_count IS NULL));
3157:
3158: l_msg_idx := FND_MSG_PUB.G_NEXT;
3159: END LOOP;
3160:
3161: fnd_file.put_line(fnd_file.log, '');
3162: fnd_file.put_line(fnd_file.output, '');