DBA Data[Home] [Help]

APPS.GL_AUTO_ALLOC_WF_PKG dependencies on FND_MESSAGE

Line 2756: FND_MESSAGE.Set_Name('SQLGL', 'GL_JE_BATCH_NOT_FOUND');

2752: Close get_je_batch_attributes_C;
2753: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
2754: diagn_debug_msg('Is_je_valid_for_posting: ' || 'Generated JE batch not found '||c_je_batch_id);
2755: END IF;
2756: FND_MESSAGE.Set_Name('SQLGL', 'GL_JE_BATCH_NOT_FOUND');
2757: FND_MESSAGE.Set_Token('BATCH',l_batch_name);
2758: l_invalid_error := FND_MESSAGE.Get;
2759: result := 'N';
2760: return;

Line 2757: FND_MESSAGE.Set_Token('BATCH',l_batch_name);

2753: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
2754: diagn_debug_msg('Is_je_valid_for_posting: ' || 'Generated JE batch not found '||c_je_batch_id);
2755: END IF;
2756: FND_MESSAGE.Set_Name('SQLGL', 'GL_JE_BATCH_NOT_FOUND');
2757: FND_MESSAGE.Set_Token('BATCH',l_batch_name);
2758: l_invalid_error := FND_MESSAGE.Get;
2759: result := 'N';
2760: return;
2761: Elsif l_approval_status_code = 'R' Then

Line 2758: l_invalid_error := FND_MESSAGE.Get;

2754: diagn_debug_msg('Is_je_valid_for_posting: ' || 'Generated JE batch not found '||c_je_batch_id);
2755: END IF;
2756: FND_MESSAGE.Set_Name('SQLGL', 'GL_JE_BATCH_NOT_FOUND');
2757: FND_MESSAGE.Set_Token('BATCH',l_batch_name);
2758: l_invalid_error := FND_MESSAGE.Get;
2759: result := 'N';
2760: return;
2761: Elsif l_approval_status_code = 'R' Then
2762: l_operating_mode := wf_engine.GetItemAttrText

Line 2777: FND_MESSAGE.Set_Name('SQLGL', 'GL_JE_BATCH_APPROVAL_REQ');

2773: Else
2774: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
2775: diagn_debug_msg('Is_je_valid_for_posting: ' || 'Batch approval require before posting');
2776: END IF;
2777: FND_MESSAGE.Set_Name('SQLGL', 'GL_JE_BATCH_APPROVAL_REQ');
2778: FND_MESSAGE.Set_Token('BATCH',l_batch_name);
2779: l_invalid_error := FND_MESSAGE.Get;
2780: result := 'N';
2781: return;

Line 2778: FND_MESSAGE.Set_Token('BATCH',l_batch_name);

2774: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
2775: diagn_debug_msg('Is_je_valid_for_posting: ' || 'Batch approval require before posting');
2776: END IF;
2777: FND_MESSAGE.Set_Name('SQLGL', 'GL_JE_BATCH_APPROVAL_REQ');
2778: FND_MESSAGE.Set_Token('BATCH',l_batch_name);
2779: l_invalid_error := FND_MESSAGE.Get;
2780: result := 'N';
2781: return;
2782: End If;

Line 2779: l_invalid_error := FND_MESSAGE.Get;

2775: diagn_debug_msg('Is_je_valid_for_posting: ' || 'Batch approval require before posting');
2776: END IF;
2777: FND_MESSAGE.Set_Name('SQLGL', 'GL_JE_BATCH_APPROVAL_REQ');
2778: FND_MESSAGE.Set_Token('BATCH',l_batch_name);
2779: l_invalid_error := FND_MESSAGE.Get;
2780: result := 'N';
2781: return;
2782: End If;
2783: Elsif l_approval_status_code = 'I' Then

Line 2788: FND_MESSAGE.Set_Name('SQLGL', 'GL_APPROVAL_NOT_COMPLETE');

2784: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
2785: diagn_debug_msg('Is_je_valid_for_posting: ' || 'Batch '||To_char(l_je_batch_id)||
2786: ' approval launched but batch is not yet approved');
2787: END IF;
2788: FND_MESSAGE.Set_Name('SQLGL', 'GL_APPROVAL_NOT_COMPLETE');
2789: FND_MESSAGE.Set_Token('BATCH',l_batch_name);
2790: l_invalid_error := FND_MESSAGE.Get;
2791: result := 'N';
2792: return;

Line 2789: FND_MESSAGE.Set_Token('BATCH',l_batch_name);

2785: diagn_debug_msg('Is_je_valid_for_posting: ' || 'Batch '||To_char(l_je_batch_id)||
2786: ' approval launched but batch is not yet approved');
2787: END IF;
2788: FND_MESSAGE.Set_Name('SQLGL', 'GL_APPROVAL_NOT_COMPLETE');
2789: FND_MESSAGE.Set_Token('BATCH',l_batch_name);
2790: l_invalid_error := FND_MESSAGE.Get;
2791: result := 'N';
2792: return;
2793: ElsIf l_status = 'P' then

Line 2790: l_invalid_error := FND_MESSAGE.Get;

2786: ' approval launched but batch is not yet approved');
2787: END IF;
2788: FND_MESSAGE.Set_Name('SQLGL', 'GL_APPROVAL_NOT_COMPLETE');
2789: FND_MESSAGE.Set_Token('BATCH',l_batch_name);
2790: l_invalid_error := FND_MESSAGE.Get;
2791: result := 'N';
2792: return;
2793: ElsIf l_status = 'P' then
2794: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN

Line 2804: FND_MESSAGE.Set_Name('SQLGL', 'GL_FUND_CHECK_IN_PROCESS');

2800: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
2801: diagn_debug_msg('Is_je_valid_for_posting: ' || 'Batch '||To_char(l_je_batch_id)||
2802: ' fund checker is in process');
2803: END IF;
2804: FND_MESSAGE.Set_Name('SQLGL', 'GL_FUND_CHECK_IN_PROCESS');
2805: FND_MESSAGE.Set_Token('BATCH',l_batch_name);
2806: l_invalid_error := FND_MESSAGE.Get;
2807: result := 'N';
2808: return;

Line 2805: FND_MESSAGE.Set_Token('BATCH',l_batch_name);

2801: diagn_debug_msg('Is_je_valid_for_posting: ' || 'Batch '||To_char(l_je_batch_id)||
2802: ' fund checker is in process');
2803: END IF;
2804: FND_MESSAGE.Set_Name('SQLGL', 'GL_FUND_CHECK_IN_PROCESS');
2805: FND_MESSAGE.Set_Token('BATCH',l_batch_name);
2806: l_invalid_error := FND_MESSAGE.Get;
2807: result := 'N';
2808: return;
2809: End If;

Line 2806: l_invalid_error := FND_MESSAGE.Get;

2802: ' fund checker is in process');
2803: END IF;
2804: FND_MESSAGE.Set_Name('SQLGL', 'GL_FUND_CHECK_IN_PROCESS');
2805: FND_MESSAGE.Set_Token('BATCH',l_batch_name);
2806: l_invalid_error := FND_MESSAGE.Get;
2807: result := 'N';
2808: return;
2809: End If;
2810:

Line 2819: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_UNTAXED');

2815: FETCH check_untaxed INTO l_untaxed_cursor;
2816:
2817: IF check_untaxed%FOUND THEN
2818: CLOSE check_untaxed;
2819: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_UNTAXED');
2820: l_invalid_error := FND_MESSAGE.Get;
2821: result := 'N';
2822: return;
2823: ELSE

Line 2820: l_invalid_error := FND_MESSAGE.Get;

2816:
2817: IF check_untaxed%FOUND THEN
2818: CLOSE check_untaxed;
2819: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_UNTAXED');
2820: l_invalid_error := FND_MESSAGE.Get;
2821: result := 'N';
2822: return;
2823: ELSE
2824: CLOSE check_untaxed;

Line 2853: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_PERIOD_NOT_OPEN');

2849: IF ( l_balance_type = 'A') THEN
2850: -- Check that the batch period is open for actual batches
2851: BEGIN
2852: IF (nvl(l_period_status,'X') NOT IN ('O', 'F')) THEN
2853: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_PERIOD_NOT_OPEN');
2854: l_invalid_error := FND_MESSAGE.Get;
2855: result := 'N';
2856: return;
2857: END IF;

Line 2854: l_invalid_error := FND_MESSAGE.Get;

2850: -- Check that the batch period is open for actual batches
2851: BEGIN
2852: IF (nvl(l_period_status,'X') NOT IN ('O', 'F')) THEN
2853: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_PERIOD_NOT_OPEN');
2854: l_invalid_error := FND_MESSAGE.Get;
2855: result := 'N';
2856: return;
2857: END IF;
2858: END;

Line 2882: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_FROZEN_BUDGET');

2878: year_violation;
2879: CLOSE chk_budgets;
2880:
2881: IF (frozen_budget = 1) THEN
2882: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_FROZEN_BUDGET');
2883: l_invalid_error := FND_MESSAGE.Get;
2884: result := 'N';
2885: return;
2886: ELSIF (year_violation = 1) THEN

Line 2883: l_invalid_error := FND_MESSAGE.Get;

2879: CLOSE chk_budgets;
2880:
2881: IF (frozen_budget = 1) THEN
2882: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_FROZEN_BUDGET');
2883: l_invalid_error := FND_MESSAGE.Get;
2884: result := 'N';
2885: return;
2886: ELSIF (year_violation = 1) THEN
2887: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_BUDGET_PERIOD');

Line 2887: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_BUDGET_PERIOD');

2883: l_invalid_error := FND_MESSAGE.Get;
2884: result := 'N';
2885: return;
2886: ELSIF (year_violation = 1) THEN
2887: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_BUDGET_PERIOD');
2888: l_invalid_error := FND_MESSAGE.Get;
2889: result := 'N';
2890: return;
2891: END IF;

Line 2888: l_invalid_error := FND_MESSAGE.Get;

2884: result := 'N';
2885: return;
2886: ELSIF (year_violation = 1) THEN
2887: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_BUDGET_PERIOD');
2888: l_invalid_error := FND_MESSAGE.Get;
2889: result := 'N';
2890: return;
2891: END IF;
2892: END ;

Line 2898: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_ENC_YEAR');

2894: ELSE
2895: -- Make sure that for encumbrance batches, the
2896: -- batch is within an open encumbrance year
2897: IF (l_period_year > l_latest_encumbrance_year) THEN
2898: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_ENC_YEAR');
2899: l_invalid_error := FND_MESSAGE.Get;
2900: result := 'N';
2901: return;
2902: END IF;

Line 2899: l_invalid_error := FND_MESSAGE.Get;

2895: -- Make sure that for encumbrance batches, the
2896: -- batch is within an open encumbrance year
2897: IF (l_period_year > l_latest_encumbrance_year) THEN
2898: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_ENC_YEAR');
2899: l_invalid_error := FND_MESSAGE.Get;
2900: result := 'N';
2901: return;
2902: END IF;
2903:

Line 2921: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_CONTROL_TOTAL');

2917:
2918: ) THEN
2919: null;
2920: ELSE
2921: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_CONTROL_TOTAL');
2922: l_invalid_error := FND_MESSAGE.Get;
2923: result := 'N';
2924: return;
2925: END IF;

Line 2922: l_invalid_error := FND_MESSAGE.Get;

2918: ) THEN
2919: null;
2920: ELSE
2921: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_CONTROL_TOTAL');
2922: l_invalid_error := FND_MESSAGE.Get;
2923: result := 'N';
2924: return;
2925: END IF;
2926:

Line 3275: l_wait_error := fnd_message.get;

3271: p_result := 'COMPLETE:PASS';
3272: return;
3273: Else
3274: If NOT (l_call_status ) Then
3275: l_wait_error := fnd_message.get;
3276: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
3277: diagn_debug_msg('WAITING_TO_COMPLETE: ' || 'Wait failure message='||l_wait_error);
3278: END IF;
3279: End If;