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.

APPS.ENG_WORKFLOW_UTIL dependencies on FND_API

Line 106: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS)

102: );
103:
104: FND_FILE.put_line(FND_FILE.LOG, 'Log file location --> '||l_log_output_dir||'/'||g_debug_filename ||' created with status '|| l_log_return_status);
105:
106: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS)
107: THEN
108: FND_FILE.put_line(FND_FILE.LOG, 'Unable to open error log file. Error => '||l_errbuff) ;
109: END IF;
110:

Line 149: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

145: -- FND_MSG_PUB.Add_Exc_Msg
146: -- ( G_PKG_NAME ,
147: -- 'Open_Debug_Session' ,
148: -- l_error_mesg ) ;
149: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
150:
151: FND_FILE.put_line(FND_FILE.LOG, G_PKG_NAME || ' Open_Debug_Session: LOGGING ERROR > '||l_error_mesg);
152: g_debug_flag := FALSE;
153: RETURN;

Line 168: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

164: WHEN OTHERS THEN
165: g_debug_errmesg := Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240);
166: FND_FILE.put_line(FND_FILE.LOG, 'LOGGING SQL ERROR => '||g_debug_errmesg);
167: g_debug_flag := FALSE;
168: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
169:
170: END Open_Debug_Session ;
171:
172:

Line 195: OR FND_API.to_Boolean(p_debug_flag)

191: g_profile_debug_option := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), TO_CHAR(0));
192: g_profile_debug_level := NVL(FND_PROFILE.VALUE('INV_DEBUG_LEVEL'), TO_CHAR(0));
193:
194: IF (g_profile_debug_option = '1' AND TO_NUMBER(g_profile_debug_level) >= 20)
195: OR FND_API.to_Boolean(p_debug_flag)
196: THEN
197:
198: ----------------------------------------------------------------------------------
199: -- Opens Error_Handler debug session, only if Debug session is not already open.

Line 244: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

240: -- ( G_PKG_NAME ,
241: -- 'Close_Debug_Session' ,
242: -- l_error_mesg ) ;
243: --
244: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
245:
246: END Close_Debug_Session ;
247:
248: -- Test Debug

Line 297: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

293: -- ( G_PKG_NAME ,
294: -- 'Write_Debug' ,
295: -- l_error_mesg ) ;
296: --
297: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
298:
299: END Write_Debug;
300:
301: PROCEDURE Get_Debug_Mode

Line 322: IF FND_API.to_Boolean( l_debug_flag ) THEN

318: , p_item_key
319: , '.DEBUG_FLAG'
320: );
321:
322: IF FND_API.to_Boolean( l_debug_flag ) THEN
323: x_debug_flag := TRUE ;
324: END IF ;
325:
326:

Line 4006: x_return_status := FND_API.G_RET_STS_SUCCESS;

4002: l_header BOOLEAN := TRUE ;
4003:
4004: BEGIN
4005:
4006: x_return_status := FND_API.G_RET_STS_SUCCESS;
4007: l_user_id := p_wf_user_id ;
4008:
4009: SELECT meaning
4010: INTO l_approval_status

Line 4236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4232: IF g_debug_flag THEN
4233: Write_Debug('When Others in SetChangeApprovalStatus ' || SQLERRM );
4234: END IF ;
4235:
4236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4237: IF FND_MSG_PUB.Check_Msg_Level
4238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4239: THEN
4240: FND_MSG_PUB.Add_Exc_Msg

Line 4294: l_return_status := FND_API.G_RET_STS_SUCCESS;

4290:
4291: BEGIN
4292:
4293: -- Initialize API return status to success
4294: l_return_status := FND_API.G_RET_STS_SUCCESS;
4295: x_return_status := FND_API.G_RET_STS_SUCCESS;
4296:
4297:
4298: -- Get Lines for this Header

Line 4295: x_return_status := FND_API.G_RET_STS_SUCCESS;

4291: BEGIN
4292:
4293: -- Initialize API return status to success
4294: l_return_status := FND_API.G_RET_STS_SUCCESS;
4295: x_return_status := FND_API.G_RET_STS_SUCCESS;
4296:
4297:
4298: -- Get Lines for this Header
4299: FOR l_line_rec IN c_lines (p_change_id)

Line 4324: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

4320: , p_wf_user_id => p_wf_user_id
4321: , p_new_appr_status_type => p_header_appr_status_type
4322: ) ;
4323:
4324: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4325: THEN
4326:
4327: x_return_status := l_return_status ;
4328:

Line 4343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4339: IF g_debug_flag THEN
4340: Write_Debug('When Others in SyncLineApprovalStatus ' || SQLERRM );
4341: END IF ;
4342:
4343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4344: IF FND_MSG_PUB.Check_Msg_Level
4345: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4346: THEN
4347: FND_MSG_PUB.Add_Exc_Msg

Line 4363: , p_init_route IN VARCHAR2 := FND_API.G_FALSE

4359: , p_item_key IN VARCHAR2
4360: , p_wf_user_id IN NUMBER
4361: , p_route_id IN NUMBER
4362: , p_new_status_code IN VARCHAR2
4363: , p_init_route IN VARCHAR2 := FND_API.G_FALSE
4364: , p_change_id IN NUMBER := NULL
4365: , p_change_line_id IN NUMBER := NULL
4366: )
4367: IS

Line 4411: IF FND_API.To_Boolean( p_init_route )

4407: END IF ;
4408:
4409:
4410: -- Check if this call is to initialize Route Process
4411: IF FND_API.To_Boolean( p_init_route )
4412: AND p_change_id IS NOT NULL
4413: AND p_change_id > 0
4414: THEN
4415: -- Get Current Change Revision

Line 4503: , p_init_msg_list => FND_API.G_FALSE

4499: ( p_api_version => 1.0
4500: , x_return_status => l_return_status
4501: , x_msg_count => l_msg_count
4502: , x_msg_data => l_msg_data
4503: , p_init_msg_list => FND_API.G_FALSE
4504: , p_commit => FND_API.G_FALSE
4505: , p_action_type => Eng_Workflow_Util.G_LINE_ACT_CHG_STATUS
4506: , p_object_name => Eng_Workflow_Util.G_ENG_CHANGE_LINE
4507: , p_object_id1 => p_change_id

Line 4504: , p_commit => FND_API.G_FALSE

4500: , x_return_status => l_return_status
4501: , x_msg_count => l_msg_count
4502: , x_msg_data => l_msg_data
4503: , p_init_msg_list => FND_API.G_FALSE
4504: , p_commit => FND_API.G_FALSE
4505: , p_action_type => Eng_Workflow_Util.G_LINE_ACT_CHG_STATUS
4506: , p_object_name => Eng_Workflow_Util.G_ENG_CHANGE_LINE
4507: , p_object_id1 => p_change_id
4508: , p_object_id2 => p_change_line_id

Line 4527: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

4523: Write_Debug('After Creating Line Status Action Log: return status ' || l_return_status
4524: || '- Act Id:' || to_char(l_line_stat_chg_act_id) );
4525: END IF ;
4526:
4527: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4528: THEN
4529: RAISE FND_API.G_EXC_ERROR ;
4530: END IF ;
4531:

Line 4529: RAISE FND_API.G_EXC_ERROR ;

4525: END IF ;
4526:
4527: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4528: THEN
4529: RAISE FND_API.G_EXC_ERROR ;
4530: END IF ;
4531:
4532:
4533: -- 3. Start Line Status Change Workflow

Line 4541: , p_init_msg_list => FND_API.G_FALSE

4537:
4538: -- Create and Start Line Status Change Workflow to send Resp FYI ntf
4539: Eng_Workflow_Util.StartWorkflow
4540: ( p_api_version => 1.0
4541: , p_init_msg_list => FND_API.G_FALSE
4542: , p_commit => FND_API.G_FALSE
4543: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4544: , x_return_status => l_return_status
4545: , x_msg_count => l_msg_count

Line 4542: , p_commit => FND_API.G_FALSE

4538: -- Create and Start Line Status Change Workflow to send Resp FYI ntf
4539: Eng_Workflow_Util.StartWorkflow
4540: ( p_api_version => 1.0
4541: , p_init_msg_list => FND_API.G_FALSE
4542: , p_commit => FND_API.G_FALSE
4543: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4544: , x_return_status => l_return_status
4545: , x_msg_count => l_msg_count
4546: , x_msg_data => l_msg_data

Line 4543: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

4539: Eng_Workflow_Util.StartWorkflow
4540: ( p_api_version => 1.0
4541: , p_init_msg_list => FND_API.G_FALSE
4542: , p_commit => FND_API.G_FALSE
4543: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4544: , x_return_status => l_return_status
4545: , x_msg_count => l_msg_count
4546: , x_msg_data => l_msg_data
4547: , p_item_type => Eng_Workflow_Util.G_CHANGE_LINE_ACTION_ITEM_TYPE

Line 4557: , p_debug => FND_API.G_FALSE

4553: , p_host_url => NULL
4554: , p_action_id => l_line_stat_chg_act_id
4555: , p_route_id => 0
4556: , p_route_step_id => 0
4557: , p_debug => FND_API.G_FALSE
4558: , p_output_dir => NULL
4559: , p_debug_filename => 'Eng_LineStatChg_Start.log'
4560: ) ;
4561:

Line 4850: x_return_status := FND_API.G_RET_STS_SUCCESS;

4846:
4847: BEGIN
4848:
4849: -- Initialize API return status to success
4850: x_return_status := FND_API.G_RET_STS_SUCCESS;
4851:
4852: l_change_id := p_change_id ;
4853:
4854: IF g_debug_flag THEN

Line 5723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5719: Write_Debug('When Others in SetAttributes ' || SQLERRM );
5720: END IF ;
5721:
5722:
5723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5724: IF FND_MSG_PUB.Check_Msg_Level
5725: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5726: THEN
5727: FND_MSG_PUB.Add_Exc_Msg

Line 5759: l_return_status := FND_API.G_RET_STS_SUCCESS;

5755:
5756: BEGIN
5757:
5758: -- Initialize API return status to success
5759: l_return_status := FND_API.G_RET_STS_SUCCESS;
5760:
5761:
5762: FOR step_rec IN c_route_req_date(p_route_id => p_route_id)
5763: LOOP

Line 5771: l_return_status := FND_API.G_RET_STS_ERROR ;

5767: -- for bug fix3456536
5768: IF step_rec.required_date < SYSDATE THEN
5769:
5770:
5771: l_return_status := FND_API.G_RET_STS_ERROR ;
5772:
5773: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_REQDATE_INVALID') ;
5774: FND_MESSAGE.SET_TOKEN('STEP_SEQ_NUM', step_rec.step_seq_num );
5775: FND_MSG_PUB.Add ;

Line 5785: l_return_status := FND_API.G_RET_STS_ERROR ;

5781: IF step_rec.required_date < l_pre_require_date
5782: THEN
5783:
5784:
5785: l_return_status := FND_API.G_RET_STS_ERROR ;
5786:
5787: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_REQDATE_LESS') ;
5788: FND_MESSAGE.SET_TOKEN('STEP_SEQ_NUM', step_rec.step_seq_num );
5789: FND_MSG_PUB.Add ;

Line 5808: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5804:
5805:
5806: END LOOP ;
5807:
5808: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5809:
5810: RETURN FALSE ;
5811:
5812: END IF ;

Line 5855: l_return_status := FND_API.G_RET_STS_SUCCESS;

5851:
5852:
5853:
5854: BEGIN
5855: l_return_status := FND_API.G_RET_STS_SUCCESS;
5856:
5857:
5858: -- Check Route Status
5859: FOR route_rec IN c_route_status(p_route_id => p_route_id)

Line 5862: l_return_status := FND_API.G_RET_STS_ERROR ;

5858: -- Check Route Status
5859: FOR route_rec IN c_route_status(p_route_id => p_route_id)
5860: LOOP
5861:
5862: l_return_status := FND_API.G_RET_STS_ERROR ;
5863:
5864: IF p_change_line_id IS NOT NULL AND p_change_line_id > 0
5865: THEN
5866:

Line 5897: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5893:
5894: END LOOP ;
5895:
5896:
5897: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5898:
5899: RETURN FALSE ;
5900:
5901: END IF ;

Line 5907: l_return_status := FND_API.G_RET_STS_ERROR ;

5903: -- Check Route is instance
5904: FOR route_rec IN c_route_instance(p_route_id => p_route_id)
5905: LOOP
5906:
5907: l_return_status := FND_API.G_RET_STS_ERROR ;
5908:
5909: -- Set Error Message for Header
5910: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_NOT_INSTANCE') ;
5911: FND_MSG_PUB.Add ;

Line 5916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5912:
5913: END LOOP ;
5914:
5915:
5916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5917:
5918: RETURN FALSE ;
5919:
5920: END IF ;

Line 5963: l_return_status := FND_API.G_RET_STS_SUCCESS;

5959:
5960: BEGIN
5961:
5962: -- Initialize API return status to success
5963: l_return_status := FND_API.G_RET_STS_SUCCESS;
5964:
5965:
5966: FOR route_rec IN c_route_assignees(p_route_id => p_route_id)
5967: LOOP

Line 5969: l_return_status := FND_API.G_RET_STS_ERROR ;

5965:
5966: FOR route_rec IN c_route_assignees(p_route_id => p_route_id)
5967: LOOP
5968:
5969: l_return_status := FND_API.G_RET_STS_ERROR ;
5970:
5971: IF p_change_line_id IS NOT NULL AND p_change_line_id > 0
5972: THEN
5973:

Line 6006: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6002:
6003:
6004: END LOOP ;
6005:
6006: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6007:
6008: RETURN FALSE ;
6009:
6010: END IF ;

Line 6035: l_return_status := FND_API.G_RET_STS_SUCCESS;

6031: route_rec c_Mandatory_route_assignees%rowtype;
6032: BEGIN
6033:
6034: -- Initialize API return status to success
6035: l_return_status := FND_API.G_RET_STS_SUCCESS;
6036:
6037: OPEN c_Mandatory_route_assignees(p_route_id => p_route_id) ;
6038: FETCH c_Mandatory_route_assignees into route_rec;
6039:

Line 6041: l_return_status := FND_API.G_RET_STS_ERROR ;

6037: OPEN c_Mandatory_route_assignees(p_route_id => p_route_id) ;
6038: FETCH c_Mandatory_route_assignees into route_rec;
6039:
6040: IF (c_Mandatory_route_assignees%found) THEN
6041: l_return_status := FND_API.G_RET_STS_ERROR ;
6042:
6043: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_MANDAT_ASSIGN_MISS') ;
6044: --fnd_message.SET_TOKEN ('STEP_NO',route_rec.STEP_SEQ_NUM , TRUE);
6045: FND_MSG_PUB.Add ;

Line 6049: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6045: FND_MSG_PUB.Add ;
6046:
6047: END IF ;
6048:
6049: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6050:
6051: RETURN FALSE ;
6052:
6053: END IF ;

Line 6062: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

6058:
6059:
6060:
6061: PROCEDURE ValidateProcess
6062: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6063: , x_return_status OUT NOCOPY VARCHAR2
6064: , x_msg_count OUT NOCOPY NUMBER
6065: , x_msg_data OUT NOCOPY VARCHAR2
6066: , p_item_type IN VARCHAR2

Line 6102: x_return_status := FND_API.G_RET_STS_SUCCESS;

6098:
6099: BEGIN
6100:
6101: -- Initialize API return status to success
6102: x_return_status := FND_API.G_RET_STS_SUCCESS;
6103:
6104: IF p_validation_level <= FND_API.G_VALID_LEVEL_NONE THEN
6105: RETURN ;
6106: END IF ;

Line 6104: IF p_validation_level <= FND_API.G_VALID_LEVEL_NONE THEN

6100:
6101: -- Initialize API return status to success
6102: x_return_status := FND_API.G_RET_STS_SUCCESS;
6103:
6104: IF p_validation_level <= FND_API.G_VALID_LEVEL_NONE THEN
6105: RETURN ;
6106: END IF ;
6107:
6108: -- Item Type: ALL

Line 6157: , p_init_msg_list => FND_API.G_FALSE --

6153: END IF ;
6154:
6155: ENG_DOCUMENT_UTIL.Start_Doc_LC_Phase_WF
6156: ( p_api_version => 1.0
6157: , p_init_msg_list => FND_API.G_FALSE --
6158: , p_commit => FND_API.G_FALSE --
6159: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6160: , x_return_status => l_return_status
6161: , x_msg_count => l_msg_count

Line 6158: , p_commit => FND_API.G_FALSE --

6154:
6155: ENG_DOCUMENT_UTIL.Start_Doc_LC_Phase_WF
6156: ( p_api_version => 1.0
6157: , p_init_msg_list => FND_API.G_FALSE --
6158: , p_commit => FND_API.G_FALSE --
6159: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6160: , x_return_status => l_return_status
6161: , x_msg_count => l_msg_count
6162: , x_msg_data => l_msg_data

Line 6159: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

6155: ENG_DOCUMENT_UTIL.Start_Doc_LC_Phase_WF
6156: ( p_api_version => 1.0
6157: , p_init_msg_list => FND_API.G_FALSE --
6158: , p_commit => FND_API.G_FALSE --
6159: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6160: , x_return_status => l_return_status
6161: , x_msg_count => l_msg_count
6162: , x_msg_data => l_msg_data
6163: , p_change_id => p_change_id -- Change Id

Line 6171: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

6167:
6168: IF g_debug_flag THEN
6169: Write_Debug('After calling ENG_DOCUMENT_UTIL.Start_Doc_LC_Phase_WF: ' || l_return_status );
6170: END IF ;
6171: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
6172: THEN
6173: x_return_status := l_return_status ;
6174: END IF ;
6175:

Line 6183: x_return_status := FND_API.G_RET_STS_ERROR ;

6179:
6180:
6181: IF NOT CheckMandatoryAssignee(p_route_id => p_route_id)
6182: THEN
6183: x_return_status := FND_API.G_RET_STS_ERROR ;
6184: END IF;
6185:
6186:
6187: /*

Line 6199: x_return_status := FND_API.G_RET_STS_ERROR ;

6195: -- 2. the greater step num, the later required date
6196: IF NOT CheckRouteStepRequiredDate(p_route_id => p_route_id)
6197: THEN
6198:
6199: x_return_status := FND_API.G_RET_STS_ERROR ;
6200:
6201: END IF ;
6202: */
6203:

Line 6217: x_return_status := FND_API.G_RET_STS_ERROR ;

6213: Write_Debug('Verify Route is Instance . . .');
6214: END IF ;
6215:
6216:
6217: x_return_status := FND_API.G_RET_STS_ERROR ;
6218:
6219: END IF ;
6220:
6221:

Line 6235: x_return_status := FND_API.G_RET_STS_ERROR ;

6231: IF g_debug_flag THEN
6232: Write_Debug('Verify there is not missing assignee . . .');
6233: END IF ;
6234:
6235: x_return_status := FND_API.G_RET_STS_ERROR ;
6236:
6237: END IF ;
6238: */
6239:

Line 6257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6253:
6254: EXCEPTION
6255: WHEN OTHERS THEN
6256:
6257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6258: IF FND_MSG_PUB.Check_Msg_Level
6259: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6260: THEN
6261: FND_MSG_PUB.Add_Exc_Msg

Line 6271: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

6267: END ValidateProcess;
6268:
6269:
6270: PROCEDURE ValidateAbortingProcess
6271: ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
6272: , x_return_status OUT NOCOPY VARCHAR2
6273: , x_msg_count OUT NOCOPY NUMBER
6274: , x_msg_data OUT NOCOPY VARCHAR2
6275: , p_item_type IN VARCHAR2

Line 6288: x_return_status := FND_API.G_RET_STS_SUCCESS;

6284:
6285: BEGIN
6286:
6287: -- Initialize API return status to success
6288: x_return_status := FND_API.G_RET_STS_SUCCESS;
6289:
6290: IF p_validation_level <= FND_API.G_VALID_LEVEL_NONE THEN
6291: RETURN ;
6292: END IF ;

Line 6290: IF p_validation_level <= FND_API.G_VALID_LEVEL_NONE THEN

6286:
6287: -- Initialize API return status to success
6288: x_return_status := FND_API.G_RET_STS_SUCCESS;
6289:
6290: IF p_validation_level <= FND_API.G_VALID_LEVEL_NONE THEN
6291: RETURN ;
6292: END IF ;
6293:
6294:

Line 6318: x_return_status := FND_API.G_RET_STS_ERROR ;

6314:
6315: IF l_status = G_WF_COMPLETE
6316: THEN
6317:
6318: x_return_status := FND_API.G_RET_STS_ERROR ;
6319:
6320: FND_MESSAGE.SET_NAME('ENG', 'ENG_ROUTE_WF_NOT_RUNNING') ;
6321: FND_MSG_PUB.Add ;
6322:

Line 6328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6324:
6325: EXCEPTION
6326: WHEN OTHERS THEN
6327:
6328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6329: IF FND_MSG_PUB.Check_Msg_Level
6330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6331: THEN
6332: FND_MSG_PUB.Add_Exc_Msg

Line 6371: x_return_status := FND_API.G_RET_STS_SUCCESS;

6367:
6368: BEGIN
6369:
6370: -- Initialize API return status to success
6371: x_return_status := FND_API.G_RET_STS_SUCCESS;
6372:
6373: -- Get Adhoc Party List
6374: list_rest := LTRIM(p_adhoc_party_list) ;
6375: LOOP

Line 6442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6438:
6439: EXCEPTION
6440: WHEN OTHERS THEN
6441:
6442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6443: IF FND_MSG_PUB.Check_Msg_Level
6444: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6445: THEN
6446: FND_MSG_PUB.Add_Exc_Msg

Line 6491: x_return_status := FND_API.G_RET_STS_SUCCESS;

6487: END IF ;
6488:
6489:
6490: -- Initialize API return status to success
6491: x_return_status := FND_API.G_RET_STS_SUCCESS;
6492:
6493: -- Get Change Object Identifier
6494: GetChangeObject
6495: ( p_item_type => p_item_type

Line 6557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6553:
6554: EXCEPTION
6555: WHEN OTHERS THEN
6556:
6557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6558: IF FND_MSG_PUB.Check_Msg_Level
6559: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6560: THEN
6561: FND_MSG_PUB.Add_Exc_Msg

Line 6613: x_return_status := FND_API.G_RET_STS_SUCCESS;

6609:
6610:
6611:
6612: -- Initialize API return status to success
6613: x_return_status := FND_API.G_RET_STS_SUCCESS;
6614:
6615: IF g_debug_flag THEN
6616: Write_Debug('Get Change Object Identifier . . . ' );
6617: END IF ;

Line 6726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6722:
6723: EXCEPTION
6724: WHEN OTHERS THEN
6725:
6726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6727: IF FND_MSG_PUB.Check_Msg_Level
6728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6729: THEN
6730: FND_MSG_PUB.Add_Exc_Msg

Line 6767: l_debug VARCHAR2(1) := FND_API.G_FALSE ;

6763:
6764: l_return_status VARCHAR2(1) ;
6765: l_line_item_key VARCHAR2(240) ;
6766: l_change_id NUMBER ;
6767: l_debug VARCHAR2(1) := FND_API.G_FALSE ;
6768: l_output_dir VARCHAR2(240) := '' ;
6769: l_debug_filename VARCHAR2(200) := 'StartAllLineWorkflows.log' ;
6770:
6771: CURSOR c_lines (p_change_id NUMBER)

Line 6795: l_return_status := FND_API.G_RET_STS_SUCCESS;

6791: Write_Debug('-----------------------------------------------------');
6792: END IF ;
6793:
6794: -- Initialize API return status to success
6795: l_return_status := FND_API.G_RET_STS_SUCCESS;
6796: x_return_status := FND_API.G_RET_STS_SUCCESS;
6797:
6798:
6799: --

Line 6796: x_return_status := FND_API.G_RET_STS_SUCCESS;

6792: END IF ;
6793:
6794: -- Initialize API return status to success
6795: l_return_status := FND_API.G_RET_STS_SUCCESS;
6796: x_return_status := FND_API.G_RET_STS_SUCCESS;
6797:
6798:
6799: --
6800: -- Don't try to get Parent Item Attributes from this procedure

Line 6818: , p_init_msg_list => FND_API.G_FALSE

6814: -- Start Change Line Workflows
6815: -- FND_MSG_PUB.initialize ;
6816: Eng_Workflow_Util.StartWorkflow
6817: ( p_api_version => 1.0
6818: , p_init_msg_list => FND_API.G_FALSE
6819: , p_commit => FND_API.G_FALSE
6820: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6821: , x_return_status => l_return_status
6822: , x_msg_count => x_msg_count

Line 6819: , p_commit => FND_API.G_FALSE

6815: -- FND_MSG_PUB.initialize ;
6816: Eng_Workflow_Util.StartWorkflow
6817: ( p_api_version => 1.0
6818: , p_init_msg_list => FND_API.G_FALSE
6819: , p_commit => FND_API.G_FALSE
6820: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6821: , x_return_status => l_return_status
6822: , x_msg_count => x_msg_count
6823: , x_msg_data => x_msg_data

Line 6820: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

6816: Eng_Workflow_Util.StartWorkflow
6817: ( p_api_version => 1.0
6818: , p_init_msg_list => FND_API.G_FALSE
6819: , p_commit => FND_API.G_FALSE
6820: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
6821: , x_return_status => l_return_status
6822: , x_msg_count => x_msg_count
6823: , x_msg_data => x_msg_data
6824: , p_item_type => p_line_item_type

Line 6837: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

6833: , p_output_dir => l_output_dir
6834: , p_debug_filename => l_debug_filename || TO_CHAR(line_rec.change_line_id)
6835: ) ;
6836:
6837: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
6838: THEN
6839:
6840: x_return_status := l_return_status ;
6841:

Line 6859: IF x_return_status = FND_API.G_RET_STS_SUCCESS

6855: END LOOP ;
6856:
6857:
6858:
6859: IF x_return_status = FND_API.G_RET_STS_SUCCESS
6860: THEN
6861:
6862: -- COMMENT OUT PRAGMA AUTONOMOUS_TRANSACTION
6863: -- COMMIT ;

Line 6870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

6866: ELSE
6867:
6868: -- COMMENT OUT PRAGMA AUTONOMOUS_TRANSACTION
6869: -- ROLLBACK ;
6870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6871:
6872: END IF ;
6873:
6874:

Line 6878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6874:
6875: EXCEPTION
6876: WHEN OTHERS THEN
6877: -- ROLLBACK ;
6878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6879:
6880: IF FND_MSG_PUB.Check_Msg_Level
6881: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6882: THEN

Line 6925: x_return_status := FND_API.G_RET_STS_SUCCESS;

6921: Write_Debug('-----------------------------------------------------');
6922: END IF ;
6923:
6924: -- Initialize API return status to success
6925: x_return_status := FND_API.G_RET_STS_SUCCESS;
6926:
6927: -- Get Change Line Object Identifier
6928: GetChangeLineObject
6929: ( p_item_type => p_item_type

Line 6987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6983:
6984: EXCEPTION
6985: WHEN OTHERS THEN
6986:
6987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6988: IF FND_MSG_PUB.Check_Msg_Level
6989: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6990: THEN
6991: FND_MSG_PUB.Add_Exc_Msg

Line 7045: x_return_status := FND_API.G_RET_STS_SUCCESS;

7041: END IF ;
7042:
7043:
7044: -- Initialize API return status to success
7045: x_return_status := FND_API.G_RET_STS_SUCCESS;
7046:
7047: IF g_debug_flag THEN
7048: Write_Debug('Get Change Header and Line Object Identifier . . . ' );
7049: END IF ;

Line 7169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7165:
7166: EXCEPTION
7167: WHEN OTHERS THEN
7168:
7169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7170: IF FND_MSG_PUB.Check_Msg_Level
7171: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7172: THEN
7173: FND_MSG_PUB.Add_Exc_Msg

Line 7225: x_return_status := FND_API.G_RET_STS_SUCCESS;

7221: END IF ;
7222:
7223:
7224: -- Initialize API return status to success
7225: x_return_status := FND_API.G_RET_STS_SUCCESS;
7226:
7227: -- Get Route Route Id
7228: GetRouteId
7229: ( p_item_type => p_item_type

Line 7295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7291:
7292: EXCEPTION
7293: WHEN OTHERS THEN
7294:
7295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7296: IF FND_MSG_PUB.Check_Msg_Level
7297: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7298: THEN
7299: FND_MSG_PUB.Add_Exc_Msg

Line 7351: x_return_status := FND_API.G_RET_STS_SUCCESS;

7347: END IF ;
7348:
7349:
7350: -- Initialize API return status to success
7351: x_return_status := FND_API.G_RET_STS_SUCCESS;
7352:
7353: -- Get Route Step Id
7354: GetRouteStepId
7355: ( p_item_type => p_item_type

Line 7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7403:
7404: EXCEPTION
7405: WHEN OTHERS THEN
7406:
7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7408: IF FND_MSG_PUB.Check_Msg_Level
7409: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7410: THEN
7411: FND_MSG_PUB.Add_Exc_Msg

Line 7448: x_return_status := FND_API.G_RET_STS_SUCCESS;

7444:
7445: BEGIN
7446:
7447: -- Initialize API return status to success
7448: x_return_status := FND_API.G_RET_STS_SUCCESS;
7449:
7450:
7451: -- Eng Workflow Adhoc Roles Pre-Fix
7452: -- G_ADHOC_PARTY_ROLE

Line 7524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7520:
7521: EXCEPTION
7522: WHEN OTHERS THEN
7523:
7524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7525: IF FND_MSG_PUB.Check_Msg_Level
7526: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7527: THEN
7528: FND_MSG_PUB.Add_Exc_Msg

Line 7548: , p_raise_event_flag IN VARCHAR2 := FND_API.G_FALSE -- R12

7544: , p_action_type IN VARCHAR2
7545: , p_comment IN VARCHAR2 := NULL
7546: , x_action_id OUT NOCOPY NUMBER
7547: , p_assignee_id IN NUMBER := NULL
7548: , p_raise_event_flag IN VARCHAR2 := FND_API.G_FALSE -- R12
7549: )
7550: IS
7551:
7552: l_api_name CONSTANT VARCHAR2(30) := 'CreateAction';

Line 7589: x_return_status := FND_API.G_RET_STS_SUCCESS;

7585: -- Write_Debug('-----------------------------------------------------');
7586: --END IF ;
7587:
7588: -- Initialize API return status to success
7589: x_return_status := FND_API.G_RET_STS_SUCCESS;
7590:
7591: -- Get Change Object Identifier
7592: GetChangeObject
7593: ( p_item_type => p_item_type

Line 7693: -- , p_init_msg_list => FND_API.g_FALSE

7689: ( p_api_version => 1.0
7690: , x_return_status => x_return_status
7691: , x_msg_count => x_msg_count
7692: , x_msg_data => x_msg_data
7693: -- , p_init_msg_list => FND_API.g_FALSE
7694: -- , p_commit => FND_API.g_FALSE
7695: , p_action_type => p_action_type
7696: , p_object_name => l_object_name
7697: , p_object_id1 => l_change_id

Line 7694: -- , p_commit => FND_API.g_FALSE

7690: , x_return_status => x_return_status
7691: , x_msg_count => x_msg_count
7692: , x_msg_data => x_msg_data
7693: -- , p_init_msg_list => FND_API.g_FALSE
7694: -- , p_commit => FND_API.g_FALSE
7695: , p_action_type => p_action_type
7696: , p_object_name => l_object_name
7697: , p_object_id1 => l_change_id
7698: , p_object_id2 => l_change_line_id

Line 7725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7721:
7722: EXCEPTION
7723: WHEN OTHERS THEN
7724:
7725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7726:
7727: IF FND_MSG_PUB.Check_Msg_Level
7728: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7729: THEN

Line 7759: , p_raise_event_flag IN VARCHAR2 := FND_API.G_FALSE -- R12

7755: , p_object_id4 IN NUMBER := NULL
7756: , p_object_id5 IN NUMBER := NULL
7757: , p_parent_object_name IN VARCHAR2 := NULL
7758: , p_parent_object_id1 IN NUMBER := NULL
7759: , p_raise_event_flag IN VARCHAR2 := FND_API.G_FALSE -- R12
7760: )
7761: IS
7762:
7763: l_api_name CONSTANT VARCHAR2(30) := 'CreateRouteAction';

Line 7799: x_return_status := FND_API.G_RET_STS_SUCCESS;

7795: Write_Debug('-----------------------------------------------------');
7796: END IF ;
7797:
7798: -- Initialize API return status to success
7799: x_return_status := FND_API.G_RET_STS_SUCCESS;
7800:
7801:
7802: IF p_change_line_id IS NOT NULL AND p_change_line_id > 0
7803: THEN

Line 7859: -- , p_init_msg_list => FND_API.g_FALSE

7855: ( p_api_version => 1.0
7856: , x_return_status => x_return_status
7857: , x_msg_count => x_msg_count
7858: , x_msg_data => x_msg_data
7859: -- , p_init_msg_list => FND_API.g_FALSE
7860: -- , p_commit => FND_API.g_FALSE
7861: , p_action_type => p_action_type
7862: , p_object_name => l_object_name
7863: , p_object_id1 => p_change_id

Line 7860: -- , p_commit => FND_API.g_FALSE

7856: , x_return_status => x_return_status
7857: , x_msg_count => x_msg_count
7858: , x_msg_data => x_msg_data
7859: -- , p_init_msg_list => FND_API.g_FALSE
7860: -- , p_commit => FND_API.g_FALSE
7861: , p_action_type => p_action_type
7862: , p_object_name => l_object_name
7863: , p_object_id1 => p_change_id
7864: , p_object_id2 => l_change_line_id

Line 7891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7887:
7888: EXCEPTION
7889: WHEN OTHERS THEN
7890:
7891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7892:
7893: IF FND_MSG_PUB.Check_Msg_Level
7894: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7895: THEN

Line 7946: x_return_status := FND_API.G_RET_STS_SUCCESS;

7942: Write_Debug('-----------------------------------------------------');
7943: END IF ;
7944:
7945: -- Initialize API return status to success
7946: x_return_status := FND_API.G_RET_STS_SUCCESS;
7947:
7948:
7949: -- In case that we have to use PRAGMA AUTONOMOUS_TRANSACTION,
7950: -- DON'T try to get Data/Item Attributes updated

Line 7994: , p_commit => FND_API.g_FALSE

7990: -- properly if it return error based on some validation
7991: -- like Mandatory task is not completed on Auto Promotion
7992: ENG_CHANGE_LIFECYCLE_UTIL.Update_Lifecycle_States
7993: ( p_api_version => 1.0
7994: , p_commit => FND_API.g_FALSE
7995: , p_init_msg_list => FND_API.g_FALSE
7996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7997: , p_debug => FND_API.G_FALSE
7998: , p_output_dir => NULL -- '/appslog/bis_top/utl/plm115dv/log'

Line 7995: , p_init_msg_list => FND_API.g_FALSE

7991: -- like Mandatory task is not completed on Auto Promotion
7992: ENG_CHANGE_LIFECYCLE_UTIL.Update_Lifecycle_States
7993: ( p_api_version => 1.0
7994: , p_commit => FND_API.g_FALSE
7995: , p_init_msg_list => FND_API.g_FALSE
7996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7997: , p_debug => FND_API.G_FALSE
7998: , p_output_dir => NULL -- '/appslog/bis_top/utl/plm115dv/log'
7999: , p_debug_filename => NULL -- 'UpdateLCStatesFromWF.log' || to_char(p_route_id)

Line 7996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

7992: ENG_CHANGE_LIFECYCLE_UTIL.Update_Lifecycle_States
7993: ( p_api_version => 1.0
7994: , p_commit => FND_API.g_FALSE
7995: , p_init_msg_list => FND_API.g_FALSE
7996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7997: , p_debug => FND_API.G_FALSE
7998: , p_output_dir => NULL -- '/appslog/bis_top/utl/plm115dv/log'
7999: , p_debug_filename => NULL -- 'UpdateLCStatesFromWF.log' || to_char(p_route_id)
8000: , x_return_status => l_return_status

Line 7997: , p_debug => FND_API.G_FALSE

7993: ( p_api_version => 1.0
7994: , p_commit => FND_API.g_FALSE
7995: , p_init_msg_list => FND_API.g_FALSE
7996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7997: , p_debug => FND_API.G_FALSE
7998: , p_output_dir => NULL -- '/appslog/bis_top/utl/plm115dv/log'
7999: , p_debug_filename => NULL -- 'UpdateLCStatesFromWF.log' || to_char(p_route_id)
8000: , x_return_status => l_return_status
8001: , x_msg_count => l_msg_count

Line 8020: -- IF x_return_status = FND_API.G_RET_STS_SUCCESS

8016: END IF ;
8017:
8018:
8019: -- Comment Out Here
8020: -- IF x_return_status = FND_API.G_RET_STS_SUCCESS
8021: -- THEN
8022: -- COMMIT ;
8023: -- ELSE
8024: -- ROLLBACK ;

Line 8034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8030: WHEN OTHERS THEN
8031:
8032: -- ROLLBACK ;
8033:
8034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8035:
8036: IF FND_MSG_PUB.Check_Msg_Level
8037: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8038: THEN

Line 8135: x_return_status := FND_API.G_RET_STS_SUCCESS;

8131: Write_Debug('-----------------------------------------------------');
8132: END IF ;
8133:
8134: -- Initialize API return status to success
8135: x_return_status := FND_API.G_RET_STS_SUCCESS;
8136:
8137:
8138: -- Check if this is setting header or line
8139: IF p_change_line_id IS NOT NULL AND p_change_line_id > 0

Line 8209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8205:
8206: EXCEPTION
8207: WHEN OTHERS THEN
8208:
8209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8210:
8211: IF FND_MSG_PUB.Check_Msg_Level
8212: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8213: THEN

Line 8336: Check_And_Open_Debug_Session(p_debug_flag => FND_API.G_FALSE

8332:
8333: BEGIN
8334:
8335: -- For Test/Debug
8336: Check_And_Open_Debug_Session(p_debug_flag => FND_API.G_FALSE
8337: , p_output_dir => NULL
8338: , p_file_name => NULL
8339: ) ;
8340:

Line 8354: x_return_status := FND_API.G_RET_STS_SUCCESS;

8350: Write_Debug('-----------------------------------------------------');
8351: END IF ;
8352:
8353: -- Initialize API return status to success
8354: x_return_status := FND_API.G_RET_STS_SUCCESS;
8355:
8356: -- Initialize Table var
8357: l_target_obj_tbl := FND_TABLE_OF_VARCHAR2_30();
8358: l_person_id_tbl := FND_TABLE_OF_NUMBER();

Line 8542: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8538: , p_action_type => l_action_type
8539: , x_action_id => l_created_action_id
8540: ) ;
8541:
8542: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8543:
8544: x_return_status := l_return_status ;
8545: x_msg_count := l_msg_count ;
8546: x_msg_data := l_msg_data ;

Line 8659: , p_init_msg_list => FND_API.G_FALSE --

8655:
8656:
8657: Eng_Workflow_Util.RevokeObjectRoles
8658: ( p_api_version => 1.0
8659: , p_init_msg_list => FND_API.G_FALSE --
8660: , p_commit => FND_API.G_FALSE --
8661: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8662: , p_debug => FND_API.G_FALSE
8663: , p_output_dir => NULL

Line 8660: , p_commit => FND_API.G_FALSE --

8656:
8657: Eng_Workflow_Util.RevokeObjectRoles
8658: ( p_api_version => 1.0
8659: , p_init_msg_list => FND_API.G_FALSE --
8660: , p_commit => FND_API.G_FALSE --
8661: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8662: , p_debug => FND_API.G_FALSE
8663: , p_output_dir => NULL
8664: , p_debug_filename => NULL

Line 8661: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

8657: Eng_Workflow_Util.RevokeObjectRoles
8658: ( p_api_version => 1.0
8659: , p_init_msg_list => FND_API.G_FALSE --
8660: , p_commit => FND_API.G_FALSE --
8661: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8662: , p_debug => FND_API.G_FALSE
8663: , p_output_dir => NULL
8664: , p_debug_filename => NULL
8665: , x_return_status => l_return_status

Line 8662: , p_debug => FND_API.G_FALSE

8658: ( p_api_version => 1.0
8659: , p_init_msg_list => FND_API.G_FALSE --
8660: , p_commit => FND_API.G_FALSE --
8661: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8662: , p_debug => FND_API.G_FALSE
8663: , p_output_dir => NULL
8664: , p_debug_filename => NULL
8665: , x_return_status => l_return_status
8666: , x_msg_count => l_msg_count

Line 8683: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

8679: Write_Debug('After Eng_Workflow_Util.RevokeObjectRoles.' || l_return_status );
8680: END IF ;
8681:
8682: --
8683: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
8684: -- THEN
8685: -- RAISE FND_API.G_EXC_ERROR ;
8686: -- END IF ;
8687:

Line 8685: -- RAISE FND_API.G_EXC_ERROR ;

8681:
8682: --
8683: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
8684: -- THEN
8685: -- RAISE FND_API.G_EXC_ERROR ;
8686: -- END IF ;
8687:
8688: END IF ; -- ( l_auto_revoke_resp IS NOT NULL AND p_response_code = l_auto_revoke_resp )
8689:

Line 8701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8697: IF g_debug_flag THEN
8698: Write_Debug('Eng_Workflow_Util.SetRouteResponse Unxexpected Error.' || SQLERRM);
8699: END IF ;
8700:
8701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8702:
8703: IF FND_MSG_PUB.Check_Msg_Level
8704: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8705: THEN

Line 8750: x_return_status := FND_API.G_RET_STS_SUCCESS;

8746:
8747: BEGIN
8748:
8749: -- Initialize API return status to success
8750: x_return_status := FND_API.G_RET_STS_SUCCESS;
8751:
8752:
8753: OPEN c_next_step(p_route_id => p_route_id) ;
8754: FETCH c_next_step into recinfo;

Line 8774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8770:
8771: EXCEPTION
8772: WHEN OTHERS THEN
8773:
8774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8775:
8776: IF FND_MSG_PUB.Check_Msg_Level
8777: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8778: THEN

Line 8823: l_debug VARCHAR2(1) := FND_API.G_FALSE ;

8819: -- l_change_notice VARCHAR2(10) ;
8820: -- l_organization_id NUMBER ;
8821: -- l_wf_user_id NUMBER ;
8822: -- l_host_url VARCHAR2(256) ;
8823: l_debug VARCHAR2(1) := FND_API.G_FALSE ;
8824: l_output_dir VARCHAR2(240) := NULL ;
8825: l_debug_filename VARCHAR2(200) := 'StartNextRouteStep.log' ;
8826:
8827:

Line 8842: x_return_status := FND_API.G_RET_STS_SUCCESS;

8838: Write_Debug('-----------------------------------------------------');
8839: END IF ;
8840:
8841: -- Initialize API return status to success
8842: x_return_status := FND_API.G_RET_STS_SUCCESS;
8843:
8844: --
8845: -- Don't try to get Parent Item Attributes from this procedure
8846: -- because this proc is setting PRAGMA AUTONOMOUS_TRANSACTION

Line 8875: , p_init_msg_list => FND_API.G_FALSE

8871:
8872: -- FND_MSG_PUB.initialize ;
8873: Eng_Workflow_Util.StartWorkflow
8874: ( p_api_version => 1.0
8875: , p_init_msg_list => FND_API.G_FALSE
8876: , p_commit => FND_API.G_FALSE
8877: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8878: , x_return_status => x_return_status
8879: , x_msg_count => x_msg_count

Line 8876: , p_commit => FND_API.G_FALSE

8872: -- FND_MSG_PUB.initialize ;
8873: Eng_Workflow_Util.StartWorkflow
8874: ( p_api_version => 1.0
8875: , p_init_msg_list => FND_API.G_FALSE
8876: , p_commit => FND_API.G_FALSE
8877: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8878: , x_return_status => x_return_status
8879: , x_msg_count => x_msg_count
8880: , x_msg_data => x_msg_data

Line 8877: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

8873: Eng_Workflow_Util.StartWorkflow
8874: ( p_api_version => 1.0
8875: , p_init_msg_list => FND_API.G_FALSE
8876: , p_commit => FND_API.G_FALSE
8877: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8878: , x_return_status => x_return_status
8879: , x_msg_count => x_msg_count
8880: , x_msg_data => x_msg_data
8881: , p_item_type => x_step_item_type

Line 8898: IF x_return_status = FND_API.G_RET_STS_SUCCESS

8894: , p_output_dir => l_output_dir
8895: , p_debug_filename => l_debug_filename
8896: ) ;
8897:
8898: IF x_return_status = FND_API.G_RET_STS_SUCCESS
8899: THEN
8900:
8901: -- COMMENT OUT PRAGMA AUTONOMOUS_TRANSACTION
8902: -- COMMIT ;

Line 8909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

8905: ELSE
8906:
8907: -- COMMENT OUT PRAGMA AUTONOMOUS_TRANSACTION
8908: -- ROLLBACK ;
8909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
8910:
8911: END IF ;
8912:
8913: IF g_debug_flag THEN

Line 8929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8925: WHEN OTHERS THEN
8926:
8927: -- ROLLBACK ;
8928:
8929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8930:
8931: IF FND_MSG_PUB.Check_Msg_Level
8932: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8933: THEN

Line 8958: l_debug VARCHAR2(1) := FND_API.G_FALSE ;

8954: l_msg_count NUMBER ;
8955: l_msg_data VARCHAR2(2000) ;
8956: l_return_status VARCHAR2(1) ;
8957:
8958: l_debug VARCHAR2(1) := FND_API.G_FALSE ;
8959: l_output_dir VARCHAR2(240) := NULL ;
8960: l_debug_filename VARCHAR2(200) := 'AbortRouteSteps.log' ;
8961:
8962:

Line 8989: x_return_status := FND_API.G_RET_STS_SUCCESS;

8985: Write_Debug('-----------------------------------------------------');
8986: END IF ;
8987:
8988: -- Initialize API return status to success
8989: x_return_status := FND_API.G_RET_STS_SUCCESS;
8990:
8991: FOR abort_step_rec IN c_abort_step ( p_route_item_type => p_route_item_type
8992: , p_route_item_key => p_route_item_key )
8993: LOOP

Line 9005: , p_init_msg_list => FND_API.G_FALSE

9001:
9002:
9003: Eng_Workflow_Util.AbortWorkflow
9004: ( p_api_version => 1.0
9005: , p_init_msg_list => FND_API.G_FALSE
9006: , p_commit => FND_API.G_FALSE
9007: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9008: , x_return_status => l_return_status
9009: , x_msg_count => l_msg_count

Line 9006: , p_commit => FND_API.G_FALSE

9002:
9003: Eng_Workflow_Util.AbortWorkflow
9004: ( p_api_version => 1.0
9005: , p_init_msg_list => FND_API.G_FALSE
9006: , p_commit => FND_API.G_FALSE
9007: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9008: , x_return_status => l_return_status
9009: , x_msg_count => l_msg_count
9010: , x_msg_data => l_msg_data

Line 9007: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

9003: Eng_Workflow_Util.AbortWorkflow
9004: ( p_api_version => 1.0
9005: , p_init_msg_list => FND_API.G_FALSE
9006: , p_commit => FND_API.G_FALSE
9007: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9008: , x_return_status => l_return_status
9009: , x_msg_count => l_msg_count
9010: , x_msg_data => l_msg_data
9011: , p_item_type => abort_step_rec.wf_item_type

Line 9021: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

9017: , p_debug_filename => l_debug_filename
9018: ) ;
9019:
9020:
9021: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
9022: THEN
9023:
9024: x_return_status := l_return_status ;
9025: x_msg_count := NVL(l_msg_count, 0) + NVL(l_msg_count,0) ;

Line 9042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9038:
9039: EXCEPTION
9040: WHEN OTHERS THEN
9041:
9042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9043:
9044: IF FND_MSG_PUB.Check_Msg_Level
9045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9046: THEN

Line 9078: x_return_status := FND_API.G_RET_STS_SUCCESS;

9074:
9075: BEGIN
9076:
9077: -- Initialize API return status to success
9078: x_return_status := FND_API.G_RET_STS_SUCCESS;
9079:
9080:
9081:
9082: EGO_SECURITY_PUB.grant_role_guid

Line 9106: IF ( l_return_status = FND_API.G_TRUE OR

9102: --
9103: -- EGO Security pub returns T if the action is success
9104: -- and F on failure
9105: --
9106: IF ( l_return_status = FND_API.G_TRUE OR
9107: l_return_status = FND_API.G_FALSE )
9108: THEN
9109:
9110: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9107: l_return_status = FND_API.G_FALSE )

9103: -- EGO Security pub returns T if the action is success
9104: -- and F on failure
9105: --
9106: IF ( l_return_status = FND_API.G_TRUE OR
9107: l_return_status = FND_API.G_FALSE )
9108: THEN
9109:
9110: x_return_status := FND_API.G_RET_STS_SUCCESS;
9111:

Line 9110: x_return_status := FND_API.G_RET_STS_SUCCESS;

9106: IF ( l_return_status = FND_API.G_TRUE OR
9107: l_return_status = FND_API.G_FALSE )
9108: THEN
9109:
9110: x_return_status := FND_API.G_RET_STS_SUCCESS;
9111:
9112: ELSE
9113:
9114: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 9114: x_return_status := FND_API.G_RET_STS_ERROR ;

9110: x_return_status := FND_API.G_RET_STS_SUCCESS;
9111:
9112: ELSE
9113:
9114: x_return_status := FND_API.G_RET_STS_ERROR ;
9115:
9116: END IF ;
9117:
9118:

Line 9122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9118:
9119: EXCEPTION
9120: WHEN OTHERS THEN
9121:
9122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9123:
9124: IF FND_MSG_PUB.Check_Msg_Level
9125: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9126: THEN

Line 9155: l_debug VARCHAR2(1) := FND_API.G_FALSE ;

9151: l_return_status VARCHAR2(1) ;
9152: l_line_item_key VARCHAR2(240) ;
9153: l_change_id NUMBER ;
9154:
9155: l_debug VARCHAR2(1) := FND_API.G_FALSE ;
9156: l_output_dir VARCHAR2(240) := '' ;
9157: l_debug_filename VARCHAR2(200) := 'StartLineRoutes.log' ;
9158:
9159:

Line 9222: , p_init_msg_list => FND_API.G_FALSE

9218: -- Start Change Line Workflows
9219: -- FND_MSG_PUB.initialize ;
9220: Eng_Workflow_Util.StartWorkflow
9221: ( p_api_version => 1.0
9222: , p_init_msg_list => FND_API.G_FALSE
9223: , p_commit => FND_API.G_FALSE
9224: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9225: , x_return_status => l_return_status
9226: , x_msg_count => x_msg_count

Line 9223: , p_commit => FND_API.G_FALSE

9219: -- FND_MSG_PUB.initialize ;
9220: Eng_Workflow_Util.StartWorkflow
9221: ( p_api_version => 1.0
9222: , p_init_msg_list => FND_API.G_FALSE
9223: , p_commit => FND_API.G_FALSE
9224: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9225: , x_return_status => l_return_status
9226: , x_msg_count => x_msg_count
9227: , x_msg_data => x_msg_data

Line 9224: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

9220: Eng_Workflow_Util.StartWorkflow
9221: ( p_api_version => 1.0
9222: , p_init_msg_list => FND_API.G_FALSE
9223: , p_commit => FND_API.G_FALSE
9224: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
9225: , x_return_status => l_return_status
9226: , x_msg_count => x_msg_count
9227: , x_msg_data => x_msg_data
9228: , p_item_type => line_rec.wf_item_type

Line 9241: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

9237: , p_output_dir => l_output_dir
9238: , p_debug_filename => l_debug_filename || TO_CHAR(line_rec.change_line_id)
9239: ) ;
9240:
9241: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
9242: THEN
9243:
9244: x_return_status := l_return_status ;
9245:

Line 9263: IF x_return_status = FND_API.G_RET_STS_SUCCESS

9259: END LOOP ;
9260:
9261:
9262:
9263: IF x_return_status = FND_API.G_RET_STS_SUCCESS
9264: OR x_return_status = Eng_Workflow_Util.G_RET_STS_NONE
9265: THEN
9266:
9267: COMMIT ;

Line 9272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

9268:
9269: ELSE
9270:
9271: ROLLBACK ;
9272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9273:
9274: END IF ;
9275:
9276:

Line 9282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9278: WHEN OTHERS THEN
9279:
9280: ROLLBACK ;
9281:
9282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9283:
9284: IF FND_MSG_PUB.Check_Msg_Level
9285: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9286: THEN

Line 9332: x_return_status := FND_API.G_RET_STS_SUCCESS;

9328:
9329: BEGIN
9330:
9331: -- Initialize API return status to success
9332: x_return_status := FND_API.G_RET_STS_SUCCESS;
9333:
9334: x_line_approval_status := Eng_Workflow_Util.G_APPROVED ;
9335:
9336: FOR l_approved_line_rec IN c_approved_line (p_change_id )

Line 9347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9343:
9344: EXCEPTION
9345: WHEN OTHERS THEN
9346:
9347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9348:
9349: IF FND_MSG_PUB.Check_Msg_Level
9350: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9351: THEN

Line 9480: x_return_status := FND_API.G_RET_STS_SUCCESS;

9476:
9477: BEGIN
9478:
9479: -- Initialize API return status to success
9480: x_return_status := FND_API.G_RET_STS_SUCCESS;
9481:
9482:
9483: -- Get Step Activity Attributes
9484: GetStepActAttributes

Line 9515: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

9511: , p_end_date => NULL
9512: ) ;
9513:
9514:
9515: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
9516: THEN
9517:
9518: x_return_status := l_return_status ;
9519: x_msg_count := NVL(l_msg_count, 0) + NVL(l_msg_count,0) ;

Line 9532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9528:
9529: EXCEPTION
9530: WHEN OTHERS THEN
9531:
9532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9533:
9534: IF FND_MSG_PUB.Check_Msg_Level
9535: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9536: THEN

Line 10473: l_debug VARCHAR2(1) := FND_API.G_FALSE ;

10469: AND ecr.route_id = eec.route_id
10470: AND eec.change_id = p_change_id ;
10471:
10472:
10473: l_debug VARCHAR2(1) := FND_API.G_FALSE ;
10474: l_output_dir VARCHAR2(240) := NULL ;
10475: l_debug_filename VARCHAR2(200) := 'ContinueHeaderRoute.log' ;
10476:
10477:

Line 10495: x_return_status := FND_API.G_RET_STS_SUCCESS;

10491: Write_Debug('-----------------------------------------------------');
10492: END IF ;
10493:
10494: -- Initialize API return status to success
10495: x_return_status := FND_API.G_RET_STS_SUCCESS;
10496:
10497:
10498: if (p_waiting_flow_type = 'APPROVAL') then
10499:

Line 10628: x_return_status := FND_API.G_RET_STS_SUCCESS;

10624: BEGIN
10625:
10626:
10627: -- Initialize API return status to success
10628: x_return_status := FND_API.G_RET_STS_SUCCESS;
10629:
10630:
10631: if (p_continuation_flow_type = 'APPROVAL') then
10632:

Line 10743: , p_init_msg_list => FND_API.G_FALSE

10739:
10740: -- create and start Response FYI process to send Resp FYI ntf
10741: Eng_Workflow_Util.StartWorkflow
10742: ( p_api_version => 1.0
10743: , p_init_msg_list => FND_API.G_FALSE
10744: , p_commit => FND_API.G_FALSE
10745: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10746: , x_return_status => x_return_status
10747: , x_msg_count => x_msg_count

Line 10744: , p_commit => FND_API.G_FALSE

10740: -- create and start Response FYI process to send Resp FYI ntf
10741: Eng_Workflow_Util.StartWorkflow
10742: ( p_api_version => 1.0
10743: , p_init_msg_list => FND_API.G_FALSE
10744: , p_commit => FND_API.G_FALSE
10745: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10746: , x_return_status => x_return_status
10747: , x_msg_count => x_msg_count
10748: , x_msg_data => x_msg_data

Line 10745: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

10741: Eng_Workflow_Util.StartWorkflow
10742: ( p_api_version => 1.0
10743: , p_init_msg_list => FND_API.G_FALSE
10744: , p_commit => FND_API.G_FALSE
10745: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10746: , x_return_status => x_return_status
10747: , x_msg_count => x_msg_count
10748: , x_msg_data => x_msg_data
10749: , p_item_type => G_CHANGE_ACTION_ITEM_TYPE

Line 10762: , p_debug => FND_API.G_FALSE

10758: , p_route_id => 0
10759: , p_route_step_id => 0
10760: , p_parent_item_type => p_itemtype
10761: , p_parent_item_key => p_itemkey
10762: , p_debug => FND_API.G_FALSE
10763: , p_output_dir => NULL
10764: , p_debug_filename => 'Eng_ChangeWF_Start.log'
10765: ) ;
10766:

Line 10791: l_debug VARCHAR2(1) := FND_API.G_FALSE ;

10787: PRAGMA AUTONOMOUS_TRANSACTION;
10788:
10789: l_api_name CONSTANT VARCHAR2(30) := 'StartValidateDefProcess';
10790:
10791: l_debug VARCHAR2(1) := FND_API.G_FALSE ;
10792: l_output_dir VARCHAR2(240) := NULL ;
10793: l_debug_filename VARCHAR2(200) := 'StartValidateDefProcess.log' ;
10794:
10795: l_resp_user_id NUMBER ;

Line 10826: x_return_status := FND_API.G_RET_STS_SUCCESS ;

10822: WHERE UserV.user_id = p_user_id ;
10823:
10824: BEGIN
10825:
10826: x_return_status := FND_API.G_RET_STS_SUCCESS ;
10827:
10828:
10829: IF g_debug_flag THEN
10830: Write_Debug('Eng_Workflow_Util.StartValidateDefProcess Log');

Line 10846: l_return_status := FND_API.G_RET_STS_SUCCESS ;

10842: l_resp_user_id := ntf_info_rec.user_id ;
10843: END LOOP ;
10844:
10845: BEGIN
10846: l_return_status := FND_API.G_RET_STS_SUCCESS ;
10847:
10848: -- FND_MSG_PUB.initialize ;
10849: Eng_Workflow_Util.StartWorkflow
10850: ( p_api_version => 1.0

Line 10851: , p_init_msg_list => FND_API.G_FALSE

10847:
10848: -- FND_MSG_PUB.initialize ;
10849: Eng_Workflow_Util.StartWorkflow
10850: ( p_api_version => 1.0
10851: , p_init_msg_list => FND_API.G_FALSE
10852: , p_commit => FND_API.G_FALSE
10853: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10854: , x_return_status => l_return_status
10855: , x_msg_count => l_msg_count

Line 10852: , p_commit => FND_API.G_FALSE

10848: -- FND_MSG_PUB.initialize ;
10849: Eng_Workflow_Util.StartWorkflow
10850: ( p_api_version => 1.0
10851: , p_init_msg_list => FND_API.G_FALSE
10852: , p_commit => FND_API.G_FALSE
10853: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10854: , x_return_status => l_return_status
10855: , x_msg_count => l_msg_count
10856: , x_msg_data => l_msg_data

Line 10853: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

10849: Eng_Workflow_Util.StartWorkflow
10850: ( p_api_version => 1.0
10851: , p_init_msg_list => FND_API.G_FALSE
10852: , p_commit => FND_API.G_FALSE
10853: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
10854: , x_return_status => l_return_status
10855: , x_msg_count => l_msg_count
10856: , x_msg_data => l_msg_data
10857: , p_item_type => p_val_def_item_type

Line 10883: IF l_return_status = FND_API.G_RET_STS_SUCCESS

10879: Write_Debug('Started Val Def WF Process Name: ' || p_val_def_process_name ) ;
10880: END IF ;
10881:
10882:
10883: IF l_return_status = FND_API.G_RET_STS_SUCCESS
10884: THEN
10885:
10886: COMMIT ;
10887:

Line 10907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

10903:
10904: EXCEPTION
10905: WHEN OTHERS THEN
10906:
10907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10908:
10909: IF FND_MSG_PUB.Check_Msg_Level
10910: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10911: THEN

Line 11154: x_return_status := FND_API.G_RET_STS_SUCCESS;

11150:
11151: BEGIN
11152:
11153: -- Initialize API return status to success
11154: x_return_status := FND_API.G_RET_STS_SUCCESS;
11155:
11156: IF g_debug_flag THEN
11157: Write_Debug('Eng_Workflow_Util.RespondToActReqCommentFromUI Log');
11158: Write_Debug('-----------------------------------------------------');

Line 11223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

11219:
11220: EXCEPTION
11221: WHEN OTHERS THEN
11222:
11223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11224:
11225: IF FND_MSG_PUB.Check_Msg_Level
11226: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11227: THEN

Line 11275: x_return_status := FND_API.G_RET_STS_SUCCESS;

11271: BEGIN
11272:
11273:
11274: -- Initialize API return status to success
11275: x_return_status := FND_API.G_RET_STS_SUCCESS;
11276:
11277: IF g_debug_flag THEN
11278: Write_Debug('Eng_Workflow_Util.SetChangeOrderMRPFlag Log');
11279: Write_Debug('-----------------------------------------------------');

Line 11333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

11329:
11330: EXCEPTION
11331: WHEN OTHERS THEN
11332:
11333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11334:
11335: IF FND_MSG_PUB.Check_Msg_Level
11336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11337: THEN

Line 11354: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

11350: * Purpose : Those APIs are public
11351: *********************************************************************/
11352: PROCEDURE GetWorkflowMonitorURL
11353: ( p_api_version IN NUMBER
11354: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11355: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11356: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11357: , x_return_status OUT NOCOPY VARCHAR2
11358: , x_msg_count OUT NOCOPY NUMBER

Line 11355: , p_commit IN VARCHAR2 := FND_API.G_FALSE

11351: *********************************************************************/
11352: PROCEDURE GetWorkflowMonitorURL
11353: ( p_api_version IN NUMBER
11354: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11355: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11356: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11357: , x_return_status OUT NOCOPY VARCHAR2
11358: , x_msg_count OUT NOCOPY NUMBER
11359: , x_msg_data OUT NOCOPY VARCHAR2

Line 11356: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

11352: PROCEDURE GetWorkflowMonitorURL
11353: ( p_api_version IN NUMBER
11354: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11355: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11356: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11357: , x_return_status OUT NOCOPY VARCHAR2
11358: , x_msg_count OUT NOCOPY NUMBER
11359: , x_msg_data OUT NOCOPY VARCHAR2
11360: , p_item_type IN VARCHAR2

Line 11363: , p_admin_mode IN VARCHAR2 := FND_API.G_FALSE

11359: , x_msg_data OUT NOCOPY VARCHAR2
11360: , p_item_type IN VARCHAR2
11361: , p_item_key IN VARCHAR2
11362: , p_url_type IN VARCHAR2 := Eng_Workflow_Util.G_MONITOR_DIAGRAM
11363: , p_admin_mode IN VARCHAR2 := FND_API.G_FALSE
11364: , p_option IN VARCHAR2 := NULL
11365: , x_url OUT NOCOPY VARCHAR2
11366: )
11367: IS

Line 11383: IF NOT FND_API.Compatible_API_Call( l_api_version

11379: -- No Need to set SAVEPOINT for this API
11380: -- SAVEPOINT GetWorkflowMonitorURL_Util ;
11381:
11382: -- Standard call to check for call compatibility.
11383: IF NOT FND_API.Compatible_API_Call( l_api_version
11384: , p_api_version
11385: , l_api_name
11386: , G_PKG_NAME )
11387: THEN

Line 11388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11384: , p_api_version
11385: , l_api_name
11386: , G_PKG_NAME )
11387: THEN
11388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11389: END IF;
11390:
11391:
11392: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 11393: IF FND_API.to_Boolean( p_init_msg_list ) THEN

11389: END IF;
11390:
11391:
11392: -- Initialize message list if p_init_msg_list is set to TRUE.
11393: IF FND_API.to_Boolean( p_init_msg_list ) THEN
11394: FND_MSG_PUB.initialize;
11395: END IF ;
11396:
11397: -- Initialize API return status to success

Line 11398: x_return_status := FND_API.G_RET_STS_SUCCESS;

11394: FND_MSG_PUB.initialize;
11395: END IF ;
11396:
11397: -- Initialize API return status to success
11398: x_return_status := FND_API.G_RET_STS_SUCCESS;
11399:
11400:
11401: -- API body
11402:

Line 11404: IF FND_API.to_Boolean( p_admin_mode ) THEN

11400:
11401: -- API body
11402:
11403: -- Get Admin Mode.
11404: IF FND_API.to_Boolean( p_admin_mode ) THEN
11405: l_admin_mode := l_YES ;
11406: ELSE
11407: l_admin_mode := l_NO ;
11408: END IF ;

Line 11458: -- IF FND_API.To_Boolean( p_commit ) THEN

11454: END IF ;
11455:
11456:
11457: -- Standard check of p_commit.
11458: -- IF FND_API.To_Boolean( p_commit ) THEN
11459: -- COMMIT WORK;
11460: -- END IF;
11461:
11462: -- Standard call to get message count and if count is 1, get message info.

Line 11469: WHEN FND_API.G_EXC_ERROR THEN

11465: , p_data => x_msg_data
11466: );
11467:
11468: EXCEPTION
11469: WHEN FND_API.G_EXC_ERROR THEN
11470: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11471: x_return_status := FND_API.G_RET_STS_ERROR ;
11472:
11473: FND_MSG_PUB.Count_And_Get

Line 11471: x_return_status := FND_API.G_RET_STS_ERROR ;

11467:
11468: EXCEPTION
11469: WHEN FND_API.G_EXC_ERROR THEN
11470: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11471: x_return_status := FND_API.G_RET_STS_ERROR ;
11472:
11473: FND_MSG_PUB.Count_And_Get
11474: ( p_count => x_msg_count
11475: , p_data => x_msg_data

Line 11478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

11474: ( p_count => x_msg_count
11475: , p_data => x_msg_data
11476: );
11477:
11478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11479: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11481:
11482: FND_MSG_PUB.Count_And_Get

Line 11480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

11476: );
11477:
11478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11479: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11481:
11482: FND_MSG_PUB.Count_And_Get
11483: ( p_count => x_msg_count
11484: , p_data => x_msg_data

Line 11489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

11485: );
11486:
11487: WHEN OTHERS THEN
11488: -- ROLLBACK TO GetWorkflowMonitorURL_Util ;
11489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11490:
11491: FND_MSG_PUB.Count_And_Get
11492: ( p_count => x_msg_count
11493: , p_data => x_msg_data

Line 11516: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

11512:
11513:
11514: PROCEDURE StartWorkflow
11515: ( p_api_version IN NUMBER
11516: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11517: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11518: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11519: , x_return_status OUT NOCOPY VARCHAR2
11520: , x_msg_count OUT NOCOPY NUMBER

Line 11517: , p_commit IN VARCHAR2 := FND_API.G_FALSE

11513:
11514: PROCEDURE StartWorkflow
11515: ( p_api_version IN NUMBER
11516: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11517: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11518: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11519: , x_return_status OUT NOCOPY VARCHAR2
11520: , x_msg_count OUT NOCOPY NUMBER
11521: , x_msg_data OUT NOCOPY VARCHAR2

Line 11518: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

11514: PROCEDURE StartWorkflow
11515: ( p_api_version IN NUMBER
11516: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11517: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11518: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11519: , x_return_status OUT NOCOPY VARCHAR2
11520: , x_msg_count OUT NOCOPY NUMBER
11521: , x_msg_data OUT NOCOPY VARCHAR2
11522: , p_item_type IN VARCHAR2

Line 11535: , p_debug IN VARCHAR2 := FND_API.G_FALSE

11531: , p_route_id IN NUMBER := NULL
11532: , p_route_step_id IN NUMBER := NULL
11533: , p_parent_item_type IN VARCHAR2 := NULL
11534: , p_parent_item_key IN VARCHAR2 := NULL
11535: , p_debug IN VARCHAR2 := FND_API.G_FALSE
11536: , p_output_dir IN VARCHAR2 := NULL
11537: , p_debug_filename IN VARCHAR2 := 'Eng_ChangeWF_Start.log'
11538: )
11539: IS

Line 11610: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

11606:
11607:
11608: PROCEDURE StartWorkflow
11609: ( p_api_version IN NUMBER
11610: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11611: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11612: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11613: , x_return_status OUT NOCOPY VARCHAR2
11614: , x_msg_count OUT NOCOPY NUMBER

Line 11611: , p_commit IN VARCHAR2 := FND_API.G_FALSE

11607:
11608: PROCEDURE StartWorkflow
11609: ( p_api_version IN NUMBER
11610: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11611: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11612: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11613: , x_return_status OUT NOCOPY VARCHAR2
11614: , x_msg_count OUT NOCOPY NUMBER
11615: , x_msg_data OUT NOCOPY VARCHAR2

Line 11612: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

11608: PROCEDURE StartWorkflow
11609: ( p_api_version IN NUMBER
11610: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
11611: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11612: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
11613: , x_return_status OUT NOCOPY VARCHAR2
11614: , x_msg_count OUT NOCOPY NUMBER
11615: , x_msg_data OUT NOCOPY VARCHAR2
11616: , p_item_type IN VARCHAR2

Line 11635: , p_debug IN VARCHAR2 := FND_API.G_FALSE

11631: , p_route_id IN NUMBER := NULL
11632: , p_route_step_id IN NUMBER := NULL
11633: , p_parent_item_type IN VARCHAR2 := NULL
11634: , p_parent_item_key IN VARCHAR2 := NULL
11635: , p_debug IN VARCHAR2 := FND_API.G_FALSE
11636: , p_output_dir IN VARCHAR2 := NULL
11637: , p_debug_filename IN VARCHAR2 := 'Eng_ChangeWF_Start.log'
11638: )
11639: IS

Line 11670: IF NOT FND_API.Compatible_API_Call( l_api_version

11666: -- Standard Start of API savepoint
11667: SAVEPOINT StartWorkflow_Util;
11668:
11669: -- Standard call to check for call compatibility.
11670: IF NOT FND_API.Compatible_API_Call( l_api_version
11671: , p_api_version
11672: , l_api_name
11673: , G_PKG_NAME )
11674: THEN

Line 11675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11671: , p_api_version
11672: , l_api_name
11673: , G_PKG_NAME )
11674: THEN
11675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11676: END IF;
11677:
11678: -- Initialize message list if p_init_msg_list is set to TRUE.
11679: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 11679: IF FND_API.to_Boolean( p_init_msg_list ) THEN

11675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11676: END IF;
11677:
11678: -- Initialize message list if p_init_msg_list is set to TRUE.
11679: IF FND_API.to_Boolean( p_init_msg_list ) THEN
11680: FND_MSG_PUB.initialize;
11681: END IF ;
11682:
11683:

Line 11688: -- IF FND_API.to_Boolean( p_debug ) THEN

11684:
11685: -- For Test/Debug
11686: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
11687: -- R12 Comment out
11688: -- IF FND_API.to_Boolean( p_debug ) THEN
11689: -- Open_Debug_Session(p_output_dir, p_debug_filename ) ;
11690: -- END IF;
11691:
11692: -- Initialize Other Variables

Line 11733: x_return_status := FND_API.G_RET_STS_SUCCESS;

11729: Write_Debug('Initialize return status ' );
11730: END IF ;
11731:
11732: -- Initialize API return status to success
11733: x_return_status := FND_API.G_RET_STS_SUCCESS;
11734:
11735: -----------------------------------------------------------------
11736: -- API body
11737: -----------------------------------------------------------------

Line 11782: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

11778: , p_parent_object_id1 => p_parent_object_id1
11779: ) ;
11780:
11781:
11782: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
11783: THEN
11784: RAISE FND_API.G_EXC_ERROR ;
11785: END IF ;
11786:

Line 11784: RAISE FND_API.G_EXC_ERROR ;

11780:
11781:
11782: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
11783: THEN
11784: RAISE FND_API.G_EXC_ERROR ;
11785: END IF ;
11786:
11787:
11788: --

Line 11823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

11819: Write_Debug('CM Workflows except Doc Phse WF Routing are not supported in Document LC ChangeObject. Raise Error. .. ');
11820: END IF ;
11821: -- At this time, not raising any error
11822:
11823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
11824: END IF ;
11825:
11826:
11827: END IF ;

Line 11952: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

11948: Write_Debug('Change Id : ' || to_char(l_change_id));
11949: END IF ;
11950:
11951:
11952: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
11953: THEN
11954: RAISE FND_API.G_EXC_ERROR ;
11955: END IF ;
11956:

Line 11954: RAISE FND_API.G_EXC_ERROR ;

11950:
11951:
11952: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
11953: THEN
11954: RAISE FND_API.G_EXC_ERROR ;
11955: END IF ;
11956:
11957: IF g_debug_flag THEN
11958: Write_Debug('4. SetItemParent. . .');

Line 11996: , p_init_route => FND_API.G_TRUE

11992: , p_item_key => x_item_key
11993: , p_wf_user_id => p_wf_user_id
11994: , p_route_id => p_route_id
11995: , p_new_status_code => Eng_Workflow_Util.G_RT_IN_PROGRESS
11996: , p_init_route => FND_API.G_TRUE
11997: , p_change_id => l_change_id
11998: , p_change_line_id => l_change_line_id -- Added in R12B
11999: ) ;
12000:

Line 12032: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12028: -- IF g_debug_flag THEN
12029: -- Write_Debug('After Set Approval Status .' || x_return_status );
12030: -- END IF ;
12031:
12032: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12033: -- THEN
12034: -- RAISE FND_API.G_EXC_ERROR ;
12035: -- END IF ;
12036: --

Line 12034: -- RAISE FND_API.G_EXC_ERROR ;

12030: -- END IF ;
12031:
12032: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12033: -- THEN
12034: -- RAISE FND_API.G_EXC_ERROR ;
12035: -- END IF ;
12036: --
12037: ****************************************************/
12038:

Line 12065: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12061: IF g_debug_flag THEN
12062: Write_Debug('After Set Workflow Routing Action Log .' || x_return_status );
12063: END IF ;
12064:
12065: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12066: THEN
12067: RAISE FND_API.G_EXC_ERROR ;
12068: END IF ;
12069:

Line 12067: RAISE FND_API.G_EXC_ERROR ;

12063: END IF ;
12064:
12065: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12066: THEN
12067: RAISE FND_API.G_EXC_ERROR ;
12068: END IF ;
12069:
12070: -- Set Action Id
12071: SetActionId

Line 12102: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12098: Write_Debug('After Sync Workflow Routing Status and LC Phase WF Status.' || x_return_status );
12099: END IF ;
12100:
12101:
12102: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12103: THEN
12104: RAISE FND_API.G_EXC_ERROR ;
12105: END IF ;
12106:

Line 12104: RAISE FND_API.G_EXC_ERROR ;

12100:
12101:
12102: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12103: THEN
12104: RAISE FND_API.G_EXC_ERROR ;
12105: END IF ;
12106:
12107: END IF ;
12108:

Line 12141: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12137: IF g_debug_flag THEN
12138: Write_Debug('After Set Line Workflow Routing Action Log .' || x_return_status );
12139: END IF ;
12140:
12141: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12142: THEN
12143: RAISE FND_API.G_EXC_ERROR ;
12144: END IF ;
12145:

Line 12143: RAISE FND_API.G_EXC_ERROR ;

12139: END IF ;
12140:
12141: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12142: THEN
12143: RAISE FND_API.G_EXC_ERROR ;
12144: END IF ;
12145:
12146: -- Set Action Id
12147: SetActionId

Line 12180: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12176: --IF g_debug_flag THEN
12177: -- Write_Debug('After Set Parenet Child for Route Worklfow.' || x_return_status );
12178: --END IF ;
12179:
12180: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12181: -- THEN
12182: -- RAISE FND_API.G_EXC_ERROR ;
12183: -- END IF ;
12184: --

Line 12182: -- RAISE FND_API.G_EXC_ERROR ;

12178: --END IF ;
12179:
12180: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12181: -- THEN
12182: -- RAISE FND_API.G_EXC_ERROR ;
12183: -- END IF ;
12184: --
12185: ***********************************************/
12186:

Line 12251: , p_init_msg_list => FND_API.G_FALSE --

12247:
12248:
12249: Eng_Workflow_Util.GrantObjectRoles
12250: ( p_api_version => 1.0
12251: , p_init_msg_list => FND_API.G_FALSE --
12252: , p_commit => FND_API.G_FALSE --
12253: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12254: , p_debug => p_debug
12255: , p_output_dir => p_output_dir

Line 12252: , p_commit => FND_API.G_FALSE --

12248:
12249: Eng_Workflow_Util.GrantObjectRoles
12250: ( p_api_version => 1.0
12251: , p_init_msg_list => FND_API.G_FALSE --
12252: , p_commit => FND_API.G_FALSE --
12253: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12254: , p_debug => p_debug
12255: , p_output_dir => p_output_dir
12256: , p_debug_filename => p_debug_filename

Line 12253: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

12249: Eng_Workflow_Util.GrantObjectRoles
12250: ( p_api_version => 1.0
12251: , p_init_msg_list => FND_API.G_FALSE --
12252: , p_commit => FND_API.G_FALSE --
12253: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12254: , p_debug => p_debug
12255: , p_output_dir => p_output_dir
12256: , p_debug_filename => p_debug_filename
12257: , x_return_status => l_return_status

Line 12276: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

12272: Write_Debug('After Eng_Workflow_Util.GrantObjectRoles: ' || l_return_status );
12273: END IF ;
12274:
12275: --
12276: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12277: -- THEN
12278: -- RAISE FND_API.G_EXC_ERROR ;
12279: -- END IF ;
12280: --

Line 12278: -- RAISE FND_API.G_EXC_ERROR ;

12274:
12275: --
12276: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12277: -- THEN
12278: -- RAISE FND_API.G_EXC_ERROR ;
12279: -- END IF ;
12280: --
12281:
12282: END IF ;

Line 12326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12322: Write_Debug('Return Status: ' || x_return_status );
12323: END IF ;
12324:
12325:
12326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12327: THEN
12328: RAISE FND_API.G_EXC_ERROR ;
12329: END IF ;
12330:

Line 12328: RAISE FND_API.G_EXC_ERROR ;

12324:
12325:
12326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12327: THEN
12328: RAISE FND_API.G_EXC_ERROR ;
12329: END IF ;
12330:
12331: IF g_debug_flag THEN
12332: Write_Debug('6. StartProcess. . .');

Line 12360: IF FND_API.To_Boolean( p_commit ) THEN

12356: END IF ;
12357:
12358:
12359: -- Standard check of p_commit.
12360: IF FND_API.To_Boolean( p_commit ) THEN
12361:
12362: IF g_debug_flag THEN
12363: Write_Debug('Do Commit.') ;
12364: END IF ;

Line 12382: WHEN FND_API.G_EXC_ERROR THEN

12378: END IF ;
12379:
12380:
12381: EXCEPTION
12382: WHEN FND_API.G_EXC_ERROR THEN
12383: -- Standard check of p_commit.
12384: IF FND_API.To_Boolean( p_commit ) THEN
12385: IF g_debug_flag THEN
12386: Write_Debug('Rollback . . .') ;

Line 12384: IF FND_API.To_Boolean( p_commit ) THEN

12380:
12381: EXCEPTION
12382: WHEN FND_API.G_EXC_ERROR THEN
12383: -- Standard check of p_commit.
12384: IF FND_API.To_Boolean( p_commit ) THEN
12385: IF g_debug_flag THEN
12386: Write_Debug('Rollback . . .') ;
12387: END IF ;
12388: ROLLBACK TO StartWorkflow_Util ;

Line 12391: x_return_status := FND_API.G_RET_STS_ERROR ;

12387: END IF ;
12388: ROLLBACK TO StartWorkflow_Util ;
12389: END IF;
12390:
12391: x_return_status := FND_API.G_RET_STS_ERROR ;
12392:
12393: FND_MSG_PUB.Count_And_Get
12394: ( p_count => x_msg_count
12395: , p_data => x_msg_data

Line 12403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

12399: Write_Debug('RollBack and Finish with Error.') ;
12400: Close_Debug_Session ;
12401: END IF ;
12402:
12403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12404: IF FND_API.To_Boolean( p_commit ) THEN
12405: IF g_debug_flag THEN
12406: Write_Debug('Rollback . . .') ;
12407: END IF ;

Line 12404: IF FND_API.To_Boolean( p_commit ) THEN

12400: Close_Debug_Session ;
12401: END IF ;
12402:
12403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12404: IF FND_API.To_Boolean( p_commit ) THEN
12405: IF g_debug_flag THEN
12406: Write_Debug('Rollback . . .') ;
12407: END IF ;
12408: ROLLBACK TO StartWorkflow_Util ;

Line 12411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

12407: END IF ;
12408: ROLLBACK TO StartWorkflow_Util ;
12409: END IF;
12410:
12411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12412:
12413: FND_MSG_PUB.Count_And_Get
12414: ( p_count => x_msg_count
12415: , p_data => x_msg_data

Line 12424: IF FND_API.To_Boolean( p_commit ) THEN

12420: Close_Debug_Session ;
12421: END IF ;
12422:
12423: WHEN OTHERS THEN
12424: IF FND_API.To_Boolean( p_commit ) THEN
12425: IF g_debug_flag THEN
12426: Write_Debug('Rollback . . .') ;
12427: END IF ;
12428: ROLLBACK TO StartWorkflow_Util ;

Line 12431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

12427: END IF ;
12428: ROLLBACK TO StartWorkflow_Util ;
12429: END IF;
12430:
12431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12432:
12433: FND_MSG_PUB.Count_And_Get
12434: ( p_count => x_msg_count
12435: , p_data => x_msg_data

Line 12465: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

12461:
12462:
12463: PROCEDURE AbortWorkflow
12464: ( p_api_version IN NUMBER
12465: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
12466: , p_commit IN VARCHAR2 := FND_API.G_FALSE
12467: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
12468: , x_return_status OUT NOCOPY VARCHAR2
12469: , x_msg_count OUT NOCOPY NUMBER

Line 12466: , p_commit IN VARCHAR2 := FND_API.G_FALSE

12462:
12463: PROCEDURE AbortWorkflow
12464: ( p_api_version IN NUMBER
12465: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
12466: , p_commit IN VARCHAR2 := FND_API.G_FALSE
12467: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
12468: , x_return_status OUT NOCOPY VARCHAR2
12469: , x_msg_count OUT NOCOPY NUMBER
12470: , x_msg_data OUT NOCOPY VARCHAR2

Line 12467: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

12463: PROCEDURE AbortWorkflow
12464: ( p_api_version IN NUMBER
12465: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
12466: , p_commit IN VARCHAR2 := FND_API.G_FALSE
12467: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
12468: , x_return_status OUT NOCOPY VARCHAR2
12469: , x_msg_count OUT NOCOPY NUMBER
12470: , x_msg_data OUT NOCOPY VARCHAR2
12471: , p_item_type IN VARCHAR2

Line 12475: , p_debug IN VARCHAR2 := FND_API.G_FALSE

12471: , p_item_type IN VARCHAR2
12472: , p_item_key IN VARCHAR2
12473: , p_process_name IN VARCHAR2 := NULL
12474: , p_wf_user_id IN NUMBER
12475: , p_debug IN VARCHAR2 := FND_API.G_FALSE
12476: , p_output_dir IN VARCHAR2 := NULL
12477: , p_debug_filename IN VARCHAR2 := 'Eng_ChangeWF_Abort.log'
12478: )
12479: IS

Line 12516: IF NOT FND_API.Compatible_API_Call( l_api_version

12512: -- Standard Start of API savepoint
12513: SAVEPOINT AbortWorkflow_Util;
12514:
12515: -- Standard call to check for call compatibility.
12516: IF NOT FND_API.Compatible_API_Call( l_api_version
12517: , p_api_version
12518: , l_api_name
12519: , G_PKG_NAME )
12520: THEN

Line 12521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

12517: , p_api_version
12518: , l_api_name
12519: , G_PKG_NAME )
12520: THEN
12521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12522: END IF;
12523:
12524: -- Initialize message list if p_init_msg_list is set to TRUE.
12525: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 12525: IF FND_API.to_Boolean( p_init_msg_list ) THEN

12521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12522: END IF;
12523:
12524: -- Initialize message list if p_init_msg_list is set to TRUE.
12525: IF FND_API.to_Boolean( p_init_msg_list ) THEN
12526: FND_MSG_PUB.initialize;
12527: END IF ;
12528:
12529:

Line 12533: -- IF FND_API.to_Boolean( p_debug ) THEN

12529:
12530: -- For Test/Debug
12531: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
12532: -- R12 Comment out
12533: -- IF FND_API.to_Boolean( p_debug ) THEN
12534: -- Open_Debug_Session(p_output_dir, p_debug_filename ) ;
12535: -- END IF;
12536:
12537:

Line 12549: x_return_status := FND_API.G_RET_STS_SUCCESS;

12545: Write_Debug('Initialize return status ' );
12546: END IF ;
12547:
12548: -- Initialize API return status to success
12549: x_return_status := FND_API.G_RET_STS_SUCCESS;
12550:
12551: -----------------------------------------------------------------
12552: -- API body
12553: -----------------------------------------------------------------

Line 12579: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12575: , p_wf_user_id => p_wf_user_id
12576: ) ;
12577:
12578:
12579: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12580: THEN
12581: RAISE FND_API.G_EXC_ERROR ;
12582: END IF ;
12583:

Line 12581: RAISE FND_API.G_EXC_ERROR ;

12577:
12578:
12579: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12580: THEN
12581: RAISE FND_API.G_EXC_ERROR ;
12582: END IF ;
12583:
12584: IF g_debug_flag THEN
12585: Write_Debug('2. Set User Id who is aborting the process. . .');

Line 12700: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12696: IF g_debug_flag THEN
12697: Write_Debug('After Set Approval Status .' || x_return_status );
12698: END IF ;
12699:
12700: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12701: -- THEN
12702: -- RAISE FND_API.G_EXC_ERROR ;
12703: -- END IF ;
12704:

Line 12702: -- RAISE FND_API.G_EXC_ERROR ;

12698: END IF ;
12699:
12700: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12701: -- THEN
12702: -- RAISE FND_API.G_EXC_ERROR ;
12703: -- END IF ;
12704:
12705: */
12706:

Line 12724: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12720: IF g_debug_flag THEN
12721: Write_Debug('After Route Step Workflow ' || x_return_status );
12722: END IF ;
12723:
12724: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12725: THEN
12726: RAISE FND_API.G_EXC_ERROR ;
12727: END IF ;
12728:

Line 12726: RAISE FND_API.G_EXC_ERROR ;

12722: END IF ;
12723:
12724: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12725: THEN
12726: RAISE FND_API.G_EXC_ERROR ;
12727: END IF ;
12728:
12729:
12730: -- In case that Route Object is Change Object

Line 12747: , p_init_msg_list => FND_API.G_FALSE --

12743: END IF ;
12744:
12745: ENG_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF
12746: ( p_api_version => 1.0
12747: , p_init_msg_list => FND_API.G_FALSE --
12748: , p_commit => FND_API.G_FALSE --
12749: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12750: , x_return_status => l_return_status
12751: , x_msg_count => l_msg_count

Line 12748: , p_commit => FND_API.G_FALSE --

12744:
12745: ENG_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF
12746: ( p_api_version => 1.0
12747: , p_init_msg_list => FND_API.G_FALSE --
12748: , p_commit => FND_API.G_FALSE --
12749: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12750: , x_return_status => l_return_status
12751: , x_msg_count => l_msg_count
12752: , x_msg_data => l_msg_data

Line 12749: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

12745: ENG_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF
12746: ( p_api_version => 1.0
12747: , p_init_msg_list => FND_API.G_FALSE --
12748: , p_commit => FND_API.G_FALSE --
12749: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12750: , x_return_status => l_return_status
12751: , x_msg_count => l_msg_count
12752: , x_msg_data => l_msg_data
12753: , p_change_id => l_change_id -- Change Id

Line 12761: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

12757:
12758: IF g_debug_flag THEN
12759: Write_Debug('After calling ENG_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF: ' || l_return_status );
12760: END IF ;
12761: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12762: THEN
12763: RAISE FND_API.G_EXC_ERROR ;
12764: END IF ;
12765:

Line 12763: RAISE FND_API.G_EXC_ERROR ;

12759: Write_Debug('After calling ENG_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF: ' || l_return_status );
12760: END IF ;
12761: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12762: THEN
12763: RAISE FND_API.G_EXC_ERROR ;
12764: END IF ;
12765:
12766: END IF ;
12767:

Line 12803: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12799: IF g_debug_flag THEN
12800: Write_Debug('After Set Workflow Routing Action Log: ' || x_return_status );
12801: END IF ;
12802:
12803: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12804: THEN
12805: RAISE FND_API.G_EXC_ERROR ;
12806: END IF ;
12807:

Line 12805: RAISE FND_API.G_EXC_ERROR ;

12801: END IF ;
12802:
12803: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12804: THEN
12805: RAISE FND_API.G_EXC_ERROR ;
12806: END IF ;
12807:
12808:
12809: -- R12B

Line 12829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12825: IF g_debug_flag THEN
12826: Write_Debug('After call SyncChangeLCPhase: ' || x_return_status );
12827: END IF ;
12828:
12829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12830: THEN
12831: RAISE FND_API.G_EXC_ERROR ;
12832: END IF ;
12833: END IF ;

Line 12831: RAISE FND_API.G_EXC_ERROR ;

12827: END IF ;
12828:
12829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12830: THEN
12831: RAISE FND_API.G_EXC_ERROR ;
12832: END IF ;
12833: END IF ;
12834:
12835:

Line 12877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12873: IF g_debug_flag THEN
12874: Write_Debug('After Set Line Workflow Routing Abort Action Log .' || x_return_status );
12875: END IF ;
12876:
12877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12878: THEN
12879: RAISE FND_API.G_EXC_ERROR ;
12880: END IF ;
12881:

Line 12879: RAISE FND_API.G_EXC_ERROR ;

12875: END IF ;
12876:
12877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12878: THEN
12879: RAISE FND_API.G_EXC_ERROR ;
12880: END IF ;
12881:
12882:
12883: END IF ; -- End if p_object_name = Eng_Workflow_Util.G_ENG_CHANGE_LINE

Line 12912: , p_init_msg_list => FND_API.G_FALSE --

12908:
12909:
12910: Eng_Workflow_Util.RevokeObjectRoles
12911: ( p_api_version => 1.0
12912: , p_init_msg_list => FND_API.G_FALSE --
12913: , p_commit => FND_API.G_FALSE --
12914: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12915: , p_debug => p_debug
12916: , p_output_dir => p_output_dir

Line 12913: , p_commit => FND_API.G_FALSE --

12909:
12910: Eng_Workflow_Util.RevokeObjectRoles
12911: ( p_api_version => 1.0
12912: , p_init_msg_list => FND_API.G_FALSE --
12913: , p_commit => FND_API.G_FALSE --
12914: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12915: , p_debug => p_debug
12916: , p_output_dir => p_output_dir
12917: , p_debug_filename => p_debug_filename

Line 12914: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

12910: Eng_Workflow_Util.RevokeObjectRoles
12911: ( p_api_version => 1.0
12912: , p_init_msg_list => FND_API.G_FALSE --
12913: , p_commit => FND_API.G_FALSE --
12914: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
12915: , p_debug => p_debug
12916: , p_output_dir => p_output_dir
12917: , p_debug_filename => p_debug_filename
12918: , x_return_status => l_return_status

Line 12936: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

12932: Write_Debug('After Eng_Workflow_Util.RevokeObjectRoles.' || l_return_status );
12933: END IF ;
12934:
12935: --
12936: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12937: -- THEN
12938: -- RAISE FND_API.G_EXC_ERROR ;
12939: -- END IF ;
12940: --

Line 12938: -- RAISE FND_API.G_EXC_ERROR ;

12934:
12935: --
12936: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
12937: -- THEN
12938: -- RAISE FND_API.G_EXC_ERROR ;
12939: -- END IF ;
12940: --
12941:
12942: -- R12B

Line 12998: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

12994: Write_Debug('Return Status: ' || x_return_status );
12995: END IF ;
12996:
12997:
12998: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12999: THEN
13000: RAISE FND_API.G_EXC_ERROR ;
13001: END IF ;
13002:

Line 13000: RAISE FND_API.G_EXC_ERROR ;

12996:
12997:
12998: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
12999: THEN
13000: RAISE FND_API.G_EXC_ERROR ;
13001: END IF ;
13002:
13003:
13004:

Line 13064: IF FND_API.To_Boolean( p_commit ) THEN

13060: END IF ;
13061:
13062:
13063: -- Standard check of p_commit.
13064: IF FND_API.To_Boolean( p_commit ) THEN
13065:
13066: IF g_debug_flag THEN
13067: Write_Debug('Do Commit.') ;
13068: END IF ;

Line 13088: WHEN FND_API.G_EXC_ERROR THEN

13084:
13085: -- To remove the step assignee created by the Reassignment.
13086:
13087: EXCEPTION
13088: WHEN FND_API.G_EXC_ERROR THEN
13089: IF FND_API.To_Boolean( p_commit ) THEN
13090: IF g_debug_flag THEN
13091: Write_Debug('Rollback . . .') ;
13092: END IF ;

Line 13089: IF FND_API.To_Boolean( p_commit ) THEN

13085: -- To remove the step assignee created by the Reassignment.
13086:
13087: EXCEPTION
13088: WHEN FND_API.G_EXC_ERROR THEN
13089: IF FND_API.To_Boolean( p_commit ) THEN
13090: IF g_debug_flag THEN
13091: Write_Debug('Rollback . . .') ;
13092: END IF ;
13093: ROLLBACK TO AbortWorkflow_Util ;

Line 13096: x_return_status := FND_API.G_RET_STS_ERROR ;

13092: END IF ;
13093: ROLLBACK TO AbortWorkflow_Util ;
13094: END IF;
13095:
13096: x_return_status := FND_API.G_RET_STS_ERROR ;
13097:
13098: FND_MSG_PUB.Count_And_Get
13099: ( p_count => x_msg_count
13100: , p_data => x_msg_data

Line 13108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

13104: Write_Debug('Finish with Error.') ;
13105: Close_Debug_Session ;
13106: END IF ;
13107:
13108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13109: IF FND_API.To_Boolean( p_commit ) THEN
13110: IF g_debug_flag THEN
13111: Write_Debug('Rollback . . .') ;
13112: END IF ;

Line 13109: IF FND_API.To_Boolean( p_commit ) THEN

13105: Close_Debug_Session ;
13106: END IF ;
13107:
13108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13109: IF FND_API.To_Boolean( p_commit ) THEN
13110: IF g_debug_flag THEN
13111: Write_Debug('Rollback . . .') ;
13112: END IF ;
13113: ROLLBACK TO AbortWorkflow_Util ;

Line 13116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

13112: END IF ;
13113: ROLLBACK TO AbortWorkflow_Util ;
13114: END IF;
13115:
13116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13117:
13118: FND_MSG_PUB.Count_And_Get
13119: ( p_count => x_msg_count
13120: , p_data => x_msg_data

Line 13129: IF FND_API.To_Boolean( p_commit ) THEN

13125: Close_Debug_Session ;
13126: END IF ;
13127:
13128: WHEN OTHERS THEN
13129: IF FND_API.To_Boolean( p_commit ) THEN
13130: IF g_debug_flag THEN
13131: Write_Debug('Rollback . . .') ;
13132: END IF ;
13133: ROLLBACK TO AbortWorkflow_Util ;

Line 13136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

13132: END IF ;
13133: ROLLBACK TO AbortWorkflow_Util ;
13134: END IF;
13135:
13136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13137:
13138: FND_MSG_PUB.Count_And_Get
13139: ( p_count => x_msg_count
13140: , p_data => x_msg_data

Line 13252: x_return_status := FND_API.G_RET_STS_SUCCESS;

13248: where ROUTE_PEOPLE_ID=p_route_people_id;
13249:
13250: BEGIN
13251: -- Initialize API return status to success
13252: x_return_status := FND_API.G_RET_STS_SUCCESS;
13253:
13254: IF g_debug_flag THEN
13255: Write_Debug('Route p_notification_id ' || to_char(p_notification_id));
13256: END IF ;

Line 13475: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

13471: , p_assignee_id => l_new_party_id
13472: ) ;
13473:
13474:
13475: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13476:
13477: x_return_status := l_return_status ;
13478: x_msg_count := l_msg_count ;
13479: x_msg_data := l_msg_data ;

Line 13519: , p_init_msg_list => FND_API.G_FALSE --

13515: END IF ;
13516:
13517: Eng_Workflow_Util.GrantObjectRoles
13518: ( p_api_version => 1.0
13519: , p_init_msg_list => FND_API.G_FALSE --
13520: , p_commit => FND_API.G_FALSE --
13521: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13522: , p_debug => FND_API.G_FALSE
13523: , p_output_dir => NULL

Line 13520: , p_commit => FND_API.G_FALSE --

13516:
13517: Eng_Workflow_Util.GrantObjectRoles
13518: ( p_api_version => 1.0
13519: , p_init_msg_list => FND_API.G_FALSE --
13520: , p_commit => FND_API.G_FALSE --
13521: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13522: , p_debug => FND_API.G_FALSE
13523: , p_output_dir => NULL
13524: , p_debug_filename => NULL

Line 13521: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

13517: Eng_Workflow_Util.GrantObjectRoles
13518: ( p_api_version => 1.0
13519: , p_init_msg_list => FND_API.G_FALSE --
13520: , p_commit => FND_API.G_FALSE --
13521: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13522: , p_debug => FND_API.G_FALSE
13523: , p_output_dir => NULL
13524: , p_debug_filename => NULL
13525: , x_return_status => l_return_status

Line 13522: , p_debug => FND_API.G_FALSE

13518: ( p_api_version => 1.0
13519: , p_init_msg_list => FND_API.G_FALSE --
13520: , p_commit => FND_API.G_FALSE --
13521: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13522: , p_debug => FND_API.G_FALSE
13523: , p_output_dir => NULL
13524: , p_debug_filename => NULL
13525: , x_return_status => l_return_status
13526: , x_msg_count => l_msg_count

Line 13543: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

13539: Write_Debug('After Eng_Workflow_Util.GrantObjectRoles: ' || l_return_status );
13540: END IF ;
13541:
13542: --
13543: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
13544: -- THEN
13545: -- RAISE FND_API.G_EXC_ERROR ;
13546: -- END IF ;
13547: END IF ;

Line 13545: -- RAISE FND_API.G_EXC_ERROR ;

13541:
13542: --
13543: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
13544: -- THEN
13545: -- RAISE FND_API.G_EXC_ERROR ;
13546: -- END IF ;
13547: END IF ;
13548:
13549: EXCEPTION

Line 13550: WHEN FND_API.G_EXC_ERROR THEN

13546: -- END IF ;
13547: END IF ;
13548:
13549: EXCEPTION
13550: WHEN FND_API.G_EXC_ERROR THEN
13551: ROLLBACK TO AbortWorkflow_Util ;
13552: x_return_status := FND_API.G_RET_STS_ERROR ;
13553:
13554: FND_MSG_PUB.Count_And_Get

Line 13552: x_return_status := FND_API.G_RET_STS_ERROR ;

13548:
13549: EXCEPTION
13550: WHEN FND_API.G_EXC_ERROR THEN
13551: ROLLBACK TO AbortWorkflow_Util ;
13552: x_return_status := FND_API.G_RET_STS_ERROR ;
13553:
13554: FND_MSG_PUB.Count_And_Get
13555: ( p_count => x_msg_count
13556: , p_data => x_msg_data

Line 13575: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

13571: -- x_msg_data OUT VARCHAR2
13572: --
13573: PROCEDURE GrantObjectRoles
13574: ( p_api_version IN NUMBER
13575: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
13576: , p_commit IN VARCHAR2 := FND_API.G_FALSE
13577: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
13578: , p_debug IN VARCHAR2 := FND_API.G_FALSE
13579: , p_output_dir IN VARCHAR2 := NULL

Line 13576: , p_commit IN VARCHAR2 := FND_API.G_FALSE

13572: --
13573: PROCEDURE GrantObjectRoles
13574: ( p_api_version IN NUMBER
13575: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
13576: , p_commit IN VARCHAR2 := FND_API.G_FALSE
13577: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
13578: , p_debug IN VARCHAR2 := FND_API.G_FALSE
13579: , p_output_dir IN VARCHAR2 := NULL
13580: , p_debug_filename IN VARCHAR2 := NULL

Line 13577: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

13573: PROCEDURE GrantObjectRoles
13574: ( p_api_version IN NUMBER
13575: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
13576: , p_commit IN VARCHAR2 := FND_API.G_FALSE
13577: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
13578: , p_debug IN VARCHAR2 := FND_API.G_FALSE
13579: , p_output_dir IN VARCHAR2 := NULL
13580: , p_debug_filename IN VARCHAR2 := NULL
13581: , x_return_status OUT NOCOPY VARCHAR2

Line 13578: , p_debug IN VARCHAR2 := FND_API.G_FALSE

13574: ( p_api_version IN NUMBER
13575: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
13576: , p_commit IN VARCHAR2 := FND_API.G_FALSE
13577: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
13578: , p_debug IN VARCHAR2 := FND_API.G_FALSE
13579: , p_output_dir IN VARCHAR2 := NULL
13580: , p_debug_filename IN VARCHAR2 := NULL
13581: , x_return_status OUT NOCOPY VARCHAR2
13582: , x_msg_count OUT NOCOPY NUMBER

Line 13727: IF NOT FND_API.Compatible_API_Call( l_api_version

13723: -- Standard Start of API savepoint
13724: SAVEPOINT GrantObjectRoles;
13725:
13726: -- Standard call to check for call compatibility.
13727: IF NOT FND_API.Compatible_API_Call( l_api_version
13728: , p_api_version
13729: , l_api_name
13730: , G_PKG_NAME )
13731: THEN

Line 13732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

13728: , p_api_version
13729: , l_api_name
13730: , G_PKG_NAME )
13731: THEN
13732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13733: END IF;
13734:
13735: -- Initialize message list if p_init_msg_list is set to TRUE.
13736: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 13736: IF FND_API.to_Boolean( p_init_msg_list ) THEN

13732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13733: END IF;
13734:
13735: -- Initialize message list if p_init_msg_list is set to TRUE.
13736: IF FND_API.to_Boolean( p_init_msg_list ) THEN
13737: FND_MSG_PUB.initialize;
13738: END IF ;
13739:
13740:

Line 13742: IF FND_API.to_Boolean( p_debug ) THEN

13738: END IF ;
13739:
13740:
13741: -- For Test/Debug
13742: IF FND_API.to_Boolean( p_debug ) THEN
13743: Open_Debug_Session(p_output_dir, p_debug_filename ) ;
13744: END IF ;
13745:
13746:

Line 13761: x_return_status := FND_API.G_RET_STS_SUCCESS;

13757: Write_Debug('Initialize return status ' );
13758: END IF ;
13759:
13760: -- Initialize API return status to success
13761: x_return_status := FND_API.G_RET_STS_SUCCESS;
13762: l_return_status := FND_API.G_RET_STS_SUCCESS;
13763:
13764: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;
13765: l_obj_idx := 0 ;

Line 13762: l_return_status := FND_API.G_RET_STS_SUCCESS;

13758: END IF ;
13759:
13760: -- Initialize API return status to success
13761: x_return_status := FND_API.G_RET_STS_SUCCESS;
13762: l_return_status := FND_API.G_RET_STS_SUCCESS;
13763:
13764: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;
13765: l_obj_idx := 0 ;
13766:

Line 13995: , p_init_msg_list => FND_API.G_FALSE --

13991:
13992:
13993: ENG_DOCUMENT_UTIL.Grant_Document_Role
13994: ( p_api_version => 1.0
13995: , p_init_msg_list => FND_API.G_FALSE --
13996: , p_commit => FND_API.G_FALSE --
13997: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13998: , p_debug => p_debug
13999: , p_output_dir => p_output_dir

Line 13996: , p_commit => FND_API.G_FALSE --

13992:
13993: ENG_DOCUMENT_UTIL.Grant_Document_Role
13994: ( p_api_version => 1.0
13995: , p_init_msg_list => FND_API.G_FALSE --
13996: , p_commit => FND_API.G_FALSE --
13997: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13998: , p_debug => p_debug
13999: , p_output_dir => p_output_dir
14000: , p_debug_filename => p_debug_filename

Line 13997: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

13993: ENG_DOCUMENT_UTIL.Grant_Document_Role
13994: ( p_api_version => 1.0
13995: , p_init_msg_list => FND_API.G_FALSE --
13996: , p_commit => FND_API.G_FALSE --
13997: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
13998: , p_debug => p_debug
13999: , p_output_dir => p_output_dir
14000: , p_debug_filename => p_debug_filename
14001: , x_return_status => l_return_status

Line 14019: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

14015: Write_Debug('After calling ENG_DOCUMENT_UTIL.Grant_Document_Role: ' || l_return_status );
14016: END IF ;
14017:
14018: --
14019: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14020: -- THEN
14021: -- RAISE FND_API.G_EXC_ERROR ;
14022: -- END IF ;
14023: --

Line 14021: -- RAISE FND_API.G_EXC_ERROR ;

14017:
14018: --
14019: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14020: -- THEN
14021: -- RAISE FND_API.G_EXC_ERROR ;
14022: -- END IF ;
14023: --
14024:
14025: END IF ;

Line 14061: , p_init_msg_list => FND_API.G_FALSE --

14057: end if;
14058:
14059: ENG_DOCUMENT_UTIL.Grant_Attachments_OCSRole
14060: ( p_api_version => 1.0
14061: , p_init_msg_list => FND_API.G_FALSE --
14062: , p_commit => FND_API.G_FALSE --
14063: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14064: , p_debug => p_debug
14065: , p_output_dir => p_output_dir

Line 14062: , p_commit => FND_API.G_FALSE --

14058:
14059: ENG_DOCUMENT_UTIL.Grant_Attachments_OCSRole
14060: ( p_api_version => 1.0
14061: , p_init_msg_list => FND_API.G_FALSE --
14062: , p_commit => FND_API.G_FALSE --
14063: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14064: , p_debug => p_debug
14065: , p_output_dir => p_output_dir
14066: , p_debug_filename => p_debug_filename

Line 14063: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

14059: ENG_DOCUMENT_UTIL.Grant_Attachments_OCSRole
14060: ( p_api_version => 1.0
14061: , p_init_msg_list => FND_API.G_FALSE --
14062: , p_commit => FND_API.G_FALSE --
14063: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14064: , p_debug => p_debug
14065: , p_output_dir => p_output_dir
14066: , p_debug_filename => p_debug_filename
14067: , x_return_status => l_return_status

Line 14092: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

14088: Write_Debug('After ENG_DOCUMENT_UTIL.Grant_Attachments_OCSRole: ' || l_return_status );
14089: END IF ;
14090:
14091: --
14092: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14093: -- THEN
14094: -- RAISE FND_API.G_EXC_ERROR ;
14095: -- END IF ;
14096: --

Line 14094: -- RAISE FND_API.G_EXC_ERROR ;

14090:
14091: --
14092: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14093: -- THEN
14094: -- RAISE FND_API.G_EXC_ERROR ;
14095: -- END IF ;
14096: --
14097:
14098:

Line 14109: IF FND_API.To_Boolean( p_commit ) THEN

14105: END IF ;
14106:
14107:
14108: -- Standard check of p_commit.
14109: IF FND_API.To_Boolean( p_commit ) THEN
14110:
14111: IF g_debug_flag THEN
14112: Write_Debug('Do Commit.') ;
14113: END IF ;

Line 14132: WHEN FND_API.G_EXC_ERROR THEN

14128: END IF ;
14129:
14130:
14131: EXCEPTION
14132: WHEN FND_API.G_EXC_ERROR THEN
14133:
14134: -- Standard check of p_commit.
14135: IF FND_API.To_Boolean( p_commit )
14136: THEN

Line 14135: IF FND_API.To_Boolean( p_commit )

14131: EXCEPTION
14132: WHEN FND_API.G_EXC_ERROR THEN
14133:
14134: -- Standard check of p_commit.
14135: IF FND_API.To_Boolean( p_commit )
14136: THEN
14137: ROLLBACK TO GrantObjectRoles ;
14138: END IF ;
14139: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 14139: x_return_status := FND_API.G_RET_STS_ERROR ;

14135: IF FND_API.To_Boolean( p_commit )
14136: THEN
14137: ROLLBACK TO GrantObjectRoles ;
14138: END IF ;
14139: x_return_status := FND_API.G_RET_STS_ERROR ;
14140:
14141: FND_MSG_PUB.Count_And_Get
14142: ( p_count => x_msg_count
14143: , p_data => x_msg_data

Line 14151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

14147: Write_Debug('Finish with Error.') ;
14148: Close_Debug_Session ;
14149: END IF ;
14150:
14151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14152: -- Standard check of p_commit.
14153: IF FND_API.To_Boolean( p_commit )
14154: THEN
14155: ROLLBACK TO GrantObjectRoles ;

Line 14153: IF FND_API.To_Boolean( p_commit )

14149: END IF ;
14150:
14151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14152: -- Standard check of p_commit.
14153: IF FND_API.To_Boolean( p_commit )
14154: THEN
14155: ROLLBACK TO GrantObjectRoles ;
14156: IF g_debug_flag THEN
14157: Write_Debug('Rollback. . . ' );

Line 14162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

14158: END IF ;
14159:
14160: END IF ;
14161:
14162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14163:
14164: FND_MSG_PUB.Count_And_Get
14165: ( p_count => x_msg_count
14166: , p_data => x_msg_data

Line 14176: IF FND_API.To_Boolean( p_commit )

14172: END IF ;
14173:
14174: WHEN OTHERS THEN
14175: -- Standard check of p_commit.
14176: IF FND_API.To_Boolean( p_commit )
14177: THEN
14178: ROLLBACK TO GrantObjectRoles ;
14179:
14180: IF g_debug_flag THEN

Line 14185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

14181: Write_Debug('Rollback. . . ' );
14182: END IF ;
14183:
14184: END IF ;
14185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14186:
14187: FND_MSG_PUB.Count_And_Get
14188: ( p_count => x_msg_count
14189: , p_data => x_msg_data

Line 14236: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

14232: -- p_revoke_option default G_REVOKE_LINE
14233: --
14234: PROCEDURE RevokeObjectRoles
14235: ( p_api_version IN NUMBER --
14236: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14237: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14238: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14239: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14240: , p_output_dir IN VARCHAR2 := NULL

Line 14237: , p_commit IN VARCHAR2 := FND_API.G_FALSE --

14233: --
14234: PROCEDURE RevokeObjectRoles
14235: ( p_api_version IN NUMBER --
14236: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14237: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14238: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14239: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14240: , p_output_dir IN VARCHAR2 := NULL
14241: , p_debug_filename IN VARCHAR2 := NULL

Line 14238: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

14234: PROCEDURE RevokeObjectRoles
14235: ( p_api_version IN NUMBER --
14236: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14237: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14238: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14239: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14240: , p_output_dir IN VARCHAR2 := NULL
14241: , p_debug_filename IN VARCHAR2 := NULL
14242: , x_return_status OUT NOCOPY VARCHAR2 --

Line 14239: , p_debug IN VARCHAR2 := FND_API.G_FALSE --

14235: ( p_api_version IN NUMBER --
14236: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14237: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14238: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14239: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14240: , p_output_dir IN VARCHAR2 := NULL
14241: , p_debug_filename IN VARCHAR2 := NULL
14242: , x_return_status OUT NOCOPY VARCHAR2 --
14243: , x_msg_count OUT NOCOPY NUMBER --

Line 14328: , p_init_msg_list => FND_API.G_FALSE

14324: END IF ;
14325: BEGIN
14326: RevokeObjectRoles
14327: ( p_api_version => p_api_version
14328: , p_init_msg_list => FND_API.G_FALSE
14329: , p_commit => p_commit
14330: , p_validation_level => p_validation_level
14331: , p_debug => p_debug
14332: , p_output_dir => p_output_dir

Line 14354: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

14350: WHEN OTHERS THEN
14351: NULL ;
14352: END ;
14353:
14354: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14355: THEN
14356: x_return_status := l_return_status ;
14357: x_msg_count := l_msg_count ;
14358: x_msg_data := l_msg_data ;

Line 14378: , p_init_msg_list => FND_API.G_FALSE

14374: END IF ;
14375: BEGIN
14376: RevokeObjectRoles
14377: ( p_api_version => p_api_version
14378: , p_init_msg_list => FND_API.G_FALSE
14379: , p_commit => p_commit
14380: , p_validation_level => p_validation_level
14381: , p_debug => p_debug
14382: , p_output_dir => p_output_dir

Line 14404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

14400: WHEN OTHERS THEN
14401: NULL ;
14402: END ;
14403:
14404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14405: THEN
14406: x_return_status := l_return_status ;
14407: x_msg_count := l_msg_count ;
14408: x_msg_data := l_msg_data ;

Line 14432: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

14428: -- x_msg_data OUT VARCHAR2
14429: --
14430: PROCEDURE RevokeObjectRoles
14431: ( p_api_version IN NUMBER --
14432: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14433: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14434: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14435: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14436: , p_output_dir IN VARCHAR2 := NULL

Line 14433: , p_commit IN VARCHAR2 := FND_API.G_FALSE --

14429: --
14430: PROCEDURE RevokeObjectRoles
14431: ( p_api_version IN NUMBER --
14432: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14433: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14434: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14435: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14436: , p_output_dir IN VARCHAR2 := NULL
14437: , p_debug_filename IN VARCHAR2 := NULL

Line 14434: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

14430: PROCEDURE RevokeObjectRoles
14431: ( p_api_version IN NUMBER --
14432: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14433: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14434: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14435: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14436: , p_output_dir IN VARCHAR2 := NULL
14437: , p_debug_filename IN VARCHAR2 := NULL
14438: , x_return_status OUT NOCOPY VARCHAR2 --

Line 14435: , p_debug IN VARCHAR2 := FND_API.G_FALSE --

14431: ( p_api_version IN NUMBER --
14432: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14433: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14434: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14435: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14436: , p_output_dir IN VARCHAR2 := NULL
14437: , p_debug_filename IN VARCHAR2 := NULL
14438: , x_return_status OUT NOCOPY VARCHAR2 --
14439: , x_msg_count OUT NOCOPY NUMBER --

Line 14481: , p_init_msg_list => FND_API.G_FALSE

14477: END IF ;
14478: BEGIN
14479: RevokeObjectRoles
14480: ( p_api_version => p_api_version
14481: , p_init_msg_list => FND_API.G_FALSE
14482: , p_commit => p_commit
14483: , p_validation_level => p_validation_level
14484: , p_debug => p_debug
14485: , p_output_dir => p_output_dir

Line 14508: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

14504: WHEN OTHERS THEN
14505: NULL ;
14506: END ;
14507:
14508: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14509: THEN
14510: x_return_status := l_return_status ;
14511: x_msg_count := l_msg_count ;
14512: x_msg_data := l_msg_data ;

Line 14534: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

14530: -- x_msg_data OUT VARCHAR2
14531: --
14532: PROCEDURE RevokeObjectRoles
14533: ( p_api_version IN NUMBER --
14534: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14535: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14536: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14537: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14538: , p_output_dir IN VARCHAR2 := NULL

Line 14535: , p_commit IN VARCHAR2 := FND_API.G_FALSE --

14531: --
14532: PROCEDURE RevokeObjectRoles
14533: ( p_api_version IN NUMBER --
14534: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14535: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14536: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14537: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14538: , p_output_dir IN VARCHAR2 := NULL
14539: , p_debug_filename IN VARCHAR2 := NULL

Line 14536: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

14532: PROCEDURE RevokeObjectRoles
14533: ( p_api_version IN NUMBER --
14534: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14535: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14536: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14537: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14538: , p_output_dir IN VARCHAR2 := NULL
14539: , p_debug_filename IN VARCHAR2 := NULL
14540: , x_return_status OUT NOCOPY VARCHAR2 --

Line 14537: , p_debug IN VARCHAR2 := FND_API.G_FALSE --

14533: ( p_api_version IN NUMBER --
14534: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
14535: , p_commit IN VARCHAR2 := FND_API.G_FALSE --
14536: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
14537: , p_debug IN VARCHAR2 := FND_API.G_FALSE --
14538: , p_output_dir IN VARCHAR2 := NULL
14539: , p_debug_filename IN VARCHAR2 := NULL
14540: , x_return_status OUT NOCOPY VARCHAR2 --
14541: , x_msg_count OUT NOCOPY NUMBER --

Line 14684: IF NOT FND_API.Compatible_API_Call( l_api_version

14680: -- Standard Start of API savepoint
14681: SAVEPOINT RevokeObjectRoles;
14682:
14683: -- Standard call to check for call compatibility.
14684: IF NOT FND_API.Compatible_API_Call( l_api_version
14685: , p_api_version
14686: , l_api_name
14687: , G_PKG_NAME )
14688: THEN

Line 14689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

14685: , p_api_version
14686: , l_api_name
14687: , G_PKG_NAME )
14688: THEN
14689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14690: END IF;
14691:
14692: -- Initialize message list if p_init_msg_list is set to TRUE.
14693: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 14693: IF FND_API.to_Boolean( p_init_msg_list ) THEN

14689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14690: END IF;
14691:
14692: -- Initialize message list if p_init_msg_list is set to TRUE.
14693: IF FND_API.to_Boolean( p_init_msg_list ) THEN
14694: FND_MSG_PUB.initialize;
14695: END IF ;
14696:
14697:

Line 14699: IF FND_API.to_Boolean( p_debug ) THEN

14695: END IF ;
14696:
14697:
14698: -- For Test/Debug
14699: IF FND_API.to_Boolean( p_debug ) THEN
14700: Open_Debug_Session(p_output_dir, p_debug_filename ) ;
14701: END IF ;
14702:
14703:

Line 14718: x_return_status := FND_API.G_RET_STS_SUCCESS;

14714: Write_Debug('Initialize return status ' );
14715: END IF ;
14716:
14717: -- Initialize API return status to success
14718: x_return_status := FND_API.G_RET_STS_SUCCESS;
14719: l_return_status := FND_API.G_RET_STS_SUCCESS;
14720:
14721: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;
14722: l_obj_idx := 0 ;

Line 14719: l_return_status := FND_API.G_RET_STS_SUCCESS;

14715: END IF ;
14716:
14717: -- Initialize API return status to success
14718: x_return_status := FND_API.G_RET_STS_SUCCESS;
14719: l_return_status := FND_API.G_RET_STS_SUCCESS;
14720:
14721: l_target_object_tbl := FND_TABLE_OF_VARCHAR2_30() ;
14722: l_obj_idx := 0 ;
14723:

Line 14941: , p_init_msg_list => FND_API.G_FALSE --

14937: END IF ;
14938:
14939: ENG_DOCUMENT_UTIL.Revoke_Document_Role
14940: ( p_api_version => 1.0
14941: , p_init_msg_list => FND_API.G_FALSE --
14942: , p_commit => FND_API.G_FALSE --
14943: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14944: , p_debug => p_debug
14945: , p_output_dir => p_output_dir

Line 14942: , p_commit => FND_API.G_FALSE --

14938:
14939: ENG_DOCUMENT_UTIL.Revoke_Document_Role
14940: ( p_api_version => 1.0
14941: , p_init_msg_list => FND_API.G_FALSE --
14942: , p_commit => FND_API.G_FALSE --
14943: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14944: , p_debug => p_debug
14945: , p_output_dir => p_output_dir
14946: , p_debug_filename => p_debug_filename

Line 14943: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

14939: ENG_DOCUMENT_UTIL.Revoke_Document_Role
14940: ( p_api_version => 1.0
14941: , p_init_msg_list => FND_API.G_FALSE --
14942: , p_commit => FND_API.G_FALSE --
14943: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14944: , p_debug => p_debug
14945: , p_output_dir => p_output_dir
14946: , p_debug_filename => p_debug_filename
14947: , x_return_status => l_return_status

Line 14966: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

14962: Write_Debug('After ENG_DOCUMENT_UTIL.Revoke_Document_Role: ' || l_return_status );
14963: END IF ;
14964:
14965: --
14966: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14967: -- THEN
14968: -- RAISE FND_API.G_EXC_ERROR ;
14969: -- END IF ;
14970: --

Line 14968: -- RAISE FND_API.G_EXC_ERROR ;

14964:
14965: --
14966: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14967: -- THEN
14968: -- RAISE FND_API.G_EXC_ERROR ;
14969: -- END IF ;
14970: --
14971:
14972: END IF ;

Line 14994: , p_init_msg_list => FND_API.G_FALSE --

14990: END IF ;
14991:
14992: ENG_DOCUMENT_UTIL.Revoke_Attachments_OCSRole
14993: ( p_api_version => 1.0
14994: , p_init_msg_list => FND_API.G_FALSE --
14995: , p_commit => FND_API.G_FALSE --
14996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14997: , p_debug => p_debug
14998: , p_output_dir => p_output_dir

Line 14995: , p_commit => FND_API.G_FALSE --

14991:
14992: ENG_DOCUMENT_UTIL.Revoke_Attachments_OCSRole
14993: ( p_api_version => 1.0
14994: , p_init_msg_list => FND_API.G_FALSE --
14995: , p_commit => FND_API.G_FALSE --
14996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14997: , p_debug => p_debug
14998: , p_output_dir => p_output_dir
14999: , p_debug_filename => p_debug_filename

Line 14996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

14992: ENG_DOCUMENT_UTIL.Revoke_Attachments_OCSRole
14993: ( p_api_version => 1.0
14994: , p_init_msg_list => FND_API.G_FALSE --
14995: , p_commit => FND_API.G_FALSE --
14996: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
14997: , p_debug => p_debug
14998: , p_output_dir => p_output_dir
14999: , p_debug_filename => p_debug_filename
15000: , x_return_status => l_return_status

Line 15020: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS

15016: Write_Debug('After ENG_DOCUMENT_UTIL.Revoke_Attachments_OCSRole: ' || l_return_status );
15017: END IF ;
15018:
15019: --
15020: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
15021: -- THEN
15022: -- RAISE FND_API.G_EXC_ERROR ;
15023: -- END IF ;
15024: --

Line 15022: -- RAISE FND_API.G_EXC_ERROR ;

15018:
15019: --
15020: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS
15021: -- THEN
15022: -- RAISE FND_API.G_EXC_ERROR ;
15023: -- END IF ;
15024: --
15025:
15026:

Line 15041: IF FND_API.To_Boolean( p_commit ) THEN

15037: END IF ;
15038:
15039:
15040: -- Standard check of p_commit.
15041: IF FND_API.To_Boolean( p_commit ) THEN
15042:
15043: IF g_debug_flag THEN
15044: Write_Debug('Do Commit.') ;
15045: END IF ;

Line 15064: WHEN FND_API.G_EXC_ERROR THEN

15060: END IF ;
15061:
15062:
15063: EXCEPTION
15064: WHEN FND_API.G_EXC_ERROR THEN
15065:
15066: -- Standard check of p_commit.
15067: IF FND_API.To_Boolean( p_commit )
15068: THEN

Line 15067: IF FND_API.To_Boolean( p_commit )

15063: EXCEPTION
15064: WHEN FND_API.G_EXC_ERROR THEN
15065:
15066: -- Standard check of p_commit.
15067: IF FND_API.To_Boolean( p_commit )
15068: THEN
15069: ROLLBACK TO RevokeObjectRoles ;
15070: END IF ;
15071: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 15071: x_return_status := FND_API.G_RET_STS_ERROR ;

15067: IF FND_API.To_Boolean( p_commit )
15068: THEN
15069: ROLLBACK TO RevokeObjectRoles ;
15070: END IF ;
15071: x_return_status := FND_API.G_RET_STS_ERROR ;
15072:
15073: FND_MSG_PUB.Count_And_Get
15074: ( p_count => x_msg_count
15075: , p_data => x_msg_data

Line 15083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

15079: Write_Debug('Finish with Error.') ;
15080: Close_Debug_Session ;
15081: END IF ;
15082:
15083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15084: -- Standard check of p_commit.
15085: IF FND_API.To_Boolean( p_commit )
15086: THEN
15087: ROLLBACK TO RevokeObjectRoles ;

Line 15085: IF FND_API.To_Boolean( p_commit )

15081: END IF ;
15082:
15083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15084: -- Standard check of p_commit.
15085: IF FND_API.To_Boolean( p_commit )
15086: THEN
15087: ROLLBACK TO RevokeObjectRoles ;
15088: IF g_debug_flag THEN
15089: Write_Debug('RollBack . . ..') ;

Line 15093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

15089: Write_Debug('RollBack . . ..') ;
15090: END IF ;
15091: END IF ;
15092:
15093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
15094:
15095: FND_MSG_PUB.Count_And_Get
15096: ( p_count => x_msg_count
15097: , p_data => x_msg_data

Line 15107: IF FND_API.To_Boolean( p_commit )

15103: END IF ;
15104:
15105: WHEN OTHERS THEN
15106: -- Standard check of p_commit.
15107: IF FND_API.To_Boolean( p_commit )
15108: THEN
15109: ROLLBACK TO RevokeObjectRoles ;
15110: IF g_debug_flag THEN
15111: Write_Debug('RollBack . . ..') ;

Line 15115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

15111: Write_Debug('RollBack . . ..') ;
15112: END IF ;
15113: END IF ;
15114:
15115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
15116:
15117: FND_MSG_PUB.Count_And_Get
15118: ( p_count => x_msg_count
15119: , p_data => x_msg_data