66: p_flow_details_id => Solutions.FLow_Details_Id,
67: p_group_id => Solutions.Group_Id,
68: p_solution_title => Solutions.Name );
69: EXCEPTION WHEN OTHERS THEN
70: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_NOT_RESEND_ERR')||
71: Solutions.Set_Number||' -'||substrb(sqlerrm,1,200));
72: END;
73:
74: END IF;
72: END;
73:
74: END IF;
75:
76: FND_FILE.PUT_LINE(FND_FILE.LOG, Solutions.Set_Number||fnd_message.GET_STRING('CS','CS_KB_SOLN_UNLOCK'));
77:
78: END IF;
79:
80: END LOOP;
92: WHEN OTHERS THEN
93:
94: RETCODE := 2;
95:
96: ERRBUF := fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
97: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
98:
99: END CHECK_SOLN_IN_PROGRESS;
100: