DBA Data[Home] [Help]

APPS.AHL_PRD_WO_LOGIN_PVT dependencies on FND_MESSAGE

Line 197: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_AUTOTXN_DSBLD');

193: l_user_role := get_user_role();
194:
195: IF (NVL(FND_PROFILE.value('AHL_MANUAL_RES_TXN'),'N') = 'Y') OR
196: (l_user_role = AHL_PRD_UTIL_PKG.G_DATA_CLERK) THEN
197: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_AUTOTXN_DSBLD');
198: FND_MSG_PUB.ADD;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201:

Line 248: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_NULL');

244:
245:
246: -- Validate workorder.
247: IF (l_workorder_id IS NULL) THEN
248: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_NULL');
249: --FND_MESSAGE.set_token('WO_ID',l_workorder_id);
250: FND_MSG_PUB.ADD;
251: RAISE FND_API.G_EXC_ERROR;
252: ELSE

Line 249: --FND_MESSAGE.set_token('WO_ID',l_workorder_id);

245:
246: -- Validate workorder.
247: IF (l_workorder_id IS NULL) THEN
248: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_NULL');
249: --FND_MESSAGE.set_token('WO_ID',l_workorder_id);
250: FND_MSG_PUB.ADD;
251: RAISE FND_API.G_EXC_ERROR;
252: ELSE
253: -- get WO number to display error message.

Line 258: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_INVALID');

254: OPEN c_wo_name(p_workorder_id);
255: FETCH c_wo_name INTO l_workorder_name;
256: IF (c_wo_name%NOTFOUND) THEN
257: CLOSE c_wo_name;
258: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_INVALID');
259: FND_MESSAGE.set_token('WO_ID',l_workorder_id);
260: FND_MSG_PUB.ADD;
261: RAISE FND_API.G_EXC_ERROR;
262:

Line 259: FND_MESSAGE.set_token('WO_ID',l_workorder_id);

255: FETCH c_wo_name INTO l_workorder_name;
256: IF (c_wo_name%NOTFOUND) THEN
257: CLOSE c_wo_name;
258: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_INVALID');
259: FND_MESSAGE.set_token('WO_ID',l_workorder_id);
260: FND_MSG_PUB.ADD;
261: RAISE FND_API.G_EXC_ERROR;
262:
263: END IF;

Line 449: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_NULL');

445:
446: -- Workorder Num/ID
447: IF (p_x_workorder_id IS NULL) THEN
448: IF (p_workorder_name IS NULL OR p_org_code IS NULL) THEN
449: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_NULL');
450: FND_MSG_PUB.ADD;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: ELSE
453: OPEN c_get_wo_id(p_workorder_name, p_org_code);

Line 456: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_INVALID');

452: ELSE
453: OPEN c_get_wo_id(p_workorder_name, p_org_code);
454: FETCH c_get_wo_id INTO l_workorder_id;
455: IF (c_get_wo_id%NOTFOUND) THEN
456: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_INVALID');
457: FND_MESSAGE.set_token('WO_NUM', p_workorder_name);
458: FND_MESSAGE.set_token('ORG_CODE', p_org_code);
459: FND_MSG_PUB.ADD;
460: x_return_status := FND_API.G_RET_STS_ERROR;

Line 457: FND_MESSAGE.set_token('WO_NUM', p_workorder_name);

453: OPEN c_get_wo_id(p_workorder_name, p_org_code);
454: FETCH c_get_wo_id INTO l_workorder_id;
455: IF (c_get_wo_id%NOTFOUND) THEN
456: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_INVALID');
457: FND_MESSAGE.set_token('WO_NUM', p_workorder_name);
458: FND_MESSAGE.set_token('ORG_CODE', p_org_code);
459: FND_MSG_PUB.ADD;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: ELSE

Line 458: FND_MESSAGE.set_token('ORG_CODE', p_org_code);

454: FETCH c_get_wo_id INTO l_workorder_id;
455: IF (c_get_wo_id%NOTFOUND) THEN
456: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_INVALID');
457: FND_MESSAGE.set_token('WO_NUM', p_workorder_name);
458: FND_MESSAGE.set_token('ORG_CODE', p_org_code);
459: FND_MSG_PUB.ADD;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: ELSE
462: p_x_workorder_id := l_workorder_id;

Line 612: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');

608:
609: CLOSE c_lock_wo_oper;
610:
611: -- add error to stack.
612: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
613: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
614: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
615: FND_MSG_PUB.ADD;
616: RAISE FND_API.G_EXC_ERROR;

Line 613: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);

609: CLOSE c_lock_wo_oper;
610:
611: -- add error to stack.
612: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
613: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
614: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
615: FND_MSG_PUB.ADD;
616: RAISE FND_API.G_EXC_ERROR;
617: END IF;

Line 614: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);

610:
611: -- add error to stack.
612: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
613: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
614: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
615: FND_MSG_PUB.ADD;
616: RAISE FND_API.G_EXC_ERROR;
617: END IF;
618: CLOSE c_lock_wo_oper;

Line 623: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');

619:
620: -- check operation status.
621: IF (l_oper_status <> '2') THEN
622: -- add error to stack.
623: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
624: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
625: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
626: FND_MSG_PUB.ADD;
627: RAISE FND_API.G_EXC_ERROR;

Line 624: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);

620: -- check operation status.
621: IF (l_oper_status <> '2') THEN
622: -- add error to stack.
623: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
624: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
625: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
626: FND_MSG_PUB.ADD;
627: RAISE FND_API.G_EXC_ERROR;
628: END IF;

Line 625: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);

621: IF (l_oper_status <> '2') THEN
622: -- add error to stack.
623: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
624: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
625: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
626: FND_MSG_PUB.ADD;
627: RAISE FND_API.G_EXC_ERROR;
628: END IF;
629:

Line 662: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RES_NULL');

658: l_initial_assign_rec.login_date := sysdate;
659:
660: IF (p_resource_id IS NULL AND p_resource_seq_num IS NULL) THEN
661: -- add error to stack.
662: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RES_NULL');
663: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
664: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
665: FND_MSG_PUB.ADD;
666: RAISE FND_API.G_EXC_ERROR;

Line 663: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);

659:
660: IF (p_resource_id IS NULL AND p_resource_seq_num IS NULL) THEN
661: -- add error to stack.
662: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RES_NULL');
663: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
664: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
665: FND_MSG_PUB.ADD;
666: RAISE FND_API.G_EXC_ERROR;
667: END IF;

Line 664: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);

660: IF (p_resource_id IS NULL AND p_resource_seq_num IS NULL) THEN
661: -- add error to stack.
662: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RES_NULL');
663: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
664: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
665: FND_MSG_PUB.ADD;
666: RAISE FND_API.G_EXC_ERROR;
667: END IF;
668:

Line 747: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RES_INVALID');

743: END IF;
744:
745: CLOSE c_qualified_req;
746: -- add error to stack.
747: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RES_INVALID');
748: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
749: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
750: FND_MSG_PUB.ADD;
751: RAISE FND_API.G_EXC_ERROR;

Line 748: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);

744:
745: CLOSE c_qualified_req;
746: -- add error to stack.
747: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RES_INVALID');
748: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
749: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
750: FND_MSG_PUB.ADD;
751: RAISE FND_API.G_EXC_ERROR;
752:

Line 749: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);

745: CLOSE c_qualified_req;
746: -- add error to stack.
747: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RES_INVALID');
748: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
749: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
750: FND_MSG_PUB.ADD;
751: RAISE FND_API.G_EXC_ERROR;
752:
753: END IF; -- c_qualified_req%FOUND

Line 968: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');

964: IF (c_lock_wo_oper%NOTFOUND) THEN
965: CLOSE c_lock_wo_oper;
966:
967: -- add error to stack.
968: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
969: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
970: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
971: FND_MSG_PUB.ADD;
972: RAISE FND_API.G_EXC_ERROR;

Line 969: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);

965: CLOSE c_lock_wo_oper;
966:
967: -- add error to stack.
968: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
969: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
970: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
971: FND_MSG_PUB.ADD;
972: RAISE FND_API.G_EXC_ERROR;
973: ELSIF (l_oper_status <> 2) THEN

Line 970: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);

966:
967: -- add error to stack.
968: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
969: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
970: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
971: FND_MSG_PUB.ADD;
972: RAISE FND_API.G_EXC_ERROR;
973: ELSIF (l_oper_status <> 2) THEN
974: CLOSE c_lock_wo_oper;

Line 977: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');

973: ELSIF (l_oper_status <> 2) THEN
974: CLOSE c_lock_wo_oper;
975:
976: -- add error to stack.
977: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
978: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
979: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
980: FND_MSG_PUB.ADD;
981: RAISE FND_API.G_EXC_ERROR;

Line 978: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);

974: CLOSE c_lock_wo_oper;
975:
976: -- add error to stack.
977: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
978: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
979: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
980: FND_MSG_PUB.ADD;
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;

Line 979: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);

975:
976: -- add error to stack.
977: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
978: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
979: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
980: FND_MSG_PUB.ADD;
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983: CLOSE c_lock_wo_oper;

Line 988: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_NULL');

984:
985: ELSE
986:
987: -- add error to stack.
988: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_NULL');
989: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
990: FND_MSG_PUB.ADD;
991: RAISE FND_API.G_EXC_ERROR;
992: END IF; -- p_operation_seq_num IS NOT NULL

Line 989: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);

985: ELSE
986:
987: -- add error to stack.
988: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_NULL');
989: FND_MESSAGE.set_token('WO_NUM' , p_workorder_name);
990: FND_MSG_PUB.ADD;
991: RAISE FND_API.G_EXC_ERROR;
992: END IF; -- p_operation_seq_num IS NOT NULL
993:

Line 1277: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_INVALID');

1273: -- Lock WO record.
1274: OPEN c_lock_wo (p_workorder_id);
1275: FETCH c_lock_wo INTO l_wo_status;
1276: IF (c_lock_wo%NOTFOUND) THEN
1277: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_INVALID');
1278: FND_MSG_PUB.ADD;
1279: END IF;
1280: CLOSE c_lock_wo;
1281:

Line 1572: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_AUTOTXN_DSBLD');

1568: /* THis validation is not needed. Data Clerk can complete WO in which case all users
1569: should be logged out
1570: IF (NVL(FND_PROFILE.value('AHL_MANUAL_RES_TXN'),'N') = 'Y') OR
1571: (l_user_role = AHL_PRD_UTIL_PKG.G_DATA_CLERK) THEN
1572: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_AUTOTXN_DSBLD');
1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;
1575: END IF; */
1576:

Line 1622: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_NULL');

1618: END IF;
1619:
1620: -- Check required parameters.
1621: IF (l_workorder_id IS NULL) THEN
1622: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_NULL');
1623: FND_MSG_PUB.ADD;
1624: RAISE FND_API.G_EXC_ERROR;
1625: END IF;
1626:

Line 1628: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_EMPID_NULL');

1624: RAISE FND_API.G_EXC_ERROR;
1625: END IF;
1626:
1627: IF (l_employee_id IS NULL) THEN
1628: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_EMPID_NULL');
1629: FND_MSG_PUB.ADD;
1630: RAISE FND_API.G_EXC_ERROR;
1631: END IF;
1632:

Line 1982: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_NOTLOGGEDIN');

1978: l_object_version_number;
1979:
1980: IF (c_emp_login_details%NOTFOUND) THEN
1981: CLOSE c_emp_login_details;
1982: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_NOTLOGGEDIN');
1983: FND_MSG_PUB.ADD;
1984: RAISE FND_API.G_EXC_ERROR;
1985: END IF;
1986:

Line 1990: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_NOTLOGGEDIN');

1986:
1987: -- Check login WO matches input WO.
1988: IF (l_login_workorder_id IS NULL) THEN
1989: -- user is not logged in any workorder.
1990: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_NOTLOGGEDIN');
1991: FND_MSG_PUB.ADD;
1992: RAISE FND_API.G_EXC_ERROR;
1993: ELSIF (l_login_workorder_id <> p_workorder_id) THEN
1994: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_WO_INVALID');

Line 1994: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_WO_INVALID');

1990: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_NOTLOGGEDIN');
1991: FND_MSG_PUB.ADD;
1992: RAISE FND_API.G_EXC_ERROR;
1993: ELSIF (l_login_workorder_id <> p_workorder_id) THEN
1994: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_WO_INVALID');
1995: FND_MESSAGE.set_token('WO_NAME', l_workorder_name);
1996: FND_MSG_PUB.ADD;
1997: RAISE FND_API.G_EXC_ERROR;
1998: END IF;

Line 1995: FND_MESSAGE.set_token('WO_NAME', l_workorder_name);

1991: FND_MSG_PUB.ADD;
1992: RAISE FND_API.G_EXC_ERROR;
1993: ELSIF (l_login_workorder_id <> p_workorder_id) THEN
1994: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_WO_INVALID');
1995: FND_MESSAGE.set_token('WO_NAME', l_workorder_name);
1996: FND_MSG_PUB.ADD;
1997: RAISE FND_API.G_EXC_ERROR;
1998: END IF;
1999:

Line 2007: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_OP_NULL');

2003: END IF;
2004:
2005: -- For 'R' and 'O' logins, operation_seq_num is mandatory.
2006: IF (l_login_level <> 'W' AND p_operation_seq_num IS NULL) THEN
2007: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_OP_NULL');
2008: FND_MSG_PUB.ADD;
2009: RAISE FND_API.G_EXC_ERROR;
2010: ELSIF (p_operation_seq_num <> l_operation_seq_num) THEN
2011: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_OP_INVALID');

Line 2011: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_OP_INVALID');

2007: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_OP_NULL');
2008: FND_MSG_PUB.ADD;
2009: RAISE FND_API.G_EXC_ERROR;
2010: ELSIF (p_operation_seq_num <> l_operation_seq_num) THEN
2011: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_OP_INVALID');
2012: FND_MESSAGE.set_token('OP_NUM', p_operation_seq_num);
2013: FND_MSG_PUB.ADD;
2014: RAISE FND_API.G_EXC_ERROR;
2015: END IF;

Line 2012: FND_MESSAGE.set_token('OP_NUM', p_operation_seq_num);

2008: FND_MSG_PUB.ADD;
2009: RAISE FND_API.G_EXC_ERROR;
2010: ELSIF (p_operation_seq_num <> l_operation_seq_num) THEN
2011: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_OP_INVALID');
2012: FND_MESSAGE.set_token('OP_NUM', p_operation_seq_num);
2013: FND_MSG_PUB.ADD;
2014: RAISE FND_API.G_EXC_ERROR;
2015: END IF;
2016:

Line 2025: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_RES_NULL');

2021:
2022: -- For 'R' login, resource is mandatory.
2023: IF (l_login_level = 'R' AND
2024: p_resource_seq_num IS NULL AND p_resource_id IS NULL) THEN
2025: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_RES_NULL');
2026: FND_MSG_PUB.ADD;
2027: RAISE FND_API.G_EXC_ERROR;
2028: ELSIF (p_resource_seq_num IS NOT NULL) AND
2029: (p_resource_seq_num <> nvl(l_resource_seq_num, -1) ) THEN

Line 2030: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_RES_INVALID');

2026: FND_MSG_PUB.ADD;
2027: RAISE FND_API.G_EXC_ERROR;
2028: ELSIF (p_resource_seq_num IS NOT NULL) AND
2029: (p_resource_seq_num <> nvl(l_resource_seq_num, -1) ) THEN
2030: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_RES_INVALID');
2031: FND_MESSAGE.set_token('RES_NUM', p_resource_seq_num);
2032: FND_MSG_PUB.ADD;
2033: RAISE FND_API.G_EXC_ERROR;
2034: ELSIF (p_resource_id IS NOT NULL) THEN

Line 2031: FND_MESSAGE.set_token('RES_NUM', p_resource_seq_num);

2027: RAISE FND_API.G_EXC_ERROR;
2028: ELSIF (p_resource_seq_num IS NOT NULL) AND
2029: (p_resource_seq_num <> nvl(l_resource_seq_num, -1) ) THEN
2030: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_RES_INVALID');
2031: FND_MESSAGE.set_token('RES_NUM', p_resource_seq_num);
2032: FND_MSG_PUB.ADD;
2033: RAISE FND_API.G_EXC_ERROR;
2034: ELSIF (p_resource_id IS NOT NULL) THEN
2035: IF (p_resource_id <> nvl(l_resource_id,-1)) THEN

Line 2036: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_RESID_INVALID');

2032: FND_MSG_PUB.ADD;
2033: RAISE FND_API.G_EXC_ERROR;
2034: ELSIF (p_resource_id IS NOT NULL) THEN
2035: IF (p_resource_id <> nvl(l_resource_id,-1)) THEN
2036: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_RESID_INVALID');
2037: FND_MESSAGE.set_token('RES_ID', p_resource_id);
2038: FND_MSG_PUB.ADD;
2039: RAISE FND_API.G_EXC_ERROR;
2040: /* jkjain, Bug No 8325834, FP for Bug No 7759348

Line 2037: FND_MESSAGE.set_token('RES_ID', p_resource_id);

2033: RAISE FND_API.G_EXC_ERROR;
2034: ELSIF (p_resource_id IS NOT NULL) THEN
2035: IF (p_resource_id <> nvl(l_resource_id,-1)) THEN
2036: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_RESID_INVALID');
2037: FND_MESSAGE.set_token('RES_ID', p_resource_id);
2038: FND_MSG_PUB.ADD;
2039: RAISE FND_API.G_EXC_ERROR;
2040: /* jkjain, Bug No 8325834, FP for Bug No 7759348
2041:

Line 2048: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_RES_INVALID');

2044: OPEN c_get_resrc_seq(l_wip_entity_id, l_operation_seq_num, l_resource_id);
2045: FETCH c_get_resrc_seq INTO l_resource_seq_num;
2046: IF (c_get_resrc_seq%NOTFOUND) THEN
2047: CLOSE c_get_resrc_seq;
2048: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_RES_INVALID');
2049: FND_MESSAGE.set_token('RES_ID', p_resource_id);
2050: FND_MSG_PUB.ADD;
2051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2052: END IF; -- c_get_resrc_seq

Line 2049: FND_MESSAGE.set_token('RES_ID', p_resource_id);

2045: FETCH c_get_resrc_seq INTO l_resource_seq_num;
2046: IF (c_get_resrc_seq%NOTFOUND) THEN
2047: CLOSE c_get_resrc_seq;
2048: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGNOUT_RES_INVALID');
2049: FND_MESSAGE.set_token('RES_ID', p_resource_id);
2050: FND_MSG_PUB.ADD;
2051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2052: END IF; -- c_get_resrc_seq
2053: CLOSE c_get_resrc_seq;

Line 2070: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_UNTLCKD');

2066: p_visit_id => null,
2067: p_item_instance_id => null) = FND_API.g_true THEN
2068: -- Unit is locked, therefore cannot perform resource transactions
2069: -- and cannot login to the workorder
2070: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_UNTLCKD');
2071: FND_MESSAGE.set_token('WO_NUM' , l_workorder_name);
2072: FND_MSG_PUB.ADD;
2073: RAISE FND_API.G_EXC_ERROR;
2074: END IF;

Line 2071: FND_MESSAGE.set_token('WO_NUM' , l_workorder_name);

2067: p_item_instance_id => null) = FND_API.g_true THEN
2068: -- Unit is locked, therefore cannot perform resource transactions
2069: -- and cannot login to the workorder
2070: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_UNTLCKD');
2071: FND_MESSAGE.set_token('WO_NUM' , l_workorder_name);
2072: FND_MSG_PUB.ADD;
2073: RAISE FND_API.G_EXC_ERROR;
2074: END IF;
2075:

Line 2530: FND_MESSAGE.Set_Name('AHL','AHL_PRD_LGN_EMP_NULL');

2526: END IF;
2527:
2528: -- Return error if employee id not found.
2529: IF (l_employee_id IS NULL) THEN
2530: FND_MESSAGE.Set_Name('AHL','AHL_PRD_LGN_EMP_NULL');
2531: FND_MSG_PUB.ADD;
2532: RAISE FND_API.G_EXC_ERROR;
2533: END IF;
2534:

Line 2908: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_AUTOTXN_DSBLD');

2904:
2905: -- Check if login enabled.
2906: IF (NVL(FND_PROFILE.value('AHL_PRD_MANUAL_RES_TXN'),'N') = 'Y') OR
2907: (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_DATA_CLERK) THEN
2908: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_AUTOTXN_DSBLD');
2909: FND_MSG_PUB.ADD;
2910: Return FND_API.G_FALSE;
2911: END IF;
2912:

Line 2921: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_NULL');

2917: END IF;
2918:
2919: -- Check required parameters.
2920: IF p_workorder_id IS NULL THEN
2921: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_NULL');
2922: FND_MSG_PUB.ADD;
2923: Return FND_API.G_FALSE;
2924: END IF;
2925:

Line 2937: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_INVALID');

2933: OPEN c_is_wo_valid (p_workorder_id);
2934: FETCH c_is_wo_valid INTO l_wo_status, l_wo_name, l_wip_entity_id, l_org_id;
2935: IF c_is_wo_valid%NOTFOUND THEN
2936: CLOSE c_is_wo_valid;
2937: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_INVALID');
2938: FND_MSG_PUB.ADD;
2939: RETURN FND_API.G_FALSE;
2940: END IF;
2941: CLOSE c_is_wo_valid;

Line 2945: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WOSTS_INVLD');

2941: CLOSE c_is_wo_valid;
2942:
2943: -- Validate WO status.
2944: IF l_wo_status in ('1','6','7','22','12','4','5') THEN
2945: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WOSTS_INVLD');
2946: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
2947: FND_MSG_PUB.ADD;
2948: RETURN FND_API.G_FALSE;
2949: END IF;

Line 2946: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);

2942:
2943: -- Validate WO status.
2944: IF l_wo_status in ('1','6','7','22','12','4','5') THEN
2945: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WOSTS_INVLD');
2946: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
2947: FND_MSG_PUB.ADD;
2948: RETURN FND_API.G_FALSE;
2949: END IF;
2950:

Line 2966: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_EMPID_INVALID');

2962: OPEN c_is_emp_valid(p_employee_id, l_org_id);
2963: FETCH c_is_emp_valid INTO l_employee_id;
2964: IF (c_is_emp_valid%NOTFOUND) THEN
2965: CLOSE c_is_emp_valid;
2966: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_EMPID_INVALID');
2967: FND_MESSAGE.set_token('EMP_ID' , p_employee_id);
2968: FND_MSG_PUB.ADD;
2969: RETURN FND_API.G_FALSE;
2970: END IF;

Line 2967: FND_MESSAGE.set_token('EMP_ID' , p_employee_id);

2963: FETCH c_is_emp_valid INTO l_employee_id;
2964: IF (c_is_emp_valid%NOTFOUND) THEN
2965: CLOSE c_is_emp_valid;
2966: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_EMPID_INVALID');
2967: FND_MESSAGE.set_token('EMP_ID' , p_employee_id);
2968: FND_MSG_PUB.ADD;
2969: RETURN FND_API.G_FALSE;
2970: END IF;
2971: CLOSE c_is_emp_valid;

Line 2999: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_USER_LOGGED_IN');

2995: END IF;
2996:
2997: -- Check for login WO. If user already logged in, then do not allow login into another WO.
2998: IF (l_login_workorder_id IS NOT NULL) THEN
2999: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_USER_LOGGED_IN');
3000: FND_MSG_PUB.ADD;
3001: RETURN FND_API.G_FALSE;
3002: END IF;
3003:

Line 3017: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_UNTLCKD');

3013: p_visit_id => null,
3014: p_item_instance_id => null) = FND_API.g_true THEN
3015: -- Unit is locked, therefore cannot perform resource transactions
3016: -- and hence cannot login to the workorder
3017: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_UNTLCKD');
3018: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3019: FND_MSG_PUB.ADD;
3020: RETURN FND_API.G_FALSE;
3021: END IF;

Line 3018: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);

3014: p_item_instance_id => null) = FND_API.g_true THEN
3015: -- Unit is locked, therefore cannot perform resource transactions
3016: -- and hence cannot login to the workorder
3017: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_UNTLCKD');
3018: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3019: FND_MSG_PUB.ADD;
3020: RETURN FND_API.G_FALSE;
3021: END IF;
3022:

Line 3030: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_FUNC_NULL');

3026: l_fnd_function_name := p_fnd_function_name;
3027: END IF;
3028:
3029: IF (l_fnd_function_name IS NULL) THEN
3030: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_FUNC_NULL');
3031: FND_MSG_PUB.ADD;
3032: Return FND_API.G_FALSE;
3033: END IF;
3034:

Line 3056: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WOOPS_COMPLETE');

3052: OPEN c_workorder_oper(p_workorder_id);
3053: FETCH c_workorder_oper INTO l_junk;
3054: IF (c_workorder_oper%FOUND) THEN
3055: CLOSE c_workorder_oper;
3056: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WOOPS_COMPLETE');
3057: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3058: FND_MSG_PUB.ADD;
3059: RETURN FND_API.G_FALSE;
3060: END IF;

Line 3057: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);

3053: FETCH c_workorder_oper INTO l_junk;
3054: IF (c_workorder_oper%FOUND) THEN
3055: CLOSE c_workorder_oper;
3056: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WOOPS_COMPLETE');
3057: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3058: FND_MSG_PUB.ADD;
3059: RETURN FND_API.G_FALSE;
3060: END IF;
3061: CLOSE c_workorder_oper;

Line 3069: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_NO_RESREQ');

3065: FETCH c_check_res_reqd INTO l_junk;
3066: IF c_check_res_reqd%NOTFOUND THEN
3067: -- Login at the workorder level will be disabled.
3068: CLOSE c_check_res_reqd;
3069: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_NO_RESREQ');
3070: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3071: FND_MSG_PUB.ADD;
3072: RETURN FND_API.G_FALSE;
3073: END IF; -- c_check_res_reqd.

Line 3070: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);

3066: IF c_check_res_reqd%NOTFOUND THEN
3067: -- Login at the workorder level will be disabled.
3068: CLOSE c_check_res_reqd;
3069: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WO_NO_RESREQ');
3070: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3071: FND_MSG_PUB.ADD;
3072: RETURN FND_API.G_FALSE;
3073: END IF; -- c_check_res_reqd.
3074: CLOSE c_check_res_reqd;

Line 3085: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WOOPS_NOTQUAL');

3081: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, operation_rec.operation_seq_num);
3082: FETCH c_qualified_for_one_res INTO l_junk;
3083: IF c_qualified_for_one_res%NOTFOUND THEN
3084: CLOSE c_qualified_for_one_res;
3085: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WOOPS_NOTQUAL');
3086: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3087: FND_MSG_PUB.ADD;
3088: RETURN FND_API.G_FALSE;
3089: END IF; -- c_qualified_for_one_ops

Line 3086: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);

3082: FETCH c_qualified_for_one_res INTO l_junk;
3083: IF c_qualified_for_one_res%NOTFOUND THEN
3084: CLOSE c_qualified_for_one_res;
3085: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_WOOPS_NOTQUAL');
3086: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3087: FND_MSG_PUB.ADD;
3088: RETURN FND_API.G_FALSE;
3089: END IF; -- c_qualified_for_one_ops
3090: CLOSE c_qualified_for_one_res;

Line 3103: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_MULTI_RES_WO');

3099: FETCH c_check_res_multiple_wo INTO l_junk;
3100: IF (c_check_res_multiple_wo%FOUND) THEN
3101: -- disable login at WO level.
3102: CLOSE c_check_res_multiple_wo;
3103: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_MULTI_RES_WO');
3104: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3105: FND_MSG_PUB.ADD;
3106: RETURN FND_API.G_FALSE;
3107: END IF;

Line 3104: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);

3100: IF (c_check_res_multiple_wo%FOUND) THEN
3101: -- disable login at WO level.
3102: CLOSE c_check_res_multiple_wo;
3103: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_MULTI_RES_WO');
3104: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3105: FND_MSG_PUB.ADD;
3106: RETURN FND_API.G_FALSE;
3107: END IF;
3108: CLOSE c_check_res_multiple_wo;

Line 3129: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');

3125: OPEN c_is_op_seq_valid (p_workorder_id, p_operation_seq_num, l_wip_entity_id);
3126: FETCH c_is_op_seq_valid INTO l_junk;
3127: IF c_is_op_seq_valid%NOTFOUND THEN
3128: CLOSE c_is_op_seq_valid;
3129: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
3130: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3131: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3132: FND_MSG_PUB.ADD;
3133: RETURN FND_API.G_FALSE;

Line 3130: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);

3126: FETCH c_is_op_seq_valid INTO l_junk;
3127: IF c_is_op_seq_valid%NOTFOUND THEN
3128: CLOSE c_is_op_seq_valid;
3129: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
3130: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3131: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3132: FND_MSG_PUB.ADD;
3133: RETURN FND_API.G_FALSE;
3134: END IF; -- c_is_op_seq_valid.

Line 3131: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);

3127: IF c_is_op_seq_valid%NOTFOUND THEN
3128: CLOSE c_is_op_seq_valid;
3129: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_INVALID');
3130: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3131: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3132: FND_MSG_PUB.ADD;
3133: RETURN FND_API.G_FALSE;
3134: END IF; -- c_is_op_seq_valid.
3135: CLOSE c_is_op_seq_valid;

Line 3157: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_NOT_QUAL');

3153: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, p_operation_seq_num);
3154: FETCH c_qualified_for_one_res INTO l_junk;
3155: IF (c_qualified_for_one_res%NOTFOUND) THEN
3156: CLOSE c_qualified_for_one_res;
3157: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_NOT_QUAL');
3158: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3159: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3160: FND_MSG_PUB.ADD;
3161: RETURN FND_API.G_FALSE;

Line 3158: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);

3154: FETCH c_qualified_for_one_res INTO l_junk;
3155: IF (c_qualified_for_one_res%NOTFOUND) THEN
3156: CLOSE c_qualified_for_one_res;
3157: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_NOT_QUAL');
3158: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3159: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3160: FND_MSG_PUB.ADD;
3161: RETURN FND_API.G_FALSE;
3162: END IF; -- c_qualified_for_one_res

Line 3159: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);

3155: IF (c_qualified_for_one_res%NOTFOUND) THEN
3156: CLOSE c_qualified_for_one_res;
3157: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_NOT_QUAL');
3158: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3159: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3160: FND_MSG_PUB.ADD;
3161: RETURN FND_API.G_FALSE;
3162: END IF; -- c_qualified_for_one_res
3163: CLOSE c_qualified_for_one_res;

Line 3175: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_MULTI_RES_OP');

3171: FETCH c_check_res_multiple_op INTO l_junk;
3172: IF (c_check_res_multiple_op%FOUND) THEN
3173: -- disable login at WO level.
3174: CLOSE c_check_res_multiple_op;
3175: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_MULTI_RES_OP');
3176: FND_MESSAGE.set_token('OP_NUM' , p_operation_seq_num);
3177: FND_MSG_PUB.ADD;
3178: RETURN FND_API.G_FALSE;
3179: END IF;

Line 3176: FND_MESSAGE.set_token('OP_NUM' , p_operation_seq_num);

3172: IF (c_check_res_multiple_op%FOUND) THEN
3173: -- disable login at WO level.
3174: CLOSE c_check_res_multiple_op;
3175: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_MULTI_RES_OP');
3176: FND_MESSAGE.set_token('OP_NUM' , p_operation_seq_num);
3177: FND_MSG_PUB.ADD;
3178: RETURN FND_API.G_FALSE;
3179: END IF;
3180: CLOSE c_check_res_multiple_op;

Line 3198: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RESSEQ_INVALID');

3194: OPEN c_get_resrc_id(l_wip_entity_id, p_operation_seq_num, p_resource_seq_num);
3195: FETCH c_get_resrc_id INTO l_resource_id;
3196: IF (c_get_resrc_id%NOTFOUND) THEN
3197: CLOSE c_get_resrc_id;
3198: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RESSEQ_INVALID');
3199: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3200: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3201: FND_MESSAGE.set_token('RES_NAME' ,p_resource_seq_num);
3202: FND_MSG_PUB.ADD;

Line 3199: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);

3195: FETCH c_get_resrc_id INTO l_resource_id;
3196: IF (c_get_resrc_id%NOTFOUND) THEN
3197: CLOSE c_get_resrc_id;
3198: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RESSEQ_INVALID');
3199: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3200: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3201: FND_MESSAGE.set_token('RES_NAME' ,p_resource_seq_num);
3202: FND_MSG_PUB.ADD;
3203: RETURN FND_API.G_FALSE;

Line 3200: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);

3196: IF (c_get_resrc_id%NOTFOUND) THEN
3197: CLOSE c_get_resrc_id;
3198: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RESSEQ_INVALID');
3199: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3200: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3201: FND_MESSAGE.set_token('RES_NAME' ,p_resource_seq_num);
3202: FND_MSG_PUB.ADD;
3203: RETURN FND_API.G_FALSE;
3204: END IF;

Line 3201: FND_MESSAGE.set_token('RES_NAME' ,p_resource_seq_num);

3197: CLOSE c_get_resrc_id;
3198: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RESSEQ_INVALID');
3199: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3200: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3201: FND_MESSAGE.set_token('RES_NAME' ,p_resource_seq_num);
3202: FND_MSG_PUB.ADD;
3203: RETURN FND_API.G_FALSE;
3204: END IF;
3205: CLOSE c_get_resrc_id;

Line 3215: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RESID_INVALID');

3211: OPEN c_is_resource_valid(l_resource_id, l_org_id);
3212: FETCH c_is_resource_valid INTO l_resource_code;
3213: IF (c_is_resource_valid%NOTFOUND) THEN
3214: CLOSE c_is_resource_valid;
3215: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RESID_INVALID');
3216: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3217: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3218: FND_MESSAGE.set_token('RES_ID' , l_resource_id);
3219: FND_MSG_PUB.ADD;

Line 3216: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);

3212: FETCH c_is_resource_valid INTO l_resource_code;
3213: IF (c_is_resource_valid%NOTFOUND) THEN
3214: CLOSE c_is_resource_valid;
3215: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RESID_INVALID');
3216: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3217: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3218: FND_MESSAGE.set_token('RES_ID' , l_resource_id);
3219: FND_MSG_PUB.ADD;
3220: RETURN FND_API.G_FALSE;

Line 3217: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);

3213: IF (c_is_resource_valid%NOTFOUND) THEN
3214: CLOSE c_is_resource_valid;
3215: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RESID_INVALID');
3216: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3217: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3218: FND_MESSAGE.set_token('RES_ID' , l_resource_id);
3219: FND_MSG_PUB.ADD;
3220: RETURN FND_API.G_FALSE;
3221: END IF; -- c_is_resource_valid

Line 3218: FND_MESSAGE.set_token('RES_ID' , l_resource_id);

3214: CLOSE c_is_resource_valid;
3215: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_RESID_INVALID');
3216: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3217: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3218: FND_MESSAGE.set_token('RES_ID' , l_resource_id);
3219: FND_MSG_PUB.ADD;
3220: RETURN FND_API.G_FALSE;
3221: END IF; -- c_is_resource_valid
3222: CLOSE c_is_resource_valid;

Line 3232: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_NOTQUAL');

3228: l_resource_id);
3229: FETCH c_qualify_res INTO l_junk;
3230: IF (c_qualify_res%FOUND) THEN
3231: CLOSE c_qualify_res;
3232: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_NOTQUAL');
3233: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3234: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3235: FND_MESSAGE.set_token('RES_NUM', l_resource_code);
3236: FND_MSG_PUB.ADD;

Line 3233: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);

3229: FETCH c_qualify_res INTO l_junk;
3230: IF (c_qualify_res%FOUND) THEN
3231: CLOSE c_qualify_res;
3232: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_NOTQUAL');
3233: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3234: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3235: FND_MESSAGE.set_token('RES_NUM', l_resource_code);
3236: FND_MSG_PUB.ADD;
3237: RETURN FND_API.G_FALSE;

Line 3234: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);

3230: IF (c_qualify_res%FOUND) THEN
3231: CLOSE c_qualify_res;
3232: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_NOTQUAL');
3233: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3234: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3235: FND_MESSAGE.set_token('RES_NUM', l_resource_code);
3236: FND_MSG_PUB.ADD;
3237: RETURN FND_API.G_FALSE;
3238: END IF;

Line 3235: FND_MESSAGE.set_token('RES_NUM', l_resource_code);

3231: CLOSE c_qualify_res;
3232: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_OP_NOTQUAL');
3233: FND_MESSAGE.SET_TOKEN('OP_NUM', p_operation_seq_num);
3234: FND_MESSAGE.set_token('WO_NUM' , l_wo_name);
3235: FND_MESSAGE.set_token('RES_NUM', l_resource_code);
3236: FND_MSG_PUB.ADD;
3237: RETURN FND_API.G_FALSE;
3238: END IF;
3239: CLOSE c_qualify_res;