246: next_approver_id);
247: END IF;
248:
249: ELSE
250: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_APPROVER_METHOD');
251: l_error_message := FND_MESSAGE.Get;
252:
253: wf_engine.SetItemAttrText(item_type,
254: item_key,
247: END IF;
248:
249: ELSE
250: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_APPROVER_METHOD');
251: l_error_message := FND_MESSAGE.Get;
252:
253: wf_engine.SetItemAttrText(item_type,
254: item_key,
255: 'ERROR_MESSAGE',
822: FETCH check_untaxed INTO l_untaxed_cursor;
823:
824: IF check_untaxed%FOUND THEN
825: CLOSE check_untaxed;
826: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_UNTAXED');
827: l_invalid_error := FND_MESSAGE.Get;
828: wf_engine.SetItemAttrText( itemtype,
829: itemkey,
830: 'INVALID_JE_ERROR',
823:
824: IF check_untaxed%FOUND THEN
825: CLOSE check_untaxed;
826: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_UNTAXED');
827: l_invalid_error := FND_MESSAGE.Get;
828: wf_engine.SetItemAttrText( itemtype,
829: itemkey,
830: 'INVALID_JE_ERROR',
831: l_invalid_error );
843: AND led.ledger_id = jeh.ledger_id
844: AND led.enable_budgetary_control_flag = 'Y';
845:
846: IF (l_budgetary_control_flag = 'Y' AND l_budgetary_status <> 'P') THEN
847: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_RESERVE_FUNDS');
848: l_invalid_error := FND_MESSAGE.Get;
849: wf_engine.SetItemAttrText( itemtype,
850: itemkey,
851: 'INVALID_JE_ERROR',
844: AND led.enable_budgetary_control_flag = 'Y';
845:
846: IF (l_budgetary_control_flag = 'Y' AND l_budgetary_status <> 'P') THEN
847: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_RESERVE_FUNDS');
848: l_invalid_error := FND_MESSAGE.Get;
849: wf_engine.SetItemAttrText( itemtype,
850: itemkey,
851: 'INVALID_JE_ERROR',
852: l_invalid_error );
864: = l_control_total)
865: ) THEN
866: null;
867: ELSE
868: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_CONTROL_TOTAL');
869: l_invalid_error := FND_MESSAGE.Get;
870: wf_engine.SetItemAttrText( itemtype,
871: itemkey,
872: 'INVALID_JE_ERROR',
865: ) THEN
866: null;
867: ELSE
868: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_CONTROL_TOTAL');
869: l_invalid_error := FND_MESSAGE.Get;
870: wf_engine.SetItemAttrText( itemtype,
871: itemkey,
872: 'INVALID_JE_ERROR',
873: l_invalid_error);
1294:
1295: IF (l_dir_manager_id IS NOT NULL) THEN
1296: l_next_approver_id := l_dir_manager_id;
1297: ELSE
1298: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_CANNOT_FIND_MANAGER');
1299: l_error_message := FND_MESSAGE.Get;
1300:
1301: wf_engine.SetItemAttrText( item_type,
1302: item_key,
1295: IF (l_dir_manager_id IS NOT NULL) THEN
1296: l_next_approver_id := l_dir_manager_id;
1297: ELSE
1298: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_CANNOT_FIND_MANAGER');
1299: l_error_message := FND_MESSAGE.Get;
1300:
1301: wf_engine.SetItemAttrText( item_type,
1302: item_key,
1303: 'ERROR_MESSAGE',
1322:
1323: END IF;
1324:
1325: IF (l_next_approver_id IS NULL) THEN
1326: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_CANNOT_FIND_APPROVER');
1327: l_error_message := FND_MESSAGE.Get;
1328:
1329: WF_ENGINE.SetItemAttrText( item_type,
1330: item_key,
1323: END IF;
1324:
1325: IF (l_next_approver_id IS NULL) THEN
1326: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_CANNOT_FIND_APPROVER');
1327: l_error_message := FND_MESSAGE.Get;
1328:
1329: WF_ENGINE.SetItemAttrText( item_type,
1330: item_key,
1331: 'ERROR_MESSAGE',
1413: item_type,
1414: item_key,
1415: 'FORWARD_FROM_DISPLAY_NAME');
1416:
1417: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_FORWARD_COMMENT_FROM');
1418: FND_MESSAGE.Set_Token('APPROVER_NAME', l_forward_from_display_name);
1419: l_forward_comment_from := FND_MESSAGE.Get;
1420:
1421: WF_ENGINE.SetItemAttrText(item_type,
1414: item_key,
1415: 'FORWARD_FROM_DISPLAY_NAME');
1416:
1417: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_FORWARD_COMMENT_FROM');
1418: FND_MESSAGE.Set_Token('APPROVER_NAME', l_forward_from_display_name);
1419: l_forward_comment_from := FND_MESSAGE.Get;
1420:
1421: WF_ENGINE.SetItemAttrText(item_type,
1422: item_key,
1415: 'FORWARD_FROM_DISPLAY_NAME');
1416:
1417: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_FORWARD_COMMENT_FROM');
1418: FND_MESSAGE.Set_Token('APPROVER_NAME', l_forward_from_display_name);
1419: l_forward_comment_from := FND_MESSAGE.Get;
1420:
1421: WF_ENGINE.SetItemAttrText(item_type,
1422: item_key,
1423: 'COMMENT_FROM',